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