{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["табель","input_table","Табель фио-пропуски"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,19],[8,20,9,20],[10,20,11,20],[0,0,0,20],[1,0,1,20],[2,0,2,20],[3,0,3,20],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,4,19],[4,20,6,20],[28,20,29,20],[30,20,31,20],[12,20,13,20],[8,0,13,0],[14,20,15,20],[26,0,31,0],[20,0,25,0],[14,0,19,0],[24,20,25,20],[26,20,27,20],[20,20,21,20],[22,20,23,20],[16,20,17,20],[18,20,19,20]]}
[1929]
[]
[]
[]
["№\nп/п","Наименование объекта   ","Описание ","ФИО\n   ","сентября 26.09.2020 / октября 25.10.2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итого\nдней"]
[null,null,null,null,26,27,28,29,30,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
[1,"скв.№1006-2","Оказание Услуг","Волк В.Ф.",1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,{"$f":"SUM(E9:T10)","v":2}]
[null,{"$f":"B9","v":"скв.№1006-2"},{"$f":"C9","v":"Оказание Услуг"},{"$f":"D9","v":"Волк В.Ф."},"x","x","x","x",1,"x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№1006-2","Простой из-за погодных условий","Волк В.Ф.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:T12)","v":0}]
[null,"скв.№1006-2",{"$f":"C11","v":"Простой из-за погодных условий"},"Волк В.Ф."]
[null,"скв.№1006-2","Простой по вине заказчика","Волк В.Ф.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:T14)","v":0}]
[null,"скв.№1006-2",{"$f":"C13","v":"Простой по вине заказчика"},"Волк В.Ф."]
[2,"скв.№1033-1","Оказание Услуг","Пяк У.Ц.",1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,{"$f":"SUM(E15:T16)","v":1}]
[null,{"$f":"B15","v":"скв.№1033-1"},{"$f":"C15","v":"Оказание Услуг"},{"$f":"D15","v":"Пяк У.Ц."},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№1033-1","Простой из-за погодных условий","Пяк У.Ц.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:T18)","v":0}]
[null,"скв.№1033-1",{"$f":"C17","v":"Простой из-за погодных условий"},"Пяк У.Ц."]
[null,"скв.№1033-1","Простой по вине заказчика","Пяк У.Ц.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:T20)","v":0}]
[null,"скв.№1033-1",{"$f":"C19","v":"Простой по вине заказчика"},"Пяк У.Ц."]
[3,"скв.№106-1","Оказание Услуг","Жук П.И.",1,1,1,1,1,1,1,1,1,1,1,"x","x","x","x",null,{"$f":"SUM(E21:T22)","v":12}]
[null,{"$f":"B21","v":"скв.№106-1"},{"$f":"C21","v":"Оказание Услуг"},{"$f":"D21","v":"Жук П.И."},"x",1,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№106-1","Простой из-за погодных условий","Жук П.И.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:T24)","v":0}]
[null,"скв.№106-1",{"$f":"C23","v":"Простой из-за погодных условий"},"Жук П.И."]
[null,"скв.№106-1","Простой по вине заказчика","Жук П.И.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:T26)","v":0}]
[null,"скв.№106-1",{"$f":"C25","v":"Простой по вине заказчика"},"Жук П.И."]
[4,"скв.№1073","Оказание Услуг","Иванов А.А.","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,{"$f":"SUM(E27:T28)","v":2}]
[null,{"$f":"B27","v":"скв.№1073"},{"$f":"C27","v":"Оказание Услуг"},{"$f":"D27","v":"Иванов А.А."},"x","x","x","x","x",1,1,"x","x","x","x","x","x","x","x"]
[null,"скв.№1073","Простой из-за погодных условий","Иванов А.А.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:T30)","v":0}]
[null,"скв.№1073",{"$f":"C29","v":"Простой из-за погодных условий"},"Иванов А.А."]
[null,"скв.№1073","Простой по вине заказчика","Иванов А.А.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:T32)","v":0}]
[null,"скв.№1073",{"$f":"C31","v":"Простой по вине заказчика"},"Иванов А.А."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U9:U32)","v":17}]

