{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Marschzeitberechnung","Höhenprofil","Marschzeitberechnung (Beispiel)","Anleitung","Impressum"],"not_rendered":{"charts":1,"images":3,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Marschzeitberechnung","index":0,"n_rows":57,"n_cols":16,"rows_kept":57,"merged":[[1,0,3,7],[5,1,5,11],[6,1,6,2],[6,3,6,6],[6,7,6,10],[7,1,7,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[7,11,9,11],[7,12,10,12],[8,0,8,2],[9,0,9,2],[10,0,10,1],[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],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[51,0,52,1],[51,2,52,2],[51,7,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[51,11,52,11],[51,12,52,12],[53,0,53,4],[53,5,53,6],[53,7,53,12],[54,0,54,12],[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],[60,0,60,1],[60,3,60,12],[61,0,61,1],[61,3,61,12]]}
[]
["Marschzeitberechnung\ncudesch"]
[]
[]
[]
["Route:",{"$nulls":11},"Geschwindigkeits-\nfaktor (Lkm / h):"]
["Datum:",null,null,"Zwischenwerte",{"$nulls":3},"Gesamtsummen",{"$nulls":4},4]
["erstellt von:",null,null,"Höhendifferenz in 100m *","Horizontaldistanz","Leistungskilometer **","Marschzeit","Distanz","Leistungskilometer","Geplante Zeit","Tatsächliche Zeit","Pausen","Bemerkungen\n\n* Höhenmeter direkt\nin Hektometer notie-\nren (1 hm = 100 m)\n\n** Leistungskilometer:\nDistanz (in km) +\nSteigung (in hm)"]
["Landeskarten:"]
[]
["Ort, Flurname, Koordinaten",null,"Höhe","hm","km","Lkm","h:mm","km","Lkm","hh:mm","hh:mm","h:mm",{"$nulls":3},"Steigung/Gefälle"]
[{"$nulls":15},"%"]
[{"$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$7*F13,0)","v":"00:00:00"}]
[{"$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$7*F15,0)","v":"00:00:00"},null,null,{"$f":"IF((J14+G15+L15)<>J14,J14+G15+L15,0)","v":0},{"$nulls":5},{"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},{"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$7*F17,0)","v":"00:00:00"},null,null,{"$f":"IF((J16+G17+L17)<>J16,J16+G17+L17,0)","v":0},{"$nulls":5},{"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},{"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$7*F19,0)","v":"00:00:00"},null,null,{"$f":"IF((J18+G19+L19)<>J18,J18+G19+L19,0)","v":0},{"$nulls":5},{"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},{"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$7*F21,0)","v":"00:00:00"},null,null,{"$f":"IF((J20+G21+L21)<>J20,J20+G21+L21,0)","v":0},{"$nulls":5},{"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},{"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$7*F23,0)","v":"00:00:00"},null,null,{"$f":"IF((J22+G23+L23)<>J22,J22+G23+L23,0)","v":0},{"$nulls":5},{"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},{"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$7*F25,0)","v":"00:00:00"},null,null,{"$f":"IF((J24+G25+L25)<>J24,J24+G25+L25,0)","v":0},{"$nulls":5},{"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},{"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$7*F27,0)","v":"00:00:00"},null,null,{"$f":"IF((J26+G27+L27)<>J26,J26+G27+L27,0)","v":0},{"$nulls":5},{"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},{"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$7*F29,0)","v":"00:00:00"},null,null,{"$f":"IF((J28+G29+L29)<>J28,J28+G29+L29,0)","v":0},{"$nulls":5},{"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},{"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$7*F31,0)","v":"00:00:00"},null,null,{"$f":"IF((J30+G31+L31)<>J30,J30+G31+L31,0)","v":0},{"$nulls":5},{"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},{"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$7*F33,0)","v":"00:00:00"},null,null,{"$f":"IF((J32+G33+L33)<>J32,J32+G33+L33,0)","v":0},{"$nulls":5},{"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},{"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$7*F35,0)","v":"00:00:00"},null,null,{"$f":"IF((J34+G35+L35)<>J34,J34+G35+L35,0)","v":0},{"$nulls":5},{"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},{"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$7*F37,0)","v":"00:00:00"},null,null,{"$f":"IF((J36+G37+L37)<>J36,J36+G37+L37,0)","v":0},{"$nulls":5},{"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},{"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$7*F39,0)","v":"00:00:00"},null,null,{"$f":"IF((J38+G39+L39)<>J38,J38+G39+L39,0)","v":0},{"$nulls":5},{"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},{"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$7*F41,0)","v":"00:00:00"},null,null,{"$f":"IF((J40+G53+L41)<>J40,J40+G53+L41,0)","v":0},{"$nulls":5},{"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},{"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$7*F43,0)","v":"00:00:00"},null,null,{"$f":"IF((J42+#REF!+L43)<>J42,J42+#REF!+L43,0)","v":{"$error":"#REF!"}},{"$nulls":5},{"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},{"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$7*F45,0)","v":"00:00:00"},null,null,{"$f":"IF((J44+G45+L45)<>J44,J44+G45+L45,0)","v":0},{"$nulls":5},{"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},{"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$7*F47,0)","v":"00:00:00"},null,null,{"$f":"IF((J46+G47+L47)<>J46,J46+G47+L47,0)","v":0},{"$nulls":5},{"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},{"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$7*F49,0)","v":"00:00:00"},null,null,{"$f":"IF((J48+G49+L49)<>J48,J48+G49+L49,0)","v":0},{"$nulls":5},{"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},{"v":0,"d":"0.0"}]
[{"$nulls":3},{"$f":"IF(C52>0,(C52-C50)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P52<-20,-D51/1.5+E51,IF(P52<0,E51,D51+E51))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$7*F51,0)","v":"00:00:00"},null,null,{"$f":"IF((J50+G51+L51)<>J50,J50+G51+L51,0)","v":0},{"$nulls":5},{"v":0,"d":"0.0"}]
[{"$nulls":7},{"$f":"IF(E51>0,H50+E51,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F51>0,I50+F51,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J50+G51+L50)<>J50,J50+G51+L50,0)","v":"00:00:00"},{"$nulls":5},{"v":0,"d":"0.0"}]
[{"$nulls":9},{"$f":"IF((J52+#REF!+L53)<>J52,J52+#REF!+L53,0)","v":{"$error":"#REF!"}},{"$nulls":5},{"v":0,"d":"0.0"}]
["TOTAL Marschzeit ohne Pausen",{"$nulls":4},{"$f":"SUM(G12:G53)","v":"00:00:00"}]
[]
["Fahrplan",null,null,"Bemerkungen"]
["Ort",null,"Zeit"]

