{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Titulní list","Rozbor hospodaření FN Olomouc-1","Ziskové kliniky FN Olomouc-3","Ziskové kliniky FN Olomouc-0","Ztrátové kliniky FN Olomouc-4","Ztrátové kliniky FN Olomouc-0","Vývoj stavu zásob-5","Přehled o čerpání nákladů-6","Náklady FN Olomouc v tis.Kč-7","Čerpání vybraných nákladů-8","Přehled o výnosech roku-9","Výnosy FN Olomouc v tis.Kč-10","Srovnání nákladů, výnosů a m-11","Srovnání nákladů a výnosů mě-12","Srovnání nákladů a výnosů na-13","Srovnání měs.přímých nákladů-14","Náklady na lůžkoden-15","LF 1-3","DA18-lůžkový fond-17","Rozbor investic-FRIM-18","Celková finanční situace-19","Nezaplacené pohledávky FN Ol-20","Pohledávky po zdr. pojišťov.-21","Nezaplacené pohledávky-22","Hospodaření,fin.sit.,solvent-23","Nezap. pohled. FNOl - souhrn-24","Vývojová řada nákladů-25","Vývojová řada výnosů -26","Vývojová řada HV - 27","Podíl ukazatelů N a V - 28","List1"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":1,"defined_names":666,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Titulní list","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                    ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[null,null,null,null,null,{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Období od:","2010-01-01"]
["do:","2010-03-31"]
["rok:",{"$f":"YEAR(dat_do)","v":2010}]
["Typ období:",{"$f":"CONCATENATE(MONTH(dat_od),\"-\",MONTH(dat_do),\"/\",YEAR(dat_do))","v":"1-3/2010"}]
["Měsíc:",{"$f":"dat_do","v":"2010-03-31"}]
[null,{"$f":"CONCATENATE(\"Skut. \", dat_obdobi)","v":"Skut. 1-3/2010"}]
[null,{"$f":"CONCATENATE(\"PLÁN \", dat_rok)","v":"PLÁN 2010"}]
["Předch.obd.od:",{"$f":"CONCATENATE(\"1.1.\",YEAR(dat_od)-1)","v":"1.1.2009"}]
["Předch.obd.do:",{"$f":"CONCATENATE((DAY(dat_do)),\".\",MONTH(dat_do),\".\",YEAR(dat_do)-1)","v":"31.3.2009"}]
["Předch.rok:",{"$f":"YEAR(dat_dorokpredch)","v":2009}]
["Předch.r. měs.",{"$f":"dat_do-366","v":"2009-03-30"}]
["Predch.typ obd.",{"$f":"CONCATENATE(MONTH(dat_odrokpredch),\"-\",MONTH(dat_dorokpredch),\"/\",YEAR(dat_dorokpredch))","v":"1-3/2009"}]

{"sheet":"Rozbor hospodaření FN Olomouc-1","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[12,0,12,1],[25,4,25,5],[2,0,2,7],[0,0,0,7]]}
["ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[null,null,null,"Rozpočet","Skutečnost",null,"Rozdíl","Překročení"]
[null,null,null,{"$f":"YEAR(dat_do)","v":2010},{"$f":"dat_obdobi","v":"1-3/2010"}]
["Náklady bez VPN",null,null,4195228,1139155.6714199965,"tis.Kč",{"$f":"N_bez_VPN-((N_bez_VPN_Rozp/12)*MONTH(dat_do))","v":90348.671419996535},{"$f":"IF(N_bez_VPN_Rozp <> 0,G7/((N_bez_VPN_Rozp/12)*MONTH(dat_do)),\"-\")","v":8.6144229987020052E-2}]
["Náklady celkem vč. VPN",null,null,4468965,1211225.3834399974,"tis.Kč",{"$f":"N_vc_VPN-((N_vc_VPN_Rozp/12)*MONTH(dat_do))","v":93984.133439997444}]
[]
["Výnosy bez VPV",null,null,4216203,1141653.3523000013,"tis.Kč",{"$f":"V_bez_VPV-((V_bez_VPV_Rozp/12)*MONTH(dat_do))","v":87602.602300001308},{"$f":"IF(V_bez_VPV_Rozp <> 0,G10/((V_bez_VPV_Rozp/12)*MONTH(dat_do)),\"-\")","v":8.3110421675617899E-2}]
["Výnosy celkem vč. VPV",null,null,4489940,1213723.064320002,"tis.Kč",{"$f":"V_vc_VPV-((V_vc_VPV_Rozp/12)*MONTH(dat_do))","v":91238.064320001984}]
[]
["Hospodářský  výsledek    = ",null,"zisk",null,{"$f":"ABS(E10-E7)","v":2497.6808800047729},"tis.Kč"]
[]
["Rozbor nákladů:"]
[]
["Překročení nákladů o:"]
[]
["SZM",null,null,null,62816,"tis. Kč"]
["Léky",null,null,null,22403,"tis. Kč"]
["Spotřeba energie",null,null,null,9739,"tis. Kč"]
["Všeobecný materiál",null,null,null,354,"tis. Kč"]
["DDHM",null,null,null,790,"tis. Kč"]
[]
[]
["Zásoby:","Limit",{"$f":"CONCATENATE(\"Počáteční stav \",DAY(dat_od),\".\",MONTH(dat_od),\".\",YEAR(dat_do))","v":"Počáteční stav 1.1.2010"},{"$f":"CONCATENATE(\"Stav k \",DAY(dat_do),\".\",MONTH(dat_do),\".\",YEAR(dat_do))","v":"Stav k 31.3.2010"},"Snížení / Zvýšení zásob o"]
["Léky",23300,34109,32237,{"$f":"IF(C27>D27,\"snížení\",\"zvýšení\")","v":"snížení"},{"$f":"D27-C27","v":-1872}]
["Krev",13000,16522,15624,{"$f":"IF(C28>D28,\"snížení\",\"zvýšení\")","v":"snížení"},{"$f":"D28-C28","v":-898}]
["SZM",14700,4824,6292,"zvýšení",1468]
["Dentální slitiny","nestanoven",242,279,{"$f":"IF(C30>D30,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D30-C30","v":37}]
["Potraviny",1600,1368,1608,"zvýšení",240]
["Prádlo",2600,1907,1888,"snížení",-19]
["Všeobecný materiál",1000,1835,1538,"snížení",-297]
["Údržbový materiál","nestanoven",936,884,"snížení",-52]
["DDHM","nestanoven",582,224,"snížení",-358]
["Materiál na cestě","nestanoven",787,971,"zvýšení",184]
["Zboží na skladě","nestanoven",21,40,"zvýšení",19]
["Zboží na cestě","nestanoven",0,0,"zvýšení",0]
["CELKEM","nestanoven",63132,61586,"snížení",-1546]
[]
[]
["Rozbor výnosů"]
[null,null,null,"Rozpočet","Skutečnost",null,"Rozdíl","Překročení"]
[null,null,null,{"$f":"YEAR(dat_do)","v":2010},{"$f":"dat_obdobi","v":"1-3/2010"}]
["Výnosy celkem",null,null,4216203,1141653.3523000013,"tis.Kč",{"$f":"E45-((D45/12)*MONTH(dat_do))","v":87602.602300001308},{"$f":"G45/((D45/12)*MONTH(dat_do))","v":8.3110421675617899E-2}]
["z toho:"]
["Výkony pro zdravotní pojišťovny",null,null,3391679,905793.37033000006,"tis.Kč",{"$f":"E47-((D47/12)*MONTH(dat_do))","v":57873.620330000063},{"$f":"IF(D47 <> 0,G47/((D47/12)*MONTH(dat_do)),\"-\")","v":6.825365293118843E-2}]
["671 vybrané činnosti MZ",null,null,5200,0,"tis.Kč",-1300,-1]
["671 VaV",null,null,15000,6581,"tis.Kč",2831,0.75493333333333335]
["671 dotace na DDM ISPROFIN",null,null,0,119,"tis.Kč",119,"-"]
["691 dotace na provoz  z ÚSC",null,null,0,0,"tis.Kč",0,"-"]
["899 vnitropodnikové výnosy",null,null,273737,72070,"tis.Kč",3635.75,5.3127637111534065E-2]
["604 tržby LS",null,null,381635,84601,"tis.Kč",-10807.75,-0.11327839427725445]
["ostatní výnosy",null,null,{"$f":" D45 -SUM(D47:D53)","v":148952},{"$f":" E45 -SUM(E47:E53)","v":72488.981970001245},"tis.Kč",35250.981970001245,0.94664004430960969]
[]
["Komentář: vlivy do nákladů - vyšší spotřeba léků v centrech, vyšší spotřeba krev.deriv., překročení nákladů na defibrilátory, pořízení "]
["                                                  nábytku - vybavení ambulance traumatologie, OUP, marketingu, poradenské služby-inv.strategie z r.09,"]
["                                                  IOP-porad.služby, školení lékařů a ost.zdr.prac, studium MBA, dorovnání DPH-strava"]
["                   vlivy do výnosů - dorovnání péče min.let VZP 4,5 mil., ZPMV a RBP 3 mil.  "]
[null,"odhad ZP z minulých let 71,2 mil. Kč"]
[null,"na regulačních poplatcích bylo vybráno 8,5 mil. Kč"]

{"sheet":"Ziskové kliniky FN Olomouc-3","index":2,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ziskové kliniky FN Olomouc proti rozpočtu"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"Klinika TVL a kard.reh","27",318]
[null,null,"Transfůzní oddělení","35",1515]

{"sheet":"Ziskové kliniky FN Olomouc-0","index":3,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ziskové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"Novorozenecké oddělení","09",3070]
[null,null,"Onkologická klinika","21",466]
[null,null,"Klinika nukleární medicíny","22",13725]
[null,null,"Klinika rehabilit. a tělových.","26",2870]
[null,null,"Ústav lékařské genetiky a fet.","28",5035]
[null,null,"Odděl.klin.biochemie a imunoge","33",5988]
[null,null,"Radiologická klinika","34",2656]
[null,null,"Transfůzní oddělení","35",10602]
[null,null,"Ústav patologie","37",7863]
[null,null,"Ústav mikrobiologie","40",2495]
[null,null,"Ústav imunologie","41",3178]
[null,null,"Kardiochirurgická klinika","50",858]
[null,null,"Oddělení int.péče chir.oborů","59",153]

{"sheet":"Ztrátové kliniky FN Olomouc-4","index":4,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ztrátové kliniky FN Olomouc proti rozpočtu"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",13875]
[null,null,"II. Interní klinika","02",1404]
[null,null,"III. Interní klinika","03",3589]
[null,null,"I. Chirurgická klinika","04",3578]
[null,null,"II. Chirurgická klinika","05",1603]
[null,null,"Neurochirurgická klinika","06",4296]
[null,null,"Klinika anesteziologie a resus","07",5542]
[null,null,"Porodnicko-gynekologická klini","08",4250]
[null,null,"Novorozenecké oddělení","09",1153]
[null,null,"Dětská klinika","10",4151]
[null,null,"Ortopedická klinika","11",2233]
[null,null,"Urologická klinika","12",1826]
[null,null,"Otolaryngologická klinika","13",492]
[null,null,"Oční klinika","14",7713]
[null,null,"Oddělení alergologie","15",411]
[null,null,"Klinika plicních nemocí a tube","16",2746]
[null,null,"Neurologická klinika","17",6202]
[null,null,"Klinika psychiatrie","18",3470]
[null,null,"Klinika pracovního lékařství","19",604]
[null,null,"Klinika chorob kožních a pohl.","20",1213]
[null,null,"Onkologická klinika","21",1807]
[null,null,"Klinika nukleární medicíny","22",2184]
[null,null,"Klinika zubního lékařství","24",159]
[null,null,"Klinika ústní,čelistní a obl.","25",279]
[null,null,"Klinika rehabilit. a tělových.","26",4349]
[null,null,"Ústav lékařské genetiky a fet.","28",1079]
[null,null,"Oddělení plastické a estetické","29",1466]
[null,null,"Oddělení geriatrie","30",1127]
[null,null,"Traumatologické oddělení","31",1851]
[null,null,"Hemato-onkologická klinika","32",11959]
[null,null,"Odděl.klin.biochemie a imunoge","33",5646]
[null,null,"Radiologická klinika","34",4226]
[null,null,"Oddělení klinické logopedie","36",128]
[null,null,"Ústav patologie","37",21]
[null,null,"Ústav soudního lékařství a med","38",847]
[null,null,"Oddělení klinické psychologie","39",412]
[null,null,"Ústav mikrobiologie","40",930]
[null,null,"Ústav imunologie","41",2217]
[null,null,"Ústav farmakologie","43",8]
[null,null,"Sociální oddělení","45",140]
[null,null,"Transplantační centrum","46",68]
[null,null,"Centrální operační sály","47",1191]
[null,null,"Lékárna","48",4150]
[null,null,"Kardiochirurgická klinika","50",6137]
[null,null,"Oddělení lékařské fyziky a rad","53",95]
[null,null,"Oddělení centrální sterilizace","56",174]
[null,null,"Oddělení int.péče chir.oborů","59",2431]
[null,null,"Oddělení urgentního příjmu","60",1714]

{"sheet":"Ztrátové kliniky FN Olomouc-0","index":5,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ztrátové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",12382]
[null,null,"II. Interní klinika","02",3469]
[null,null,"III. Interní klinika","03",443]
[null,null,"I. Chirurgická klinika","04",7577]
[null,null,"II. Chirurgická klinika","05",1660]
[null,null,"Neurochirurgická klinika","06",2392]
[null,null,"Klinika anesteziologie a resus","07",3750]
[null,null,"Porodnicko-gynekologická klini","08",4741]
[null,null,"Dětská klinika","10",5599]
[null,null,"Ortopedická klinika","11",4429]
[null,null,"Urologická klinika","12",4424]
[null,null,"Otolaryngologická klinika","13",3759]
[null,null,"Oční klinika","14",5008]
[null,null,"Oddělení alergologie","15",615]
[null,null,"Klinika plicních nemocí a tube","16",5479]
[null,null,"Neurologická klinika","17",10177]
[null,null,"Klinika psychiatrie","18",3026]
[null,null,"Klinika pracovního lékařství","19",989]
[null,null,"Klinika chorob kožních a pohl.","20",1684]
[null,null,"Klinika zubního lékařství","24",1523]
[null,null,"Klinika ústní,čelistní a obl.","25",873]
[null,null,"Klinika TVL a kard.reh","27",106]
[null,null,"Oddělení plastické a estetické","29",2400]
[null,null,"Oddělení geriatrie","30",3698]
[null,null,"Traumatologické oddělení","31",4531]
[null,null,"Hemato-onkologická klinika","32",2500]
[null,null,"Oddělení klinické logopedie","36",267]
[null,null,"Ústav soudního lékařství a med","38",1913]
[null,null,"Oddělení klinické psychologie","39",203]
[null,null,"Ústav farmakologie","43",290]
[null,null,"Sociální oddělení","45",697]
[null,null,"Transplantační centrum","46",287]
[null,null,"Centrální operační sály","47",14458]
[null,null,"Lékárna","48",60]
[null,null,"Oddělení lékařské fyziky a rad","53",1278]
[null,null,"Oddělení centrální sterilizace","56",5306]
[null,null,"Oddělení urgentního příjmu","60",9628]

{"sheet":"Vývoj stavu zásob-5","index":6,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13]]}
["    Vývoj stavu zásob"]
[{"$f":"CONCATENATE(\"      v průběhu roku  \",dat_rok)","v":"      v průběhu roku  2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poč.stav","leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Zásoby celkem",63132,65896,64030,61586]
["Léky ",34109,38614,35127,32237]
["z toho RTG diagn.",313,258,117,54]
["Krev",16522,14695,15676,15624]
["SZM",4824,4812,5758,6292]
["z toho lab. diagn.*"]
["Mater.na cestě",787,1296,1024,971]
[]
["* včetně meziskladů"]

{"sheet":"Přehled o čerpání nákladů-6","index":7,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"CONCATENATE(\"Přehled o čerpání nákladů roku  \",dat_rok)","v":"Přehled o čerpání nákladů roku  2010"}]
[]
[null,null,null,null,"(v tis.Kč)"]
[]
["Položka",{"$f":"PLAN_rok","v":"PLÁN 2010"},"Poměr pl.",{"$f":"Skut_typobd","v":"Skut. 1-3/2010"},"SK/PL v %"]
["501 10 Biologické implantáty",4200,{"$f":"B6/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":1050},2222.5219999999999,{"$f":"IF(B6<>0,D6/B6*100,0)","v":52.917190476190477}]
["501 12 PHM",2185,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":546.25},594.37017000000003,27.202296109839818]
["501 13 Léky",832484,208121,230524.34045999998,27.691143668827266]
["501 14 Krev",49954,12488.5,12655.24734,25.333801777635422]
["501 15 SZM",658938,164734.5,227550.90240000005,34.532976152536357]
["501 16 Potraviny",38751,9687.75,10397.797720000002,26.832333926866408]
["501 17 Všeobecný materiál",34889,8722.25,9076.3730999999989,26.014999283441771]
["501 18 Náhradní díly",13412,3353,2833.08043,21.123474724127647]
["501 19 DHM a textil",25000,6250,7039.6526199999989,28.158610479999997]
["501 60 Knihy a časopisy",400,100,136.273,34.068249999999999]
["501 80 Spotř.nák.-z darů, kl.stud.",4000,1000,699.33409999999992,17.483352499999999]
["502      Spotřeba energie",109812,27453,37191.990299999998,33.86878510545295]
["504 01 Prodané zboží",3532,883,885.27548999999999,25.064424971687426]
["504 95 Prodané LS",338918,84729.5,75994.519889999996,22.422686281047334]
["501 99 Opravy nákl. min. let",0,0,0,0]
["Spotřebované nákupy",{"$f":"SUM(B6:B20)","v":2116475},529118.75,{"$f":"SUM(D6:D20)","v":617801.67902000004},29.19012409879635]
["511               Opravy a udržování",47306,11826.5,10460.876990000001,22.113213947490806]
["512               Cestovné",2850,712.5,761.92898000000002,26.7343501754386]
["513               Náklady na reprezentaci",300,75,24.32,8.1066666666666656]
["518 01          Přepravné",450,112.5,95.897440000000003,21.310542222222224]
["518 02          Spoje",5800,1450,1282.0145400000001,22.103698965517243]
["518 04          Nájemné",11675,2918.75,2632.7467099999999,22.550293019271948]
["518               Ostatní služby",124487,31121.75,28640.345920000003,23.006696217275703]
["521               Osobní náklady",1145130,286282.5,289025.01699999999,25.23949394391903]
["524               Zákonné sociální pojištění",389344,97336,98419.839500000002,25.278375806484753]
["525               Ostatní sociální pojištění",4777,1194.25,0,0]
["527               Zákon. soc. poj. (FKSP)",22747,5686.75,5729.8980600000014,25.189686815843853]
["528               Náhrady-prac.nesch.",1100,275,358.07749999999999,32.552500000000002]
["53                 Daně a poplatky",725,181.25,90.318190000000001,12.457681379310346]
["54x,55x,56x  Ostatní fin.náklady",9407,2351.75,4631.8035299999901,49.237839162325827]
["551               Odpisy ",272360,68090,68028.467999999993,24.977407842561313]
["552,553        ZC prod.DNM, DHM",0,0,0,0]
["544,554        Prodaný mat. a pozemky",36100,9025,11172.440040000001,30.948587368421055]
["555               Tvorba zák. rez. a opr.pol.",0,0,0,0]
["59                 Daň z příjmů",4195,1048.75,0,0]
["Přímé náklady celkem",{"$f":"SUM(B21:B40)","v":4195228},{"$f":"SUM(C21:C40)","v":1048807},{"$f":"SUM(D21:D40)","v":1139155.6714199998},27.153605749675581]

{"sheet":"Náklady FN Olomouc v tis.Kč-7","index":8,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[36,0,36,7],[37,0,37,7]]}
["          Náklady FN Olomouc v tis. Kč"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Náklady FN Olomouc v tis. Kč"]
[null,null,"Léky ",230524]
[null,null,"Krev",12655]
[null,null,"SZM",227551]
[null,null,"Potraviny",10398]
[null,null,"Energie",37192]
[null,null,"Osobní náklady",393533]
[null,null,"Odpisy",68028]
[null,null,"Prodané zboží LS",75995]
[null,null,"Ostatní",{"$f":"D34-SUM(D25:D32)","v":83280}]
[null,null,"Celkem",1139156]
[]
[]
["        Podíl ukazatelů z celkových nákladů"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]

{"sheet":"Čerpání vybraných nákladů-8","index":9,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,13]]}
["Čerpání vybraných nákladů"]
[{"$f":"CONCATENATE(\"  v jednotlivých měsících roku  \", dat_rok)","v":"  v jednotlivých měsících roku  2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Název ","rozpočet","leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Léky",69374,78495,71187,80842]
["Krev",4163,4347,3630,4678]
["SZM",54912,63572,77825,86153]

{"sheet":"Přehled o výnosech roku-9","index":10,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"CONCATENATE(\"Přehled o výnosech roku  \",dat_rok)","v":"Přehled o výnosech roku  2010"}]
[]
[null,null,null,null,"(v tis. Kč)"]
[]
["Položka",{"$f":"PLAN_rok","v":"PLÁN 2010"},"Poměr pl.",{"$f":"Skut_typobd","v":"Skut. 1-3/2010"},"SK/PL v %"]
["601 Tržby za vlastní výrobky",0,{"$f":"B6/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":0},0,{"$f":"IF(B6<>0,D6/B6*100,0)","v":0}]
["602 10,11,13,14 Zdrav. sl. za  úhr.",56685,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":14171.25},15281.542449999997,26.958705918673363]
["602 27,28, 29 Zdrav.  výk. - běžný rok",72479,18119.75,18035.113890000019,24.883226713944754]
["602 40,42,43,46 Zdrav.vyk.-min.let",0,0,97023.750639999969,0]
["602 45 Fakturace ZP - běžný rok",3319200,829800,790734.50580000004,23.823044884309475]
["602 Ostatní služby",960,240,279.64168999999998,29.129342708333333]
["604 Prodej zboží",4330,1082.5,1120.9299099999998,25.887526789838333]
["604 Prodané léky a léčiva",381635,95408.75,84600.93428999999,22.168022925046181]
["62   Aktivace - krev a KV",82795,20698.75,21441.89316,25.89757009481249]
["648 01,02,03 Použití RF",2000,500,232.59317999999999,11.629658999999998]
["648 04 Použití FRM",47266,11816.5,10389.206450000003,21.980295455507136]
["603 Tržby z nájem.",24800,6200,6224.8083099999994,25.100033508064513]
["64x,66x,   Ostatní výnosy",160733,40183.25,75336.915069999959,46.870844860731751]
["644,645,646 Tržby z prod. mat. a majetku",43120,10780,14251.498609999999,33.050785273654917]
["67x  Výnosy z nároků na pr.SR,ÚSC,ost. ",20200,5050,6700,33.168316831683171]
["Přímé výnosy celkem",4216203,{"$f":"B21/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":1054050.75},1141653.3523000013,{"$f":"IF(B21<>0,D21/B21*100,0)","v":27.077760541890449}]

{"sheet":"Výnosy FN Olomouc v tis.Kč-10","index":11,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":true,"merged":[[33,0,33,6],[34,0,34,6],[22,2,22,3],[0,0,0,6],[1,0,1,6]]}
["Výnosy FN Olomouc v tis. Kč"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Výnosy FN Olomouc v tis. Kč"]
[null,null,"Provozní dotace",6700]
[null,null,"Výkony pro zdr.poj.",905793.37033000006]
[null,null,"Aktivace",21441.89316]
[null,null,"Tržby za léčiva",84600.93428999999]
[null,null,"Ostatní výnosy",{"$f":"D29-SUM(D23:D27)","v":123117.15452000126}]
[null,null,"Celkem",1141653.3523000013]
[]
[]
[]
[]
["      Podíl ukazatelů z celkových výnosů"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]

{"sheet":"Srovnání nákladů, výnosů a m-11","index":12,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,13]]}
["Srovnání nákladů, výnosů a os. nákladů"]
[{"$f":"CONCATENATE(\"      v jednotlivých měsících roku  \",dat_rok)","v":"      v jednotlivých měsících roku  2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["př. náklady",368455,371761,398939,0,0,0,0,0,0,0,0,0]
["př. výnosy",347098,357811,436745,0,0,0,0,0,0,0,0,0]
["os. náklady",132481,130641,130411,0,0,0,0,0,0,0,0,0]

{"sheet":"Srovnání nákladů a výnosů mě-12","index":13,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(\"                             Srovnání nákladů a výnosů v roce  \",dat_rok)","v":"                             Srovnání nákladů a výnosů v roce  2010"}]
[{"$f":"CONCATENATE(\"                                 se stejným obdobím roku  \",dat_rok-1)","v":"                                 se stejným obdobím roku  2009"}]
[]
[]
[]
["Položka",{"$f":"mesic_rokpredchoz","v":"2009-03-30"},"%",{"$f":"mesic_rok","v":"2010-03-31"},"%","Rozdíl"]
["Léky",68696,{"$f":"B7/B$19*100","v":19.223610345903502},80842,{"$f":"D7/D$19*100","v":19.116476597630058},{"$f":"D7-B7","v":12146}]
["Krev",3156,0.88316225474076304,4678,1.1061932847246903,{"$f":"D8-B8","v":1522}]
["SZM",56102,15.699356405407567,86153,20.372353582489577,30051]
["Potraviny",3562,0.9967756499957533,3887,0.91914777634135769,325]
["Všeobecný materiál",2912,0.81488228320820721,2847,0.67322194989550943,-65]
["Spotřeba energie",11469,3.2094384979790274,11281,2.6675858155150132,-188]
["Opravy a udržování",2635,0.73736772536182205,4162,0.98417624006501936,1527]
["Osobní náklady",114264,31.975174865557204,130410.65382000015,30.837834440410528,16146.653820000152]
["Odpisy",21523,6.0229091282590117,22677,5.3623653522235575,1154]
["Vnitropodnik. náklady",23530.729419999985,6.5847439956470186,23952.332150000006,5.6639394993213577,421.60273000002053]
["Ostatní náklady",{"$f":"B19- SUM(B7:B16) - B18","v":49502.499239997414},13.852578847940119,{"$f":"D19- SUM(D7:D16) - D18","v":52001.75135999656},12.296705461383333,2499.2521199991461]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",357352.2286599974,100,422891.73732999671,100,65539.508669999312]
["Tržby za vl. výrobky",0,{"$f":"B20/B$35*100","v":0},0,{"$f":"D20/D$35*100","v":0},0]
["Zdr. služby za úhradu",5287.2897499999999,1.5131833922413176,6122.5971200000022,1.3289857045963804,835.30737000000227]
["Tržby z nájemného",2690.510389999999,0.77000426140835365,2000.9538900000002,0.43433187963321646,-689.55649999999878]
["Zdrav. výk. - běžný rok",8110.3051700000005,2.3211096175035415,7320.3673099999996,1.5889765922381407,-789.93786000000091]
["Zdrav. výk. - min. let",19.959779999999903,5.7123420574388337E-3,72110.315160000013,15.652439009669743,72090.355380000008]
["Fakturace ZP - běžný rok",253692.14400000003,72.604823490691601,264062.02171999984,57.317939611989132,10369.877719999815]
["Ostatní služby",47.369599999999998,1.3556830702746018E-2,110.56259,2.3998982571165922E-2,63.192990000000002]
["Tržby za prodané léky",29863,8.5465706967359729,34585,7.507103553053283,4722]
["Ost. tržby za prodané zboží",371,0.10617746805374698,419,9.0949151040315909E-2,48]
["Aktivace - krev a KV",6275,1.7958587925532676,8154,1.7699269154719235,1879]
["Tržby z prodeje materiálu a majetku",4594,1.3147689709943762,6465.0124500000002,1.4033112023689089,1871.0124500000002]
["Provozní dotace od zřizovatele",306,8.7574946696621497E-2,6700,1.4543181669931184,6394]
["Vnitropodnik. výnosy",23531,6.7343989239156885,23952.332150000009,5.1991510130743812,421.33215000000928]
["Použití rezervního fondu",59,1.6885365539544669E-2,69,1.4977306495899279E-2,10]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":14568.421310000005},4.169374900905801,{"$f":"D35 - SUM(D20:D33)","v":28625.826209999097},6.2135909108043963,14057.404899999092]
["Výnosy celkem",349415,100,460696.98859999893,100,111281.98859999893]
["Hospodářský výsledek",{"$f":"B35-B19","v":-7937.2286599974032},null,{"$f":"D35-D19","v":37805.25127000222},null,45742.479929999623]
["Průměrný počet lůžek",1396,null,1393,null,-3]
["Počet oš. dnů",33134,null,32491,null,-643]
["Prům. nákl. na lůžkoden (hospit.)",2553.4574361682903,null,3198.1912794312293,null,644.73384326293899]
["Prům. náklady na oš. den FNO",9262.6050751493985,null,11310.69496906831,null,2048.0898939189119]
[]
[]
["Rozdíl:"]
["            úspora nákladů (-)"]
["            překročení nákladů (+)"]
["            snížení výnosů (-)"]
["            překročení výnosů (+)"]

{"sheet":"Srovnání nákladů a výnosů na-13","index":14,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["                        Srovnání nákladů a výnosů v roce",null,null,{"$f":"dat_rok","v":2010}]
["                               se stejným obdobím roku",null,{"$f":"dat_rok-1","v":2009}]
[]
[]
[]
["Položka",{"$f":"dat_obdobirokpredch","v":"1-3/2009"},"%",{"$f":"dat_obdobi","v":"1-3/2010"},"%","Rozdíl"]
["Léky",197858,{"$f":"B7/B$19*100","v":19.314393595514286},230524,{"$f":"D7/D$19*100","v":19.032295983204175},{"$f":"D7-B7","v":32666}]
["Krev",8698,0.8490765877234342,12655,1.044809675640926,{"$f":"D8-B8","v":3957}]
["SZM",148439,14.49023679065059,227551,18.786842078369684,79112]
["Potraviny",9732,0.950013031929692,10398,0.85846945928995244,666]
["Všeobecný materiál",8774,0.85649551399004498,9076,0.74932379424077789,302]
["Spotřeba energie",34972,3.4138774920514989,37192,3.0706093604454621,2220]
["Opravy a udržování",6870,0.67063188752126834,10461,0.86367080338836244,3591]
["Osobní náklady",340675,33.255825077337427,393532.83205999923,32.49047100898165,52857.832059999229]
["Odpisy",65943,6.4371875631462894,68028,5.616460894073561,2085]
["Vnitropodnik. náklady",65601,6.4038023949465392,72069.712020000341,5.9501487506243782,6468.712020000341]
["Ostatní náklady",{"$f":"B19 - SUM(B7:B16) - B18","v":136845},13.358460065188934,{"$f":"D19 - SUM(D7:D16) - D18","v":139737.83935999777},11.536898191741059,2892.8393599977717]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",1024407,100,1211225.3834399974,{"$f":"SUM(E7:E17)","v":99.999999999999986},186818.38343999744]
["Tržby za vl. výrobky",0,{"$f":"B20/B$35*100","v":0},0,{"$f":"D20/D$19*100","v":0},0]
["Zdr. služby za úhradu",14387.115360000009,1.3816878948899958,15281.542449999997,1.2616596926493511,894.42708999998831]
["Tržby z nájemného",8500.1709100000007,0.8163264808104711,6224.8083099999994,0.51392650741193524,-2275.3626000000013]
["Zdrav. výk. - běžný rok",29114.764149999966,2.7960794212073479,18035.113890000019,1.4889973523159288,-11079.650259999948]
["Zdrav. výk. - min. let",480.8397699999997,4.6178158231622676E-2,97023.750639999969,8.0103795682058045,96542.910869999963]
["Fakturace ZP - běžný rok",761087.36320000072,73.092150189528056,790734.50580000004,65.283845319872455,29647.142599999323]
["Ostatní služby",272.99869999999993,2.6217833781983745E-2,279.64168999999998,{"$f":"D26/D$35*100","v":2.303999142973125E-2},6.6429900000000544]
["Tržby za prodané léky",90213,8.6637388345589184,84601,6.9703709591609666,-5612]
["Ost. tržby za prodané zboží",983,9.4403858361560053E-2,1121,9.2360443082462898E-2,138]
["Aktivace - krev a KV",18092,1.7374919689494857,21442,1.7666303484158514,3350]
["Tržby z prodeje materiálu a majetku",11105,1.0664850936979902,14251.498609999999,1.1741969011674434,3146.4986099999987]
["Provozní dotace od zřizovatele",918,8.8161487259320576E-2,6700,0.55202048943131266,5782]
["Vnitropodnik. výnosy",65601,6.3000890258155655,72069.712020000341,5.9379041346946781,6468.712020000341]
["Použití rezerv. Fondu",439,4.2160014059740451E-2,233,1.9197130453357587E-2,-206]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":40076.747909999336},3.8488297388479404,{"$f":"D35 - SUM(D20:D33)","v":85725.490910001565},7.0630190222206872,45648.743000002229]
["Výnosy celkem",1041271,100,1213723.064320002,100,172452.06432000198]
["Hospodářský výsledek",{"$f":"B35-B19","v":16864},null,{"$f":"D35-D19","v":2497.6808800045401},null,-14366.31911999546]
["Průměrný počet lůžek",1396,null,1393,null,-3]
["Počet oš. dnů",91069,null,90147,null,-922]
["Prům. nákl. na lůžkoden (hospit.)",929.03467359914055,null,3421.7919342851142,null,2492.7572606859735]
["Prům. náklady na oš. den FNO",9630.526605979996,null,11783.818385969524,null,2153.2917799895276]
[]
[]
["Rozdíl:"]
["            úspora nákladů (-)"]
["            překročení nákladů (+)"]
["            snížení výnosů (-)"]
["            překročení výnosů (+)"]

{"sheet":"Srovnání měs.přímých nákladů-14","index":15,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14]]}
["Srovnání měsíčních přímých nákladů"]
[{"$f":"CONCATENATE(\"v letech \",(dat_rok - 3),\" - \",(dat_rok))","v":"v letech 2007 - 2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"dat_rok-3","v":2007},{"$f":"dat_rok-2","v":2008},{"$f":"dat_rok-1","v":2009},{"$f":"dat_rok","v":2010}]
[null,null,null,null,null,"leden",281893,314446,323329,368455]
[null,null,null,null,null,"únor",256650,291124,301656,371761]
[null,null,null,null,null,"březen",290042,307756,333821,398939]
[null,null,null,null,null,"duben",272114,310025,334925]
[null,null,null,null,null,"květen",281236,299979,323913]
[null,null,null,null,null,"červen",308643,241350,327130]
[null,null,null,null,null,"červenec",288462,323227,340500]
[null,null,null,null,null,"srpen",282016,295521,322292]
[null,null,null,null,null,"září",268948,314214,368941]
[null,null,null,null,null,"říjen",304485,325578,382151]
[null,null,null,null,null,"listopad",317797,330337,396024]
[null,null,null,null,null,"prosinec",374472,198450,475105]

{"sheet":"Náklady na lůžkoden-15","index":16,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Náklady na lůžkoden"]
[{"$f":"CONCATENATE(\"ve FN Olomouc v roce \",dat_rok)","v":"ve FN Olomouc v roce 2010"}]
[]
[]
[]
[]
[]
["Počet ošetř. dnů",32491,null,{"$f":"mesic_rok","v":"2010-03-31"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",17298.914989999968,{"$f":"B10*1000/B8","v":532.4217472530845},{"$f":"C10/C17*100","v":16.647589238245033}]
["Krev a KV",4108.9650000000001,{"$f":"B11*1000/B8","v":126.46471330522299},{"$f":"C11/C17*100","v":3.9542573365941274}]
["ZPr",4714.3097600000001,{"$f":"B12*1000/B8","v":145.09586531654918},{"$f":"C12/C17*100","v":4.5368101104432137}]
["Potraviny",1969.4026599999995,{"$f":"B13*1000/B8","v":60.613790280385324},{"$f":"C13/C17*100","v":1.8952521905182909}]
["Prádlo",365.67756000000014,{"$f":"B14*1000/B8","v":11.25473392631806},{"$f":"C14/C17*100","v":0.35190934321850875}]
["Osobní náklady",52949.465739999971,{"$f":"B15*1000/B8","v":1629.6656224800706},{"$f":"C15/C17*100","v":50.95585223313762}]
["Ost.nákl. v lůžkové č.",{"$f":"B17-SUM(B10:B15)","v":22505.697150000138},{"$f":"B16*1000/B8","v":692.67480686959902},{"$f":"C16/C17*100","v":21.65832954784322}]
["Náklady celkem",103912.43286000007,{"$f":"SUM(C10:C16)","v":3198.1912794312293},{"$f":"SUM(D10:D16)","v":100.00000000000001}]
[]
[]
[]
[]
["Počet ošetř. dnů",90147,null,{"$f":"dat_obdobi","v":"1-3/2010"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",48267.168070000007,{"$f":"B24*1000/B22","v":535.42733612876759},{"$f":"C24/C31*100","v":15.647571401521521}]
["Krev a KV",11345.781999999999,{"$f":"B25*1000/B22","v":125.8586752748289},{"$f":"C25/C31*100","v":3.678151029984337}]
["SZM",13568.613750000002,{"$f":"B26*1000/B22","v":150.51653133215748},{"$f":"C26/C31*100","v":4.3987634030005278}]
["Potraviny",5493.2407499999954,{"$f":"B27*1000/B22","v":60.936478751372704},{"$f":"C27/C31*100","v":1.7808353027199371}]
["Prádlo",994.86728999999912,{"$f":"B28*1000/B22","v":11.036055442776789},{"$f":"C28/C31*100","v":0.32252269146465379}]
["Osobní náklady",160089.4380800002,{"$f":"B29*1000/B22","v":1775.870945012038},{"$f":"C29/C31*100","v":51.898858233268221}]
["Ost.nákl. v lůžkové č.",{"$f":"B31-SUM(B24:B29)","v":68705.167560000002},{"$f":"B30*1000/B22","v":762.14591234317288},{"$f":"C30/C31*100","v":22.273297938040805}]
["Náklady celkem",308464.2775000002,{"$f":"SUM(C24:C30)","v":3421.7919342851142},{"$f":"SUM(D24:D30)","v":100}]

{"sheet":"LF 1-3","index":17,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Fakultní nemocnice Olomouc",null,null,null,null,null,null,"               L E D E N - B Ř E Z E N  2 0 1 0"]
["LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS"]
["             Počet dnů: 90"]
["Klinika  |Prům|      Počet ošetřovanců      |Prům|Skut. |Uzav.|Počet  |Využ.lůžek |Prům.|Počet|Prost|Obrat"]
["         |poč.|-----------------------------|den.|lůžko.|lůžka|ošetř. |-----------|ošetř|hosp.|L/lho|Lůžka"]
["         |lůž.|PŘIJ |exTR+|PROP |exTR-|Úmrtí|p.ho|kapac.|     |dnů    | dny  |  % |doba |     |(dny)|     "]
["=========================================================================================================="]
["1.IK     |  63|  911|   31|  805|   94|    8|  53|  5342|  328|  4758 | 75,5| 89,1|  5,1|  925| 0,6| 15,6|"]
["2.IK     |  62|  606|   30|  521|   81|   17|  50|  5580|    0|  4506 | 72,7| 80,8|  7,2|  628| 1,7| 10,1|"]
["3.IK     |  70|  619|   55|  525|   97|   21|  51|  5628|  672|  4593 | 65,6| 81,6|  7,0|  659| 1,6| 10,5|"]
["GER      |  90|   36|  211|  189|    8|   14|  51|  4842| 3258|  4625 | 51,4| 95,5| 20,2|  229| 0,9|  4,3|"]
["PLIC     |  61|  584|   50|  518|   46|   22|  49|  5394|   96|  4404 | 72,2| 81,6|  7,2|  610| 1,6| 10,2|"]
["NEUR     |  72|  594|   17|  521|   64|    5|  59|  6390|   90|  5291 | 73,5| 82,8|  8,8|  601| 1,8|  8,5|"]
["PSY      |  90|  219|   10|  200|    6|    0|  48|  5154| 2946|  4327 | 48,1| 84,0| 19,9|  218| 3,8|  3,8|"]
["DK       | 100| 1562|    3| 1514|    1|    1|  77|  9000|    0|  6965 | 69,7| 77,4|  4,5| 1541| 1,3| 15,4|"]
["PORGYN   |  87| 1094|    8| 1071|    9|    1|  59|  6997|  833|  5327 | 61,2| 76,1|  4,9| 1092| 1,5| 14,0|"]
["NOVO     |  50|  609|    0|  611|    3|    1|  47|  4500|    0|  4260 | 85,2| 94,7|  7,0|  612| 0,4| 12,2|"]
["1CHIR    |  86|  666|  188|  605|  173|   10|  65|  7362|  378|  5825 | 67,7| 79,1|  7,1|  821| 1,9| 10,0|"]
["2CHIR    |  33|  392|   21|  357|   26|    2|  29|  2970|    0|  2566 | 77,8| 86,4|  6,4|  399| 1,0| 12,1|"]
["NCHIR    |  44|  392|   30|  362|   21|   11|  29|  3683|  277|  2590 | 58,9| 70,3|  6,3|  408| 2,7| 10,0|"]
["PCHIR    |  18|  225|   11|  211|   10|    0|  11|  1566|   54|  1014 | 56,3| 64,8|  4,4|  229| 2,4| 13,1|"]
["KCHIR    |  41|  162|   59|  174|   16|    3|  27|  3500|  190|  2398 | 58,5| 68,5| 11,6|  207| 5,3|  5,3|"]
["TRAUM    |  33|  514|   15|  446|   64|    1|  22|  2970|    0|  2005 | 60,8| 67,5|  3,9|  520| 1,9| 15,8|"]
["KAR      |  10|   54|   69|   20|   67|   37|   7|   860|   40|   655 | 65,5| 76,2|  5,3|  124| 1,7| 12,9|"]
["ORT      |  72|  695|   19|  622|   49|    0|  41|  4413| 2067|  3686 | 51,2| 83,5|  5,3|  693| 1,0| 14,1|"]
["URO      |  32|  371|  145|  347|  153|    2|  24|  2817|   63|  2178 | 68,1| 77,3|  4,3|  509| 1,3| 16,3|"]
["ORL      |  40|  416|   31|  390|   34|    1|  24|  3242|  358|  2198 | 55,0| 67,8|  5,0|  436| 2,4| 12,1|"]
["OCNI     |  26|  218|    4|  201|    3|    0|  13|  2340|    0|  1165 | 44,8| 49,8|  5,5|  213| 5,5|  8,2|"]
["KOZNI    |  26|  217|    3|  197|    8|    0|  23|  2277|   63|  2051 | 78,9| 90,1|  9,7|  213| 1,1|  8,4|"]
["ONK      |  64|  572|   10|  514|    9|   21|  44|  5649|  111|  3980 | 62,2| 70,5|  7,1|  563| 3,0|  9,0|"]
["HOK      |  34|  233|    6|  197|    8|    7|  30|  3060|    0|  2664 | 78,4| 87,1| 11,8|  226| 1,8|  6,6|"]
["REH      |  28|   86|   37|   92|    3|    0|  24|  2436|   84|  2126 | 75,9| 87,3| 19,5|  109| 2,8|  4,0|"]
["KNM      |  10|   96|    0|   81|    6|    0|   7|   860|   40|   623 | 62,3| 72,4|  6,8|   92| 2,6|  9,6|"]
["PRAC     |  18|  152|    1|  137|    2|    0|  14|  1566|   54|  1296 | 72,0| 82,8|  8,9|  146| 1,8|  8,4|"]
["IPCHO    |  13|   15|  337|    3|  339|    6|  10|  1155|   15|   925 | 71,2| 80,1|  2,6|  350| 0,7| 27,3|"]
["UCOCH    |  20|  223|   13|  212|   14|    0|  13|  1800|    0|  1146 | 57,3| 63,7|  5,0|  231| 2,8| 11,6|                                                                                                         "]
["=========================================================================================================="]
["Celkem   |1393|12533| 1414|11643| 1414|  191|1002|113353|12017| 90147 | 64,7| 79,5|  7,4|12184| 1,9| 9,7 |"]

{"sheet":"DA18-lůžkový fond-17","index":18,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Fakultní nemocnice Olomouc",null,null,null,null,null,null,null,null,"    B Ř E Z E N  2 0 1 0 "]
["LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Počet dnů:",31]
["Klinika  |Poč.|      Počet ošetřovanců      |Prům|Skut. |Uzav.|Počet  | Využ.lůžek|Prům.|Počet"]
["         |lůž.|-----------------------------|den.|lůžko.|lůžka|ošetř. |-----------|ošetř|hosp."]
["         |    |PŘIJ |exTR+|PROP |exTR-|Úmrtí|p.ho|kapac.|     |dnů    | dny  |  % |doba |     "]
["=============================================================================================="]
["1.IK     |  63|  351|    7|  315|   31|    4|  51|  1709|  244|  1579 | 25,1| 92,4|  4,5|  354"]
["2.IK     |  62|  227|   12|  187|   38|    5|  53|  1922|    0|  1658 | 26,7| 86,3|  7,1|  235"]
["3.IK     |  70|  236|   19|  195|   34|    8|  53|  1984|  186|  1650 | 23,6| 83,2|  6,7|  246"]
["GER      |  90|   16|   72|   76|    2|    4|  54|  1705| 1085|  1662 | 18,5| 97,5| 19,6|   85"]
["PLIC     |  61|  213|   16|  187|   15|    9|  49|  1891|    0|  1530 | 25,1| 80,9|  7,0|  220"]
["NEUR     |  72|  216|    6|  199|   15|    2|  59|  2232|    0|  1817 | 25,2| 81,4|  8,3|  219"]
["PSY      |  90|   71|    3|   74|    5|    0|  48|  1798|  992|  1503 | 16,7| 83,6| 19,6|   77"]
["DK       | 100|  599|    2|  582|    1|    0|  84|  3100|    0|  2619 | 26,2| 84,5|  4,4|  592"]
["PORGYN   |  87|  426|    2|  423|    4|    0|  65|  2480|  217|  2028 | 23,3| 81,8|  4,7|  428"]
["NOVO     |  50|  222|    0|  220|    2|    1|  48|  1550|    0|  1495 | 29,9| 96,5|  6,7|  223"]
["1CHIR    |  86|  254|   69|  239|   62|    3|  73|  2666|    0|  2257 | 26,2| 84,7|  7,2|  314"]
["2CHIR    |  33|  128|    9|  124|   10|    1|  30|  1023|    0|   916 | 27,8| 89,5|  6,7|  136"]
["NCHIR    |  44|  155|    5|  130|    7|    6|  29|  1364|    0|   912 | 20,7| 66,9|  6,0|  152"]
["PCHIR    |  18|   88|    3|   82|    4|    0|  12|   558|    0|   383 | 21,3| 68,6|  4,3|   89"]
["KCHIR    |  41|   58|   25|   70|    4|    1|  30|  1271|    0|   921 | 22,5| 72,5| 11,7|   79"]
["TRAUM    |  33|  159|    5|  140|   19|    0|  21|  1023|    0|   643 | 19,5| 62,9|  4,0|  162"]
["KAR      |  10|   14|   33|    7|   27|    6|   7|   310|    0|   224 | 22,4| 72,3|  5,1|   44"]
["ORT      |  72|  257|    6|  237|   16|    0|  45|  1550|  682|  1391 | 19,3| 89,7|  5,4|  258"]
["URO      |  32|  122|   47|  126|   53|    1|  24|   992|    0|   757 | 23,7| 76,3|  4,3|  175"]
["ORL      |  40|  147|   13|  147|   15|    0|  25|  1147|   93|   763 | 19,1| 66,5|  4,7|  161"]
["OCNI     |  26|   82|    1|   76|    0|    0|  14|   806|    0|   437 | 16,8| 54,2|  5,5|   80"]
["KOZNI    |  26|   83|    2|   80|    5|    0|  26|   806|    0|   800 | 30,8| 99,3|  9,4|   85"]
["ONK      |  64|  208|    3|  194|    2|    8|  41|  1984|    0|  1276 | 19,9| 64,3|  6,1|  208"]
["HOK      |  34|   92|    1|   82|    2|    2|  31|  1054|    0|   969 | 28,5| 91,9| 10,8|   90"]
["REH      |  28|   29|   13|   36|    1|    0|  26|   868|    0|   795 | 28,4| 91,6| 20,1|   40"]
["KNM      |  10|   39|    0|   35|    3|    0|   7|   310|    0|   228 | 22,8| 73,5|  5,9|   39"]
["PRAC     |  18|   55|    1|   50|    1|    0|  16|   558|    0|   496 | 27,6| 88,9|  9,3|   54"]
["IPCHO    |  13|    4|  123|    2|  122|    1|  11|   403|    0|   326 | 25,1| 80,9|  2,6|  126"]
["UCOCH    |  20|   82|    7|   80|    5|    0|  15|   620|    0|   456 | 22,8| 73,5|  5,2|   87                                                                                                          "]
["=============================================================================================="]
["Celkem   |1393| 4633|  505| 4395|  505|   62|1048| 39684| 3499| 32491 | 23,3| 81,9|  7,1| 4545"]

{"sheet":"Rozbor investic-FRIM-18","index":19,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["                             Rozbor investic - FRM k",null,{"$f":"dat_do","v":"2010-03-31"}]
[]
[]
["Plán odpisů roku",{"$f":"dat_rok","v":2010},272360000]
["               Alikvotní část odpisů",null,{"$f":"FRIM_planodpisu/12*MONTH(dat_do)-MONTH(g)+1","v":68090000}]
["               Skutečně zúčtované odpisy",null,67800615]
["               Limit vlastních zdrojů pro nákup inv.2009",null,311314761]
[]
[]
["F R M  -  čerpání",null,null,"v Kč"]
[]
[]
[]
["DRUH  INVESTICE","ČERPÁNÍ  CELKEM","TVORBA-VLAST.+CIZÍ ZDR.","NEDOČERPÁNO"]
["vlastní zdroje",null,{"$f":"C7","v":311314761},{"$f":"C15-(B16+B17+B18+B19+B20)","v":280987435.25}]
["stavby",12803447]
["projekty",42000]
["Přístrojová technika",2999056]
["technické zhodnocení",4093616.3]
["oprava a udržování",10389206.449999999]
["DARY",null,0,{"$f":"C21-(B22+B23+B24)","v":0}]
["stavby",0]
["projekty",0]
["Přístrojová technika",0]
["OSTATNÍ DOTACE",null,0,{"$f":"C25-(B26+B27+B28)","v":0}]
["stavby",0]
["projekty",0]
["Přístrojová technika",0]
["SYSTÉM.DOTACE 916",null,0,{"$f":"C29-(B30+B31+B32+B33)","v":0}]
["stavby",0]
["projekty",0]
["Přístrojová technika",0]
["Přístrojová technika - granty",0]
["SYSTÉM.DOTACE 916 IOP",null,0,{"$f":"C34-(B35+B36+B37)","v":0}]
["stavby",0]
["projekty",0]
["Přístrojová technika",0]
["C E L K E M ",{"$f":"SUM(B15:B37)","v":30327325.75},{"$f":"SUM(C15:C37)","v":311314761},{"$f":"SUM(D15:D37)","v":280987435.25}]
[]
["Z toho:"]
["čerpání z odpisů",{"$f":"SUM(B16:B20)","v":30327325.75},{"$f":"SUM(C15)","v":311314761},{"$f":"SUM(D15)","v":280987435.25}]
["čerpání z dotací",{"$f":"SUM(B22:B37)","v":0},{"$f":"SUM(C21:C37)","v":0},{"$f":"SUM(D21:D37)","v":0}]

{"sheet":"Celková finanční situace-19","index":20,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Celková finanční situace:"]
[]
["Rozbor platební neschopnosti FN k ",null,"2010-03-31"]
[]
[]
["Zůstatek na BÚ  (bez FKSP) ",null,242906,"tis. Kč"]
[]
[]
["Potřeba finančních prostředků na mzdy za měsíc ",null,null,"2010-03-01"]
["celkem",null,130209,"tis. Kč"]
[]
[]
["1. Stav závazků vůči dodavatelům k ",null,"2010-03-31"]
[]
["Závazky","LS","FN","Celkem"]
["do splatnosti",347797464.86000001,200356631.84999999,{"$f":"SUM(B16:C16)","v":548154096.71000004}]
["po splat. do 30 dnů",10156847.65,32525324.469999999,42682172.119999997]
["31 - 90 dnů",0,26543895.120000001,26543895.120000001]
["91 - 180 dnů",0,5045.1899999999996,5045.1899999999996]
["181 - 360 dnů",0,130719.6,130719.6]
["nad 360 dnů",0,313123.56,313123.56]
["C e l k e m ",{"$f":"SUM(B16:B21)","v":357954312.50999999},{"$f":"SUM(C16:C21)","v":259874739.78999999},{"$f":"SUM(D16:D21)","v":617829052.30000007}]
[]
[]
[]
[]
["Pohledávky"]
[]
["FN - pouze ve vztahu k odběratel.  (úč. 311+324+970)",null,null,409116,"tis. Kč"]
["LS - pouze ve vztahu k odběratelům",null,null,35586,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D29:D30)","v":444702},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,18723,"tis. Kč"]
[]
[]
["Závazky"]
[]
["FN - pouze ve vztahu k dodavatel. (úč.321+314+970)",null,null,259875,"tis. Kč"]
["LS - pouze ve vztahu k dodavatelům",null,null,357954,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D38:D39)","v":617829},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,69675,"tis. Kč"]

{"sheet":"Nezaplacené pohledávky FN Ol-20","index":21,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"                                              Nezaplacené pohledávky FN Olomouc"]
[null,"                                                                   k 31.3..2010"]
[]
[]
["Kód","Název zdravotní pojišťovny (ZP)","do splatnosti","po splatnosti","Celkem"]
[111,"Všeobecná zdrav.pojišťovna ČR",{"$f":"294983153.71+17880552.33","v":312863706.03999996},-32037.439999999999,{"$f":"C6+D6","v":312831668.59999996}]
[201,"Vojenská zdrav.pojišťovna  ČR",{"$f":"27491484.6+2222921.9","v":29714406.5},{"$f":"25-10500","v":-10475},29703931.5]
[205,"Česká průmyslová ZP",{"$f":"19693015.78+3394844.83","v":23087860.609999999},{"$f":"1481.48+26380.22+5.02","v":27866.720000000001},23115727.329999998]
[207,"Oborová zdr.poj.zam.bank a p.",{"$f":"8758134.83+1465987.13","v":10224121.960000001},18898,10243019.960000001]
[209,"Zaměstnanecká poj.ŠKODA",{"$f":"56718.51+7498.89","v":64217.4},0,64217.4]
[211,"Zdr.poj.ministerstva vnitra CR",{"$f":"648773.6+2619232.47","v":3268006.0700000003},0,3268006.0700000003]
[213,"Revirní bratrská pokladna",{"$f":"102865.54+1863071.07","v":1965936.61},0,1965936.61]
[217,"Zdrav.poj. METAL-ALIANCE",{"$f":"32520787.35+4831659.21","v":37352446.560000002},52000,37404446.560000002]
[222,"Česká národní zdravotní pojiš.",0,0,{"$f":"C14+D14","v":0}]
[227,"Pojišťovna AGEL",0,0,0]
[228,"ZP Media",{"$f":"1399187.14+318970.49","v":1718157.63},{"$f":"301578.32+65418.94","v":366997.26},2085154.89]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C18)","v":420258859.37999994},{"$f":"SUM(D6:D18)","v":423249.54000000004},{"$f":"SUM(E6:E18)","v":420682108.9199999}]
[202,"Hornická zaměstnanecká poj.",0,0,0]
[204,"Zdrav.poj. GARANT-HOSPITAL",0,0,0]
[206,"Moravská zdravotní pojišťovna",0,0,0]
[208,"Zdravotní pojišťovna ATLAS",0,0,0]
[210,"Zdrav.poj. škodováků",0,0,0]
[214,"Regionální zdrav.poj.REZAPO",0,0,0]
[215,"Moravskoslezská poj. IMPULS",0,0,0]
[216,"Zdravotní pojišťovna SALVUS",0,0,0]
[218,"Zdrav.poj. CRYSTAL",0,0,0]
[219,"Prostějovská zdravotní poj.",0,0,0]
[221,"Mendlova zdravotní poj.",0,0,0]
[223,"Zem.-potrav. zdrav.poj. ZEPO",0,0,0]
[224,"Zaměstnanecká zdrav.poj. RADIX",0,0,0]
[225,"Zdravotní pojišťovna SPORT",0,0,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (zaniklé ZP)",{"$f":"SUM(C20:C35)","v":0},{"$f":"SUM(D20:D35)","v":0},{"$f":"SUM(E20:E35)","v":0}]
[null,"Slovenské ZP",0,0,0]
[null,"Pohledávky celkem",{"$f":"C19+C36+C37","v":420258859.37999994},{"$f":"D19+D36+D37","v":423249.54000000004},{"$f":"E19+E36+E37","v":420682108.9199999}]

{"sheet":"Pohledávky po zdr. pojišťov.-21","index":22,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,null,"              Pohledávky po zdrav. pojišťovnách"]
[null,null,null,"k ",{"$f":"dat_do","v":"2010-03-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ZP celkem","VZP","Ostat. ZP"]
[null,null,"pohl.celkem",{"$f":"SUM(E47:F47)","v":420682.10891999997},312831.66859999998,107850.44031999999]
[null,null,"pohl.po spl.",{"$f":"SUM(E48:F48)","v":423.24953999999997},-32.037440000000004,455.28697999999997]

{"sheet":"Nezaplacené pohledávky-22","index":23,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,null,"      Nezaplacené pohledávky k ",null,null,null,null,{"$f":"dat_do","v":"2010-03-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zdrav.poj.","VZP",201,205,207,210,211,213,215,217,219,222,225]
["pohl.celk.",312831.66859999998,29703.931499999999,23099.035899999999,10243.019960000001,0,3268.0060699999999,1965.9366100000002,0,37404.446560000004,0,5.0199999999999993E-3,0]
["pohl.po spl.",-32.037440000000004,-10.475,26.380220000000001,18.898,0,0,0,0,52,0,5.0199999999999993E-3,0]

{"sheet":"Hospodaření,fin.sit.,solvent-23","index":24,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,"Hospodaření, finanční situace a solventnost"]
[null,null,null,"     FN Olomouc v roce ",null,{"$f":"dat_rok","v":2010}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"HV","Pohledávky","Závazky","Solventnost"]
[null,null,1,-21.357035850000084,487.52528856000026,584.1,{"$f":"SUM(E36-F36)","v":-96.57471143999976}]
[null,null,"1-2",-35.307570389999988,499.65068026000017,582.79999999999995,{"$f":"SUM(E37-F37)","v":-83.149319739999783}]
[null,null,"1-3",2.497680879999876,444.6882145400001,617.79999999999995,{"$f":"SUM(E38-F38)","v":-173.11178545999985}]
[null,null,"1-4"]
[null,null,"1-5"]
[null,null,"1-6"]
[null,null,"1-7"]
[null,null,"1-8"]
[null,null,"1-9"]
[null,null,"1-10"]
[null,null,"1-11"]
[null,null,"1-12"]

{"sheet":"Nezap. pohled. FNOl - souhrn-24","index":25,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4]]}
["Nezaplacené pohledávky FN Olomouc"]
[{"$f":"CONCATENATE(\"k  \",DAY(dat_do),\".\",MONTH(dat_do),\".\",YEAR(dat_do))","v":"k  31.3.2010"}]
[]
[]
["Kód","Název zdravotní pojišťovny (ZP)","do splatnosti","po splatnosti","Celkem"]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A6","v":111},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B6","v":"Všeobecná zdrav.pojišťovna ČR"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C6","v":312863706.03999996},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D6","v":-32037.439999999999},{"$f":"C6+D6","v":312831668.59999996}]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A7","v":201},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B7","v":"Vojenská zdrav.pojišťovna  ČR"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C7","v":29714406.5},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D7","v":-10475},29703931.5]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A8","v":205},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B8","v":"Česká průmyslová ZP"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C8","v":23087860.609999999},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D8","v":27866.720000000001},23115727.329999998]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A9","v":207},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B9","v":"Oborová zdr.poj.zam.bank a p."},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C9","v":10224121.960000001},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D9","v":18898},10243019.960000001]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A10","v":209},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B10","v":"Zaměstnanecká poj.ŠKODA"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C10","v":64217.4},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D10","v":0},64217.4]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A11","v":211},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B11","v":"Zdr.poj.ministerstva vnitra CR"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C11","v":3268006.0700000003},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D11","v":0},3268006.0700000003]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A12","v":213},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B12","v":"Revirní bratrská pokladna"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C12","v":1965936.61},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D12","v":0},1965936.61]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A13","v":217},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B13","v":"Zdrav.poj. METAL-ALIANCE"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C13","v":37352446.560000002},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D13","v":52000},37404446.560000002]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A15","v":227},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B15","v":"Pojišťovna AGEL"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C15","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D15","v":0},0]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A16","v":228},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B16","v":"ZP Media"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C16","v":1718157.63},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D16","v":366997.26},2085154.89]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A17","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B17","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C17","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D17","v":0},0]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A18","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B18","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C18","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D18","v":0},0]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C17)","v":420258859.37999994},{"$f":"SUM(D6:D17)","v":423249.54000000004},{"$f":"SUM(E6:E17)","v":420682108.9199999}]
[null,"Pohledávky celkem (zaniklé ZP)",{"$f":"'Nezaplacené pohledávky FN Ol-20'!C36","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D36","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!E36","v":0}]
[null,"Slovenské ZP",{"$f":"Slovenske_ZP_dospl","v":0},{"$f":"Slovenske_ZP_pospl","v":0},{"$f":"C20+D20","v":0}]
[null,"Pohledávky celkem",{"$f":"C18+C19+C20","v":420258859.37999994},{"$f":"D18+D19+D20","v":423249.54000000004},{"$f":"E18+E19+E20","v":420682108.9199999}]

