{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Pojišťovny"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data","index":0,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[0,0,0,5],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2]]}
["PROMOFAKTURA"]
[]
[]
["DODAVATEL:",null,null,null,null,"ODBĚRATEL:"]
[null,null,null,null,null,211]
["Lékárna Fakultní nemocnice Olomouc ",null,null,null,null,{"$f":"VLOOKUP(F$5,Pojišťovny!A:G,2,0)","v":"ZP Ministerstva vnitra ČR"}]
["I. P. Pavlova 6 ",null,null,null,null,{"$f":"VLOOKUP(F$5,Pojišťovny!A:G,3,0)","v":"Jeremenkova 42A"}]
["775 20 Olomouc ",null,null,null,null,{"$f":"VLOOKUP(F$5,Pojišťovny!A:G,5,0)& \" \" &VLOOKUP(F$5,Pojišťovny!A:G,4,0)","v":"772 11 Olomouc"}]
["IČ: 00098892",null,null,null,null,{"$f":"\"IČ: \" &VLOOKUP(F$5,Pojišťovny!A:G,6,0)","v":"IČ: 47114304"}]
["DIČ: CZ00098892",null,null,null,null,{"$f":"\"DIČ: \" &VLOOKUP(F$5,Pojišťovny!A:G,7,0)","v":"DIČ: CZ47114304"}]
[]
["Datum vystavení:",null,{"$f":"TODAY()","v":"2023-01-09"}]
["RČ pacienta:",null,1359090557]
[]
[]
["Název léku",null,null,"Cena/ks","Množství","Cena celkem"]
["Materiál dle přílohy",null,null,4500.37,1,{"$f":"IF(E17=\"\",\"\",E17*D17)","v":4500.37}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
["Celkem",null,null,null,{"$f":"SUM(E17:E43)","v":1},{"$f":"SUM(F17:F43)","v":4500.37}]
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2023-01-09"}]

{"sheet":"Pojišťovny","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["pojistovna","nazev","ulice","mesto","psc","ico","dic"]
[111,"VZP ČR OP Olomouc","Lazecká 22a","Olomouc","772 11","41197518","CZ41197518"]
[211,"ZP Ministerstva vnitra ČR","Jeremenkova 42A","Olomouc","772 11","47114304","CZ47114304"]
[201,"Vojenská zdravotní pojišťovna ČR","U Botanické zahrady 11","Olomouc 9","779 00","47114975","CZ47114975"]
[205,"Česká průmyslová zdravotní pojišťovna","Jeremenkova 11","Ostrava 3","703 00","47672234","CZ47672234"]
[207,"Oborová zdravotní pojišťovna","Roškotova 1225/1","Praha 4","140 44","47114321","CZ47114321"]
[209,"Zaměstnanecká poj. ŠKODA","Husova 302/5","Mladá Boleslav 1","293 01","46354182","CZ46354182"]
[213,"Revírní bratrská pokladna","Michálkovická 108","Ostrava","710 00","47673036","CZ47673036"]
[217,"ZP METAL-Aliance Divize Morava","Erbenova 11","Olomouc 9","779 00","48703893","CZ48703893"]
[211,"ZP Ministerstvo vnitra ČR EU","U Výstaviště 17","Praha 7","17042","47114304","CZ47114304"]
[999,"Samoplátce"]