{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["VZ","Ganglinien","Steuerung","Doku"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"VZ","index":0,"n_rows":71,"n_cols":14,"rows_kept":71,"cut":false,"hidden":false,"merged":[[35,1,36,1],[25,3,37,14],[51,1,51,3],[41,11,41,12],[23,6,23,7],[33,1,34,1],[47,11,47,12],[50,1,50,3],[23,9,23,13],[50,4,50,7],[51,4,51,7],[4,3,4,5],[43,11,43,12],[4,10,4,13],[6,3,6,5],[45,11,45,12],[15,5,15,7],[17,5,17,13],[8,3,8,5],[8,10,8,13],[21,5,21,13],[19,5,19,7],[19,9,19,13],[59,8,59,11],[0,9,0,13],[1,9,1,13],[2,9,2,13],[6,10,6,13],[52,4,52,7],[52,1,52,3],[54,1,54,3],[53,4,53,6],[53,1,53,3],[54,4,54,6]]}
[null,null,null,null,null,"Strassenlärmsanierung",null,null,null,"Grobabschätzung der"]
[null,null,null,null,null,"Gemeindestrassen",null,null,null,"Verkehrsbelastung"]
[null,"Tiefbauamt / Fachstelle Lärmschutz"]
[]
[null,"Gemeinde:",null,null,null,null,null,"Abschnitt:"]
[]
[null,"Strasse:",null,null,null,null,null,"von Koordinaten X/Y:"]
[]
[null,"Verkehrsart:",null,null,null,null,null,"bis Koordinaten X/Y:"]
[]
[null,null,null,null,null,null,null,"Abschnittslänge:"]
[]
[]
[null,"Angaben zu Standort und Art der Verkehrszählung"]
[]
[null,"Koordinaten X/Y:"]
[]
[null,"Beschreibung in Worten:"]
[]
[null,"Art der Verkehrszählung:",null,null,null,null,null,null,"Gerät:"]
[]
[null,"Verantwortlicher:"]
[]
[null,null,null,null,null,"Tel.:",null,null,"E-Mail: "]
[]
[null,"Situation"]
[]
[]
[]
[]
[]
[]
[]
[null,"Zähl-\nquerschnitt"]
[]
[null,"Abschnitts-\ngrenzen"]
[]
[]
[]
[null,"Zähldaten (manuell eingeben)"]
[]
[null,"Datum der Zählung (Tag.Monat.Jahr)"]
[]
[null,"Monat",null,null,null,null,null,null,null,null,null,{"$f":"update_month(L42)","v":""}]
[]
[null,"Wochentag",null,null,null,null,null,null,null,null,null,{"$f":"update_weekday(L42)","v":""}]
[]
[null,"Messzeit (vorgegeben zwischen 10:00-16:00, jeweils 1h):"]
[]
[]
[null,"Zählquerschnitt",null,null,"Richtung",null,null,null,"PW","Roller\nMofa","Motor-\nrad","Liefer-\nwagen","LW\nTraktor  ","Total  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I52:M52)>0,SUM(I52:M52),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I53:M53)>0,SUM(I53:M53),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I54:M54)>0,SUM(I54:M54),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I55:M55)>0,SUM(I55:M55),\"\")","v":""}]
[]
[]
[null,"Anzahl Fahrzeuge pro Stunde (für die Kategorien nach Anhang 3 §32 LSV):",null,null,null,null,null,null,null,null,null,"PW* :",0," [Fz/h]"]
[null," * inkl. Lieferwagenanteil von 80% ",null,null,null,null,null,null,null,null,null,"LW**:",0," [Fz/h]"]
[null,"** inkl. Lieferwagenanteil von 20% ",null,null,null,null,null,null,"Schwerverkehrsanteil:",null,null,null,0," [%]"]
[]
[]
[null,"Massgebende Verkehrszahlen (automatisch ermittelt)"]
[]
[null,"Durchschnittlicher 24h-Verkehr:",null,null,null,null,null,null,null,null,null,"DTV:",0," [Fz/24h]"]
[null,"Genauigkeit (Standardabweichung):",null,null,null,null,null,null,null,null,null,"σ:",0," [%]"]
[]
[null,null,null,null,null,null,null,null,null," tags (06-22 Uhr)",null,null," nachts (22-06 Uhr)"]
[null,"Verkehr im Jahresdurchschnitt:",null,null,null,null,null,null,"Nt","Nt1","Nt2","Nn","Nn1","Nn2"]
[null,"(aus Zähldaten hochgerechnet)   ",null,null,null,null,null,null,"[Fz/h]","[Fz/h]","[%]","[Fz/h]","[Fz/h]","[%]"]
[null,null,null,null,null,null,null,null,0,{"$f":"I71-I71*(K71/100)","v":0},0,0,{"$f":"L71-L71*(N71/100)","v":0},0]

