{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Главная страница","14 (8)"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"1904"}

{"sheet":"Главная страница","index":0,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[39,2,40,19]]}
[]
[null,null,"Выбор графика: "]
[null,null,"4 машины, 8 рейсов"]
[null,null,"5 машин, 8 рейсов"]
[null,null,"6 машин, 8 рейсов"]
[null,null,"7 машин, 8 рейсов"]
[null,null,"8 машин, 8 рейсов"]
[null,null,"9 машин, 8 рейсов"]
[null,null,"10 машин, 8 рейсов"]
[null,null,"11 машин, 8 рейсов"]
[null,null,"12 машин, 8 рейсов"]
[null,null,"13 машин, 8 рейсов"]
[null,null,"14 машин, 8 рейсов"]
[]
[]
[null,null,"На каждом листе заполняются только следующие ячейки: "]
[]
[null,null,null," - \"время рейса\", т.е. среднее время прохождения дистанции от одной конечной до другой"]
[]
[null,null,null,"- минимальное время отдыха на конечной"]
[]
[null,null,null," - максимальное время отдыха на конечной"]
[]
[null,null,"06:45:00"," - время выхода на линию самой первой машины"]
[]
[null,null,null," - интервал выхода машин на линию"]
[]
[null,null,"Рейсам,которые следуют не подряд один за другим, а через промежутки (дежурные и т.п.) следует проставлять время в ячейке вместо формулы, предварительно убрав защиту листа. "]
[]
[]
[null,null,"Правила автоматического закрашивания ячеек в таблице:"]
[]
[null,null,null,"- время отдыха на конечной укладываетсяв заданный диапазон между минимальным и максимальным"]
[]
[null,null,null," - время отдыха на конечной равно или превышает максимальное "]
[]
[null,null,null,"- время отдыха не соответствует минимально заданному. При отрицательном значении показывает на сколько минут автобус не успевает на свой следующий рейс"]
[null,null,"Сумма интервалов между машинами в рамках одного рейса не должна быть меньше времени рейса. Иначе машины не будут успевать на следующий рейс. "]
[]
[null,null,"Также под столбцом первого рейса расположена ячейка, которая суммирует все интервалы первого рейса и тем самым показывает достаточно ли времени для совершения рейса без опозданий. Если сумма интервалов меньше времени рейса, то ячейка окрашивается в красный цвет. "]
[]
[]
[]
[null,null,"Расчет времени выезда нулевого рейса:"]
[null,null,"среднее время рейса: 1:15 - 1:25",null,null,null,null,null,null,"в среднем:","01:20:00"]
[null,null,"с зорге до гимеина: 0:31 - 0:37",null,null,null,null,null,null,"в среднем:","00:34:00"]
[null,null,"с гимеина до колонии: ",null,null,null,"01:20:00","-","00:34:00","=",{"$f":"G47-I47","v":"00:46:00"}]
[null,null,"с колонии до гимеина: 0:42 - 0:47",null,null,null,null,null,null,"в среднем:","00:45:00"]
[null,null,"с гимеина до зорге: ",null,null,null,"01:20:00","-","00:45:00","=",{"$f":"G49-I49","v":"00:35:00"}]
[]
[null,null,"время выезда 1 графика:","06:45:00"]
[null,null,"подъедет к гимеину через:",{"$f":"K46","v":"00:34:00"},{"$f":"D51+D52","v":"07:19:00"}]
[null,null,"утренний интервал:","00:08:00"]
[null,null,"выезд 0-рейса с гимеина:",{"$f":"D51+D52-D53","v":"07:11:00"}]

