{"text_format":"1","workbook":"xlsx","n_sheets":1,"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":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["№ Заявки","Дата создания","Дата закрытия","Период заявки без округления, дни.","Период заявки без округления, час.","день недели даты создания заявки","Период заявки, дни","Количество выходных дней в период заявки, дни","Количество часов выходных дней в период заявки, час","Период заявки без выходных дней, час.","время, затраченное на заявку в рамках рабочего графика, час."]
[1,2,3,"4 = 3 - 2","5 = 4 х [24]"," 5 =ДЕНЬНЕД(B3;2)","6  =ДНЕЙ360(B3;C3)","7 = ЕСЛИ(get_vih(F3;G3)=1;0;get_vih(F3;G3))","8 = 7 х [24]","9 = 5 -8","10 =ЦЕЛОЕ(J3/24)*9+((J3/24)-ЦЕЛОЕ(J3/24))*24"]
[48153,"2022-10-14T14:11:00","2022-10-19T15:51:00",{"$f":"C3-B3","v":5.0694444444452529},{"$f":"D3*24","v":121.66666666668607},{"$f":"WEEKDAY(B3,2)","v":5},{"$f":"DAYS360(B3,C3)","v":5},{"$f":"IF(get_vih(F3,G3)=1,0,get_vih(F3,G3))","v":2},{"$f":"H3*24","v":48},{"$f":"E3-I3","v":73.666666666686069},{"$f":"INT(J3/24)*9+((J3/24)-INT(J3/24))*24","v":28.666666666686069},null,null,null,null,null,{"$f":"get_vih(O3,P3)","v":0}]
[48024,"2022-10-04T21:08:00","2022-10-10T10:50:00",{"$f":"C4-B4","v":5.5708333333313931},{"$f":"D4*24","v":133.69999999995343},{"$f":"WEEKDAY(B4,2)","v":2},{"$f":"DAYS360(B4,C4)","v":6},{"$f":"IF(get_vih(F4,G4)=1,0,get_vih(F4,G4))","v":2},{"$f":"H4*24","v":48},{"$f":"E4-I4","v":85.699999999953434},{"$f":"INT(J4/24)*9+((J4/24)-INT(J4/24))*24","v":40.699999999953434},null,null,null,null,null,{"$f":"get_vih(O4,P4)","v":0}]
[48208,"2022-10-20T09:38:00","2022-10-26T15:12:00",6.2319444444437977,149.56666666665114,4,6,{"$f":"IF(get_vih(F5,G5)=1,0,get_vih(F5,G5))","v":2},48,101.56666666665114,41.566666666651145]
[48261,"2022-10-25T07:28:00","2022-10-31T17:36:00",6.4222222222160781,154.13333333318587,2,6,{"$f":"IF(get_vih(F6,G6)=1,0,get_vih(F6,G6))","v":2},48,106.13333333318587,46.133333333185874]
[48050,"2022-10-05T21:31:00","2022-10-12T10:30:00",6.5409722222248092,156.98333333339542,3,7,{"$f":"IF(get_vih(F7,G7)=1,0,get_vih(F7,G7))","v":2},48,108.98333333339542,48.983333333395422]
[48150,"2022-10-14T12:02:00","2022-10-25T11:10:00",10.963888888894871,263.13333333347691,5,11,{"$f":"IF(get_vih(F8,G8)=1,0,get_vih(F8,G8))","v":4},96,167.13333333347691,77.133333333476912]
[48073,"2022-10-07T11:55:00","2022-10-18T15:54:00",11.165972222217533,267.9833333332208,5,11,{"$f":"IF(get_vih(F9,G9)=1,0,get_vih(F9,G9))","v":4},96,171.9833333332208,66.983333333220799]
[48149,"2022-10-14T12:01:00","2022-10-25T18:49:00",11.283333333332848,270.79999999998836,5,11,{"$f":"IF(get_vih(F10,G10)=1,0,get_vih(F10,G10))","v":4},96,174.79999999998836,69.799999999988358]
[48122,"2022-10-12T17:08:00","2022-10-24T17:35:00",12.01875000000291,288.45000000006985,3,12,{"$f":"IF(get_vih(F11,G11)=1,0,get_vih(F11,G11))","v":4},96,192.45000000006985,72.450000000069849]
[48060,"2022-10-06T13:42:00","2022-10-19T15:33:00",13.077083333337214,313.85000000009313,4,13,{"$f":"IF(get_vih(F12,G12)=1,0,get_vih(F12,G12))","v":4},96,217.85000000009313,82.850000000093132]
[48186,"2022-10-18T21:21:00","2022-11-01T00:36:00",13.135416666671517,315.25000000011642,2,13,{"$f":"IF(get_vih(F13,G13)=1,0,get_vih(F13,G13))","v":4},96,219.25000000011642,84.250000000116415]
[48198,"2022-10-19T13:00:00","2022-11-01T16:33:00",13.147916666668607,315.55000000004657,3,12,{"$f":"IF(get_vih(F14,G14)=1,0,get_vih(F14,G14))","v":4},96,219.55000000004657,84.550000000046566]
[48192,"2022-10-19T11:29:00","2022-11-02T13:14:00",14.072916666664241,337.74999999994179,3,13,{"$f":"IF(get_vih(F15,G15)=1,0,get_vih(F15,G15))","v":4},96,241.74999999994179,91.749999999941792]
[48012,"2022-10-03T17:19:00","2022-10-20T14:48:00",16.895138888889051,405.48333333333721,1,17,{"$f":"IF(get_vih(F16,G16)=1,0,get_vih(F16,G16))","v":4},96,309.48333333333721,129.48333333333721]
[48051,"2022-10-05T23:52:00","2022-11-01T16:34:00",26.695833333338669,640.70000000012806,3,26,{"$f":"IF(get_vih(F17,G17)=1,0,get_vih(F17,G17))","v":8},192,448.70000000012806,178.70000000012806]
[48018,"2022-10-04T13:05:00","2022-11-02T15:07:00",29.084722222221899,698.03333333332557,2,28,{"$f":"IF(get_vih(F18,G18)=1,0,get_vih(F18,G18))","v":8},192,506.03333333332557,191.03333333332557]
["TECT"]
[48153,"2022-10-14T09:00:00","2022-10-15T18:00:00",{"$f":"C20-B20","v":1.375},{"$f":"D20*24","v":33},{"$f":"WEEKDAY(B20,2)","v":5},{"$f":"DAYS360(B20,C20)","v":1},{"$f":"IF(get_vih(F20,G20)=1,0,get_vih(F20,G20))","v":0},{"$f":"H20*24","v":0},{"$f":"E20-I20","v":33},{"$f":"INT(J20/24)*9+((J20/24)-INT(J20/24))*24","v":18}]
[]
[null,"График работы с 9 до 18"]