{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ГРД","Переменные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Дата","Визуализация","Время прихода на работу","Подпись","Время ухода  с работы","Подпись","Отработано времени за 1 день","Отработано времени с начала недели"]
[1,2,3,4,5,6,7,8]
["2018-04-01",{"$f":"IF(WEEKDAY(A3,2)=6,\"суббота\",IF(WEEKDAY(A3,2)=7,\"воскресенье\",A3))","v":"воскресенье"},{"$f":"IF(B3=\"суббота\",\"\",IF(B3=\"воскресенье\",\"\",\"8:35:00\"))","v":""},null,{"$f":"IF(B3=\"суббота\",\"\",IF(B3=\"воскресенье\",\"\",\"18:50:00\"))","v":""},null,{"$f":"IF(C3=\"\",\"\",IF(E3=\"\",\"\",(E3-C3)-Переменные!$A$2))","v":""},{"$f":"IF(G3=\"\",\"\",IF(G2=\"\",G3,G3+H2))","v":""}]
["2018-04-02","2018-04-02",{"$f":"IF(B4=\"суббота\",\"\",IF(B4=\"воскресенье\",\"\",\"8:35:00\"))","v":"8:35:00"},null,{"$f":"IF(B4=\"суббота\",\"\",IF(B4=\"воскресенье\",\"\",\"18:50:00\"))","v":"18:50:00"},null,{"$f":"IF(C4=\"\",\"\",IF(E4=\"\",\"\",(E4-C4)-Переменные!$A$2))","v":"09:30:00"},{"$f":"IF(G4=\"\",\"\",IF(G3=\"\",G4,G4+H3))","v":0.39583333333333331}]
["2018-04-03","2018-04-03","8:35:00",null,"18:50:00",null,{"$f":"IF(C5=\"\",\"\",IF(E5=\"\",\"\",(E5-C5)-Переменные!$A$2))","v":"09:30:00"},0.79166666666666663]
["2018-04-04","2018-04-04","8:35:00",null,"18:50:00",null,{"$f":"IF(C6=\"\",\"\",IF(E6=\"\",\"\",(E6-C6)-Переменные!$A$2))","v":"09:30:00"},1.1875]
["2018-04-05","2018-04-05","8:35:00",null,"18:50:00",null,{"$f":"IF(C7=\"\",\"\",IF(E7=\"\",\"\",(E7-C7)-Переменные!$A$2))","v":"09:30:00"},1.5833333333333333]
["2018-04-06","2018-04-06","8:35:00",null,"18:50:00",null,{"$f":"IF(C8=\"\",\"\",IF(E8=\"\",\"\",(E8-C8)-Переменные!$A$2))","v":"09:30:00"},1.9791666666666665]
["2018-04-07","суббота","",null,"",null,{"$f":"IF(C9=\"\",\"\",IF(E9=\"\",\"\",(E9-C9)-Переменные!$A$2))","v":""},""]
["2018-04-08","воскресенье","",null,"",null,{"$f":"IF(C10=\"\",\"\",IF(E10=\"\",\"\",(E10-C10)-Переменные!$A$2))","v":""},"",null,null,null,1]
["2018-04-09","2018-04-09","8:35:00",null,"18:50:00",null,{"$f":"IF(C11=\"\",\"\",IF(E11=\"\",\"\",(E11-C11)-Переменные!$A$2))","v":"09:30:00"},0.39583333333333331]
["2018-04-10","2018-04-10","8:35:00",null,"18:50:00",null,{"$f":"IF(C12=\"\",\"\",IF(E12=\"\",\"\",(E12-C12)-Переменные!$A$2))","v":"09:30:00"},0.79166666666666663]
["2018-04-11","2018-04-11","8:35:00",null,"18:50:00",null,{"$f":"IF(C13=\"\",\"\",IF(E13=\"\",\"\",(E13-C13)-Переменные!$A$2))","v":"09:30:00"},1.1875]
["2018-04-12","2018-04-12","8:35:00",null,"18:50:00",null,{"$f":"IF(C14=\"\",\"\",IF(E14=\"\",\"\",(E14-C14)-Переменные!$A$2))","v":"09:30:00"},1.5833333333333333]
["2018-04-13","2018-04-13","8:35:00",null,"18:50:00",null,{"$f":"IF(C15=\"\",\"\",IF(E15=\"\",\"\",(E15-C15)-Переменные!$A$2))","v":"09:30:00"},1.9791666666666665]
["2018-04-14","суббота","",null,"",null,{"$f":"IF(C16=\"\",\"\",IF(E16=\"\",\"\",(E16-C16)-Переменные!$A$2))","v":""},""]
["2018-04-15","воскресенье","",null,"",null,{"$f":"IF(C17=\"\",\"\",IF(E17=\"\",\"\",(E17-C17)-Переменные!$A$2))","v":""},""]
["2018-04-16","2018-04-16","8:35:00",null,"18:50:00",null,{"$f":"IF(C18=\"\",\"\",IF(E18=\"\",\"\",(E18-C18)-Переменные!$A$2))","v":"09:30:00"},0.39583333333333331]
["2018-04-17","2018-04-17","8:35:00",null,"18:50:00",null,{"$f":"IF(C19=\"\",\"\",IF(E19=\"\",\"\",(E19-C19)-Переменные!$A$2))","v":"09:30:00"},0.79166666666666663]
["2018-04-18","2018-04-18","8:35:00",null,"18:50:00",null,{"$f":"IF(C20=\"\",\"\",IF(E20=\"\",\"\",(E20-C20)-Переменные!$A$2))","v":"09:30:00"},1.1875]
["2018-04-19","2018-04-19","8:35:00",null,"18:50:00",null,{"$f":"IF(C21=\"\",\"\",IF(E21=\"\",\"\",(E21-C21)-Переменные!$A$2))","v":"09:30:00"},1.5833333333333333]
["2018-04-20","2018-04-20","8:35:00",null,"18:50:00",null,{"$f":"IF(C22=\"\",\"\",IF(E22=\"\",\"\",(E22-C22)-Переменные!$A$2))","v":"09:30:00"},1.9791666666666665]
["2018-04-21","суббота","",null,"",null,{"$f":"IF(C23=\"\",\"\",IF(E23=\"\",\"\",(E23-C23)-Переменные!$A$2))","v":""},""]
["2018-04-22","воскресенье","",null,"",null,{"$f":"IF(C24=\"\",\"\",IF(E24=\"\",\"\",(E24-C24)-Переменные!$A$2))","v":""},""]
["2018-04-23","2018-04-23","8:35:00",null,"18:50:00",null,{"$f":"IF(C25=\"\",\"\",IF(E25=\"\",\"\",(E25-C25)-Переменные!$A$2))","v":"09:30:00"},0.39583333333333331]
["2018-04-24","2018-04-24","8:35:00",null,"18:50:00",null,{"$f":"IF(C26=\"\",\"\",IF(E26=\"\",\"\",(E26-C26)-Переменные!$A$2))","v":"09:30:00"},0.79166666666666663]
["2018-04-25","2018-04-25","8:35:00",null,"18:50:00",null,{"$f":"IF(C27=\"\",\"\",IF(E27=\"\",\"\",(E27-C27)-Переменные!$A$2))","v":"09:30:00"},1.1875]
["2018-04-26","2018-04-26","8:35:00",null,"18:50:00",null,{"$f":"IF(C28=\"\",\"\",IF(E28=\"\",\"\",(E28-C28)-Переменные!$A$2))","v":"09:30:00"},1.5833333333333333]
["2018-04-27","2018-04-27","8:35:00",null,"18:50:00",null,{"$f":"IF(C29=\"\",\"\",IF(E29=\"\",\"\",(E29-C29)-Переменные!$A$2))","v":"09:30:00"},1.9791666666666665]
["2018-04-28","суббота","",null,"",null,{"$f":"IF(C30=\"\",\"\",IF(E30=\"\",\"\",(E30-C30)-Переменные!$A$2))","v":""},""]
["2018-04-29","воскресенье","",null,"",null,{"$f":"IF(C31=\"\",\"\",IF(E31=\"\",\"\",(E31-C31)-Переменные!$A$2))","v":""},""]
["2018-04-30","2018-04-30","8:35:00",null,"18:50:00",null,{"$f":"IF(C32=\"\",\"\",IF(E32=\"\",\"\",(E32-C32)-Переменные!$A$2))","v":"09:30:00"},0.39583333333333331]

{"sheet":"Переменные","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Продолжительность обеда"]
[3.125E-2]