{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Information","Indata & Resultat","Beräkna ÅDT","Hastighet","Trafiksäkerhet","CO2","Version"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":5,"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":"Information","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,1,3,11],[30,1,30,11],[27,1,27,11],[28,1,28,11],[17,1,17,11]]}
["Schablonmodell, trafiksäkerhets-, restids- och CO2-effekter - RHA regionala hastighetsanalyser, 2023.1"]
[]
["Indata:","Fylls i de grå fälten och tryck \"Starta\" för att se resultat, avvakta tills makrot har kört klart. "]
[null,"Hela den grå raden på Indata och Resultat måste vara ifylld för att makrot ska fungera"]
["Löpnummer"]
["Region"]
["Län"]
["Vägnummer"]
["Objektnamn:","Förslagsvis namn som används i RHA"]
["Vägkategori:","Ange europaväg, länsväg eller riksväg"]
["Trafikflöde:","Fordon per dygn 2025. Vänligen använd fliken \"Beräkna ÅDT\""]
["Längd:","Km. Längd och trafikflöde antas konstant före/efter"]
["Vägtyp före:","GIF om genomfart i tätortsmiljö, 2kf om landsväg, MLV eller MV"]
["Skyltad hastighet före:","Avser huvudsaklig skyltad hastighetsgräns före. GIF 50 eller 70, 2 kf 70, 90 eller 100 och för MLV 90, 100 eller 110"]
["ATK före:","Ja eller Nej. Vid ATK innan så antas ATK efter och tvärt om"]
["Landsbygd eller tätort:","Ger potens enligt effektkatalogen, kap 6, se flik Trafiksäkerhet U3:W5. GIF=tätort och 2kf/MLV/MV=landsbygd"]
["Ombyggnad till:","RHA beräknar enbart effekter vid hastighetsförändringar, vid ombyggnation bör istället EVA användas (är nu en dold flik)"]
["Beräkningsmetod:","Beräkningar i gula fält, har dolts"]
["Hastighet före ATK:","Medelhastighet skattas enligt Effektkatalogsamband för typisk timhastighet."]
[null,"Linjeföring SK1 till SK2. Inga korsningar med större inverkan på medelhastighet sett över hela sträckan."]
["Hastighet före med ATK:","Beräknas enligt Effektkatalogen kap 4.5.10 ATK, se Hastighet K5:P15 "]
["Hastigheter efter utan ATK:","Beräknas med uppskattningar enligt utvärdering översyn, se hastighet R28:U34"]
["Andelar personbilar och lastbilar med och utan släp","Använd senaste mätning på Trafikflödeskartan: http://vtf.trafikverket.se/SeTrafikfloden"]
["ATK-effekter:","Enligt effektkatalog 4.10, se hastighet V4:Y21"]
["Trafiksäkerhet före:","Före-utfall beräknas enligt effektkatalog med schablontillägg korsningar, se trafiksäkerhet H2:N18"]
["Trafiksäkerhetseffkter:","Med potensmodell, se Trafiksäkerhet U3:W5"]
["Koldioxideffekter:","Beräknas enligt CO2 effekter enligt beslutad politik, indata från Helen Lindblom"]
["Resultat:","Restid i de ljusblå"]
[null,"Trafiksäkerhetseffekter ges i de gröna fälten"]
[null,"Koldioxideffekter ges i de oranga fälten"]
[null,"Summa av respektive effekt återfinns längst ner i \"Indata & resultat\""]
[]
[null,"Tryck på \"Radera\" för att återställa beräkningarna"]
[]
[null,"Vid frågor eller synpunkter, vänligen kontakta:"]
[null,"Magdalena Wande"]
[null,"PLee"]

{"sheet":"Indata & Resultat","index":1,"n_rows":92,"n_cols":100,"rows_kept":92,"cut":false,"hidden":false,"merged":[[7,5,8,5],[7,8,8,8],[7,10,8,10],[2,11,8,11],[2,13,8,13],[8,18,8,19],[8,60,8,63],[7,15,8,17],[7,6,8,6],[7,7,8,7]]}
[{"$f":"Information!A1","v":"Schablonmodell, trafiksäkerhets-, restids- och CO2-effekter - RHA regionala hastighetsanalyser, 2023.1"},null,null,null,null,null,null,null,null,null,null,"Ombyggnad","EFTER ÅTGÄRD Skyltad hastighet ","ATK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alternativ:","Alternativ:"]
[null,null,null,null,null,null,null,null,null,null,null,"Ombyggnad finns inte som alternativ längre, vänligen välj \"Nej\"","GIF50 före: 40","Om ATK före åtgärd så måste det finnas efter. Det går att lägga till ATK för: GIF50 GIF70 2kf70 2kf90"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GIF70 före:60"]
["Indata:",null,null,null,null,null,null,null,"FÖRE ÅTGÄRD",null,null,null,"2kf90 före:80"]
[null,null,null,null,null,"Vägkategori","Trafikflöde","Längd","Vägtyp","Skyltad hastighet","ATK",null,"2kf100 före:80"]
[null,null,null,null,null,"Alternativ:","(f/dygn)","(km)","Alternativ:","Alternativ:","Alternativ:",null,"MLV90 före: 100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per mapkm"]
[null,null,null,null,null,"Europaväg Riksväg Länsväg","Ska avse 2025 medeluppräkning","Antas vara samma före och efter","2kf tätort = GIF 2kf landbyggd = 2kf Mötesfri landsväg = MLV Motorväg = MV ","GIF: 50, 70","Ja eller Nej MV ej ATK",null,"MLV110 före: 100",null,null,"Andelar personbilar och lastbilar med och utan släp. Anges i %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULTAT",null,null,null,null,null,null,null,null,null,null,"Efter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tidseffekter (-minskning)",null,null,null,null,null,null,null,"Trafiksäkerhet",null,"CO2 FÖRE",null,null,null,null,null,null,null,null,"CO2 EFTER",null,null,null,null,null,null,null,null,"Klimat"]
[null,null,null,null,null,null,null,null,null,"2kf: 70, 90, 100 MLV:90,110 MV: 110",null,null,"MV110 före: 120",null,"Beräkning",null,null,null,"Hastighet relativt pb",null,"\"Hastighet före ATK\"",null,null,"Konstanter AC ATK formel",null,null,null,"Hastigheter före efter ATK",null,null,null,null,"Pb","Lb","Lbs","Tot","Resulterande medelhastighet före",null,null,null,null,null,null,"Beräkning om alt nr =",null,null,null,null,null,null,null,null,null,"Medelhastighet efter",null,null,null,null,null,null,"timmar/år",null,null,null,"Före",null,"Efter",null,"D/år (-minskning)","SS/år (-minskning)","pb",null,"CO2 g/fkm","lb",null,"CO2 g/fkm","lbs",null,"CO2 g/fkm","pb",null,"CO2 g/fkm","lb",null,"CO2 g/fkm","lbs",null,"CO2 g/fkm","Resultat CO2 kiloton/år (-minskning)"]
["Löpnr","Reg","Län","Vägnr","Objektnamn","Vägkategori","ÅDT","Längd (km)","VägTyp","Skyltad hastighet","ATK","Ombyggnad","Hastighetsgräns","ATK Efter","Alt Nr","Pb","Lb","Lbs","Lb Rel","Lbs Rel","Vpb","Vlb","Vlbs","A pb","A lb","A lbs","Lb korr","Vpb2","Vlb2","Vlb Slut","Vlbs2","Vlbs slut","Pb fkm","Lb fkm","Lbs fkm","Tot fkm","PbMedel","LbMedel","LbsMedel","PbLbLbsMedel","PbMedel1","LbMedel1","LbsMedel1","Alt1","Alt2","Alt3","Alt4","Alt5","Alt7","Alt8","Alt9","Alt10","AltEfter","PbEfter","LbEfter","LbsEfter","PbLbLbsEfter","PbEfter1","LbEfter1","LbsEfter1","Resultat Pb","Resultat Lb","Resultat Lbs","Resultat tot","DkFöre","SskFöre","DkEfter","SskEfter","DkResultat","SskResultat","CO2 före pb","CO2 före pb1","CO2 före pb res","CO2 före lb","CO2 före lb1","CO2 före lb res","CO2 före lbs","CO2 före lbs1","CO2 före lbs res","CO2 efter pb","CO2 efter pb1","CO2 efter pb res","CO2 efter lb","CO2 efter lb1","CO2 efter lb res","CO2 efter lbs","CO2 efter lbs1","CO2 efter lbs res","CO2 pb","CO2 lb","CO2 lbs","CO2 tot","Kolumn1","Kolumn2","Kolumn3","Kolumn4","Kolumn5","Kolumn6","Kolumn7","Kolumn8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($P11>0%,$Q11>0%),100%-SUM($P11:$Q11),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G29>0,\"Nej\",\"\")","v":""},null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(AND($P43>0%,$Q43>0%),100%-SUM($P43:$Q43),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(AND($P75>0%,$Q75>0%),100%-SUM($P75:$Q75),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G90>0,\"Nej\",\"\")","v":""},null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(RHA[Resultat Pb])","v":0},{"$f":"SUM(RHA[Resultat Lb])","v":0},{"$f":"SUM(RHA[Resultat Lbs])","v":0},{"$f":"SUM(RHA[Resultat tot])","v":0},null,null,null,null,{"$f":"SUM(RHA[DkResultat])","v":0},{"$f":"SUM(RHA[SskResultat])","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(RHA[CO2 pb])","v":0},{"$f":"SUM(RHA[CO2 lb])","v":0},{"$f":"SUM(RHA[CO2 lbs])","v":0},{"$f":"SUM(RHA[CO2 tot])","v":0}]

{"sheet":"Beräkna ÅDT","index":2,"n_rows":354,"n_cols":13,"rows_kept":354,"cut":false,"hidden":false,"merged":[[33,12,33,13],[33,9,33,10]]}
["Beräkning av ÅDT"]
["Plats - Sträcka","Beskrivning av vilken stäcka som avses"]
["Vägtyp","Europaväg, Riksväg eller Länsväg"]
["Län - Lastbil","Välj län utefter geografisk plats, tabell J10:L32"]
["Grupp - Personbil","Välj grupp utefter geografisk plats K37:M66, respektive kommuns gruppnummer återfinns i tabellen K68:L358"]
["ÅDT enligt TFK/TIKK","Återfinns på respektive länk i Trafikflödeskartan, använd senaste mätning",null,null,"http://vtf.trafikverket.se/SeTrafikinformation#",null,null,null,null,"Trafikuppräkningstal för EVA och manuella beräkningar 2017-2040"]
["Året för senaste trafikmätning enligt TFK/TIKK","Återfinns på respektive länk i Trafikflödeskartan, använd senaste mätning",null,null,"http://vtf.trafikverket.se/SeTrafikinformation#",null,null,null,null,"Trafikuppräkningstal finns på EVA:s sida på Trafikverket"]
["Trafikuppräkning antal år","Beräknas automatiskt: 2025-Året för senaste trafikmätning",null,null,null,null,null,null,null,"Nedanstående trafikuppräkningstal gäller fr.o.m. 2020-06-15 "]
["ÅDT2025","Kopiera och använd i \"Indata & Resultat\" för respektive stäcka"]
[]
["Plats - Sträcka","Vägtyp","Län - Lastbil","Grupp - Personbil","ÅDT  enl. vägtrafikflödeskartan (TFK)","Senaste året för trafikmätning enl. TFK/TIKK","Trafikuppräkning antal år","ÅDT 2025 (utifrån gällande trafikuppräkningstal)",null,"LASTBIL - Län","Prognos 2017-2040 [kvot] ","Årlig % tillväxt (kvot omräknad från 2040-2017=23 år)"]
[null,null,null,null,null,null,{"$f":"IF(F12>0,2025-F12,\"0\")","v":"0"},{"$f":"E12*IF(B12=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C12,Tabell4[],3,FALSE))^G12)+E12*IF(B12=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D12,Tabell5[],3,FALSE))^G12)","v":{"$error":"#N/A"}},null,"Stockholm",1.5157689514987536,{"$f":"(K12^(1/23))-1","v":1.8248101424846341E-2}]
[null,null,null,null,null,null,"0",{"$f":"E13*IF(B13=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C13,Tabell4[],3,FALSE))^G13)+E13*IF(B13=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D13,Tabell5[],3,FALSE))^G13)","v":{"$error":"#N/A"}},null,"Uppsala",1.5585000320162012,1.9479640656359543E-2]
[null,null,null,null,null,null,"0",{"$f":"E14*IF(B14=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C14,Tabell4[],3,FALSE))^G14)+E14*IF(B14=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D14,Tabell5[],3,FALSE))^G14)","v":{"$error":"#N/A"}},null,"Södermanland",1.4705131981307817,1.6907048754990051E-2]
[null,null,null,null,null,null,"0",{"$f":"E15*IF(B15=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C15,Tabell4[],3,FALSE))^G15)+E15*IF(B15=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D15,Tabell5[],3,FALSE))^G15)","v":{"$error":"#N/A"}},null,"Östergötland",1.4064748140664112,1.4940353054252675E-2]
[null,null,null,null,null,null,"0",{"$f":"E16*IF(B16=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C16,Tabell4[],3,FALSE))^G16)+E16*IF(B16=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D16,Tabell5[],3,FALSE))^G16)","v":{"$error":"#N/A"}},null,"Jönköping",1.4316584927289948,1.5723797167481957E-2]
[null,null,null,null,null,null,"0",{"$f":"E17*IF(B17=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C17,Tabell4[],3,FALSE))^G17)+E17*IF(B17=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D17,Tabell5[],3,FALSE))^G17)","v":{"$error":"#N/A"}},null,"Kronoberg",1.5255929117817653,1.8534148015042939E-2]
[null,null,null,null,null,null,"0",{"$f":"E18*IF(B18=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C18,Tabell4[],3,FALSE))^G18)+E18*IF(B18=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D18,Tabell5[],3,FALSE))^G18)","v":{"$error":"#N/A"}},null,"Kalmar",1.3945469640883057,1.4564593025060413E-2]
[null,null,null,null,null,null,"0",{"$f":"E19*IF(B19=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C19,Tabell4[],3,FALSE))^G19)+E19*IF(B19=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D19,Tabell5[],3,FALSE))^G19)","v":{"$error":"#N/A"}},null,"Gotland",1.1074169067899506,4.4459493580573106E-3]
[null,null,null,null,null,null,"0",{"$f":"E20*IF(B20=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C20,Tabell4[],3,FALSE))^G20)+E20*IF(B20=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D20,Tabell5[],3,FALSE))^G20)","v":{"$error":"#N/A"}},null,"Blekinge",1.5760736559920883,1.9976775244340494E-2]
[null,null,null,null,null,null,"0",{"$f":"E21*IF(B21=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C21,Tabell4[],3,FALSE))^G21)+E21*IF(B21=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D21,Tabell5[],3,FALSE))^G21)","v":{"$error":"#N/A"}},null,"Skåne",1.4823267421763981,1.7260884398118126E-2]
[null,null,null,null,null,null,"0",{"$f":"E22*IF(B22=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C22,Tabell4[],3,FALSE))^G22)+E22*IF(B22=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D22,Tabell5[],3,FALSE))^G22)","v":{"$error":"#N/A"}},null,"Halland",1.5245035244163723,1.8502515058024471E-2]
[null,null,null,null,null,null,"0",{"$f":"E23*IF(B23=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C23,Tabell4[],3,FALSE))^G23)+E23*IF(B23=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D23,Tabell5[],3,FALSE))^G23)","v":{"$error":"#N/A"}},null,"Västra Götaland",1.4793098616119487,1.7170780875748193E-2]
[null,null,null,null,null,null,"0",{"$f":"E24*IF(B24=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C24,Tabell4[],3,FALSE))^G24)+E24*IF(B24=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D24,Tabell5[],3,FALSE))^G24)","v":{"$error":"#N/A"}},null,"Värmland",1.568856480983706,1.9773255706553972E-2]
[null,null,null,null,null,null,"0",{"$f":"E25*IF(B25=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C25,Tabell4[],3,FALSE))^G25)+E25*IF(B25=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D25,Tabell5[],3,FALSE))^G25)","v":{"$error":"#N/A"}},null,"Örebro",1.3613034213278365,1.3500874249216421E-2]
[null,null,null,null,null,null,"0",{"$f":"E26*IF(B26=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C26,Tabell4[],3,FALSE))^G26)+E26*IF(B26=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D26,Tabell5[],3,FALSE))^G26)","v":{"$error":"#N/A"}},null,"Västmanland",1.4952660389238563,1.7645356353435782E-2]
[null,null,null,null,null,null,"0",{"$f":"E27*IF(B27=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C27,Tabell4[],3,FALSE))^G27)+E27*IF(B27=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D27,Tabell5[],3,FALSE))^G27)","v":{"$error":"#N/A"}},null,"Dalarna",1.3195166081615206,1.2127974773303851E-2]
[null,null,null,null,null,null,"0",{"$f":"E28*IF(B28=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C28,Tabell4[],3,FALSE))^G28)+E28*IF(B28=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D28,Tabell5[],3,FALSE))^G28)","v":{"$error":"#N/A"}},null,"Gävleborg",1.4004975277968854,1.4752434764931266E-2]
[null,null,null,null,null,null,"0",{"$f":"E29*IF(B29=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C29,Tabell4[],3,FALSE))^G29)+E29*IF(B29=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D29,Tabell5[],3,FALSE))^G29)","v":{"$error":"#N/A"}},null,"Västernorrland",1.2875951768159173,1.1050887709903812E-2]
[null,null,null,null,null,null,"0",{"$f":"E30*IF(B30=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C30,Tabell4[],3,FALSE))^G30)+E30*IF(B30=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D30,Tabell5[],3,FALSE))^G30)","v":{"$error":"#N/A"}},null,"Jämtland",1.3371681997822351,1.2712917418407521E-2]
[null,null,null,null,null,null,"0",{"$f":"E31*IF(B31=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C31,Tabell4[],3,FALSE))^G31)+E31*IF(B31=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D31,Tabell5[],3,FALSE))^G31)","v":{"$error":"#N/A"}},null,"Västerbotten ",1.2695850969658034,1.0431869157601747E-2]
[null,null,null,null,null,null,"0",{"$f":"E32*IF(B32=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C32,Tabell4[],3,FALSE))^G32)+E32*IF(B32=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D32,Tabell5[],3,FALSE))^G32)","v":{"$error":"#N/A"}},null,"Norrbotten ",1.3208661648328159,1.2172960165719227E-2]
[null,null,null,null,null,null,"0",{"$f":"E33*IF(B33=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C33,Tabell4[],3,FALSE))^G33)+E33*IF(B33=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D33,Tabell5[],3,FALSE))^G33)","v":{"$error":"#N/A"}},null,"Riket",1.4334700658069917,1.5779644383514091E-2]
[null,null,null,null,null,null,"0",{"$f":"E34*IF(B34=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C34,Tabell4[],3,FALSE))^G34)+E34*IF(B34=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D34,Tabell5[],3,FALSE))^G34)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"0",{"$f":"E35*IF(B35=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C35,Tabell4[],3,FALSE))^G35)+E35*IF(B35=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D35,Tabell5[],3,FALSE))^G35)","v":{"$error":"#N/A"}},null,"PERSONBIL - Grupp","Prognos 2017-2040 [kvot] ","Årlig % tillväxt (kvot omräknad från 2040-2017=23 år)","Grupp"]
[null,null,null,null,null,null,"0",{"$f":"E36*IF(B36=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C36,Tabell4[],3,FALSE))^G36)+E36*IF(B36=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D36,Tabell5[],3,FALSE))^G36)","v":{"$error":"#N/A"}},null,"Stockholm",1.4291896822278987,{"$f":"(K36^(1/23))-1","v":1.5647579694433977E-2},10]
[null,null,null,null,null,null,"0",{"$f":"E37*IF(B37=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C37,Tabell4[],3,FALSE))^G37)+E37*IF(B37=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D37,Tabell5[],3,FALSE))^G37)","v":{"$error":"#N/A"}},null,"Uppsala",1.2901140954736185,1.1136803695014574E-2,30]
[null,null,null,null,null,null,"0",{"$f":"E38*IF(B38=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C38,Tabell4[],3,FALSE))^G38)+E38*IF(B38=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D38,Tabell5[],3,FALSE))^G38)","v":{"$error":"#N/A"}},null,"Södermanland",1.3279061949765818,1.2406918210769557E-2,40]
[null,null,null,null,null,null,"0",{"$f":"E39*IF(B39=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C39,Tabell4[],3,FALSE))^G39)+E39*IF(B39=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D39,Tabell5[],3,FALSE))^G39)","v":{"$error":"#N/A"}},null,"Östergötland",1.2536218680361468,9.8761397231426074E-3,50]
[null,null,null,null,null,null,"0",{"$f":"E40*IF(B40=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C40,Tabell4[],3,FALSE))^G40)+E40*IF(B40=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D40,Tabell5[],3,FALSE))^G40)","v":{"$error":"#N/A"}},null,"Jönköping",1.2935443493273628,1.1253546080612242E-2,60]
[null,null,null,null,null,null,"0",{"$f":"E41*IF(B41=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C41,Tabell4[],3,FALSE))^G41)+E41*IF(B41=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D41,Tabell5[],3,FALSE))^G41)","v":{"$error":"#N/A"}},null,"Kronoberg",1.322901150128369,1.224071020592632E-2,70]
[null,null,null,null,null,null,"0",{"$f":"E42*IF(B42=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C42,Tabell4[],3,FALSE))^G42)+E42*IF(B42=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D42,Tabell5[],3,FALSE))^G42)","v":{"$error":"#N/A"}},null,"Kalmar",1.2018166031610877,8.0248210405915454E-3,80]
[null,null,null,null,null,null,"0",{"$f":"E43*IF(B43=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C43,Tabell4[],3,FALSE))^G43)+E43*IF(B43=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D43,Tabell5[],3,FALSE))^G43)","v":{"$error":"#N/A"}},null,"Gotland",1.0517080082520276,2.1943831463173691E-3,90]
[null,null,null,null,null,null,{"$f":"IF(F44>0,2025-F44,\"0\")","v":"0"},{"$f":"E44*IF(B44=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C44,Tabell4[],3,FALSE))^G44)+E44*IF(B44=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D44,Tabell5[],3,FALSE))^G44)","v":{"$error":"#N/A"}},null,"Blekinge",1.2561242534069472,9.9637013138507147E-3,100]
[null,null,null,null,null,null,"0",{"$f":"E45*IF(B45=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C45,Tabell4[],3,FALSE))^G45)+E45*IF(B45=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D45,Tabell5[],3,FALSE))^G45)","v":{"$error":"#N/A"}},null,"Skåne",1.3700910005173852,1.3784452794435964E-2,120]
[null,null,null,null,null,null,"0",{"$f":"E46*IF(B46=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C46,Tabell4[],3,FALSE))^G46)+E46*IF(B46=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D46,Tabell5[],3,FALSE))^G46)","v":{"$error":"#N/A"}},null,"Stor-Göteborg",1.2788928670558681,1.0752824683022411E-2,141]
[null,null,null,null,null,null,"0",{"$f":"E47*IF(B47=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C47,Tabell4[],3,FALSE))^G47)+E47*IF(B47=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D47,Tabell5[],3,FALSE))^G47)","v":{"$error":"#N/A"}},null,"Södra VVÄ",1.2974108092083365,1.1384779465098971E-2,142]
[null,null,null,null,null,null,"0",{"$f":"E48*IF(B48=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C48,Tabell4[],3,FALSE))^G48)+E48*IF(B48=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D48,Tabell5[],3,FALSE))^G48)","v":{"$error":"#N/A"}},null,"Östra VVÄ",1.2194928922839592,8.6649386123514027E-3,143]
[null,null,null,null,null,null,"0",{"$f":"E49*IF(B49=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C49,Tabell4[],3,FALSE))^G49)+E49*IF(B49=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D49,Tabell5[],3,FALSE))^G49)","v":{"$error":"#N/A"}},null,"Västra och Norra VVÄ",1.1964164500382912,7.8274668771831646E-3,144]
[null,null,null,null,null,null,"0",{"$f":"E50*IF(B50=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C50,Tabell4[],3,FALSE))^G50)+E50*IF(B50=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D50,Tabell5[],3,FALSE))^G50)","v":{"$error":"#N/A"}},null,"Längs E18 VVÄ",1.1563230183134086,6.33498860088344E-3,145]
[null,null,null,null,null,null,"0",{"$f":"E51*IF(B51=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C51,Tabell4[],3,FALSE))^G51)+E51*IF(B51=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D51,Tabell5[],3,FALSE))^G51)","v":{"$error":"#N/A"}},null,"Örebro",1.2464902175809738,9.6256740826718978E-3,180]
[null,null,null,null,null,null,"0",{"$f":"E52*IF(B52=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C52,Tabell4[],3,FALSE))^G52)+E52*IF(B52=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D52,Tabell5[],3,FALSE))^G52)","v":{"$error":"#N/A"}},null,"Västmanland",1.2822084567247944,1.0866615136549296E-2,190]
[null,null,null,null,null,null,"0",{"$f":"E53*IF(B53=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C53,Tabell4[],3,FALSE))^G53)+E53*IF(B53=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D53,Tabell5[],3,FALSE))^G53)","v":{"$error":"#N/A"}},null,"Dalarna",1.1638609644413422,6.6193287671667544E-3,200]
[null,null,null,null,null,null,"0",{"$f":"E54*IF(B54=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C54,Tabell4[],3,FALSE))^G54)+E54*IF(B54=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D54,Tabell5[],3,FALSE))^G54)","v":{"$error":"#N/A"}},null,"Gävleborg",1.1459290292013617,5.9399933931856275E-3,210]
[null,null,null,null,null,null,"0",{"$f":"E55*IF(B55=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C55,Tabell4[],3,FALSE))^G55)+E55*IF(B55=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D55,Tabell5[],3,FALSE))^G55)","v":{"$error":"#N/A"}},null,"Västernorrlands läns kustkommuner exkl. Kramfors",1.1388984779737099,5.6708687527944335E-3,221]
[null,null,null,null,null,null,"0",{"$f":"E56*IF(B56=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C56,Tabell4[],3,FALSE))^G56)+E56*IF(B56=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D56,Tabell5[],3,FALSE))^G56)","v":{"$error":"#N/A"}},null,"Västernorrlands läns kustkommuner inkl. Kramfors",0.99518020012024444,-2.1004109361522083E-4,222]
[null,null,null,null,null,null,"0",{"$f":"E57*IF(B57=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C57,Tabell4[],3,FALSE))^G57)+E57*IF(B57=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D57,Tabell5[],3,FALSE))^G57)","v":{"$error":"#N/A"}},null,"Jämtland",1.1419186437114544,5.7866727630240256E-3,230]
[null,null,null,null,null,null,"0",{"$f":"E58*IF(B58=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C58,Tabell4[],3,FALSE))^G58)+E58*IF(B58=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D58,Tabell5[],3,FALSE))^G58)","v":{"$error":"#N/A"}},null,"Västerbottens kust och inland",1.126251482493807,5.1827252375709065E-3,241]
[null,null,null,null,null,null,"0",{"$f":"E59*IF(B59=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C59,Tabell4[],3,FALSE))^G59)+E59*IF(B59=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D59,Tabell5[],3,FALSE))^G59)","v":{"$error":"#N/A"}},null,"Västerbottens fjäll och inland",0.85592930366981723,-6.7409811113365858E-3,242]
[null,null,null,null,null,null,"0",{"$f":"E60*IF(B60=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C60,Tabell4[],3,FALSE))^G60)+E60*IF(B60=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D60,Tabell5[],3,FALSE))^G60)","v":{"$error":"#N/A"}},null,"Norrbottens kust och inland",1.0894075613042171,3.7301583422368889E-3,251]
[null,null,null,null,null,null,"0",{"$f":"E61*IF(B61=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C61,Tabell4[],3,FALSE))^G61)+E61*IF(B61=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D61,Tabell5[],3,FALSE))^G61)","v":{"$error":"#N/A"}},null,"Norrbottens fjäll och inland",0.94218736811840142,-2.5858300798593525E-3,252]
[null,null,null,null,null,null,"0",{"$f":"E62*IF(B62=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C62,Tabell4[],3,FALSE))^G62)+E62*IF(B62=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D62,Tabell5[],3,FALSE))^G62)","v":{"$error":"#N/A"}},null,"Riket",1.2788750034267395,1.0752210842496224E-2]
[null,null,null,null,null,null,"0",{"$f":"E63*IF(B63=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C63,Tabell4[],3,FALSE))^G63)+E63*IF(B63=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D63,Tabell5[],3,FALSE))^G63)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"0",{"$f":"E64*IF(B64=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C64,Tabell4[],3,FALSE))^G64)+E64*IF(B64=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D64,Tabell5[],3,FALSE))^G64)","v":{"$error":"#N/A"}},null,"Kommun-nr","Kommun-namn","Grupp-nr","Grupp-namn"]
[null,null,null,null,null,null,"0",{"$f":"E65*IF(B65=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C65,Tabell4[],3,FALSE))^G65)+E65*IF(B65=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D65,Tabell5[],3,FALSE))^G65)","v":{"$error":"#N/A"}},null,114,"UPPLANDS VÄSBY",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E66*IF(B66=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C66,Tabell4[],3,FALSE))^G66)+E66*IF(B66=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D66,Tabell5[],3,FALSE))^G66)","v":{"$error":"#N/A"}},null,115,"VALLENTUNA",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E67*IF(B67=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C67,Tabell4[],3,FALSE))^G67)+E67*IF(B67=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D67,Tabell5[],3,FALSE))^G67)","v":{"$error":"#N/A"}},null,117,"ÖSTERÅKER",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E68*IF(B68=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C68,Tabell4[],3,FALSE))^G68)+E68*IF(B68=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D68,Tabell5[],3,FALSE))^G68)","v":{"$error":"#N/A"}},null,120,"VÄRMDÖ",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E69*IF(B69=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C69,Tabell4[],3,FALSE))^G69)+E69*IF(B69=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D69,Tabell5[],3,FALSE))^G69)","v":{"$error":"#N/A"}},null,123,"JÄRFÄLLA",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E70*IF(B70=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C70,Tabell4[],3,FALSE))^G70)+E70*IF(B70=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D70,Tabell5[],3,FALSE))^G70)","v":{"$error":"#N/A"}},null,125,"EKERÖ",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E71*IF(B71=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C71,Tabell4[],3,FALSE))^G71)+E71*IF(B71=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D71,Tabell5[],3,FALSE))^G71)","v":{"$error":"#N/A"}},null,126,"HUDDINGE",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E72*IF(B72=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C72,Tabell4[],3,FALSE))^G72)+E72*IF(B72=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D72,Tabell5[],3,FALSE))^G72)","v":{"$error":"#N/A"}},null,127,"BOTKYRKA",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E73*IF(B73=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C73,Tabell4[],3,FALSE))^G73)+E73*IF(B73=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D73,Tabell5[],3,FALSE))^G73)","v":{"$error":"#N/A"}},null,128,"SALEM",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E74*IF(B74=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C74,Tabell4[],3,FALSE))^G74)+E74*IF(B74=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D74,Tabell5[],3,FALSE))^G74)","v":{"$error":"#N/A"}},null,136,"HANINGE",10,"Stockholm"]
[null,null,null,null,null,null,"0",{"$f":"E75*IF(B75=\"Europaväg\",0.14,0.08)*((1+VLOOKUP(C75,Tabell4[],3,FALSE))^G75)+E75*IF(B75=\"Europaväg\",0.86,0.92)*((1+VLOOKUP(D75,Tabell5[],3,FALSE))^G75)","v":{"$error":"#N/A"}},null,138,"TYRESÖ",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,139,"UPPLANDS-BRO",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,140,"NYKVARN",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,160,"TÄBY",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,162,"DANDERYD",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,163,"SOLLENTUNA",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,180,"STOCKHOLM",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,181,"SÖDERTÄLJE",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,182,"NACKA",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,183,"SUNDBYBERG",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,184,"SOLNA",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,186,"LIDINGÖ",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,187,"VAXHOLM",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,188,"NORRTÄLJE",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,191,"SIGTUNA",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,192,"NYNÄSHAMN",10,"Stockholm"]
[null,null,null,null,null,null,null,null,null,305,"HÅBO",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,319,"ÄLVKARLEBY",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,330,"KNIVSTA",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,360,"TIERP",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,380,"UPPSALA",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,381,"ENKÖPING",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,382,"ÖSTHAMMAR",30,"Uppsala"]
[null,null,null,null,null,null,null,null,null,428,"VINGÅKER",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,461,"GNESTA",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,480,"NYKÖPING",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,481,"OXELÖSUND",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,482,"FLEN",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,483,"KATRINEHOLM",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,484,"ESKILSTUNA",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,486,"STRÄNGNÄS",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,488,"TROSA",40,"Södermanland"]
[null,null,null,null,null,null,null,null,null,509,"ÖDESHÖG",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,512,"YDRE",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,513,"KINDA",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,560,"BOXHOLM",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,561,"ÅTVIDABERG",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,562,"FINSPÅNG",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,563,"VALDEMARSVIK",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,580,"LINKÖPING",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,581,"NORRKÖPING",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,582,"SÖDERKÖPING",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,583,"MOTALA",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,584,"VADSTENA",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,586,"MJÖLBY",50,"Östergötland"]
[null,null,null,null,null,null,null,null,null,604,"ANEBY",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,617,"GNOSJÖ",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,642,"MULLSJÖ",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,643,"HABO",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,662,"GISLAVED",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,665,"VAGGERYD",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,680,"JÖNKÖPING",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,682,"NÄSSJÖ",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,683,"VÄRNAMO",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,684,"SÄVSJÖ",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,685,"VETLANDA",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,686,"EKSJÖ",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,687,"TRANÅS",60,"Jönköping"]
[null,null,null,null,null,null,null,null,null,760,"UPPVIDINGE",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,761,"LESSEBO",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,763,"TINGSRYD",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,764,"ALVESTA",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,765,"ÄLMHULT",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,767,"MARKARYD",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,780,"VÄXJÖ",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,781,"LJUNGBY",70,"Kronoberg"]
[null,null,null,null,null,null,null,null,null,821,"HÖGSBY",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,834,"TORSÅS",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,840,"MÖRBYLÅNGA",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,860,"HULTSFRED",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,861,"MÖNSTERÅS",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,862,"EMMABODA",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,880,"KALMAR",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,881,"NYBRO",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,882,"OSKARSHAMN",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,883,"VÄSTERVIK",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,884,"VIMMERBY",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,885,"BORGHOLM",80,"Kalmar"]
[null,null,null,null,null,null,null,null,null,980,"GOTLAND",90,"Gotland"]
[null,null,null,null,null,null,null,null,null,1060,"OLOFSTRÖM",100,"Blekinge"]
[null,null,null,null,null,null,null,null,null,1080,"KARLSKRONA",100,"Blekinge"]
[null,null,null,null,null,null,null,null,null,1081,"RONNEBY",100,"Blekinge"]
[null,null,null,null,null,null,null,null,null,1082,"KARLSHAMN",100,"Blekinge"]
[null,null,null,null,null,null,null,null,null,1083,"SÖLVESBORG",100,"Blekinge"]
[null,null,null,null,null,null,null,null,null,1214,"SVALÖV",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1230,"STAFFANSTORP",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1231,"BURLÖV",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1233,"VELLINGE",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1256,"ÖSTRA GÖINGE",124,"Skåne Nordöst"]
[null,null,null,null,null,null,null,null,null,1257,"ÖRKELLJUNGA",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1260,"BJUV",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1261,"KÄVLINGE",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1262,"LOMMA",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1263,"SVEDALA",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1264,"SKURUP",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1265,"SJÖBO",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1266,"HÖRBY",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1267,"HÖÖR",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1270,"TOMELILLA",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1272,"BROMÖLLA",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1273,"OSBY",124,"Skåne Nordöst"]
[null,null,null,null,null,null,null,null,null,1275,"PERSTORP",124,"Skåne Nordöst"]
[null,null,null,null,null,null,null,null,null,1276,"KLIPPAN",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1277,"ÅSTORP",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1278,"BÅSTAD",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1280,"MALMÖ",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1281,"LUND",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1282,"LANDSKRONA",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1283,"HELSINGBORG",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1284,"HÖGANÄS",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1285,"ESLÖV",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1286,"YSTAD",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1287,"TRELLEBORG",121,"Skåne Sydväst"]
[null,null,null,null,null,null,null,null,null,1290,"KRISTIANSTAD",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1291,"SIMRISHAMN",123,"Skåne Öst"]
[null,null,null,null,null,null,null,null,null,1292,"ÄNGELHOLM",122,"Skåne Nordväst"]
[null,null,null,null,null,null,null,null,null,1293,"HÄSSLEHOLM",124,"Skåne Nordöst"]
[null,null,null,null,null,null,null,null,null,1315,"HYLTE",142,"Södra VVÄ"]
[null,null,null,null,null,null,null,null,null,1380,"HALMSTAD",142,"Södra VVÄ"]
[null,null,null,null,null,null,null,null,null,1381,"LAHOLM",142,"Södra VVÄ"]
[null,null,null,null,null,null,null,null,null,1382,"FALKENBERG",142,"Södra VVÄ"]
[null,null,null,null,null,null,null,null,null,1383,"VARBERG",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1384,"KUNGSBACKA",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1401,"HÄRRYDA",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1402,"PARTILLE",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1407,"ÖCKERÖ",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1415,"STENUNGSUND",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1419,"TJÖRN",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1421,"ORUST",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1427,"SOTENÄS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1430,"MUNKEDAL",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1435,"TANUM",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1438,"DALS-ED",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1439,"FÄRGELANDA",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1440,"ALE",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1441,"LERUM",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1442,"VÅRGÅRDA",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1443,"BOLLEBYGD",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1444,"GRÄSTORP",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1445,"ESSUNGA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1446,"KARLSBORG",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1447,"GULLSPÅNG",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1452,"TRANEMO",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1460,"BENGTSFORS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1461,"MELLERUD",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1462,"LILLA EDET",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1463,"MARK",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1465,"SVENLJUNGA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1466,"HERRLJUNGA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1470,"VARA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1471,"GÖTENE",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1472,"TIBRO",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1473,"TÖREBODA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1480,"GÖTEBORG",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1481,"MÖLNDAL",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1482,"KUNGÄLV",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1484,"LYSEKIL",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1485,"UDDEVALLA",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1486,"STRÖMSTAD",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1487,"VÄNERSBORG",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1488,"TROLLHÄTTAN",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1489,"ALINGSÅS",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1490,"BORÅS",141,"Stor-Göteborg"]
[null,null,null,null,null,null,null,null,null,1491,"ULRICEHAMN",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1492,"ÅMÅL",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1493,"MARIESTAD",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1494,"LIDKÖPING",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1495,"SKARA",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1496,"SKÖVDE",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1497,"HJO",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1498,"TIDAHOLM",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1499,"FALKÖPING",143,"Östra VVÄ"]
[null,null,null,null,null,null,null,null,null,1715,"KIL",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1730,"EDA",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1737,"TORSBY",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1760,"STORFORS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1761,"HAMMARÖ",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1762,"MUNKFORS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1763,"FORSHAGA",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1764,"GRUMS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1765,"ÅRJÄNG",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1766,"SUNNE",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1780,"KARLSTAD",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1781,"KRISTINEHAMN",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1782,"FILIPSTAD",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1783,"HAGFORS",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1784,"ARVIKA",145,"VVÄ Längs E18"]
[null,null,null,null,null,null,null,null,null,1785,"SÄFFLE",144,"Västra och Norra VVÄ"]
[null,null,null,null,null,null,null,null,null,1814,"LEKEBERG",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1860,"LAXÅ",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1861,"HALLSBERG",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1862,"DEGERFORS",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1863,"HÄLLEFORS",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1864,"LJUSNARSBERG",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1880,"ÖREBRO",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1881,"KUMLA",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1882,"ASKERSUND",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1883,"KARLSKOGA",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1884,"NORA",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1885,"LINDESBERG",180,"Örebro"]
[null,null,null,null,null,null,null,null,null,1904,"SKINNSKATTEBERG",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1907,"SURAHAMMAR",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1917,"HEBY",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1960,"KUNGSÖR",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1961,"HALLSTAHAMMAR",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1962,"NORBERG",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1980,"VÄSTERÅS",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1981,"SALA",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1982,"FAGERSTA",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1983,"KÖPING",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,1984,"ARBOGA",190,"Västmanland"]
[null,null,null,null,null,null,null,null,null,2021,"VANSBRO",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2023,"MALUNG",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2026,"GAGNEF",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2029,"LEKSAND",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2031,"RÄTTVIK",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2034,"ORSA",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2039,"ÄLVDALEN",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2061,"SMEDJEBACKEN",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2062,"MORA",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2080,"FALUN",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2081,"BORLÄNGE",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2082,"SÄTER",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2083,"HEDEMORA",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2084,"AVESTA",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2085,"LUDVIKA",200,"Dalarna"]
[null,null,null,null,null,null,null,null,null,2101,"OCKELBO",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2104,"HOFORS",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2121,"OVANÅKER",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2132,"NORDANSTIG",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2161,"LJUSDAL",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2180,"GÄVLE",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2181,"SANDVIKEN",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2182,"SÖDERHAMN",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2183,"BOLLNÄS",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2184,"HUDIKSVALL",210,"Gävleborg"]
[null,null,null,null,null,null,null,null,null,2260,"ÅNGE",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2262,"TIMRÅ",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2280,"HÄRNÖSAND",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2281,"SUNDSVALL",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2282,"KRAMFORS",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2283,"SOLLEFTEÅ",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2284,"ÖRNSKÖLDSVIK",220,"Västernorrland"]
[null,null,null,null,null,null,null,null,null,2303,"RAGUNDA",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2305,"BRÄCKE",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2309,"KROKOM",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2313,"STRÖMSUND",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2321,"ÅRE",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2326,"BERG",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2361,"HÄRJEDALEN",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2380,"ÖSTERSUND",230,"Jämtland"]
[null,null,null,null,null,null,null,null,null,2401,"NORDMALING",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2403,"BJURHOLM",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2404,"VINDELN",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2409,"ROBERTSFORS",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2417,"NORSJÖ",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2418,"MALÅ",242,"Västerbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2421,"STORUMAN",242,"Västerbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2422,"SORSELE",242,"Västerbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2425,"DOROTEA",242,"Västerbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2460,"VÄNNÄS",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2462,"VILHELMINA",242,"Västerbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2463,"ÅSELE",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2480,"UMEÅ",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2481,"LYCKSELE",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2482,"SKELLEFTEÅ",241,"Västerbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2505,"ARVIDSJAUR",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2506,"ARJEPLOG",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2510,"JOKKMOKK",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2513,"ÖVERKALIX",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2514,"KALIX",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2518,"ÖVERTORNEÅ",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2521,"PAJALA",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2523,"GÄLLIVARE",252,"Norrbottens fjäll och inland"]
[null,null,null,null,null,null,null,null,null,2560,"ÄLVSBYN",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2580,"LULEÅ",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2581,"PITEÅ",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2582,"BODEN",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2583,"HAPARANDA",251,"Norrbottens kust och inland"]
[null,null,null,null,null,null,null,null,null,2584,"KIRUNA",252,"Norrbottens fjäll och inland"]

{"sheet":"Hastighet","index":3,"n_rows":107,"n_cols":27,"rows_kept":107,"cut":false,"hidden":false,"merged":[[21,4,21,6],[63,9,63,11],[50,3,50,5],[50,9,50,11],[61,3,61,5],[30,3,30,5],[30,9,30,11],[40,3,40,5],[40,9,40,11]]}
[null,null,null,"Hastigheter före",null,null,null,null,null,null,"Konstant i AC ATK-formel",null,null,null,null,null,null,null,null,null,"Hastighet efter "]
[null,null,null,"-med ATK beror på vägkategori",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medelhastighet km/tim",null,null,"Stopp/km"]
["Vägtyp","Skyltad hastighet","ATK före","alt nr","Vpb","Vlb","Vlbs","lb rel","lbs rel",null,null,"A",null,null,null,null,null,null,"Vägtyp","Skyltad hastighet före","Skyltad hastighet efter",null,"Vpb","Vlbu","Vlbs"]
["GIF",50,"Nej",1,{"$f":"E28","v":49.26315789473685},{"$f":"F28","v":49.26315789473685},{"$f":"G28","v":49.26315789473685},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":1},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":1},null,null,"pb","lb","lbs",null,null,null,null,"GIF",50,40,1,{"$f":"E4+S28","v":47.433157894736851},{"$f":"F4+T28","v":47.433157894736851},{"$f":"G4+U28","v":47.433157894736851},0.1]
[null,50,"Ja",2,{"$f":"E4*L6+(1-L6)*($B$4-10)","v":46.051926736842105},{"$f":"F4*M6+(1-M6)*($B$4-10)","v":46.051926736842105},{"$f":"G4*N6+(1-N6)*($B$4-10)","v":46.051926736842105},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":1},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":1},null,40,{"$f":"+L6","v":0.65333300000000005},{"$f":"+M6","v":0.65333300000000005},{"$f":"+N6","v":0.65333300000000005},null,null,null,null,null,50,"40ATK",2,{"$f":"D75","v":41.389657346842114},{"$f":"E75","v":41.389657346842114},{"$f":"F75","v":41.389657346842114},0.1]
[null,70,"Nej",3,{"$f":"E25","v":68.94202898550725},{"$f":"F25","v":68.467153284671539},{"$f":"G25","v":67.985294117647058},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.99311195640999284},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.98612261806130896},null,50,0.65333300000000005,0.65333300000000005,0.65333300000000005,null,null,null,null,null,"50ATK","40ATK",3,{"$f":"D72","v":39.606170698890004},{"$f":"E72","v":39.606170698890004},{"$f":"F72","v":39.606170698890004},0.05]
[null,70,"Ja",4,{"$f":"E6*L8+(1-L8)*($B$6-10)","v":65.973275362318844},{"$f":"F6*M8+(1-M8)*($B$6-10)","v":66.003211678832116},65.661573529411754,{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":1.0004537642909022},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.99527533184921846},null,60,0.626,0.63400000000000001,0.63400000000000001,null,null,null,null,null,70,60,4,{"$f":"E6+S29","v":66.377028985507252},{"$f":"F6+T29","v":66.602153284671544},{"$f":"G6+U29","v":66.570294117647052},0.05]
["2kf",70,"Nej",5,{"$f":"M29","v":74.249158249158242},{"$f":"N29","v":73.249146757679185},{"$f":"O29","v":71.986111111111114},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.98653167907812078},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.96952090513332134},null,70,0.66800000000000004,0.70899999999999996,0.70899999999999996,null,null,null,null,null,70,"60ATK",5,{"$f":"D82","v":60.252020144927542},{"$f":"E82","v":60.525765182481763},60.505566470588235,0.05]
[null,70,"Ja",6,{"$f":"E8*L8+(1-L8)*($B$8-10)","v":69.518437710437709},{"$f":"F8*M8+(1-M8)*($B$8-10)","v":69.39364505119454},{"$f":"G8*N8+(1-N8)*($B$8-10)","v":68.498152777777776},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.99820489839310023},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.98532353478785462},null,80,0.67700000000000005,0.72199999999999998,0.76100000000000001,null,null,null,null,null,"70ATK","60ATK",6,{"$f":"AVERAGE(D78:D79)","v":58.870857095526148},{"$f":"AVERAGE(E78:E79)","v":59.473136727589278},{"$f":"AVERAGE(F78:F79)","v":59.538252299989637},0.05]
[null,80,"Nej",null,{"$f":"M27","v":83.249249249249246},{"$f":"N27","v":81.249230769230778},{"$f":"O27","v":78.987341772151893},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.97597553734051834},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.94880545451722753},null,90,0.641957,0.873,0.89600000000000002,null,null,null,null,"2kf",70,60,7,{"$f":"E8+S29","v":71.684158249158244},{"$f":"F8+T29","v":71.38414675767919},{"$f":"G8+U29","v":70.571111111111108},0.02]
[null,80,"Ja",null,{"$f":"E10*L9+(1-L9)*($B$10-10)","v":78.969741741741743},{"$f":"F10*M9+(1-M9)*($B$10-10)","v":78.121944615384621},{"$f":"G10*N9+(1-N9)*($B$10-10)","v":76.839367088607588},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.98926427885341561},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.97302289957967425},null,100,0.75,0.89900000000000002,0.90500000000000003,null,null,null,null,null,70,"60ATK",8,{"$f":"D104","v":63.574283063973056},{"$f":"E104","v":63.557549044368614},{"$f":"F104","v":63.042084444444441},0.02]
[null,90,"Nej",7,{"$f":"M25","v":89.249299719887944},{"$f":"N25","v":84.749262536873161},{"$f":"O25","v":79.987500000000011},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.94957901969944514},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.89622551942753148},null,110,{"$f":"+L11","v":0.75},{"$f":"+M11","v":0.89900000000000002},{"$f":"+N11","v":0.90500000000000003},null,null,null,null,null,"70ATK","60ATK",9,{"$f":"D107","v":58.933146268259378},{"$f":"E107","v":59.757087272866912},60.042387272866904,0.02]
[null,90,"Ja",8,{"$f":"E12*L10+(1-L10)*($B$12-10)","v":85.937652700280097},{"$f":"F12*M10+(1-M10)*($B$12-10)","v":84.146106194690262},{"$f":"G12*N10+(1-N10)*($B$12-10)","v":79.988800000000012},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.97915295043212192},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.93077710976086858},null,null,null,null,null,null,null,null,null,null,90,80,10,{"$f":"E12+S30","v":85.949299719887946},{"$f":"F12+T30","v":82.849262536873155},{"$f":"G12+U30","v":78.987500000000011},0.02]
[null,100,"Nej",9,{"$f":"M23","v":95.497382198952877},{"$f":"N23","v":89.497206703910607},{"$f":"O23","v":80.987654320987644},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.93716921493678329},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.84806151180420175},null,"Vatk = A*V+(1-A)*(HG-10) om V>=HG-10, för lb 72 om HG>=90",null,null,null,null,null,null,null,null,90,"80ATK",11,{"$f":"D91","v":80.797675910364134},{"$f":"E91","v":79.277167551622426},{"$f":"F91","v":76.839487500000004},0.02]
[null,100,"Ja",10,{"$f":"E14*L11+(1-L11)*($B$14-10)","v":94.123036649214654},{"$f":"F14*M11+(1-M11)*($B$14-10)","v":89.54798882681564},{"$f":"G14*N11+(1-N11)*($B$14-10)","v":81.843827160493817},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.95139290034330626},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.86954086984588064},null,"Vatk = V                                     om V<HG-10, för lb 72 om HG>=90",null,null,null,null,null,null,null,null,"90ATK","80ATK",12,{"$f":"AVERAGE(D87:D88)","v":79.257539340026398},{"$f":"AVERAGE(E87:E88)","v":79.808254188693766},{"$f":"AVERAGE(F87:F88)","v":77.827344005997503},0.02]
["MLV",90,"Nej",11,{"$f":"R46","v":87.627852697095435},{"$f":"S46","v":82.594620623237248},78.413767622469834,{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.94256127567958736},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.894849813261132},null,null,null,null,null,null,null,null,null,null,100,80,13,{"$f":"E14+S31","v":90.247382198952877},{"$f":"F14+T31","v":85.747206703910607},{"$f":"G14+U31","v":79.737654320987644},0.02]
[null,90,"Ja",12,{"$f":"E16*L10+(1-L10)*($B$16-10)","v":84.896753433869293},{"$f":"F16*M10+(1-M10)*($B$16-10)","v":82.26510380408611},{"$f":"G16*N10+(1-N10)*($B$16-10)","v":78.57873578973296},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.96900176363242063},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.92557998523397267},null,null,null,null,null,null,null,null,null,null,"100ATK","80ATK",14,{"$f":"W16*L9+(1-L9)*($K$9-10)","v":83.707477748691105},{"$f":"X16*M9+(1-M9)*($K$9-10)","v":81.36948324022346},{"$f":"Y16*N9+(1-N9)*($K$9-10)","v":77.410354938271595},0.02]
[null,100,"Nej",null,{"$f":"R56","v":95.116465973713062},{"$f":"S56","v":87.805251782733038},{"$f":"T56","v":81.897599555987242},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.92313408497535443},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.86102441588421652},null,null,null,null,null,null,null,null,null,"MLV",90,100,15,{"$f":"E16+S34","v":90.02785269709544},{"$f":"F16+T34","v":84.494620623237253},{"$f":"G16+U34","v":78.413767622469834},0.02]
[null,110,"Nej",13,{"$f":"D64","v":104.5},{"$f":"E64","v":92},{"$f":"F64","v":83.5},{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.88038277511961727},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.79904306220095689},null,null,null,null,null,null,null,null,null,null,"90ATK","100ATK",16,{"$f":"W18*L11+(1-L11)*($K$11-10)","v":90.020889522821577},{"$f":"X18*M11+(1-M11)*($K$11-10)","v":85.050663940290292},{"$f":"Y18*N11+(1-N11)*($K$11-10)","v":79.514459698335202},0.02]
["MV",110,"Nej",14,{"$f":"J67","v":109},{"$f":"K67","v":93},84.5,{"$f":"Tabell1[[#This Row],[Vlb]]/Tabell1[[#This Row],[Vpb]]","v":0.85321100917431192},{"$f":"Tabell1[[#This Row],[Vlbs]]/Tabell1[[#This Row],[Vpb]]","v":0.77522935779816515},"2kf land",null,null,"2 kf land schablon",null,null,null,null,null,null,110,100,17,{"$f":"E19+S32","v":102.2},92,83,0.02]
[null,null,null,null,null,null,null,null,"BP1 150 Normal","Pb","Lb","Lbs","Pb","Lb","Lbs",null,null,null,"MV",110,120,18,112.7,96.2,84.5,0.02]
[null,"2kf GIF",null,null,"2kf GIF schablon",null,null,null,"2 N 100 SK1",96,90,82,{"$f":"+M23/$M$23","v":1},{"$f":"+N23/$M$23","v":0.93716921493678329},{"$f":"+O23/$M$23","v":0.84806151180420175}]
[null,"Pb","Lb","Lbs","Pb","Lb","Lbs",null,"2N 100 SK2",95,89,80,{"$f":"1/(0.5/J22+0.5/J23)","v":95.497382198952877},{"$f":"1/(0.5/K22+0.5/K23)","v":89.497206703910607},{"$f":"1/(0.5/L22+0.5/L23)","v":80.987654320987644}]
[null,71,70,69,{"$f":"+E25/$E$25","v":1},{"$f":"+F25/$E$25","v":0.99311195640999284},{"$f":"+G25/$E$25","v":0.98612261806130896},null,"2N 90 SK1",89.5,85,81,{"$f":"+M25/$M$25","v":1},{"$f":"+N25/$M$25","v":0.94957901969944514},{"$f":"+O25/$M$25","v":0.89622551942753148}]
[null,67,67,67,{"$f":"1/(0.5/B24+0.5/B25)","v":68.94202898550725},{"$f":"1/(0.5/C24+0.5/C25)","v":68.467153284671539},{"$f":"1/(0.5/D24+0.5/D25)","v":67.985294117647058},null,"2N 90 SK2",89,84.5,79,{"$f":"1/(0.5/J24+0.5/J25)","v":89.249299719887944},{"$f":"1/(0.5/K24+0.5/K25)","v":84.749262536873161},{"$f":"1/(0.5/L24+0.5/L25)","v":79.987500000000011}]
[null,52,52,52,null,null,null,null,"2N 80 SK1",83.5,81.5,80,{"$f":"+M27/$M$27","v":1},{"$f":"+N27/$M$27","v":0.97597553734051834},{"$f":"+O27/$M$27","v":0.94880545451722753},null,null,null,null,null,null,null,null,null,null,null,"Referens: "]
[null,48,48,48,{"$f":"+E28/E28","v":1},{"$f":"+F28/F28","v":1},{"$f":"+G28/G28","v":1},null,"2N 80 SK2",83,81,78,{"$f":"1/(0.5/J26+0.5/J27)","v":83.249249249249246},{"$f":"1/(0.5/K26+0.5/K27)","v":81.249230769230778},{"$f":"1/(0.5/L26+0.5/L27)","v":78.987341772151893},null,null,null,"pb","lb","lbs",null,null,null,null,null,"VTI rapport 938 - Hastighetsflödessamband för svenska vägtyper"]
[null,48,48,48,{"$f":"1/(1/3/B27+1/3/B28+1/3/B26)","v":49.26315789473685},{"$f":"1/(1/3/C27+1/3/C28+1/3/C26)","v":49.26315789473685},{"$f":"1/(1/3/D27+1/3/D28+1/3/D26)","v":49.26315789473685},null,"2N 70 SK1",{"$f":"D34","v":74.5},{"$f":"E34","v":73.5},{"$f":"F34","v":73},{"$f":"+M29/$M$29","v":1},{"$f":"+N29/$M$29","v":0.98653167907812078},{"$f":"+O29/$M$29","v":0.96952090513332134},null,1,"50-40",-1.83,-1.83,-1.83,null,null,null,null,null,"Effektsamband för transportsystem"]
[null,null,null,null,null,null,null,null,"2N 70 SK2",{"$f":"J34","v":74},{"$f":"K34","v":73},{"$f":"L34","v":71},{"$f":"1/(0.5/J28+0.5/J29)","v":74.249158249158242},{"$f":"1/(0.5/K28+0.5/K29)","v":73.249146757679185},{"$f":"1/(0.5/L28+0.5/L29)","v":71.986111111111114},null,2,"70-60",{"$f":"(0.5*S28)+(0.5*S30)","v":-2.5649999999999999},{"$f":"(0.5*T28)+(0.5*T30)","v":-1.865},{"$f":"(0.5*U28)+(0.5*U30)","v":-1.415}]
[null,"70km/h, tvåfältsväg, 8-10m, siktklass 1",null,null,null,null,null,"70km/h, tvåfältsväg, 8-10m, siktklass 2",null,null,null,null,null,null,null,null,3,"90-80",-3.3,-1.9,-1]
[null,null,"Flöde","Reshastighet km/h",null,null,null,null,"Flöde","Reshastighet km/h",null,null,null,null,null,null,4,"100-80",{"$f":"(0.5*-5.4)+(0.5*-5.1)","v":-5.25},{"$f":"(0.5*-3.4)+(0.5*-4.1)","v":-3.75},{"$f":"(0.5*-2.6)+(0.5*0.1)","v":-1.25}]
[null,"Normal","f/h","Pb","Lb","Lbs",null,"Normal","f/h","Pb","Lb","Lbs",null,null,null,null,5,"110-100",-2.2999999999999998,0,-0.5]
[null,"Brytpunkt 0",0,74.5,73.5,73,null,"Brytpunkt 0",0,74,73,71,null,null,null,null,6,"110-120",3.7,3.2,0]
[null,"Brytpunkt 1",150,74.5,73.5,73,null,"Brytpunkt 1",150,74,73,71,null,null,null,null,7,"90-100",2.4,1.9,0]
[null,"Brytpunkt 2",600,70.400000000000006,70,69.7,null,"Brytpunkt 2",550,69.099999999999994,68.7,67.400000000000006]
[null,"Brytpunkt 3",1200,66.5,66.3,66.2,null,"Brytpunkt 3",1100,64.2,64.099999999999994,63.4]
[null,"Brytpunkt 4",1800,63,63,63,null,"Brytpunkt 4",1700,59.5,59.5,59.5]
[null,"Brytpunkt 5",2160,10,10,10,null,"Brytpunkt 5",2040,10,10,10]
[]
[null,"90km/h, MLV, 2+1 kf, 13-14m, siktklass 1, andel tvåfält 40 %",null,null,null,null,null,"90km/h, MLV, 2+1 kf, 13-14m, siktklass 2, andel tvåfält 40 %"]
[null,null,"Flöde","Reshastighet km/h",null,null,null,null,"Flöde","Reshastighet km/h"]
[null,null,"f/h","Pb","Lb","Lbs",null,null,"f/h","Pb","Lb","Lbs"]
[null,"Brytpunkt 0",0,88.5,83,79.5,null,"Brytpunkt 0",0,88,82.5,77.5,null,null,"MLV 90",null,null,"MLV 90","schablon"]
[null,"Brytpunkt 1",240,88.5,83,79.5,null,"Brytpunkt 1",60,88,82.5,77.5,null,"Villkor","Pb","Lbs","Lbs","Pb","Lbs","Lbs"]
[null,"Brytpunkt 2",750,85.7,81.5,78.8,null,"Brytpunkt 2",500,82,81,76.8,null,"40%  150 f/h",{"$f":"+D43","v":88.5},{"$f":"+E43","v":83},{"$f":"+F43","v":79.5},{"$f":"+R46/R46","v":1},{"$f":"+S46/R46","v":0.94256127567958736},{"$f":"+T46/R46","v":0.894849813261132}]
[null,"Brytpunkt 3",1500,81.5,79.3,78.099999999999994,null,"Brytpunkt 3",1500,81,78.8,76.099999999999994,null,"20% 150 f/h",{"$f":"+J44+(J45-J44)*(150-60)/(500-60)","v":86.772727272727266},{"$f":"+K44+(K45-K44)*(150-60)/(500-60)","v":82.193181818181813},{"$f":"+L44+(L45-L44)*(150-60)/(500-60)","v":77.356818181818184},{"$f":"1/(0.5/O45+0.5/O46)","v":87.627852697095435},{"$f":"1/(0.5/P45+0.5/P46)","v":82.594620623237248},{"$f":"1/(0.5/Q45+0.5/Q46)","v":78.413767622469834}]
[null,"Brytpunkt 4",1550,78.099999999999994,78.099999999999994,78.099999999999994,null,"Brytpunkt 4",1550,76.099999999999994,76.099999999999994,76.099999999999994]
[null,"Brytpunkt 5",1860,10,10,10,null,"Brytpunkt 5",1860,10,10,10]
[]
[null,"100km/h, MLV, 2+1 kf, 13-14m, siktklass 1, andel tvåfält 40 %",null,null,null,null,null,"100km/h, MLV, 2+1 kf, 13-14m, siktklass 1, andel tvåfält 20 %"]
[null,null,"Flöde","Reshastighet km/h",null,null,null,null,"Flöde","Reshastighet km/h"]
[null,null,"f/h","Pb","Lb","Lbs",null,null,"f/h","Pb","Lb","Lbs"]
[null,"Brytpunkt 0",0,96,88,82,null,"Brytpunkt 0",0,96,88,82,null,null,"MLV 100",null,null,"MLV 100","schablon"]
[null,"Brytpunkt 1",240,96,88,82,null,"Brytpunkt 1",60,96,88,82,null,"Villkor","Pb","Lbs","Lbs","Pb","Lbs","Lbs"]
[null,"Brytpunkt 2",750,92.639643774634294,86.1,81,null,"Brytpunkt 2",500,87.439784400140539,86.1,81,null,"40%  150 f/h",{"$f":"+D53","v":96},{"$f":"+E53","v":88},{"$f":"+F53","v":82},{"$f":"+R56/R56","v":1},{"$f":"+S56/R56","v":0.92313408497535443},{"$f":"+T56/R56","v":0.86102441588421652}]
[null,"Brytpunkt 3",1500,87.549708980703485,83.5,80,null,"Brytpunkt 3",1500,81.411976542724631,80.599999999999994,79,null,"20% 150 f/h",{"$f":"+J54+(J55-J54)*(150-60)/(500-60)","v":94.249046809119662},{"$f":"+K54+(K55-K54)*(150-60)/(500-60)","v":87.611363636363635},{"$f":"+L54+(L55-L54)*(150-60)/(500-60)","v":81.795454545454547},{"$f":"1/(0.5/O55+0.5/O56)","v":95.116465973713062},{"$f":"1/(0.5/P55+0.5/P56)","v":87.805251782733038},{"$f":"1/(0.5/Q55+0.5/Q56)","v":81.897599555987242}]
[null,"Brytpunkt 4",1550,79,79,79,null,"Brytpunkt 4",1550,79,79,79]
[null,"Brytpunkt 5",1860,10,10,10,null,"Brytpunkt 5",1860,10,10,10]
[]
[]
[null,"110km/h, MML, 2+1 kf, 13-14m, siktklass 1, andel tvåfält 40%"]
[null,null,"Flöde","Reshastighet km/h"]
[null,null,"f/h","Pb","Lb","Lbs",null,null,"MV110 (3kf S1 Flöde 0-1872f/h)"]
[null,"Brytpunkt 0",0,104.5,92,83.5,null,null,"Flöde","Reshastighet km/h"]
[null,"Brytpunkt 1",240,104.5,92,83.5,null,null,"f/h","Pb","Lb","Lbs"]
[null,"Brytpunkt 2",750,100.4,90,82.5,null,null,null,{"$f":"+J67/$J$67","v":1},{"$f":"+K67/$J$67","v":0.85321100917431192},{"$f":"+L67/$J$67","v":0.77522935779816515}]
[null,"Brytpunkt 3",1500,93.4,86.9,81.5,null,"Brytpunkt 1",1872,109,93,84.5]
[null,"Brytpunkt 4",1550,79,79,79]
[null,"Brytpunkt 5",1860,10,10,10]
[null,null,"Medelhastighet"]
[null,"GIF50ATK","ERL",{"$f":"T75*L6+(1-L6)*40","v":46.533330000000007},{"$f":"U75*M6+(1-M6)*40","v":46.533330000000007},{"$f":"V75*N6+(1-N6)*40","v":46.533330000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,"Medelhastighet"]
[null,"- 40ATK",null,{"$f":"(D71+S28)*L5+(1-L5)*($K5-10)","v":39.606170698890004},{"$f":"(E71+T28)*M5+(1-M5)*($K5-10)","v":39.606170698890004},{"$f":"(F71+U28)*N5+(1-N5)*($K5-10)","v":39.606170698890004},null,null,null,null,null,null,"pb","lb","lbs","lb rel","lbs rel","\"Före\"",null,"Vpb","Vlbu","Vlbs"]
[null,"GIF 50",null,{"$f":"E4","v":49.26315789473685},{"$f":"F4","v":49.26315789473685},{"$f":"G4","v":49.26315789473685},0.1,50,50,50,null,null,0.86,0.06,0.08,{"$f":"F27","v":1},{"$f":"G27","v":1},"GIF50ATK","E",{"$f":"($M73+$N73/$P73+$O73/$Q73)*(50)","v":49.999999999999993},{"$f":"P73*$T73","v":49.999999999999993},{"$f":"Q73*$T73","v":49.999999999999993}]
[null,"-40",null,{"$f":"D73+S28","v":47.433157894736851},{"$f":"E73+T28","v":47.433157894736851},{"$f":"F73+U28","v":47.433157894736851},0.1,47,47,47,null,null,0.92,0.04,0.04,{"$f":"P73","v":1},{"$f":"Q73","v":1},null,"R",{"$f":"($M74+$N74/$P74+$O74/$Q74)*(50)","v":50},50,50]
[null,"-40ATK",null,{"$f":"D74*L5+(1-L5)*($K5-10)","v":41.389657346842114},{"$f":"E74*M5+(1-M5)*($K5-10)","v":41.389657346842114},{"$f":"F74*N5+(1-N5)*($K5-10)","v":41.389657346842114},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P74","v":1},{"$f":"Q74","v":1},null,"L",{"$f":"($M75+$N75/$P75+$O75/$Q75)*(50)","v":50},50,50]
[null,"GIF70ATK","E",{"$f":"T76*L8+(1-L8)*($K8-10)","v":66.752102188615837},{"$f":"U76*M8+(1-M8)*($K8-10)","v":66.824146893377616},{"$f":"V76*N8+(1-N8)*($K8-10)","v":66.476731153686814},null,null,null,null,null,null,0.86,0.06,0.08,{"$f":"F24","v":0.99311195640999284},{"$f":"G24","v":0.98612261806130896},"70ATK","E",{"$f":"($M76+$N76/$P76+$O76/$Q76)*(70)","v":70.107937408107531},69.625030879234998,69.135022783761372]
[null,null,"RL",{"$f":"T77*L8+(1-L8)*($K8-10)","v":66.719294282713719},{"$f":"U77*M8+(1-M8)*($K8-10)","v":66.789565181036494},{"$f":"V77*N8+(1-N8)*($K8-10)","v":66.44239282104391},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P76","v":0.99311195640999284},{"$f":"Q76","v":0.98612261806130896},null,"R",{"$f":"($M77+$N77/$P77+$O77/$Q77)*(70)","v":70.058823776517542},69.576255544480262,69.086590720795357]
[null,"-60ATK","E",{"$f":"(D76+S29)*L7+(1-L7)*($K7-10)","v":58.881125970073512},{"$f":"(E76+T29)*M7+(1-M7)*($K7-10)","v":59.484099130401418},{"$f":"(F76+U29)*N7+(1-N7)*($K7-10)","v":59.54913755143744},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P77","v":0.99311195640999284},{"$f":"Q77","v":0.98612261806130896},null,"L",{"$f":"($M78+$N78/$P78+$O78/$Q78)*(70)","v":70.058823776517542},69.576255544480262,69.086590720795357]
[null,null,"RL",{"$f":"(D77+S29)*L7+(1-L7)*($K7-10)","v":58.860588220978784},{"$f":"(E77+T29)*M7+(1-M7)*($K7-10)","v":59.462174324777138},{"$f":"(F77+U29)*N7+(1-N7)*($K7-10)","v":59.527367048541834},null,null,null,null,null,null,0.86,0.06,0.08,{"$f":"N24","v":0.94957901969944514},{"$f":"O24","v":0.89622551942753148},"GIF 90ATK","E",{"$f":"($M79+$N79/$P79+$O79/$Q79)*(90)","v":91.120422767125248},86.526041725805797,81.664448224923092]
[null,"GIF 70",null,{"$f":"E6","v":68.94202898550725},{"$f":"F6","v":68.467153284671539},{"$f":"G6","v":67.985294117647058},0.05,70,70,69,null,null,0.92,0.04,0.04,{"$f":"P79","v":0.94957901969944514},{"$f":"Q79","v":0.89622551942753148},null,"RL",{"$f":"($M80+$N80/$P80+$O80/$Q80)*(90)","v":90.607999804883121},86.039455631648437,81.205201689421045]
[null,"-60",null,{"$f":"D80+S29","v":66.377028985507252},{"$f":"E80+T29","v":66.602153284671544},{"$f":"F80+U29","v":66.570294117647052},0.05,66,66,65,null,null,0.86,0.06,0.08,{"$f":"N22","v":0.93716921493678329},{"$f":"O22","v":0.84806151180420175},"100ATK","E",{"$f":"($M81+$N81/$P81+$O81/$Q81)*(100)","v":101.83553695411065},95.437130219949665,86.362799424695737]
[null,"-60ATK",null,{"$f":"D81*L7+(1-L7)*($K7-10)","v":60.252020144927542},{"$f":"E81*M7+(1-M7)*($K7-10)","v":60.525765182481763},{"$f":"F81*N7+(1-N7)*($K7-10)","v":60.505566470588235},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P81","v":0.93716921493678329},{"$f":"Q81","v":0.84806151180420175},null,"RL",{"$f":"($M82+$N82/$P82+$O82/$Q82)*(100)","v":100.98481163645687},94.639856641877216,85.641332025676164]
[null,"2kf 80",null,{"$f":"M27","v":83.249249249249246},{"$f":"N27","v":81.249230769230778},{"$f":"O27","v":78.987341772151893},0.02,87,84,82,null,null,0.86,0.06,0.08,{"$f":"(E34+K34)/($D$34+$J$34)","v":0.98653198653198648},{"$f":"(F34+L34)/($D$34+$J$34)","v":0.96969696969696972},"70ATK","E",{"$f":"($M83+$N83/$P83+$O83/$Q83)*(70)","v":70.232337883959048},70.232337883959048,70.232337883959048]
[null,"-ATK",null,{"$f":"D83*L9+(1-L9)*($K9-10)","v":78.969741741741743},{"$f":"E83*M9+(1-M9)*($K9-10)","v":78.121944615384621},{"$f":"F83*N9+(1-N9)*($K9-10)","v":76.839367088607588},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P83","v":0.98653198653198648},{"$f":"Q83","v":0.96969696969696972},null,"R",70.125725255972696,70.125725255972696,70.125725255972696]
[null,"2kf90ATK","E",{"$f":"T79*L10+(1-L10)*($K10-10)","v":87.138833238315414},{"$f":"U79*M10+(1-M10)*($K10-10)","v":85.697234426628455},{"$f":"V79*N10+(1-N10)*($K10-10)","v":81.491345609531081},null,null,null,null,null,null,0.92,0.04,0.04,{"$f":"P84","v":0.98653198653198648},{"$f":"Q84","v":0.96969696969696972},null,"L",70.125725255972696,70.125725255972696,70.125725255972696]
[null,null,"RL",{"$f":"T80*L10+(1-L10)*($K10-10)","v":86.809879730743347},{"$f":"U80*M10+(1-M10)*($K10-10)","v":85.272444766429075},{"$f":"V80*N10+(1-N10)*($K10-10)","v":81.079860713721246}]
[null,"- 80ATK","E",{"$f":"(D85+S30)*L9+(1-L9)*($K9-10)","v":79.368890102339535},{"$f":"(E85+T30)*M9+(1-M9)*($K9-10)","v":79.961603256025739},{"$f":"(F85+U30)*N9+(1-N9)*($K9-10)","v":77.983914008853148}]
[null,null,"RL",{"$f":"(D86+S30)*L9+(1-L9)*($K9-10)","v":79.146188577713247},{"$f":"(E86+T30)*M9+(1-M9)*($K9-10)","v":79.654905121361793},{"$f":"(F86+U30)*N9+(1-N9)*($K9-10)","v":77.670774003141872}]
[null,"2kf 90",null,{"$f":"M25","v":89.249299719887944},{"$f":"N25","v":84.749262536873161},{"$f":"O25","v":79.987500000000011},0.02,93,87,82]
[null,"-80",null,{"$f":"D89+S30","v":85.949299719887946},{"$f":"E89+T30","v":82.849262536873155},{"$f":"F89+U30","v":78.987500000000011},0.02,89,84,81]
[null,"-80ATK",null,{"$f":"D90*L9+(1-L9)*($K9-10)","v":80.797675910364134},{"$f":"E90*M9+(1-M9)*($K9-10)","v":79.277167551622426},{"$f":"F90*N9+(1-N9)*($K9-10)","v":76.839487500000004}]
[null,"2kf100ATK","E",{"$f":"T81*L11+(1-L11)*($K11-10)","v":98.876652715582992},{"$f":"U81*M11+(1-M11)*($K11-10)","v":94.887980067734759},{"$f":"V81*N11+(1-N11)*($K11-10)","v":86.708333479349648}]
[null,null,"RL",{"$f":"T82*L11+(1-L11)*($K11-10)","v":98.238608727342651},{"$f":"U82*M11+(1-M11)*($K11-10)","v":94.171231121047626},{"$f":"V82*N11+(1-N11)*($K11-10)","v":86.055405483236925}]
[null,"- 80ATK","E",{"$f":"(D92+S31)*L9+(1-L9)*($K9-10)","v":85.995243888449693},{"$f":"(E92+T31)*M9+(1-M9)*($K9-10)","v":85.261621608904505},{"$f":"(F92+U31)*N9+(1-N9)*($K9-10)","v":81.763791777785087}]
[null,null,"RL",{"$f":"(D93+S31)*L9+(1-L9)*($K9-10)","v":85.563288108410973},{"$f":"(E93+T31)*M9+(1-M9)*($K9-10)","v":84.744128869396377},{"$f":"(F93+U31)*N9+(1-N9)*($K9-10)","v":81.266913572743306}]
[null,"2kf100",null,{"$f":"M23","v":95.497382198952877},{"$f":"N23","v":89.497206703910607},{"$f":"O23","v":80.987654320987644},0.02,100,91,83]
[null,"- 80",null,{"$f":"D96+S31","v":90.247382198952877},{"$f":"E96+T31","v":85.747206703910607},{"$f":"F96+U31","v":79.737654320987644},0.02,95,88,81]
[null,"- 80ATK",null,{"$f":"D97*L9+(1-L9)*($K9-10)","v":83.707477748691105},{"$f":"E97*M9+(1-M9)*($K9-10)","v":81.36948324022346},{"$f":"F97*N9+(1-N9)*($K9-10)","v":77.410354938271595}]
[null,"MLV 100",null,{"$f":"R56","v":95.116465973713062},{"$f":"S56","v":87.805251782733038},{"$f":"T56","v":81.897599555987242},0.02,96,88,82]
[null,"MV110",null,{"$f":"J67","v":109},{"$f":"K67","v":93},{"$f":"L67","v":84.5},0.02,111,93,87]
[]
[null,"2kf70",null,{"$f":"E8","v":74.249158249158242},{"$f":"F8","v":73.249146757679185},71.986111111111114]
[null,"-60",null,{"$f":"D102+S29","v":71.684158249158244},{"$f":"E102+T29","v":71.38414675767919},70.571111111111108]
[null,"-60ATK",null,{"$f":"D103*L7+(1-L7)*($K7-10)","v":63.574283063973056},{"$f":"E103*M7+(1-M7)*($K7-10)","v":63.557549044368614},{"$f":"F103*N7+(1-N7)*($K7-10)","v":63.042084444444441}]
[null,"2kf70ATK","E",{"$f":"T83*L8+(1-L8)*($K8-10)","v":66.835201706484639},{"$f":"U83*M8+(1-M8)*($K8-10)","v":67.254727559726973},67.254727559726973]
[null,null,"RL",{"$f":"T84*L8+(1-L8)*($K8-10)","v":66.763984470989769},{"$f":"U84*M8+(1-M8)*($K8-10)","v":67.179139206484649},67.179139206484649]
[null,"-60ATK",null,{"$f":"(D105+S29)*L7+(1-L7)*($K7-10)","v":58.933146268259378},{"$f":"(E105+T29)*M7+(1-M7)*($K7-10)","v":59.757087272866912},{"$f":"(F105+U29)*N7+(1-N7)*($K7-10)","v":60.042387272866904}]

{"sheet":"Trafiksäkerhet","index":4,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["Hastig-","Typ","Bredd/miljö","Tot per Mapkm  2010",null,null,null,"Korsninspåslag"]
["hetsgräns",null,"m","Dk","SSk",null,null,null,null,null,null,null,"länk + nod result.",null,"Vföre",null,null,"Vrel",null,null,"Potensmodellen","D","SS"]
[50,"GIF","Centrum",3.6709999999999998E-3,{"$f":"0.049619*D39","v":7.4428500000000009E-2},null,null,null,"Dk","SSk","Korsningspåslag",null,"Dk","SSk","Vpb","Vlb","Vlbs","lb","lbs",null,"Landsbygd",4.5999999999999996,3.5]
[50,"GIF","Mellan",3.1050000000000001E-3,{"$f":"0.043057*D39","v":6.458549999999999E-2},null,null,"50 GIF",{"$f":"+AVERAGE(D4:D8)*V10","v":2.5654936349490732E-3},{"$f":"+AVERAGE(E4:E8)*V11","v":5.4985078717255928E-2},1.21,1,{"$f":"+I5*K5","v":3.1042472982883785E-3},{"$f":"+K5*J5","v":6.653194524787967E-2},{"$f":"Hastighet!E28","v":49.26315789473685},{"$f":"Hastighet!F28","v":49.26315789473685},{"$f":"Hastighet!G28","v":49.26315789473685},{"$f":"Hastighet!F27","v":1},{"$f":"Hastighet!G27","v":1},null,"Tätort",3,2]
[50,"GIF","Ytter",2.8739999999999998E-3,{"$f":"0.04361*D39","v":6.5415000000000001E-2},null,null,"- med ATK",null,null,null,2,{"$f":"0.9*M5","v":2.7938225684595408E-3},{"$f":"0.9*N5","v":5.9878750723091706E-2}]
[50,"stat, ej ML","6.7-7.9",3.859E-3,{"$f":"0.03841*D39","v":5.7615E-2},null,null,"70 GIF",{"$f":"+AVERAGE(D9:D10)*V10","v":3.2788775311942695E-3},{"$f":"+AVERAGE(E9:E10)*V11","v":4.6869525079942992E-2},1.32,3,{"$f":"+I7*K7","v":4.3281183411764358E-3},{"$f":"+K7*J7","v":6.186777310552475E-2},{"$f":"Hastighet!E25","v":68.94202898550725},{"$f":"Hastighet!F25","v":68.467153284671539},{"$f":"Hastighet!G25","v":67.985294117647058},{"$f":"Hastighet!F24","v":0.99311195640999284},{"$f":"Hastighet!G24","v":0.98612261806130896},null,"Formler"]
[50,"stat, ej ML","8-10",{"$f":"D7","v":3.859E-3},{"$f":"E7","v":5.7615E-2},null,null,"- med ATK",null,null,null,4,{"$f":"0.9*M7","v":3.8953065070587924E-3},{"$f":"0.9*N7","v":5.5680995794972273E-2},null,null,null,null,null,null,"TS-EVA Excel-fil","https://www.trafikverket.se/tseva"]
[70,"GIF","Mellan",4.5900000000000003E-3,{"$f":"0.037296*D39","v":5.5944000000000008E-2},null,null,"70 2kf",{"$f":"+AVERAGE(D11:D12)*V10","v":3.054721808541389E-3},{"$f":"+AVERAGE(E11:E12)*V11","v":5.1198327787605788E-2},1.32,5,{"$f":"+I9*K9","v":4.0322327872746337E-3},{"$f":"+K9*J9","v":6.7581792679639638E-2},{"$f":"Hastighet!M27","v":83.249249249249246},{"$f":"Hastighet!N27","v":81.249230769230778},{"$f":"Hastighet!O27","v":78.987341772151893},{"$f":"Hastighet!N26","v":0.97597553734051834},{"$f":"Hastighet!O26","v":0.94880545451722753},null,"Riskmåttens förändring över tid 6.2.1.2","https://www.trafikverket.se/contentassets/0ebc841761f74f56b31c6eba59511bca/bygg-om/kapitel_6_trafiksakerhet.pdf"]
[70,"GIF","Ytter",4.2890000000000003E-3,{"$f":"0.035365*D39","v":5.3047499999999997E-2},null,null,"- med ATK",null,null,null,6,{"$f":"+M9*0.9","v":3.6290095085471704E-3},{"$f":"+N9*0.9","v":6.0823613411675678E-2},null,null,null,null,null,null,"Dödade minskar med 2% per år över tid (2010-2025)",{"$f":"0.98^15","v":0.73856910264540354}]
[70,"stat, ej ML","6.7-7.9",5.6090000000000003E-3,{"$f":"0.038796*D38","v":6.595319999999999E-2},null,null,"90 2kf",{"$f":"+AVERAGE(D15:D16)*V10","v":3.3944635957582747E-3},{"$f":"+AVERAGE(E15:E16)*V11","v":3.6654095966855614E-2},1.1299999999999999,7,{"$f":"+I11*K11","v":3.8357438632068501E-3},{"$f":"+K11*J11","v":4.1419128442546839E-2},{"$f":"Hastighet!M25","v":89.249299719887944},{"$f":"Hastighet!N25","v":84.749262536873161},{"$f":"Hastighet!O25","v":79.987500000000011},{"$f":"Hastighet!N24","v":0.94957901969944514},{"$f":"Hastighet!O24","v":0.89622551942753148},null,"Svårt skadade minskar med 1% per år över tid (2010-2025)",{"$f":"0.99^15","v":0.86005835464128833}]
[70,"stat, ej ML","8-10",2.663E-3,{"$f":"0.031238*D38","v":5.3104599999999995E-2},null,null,"- med ATK",null,null,null,8,{"$f":"0.95*M11","v":3.6439566700465073E-3},{"$f":"0.95*N11","v":3.9348172020419493E-2}]
[80,"stat, ej ML","6.7-7.9",4.5657810788198088E-3,{"$f":"0.0279408560118313*D38","v":4.7499455220113208E-2},null,null,"100 2kf",{"$f":"+AVERAGE(D17:D18)*V10","v":3.2275469785604132E-3},{"$f":"+AVERAGE(E17:E18)*V11","v":3.2331399673510772E-2},1.08,9,{"$f":"+I13*K13","v":3.4857507368452464E-3},{"$f":"+K13*J13","v":3.4917911647391636E-2},{"$f":"Hastighet!M23","v":95.497382198952877},{"$f":"Hastighet!N23","v":89.497206703910607},{"$f":"Hastighet!O23","v":80.987654320987644},{"$f":"Hastighet!N22","v":0.93716921493678329},{"$f":"Hastighet!O22","v":0.84806151180420175}]
[80,"stat, ej ML","8-10",2.9972738935277279E-3,{"$f":"0.0212449513616221*D38","v":3.6116417314757565E-2},null,null,"- med ATK",null,null,null,10,{"$f":"+M13","v":3.4857507368452464E-3},{"$f":"+N13","v":3.4917911647391636E-2}]
[90,"stat, ej ML","6.7-7.9",4.2370000000000003E-3,{"$f":"0.025133*D38","v":4.2726099999999996E-2},null,null,"90 MLV",{"$f":"+AVERAGE(D15:D16)*V10","v":3.3944635957582747E-3},{"$f":"+AVERAGE(E15:E16)*V11","v":3.6654095966855614E-2},1.3,11,{"$f":"I15*K15","v":4.4128026744857576E-3},{"$f":"J15*K15","v":4.7650324756912298E-2}]
[90,"stat, ej ML","8-10",4.9550000000000002E-3,{"$f":"0.025006*D38","v":4.2510199999999998E-2},null,null,"- med ATK",null,null,null,12,{"$f":"+M15","v":4.4128026744857576E-3},{"$f":"N15","v":4.7650324756912298E-2}]
[100,"stat, ej ML","6.7-7.9",4.4679999999999997E-3,{"$f":"0.015138*D38","v":2.57346E-2},null,null,"MLV 110",{"$f":"D23*V10","v":8.921914759956476E-4},{"$f":"E23*V11","v":9.0598547077913316E-3},1.1499999999999999,13,{"$f":"I17*K17","v":1.0260201973949948E-3},{"$f":"J17*L17","v":0.11777811120128731},{"$f":"Hastighet!E8","v":74.249158249158242},{"$f":"Hastighet!F8","v":73.249146757679185},{"$f":"Hastighet!G8","v":71.986111111111114},{"$f":"Hastighet!H8","v":0.98653167907812078},{"$f":"Hastighet!I8","v":0.96952090513332134}]
[100,"stat, ej ML","8-10",4.2719999999999998E-3,{"$f":"0.029088*D38","v":4.9449599999999996E-2},null,null,"MV 110",{"$f":"D21*V10","v":5.3250832300733594E-4},{"$f":"E21*V11","v":7.6877176087966192E-3},1.05,14,{"$f":"I18*K18","v":5.5913373915770278E-4},{"$f":"J18*K18","v":8.0721034892364506E-3}]
[100,"MLV","13-14m",4.2000000000000002E-4,{"$f":"0.008611*D38","v":1.4638700000000001E-2}]
[100,"2+1 Räcke Gles","9-13m",4.0505593366344607E-4,{"$f":"0.00827547133480904*D38","v":1.4068301269175366E-2}]
[110,"MV räcke","21,5m",7.2099999999999996E-4,{"$f":"0.005258*D38","v":8.9385999999999997E-3}]
[120,"MV räcke","<24,5",9.5100000000000002E-4,{"$f":"0.022028*D38","v":3.7447599999999998E-2}]
[110,"MLV   ","13-14",1.2080000000000001E-3,1.0534E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bortfallsfaktorer","D","SS","LS","EG"]
[null,"Landsbygd",1,1.7,1.7,7]
[null,"Tätort",1,1.5,1.5,7]

{"sheet":"CO2","index":5,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["CO2-utsläpp i gram per fordonskilometer enligt nivå 2025",null,null,null,null,null,null,null,null,"y=kx+m",null,"k","m",null,"y=k1x^2+k2x+m","k1","k2","m",null,"y=k1x^2+k2x+m","k1","k2","m"]
["V","Pb",null,"Lbu",null,"Lbs",null,null,null,null,"PB tätort",0.1087,101.89,null,"LBU tätort",0.12180000000000001,-15.125999999999999,849.71,null,"LBS tätort",0.18790000000000001,-25.239000000000001,1469]
[null,"Landsbygd","Tätort","Landsbygd","Tätort","Landsbygd","Tätort",null,null,null,"PB landsbygd",0.92130000000000001,25.527999999999999,null,"LBU landsbygd",null,1.2558,265.06,null,"LBS landsbygd",null,0.52300000000000002,525.20000000000005]
[30]
[31]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fordonstyp","Viktning"]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pb",0.69799999999999995]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lbu",0.77]
[35,null,{"$f":"(A9*$L$2+$M$2)*$S$7","v":73.774760999999998},null,{"$f":"(A9^2*$P$2+A9*$Q$2+$R$2)*$S$8","v":361.5188500000001},null,{"$f":"(A9^2*$U$2+A9*$V$2+$W$2)*$S$9","v":677.12437499999999},null,null,null,null,null,null,null,null,null,null,"Lbs",0.83]
[36,null,{"$f":"(A10*$L$2+$M$2)*$S$7","v":73.850633599999995},null,356.53063600000007,null,667.24895199999992]
[37,null,73.926506199999992,null,351.72999399999998,null,657.68544299999985]
[38,null,74.002378800000002,null,347.11692399999998,null,648.4338479999999]
[39,null,74.078251399999999,null,342.69142600000004,null,639.49416699999995]
[40,null,74.154123999999996,null,338.45350000000008,null,630.86639999999989]
[41,null,74.229996599999993,null,334.40314600000011,null,622.55054700000005]
[42,null,74.305869199999989,null,330.54036400000001,null,614.54660799999999]
[43,null,74.381741799999986,null,326.86515400000008,null,606.85458299999993]
[44,null,74.457614399999997,null,323.37751600000007,null,599.47447199999988]
[45,null,74.533486999999994,null,320.07745000000006,null,592.40627499999982]
[46,null,74.609359600000005,null,316.96495600000009,null,585.64999199999988]
[47,null,74.685232200000002,null,314.04003399999999,null,579.20562300000006]
[48,null,74.761104799999998,null,311.30268400000006,null,573.07316800000001]
[49,null,74.836977399999995,null,308.75290600000005,null,567.25262699999996]
[50,null,74.912849999999992,null,306.39070000000009,null,561.74399999999991]
[51,null,74.988722600000003,null,304.21606600000013,null,556.54728699999998]
[52,null,75.064595199999999,null,302.22900400000003,null,551.66248799999983]
[53,null,75.140467799999996,null,300.42951400000004,null,547.0896029999999]
[54,null,75.216340399999993,null,298.81759600000009,null,542.82863200000008]
[55,null,75.29221299999999,null,297.39325000000008,null,538.87957500000005]
[56,null,75.368085599999986,null,296.15647600000011,null,535.24243200000001]
[57,null,75.443958199999997,null,295.10727400000002,null,531.91720299999997]
[58,null,75.519830799999994,null,294.24564400000008,null,528.90388799999994]
[59,null,75.595703400000005,null,293.57158600000008,null,526.20248699999991]
[60,null,75.671576000000002,null,293.08510000000007,null,523.81299999999987]
[61,null,75.747448599999998,null,292.7861860000001,null,521.73542700000007]
[62,null,75.823321199999995,null,292.67484400000006,null,519.96976799999993]
[63,null,75.899193799999992,null,292.75107400000007,null,518.51602300000002]
[64,null,75.975066400000003,null,293.01487600000007,null,517.37419199999999]
[65,null,76.050939,null,293.46625000000012,null,516.54427499999997]
[66,{"$f":"(A40*$L$3+$M$3)*$S$7","v":60.260992399999992},76.126811599999996,{"$f":"(A40*$Q$3+$R$3)*$S$8","v":267.91595600000005},294.10519600000009,{"$f":"(A40^2*$U$3+A40*$V$3+$W$3)*$S$9","v":464.56594000000001},516.02627199999995]
[67,60.904059799999992,76.202684199999993,268.88292200000001,294.93171400000006,465.00003000000004,515.82018299999993]
[68,61.547127199999998,76.27855679999999,269.84988800000002,295.94580400000007,465.43412000000001,515.92600800000002]
[69,62.190194599999998,76.354429399999987,270.81685399999998,297.14746600000012,465.86821000000003,516.34374700000001]
[70,62.833261999999998,76.430301999999998,271.78381999999999,298.53670000000011,466.3023,517.07339999999999]
[71,63.476329400000004,null,272.75078600000001,null,466.73639000000003]
[72,64.119396800000004,null,273.71775200000002,null,467.17048]
[73,64.762464200000011,null,274.68471800000003,null,467.60456999999997]
[74,65.405531599999989,null,275.65168399999999,null,468.03865999999999]
[75,66.048598999999982,null,276.61865,null,468.47275000000002]
[76,66.691666399999988,null,277.58561600000002,null,468.90684000000005]
[77,67.334733799999995,null,278.55258199999997,null,469.34092999999996]
[78,67.977801199999988,null,279.51954800000004,null,469.77501999999998]
[79,68.620868599999994,null,280.486514,null,470.20911000000001]
[80,69.263936000000001,null,281.45348000000001,null,470.64320000000004]
[81,69.907003399999994,null,282.42044600000003,null,471.07729000000006]
[82,70.5500708,null,283.38741199999998,null,471.51137999999997]
[83,71.193138199999993,null,284.354378,null,471.94547]
[84,71.8362056,null,285.32134400000001,null,472.37956000000003]
[85,72.479273000000006,null,286.28831000000002,null,472.81365000000005]
[86,73.122340399999999,null,287.25527600000004,null,473.24773999999996]
[87,73.765407799999991,null,288.22224199999999,null,473.68182999999999]
[88,74.408475199999984,null,289.18920800000001,null,474.11592000000002]
[89,75.051542599999991,null,290.15617399999996,null,474.55001000000004]
[90,75.694609999999997,null,291.12313999999998,null,474.98410000000007]
[91,76.33767739999999,null,292.09010599999999,null,475.41818999999998]
[92,76.980744799999997,null,293.05707200000006,null,475.85228000000001]
[93,77.623812199999989,null,294.02403800000002,null,476.28637000000003]
[94,78.266879599999996,null,294.99100400000003,null,476.72046000000006]
[95,78.909947000000003,null,295.95796999999999,null,477.15454999999997]
[96,79.553014399999995,null,296.924936,null,477.58864]
[97,80.196081800000002,null,297.89190200000002,null,478.02273000000002]
[98,{"$f":"(A72*$L$3+$M$3)*$S$7","v":80.839149200000008},null,{"$f":"(A72*$Q$3+$R$3)*$S$8","v":298.85886800000003},null,{"$f":"(A72^2*$U$3+A72*$V$3+$W$3)*$S$9","v":478.45682000000005}]
[99,81.482216600000001,null,299.82583400000004,null,478.89091000000008]
[100,82.125283999999979,null,300.7928,null,479.32499999999999]
[101,82.768351399999986,null,301.75976600000001,null,479.75909000000001]
[102,83.411418799999993,null,302.72673200000003,null,480.19318000000004]
[103,84.054486199999985,null,303.69369799999998,null,480.62727000000001]
[104,84.697553599999992,null,304.660664,null,481.06136000000004]
[105,85.340620999999999,null,305.62763000000001,null,481.49545000000001]
[106,85.983688399999991,null,306.59459600000002,null,481.92954000000003]
[107,86.626755799999998,null,307.56156200000004,null,482.36363]
[108,87.269823200000005,null,308.52852799999999,null,482.79772000000003]
[109,87.912890599999997,null,309.49549400000001,null,483.23181000000005]
[110,88.555958000000004,null,310.46245999999996,null,483.66589999999997]
[111,89.199025399999996,null,311.42942600000003,null,484.09998999999999]
[112,89.842092799999989,null,312.39639200000005,null,484.53408000000002]
[113,90.485160199999982,null,313.36335800000006,null,484.96817000000004]
[114,91.128227599999988,null,314.33032400000002,null,485.40225999999996]
[115,91.771294999999995,null,315.29728999999998,null,485.83634999999998]
[116,92.414362399999987,null,316.26425599999999,null,486.27044000000001]
[117,93.057429799999994,null,317.231222,null,486.70453000000003]
[118,93.700497199999987,null,318.19818800000002,null,487.13862000000006]
[119,94.343564599999993,null,319.16515400000003,null,487.57270999999997]
[120,94.986632,null,320.13211999999999,null,488.0068]
[121,95.629699399999993,null,321.099086,null,488.44089000000002]
[122,96.272766799999999,null,322.06605200000001,null,488.87498000000005]
[123,96.915834200000006,null,323.03301800000003,null,489.30906999999996]
[124,97.558901599999999,null,323.99998399999998,null,489.74315999999999]
[125,98.201968999999977,null,324.96695,null,490.17725000000002]
[126,98.845036399999984,null,325.93391600000001,null,490.61134000000004]
[127,99.48810379999999,null,326.90088200000002,null,491.04543000000007]
[128,100.13117119999998,null,327.86784800000004,null,491.47951999999998]
[129,100.77423859999999,null,328.83481399999999,null,491.91361000000001]
[130,{"$f":"(A104*$L$3+$M$3)*$S$7","v":101.417306},null,329.80178000000001,null,492.34770000000003]

{"sheet":"Version","index":6,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["Version 0.4"]
["1) Potensfel rättat i CO2-beräkning"]
["2) Indata-kolumner från Reg Ö"]
["3) Viktsfaktor i VQ-före rättad"]
[]
[]
["4) Infört 2kf 70 före med/utan ATK och 2kf80 med/utan ATK efter"]
[]
["5) Infört MLV110 till MLV100"]
[]
["6) Rättat tidsfel i olycksmodell för MLV110"]
[]
["V 0.44"]
["Gånger 10 för D o SS"]
["Kiloton för CO2"]
["Summa för tid"]
[]
["V 0.45"]
["kolumn CC pekade tidigare fel till kolumn BG istället för BF. Valde därför CO2 för lbu istället för pb."]
[]
["V 0.46"]
["MLV 2+1 40 % i hastighetsflikens VQ avsåg tidigare S2 nu S1"]
[]
["V 0.47"]
["Ombyggnad till MV110 tidigare endast från MLV110 nu även från MLV100"]
[]
["V 1.0"]
["1) VBA programmerad"]
["2) Beräkningshjälp av ÅDT"]
["3) Summa för respektive effekt på \"Indata & Resulat"]
["4) Hastighetssamband har uppdaterats till gällande effektsamband 2018-04-01"]
["5) Trafiksäkerhetseffekter har uppdaterats utefter TS EVA 3.0"]
["6) Koldioxidutsläpp har med indata från Helen Lindblom utefter beslutad politik 2019-10-03"]
["7) D och SS beräknas återigen på årsbasis"]
["8) Ytterligare mindre ändringar har gjorts i utformning av flikar och grafisk tydlighet"]
[]
["V 2020:1"]
["1) Trafikuppräkningstalen har uppdaterats för att överensstämma med nya trafikprognoser"]
["2) Hastighetsvalen har uppdaterats för att motsvara nuvarande behov"]
["3) CO2-värdering har uppdaterats för att spegla basprognosen"]
["4) Ytterligare felkod har åtgärdats"]
["5) Generella hastighetsgränser har uppdaterats till nedanstående effektsamband"]
[null,"pb","lb","lbs"]
["50-40",-1.83,-1.83,-1.83]
["70-60",{"$f":"(0.5*B45)+(0.5*B47)","v":-2.5649999999999999},{"$f":"(0.5*C45)+(0.5*C47)","v":-1.865},{"$f":"(0.5*D45)+(0.5*D47)","v":-1.415}]
["90-80",-3.3,-1.9,-1]
["100-80",{"$f":"(0.5*-5.4)+(0.5*-5.1)","v":-5.25},{"$f":"(0.5*-3.4)+(0.5*-4.1)","v":-3.75},{"$f":"(0.5*-2.6)+(0.5*0.1)","v":-1.25}]
["110-100",-2.2999999999999998,0,-0.5]
["110-120",3.7,3.2,0]
["90-100",2.4,1.9,0]
["6) Ytterligare mindre ändringar har gjorts i utformning av flikar och grafisk tydlighet"]
[]
["V 2021:1"]
["Rättning av potensen i årlig procenuell tillväxt vid beräkning av ÅDT"]
[]
["V 2023:1"]
["1) Trafikuppräkningstalen har uppdaterats för att överensstämma med nya trafikprognoser"]
["2) Uppdaterat länk till EVA:s hemsida för referens trafikuppräkningstal"]
["3) Enklare redaktionella förändringar och förtydliganden"]
["Förändringarna gjorda 2023-03-05, Version publiceras 2023-04-03"]