{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Выходные и праздники","Поправки"],"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":"Лист1","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Создано","Закрыта","рабочее время","Нерабочие будни","Ошибки в расчете"]
["2024-10-29T11:43:00","2024-10-29T11:45:00",{"$f":"(SUMPRODUCT((WEEKDAY(A2+ROW($1:$2923),2)<6)*(TRUNC(A2)+ROW($1:$2923)<--TRUNC(B2))*ISERROR(MATCH(TRUNC(A2)+ROW($1:$2923),$D$2:$D$2,)))-(TRUNC(A2)=TRUNC(B2)))*\"8:00\"+MAX(,\"18:\"-MOD(A2,1))+(WEEKDAY(B2,2)<6)*MAX(,MAX(MIN(MOD(B2,1),\"18:00\"),\"9:00\")-\"9:\")-MIN(--\"1:\",MAX(,\"14:\"-MOD(A2,1)))-(WEEKDAY(B2,2)<6)*MIN(--\"1:\",MAX(,MAX(MIN(MOD(B2,1),\"18:00\"),\"9:00\")-\"13:\"))","v":1.3888888934161722E-3},"2024-10-25","правильно",null,null,{"$f":"РабВремя(A2,B2)","v":1.3888888934161514E-3}]
["2024-10-28T23:53:00","2024-10-29T10:01:00",4.2361111110949423E-2,null,"правильно",null,null,{"$f":"РабВремя(A3,B3)","v":4.2361111110949423E-2}]
["2024-10-28T23:31:00","2024-10-29T09:28:00",1.9444444442342501E-2,null,"правильно",null,null,1.9444444442342501E-2]
["2024-10-28T09:21:00","2024-10-28T15:25:00",0.21111111111288969,null,"правильно",null,null,0.21111111110803904]
["2024-10-28T08:33:00","2024-10-28T15:23:00",0.24305555555959776,null,"должно быть 5:23",null,null,0.22430555555183673]
["2024-10-28T08:32:00","2024-10-28T15:20:00",0.24166666666618161,null,"должно быть 5:20",null,null,0.22222222221898846]
["2024-10-28T08:20:00","2024-10-28T15:20:00",0.25000000000485062,null,"должно быть 5:20",null,null,0.22222222221898846]
["2024-10-27T17:10:00","2024-10-28T14:59:00",0.24236111110561373,null,"должно быть 4:49",null,null,0.20763888888177462]
["2024-10-01T00:15:00","2024-10-18T09:33:00",4.7208333333376986,null,"должно быть 104:33",null,null,4.356249999938882]

{"sheet":"Выходные и праздники","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Выходные дни и праздники","Столбец1"]
["2017-12-30",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":6}]
["2017-12-31",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":7}]
["2018-01-01",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":1}]
["2018-01-02",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":2}]
["2018-01-03",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":3}]
["2018-01-04",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":4}]
["2018-01-05",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":5}]
["2018-01-06",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":6}]
["2018-01-07",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":7}]
["2018-01-08",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":1}]
["2018-01-13",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":6}]
["2018-01-14",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":7}]
["2018-01-20",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":6}]
["2024-07-08",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":1}]
["2018-01-27",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":6}]
["2018-01-28",{"$f":"WEEKDAY(Таблица2[[#This Row],[Выходные дни и праздники]],2)","v":7}]

{"sheet":"Поправки","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Праздничные и перенесенные\nнерабочие дни",null,"Рабочие субботы",null,"Сокращенные дни"]
["2024-01-01",null,"2024-04-27",null,"2024-03-07"]
["2024-01-02",null,"2024-11-02",null,"2024-05-08"]
["2024-01-03",null,"2024-12-28",null,"2024-06-11"]
["2024-01-04",null,null,null,"2024-11-02"]
["2024-01-05"]
["2024-01-06"]
["2024-01-07"]
["2024-01-08"]
["2024-02-23"]
["2024-03-08"]
["2024-04-29"]
["2024-04-30"]
["2024-05-01"]
["2024-05-09"]
["2024-05-10"]
["2024-06-12"]
["2024-11-04"]
["2024-12-30"]
["2024-12-31"]