{"sheet":"Vývojová řada nákladů-25","index":26,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vývojová řada nákladů "]
[null,null,null,null,null,{"$f":"CONCATENATE(\"v letech \",YEAR(dat_do)-2,\" - \",YEAR(dat_do))","v":"v letech 2008 - 2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-2)","v":"Ø 2008"},{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-1)","v":"Ø 2009"},{"$f":"CONCATENATE(\"I.\",RIGHT(YEAR(dat_do),2))","v":"I.10"},{"$f":"CONCATENATE(\"II.\",RIGHT(YEAR(dat_do),2))","v":"II.10"},{"$f":"CONCATENATE(\"III.\",RIGHT(YEAR(dat_do),2))","v":"III.10"},{"$f":"CONCATENATE(\"IV.\",RIGHT(YEAR(dat_do),2))","v":"IV.10"},{"$f":"CONCATENATE(\"V.\",RIGHT(YEAR(dat_do),2))","v":"V.10"},{"$f":"CONCATENATE(\"VI.\",RIGHT(YEAR(dat_do),2))","v":"VI.10"},{"$f":"CONCATENATE(\"VII.\",RIGHT(YEAR(dat_do),2))","v":"VII.10"},{"$f":"CONCATENATE(\"VIII.\",RIGHT(YEAR(dat_do),2))","v":"VIII.10"},{"$f":"CONCATENATE(\"IX.\",RIGHT(YEAR(dat_do),2))","v":"IX.10"},{"$f":"CONCATENATE(\"X.\",RIGHT(YEAR(dat_do),2))","v":"X.10"},{"$f":"CONCATENATE(\"XI.\",RIGHT(YEAR(dat_do),2))","v":"XI.10"},{"$f":"CONCATENATE(\"XII.\",RIGHT(YEAR(dat_do),2))","v":"XII.10"}]
["Léky ",58886.609380833353,68993.114580833397,78495.006140000012,71186.890699999887,80842.443619999831]
["    z toho: VLV",25811.338088333338,5945.0256641666665,5053.2768400000004,5424.5941599999996,8187.9708200000005]
["                 centra",7881.1863650000023,37807.690004999989,47050.635599999994,41008.531070000005,44071.487230000006]
["Krev",3422.3033625000025,4286.6305858333335,4347.0470800000003,3630.0563000000002,4678.1439600000003]
["SZM",48845.256045833492,57669.053428333173,63572.343459999996,77825.44716000004,86153.111780000065]
["Prodej LS",25951.585750833336,26661.976469999998,22922.720369999999,21967.742850000002,31104.056669999994]
["Os. náklady",115119.05588333332,125951.29197083003,132480.91122000004,130641.2670200002,130410.65382000015]
["Odpisy ",9957.4513783333332,22151.828583333336,22316.278999999999,23035.569,22676.62]
["Př. náklady",296000.58570250124,352482.24844916508,368454.98642999859,371761.2798099987,398939.40517999843]
[]
["*VLV = vliv lékové vyhlášky"]

{"sheet":"Vývojová řada výnosů -26","index":27,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vývojová řada výnosů"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"v letech \",YEAR(dat_do)-2,\" - \",YEAR(dat_do))","v":"v letech 2008 - 2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-2)","v":"Ø 2008"},{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-1)","v":"Ø 2009"},{"$f":"CONCATENATE(\"I.\",RIGHT(YEAR(dat_do),2))","v":"I.10"},{"$f":"CONCATENATE(\"II.\",RIGHT(YEAR(dat_do),2))","v":"II.10"},{"$f":"CONCATENATE(\"III.\",RIGHT(YEAR(dat_do),2))","v":"III.10"},{"$f":"CONCATENATE(\"IV.\",RIGHT(YEAR(dat_do),2))","v":"IV.10"},{"$f":"CONCATENATE(\"V.\",RIGHT(YEAR(dat_do),2))","v":"V.10"},{"$f":"CONCATENATE(\"VI.\",RIGHT(YEAR(dat_do),2))","v":"VI.10"},{"$f":"CONCATENATE(\"VII.\",RIGHT(YEAR(dat_do),2))","v":"VII.10"},{"$f":"CONCATENATE(\"VIII.\",RIGHT(YEAR(dat_do),2))","v":"VIII.10"},{"$f":"CONCATENATE(\"IX.\",RIGHT(YEAR(dat_do),2))","v":"IX.10"},{"$f":"CONCATENATE(\"X.\",RIGHT(YEAR(dat_do),2))","v":"X.10"},{"$f":"CONCATENATE(\"XI.\",RIGHT(YEAR(dat_do),2))","v":"XI.10"},{"$f":"CONCATENATE(\"XII.\",RIGHT(YEAR(dat_do),2))","v":"XII.10"}]
["Fakt. ZP běžný rok ",242648.21238750019,277470.68090083374,267522.90396000003,269864.32670000009,271382.38902999985]
["Dorov. ZP minul. let",2335.1782258333228,9548.6144950000089,22013.403109999992,2900.0323700000017,72110.315160000013]
["Prodej LS",28611.439774166647,29544.619079166681,25463.889859999999,24551.937130000006,34585.107300000003]
["Přímé výnosy",305094.63721083337,352687.97786083305,347097.95057999971,357810.74527000025,436744.65645000042]

