{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["leer","Beispiel","Anleitung"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1900"}

{"sheet":"leer","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,10,5,10],[3,11,5,11],[3,12,5,12],[3,13,6,13],[6,0,6,1],[3,8,5,8],[1,1,1,12],[2,1,2,2],[2,3,2,6],[2,7,2,11],[3,1,3,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,7,5,7],[4,0,4,2],[5,0,5,2],[3,9,5,9]]}
["Calcul du temps"]
["Itinéraire:",{"$nulls":12},"Facteur de vitesse (kme/h):"]
["Date:",null,null,"Valeurs intermédiaires",null,null,null,"Sommes totales"]
["Réalisé par:",null,null,"Dénivelé par 100 m *","Distance horizontale","Kilomètre-effort **","Temps","Distance","Kilomètre-effort","Pente/déclivité","Temps planifié","Temps effectif","Pauses/Trajets motorisés","Remarques \n\n * Noter les dénivelés\n   directement en hm\n   (1 hm = 100 m)\n\n** kilomètre-effort:  \n   distance (en km) \n   + pente (en hm)"]
["Cartes nationales:"]
[]
["Lieux, lieux-dits, coordonnées",null,"Altitude","hm","km","kme","h:mm","km","kme","%","hh:mm","hh:mm","h:mm"]
[null,null,null,0,0,0,"00:00:00",0,0,0,"09:00:00"]
[null,null,null,{"$f":"IF(E9=0,0,IF(C9>0,(C9-C8)/100,0))","v":0},null,{"$f":"IF(E9=0,0,IF(J9<-20,-D9/1.5+E9,IF(J9<0,E9,D9+E9)))","v":0},{"$f":"IF(E9=0,0,TIME(0,60/$N$3*F9,0))","v":"00:00:00"},{"$f":"H8+E9","v":0},{"$f":"I8+F9","v":0},{"$f":"IF(E9=0,0,D9/(10*E9)*100)","v":0},{"$f":"IF((K8+G9+M9)<>K8,K8+G9+M9,0)","v":"00:00:00"}]
[null,null,null,{"$f":"IF(E10=0,0,IF(C10>0,(C10-C9)/100,0))","v":0},null,0,"00:00:00",{"$f":"H9+E10","v":0},0,{"$f":"IF(E10=0,0,D10/(10*E10)*100)","v":0},{"$f":"IF((K9+G10+M10)<>K9,K9+G10+M10,0)","v":"00:00:00"}]
[null,null,null,{"$f":"IF(E11=0,0,IF(C11>0,(C11-C10)/100,0))","v":0},null,0,"00:00:00",{"$f":"H10+E11","v":0},0,{"$f":"IF(E11=0,0,D11/(10*E11)*100)","v":0},{"$f":"IF((K10+G11+M11)<>K10,K10+G11+M11,0)","v":"00:00:00"}]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,{"$f":"IF((K16+G17+M17)<>K16,K16+G17+M17,0)","v":"00:00:00"}]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
[null,null,null,0,null,0,"00:00:00",0,0,0,"00:00:00"]
["Sommes",{"$nulls":5},{"$f":"SUM(G8:G28)","v":"00:00:00"},{"$f":"MAX(H9:H28)","v":0},{"$f":"MAX(I9:I28)","v":0},null,null,null,{"$f":"SUM(M8:M28)","v":"00:00:00"}]

{"sheet":"Beispiel","index":1,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,12],[2,1,2,2],[2,3,2,6],[2,7,2,11],[3,13,6,13],[4,0,4,2],[5,0,5,2],[6,0,6,1],[3,7,5,7],[3,8,5,8],[3,9,5,9],[3,10,5,10],[3,11,5,11],[3,12,5,12],[3,1,3,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[3,6,5,6]]}
["Calcul du temps"]
["Itinéraire:","Vrin (GR) − col Pass Disruet − Plaine de la Greina − Campo (Blenio)",{"$nulls":11},"Facteur de vitesse (kme/h):"]
["Date:","22.-23.09.2007",null,"Valeurs intermédiaires",null,null,null,"Sommes totales",{"$nulls":5},4]
["Réalisé par:","Omega",null,"Dénivelé par 100 m *","Distance horizontale","Kilomètre-effort **","Temps","Sdistance","Kilomètre-effort","Pente/déclivité","Temps planifié","Temps effectif","Pauses/Trajets motorisés","Remarques \n\n * Noter les dénivelés\n   directement en hm\n   (1 hm = 100 m)\n\n** kilomètre-effort:  \n   distance (en km) \n   + pente (en hm)"]
["Cartes nationales:"]
["1233 Greina\n1234 Vals\n1253 Olivone"]
["Lieux, lieux-dits, coordonnées",null,"Altitude","hm","km","kme","h:mm","km","kme","%","hh:mm","hh:mm","h:mm"]
["Vrin",null,1400,0,0,0,"00:00:00",0,0,0,"09:00:00"]
["Cons",null,1500,{"$f":"IF(E9=0,0,IF(C9>0,(C9-C8)/100,0))","v":1},1,{"$f":"IF(E9=0,0,IF(J9<-20,-D9/1.5+E9,IF(J9<0,E9,D9+E9)))","v":2},{"$f":"IF(E9=0,0,TIME(0,60/$N$3*F9,0))","v":"00:30:00"},{"$f":"H8+E9","v":1},{"$f":"I8+F9","v":2},{"$f":"IF(E9=0,0,D9/(10*E9)*100)","v":10},{"$f":"IF((K8+G9+M9)<>K8,K8+G9+M9,0)","v":"09:30:00"}]
["Sogn Giusep",null,1598,{"$f":"IF(E10=0,0,IF(C10>0,(C10-C9)/100,0))","v":0},0,0,"00:00:00",{"$f":"H9+E10","v":1},2,{"$f":"IF(E10=0,0,D10/(10*E10)*100)","v":0},{"$f":"IF((K9+G10+M10)<>K9,K9+G10+M10,0)","v":"11:30:00"},null,"02:00:00","Trajet motorisé"]
["Puzzatsch",null,1667,{"$f":"IF(E11=0,0,IF(C11>0,(C11-C10)/100,0))","v":0.69},1.2,1.89,"00:28:00",{"$f":"H10+E11","v":2.2000000000000002},3.8899999999999997,{"$f":"IF(E11=0,0,D11/(10*E11)*100)","v":5.75},{"$f":"IF((K10+G11+M11)<>K10,K10+G11+M11,0)","v":"11:58:00"}]
["Tegia Sut",null,1899,2.3199999999999998,1.8,4.12,"01:01:00",4,8.01,12.888888888888889,"12:59:00"]
["Pass  Diesrut",null,2428,5.29,2.7,7.99,"01:59:00",6.7,16,19.592592592592592,"15:58:00",null,"01:00:00","Pause midi"]
["Camona",null,2194,-2.34,1,2.5599999999999996,"00:38:00",7.7,18.559999999999999,-23.4,"16:36:00"]
["Carpet la Greina",null,2257,0.63,0.2,0.83000000000000007,"00:12:00",7.9,19.39,31.5,"16:48:00"]
["Cabane Terri",null,2170,-0.87,0.6,0.6,"00:09:00",8.5,19.990000000000002,-14.499999999999998,"16:57:00"]
["Cabane Terri",null,2170,{"$f":"IF(E17=0,0,IF(C17>0,(C17-C16)/100,0))","v":0},0,0,"00:00:00",8.5,19.990000000000002,0,{"$f":"IF((K16+G17+M17)<>K16,K16+G17+M17,0)","v":1.375},null,"16:03:00","Nuit en cabane"]
["Pt. 2265",null,2265,{"$f":"IF(E18=0,0,IF(C18>0,(C18-C17)/100,0))","v":0.95},1.5,2.4500000000000002,"00:36:00",10,22.44,6.3333333333333321,1.4]
["Pt. 2246",null,2246,-0.19,1,1,"00:15:00",11,23.44,-1.9,1.4104166666666667]
["Pt. 2344",null,2344,0.98,2.5,3.48,"00:52:00",13.5,26.92,3.92,1.4465277777777779]
["Col de la Greina",null,2355,0.11,0.5,0.61,"00:09:00",14,27.53,2.1999999999999997,1.4527777777777779]
["Pt. 2379",null,2379,0.24,0.5,0.74,"00:11:00",14.5,28.27,4.8,1.4604166666666669]
["Près cabane Scaletta",null,2229,-1.5,1.3,1.3,"00:19:00",15.8,29.57,-11.538461538461538,1.4736111111111114]
["Pian Geirett",null,1976,-2.5299999999999998,1.5,1.5,"00:22:00",17.3,31.07,-16.866666666666667,1.5305555555555559,null,"01:00:00","Pause midi"]
["Alpe di Camadra di Fuori",null,1784,-1.92,1.5,1.5,"00:22:00",18.8,32.57,-12.8,1.5458333333333336]
["Daigra",null,1408,-3.76,2,2,"00:30:00",20.8,34.57,-18.8,1.5666666666666669]
["Baselga",null,1240,-1.68,2,2,"00:30:00",22.8,36.57,-8.3999999999999986,1.5875000000000001]
["Campo (Blenio)",null,1216,-0.24,1.5,1.5,"00:22:00",24.3,38.07,-1.6,1.6027777777777779]
["Sommes",{"$nulls":5},{"$f":"SUM(G8:G28)","v":"09:25:00"},{"$f":"MAX(H9:H28)","v":24.3},{"$f":"MAX(I9:I28)","v":38.07},null,null,null,{"$f":"SUM(M8:M28)","v":"20:03:00"}]

{"sheet":"Anleitung","index":2,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,4,17,6],[4,4,4,6],[8,4,8,6],[9,4,9,6],[13,4,13,6],[14,4,14,6],[16,4,16,6]]}
["  Calcul du temps"]
["   Marche à suivre",{"$nulls":10},"Start"]
[{"$nulls":11},"x1","x2","y1","y2"]
[{"$nulls":11},0,100,0,0]
[{"$nulls":4},"Facteurs de vitesse",{"$nulls":8},0,10]
[{"$nulls":5},"Avec bagages","Sans bagages",{"$nulls":6},0,20]
[{"$nulls":4},"Groupes non entraînés, enfants, grands groupes","15 min/kme\n4 kme/h","12 min/kme\n5 kme/h",{"$nulls":6},0,30]
[{"$nulls":4},"Groupes entraînés, jeunes, petits groupes","12 min/kme\n5 kme/h","10 min/kme\n6 kme/h",{"$nulls":6},0,40]
[{"$nulls":4},"Excursions à vélo",{"$nulls":8},0,50]
[{"$nulls":4},"Le calcul du temps avec les kme est nettement moins précis pour les excursions à vélo que pour les randonnées à pied. Les montées et les descentes ont une plus grande influence. Les facteurs mentionnés ici sont valables pour des excursions à vélo au plat.",{"$nulls":8},0,60]
[{"$nulls":4},"Groupes peu entraînés   ou grands groupes","5 min/kme\n12 km/h","4 min/kme\n15 km/h",{"$nulls":6},0,70]
[{"$nulls":4},"Groupes entraînés, petits groupes, bons vélos","4 min/kme\n15 km/h","3 min/kme\n20 km/h",{"$nulls":6},0,80]
[{"$nulls":13},0,90]
[{"$nulls":4},"Descentes raides",{"$nulls":8},0,100]
[{"$nulls":4},"Pour les descentes longues et raides en montagne, il faut compter plus de temps. La pente sera prise en considération \nà partir du moment où elle est supérieure à 20 m par 100 m de distance horizontale. Dès lors, 150 m de dénivelé comptent comme un kilomètre-effort.",{"$nulls":8},0,110]
[{"$nulls":13},0,120]
[{"$nulls":4},"Autres facteurs",{"$nulls":8},0,130]
[{"$nulls":4},"La vitesse de marche effective dépend de nombreux facteurs. Certains endroits difficiles peuvent devenir des «bouffeurs de temps». \nVoici quelques facteurs à prendre en considération:",{"$nulls":8},0,140]
[{"$nulls":5},"Plus rapide","Plus lent",{"$nulls":6},0,150]
[{"$nulls":4},"Taille du groupe","Petit ","Grand ",{"$nulls":6},0,160]
[{"$nulls":4},"Heure de la journée","Matin, \nnuit","Après-midi,\nsoir",{"$nulls":6},0,170]
[{"$nulls":4},"Météo","Frais ","Chaud"]
[{"$nulls":4},"Bagages","Peu ","Beaucoup "]
[{"$nulls":4},"Chemins","Bons chemins","Eboulis, à travers champ"]
[{"$nulls":4},"Connaissances topographiques","Bonnes connaissances","Contrôle fréquent         des cartes"]