{"sheet":"Höhenprofil","index":1,"n_rows":24,"n_cols":3,"rows_kept":24}
[]
[null,"Hilfstabelle für Höhenprofil"]
[null,"Horizontaldistanz in km","Höhe ü.M."]
[null,{"$f":"Marschzeitberechnung!H12","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C12","v":0}]
[null,{"$f":"Marschzeitberechnung!H14","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C14","v":0}]
[null,{"$f":"Marschzeitberechnung!H16","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C16","v":0}]
[null,{"$f":"Marschzeitberechnung!H18","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C18","v":0}]
[null,{"$f":"Marschzeitberechnung!H20","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C20","v":0}]
[null,{"$f":"Marschzeitberechnung!H22","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C22","v":0}]
[null,{"$f":"Marschzeitberechnung!H24","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C24","v":0}]
[null,{"$f":"Marschzeitberechnung!H26","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C26","v":0}]
[null,{"$f":"Marschzeitberechnung!H28","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C28","v":0}]
[null,{"$f":"Marschzeitberechnung!H30","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C30","v":0}]
[null,{"$f":"Marschzeitberechnung!H32","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C32","v":0}]
[null,{"$f":"Marschzeitberechnung!H34","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C34","v":0}]
[null,{"$f":"Marschzeitberechnung!H36","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C36","v":0}]
[null,{"$f":"Marschzeitberechnung!H38","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C38","v":0}]
[null,{"$f":"Marschzeitberechnung!H40","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C40","v":0}]
[null,{"$f":"Marschzeitberechnung!H42","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C42","v":0}]
[null,{"$f":"Marschzeitberechnung!H44","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C44","v":0}]
[null,{"$f":"Marschzeitberechnung!H46","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C46","v":0}]
[null,{"$f":"Marschzeitberechnung!H48","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C48","v":0}]
[null,{"$f":"Marschzeitberechnung!H50","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C50","v":0}]
[null,{"$f":"Marschzeitberechnung!H52","v":{"v":0,"d":"0.0"}},{"$f":"Marschzeitberechnung!C52","v":0}]

