{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Calcul du temps de marche"],"not_rendered":{"charts":1,"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Calcul du temps de marche","index":0,"n_rows":55,"n_cols":16,"rows_kept":55,"merged":[[0,0,0,11],[0,12,1,12],[1,0,1,11],[3,1,3,11],[4,1,4,2],[4,3,4,6],[4,7,4,10],[5,1,5,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,12,8,12],[6,0,6,2],[7,0,7,2],[8,0,8,1],[9,0,10,1],[9,2,10,2],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,10,12],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[11,0,12,1],[11,2,12,2],[11,7,12,7],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[13,0,14,1],[13,2,14,2],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[15,0,16,1],[15,2,16,2],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,6],[17,0,18,1],[17,2,18,2],[17,7,18,7],[17,8,18,8],[17,9,18,9],[17,10,18,10],[17,11,18,11],[17,12,18,12],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[19,0,20,1],[19,2,20,2],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[21,0,22,1],[21,2,22,2],[21,7,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[23,0,24,1],[23,2,24,2],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,10,24,10],[23,11,24,11],[23,12,24,12],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,25,6],[25,0,26,1],[25,2,26,2],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[25,12,26,12],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[27,0,28,1],[27,2,28,2],[27,7,28,7],[27,8,28,8],[27,9,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[29,0,30,1],[29,2,30,2],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,6],[31,0,32,1],[31,2,32,2],[31,7,32,7],[31,8,32,8],[31,9,32,9],[31,10,32,10],[31,11,32,11],[31,12,32,12],[32,3,33,3],[32,4,33,4],[32,5,33,5],[32,6,33,6],[33,0,34,1],[33,2,34,2],[33,7,34,7],[33,8,34,8],[33,9,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,6],[35,0,36,1],[35,2,36,2],[35,7,36,7],[35,8,36,8],[35,9,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,6],[37,0,38,1],[37,2,38,2],[37,7,38,7],[37,8,38,8],[37,9,38,9],[37,10,38,10],[37,11,38,11],[37,12,38,12],[38,3,39,3],[38,4,39,4],[38,5,39,5],[38,6,39,6],[39,0,40,1],[39,2,40,2],[39,7,40,7],[39,8,40,8],[39,9,40,9],[39,10,40,10],[39,11,40,11],[39,12,40,12],[40,3,41,3],[40,4,41,4],[40,5,41,5],[40,6,41,6],[41,0,42,1],[41,2,42,2],[41,7,42,7],[41,8,42,8],[41,9,42,9],[41,10,42,10],[41,11,42,11],[41,12,42,12],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6],[43,0,44,1],[43,2,44,2],[43,7,44,7],[43,8,44,8],[43,9,44,9],[43,10,44,10],[43,11,44,11],[43,12,44,12],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[45,0,46,1],[45,2,46,2],[45,7,46,7],[45,8,46,8],[45,9,46,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[46,3,47,3],[46,4,47,4],[46,5,47,5],[46,6,47,6],[47,0,48,1],[47,2,48,2],[47,7,48,7],[47,8,48,8],[47,9,48,9],[47,10,48,10],[47,11,48,11],[47,12,48,12],[48,3,49,3],[48,4,49,4],[48,5,49,5],[48,6,49,6],[49,0,50,1],[49,2,50,2],[49,7,50,7],[49,8,50,8],[49,9,50,9],[49,10,50,10],[49,11,50,11],[49,12,50,12],[51,0,51,4],[51,5,51,6],[51,7,51,12],[52,0,52,12],[53,3,53,12],[54,0,54,1],[54,3,54,12],[55,0,55,1],[55,3,55,12],[56,0,56,1],[56,3,56,12],[57,0,57,1],[57,3,57,12],[58,0,58,1],[58,3,58,12],[59,0,59,1],[59,3,59,12]]}
["[Nom du camp]"]
["Scouts Perceval Moutier, [unité]"]
[]
["Randonnée :",{"$nulls":11},"Facteur de vitesse\n(kme/h) :"]
["Date :",null,null,"Valeurs intermédiaires",{"$nulls":3},"Sommes totales",{"$nulls":4},5]
["Réalisé par :",null,null,"Dénivelé par 100 m *","Distance horizontale","Kilomètres-eforts **","Temps de marche","Distance","Kilomètres-eforts","Temps planifié","Temps effectif","Pauses","Remarques\n\n* Noter les dénivelés directement en hm\n(1 hm = 100 m)\n\n** kilomètres-efforts :\nDistance (en km) +\nPente en hectomètre"]
["Cartes topographiques :"]
[]
["Lieux, lieux-dits, coordonnées",null,"Altitude","± hm","km","kme","h:mm","km","kme","h:mm","h:mm","h:mm",{"$nulls":3},"Montée/descente"]
[{"$nulls":7},0,{"$nulls":7},"%"]
[{"$nulls":3},{"$f":"IF(C12>0,(C12-C10)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P12<-20,-D11/1.5+E11,IF(P12<0,E11,D11+E11))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F11,0)","v":"00:00:00"}]
[{"$nulls":7},{"$f":"IF(E11>0,H10+E11,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F11>0,I10+F11,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J10+G11+L10)<>J10,J10+G11+L10,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E11=0,0,D11/(10*E11)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C14>0,(C14-C12)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P14<-20,-D13/1.5+E13,IF(P14<0,E13,D13+E13))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F13,0)","v":"00:00:00"},null,null,{"$f":"IF((J12+G13+L13)<>J12,J12+G13+L13,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E12=0,0,D12/(10*E12)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E13>0,H12+E13,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F13>0,I12+F13,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J12+G13+L12)<>J12,J12+G13+L12,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E13=0,0,D13/(10*E13)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C16>0,(C16-C14)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P16<-20,-D15/1.5+E15,IF(P16<0,E15,D15+E15))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F15,0)","v":"00:00:00"},null,null,{"$f":"IF((J14+G15+L15)<>J14,J14+G15+L15,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E14=0,0,D14/(10*E14)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E15>0,H14+E15,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F15>0,I14+F15,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J14+G15+L14)<>J14,J14+G15+L14,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E15=0,0,D15/(10*E15)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C18>0,(C18-C16)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P18<-20,-D17/1.5+E17,IF(P18<0,E17,D17+E17))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F17,0)","v":"00:00:00"},null,null,{"$f":"IF((J16+G17+L17)<>J16,J16+G17+L17,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E16=0,0,D16/(10*E16)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E17>0,H16+E17,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F17>0,I16+F17,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J16+G17+L16)<>J16,J16+G17+L16,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E17=0,0,D17/(10*E17)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C20>0,(C20-C18)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P20<-20,-D19/1.5+E19,IF(P20<0,E19,D19+E19))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F19,0)","v":"00:00:00"},null,null,{"$f":"IF((J18+G19+L19)<>J18,J18+G19+L19,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E18=0,0,D18/(10*E18)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E19>0,H18+E19,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F19>0,I18+F19,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J18+G19+L18)<>J18,J18+G19+L18,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E19=0,0,D19/(10*E19)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C22>0,(C22-C20)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P22<-20,-D21/1.5+E21,IF(P22<0,E21,D21+E21))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F21,0)","v":"00:00:00"},null,null,{"$f":"IF((J20+G21+L21)<>J20,J20+G21+L21,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E20=0,0,D20/(10*E20)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E21>0,H20+E21,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F21>0,I20+F21,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J20+G21+L20)<>J20,J20+G21+L20,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E21=0,0,D21/(10*E21)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C24>0,(C24-C22)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P24<-20,-D23/1.5+E23,IF(P24<0,E23,D23+E23))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F23,0)","v":"00:00:00"},null,null,{"$f":"IF((J22+G23+L23)<>J22,J22+G23+L23,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E22=0,0,D22/(10*E22)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E23>0,H22+E23,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F23>0,I22+F23,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J22+G23+L22)<>J22,J22+G23+L22,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E23=0,0,D23/(10*E23)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C26>0,(C26-C24)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P26<-20,-D25/1.5+E25,IF(P26<0,E25,D25+E25))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F25,0)","v":"00:00:00"},null,null,{"$f":"IF((J24+G25+L25)<>J24,J24+G25+L25,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E24=0,0,D24/(10*E24)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E25>0,H24+E25,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F25>0,I24+F25,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J24+G25+L24)<>J24,J24+G25+L24,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E25=0,0,D25/(10*E25)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C28>0,(C28-C26)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P28<-20,-D27/1.5+E27,IF(P28<0,E27,D27+E27))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F27,0)","v":"00:00:00"},null,null,{"$f":"IF((J26+G27+L27)<>J26,J26+G27+L27,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E26=0,0,D26/(10*E26)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E27>0,H26+E27,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F27>0,I26+F27,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J26+G27+L26)<>J26,J26+G27+L26,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E27=0,0,D27/(10*E27)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C30>0,(C30-C28)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P30<-20,-D29/1.5+E29,IF(P30<0,E29,D29+E29))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F29,0)","v":"00:00:00"},null,null,{"$f":"IF((J28+G29+L29)<>J28,J28+G29+L29,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E28=0,0,D28/(10*E28)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E29>0,H28+E29,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F29>0,I28+F29,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J28+G29+L28)<>J28,J28+G29+L28,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E29=0,0,D29/(10*E29)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C32>0,(C32-C30)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P32<-20,-D31/1.5+E31,IF(P32<0,E31,D31+E31))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F31,0)","v":"00:00:00"},null,null,{"$f":"IF((J30+G31+L31)<>J30,J30+G31+L31,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E30=0,0,D30/(10*E30)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E31>0,H30+E31,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F31>0,I30+F31,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J30+G31+L30)<>J30,J30+G31+L30,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E31=0,0,D31/(10*E31)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C34>0,(C34-C32)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P34<-20,-D33/1.5+E33,IF(P34<0,E33,D33+E33))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F33,0)","v":"00:00:00"},null,null,{"$f":"IF((J32+G33+L33)<>J32,J32+G33+L33,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E32=0,0,D32/(10*E32)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E33>0,H32+E33,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F33>0,I32+F33,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J32+G33+L32)<>J32,J32+G33+L32,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E33=0,0,D33/(10*E33)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C36>0,(C36-C34)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P36<-20,-D35/1.5+E35,IF(P36<0,E35,D35+E35))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F35,0)","v":"00:00:00"},null,null,{"$f":"IF((J34+G35+L35)<>J34,J34+G35+L35,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E34=0,0,D34/(10*E34)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E35>0,H34+E35,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F35>0,I34+F35,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J34+G35+L34)<>J34,J34+G35+L34,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E35=0,0,D35/(10*E35)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C38>0,(C38-C36)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P38<-20,-D37/1.5+E37,IF(P38<0,E37,D37+E37))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F37,0)","v":"00:00:00"},null,null,{"$f":"IF((J36+G37+L37)<>J36,J36+G37+L37,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E36=0,0,D36/(10*E36)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E37>0,H36+E37,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F37>0,I36+F37,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J36+G37+L36)<>J36,J36+G37+L36,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E37=0,0,D37/(10*E37)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C40>0,(C40-C38)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P40<-20,-D39/1.5+E39,IF(P40<0,E39,D39+E39))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F39,0)","v":"00:00:00"},null,null,{"$f":"IF((J38+G51+L39)<>J38,J38+G51+L39,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E38=0,0,D38/(10*E38)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E39>0,H38+E39,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F39>0,I38+F39,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J38+G39+L38)<>J38,J38+G39+L38,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E39=0,0,D39/(10*E39)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C42>0,(C42-C40)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P42<-20,-D41/1.5+E41,IF(P42<0,E41,D41+E41))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F41,0)","v":"00:00:00"},null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IF(E40=0,0,D40/(10*E40)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E41>0,H40+E41,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F41>0,I40+F41,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J40+G41+L40)<>J40,J40+G41+L40,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E41=0,0,D41/(10*E41)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C44>0,(C44-C42)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P44<-20,-D43/1.5+E43,IF(P44<0,E43,D43+E43))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F43,0)","v":"00:00:00"},null,null,{"$f":"IF((J42+G43+L43)<>J42,J42+G43+L43,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E42=0,0,D42/(10*E42)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E43>0,H42+E43,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F43>0,I42+F43,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J42+G43+L42)<>J42,J42+G43+L42,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E43=0,0,D43/(10*E43)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C46>0,(C46-C44)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P46<-20,-D45/1.5+E45,IF(P46<0,E45,D45+E45))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F45,0)","v":"00:00:00"},null,null,{"$f":"IF((J44+G45+L45)<>J44,J44+G45+L45,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E44=0,0,D44/(10*E44)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E45>0,H44+E45,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F45>0,I44+F45,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J44+G45+L44)<>J44,J44+G45+L44,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E45=0,0,D45/(10*E45)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C48>0,(C48-C46)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P48<-20,-D47/1.5+E47,IF(P48<0,E47,D47+E47))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F47,0)","v":"00:00:00"},null,null,{"$f":"IF((J46+G47+L47)<>J46,J46+G47+L47,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E46=0,0,D46/(10*E46)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E47>0,H46+E47,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F47>0,I46+F47,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J46+G47+L46)<>J46,J46+G47+L46,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E47=0,0,D47/(10*E47)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":3},{"$f":"IF(C50>0,(C50-C48)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P50<-20,-D49/1.5+E49,IF(P50<0,E49,D49+E49))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$5*F49,0)","v":"00:00:00"},null,null,{"$f":"IF((J48+G49+L49)<>J48,J48+G49+L49,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E48=0,0,D48/(10*E48)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":7},{"$f":"IF(E49>0,H48+E49,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F49>0,I48+F49,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J48+G49+L48)<>J48,J48+G49+L48,0)","v":"00:00:00"},{"$nulls":5},{"$f":"IF(E49=0,0,D49/(10*E49)*100)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"$f":"NA()","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IF(E50=0,0,D50/(10*E50)*100)","v":{"v":0,"d":"0.0"}}]
["TOTAL temps de marche sans pauses",{"$nulls":4},{"$f":"SUM(G10:G51)","v":"00:00:00"}]
[]
["Horaire",null,null,"Remarques"]
["Lieu",null,"Temps"]