{"sheet":"Ganglinien","index":1,"n_rows":58,"n_cols":26,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,3,0,8]]}
["Ganglinien gemäss SN 640 005a ",null,null,"Benannte Bereiche, es dürfen nur die Faktoren geändert werden",null,null,null,null,null,"dito"]
[]
["Jahresganglinie für Orts-/Pendlerverkehr (Seite 23)",null,null,null,null,null,"Werktagsganglinie für Regionalverkehr (Seite 24)",null,null,null,null,null,"Werktagsganglinie für Ortsverkehr (Seite 23)",null,null,null,null,"Jahresganglinie für Pendlerverkehr wie Ortsverkehr (Seite 23)",null,null,null,null,"Jahresganglinie für kleinräumigen Schwerverkehr (Seite 40)"]
[null,null,"Faktor:","in %","Standard-Abw.",null,null,null,"Faktor:",null,"Standard-Abw.",null,null,null,"Faktor:",null,null,null,null,"Faktor:",null,null,null,null,"Faktor:"]
["Januar",1,0.89,{"$f":"C5","v":0.89},0.06,null,"Januar",1,0.85,{"$f":"I5","v":0.85},0.06,null,"Januar",1,0.89,{"$f":"O5","v":0.89},null,"Januar",1,0.89,{"$f":"T5","v":0.89},null,"Januar",1,0.79600000000000004,{"$f":"Y5","v":0.79600000000000004}]
["Februar",2,0.88,0.88,0.05,null,"Februar",2,0.87,0.87,0.05,null,"Februar",2,0.88,0.88,null,"Februar",2,0.88,0.88,null,"Februar",2,0.84199999999999997,0.84199999999999997]
["März",3,1.02,1.02,0.03,null,"März",3,1.03,1.03,0.03,null,"März",3,1.02,1.02,null,"März",3,1.02,1.02,null,"März",3,0.93600000000000005,0.93600000000000005]
["April",4,1.01,1.01,0.04,null,"April",4,0.96,0.96,0.04,null,"April",4,1.01,1.01,null,"April",4,1.01,1.01,null,"April",4,1.0740000000000001,1.0740000000000001]
["Mai",5,1.05,1.05,0.05,null,"Mai",5,1.07,1.07,0.05,null,"Mai",5,1.05,1.05,null,"Mai",5,1.05,1.05,null,"Mai",5,1.0189999999999999,1.0189999999999999]
["Juni",6,1.02,1.02,0.03,null,"Juni",6,1,1,0.03,null,"Juni",6,1.02,1.02,null,"Juni",6,1.02,1.02,null,"Juni",6,1.0840000000000001,1.0840000000000001]
["Juli",7,1.04,1.04,0.09,null,"Juli",7,1.1200000000000001,1.1200000000000001,0.09,null,"Juli",7,1.04,1.04,null,"Juli",7,1.04,1.04,null,"Juli",7,1.1220000000000001,1.1220000000000001]
["August",8,1.07,1.07,0.1,null,"August",8,1.22,1.22,0.1,null,"August",8,1.07,1.07,null,"August",8,1.07,1.07,null,"August",8,1.0169999999999999,1.0169999999999999]
["September",9,1.05,1.05,0.04,null,"September",9,1.08,1.08,0.04,null,"September",9,1.05,1.05,null,"September",9,1.05,1.05,null,"September",9,1.1519999999999999,1.1519999999999999]
["Oktober",10,1.06,1.06,0.03,null,"Oktober",10,1.04,1.04,0.03,null,"Oktober",10,1.06,1.06,null,"Oktober",10,1.06,1.06,null,"Oktober",10,1.149,1.149]
["November",11,0.97,0.97,7.0000000000000007E-2,null,"November",11,0.88,0.88,7.0000000000000007E-2,null,"November",11,0.97,0.97,null,"November",11,0.97,0.97,null,"November",11,0.96,0.96]
["Dezember",12,0.95,0.95,0.05,null,"Dezember",12,0.88,0.88,0.05,null,"Dezember",12,0.95,0.95,null,"Dezember",12,0.95,0.95,null,"Dezember",12,0.84799999999999998,0.84799999999999998]
[]
[]
["Werktagsganglinie für Orts-/Pendlerverkehr (Seite 9)",null,null,null,null,null,"Werktagsganglinie für Regionalverkehr (Seite 11)",null,null,null,null,null,"Werktagsganglinie für Ortsverkehr (Seite 10)",null,null,null,null,"Werktagsganglinie für Pendlerverkehr (Seite 9)",null,null,null,null,"Werktagsganglinie für kleinräumigen Schwerverkehr (Seite 33)"]
["Mittel aus Orts- und Pendlerverkehr",null,"Faktor:","in %","Standard-Abw.",null,null,null,"Faktor:",null,"Standard-Abw.",null,null,null,"Faktor:",null,null,null,null,"Faktor:",null,null,null,null,"Faktor:"]
[1,"00:00-01:00",{"$f":"(O21+T21)/2","v":7.0000000000000001E-3},{"$f":"C21","v":7.0000000000000001E-3},1E-3,null,1,"00:00-01:00",6.0000000000000001E-3,{"$f":"I21","v":6.0000000000000001E-3},1E-3,null,1,"00:00-01:00",7.0000000000000001E-3,{"$f":"O21","v":7.0000000000000001E-3},null,1,"00:00-01:00",7.0000000000000001E-3,{"$f":"T21","v":7.0000000000000001E-3},null,1,"00:00-01:00",2E-3,{"$f":"Y21","v":2E-3}]
[2,"01:00-02:00",{"$f":"(O22+T22)/2","v":3.0000000000000001E-3},3.0000000000000001E-3,1E-3,null,2,"01:00-02:00",3.0000000000000001E-3,{"$f":"I22","v":3.0000000000000001E-3},1E-3,null,2,"01:00-02:00",3.0000000000000001E-3,3.0000000000000001E-3,null,2,"01:00-02:00",3.0000000000000001E-3,3.0000000000000001E-3,null,2,"01:00-02:00",1E-3,1E-3]
[3,"02:00-03:00",2E-3,2E-3,1E-3,null,3,"02:00-03:00",2E-3,2E-3,1E-3,null,3,"02:00-03:00",2E-3,2E-3,null,3,"02:00-03:00",2E-3,2E-3,null,3,"02:00-03:00",2E-3,2E-3]
[4,"03:00-04:00",2E-3,2E-3,1E-3,null,4,"03:00-04:00",2E-3,2E-3,1E-3,null,4,"03:00-04:00",2E-3,2E-3,null,4,"03:00-04:00",2E-3,2E-3,null,4,"03:00-04:00",2E-3,2E-3]
[5,"04:00-05:00",4.0000000000000001E-3,4.0000000000000001E-3,1E-3,null,5,"04:00-05:00",3.0000000000000001E-3,3.0000000000000001E-3,1E-3,null,5,"04:00-05:00",4.0000000000000001E-3,4.0000000000000001E-3,null,5,"04:00-05:00",4.0000000000000001E-3,4.0000000000000001E-3,null,5,"04:00-05:00",5.0000000000000001E-3,5.0000000000000001E-3]
[6,"05:00-06:00",1.35E-2,1.35E-2,4.0000000000000001E-3,null,6,"05:00-06:00",1.2E-2,1.2E-2,4.0000000000000001E-3,null,6,"05:00-06:00",1.0999999999999999E-2,1.0999999999999999E-2,null,6,"05:00-06:00",1.6E-2,1.6E-2,null,6,"05:00-06:00",0.03,0.03]
[7,"06:00-07:00",5.45E-2,5.45E-2,1.4E-2,null,7,"06:00-07:00",4.2000000000000003E-2,4.2000000000000003E-2,7.0000000000000001E-3,null,7,"06:00-07:00",4.8000000000000001E-2,4.8000000000000001E-2,null,7,"06:00-07:00",6.0999999999999999E-2,6.0999999999999999E-2,null,7,"06:00-07:00",5.5E-2,5.5E-2]
[8,"07:00-08:00",7.7499999999999999E-2,7.7499999999999999E-2,8.9999999999999993E-3,null,8,"07:00-08:00",6.4000000000000001E-2,6.4000000000000001E-2,8.0000000000000002E-3,null,8,"07:00-08:00",7.1999999999999995E-2,7.1999999999999995E-2,null,8,"07:00-08:00",8.3000000000000004E-2,8.3000000000000004E-2,null,8,"07:00-08:00",7.6999999999999999E-2,7.6999999999999999E-2]
[9,"08:00-09:00",5.6999999999999995E-2,5.6999999999999995E-2,8.0000000000000002E-3,null,9,"08:00-09:00",5.1999999999999998E-2,5.1999999999999998E-2,4.0000000000000001E-3,null,9,"08:00-09:00",5.3999999999999999E-2,5.3999999999999999E-2,null,9,"08:00-09:00",0.06,0.06,null,9,"08:00-09:00",8.4000000000000005E-2,8.4000000000000005E-2]
[10,"09:00-10:00",4.9000000000000002E-2,4.9000000000000002E-2,4.0000000000000001E-3,null,10,"09:00-10:00",5.0999999999999997E-2,5.0999999999999997E-2,3.0000000000000001E-3,null,10,"09:00-10:00",4.9000000000000002E-2,4.9000000000000002E-2,null,10,"09:00-10:00",4.9000000000000002E-2,4.9000000000000002E-2,null,10,"09:00-10:00",8.4000000000000005E-2,8.4000000000000005E-2]
[11,"10:00-11:00",5.1000000000000004E-2,5.1000000000000004E-2,4.0000000000000001E-3,null,11,"10:00-11:00",5.6000000000000001E-2,5.6000000000000001E-2,4.0000000000000001E-3,null,11,"10:00-11:00",5.1999999999999998E-2,5.1999999999999998E-2,null,11,"10:00-11:00",0.05,0.05,null,11,"10:00-11:00",9.0999999999999998E-2,9.0999999999999998E-2]
[12,"11:00-12:00",5.4999999999999993E-2,5.4999999999999993E-2,4.0000000000000001E-3,null,12,"11:00-12:00",5.8000000000000003E-2,5.8000000000000003E-2,3.0000000000000001E-3,null,12,"11:00-12:00",5.8999999999999997E-2,5.8999999999999997E-2,null,12,"11:00-12:00",5.0999999999999997E-2,5.0999999999999997E-2,null,12,"11:00-12:00",8.4000000000000005E-2,8.4000000000000005E-2]
[13,"12:00-13:00",5.1500000000000004E-2,5.1500000000000004E-2,4.0000000000000001E-3,null,13,"12:00-13:00",5.2999999999999999E-2,5.2999999999999999E-2,4.0000000000000001E-3,null,13,"12:00-13:00",5.5E-2,5.5E-2,null,13,"12:00-13:00",4.8000000000000001E-2,4.8000000000000001E-2,null,13,"12:00-13:00",5.3999999999999999E-2,5.3999999999999999E-2]
[14,"13:00-14:00",6.2E-2,6.2E-2,6.0000000000000001E-3,null,14,"13:00-14:00",6.6000000000000003E-2,6.6000000000000003E-2,3.0000000000000001E-3,null,14,"13:00-14:00",6.7000000000000004E-2,6.7000000000000004E-2,null,14,"13:00-14:00",5.7000000000000002E-2,5.7000000000000002E-2,null,14,"13:00-14:00",7.8E-2,7.8E-2]
[15,"14:00-15:00",5.8999999999999997E-2,5.8999999999999997E-2,5.0000000000000001E-3,null,15,"14:00-15:00",6.7000000000000004E-2,6.7000000000000004E-2,4.0000000000000001E-3,null,15,"14:00-15:00",6.0999999999999999E-2,6.0999999999999999E-2,null,15,"14:00-15:00",5.7000000000000002E-2,5.7000000000000002E-2,null,15,"14:00-15:00",8.5000000000000006E-2,8.5000000000000006E-2]
[16,"15:00-16:00",6.1499999999999999E-2,6.1499999999999999E-2,4.0000000000000001E-3,null,16,"15:00-16:00",7.0000000000000007E-2,7.0000000000000007E-2,5.0000000000000001E-3,null,16,"15:00-16:00",6.3E-2,6.3E-2,null,16,"15:00-16:00",0.06,0.06,null,16,"15:00-16:00",0.08,0.08]
[17,"16:00-17:00",7.9000000000000001E-2,7.9000000000000001E-2,6.0000000000000001E-3,null,17,"16:00-17:00",8.3000000000000004E-2,8.3000000000000004E-2,5.0000000000000001E-3,null,17,"16:00-17:00",7.9000000000000001E-2,7.9000000000000001E-2,null,17,"16:00-17:00",7.9000000000000001E-2,7.9000000000000001E-2,null,17,"16:00-17:00",6.8000000000000005E-2,6.8000000000000005E-2]
[18,"17:00-18:00",9.2999999999999999E-2,9.2999999999999999E-2,8.9999999999999993E-3,null,18,"17:00-18:00",9.4E-2,9.4E-2,4.0000000000000001E-3,null,18,"17:00-18:00",9.1999999999999998E-2,9.1999999999999998E-2,null,18,"17:00-18:00",9.4E-2,9.4E-2,null,18,"17:00-18:00",4.7E-2,4.7E-2]
[19,"18:00-19:00",7.2999999999999995E-2,7.2999999999999995E-2,5.0000000000000001E-3,null,19,"18:00-19:00",7.3999999999999996E-2,7.3999999999999996E-2,4.0000000000000001E-3,null,19,"18:00-19:00",7.2999999999999995E-2,7.2999999999999995E-2,null,19,"18:00-19:00",7.2999999999999995E-2,7.2999999999999995E-2,null,19,"18:00-19:00",2.9000000000000001E-2,2.9000000000000001E-2]
[20,"19:00-20:00",0.05,0.05,4.0000000000000001E-3,null,20,"19:00-20:00",5.0999999999999997E-2,5.0999999999999997E-2,4.0000000000000001E-3,null,20,"19:00-20:00",5.0999999999999997E-2,5.0999999999999997E-2,null,20,"19:00-20:00",4.9000000000000002E-2,4.9000000000000002E-2,null,20,"19:00-20:00",1.7999999999999999E-2,1.7999999999999999E-2]
[21,"20:00-21:00",3.2000000000000001E-2,3.2000000000000001E-2,3.0000000000000001E-3,null,21,"20:00-21:00",3.2000000000000001E-2,3.2000000000000001E-2,3.0000000000000001E-3,null,21,"20:00-21:00",3.3000000000000002E-2,3.3000000000000002E-2,null,21,"20:00-21:00",3.1E-2,3.1E-2,null,21,"20:00-21:00",1.2E-2,1.2E-2]
[22,"21:00-22:00",2.4500000000000001E-2,2.4500000000000001E-2,3.0000000000000001E-3,null,22,"21:00-22:00",2.4E-2,2.4E-2,3.0000000000000001E-3,null,22,"21:00-22:00",2.5000000000000001E-2,2.5000000000000001E-2,null,22,"21:00-22:00",2.4E-2,2.4E-2,null,22,"21:00-22:00",7.0000000000000001E-3,7.0000000000000001E-3]
[23,"22:00-23:00",2.1999999999999999E-2,2.1999999999999999E-2,3.0000000000000001E-3,null,23,"22:00-23:00",2.1000000000000001E-2,2.1000000000000001E-2,3.0000000000000001E-3,null,23,"22:00-23:00",2.1999999999999999E-2,2.1999999999999999E-2,null,23,"22:00-23:00",2.1999999999999999E-2,2.1999999999999999E-2,null,23,"22:00-23:00",4.0000000000000001E-3,4.0000000000000001E-3]
[24,"23:00-24:00",{"$f":"(O44+T44)/2","v":1.6E-2},1.6E-2,2E-3,null,24,"23:00-24:00",1.4E-2,1.4E-2,2E-3,null,24,"23:00-24:00",1.6E-2,1.6E-2,null,24,"23:00-24:00",1.6E-2,{"$f":"T44","v":1.6E-2},null,24,"23:00-24:00",3.0000000000000001E-3,3.0000000000000001E-3]
["Anteil Tagesperiode",null,{"$f":"SUM(C27:C42)","v":0.92949999999999988},null,null,null,"Anteil Tagesperiode",null,{"$f":"SUM(I27:I42)","v":0.93699999999999994},null,null,null,"Anteil Tagesperiode",null,{"$f":"SUM(O27:O42)","v":0.93299999999999983},null,null,"Anteil Tagesperiode",null,{"$f":"SUM(T27:T42)","v":0.92600000000000005},null,null,"Anteil Tagesperiode",null,{"$f":"SUM(Y27:Y42)","v":0.95299999999999996}]
[]
[]
["Wochenganglinie für Orts-/Pendlerverkehr (Seite 19)",null,null,null,null,null,"Wochenganglinie für Regionalverkehr (Seite 20)",null,null,null,null,null,"Wochenganglinie für Ortsverkehr (Seite 19)",null,null,null,null,"Wochenganglinie für Pendlerverkehr wie Ortsverkehr (Seite 9)",null,null,null,null,"Wochenganglinie für kleinräumigen Schwerverkehr (Seite 38)"]
[null,null,"Faktor:","in %","Standard-Abw.",null,null,null,"Faktor:",null,"Standard-Abw.",null,null,null,"Faktor:",null,null,null,null,"Faktor:",null,null,null,null,"Faktor:"]
[1,"Montag",0.95,{"$f":"C50","v":0.95},0.02,null,1,"Montag",0.94,{"$f":"I50","v":0.94},0.02,null,1,"Montag",0.95,{"$f":"O50","v":0.95},null,1,"Montag",0.95,{"$f":"T50","v":0.95},null,1,"Montag",0.98,{"$f":"Y50","v":0.98}]
[2,"Dienstag",0.97,{"$f":"C51","v":0.97},0.02,null,2,"Dienstag",0.95,{"$f":"I51","v":0.95},0.02,null,2,"Dienstag",0.97,{"$f":"O51","v":0.97},null,2,"Dienstag",0.97,{"$f":"T51","v":0.97},null,2,"Dienstag",1.01,{"$f":"Y51","v":1.01}]
[3,"Mittwoch",1,1,0.02,null,3,"Mittwoch",1,1,0.02,null,3,"Mittwoch",1,1,null,3,"Mittwoch",1,1,null,3,"Mittwoch",1.01,1.01]
[4,"Donnerstag",1,1,0.01,null,4,"Donnerstag",1,1,0.01,null,4,"Donnerstag",1,1,null,4,"Donnerstag",1,1,null,4,"Donnerstag",1.03,1.03]
[5,"Freitag",1.08,1.08,0.04,null,5,"Freitag",1.1100000000000001,1.1100000000000001,0.04,null,5,"Freitag",1.08,1.08,null,5,"Freitag",1.08,1.08,null,5,"Freitag",0.97,0.97]
[6,"Samstag",0.93,0.93,0.09,null,6,"Samstag",1.1000000000000001,1.1000000000000001,0.09,null,6,"Samstag",0.93,0.93,null,6,"Samstag",0.93,0.93,null,6,"Samstag",0.28999999999999998,0.28999999999999998]
[7,"Sonntag",0.8,0.8,0.13,null,7,"Sonntag",1.04,1.04,0.13,null,7,"Sonntag",0.8,0.8,null,7,"Sonntag",0.8,0.8,null,7,"Sonntag",0.14000000000000001,0.14000000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"6.73/7","v":0.96142857142857152},{"$f":"T58*52","v":49.994285714285716}]

