honzapav

ač,ad,ah,ai,aj,ak,ap,aš,ať,au,až,by,či,čj,čl,co,dá,do,dr,ec,es,fa,fn,fy,hd,hl,ho,hw,já,je,ji,kb,ke,km,ks,ku,kv,lg,li,lq,má,mb,mé,mi,mu,na,nc,nd,ne,ně,nf,nv,od,ok,on,op,os,pa,pc,pí,po,př,pt,sb,se,si,sk,ss,sš,st,sw,ta,té,ti,tj,to,tř,tu,ty,uč,uk,úl,um,úv,už,ve,ví,vš,vy,wc,xt,za,ze,že,zš,a přec,a přece,a přeci,a sice,a to,a/čeština,aby,aji,ale,an,aneb,ani,aniž,ano i,anžto,avšak,ačkoli,ačkoliv,ba,bo,buď,div,dokud,dílem,enem,hned,i,i když,jakkoliv,jako,jakoby,jednak,jen,jenom,jenže,jestli,jestliže,jinak,kdyby,když,kór,ledva,leč,málem,neb,nebo,neboli,neboť,než,nežli,ni,nicméně,nobrž,nýbrž,pak,pokud,potom,protože,přesto,přestože,seč,sice,sotva,tak,takže,tedy,totiž,tož,třeba,třebaže,však,vždyť,zatím co,zatímco,zda,čili,bez,beze,blízko,během,cestou,coby,dle,dík,díky,k,kol,kolem,kromě,kvůli,mezi,mimo,místo,nad,nade,naproti,navzdory,o,ob,ode,ohledně,okolo,oproti,poblíž,pod,pode,podle,podlevá,podlivá,podél,pomocí,pro,prostřednictvím,proti,před,přede,přes,přese,při,s,skrz,skrze,stran,u,u příležitosti,uprostřed,v,vedle,vino

honzapav

a able about across after ain't all almost also am among an and any are aren't as at be because been but by can can't cannot could could've couldn't did didn't do does doesn't don't either else ever every for from get got had has hasn't have he he'd he'll he's her hers him his how how'd how'll how's however i i'd i'll i'm i've if in into is isn't it it's its just least let like likely may me might might've most must must've mustn't my neither no nor not of off often on only or other our own rather said say says she she'd she'll she's should should've shouldn't since so some than that that'll that's the their them then there there's these they they'd they'll they're they've this to too us wants was wasn't we we'd we'll we're were weren't what what's when where where'd where'll where's which while who who'd who'll who's whom why why'd will with won't would would've wouldn't yet you you'd you'll you're you've your

honzapav

https://free.sharedcount.com/?url={sem-patri-url}&apikey={sem-patri-api-key}

pro OpenRefine:

'https://free.sharedcount.com/?url=' + value + '&apikey={sem-patri-api-key}'

value.parseJson()[„like_count“] 
value.parseJson()[„share_count“]
value.parseJson()[„GooglePlusOne“]
value.parseJson()[„Twitter“]

honzapav

'ač', 'ad', 'ah', 'ai', 'aj', 'ak', 'ap', 'aš', 'ať', 'au', 'až', 'by', 'či', 'čj', 'čl', 'co', 'dá', 'do', 'dr', 'ec', 'es', 'fa', 'fn', 'fy', 'hd', 'hl', 'ho', 'hw', 'já', 'je', 'ji', 'kb', 'ke', 'km', 'ks', 'ku', 'kv', 'lg', 'li', 'lq', 'má', 'mb', 'mé', 'mi', 'mu', 'na', 'nc', 'nd', 'ne', 'ně', 'nf', 'nv', 'od', 'ok', 'on', 'op', 'os', 'pa', 'pc', 'pí', 'po', 'př', 'pt', 'sb', 'se', 'si', 'sk', 'ss', 'sš', 'st', 'sw', 'ta', 'té', 'ti', 'tj', 'to', 'tř', 'tu', 'ty', 'uč', 'uk', 'úl', 'um', 'úv', 'už', 've', 'ví', 'vš', 'vy', 'wc', 'xt', 'za', 'ze', 'že', 'zš', 'a přec', 'a přece', 'a přeci', 'a sice', 'a to', 'a/čeština', 'aby', 'aji', 'ale', 'an', 'aneb', 'ani', 'aniž', 'ano i', 'anžto', 'avšak', 'ačkoli', 'ačkoliv', 'ba', 'bo', 'buď', 'div', 'dokud', 'dílem', 'enem', 'hned', 'i', 'i když', 'jakkoliv', 'jako', 'jakoby', 'jednak', 'jen', 'jenom', 'jenže', 'jestli', 'jestliže', 'jinak', 'kdyby', 'když', 'kór', 'ledva', 'leč', 'málem', 'neb', 'nebo', 'neboli', 'neboť', 'než', 'nežli', 'ni', 'nicméně', 'nobrž

honzapav

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

honzapav

Sub HideEveryOtherRow()
'Updateby20140317
Dim rng As Range
Dim InputRng As Range
xTitleId = "KutoolsforExcel"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address, Type:=8)
Application.ScreenUpdating = False
For i = 1 To InputRng.Rows.Count Step 2
    Set rng = InputRng.Cells(i, 1)

honzapav

SELECT
    cols.table_schema,
    cols.table_name,
    cols.column_name,
    cols.data_type,
    cols.column_default,
    (
        SELECT CASE 
               WHEN COUNT(*) > 0 THEN 'Yes' 
               ELSE 'No' 

honzapav

WITH user_contact_details AS (
    SELECT 
        ucd.user_id,
        MAX(CASE WHEN ucd.type = 'email' THEN ucd.value ELSE NULL END) AS user_contact_detail_email,
        MAX(CASE WHEN ucd.type = 'phone' THEN ucd.value ELSE NULL END) AS user_contact_detail_phone
    FROM 
        user_contact_detail ucd
    GROUP BY 
        ucd.user_id
)

honzapav

SELECT b.id AS business_case_id, 
       b.supplier_id AS business_case_supplier_id, 
       p.supplier_id AS product_supplier_id,
       b.product_id,
       b.status
FROM business_case b
JOIN product p ON b.product_id = p.id
WHERE b.supplier_id IS NOT NULL
  AND b.supplier_id != p.supplier_id
  AND b.status = 'čekáme na výsledek aukce';