{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Ark1"],"read":"whole","date_system":"1900"}

{"sheet":"Ark1","index":0,"n_rows":73,"n_cols":30,"rows_kept":73,"merged":[[0,0,0,1],[0,4,0,10],[1,0,1,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[4,0,8,0],[4,18,28,22],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[9,0,13,0],[10,2,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[14,0,18,0],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[19,0,23,0],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[24,0,28,0],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[29,0,33,0],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[34,0,38,0],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,15],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[38,2,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[43,3,43,8],[60,2,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[60,10,60,11],[60,12,60,13],[60,14,60,15],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13],[61,14,61,15],[62,2,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13],[62,14,62,15],[63,2,63,3],[63,4,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,12,63,13],[63,14,63,15],[64,2,64,3],[64,4,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,15],[65,2,65,3],[65,4,65,5],[65,6,65,7],[65,8,65,9],[65,10,65,11],[65,12,65,13],[65,14,65,15],[66,2,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[66,12,66,13],[66,14,66,15]]}
["Antall uker i rotasjonen:",null,4,null,{"$f":"IF(Z43>0,\"Obs! Må godkjennes av forbund/LO/Arbeidstilsyn!\",IF(AD43>0,\"Obs! Må godkjennes av forbund/LO/Arbeidstilsyn!\",IF(AA43>0,\"Obs! Må godkjennes av TV!\",IF(AC43>0,\"Obs! Må godkjennes av TV!\",\"\"))))","v":""}]
["Antall timer/uke:",null,37.5]
[]
["Uke",null,"Mandag",null,"Tirsdag",null,"Onsdag",null,"Torsdag",null,"Fredag",null,"Lørdag",null,"Søndag"]
[1,"Start/slutt",{"$nulls":14},"Summer:","Betalte timer:","Velg antall uker i rotasjonen og deretter antall timer per uke som er gjeldende for gjennomsnittsberegningen (eks. 37,5 36,5 35,5 eller 33,6). I feltene for start og slutt føres klokkeslettene inn i formatet tt:mm (eks. 7:00).  I feltene for pause føres antall timer i hhv betalt og ubetalt pause (eks. en halv times pause skrives som 0,5 og en times pause som 1 osv.).  Dersom timetallet per dag eller uke overstiger tersklene i aml, vil du få melding om avtalen må godkjennes av hhv tillitsvalgt eller forbund/LO/Arbeidstilsynet."]
[null,"Arbeidstid",{"$f":"IF(C5<>\"\",DAY(C61)*24+HOUR(C61)+MINUTE(C61)/60,0)","v":0},null,{"$f":"IF(E5<>\"\",DAY(E61)*24+HOUR(E61)+MINUTE(E61)/60,0)","v":0},null,{"$f":"IF(G5<>\"\",DAY(G61)*24+HOUR(G61)+MINUTE(G61)/60,0)","v":0},null,{"$f":"IF(I5<>\"\",DAY(I61)*24+HOUR(I61)+MINUTE(I61)/60,0)","v":0},null,{"$f":"IF(K5<>\"\",DAY(K61)*24+HOUR(K61)+MINUTE(K61)/60,0)","v":0},null,{"$f":"IF(M5<>\"\",DAY(M61)*24+HOUR(M61)+MINUTE(M61)/60,0)","v":0},null,{"$f":"IF(O5<>\"\",DAY(O61)*24+HOUR(O61)+MINUTE(O61)/60,0)","v":0},null,{"$f":"SUM(C6:P6)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C7:P7)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C6-(C8+C7)","v":0},null,{"$f":"E6-(E8+E7)","v":0},null,{"$f":"G6-(G8+G7)","v":0},null,{"$f":"I6-(I8+I7)","v":0},null,{"$f":"K6-(K8+K7)","v":0},null,{"$f":"M6-(M8+M7)","v":0},null,{"$f":"O6-(O8+O7)","v":0},null,{"$f":"SUM(C9:P9)","v":0},{"$f":"Q6-Q8","v":0},{"$nulls":7},{"$f":"COUNTIF(Q9,\">54\")","v":0},{"$f":"COUNTIF(Q9,\">50\")","v":0},null,{"$f":"COUNTIF(C9:P9,\">10\")","v":0},{"$f":"COUNTIF(C9:P9,\">12,5\")","v":0}]
[2,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C10<>\"\",DAY(C62)*24+HOUR(C62)+MINUTE(C62)/60,0)","v":0},null,{"$f":"IF(E10<>\"\",DAY(E62)*24+HOUR(E62)+MINUTE(E62)/60,0)","v":0},null,{"$f":"IF(G10<>\"\",DAY(G62)*24+HOUR(G62)+MINUTE(G62)/60,0)","v":0},null,{"$f":"IF(I10<>\"\",DAY(I62)*24+HOUR(I62)+MINUTE(I62)/60,0)","v":0},null,{"$f":"IF(K10<>\"\",DAY(K62)*24+HOUR(K62)+MINUTE(K62)/60,0)","v":0},null,{"$f":"IF(M10<>\"\",DAY(M62)*24+HOUR(M62)+MINUTE(M62)/60,0)","v":0},null,{"$f":"IF(O10<>\"\",DAY(O62)*24+HOUR(O62)+MINUTE(O62)/60,0)","v":0},null,{"$f":"SUM(C11:P11)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C12:P12)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C11-(C13+C12)","v":0},null,{"$f":"E11-(E13+E12)","v":0},null,{"$f":"G11-(G13+G12)","v":0},null,{"$f":"I11-(I13+I12)","v":0},null,{"$f":"K11-(K13+K12)","v":0},null,{"$f":"M11-(M13+M12)","v":0},null,{"$f":"O11-(O13+O12)","v":0},null,0,{"$f":"Q11-Q13","v":0},{"$nulls":7},{"$f":"COUNTIF(Q14,\">54\")","v":0},{"$f":"COUNTIF(Q14,\">50\")","v":0},null,{"$f":"COUNTIF(C14:P14,\">10\")","v":0},{"$f":"COUNTIF(C14:P14,\">12,5\")","v":0}]
[3,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C15<>\"\",DAY(C63)*24+HOUR(C63)+MINUTE(C63)/60,0)","v":0},null,{"$f":"IF(E15<>\"\",DAY(E63)*24+HOUR(E63)+MINUTE(E63)/60,0)","v":0},null,{"$f":"IF(G15<>\"\",DAY(G63)*24+HOUR(G63)+MINUTE(G63)/60,0)","v":0},null,{"$f":"IF(I15<>\"\",DAY(I63)*24+HOUR(I63)+MINUTE(I63)/60,0)","v":0},null,{"$f":"IF(K15<>\"\",DAY(K63)*24+HOUR(K63)+MINUTE(K63)/60,0)","v":0},null,{"$f":"IF(M15<>\"\",DAY(M63)*24+HOUR(M63)+MINUTE(M63)/60,0)","v":0},null,{"$f":"IF(O15<>\"\",DAY(O63)*24+HOUR(O63)+MINUTE(O63)/60,0)","v":0},null,{"$f":"SUM(C16:P16)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C17:P17)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C16-(C18+C17)","v":0},null,{"$f":"E16-(E18+E17)","v":0},null,{"$f":"G16-(G18+G17)","v":0},null,{"$f":"I16-(I18+I17)","v":0},null,{"$f":"K16-(K18+K17)","v":0},null,{"$f":"M16-(M18+M17)","v":0},null,{"$f":"O16-(O18+O17)","v":0},null,0,{"$f":"Q16-Q18","v":0},{"$nulls":7},{"$f":"COUNTIF(Q19,\">54\")","v":0},{"$f":"COUNTIF(Q19,\">50\")","v":0},null,{"$f":"COUNTIF(C19:P19,\">10\")","v":0},{"$f":"COUNTIF(C19:P19,\">12,5\")","v":0}]
[4,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C20<>\"\",DAY(C64)*24+HOUR(C64)+MINUTE(C64)/60,0)","v":0},null,{"$f":"IF(E20<>\"\",DAY(E64)*24+HOUR(E64)+MINUTE(E64)/60,0)","v":0},null,{"$f":"IF(G20<>\"\",DAY(G64)*24+HOUR(G64)+MINUTE(G64)/60,0)","v":0},null,{"$f":"IF(I20<>\"\",DAY(I64)*24+HOUR(I64)+MINUTE(I64)/60,0)","v":0},null,{"$f":"IF(K20<>\"\",DAY(K64)*24+HOUR(K64)+MINUTE(K64)/60,0)","v":0},null,{"$f":"IF(M20<>\"\",DAY(M64)*24+HOUR(M64)+MINUTE(M64)/60,0)","v":0},null,{"$f":"IF(O20<>\"\",DAY(O64)*24+HOUR(O64)+MINUTE(O64)/60,0)","v":0},null,{"$f":"SUM(C21:P21)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C22:P22)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C21-(C23+C22)","v":0},null,{"$f":"E21-(E23+E22)","v":0},null,{"$f":"G21-(G23+G22)","v":0},null,{"$f":"I21-(I23+I22)","v":0},null,{"$f":"K21-(K23+K22)","v":0},null,{"$f":"M21-(M23+M22)","v":0},null,{"$f":"O21-(O23+O22)","v":0},null,0,{"$f":"Q21-Q23","v":0},{"$nulls":7},{"$f":"COUNTIF(Q24,\">54\")","v":0},{"$f":"COUNTIF(Q24,\">50\")","v":0},null,{"$f":"COUNTIF(C24:P24,\">10\")","v":0},{"$f":"COUNTIF(C24:P24,\">12,5\")","v":0}]
[5,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C25<>\"\",DAY(C65)*24+HOUR(C65)+MINUTE(C65)/60,0)","v":0},null,{"$f":"IF(E25<>\"\",DAY(E65)*24+HOUR(E65)+MINUTE(E65)/60,0)","v":0},null,{"$f":"IF(G25<>\"\",DAY(G65)*24+HOUR(G65)+MINUTE(G65)/60,0)","v":0},null,{"$f":"IF(I25<>\"\",DAY(I65)*24+HOUR(I65)+MINUTE(I65)/60,0)","v":0},null,{"$f":"IF(K25<>\"\",DAY(K65)*24+HOUR(K65)+MINUTE(K65)/60,0)","v":0},null,{"$f":"IF(M25<>\"\",DAY(M65)*24+HOUR(M65)+MINUTE(M65)/60,0)","v":0},null,{"$f":"IF(O25<>\"\",DAY(O65)*24+HOUR(O65)+MINUTE(O65)/60,0)","v":0},null,{"$f":"SUM(C26:P26)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C27:P27)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C26-(C28+C27)","v":0},null,{"$f":"E26-(E28+E27)","v":0},null,{"$f":"G26-(G28+G27)","v":0},null,{"$f":"I26-(I28+I27)","v":0},null,{"$f":"K26-(K28+K27)","v":0},null,{"$f":"M26-(M28+M27)","v":0},null,{"$f":"O26-(O28+O27)","v":0},null,0,{"$f":"Q26-Q28","v":0},{"$nulls":7},{"$f":"COUNTIF(Q29,\">54\")","v":0},{"$f":"COUNTIF(Q29,\">50\")","v":0},null,{"$f":"COUNTIF(C29:P29,\">10\")","v":0},{"$f":"COUNTIF(C29:P29,\">12,5\")","v":0}]
[6,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C30<>\"\",DAY(C66)*24+HOUR(C66)+MINUTE(C66)/60,0)","v":0},null,{"$f":"IF(E30<>\"\",DAY(E67)*24+HOUR(E67)+MINUTE(E67)/60,0)","v":0},null,{"$f":"IF(G30<>\"\",DAY(G67)*24+HOUR(G67)+MINUTE(G67)/60,0)","v":0},null,{"$f":"IF(I30<>\"\",DAY(I67)*24+HOUR(I67)+MINUTE(I67)/60,0)","v":0},null,{"$f":"IF(K30<>\"\",DAY(K67)*24+HOUR(K67)+MINUTE(K67)/60,0)","v":0},null,{"$f":"IF(M30<>\"\",DAY(M67)*24+HOUR(M67)+MINUTE(M67)/60,0)","v":0},null,{"$f":"IF(O30<>\"\",DAY(O67)*24+HOUR(O67)+MINUTE(O67)/60,0)","v":0},null,{"$f":"SUM(C31:P31)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C32:P32)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C31-(C33+C32)","v":0},null,{"$f":"E31-(E33+E32)","v":0},null,{"$f":"G31-(G33+G32)","v":0},null,{"$f":"I31-(I33+I32)","v":0},null,{"$f":"K31-(K33+K32)","v":0},null,{"$f":"M31-(M33+M32)","v":0},null,{"$f":"O31-(O33+O32)","v":0},null,0,{"$f":"Q31-Q33","v":0},{"$nulls":7},{"$f":"COUNTIF(Q34,\">54\")","v":0},{"$f":"COUNTIF(Q34,\">50\")","v":0},null,{"$f":"COUNTIF(C34:P34,\">10\")","v":0},{"$f":"COUNTIF(C34:P34,\">12,5\")","v":0}]
[7,"Start/slutt"]
[null,"Arbeidstid",{"$f":"IF(C35<>\"\",DAY(C68)*24+HOUR(C68)+MINUTE(C68)/60,0)","v":0},null,{"$f":"IF(E35<>\"\",DAY(E68)*24+HOUR(E68)+MINUTE(E68)/60,0)","v":0},null,{"$f":"IF(G35<>\"\",DAY(G68)*24+HOUR(G68)+MINUTE(G68)/60,0)","v":0},null,{"$f":"IF(I35<>\"\",DAY(I68)*24+HOUR(I68)+MINUTE(I68)/60,0)","v":0},null,{"$f":"IF(K35<>\"\",DAY(K68)*24+HOUR(K68)+MINUTE(K68)/60,0)","v":0},null,{"$f":"IF(M35<>\"\",DAY(M68)*24+HOUR(M68)+MINUTE(M68)/60,0)","v":0},null,{"$f":"IF(O35<>\"\",DAY(O68)*24+HOUR(O68)+MINUTE(O68)/60,0)","v":0},null,{"$f":"SUM(C36:P36)","v":0}]
[null,"Pause(r), betalt",{"$nulls":14},{"$f":"SUM(C37:P37)","v":0}]
[null,"Pause(r), ubetalt",{"$nulls":14},0]
[null,"Arbeidstid eks. pauser",{"$f":"C36-(C38+C37)","v":0},null,{"$f":"E36-(E38+E37)","v":0},null,{"$f":"G36-(G38+G37)","v":0},null,{"$f":"I36-(I38+I37)","v":0},null,{"$f":"K36-(K38+K37)","v":0},null,{"$f":"M36-(M38+M37)","v":0},null,{"$f":"O36-(O38+O37)","v":0},null,0,{"$f":"Q36-Q38","v":0},{"$nulls":7},{"$f":"COUNTIF(Q39,\">54\")","v":0},{"$f":"COUNTIF(Q39,\">50\")","v":0},null,{"$f":"COUNTIF(C39:P39,\">10\")","v":0},{"$f":"COUNTIF(C39:P39,\">12,5\")","v":0}]
[{"$nulls":16},{"$f":"Q9+Q14+Q19+Q24+Q29+Q34+Q39","v":0},{"$f":"SUM(R9:R39)","v":0}]
[]
[]
[null,"Gj.snitt t/uke:",{"$f":"R40/C1","v":0},{"$nulls":13},{"$f":"COUNTIFS(Q9,\">54\",Q14,\">54\",Q19,\">54\",Q24,\">54\",Q29,\">54\",Q34,\">54\",Q39,\">54\")","v":0},{"$nulls":8},{"$f":"SUM(Z9:Z39)","v":0},{"$f":"SUM(AA9:AA39)","v":0},null,{"$f":"SUM((AC9:AC39))","v":0},{"$f":"SUM((AD9:AD39))","v":0}]
[null,"Kompensasjon/uke",{"$f":"C2-C43","v":37.5},{"$f":"IF(C44<0,\"Obs! Innebærer overtid!\",\"\")","v":""},{"$nulls":12},{"$f":"COUNTIFS(Q9,\">50\",Q14,\">50\",Q19,\">50\",Q24,\">50\",Q29,\">50\",Q34,\">50\",Q39,\">50\")","v":0}]
[null,"Timer/uke:",{"$f":"SUM(C43:C44)","v":37.5}]
{"$rows_empty":15}
[null,1,{"$f":"IF(C5=0,0,IF(D5>C5,D5-C5,($D$72-C5)+(D5-$E$72)))","v":0},null,{"$f":"IF(E5=0,0,IF(F5>E5,F5-E5,($D$72-E5)+(F5-$E$72)))","v":0},null,{"$f":"IF(G5=0,0,IF(H5>G5,H5-G5,($D$72-G5)+(H5-$E$72)))","v":0},null,{"$f":"IF(I5=0,0,IF(J5>I5,J5-I5,($D$72-I5)+(J5-$E$72)))","v":0},null,{"$f":"IF(K5=0,0,IF(L5>K5,L5-K5,($D$72-K5)+(L5-$E$72)))","v":0},null,{"$f":"IF(M5=0,0,IF(N5>M5,N5-M5,($D$72-M5)+(N5-$E$72)))","v":0},null,{"$f":"IF(O5=0,0,IF(P5>O5,P5-O5,($D$72-O5)+(P5-$E$72)))","v":0}]
[null,2,{"$f":"IF(C10=0,0,IF(D10>C10,D10-C10,($D$72-C10)+(D10-$E$72)))","v":0},null,{"$f":"IF(E10=0,0,IF(F10>E10,F10-E10,($D$72-E10)+(F10-$E$72)))","v":0},null,{"$f":"IF(G10=0,0,IF(H10>G10,H10-G10,($D$72-G10)+(H10-$E$72)))","v":0},null,{"$f":"IF(I10=0,0,IF(J10>I10,J10-I10,($D$72-I10)+(J10-$E$72)))","v":0},null,{"$f":"IF(K10=0,0,IF(L10>K10,L10-K10,($D$72-K10)+(L10-$E$72)))","v":0},null,{"$f":"IF(M10=0,0,IF(N10>M10,N10-M10,($D$72-M10)+(N10-$E$72)))","v":0},null,{"$f":"IF(O10=0,0,IF(P10>O10,P10-O10,($D$72-O10)+(P10-$E$72)))","v":0}]
[null,3,{"$f":"IF(C15=0,0,IF(D15>C15,D15-C15,($D$72-C15)+(D15-$E$72)))","v":0},null,{"$f":"IF(E15=0,0,IF(F15>E15,F15-E15,($D$72-E15)+(F15-$E$72)))","v":0},null,{"$f":"IF(G15=0,0,IF(H15>G15,H15-G15,($D$72-G15)+(H15-$E$72)))","v":0},null,{"$f":"IF(I15=0,0,IF(J15>I15,J15-I15,($D$72-I15)+(J15-$E$72)))","v":0},null,{"$f":"IF(K15=0,0,IF(L15>K15,L15-K15,($D$72-K15)+(L15-$E$72)))","v":0},null,{"$f":"IF(M15=0,0,IF(N15>M15,N15-M15,($D$72-M15)+(N15-$E$72)))","v":0},null,{"$f":"IF(O15=0,0,IF(P15>O15,P15-O15,($D$72-O15)+(P15-$E$72)))","v":0}]
[null,4,{"$f":"IF(C20=0,0,IF(D20>C20,D20-C20,($D$72-C20)+(D20-$E$72)))","v":0},null,{"$f":"IF(E20=0,0,IF(F20>E20,F20-E20,($D$72-E20)+(F20-$E$72)))","v":0},null,{"$f":"IF(G20=0,0,IF(H20>G20,H20-G20,($D$72-G20)+(H20-$E$72)))","v":0},null,{"$f":"IF(I20=0,0,IF(J20>I20,J20-I20,($D$72-I20)+(J20-$E$72)))","v":0},null,{"$f":"IF(K20=0,0,IF(L20>K20,L20-K20,($D$72-K20)+(L20-$E$72)))","v":0},null,{"$f":"IF(M20=0,0,IF(N20>M20,N20-M20,($D$72-M20)+(N20-$E$72)))","v":0},null,{"$f":"IF(O20=0,0,IF(P20>O20,P20-O20,($D$72-O20)+(P20-$E$72)))","v":0}]
[null,5,{"$f":"IF(C25=0,0,IF(D25>C25,D25-C25,($D$72-C25)+(D25-$E$72)))","v":0},null,{"$f":"IF(E25=0,0,IF(F25>E25,F25-E25,($D$72-E25)+(F25-$E$72)))","v":0},null,{"$f":"IF(G25=0,0,IF(H25>G25,H25-G25,($D$72-G25)+(H25-$E$72)))","v":0},null,{"$f":"IF(I25=0,0,IF(J25>I25,J25-I25,($D$72-I25)+(J25-$E$72)))","v":0},null,{"$f":"IF(K25=0,0,IF(L25>K25,L25-K25,($D$72-K25)+(L25-$E$72)))","v":0},null,{"$f":"IF(M25=0,0,IF(N25>M25,N25-M25,($D$72-M25)+(N25-$E$72)))","v":0},null,{"$f":"IF(O25=0,0,IF(P25>O25,P25-O25,($D$72-O25)+(P25-$E$72)))","v":0}]
[null,6,{"$f":"IF(C30=0,0,IF(D30>C30,D30-C30,($D$72-C30)+(D30-$E$72)))","v":0},null,{"$f":"IF(E30=0,0,IF(F30>E30,F30-E30,($D$72-E30)+(F30-$E$72)))","v":0},null,{"$f":"IF(G30=0,0,IF(H30>G30,H30-G30,($D$72-G30)+(H30-$E$72)))","v":0},null,{"$f":"IF(I30=0,0,IF(J30>I30,J30-I30,($D$72-I30)+(J30-$E$72)))","v":0},null,{"$f":"IF(K30=0,0,IF(L30>K30,L30-K30,($D$72-K30)+(L30-$E$72)))","v":0},null,{"$f":"IF(M30=0,0,IF(N30>M30,N30-M30,($D$72-M30)+(N30-$E$72)))","v":0},null,{"$f":"IF(O30=0,0,IF(P30>O30,P30-O30,($D$72-O30)+(P30-$E$72)))","v":0}]
[null,7,{"$f":"IF(C35=0,0,IF(D35>C35,D35-C35,($D$72-C35)+(D35-$E$72)))","v":0},null,{"$f":"IF(E35=0,0,IF(F35>E35,F35-E35,($D$72-E35)+(F35-$E$72)))","v":0},null,{"$f":"IF(G35=0,0,IF(H35>G35,H35-G35,($D$72-G35)+(H35-$E$72)))","v":0},null,{"$f":"IF(I35=0,0,IF(J35>I35,J35-I35,($D$72-I35)+(J35-$E$72)))","v":0},null,{"$f":"IF(K35=0,0,IF(L35>K35,L35-K35,($D$72-K35)+(L35-$E$72)))","v":0},null,{"$f":"IF(M35=0,0,IF(N35>M35,N35-M35,($D$72-M35)+(N35-$E$72)))","v":0},null,{"$f":"IF(O35=0,0,IF(P35>O35,P35-O35,($D$72-O35)+(P35-$E$72)))","v":0}]
[]
[]
[]
[]
[{"$nulls":3},1,"00:00:00"]
[{"$nulls":3},{"$f":"IF(C5<>\"\",D72-C5,0)","v":0}]