{"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":7,"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":[[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],[3,10,5,10],[3,11,5,11],[3,12,5,12],[3,13,6,13],[6,0,6,1],[3,8,5,8]]}
["Calcolare il tempo"]
["Percorso:",{"$nulls":12},"Fattore velocità (kms/h):"]
["Data:",null,null,"Valori intermedi",null,null,null,"Valori complessivi"]
["Compilato da:",null,null,"Differenza altimetrica in 100 m*","Distanza orizzontale","Chilometro-sforzo**","Tempo","Distanza","Chilometro-sforzo","Dislivello/Pendenza","Tempo previsto","Tempo effettivo","Pause/Spostamenti","\nOsservazioni\n\n * Riportare i metri \n   di dislivello \n   direttamente \n   in ettometri \n   (1 hm = 100 m)\n\n** Chilometro-sforzo: \n    Distanza (in km) \n    + dislivello in hm"]
["Carte topografiche:"]
[]
["Luogo, nome della località, \ncoordinate",null,"Altezza","hm","km","kms","h:mm","km","kms","%","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"]
["Totali",{"$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":[[3,4,5,4],[3,5,5,5],[3,6,5,6],[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]]}
["Calcolare il tempo"]
["Percorso:","Vrin (GR) - Disrut Pass - Greina Ebene - Campo (Blenio)",{"$nulls":11},"Fattore velocità (kms/h):"]
["Data:","22.-23.09.2007",null,"Valori intermedi",null,null,null,"Valori complessivi",{"$nulls":5},4]
["Compilato da:","Omega",null,"Differenza altimetrica in 100 m*","Distanza orizzontale","Chilometro-sforzo**","Tempo","Distanza","Chilometro-sforzo","Dislivello/Pendenza","Tempo previsto","Tempo effettivo","Pause/Spostamenti","\nOsservazioni\n\n * Riportare i metri \n   di dislivello \n   direttamente \n   in ettometri \n   (1 hm = 100 m)\n\n** Chilometro-sforzo: \n    Distanza (in km) \n    + dislivello in hm"]
["Carte topografiche:"]
["1233 Greina\n1234 Vals\n1253 Olivone"]
["Luogo, nome della località, \ncoordinate",null,"Altezza","hm","km","kms","h:mm","km","kms","%","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","Spostamento"]
["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","Pausa pranzo"]
["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"]
["Capanna Terri ",null,2170,-0.87,0.6,0.6,"00:09:00",8.5,19.990000000000002,-14.499999999999998,"16:57:00"]
["Capanna 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","Pernottamento \nin capanna"]
["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]
["Passo 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]
["Capanna 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","Pausa pranzo"]
["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]
["Totali",{"$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]]}
["Calcolare il tempo"]
["Istruzioni",{"$nulls":10},"Start"]
[{"$nulls":11},"x1","x2","y1","y2"]
[{"$nulls":11},0,100,0,0]
[{"$nulls":4},"Fattori velocità",{"$nulls":8},0,10]
[{"$nulls":5},"con bagaglio","senza bagaglio",{"$nulls":6},0,20]
[{"$nulls":4},"gruppi non allenati, bambini, gruppi numerosi 15 min/kms 4 kms/h","15 min / kms\n4 kms / h","12 min / kms\n5 kms / h",{"$nulls":6},0,30]
[{"$nulls":4},"gruppi allenati, giovani, gruppi poco numerosi","12 min / kms\n5 kms / h","10 min / kms\n6 kms / h",{"$nulls":6},0,40]
[{"$nulls":4},"Escursioni in bicicletta",{"$nulls":8},0,50]
[{"$nulls":4},"Il calcolo del tempo in chilometri-sforzo è molto meno preciso per le escursioni in bicicletta rispetto alle escursioni a piedi. Salite e dislivelli hanno un'incidenza maggiore. I fattori riportati di seguito valgono per escursioni in bicicletta su terreno pianeggiante.",{"$nulls":8},0,60]
[{"$nulls":4},"Gruppi poco allenati o numerosi","5 min / kms\n12 km / h","4 min / kms\n15 km / h",{"$nulls":6},0,70]
[{"$nulls":4},"gruppi allenati, \npoco numerosi, buone biciclette\n","4 min /kms\n15 km / h","3 min / kms\n20 km / h",{"$nulls":6},0,80]
[{"$nulls":13},0,90]
[{"$nulls":4},"Dislivello",{"$nulls":8},0,100]
[{"$nulls":4},"Per le discese lunghe e ripide in montagna si impiegherà più tempo. Il dislivello viene preso in considerazione se è maggiore di 20 m su 100 m di distanza orizzontale. In questo caso 150 metri di dislivello corrispondono a un chilometro-sforzo.",{"$nulls":8},0,110]
[{"$nulls":13},0,120]
[{"$nulls":4},"Altri fattori",{"$nulls":8},0,130]
[{"$nulls":4},"La velocità effettiva dipende da molti fattori. Singoli passaggi difficili possono far perdere molto tempo. Ecco alcuni fattori importanti da tenere in considerazione 09.05.2014",{"$nulls":8},0,140]
[{"$nulls":5},"velocità maggiore","velocità \nminore",{"$nulls":6},0,150]
[{"$nulls":4},"Dimensione del gruppo\n","poco \nnumeroso","molto \nnumeroso",{"$nulls":6},0,160]
[{"$nulls":4},"Ora del giorno\n","mattina,\nnotte","pomeriggio, sera",{"$nulls":6},0,170]
[{"$nulls":4},"Condizioni meteo","freddo","caldo"]
[{"$nulls":4},"Bagaglio","poco","tanto"]
[{"$nulls":4},"Sentieri\n\n","sentieri\nin buone \ncondizioni","pietraia estesa, terreno \nimpervio"]
[{"$nulls":4},"\nConoscenza delle carte\n","buona conoscenza","consultazione frequente"]