{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Графік","Босс","Розрахунки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Графік","index":0,"n_rows":26,"n_cols":39,"rows_kept":26,"cut":false,"hidden":false,"merged":[[30,0,30,34],[32,19,32,21],[32,24,32,25],[5,0,5,21],[5,22,5,24],[5,28,5,29],[20,1,20,19],[20,20,20,22],[20,25,20,26]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-10"]
["Погоджено:",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,{"$f":"НАЗМЕСЯЦ2(Q1)","v":"жовтень"},null,null,null,"місяць",null,2021,null,"   року",null,{"$f":"IF(W6=\"січень\",Розрахунки!B4,IF(W6=\"лютий\",Розрахунки!B5,IF(W6=\"березень\",Розрахунки!B6,IF(W6=\"квітень\",Розрахунки!B7,IF(W6=\"травень\",Розрахунки!B8,IF(W6=\"червень\",Розрахунки!B9,IF(W6=\"липень\",Розрахунки!B10,IF(W6=\"серпень\",Розрахунки!B11,IF(W6=\"вересень\",Розрахунки!B12,IF(W6=\"жовтень\",Розрахунки!B13,IF(W6=\"листопад\",Розрахунки!B14,IF(W6=\"грудень\",Розрахунки!B15))))))))))))","v":159}]
["Прізвище І.П.",{"$f":"DATE(AC6,$Q$1,1)","v":"2021-10-01"},{"$f":"B7+1","v":"2021-10-02"},"2021-10-03",{"$f":"D7+1","v":"2021-10-04"},"2021-10-05","2021-10-06","2021-10-07","2021-10-08","2021-10-09","2021-10-10","2021-10-11","2021-10-12","2021-10-13","2021-10-14","2021-10-15","2021-10-16","2021-10-17","2021-10-18","2021-10-19","2021-10-20","2021-10-21","2021-10-22","2021-10-23","2021-10-24","2021-10-25","2021-10-26","2021-10-27","2021-10-28","2021-10-29","2021-10-30","2021-10-31","годин","підпис","ознайо\nмлен."]
["Перший",1.75,"3/","3/",1.75,1.75,1.75,null,1.5,"/3","/3",1.5,1.5,1.5,null,"3/","3/","3/",1.75,1.75,1.75,null,1.5,1.5,"/3",1.5,1.5,1.5,null,1.75,"3/","3/",{"$f":"SUM(B8:AF8)+COUNTIF(B8:AF8,\"/3\")*3+COUNTIF(B8:AF8,\"3/\")*3","v":57.5}]
["Другий",1.5,"/3","/3",1.5,1.5,1.5,null,1.75,"3/","3/",1.75,1.75,1.75,null,"/3","/3","/3",1.5,1.5,1.5,null,1.75,1.75,"3/",1.75,1.75,1.75,null,1.5,"/3","/3",{"$f":"SUM(B9:AF9)+COUNTIF(B9:AF9,\"/3\")*3+COUNTIF(B9:AF9,\"3/\")*3","v":57.75}]
["Третій",null,"3/","3/",1.75,1.75,1.75,1.75,null,"/3","/3",1.5,1.5,1.5,"/3",null,"3/","3/",1.75,1.75,1.75,1.75,null,1.75,"/3",1.5,1.5,1.5,1.5,null,"3/","3/",56.25]
["Четвертий",null,"3/","3/",1.5,1.5,1.5,1.5,null,"/3","/3",1.5,1.5,1.5,"/3",null,"3/","3/",1.75,1.75,1.75,1.75,null,1.75,"3/",1.5,1.5,1.5,1.5,null,"/3","/3",{"$f":"SUM(B11:AF11)+COUNTIF(B11:AF11,\"/3\")*3+COUNTIF(B11:AF11,\"3/\")*3","v":55.25}]
["П'ятий",1.5,"/3","/3",1.5,1.5,1.5,null,1.75,"3/","3/",1.75,1.75,1.75,null,"/3","/3","/3",1.5,1.5,1.5,null,1.5,1.5,"3/",1.75,1.75,1.75,null,1.5,"/3","/3",{"$f":"SUM(B12:AF12)+COUNTIF(B12:AF12,\"/3\")*3+COUNTIF(B12:AF12,\"3/\")*3","v":57.25}]
["Шостий",1.5,"/3","/3",1.5,null,1.75,1.75,1.75,"3/","3/",1.75,null,1.5,"/3","/3","/3","/3",1.5,null,1.75,1.75,1.75,1.5,"3/",1.75,null,1.5,1.5,1.5,"/3","/3",59]
["Сьомий",1.75,"/3","/3",null,1.5,1.5,1.5,null,"3/","3/",null,1.75,1.75,"3/","3/","3/","3/",null,1.5,1.5,1.5,1.5,1.5,"/3",null,1.75,1.75,1.75,1.75,"3/","3/",57.25]
["ДЕНЬ",{"$f":"COUNTIF(B8:B14,1.75)+COUNTIF(B8:B14,\"3/\")","v":2},{"$f":"COUNTIF(C8:C14,1.75)+COUNTIF(C8:C14,\"3/\")","v":3},3,2,2,3,2,3,4,4,3,3,3,1,2,4,4,3,3,4,3,2,3,4,3,3,3,1,2,3,3]
["НОЧЬ",{"$f":"COUNTIF(B8:B14,1.5)+COUNTIF(B8:B14,\"/3\")","v":3},{"$f":"COUNTIF(C8:C14,1.5)+COUNTIF(C8:C14,\"/3\")","v":4},4,4,4,4,2,1,3,3,3,3,4,3,3,3,3,3,3,3,1,3,4,3,3,3,4,3,3,4,4]
[null,"1,75; з 24:00 до 07:00;  1,5 з 18:00 до 24:00;  3/ з 24:00 до 12:00;  /3 з 12:00т до 24:00;  6 з 24:00 до 0:00",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,"/3",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,11,null,8]

