{"text_format":"1","workbook":"xlsx","n_sheets":30,"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 měsíční","LF nápočtem","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"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":0,"defined_names":659,"comments":1,"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":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                    ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[null,null,null,null,null,{"$f":"dat_obdobi","v":"1-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Období od:","2009-01-01"]
["do:","2009-12-31"]
["rok:",{"$f":"YEAR(dat_do)","v":2009}]
["Typ období:",{"$f":"CONCATENATE(MONTH(dat_od),\"-\",MONTH(dat_do),\"/\",YEAR(dat_do))","v":"1-12/2009"}]
["Měsíc:",{"$f":"dat_do","v":"2009-12-31"}]
[null,{"$f":"CONCATENATE(\"Skut. \", dat_obdobi)","v":"Skut. 1-12/2009"}]
[null,{"$f":"CONCATENATE(\"PLÁN \", dat_rok)","v":"PLÁN 2009"}]
["Předch.obd.od:",{"$f":"CONCATENATE(\"1.1.\",YEAR(dat_od)-1)","v":"1.1.2008"}]
["Předch.obd.do:",{"$f":"CONCATENATE((DAY(dat_do)),\".\",MONTH(dat_do),\".\",YEAR(dat_do)-1)","v":"31.12.2008"}]
["Předch.rok:",{"$f":"YEAR(dat_dorokpredch)","v":2008}]
["Předch.r. měs.",{"$f":"dat_do-366","v":"2008-12-30"}]
["Predch.typ obd.",{"$f":"CONCATENATE(MONTH(dat_odrokpredch),\"-\",MONTH(dat_dorokpredch),\"/\",YEAR(dat_dorokpredch))","v":"1-12/2008"}]

{"sheet":"Rozbor hospodaření FN Olomouc-1","index":1,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[12,0,12,1],[26,4,26,5],[2,0,2,7],[0,0,0,7]]}
["ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[{"$f":"dat_obdobi","v":"1-12/2009"}]
[]
[null,null,null,"Rozpočet","Skutečnost",null,"Rozdíl","Překročení"]
[null,null,null,{"$f":"YEAR(dat_do)","v":2009},{"$f":"dat_obdobi","v":"1-12/2009"}]
["Náklady bez VPN",null,null,3757414,4229786.9813899817,"tis.Kč",{"$f":"N_bez_VPN-((N_bez_VPN_Rozp/12)*MONTH(dat_do))","v":472372.98138998169},{"$f":"IF(N_bez_VPN_Rozp <> 0,G7/((N_bez_VPN_Rozp/12)*MONTH(dat_do)),\"-\")","v":0.12571757634106376}]
["Náklady celkem vč. VPN",null,null,4040621,4529003.6453000586,"tis.Kč",{"$f":"N_vc_VPN-((N_vc_VPN_Rozp/12)*MONTH(dat_do))","v":488382.64530005865}]
[]
["Výnosy bez VPV",null,null,3808028,4232255.7343299966,"tis.Kč",{"$f":"V_bez_VPV-((V_bez_VPV_Rozp/12)*MONTH(dat_do))","v":424227.73432999663},{"$f":"IF(V_bez_VPV_Rozp <> 0,G10/((V_bez_VPV_Rozp/12)*MONTH(dat_do)),\"-\")","v":0.11140352285487308}]
["Výnosy celkem vč. VPV",null,null,4091235,4531472.3982400885,"tis.Kč",{"$f":"V_vc_VPV-((V_vc_VPV_Rozp/12)*MONTH(dat_do))","v":440237.39824008849}]
[]
["Hospodářský  výsledek    = ",null,"zisk",null,{"$f":"ABS(E10-E7)","v":2468.752940014936},"tis.Kč"]
[]
["Rozbor nákladů:"]
[]
["Překročení nákladů o:"]
[]
["SZM",null,null,null,166877,"tis. Kč"]
["Léky",null,null,null,95617,"tis. Kč"]
["Všeobecný materiál",null,null,null,11601,"tis. Kč"]
["Krev",null,null,null,8940,"tis. Kč"]
["Opravy a udržování",null,null,null,7124,"tis. Kč"]
["Náhradní díly",null,null,null,6893,"tis. Kč"]
["DDHM",null,null,null,25253,"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.2009"},{"$f":"CONCATENATE(\"Stav k \",DAY(dat_do),\".\",MONTH(dat_do),\".\",YEAR(dat_do))","v":"Stav k 31.12.2009"},"Snížení / Zvýšení zásob o"]
["Léky",23300,27741,34109,{"$f":"IF(C28>D28,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D28-C28","v":6368}]
["Krev",13000,17087,16522,{"$f":"IF(C29>D29,\"snížení\",\"zvýšení\")","v":"snížení"},{"$f":"D29-C29","v":-565}]
["SZM",14700,2940,4824,"zvýšení",1884]
["Dentální slitiny","nestanoven",241,242,{"$f":"IF(C31>D31,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D31-C31","v":1}]
["Potraviny",1600,1353,1368,"zvýšení",15]
["Prádlo",2600,1565,1907,"zvýšení",342]
["Všeobecný materiál",1000,1578,1835,"zvýšení",257]
["Údržbový materiál","nestanoven",882,936,"zvýšení",54]
["DDHM","nestanoven",883,582,"snížení",-301]
["Materiál na cestě","nestanoven",479,787,"zvýšení",308]
["Zboží na skladě","nestanoven",30,21,"snížení",-9]
["Zboží na cestě","nestanoven",0,0,"zvýšení",0]
["CELKEM","nestanoven",54778,63132,"zvýšení",8354]
[]
[]
["Rozbor výnosů"]
[null,null,null,"Rozpočet","Skutečnost",null,"Rozdíl","Překročení"]
[null,null,null,{"$f":"YEAR(dat_do)","v":2009},{"$f":"dat_obdobi","v":"1-12/2009"}]
["Výnosy celkem",null,null,4091235,4531472.3982400885,"tis.Kč",{"$f":"E46-((D46/12)*MONTH(dat_do))","v":440237.39824008849},{"$f":"G46/((D46/12)*MONTH(dat_do))","v":0.10760501370370767}]
["z toho:"]
["Výkony pro zdravotní pojišťovny",null,null,3125030,3447000,"tis.Kč",{"$f":"E48-((D48/12)*MONTH(dat_do))","v":321970},{"$f":"IF(D48 <> 0,G48/((D48/12)*MONTH(dat_do)),\"-\")","v":0.10302941091765519}]
["691 vybrané činnosti MZ",null,null,3850,9205,"tis.Kč",5355,1.3909090909090909]
["691 granty",null,null,0,14986,"tis.Kč",14986,"-"]
["691 dotace na DDM",null,null,0,802,"tis.Kč",802,"-"]
["691 dotace na provoz  z ÚSC",null,null,0,0,"tis.Kč",0,"-"]
["699 vnitropodnikové výnosy",null,null,283207,299217,"tis.Kč",16010,5.6531088567726082E-2]
["604 tržby LS",null,null,337695,354535,"tis.Kč",16840,4.9867483972223459E-2]
["ostatní výnosy",null,null,{"$f":" D46 -SUM(D48:D54)","v":341453},{"$f":" E46 -SUM(E48:E54)","v":405727.39824008849},"tis.Kč",64274.398240088485,0.18823790753072453]
[]
["Komentář: vlivy do nákladů - vyšší spotřeba léků v centrech, překročení nákladů na defibr-povolené překroč.,ost.ZPr-nové prac.Robot.centrum,  "]
["                                             ","krve,nákup DDHM-lékař.nástr.onkologie, poloh.lůžka, inf.pumpy,nábytek, ",null,null,"inf.pumpy,ND na PET CT, netkaný textil, revize a techn.kontroly přístrojů"]
[null,"nábytek-výdejna léků, nájem přístr.,nákup SW-licence,výběr.říz.PACS,person.rozvoj,poradenství,spotřeba PZT-Granty,vyřazení "]
[null,"dekontaminačního zařízení-analytický modulár,parní desinfektor, změna vykazování CDL z receptů na žádanky."]
["                 vlivy do výnosů - vyúčtování zdrav.péče za r. 2008 u ZP Metal ,OZP, VoZP, HZP,ZPMV, ČNZP a RBP ve výši 145 mil.Kč,  "]
["                                                                                               ","zvýšení měs.zálohy METAL Al. na 107 %,finanční bonusy LS.Navýšení paušální úhrady od VZP 4Q(měs. 20 mil.)"]
[null,"Minusová dohadná položka-vyúčtování zdrav.péče VZP - 61,8 mil.Kč a OZP - 3,9 mil. Kč-nenaplnění stanov.limitů."]

