{"text_format":"1","workbook":"xlsx","n_sheets":32,"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","DA19-lůžkový fond-16","lůžkový fond měs.-16","lůžkový fond načít.-17","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"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":0,"defined_names":667,"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":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                    ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[null,null,null,null,null,{"$f":"dat_obdobi","v":"1-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Období od:","2010-01-01"]
["do:","2010-02-28"]
["rok:",{"$f":"YEAR(dat_do)","v":2010}]
["Typ období:",{"$f":"CONCATENATE(MONTH(dat_od),\"-\",MONTH(dat_do),\"/\",YEAR(dat_do))","v":"1-2/2010"}]
["Měsíc:",{"$f":"dat_do","v":"2010-02-28"}]
[null,{"$f":"CONCATENATE(\"Skut. \", dat_obdobi)","v":"Skut. 1-2/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":"28.2.2009"}]
["Předch.rok:",{"$f":"YEAR(dat_dorokpredch)","v":2009}]
["Předch.r. měs.",{"$f":"dat_do-366","v":"2009-02-27"}]
["Predch.typ obd.",{"$f":"CONCATENATE(MONTH(dat_odrokpredch),\"-\",MONTH(dat_dorokpredch),\"/\",YEAR(dat_dorokpredch))","v":"1-2/2009"}]

{"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],[29,4,29,5],[2,0,2,7],[0,0,0,7]]}
["ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[{"$f":"dat_obdobi","v":"1-2/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-2/2010"}]
["Náklady bez VPN",null,null,4195228,740216.26623999805,"tis.Kč",{"$f":"N_bez_VPN-((N_bez_VPN_Rozp/12)*MONTH(dat_do))","v":41011.599573331419},{"$f":"IF(N_bez_VPN_Rozp <> 0,G7/((N_bez_VPN_Rozp/12)*MONTH(dat_do)),\"-\")","v":5.865464223636678E-2}]
["Náklady celkem vč. VPN",null,null,4468965,788333.64610999567,"tis.Kč",{"$f":"N_vc_VPN-((N_vc_VPN_Rozp/12)*MONTH(dat_do))","v":43506.146109995665}]
[]
["Výnosy bez VPV",null,null,4216203,704908.69584999932,"tis.Kč",{"$f":"V_bez_VPV-((V_bez_VPV_Rozp/12)*MONTH(dat_do))","v":2208.1958499993198},{"$f":"IF(V_bez_VPV_Rozp <> 0,G10/((V_bez_VPV_Rozp/12)*MONTH(dat_do)),\"-\")","v":3.142442406116574E-3}]
["Výnosy celkem vč. VPV",null,null,4489940,753026.07571999729,"tis.Kč",{"$f":"V_vc_VPV-((V_vc_VPV_Rozp/12)*MONTH(dat_do))","v":4702.7423866639147}]
[]
["Hospodářský  výsledek    = ",null,"ztráta",null,{"$f":"ABS(E10-E7)","v":35307.570389998727},"tis.Kč"]
[]
["Rozbor nákladů:"]
[]
["Překročení nákladů o:"]
[]
["SZM",null,null,null,31575,"tis. Kč"]
["Léky",null,null,null,10935,"tis. Kč"]
["Spotřeba energie",null,null,null,7609,"tis. Kč"]
["Všeobecný materiál",null,null,null,414,"tis. Kč"]
["Biologické implantáty",null,null,null,598,"tis. Kč"]
["DHM a textil",null,null,null,1075,"tis. Kč"]
["Osobní náklady",null,null,null,2606,"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 28.2.2010"},"Snížení / Zvýšení zásob o"]
["Léky",23300,34109,35127,{"$f":"IF(C31>D31,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D31-C31","v":1018}]
["Krev",13000,16522,15676,{"$f":"IF(C32>D32,\"snížení\",\"zvýšení\")","v":"snížení"},{"$f":"D32-C32","v":-846}]
["SZM",14700,4824,5758,"zvýšení",934]
["Dentální slitiny","nestanoven",242,283,{"$f":"IF(C34>D34,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D34-C34","v":41}]
["Potraviny",1600,1368,1502,"zvýšení",134]
["Prádlo",2600,1907,2039,"zvýšení",132]
["Všeobecný materiál",1000,1835,1482,"snížení",-353]
["Údržbový materiál","nestanoven",936,826,"snížení",-110]
["DDHM","nestanoven",582,232,"snížení",-350]
["Materiál na cestě","nestanoven",787,1024,"zvýšení",237]
["Zboží na skladě","nestanoven",21,39,"zvýšení",18]
["Zboží na cestě","nestanoven",0,42,"zvýšení",42]
["CELKEM","nestanoven",63132,64030,"zvýšení",898]
[]
[]
["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-2/2010"}]
["Výnosy celkem",null,null,4216203,704908.69584999932,"tis.Kč",{"$f":"E49-((D49/12)*MONTH(dat_do))","v":2208.1958499993198},{"$f":"G49/((D49/12)*MONTH(dat_do))","v":3.142442406116574E-3}]
["z toho:"]
["Výkony pro zdravotní pojišťovny",null,null,3391679,562300.66613999975,"tis.Kč",{"$f":"E51-((D51/12)*MONTH(dat_do))","v":-2979.1671933336183},{"$f":"IF(D51 <> 0,G51/((D51/12)*MONTH(dat_do)),\"-\")","v":-5.2702520374132422E-3}]
["671 vybrané činnosti MZ",null,null,5200,0,"tis.Kč",-866.66666666666663,-1]
["671 VaV",null,null,15000,0,"tis.Kč",-2500,-1]
["671 dotace na DDM ISPROFIN",null,null,0,0,"tis.Kč",0,"-"]
["691 dotace na provoz  z ÚSC",null,null,0,0,"tis.Kč",0,"-"]
["899 vnitropodnikové výnosy",null,null,273737,48117,"tis.Kč",2494.1666666666642,5.4669262832572812E-2]
["604 tržby LS",null,null,381635,50016,"tis.Kč",-13589.833333333336,-0.21365702831239275]
["ostatní výnosy",null,null,{"$f":" D49 -SUM(D51:D57)","v":148952},{"$f":" E49 -SUM(E51:E57)","v":44475.029709999566},"tis.Kč",19649.696376666234,0.7915179269831718]
[]
["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"]
["                   vlivy do výnosů - dorovnání péče min.let VZP 4,5 mil., ZPMV a RBP 3 mil.  "]

{"sheet":"Ziskové kliniky FN Olomouc-3","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"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-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"Novorozenecké oddělení","09",693]
[null,null,"Klinika TVL a kard.reh","27",606]
[null,null,"Ústav lékařské genetiky a fet.","28",1081]
[null,null,"Ústav patologie","37",1039]

{"sheet":"Ziskové kliniky FN Olomouc-0","index":3,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ziskové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"III. Interní klinika","03",1023]
[null,null,"Klinika anesteziologie a resus","07",35]
[null,null,"Novorozenecké oddělení","09",2462]
[null,null,"Onkologická klinika","21",1095]
[null,null,"Klinika nukleární medicíny","22",9696]
[null,null,"Klinika rehabilit. a tělových.","26",1330]
[null,null,"Klinika TVL a kard.reh","27",327]
[null,null,"Ústav lékařské genetiky a fet.","28",2890]
[null,null,"Odděl.klin.biochemie a imunoge","33",5696]
[null,null,"Radiologická klinika","34",1932]
[null,null,"Transfůzní oddělení","35",4541]
[null,null,"Ústav patologie","37",5628]
[null,null,"Ústav mikrobiologie","40",2259]
[null,null,"Ústav imunologie","41",2702]
[null,null,"Oddělení int.péče chir.oborů","59",150]

{"sheet":"Ztrátové kliniky FN Olomouc-4","index":4,"n_rows":76,"n_cols":5,"rows_kept":76,"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-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",3346]
[null,null,"II. Interní klinika","02",207]
[null,null,"III. Interní klinika","03",1283]
[null,null,"I. Chirurgická klinika","04",1165]
[null,null,"II. Chirurgická klinika","05",961]
[null,null,"Neurochirurgická klinika","06",1682]
[null,null,"Klinika anesteziologie a resus","07",1448]
[null,null,"Porodnicko-gynekologická klini","08",3395]
[null,null,"Dětská klinika","10",1273]
[null,null,"Ortopedická klinika","11",1402]
[null,null,"Urologická klinika","12",1772]
[null,null,"Otolaryngologická klinika","13",789]
[null,null,"Oční klinika","14",5431]
[null,null,"Oddělení alergologie","15",297]
[null,null,"Klinika plicních nemocí a tube","16",2228]
[null,null,"Neurologická klinika","17",769]
[null,null,"Klinika psychiatrie","18",2845]
[null,null,"Klinika pracovního lékařství","19",436]
[null,null,"Klinika chorob kožních a pohl.","20",1279]
[null,null,"Onkologická klinika","21",573]
[null,null,"Klinika nukleární medicíny","22",1082]
[null,null,"Klinika zubního lékařství","24",139]
[null,null,"Klinika ústní,čelistní a obl.","25",193]
[null,null,"Klinika rehabilit. a tělových.","26",3612]
[null,null,"Oddělení plastické a estetické","29",1044]
[null,null,"Oddělení geriatrie","30",1271]
[null,null,"Traumatologické oddělení","31",566]
[null,null,"Hemato-onkologická klinika","32",9941]
[null,null,"Odděl.klin.biochemie a imunoge","33",1261]
[null,null,"Radiologická klinika","34",2925]
[null,null,"Transfůzní oddělení","35",1564]
[null,null,"Oddělení klinické logopedie","36",89]
[null,null,"Ústav soudního lékařství a med","38",503]
[null,null,"Oddělení klinické psychologie","39",307]
[null,null,"Ústav mikrobiologie","40",122]
[null,null,"Ústav imunologie","41",397]
[null,null,"Ústav farmakologie","43",9]
[null,null,"Sociální oddělení","45",83]
[null,null,"Transplantační centrum","46",56]
[null,null,"Centrální operační sály","47",44]
[null,null,"Lékárna","48",3519]
[null,null,"Kardiochirurgická klinika","50",6677]
[null,null,"Oddělení lékařské fyziky a rad","53",56]
[null,null,"Oddělení centrální sterilizace","56",66]
[null,null,"Oddělení int.péče chir.oborů","59",1671]
[null,null,"Oddělení urgentního příjmu","60",1295]

{"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-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",2144]
[null,null,"II. Interní klinika","02",1484]
[null,null,"I. Chirurgická klinika","04",3686]
[null,null,"II. Chirurgická klinika","05",934]
[null,null,"Neurochirurgická klinika","06",264]
[null,null,"Porodnicko-gynekologická klini","08",3591]
[null,null,"Dětská klinika","10",2009]
[null,null,"Ortopedická klinika","11",2775]
[null,null,"Urologická klinika","12",3454]
[null,null,"Otolaryngologická klinika","13",2337]
[null,null,"Oční klinika","14",3178]
[null,null,"Oddělení alergologie","15",415]
[null,null,"Klinika plicních nemocí a tube","16",3968]
[null,null,"Neurologická klinika","17",3334]
[null,null,"Klinika psychiatrie","18",2472]
[null,null,"Klinika pracovního lékařství","19",677]
[null,null,"Klinika chorob kožních a pohl.","20",1560]
[null,null,"Klinika zubního lékařství","24",1049]
[null,null,"Klinika ústní,čelistní a obl.","25",569]
[null,null,"Oddělení plastické a estetické","29",1641]
[null,null,"Oddělení geriatrie","30",2519]
[null,null,"Traumatologické oddělení","31",2278]
[null,null,"Hemato-onkologická klinika","32",3307]
[null,null,"Oddělení klinické logopedie","36",177]
[null,null,"Ústav soudního lékařství a med","38",1202]
[null,null,"Oddělení klinické psychologie","39",154]
[null,null,"Ústav farmakologie","43",197]
[null,null,"Sociální oddělení","45",454]
[null,null,"Transplantační centrum","46",202]
[null,null,"Centrální operační sály","47",8889]
[null,null,"Lékárna","48",792]
[null,null,"Kardiochirurgická klinika","50",1734]
[null,null,"Oddělení lékařské fyziky a rad","53",845]
[null,null,"Oddělení centrální sterilizace","56",3487]
[null,null,"Oddělení urgentního příjmu","60",6546]

{"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]
["Léky ",34109,38614,35127]
["z toho RTG diagn.",313,258,117]
["Krev",16522,14695,15676]
["SZM",4824,4812,5758]
["z toho lab. diagn.*"]
["Mater.na cestě",787,1296,1024]
[]
["* 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-2/2010"},"SK/PL v %"]
["501 10 Biologické implantáty",4200,{"$f":"B6/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":700},1298.126,{"$f":"IF(B6<>0,D6/B6*100,0)","v":30.907761904761905}]
["501 12 PHM",2185,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":364.16666666666669},400.49164999999999,18.329137299771165]
["501 13 Léky",832484,138747.33333333334,149681.89683999997,17.980152992730186]
["501 14 Krev",49954,8325.6666666666661,7977.1033799999996,15.968898146294592]
["501 15 SZM",658938,109823,141397.79062000004,21.458436244381115]
["501 16 Potraviny",38751,6458.5,6510.3269700000019,16.800410234574599]
["501 17 Všeobecný materiál",34889,5814.833333333333,6228.9741399999994,17.853690676144339]
["501 18 Náhradní díly",13412,2235.3333333333335,1613.2846299999999,12.028665597971964]
["501 19 DHM a textil",25000,4166.666666666667,5242.2778799999996,20.969111519999998]
["501 60 Knihy a časopisy",400,66.666666666666671,121.762,30.440499999999997]
["501 80 Spotř.nák.-z darů, kl.stud.",4000,666.66666666666663,448.57470000000001,11.2143675]
["502      Spotřeba energie",109812,18302,25910.708939999997,23.59551682876188]
["504 01 Prodané zboží",3532,588.66666666666663,545.71722,15.450657417893545]
["504 95 Prodané LS",338918,56486.333333333336,44890.463219999998,13.24522840923173]
["501 99 Opravy nákl. min. let",0,0,0,0]
["Spotřebované nákupy",{"$f":"SUM(B6:B20)","v":2116475},352745.83333333331,{"$f":"SUM(D6:D20)","v":392267.49818999995},18.534001024817208]
["511               Opravy a udržování",47306,7884.333333333333,6298.5720199999996,13.314530968587492]
["512               Cestovné",2850,475,497.57898,17.458911578947369]
["513               Náklady na reprezentaci",300,50,14.541,4.8469999999999995]
["518 01          Přepravné",450,75,60.893839999999997,13.531964444444444]
["518 02          Spoje",5800,966.66666666666663,1004.5688800000001,17.320153103448281]
["518 04          Nájemné",11675,1945.8333333333333,1823.76081,15.621077601713063]
["518               Ostatní služby",124487,20747.833333333332,18739.575129999997,15.053439419377121]
["521               Osobní náklady",1145130,190855,193239.03400000001,16.874855605913741]
["524               Zákonné sociální pojištění",389344,64890.666666666664,65811.8,16.903252650612313]
["525               Ostatní sociální pojištění",4777,796.16666666666663,0,0]
["527               Zákon. soc. poj. (FKSP)",22747,3791.1666666666665,3832.7232400000003,16.849357014111753]
["528               Náhrady-prac.nesch.",1100,183.33333333333334,238.62100000000001,21.692818181818183]
["53                 Daně a poplatky",725,120.83333333333333,46.256190000000004,6.3801641379310352]
["54x,55x,56x  Ostatní fin.náklady",9407,1567.8333333333333,4054.0325899999939,43.095913574997283]
["551               Odpisy ",272360,45393.333333333336,45351.847999999998,16.651434865619034]
["552,553        ZC prod.DNM, DHM",0,0,0,0]
["544,554        Prodaný mat. a pozemky",36100,6016.666666666667,6934.9598299999998,19.210415041551247]
["555               Tvorba zák. rez. a opr.pol.",0,0,0,0]
["59                 Daň z příjmů",4195,699.16666666666663,0,0]
["Přímé náklady celkem",{"$f":"SUM(B21:B40)","v":4195228},{"$f":"SUM(C21:C40)","v":699204.66666666663},{"$f":"SUM(D21:D40)","v":740216.26369999989},17.644243976727843]

{"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-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Náklady FN Olomouc v tis. Kč"]
[null,null,"Léky ",149682]
[null,null,"Krev",7977]
[null,null,"SZM",141398]
[null,null,"Potraviny",6510]
[null,null,"Energie",25911]
[null,null,"Osobní náklady",263122]
[null,null,"Odpisy",45352]
[null,null,"Prodané zboží LS",44890]
[null,null,"Ostatní",{"$f":"D34-SUM(D25:D32)","v":55374}]
[null,null,"Celkem",740216]
[]
[]
["        Podíl ukazatelů z celkových nákladů"]
[{"$f":"dat_obdobi","v":"1-2/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]
["Krev",4163,4347,3630]
["SZM",54912,63572,77825]

{"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-2/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":9447.5},9158.9453299999986,16.157617235600245]
["602 27,28, 29 Zdrav.  výk. - běžný rok",72479,12079.833333333334,10714.74658000001,14.783242842754465]
["602 40,42,43,46 Zdrav.vyk.-min.let",0,0,24913.435479999967,0]
["602 45 Fakturace ZP - běžný rok",3319200,553200,526672.48407999997,15.867452521089417]
["602 Ostatní služby",960,160,169.07910000000001,17.612406249999999]
["604 Prodej zboží",4330,721.66666666666663,702.15263999999991,16.215996304849885]
["604 Prodané léky a léčiva",381635,63605.833333333336,50015.826989999994,13.105670860901123]
["62   Aktivace - krev a KV",82795,13799.166666666666,13287.929239999999,16.049192873965819]
["648 01,02,03 Použití RF",2000,333.33333333333331,163.25217999999998,8.162608999999998]
["648 04 Použití FRM",47266,7877.666666666667,6236.6335100000006,13.194756294164939]
["603,649 11,14,25 Tržby z nájem.",30350,5058.333333333333,5491.5272700000005,18.093994299835256]
["64x,66x,   Ostatní výnosy",155183,25863.833333333332,49596.596310000001,31.960070568296782]
["644,645,646 Tržby z prod. mat. a majetku",43120,7186.666666666667,7786.4861600000004,18.057713729128018]
["67x  Výnosy z nároků na pr.SR,ÚSC,ost. ",20200,3366.6666666666665,0,0]
["Přímé výnosy celkem",4216203,{"$f":"B21/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":702700.5},704908.69584999932,{"$f":"IF(B21<>0,D21/B21*100,0)","v":16.71904070676861}]

{"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-2/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Výnosy FN Olomouc v tis. Kč"]
[null,null,"Provozní dotace",0]
[null,null,"Výkony pro zdr.poj.",562300.66613999975]
[null,null,"Aktivace",13287.929239999999]
[null,null,"Tržby za léčiva",50015.826989999994]
[null,null,"Ostatní výnosy",{"$f":"D29-SUM(D23:D27)","v":79304.273479999625}]
[null,null,"Celkem",704908.69584999932]
[]
[]
[]
[]
["      Podíl ukazatelů z celkových výnosů"]
[{"$f":"dat_obdobi","v":"1-2/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,0,0,0,0,0,0,0,0,0,0]
["př. výnosy",347098,357811,0,0,0,0,0,0,0,0,0,0]
["os. náklady",132481,130641,0,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-02-27"},"%",{"$f":"mesic_rok","v":"2010-02-28"},"%","Rozdíl"]
["Léky",65027,{"$f":"B7/B$19*100","v":20.28639965987448},71187,{"$f":"D7/D$19*100","v":17.98303909247706},{"$f":"D7-B7","v":6160}]
["Krev",3003,0.93684251431871479,3630,0.91699933844229597,{"$f":"D8-B8","v":627}]
["SZM",44363,13.839874945961087,77825,19.659910059028014,33462]
["Potraviny",3082,0.96148805498843781,3268,0.82555202149570894,186]
["Všeobecný materiál",3025,0.94370582944192871,3080,0.77806004473891777,55]
["Spotřeba energie",10887,3.3964050793832321,11932,3.0142248226703789,1045]
["Opravy a udržování",3281,1.023569859966601,4262,1.0766532177523598,981]
["Osobní náklady",110977,34.621369201314693,130641.2670200002,33.002191578678655,19664.267020000203]
["Odpisy",22448,7.0030771766322042,23036,5.819282854092763,588]
["Vnitropodnik. náklady",18889.227620000001,5.8928509813717325,24095.058120000005,6.0868188307902695,5205.8305000000037]
["Ostatní náklady",{"$f":"B19- SUM(B7:B16) - B18","v":35562.57623999822},11.094416696746892,{"$f":"D19- SUM(D7:D16) - D18","v":42900.012789999833},10.837268139833576,7337.4365500016138]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",320544.80385999824,100,395856.33793000004,100,75311.534070001799]
["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",4917.9960699999983,1.4513613739250526,5093.1390699999984,1.3336113315876728,175.14300000000003]
["Tržby z nájemného",3008.0015999999991,0.88769841878803235,2568.0026000000003,0.67241779967861892,-439.99899999999889]
["Zdrav. výk. - běžný rok",9154.4839700000011,2.7016012707537764,5802.00882,1.5192250990946581,-3352.4751500000011]
["Zdrav. výk. - min. let",479.44323000000009,0.14148961794755266,2900.0323700000017,0.7593580260519095,2420.5891400000019]
["Fakturace ZP - běžný rok",253692.14400000003,74.867684607530094,264062.3178800001,69.143311134850748,10370.173880000075]
["Ostatní služby",3.8961000000000001,1.1497872239961755E-3,167.9999,4.3989878789152316E-2,164.10380000000001]
["Tržby za prodané léky",25583,7.549859231409398,24552,6.4288103982875446,-1031]
["Ost. tržby za prodané zboží",321,9.4731064116109001E-2,364,9.5311460776175722E-2,43]
["Aktivace - krev a KV",5776,1.7045689293914195,7037,1.8426009601152431,1261]
["Tržby z prodeje materiálu a majetku",4541,1.3401051780412803,3306.6584600000001,0.86583090140247143,-1234.3415399999999]
["Provozní dotace od zřizovatele",306,9.0304378877038488E-2,0,0,-306]
["Vnitropodnik. výnosy",18889,5.5743771653868635,24095.058120000009,6.3091626013847675,5206.0581200000088]
["Použití rezervního fondu",192,5.6661571060102583E-2,62,1.6234369692645315E-2,-130]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":11990.03502999997},3.5384074055492842,{"$f":"D35 - SUM(D20:D33)","v":41895.586170001363},10.970136038288391,29905.551140001393]
["Výnosy celkem",338854,100,381905.80339000147,100,43051.803390001471]
["Hospodářský výsledek",{"$f":"B35-B19","v":18309.196140001761},null,{"$f":"D35-D19","v":-13950.534539998567},null,-32259.730680000328]
["Průměrný počet lůžek",1396,null,1393,null,-3]
["Počet oš. dnů",29045,null,28357,null,-688]
["Prům. nákl. na lůžkoden (hospit.)",2867.5473658116766,null,3553.7544486370193,null,686.2070828253427]
["Prům. náklady na oš. den FNO",9590.6866644861529,null,12324.733214373831,null,2734.0465498876783]
[]
[]
["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-2/2009"},"%",{"$f":"dat_obdobi","v":"1-2/2010"},"%","Rozdíl"]
["Léky",129162,{"$f":"B7/B$19*100","v":19.363050067910546},149682,{"$f":"D7/D$19*100","v":18.987138344100941},{"$f":"D7-B7","v":20520}]
["Krev",5542,0.83081729515151692,7977,1.0118812052945123,{"$f":"D8-B8","v":2435}]
["SZM",92337,13.842507503140675,141398,17.936314236709723,49061]
["Potraviny",6170,0.9249625967312991,6510,0.82579248420048579,340]
["Všeobecný materiál",5861,0.87863951044443189,6229,0.79014767804682429,368]
["Spotřeba energie",23503,3.5234029029134071,25911,3.2868063069306896,2408]
["Opravy a udržování",4235,0.63488113406111046,6299,0.79902716712424893,2064]
["Osobní náklady",226411,33.941929738821749,263122.17823999992,33.377007253003462,36711.178239999921]
["Odpisy",44420,6.6591310448629342,45352,5.7528941234194209,932]
["Vnitropodnik. náklady",42070,6.3068357284417758,48117.379870000077,6.1036821284279288,6047.3798700000771]
["Ostatní náklady",{"$f":"B19 - SUM(B7:B16) - B18","v":87343},13.093842477520559,{"$f":"D19 - SUM(D7:D16) - D18","v":87736.087999995681},11.129309072741762,393.08799999568146]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",667054,100,788333.64610999567,{"$f":"SUM(E7:E17)","v":100.00000000000001},121279.64610999567]
["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",9099.8256100000053,1.3152774002104493,9158.9453299999986,1.1618107859780549,59.119719999993322]
["Tržby z nájemného",5809.6605200000022,0.83972105756111126,5491.5272700000005,0.69659937731920318,-318.13325000000168]
["Zdrav. výk. - běžný rok",21004.458979999981,3.0359582022848657,10714.74658000001,1.3591639317783206,-10289.712399999971]
["Zdrav. výk. - min. let",460.87999000000013,6.6615016708679281E-2,24913.435479999967,3.1602654032254525,24452.555489999966]
["Fakturace ZP - běžný rok",507395.21920000028,73.338269697740614,526672.48407999997,66.808322425263285,19277.264879999682]
["Ostatní služby",225.62909999999999,3.2612147614532502E-2,169.07910000000001,{"$f":"D26/D$35*100","v":2.2453286207696987E-2},-56.549999999999983]
["Tržby za prodané léky",60350,8.7229134386346292,50016,6.6420010691100924,-10334]
["Ost. tržby za prodané zboží",612,8.8457713743900462E-2,702,9.3223863374026023E-2,90]
["Aktivace - krev a KV",11817,1.7080143844961957,13288,1.764613527797803,1471]
["Tržby z prodeje materiálu a majetku",6511,0.94109178788649661,7786.4861600000004,1.0340260996347357,1275.4861600000004]
["Provozní dotace od zřizovatele",612,8.8457713743900462E-2,0,0,-612]
["Vnitropodnik. výnosy",42070,6.0807451261534196,48117.37987000007,6.3898690127022748,6047.3798700000698]
["Použití rezerv. Fondu",380,5.4924724220068916E-2,163,2.1645996766333678E-2,-217]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":25508.32659999968},3.6869415890011332,{"$f":"D35 - SUM(D20:D33)","v":55832.991849997314},7.4144831965630456,30324.665249997634]
["Výnosy celkem",691856,100,753026.07571999729,100,61170.075719997287]
["Hospodářský výsledek",{"$f":"B35-B19","v":24802},null,{"$f":"D35-D19","v":-35307.570389998378},null,-60109.570389998378]
["Průměrný počet lůžek",1396,null,1393,null,-3]
["Počet oš. dnů",57935,null,57656,null,-279]
["Prům. nákl. na lůžkoden (hospit.)",1437.609618365412,null,3547.7980546690824,null,2110.1884363036706]
["Prům. náklady na oš. den FNO",9840.9471117631292,null,12050.438563202359,null,2209.4914514392294]
[]
[]
["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]
[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ů",28357,null,{"$f":"mesic_rok","v":"2010-02-28"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",15091.106930000013,{"$f":"B10*1000/B8","v":532.18277427090356},{"$f":"C10/C17*100","v":14.975226396832594}]
["Krev a KV",3432.8339999999998,{"$f":"B11*1000/B8","v":121.05772825052016},{"$f":"C11/C17*100","v":3.4064741951135575}]
["ZPr",4249.7250799999983,{"$f":"B12*1000/B8","v":149.86511549176564},{"$f":"C12/C17*100","v":4.21709258919799}]
["Potraviny",1744.1827199999991,{"$f":"B13*1000/B8","v":61.508012836336675},{"$f":"C13/C17*100","v":1.7307896120939643}]
["Prádlo",330.43197999999995,{"$f":"B14*1000/B8","v":11.652571851747362},{"$f":"C14/C17*100","v":0.32789468209365175}]
["Osobní náklady",52722.729870000032,{"$f":"B15*1000/B8","v":1859.2492107768817},{"$f":"C15/C17*100","v":52.317886270672531}]
["Ost.nákl. v lůžkové č.",{"$f":"B17-SUM(B10:B15)","v":23202.804319999923},{"$f":"B16*1000/B8","v":818.23903515886457},{"$f":"C16/C17*100","v":23.024636253995709}]
["Náklady celkem",100773.81489999997,{"$f":"SUM(C10:C16)","v":3553.7544486370198},{"$f":"SUM(D10:D16)","v":100}]
[]
[]
[]
[]
["Počet ošetř. dnů",57656,null,{"$f":"dat_obdobi","v":"1-2/2010"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",30968.253079999966,{"$f":"B24*1000/B22","v":537.12108158734497},{"$f":"C24/C31*100","v":15.139561872200321}]
["Krev a KV",7236.817,{"$f":"B25*1000/B22","v":125.51715346191203},{"$f":"C25/C31*100","v":3.5378888969377811}]
["SZM",8854.3039900000022,{"$f":"B26*1000/B22","v":153.57125000000005},{"$f":"C26/C31*100","v":4.3286356109782664}]
["Potraviny",3523.8380899999997,{"$f":"B27*1000/B22","v":61.118324025253223},{"$f":"C27/C31*100","v":1.7227114701418369}]
["Prádlo",629.18972999999983,{"$f":"B28*1000/B22","v":10.912823123352293},{"$f":"C28/C31*100","v":0.30759425861318307}]
["Osobní náklady",107139.97234000004,{"$f":"B29*1000/B22","v":1858.2623203135845},{"$f":"C29/C31*100","v":52.377905722903741}]
["Ost.nákl. v lůžkové č.",{"$f":"B31-SUM(B24:B29)","v":46199.470410000591},{"$f":"B30*1000/B22","v":801.2951021576348},{"$f":"C30/C31*100","v":22.585702168224877}]
["Náklady celkem",204551.84464000061,{"$f":"SUM(C24:C30)","v":3547.7980546690815},{"$f":"SUM(D24:D30)","v":100}]

{"sheet":"DA19-lůžkový fond-16","index":17,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":true,"merged":[[2,6,2,7],[0,1,1,12],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[8,2,8,6],[6,12,6,13]]}
[null,"    DA19 - L Ů Ž K O V Ý  F O N D  a jeho využití včetně SVLS"]
[]
[null,null,null,null,null,null,{"$f":"dat_obdobi","v":"1-2/2010"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Počet  dnů:",null,{"$f":"dat_do - dat_od +1","v":59}]
[]
["Klinika","Prům.","Počet ošetřovanců",null,null,null,null,"Prům.","Skut.","Uzav.","Počet"," Využ.lůžek",null,"Prům.","Počet"]
[null,"Poč.","PŘIJ.","TR +","PROP.","TR -","ÚMRTÍ","denní","lůžko.","lůžka","ošetř.","dny","(%)","ošetř.","hosp."]
[null,"lůž.",null,null,null,null,null,"p.hos","kapac.",null,"dnů",null,null,"doba"]
["I.interní klinika",63,560,24,490,63,4,54,3633,84,3179,50.460317460317462,88,5.5674255691768826,571]
["II.interní klinika",62,379,18,334,43,12,48,3658,0,2848,45.935483870967744,78,7.2468193384223918,393]
["III.interní klinika",70,383,36,330,63,13,50,3644,486,2943,42.042857142857144,81,7.1259079903147704,413]
["Geriatrické oddělení",90,20,139,113,6,10,50,3137,2173,2963,32.922222222222224,94,20.576388888888889,144]
["Alergologické oddělení",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Klinika TRN",61,371,34,331,31,13,49,3503,96,2874,47.114754098360656,82,7.3692307692307688,390]
["Neurologická klinika",72,378,11,322,49,3,59,4158,90,3474,48.25,84,9.0942408376963346,382]
["Psychiatrická klinika",90,148,7,126,1,0,48,3356,1954,2824,31.377777777777776,84,20.028368794326241,141]
["Klinika nemoci z povolání",18,97,0,87,1,0,14,1008,54,800,44.444444444444443,79,8.6021505376344081,93]
["Dětská klinika",100,963,1,932,0,1,74,5900,0,4346,43.46,74,4.5795574288724969,949]
["Por. - gyn. Klinika",87,668,6,648,5,1,56,4517,616,3299,37.919540229885058,73,4.9683734939759034,664]
["Novorozenecké oddělení",50,387,0,391,1,0,47,2950,0,2765,55.3,94,7.0897435897435894,390]
["I.chirurgická klinika",86,412,119,366,111,7,60,4696,378,3568,41.488372093023258,76,7.0236220472440944,508]
["II.chirurgická klinika",33,264,12,233,16,1,28,1947,0,1650,50,85,6.2737642585551328,263]
["Neurochirurgická klinika",44,237,25,232,14,5,28,2319,277,1678,38.136363636363633,72,6.5291828793774318,257]
["Plastická a est.chirurgie",18,137,8,129,6,0,11,1008,54,631,35.055555555555557,63,4.5071428571428571,140]
["Traumatologické oddělení",33,355,10,306,45,1,23,1947,0,1362,41.272727272727273,70,3.7938718662952646,359]
["Kl.anestez.-resuscitační",10,40,36,13,40,31,7,550,40,431,43.1,78,5.3875000000000002,80]
["Ortopedická klinika",72,438,13,385,33,0,39,2863,1385,2295,31.875,80,5.2758620689655169,435]
["Urologická klinika",32,249,98,221,100,1,24,1825,63,1421,44.40625,78,4.2417910447761198,335]
["ORL klinika",40,269,18,243,19,1,24,2095,265,1435,35.875,68,5.2181818181818178,275]
["Oční klinika",26,136,3,125,3,0,12,1534,0,728,28,47,5.4328358208955221,134]
["Ortoptické oddělení",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ústní,čelist. a obl.chir.",20,141,6,132,9,0,12,1180,0,690,34.5,58,4.791666666666667,144]
["Kožní klinika",26,134,1,117,3,0,21,1471,63,1251,48.115384615384613,85,9.7734375,128]
["Onkologická klinika",64,364,7,320,7,13,46,3665,111,2704,42.25,74,7.595505617977528,356]
["Hemato-onkologická kl.",34,141,5,115,6,5,29,2006,0,1695,49.852941176470587,84,12.463235294117647,136]
["Rehabilitační oddělení",28,57,24,56,2,0,23,1568,84,1331,47.535714285714285,85,19.014285714285716,70]
["Kl.nukleární medicíny",10,57,0,46,3,0,7,550,40,395,39.5,72,7.4528301886792452,53]
["FN celkem:",1393,7900,909,7248,909,129,977,73669,8518,57656,41.389806173725773,78,6.7449695835283103,7639]

{"sheet":"lůžkový fond měs.-16","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,null,"  Ú N O R   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ů:",28]
["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|  257|   14|  239|   29|    3|  53|  1764|    0|  1492 | 23,7| 84,6|  5,5|  271"]
["2.IK     |  62|  197|    9|  175|   21|    6|  48|  1736|    0|  1350 | 21,8| 77,8|  6,6|  204"]
["3.IK     |  70|  175|   20|  164|   33|    8|  52|  1756|  204|  1452 | 20,7| 82,7|  7,3|  200"]
["GER      |  90|   11|   63|   68|    4|    5|  53|  1540|  980|  1488 | 16,5| 96,6| 19,7|   76"]
["PLIC     |  61|  168|   17|  166|   16|    6|  52|  1708|    0|  1465 | 24,0| 85,8|  7,9|  187"]
["NEUR     |  72|  178|    4|  168|   22|    1|  61|  2016|    0|  1694 | 23,5| 84,0|  9,1|  187"]
["PSY      |  90|   75|    4|   70|    1|    0|  49|  1624|  896|  1373 | 15,3| 84,5| 18,3|   75"]
["DK       | 100|  487|    1|  485|    0|    0|  78|  2800|    0|  2182 | 21,8| 77,9|  4,5|  487"]
["PORGYN   |  87|  319|    2|  319|    2|    1|  55|  2213|  223|  1534 | 17,6| 69,3|  4,8|  322"]
["NOVO     |  50|  174|    0|  166|    1|    0|  45|  1400|    0|  1273 | 25,5| 90,9|  7,5|  171"]
["1CHIR    |  86|  184|   55|  189|   52|    2|  61|  2408|    0|  1714 | 19,9| 71,2|  7,1|  241"]
["2CHIR    |  33|  130|    9|  131|    9|    1|  31|   924|    0|   866 | 26,2| 93,7|  6,2|  140"]
["NCHIR    |  44|   99|   16|  112|    7|    2|  25|   991|  241|   712 | 16,2| 71,8|  6,0|  118"]
["PCHIR    |  18|   62|    4|   63|    4|    0|  11|   504|    0|   306 | 17,0| 60,7|  4,6|   67"]
["KCHIR    |  41|   54|   13|   61|    5|    2|  28|  1015|  133|   779 | 19,0| 76,7| 11,5|   68"]
["TRAUM    |  33|  160|    5|  148|   21|    1|  24|   924|    0|   670 | 20,3| 72,5|  4,0|  168"]
["KAR      |  10|   24|   11|    8|   21|   12|   6|   240|   40|   173 | 17,3| 72,1|  4,6|   38"]
["ORT      |  72|  211|    4|  198|   16|    0|  40|  1400|  616|  1119 | 15,5| 79,9|  5,2|  215"]
["URO      |  32|  116|   46|  107|   48|    0|  24|   896|    0|   664 | 20,8| 74,1|  4,2|  159"]
["ORL      |  40|  133|   14|  130|   11|    1|  28|  1036|   84|   772 | 19,3| 74,5|  5,3|  145"]
["OCNI     |  26|   65|    2|   69|    2|    0|  13|   728|    0|   376 | 14,5| 51,6|  5,4|   69"]
["KOZNI    |  26|   64|    0|   61|    1|    0|  22|   728|    0|   614 | 23,6| 84,3|  9,7|   63"]
["ONK      |  64|  166|    5|  158|    4|   10|  52|  1792|    0|  1448 | 22,6| 80,8|  8,4|  172"]
["HOK      |  34|   56|    3|   54|    1|    1|  32|   952|    0|   887 | 26,1| 93,2| 15,4|   58"]
["REH      |  28|   23|   14|   35|    1|    0|  26|   784|    0|   732 | 26,1| 93,4| 20,1|   37"]
["KNM      |  10|   29|    0|   27|    0|    0|   7|   280|    0|   193 | 19,3| 68,9|  6,9|   28"]
["PRAC     |  18|   46|    0|   50|    0|    0|  14|   504|    0|   402 | 22,3| 79,8|  8,4|   48"]
["IPCHO    |  13|    5|  101|    0|  103|    3|  10|   364|    0|   280 | 21,5| 76,9|  2,6|  106"]
["UCOCH    |  20|   72|    2|   69|    3|    0|  12|   560|    0|   347 | 17,4| 62,0|  4,8|   73                                                                                                          "]
["=============================================================================================="]
["Celkem   |1393| 3740|  438| 3690|  438|   65|1013| 35587| 3417| 28357 | 20,4| 79,7|  7,6| 3748"]

{"sheet":"lůžkový fond načít.-17","index":19,"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  -  Ú N O R   2 0 1 0"]
["LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS"]
[" Počet dnů: 59"]
["Klinika  |Prům|      Počet ošetřovanců      |Prům|Skut. |Uzav.|Počet  |Využ.lůžek |Prům.|Počet"]
["         |poč.|-----------------------------|den.|lůžko.|lůžka|ošetř. |-----------|ošetř|hosp."]
["         |lůž.|PŘIJ |exTR+|PROP |exTR-|Úmrtí|p.ho|kapac.|     |dnů    | dny |  %  |doba |     "]
["=============================================================================================="]
["1.IK     |  63|  560|   24|  490|   63|    4|  54|  3633|   84|  3179 | 50,5| 87,5|  5,6|  571"]
["2.IK     |  62|  379|   18|  334|   43|   12|  48|  3658|    0|  2848 | 45,9| 77,9|  7,2|  393"]
["3.IK     |  70|  383|   36|  330|   63|   13|  50|  3644|  486|  2943 | 42,0| 80,8|  7,1|  413"]
["GER      |  90|   20|  139|  113|    6|   10|  50|  3137| 2173|  2963 | 32,9| 94,5| 20,6|  144"]
["PLIC     |  61|  371|   34|  331|   31|   13|  49|  3503|   96|  2874 | 47,1| 82,0|  7,4|  390"]
["NEUR     |  72|  378|   11|  322|   49|    3|  59|  4158|   90|  3474 | 48,3| 83,5|  9,1|  382"]
["PSY      |  90|  148|    7|  126|    1|    0|  48|  3356| 1954|  2824 | 31,4| 84,1| 20,0|  141"]
["DK       | 100|  963|    1|  932|    0|    1|  74|  5900|    0|  4346 | 43,5| 73,7|  4,6|  949"]
["PORGYN   |  87|  668|    6|  648|    5|    1|  56|  4517|  616|  3299 | 37,9| 73,0|  5,0|  664"]
["NOVO     |  50|  387|    0|  391|    1|    0|  47|  2950|    0|  2765 | 55,3| 93,7|  7,1|  390"]
["1CHIR    |  86|  412|  119|  366|  111|    7|  60|  4696|  378|  3568 | 41,5| 76,0|  7,0|  508"]
["2CHIR    |  33|  264|   12|  233|   16|    1|  28|  1947|    0|  1650 | 50,0| 84,7|  6,3|  263"]
["NCHIR    |  44|  237|   25|  232|   14|    5|  28|  2319|  277|  1678 | 38,1| 72,4|  6,5|  257"]
["PCHIR    |  18|  137|    8|  129|    6|    0|  11|  1008|   54|   631 | 35,1| 62,6|  4,5|  140"]
["KCHIR    |  41|  104|   34|  104|   12|    2|  25|  2229|  190|  1477 | 36,0| 66,3| 11,5|  128"]
["TRAUM    |  33|  355|   10|  306|   45|    1|  23|  1947|    0|  1362 | 41,3| 70,0|  3,8|  359"]
["KAR      |  10|   40|   36|   13|   40|   31|   7|   550|   40|   431 | 43,1| 78,4|  5,4|   80"]
["ORT      |  72|  438|   13|  385|   33|    0|  39|  2863| 1385|  2295 | 31,9| 80,2|  5,3|  435"]
["URO      |  32|  249|   98|  221|  100|    1|  24|  1825|   63|  1421 | 44,4| 77,9|  4,2|  335"]
["ORL      |  40|  269|   18|  243|   19|    1|  24|  2095|  265|  1435 | 35,9| 68,5|  5,2|  275"]
["OCNI     |  26|  136|    3|  125|    3|    0|  12|  1534|    0|   728 | 28,0| 47,5|  5,5|  134"]
["KOZNI    |  26|  134|    1|  117|    3|    0|  21|  1471|   63|  1251 | 48,1| 85,0|  9,8|  128"]
["ONK      |  64|  364|    7|  320|    7|   13|  46|  3665|  111|  2704 | 42,3| 73,8|  7,6|  356"]
["HOK      |  34|  141|    5|  115|    6|    5|  29|  2006|    0|  1695 | 49,9| 84,5| 12,5|  136"]
["REH      |  28|   57|   24|   56|    2|    0|  23|  1568|   84|  1331 | 47,5| 84,9| 19,2|   70"]
["KNM      |  10|   57|    0|   46|    3|    0|   7|   550|   40|   395 | 39,5| 71,8|  7,5|   53"]
["PRAC     |  18|   97|    0|   87|    1|    0|  14|  1008|   54|   800 | 44,4| 79,4|  8,6|   93"]
["IPCHO    |  13|   11|  214|    1|  217|    5|  10|   752|   15|   599 | 46,1| 79,7|  2,7|  224"]
["UCOCH    |  20|  141|    6|  132|    9|    0|  12|  1180|    0|   690 | 34,5| 58,5|  4,8|  144                                                                                             "]
["=============================================================================================="]
["Celkem   |1393| 7900|  909| 7248|  909|  129| 977| 73669| 8518| 57656 | 41,4| 78,3|  7,5| 7639"]

{"sheet":"DA18-lůžkový fond-17","index":20,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":true,"merged":[[9,6,10,6],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[0,1,1,12],[2,1,2,12],[3,12,3,13],[6,12,6,13]]}
[null,"    DA19 - L Ů Ž K O V Ý  F O N D  a jeho využití včetně SVLS"]
[]
[null,{"$f":"mesic_rok","v":"2010-02-28"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Počet dnů:",null,{"$f":"dat_do - CONCATENATE(\"1/\",(MONTH(dat_do)),\"/\",(YEAR(dat_do))) +1","v":28}]
[]
["Klinika","Prům.",null,"Počet ošetřovanců",null,null,null,"Prům.","Skut.","Uzav.","Počet"," Využ.lůžek",null,"Prům.","Počet"]
[null,"Poč.","PŘIJ.","TR +","PROP.","TR -","ÚMRTÍ","denní","lůžko.","lůžka","ošetř.","dny","(%)","ošetř.","hosp."]
[null,"lůž.",null,null,null,null,null,"p.hos","kapac.",null,"dnů",null,null,"doba"]
["I.interní klinika",63,257,14,239,29,3,53,1764,0,1492,23.682539682539684,85,5.5055350553505535,271]
["II.interní klinika",62,197,9,175,21,6,48,1736,0,1350,21.774193548387096,78,6.617647058823529,204]
["III.interní klinika",70,175,20,164,33,8,52,1756,204,1452,20.742857142857144,83,7.26,200]
["Geriatrické oddělení",90,11,63,68,4,5,53,1540,980,1488,16.533333333333335,97,19.578947368421051,76]
["Alergologické oddělení",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Klinika TRN",61,168,17,166,16,6,52,1708,0,1465,24.016393442622952,86,7.8342245989304811,187]
["Neurologická klinika",72,178,4,168,22,1,61,2016,0,1694,23.527777777777779,84,9.0588235294117645,187]
["Psychiatrická klinika",90,75,4,70,1,0,49,1624,896,1373,15.255555555555556,85,18.306666666666668,75]
["Klinika nemoci z povolání",18,46,0,50,0,0,14,504,0,402,22.333333333333332,80,8.375,48]
["Dětská klinika",100,487,1,485,0,0,78,2800,0,2182,21.82,78,4.4804928131416837,487]
["Por. - gyn. Klinika",87,319,2,319,2,1,55,2213,223,1534,17.632183908045977,69,4.7639751552795033,322]
["Novorozenecké oddělení",50,174,0,166,1,0,45,1400,0,1273,25.46,91,7.4444444444444446,171]
["I.chirurgická klinika",86,184,55,189,52,2,61,2408,0,1714,19.930232558139537,71,7.1120331950207465,241]
["II.chirurgická klinika",33,130,9,131,9,1,31,924,0,866,26.242424242424242,94,6.1857142857142859,140]
["Neurochirurgická klinika",44,99,16,112,7,2,25,991,241,712,16.181818181818183,72,6.0338983050847457,118]
["Plastická a est.chirurgie",18,62,4,63,4,0,11,504,0,306,17,61,4.5671641791044779,67]
["Traumatologické oddělení",33,160,5,148,21,1,24,924,0,670,20.303030303030305,73,3.9880952380952381,168]
["Kl.anestez.-resuscitační",10,24,11,8,21,12,6,240,40,173,17.3,72,4.5526315789473681,38]
["Ortopedické oddělení",72,211,4,198,16,0,40,1400,616,1119,15.541666666666666,80,5.2046511627906975,215]
["Urologická klinika",32,116,46,107,48,0,24,896,0,664,20.75,74,4.1761006289308176,159]
["ORL klinika",40,133,14,130,11,1,28,1036,84,772,19.3,75,5.3241379310344827,145]
["Oční klinika",26,65,2,69,2,0,13,728,0,376,14.461538461538462,52,5.4492753623188408,69]
["Ortoptické oddělení",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ústní,čelist. a obl.chir.",20,72,2,69,3,0,12,560,0,347,17.350000000000001,62,4.7534246575342465,73]
["Kožní klinika",26,64,0,61,1,0,22,728,0,614,23.615384615384617,84,9.7460317460317452,63]
["Onkologická klinika",64,166,5,158,4,10,52,1792,0,1448,22.625,81,8.4186046511627914,172]
["Hemato-onkologická kl.",34,56,3,54,1,1,32,952,0,887,26.088235294117649,93,15.293103448275861,58]
["Rehabilitační oddělení",28,23,14,35,1,0,26,784,0,732,26.142857142857142,93,19.783783783783782,37]
["Kl.nukleární medicíny",10,29,0,27,0,0,7,280,0,193,19.3,69,6.8928571428571432,28]
["FN celkem:",1393,3740,438,3690,438,65,1013,35587,3417,28357,20.356783919597991,80,6.7742474916387962,3748]

{"sheet":"Rozbor investic-FRIM-18","index":21,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["                             Rozbor investic - FRM k",null,{"$f":"dat_do","v":"2010-02-28"}]
[]
[]
["Plán odpisů roku",{"$f":"dat_rok","v":2010},272360000]
["               Alikvotní část odpisů",null,45393333.32]
["               Skutečně zúčtované odpisy",null,45134922]
["               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":300685273.49000001}]
["stavby",1253136.7]
["projekty",0]
["Přístrojová technika",0]
["technické zhodnocení",3139717.3]
["oprava a udržování",6236633.5099999998]
["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]
["ÚČEL.DOTACE 908",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":10629487.51},{"$f":"SUM(C15:C37)","v":311314761},{"$f":"SUM(D15:D37)","v":300685273.49000001}]
[]
["Z toho:"]
["čerpání z odpisů",{"$f":"SUM(B16:B20)","v":10629487.51},{"$f":"SUM(C15)","v":311314761},{"$f":"SUM(D15)","v":300685273.49000001}]
["č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":22,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Celková finanční situace:"]
[]
["Rozbor platební neschopnosti FN k ",null,{"$f":"dat_do","v":"2010-02-28"}]
[]
[]
["Zůstatek na BÚ  (bez FKSP) ",null,185904,"tis. Kč"]
[]
[]
["Potřeba finančních prostředků na mzdy za měsíc ",null,null,{"$f":"mesic_rok","v":"2010-02-28"}]
["celkem",null,130291,"tis. Kč"]
[]
[]
["1. Stav závazků vůči dodavatelům k ",null,{"$f":"dat_do","v":"2010-02-28"}]
[]
["Závazky","LS","FN","Celkem"]
["do splatnosti",370601022.45999998,183717163.19,{"$f":"SUM(B16:C16)","v":554318185.64999998}]
["po splat. do 30 dnů",47696.639999999999,27551035.969999999,27598732.609999999]
["31 - 90 dnů",-6238111,6603802.7400000002,365691.74000000022]
["91 - 180 dnů",0,80612.800000000003,80612.800000000003]
["181 - 360 dnů",0,98373.2,98373.2]
["nad 360 dnů",0,358941.66,358941.66]
["C e l k e m ",{"$f":"SUM(B16:B21)","v":364410608.09999996},{"$f":"SUM(C16:C21)","v":218409929.56},{"$f":"SUM(D16:D21)","v":582820537.65999997}]
[]
[]
[]
[]
["Pohledávky"]
[]
["FN - pouze ve vztahu k odběratel.  (úč. 311+324+970)",null,null,473822,"tis. Kč"]
["LS - pouze ve vztahu k odběratelům",null,null,25863.146010000004,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D29:D30)","v":499685.14601000003},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,23518,"tis. Kč"]
[]
[]
["Závazky"]
[]
["FN - pouze ve vztahu k dodavatel. (úč.321+314+970)",null,null,218410,"tis. Kč"]
["LS - pouze ve vztahu k dodavatelům",null,null,364411,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D38:D39)","v":582821},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,28503,"tis. Kč"]

{"sheet":"Nezaplacené pohledávky FN Ol-20","index":23,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"                                              Nezaplacené pohledávky FN Olomouc"]
[null,"                                                                   k 28.2.2010"]
[]
[]
["Kód","Název zdravotní pojišťovny (ZP)","do splatnosti","po splatnosti","Celkem"]
[111,"Všeobecná zdrav.pojišťovna ČR",{"$f":"293618970.46+12111358.38","v":305730328.83999997},{"$f":"3023977.86+3677.52","v":3027655.38},{"$f":"C6+D6","v":308757984.21999997}]
[201,"Vojenská zdrav.pojišťovna  ČR",{"$f":"27835394.02+1688294.64","v":29523688.66},0,29523688.66]
[205,"Česká průmyslová ZP",{"$f":"38886143.85+1648098.55","v":40534242.399999999},{"$f":"2030865.48+15376.67+5.02","v":2046247.17},42580489.57]
[207,"Oborová zdr.poj.zam.bank a p.",{"$f":"8688498.4+1057502.22","v":9746000.620000001},18973.150000000001,9764973.7700000014]
[209,"Zaměstnanecká poj.ŠKODA",{"$f":"21697.18+1539.97","v":23237.15},0,23237.15]
[211,"Zdr.poj.ministerstva vnitra CR",{"$f":"556443.95+3169246.16","v":3725690.1100000003},3.91,3725694.0200000005]
[213,"Revirní bratrská pokladna",{"$f":"8443599.49+1322403.89","v":9766003.3800000008},0,9766003.3800000008]
[217,"Zdrav.poj. METAL-ALIANCE",{"$f":"64820660.93+3174855.39","v":67995516.319999993},{"$f":"36000+38530","v":74530},68070046.319999993]
[222,"Česká národní zdravotní pojiš.",0,0,{"$f":"C14+D14","v":0}]
[227,"Pojišťovna AGEL",0,0,0]
[228,"ZP Media",{"$f":"1656689.07+217261.83","v":1873950.9000000001},{"$f":"301578.32+94958.67","v":396536.99},2270487.89]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C18)","v":468918658.37999994},{"$f":"SUM(D6:D18)","v":5563946.6000000006},{"$f":"SUM(E6:E18)","v":474482604.9799999}]
[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":468918658.37999994},{"$f":"D19+D36+D37","v":5581605.5000000009},{"$f":"E19+E36+E37","v":474500263.87999988}]

{"sheet":"Pohledávky po zdr. pojišťov.-21","index":24,"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-02-28"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ZP celkem","VZP","Ostat. ZP"]
[null,null,"pohl.celkem",{"$f":"SUM(E47:F47)","v":474500.26387999998},308757.98422000004,165742.27965999997]
[null,null,"pohl.po spl.",{"$f":"SUM(E48:F48)","v":5581.6054999999997},3027.6553799999997,2553.95012]

{"sheet":"Nezaplacené pohledávky-22","index":25,"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-02-28"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zdrav.poj.","VZP",201,205,207,210,211,213,215,217,219,222,225]
["pohl.celk.",308757.98422000004,29523.68866,42564.274069999999,9764.9737699999987,0,3725.6940200000004,9766.0033799999983,0,68070.046319999994,0,5.0199999999999993E-3,0]
["pohl.po spl.",3027.6553799999997,0,2044.7606699999999,18.97315,0,3.9100000000000003E-3,0,0,74.53,0,5.0199999999999993E-3,0]

{"sheet":"Hospodaření,fin.sit.,solvent-23","index":26,"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"]
[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":27,"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  28.2.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":305730328.83999997},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D6","v":3027655.38},{"$f":"C6+D6","v":308757984.21999997}]
[{"$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":29523688.66},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D7","v":0},29523688.66]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Nezaplacené pohledávky FN Ol-20'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Nezaplacené pohledávky FN Ol-20'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Nezaplacené pohledávky FN Ol-20'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$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":40534242.399999999},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D8","v":2046247.17},42580489.57]
[{"$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":9746000.620000001},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D9","v":18973.150000000001},9764973.7700000014]
[{"$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":23237.15},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D10","v":0},23237.15]
[{"$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":3725690.1100000003},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D11","v":3.91},3725694.0200000005]
[{"$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":9766003.3800000008},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D12","v":0},9766003.3800000008]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A14","v":222},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B14","v":"Česká národní zdravotní pojiš."},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C14","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D14","v":0},0]
[{"$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":1873950.9000000001},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D16","v":396536.99},2270487.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]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D6:D17)","v":{"$error":"#REF!"}},{"$f":"SUM(E6:E17)","v":{"$error":"#REF!"}}]
[null,"Pohledávky celkem (zaniklé ZP)",{"$f":"'Nezaplacené pohledávky FN Ol-20'!C35","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D35","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!E35","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":{"$error":"#REF!"}},{"$f":"D18+D19+D20","v":{"$error":"#REF!"}},{"$f":"E18+E19+E20","v":{"$error":"#REF!"}}]

{"sheet":"Vývojová řada nákladů-25","index":28,"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]
["    z toho: VLV",25811.338088333338,5945.0256641666665,5053.2768400000004,5424.5941599999996]
["                 centra",7881.1863650000023,37807.690004999989,47050.635599999994,41008.531070000005]
["Krev",3422.3033625000025,4286.6305858333335,4347.0470800000003,3630.0563000000002]
["SZM",48845.256045833492,57669.053428333173,63572.343459999996,77825.44716000004]
["Prodej LS",25951.585750833336,26661.976469999998,22922.720369999999,21967.742850000002]
["Os. náklady",115119.05588333332,125951.29197083003,132480.91122000004,130641.2670200002]
["Odpisy ",9957.4513783333332,22151.828583333336,22316.278999999999,23035.569]
["Př. náklady",296000.58570250124,352482.24844916508,368454.98642999859,371761.2798099987]
[]
["*VLV = vliv lékové vyhlášky"]

{"sheet":"Vývojová řada výnosů -26","index":29,"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]
["Dorov. ZP minul. let",2335.1782258333228,9548.6144950000089,22013.403109999992,2900.0323700000017]
["Prodej LS",28611.439774166647,29544.619079166681,25463.889859999999,24551.937130000006]
["Přímé výnosy",305094.63721083337,352687.97786083305,347097.95057999971,357810.74527000025]

{"sheet":"Vývojová řada HV - 27","index":30,"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]

{"sheet":"Podíl ukazatelů N a V - 28","index":31,"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-2/2010"}]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových nákladů"]
["Náklady FN Olomouc v tis. Kč"]
["Léky ",149682]
["Krev",7977]
["SZM",141398]
["Potraviny",6510]
["Energie",25911]
["Osobní náklady",263122.17823999992]
["Odpisy",45352]
["Prodané zboží LS",44890]
["Ostatní",{"$f":"B17-SUM(B8:B15)","v":55374.087999998126}]
["Celkem",740216.26623999805]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových výnosů"]
["Výnosy FN Olomouc v tis. Kč"]
["Provozní dotace",0]
["Výkony pro zdr.poj.",562300.66613999975]
["Aktivace",13287.929239999999]
["Tržby za léčiva",50015.826989999994]
["Ostatní výnosy",{"$f":"B38-SUM(B33:B36)","v":79304.273479999625}]
["Celkem",704908.69584999932]