{"sheet":"Vývojová řada HV - 27","index":28,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vývojová řada hospodářských výsledků"]
[null,null,null,null,null,{"$f":"CONCATENATE(\"v letech \",YEAR(dat_do)-2,\"-\",YEAR(dat_do))","v":"v letech 2008-2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"01","02","03","04","05","06","07","08","09","10","11","12"]
[{"$f":"CONCATENATE(\"HV \",YEAR(dat_do)-2)","v":"HV 2008"},-31193.583689999534,-7114.382030000037,441.1776199999149,8042.749690000026,10746.536910000374,67656.097729999863,74.627199999755248,8.9515200004098006,17608.644030000141,-11563.223969999584,-19354.016400000022,73775.03949000017]
[{"$f":"CONCATENATE(\"HV \",YEAR(dat_do)-1)","v":"HV 2009"},6492.6183300004923,18308.923580000584,-7937.4590099988854,-5773.7357599988463,46337.237870001001,41870.974000001501,51840.851900001289,41112.93109000026,-24927.695099998324,-15718.649140000285,6463.4056700018118,-155600.65048999997]
[{"$f":"CONCATENATE(\"HV \",YEAR(dat_do))","v":"HV 2010"},-21357.03584999888,-13950.534539998451,37805.251270001987]

{"sheet":"Podíl ukazatelů N a V - 28","index":29,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[31,0,31,1]]}
["Náklady a výnosy FN Olomouc v tis. Kč"]
[{"$f":"dat_obdobi","v":"1-3/2010"}]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových nákladů"]
["Náklady FN Olomouc v tis. Kč"]
["Léky ",230524]
["Krev",12655]
["SZM",227551]
["Potraviny",10398]
["Energie",37192]
["Osobní náklady",393532.83205999923]
["Odpisy",68028]
["Prodané zboží LS",75995]
["Ostatní",{"$f":"B17-SUM(B8:B15)","v":83279.839359997306}]
["Celkem",1139155.6714199965]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových výnosů"]
["Výnosy FN Olomouc v tis. Kč"]
["Provozní dotace",6700]
["Výkony pro zdr.poj.",905793.37033000006]
["Aktivace",21441.89316]
["Tržby za léčiva",84600.93428999999]
["Ostatní výnosy",{"$f":"B38-SUM(B33:B36)","v":123117.15452000126}]
["Celkem",1141653.3523000013]

{"sheet":"List1","index":30,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}