{"sheet":"input_table","index":1,"n_rows":27,"n_cols":34,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[1929]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34]
["№\nп/п","Наименование объекта   ","Описание ","ФИО\n   ","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25"]
[1,"скв.№1006-2","Оказание Услуг","Волк В.Ф.",1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",1,"x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№1006-2","Оказание Услуг","Волк В.Ф."]
[null,"скв.№1006-2","Простой из-за погодных условий","Волк В.Ф."]
[null,"скв.№1006-2","Простой из-за погодных условий","Волк В.Ф."]
[null,"скв.№1006-2","Простой по вине заказчика","Волк В.Ф."]
[null,"скв.№1006-2","Простой по вине заказчика","Волк В.Ф."]
[2,"скв.№1033-1","Оказание Услуг","Пяк У.Ц.",1,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№1033-1","Оказание Услуг","Пяк У.Ц."]
[null,"скв.№1033-1","Простой из-за погодных условий","Пяк У.Ц."]
[null,"скв.№1033-1","Простой из-за погодных условий","Пяк У.Ц."]
[null,"скв.№1033-1","Простой по вине заказчика","Пяк У.Ц."]
[null,"скв.№1033-1","Простой по вине заказчика","Пяк У.Ц."]
[3,"скв.№106-1","Оказание Услуг","Жук П.И.",1,1,1,1,1,1,1,1,1,1,1,"x","x","x","x","x",1,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"скв.№106-1","Оказание Услуг","Жук П.И."]
[null,"скв.№106-1","Простой из-за погодных условий","Жук П.И."]
[null,"скв.№106-1","Простой из-за погодных условий","Жук П.И."]
[null,"скв.№106-1","Простой по вине заказчика","Жук П.И."]
[null,"скв.№106-1","Простой по вине заказчика","Жук П.И."]
[4,"скв.№1073","Оказание Услуг","Иванов А.А.","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",1,1,"x","x","x","x","x","x","x","x"]
[null,"скв.№1073","Оказание Услуг","Иванов А.А."]
[null,"скв.№1073","Простой из-за погодных условий","Иванов А.А."]
[null,"скв.№1073","Простой из-за погодных условий","Иванов А.А."]
[null,"скв.№1073","Простой по вине заказчика","Иванов А.А."]
[null,"скв.№1073","Простой по вине заказчика","Иванов А.А."]

{"sheet":"Табель фио-пропуски","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Табель пропущенных дней"]
["№ п/п","ФИО","Не работал","Итого дней отсутствия"]
[1,2,3,4]
[1,"Волк В.Ф."," 27.10.2020, 28.10.2020, 29.10.2020, 30.10.2020, 01.11.2020, 02.11.2020, 03.11.2020, 04.11.2020, 05.11.2020, 06.11.2020, 07.11.2020, 08.11.2020, 09.11.2020, 10.11.2020, 11.11.2020, 12.11.2020, 13.11.2020, 14.11.2020, 16.11.2020, 17.11.2020, 18.11.2020, 19.11.2020, 20.11.2020, 21.11.2020, 22.11.2020, 23.11.2020, 24.11.2020, 25.11.2020, ",28]
[2,"Пяк У.Ц."," 27.10.2020, 28.10.2020, 29.10.2020, 30.10.2020, 01.11.2020, 02.11.2020, 03.11.2020, 04.11.2020, 05.11.2020, 06.11.2020, 07.11.2020, 08.11.2020, 09.11.2020, 10.11.2020, 11.11.2020, 12.11.2020, 13.11.2020, 14.11.2020, 15.11.2020, 16.11.2020, 17.11.2020, 18.11.2020, 19.11.2020, 20.11.2020, 21.11.2020, 22.11.2020, 23.11.2020, 24.11.2020, 25.11.2020, ",29]
[3,"Жук П.И."," 07.11.2020, 08.11.2020, 09.11.2020, 10.11.2020, 11.11.2020, 13.11.2020, 14.11.2020, 15.11.2020, 16.11.2020, 17.11.2020, 18.11.2020, 19.11.2020, 20.11.2020, 21.11.2020, 22.11.2020, 23.11.2020, 24.11.2020, 25.11.2020, ",18]
[4,"Иванов А.А."," 26.10.2020, 27.10.2020, 28.10.2020, 29.10.2020, 30.10.2020, 01.11.2020, 02.11.2020, 03.11.2020, 04.11.2020, 05.11.2020, 06.11.2020, 07.11.2020, 08.11.2020, 09.11.2020, 10.11.2020, 11.11.2020, 12.11.2020, 13.11.2020, 14.11.2020, 15.11.2020, 18.11.2020, 19.11.2020, 20.11.2020, 21.11.2020, 22.11.2020, 23.11.2020, 24.11.2020, 25.11.2020, ",28]