{"sheet":"Ziskové kliniky FN Olomouc-3","index":2,"n_rows":54,"n_cols":5,"rows_kept":54,"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-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"III. Interní klinika","03",203]
[null,null,"I. Chirurgická klinika","04",3358]
[null,null,"Novorozenecké oddělení","09",6076]
[null,null,"Ortopedická klinika","11",3595]
[null,null,"Urologická klinika","12",1314]
[null,null,"Oddělení alergologie","15",326]
[null,null,"Klinika pracovního lékařství","19",460]
[null,null,"Onkologická klinika","21",22192]
[null,null,"Klinika nukleární medicíny","22",21540]
[null,null,"Klinika ústní,čelistní a obl.","25",696]
[null,null,"Ústav lékařské genetiky a fet.","28",15309]
[null,null,"Hemato-onkologická klinika","32",12928]
[null,null,"Odděl.klin.biochemie a imunoge","33",2489]
[null,null,"Radiologická klinika","34",5825]
[null,null,"Transfůzní oddělení","35",20107]
[null,null,"Oddělení klinické logopedie","36",140]
[null,null,"Ústav patologie","37",8655]
[null,null,"Ústav soudního lékařství a med","38",34]
[null,null,"Ústav mikrobiologie","40",1942]
[null,null,"Ústav imunologie","41",4615]
[null,null,"Ústav farmakologie","43",25]
[null,null,"Sociální oddělení","45",746]
[null,null,"Oddělení centrální sterilizace","56",1362]
[null,null,"Oddělení int.péče chir.oborů","59",1847]

{"sheet":"Ziskové kliniky FN Olomouc-0","index":3,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ziskové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"Novorozenecké oddělení","09",17105]
[null,null,"Onkologická klinika","21",11541]
[null,null,"Klinika nukleární medicíny","22",66077]
[null,null,"Klinika rehabilit. a tělových.","26",19689]
[null,null,"Ústav lékařské genetiky a fet.","28",26415]
[null,null,"Hemato-onkologická klinika","32",43424]
[null,null,"Odděl.klin.biochemie a imunoge","33",49883]
[null,null,"Radiologická klinika","34",28235]
[null,null,"Transfůzní oddělení","35",29321]
[null,null,"Ústav patologie","37",35209]
[null,null,"Ústav mikrobiologie","40",31915]
[null,null,"Ústav imunologie","41",22935]
[null,null,"Kardiochirurgická klinika","50",14673]
[null,null,"Oddělení int.péče chir.oborů","59",3959]

{"sheet":"Ztrátové kliniky FN Olomouc-4","index":4,"n_rows":55,"n_cols":5,"rows_kept":55,"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-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",26890]
[null,null,"II. Interní klinika","02",5245]
[null,null,"II. Chirurgická klinika","05",1047]
[null,null,"Neurochirurgická klinika","06",5981]
[null,null,"Klinika anesteziologie a resus","07",14422]
[null,null,"Porodnicko-gynekologická klini","08",1823]
[null,null,"Dětská klinika","10",8207]
[null,null,"Otolaryngologická klinika","13",3629]
[null,null,"Oční klinika","14",9906]
[null,null,"Klinika plicních nemocí a tube","16",9609]
[null,null,"Neurologická klinika","17",759]
[null,null,"Klinika psychiatrie","18",462]
[null,null,"Klinika chorob kožních a pohl.","20",2837]
[null,null,"Klinika zubního lékařství","24",2564]
[null,null,"Klinika rehabilit. a tělových.","26",3520]
[null,null,"Oddělení plastické a estetické","29",832]
[null,null,"Oddělení geriatrie","30",3950]
[null,null,"Traumatologické oddělení","31",5421]
[null,null,"Oddělení klinické psychologie","39",1030]
[null,null,"Transplantační centrum","46",8]
[null,null,"Centrální operační sály","47",6085]
[null,null,"Lékárna","48",2146]
[null,null,"Kardiochirurgická klinika","50",8047]
[null,null,"Oddělení lékařské fyziky a rad","53",324]
[null,null,"Oddělení urgentního příjmu","60",2057]

{"sheet":"Ztrátové kliniky FN Olomouc-0","index":5,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ztrátové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",11894]
[null,null,"II. Interní klinika","02",20341]
[null,null,"III. Interní klinika","03",4631]
[null,null,"I. Chirurgická klinika","04",27117]
[null,null,"II. Chirurgická klinika","05",6120]
[null,null,"Neurochirurgická klinika","06",4673]
[null,null,"Klinika anesteziologie a resus","07",8482]
[null,null,"Porodnicko-gynekologická klini","08",12340]
[null,null,"Dětská klinika","10",20800]
[null,null,"Ortopedická klinika","11",6027]
[null,null,"Urologická klinika","12",19059]
[null,null,"Otolaryngologická klinika","13",16269]
[null,null,"Oční klinika","14",6635]
[null,null,"Oddělení alergologie","15",1677]
[null,null,"Klinika plicních nemocí a tube","16",21955]
[null,null,"Neurologická klinika","17",19269]
[null,null,"Klinika psychiatrie","18",2426]
[null,null,"Klinika pracovního lékařství","19",2257]
[null,null,"Klinika chorob kožních a pohl.","20",5190]
[null,null,"Klinika zubního lékařství","24",10287]
[null,null,"Klinika ústní,čelistní a obl.","25",3866]
[null,null,"Oddělení plastické a estetické","29",6820]
[null,null,"Oddělení geriatrie","30",14688]
[null,null,"Traumatologické oddělení","31",21483]
[null,null,"Oddělení klinické logopedie","36",626]
[null,null,"Ústav soudního lékařství a med","38",5274]
[null,null,"Oddělení klinické psychologie","39",679]
[null,null,"Ústav farmakologie","43",1422]
[null,null,"Sociální oddělení","45",1866]
[null,null,"Transplantační centrum","46",8]
[null,null,"Centrální operační sály","47",49722]
[null,null,"Lékárna","48",2438]
[null,null,"Oddělení lékařské fyziky a rad","53",5352]
[null,null,"Oddělení centrální sterilizace","56",21784]
[null,null,"Oddělení urgentního příjmu","60",34017]

{"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  2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poč.stav","leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Zásoby celkem",54778,61574,59058,60124,61299,61617,64108,60222,58241,66200,66301,75035,63132]
["Léky ",27741,31181,29761,32484,31602,33401,33397,34038,30476,36496,39545,45749,34109]
["z toho RTG diagn.",13,24,28,58,845,74,59,18,382,85,306,213,313]
["Krev",17087,18769,18166,16067,16799,15927,15508,14674,16152,16245,15610,13293,16522]
["SZM",2940,4368,4545,4962,4643,4424,4969,3814,4682,6010,4373,6566,4824]
["z toho lab. diagn.*"]
["Mater.na cestě",479,587,48,277,642,726,746,677,256,1211,746,1647,787]
[]
["* 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  2009"}]
[]
[null,null,null,null,"(v tis.Kč)"]
[]
["Položka",{"$f":"PLAN_rok","v":"PLÁN 2009"},"Poměr pl.",{"$f":"Skut_typobd","v":"Skut. 1-12/2009"},"SK/PL v %"]
["501 10 Biologické implantáty",6200,{"$f":"B6/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":6200},4230.3059999999996,{"$f":"IF(B6<>0,D6/B6*100,0)","v":68.230741935483863}]
["501 12 PHM",2250,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":2250},2110.58923,93.803965777777776]
["501 13 Léky",732300,732300,827917.37497,113.05713163594156]
["501 14 Krev",42500,42500,51439.567029999991,121.03427536470586]
["501 15 SZM",525152,525152,692028.64114000008,131.77682673587839]
["501 16 Potraviny",38536,38536,37766.674550000003,98.003618823956828]
["501 17 Všeobecný materiál",28365,28365,39966.363250000002,140.90027586814736]
["501 18 Náhradní díly",11214,11214,18106.920149999998,161.46709604066345]
["501 19 DHM a textil",19800,19800,45053.596799999999,227.54341818181817]
["501 60 Knihy a časopisy",300,300,982.38522999999998,327.46174333333335]
["501 80 Spotř.nák.-z darů, kl.stud.",4000,4000,5352.7134399999995,133.817836]
["502      Spotřeba energie",108500,108500,105085.37521000001,96.852880377880197]
["504 01 Prodané zboží",3500,3500,3211.2453699999996,91.749867714285699]
["504 95 Prodané LS",303740,303740,319943.71763999999,105.33473287680253]
["501 99 Opravy nákl. min. let",0,0,9.014899999999999,0]
["Spotřebované nákupy",{"$f":"SUM(B6:B20)","v":1826357},1826357,{"$f":"SUM(D6:D20)","v":2153204.4849099996},117.89614434144036]
["511      Opravy a udržování",41650,41650,48774.453229999999,117.1055299639856]
["512      Cestovné",2300,2300,3479.3150900000001,151.27456913043477]
["513      Náklady na reprezentaci",200,200,153.24921000000001,76.624605000000003]
["518 01 Přepravné",400,400,512.45483999999999,128.11371]
["518 02 Spoje",5650,5650,5415.3317100000004,95.846578938053113]
["518 04 Nájemné",6560,6560,9996.9874499999987,152.39310137195119]
["518      Ostatní služby",116920,116920,129585.25016999998,110.83240691926102]
["521      Osobní náklady",1043500,1043500,1113895.92652,106.74613574700527]
["524      Zákonné sociální pojištění",354790,354790,368469.08600000001,103.85554440655037]
["525      Ostatní sociální pojištění",4368,4368,5763.4523200000003,131.94716849816851]
["527      Zákon. soc. poj. (FKSP)",20800,20800,22108.729810000001,106.29197024038461]
["528      Náhrady-prac.nesch.",0,0,1178.309,0]
["53        Daně a poplatky",622,622,435.36900000000003,69.995016077170419]
["54        Ostatní náklady",8743,8743,35928.658360000009,410.94199199359497]
["551      Odpisy ",286500,286500,265821.94300000003,92.782528097731259]
["552      ZC prod. IM ",0,0,0,0]
["554      Prodaný mat. vč. krve",25400,25400,40788.830770000008,160.58594791338584]
["556     Tvorba zák. rezerv",0,0,0,0]
["59      Daň z příjmů",12654,12654,24275.15,191.83775881144302]
["Přímé náklady celkem",{"$f":"SUM(B21:B40)","v":3757414},{"$f":"SUM(C21:C40)","v":3757414},{"$f":"SUM(D21:D40)","v":4229786.9813900003},112.57175763410687]

{"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-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Náklady FN Olomouc v tis. Kč"]
[null,null,"Léky ",827917]
[null,null,"Krev",51440]
[null,null,"SZM",692029]
[null,null,"Potraviny",37767]
[null,null,"Energie",105085]
[null,null,"Osobní náklady",1511416]
[null,null,"Odpisy",265822]
[null,null,"Prodané zboží LS",319944]
[null,null,"Ostatní",{"$f":"D34-SUM(D25:D32)","v":418367}]
[null,null,"Celkem",4229787]
[]
[]
["        Podíl ukazatelů z celkových nákladů"]
[{"$f":"dat_obdobi","v":"1-12/2009"}]

{"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  2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Název ","rozpočet","leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Léky",61025,64135,65027,68696,80236,63021,63793,67748,61456,70615,82050,71107,70034]
["Krev",3542,2539,3003,3156,7300,3970,4447,3900,4107,4749,5573,4605,4092]
["SZM",43763,47974,44363,56102,49512,48502,53931,43608,51800,57168,67063,84558,87448]

{"sheet":"Přehled o výnosech roku-9","index":10,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"CONCATENATE(\"Přehled o výnosech roku  \",dat_rok)","v":"Přehled o výnosech roku  2009"}]
[]
[null,null,null,null,"(v tis. Kč)"]
[]
["Položka",{"$f":"PLAN_rok","v":"PLÁN 2009"},"Poměr pl.",{"$f":"Skut_typobd","v":"Skut. 1-12/2009"},"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.",60550,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":60550},60255.663500000061,99.513895127993493]
["602 27 Zdr.sl. - výkony ředění cytostatik",0,0,2768.71603,0]
["602 28, 29 Zdrav.  výk. - běžný rok",53114,53114,256058.24311999982,482.09180841209439]
["602 40,42,43,46 Zdrav.vyk.-min.let",0,0,114583.37394000011,0]
["602 45 Fakturace ZP - běžný rok",3071916,3071916,3073589.9276900021,100.05449132365605]
["602 Ostatní služby",900,900,1348.5749500000002,149.84166111111114]
["604 Prodej zboží",4370,4370,4084.0928599999997,93.457502517162467]
["604 Prodané léky a léčiva",337695,337695,354535.42895000003,104.98687542012763]
["62   Aktivace - krev a KV",69400,69400,85849.873689999993,123.70298802593661]
["648 01,02,03 Použití RF",2000,2000,2818.4072900000001,140.92036450000001]
["648 04 Použití FRM",41650,41650,-3.7252902984619141E-12,-8.9442744260790249E-15]
["649 11,13,14,25 Tržby z nájem.",28950,28950,33157.970900000029,114.53530535405882]
["64   Ostatní výnosy",108113,108113,153018.57520000008,141.53577756606521]
["65   Tržby z prodeje materiálu a majetku",25520,25520,45979.79623,180.17161532131664]
["691 Provozní dotace ",3850,3850,44207.089979999997,1148.2361033766233]
["Přímé výnosy celkem",{"$f":"SUM(B6:B21)","v":3808028},{"$f":"SUM(C6:C21)","v":3808028},{"$f":"SUM(D6:D21)","v":4232255.7343300022},111.14035228548747]

{"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-12/2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Výnosy FN Olomouc v tis. Kč"]
[null,null,"Provozní dotace",44207.089979999997]
[null,null,"Výkony pro zdr.poj.","!DEFINICE!"]
[null,null,"Aktivace",85849.873689999993]
[null,null,"Tržby za léčiva",354535.42895000003]
[null,null,"Ostatní výnosy",{"$f":"D29-SUM(D23:D27)","v":3747663.3417100003}]
[null,null,"Celkem",4232255.7343300004]
[]
[]
[]
[]
["      Podíl ukazatelů z celkových výnosů"]
[{"$f":"dat_obdobi","v":"1-12/2009"}]

{"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  2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["př. náklady",323329,301656,333821,334925,323913,327130,340500,322292,368941,382151,396024,475105]
["př. výnosy",329821,319964,325884,329152,370250,369001,392340,363405,344014,366433,402488,319504]
["os. náklady",115434,110977,114264,115428,121392,119582,133481,125690,145347,130716,141312,137792]

{"sheet":"Srovnání nákladů a výnosů mě-12","index":13,"n_rows":48,"n_cols":6,"rows_kept":48,"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  2009"}]
[{"$f":"CONCATENATE(\"                                 se stejným obdobím roku  \",dat_rok-1)","v":"                                 se stejným obdobím roku  2008"}]
[]
[]
[]
["Položka",{"$f":"mesic_rokpredchoz","v":"2008-12-30"},"%",{"$f":"mesic_rok","v":"2009-12-31"},"%","Rozdíl"]
["Léky",56193,{"$f":"B7/B$19*100","v":26.659297283449252},70034,{"$f":"D7/D$19*100","v":13.473422742962615},{"$f":"D7-B7","v":13841}]
["Krev",3009,1.4275412511504777,4092,0.78723542656713907,{"$f":"D8-B8","v":1083}]
["SZM",56825,26.959133132810205,87448,16.823598138426977,30623]
["Potraviny",2744,1.3018189408962815,2965,0.57041863142022664,221]
["Všeobecný materiál",3498,1.6595344953553908,6707,1.2903196495566478,3209]
["Spotřeba energie",12382,5.8743156436507862,12627,2.4292330721562236,245]
["Opravy a udržování",6899,3.2730498809196233,12571,2.4184595668073086,5672]
["Osobní náklady",116464,55.253294873376277,137792.26102000021,26.509029663179483,21328.261020000209]
["Odpisy",-123755,-58.71231888870966,22799,4.3861633651769809,146554]
["Vnitropodnik. náklady",12331,5.8501200292245068,44689,8.5974496524581827,32358]
["Ostatní náklady",{"$f":"B19- SUM(B7:B16) - B18","v":64192},30.45421335787686,{"$f":"D19- SUM(D7:D16) - D18","v":118069.41973999731},22.714670091288216,53877.419739997305]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",210782,100,519793.68075999751,100,309011.68075999751]
["Tržby za vl. výrobky",0,{"$f":"B20/B$36*100","v":0},0,{"$f":"D20/D$36*100","v":0},0]
["Zdr. služby za úhradu",5027.4257499999985,1.7667552546589957,5468.5138500000003,1.5015407225988235,441.08810000000176]
["Tržby z nájemného",4275.1133500000005,1.5023750426100924,3200.7939699999993,0.87887177804327143,-1074.3193800000013]
["Výkony ředění cytostatik",0,0,-100,-2.7457930322309112E-2,-100]
["Zdrav. výk. - běžný rok",32807.166059999989,11.529207174660961,34148.62938000002,9.3765068611839837,1341.4633200000317]
["Zdrav. výk. - min. let",-52651,-18.50279557347034,-66878.102469999998,-18.363342777095092,-14227.102469999998]
["Fakturace ZP - běžný rok",238457.65265999988,83.799608746226554,302843.24465000001,83.154487101817125,64385.591990000132]
["Ostatní služby",98.5518,3.4633412637889778E-2,103.35239999999999,2.8378429978434202E-2,4.8005999999999887]
["Tržby za prodané léky",32478,11.413530505311765,33495,9.1970337614574369,1017]
["Ost. tržby za prodané zboží",263,9.2424364889986885E-2,301,8.2648370270150429E-2,38]
["Aktivace - krev a KV",5774,2.0291189462919554,7164,1.9670861282902248,1390]
["Tržby z prodeje materiálu a majetku",22600,7.9421697586072382,1415,0.38852971406067394,-21185]
["Provozní dotace od zřizovatele",113,3.9710848793036192E-2,13194,3.6227993267254641,13081]
["Vnitropodnik. výnosy",12331,4.3334024466099939,44689,12.270674481736719,32358]
["Použití rezervního fondu",463,0.16270905301925448,568,0.15596104423071577,105]
["Ostatní výnosy ",{"$f":"B36 - SUM(B20:B34)","v":-17479.909619999817},-6.142849980847358,-15418.92256000001,-4.2337170129756032,2060.9870599998067]
["Výnosy celkem",284557,100,{"$f":"SUM(D20:D35)","v":364193.50921999995},100,79636.509219999949]
["Hospodářský výsledek",{"$f":"B36-B19","v":73775},null,{"$f":"D36-D19","v":-155600.17153999757},null,-229375.17153999757]
["Průměrný počet lůžek",1406,null,1393,null,-13]
["Počet oš. dnů",31775,null,32306,null,531]
["Prům. nákl. na lůžkoden (hospit.)",2488.7732799370606,null,3462.1563251408488,null,973.38304520378824]
["Prům. náklady na oš. den FNO",5309.2028374508327,null,13753.543333436521,null,8444.3404959856889]
[]
[]
["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":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["                        Srovnání nákladů a výnosů v roce",null,null,{"$f":"dat_rok","v":2009}]
["                               se stejným obdobím roku",null,{"$f":"dat_rok-1","v":2008}]
[]
[]
[]
["Položka",{"$f":"dat_obdobirokpredch","v":"1-12/2008"},"%",{"$f":"dat_obdobi","v":"1-12/2009"},"%","Rozdíl"]
["Léky",706639,{"$f":"B7/B$19*100","v":19.317658990785937},827917,{"$f":"D7/D$19*100","v":18.280334149414188},{"$f":"D7-B7","v":121278}]
["Krev",41068,1.1226915291026915,51440,1.1357906512921776,{"$f":"D8-B8","v":10372}]
["SZM",586143,16.023614028996761,692029,15.279939125642969,105886]
["Potraviny",37835,1.0343097789909499,37767,0.8338920203606468,-68]
["Všeobecný materiál",30730,0.84007769283446254,39966,0.88244574590869307,9236]
["Spotřeba energie",101888,2.7853509914584356,105085,2.3202675076018369,3197]
["Opravy a udržování",46497,1.2711061660827858,48774,1.0769256070397486,2277]
["Osobní náklady",1381429,37.764649760319521,1511415.5036499605,33.371920669978287,129986.5036499605]
["Odpisy",119489,3.2665162199510931,265822,5.8693262540394482,146333]
["Vnitropodnik. náklady",105988,2.897434250183502,299217,6.6066849010048889,193229]
["Ostatní náklady",{"$f":"B19 - SUM(B7:B16) - B18","v":500271},13.676098518450679,{"$f":"D19 - SUM(D7:D16) - D18","v":649562.14165009838},14.342274648512966,149291.14165009838]
["Opravy nákladů min. let",18,4.9207284318321929E-4,9,1.9871920415298597E-4,-9]
["Náklady celkem",3657995,100,4529003.6453000586,{"$f":"SUM(E7:E17)","v":99.999801280795836},871008.64530005865]
["Tržby za vl. výrobky",0,{"$f":"B20/B$36*100","v":0},0,{"$f":"D20/D$19*100","v":0},0]
["Zdr. služby za úhradu",61051.914929999919,1.6206505262369892,60255.663500000061,1.3304397218255708,-796.25142999985837]
["Tržby z nájemného",30552.966319999985,0.81104222531565151,33157.970900000029,0.73212506539731925,2605.0045800000444]
["Výkony ředění cytostatik",0,0,2769,6.1139275144402018E-2,2769]
["Zdrav. výk. - běžný rok",265714.74874999991,7.0535174512439704,256058.24311999982,5.6537433655131286,-9656.505630000087]
["Zdrav. výk. - min. let",28022.138709999876,0.74386026873550959,114583.37394000011,2.5299907642800901,86561.235230000224]
["Fakturace ZP - běžný rok",2646063.7999000065,70.240953042692695,3073589.9276900021,67.864593813687875,427526.12778999563]
["Ostatní služby",967.97286000000008,2.5695274697620785E-2,1348.5749500000002,{"$f":"D27/D$36*100","v":2.976019386194334E-2},380.60209000000009]
["Tržby za prodané léky",343337,9.1140350038915621,354535,7.823836807026618,11198]
["Ost. tržby za prodané zboží",4223,0.11210143334809261,4084,9.0125233107864411E-2,-139]
["Aktivace - krev a KV",74213,1.9700174456694284,85850,1.8945277331807442,11637]
["Tržby z prodeje materiálu a majetku",80973,2.1494646844648595,45980,1.0146812483593548,-34993]
["Provozní dotace od zřizovatele",19398,0.51492862990440447,44207,0.97555489226233161,24809]
["Vnitropodnik. výnosy",105988,2.8134991043565329,299217,6.6030856696463918,193229]
["Použití rezerv. Fondu",2427,6.4425805999483957E-2,2818,6.2187293559736019E-2,391]
["Ostatní výnosy ",{"$f":"B36 - SUM(B20:B34)","v":104191.45852999389},2.7658091034432073,153018.57519999999,3.3767959744694611,48827.1166700061]
["Výnosy celkem",3767124,100,{"$f":"SUM(D20:D35)","v":4531472.3293000022},100,764348.32930000219]
["Hospodářský výsledek",{"$f":"B36-B19","v":109129},null,{"$f":"D36-D19","v":2468.683999943547},null,-106660.31600005645]
["Průměrný počet lůžek",1412.5,null,1395,null,-17.5]
["Počet oš. dnů",366378,null,356156,null,-10222]
["Prům. nákl. na lůžkoden (hospit.)",2721.0797414419067,null,3033.9942847515795,null,312.91454330967281]
["Prům. náklady na oš. den FNO",8835.9010179923953,null,10968.878857522954,null,2132.9778395305584]
[]
[]
["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 2006 - 2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"dat_rok-3","v":2006},{"$f":"dat_rok-2","v":2007},{"$f":"dat_rok-1","v":2008},{"$f":"dat_rok","v":2009}]
[null,null,null,null,null,"leden",255684,281893,314446,323329]
[null,null,null,null,null,"únor",262571,256650,291124,301656]
[null,null,null,null,null,"březen",257767,290042,307756,333821]
[null,null,null,null,null,"duben",249745,272114,310025,334925]
[null,null,null,null,null,"květen",271526,281236,299979,323913]
[null,null,null,null,null,"červen",239574,308643,241350,327130]
[null,null,null,null,null,"červenec",262393,288462,323227,340500]
[null,null,null,null,null,"srpen",258188,282016,295521,322292]
[null,null,null,null,null,"září",257499,268948,314214,368941]
[null,null,null,null,null,"říjen",266105,304485,325578,382151]
[null,null,null,null,null,"listopad",282890,317797,330337,396024]
[null,null,null,null,null,"prosinec",245341,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 2009"}]
[]
[]
[]
[]
[]
["Počet ošetř. dnů",32306,null,{"$f":"mesic_rok","v":"2009-12-31"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",16179.75181999999,{"$f":"B10*1000/B8","v":500.8280758992135},{"$f":"C10/C17*100","v":14.465784582353889}]
["Krev a KV",3508.4070000000002,{"$f":"B11*1000/B8","v":108.59923853154213},{"$f":"C11/C17*100","v":3.1367514442642719}]
["SZM",4685.3237200000003,{"$f":"B12*1000/B8","v":145.02952145112366},{"$f":"C12/C17*100","v":4.1889940208064953}]
["Potraviny",1270.7449499999996,{"$f":"B13*1000/B8","v":39.334642171732789},{"$f":"C13/C17*100","v":1.1361313146405272}]
["Prádlo",331.54762000000005,{"$f":"B14*1000/B8","v":10.262725809447163},{"$f":"C14/C17*100","v":0.29642583539406409}]
["Mzdy",48398.075880000004,{"$f":"B15*1000/B8","v":1498.1141546461959},{"$f":"C15/C17*100","v":43.271129722464316}]
["Ost.nákl. v lůžkové č.",37474.571249999957,{"$f":"B16*1000/B8","v":1159.9879666315842},{"$f":"C16/C17*100","v":33.504783080076436}]
["Náklady celkem",{"$f":"SUM(B10:B16)","v":111848.42223999996},{"$f":"SUM(C10:C16)","v":3462.1563251408393},{"$f":"SUM(D10:D16)","v":100}]
[]
[]
[]
[]
["Počet ošetř. dnů",356156,null,{"$f":"dat_obdobi","v":"1-12/2009"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",172829.79041999992,{"$f":"B24*1000/B22","v":485.26429547726258},{"$f":"C24/C31*100","v":15.994238944882792}]
["Krev a KV",45592.611480000007,{"$f":"B25*1000/B22","v":128.01303776996599},{"$f":"C25/C31*100","v":4.2192906695091432}]
["SZM",47248.53357,{"$f":"B26*1000/B22","v":132.66246692460606},{"$f":"C26/C31*100","v":4.3725351623550051}]
["Potraviny",17429.36289,{"$f":"B27*1000/B22","v":48.937440026280619},{"$f":"C27/C31*100","v":1.6129707386804397}]
["Prádlo",3196.94301,{"$f":"B28*1000/B22","v":8.9762435842720603},{"$f":"C28/C31*100","v":0.29585565237829348}]
["Mzdy",541609.84976000013,{"$f":"B29*1000/B22","v":1520.7096041060661},{"$f":"C29/C31*100","v":50.122362186010427}]
["Ost.nákl. v lůžkové č.",252668.17734999978,{"$f":"B30*1000/B22","v":709.43119686317175},{"$f":"C30/C31*100","v":23.382746646183893}]
["Náklady celkem",{"$f":"SUM(B24:B30)","v":1080575.2684799999},{"$f":"SUM(C24:C30)","v":3033.9942847516254},{"$f":"SUM(D24:D30)","v":99.999999999999986}]

{"sheet":"LF měsíční","index":17,"n_rows":39,"n_cols":32,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Fakultní nemocnice Olomouc                                                                  Prosinec 2009",null,null,null,null,null,"                    P R O S I N E C   2 0 0 9"]
[]
["LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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|  267|    7|  272|   22|    7|  48|  1645|  308|  1475 | 23,4| 89,7|  5,1|  288"]
["2.IK     |  62|  178|   12|  168|   15|   12|  45|  1922|    0|  1382 | 22,3| 71,9|  7,2|  193"]
["3.IK     |  70|  153|   16|  187|   16|    8|  46|  1684|  486|  1418 | 20,3| 84,2|  7,5|  190"]
["GER      |  90|    6|   36|   64|    6|    6|  35|  1300| 1490|  1100 | 12,2| 84,6| 18,6|   59"]
["PLIC     |  61|  112|   17|  151|   13|    6|  31|  1435|  456|   972 | 15,9| 67,7|  6,5|  150"]
["NEUR     |  72|  120|    2|  123|   17|    3|  41|  1722|  510|  1267 | 17,6| 73,6|  9,6|  133"]
["PSY      |  90|   30|    2|   42|    0|    0|  17|  1026| 1764|   542 |  6,0| 52,8| 14,6|   37"]
["DK       | 100|  409|    3|  436|    1|    1|  63|  3100|    0|  1948 | 19,5| 62,8|  4,6|  425"]
["PORGYN   |  87|  321|    3|  329|    5|    0|  56|  2238|  459|  1749 | 20,1| 78,2|  5,3|  329"]
["NOVO     |  50|  194|    1|  179|    1|    4|  45|  1550|    0|  1409 | 28,2| 90,9|  7,4|  190"]
["1CHIR    |  86|  139|   43|  199|   39|    4|  50|  1928|  738|  1559 | 18,1| 80,9|  7,4|  212"]
["2CHIR    |  33|   81|    4|  106|    5|    1|  20|  1023|    0|   612 | 18,5| 59,8|  6,2|   99"]
["NCHIR    |  44|  100|    7|  123|    4|    1|  27|  1208|  156|   826 | 18,8| 68,4|  7,0|  118"]
["PCHIR    |  18|   60|    0|   72|    0|    0|   8|   396|  162|   250 | 13,9| 63,1|  3,8|   66"]
["KCHIR    |  41|   28|   16|   62|    0|    6|  20|  1062|  209|   627 | 15,3| 59,0| 11,2|   56"]
["TRAUM    |  33|  124|    7|  131|   17|    0|  19|  1023|    0|   583 | 17,7| 57,0|  4,2|  140"]
["KAR      |  10|   16|   27|    8|   23|   12|   7|   240|   70|   209 | 20,9| 87,1|  4,9|   43"]
["ORT      |  72|  141|    3|  175|   12|    0|  29|  1231| 1001|   913 | 12,7| 74,2|  5,5|  166"]
["URO      |  32|   63|   21|   86|   20|    1|  16|   593|  399|   482 | 15,1| 81,3|  5,0|   96"]
["ORL      |  40|   94|    1|  123|    2|    0|  17|   792|  448|   515 | 12,9| 65,0|  4,7|  110"]
["OCNI     |  26|   53|    0|   70|    0|    0|  12|   806|    0|   366 | 14,1| 45,4|  6,0|   62"]
["KOZNI    |  26|   47|    1|   57|    2|    0|  16|   533|  273|   485 | 18,7| 91,0|  9,1|   54"]
["ONK      |  64|  164|    1|  200|    5|    2|  30|  1375|  609|   916 | 14,3| 66,6|  4,9|  186"]
["HOK      |  34|   58|    3|   67|    6|    0|  21|  1054|    0|   641 | 18,9| 60,8|  9,6|   67"]
["REH      |  28|    3|   10|   37|    3|    0|  14|   504|  364|   421 | 15,0| 83,5| 15,9|   27"]
["KNM      |  10|   16|    0|   24|    0|    0|   4|   150|  160|   124 | 12,4| 82,7|  6,2|   20"]
["PRAC     |  18|   25|    0|   39|    0|    0|   8|   324|  234|   249 | 13,8| 76,9|  7,8|   32"]
["IPCHO    |  13|    7|   57|    0|   64|    2|   6|   241|  162|   185 | 14,2| 76,8|  2,8|   65"]
["UCOCH    |  20|   62|    3|   66|    5|    0|  11|   620|    0|   346 | 17,3| 55,8|  5,1|   68                                                                                                          "]
["=============================================================================================="]
["Celkem   |1393| 3071|  303| 3596|  303|   76| 760| 32725|10458| 23571 | 16,9| 72,0|  7,0| 3372"]

{"sheet":"LF nápočtem","index":18,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS",null,null,null,null,null,null,null,null,"leden prosinec 2009"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "]
["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| 3124|  110| 2817|  351|   66|  51| 22658|  337| 18450 |292,9| 81,4|  5,7| 3234| 1,3| 52,1|"]
["2.IK     |  62| 2281|  140| 1941|  363|  104|  47| 21944|  686| 17214 |277,6| 78,4|  7,1| 2415| 2,0| 40,2|"]
["3.IK     |  70| 2210|  165| 1938|  379|   68|  49| 22206| 3344| 17838 |254,8| 80,3|  7,5| 2380| 1,8| 39,1|"]
["GER      |  90|  110|  744|  709|   64|   77|  48| 18608|14242| 17405 |193,4| 93,5| 20,4|  852| 1,4| 16,7|"]
["PLIC     |  63| 1722|  164| 1662|  139|   76|  39| 18155| 4857| 14296 |226,9| 78,7|  7,6| 1882| 2,1| 37,8|"]
["NEUR     |  72| 2051|   75| 1815|  257|   42|  54| 24198| 2082| 19852 |275,7| 82,0|  9,4| 2120| 2,1| 32,0|"]
["PSY      |  90|  856|   66|  900|   22|    3|  47| 21884|10966| 17230 |191,4| 78,7| 18,7|  924| 5,0| 15,4|"]
["DK       | 100| 5928|   26| 5936|   12|    4|  71| 36026|  474| 25754 |257,5| 71,5|  4,3| 5953| 1,7| 60,3|"]
["PORGYN   |  87| 3993|   34| 3977|   45|    3|  61| 27538| 4217| 22336 |256,7| 81,1|  5,5| 4026| 1,3| 53,4|"]
["NOVO     |  50| 2436|   10| 2403|    8|   20|  46| 18250|    0| 16891 |337,8| 92,6|  6,9| 2439| 0,6| 48,8|"]
["1CHIR    |  86| 2405|  735| 2433|  674|   32|  62| 28004| 3386| 22468 |261,3| 80,2|  7,2| 3140| 1,8| 40,9|"]
["2CHIR    |  33| 1411|   96| 1364|  128|   13|  29| 11921|  124| 10432 |316,1| 87,5|  6,9| 1506| 1,0| 46,1|"]
["NCHIR    |  44| 1332|   68| 1293|   81|   24|  29| 15006| 1054| 10421 |236,8| 69,4|  7,4| 1399| 3,3| 34,0|"]
["PCHIR    |  18|  826|   34|  831|   29|    0|  11|  6048|  522|  4192 |232,9| 69,3|  4,9|  860| 2,2| 51,9|"]
["KCHIR    |  41|  509|  229|  683|   29|   28|  25| 14247|  718|  9067 |221,1| 63,6| 12,3|  739| 7,0| 18,9|"]
["TRAUM    |  33| 1911|   70| 1777|  200|    7|  21| 12029|   16|  7703 |233,4| 64,0|  3,9| 1983| 2,2| 60,2|"]
["KAR      |  10|  215|  293|  120|  263|  123|   7|  3460|  190|  2711 |271,1| 78,4|  5,3|  507| 1,5| 53,5|"]
["ORT      |  72| 2387|   73| 2290|  170|    1|  37| 17107| 9173| 13533 |188,0| 79,1|  5,5| 2461| 1,5| 52,5|"]
["URO      |  32| 1573|  440| 1578|  426|    9|  24| 11167|  513|  8730 |272,8| 78,2|  4,3| 2013| 1,2| 65,8|"]
["ORL      |  40| 1823|  100| 1831|   96|    1|  24| 12237| 2363|  8689 |217,2| 71,0|  4,5| 1926| 1,8| 57,4|"]
["OCNI     |  26|  836|   14|  843|   10|    0|  13|  9258|  232|  4818 |185,3| 52,0|  5,7|  852| 5,2| 33,6|"]
["KOZNI    |  26|  705|   19|  686|   33|    0|  19|  8737|  753|  7061 |271,6| 80,8|  9,8|  722| 2,3| 30,1|"]
["ONK      |  64| 2668|   31| 2584|   30|   85|  49| 22393|  967| 17885 |279,5| 79,9|  6,6| 2699| 1,7| 44,0|"]
["HOK      |  34|  950|   27|  925|   33|   19|  28| 12286|  124| 10346 |304,3| 84,2| 10,6|  977| 2,0| 29,0|"]
["REH      |  28|  276|  158|  408|   26|    0|  22|  9296|  924|  7906 |282,4| 85,0| 18,2|  434| 3,2| 17,0|"]
["KNM      |  10|  322|    8|  328|    2|    0|   6|  3160|  490|  2238 |223,8| 70,8|  6,8|  330| 2,8| 38,1|"]
["PRAC     |  18|  519|    1|  516|    4|    0|  12|  5544| 1026|  4447 |247,1| 80,2|  8,6|  520| 2,1| 34,2|"]
["IPCHO    |  13|   90| 1133|   17| 1187|   20|   9|  4273|  472|  3232 |248,6| 75,6|  2,6| 1224| 0,9|104,5|"]
["UCOCH    |  20|  822|   43|  819|   45|    1|  12|  7020|  280|  4276 |213,8| 60,9|  4,9|  865| 3,2| 45,0|                                                                                                         "]
["=========================================================================================================="]
["Celkem   |1395|46291| 5106|45424| 5106|  826| 952|444660|64532|347421 |249,0| 78,1|  7,5|46271| 2,1| 38,0|"]

{"sheet":"Rozbor investic-FRIM-18","index":19,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["                             Rozbor investic - FRM k",null,"2009-12-31"]
[]
[]
["Plán odpisů roku",{"$f":"dat_rok","v":2009},286500000]
["               Alikvotní část odpisů",null,286500000]
["               Skutečně zúčtované odpisy",null,254839351]
["               Limit vlastních zdrojů pro nákup inv.2009",null,328491285]
[]
[]
["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":328491285},{"$f":"C15-(B16+B17+B18+B19+B20)","v":144378658.66999999}]
["stavby",42824192.969999999]
["projekty",11306083]
["Přístrojová technika",124489252.27]
["technické zhodnocení",5493098.0899999999]
["oprava a udržování",0]
["DARY",null,1444410.8,{"$f":"C21-(B22+B23+B24)","v":0}]
["stavby",76626.8]
["technické zhodnocení",58543]
["Přístrojová technika",1309241]
["OSTATNÍ DOTACE",null,1446837,{"$f":"C25-(B28+B29)","v":0}]
["stavby"]
["technické zhodnocení"]
["Přístrojová technika",844837]
["IGA-spoluřešitel",602000]
["SYSTÉM.DOTACE 916",null,201669000,{"$f":"C30-(B31+B32+B33)","v":75}]
["stavby",0]
["projekty",0]
["Přístrojová technika",201668925]
["SYSTÉM.DOTACE 916 IOP",null,164835000,{"$f":"C34-(B35+B36+B37)","v":11793.520000010729}]
["stavby",0]
["projekty",0]
["Přístrojová technika",164823206.47999999]
["PROJEKTY IGA - 924",null,3197000,{"$f":"C38-(B39+B40+B41)","v":75936.399999999907}]
["stavby"]
["projekty"]
["Přístrojová technika",3121063.6]
["C E L K E M ",{"$f":"SUM(B15:B37)","v":553496005.61000001},{"$f":"SUM(C15:C37)","v":697886532.79999995},{"$f":"SUM(D15:D37)","v":144390527.19}]
[]
["Z toho:"]
["čerpání z odpisů",{"$f":"SUM(B16:B20)","v":184112626.33000001},{"$f":"SUM(C15)","v":328491285},{"$f":"SUM(D15)","v":144378658.66999999}]
["čerpání z dotací",{"$f":"SUM(B22:B41)","v":372504442.88},{"$f":"SUM(C21:C38)","v":372592247.80000001},{"$f":"SUM(D21:D41)","v":87804.920000010636}]

{"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,"2009-12-31"]
[]
[]
["Zůstatek na BÚ  (bez FKSP) ",null,250902,"tis. Kč"]
["čerpání KTK",null,0,"tis. Kč"]
[]
["Potřeba finančních prostředků na mzdy za měsíc ",null,null,"2009-12-01"]
["celkem",null,136028,"tis. Kč"]
[]
[]
["1. Stav závazků vůči dodavatelům k ",null,"2009-12-31"]
[]
["Závazky","LS","FN","Celkem"]
["do splatnosti",448322876.63999999,89915263.920000002,{"$f":"SUM(B16:C16)","v":538238140.55999994}]
["po splat. do 30 dnů",-1702286.35,42365296.380000003,40663010.030000001]
["31 - 90 dnů",-7756601.79,7477060.7699999996,-279541.02000000048]
["91 - 180 dnů",0,413402.32,413402.32]
["181 - 360 dnů",0,83367.72,83367.72]
["nad 360 dnů",0,372029.46,372029.46]
["C e l k e m ",{"$f":"SUM(B16:B21)","v":438863988.49999994},{"$f":"SUM(C16:C21)","v":140626420.57000002},{"$f":"SUM(D16:D21)","v":579490409.07000005}]
[]
[]
[]
[]
["Pohledávky"]
[]
["FN - pouze ve vztahu k odběratel.  (úč. 311+324+970)",null,null,440470,"tis. Kč"]
["LS - pouze ve vztahu k odběratelům",null,null,34958,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D29:D30)","v":475428},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,17362,"tis. Kč"]
[]
[]
["Závazky"]
[]
["FN - pouze ve vztahu k dodavatel. (úč.321+314+970)",null,null,140626,"tis. Kč"]
["LS - pouze ve vztahu k dodavatelům",null,null,438864,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D38:D39)","v":579490},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,41252,"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.12.2009"]
[]
[]
["Kód","Název zdravotní pojišťovny (ZP)","do splatnosti","po splatnosti","Celkem"]
[111,"Všeobecná zdrav.pojišťovna ČR",{"$f":"364211306.05+18107312.74","v":382318618.79000002},{"$f":"546420.59+21356.86","v":567777.44999999995},{"$f":"C6+D6","v":382886396.24000001}]
[201,"Vojenská zdrav.pojišťovna  ČR",{"$f":"26535105.53+2526377.02","v":29061482.550000001},0,29061482.550000001]
[205,"Česká průmyslová ZP",{"$f":"19331417.57+2775816.47+53240.5","v":22160474.539999999},2466780.2799999998,24627254.82]
[207,"Oborová zdr.poj.zam.bank a p.",{"$f":"7140743.34+918262.69","v":8059006.0299999993},{"$f":"1614.05+5432.91","v":7046.96},8066052.9899999993]
[209,"Zaměstnanecká poj.ŠKODA",{"$f":"29421.51+1629.48","v":31050.989999999998},0,31050.989999999998]
[211,"Zdr.poj.ministerstva vnitra CR",{"$f":"821616.78+2441104.29","v":3262721.0700000003},0,3262721.0700000003]
[213,"Revirní bratrská pokladna",{"$f":"203070.16+1718951.04","v":1922021.2},0,1922021.2]
[217,"Zdrav.poj. METAL-ALIANCE",{"$f":"1276185.56+4634924.81","v":5911110.3699999992},65000,5976110.3699999992]
[222,"Česká národní zdravotní pojiš.",0,0,{"$f":"C14+D14","v":0}]
[227,"Pojišťovna AGEL",0,0,0]
[228,"ZP Media",{"$f":"767596.37+91741.62","v":859337.99},{"$f":"627522.79+3217.05","v":630739.84000000008},1490077.83]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C18)","v":453585823.53000003},{"$f":"SUM(D6:D18)","v":3737344.5299999993},{"$f":"SUM(E6:E18)","v":457323168.06}]
[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,17658.900000000001,17658.900000000001]
[null,"Pohledávky celkem",{"$f":"C19+C36+C37","v":453585823.53000003},{"$f":"D19+D36+D37","v":3755003.4299999992},{"$f":"E19+E36+E37","v":457340826.95999998}]

{"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":"2009-12-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ZP celkem","VZP","Ostat. ZP"]
[null,null,"pohl.celkem",{"$f":"SUM(E47:F47)","v":457340.82695999998},382886.39623999997,74454.430720000018]
[null,null,"pohl.po spl.",{"$f":"SUM(E48:F48)","v":3755.0034300000002},567.77744999999993,3187.2259800000002]

{"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":"2009-12-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zdrav.poj.","VZP",201,205,207,210,211,213,215,217,219,222,225]
["pohl.celk.",382886.39623999997,29061.482550000001,24545.458449999998,8066.0529900000001,0,3262.7210700000001,1922.0211999999999,0,5976.1103700000012,0,56.464700000000001,0]
["pohl.po spl.",567.77744999999993,0,2466.7802799999999,7.0469600000000012,0,0,0,0,65,0,0,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":2009}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"HV","Pohledávky","Závazky","Solventnost"]
[null,null,1,6.4926183299998641,452.82975471000003,450.4,{"$f":"SUM(E36-F36)","v":2.4297547100000543}]
[null,null,"1-2",24.801541909999965,477.48643319999996,458.6,{"$f":"SUM(E37-F37)","v":18.886433199999942}]
[null,null,"1-3",16.864082899999975,474.98634869000017,466,8.9863486900001703]
[null,null,"1-4",11.090347140000105,483.21031528999998,485.3,-2.0896847100000286]
[null,null,"1-5",57.427585010000229,500.25707705000031,502.6,-2.3429229499997177]
[null,null,"1-6",99.298559010000233,520.94023666000021,486.4,34.540236660000232]
[null,null,"1-7",151.13941091000032,522.14013291000026,510.8,11.34013291000025]
[null,null,"1-8",192.25234200000048,471.54882997000021,528.1,-56.55117002999981]
[null,null,"1-9",167.32464690000057,490.49687194000001,516,-25.503128059999995]
[null,null,"1-10",151.60599776000072,494.62854636999981,571.1,-76.471453630000212]
[null,null,"1-11",158.06940343000079,564.38393792000056,628.70000000000005,-64.316062079999483]
[null,null,"1-12",2.4687529400005341,475.40729225000018,579.5,-104.09270774999982]

{"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.12.2009"}]
[]
[]
["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":382318618.79000002},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D6","v":567777.44999999995},{"$f":"C6+D6","v":382886396.24000001}]
[{"$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":29061482.550000001},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D7","v":0},29061482.550000001]
[{"$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":22160474.539999999},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D8","v":2466780.2799999998},24627254.82]
[{"$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":8059006.0299999993},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D9","v":7046.96},8066052.9899999993]
[{"$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":31050.989999999998},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D10","v":0},31050.989999999998]
[{"$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":3262721.0700000003},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D11","v":0},3262721.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":1922021.2},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D12","v":0},1922021.2]
[{"$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":5911110.3699999992},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D13","v":65000},5976110.3699999992]
[{"$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":859337.99},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D16","v":630739.84000000008},1490077.83]
[{"$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":453585823.53000003},{"$f":"SUM(D6:D17)","v":3737344.5299999993},{"$f":"SUM(E6:E17)","v":457323168.06}]
[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":17658.900000000001},{"$f":"C20+D20","v":17658.900000000001}]
[null,"Pohledávky celkem",{"$f":"C18+C19+C20","v":453585823.53000003},{"$f":"D18+D19+D20","v":3755003.4299999992},{"$f":"E18+E19+E20","v":457340826.95999998}]

{"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 2007 - 2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-2)","v":"Ø 2007"},{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-1)","v":"Ø 2008"},{"$f":"CONCATENATE(\"I.\",RIGHT(YEAR(dat_do),2))","v":"I.09"},{"$f":"CONCATENATE(\"II.\",RIGHT(YEAR(dat_do),2))","v":"II.09"},{"$f":"CONCATENATE(\"III.\",RIGHT(YEAR(dat_do),2))","v":"III.09"},{"$f":"CONCATENATE(\"IV.\",RIGHT(YEAR(dat_do),2))","v":"IV.09"},{"$f":"CONCATENATE(\"V.\",RIGHT(YEAR(dat_do),2))","v":"V.09"},{"$f":"CONCATENATE(\"VI.\",RIGHT(YEAR(dat_do),2))","v":"VI.09"},{"$f":"CONCATENATE(\"VII.\",RIGHT(YEAR(dat_do),2))","v":"VII.09"},{"$f":"CONCATENATE(\"VIII.\",RIGHT(YEAR(dat_do),2))","v":"VIII.09"},{"$f":"CONCATENATE(\"IX.\",RIGHT(YEAR(dat_do),2))","v":"IX.09"},{"$f":"CONCATENATE(\"X.\",RIGHT(YEAR(dat_do),2))","v":"X.09"},{"$f":"CONCATENATE(\"XI.\",RIGHT(YEAR(dat_do),2))","v":"XI.09"},{"$f":"CONCATENATE(\"XII.\",RIGHT(YEAR(dat_do),2))","v":"XII.09"}]
["Léky ",47834.6723608334,58886.609380833353,64135.32310999999,65026.548960000044,68696.004429999899,80236.084240000011,63020.765910000024,63793.186049999982,67747.626979999972,61456.240989999918,70614.819720000174,82049.675859999974,71107.157070000074,70033.941649999906]
["    z toho: VLV",24508.675679999993,25811.338088333338,6713.5074599999998,6765.6863099999982,5482.7801100000015,6782.5667899999999,5339.1210000000001,4742.2028,5775.630079999999,4410.7267599999996,5521.3688700000002,6794.0538299999998,5269.3509499999991,7743.3130099999998]
["                 centra",0,7881.1863650000023,35794.609689999997,33907.920899999997,36783.125850000004,44531.804000000011,34842.265980000004,32846.721519999999,37734.618969999996,34313.398310000004,39392.970870000005,43473.130349999999,44220.852909999994,35850.860709999994]
["Krev",3818.4795866666664,3422.3033625000025,2539.0114900000003,3002.93604,3155.6067899999998,7299.6105900000002,3969.7534900000001,4446.6784299999999,3899.8561099999997,4107.3040300000002,4749.1317100000006,5573.0160500000002,4604.5832599999994,4092.0790400000001]
["SZM",42788.214184999888,48845.256045833492,47973.692919999972,44363.387659999964,56102.196770000017,49511.515140000003,48501.950540000027,53931.002219999958,43607.655279999984,51800.366930000055,57168.181289999979,67062.602250000025,84558.079850000082,87448.010289999933]
["Prodej LS",23514.798978333329,25951.585750833336,31524.643490000002,22846.800169999999,26620.135240000003,27116.21082,24315.074829999998,29255.392699999997,27843.567720000003,21686.640430000003,32710.0501,24684.778859999995,20789.130280000001,30551.293000000005]
["Os. náklady",114355.25914083367,115119.05588333332,115434.24240000026,110977.21570000036,114263.74068000024,115427.69956000018,121392.0618000003,119582.26663000017,133480.66227000032,125689.76188000017,145347.20132000017,130715.89933000029,141312.49106000017,137792.26102000021]
["Odpisy ",12583.070139166666,9957.4513783333332,21972.02,22447.567999999999,21523.281999999999,21283.845000000001,21247.162,21046.556000000004,21035.123,21691.395,20708.198,28965.084999999999,21102.577000000001,22799.131999999998]
["Př. náklady",293896.42696916667,296000.58570250124,323328.80714999972,301655.57624000002,333821.49923999899,334925.4094799991,323912.54398999939,327129.60420999845,340499.55187999929,322291.74925999949,368941.49256999861,382151.4438800005,396024.23234999843,475105.07114000025]
[]
["*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 2007 - 2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-2)","v":"Ø 2007"},{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-1)","v":"Ø 2008"},{"$f":"CONCATENATE(\"I.\",RIGHT(YEAR(dat_do),2))","v":"I.09"},{"$f":"CONCATENATE(\"II.\",RIGHT(YEAR(dat_do),2))","v":"II.09"},{"$f":"CONCATENATE(\"III.\",RIGHT(YEAR(dat_do),2))","v":"III.09"},{"$f":"CONCATENATE(\"IV.\",RIGHT(YEAR(dat_do),2))","v":"IV.09"},{"$f":"CONCATENATE(\"V.\",RIGHT(YEAR(dat_do),2))","v":"V.09"},{"$f":"CONCATENATE(\"VI.\",RIGHT(YEAR(dat_do),2))","v":"VI.09"},{"$f":"CONCATENATE(\"VII.\",RIGHT(YEAR(dat_do),2))","v":"VII.09"},{"$f":"CONCATENATE(\"VIII.\",RIGHT(YEAR(dat_do),2))","v":"VIII.09"},{"$f":"CONCATENATE(\"IX.\",RIGHT(YEAR(dat_do),2))","v":"IX.09"},{"$f":"CONCATENATE(\"X.\",RIGHT(YEAR(dat_do),2))","v":"X.09"},{"$f":"CONCATENATE(\"XI.\",RIGHT(YEAR(dat_do),2))","v":"XI.09"},{"$f":"CONCATENATE(\"XII.\",RIGHT(YEAR(dat_do),2))","v":"XII.09"}]
["Fakt. ZP běžný rok ",221499.84004666659,242648.21238750019,265553.05020999996,262846.62797000009,261802.44917000004,261637.23794999995,272236.88879999996,265512.27912000008,264297.69326000003,265779.04194999998,272167.50314000004,283595.5426899998,317227.98252000008,336991.87402999995]
["Dorov. ZP minul. let",3552.5275216666646,2335.1782258333228,-18.563239999999961,479.44323000000009,19.959779999999903,285.14814999999999,39236.125959999976,23227.877129999986,62871.144260000001,36292.635829999985,-4.2572699999999992,1511.8155500000003,17560.14703,-66878.102469999998]
["Prodej LS",26315.484969999994,28611.439774166647,34766.256809999992,25583.392059999998,29863.077349999992,30155.14302,27174.426770000005,32505.957339999997,30589.818099999993,24085.814999999999,34637.975039999998,28602.644440000004,23075.994109999996,33494.928910000002]
["Přímé výnosy",273276.08399833174,305094.63721083337,329821.42547999998,319964.49982000014,325884.04023000028,329151.6737200002,370249.7818600004,369000.57821000007,392340.40378000063,363404.68034999981,344013.79747000011,366432.79474000022,402487.6380200003,319504.42065000028]

{"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 2007-2009"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"01","02","03","04","05","06","07","08","09","10","11","12"]
[{"$f":"CONCATENATE(\"HV \",YEAR(dat_do)-2)","v":"HV 2007"},-23884.833469999838,27913.486670001061,25082.485809999285,-11095.409739999974,8189.4710999998497,21742.941330001107,-5037.9044300005189,4848.9729100003024,-31638.887449998932,-34970.764960000408,-49064.357780000253,-179529.31564000036]
[{"$f":"CONCATENATE(\"HV \",YEAR(dat_do)-1)","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))","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]

{"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-12/2009"}]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových nákladů"]
["Náklady FN Olomouc v tis. Kč"]
["Léky ",827917]
["Krev",51440]
["SZM",692029]
["Potraviny",37767]
["Energie",105085]
["Osobní náklady",1511415.5036499605]
["Odpisy",265822]
["Prodané zboží LS",319944]
["Ostatní",{"$f":"B17-SUM(B8:B15)","v":418367.47774002142}]
["Celkem",4229786.9813899817]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových výnosů"]
["Výnosy FN Olomouc v tis. Kč"]
["Provozní dotace",44207.089979999997]
["Výkony pro zdr.poj.",3447000]
["Aktivace",85849.873689999993]
["Tržby za léčiva",354535.42895000003]
["Ostatní výnosy",{"$f":"B38-SUM(B33:B36)","v":300663.3417100003}]
["Celkem",4232255.7343300004]