{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["základní data","To_XML","vysvetlivky","List1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"základní data","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["13- MÍSTNÝ EAN RUT ODESÍLATELE[povinné]","ID zprávy v hlavičce(max 35 znaků)[nepovinné]"]
["8591824012348","registrace test"]

{"sheet":"To_XML","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,4,0,9]]}
[null,null,null,null,"- vygenerované xml nutné nahrát do portálu OTE - CDS - Upload souboru"]
["název OPM","ID OPM (EAN 18)","sousední OPM","Síť","Napěťová úroveň","Typ měření","kategorie měření","registrovat od","registrovat do","Odhad roční spotřeby","Třída TDD","Teplotní oblast","počet fází","hodnota hlavního jističe[A]","rezervovaný příkon","distribuční sazba","kategorie odběru","město","Ulice","Číslo domu ","Poštovní směrovací číslo "]
["test1","859182466660000007",null,"6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","3","75","1000","VO"]
["test2","859182466660000014","859182466660000069","6666","0,4","C","C3","2019-04-30","9999-12-31","-2200","5","8","1","25"]
["test3","859182466660000021",null,"6666","0,4","C","C2","2019-04-30","9999-12-31","-2200","1","9","3","75"]
["test4","859182466660000038",null,"6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","1","25"]
["test5","859182466660000045",null,"6666","0,4","C","C1","2019-04-30","9999-12-31","-2200","1","9","3","75"]
["test6","859182466660000052",null,"6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","1","25"]
["test7","859182466660000069",null,"6666","220","A",null,"2019-04-30","9999-12-31"]
["test8","859182466660000076",null,"6666","400","A",null,"2019-04-30","9999-12-31"]
["test9","859182466660000083",null,"6666","0,4","C","C1","2019-04-30","9999-12-31","-2200","1","9","3","75"]
["test10","859182466660000090","859182466660000113","6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","1","25"]
["test11","859182466660000106",null,"6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","3","75"]
["test12","859182466660000113",null,"6666","0,4","C","C4","2019-04-30","9999-12-31","-2200","1","9","1","25"]
["test13","859182466660000120",null,"6666","0,4","B",null,"2019-04-30","9999-12-31",null,null,null,"1","75"]
["test14","859182466660000137",null,"6666","22","B",null,"2019-04-30","9999-12-31"]

{"sheet":"vysvetlivky","index":2,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,0,23,0],[22,1,23,1],[22,3,23,3],[0,4,0,5],[15,0,16,0],[15,1,16,1],[15,3,16,3],[17,0,18,0],[17,1,18,1],[17,3,18,3]]}
["napěťové úrovně [kV]",null,"typ měření",null,"teplotní oblast *",null,null,"počet fází",null,"distribuční sazba",null,"kategorie odběru"]
[400,null,"A",null,"1","Jižní čechy",null,1,null,"C01D",null,"MOP"]
[220,null,"B",null,"2","Jižní morava",null,3,null,"C02D",null,"MOO"]
[110,null,"C",null,"3","Praha",null,null,null,"C03D",null,"VO"]
[35,null,null,null,"4","Severní čechy",null,null,null,"C25D",null,"VYR"]
[22,null,"kategorie měření C",null,"5","Severní morava",null,null,null,"C26D"]
[10,null,"C1",null,"6","Střední čechy",null,null,null,"C27D"]
[6,null,"C2",null,"7","Východní čechy",null,null,null,"C35D"]
[3,null,"C3",null,"8","Západní čechy",null,null,null,"C45D"]
[0.4,null,"C4",null,"9","Česká republika",null,null,null,"C46D"]
[null,null,null,null,"* Pouze pro TDD 5 je teplotní oblast dle regionu 1 – 8.\n\n",null,null,null,null,"C55D"]
[null,null,null,null,"   Ostatní třídy TDD mají teplotní oblast 9",null,null,null,null,"C56D"]
[null,null,null,null,null,null,null,null,null,"C62D"]
["třída TDD","typ zákazníka","charakter odběru","pevné ceny distribuce podle cenového rozhodnutí Úřadu",null,null,null,null,null,"D01D"]
[1,"Odběratel kategorie C","- odběratel bez tepelného využití elektřiny","- C01d; C02d; C03d",null,null,null,null,null,"D02D"]
[2,"Odběratel kategorie C","- odběr s akumulačním spotřebičem","- C25d; C26d; C27d; C35d",null,null,null,null,null,"D25D"]
[null,null,"- odběr s hybridním vytápěním",null,null,null,null,null,null,"D26D"]
[3,"Odběratel kategorie C","- odběr s přímotopným systémem vytápění","- C45d; C46d; C56d",null,null,null,null,null,"D27D"]
[null,null,"- odběr s tepelným čerpadlem",null,null,null,null,null,null,"D35D"]
[4,"Odběratel kategorie D","- odběr bez tepelného využití elektřiny","- D01d; D02d; D61d",null,null,null,null,null,"D45D"]
[5,"Odběratel kategorie D","- odběr s akumulačním spotřebičem","- D25d; D26d; D27d",null,null,null,null,null,"D55D"]
[6,"Odběratel kategorie D","- odběr s hybridním vytápěním","- D35d",null,null,null,null,null,"D56D"]
[7,"Odběratel kategorie D","- odběr s přímotopným systémem vytápění","- D45d; D55d; D56d; D57d",null,null,null,null,null,"D57D"]
[null,null,"- odběr s tepelným čerpadlem",null,null,null,null,null,null,"D61D"]
[8,"Odběratel kategorie C","- odběr pro veřejné osvětlení","- C62d",null,null,null,null,null,"VO"]
[null,null,null,null,null,null,null,null,null,"VYR"]

{"sheet":"List1","index":3,"n_rows":2,"n_cols":43,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["OPM_OPM","OPM_inv_id","OPM_inv_per_from","OPM_inv_per_to","OPM_contract_type","OPM_qty_VT","OPM_qty_NT","OPM_status","DataMO_am_enVT","DataMO_am_enNT","DataMO_am_rescap","DataMO_am_renresource","DataMO_am_sysservice","DataMO_am_oteservice","DataMO_am_distservice","DataMO_qty_prod","DataMO_am_mrdservice","METER_id","METER_inv_per_from","METER_inv_per_to","METER_prim_multiplier","METER_mr_readVTs","METER_mr_readVTe","METER_qtyVT","METER_mr_readNTs","METER_mr_readNTe","METER_qtyNT","METER_mr_addbillVT","METER_mr_addbillNT","METER_mr_status","PriceMO_dist_rate_type","PriceMO_cir_breaker","PriceMO_num_phase","PriceMO_inv_per_from","PriceMO_inv_per_to","item_inv_per_from","item_inv_per_to","item_type","item_qty","item_unit_price","item_price","item_bill_relevant","item_descript"]
["id","inv_id","inv-per-from","inv-per-to","contract-type","qty-VT","qty-NT","status","am-enVT","am-enNT","am-rescap","am-renresource","am-sysservice","am-oteservice","am-distservice","qty-prod","am-mrdservice","id","inv-per-from","inv-per-to","prim-multiplier","mr-readVTs","mr-readVTe","qtyVT","mr-readNTs","mr-readNTe","qtyNT","mr-addbillVT","mr-addbillNT","mr-status","dist-rate-type","cir-breaker","num-phase","inv-per-from","inv-per-to","inv-per-from","inv-per-to","type","qty","unit-price","price","bill-relevant","descript"]