{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MOST","Elrendelő"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"MOST","index":0,"n_rows":27,"n_cols":36,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,24,23,32],[25,7,26,7],[22,14,23,22],[2,17,2,23],[2,13,2,15],[22,23,23,23],[25,10,25,16],[26,10,26,16]]}
[null,null,null,null,null,null,"Szolgálati beosztás - jelentés"]
[1]
[null,null,0,null,null,null,null,null,null,null,null,null,null," 2016.",null,null,null,"Augusztus"]
[]
[null,null,"Azonosító sz.",null,"NÉV","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze","Cs","P","Szo","V","H","K","Sze"]
[null,null,null,null,null,"2017-12-01","2017-12-02","2017-12-03","2017-12-04","2017-12-05","2017-12-06","2017-12-07","2017-12-08","2017-12-09","2017-12-10","2017-12-11","2017-12-12","2017-12-13","2017-12-14","2017-12-15","2017-12-16","2017-12-17","2017-12-18","2017-12-19","2017-12-20","2017-12-21","2017-12-22","2017-12-23","2017-12-24","2017-12-25","2017-12-26","2017-12-27","2017-12-28","2017-12-29","2017-12-30","2017-12-31"]
[]
[1,"karbantartó",11111,null,"Kiss Ádám",null,"SZN","SZÉ",null,"TP","SZN","SZÉ","TP","TP","TZ","Év",null,"Nv","N","eP",null,"Nv","Epv","Év","TP","EP",null,"Év",null,"EP","Nv","Év","TP","TP","Nv","T2"]
[2,"mérnök",22222,null,"Tóth József","TP","B","B",null,"TP","B","B","TP","TP","TZ","B",null,null,"B","B",null,null,"B","B","TP","TP","B","B",null,null,"B","B","TP","TP","B","B"]
[3,"takarító",35343,null,"Fodor Tamás","eP",null,"Nv","É","TP","TP","Epv","Év",null,null,"N","É","TP","Epv","Nv","É",null,null,"Nv","füÉv","TP","TP","Nv","Év","eP","TP","Nv","Év","eP",null,"Nv"]
[4,"takarító",5467,null,"Nagy Csaba",null,null,"Nv","Év","TP","TP","TZ","SZÉ",null,null,"Nv","Év","eP","TP","N","É",null,null,"N","füÉ","TP","TP","N","É","TP","TP","N","É",null,null,"N"]
[5,"mérnök",345632,null,"Kovács Anna","B","TP","TP","B","B","TP","TP","B","B",null,null,"B","B","B",null,"TZ","É",null,null,"FÜN",null,"TP","TP","B","B","TP","TP","B","B"]
[6,"szerelő",34562,null,"Szép Ilona","Év","TP","TP","Nv","SZÉ","TP","TP","SZN","SZÉ",null,null,"Nv","Év","É",null,"Epv","Év",null,null,"FÜNv",null,"EP","TP","Nv","Év","TP","TP","Nv","Év"]
[7,"szerelő",56754,null,"Szabó Gábor",null,"Év","TP","TP","Nv","Év","TP","Nv","Nv","Év","eP",null,"eP","SZÉ","TP",null,"SZN","SZÉ","TP","TP","Nv","Év",null,"EP","Nv","Év","TP","EP","Nv","Év"]
[8,"karbantartó",74363,null,"Horváth Péter","eP","É","TP","TP","N","É","TP","N","N","É",null,"N","EP","É","TP",null,"N","É","TP","TP","N","É",null,null,"N","É","TP","EP",null,"É"]
[9]
[10]
[11]
[12]
[13]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e :elvett szabadnap túlóra Éjjel",null,null,null,null,null,null,null,null,null,"E :elvett szabadnap túlóra Nappal"]
[]
[]
[null,null,null,null,null,null,null,"FÜ",null,"TP","P:Pihenőnap"]
[null,null,null,null,null,null,null,null,null,"TZ","Z:Töblet szabadnap"]

{"sheet":"Elrendelő","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[26,5,26,6],[26,14,26,15],[13,10,13,15],[14,10,14,15],[15,1,15,2],[15,3,15,6],[15,10,15,11],[15,12,15,15],[13,1,13,6],[10,10,10,15],[11,1,11,6],[11,10,11,15],[12,1,12,6],[12,10,12,15],[10,1,10,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Túlóra elrendelő lap",null,null,null,null,null,null,null,null,"Túlóra elrendelő lap"]
[]
["Név:","Kiss Ádám",null,null,null,null,null,null,null,"Név:",{"$f":"B11","v":"Kiss Ádám"}]
["HR azonosító szám:",{"$f":"INDEX(MOST!C8:C20, MATCH(B11,nevek,0))","v":11111},null,null,null,null,null,null,null,"HR azonosító szám:",{"$f":"B12","v":11111}]
["Munkakör:",{"$f":"INDEX(MOST!B8:B20, MATCH(B11,nevek,0))","v":"karbantartó"},null,null,null,null,null,null,null,"Munkakör:",{"$f":"B13","v":"karbantartó"}]
["Elrendelés oka:",null,null,null,null,null,null,null,null,"Elrendelés oka:",{"$f":"IF(B14>0,B14,\"\")","v":""}]
["Túlmunka időpontja:",null,null,null,null,null,null,null,null,"Túlmunka időpontja:",{"$f":"IF(B15>0,B15,\"\")","v":""}]
["Túlmunka fajtája*","túlóra",null,"elvont pihenőnap 100 %",null,null,null,null,null,"Túlmunka fajtája*","túlóra",null,"elvont pihenőnap 100 %"]
["* megfelelő aláhúzása",null,null,null,null,null,null,null,null,"* megfelelő aláhúzása"]