{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Для_макроса","Для_формулы"],"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":"Лист1","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Создано","Закрыта",null,"Р.время макрос","Р.время формула"]
["2024-10-29T11:43:00","2024-10-29T11:45:00",null,{"$f":"РабВремя(A2,B2)","v":1.3888888934161514E-3},{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A2)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B2>13/24+TRUNC($A2)+ROW($1:$25)-1,13/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>9/24+TRUNC($A2)+ROW($1:$25)-1,A2,9/24+TRUNC($A2)+ROW($1:$25)-1))>0,IF(B2>13/24+TRUNC($A2)+ROW($1:$25)-1,13/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>9/24+TRUNC($A2)+ROW($1:$25)-1,A2,9/24+TRUNC($A2)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A2)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A2)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B2>18/24+TRUNC($A2)+ROW($1:$25)-1,18/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>14/24+TRUNC($A2)+ROW($1:$25)-1,A2,14/24+TRUNC($A2)+ROW($1:$25)-1))>0,IF(B2>18/24+TRUNC($A2)+ROW($1:$25)-1,18/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>14/24+TRUNC($A2)+ROW($1:$25)-1,A2,14/24+TRUNC($A2)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A2)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B2>17/24+TRUNC($A2)+ROW($1:$25)-1,17/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>14/24+TRUNC($A2)+ROW($1:$25)-1,A2,14/24+TRUNC($A2)+ROW($1:$25)-1))>0,IF(B2>17/24+TRUNC($A2)+ROW($1:$25)-1,17/24+TRUNC($A2)+ROW($1:$25)-1,B2)-IF(A2>14/24+TRUNC($A2)+ROW($1:$25)-1,A2,14/24+TRUNC($A2)+ROW($1:$25)-1),0)))","v":1.3888888934161514E-3}]
["2024-10-28T23:53:00","2024-10-29T10:01:00",null,4.2361111110949423E-2,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A3)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B3>13/24+TRUNC($A3)+ROW($1:$25)-1,13/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>9/24+TRUNC($A3)+ROW($1:$25)-1,A3,9/24+TRUNC($A3)+ROW($1:$25)-1))>0,IF(B3>13/24+TRUNC($A3)+ROW($1:$25)-1,13/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>9/24+TRUNC($A3)+ROW($1:$25)-1,A3,9/24+TRUNC($A3)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A3)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A3)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B3>18/24+TRUNC($A3)+ROW($1:$25)-1,18/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>14/24+TRUNC($A3)+ROW($1:$25)-1,A3,14/24+TRUNC($A3)+ROW($1:$25)-1))>0,IF(B3>18/24+TRUNC($A3)+ROW($1:$25)-1,18/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>14/24+TRUNC($A3)+ROW($1:$25)-1,A3,14/24+TRUNC($A3)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A3)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B3>17/24+TRUNC($A3)+ROW($1:$25)-1,17/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>14/24+TRUNC($A3)+ROW($1:$25)-1,A3,14/24+TRUNC($A3)+ROW($1:$25)-1))>0,IF(B3>17/24+TRUNC($A3)+ROW($1:$25)-1,17/24+TRUNC($A3)+ROW($1:$25)-1,B3)-IF(A3>14/24+TRUNC($A3)+ROW($1:$25)-1,A3,14/24+TRUNC($A3)+ROW($1:$25)-1),0)))","v":4.2361111110949423E-2}]
["2024-10-28T23:31:00","2024-10-29T09:28:00",null,1.9444444442342501E-2,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A4)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B4>13/24+TRUNC($A4)+ROW($1:$25)-1,13/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>9/24+TRUNC($A4)+ROW($1:$25)-1,A4,9/24+TRUNC($A4)+ROW($1:$25)-1))>0,IF(B4>13/24+TRUNC($A4)+ROW($1:$25)-1,13/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>9/24+TRUNC($A4)+ROW($1:$25)-1,A4,9/24+TRUNC($A4)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A4)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A4)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B4>18/24+TRUNC($A4)+ROW($1:$25)-1,18/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>14/24+TRUNC($A4)+ROW($1:$25)-1,A4,14/24+TRUNC($A4)+ROW($1:$25)-1))>0,IF(B4>18/24+TRUNC($A4)+ROW($1:$25)-1,18/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>14/24+TRUNC($A4)+ROW($1:$25)-1,A4,14/24+TRUNC($A4)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A4)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B4>17/24+TRUNC($A4)+ROW($1:$25)-1,17/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>14/24+TRUNC($A4)+ROW($1:$25)-1,A4,14/24+TRUNC($A4)+ROW($1:$25)-1))>0,IF(B4>17/24+TRUNC($A4)+ROW($1:$25)-1,17/24+TRUNC($A4)+ROW($1:$25)-1,B4)-IF(A4>14/24+TRUNC($A4)+ROW($1:$25)-1,A4,14/24+TRUNC($A4)+ROW($1:$25)-1),0)))","v":1.9444444442342501E-2}]
["2024-10-28T09:21:00","2024-10-28T15:25:00",null,0.21111111110803904,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A5)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B5>13/24+TRUNC($A5)+ROW($1:$25)-1,13/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>9/24+TRUNC($A5)+ROW($1:$25)-1,A5,9/24+TRUNC($A5)+ROW($1:$25)-1))>0,IF(B5>13/24+TRUNC($A5)+ROW($1:$25)-1,13/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>9/24+TRUNC($A5)+ROW($1:$25)-1,A5,9/24+TRUNC($A5)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A5)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A5)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B5>18/24+TRUNC($A5)+ROW($1:$25)-1,18/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>14/24+TRUNC($A5)+ROW($1:$25)-1,A5,14/24+TRUNC($A5)+ROW($1:$25)-1))>0,IF(B5>18/24+TRUNC($A5)+ROW($1:$25)-1,18/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>14/24+TRUNC($A5)+ROW($1:$25)-1,A5,14/24+TRUNC($A5)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A5)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B5>17/24+TRUNC($A5)+ROW($1:$25)-1,17/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>14/24+TRUNC($A5)+ROW($1:$25)-1,A5,14/24+TRUNC($A5)+ROW($1:$25)-1))>0,IF(B5>17/24+TRUNC($A5)+ROW($1:$25)-1,17/24+TRUNC($A5)+ROW($1:$25)-1,B5)-IF(A5>14/24+TRUNC($A5)+ROW($1:$25)-1,A5,14/24+TRUNC($A5)+ROW($1:$25)-1),0)))","v":0.21111111110803904}]
["2024-10-28T09:02:00","2024-10-28T17:23:00",null,0.30625000000145519,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A6)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B6>13/24+TRUNC($A6)+ROW($1:$25)-1,13/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>9/24+TRUNC($A6)+ROW($1:$25)-1,A6,9/24+TRUNC($A6)+ROW($1:$25)-1))>0,IF(B6>13/24+TRUNC($A6)+ROW($1:$25)-1,13/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>9/24+TRUNC($A6)+ROW($1:$25)-1,A6,9/24+TRUNC($A6)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A6)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A6)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B6>18/24+TRUNC($A6)+ROW($1:$25)-1,18/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>14/24+TRUNC($A6)+ROW($1:$25)-1,A6,14/24+TRUNC($A6)+ROW($1:$25)-1))>0,IF(B6>18/24+TRUNC($A6)+ROW($1:$25)-1,18/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>14/24+TRUNC($A6)+ROW($1:$25)-1,A6,14/24+TRUNC($A6)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A6)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B6>17/24+TRUNC($A6)+ROW($1:$25)-1,17/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>14/24+TRUNC($A6)+ROW($1:$25)-1,A6,14/24+TRUNC($A6)+ROW($1:$25)-1))>0,IF(B6>17/24+TRUNC($A6)+ROW($1:$25)-1,17/24+TRUNC($A6)+ROW($1:$25)-1,B6)-IF(A6>14/24+TRUNC($A6)+ROW($1:$25)-1,A6,14/24+TRUNC($A6)+ROW($1:$25)-1),0)))","v":0.30625000000145519}]
["2024-10-28T12:58:00","2024-10-28T14:00:00",null,1.3888888861401938E-3,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A7)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B7>13/24+TRUNC($A7)+ROW($1:$25)-1,13/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>9/24+TRUNC($A7)+ROW($1:$25)-1,A7,9/24+TRUNC($A7)+ROW($1:$25)-1))>0,IF(B7>13/24+TRUNC($A7)+ROW($1:$25)-1,13/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>9/24+TRUNC($A7)+ROW($1:$25)-1,A7,9/24+TRUNC($A7)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A7)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A7)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B7>18/24+TRUNC($A7)+ROW($1:$25)-1,18/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>14/24+TRUNC($A7)+ROW($1:$25)-1,A7,14/24+TRUNC($A7)+ROW($1:$25)-1))>0,IF(B7>18/24+TRUNC($A7)+ROW($1:$25)-1,18/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>14/24+TRUNC($A7)+ROW($1:$25)-1,A7,14/24+TRUNC($A7)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A7)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B7>17/24+TRUNC($A7)+ROW($1:$25)-1,17/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>14/24+TRUNC($A7)+ROW($1:$25)-1,A7,14/24+TRUNC($A7)+ROW($1:$25)-1))>0,IF(B7>17/24+TRUNC($A7)+ROW($1:$25)-1,17/24+TRUNC($A7)+ROW($1:$25)-1,B7)-IF(A7>14/24+TRUNC($A7)+ROW($1:$25)-1,A7,14/24+TRUNC($A7)+ROW($1:$25)-1),0)))","v":1.3888888861401938E-3}]
["2024-11-02T16:59:00","2024-11-05T09:01:00",null,1.3888888934161514E-3,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A8)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B8>13/24+TRUNC($A8)+ROW($1:$25)-1,13/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>9/24+TRUNC($A8)+ROW($1:$25)-1,A8,9/24+TRUNC($A8)+ROW($1:$25)-1))>0,IF(B8>13/24+TRUNC($A8)+ROW($1:$25)-1,13/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>9/24+TRUNC($A8)+ROW($1:$25)-1,A8,9/24+TRUNC($A8)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A8)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A8)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B8>18/24+TRUNC($A8)+ROW($1:$25)-1,18/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>14/24+TRUNC($A8)+ROW($1:$25)-1,A8,14/24+TRUNC($A8)+ROW($1:$25)-1))>0,IF(B8>18/24+TRUNC($A8)+ROW($1:$25)-1,18/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>14/24+TRUNC($A8)+ROW($1:$25)-1,A8,14/24+TRUNC($A8)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A8)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B8>17/24+TRUNC($A8)+ROW($1:$25)-1,17/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>14/24+TRUNC($A8)+ROW($1:$25)-1,A8,14/24+TRUNC($A8)+ROW($1:$25)-1))>0,IF(B8>17/24+TRUNC($A8)+ROW($1:$25)-1,17/24+TRUNC($A8)+ROW($1:$25)-1,B8)-IF(A8>14/24+TRUNC($A8)+ROW($1:$25)-1,A8,14/24+TRUNC($A8)+ROW($1:$25)-1),0)))","v":1.3888888934161514E-3}]
["2024-10-27T17:10:00","2024-10-28T14:59:00",null,0.20763888888177462,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A9)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B9>13/24+TRUNC($A9)+ROW($1:$25)-1,13/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>9/24+TRUNC($A9)+ROW($1:$25)-1,A9,9/24+TRUNC($A9)+ROW($1:$25)-1))>0,IF(B9>13/24+TRUNC($A9)+ROW($1:$25)-1,13/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>9/24+TRUNC($A9)+ROW($1:$25)-1,A9,9/24+TRUNC($A9)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A9)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A9)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B9>18/24+TRUNC($A9)+ROW($1:$25)-1,18/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>14/24+TRUNC($A9)+ROW($1:$25)-1,A9,14/24+TRUNC($A9)+ROW($1:$25)-1))>0,IF(B9>18/24+TRUNC($A9)+ROW($1:$25)-1,18/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>14/24+TRUNC($A9)+ROW($1:$25)-1,A9,14/24+TRUNC($A9)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A9)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B9>17/24+TRUNC($A9)+ROW($1:$25)-1,17/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>14/24+TRUNC($A9)+ROW($1:$25)-1,A9,14/24+TRUNC($A9)+ROW($1:$25)-1))>0,IF(B9>17/24+TRUNC($A9)+ROW($1:$25)-1,17/24+TRUNC($A9)+ROW($1:$25)-1,B9)-IF(A9>14/24+TRUNC($A9)+ROW($1:$25)-1,A9,14/24+TRUNC($A9)+ROW($1:$25)-1),0)))","v":0.20763888888177462}]
["2024-10-01T00:15:00","2024-10-18T09:33:00",null,4.356249999938882,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A10)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B10>13/24+TRUNC($A10)+ROW($1:$25)-1,13/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>9/24+TRUNC($A10)+ROW($1:$25)-1,A10,9/24+TRUNC($A10)+ROW($1:$25)-1))>0,IF(B10>13/24+TRUNC($A10)+ROW($1:$25)-1,13/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>9/24+TRUNC($A10)+ROW($1:$25)-1,A10,9/24+TRUNC($A10)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A10)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A10)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B10>18/24+TRUNC($A10)+ROW($1:$25)-1,18/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>14/24+TRUNC($A10)+ROW($1:$25)-1,A10,14/24+TRUNC($A10)+ROW($1:$25)-1))>0,IF(B10>18/24+TRUNC($A10)+ROW($1:$25)-1,18/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>14/24+TRUNC($A10)+ROW($1:$25)-1,A10,14/24+TRUNC($A10)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A10)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B10>17/24+TRUNC($A10)+ROW($1:$25)-1,17/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>14/24+TRUNC($A10)+ROW($1:$25)-1,A10,14/24+TRUNC($A10)+ROW($1:$25)-1))>0,IF(B10>17/24+TRUNC($A10)+ROW($1:$25)-1,17/24+TRUNC($A10)+ROW($1:$25)-1,B10)-IF(A10>14/24+TRUNC($A10)+ROW($1:$25)-1,A10,14/24+TRUNC($A10)+ROW($1:$25)-1),0)))","v":4.356249999938882}]
["2024-11-02T15:00:00","2024-11-02T20:00:00",null,8.3333333335758653E-2,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A11)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B11>13/24+TRUNC($A11)+ROW($1:$25)-1,13/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>9/24+TRUNC($A11)+ROW($1:$25)-1,A11,9/24+TRUNC($A11)+ROW($1:$25)-1))>0,IF(B11>13/24+TRUNC($A11)+ROW($1:$25)-1,13/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>9/24+TRUNC($A11)+ROW($1:$25)-1,A11,9/24+TRUNC($A11)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A11)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A11)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B11>18/24+TRUNC($A11)+ROW($1:$25)-1,18/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>14/24+TRUNC($A11)+ROW($1:$25)-1,A11,14/24+TRUNC($A11)+ROW($1:$25)-1))>0,IF(B11>18/24+TRUNC($A11)+ROW($1:$25)-1,18/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>14/24+TRUNC($A11)+ROW($1:$25)-1,A11,14/24+TRUNC($A11)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A11)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B11>17/24+TRUNC($A11)+ROW($1:$25)-1,17/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>14/24+TRUNC($A11)+ROW($1:$25)-1,A11,14/24+TRUNC($A11)+ROW($1:$25)-1))>0,IF(B11>17/24+TRUNC($A11)+ROW($1:$25)-1,17/24+TRUNC($A11)+ROW($1:$25)-1,B11)-IF(A11>14/24+TRUNC($A11)+ROW($1:$25)-1,A11,14/24+TRUNC($A11)+ROW($1:$25)-1),0)))","v":8.3333333335758653E-2}]
["2024-01-01T15:00:00","2024-01-09T11:00:00",null,8.3333333335758653E-2,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A12)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B12>13/24+TRUNC($A12)+ROW($1:$25)-1,13/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>9/24+TRUNC($A12)+ROW($1:$25)-1,A12,9/24+TRUNC($A12)+ROW($1:$25)-1))>0,IF(B12>13/24+TRUNC($A12)+ROW($1:$25)-1,13/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>9/24+TRUNC($A12)+ROW($1:$25)-1,A12,9/24+TRUNC($A12)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A12)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A12)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B12>18/24+TRUNC($A12)+ROW($1:$25)-1,18/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>14/24+TRUNC($A12)+ROW($1:$25)-1,A12,14/24+TRUNC($A12)+ROW($1:$25)-1))>0,IF(B12>18/24+TRUNC($A12)+ROW($1:$25)-1,18/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>14/24+TRUNC($A12)+ROW($1:$25)-1,A12,14/24+TRUNC($A12)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A12)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B12>17/24+TRUNC($A12)+ROW($1:$25)-1,17/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>14/24+TRUNC($A12)+ROW($1:$25)-1,A12,14/24+TRUNC($A12)+ROW($1:$25)-1))>0,IF(B12>17/24+TRUNC($A12)+ROW($1:$25)-1,17/24+TRUNC($A12)+ROW($1:$25)-1,B12)-IF(A12>14/24+TRUNC($A12)+ROW($1:$25)-1,A12,14/24+TRUNC($A12)+ROW($1:$25)-1),0)))","v":8.3333333335758653E-2}]
["2024-05-01T15:00:00","2024-05-01T20:00:00",null,0,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A13)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B13>13/24+TRUNC($A13)+ROW($1:$25)-1,13/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>9/24+TRUNC($A13)+ROW($1:$25)-1,A13,9/24+TRUNC($A13)+ROW($1:$25)-1))>0,IF(B13>13/24+TRUNC($A13)+ROW($1:$25)-1,13/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>9/24+TRUNC($A13)+ROW($1:$25)-1,A13,9/24+TRUNC($A13)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A13)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A13)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B13>18/24+TRUNC($A13)+ROW($1:$25)-1,18/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>14/24+TRUNC($A13)+ROW($1:$25)-1,A13,14/24+TRUNC($A13)+ROW($1:$25)-1))>0,IF(B13>18/24+TRUNC($A13)+ROW($1:$25)-1,18/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>14/24+TRUNC($A13)+ROW($1:$25)-1,A13,14/24+TRUNC($A13)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A13)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B13>17/24+TRUNC($A13)+ROW($1:$25)-1,17/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>14/24+TRUNC($A13)+ROW($1:$25)-1,A13,14/24+TRUNC($A13)+ROW($1:$25)-1))>0,IF(B13>17/24+TRUNC($A13)+ROW($1:$25)-1,17/24+TRUNC($A13)+ROW($1:$25)-1,B13)-IF(A13>14/24+TRUNC($A13)+ROW($1:$25)-1,A13,14/24+TRUNC($A13)+ROW($1:$25)-1),0)))","v":0}]
["2024-10-29T15:00:00","2024-10-30T20:00:00",null,0.45833333332848269,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A14)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B14>13/24+TRUNC($A14)+ROW($1:$25)-1,13/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>9/24+TRUNC($A14)+ROW($1:$25)-1,A14,9/24+TRUNC($A14)+ROW($1:$25)-1))>0,IF(B14>13/24+TRUNC($A14)+ROW($1:$25)-1,13/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>9/24+TRUNC($A14)+ROW($1:$25)-1,A14,9/24+TRUNC($A14)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A14)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A14)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B14>18/24+TRUNC($A14)+ROW($1:$25)-1,18/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>14/24+TRUNC($A14)+ROW($1:$25)-1,A14,14/24+TRUNC($A14)+ROW($1:$25)-1))>0,IF(B14>18/24+TRUNC($A14)+ROW($1:$25)-1,18/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>14/24+TRUNC($A14)+ROW($1:$25)-1,A14,14/24+TRUNC($A14)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A14)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B14>17/24+TRUNC($A14)+ROW($1:$25)-1,17/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>14/24+TRUNC($A14)+ROW($1:$25)-1,A14,14/24+TRUNC($A14)+ROW($1:$25)-1))>0,IF(B14>17/24+TRUNC($A14)+ROW($1:$25)-1,17/24+TRUNC($A14)+ROW($1:$25)-1,B14)-IF(A14>14/24+TRUNC($A14)+ROW($1:$25)-1,A14,14/24+TRUNC($A14)+ROW($1:$25)-1),0)))","v":0.45833333332848269}]
["2024-10-09T11:30:00","2024-10-09T23:00:00",null,0.22916666666424135,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A15)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B15>13/24+TRUNC($A15)+ROW($1:$25)-1,13/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>9/24+TRUNC($A15)+ROW($1:$25)-1,A15,9/24+TRUNC($A15)+ROW($1:$25)-1))>0,IF(B15>13/24+TRUNC($A15)+ROW($1:$25)-1,13/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>9/24+TRUNC($A15)+ROW($1:$25)-1,A15,9/24+TRUNC($A15)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A15)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A15)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B15>18/24+TRUNC($A15)+ROW($1:$25)-1,18/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>14/24+TRUNC($A15)+ROW($1:$25)-1,A15,14/24+TRUNC($A15)+ROW($1:$25)-1))>0,IF(B15>18/24+TRUNC($A15)+ROW($1:$25)-1,18/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>14/24+TRUNC($A15)+ROW($1:$25)-1,A15,14/24+TRUNC($A15)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A15)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B15>17/24+TRUNC($A15)+ROW($1:$25)-1,17/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>14/24+TRUNC($A15)+ROW($1:$25)-1,A15,14/24+TRUNC($A15)+ROW($1:$25)-1))>0,IF(B15>17/24+TRUNC($A15)+ROW($1:$25)-1,17/24+TRUNC($A15)+ROW($1:$25)-1,B15)-IF(A15>14/24+TRUNC($A15)+ROW($1:$25)-1,A15,14/24+TRUNC($A15)+ROW($1:$25)-1),0)))","v":0.22916666666424135}]
["2024-10-30T11:30:00","2024-11-02T16:25:00",null,1.163194444430701,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A16)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B16>13/24+TRUNC($A16)+ROW($1:$25)-1,13/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>9/24+TRUNC($A16)+ROW($1:$25)-1,A16,9/24+TRUNC($A16)+ROW($1:$25)-1))>0,IF(B16>13/24+TRUNC($A16)+ROW($1:$25)-1,13/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>9/24+TRUNC($A16)+ROW($1:$25)-1,A16,9/24+TRUNC($A16)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A16)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A16)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B16>18/24+TRUNC($A16)+ROW($1:$25)-1,18/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>14/24+TRUNC($A16)+ROW($1:$25)-1,A16,14/24+TRUNC($A16)+ROW($1:$25)-1))>0,IF(B16>18/24+TRUNC($A16)+ROW($1:$25)-1,18/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>14/24+TRUNC($A16)+ROW($1:$25)-1,A16,14/24+TRUNC($A16)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A16)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B16>17/24+TRUNC($A16)+ROW($1:$25)-1,17/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>14/24+TRUNC($A16)+ROW($1:$25)-1,A16,14/24+TRUNC($A16)+ROW($1:$25)-1))>0,IF(B16>17/24+TRUNC($A16)+ROW($1:$25)-1,17/24+TRUNC($A16)+ROW($1:$25)-1,B16)-IF(A16>14/24+TRUNC($A16)+ROW($1:$25)-1,A16,14/24+TRUNC($A16)+ROW($1:$25)-1),0)))","v":1.163194444430701}]
["2024-05-08T16:57:00","2024-05-13T09:05:00",null,5.5555555518367328E-3,{"$f":"SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A17)+ROW($1:$25)-1,Тб[Вых],0))))*(IF((IF(B17>13/24+TRUNC($A17)+ROW($1:$25)-1,13/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>9/24+TRUNC($A17)+ROW($1:$25)-1,A17,9/24+TRUNC($A17)+ROW($1:$25)-1))>0,IF(B17>13/24+TRUNC($A17)+ROW($1:$25)-1,13/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>9/24+TRUNC($A17)+ROW($1:$25)-1,A17,9/24+TRUNC($A17)+ROW($1:$25)-1),0)))+SUMPRODUCT((NOT(ISNUMBER(MATCH(TRUNC($A17)+ROW($1:$25)-1,Тб[Вых],0))))*NOT(ISNUMBER(MATCH(TRUNC($A17)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B17>18/24+TRUNC($A17)+ROW($1:$25)-1,18/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>14/24+TRUNC($A17)+ROW($1:$25)-1,A17,14/24+TRUNC($A17)+ROW($1:$25)-1))>0,IF(B17>18/24+TRUNC($A17)+ROW($1:$25)-1,18/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>14/24+TRUNC($A17)+ROW($1:$25)-1,A17,14/24+TRUNC($A17)+ROW($1:$25)-1),0)))+SUMPRODUCT((ISNUMBER(MATCH(TRUNC($A17)+ROW($1:$25)-1,Тб[Сокр],0)))*(IF((IF(B17>17/24+TRUNC($A17)+ROW($1:$25)-1,17/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>14/24+TRUNC($A17)+ROW($1:$25)-1,A17,14/24+TRUNC($A17)+ROW($1:$25)-1))>0,IF(B17>17/24+TRUNC($A17)+ROW($1:$25)-1,17/24+TRUNC($A17)+ROW($1:$25)-1,B17)-IF(A17>14/24+TRUNC($A17)+ROW($1:$25)-1,A17,14/24+TRUNC($A17)+ROW($1:$25)-1),0)))","v":5.5555555518367328E-3}]