{"sheet":"Marschzeitberechnung (Beispiel)","index":2,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[1,0,3,7],[5,1,5,11],[6,1,6,2],[6,3,6,6],[6,7,6,10],[7,1,7,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[7,11,9,11],[7,12,10,12],[8,0,8,2],[9,0,9,2],[10,0,10,1],[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],[50,3,51,3],[50,4,51,4],[50,5,51,5],[50,6,51,6],[51,0,52,1],[51,2,52,2],[51,7,52,7],[51,8,52,8],[51,9,52,9],[51,10,52,10],[51,11,52,11],[51,12,52,12],[53,0,53,4],[53,5,53,6],[53,7,53,12],[54,0,54,12],[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],[60,0,60,1],[60,3,60,12],[61,0,61,1],[61,3,61,12]]}
[]
["Marschzeitberechnung\ncudesch"]
[]
[]
[]
["Route:","Vrin (GR) - Disrut Pass - Greina Ebene - Campo (Blenio)",{"$nulls":10},"Geschwindigkeits-\nfaktor (Lkm / h):"]
["Datum:","22.-23.09.2007",null,"Zwischenwerte",{"$nulls":3},"Gesamtsummen",{"$nulls":4},4]
["erstellt von:","Omega",null,"Höhendifferenz in 100m *","Horizontaldistanz","Leistungskilometer **","Marschzeit","Distanz","Leistungskilometer","Geplante Zeit","Tatsächliche Zeit","Pausen","Bemerkungen\n\n* Höhenmeter direkt\nin Hektometer notie-\nren (1 hm = 100 m)\n\n** Leistungskilometer:\nDistanz (in km) +\nSteigung (in hm)"]
["Landeskarten:"]
["1233 Greina\n1234 Vals\n1253 Olivone"]
["Ort, Flurname, Koordinaten",null,"Höhe","hm","km","Lkm","h:mm","km","Lkm","hh:mm","hh:mm","h:mm",{"$nulls":3},"Steigung/Gefälle"]
["Vrin",null,1475,{"$nulls":6},"09:00:00",{"$nulls":5},"%"]
[{"$nulls":3},{"$f":"IF(C14>0,(C14-C12)/100,0)","v":0.02},1.4,{"$f":"IF(P14<-20,-D13/1.5+E13,IF(P14<0,E13,D13+E13))","v":{"v":1.42,"d":"1.4"}},{"$f":"TIME(0,60/$M$7*F13,0)","v":"00:21:00"}]
["Cons",null,1477,{"$nulls":4},{"$f":"IF(E13>0,H12+E13,0)","v":1.4},{"$f":"IF(F13>0,I12+F13,0)","v":{"v":1.42,"d":"1.4"}},{"$f":"IF((J12+G13+L12)<>J12,J12+G13+L12,0)","v":"09:21:00"},{"$nulls":5},{"$f":"IF(E13=0,0,D13/(10*E13)*100)","v":{"v":0.14285714285714285,"d":"0.1"}}]
[{"$nulls":3},{"$f":"IF(C16>0,(C16-C14)/100,0)","v":1.21},1.3,{"$f":"IF(P16<-20,-D15/1.5+E15,IF(P16<0,E15,D15+E15))","v":{"v":2.51,"d":"2.5"}},{"$f":"TIME(0,60/$M$7*F15,0)","v":"00:37:00"},null,null,{"$f":"IF((J14+G15+L15)<>J14,J14+G15+L15,0)","v":0.4152777777777778},{"$nulls":5},{"$f":"IF(E14=0,0,D14/(10*E14)*100)","v":{"v":0,"d":"0.0"}}]
["Sogn Giusep",null,1598,{"$nulls":4},{"$f":"IF(E15>0,H14+E15,0)","v":2.7},{"$f":"IF(F15>0,I14+F15,0)","v":{"v":3.9299999999999997,"d":"3.9"}},{"$f":"IF((J14+G15+L14)<>J14,J14+G15+L14,0)","v":"09:58:00"},{"$nulls":5},{"v":9.307692307692307,"d":"9.3"}]
[{"$nulls":3},{"$f":"IF(C18>0,(C18-C16)/100,0)","v":0.69},1.2,{"$f":"IF(P18<-20,-D17/1.5+E17,IF(P18<0,E17,D17+E17))","v":{"v":1.89,"d":"1.9"}},{"$f":"TIME(0,60/$M$7*F17,0)","v":"00:28:00"},null,null,{"$f":"IF((J16+G17+L17)<>J16,J16+G17+L17,0)","v":0.43472222222222223},{"$nulls":5},{"v":0,"d":"0.0"}]
["Puzzatsch",null,1667,{"$nulls":4},{"$f":"IF(E17>0,H16+E17,0)","v":{"v":3.9000000000000004,"d":"3.9"}},{"$f":"IF(F17>0,I16+F17,0)","v":{"v":5.819999999999999,"d":"5.8"}},{"$f":"IF((J16+G17+L16)<>J16,J16+G17+L16,0)","v":"10:26:00"},{"$nulls":5},{"v":5.75,"d":"5.8"}]
[{"$nulls":3},{"$f":"IF(C20>0,(C20-C18)/100,0)","v":2.32},1.8,{"$f":"IF(P20<-20,-D19/1.5+E19,IF(P20<0,E19,D19+E19))","v":{"v":4.12,"d":"4.1"}},{"$f":"TIME(0,60/$M$7*F19,0)","v":"01:01:00"},null,null,{"$f":"IF((J18+G19+L19)<>J18,J18+G19+L19,0)","v":0.47708333333333336},{"$nulls":5},{"v":0,"d":"0.0"}]
["Tegia Sut",null,1899,{"$nulls":4},{"$f":"IF(E19>0,H18+E19,0)","v":5.7},{"$f":"IF(F19>0,I18+F19,0)","v":{"v":9.94,"d":"9.9"}},{"$f":"IF((J18+G19+L18)<>J18,J18+G19+L18,0)","v":"11:27:00"},null,"01:00:00","Mittagspause",null,null,{"v":12.88888888888889,"d":"12.9"}]
[{"$nulls":3},{"$f":"IF(C22>0,(C22-C20)/100,0)","v":5.29},2.7,{"$f":"IF(P22<-20,-D21/1.5+E21,IF(P22<0,E21,D21+E21))","v":{"v":7.99,"d":"8.0"}},{"$f":"TIME(0,60/$M$7*F21,0)","v":"01:59:00"},null,null,{"$f":"IF((J20+G21+L21)<>J20,J20+G21+L21,0)","v":0.5597222222222222},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pass  Diesrut",null,2428,{"$nulls":4},{"$f":"IF(E21>0,H20+E21,0)","v":8.4},{"$f":"IF(F21>0,I20+F21,0)","v":{"v":17.93,"d":"17.9"}},{"$f":"IF((J20+G21+L20)<>J20,J20+G21+L20,0)","v":"14:26:00"},{"$nulls":5},{"v":19.59259259259259,"d":"19.6"}]
[{"$nulls":3},{"$f":"IF(C24>0,(C24-C22)/100,0)","v":-2.34},{"v":1,"d":"1.0"},{"$f":"IF(P24<-20,-D23/1.5+E23,IF(P24<0,E23,D23+E23))","v":{"v":2.5599999999999996,"d":"2.6"}},{"$f":"TIME(0,60/$M$7*F23,0)","v":"00:38:00"},null,null,{"$f":"IF((J22+G23+L23)<>J22,J22+G23+L23,0)","v":0.6277777777777778},{"$nulls":5},{"v":0,"d":"0.0"}]
["Camona",null,2194,{"$nulls":4},{"$f":"IF(E23>0,H22+E23,0)","v":9.4},{"$f":"IF(F23>0,I22+F23,0)","v":{"v":20.49,"d":"20.5"}},{"$f":"IF((J22+G23+L22)<>J22,J22+G23+L22,0)","v":"15:04:00"},{"$nulls":5},-23.4]
[{"$nulls":3},{"$f":"IF(C26>0,(C26-C24)/100,0)","v":0.63},0.2,{"$f":"IF(P26<-20,-D25/1.5+E25,IF(P26<0,E25,D25+E25))","v":{"v":0.8300000000000001,"d":"0.8"}},{"$f":"TIME(0,60/$M$7*F25,0)","v":"00:12:00"},null,null,{"$f":"IF((J24+G25+L25)<>J24,J24+G25+L25,0)","v":0.6361111111111111},{"$nulls":5},{"v":0,"d":"0.0"}]
["Carpet la Greina",null,2257,{"$nulls":4},{"$f":"IF(E25>0,H24+E25,0)","v":9.6},{"$f":"IF(F25>0,I24+F25,0)","v":{"v":21.32,"d":"21.3"}},{"$f":"IF((J24+G25+L24)<>J24,J24+G25+L24,0)","v":"15:16:00"},{"$nulls":5},31.5]
[{"$nulls":3},{"$f":"IF(C28>0,(C28-C26)/100,0)","v":-0.87},0.6,{"$f":"IF(P28<-20,-D27/1.5+E27,IF(P28<0,E27,D27+E27))","v":0.6},{"$f":"TIME(0,60/$M$7*F27,0)","v":"00:09:00"},null,null,{"$f":"IF((J26+G27+L27)<>J26,J26+G27+L27,0)","v":0.642361111111111},{"$nulls":5},{"v":0,"d":"0.0"}]
["Terri Hütte",null,2170,{"$nulls":4},{"$f":"IF(E27>0,H26+E27,0)","v":10.2},{"$f":"IF(F27>0,I26+F27,0)","v":{"v":21.92,"d":"21.9"}},{"$f":"IF((J26+G27+L26)<>J26,J26+G27+L26,0)","v":"15:25:00"},null,"17:00:00","Hüttenübernachtung",null,null,{"v":-14.499999999999998,"d":"-14.5"}]
[{"$nulls":3},{"$f":"IF(C30>0,(C30-C28)/100,0)","v":0.95},1.5,{"$f":"IF(P30<-20,-D29/1.5+E29,IF(P30<0,E29,D29+E29))","v":{"v":2.45,"d":"2.5"}},{"$f":"TIME(0,60/$M$7*F29,0)","v":"00:36:00"},null,null,{"$f":"IF((J28+G29+L29)<>J28,J28+G29+L29,0)","v":0.6673611111111111},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pt. 2265",null,2265,{"$nulls":4},{"$f":"IF(E29>0,H28+E29,0)","v":11.7},{"$f":"IF(F29>0,I28+F29,0)","v":{"v":24.37,"d":"24.4"}},{"$f":"IF((J28+G29+L28)<>J28,J28+G29+L28,0)","v":1.3756944444444446},{"$nulls":5},{"v":6.333333333333332,"d":"6.3"}]
[{"$nulls":3},{"$f":"IF(C32>0,(C32-C30)/100,0)","v":-0.19},{"v":1,"d":"1.0"},{"$f":"IF(P32<-20,-D31/1.5+E31,IF(P32<0,E31,D31+E31))","v":{"v":1,"d":"1.0"}},{"$f":"TIME(0,60/$M$7*F31,0)","v":"00:15:00"},null,null,{"$f":"IF((J30+G31+L31)<>J30,J30+G31+L31,0)","v":1.3861111111111113},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pt. 2246",null,2246,{"$nulls":4},{"$f":"IF(E31>0,H30+E31,0)","v":12.7},{"$f":"IF(F31>0,I30+F31,0)","v":{"v":25.37,"d":"25.4"}},{"$f":"IF((J30+G31+L30)<>J30,J30+G31+L30,0)","v":1.3861111111111113},{"$nulls":5},-1.9]
[{"$nulls":3},{"$f":"IF(C34>0,(C34-C32)/100,0)","v":0.98},2.5,{"$f":"IF(P34<-20,-D33/1.5+E33,IF(P34<0,E33,D33+E33))","v":{"v":3.48,"d":"3.5"}},{"$f":"TIME(0,60/$M$7*F33,0)","v":"00:52:00"},null,null,{"$f":"IF((J32+G33+L33)<>J32,J32+G33+L33,0)","v":1.4222222222222225},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pt. 2344",null,2344,{"$nulls":4},{"$f":"IF(E33>0,H32+E33,0)","v":15.2},{"$f":"IF(F33>0,I32+F33,0)","v":{"v":28.85,"d":"28.9"}},{"$f":"IF((J32+G33+L32)<>J32,J32+G33+L32,0)","v":1.4222222222222225},{"$nulls":5},{"v":3.92,"d":"3.9"}]
[{"$nulls":3},{"$f":"IF(C36>0,(C36-C34)/100,0)","v":0.11},0.5,{"$f":"IF(P36<-20,-D35/1.5+E35,IF(P36<0,E35,D35+E35))","v":{"v":0.61,"d":"0.6"}},{"$f":"TIME(0,60/$M$7*F35,0)","v":"00:09:00"},null,null,{"$f":"IF((J34+G35+L35)<>J34,J34+G35+L35,0)","v":1.4284722222222226},{"$nulls":5},{"v":0,"d":"0.0"}]
["Greina Pass",null,2355,{"$nulls":4},{"$f":"IF(E35>0,H34+E35,0)","v":15.7},{"$f":"IF(F35>0,I34+F35,0)","v":{"v":29.46,"d":"29.5"}},{"$f":"IF((J34+G35+L34)<>J34,J34+G35+L34,0)","v":1.4284722222222226},{"$nulls":5},{"v":2.1999999999999997,"d":"2.2"}]
[{"$nulls":3},{"$f":"IF(C38>0,(C38-C36)/100,0)","v":0.24},0.5,{"$f":"IF(P38<-20,-D37/1.5+E37,IF(P38<0,E37,D37+E37))","v":{"v":0.74,"d":"0.7"}},{"$f":"TIME(0,60/$M$7*F37,0)","v":"00:11:00"},null,null,{"$f":"IF((J36+G37+L37)<>J36,J36+G37+L37,0)","v":1.4361111111111116},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pt. 2379",null,2379,{"$nulls":4},{"$f":"IF(E37>0,H36+E37,0)","v":16.2},{"$f":"IF(F37>0,I36+F37,0)","v":30.2},{"$f":"IF((J36+G37+L36)<>J36,J36+G37+L36,0)","v":1.4361111111111116},{"$nulls":5},4.8]
[{"$nulls":3},{"$f":"IF(C40>0,(C40-C38)/100,0)","v":{"v":-1.5,"d":"-1.50"}},1.3,{"$f":"IF(P40<-20,-D39/1.5+E39,IF(P40<0,E39,D39+E39))","v":1.3},{"$f":"TIME(0,60/$M$7*F39,0)","v":"00:19:00"},null,null,{"$f":"IF((J38+G39+L39)<>J38,J38+G39+L39,0)","v":1.449305555555556},{"$nulls":5},{"v":0,"d":"0.0"}]
["bei Scaletta Hütte",null,2229,{"$nulls":4},{"$f":"IF(E39>0,H38+E39,0)","v":17.5},{"$f":"IF(F39>0,I38+F39,0)","v":31.5},{"$f":"IF((J38+G39+L38)<>J38,J38+G39+L38,0)","v":1.449305555555556},{"$nulls":5},{"v":-11.538461538461538,"d":"-11.5"}]
[{"$nulls":3},{"$f":"IF(C42>0,(C42-C40)/100,0)","v":-2.53},1.5,{"$f":"IF(P42<-20,-D41/1.5+E41,IF(P42<0,E41,D41+E41))","v":1.5},{"$f":"TIME(0,60/$M$7*F41,0)","v":"00:22:00"},null,null,{"$f":"IF((J40+G53+L41)<>J40,J40+G53+L41,0)","v":0},{"$nulls":5},{"v":0,"d":"0.0"}]
["Pian Geirett",null,1976,{"$nulls":4},{"$f":"IF(E41>0,H40+E41,0)","v":{"v":19,"d":"19.0"}},{"$f":"IF(F41>0,I40+F41,0)","v":{"v":33,"d":"33.0"}},{"$f":"IF((J40+G41+L40)<>J40,J40+G41+L40,0)","v":1.4645833333333338},null,"01:00:00","Mittagspause",null,null,{"v":-16.866666666666667,"d":"-16.9"}]
[{"$nulls":3},{"$f":"IF(C44>0,(C44-C42)/100,0)","v":-1.92},1.5,{"$f":"IF(P44<-20,-D43/1.5+E43,IF(P44<0,E43,D43+E43))","v":1.5},{"$f":"TIME(0,60/$M$7*F43,0)","v":"00:22:00"},null,null,{"$f":"IF((J42+#REF!+L43)<>J42,J42+#REF!+L43,0)","v":{"$error":"#REF!"}},{"$nulls":5},{"v":0,"d":"0.0"}]
["Alpe di Camadra di Fuori",null,1784,{"$nulls":4},{"$f":"IF(E43>0,H42+E43,0)","v":20.5},{"$f":"IF(F43>0,I42+F43,0)","v":34.5},{"$f":"IF((J42+G43+L42)<>J42,J42+G43+L42,0)","v":1.5215277777777783},{"$nulls":5},-12.8]
[{"$nulls":3},{"$f":"IF(C46>0,(C46-C44)/100,0)","v":-3.76},{"v":2,"d":"2.0"},{"$f":"IF(P46<-20,-D45/1.5+E45,IF(P46<0,E45,D45+E45))","v":{"v":2,"d":"2.0"}},{"$f":"TIME(0,60/$M$7*F45,0)","v":"00:30:00"},null,null,{"$f":"IF((J44+G45+L45)<>J44,J44+G45+L45,0)","v":1.5423611111111115},{"$nulls":5},{"v":0,"d":"0.0"}]
["Daigra",null,1408,{"$nulls":4},{"$f":"IF(E45>0,H44+E45,0)","v":22.5},{"$f":"IF(F45>0,I44+F45,0)","v":36.5},{"$f":"IF((J44+G45+L44)<>J44,J44+G45+L44,0)","v":1.5423611111111115},{"$nulls":5},-18.8]
[{"$nulls":3},{"$f":"IF(C48>0,(C48-C46)/100,0)","v":-1.68},{"v":2,"d":"2.0"},{"$f":"IF(P48<-20,-D47/1.5+E47,IF(P48<0,E47,D47+E47))","v":{"v":2,"d":"2.0"}},{"$f":"TIME(0,60/$M$7*F47,0)","v":"00:30:00"},null,null,{"$f":"IF((J46+G47+L47)<>J46,J46+G47+L47,0)","v":1.5631944444444448},{"$nulls":5},{"v":0,"d":"0.0"}]
["Baselga",null,1240,{"$nulls":4},{"$f":"IF(E47>0,H46+E47,0)","v":24.5},{"$f":"IF(F47>0,I46+F47,0)","v":38.5},{"$f":"IF((J46+G47+L46)<>J46,J46+G47+L46,0)","v":1.5631944444444448},{"$nulls":5},{"v":-8.399999999999999,"d":"-8.4"}]
[{"$nulls":3},{"$f":"IF(C50>0,(C50-C48)/100,0)","v":-0.24},1.5,{"$f":"IF(P50<-20,-D49/1.5+E49,IF(P50<0,E49,D49+E49))","v":1.5},{"$f":"TIME(0,60/$M$7*F49,0)","v":"00:22:00"},null,null,{"$f":"IF((J48+G49+L49)<>J48,J48+G49+L49,0)","v":1.5784722222222225},{"$nulls":5},{"v":0,"d":"0.0"}]
["Campo (Blenio)",null,1216,{"$nulls":4},{"$f":"IF(E49>0,H48+E49,0)","v":{"v":26,"d":"26.0"}},{"$f":"IF(F49>0,I48+F49,0)","v":{"v":40,"d":"40.0"}},{"$f":"IF((J48+G49+L48)<>J48,J48+G49+L48,0)","v":1.5784722222222225},{"$nulls":5},-1.6]
[{"$nulls":3},{"$f":"IF(C52>0,(C52-C50)/100,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(P52<-20,-D51/1.5+E51,IF(P52<0,E51,D51+E51))","v":{"v":0,"d":"0.0"}},{"$f":"TIME(0,60/$M$7*F51,0)","v":"00:00:00"},null,null,{"$f":"IF((J50+G51+L51)<>J50,J50+G51+L51,0)","v":0},{"$nulls":5},{"v":0,"d":"0.0"}]
[{"$nulls":7},{"$f":"IF(E51>0,H50+E51,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF(F51>0,I50+F51,0)","v":{"v":0,"d":"0.0"}},{"$f":"IF((J50+G51+L50)<>J50,J50+G51+L50,0)","v":"00:00:00"},{"$nulls":5},{"v":0,"d":"0.0"}]
[{"$nulls":9},{"$f":"IF((J52+#REF!+L53)<>J52,J52+#REF!+L53,0)","v":{"$error":"#REF!"}},{"$nulls":5},{"v":0,"d":"0.0"}]
["TOTAL Marschzeit ohne Pausen",{"$nulls":4},{"$f":"SUM(G12:G53)","v":"09:53:00"}]
[]
["Fahrplan",null,null,"Bemerkungen"]
["Ort",null,"Zeit"]
["Olten ab:",null,"06:00:00","via Zürich-Chur-Ilanz"]
["Vrin an:",null,"09:23:00"]
["Campo ab:",null,"16:58:00","via Olivone-Biasca-Luzern"]
["Olten an:",null,"21:25:00"]

{"sheet":"Anleitung","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[0,4,0,6],[4,4,4,6],[5,4,5,6],[9,4,9,6],[10,4,10,6],[12,4,12,6],[13,4,13,6]]}
[{"$nulls":4},"Geschwindigkeitsfaktoren"]
[{"$nulls":5},"mit Gepäck","ohne Gepäck"]
[{"$nulls":4},"untrainierte Gruppen,\nKinder,\ngrosse Gruppen","15 min / Lkm\n4 Lkm / h","12 min / Lkm\n5 Lkm / h"]
[{"$nulls":4},"trainierte Gruppen,\nJugendliche,\nkleine Gruppen","12 min / Lkm\n5 Lkm / h","10 min /Lkm\n6 Lkm / h"]
[{"$nulls":4},"Velofahren"]
[{"$nulls":4},"Die Zeitberechnung mit Leistunskilometern ist beim Velofahren wesentlich ungenauer als beim Wandern. Steigungen und Gefälle haben einen grösseren Einfluss. Die hier aufgeführten Faktoren gelten für falche Velotouren."]
[{"$nulls":4},"wenig trainierte oder grosse Gruppen","5 min / Lkm\n12 km / h","4 min / Lkm\n15 km / h"]
[{"$nulls":4},"trainierte, kleine Gruppe, gute Velos","4 min /Lkm\n15 km / h","3 min / Lkm\n20 km / h"]
[]
[{"$nulls":4},"Gefälle"]
[{"$nulls":4},"Für grosse und steie Abstiege im Gebirge braucht man mehr Zeit. Das Gefälle wird berücksichtigt, wenn es sich um mehr als 20 m auf 100 m Horizontaldistanz handelt. Dann entsprechen 150 Höhenmeter einem Leistungskilometer."]
[]
[{"$nulls":4},"Weitere Faktoren"]
[{"$nulls":4},"Die effektive Marschgeschwindigkeit hängt von vielen Faktoren ab. Einzelne schwierige Stellen können zu \"Zeitfressern\" werden. Einige wichtige Faktoren, welche du berücksichtigen solltest:"]
[{"$nulls":5},"schneller","langsamer"]
[{"$nulls":4},"Gruppengrösse","klein","gross"]
[{"$nulls":4},"Tageszeit","Morgen, Nacht","Nachmittag, Abend"]
[{"$nulls":4},"Wetter","kühl","heiss"]
[{"$nulls":4},"Gepäck","wenig","viel"]
[{"$nulls":4},"Wege","gute Wege","Geröllfelder, querfeldein"]
[{"$nulls":4},"Kartensicherheit","gute Karten-\nkenntnisse","häufige Kar-\ntenkontrollen"]

{"sheet":"Impressum","index":4,"n_rows":13,"n_cols":2,"rows_kept":13}
["Die Marschtabelle entspricht der Vorlage aus dem cudesch."]
[]
[null,"Die gelben Felder sind die Eingabefelder."]
[null,"Mit der Tabulatortaste springst Du von Eingabefeld zu Eingabefeld."]
[]
[]
[null,"Erstellt wurde diese Tabelle von Philipp Just/Grizzly"]
[null,"Ergänzt von Thomas Scheidgen/Phantom"]
["01-2007","Angepasst im Rahmen der cudesch-Erarbeitung von Stephan Heimgartner/Omega"]
[]
[]
["Bezug:"]
["www.cudesch.pbs.ch"]