{"sheet":"Босс","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Розрахунки","index":2,"n_rows":31,"n_cols":33,"rows_kept":31,"cut":false,"hidden":true,"merged":[[14,1,14,3],[14,4,14,6],[14,42,14,43],[15,42,15,43],[16,42,16,43],[12,1,12,3],[12,4,12,6],[12,42,12,43],[13,1,13,3],[13,4,13,6],[13,42,13,43],[10,40,10,41],[10,42,10,43],[11,1,11,3],[11,4,11,6],[11,42,11,43],[8,1,8,3],[8,4,8,6],[9,1,9,3],[9,4,9,6],[10,1,10,3],[10,4,10,6],[22,2,22,32],[25,0,25,33],[0,0,0,6],[1,0,1,6],[2,1,2,3],[2,4,2,6],[3,1,3,3],[3,4,3,6],[4,1,4,3],[4,4,4,6],[5,1,5,3],[5,4,5,6],[6,1,6,3],[6,4,6,6],[7,1,7,3],[7,4,7,6]]}
[2021,null,null,null,null,null,null,null,"в","б"]
["Норма Часу"]
[null,"Монтери",null,null,"Машиністи"]
[1,151,null,null,157]
[2,160,null,null,160]
[3,176,null,null,174]
[4,175,null,null,173]
[5,144,null,null,152]
[6,160,null,null,159]
[7,176,null,null,179]
[8,167,null,null,166]
[9,176,null,null,174]
[10,159,null,null,164]
[11,176,null,null,174]
[12,174,null,null,174]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Додаткові вихідні"]
[null,null,{"$f":"Графік!B7","v":"2021-10-01"},{"$f":"Графік!C7","v":"2021-10-02"},{"$f":"Графік!D7","v":"2021-10-03"},{"$f":"Графік!E7","v":"2021-10-04"},{"$f":"Графік!F7","v":"2021-10-05"},{"$f":"Графік!G7","v":"2021-10-06"},{"$f":"Графік!H7","v":"2021-10-07"},{"$f":"Графік!I7","v":"2021-10-08"},{"$f":"Графік!J7","v":"2021-10-09"},{"$f":"Графік!K7","v":"2021-10-10"},{"$f":"Графік!L7","v":"2021-10-11"},{"$f":"Графік!M7","v":"2021-10-12"},{"$f":"Графік!N7","v":"2021-10-13"},{"$f":"Графік!O7","v":"2021-10-14"},{"$f":"Графік!P7","v":"2021-10-15"},{"$f":"Графік!Q7","v":"2021-10-16"},{"$f":"Графік!R7","v":"2021-10-17"},{"$f":"Графік!S7","v":"2021-10-18"},{"$f":"Графік!T7","v":"2021-10-19"},{"$f":"Графік!U7","v":"2021-10-20"},{"$f":"Графік!V7","v":"2021-10-21"},{"$f":"Графік!W7","v":"2021-10-22"},{"$f":"Графік!X7","v":"2021-10-23"},{"$f":"Графік!Y7","v":"2021-10-24"},{"$f":"Графік!Z7","v":"2021-10-25"},{"$f":"Графік!AA7","v":"2021-10-26"},{"$f":"Графік!AB7","v":"2021-10-27"},{"$f":"Графік!AC7","v":"2021-10-28"},{"$f":"Графік!AD7","v":"2021-10-29"},{"$f":"Графік!AE7","v":"2021-10-30"},{"$f":"Графік!AF7","v":"2021-10-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В","В",null,null,null,null,null,null,null,"Б"]
["Щоб в графіку відображався додатковий вихідний, треба поставити букву \"В\" (нашу) під числом місяця,\nа коли треба поставити додатковий робочий день, ставим \"Б\" під числом місяця"]
[]
[]
[]
[]
["Формула графика дежурств =СУММ(B8:AF8)+СЧЁТЕСЛИ(B8:AF8;\"/3\")*3+СЧЁТЕСЛИ(B8:AF8;\"3/\")*3"]