{"sheet":"Для_макроса","index":1,"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"]

{"sheet":"Для_формулы","index":2,"n_rows":119,"n_cols":4,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
["Вых","Сокр",null,"Вых - все нерабочие дни."]
["2024-01-01","2024-03-07",null,"Сокр - сокращенные предпраздничные дни."]
["2024-01-02","2024-05-08"]
["2024-01-03","2024-06-11"]
["2024-01-04","2024-11-02"]
["2024-01-05"]
["2024-01-06"]
["2024-01-07"]
["2024-01-08"]
["2024-01-13"]
["2024-01-14"]
["2024-01-20"]
["2024-01-21"]
["2024-01-27"]
["2024-01-28"]
["2024-02-03"]
["2024-02-04"]
["2024-02-10"]
["2024-02-11"]
["2024-02-17"]
["2024-02-18"]
["2024-02-23"]
["2024-02-24"]
["2024-02-25"]
["2024-03-02"]
["2024-03-03"]
["2024-03-08"]
["2024-03-09"]
["2024-03-10"]
["2024-03-16"]
["2024-03-17"]
["2024-03-23"]
["2024-03-24"]
["2024-03-30"]
["2024-03-31"]
["2024-04-06"]
["2024-04-07"]
["2024-04-13"]
["2024-04-14"]
["2024-04-20"]
["2024-04-21"]
["2024-04-28"]
["2024-04-29"]
["2024-04-30"]
["2024-05-01"]
["2024-05-04"]
["2024-05-05"]
["2024-05-09"]
["2024-05-10"]
["2024-05-11"]
["2024-05-12"]
["2024-05-18"]
["2024-05-19"]
["2024-05-25"]
["2024-05-26"]
["2024-06-01"]
["2024-06-02"]
["2024-06-08"]
["2024-06-09"]
["2024-06-12"]
["2024-06-15"]
["2024-06-16"]
["2024-06-22"]
["2024-06-23"]
["2024-06-29"]
["2024-06-30"]
["2024-07-06"]
["2024-07-07"]
["2024-07-13"]
["2024-07-14"]
["2024-07-20"]
["2024-07-21"]
["2024-07-27"]
["2024-07-28"]
["2024-08-03"]
["2024-08-04"]
["2024-08-10"]
["2024-08-11"]
["2024-08-17"]
["2024-07-18"]
["2024-08-24"]
["2024-08-25"]
["2024-08-31"]
["2024-09-01"]
["2024-09-07"]
["2024-09-08"]
["2024-09-14"]
["2024-09-15"]
["2024-09-21"]
["2024-09-22"]
["2024-09-28"]
["2024-09-29"]
["2024-10-05"]
["2024-10-06"]
["2024-10-12"]
["2024-10-13"]
["2024-10-19"]
["2024-10-20"]
["2024-10-26"]
["2024-10-27"]
["2024-11-03"]
["2024-11-04"]
["2024-11-09"]
["2024-11-10"]
["2024-11-16"]
["2024-11-17"]
["2024-11-23"]
["2024-11-24"]
["2024-11-30"]
["2024-12-01"]
["2024-12-07"]
["2024-12-08"]
["2024-12-14"]
["2024-12-15"]
["2024-12-21"]
["2024-12-22"]
["2024-12-29"]
["2024-12-30"]
["2024-12-31"]