{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Titulní list","Rozbor hospodaření FN Olomouc-1","Ziskové kliniky FN Olomouc-3","Ziskové kliniky FN Olomouc-0","Ztrátové kliniky FN Olomouc-4","Ztrátové kliniky FN Olomouc-0","Vývoj stavu zásob-5","Přehled o čerpání nákladů-6","Náklady FN Olomouc v tis.Kč-7","Čerpání vybraných nákladů-8","Přehled o výnosech roku-9","Výnosy FN Olomouc v tis.Kč-10","Srovnání nákladů, výnosů a m-11","Srovnání nákladů a výnosů mě-12","Srovnání nákladů a výnosů na-13","Srovnání měs.přímých nákladů-14","Náklady na lůžkoden-15","DA19-lůžkový fond-16","DA18-lůžkový fond-17","Rozbor investic-FRIM-18","Celková finanční situace-19","Nezaplacené pohledávky FN Ol-20","Pohledávky po zdr. pojišťov.-21","Nezaplacené pohledávky-22","Hospodaření,fin.sit.,solvent-23","Nezap. pohled. FNOl - souhrn-24","Vývojová řada nákladů-25","Vývojová řada výnosů -26","Vývojová řada HV - 27","Podíl ukazatelů N a V - 28","List1"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":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":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                    ROZBOR HOSPODAŘENÍ  FN OLOMOUC"]
[]
[null,null,null,null,null,{"$f":"dat_obdobi","v":"1-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Období od:","2010-01-01"]
["do:","2010-07-31"]
["rok:",{"$f":"YEAR(dat_do)","v":2010}]
["Typ období:",{"$f":"CONCATENATE(MONTH(dat_od),\"-\",MONTH(dat_do),\"/\",YEAR(dat_do))","v":"1-7/2010"}]
["Měsíc:",{"$f":"dat_do","v":"2010-07-31"}]
[null,{"$f":"CONCATENATE(\"Skut. \", dat_obdobi)","v":"Skut. 1-7/2010"}]
[null,{"$f":"CONCATENATE(\"PLÁN \", dat_rok)","v":"PLÁN 2010"}]
["Předch.obd.od:",{"$f":"CONCATENATE(\"1.1.\",YEAR(dat_od)-1)","v":"1.1.2009"}]
["Předch.obd.do:",{"$f":"CONCATENATE((DAY(dat_do)),\".\",MONTH(dat_do),\".\",YEAR(dat_do)-1)","v":"31.7.2009"}]
["Předch.rok:",{"$f":"YEAR(dat_dorokpredch)","v":2009}]
["Předch.r. měs.",{"$f":"dat_do-366","v":"2009-07-30"}]
["Predch.typ obd.",{"$f":"CONCATENATE(MONTH(dat_odrokpredch),\"-\",MONTH(dat_dorokpredch),\"/\",YEAR(dat_dorokpredch))","v":"1-7/2009"}]

{"sheet":"Rozbor hospodaření FN Olomouc-1","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"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-7/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-7/2010"}]
["Náklady bez VPN",null,null,4195228,2559818.549670036,"tis.Kč",{"$f":"N_bez_VPN-((N_bez_VPN_Rozp/12)*MONTH(dat_do))","v":112602.21633670293},{"$f":"IF(N_bez_VPN_Rozp <> 0,G7/((N_bez_VPN_Rozp/12)*MONTH(dat_do)),\"-\")","v":4.6012367113996984E-2}]
["Náklady celkem vč. VPN",null,null,4468965,2734274.4892200506,"tis.Kč",{"$f":"N_vc_VPN-((N_vc_VPN_Rozp/12)*MONTH(dat_do))","v":127378.23922005063}]
[]
["Výnosy bez VPV",null,null,4216203,2618999.8939800048,"tis.Kč",{"$f":"V_bez_VPV-((V_bez_VPV_Rozp/12)*MONTH(dat_do))","v":159548.14398000482},{"$f":"IF(V_bez_VPV_Rozp <> 0,G10/((V_bez_VPV_Rozp/12)*MONTH(dat_do)),\"-\")","v":6.4871426723457706E-2}]
["Výnosy celkem vč. VPV",null,null,4489940,2793455.8335300214,"tis.Kč",{"$f":"V_vc_VPV-((V_vc_VPV_Rozp/12)*MONTH(dat_do))","v":174324.16686335439}]
[]
["Hospodářský  výsledek    = ",null,"zisk",null,{"$f":"ABS(E10-E7)","v":59181.344309968874},"tis.Kč"]
[]
["Rozbor nákladů:"]
[]
["Překročení nákladů o:"]
[]
["SZM",null,null,null,56553,"tis. Kč"]
["Léky",null,null,null,21380,"tis. Kč"]
["Spotřeba energie",null,null,null,3584,"tis. Kč"]
["Krev",null,null,null,2999,"tis. Kč"]
[]
[]
[]
[]
["Zásoby:","Limit",{"$f":"CONCATENATE(\"Počáteční stav \",DAY(dat_od),\".\",MONTH(dat_od),\".\",YEAR(dat_do))","v":"Počáteční stav 1.1.2010"},{"$f":"CONCATENATE(\"Stav k \",DAY(dat_do),\".\",MONTH(dat_do),\".\",YEAR(dat_do))","v":"Stav k 31.7.2010"},"Snížení / Zvýšení zásob o"]
["Léky",23300,34109,34047,{"$f":"IF(C28>D28,\"snížení\",\"zvýšení\")","v":"snížení"},{"$f":"D28-C28","v":-62}]
["Krev",13000,16522,16944,{"$f":"IF(C29>D29,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D29-C29","v":422}]
["SZM",14700,4824,4870,"zvýšení",46]
["Dentální slitiny","nestanoven",242,277,{"$f":"IF(C31>D31,\"snížení\",\"zvýšení\")","v":"zvýšení"},{"$f":"D31-C31","v":35}]
["Potraviny",1600,1368,1412,"zvýšení",44]
["Prádlo",2600,1907,2156,"zvýšení",249]
["Všeobecný materiál",1000,1835,1794,"snížení",-41]
["Údržbový materiál","nestanoven",936,972,"zvýšení",36]
["DDHM","nestanoven",582,745,"zvýšení",163]
["Materiál na cestě","nestanoven",787,2039,"zvýšení",1252]
["Zboží na skladě","nestanoven",21,45,"zvýšení",24]
["Zboží na cestě","nestanoven",0,0,"zvýšení",0]
["CELKEM","nestanoven",63132,65301,"zvýšení",2169]
[]
[]
["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-7/2010"}]
["Výnosy celkem",null,null,4216203,2618999.8939800048,"tis.Kč",{"$f":"E46-((D46/12)*MONTH(dat_do))","v":159548.14398000482},{"$f":"G46/((D46/12)*MONTH(dat_do))","v":6.4871426723457706E-2}]
["z toho:"]
["Výkony pro zdravotní pojišťovny",null,null,3391679,2091261.7148500006,"tis.Kč",{"$f":"E48-((D48/12)*MONTH(dat_do))","v":112782.29818333383},{"$f":"IF(D48 <> 0,G48/((D48/12)*MONTH(dat_do)),\"-\")","v":5.7004534509309646E-2}]
["671 vybrané činnosti MZ",null,null,5200,100,"tis.Kč",-2933.333333333333,-0.96703296703296704]
["671 VaV",null,null,15000,10968,"tis.Kč",2218,0.25348571428571426]
["671 dotace na DDM ISPROFIN",null,null,0,214,"tis.Kč",214,"-"]
["671 dotace - rezidenční místa",null,null,null,1844,"tis.Kč",1844,"-"]
["691 dotace na provoz  z ÚSC",null,null,0,0,"tis.Kč",0,"-"]
["899 vnitropodnikové výnosy",null,null,273737,174456,"tis.Kč",14776.083333333314,9.2535640309598391E-2]
["604 tržby LS",null,null,381635,206313,"tis.Kč",-16307.416666666686,-7.3252116363990358E-2]
["ostatní výnosy",null,null,{"$f":" D46 -SUM(D48:D55)","v":148952},{"$f":" E46 -SUM(E48:E55)","v":133843.17913000425},"tis.Kč",46954.512463337596,0.54039858435704236]
[]
[]
["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,"]
["                                                  IOP-porad.služby, školení lékařů a ost.zdr.prac, studium MBA, ,oprava vyzdívky  spalovny,"]
["                   vlivy do výnosů - dorovnání péče min.let VZP 4,5 mil., ost.ZP 98 mil.  "]
[null,"odhad ZP z minulých let 19,6 mil. Kč"]
[null,"zvýšení zálohy VZP  - zohlednění robot.centra a účtování pitev na pracov.soudního lékařství"]
[null,"na regulačních poplatcích bylo vybráno 20,5 mil. Kč"]

{"sheet":"Ziskové kliniky FN Olomouc-3","index":2,"n_rows":49,"n_cols":5,"rows_kept":49,"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-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"III. Interní klinika","03",1785]
[null,null,"Novorozenecké oddělení","09",7117]
[null,null,"Dětská klinika","10",221]
[null,null,"Ortopedická klinika","11",2031]
[null,null,"Otolaryngologická klinika","13",349]
[null,null,"Neurologická klinika","17",751]
[null,null,"Onkologická klinika","21",212]
[null,null,"Klinika nukleární medicíny","22",3229]
[null,null,"Klinika zubního lékařství","24",1227]
[null,null,"Klinika ústní,čelistní a obl.","25",592]
[null,null,"Klinika TVL a kard.reh","27",273]
[null,null,"Ústav lékařské genetiky a fet.","28",327]
[null,null,"Transfůzní oddělení","35",4710]
[null,null,"Oddělení klinické logopedie","36",45]
[null,null,"Ústav patologie","37",4179]
[null,null,"Ústav soudního lékařství a med","38",3660]
[null,null,"Ústav mikrobiologie","40",2183]
[null,null,"Ústav imunologie","41",670]
[null,null,"Oddělení centrální sterilizace","56",4]

{"sheet":"Ziskové kliniky FN Olomouc-0","index":3,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ziskové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika ","Klinika č.","Zisk"]
[null,null,"I. Interní klinika","01",10546]
[null,null,"III. Interní klinika","03",9124]
[null,null,"Novorozenecké oddělení","09",16969]
[null,null,"Oční klinika","14",1996]
[null,null,"Onkologická klinika","21",5515]
[null,null,"Klinika nukleární medicíny","22",40350]
[null,null,"Klinika rehabilit. a tělových.","26",11647]
[null,null,"Ústav lékařské genetiky a fet.","28",14594]
[null,null,"Hemato-onkologická klinika","32",18946]
[null,null,"Odděl.klin.biochemie a imunoge","33",25772]
[null,null,"Radiologická klinika","34",11960]
[null,null,"Transfůzní oddělení","35",25914]
[null,null,"Ústav patologie","37",22573]
[null,null,"Ústav soudního lékařství a med","38",1173]
[null,null,"Oddělení klinické psychologie","39",322]
[null,null,"Ústav mikrobiologie","40",10175]
[null,null,"Ústav imunologie","41",13259]
[null,null,"Lékárna","48",1275]
[null,null,"Kardiochirurgická klinika","50",7114]
[null,null,"Oddělení int.péče chir.oborů","59",1221]

{"sheet":"Ztrátové kliniky FN Olomouc-4","index":4,"n_rows":61,"n_cols":5,"rows_kept":61,"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-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"I. Interní klinika","01",2549]
[null,null,"II. Interní klinika","02",1942]
[null,null,"I. Chirurgická klinika","04",992]
[null,null,"II. Chirurgická klinika","05",1689]
[null,null,"Neurochirurgická klinika","06",8189]
[null,null,"Klinika anesteziologie a resus","07",7840]
[null,null,"Porodnicko-gynekologická klini","08",5214]
[null,null,"Urologická klinika","12",3313]
[null,null,"Oční klinika","14",4316]
[null,null,"Oddělení alergologie","15",194]
[null,null,"Klinika plicních nemocí a tube","16",2192]
[null,null,"Klinika psychiatrie","18",4887]
[null,null,"Klinika pracovního lékařství","19",457]
[null,null,"Klinika chorob kožních a pohl.","20",576]
[null,null,"Klinika rehabilit. a tělových.","26",5198]
[null,null,"Oddělení plastické a estetické","29",1812]
[null,null,"Oddělení geriatrie","30",1667]
[null,null,"Traumatologické oddělení","31",1564]
[null,null,"Hemato-onkologická klinika","32",3125]
[null,null,"Odděl.klin.biochemie a imunoge","33",1373]
[null,null,"Radiologická klinika","34",4098]
[null,null,"Oddělení klinické psychologie","39",166]
[null,null,"Ústav farmakologie","43",47]
[null,null,"Sociální oddělení","45",338]
[null,null,"Transplantační centrum","46",130]
[null,null,"Centrální operační sály","47",2226]
[null,null,"Lékárna","48",8267]
[null,null,"Kardiochirurgická klinika","50",9207]
[null,null,"Oddělení lékařské fyziky a rad","53",246]
[null,null,"Oddělení int.péče chir.oborů","59",4807]
[null,null,"Oddělení urgentního příjmu","60",3091]

{"sheet":"Ztrátové kliniky FN Olomouc-0","index":5,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Ztrátové kliniky FN Olomouc"]
[{"$f":"dat_obdobi","v":"1-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Klinika","Klinika č.","Ztráta"]
[null,null,"II. Interní klinika","02",6761]
[null,null,"I. Chirurgická klinika","04",10323]
[null,null,"II. Chirurgická klinika","05",1823]
[null,null,"Neurochirurgická klinika","06",3745]
[null,null,"Klinika anesteziologie a resus","07",3904]
[null,null,"Porodnicko-gynekologická klini","08",6359]
[null,null,"Dětská klinika","10",3705]
[null,null,"Ortopedická klinika","11",3093]
[null,null,"Urologická klinika","12",9375]
[null,null,"Otolaryngologická klinika","13",7275]
[null,null,"Oddělení alergologie","15",669]
[null,null,"Klinika plicních nemocí a tube","16",8569]
[null,null,"Neurologická klinika","17",8522]
[null,null,"Klinika psychiatrie","18",3850]
[null,null,"Klinika pracovního lékařství","19",1356]
[null,null,"Klinika chorob kožních a pohl.","20",1677]
[null,null,"Klinika zubního lékařství","24",1957]
[null,null,"Klinika ústní,čelistní a obl.","25",793]
[null,null,"Klinika TVL a kard.reh","27",715]
[null,null,"Oddělení plastické a estetické","29",3991]
[null,null,"Oddělení geriatrie","30",7665]
[null,null,"Traumatologické oddělení","31",7816]
[null,null,"Oddělení klinické logopedie","36",280]
[null,null,"Ústav farmakologie","43",705]
[null,null,"Sociální oddělení","45",1638]
[null,null,"Transplantační centrum","46",642]
[null,null,"Centrální operační sály","47",33183]
[null,null,"Oddělení lékařské fyziky a rad","53",3008]
[null,null,"Oddělení centrální sterilizace","56",11970]
[null,null,"Oddělení urgentního příjmu","60",21556]

{"sheet":"Vývoj stavu zásob-5","index":6,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13]]}
["    Vývoj stavu zásob"]
[{"$f":"CONCATENATE(\"      v průběhu roku  \",dat_rok)","v":"      v průběhu roku  2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poč.stav","leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Zásoby celkem",63132,65896,64030,61586,61293,64426,65090,65301]
["Léky ",34109,38614,35127,32237,32372,34769,33213,34047]
["z toho RTG diagn.",313,258,117,54,83,94,137,55]
["Krev",16522,14695,15676,15624,15581,16502,17654,16944]
["SZM",4824,4812,5758,6292,5433,5714,5541,4870]
["z toho lab. diagn.*"]
["Mater.na cestě",787,1296,1024,971,450,216,1142,2039]
[]
["* 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":[]}
[" ",{"$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-7/2010"},"SK/PL v %"]
["501 10 Biologické implantáty",4200,{"$f":"B6/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":2450},4361.2736400000003,{"$f":"IF(B6<>0,D6/B6*100,0)","v":103.83984857142859}]
["501 12 PHM",2185,{"$f":"B7/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":1274.5833333333335},1437.9271100000001,65.809021052631579]
["501 13 Léky",832484,485615.66666666669,506996.12212999997,60.901605571998971]
["501 14 Krev",49954,29139.833333333332,32139.018869999996,64.337227989750573]
["501 15 SZM",658938,384380.5,440933.66833000013,66.915805178939465]
["501 16 Potraviny",38751,22604.75,23905.500240000001,61.690021522025241]
["501 17 Všeobecný materiál",34889,20351.916666666664,20414.876079999995,58.513789675829045]
["501 18 Náhradní díly",13412,7823.666666666667,5742.7036500000004,42.817653220996128]
["501 19 DHM a textil",25000,14583.333333333334,15545.462019999999,62.181848079999988]
["501 60 Knihy a časopisy",400,233.33333333333334,202.09379999999999,50.52344999999999]
["501 80 Spotř.nák.-z darů, kl.stud.",4000,2333.333333333333,2182.8344099999995,54.570860249999988]
["502      Spotřeba energie",109812,64057,67640.613010000001,61.596740802462392]
["504 01 Prodané zboží",3532,2060.333333333333,2051.96828,58.096497168742921]
["504 95 Prodané LS",338918,197702.16666666669,185214.78476000001,54.648848618249843]
["501 99 Opravy nákl. min. let",0,0,0,0]
["Spotřebované nákupy",{"$f":"SUM(B6:B20)","v":2116475},1234610.4166666665,{"$f":"SUM(D6:D20)","v":1308768.8463299999},61.837198470570165]
["511               Opravy a udržování",47306,27595.166666666664,27083.018170000003,57.250704286982632]
["512               Cestovné",2850,1662.5,2397.1716000000001,84.111284210526321]
["513               Náklady na reprezentaci",300,175,155.32933000000003,51.776443333333347]
["518 01          Přepravné",450,262.5,1136.6414000000002,252.58697777777783]
["518 02          Spoje",5800,3383.333333333333,3191.0940600000004,55.018863103448282]
["518 04          Nájemné",11675,6810.4166666666661,6888.2884499999991,59.000329336188429]
["518               Ostatní služby",124487,72617.416666666657,74841.362390000009,60.119821660093031]
["521               Osobní náklady",1145130,667992.5,697121.59,60.877069852331175]
["524               Zákonné sociální pojištění",389344,227117.33333333331,237569.65950000001,61.017932599449331]
["525               Ostatní sociální pojištění",4777,2786.583333333333,2464.4178700000002,51.589237387481688]
["527               Zákon. soc. poj. (FKSP)",22747,13269.083333333332,13825.734219999998,60.780473117334147]
["528               Náhrady-prac.nesch.",1100,641.66666666666674,720.09749999999997,65.463409090909082]
["53                 Daně a poplatky",725,422.91666666666663,616.89377000000002,85.088795862068963]
["54x,55x,56x  Ostatní fin.náklady",9407,5487.4166666666661,1178.6470399999571,12.529467843095111]
["551               Odpisy ",272360,158876.66666666669,157771.12100000001,57.927419958877955]
["552,553        ZC prod.DNM, DHM",0,0,0,0]
["544,554        Prodaný mat. a pozemky",36100,21058.333333333336,25122.122139999999,69.590366038781156]
["555               Tvorba zák. rez. a opr.pol.",0,0,289.14490000000001,0]
["59                 Daň z příjmů",4195,2447.083333333333,-1322.63,-31.528724672228847]
["Přímé náklady celkem",{"$f":"SUM(B21:B40)","v":4195228},{"$f":"SUM(C21:C40)","v":2447216.3333333335},{"$f":"SUM(D21:D40)","v":2559818.5496700006},61.017388081648974]

{"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-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Náklady FN Olomouc v tis. Kč"]
[null,null,"Léky ",506996]
[null,null,"Krev",32139]
[null,null,"SZM",440934]
[null,null,"Potraviny",23906]
[null,null,"Energie",67641]
[null,null,"Osobní náklady",951701]
[null,null,"Odpisy",157771]
[null,null,"Prodané zboží LS",185215]
[null,null,"Ostatní",{"$f":"D34-SUM(D25:D32)","v":193516}]
[null,null,"Celkem",2559819]
[]
[]
["        Podíl ukazatelů z celkových nákladů"]
[{"$f":"dat_obdobi","v":"1-7/2010"}]

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

{"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-7/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":33066.25},37156.561539999959,65.549195624944801]
["602 27,28, 29 Zdrav.  výk. - běžný rok",72479,42279.416666666672,58820.03420000006,81.154588501497074]
["602 40,42,43,46 Zdrav.vyk.-min.let",0,0,140340.94132999994,0]
["602 45 Fakturace ZP - běžný rok",3319200,1936200,1892100.7393199995,57.004722201735348]
["602 Ostatní služby",960,560,625.80133000000001,65.187638541666672]
["604 Prodej zboží",4330,2525.833333333333,2642.2680799999998,61.02235750577367]
["604 Prodané léky a léčiva",381635,222620.41666666669,206313.24241999997,54.060356733528103]
["62   Aktivace - krev a KV",82795,48297.083333333328,53676.761580000006,64.830921649858084]
["648 01,02,03 Použití RF",2000,1166.6666666666665,1414.6496200000001,70.732481000000007]
["648 04 Použití FRM",47266,27571.833333333336,25892.956200000004,54.781357000803965]
["603 Tržby z nájem.",24800,14466.666666666666,14365.837860000005,57.926765564516145]
["64x,66x,   Ostatní výnosy",160733,93760.916666666657,132412.94040999984,82.380681260226481]
["644,645,646 Tržby z prod. mat. a majetku",43120,25153.333333333336,28510.842119999998,66.11976372912801]
["67x  Výnosy z nároků na pr.SR,ÚSC,ost. ",20200,11783.333333333332,24726.141,122.40663861386139]
["Přímé výnosy celkem",4216203,{"$f":"B21/12*(MONTH(dat_do)-MONTH(dat_od)+1)","v":2459451.75},2618999.8939800048,{"$f":"IF(B21<>0,D21/B21*100,0)","v":62.1174998922017}]

{"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-7/2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Výnosy FN Olomouc v tis. Kč"]
[null,null,"Provozní dotace",24726.141]
[null,null,"Výkony pro zdr.poj.",2091261.7148500006]
[null,null,"Aktivace",53676.761580000006]
[null,null,"Tržby za léčiva",206313.24241999997]
[null,null,"Ostatní výnosy",{"$f":"D29-SUM(D23:D27)","v":243022.03413000423}]
[null,null,"Celkem",2618999.8939800048]
[]
[]
[]
[]
["      Podíl ukazatelů z celkových výnosů"]
[{"$f":"dat_obdobi","v":"1-7/2010"}]

{"sheet":"Srovnání nákladů, výnosů a m-11","index":12,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,13]]}
["Srovnání nákladů, výnosů a os. nákladů"]
[{"$f":"CONCATENATE(\"      v jednotlivých měsících roku  \",dat_rok)","v":"      v jednotlivých měsících roku  2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["př. náklady",368455,371761,398939,368650,346620,353561,351831,0,0,0,0,0]
["př. výnosy",347098,357811,436745,369515,365300,376696,365835,0,0,0,0,0]
["os. náklady",132481,130641,130411,133433,137664,133930,153141,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-07-30"},"%",{"$f":"mesic_rok","v":"2010-07-31"},"%","Rozdíl"]
["Léky",67748,{"$f":"B7/B$19*100","v":18.51654446298739},64438,{"$f":"D7/D$19*100","v":16.807262467596633},{"$f":"D7-B7","v":-3310}]
["Krev",3900,1.0659284909613689,4649,1.212591377942468,{"$f":"D8-B8","v":749}]
["SZM",43608,11.9187204189342,46965,12.249807284376857,3357]
["Potraviny",2756,0.75325613361270083,2888,0.75327251010923801,132]
["Všeobecný materiál",3333,0.91095888727544694,2727,0.71127913264123688,-606]
["Spotřeba energie",6561,1.7932196997942418,7023,1.8317980742718762,462]
["Opravy a udržování",3026,0.82705118298694935,5571,1.453075191765431,2545]
["Osobní náklady",133481,36.482359205644741,153140.54258999988,39.943407519480566,19659.542589999881]
["Odpisy",21035,5.7491809762493329,22452,5.8561199435500733,1417]
["Vnitropodnik. náklady",25378.650369999985,6.9363657670590451,31562.50952,8.2323998516195012,6183.8591500000148]
["Ostatní náklady",{"$f":"B19- SUM(B7:B16) - B18","v":55051.551879998995},15.046414774494576,{"$f":"D19- SUM(D7:D16) - D18","v":41977.734499999788},10.948986646646121,-13073.817379999207]
["Opravy nákladů min. let",0,0,0,0,0]
["Náklady celkem",365878.20224999898,100,383393.78660999966,100,17515.584360000677]
["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",4235.6860900000001,1.0140036938707602,4221.137209999999,1.0621956855641757,-14.548880000001191]
["Tržby z nájemného",2661.561999999999,0.63716565442318851,2098.5291900000002,0.5280682765695941,-563.03280999999879]
["Zdrav. výk. - běžný rok",26525.159260000004,6.3500006607312587,6840.2441199999985,1.7212607482308591,-19684.915140000005]
["Zdrav. výk. - min. let",62871.144260000001,15.051061661068804,16704.144930000006,4.2033863845152544,-46166.999329999991]
["Fakturace ZP - běžný rok",238269.7490000001,57.040677824087503,267843.53788000002,67.399431998653498,29573.78887999992]
["Ostatní služby",108.95835,2.6084125931547283E-2,66.424539999999993,1.6714893710736548E-2,-42.533810000000003]
["Tržby za prodané léky",30590,7.323104766601471,27236,6.8535942455246301,-3354]
["Ost. tržby za prodané zboží",324,7.7564104098688358E-2,296,7.4484648871908157E-2,-28]
["Aktivace - krev a KV",6852,1.6403371644574463,6995,1.7602031042533703,143]
["Tržby z prodeje materiálu a majetku",4039,0.96691795202037745,3045.3831399999999,0.76633207386259838,-993.61686000000009]
["Provozní dotace od zřizovatele",900,0.21545584471857876,4802.8,1.208563755412164,3902.8]
["Vnitropodnik. výnosy",25379,6.0756154256809003,31562.50952,7.942305537545467,6183.5095199999996]
["Použití rezervního fondu",314,7.5170150268481922E-2,410,0.10317130418068361,96]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":14648.741039999935},3.5068409720409974,{"$f":"D35 - SUM(D20:D33)","v":25275.611580000899},6.3602873431050773,10626.870540000964]
["Výnosy celkem",417719,100,397397.32211000088,100,-20321.677889999119]
["Hospodářský výsledek",{"$f":"B35-B19","v":51840.797750001017},null,{"$f":"D35-D19","v":14003.53550000122},null,-37837.262249999796]
["Průměrný počet lůžek",1396,null,1392,null,-4]
["Počet oš. dnů",25440,null,23938,null,-1502]
["Prům. nákl. na lůžkoden (hospit.)",3525.6871422955983,null,4364.929013284318,null,839.24187098871971]
["Prům. náklady na oš. den FNO",12279.512377358476,null,13667.269218397476,null,1387.7568410389995]
[]
[]
["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-7/2009"},"%",{"$f":"dat_obdobi","v":"1-7/2010"},"%","Rozdíl"]
["Léky",472656,{"$f":"B7/B$19*100","v":19.339712581926264},506996,{"$f":"D7/D$19*100","v":18.542249580239478},{"$f":"D7-B7","v":34340}]
["Krev",28313,1.1584858381826915,32139,1.1754123489323716,{"$f":"D8-B8","v":3826}]
["SZM",343991,14.075113974580661,440934,16.126179055482321,96943]
["Potraviny",22289,0.91200123078635298,23906,0.87430870946754013,1617]
["Všeobecný materiál",20673,0.84587919799211597,20415,0.74663315919768392,-258]
["Spotřeba energie",61278,2.5073180232458228,67641,2.4738189332006142,6363]
["Opravy a udržování",19220,0.7864266524166047,27083,0.9905004090399645,7863]
["Osobní náklady",830558,33.984024327670681,951701.49908998876,34.806362815514575,121143.49908998876]
["Odpisy",150556,6.1603148325304034,157771,5.7701229566386383,7215]
["Vnitropodnik. náklady",158693,6.4932572711731664,174455.93955000106,6.3803374620140811,15762.939550001058]
["Ostatní náklady",{"$f":"B19 - SUM(B7:B16) - B18","v":335730},13.737097815599725,{"$f":"D19 - SUM(D7:D16) - D18","v":331232.05058006058},12.114074570272724,-4497.9494199394248]
["Opravy nákladů min. let",9,3.68253895512458E-4,0,0,-9]
["Náklady celkem",2443966,100,2734274.4892200506,{"$f":"SUM(E7:E17)","v":100},290308.48922005063]
["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",35685.844749999982,1.3751208910156263,37156.561539999959,1.358918487755735,1470.7167899999768]
["Tržby z nájemného",18913.25119000001,0.72880457252998565,14365.837860000005,0.52539852588457014,-4547.4133300000049]
["Zdrav. výk. - běžný rok",93543.393829999957,3.6046078206439334,58820.03420000006,2.1512117540466256,-34723.359629999897]
["Zdrav. výk. - min. let",126101.13526999998,4.8591901552383598,140340.94132999994,5.1326573788878118,14239.806059999959]
["Fakturace ZP - běžný rok",1760840.0476500022,67.852336191662388,1892100.7393199995,69.19937068424025,131260.69166999729]
["Ostatní služby",713.75740000000019,2.7503978642876254E-2,625.80133000000001,{"$f":"D26/D$35*100","v":2.2402406456134668E-2},-87.956070000000182]
["Tržby za prodané léky",210638,8.1167397401108072,206313,7.3855830302957521,-4325]
["Ost. tržby za prodané zboží",2425,9.3445123243520695E-2,2642,9.4578191224214542E-2,217]
["Aktivace - krev a KV",48863,1.8828903328033615,53677,1.9215267109546421,4814]
["Tržby z prodeje materiálu a majetku",27351,1.0539453879725915,28510.842119999998,1.020629779708081,1159.8421199999975]
["Provozní dotace od zřizovatele",9988,0.38487830554898333,24726.141,0.88514522775733973,14738.141]
["Vnitropodnik. výnosy",158693,6.1150873991274342,174455.93955000094,6.245165484844815,15762.939550000941]
["Použití rezerv. Fondu",1600,6.1654514305003343E-2,1415,5.0654103172696287E-2,-185]
["Ostatní výnosy ",{"$f":"B35 - SUM(B20:B33)","v":99750.56990999775},3.8437955871551202,{"$f":"D35 - SUM(D20:D33)","v":158305.9952800204},5.6670305425940111,58555.425370022655]
["Výnosy celkem",2595106,100,2793455.8335300214,100,198349.83353002137]
["Hospodářský výsledek",{"$f":"B35-B19","v":151140},null,{"$f":"D35-D19","v":59181.344309970737},null,-91958.655690029263]
["Průměrný počet lůžek",1396,null,1392.4285714285713,null,-3.5714285714286689]
["Počet oš. dnů",208885,null,205597,null,-3288]
["Prům. nákl. na lůžkoden (hospit.)",2844.4,null,3574.9300902250448,null,730.53009022504466]
["Prům. náklady na oš. den FNO",10023.874119299933,null,11539.817198840485,null,1515.9430795405515]
[]
[]
["Rozdíl:"]
["            úspora nákladů (-)"]
["            překročení nákladů (+)"]
["            snížení výnosů (-)"]
["            překročení výnosů (+)"]

{"sheet":"Srovnání měs.přímých nákladů-14","index":15,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14]]}
["Srovnání měsíčních přímých nákladů"]
[{"$f":"CONCATENATE(\"v letech \",(dat_rok - 3),\" - \",(dat_rok))","v":"v letech 2007 - 2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"dat_rok-3","v":2007},{"$f":"dat_rok-2","v":2008},{"$f":"dat_rok-1","v":2009},{"$f":"dat_rok","v":2010}]
[null,null,null,null,null,"leden",281893,314446,323329,368455]
[null,null,null,null,null,"únor",256650,291124,301656,371761]
[null,null,null,null,null,"březen",290042,307756,333821,398939]
[null,null,null,null,null,"duben",272114,310025,334925,368650]
[null,null,null,null,null,"květen",281236,299979,323913,346620]
[null,null,null,null,null,"červen",308643,241350,327130,353561]
[null,null,null,null,null,"červenec",288462,323227,340500,351831]
[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ů",23938,null,{"$f":"mesic_rok","v":"2010-07-31"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",14865.717160000017,{"$f":"B10*1000/B8","v":621.00915531790531},{"$f":"C10/C17*100","v":14.227245241054614}]
["Krev a KV",4103.2089999999998,{"$f":"B11*1000/B8","v":171.40985044698806},{"$f":"C11/C17*100","v":3.9269791083730263}]
["ZPr",4881.1005999999998,{"$f":"B12*1000/B8","v":203.9059487008104},{"$f":"C12/C17*100","v":4.6714608205594796}]
["Potraviny",1556.5825399999985,{"$f":"B13*1000/B8","v":65.025588603893326},{"$f":"C13/C17*100","v":1.4897284332916541}]
["Prádlo",326.36102999999991,{"$f":"B14*1000/B8","v":13.633596373966075},{"$f":"C14/C17*100","v":0.31234405719940228}]
["Osobní náklady",54342.773130000009,{"$f":"B15*1000/B8","v":2270.1467595454928},{"$f":"C15/C17*100","v":52.008789894096331}]
["Ost.nákl. v lůžkové č.",{"$f":"B17-SUM(B10:B15)","v":24411.927259999968},{"$f":"B16*1000/B8","v":1019.7981142952615},{"$f":"C16/C17*100","v":23.363452445425484}]
["Náklady celkem",104487.67071999999,{"$f":"SUM(C10:C16)","v":4364.929013284318},{"$f":"SUM(D10:D16)","v":99.999999999999986}]
[]
[]
[]
[]
["Počet ošetř. dnů",205597,null,{"$f":"dat_obdobi","v":"1-7/2010"}]
["Druh nákladu","v tis. Kč","Kč/den","%"]
["Léky a léčiva",122055.14461000003,{"$f":"B24*1000/B22","v":593.66208947601388},{"$f":"C24/C31*100","v":16.606257311136464}]
["Krev a KV",29330.892499999994,{"$f":"B25*1000/B22","v":142.66206462156546},{"$f":"C25/C31*100","v":3.9906252995449423}]
["SZM",31804.415739999975,{"$f":"B26*1000/B22","v":154.69299522852947},{"$f":"C26/C31*100","v":4.3271614080372531}]
["Potraviny",12779.41986,{"$f":"B27*1000/B22","v":62.157618350462307},{"$f":"C27/C31*100","v":1.7387086399373319}]
["Prádlo",2381.7140099999997,{"$f":"B28*1000/B22","v":11.584381143693729},{"$f":"C28/C31*100","v":0.32404497014833888}]
["Osobní náklady",380610.40688000014,{"$f":"B29*1000/B22","v":1851.244944624679},{"$f":"C29/C31*100","v":51.784088021372789}]
["Ost.nákl. v lůžkové č.",{"$f":"B31-SUM(B24:B29)","v":156032.90815999836},{"$f":"B30*1000/B22","v":758.92599678010072},{"$f":"C30/C31*100","v":21.229114349822872}]
["Náklady celkem",734994.90175999852,{"$f":"SUM(C24:C30)","v":3574.9300902250448},{"$f":"SUM(D24:D30)","v":100}]

{"sheet":"DA19-lůžkový fond-16","index":17,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Fakultní nemocnice Olomouc                                L E D E N – Č E R V E N E C  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,null,"Počet dnů: 212"]
["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     |  62| 1869|   73| 1686|  212|   26|  49| 12804|  430| 10480 |169,0| 81,8|  5,4| 1933"]
["2.IK     |  62| 1352|   62| 1159|  208|   56|  47| 12760|  384|  9921 |160,0| 77,8|  7,0| 1419"]
["3.IK     |  70| 1387|  123| 1222|  212|   57|  50| 12840| 2000| 10618 |151,7| 82,7|  7,1| 1501"]
["GER      |  90|   72|  468|  456|   27|   37|  52| 11552| 7528| 10948 |121,6| 94,8| 20,7|  530"]
["PLIC     |  61| 1255|  116| 1214|  100|   56|  45| 11726| 1206|  9525 |156,1| 81,2|  7,0| 1371"]
["NEUR     |  72| 1228|   46| 1116|  151|   15|  53| 14244| 1020| 11143 |154,8| 78,2|  8,7| 1278"]
["PSY      |  90|  494|   29|  510|   11|    0|  49| 12208| 6872| 10290 |114,3| 84,3| 19,7|  522"]
["DK       | 100| 3590|    5| 3578|    5|    2|  77| 21200|    0| 16327 |163,3| 77,0|  4,5| 3590"]
["PORGYN   |  87| 2441|   28| 2422|   32|    1|  59| 16207| 2237| 12410 |142,6| 76,6|  5,0| 2462"]
["NOVO     |  50| 1454|    0| 1452|    3|    7|  47| 10600|    0|  9911 |198,2| 93,5|  6,8| 1458"]
["1CHIR    |  86| 1455|  421| 1433|  396|   24|  62| 16654| 1578| 13145 |152,8| 78,9|  7,1| 1865"]
["2CHIR    |  33|  851|   47|  816|   64|    6|  28|  6921|   75|  5948 |180,2| 85,9|  6,7|  892"]
["NCHIR    |  44|  838|   58|  823|   50|   17|  28|  8574|  754|  5893 |133,9| 68,7|  6,6|  893"]
["PCHIR    |  18|  519|   25|  523|   21|    0|  11|  3582|  234|  2412 |134,0| 67,3|  4,4|  544"]
["KCHIR    |  41|  338|  128|  436|   23|   10|  26|  8328|  364|  5539 |135,1| 66,5| 11,8|  468"]
["TRAUM    |  33| 1168|   38| 1063|  131|    3|  23|  6996|    0|  4961 |150,3| 70,9|  4,1| 1202"]
["KAR      |  10|  122|  167|   48|  164|   77|   7|  2020|  100|  1522 |152,2| 75,3|  5,3|  289"]
["ORT      |  72| 1533|   35| 1465|   95|    0|  39| 10031| 5233|  8264 |114,8| 82,4|  5,3| 1564"]
["URO      |  32|  871|  306|  846|  315|    5|  25|  6721|   63|  5242 |163,8| 78,0|  4,5| 1172"]
["ORL      |  40|  940|   76|  930|   73|    4|  23|  7589|  891|  4918 |123,0| 64,8|  4,9| 1012"]
["OCNI     |  26|  480|    4|  473|    3|    0|  13|  5512|    0|  2722 |104,7| 49,4|  5,7|  480"]
["KOZNI    |  26|  470|    8|  444|   21|    1|  22|  5449|   63|  4621 |177,7| 84,8|  9,8|  472"]
["ONK      |  64| 1377|   19| 1308|   18|   42|  46| 13383|  185|  9773 |152,7| 73,0|  7,1| 1382"]
["HOK      |  34|  502|   13|  471|   15|   20|  28|  6874|  334|  6028 |177,3| 87,7| 11,8|  511"]
["REH      |  28|  179|   79|  226|   10|    0|  20|  5012|  924|  4314 |154,1| 86,1| 17,5|  247"]
["KNM      |  10|  191|    1|  184|    8|    0|   6|  1770|  350|  1289 |128,9| 72,8|  6,7|  192"]
["PRAC     |  18|  311|    1|  309|    3|    0|  13|  3438|  378|  2701 |150,1| 78,6|  8,7|  312"]
["IPCHO    |  13|   41|  738|   12|  747|   16|  10|  2611|  145|  2023 |155,6| 77,5|  2,6|  777"]
["UCOCH    |  20|  518|   30|  520|   26|    0|  13|  4240|    0|  2709 |135,5| 63,9|  5,0|  547                                                                                                        "]
["=============================================================================================="]
["Celkem   |1392|27846| 3144|27145| 3144|  482| 970|261846|33348|205597 |147,7| 78,5|  7,4|27737"]
[]
["V Olomouci dne 10.8.2010"]
["Zpracovala: Čapková M.,PZIS FNOL"]

{"sheet":"DA18-lůžkový fond-17","index":18,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Fakultní nemocnice Olomouc                                            Č E R V E N E C  2 0 1 0 "]
[]
["                            LŮŽKOVÝ FOND A JEHO VYUŽITÍ VČETNĚ SVLS"]
["                                                                                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ůžk. |lůžka|ošetř. |-----------|ošetř|hosp."]
["         |    |PŘIJ |exTR+|PROP |exTR-|Úmrtí|p.ho|kapac.|     |dnů    | dny |  %  |doba |     "]
["=============================================================================================="]
["1.IK     |  62|  228|    8|  217|   24|    4|  46|  1922|    0|  1437 | 23,2| 74,8|  6,0|  241"]
["2.IK     |  62|  158|    5|  153|   23|    9|  38|  1538|  384|  1164 | 18,8| 75,7|  6,7|  174"]
["3.IK     |  70|  155|   16|  132|   29|   10|  43|  1576|  594|  1340 | 19,1| 85,0|  7,8|  171"]
["GER      |  90|    7|   51|   60|    5|    9|  49|  1705| 1085|  1529 | 17,0| 89,7| 23,2|   66"]
["PLIC     |  61|  102|    8|  110|    6|    8|  24|   911|  980|   741 | 12,1| 81,3|  6,3|  117"]
["NEUR     |  72|   88|    2|   79|   15|    2|  26|  1362|  870|   798 | 11,1| 58,6|  8,6|   93"]
["PSY      |  90|   60|    6|   83|    1|    0|  47|  1776| 1014|  1445 | 16,1| 81,4| 19,3|   75"]
["DK       | 100|  397|    1|  448|    2|    1|  65|  3100|    0|  2010 | 20,1| 64,8|  4,7|  425"]
["PORGYN   |  87|  326|    1|  333|    1|    0|  54|  1930|  767|  1682 | 19,3| 87,2|  5,1|  331"]
["NOVO     |  50|  229|    0|  215|    0|    3|  49|  1550|    0|  1514 | 30,3| 97,7|  6,8|  224"]
["1CHIR    |  86|  148|   53|  161|   59|    2|  47|  1790|  876|  1451 | 16,9| 81,1|  6,9|  212"]
["2CHIR    |  33|   89|    5|   98|   12|    1|  22|   948|   75|   677 | 20,5| 71,4|  6,6|  103"]
["NCHIR    |  44|   87|    7|  101|    4|    1|  23|   965|  399|   710 | 16,1| 73,6|  7,1|  100"]
["PCHIR    |  18|   51|    0|   65|    3|    0|   9|   414|  144|   285 | 15,8| 68,8|  4,8|   60"]
["KCHIR    |  41|   20|   15|   57|    1|    1|  18|  1125|  146|   551 | 13,4| 49,0| 11,7|   47"]
["TRAUM    |  33|  141|    7|  141|   14|    0|  23|  1023|    0|   710 | 21,5| 69,4|  4,7|  152"]
["KAR      |  10|   18|   27|    6|   25|   11|   7|   310|    0|   226 | 22,6| 72,9|  5,2|   44"]
["ORT      |  72|  131|    3|  164|    5|    0|  24|  1068| 1164|   741 | 10,3| 69,4|  4,9|  152"]
["URO      |  32|  118|   23|  124|   23|    1|  22|   992|    0|   695 | 21,7| 70,1|  4,8|  145"]
["ORL      |  40|   92|    8|  103|   10|    1|  15|   980|  260|   471 | 11,8| 48,1|  4,4|  107"]
["OCNI     |  26|   47|    0|   57|    0|    0|  11|   806|    0|   339 | 13,0| 42,1|  6,5|   52"]
["KOZNI    |  26|   63|    1|   58|    3|    0|  20|   806|    0|   612 | 23,5| 75,9|  9,8|   63"]
["ONK      |  64|  190|    2|  202|    1|    7|  42|  1984|    0|  1296 | 20,3| 65,3|  6,4|  201"]
["HOK      |  34|   48|    3|   49|    4|    3|  21|   720|  334|   647 | 19,0| 89,9| 12,1|   54"]
["REH      |  28|   19|    7|    3|    1|    0|   4|   168|  700|   121 |  4,3| 72,0|  8,1|   15"]
["KNM      |  10|    0|    0|    0|    0|    0|   0|     0|  310|     0 |  0,0|  0,0|  0,0|    0"]
["PRAC     |  18|   12|    0|   25|    0|    0|   5|   288|  270|   155 |  8,6| 53,8|  8,4|   19"]
["IPCHO    |  13|    6|   86|    3|   76|    1|   8|   325|   78|   242 | 18,6| 74,5|  2,8|   86"]
["UCOCH    |  20|   61|    4|   72|    2|    0|  11|   620|    0|   349 | 17,5| 56,3|  5,0|   70                                                                                                          "]
["=============================================================================================="]
["Celkem   |1392| 3091|  349| 3319|  349|   75| 772| 32702|10450| 23938 | 17,2| 73,2|  7,4| 3243"]
[]
["V Olomouci dne 10.8.2010"]
["Zpracovala: Čapková M.,PZIS FNOL"]

{"sheet":"Rozbor investic-FRIM-18","index":19,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["                             Rozbor investic - FRM k",null,"2010-07-31"]
[]
[]
["Plán odpisů roku",{"$f":"dat_rok","v":2010},272360000]
["               Alikvotní část odpisů",null,158876666.62]
["               Skutečně zúčtované odpisy",null,157345349]
["               Limit vlastních zdrojů pro nákup inv.2010",null,361314761]
[]
[]
["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":361314761},{"$f":"C15-(B16+B17+B18+B19+B20)","v":237957641.64000002}]
["stavby",80201672.099999994]
["projekty",6167655.96]
["Přístrojová technika",5910460.5999999996]
["technické zhodnocení",5184374.5]
["oprava a udržování",25892956.199999999]
["DARY",null,5193552,{"$f":"C21-(B22+B23+B24)","v":0}]
["stavby",200000]
["projekty",0]
["Přístrojová technika",4993552]
["OSTATNÍ DOTACE",null,0,{"$f":"C25-(B26+B27+B28)","v":0}]
["stavby"]
["projekty",0]
["Přístrojová technika",0]
["SYSTÉM.DOTACE 916",null,53912000,{"$f":"C29-(B30+B31+B32+B33)","v":32812946.5}]
["stavby",21099053.5]
["projekty",0]
["Přístrojová technika",0]
["Přístrojová technika - granty",0]
["SYSTÉM.DOTACE 916 IOP",null,42552250,{"$f":"C34-(B35+B36+B37)","v":42552250}]
["stavby",0]
["projekty",0]
["Přístrojová technika",0]
["C E L K E M ",{"$f":"SUM(B15:B37)","v":149649724.85999998},{"$f":"SUM(C15:C37)","v":462972563},{"$f":"SUM(D15:D37)","v":313322838.13999999}]
[]
["Z toho:"]
["čerpání z odpisů",{"$f":"SUM(B16:B20)","v":123357119.35999998},{"$f":"SUM(C15)","v":361314761},{"$f":"SUM(D15)","v":237957641.64000002}]
["čerpání z dotací",{"$f":"SUM(B22:B37)","v":26292605.5},{"$f":"SUM(C21:C37)","v":101657802},{"$f":"SUM(D21:D37)","v":75365196.5}]

{"sheet":"Celková finanční situace-19","index":20,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Celková finanční situace:"]
[]
["Rozbor platební neschopnosti FN k ",null,"2010-07-31"]
[]
[]
["Zůstatek na BÚ (bez FKSP) ",null,172367,"tis. Kč"]
[]
[]
["Potřeba finančních prostředků na mzdy za měsíc ",null,null,"2010-07-01"]
["celkem",null,151088,"tis. Kč"]
[]
[]
["1. Stav závazků vůči dodavatelům k ",null,"2010-07-31"]
[]
["Závazky","LS","FN","Celkem"]
["do splatnosti",266464020.84999999,204941679.94,{"$f":"SUM(B16:C16)","v":471405700.78999996}]
["po splat. do 30 dnů",7180716.3499999996,41746321.359999999,48927037.710000001]
["31 - 90 dnů",605474.27,16812503.030000001,17417977.300000001]
["91 - 180 dnů",0,347930.79,347930.79]
["181 - 360 dnů",0,3339453.89,3339453.89]
["nad 360 dnů",0,309646.56,309646.56]
["C e l k e m ",{"$f":"SUM(B16:B21)","v":274250211.46999997},{"$f":"SUM(C16:C21)","v":267497535.56999999},{"$f":"SUM(D16:D21)","v":541747747.03999984}]
[]
[]
[null,null,null,null,null,null,null," "]
[]
["Pohledávky"]
[]
["FN - pouze ve vztahu k odběratel.  (úč. 311+324+970)",null,null,456125,"tis. Kč"]
["LS - pouze ve vztahu k odběratelům",null,null,28883,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D29:D30)","v":485008},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,42484,"tis. Kč"]
[]
[]
["Závazky"]
[]
["FN - pouze ve vztahu k dodavatel. (úč.321+314+970)",null,null,267498,"tis. Kč"]
["LS - pouze ve vztahu k dodavatelům",null,null,274250,"tis. Kč"]
["Celkem",null,null,{"$f":"SUM(D38:D39)","v":541748},"tis. Kč"]
[]
[null,"z toho po lhůtě splatnosti celkem",null,70342,"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",{"$f":"dat_do","v":"2010-07-31"}]
[]
[]
["Kód","Název zdravotní pojišťovny (ZP)","do splatnosti","po splatnosti","Celkem"]
[111,"Všeobecná zdrav.pojišťovna ČR",319667118.25999999,-19181.859999999993,{"$f":"C6+D6","v":319647936.39999998}]
[201,"Vojenská zdrav.pojišťovna  ČR",27761372.25,20694671.5,48456043.75]
[205,"Hutnická zaměstnecká poj.",0,0,0]
[205,"Česká průmyslová zdravotní poj",23220801.98,12082.21,23232884.190000001]
[207,"Oborová zdr.poj.zam.bank a p.",6490003.4699999997,547926.74,7037930.21]
[209,"Zaměstnanecká poj.ŠKODA",42299.78,0,42299.78]
[211,"Zdr.poj.ministerstva vnitra CR",3614993.42,25524.989999999998,3640518.41]
[213,"Revirní bratrská pokladna",9529985.6399999987,137418.71000000002,9667404.3499999996]
[217,"Zdrav.poj. METAL-ALIANCE",42380702.140000001,659547.35,{"$f":"C14+D14","v":43040249.490000002}]
[222,"Česká národní zdravotní pojiš.",0,0,0]
[228,"Zdravotní pojišťovny MÉDIA",1705589.9299999997,179369.22,1884959.1499999997]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (aktivní ZP)",{"$f":"SUM(C6:C18)","v":434412866.87},{"$f":"SUM(D6:D18)","v":22237358.859999999},{"$f":"SUM(E6:E18)","v":456650225.72999996}]
[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]
[227,"Pojišťovna AGEL",0,0,0]
[null,null,null,null,0]
[null,"Pohledávky celkem (zaniklé ZP)",{"$f":"SUM(C20:C35)","v":0},{"$f":"SUM(D20:D35)","v":0},{"$f":"SUM(E20:E35)","v":0}]
[null,"Slovenské ZP",0,0,0]
[null,"Pohledávky celkem",{"$f":"C19+C36+C37","v":434412866.87},{"$f":"D19+D36+D37","v":22237358.859999999},{"$f":"E19+E36+E37","v":456650225.72999996}]

{"sheet":"Pohledávky po zdr. pojišťov.-21","index":22,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,null,"              Pohledávky po zdrav. pojišťovnách"]
[null,null,null,"k ",{"$f":"dat_do","v":"2010-07-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ZP celkem","VZP","Ostat. ZP"]
[null,null,"pohl.celkem",{"$f":"SUM(E47:F47)","v":456650.22572999995},319647.93639999995,137002.28932999997]
[null,null,"pohl.po spl.",{"$f":"SUM(E48:F48)","v":22237.358859999997},-19.181860000000007,22256.540719999997]

{"sheet":"Nezaplacené pohledávky-22","index":23,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,null,"      Nezaplacené pohledávky k ",null,null,null,null,{"$f":"dat_do","v":"2010-07-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zdrav.poj.","VZP",201,205,207,210,211,213,215,217,219,222,225]
["pohl.celk.",319647.93639999995,48456.043749999997,23232.884189999997,7037.9302099999995,0,3640.5184100000001,9667.4043499999989,0,43040.249489999995,0,0,0]
["pohl.po spl.",-19.181860000000007,20694.6715,12.08221,547.92674,0,25.524989999999999,137.41871000000003,0,659.54734999999994,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":2010}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"HV","Pohledávky","Závazky","Solventnost"]
[null,null,1,-21.357035850000145,487.52528856000026,584.1,{"$f":"SUM(E36-F36)","v":-96.57471143999976}]
[null,null,"1-2",-35.307570390000102,499.65068026000017,582.79999999999995,{"$f":"SUM(E37-F37)","v":-83.149319739999783}]
[null,null,"1-3",2.497680879999876,444.6882145400001,617.79999999999995,-173.11178545999985]
[null,null,"1-4",3.3624105799996853,452.51761081999996,569.20000000000005,-116.68238918000009]
[null,null,"1-5",22.042421579999687,489.95281828000009,546.70000000000005,-56.747181719999958]
[null,null,"1-6",45.177808809999469,518.79452829000002,572.6,-53.805471710000006]
[null,null,"1-7",59.181344309999467,484.99316413999992,541.70000000000005,-56.706835860000126]
[null,null,"1-8"]
[null,null,"1-9"]
[null,null,"1-10"]
[null,null,"1-11"]
[null,null,"1-12"]

{"sheet":"Nezap. pohled. FNOl - souhrn-24","index":25,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4]]}
["Nezaplacené pohledávky FN Olomouc"]
[{"$f":"CONCATENATE(\"k  \",DAY(dat_do),\".\",MONTH(dat_do),\".\",YEAR(dat_do))","v":"k  31.7.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":319667118.25999999},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D6","v":-19181.859999999993},{"$f":"C6+D6","v":319647936.39999998}]
[{"$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":27761372.25},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D7","v":20694671.5},48456043.75]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A8","v":205},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B8","v":"Hutnická zaměstnecká poj."},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C8","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D8","v":0},0]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A9","v":205},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B9","v":"Česká průmyslová zdravotní poj"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C9","v":23220801.98},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D9","v":12082.21},23232884.190000001]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A10","v":207},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B10","v":"Oborová zdr.poj.zam.bank a p."},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C10","v":6490003.4699999997},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D10","v":547926.74},7037930.21]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A11","v":209},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B11","v":"Zaměstnanecká poj.ŠKODA"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C11","v":42299.78},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D11","v":0},42299.78]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A12","v":211},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B12","v":"Zdr.poj.ministerstva vnitra CR"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C12","v":3614993.42},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D12","v":25524.989999999998},3640518.41]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A13","v":213},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B13","v":"Revirní bratrská pokladna"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C13","v":9529985.6399999987},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D13","v":137418.71000000002},9667404.3499999996]
[{"$f":"'Nezaplacené pohledávky FN Ol-20'!A15","v":222},{"$f":"'Nezaplacené pohledávky FN Ol-20'!B15","v":"Česká národní zdravotní pojiš."},{"$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":"Zdravotní pojišťovny MÉDIA"},{"$f":"'Nezaplacené pohledávky FN Ol-20'!C16","v":1705589.9299999997},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D16","v":179369.22},1884959.1499999997]
[{"$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":392032164.73000002},{"$f":"SUM(D6:D17)","v":21577811.509999998},{"$f":"SUM(E6:E17)","v":413609976.23999995}]
[null,"Pohledávky celkem (zaniklé ZP)",{"$f":"'Nezaplacené pohledávky FN Ol-20'!C36","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!D36","v":0},{"$f":"'Nezaplacené pohledávky FN Ol-20'!E36","v":0}]
[null,"Slovenské ZP",{"$f":"Slovenske_ZP_dospl","v":0},{"$f":"Slovenske_ZP_pospl","v":0},{"$f":"C20+D20","v":0}]
[null,"Pohledávky celkem",{"$f":"C18+C19+C20","v":392032164.73000002},{"$f":"D18+D19+D20","v":21577811.509999998},{"$f":"E18+E19+E20","v":413609976.23999995}]

{"sheet":"Vývojová řada nákladů-25","index":26,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vývojová řada nákladů "]
[null,null,null,null,null,{"$f":"CONCATENATE(\"v letech \",YEAR(dat_do)-2,\" - \",YEAR(dat_do))","v":"v letech 2008 - 2010"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-2)","v":"Ø 2008"},{"$f":"CONCATENATE(\"Ø \",YEAR(dat_do)-1)","v":"Ø 2009"},{"$f":"CONCATENATE(\"I.\",RIGHT(YEAR(dat_do),2))","v":"I.10"},{"$f":"CONCATENATE(\"II.\",RIGHT(YEAR(dat_do),2))","v":"II.10"},{"$f":"CONCATENATE(\"III.\",RIGHT(YEAR(dat_do),2))","v":"III.10"},{"$f":"CONCATENATE(\"IV.\",RIGHT(YEAR(dat_do),2))","v":"IV.10"},{"$f":"CONCATENATE(\"V.\",RIGHT(YEAR(dat_do),2))","v":"V.10"},{"$f":"CONCATENATE(\"VI.\",RIGHT(YEAR(dat_do),2))","v":"VI.10"},{"$f":"CONCATENATE(\"VII.\",RIGHT(YEAR(dat_do),2))","v":"VII.10"},{"$f":"CONCATENATE(\"VIII.\",RIGHT(YEAR(dat_do),2))","v":"VIII.10"},{"$f":"CONCATENATE(\"IX.\",RIGHT(YEAR(dat_do),2))","v":"IX.10"},{"$f":"CONCATENATE(\"X.\",RIGHT(YEAR(dat_do),2))","v":"X.10"},{"$f":"CONCATENATE(\"XI.\",RIGHT(YEAR(dat_do),2))","v":"XI.10"},{"$f":"CONCATENATE(\"XII.\",RIGHT(YEAR(dat_do),2))","v":"XII.10"}]
["Léky ",58886.609380833353,68993.114580833397,78495.006140000012,71186.890699999887,80842.443619999831,76333.765140000032,66361.097819999937,69338.447680000114,64438.471029999935]
["    z toho: VLV",25811.338088333338,5945.0256641666665,5053.2768400000004,5424.5941599999996,8187.9708200000005,7088.279160000001,4678.5980299999992,4152.8310199999996,3855.5020800000011]
["                 centra",7881.1863650000023,37807.690004999989,47050.635599999994,41008.531070000005,44071.487230000006,31723.046680000003,35348.362680000006,35252.72668,33612.308210000003]
["Krev",3422.3033625000025,4286.6305858333335,4347.0470800000003,3630.0563000000002,4678.1439600000003,5041.0309500000003,4738.4557999999997,5055.6057199999996,4648.6790600000004]
["SZM",48845.256045833492,57669.053428333173,63572.343459999996,77825.44716000004,86153.111780000065,64423.195440000003,49886.490439999972,52107.779639999993,46965.300409999982]
["Prodej LS",25951.585750833336,26661.976469999998,22922.720369999999,21967.742850000002,31104.056669999994,24944.325710000001,24541.690109999996,35313.173459999998,24421.07559]
["Os. náklady",115119.05588333332,125951.29197083003,132480.91122000004,130641.2670200002,130410.65382000015,133433.37318000023,137664.34390000027,133930.4073599999,153140.54258999988]
["Odpisy ",9957.4513783333332,22151.828583333336,22316.278999999999,23035.569,22676.62,22433.96,22394.881000000001,22461.587,22452.224999999999]
["Př. náklady",296000.58570250124,352482.24844916508,368454.98642999859,371761.2798099987,398939.40517999843,368650.44575999904,346620.25576999929,353560.89962999854,351831.27708999865]
[]
["*VLV = vliv lékové vyhlášky"]

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

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

{"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-7/2010"}]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových nákladů"]
["Náklady FN Olomouc v tis. Kč"]
["Léky ",506996]
["Krev",32139]
["SZM",440934]
["Potraviny",23906]
["Energie",67641]
["Osobní náklady",951701.49908998876]
["Odpisy",157771]
["Prodané zboží LS",185215]
["Ostatní",{"$f":"B17-SUM(B8:B15)","v":193515.05058004707}]
["Celkem",2559818.549670036]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Podíl ukazatelů z celkových výnosů"]
["Výnosy FN Olomouc v tis. Kč"]
["Provozní dotace",24726.141]
["Výkony pro zdr.poj.",2091261.7148500006]
["Aktivace",53676.761580000006]
["Tržby za léčiva",206313.24241999997]
["Ostatní výnosy",{"$f":"B38-SUM(B33:B36)","v":243022.03413000423}]
["Celkem",2618999.8939800048]

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