{"sheet":"14 (8)","index":1,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,20,5,21],[6,20,6,21],[11,0,12,0],[7,0,8,0],[5,0,6,0],[5,2,5,18]]}
[]
[]
[]
[]
[]
["Назад",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"суммарное время в пути"]
[null,null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,null,"суммарное время отдыха"]
["время рейса:",null,1,"06:45:00",null,{"$f":"IFERROR(IF(OR(D34=0,D35=0),\"\",D34+D35/1440),\"\")","v":"08:37:00"},null,{"$f":"IFERROR(IF(OR(F34=0,F35=0),\"\",F34+F35/1440),\"\")","v":"10:29:00"},null,{"$f":"IFERROR(IF(OR(H34=0,H35=0),\"\",H34+H35/1440),\"\")","v":"12:21:00"},null,{"$f":"IFERROR(IF(OR(J34=0,J35=0),\"\",J34+J35/1440),\"\")","v":"14:13:00"},null,{"$f":"IFERROR(IF(OR(L34=0,L35=0),\"\",L34+L35/1440),\"\")","v":"16:05:00"},null,{"$f":"IFERROR(IF(OR(N34=0,N35=0),\"\",N34+N35/1440),\"\")","v":"17:57:00"},null,{"$f":"IFERROR(IF(OR(P34=0,P35=0),\"\",P34+P35/1440),\"\")","v":""},1,null,{"$f":"(COUNT(D8,F8,H8,J8,L8,N8,P8,R8))*$A$10","v":"09:20:00"},"всего:"]
[null,null,1,8,{"$f":"IFERROR((F8-D8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H8-F8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J8-H8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L8-J8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N8-L8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P8-N8)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R8-P8)-$A$10,\"\")","v":""},null,1,null,{"$f":"SUM(E9,G9,I9,K9,M9,O9,Q9)","v":"03:12:00"},{"$f":"U9+U8","v":"12:32:00"}]
["01:20:00",null,2,{"$f":"IFERROR(IF(OR(D8=0,D9=0),\"\",D8+D9/1440),\"\")","v":"06:53:00"},null,{"$f":"IFERROR(IF(OR(F8=0,F9=0),\"\",F8+F9/1440),\"\")","v":"08:45:00"},null,{"$f":"IFERROR(IF(OR(H8=0,H9=0),\"\",H8+H9/1440),\"\")","v":"10:37:00"},null,{"$f":"IFERROR(IF(OR(J8=0,J9=0),\"\",J8+J9/1440),\"\")","v":"12:29:00"},null,{"$f":"IFERROR(IF(OR(L8=0,L9=0),\"\",L8+L9/1440),\"\")","v":"14:21:00"},null,{"$f":"IFERROR(IF(OR(N8=0,N9=0),\"\",N8+N9/1440),\"\")","v":"16:13:00"},null,{"$f":"IFERROR(IF(OR(P8=0,P9=0),\"\",P8+P9/1440),\"\")","v":"18:05:00"},null,{"$f":"IFERROR(IF(OR(R8=0,R9=0),\"\",R8+R9/1440),\"\")","v":""},2,null,{"$f":"(COUNT(D10,F10,H10,J10,L10,N10,P10,R10))*$A$10","v":"09:20:00"}]
[null,null,2,8,{"$f":"IFERROR((F10-D10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H10-F10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J10-H10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L10-J10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N10-L10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P10-N10)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R10-P10)-$A$10,\"\")","v":""},null,2,null,{"$f":"SUM(E11,G11,I11,K11,M11,O11,Q11)","v":"03:12:00"},{"$f":"U10+U11","v":"12:32:00"}]
["время отдыха (мин, макс):",null,3,{"$f":"IFERROR(IF(OR(D10=0,D11=0),\"\",D10+D11/1440),\"\")","v":"07:01:00"},null,{"$f":"IFERROR(IF(OR(F10=0,F11=0),\"\",F10+F11/1440),\"\")","v":"08:53:00"},null,{"$f":"IFERROR(IF(OR(H10=0,H11=0),\"\",H10+H11/1440),\"\")","v":"10:45:00"},null,{"$f":"IFERROR(IF(OR(J10=0,J11=0),\"\",J10+J11/1440),\"\")","v":"12:37:00"},null,{"$f":"IFERROR(IF(OR(L10=0,L11=0),\"\",L10+L11/1440),\"\")","v":"14:29:00"},null,{"$f":"IFERROR(IF(OR(N10=0,N11=0),\"\",N10+N11/1440),\"\")","v":"16:21:00"},null,{"$f":"IFERROR(IF(OR(P10=0,P11=0),\"\",P10+P11/1440),\"\")","v":"18:13:00"},null,{"$f":"IFERROR(IF(OR(R10=0,R11=0),\"\",R10+R11/1440),\"\")","v":""},3,null,{"$f":"(COUNT(D12,F12,H12,J12,L12,N12,P12,R12))*$A$10","v":"09:20:00"}]
[null,null,3,8,{"$f":"IFERROR((F12-D12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H12-F12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J12-H12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L12-J12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N12-L12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P12-N12)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R12-P12)-$A$10,\"\")","v":""},null,3,null,{"$f":"SUM(E13,G13,I13,K13,M13,O13,Q13)","v":"03:12:00"},{"$f":"U12+U13","v":"12:32:00"}]
["00:10:00",null,4,{"$f":"IFERROR(IF(OR(D12=0,D13=0),\"\",D12+D13/1440),\"\")","v":"07:09:00"},null,{"$f":"IFERROR(IF(OR(F12=0,F13=0),\"\",F12+F13/1440),\"\")","v":"09:01:00"},null,{"$f":"IFERROR(IF(OR(H12=0,H13=0),\"\",H12+H13/1440),\"\")","v":"10:53:00"},null,{"$f":"IFERROR(IF(OR(J12=0,J13=0),\"\",J12+J13/1440),\"\")","v":"12:45:00"},null,{"$f":"IFERROR(IF(OR(L12=0,L13=0),\"\",L12+L13/1440),\"\")","v":"14:37:00"},null,{"$f":"IFERROR(IF(OR(N12=0,N13=0),\"\",N12+N13/1440),\"\")","v":"16:29:00"},null,{"$f":"IFERROR(IF(OR(P12=0,P13=0),\"\",P12+P13/1440),\"\")","v":"18:21:00"},null,{"$f":"IFERROR(IF(OR(R12=0,R13=0),\"\",R12+R13/1440),\"\")","v":""},4,null,{"$f":"(COUNT(D14,F14,H14,J14,L14,N14,P14,R14))*$A$10","v":"09:20:00"}]
["00:40:00",null,4,8,{"$f":"IFERROR((F14-D14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H14-F14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J14-H14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L14-J14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N14-L14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P14-N14)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R14-P14)-$A$10,\"\")","v":""},null,4,null,{"$f":"SUM(E15,G15,I15,K15,M15,O15,Q15)","v":"03:12:00"},{"$f":"U14+U15","v":"12:32:00"}]
[null,null,5,{"$f":"IFERROR(IF(OR(D14=0,D15=0),\"\",D14+D15/1440),\"\")","v":"07:17:00"},null,{"$f":"IFERROR(IF(OR(F14=0,F15=0),\"\",F14+F15/1440),\"\")","v":"09:09:00"},null,{"$f":"IFERROR(IF(OR(H14=0,H15=0),\"\",H14+H15/1440),\"\")","v":"11:01:00"},null,{"$f":"IFERROR(IF(OR(J14=0,J15=0),\"\",J14+J15/1440),\"\")","v":"12:53:00"},null,{"$f":"IFERROR(IF(OR(L14=0,L15=0),\"\",L14+L15/1440),\"\")","v":"14:45:00"},null,{"$f":"IFERROR(IF(OR(N14=0,N15=0),\"\",N14+N15/1440),\"\")","v":"16:37:00"},null,{"$f":"IFERROR(IF(OR(P14=0,P15=0),\"\",P14+P15/1440),\"\")","v":"18:29:00"},null,{"$f":"IFERROR(IF(OR(R14=0,R15=0),\"\",R14+R15/1440),\"\")","v":""},5,null,{"$f":"(COUNT(D16,F16,H16,J16,L16,N16,P16,R16))*$A$10","v":"09:20:00"}]
[null,null,5,8,{"$f":"IFERROR((F16-D16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H16-F16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J16-H16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L16-J16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N16-L16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P16-N16)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R16-P16)-$A$10,\"\")","v":""},null,5,null,{"$f":"SUM(E17,G17,I17,K17,M17,O17,Q17)","v":"03:12:00"},{"$f":"U16+U17","v":"12:32:00"}]
[null,null,6,{"$f":"IFERROR(IF(OR(D16=0,D17=0),\"\",D16+D17/1440),\"\")","v":"07:25:00"},null,{"$f":"IFERROR(IF(OR(F16=0,F17=0),\"\",F16+F17/1440),\"\")","v":"09:17:00"},null,{"$f":"IFERROR(IF(OR(H16=0,H17=0),\"\",H16+H17/1440),\"\")","v":"11:09:00"},null,{"$f":"IFERROR(IF(OR(J16=0,J17=0),\"\",J16+J17/1440),\"\")","v":"13:01:00"},null,{"$f":"IFERROR(IF(OR(L16=0,L17=0),\"\",L16+L17/1440),\"\")","v":"14:53:00"},null,{"$f":"IFERROR(IF(OR(N16=0,N17=0),\"\",N16+N17/1440),\"\")","v":"16:45:00"},null,{"$f":"IFERROR(IF(OR(P16=0,P17=0),\"\",P16+P17/1440),\"\")","v":"18:37:00"},null,{"$f":"IFERROR(IF(OR(R16=0,R17=0),\"\",R16+R17/1440),\"\")","v":""},6,null,{"$f":"(COUNT(D18,F18,H18,J18,L18,N18,P18,R18))*$A$10","v":"09:20:00"}]
[null,null,6,8,{"$f":"IFERROR((F18-D18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H18-F18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J18-H18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L18-J18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N18-L18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P18-N18)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R18-P18)-$A$10,\"\")","v":""},null,6,null,{"$f":"SUM(E19,G19,I19,K19,M19,O19,Q19)","v":"03:12:00"},{"$f":"U18+U19","v":"12:32:00"}]
[null,null,7,{"$f":"IFERROR(IF(OR(D18=0,D19=0),\"\",D18+D19/1440),\"\")","v":"07:33:00"},null,{"$f":"IFERROR(IF(OR(F18=0,F19=0),\"\",F18+F19/1440),\"\")","v":"09:25:00"},null,{"$f":"IFERROR(IF(OR(H18=0,H19=0),\"\",H18+H19/1440),\"\")","v":"11:17:00"},null,{"$f":"IFERROR(IF(OR(J18=0,J19=0),\"\",J18+J19/1440),\"\")","v":"13:09:00"},null,{"$f":"IFERROR(IF(OR(L18=0,L19=0),\"\",L18+L19/1440),\"\")","v":"15:01:00"},null,{"$f":"IFERROR(IF(OR(N18=0,N19=0),\"\",N18+N19/1440),\"\")","v":"16:53:00"},null,{"$f":"IFERROR(IF(OR(P18=0,P19=0),\"\",P18+P19/1440),\"\")","v":"18:45:00"},null,{"$f":"IFERROR(IF(OR(R18=0,R19=0),\"\",R18+R19/1440),\"\")","v":""},7,null,{"$f":"(COUNT(D20,F20,H20,J20,L20,N20,P20,R20))*$A$10","v":"09:20:00"}]
[null,null,7,8,{"$f":"IFERROR((F20-D20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H20-F20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J20-H20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L20-J20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N20-L20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P20-N20)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((R20-P20)-$A$10,\"\")","v":""},30,7,null,{"$f":"SUM(E21,G21,I21,K21,M21,O21,Q21)","v":"03:12:00"},{"$f":"U20+U21","v":"12:32:00"}]
[null,null,8,{"$f":"IFERROR(IF(OR(D20=0,D21=0),\"\",D20+D21/1440),\"\")","v":"07:41:00"},null,{"$f":"IFERROR(IF(OR(F20=0,F21=0),\"\",F20+F21/1440),\"\")","v":"09:33:00"},null,{"$f":"IFERROR(IF(OR(H20=0,H21=0),\"\",H20+H21/1440),\"\")","v":"11:25:00"},null,{"$f":"IFERROR(IF(OR(J20=0,J21=0),\"\",J20+J21/1440),\"\")","v":"13:17:00"},null,{"$f":"IFERROR(IF(OR(L20=0,L21=0),\"\",L20+L21/1440),\"\")","v":"15:09:00"},null,{"$f":"IFERROR(IF(OR(N20=0,N21=0),\"\",N20+N21/1440),\"\")","v":"17:01:00"},null,{"$f":"IFERROR(IF(OR(P20=0,P21=0),\"\",P20+P21/1440),\"\")","v":"18:53:00"},null,{"$f":"IFERROR(IF(OR(R20=0,R21=0),\"\",R20+R21/1440),\"\")","v":""},8,null,{"$f":"(COUNT(D22,F22,H22,J22,L22,N22,P22,R22))*$A$10","v":"09:20:00"}]
[null,null,8,8,{"$f":"IFERROR((F22-D22)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H22-F22)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J22-H22)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L22-J22)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N22-L22)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P22-N22)-$A$10,\"\")","v":"00:32:00"},7,{"$f":"IFERROR((R22-P22)-$A$10,\"\")","v":""},null,8,null,{"$f":"SUM(E23,G23,I23,K23,M23,O23,Q23)","v":"03:12:00"},{"$f":"U22+U23","v":"12:32:00"}]
[null,null,9,{"$f":"IFERROR(IF(OR(D22=0,D23=0),\"\",D22+D23/1440),\"\")","v":"07:49:00"},null,{"$f":"IFERROR(IF(OR(F22=0,F23=0),\"\",F22+F23/1440),\"\")","v":"09:41:00"},null,{"$f":"IFERROR(IF(OR(H22=0,H23=0),\"\",H22+H23/1440),\"\")","v":"11:33:00"},null,{"$f":"IFERROR(IF(OR(J22=0,J23=0),\"\",J22+J23/1440),\"\")","v":"13:25:00"},null,{"$f":"IFERROR(IF(OR(L22=0,L23=0),\"\",L22+L23/1440),\"\")","v":"15:17:00"},null,{"$f":"IFERROR(IF(OR(N22=0,N23=0),\"\",N22+N23/1440),\"\")","v":"17:09:00"},null,{"$f":"IFERROR(IF(OR(P22=0,P23=0),\"\",P22+P23/1440),\"\")","v":"19:00:00"},null,{"$f":"IFERROR(IF(OR(R22=0,R23=0),\"\",R22+R23/1440),\"\")","v":""},9,null,{"$f":"(COUNT(D24,F24,H24,J24,L24,N24,P24,R24))*$A$10","v":"09:20:00"}]
[null,null,9,8,{"$f":"IFERROR((F24-D24)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H24-F24)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J24-H24)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L24-J24)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N24-L24)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P24-N24)-$A$10,\"\")","v":"00:31:00"},null,{"$f":"IFERROR((R24-P24)-$A$10,\"\")","v":""},null,9,null,{"$f":"SUM(E25,G25,I25,K25,M25,O25,Q25)","v":"03:11:00"},{"$f":"U24+U25","v":"12:31:00"}]
[null,null,10,{"$f":"IFERROR(IF(OR(D24=0,D25=0),\"\",D24+D25/1440),\"\")","v":"07:57:00"},null,{"$f":"IFERROR(IF(OR(F24=0,F25=0),\"\",F24+F25/1440),\"\")","v":"09:49:00"},null,{"$f":"IFERROR(IF(OR(H24=0,H25=0),\"\",H24+H25/1440),\"\")","v":"11:41:00"},null,{"$f":"IFERROR(IF(OR(J24=0,J25=0),\"\",J24+J25/1440),\"\")","v":"13:33:00"},null,{"$f":"IFERROR(IF(OR(L24=0,L25=0),\"\",L24+L25/1440),\"\")","v":"15:25:00"},null,{"$f":"IFERROR(IF(OR(N24=0,N25=0),\"\",N24+N25/1440),\"\")","v":"17:17:00"},null,{"$f":"IFERROR(IF(OR(P24=0,P25=0),\"\",P24+P25/1440),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(R24=0,R25=0),\"\",R24+R25/1440),\"\")","v":""},10,null,{"$f":"(COUNT(D26,F26,H26,J26,L26,N26,P26,R26))*$A$10","v":"08:00:00"}]
[null,null,10,8,{"$f":"IFERROR((F26-D26)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H26-F26)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J26-H26)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L26-J26)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N26-L26)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P26-N26)-$A$10,\"\")","v":""},20,{"$f":"IFERROR((R26-P26)-$A$10,\"\")","v":""},null,10,null,{"$f":"SUM(E27,G27,I27,K27,M27,O27,Q27)","v":"02:40:00"},{"$f":"U26+U27","v":"10:40:00"}]
[null,null,11,{"$f":"IFERROR(IF(OR(D26=0,D27=0),\"\",D26+D27/1440),\"\")","v":"08:05:00"},null,{"$f":"IFERROR(IF(OR(F26=0,F27=0),\"\",F26+F27/1440),\"\")","v":"09:57:00"},null,{"$f":"IFERROR(IF(OR(H26=0,H27=0),\"\",H26+H27/1440),\"\")","v":"11:49:00"},null,{"$f":"IFERROR(IF(OR(J26=0,J27=0),\"\",J26+J27/1440),\"\")","v":"13:41:00"},null,{"$f":"IFERROR(IF(OR(L26=0,L27=0),\"\",L26+L27/1440),\"\")","v":"15:33:00"},null,{"$f":"IFERROR(IF(OR(N26=0,N27=0),\"\",N26+N27/1440),\"\")","v":"17:25:00"},null,{"$f":"IFERROR(IF(OR(P26=0,P27=0),\"\",P26+P27/1440),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(R26=0,R27=0),\"\",R26+R27/1440),\"\")","v":""},11,null,{"$f":"(COUNT(D28,F28,H28,J28,L28,N28,P28,R28))*$A$10","v":"08:00:00"}]
[null,null,11,8,{"$f":"IFERROR((F28-D28)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H28-F28)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J28-H28)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L28-J28)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N28-L28)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P28-N28)-$A$10,\"\")","v":""},null,{"$f":"IFERROR((R28-P28)-$A$10,\"\")","v":""},30,11,null,{"$f":"SUM(E29,G29,I29,K29,M29,O29,Q29)","v":"02:40:00"},{"$f":"U28+U29","v":"10:40:00"}]
[null,null,12,{"$f":"IFERROR(IF(OR(D28=0,D29=0),\"\",D28+D29/1440),\"\")","v":"08:13:00"},null,{"$f":"IFERROR(IF(OR(F28=0,F29=0),\"\",F28+F29/1440),\"\")","v":"10:05:00"},null,{"$f":"IFERROR(IF(OR(H28=0,H29=0),\"\",H28+H29/1440),\"\")","v":"11:57:00"},null,{"$f":"IFERROR(IF(OR(J28=0,J29=0),\"\",J28+J29/1440),\"\")","v":"13:49:00"},null,{"$f":"IFERROR(IF(OR(L28=0,L29=0),\"\",L28+L29/1440),\"\")","v":"15:41:00"},null,{"$f":"IFERROR(IF(OR(N28=0,N29=0),\"\",N28+N29/1440),\"\")","v":"17:33:00"},null,{"$f":"IFERROR(IF(OR(P28=0,P29=0),\"\",P28+P29/1440),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(R28=0,R29=0),\"\",R28+R29/1440),\"\")","v":""},12,null,{"$f":"(COUNT(D30,F30,H30,J30,L30,N30,P30,R30))*$A$10","v":"08:00:00"}]
[null,null,12,8,{"$f":"IFERROR((F30-D30)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H30-F30)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J30-H30)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L30-J30)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N30-L30)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P30-N30)-$A$10,\"\")","v":""},20,{"$f":"IFERROR((R30-P30)-$A$10,\"\")","v":""},null,12,null,{"$f":"SUM(E31,G31,I31,K31,M31,O31,Q31)","v":"02:40:00"},{"$f":"U30+U31","v":"10:40:00"}]
[null,null,13,{"$f":"IFERROR(IF(OR(D30=0,D31=0),\"\",D30+D31/1440),\"\")","v":"08:21:00"},null,{"$f":"IFERROR(IF(OR(F30=0,F31=0),\"\",F30+F31/1440),\"\")","v":"10:13:00"},null,{"$f":"IFERROR(IF(OR(H30=0,H31=0),\"\",H30+H31/1440),\"\")","v":"12:05:00"},null,{"$f":"IFERROR(IF(OR(J30=0,J31=0),\"\",J30+J31/1440),\"\")","v":"13:57:00"},null,{"$f":"IFERROR(IF(OR(L30=0,L31=0),\"\",L30+L31/1440),\"\")","v":"15:49:00"},null,{"$f":"IFERROR(IF(OR(N30=0,N31=0),\"\",N30+N31/1440),\"\")","v":"17:41:00"},null,{"$f":"IFERROR(IF(OR(P30=0,P31=0),\"\",P30+P31/1440),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(R30=0,R31=0),\"\",R30+R31/1440),\"\")","v":""},13,null,{"$f":"(COUNT(D32,F32,H32,J32,L32,N32,P32,R32))*$A$10","v":"08:00:00"}]
[null,null,13,8,{"$f":"IFERROR((F32-D32)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H32-F32)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J32-H32)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L32-J32)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N32-L32)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P32-N32)-$A$10,\"\")","v":""},null,{"$f":"IFERROR((R32-P32)-$A$10,\"\")","v":""},null,13,null,{"$f":"SUM(E33,G33,I33,K33,M33,O33,Q33)","v":"02:40:00"},{"$f":"U32+U33","v":"10:40:00"}]
[null,null,14,{"$f":"IFERROR(IF(OR(D32=0,D33=0),\"\",D32+D33/1440),\"\")","v":"08:29:00"},null,{"$f":"IFERROR(IF(OR(F32=0,F33=0),\"\",F32+F33/1440),\"\")","v":"10:21:00"},null,{"$f":"IFERROR(IF(OR(H32=0,H33=0),\"\",H32+H33/1440),\"\")","v":"12:13:00"},null,{"$f":"IFERROR(IF(OR(J32=0,J33=0),\"\",J32+J33/1440),\"\")","v":"14:05:00"},null,{"$f":"IFERROR(IF(OR(L32=0,L33=0),\"\",L32+L33/1440),\"\")","v":"15:57:00"},null,{"$f":"IFERROR(IF(OR(N32=0,N33=0),\"\",N32+N33/1440),\"\")","v":"17:49:00"},null,{"$f":"IFERROR(IF(OR(P32=0,P33=0),\"\",P32+P33/1440),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(R32=0,R33=0),\"\",R32+R33/1440),\"\")","v":""},14,null,{"$f":"(COUNT(D34,F34,H34,J34,L34,N34,P34,R34))*$A$10","v":"08:00:00"}]
[null,null,14,8,{"$f":"IFERROR((F34-D34)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((H34-F34)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((J34-H34)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((L34-J34)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((N34-L34)-$A$10,\"\")","v":"00:32:00"},8,{"$f":"IFERROR((P34-N34)-$A$10,\"\")","v":""},20,{"$f":"IFERROR((R34-P34)-$A$10,\"\")","v":""},null,14,null,{"$f":"SUM(E35,G35,I35,K35,M35,O35,Q35)","v":"02:40:00"},{"$f":"U34+U35","v":"10:40:00"}]
[]
[null,null,"сумма интервалов: ",{"$f":"(D9+D11+D13+D15+D17+D19+D21+D23+D25+D27+D29+D31+D33+D35)/1440","v":"01:52:00"}]