{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Исходник","Формирование табеля по сотр."],"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":119,"n_cols":8,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"A1+1","v":2},{"$f":"B1+1","v":3},4,5,6,7,8]
["Справка \"Контроль посещаемости\"",null,null,null,null,"10:00:00","19:00:00"]
["ФИО  ","Дата  ","Вход  ","Выход  ","Общее время  ","Опоздание","Ранний уход","Столбец1"]
["Иванов И И ","2019.01.08","10:38:48","17:36:12",{"$f":"D4-C4","v":"06:57:24"},{"$f":"IF(C4>$F$2,1,0)","v":1},{"$f":"IF(D4>$G$2,0,1)","v":1},{"$f":"EOMONTH(B4,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.09","10:02:55","19:17:06",{"$f":"D5-C5","v":"09:14:11"},{"$f":"IF(C5>$F$2,1,0)","v":1},{"$f":"IF(D5>$G$2,0,1)","v":0},{"$f":"EOMONTH(B5,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.10","09:54:52","19:11:00",{"$f":"D6-C6","v":"09:16:08"},{"$f":"IF(C6>$F$2,1,0)","v":0},{"$f":"IF(D6>$G$2,0,1)","v":0},{"$f":"EOMONTH(B6,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.11","10:04:01","19:15:05",{"$f":"D7-C7","v":"09:11:04"},{"$f":"IF(C7>$F$2,1,0)","v":1},{"$f":"IF(D7>$G$2,0,1)","v":0},{"$f":"EOMONTH(B7,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.12","10:13:42","15:17:07",{"$f":"D8-C8","v":"05:03:25"},{"$f":"IF(C8>$F$2,1,0)","v":1},{"$f":"IF(D8>$G$2,0,1)","v":1},{"$f":"EOMONTH(B8,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.14","09:49:04","19:01:00",{"$f":"D9-C9","v":"09:11:56"},{"$f":"IF(C9>$F$2,1,0)","v":0},{"$f":"IF(D9>$G$2,0,1)","v":0},{"$f":"EOMONTH(B9,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.15","08:41:27","19:18:37",{"$f":"D10-C10","v":"10:37:10"},{"$f":"IF(C10>$F$2,1,0)","v":0},{"$f":"IF(D10>$G$2,0,1)","v":0},{"$f":"EOMONTH(B10,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.16","09:56:39","19:10:22",{"$f":"D11-C11","v":"09:13:43"},{"$f":"IF(C11>$F$2,1,0)","v":0},{"$f":"IF(D11>$G$2,0,1)","v":0},{"$f":"EOMONTH(B11,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.17","09:58:48","19:13:51",{"$f":"D12-C12","v":"09:15:03"},{"$f":"IF(C12>$F$2,1,0)","v":0},{"$f":"IF(D12>$G$2,0,1)","v":0},{"$f":"EOMONTH(B12,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.18","08:47:01","19:18:03",{"$f":"D13-C13","v":"10:31:02"},{"$f":"IF(C13>$F$2,1,0)","v":0},{"$f":"IF(D13>$G$2,0,1)","v":0},{"$f":"EOMONTH(B13,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.21","09:56:18","19:08:15",{"$f":"D14-C14","v":"09:11:57"},{"$f":"IF(C14>$F$2,1,0)","v":0},{"$f":"IF(D14>$G$2,0,1)","v":0},{"$f":"EOMONTH(B14,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.22","10:06:16","19:32:48",{"$f":"D15-C15","v":"09:26:32"},{"$f":"IF(C15>$F$2,1,0)","v":1},{"$f":"IF(D15>$G$2,0,1)","v":0},{"$f":"EOMONTH(B15,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.23","09:56:20","19:06:20",{"$f":"D16-C16","v":"09:10:00"},{"$f":"IF(C16>$F$2,1,0)","v":0},{"$f":"IF(D16>$G$2,0,1)","v":0},{"$f":"EOMONTH(B16,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.24","08:50:36","19:11:04",{"$f":"D17-C17","v":"10:20:28"},{"$f":"IF(C17>$F$2,1,0)","v":0},{"$f":"IF(D17>$G$2,0,1)","v":0},{"$f":"EOMONTH(B17,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.25","09:52:40","19:27:26",{"$f":"D18-C18","v":"09:34:46"},{"$f":"IF(C18>$F$2,1,0)","v":0},{"$f":"IF(D18>$G$2,0,1)","v":0},{"$f":"EOMONTH(B18,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.26","10:25:04","15:10:02",{"$f":"D19-C19","v":"04:44:58"},{"$f":"IF(C19>$F$2,1,0)","v":1},{"$f":"IF(D19>$G$2,0,1)","v":1},{"$f":"EOMONTH(B19,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.28","09:45:41","19:14:07",{"$f":"D20-C20","v":"09:28:26"},{"$f":"IF(C20>$F$2,1,0)","v":0},{"$f":"IF(D20>$G$2,0,1)","v":0},{"$f":"EOMONTH(B20,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.29","09:52:42","19:16:05",{"$f":"D21-C21","v":"09:23:23"},{"$f":"IF(C21>$F$2,1,0)","v":0},{"$f":"IF(D21>$G$2,0,1)","v":0},{"$f":"EOMONTH(B21,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.30","10:02:29","19:10:02",{"$f":"D22-C22","v":"09:07:33"},{"$f":"IF(C22>$F$2,1,0)","v":1},{"$f":"IF(D22>$G$2,0,1)","v":0},{"$f":"EOMONTH(B22,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.01.31","10:02:06","19:10:49",{"$f":"D23-C23","v":"09:08:43"},{"$f":"IF(C23>$F$2,1,0)","v":1},{"$f":"IF(D23>$G$2,0,1)","v":0},{"$f":"EOMONTH(B23,-1)+1","v":"2019-01-01"}]
["Иванов И И ","2019.02.01","09:52:58","19:11:27",{"$f":"D24-C24","v":"09:18:29"},{"$f":"IF(C24>$F$2,1,0)","v":0},{"$f":"IF(D24>$G$2,0,1)","v":0},{"$f":"EOMONTH(B24,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.04","09:50:47","19:19:51",{"$f":"D25-C25","v":"09:29:04"},{"$f":"IF(C25>$F$2,1,0)","v":0},{"$f":"IF(D25>$G$2,0,1)","v":0},{"$f":"EOMONTH(B25,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.05","09:58:51","19:19:34",{"$f":"D26-C26","v":"09:20:43"},{"$f":"IF(C26>$F$2,1,0)","v":0},{"$f":"IF(D26>$G$2,0,1)","v":0},{"$f":"EOMONTH(B26,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.06","09:54:57","19:11:38",{"$f":"D27-C27","v":"09:16:41"},{"$f":"IF(C27>$F$2,1,0)","v":0},{"$f":"IF(D27>$G$2,0,1)","v":0},{"$f":"EOMONTH(B27,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.07","09:58:17","19:18:10",{"$f":"D28-C28","v":"09:19:53"},{"$f":"IF(C28>$F$2,1,0)","v":0},{"$f":"IF(D28>$G$2,0,1)","v":0},{"$f":"EOMONTH(B28,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.08","09:58:06","19:11:06",{"$f":"D29-C29","v":"09:13:00"},{"$f":"IF(C29>$F$2,1,0)","v":0},{"$f":"IF(D29>$G$2,0,1)","v":0},{"$f":"EOMONTH(B29,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.09","09:58:21","15:25:44",{"$f":"D30-C30","v":"05:27:23"},{"$f":"IF(C30>$F$2,1,0)","v":0},{"$f":"IF(D30>$G$2,0,1)","v":1},{"$f":"EOMONTH(B30,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.11","09:43:58","19:11:53",{"$f":"D31-C31","v":"09:27:55"},{"$f":"IF(C31>$F$2,1,0)","v":0},{"$f":"IF(D31>$G$2,0,1)","v":0},{"$f":"EOMONTH(B31,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.12","09:58:07","19:12:40",{"$f":"D32-C32","v":"09:14:33"},{"$f":"IF(C32>$F$2,1,0)","v":0},{"$f":"IF(D32>$G$2,0,1)","v":0},{"$f":"EOMONTH(B32,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.13","08:08:14","19:08:09",{"$f":"D33-C33","v":"10:59:55"},{"$f":"IF(C33>$F$2,1,0)","v":0},{"$f":"IF(D33>$G$2,0,1)","v":0},{"$f":"EOMONTH(B33,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.14","09:47:13","19:31:23",{"$f":"D34-C34","v":"09:44:10"},{"$f":"IF(C34>$F$2,1,0)","v":0},{"$f":"IF(D34>$G$2,0,1)","v":0},{"$f":"EOMONTH(B34,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.15","08:17:22","20:51:08",{"$f":"D35-C35","v":"12:33:46"},{"$f":"IF(C35>$F$2,1,0)","v":0},{"$f":"IF(D35>$G$2,0,1)","v":0},{"$f":"EOMONTH(B35,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.18","09:39:51","19:41:35",{"$f":"D36-C36","v":"10:01:44"},{"$f":"IF(C36>$F$2,1,0)","v":0},{"$f":"IF(D36>$G$2,0,1)","v":0},{"$f":"EOMONTH(B36,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.19","08:22:13","18:54:58",{"$f":"D37-C37","v":"10:32:45"},{"$f":"IF(C37>$F$2,1,0)","v":0},{"$f":"IF(D37>$G$2,0,1)","v":1},{"$f":"EOMONTH(B37,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.20","10:03:29","19:11:15",{"$f":"D38-C38","v":"09:07:46"},{"$f":"IF(C38>$F$2,1,0)","v":1},{"$f":"IF(D38>$G$2,0,1)","v":0},{"$f":"EOMONTH(B38,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.21","09:52:08","19:08:54",{"$f":"D39-C39","v":"09:16:46"},{"$f":"IF(C39>$F$2,1,0)","v":0},{"$f":"IF(D39>$G$2,0,1)","v":0},{"$f":"EOMONTH(B39,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.22","08:27:34","18:42:41",{"$f":"D40-C40","v":"10:15:07"},{"$f":"IF(C40>$F$2,1,0)","v":0},{"$f":"IF(D40>$G$2,0,1)","v":1},{"$f":"EOMONTH(B40,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.25","09:55:45","19:14:10",{"$f":"D41-C41","v":"09:18:25"},{"$f":"IF(C41>$F$2,1,0)","v":0},{"$f":"IF(D41>$G$2,0,1)","v":0},{"$f":"EOMONTH(B41,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.26","10:05:01","19:15:35",{"$f":"D42-C42","v":"09:10:34"},{"$f":"IF(C42>$F$2,1,0)","v":1},{"$f":"IF(D42>$G$2,0,1)","v":0},{"$f":"EOMONTH(B42,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.27","08:26:01","19:12:26",{"$f":"D43-C43","v":"10:46:25"},{"$f":"IF(C43>$F$2,1,0)","v":0},{"$f":"IF(D43>$G$2,0,1)","v":0},{"$f":"EOMONTH(B43,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.02.28","10:08:24","19:10:01",{"$f":"D44-C44","v":"09:01:37"},{"$f":"IF(C44>$F$2,1,0)","v":1},{"$f":"IF(D44>$G$2,0,1)","v":0},{"$f":"EOMONTH(B44,-1)+1","v":"2019-02-01"}]
["Иванов И И ","2019.03.01","09:53:37","19:18:53",{"$f":"D45-C45","v":"09:25:16"},{"$f":"IF(C45>$F$2,1,0)","v":0},{"$f":"IF(D45>$G$2,0,1)","v":0},{"$f":"EOMONTH(B45,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.02","08:27:04","15:20:42",{"$f":"D46-C46","v":"06:53:38"},{"$f":"IF(C46>$F$2,1,0)","v":0},{"$f":"IF(D46>$G$2,0,1)","v":1},{"$f":"EOMONTH(B46,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.04","09:50:42","19:14:01",{"$f":"D47-C47","v":"09:23:19"},{"$f":"IF(C47>$F$2,1,0)","v":0},{"$f":"IF(D47>$G$2,0,1)","v":0},{"$f":"EOMONTH(B47,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.05","08:27:30","19:13:33",{"$f":"D48-C48","v":"10:46:03"},{"$f":"IF(C48>$F$2,1,0)","v":0},{"$f":"IF(D48>$G$2,0,1)","v":0},{"$f":"EOMONTH(B48,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.06","09:59:17","19:11:30",{"$f":"D49-C49","v":"09:12:13"},{"$f":"IF(C49>$F$2,1,0)","v":0},{"$f":"IF(D49>$G$2,0,1)","v":0},{"$f":"EOMONTH(B49,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.07","09:44:37","19:18:46",{"$f":"D50-C50","v":"09:34:09"},{"$f":"IF(C50>$F$2,1,0)","v":0},{"$f":"IF(D50>$G$2,0,1)","v":0},{"$f":"EOMONTH(B50,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.11","08:21:42","19:16:32",{"$f":"D51-C51","v":"10:54:50"},{"$f":"IF(C51>$F$2,1,0)","v":0},{"$f":"IF(D51>$G$2,0,1)","v":0},{"$f":"EOMONTH(B51,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.12","09:56:15","19:09:18",{"$f":"D52-C52","v":"09:13:03"},{"$f":"IF(C52>$F$2,1,0)","v":0},{"$f":"IF(D52>$G$2,0,1)","v":0},{"$f":"EOMONTH(B52,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.13","09:39:40","19:10:02",{"$f":"D53-C53","v":"09:30:22"},{"$f":"IF(C53>$F$2,1,0)","v":0},{"$f":"IF(D53>$G$2,0,1)","v":0},{"$f":"EOMONTH(B53,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.14","08:31:47","19:15:32",{"$f":"D54-C54","v":"10:43:45"},{"$f":"IF(C54>$F$2,1,0)","v":0},{"$f":"IF(D54>$G$2,0,1)","v":0},{"$f":"EOMONTH(B54,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.15","09:49:06","19:16:08",{"$f":"D55-C55","v":"09:27:02"},{"$f":"IF(C55>$F$2,1,0)","v":0},{"$f":"IF(D55>$G$2,0,1)","v":0},{"$f":"EOMONTH(B55,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.18","09:38:06","19:13:01",{"$f":"D56-C56","v":"09:34:55"},{"$f":"IF(C56>$F$2,1,0)","v":0},{"$f":"IF(D56>$G$2,0,1)","v":0},{"$f":"EOMONTH(B56,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.19","09:58:06","19:11:11",{"$f":"D57-C57","v":"09:13:05"},{"$f":"IF(C57>$F$2,1,0)","v":0},{"$f":"IF(D57>$G$2,0,1)","v":0},{"$f":"EOMONTH(B57,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.20","08:19:09","19:10:05",{"$f":"D58-C58","v":"10:50:56"},{"$f":"IF(C58>$F$2,1,0)","v":0},{"$f":"IF(D58>$G$2,0,1)","v":0},{"$f":"EOMONTH(B58,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.21","09:59:50","19:11:17",{"$f":"D59-C59","v":"09:11:27"},{"$f":"IF(C59>$F$2,1,0)","v":0},{"$f":"IF(D59>$G$2,0,1)","v":0},{"$f":"EOMONTH(B59,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.22","09:48:48","19:06:30",{"$f":"D60-C60","v":"09:17:42"},{"$f":"IF(C60>$F$2,1,0)","v":0},{"$f":"IF(D60>$G$2,0,1)","v":0},{"$f":"EOMONTH(B60,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.23","08:31:11","15:59:22",{"$f":"D61-C61","v":"07:28:11"},{"$f":"IF(C61>$F$2,1,0)","v":0},{"$f":"IF(D61>$G$2,0,1)","v":1},{"$f":"EOMONTH(B61,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.25","09:52:32","19:11:46",{"$f":"D62-C62","v":"09:19:14"},{"$f":"IF(C62>$F$2,1,0)","v":0},{"$f":"IF(D62>$G$2,0,1)","v":0},{"$f":"EOMONTH(B62,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.26","08:30:07","19:06:52",{"$f":"D63-C63","v":"10:36:45"},{"$f":"IF(C63>$F$2,1,0)","v":0},{"$f":"IF(D63>$G$2,0,1)","v":0},{"$f":"EOMONTH(B63,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.27","09:56:19","19:15:08",{"$f":"D64-C64","v":"09:18:49"},{"$f":"IF(C64>$F$2,1,0)","v":0},{"$f":"IF(D64>$G$2,0,1)","v":0},{"$f":"EOMONTH(B64,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.28","09:38:19","19:14:35",{"$f":"D65-C65","v":"09:36:16"},{"$f":"IF(C65>$F$2,1,0)","v":0},{"$f":"IF(D65>$G$2,0,1)","v":0},{"$f":"EOMONTH(B65,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.03.29","08:21:35","19:13:06",{"$f":"D66-C66","v":"10:51:31"},{"$f":"IF(C66>$F$2,1,0)","v":0},{"$f":"IF(D66>$G$2,0,1)","v":0},{"$f":"EOMONTH(B66,-1)+1","v":"2019-03-01"}]
["Иванов И И ","2019.04.01","08:24:31","19:11:33",{"$f":"D67-C67","v":"10:47:02"},{"$f":"IF(C67>$F$2,1,0)","v":0},{"$f":"IF(D67>$G$2,0,1)","v":0},{"$f":"EOMONTH(B67,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.02","09:50:39","11:59:09",{"$f":"D68-C68","v":"02:08:30"},{"$f":"IF(C68>$F$2,1,0)","v":0},{"$f":"IF(D68>$G$2,0,1)","v":1},{"$f":"EOMONTH(B68,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.03","08:19:03","19:20:52",{"$f":"D69-C69","v":"11:01:49"},{"$f":"IF(C69>$F$2,1,0)","v":0},{"$f":"IF(D69>$G$2,0,1)","v":0},{"$f":"EOMONTH(B69,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.04","09:32:44","19:09:30",{"$f":"D70-C70","v":"09:36:46"},{"$f":"IF(C70>$F$2,1,0)","v":0},{"$f":"IF(D70>$G$2,0,1)","v":0},{"$f":"EOMONTH(B70,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.05","09:56:25","19:29:00",{"$f":"D71-C71","v":"09:32:35"},{"$f":"IF(C71>$F$2,1,0)","v":0},{"$f":"IF(D71>$G$2,0,1)","v":0},{"$f":"EOMONTH(B71,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.08","09:36:04","19:12:26",{"$f":"D72-C72","v":"09:36:22"},{"$f":"IF(C72>$F$2,1,0)","v":0},{"$f":"IF(D72>$G$2,0,1)","v":0},{"$f":"EOMONTH(B72,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.09","08:15:25","19:08:58",{"$f":"D73-C73","v":"10:53:33"},{"$f":"IF(C73>$F$2,1,0)","v":0},{"$f":"IF(D73>$G$2,0,1)","v":0},{"$f":"EOMONTH(B73,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.10","09:54:24","19:07:50",{"$f":"D74-C74","v":"09:13:26"},{"$f":"IF(C74>$F$2,1,0)","v":0},{"$f":"IF(D74>$G$2,0,1)","v":0},{"$f":"EOMONTH(B74,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.11","08:32:08","19:10:56",{"$f":"D75-C75","v":"10:38:48"},{"$f":"IF(C75>$F$2,1,0)","v":0},{"$f":"IF(D75>$G$2,0,1)","v":0},{"$f":"EOMONTH(B75,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.12","09:26:48","19:07:07",{"$f":"D76-C76","v":"09:40:19"},{"$f":"IF(C76>$F$2,1,0)","v":0},{"$f":"IF(D76>$G$2,0,1)","v":0},{"$f":"EOMONTH(B76,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.13","09:58:03","14:34:30",{"$f":"D77-C77","v":"04:36:27"},{"$f":"IF(C77>$F$2,1,0)","v":0},{"$f":"IF(D77>$G$2,0,1)","v":1},{"$f":"EOMONTH(B77,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.15","09:46:40","19:08:21",{"$f":"D78-C78","v":"09:21:41"},{"$f":"IF(C78>$F$2,1,0)","v":0},{"$f":"IF(D78>$G$2,0,1)","v":0},{"$f":"EOMONTH(B78,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.16","08:19:22","19:12:36",{"$f":"D79-C79","v":"10:53:14"},{"$f":"IF(C79>$F$2,1,0)","v":0},{"$f":"IF(D79>$G$2,0,1)","v":0},{"$f":"EOMONTH(B79,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.17","09:49:05","19:05:15",{"$f":"D80-C80","v":"09:16:10"},{"$f":"IF(C80>$F$2,1,0)","v":0},{"$f":"IF(D80>$G$2,0,1)","v":0},{"$f":"EOMONTH(B80,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019.04.18","10:00:03","19:08:37",{"$f":"D81-C81","v":"09:08:34"},{"$f":"IF(C81>$F$2,1,0)","v":1},{"$f":"IF(D81>$G$2,0,1)","v":0},{"$f":"EOMONTH(B81,-1)+1","v":"2019-04-01"}]
["Иванов И И ","2019-04-19","10:01:41","18:06:05",{"$f":"D82-C82","v":"08:04:24"},{"$f":"IF(C82>$F$2,1,0)","v":1},{"$f":"IF(D82>$G$2,0,1)","v":1},{"$f":"EOMONTH(B82,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.01.12","09:49:27","18:04:02",{"$f":"D83-C83","v":"08:14:35"},{"$f":"IF(C83>$F$2,1,0)","v":0},{"$f":"IF(D83>$G$2,0,1)","v":1},{"$f":"EOMONTH(B83,-1)+1","v":"2019-01-01"}]
["Петров П П","2019.01.19","10:05:22","17:54:05",{"$f":"D84-C84","v":"07:48:43"},{"$f":"IF(C84>$F$2,1,0)","v":1},{"$f":"IF(D84>$G$2,0,1)","v":1},{"$f":"EOMONTH(B84,-1)+1","v":"2019-01-01"}]
["Петров П П","2019.01.25","10:52:58","11:00:05",{"$f":"D85-C85","v":"00:07:07"},{"$f":"IF(C85>$F$2,1,0)","v":1},{"$f":"IF(D85>$G$2,0,1)","v":1},{"$f":"EOMONTH(B85,-1)+1","v":"2019-01-01"}]
["Петров П П","2019.01.30","13:37:52","19:01:00",{"$f":"D86-C86","v":"05:23:08"},{"$f":"IF(C86>$F$2,1,0)","v":1},{"$f":"IF(D86>$G$2,0,1)","v":0},{"$f":"EOMONTH(B86,-1)+1","v":"2019-01-01"}]
["Петров П П","2019.02.02","10:04:08","18:30:05",{"$f":"D87-C87","v":"08:25:57"},{"$f":"IF(C87>$F$2,1,0)","v":1},{"$f":"IF(D87>$G$2,0,1)","v":1},{"$f":"EOMONTH(B87,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.02.07","12:39:51","13:22:02",{"$f":"D88-C88","v":"00:42:11"},{"$f":"IF(C88>$F$2,1,0)","v":1},{"$f":"IF(D88>$G$2,0,1)","v":1},{"$f":"EOMONTH(B88,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.02.08","10:59:55","11:19:48",{"$f":"D89-C89","v":"00:19:53"},{"$f":"IF(C89>$F$2,1,0)","v":1},{"$f":"IF(D89>$G$2,0,1)","v":1},{"$f":"EOMONTH(B89,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.02.20","13:02:34","13:36:53",{"$f":"D90-C90","v":"00:34:19"},{"$f":"IF(C90>$F$2,1,0)","v":1},{"$f":"IF(D90>$G$2,0,1)","v":1},{"$f":"EOMONTH(B90,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.02.21","13:15:03","15:49:04",{"$f":"D91-C91","v":"02:34:01"},{"$f":"IF(C91>$F$2,1,0)","v":1},{"$f":"IF(D91>$G$2,0,1)","v":1},{"$f":"EOMONTH(B91,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.02.23","10:09:22","18:19:32",{"$f":"D92-C92","v":"08:10:10"},{"$f":"IF(C92>$F$2,1,0)","v":1},{"$f":"IF(D92>$G$2,0,1)","v":1},{"$f":"EOMONTH(B92,-1)+1","v":"2019-02-01"}]
["Петров П П","2019.03.07","11:47:36","12:05:02",{"$f":"D93-C93","v":"00:17:26"},{"$f":"IF(C93>$F$2,1,0)","v":1},{"$f":"IF(D93>$G$2,0,1)","v":1},{"$f":"EOMONTH(B93,-1)+1","v":"2019-03-01"}]
["Петров П П","2019.03.09","09:56:56","17:03:29",{"$f":"D94-C94","v":"07:06:33"},{"$f":"IF(C94>$F$2,1,0)","v":0},{"$f":"IF(D94>$G$2,0,1)","v":1},{"$f":"EOMONTH(B94,-1)+1","v":"2019-03-01"}]
["Петров П П","2019.03.13","10:05:18","10:18:39",{"$f":"D95-C95","v":"00:13:21"},{"$f":"IF(C95>$F$2,1,0)","v":1},{"$f":"IF(D95>$G$2,0,1)","v":1},{"$f":"EOMONTH(B95,-1)+1","v":"2019-03-01"}]
["Петров П П","2019.03.23","10:04:26","17:46:15",{"$f":"D96-C96","v":"07:41:49"},{"$f":"IF(C96>$F$2,1,0)","v":1},{"$f":"IF(D96>$G$2,0,1)","v":1},{"$f":"EOMONTH(B96,-1)+1","v":"2019-03-01"}]
["Петров П П","2019.03.28","09:54:52","19:08:21",{"$f":"D97-C97","v":"09:13:29"},{"$f":"IF(C97>$F$2,1,0)","v":0},{"$f":"IF(D97>$G$2,0,1)","v":0},{"$f":"EOMONTH(B97,-1)+1","v":"2019-03-01"}]
["Петров П П","2019.04.04","15:23:59","15:27:31",{"$f":"D98-C98","v":"00:03:32"},{"$f":"IF(C98>$F$2,1,0)","v":1},{"$f":"IF(D98>$G$2,0,1)","v":1},{"$f":"EOMONTH(B98,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.06","10:03:17","17:14:12",{"$f":"D99-C99","v":"07:10:55"},{"$f":"IF(C99>$F$2,1,0)","v":1},{"$f":"IF(D99>$G$2,0,1)","v":1},{"$f":"EOMONTH(B99,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.08","09:14:18","19:07:14",{"$f":"D100-C100","v":"09:52:56"},{"$f":"IF(C100>$F$2,1,0)","v":0},{"$f":"IF(D100>$G$2,0,1)","v":0},{"$f":"EOMONTH(B100,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.09","09:54:51","19:01:50",{"$f":"D101-C101","v":"09:06:59"},{"$f":"IF(C101>$F$2,1,0)","v":0},{"$f":"IF(D101>$G$2,0,1)","v":0},{"$f":"EOMONTH(B101,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.10","09:56:33","19:23:13",{"$f":"D102-C102","v":"09:26:40"},{"$f":"IF(C102>$F$2,1,0)","v":0},{"$f":"IF(D102>$G$2,0,1)","v":0},{"$f":"EOMONTH(B102,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.11","09:51:45","19:03:28",{"$f":"D103-C103","v":"09:11:43"},{"$f":"IF(C103>$F$2,1,0)","v":0},{"$f":"IF(D103>$G$2,0,1)","v":0},{"$f":"EOMONTH(B103,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.12","09:50:30","19:45:32",{"$f":"D104-C104","v":"09:55:02"},{"$f":"IF(C104>$F$2,1,0)","v":0},{"$f":"IF(D104>$G$2,0,1)","v":0},{"$f":"EOMONTH(B104,-1)+1","v":"2019-04-01"}]
["Петров П П","2019.04.13","10:14:48","18:19:15",{"$f":"D105-C105","v":"08:04:27"},{"$f":"IF(C105>$F$2,1,0)","v":1},{"$f":"IF(D105>$G$2,0,1)","v":1},{"$f":"EOMONTH(B105,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.01.09","12:18:32","13:18:02",{"$f":"D106-C106","v":"00:59:30"},{"$f":"IF(C106>$F$2,1,0)","v":1},{"$f":"IF(D106>$G$2,0,1)","v":1},{"$f":"EOMONTH(B106,-1)+1","v":"2019-01-01"}]
["Сидоров С С","2019.01.12","17:07:45","17:47:14",{"$f":"D107-C107","v":"00:39:29"},{"$f":"IF(C107>$F$2,1,0)","v":1},{"$f":"IF(D107>$G$2,0,1)","v":1},{"$f":"EOMONTH(B107,-1)+1","v":"2019-01-01"}]
["Сидоров С С","2019.01.23","10:52:47","13:21:43",{"$f":"D108-C108","v":"02:28:56"},{"$f":"IF(C108>$F$2,1,0)","v":1},{"$f":"IF(D108>$G$2,0,1)","v":1},{"$f":"EOMONTH(B108,-1)+1","v":"2019-01-01"}]
["Сидоров С С","2019.02.04","12:11:30","14:55:28",{"$f":"D109-C109","v":"02:43:58"},{"$f":"IF(C109>$F$2,1,0)","v":1},{"$f":"IF(D109>$G$2,0,1)","v":1},{"$f":"EOMONTH(B109,-1)+1","v":"2019-02-01"}]
["Сидоров С С","2019.02.12","10:48:02","11:30:46",{"$f":"D110-C110","v":"00:42:44"},{"$f":"IF(C110>$F$2,1,0)","v":1},{"$f":"IF(D110>$G$2,0,1)","v":1},{"$f":"EOMONTH(B110,-1)+1","v":"2019-02-01"}]
["Сидоров С С","2019.02.18","15:34:08","16:35:47",{"$f":"D111-C111","v":"01:01:39"},{"$f":"IF(C111>$F$2,1,0)","v":1},{"$f":"IF(D111>$G$2,0,1)","v":1},{"$f":"EOMONTH(B111,-1)+1","v":"2019-02-01"}]
["Сидоров С С","2019.02.27","13:48:40","14:23:18",{"$f":"D112-C112","v":"00:34:38"},{"$f":"IF(C112>$F$2,1,0)","v":1},{"$f":"IF(D112>$G$2,0,1)","v":1},{"$f":"EOMONTH(B112,-1)+1","v":"2019-02-01"}]
["Сидоров С С","2019.03.14","11:22:32","11:39:15",{"$f":"D113-C113","v":"00:16:43"},{"$f":"IF(C113>$F$2,1,0)","v":1},{"$f":"IF(D113>$G$2,0,1)","v":1},{"$f":"EOMONTH(B113,-1)+1","v":"2019-03-01"}]
["Сидоров С С","2019.04.01","12:19:51","13:18:39",{"$f":"D114-C114","v":"00:58:48"},{"$f":"IF(C114>$F$2,1,0)","v":1},{"$f":"IF(D114>$G$2,0,1)","v":1},{"$f":"EOMONTH(B114,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.04.08","10:33:36","13:00:05",{"$f":"D115-C115","v":"02:26:29"},{"$f":"IF(C115>$F$2,1,0)","v":1},{"$f":"IF(D115>$G$2,0,1)","v":1},{"$f":"EOMONTH(B115,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.04.09","11:19:24","12:03:00",{"$f":"D116-C116","v":"00:43:36"},{"$f":"IF(C116>$F$2,1,0)","v":1},{"$f":"IF(D116>$G$2,0,1)","v":1},{"$f":"EOMONTH(B116,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.04.15","10:50:59","13:29:43",{"$f":"D117-C117","v":"02:38:44"},{"$f":"IF(C117>$F$2,1,0)","v":1},{"$f":"IF(D117>$G$2,0,1)","v":1},{"$f":"EOMONTH(B117,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.04.18","15:46:44","16:56:32",{"$f":"D118-C118","v":"01:09:48"},{"$f":"IF(C118>$F$2,1,0)","v":1},{"$f":"IF(D118>$G$2,0,1)","v":1},{"$f":"EOMONTH(B118,-1)+1","v":"2019-04-01"}]
["Сидоров С С","2019.04.22","10:47:32","13:53:48",{"$f":"D119-C119","v":"03:06:16"},{"$f":"IF(C119>$F$2,1,0)","v":1},{"$f":"IF(D119>$G$2,0,1)","v":1},{"$f":"EOMONTH(B119,-1)+1","v":"2019-04-01"}]

{"sheet":"Формирование табеля по сотр.","index":1,"n_rows":10,"n_cols":37,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"ФИО",{"$f":"B5","v":"2019-04-01"},{"$f":"C4+1","v":"2019-04-02"},{"$f":"D4+1","v":"2019-04-03"},"2019-04-04","2019-04-05","2019-04-06","2019-04-07","2019-04-08","2019-04-09","2019-04-10","2019-04-11","2019-04-12","2019-04-13","2019-04-14","2019-04-15","2019-04-16","2019-04-17","2019-04-18","2019-04-19","2019-04-20","2019-04-21","2019-04-22","2019-04-23","2019-04-24","2019-04-25","2019-04-26","2019-04-27","2019-04-28","2019-04-29","2019-04-30","2019-05-01","Отработано, дней","Норма, дней","Отработано, часов","Норма, часов"]
[null,"2019-04-01",{"$f":"TEXT(C4,\"ДДДД\")","v":"понедельник"},{"$f":"TEXT(D4,\"ДДДД\")","v":"вторник"},{"$f":"TEXT(E4,\"ДДДД\")","v":"среда"},{"$f":"TEXT(F4,\"ДДДД\")","v":"четверг"},{"$f":"TEXT(G4,\"ДДДД\")","v":"пятница"},"суббота","воскресенье","понедельник","вторник","среда","четверг","пятница","суббота","воскресенье","понедельник","вторник","среда","четверг","пятница","суббота","воскресенье","понедельник","вторник","среда","четверг","пятница","суббота","воскресенье","понедельник","вторник","среда"]
[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":"COUNTIF(C6:AG6,\">0\")","v":0},null,{"$f":"SUM(C6:AG6)","v":0}]
[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":"COUNTIF(C7:AG7,\">0\")","v":0},null,{"$f":"SUM(C7:AG7)","v":0}]
[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":"COUNTIF(C8:AG8,\">0\")","v":0},null,{"$f":"SUM(C8:AG8)","v":0}]
[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":"COUNTIF(C9:AG9,\">0\")","v":0},null,{"$f":"SUM(C9:AG9)","v":0}]
[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":"COUNTIF(C10:AG10,\">0\")","v":0},null,{"$f":"SUM(C10:AG10)","v":0}]