{"sheet":"Steuerung","index":2,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":true,"merged":[[8,4,11,4]]}
[]
[null,null,null,null,"Aufteilung Lieferwagen auf PW und Schwerverkehr"]
[null,"VZ_Kat","Orts-/Pendlerverkehr",null,"LW_Anteil",0.8,"80% zu PW"]
[null,null,"Regionalverkehr",null,null,0.2,"20% zu LKW"]
[]
[null,"VZ_Tag","Montag"]
[null,null,"Dienstag",null,"Standardwerte LSV Art. 33:"]
[null,null,"Mittwoch"]
[null,null,"Donnerstag",null,"LSV",0.1," 10% tags Anteil Schwerverkehr"]
[null,null,"Freitag",null,null,0.05," 5% nachts Anteil Schwerverkehr"]
[null,null,null,null,null,5.8000000000000003E-2,"Anteil Tagesverkehr an DTV"]
[null,null,null,null,null,8.9999999999999993E-3,"Anteil Nachtverkehr an DTV"]
[null,"VZ_Periode","00:00-01:00"]
[null,null,"01:00-02:00"]
[null,null,"02:00-03:00"]
[null,null,"03:00-04:00"]
[null,null,"04:00-05:00"]
[null,null,"05:00-06:00"]
[null,null,"06:00-07:00"]
[null,null,"07:00-08:00"]
[null,null,"08:00-09:00"]
[null,null,"09:00-10:00"]
[null,null,"10:00-11:00"]
[null,null,"11:00-12:00"]
[null,null,"12:00-13:00"]
[null,null,"13:00-14:00"]
[null,null,"14:00-15:00"]
[null,null,"15:00-16:00"]
[null,null,"16:00-17:00"]
[null,null,"17:00-18:00"]
[null,null,"18:00-19:00"]
[null,null,"19:00-20:00"]
[null,null,"20:00-21:00"]
[null,null,"21:00-22:00"]
[null,null,"22:00-23:00"]
[null,null,"23:00-24:00"]
[]
[]
[null,"VZ_Art","Handzählung"]
[null,null,"Automatisch"]

{"sheet":"Doku","index":3,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,0,19,6],[23,0,23,6]]}
["Legende"]
[]
["X / Y","Landeskoordinaten (Rechtswert / Hochwert) gemäss Bezugssystem der Landestopographie"]
["PW","PW pro Stunde (inkl. Mofas sowie Lieferwagenanteil von 80%)"]
["LKW","Last(kraft)wagen"]
["LW","Schwerverkehr pro Stunde (LKW inkl. Motorräder und 20% Lieferwagenanteil)"]
["DTV","Durchschnittlicher täglicher Verkehr (= Anzahl PW+LW in 24h)"]
[]
["Nt","Durchschnittliche Anzahl Fahrzeuge pro Stunde zwischen 06-22"]
["Nt1","Durchschnittliche Anzahl PW pro Stunde zwischen 06-22"]
["Nt2","Durchschnittliche Anzahl LW pro Stunde zwischen 06-22"]
[]
["Nn","Durchschnittliche Anzahl Fahrzeuge pro Stunde zwischen 22-06"]
["Nn1","Durchschnittliche Anzahl PW pro Stunde zwischen 22-06"]
["Nn2","Durchschnittliche Anzahl LW pro Stunde zwischen 22-06"]
[]
[]
["Hinweise"]
[]
["Das Tool dient zur Berechnung des durchschnittlichen 24h-Verkehrs (DTV) auf Gemeindestrassen aufgrund einer einzelnen Verkehrszählung. \nAbhängig von der gewählten Verkehrsart werden die entsprechenden Jahres-, Wochentags- und Tagesganglinien für die Berechnung des DTV berücksichtigt (Quelle: VSS-Norm SN 640 005a).\nEs können zwei für Gemeinden typische Verkehrsarten eingestellt werden:\n- Orts-/Pendlerverkehr\n- Regionalverkehr\n\nBeim Ortsverkehr bestimmt der kleinräumige Pendler-, Einkaufs- und Nutzverkehr die Ganglinien.\nBeim Pendlerverkehr handelt es sich um Verkehr, der sich auf dem übergeordneten Strassennetz abspielt, wobei Pendler, welche grössere Distanzen zurücklegen, dominieren.\nWeil der Orts- und der Pendlerverkehr sehr ähnliche Ganglinien aufweisen, wurden sie zusammengefasst und die prozentualen Verkehrsanteile aus den Ganglinien gemittelt.\n\nDer Regionalverkehr umfasst den überörtlichen Verkehr, soweit es sich nicht um den Typ Freizeitverkehr handelt, und ist verglichen mit diesem kleinräumiger. Verglichen mit dem Typ Ortsverkehr haben Pendler- und Einkaufsverkehr eine geringere Bedeutung.\n\nDer Schwerverkehrsanteil wird ebenfalls aus den Ganglinien für \"kleinräumigen Schwerverkehr\" berechnet. Zusätzlich wird auch eine Angabe über die Genauigkeit des berechneten DTV in Form der Standardabweichung gemacht. Die Grundlagen dafür stammen ebenfalls aus der oben zitierten VSS-Norm, d.h. die Standardabweichung ist nur vom eingestellten Datum, der Zählzeit und der Verkehrsart abhängig."]
[]
["Vorgehen"]
[]
["Mittels 'TAB' von Feld zu Feld springen und die erforderlichen Informationen einfüllen. Teilweise sind Auswahllisten hinterlegt. Es können nur die Felder mit blauer Schrift vom Benutzer manuell verändert werden. \n\nDie Symbole für die Bezeichnung des Mess-Standortes und des Strassenabschnittes, für welchen die Verkehrszählung gilt, können in den Situationsplan kopiert werden.\n\nDie Verkehrszahlen werden pro Fahrtrichtung und Fahrzeugkategorie in die Felder der Zähltabelle eingegeben. Die von diesen Daten abhängigen Grössen (DTV, etc.) werden jeweils sofort neu berechnet.\n\nEine Neuberechnung erfolgt auch, wenn die Verkehrsart, das Datum oder die Messzeit geändert werden, mit dem Unterschied, dass nur der DTV und die Daten in der Resultat-Tabelle \"Verkehr im Jahresdurchschnitt\" aktualisiert werden. Solche nachträglichen Änderungen können jederzeit vorgenommen werden.\n\n"]