{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["VEJLEDNING","COCKPIT","DATA_UDTRÆK","BEREGNINGSARK","LISTER","INPUT_DATA"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":335,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VEJLEDNING","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Dette værktøj er udarbejdet af Movia i samarbejde med Trafikselskaberne i Danmark og Trafik, Bygge- og Boligstyrelsen."]
[null,"Værktøjet er udviklet til beregning af merpris ved anvendelse af busser med alternative drivmidler sammenholdt med diesel"]
[null,"Værktøjet består af fanebladene: COCKPIT, BEREGNINGSARK, INPUT_DATA, DATA_UDTRÆK og LISTER (skjult)."]
[null,"Alle brugerdata angives i COCKPIT. COCKPIT viser alle beregningsforudsætninger, og brugeren har mulighed for at angive egne data."]
[null,"Inputværdier, som er markeret med ? er nødvendige at angive."]
[null,"Værdier markeret med ! er omkostningsdrivende, og det anbefales at der anvendes brugerdata."]
[null,"Hvis køreplantimeantallet ikke angives (?!) skal årlige rutekilometer i stedet angives."]
[null,"Beregnede data kan gemmes i arket DATA_UDTRÆK ved at trykke på \"Gem beregning\"-knappen"]
[null,"Værktøjets brugerværdier kan nulstilles ved at trykke \"Nulstil alle værdier\"-knappen."]
[null,"Gemte beregnede data kan slettes ved at trykke på \"Slet gemte beregninger\"-knappen."]
[null,"Alle beregninger foretages i beregningsarket."]
[null,"Værktøjet understøtter følgende bustyper: dieselbusser, som anvender diesel og HVO-biodiesel, elbusser og CNG-busser, som anvender bionaturgas på certifikater."]
[null,"Beregning af merpriser ved biogas er behæftet med betydelig usikkerhed, ogde beregnede værdier bør kun anvendes ved omstilling til biogas i større flådes (ca. 20+ busser)."]
[null,"NB. Undlad at benytte programmet med ekstern monitor, da det kan forstyrre knapper mv."]
[]
[]
[null,"Version 1.1"]

{"sheet":"COCKPIT","index":1,"n_rows":113,"n_cols":17,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,10,1,12],[2,10,2,12],[2,4,2,6]]}
[]
[]
[null,null,null,null,"ØNSKET LØSNING",null,null,null,null,null,"REFERENCE LØSNING"]
[null,null,null,null,"BRUGERVÆRDI",null,"STANDARDVÆRDI",null,null,null,"BRUGERVÆRDI",null,"STANDARDVÆRDI"]
[null,"PROJEKTTYPE"]
[null,"ny kontrakt"]
[]
[null,"tilkøb af HVO i eksisterende kontrakt"]
[]
[null,"drivmiddel",null,"?",null,null,null,null,"drivmiddel",null,null,null,"diesel",null,"Elbus, depot"]
[]
[null,"kørselstype",null,"?",null,null,null,null,"kørselstype",null,null,null,{"$f":"KørTyp","v":"Landevejsbusser"},null,"Landevejsbusser"]
[]
[null,"kontraktlængde","år","?",12,null,null,null,"kontraktlængde","år",null,null,{"$f":"ÅrØns","v":12}]
[]
[null,"projektlængde","år","?",12]
[]
[null,"linje/kontraktenhed",null,null,"A16, Roskilde"]
[]
[null,"BUSDATA"]
[null,"driftsbusser","stk.","?",17]
[]
[null,"buslængde","m","?",null,null,null,null,"buslængde","m",null,null,{"$f":"BusLænØns","v":"11,9-12,8"},null,"11,9-12,8"]
[]
[null,"køreplanstimer","timer/år","?!",62986,null,null,null,"årskørsel","timer/år",null,null,{"$f":"TimÅrØns","v":62986}]
[]
[null,"rutekm ","km/år","!",1343192.7440000004,null,{"$f":"TimÅrØns*INDEX(kmT,1,MATCH(KørTyp,KØRSELSTYPE,0))","v":2204510},null,"årskørsel","km/år",null,null,{"$f":"IF(RutKmØnsVær>0,RutKmØnsVær,TimRef*INDEX(kmT,1,KørTypOps))","v":1343192.7440000004}]
[]
[null,"tomkørsel","% rutekm",null,null,null,{"$f":"INDEX(TomKmOps,1,MATCH(KørTyp,KØRSELSTYPE,0))","v":0.12}]
[]
[null,"total busser (inkl. reserve og indskud)","stk.","!",20,null,{"$f":"DriBusVær+ROUNDUP(DriBusVær/ResBusAnd,0)+ROUNDUP(IF(OR(DriØns=ElDep,DriØns=ElBy),DriBusVær/DriBusAnd*INDEX((IndBus_11,IndBus_12,IndBus_13,IndBus_137,IndBus_15,IndBus_18),kmInd,IF(DriØns=ElDep,1,2),BusLænOps),0),0)","v":20},null,"antal busser","stk.",null,null,{"$f":"DriBusVær+ROUNDUP(DriBusVær/ResBusAnd,0)","v":19}]
[]
[null,"årskørsel (inkl. tomkørsel)","km/år/bus",null,null,null,{"$f":"RutKmØns*(1+TomKmPct)/BusAnt","v":75218.793664000026},null,"årskørsel (inkl. tomkørsel)","km/år/bus",null,null,{"$f":"RutkmRef*(1+TomKmPct)/BusAntRef","v":79177.677541052661}]
[]
[null,"rente","% pa",null,null,null,{"$f":"Rente","v":0.02}]
[]
[null,"klimaanlæg",null,null,null,null,{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),\"ja\",\"nej\")","v":"ja"},null,"klimaanlæg",null,null,null,{"$f":"IF(ØnsKlima=\"\",\"nej\",ØnsKlima)","v":"ja"},null,"ja",null,"ja"]
[]
[null,"buspris","kr./bus",null,null,null,{"$f":"IF(ØnsKlima=JA,INDEX(BUSPRIS,BusLænOps,5)+INDEX(BUSPRIS,BusLænOps,DriOps),INDEX(BUSPRIS,BusLænOps,DriOps))+IF(AND(DriØns=ElBy,EffBy=kW_450),INDEX(BUSPRIS,BusLænOps,6),0)","v":3175000},null,"buspris","kr./bus",null,null,{"$f":"IF(RefKlima=JA,INDEX(BUSPRIS,BusLænRefOps,5)+INDEX(BUSPRIS,BusLænRefOps,1),INDEX(BUSPRIS,BusLænRefOps,1))","v":1675000}]
[]
[null,"momsfradrag","% af moms",null,null,null,{"$f":"MomsFrad","v":0.5}]
[]
[null,"restværdi","kr./bus",null,null,null,{"$f":"INDEX(Restværdi,1,ÅrØns)*BusPriØns+IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),INDEX(Restværdi,2,ÅrØns)*BatUds,0)","v":279375},null,"restværdi","kr./bus",null,null,{"$f":"INDEX(Restværdi,1,ÅrRef)*BusPriRef","v":41875}]
[]
[null,"forsikring","kr./bus/år",null,null,null,{"$f":"BusPriØns*Forsikring","v":38100},null,"forsikring","kr./bus/år",null,null,{"$f":"BusPriRef*Forsikring","v":20100}]
[]
[null,"service","kr./km",null,null,null,{"$f":"ÅrsKm*INDEX((SerP11,SerP12,SerP13,SerP137,SerP15,SerP18),DriOps,ROUND(ÅrØns,0),BusLænOps)","v":1.4400000000000002},null,"service","kr./km",null,null,{"$f":"ÅrsKmRef*INDEX((SerP11,SerP12,SerP13,SerP137,SerP15,SerP18),5,ROUND(ÅrRef,0),BusLænRefOps)","v":1.6}]
[]
[null,"skader","kr./år/bus",null,null,null,{"$f":"IF(KørTyp=ByPro,kmÅrØns/SkaKmÅr*SkaPro,IF(KørTyp=ByKøb,kmÅrØns/SkaKmÅr*SkaKøb,IF(KørTyp=Land,kmÅrØns/SkaKmÅr*SkaLan,0)))","v":15043.758732800006},null,"skader","kr./år/bus",null,null,{"$f":"IF(KørTyp=ByPro,kmÅrRef/SkaKmÅr*SkaPro,IF(KørTyp=ByKøb,kmÅrRef/SkaKmÅr*SkaKøb,IF(KørTyp=Land,kmÅrRef/SkaKmÅr*SkaLan,0)))","v":15835.535508210532}]
[]
[null,"forbrug, fremdrift",{"$f":"INDEX(FORBRUG,MATCH(drivmiddel,ØnskLøs,0),2)","v":"kWh/km"},null,null,null,{"$f":"INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),BusLænOps,DriOps,KørTypOps)","v":1.3224999999999998},null,"forbrug, fremdrift","km/l",null,null,{"$f":"INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),BusLænRefOps,5,KørTypOps)","v":3.7}]
[]
[null,"forbrug, opvarmning","liter HVO/km",null,null,null,{"$f":"IF(drivmiddel=ElDep,INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),BusLænOps,6,KørTypOps),\"\")","v":1.6666666666666666E-2}]
[]
[null,"chaufførløn","kr./køreplanstime",null,null,null,{"$f":"ChaLøn","v":400}]
[]
[null,"batteriudskiftning","kr./bus",null,null,null,{"$f":"IF(ForEl*kmÅrØns*ÅrØns>kWhBatUds,INDEX(BatPris,1,BusLænOps),0)","v":600000}]
[]
[null,"LADEINFRASTRUKTUR"]
[null,"ladeeffekt, depot","kW/lader",null,null,null,{"$f":"IF(drivmiddel=ElDep,Eff_150,IF(drivmiddel=ElBy,LISTER!K3,0))","v":"150 (2*75)"}]
[]
[null,"ladetab","%",null,null,null,{"$f":"LadTabBy","v":0.05}]
[]
[null,"antal ladere, depot","stk.",null,null,null,{"$f":"ROUNDUP((BusAnt-ROUNDUP(IF(DriBusVær>0,DriBusVær,BusAnt)/ResBusAnd,0))*INDEX(DepPris,MATCH(IF(kWdepVær>0,kWdepVær,kWdepStand),EFFEKT_DEPOT,0),7),0)","v":9}]
[]
[null,"depotlader, pris (ex moms)","kr./stk.",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),1)","v":440000}]
[]
[null,"depotlader, installation (ex moms)","kr./første lader",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),2)","v":234000}]
[]
[null,"depotlader, installation (ex moms)","kr./anden lader",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),3)","v":139000}]
[]
[null,"depotlader, nettilslutning","Ampere",null,null,null,{"$f":"IF(nLadDepVær>0,nLadDepVær,nLadDepStand)*INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),4)","v":2016}]
[]
[null,"depotlader, nettilslutning (ex moms)","kr./Amp.",null,null,null,{"$f":"AmpPris","v":1000}]
[]
[null,"depotlader, service (ex moms)","kr./stk./år",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),6)","v":4000}]
[]
[null,"ladeeffekt, byrum","kW/lader",null,null,null,{"$f":"IF(drivmiddel=ElBy,kW_450,0)","v":0}]
[]
[null,"antal ladere, byrum","stk.",null,null,null,{"$f":"ROUNDUP((BusAnt-ROUNDUP(BusAnt/ResBusAnd,0))*LadPerBus+1,0)","v":4}]
[]
[null,"byrumlader, pris (ex moms)","kr./lader",null,null,null,{"$f":"INDEX(ByPris,MATCH(EffBy,EFFEKT_BYRUM,0),1)","v":{"$error":"#N/A"}}]
[]
[null,"byrumlader, service (ex moms)","kr./lader",null,null,null,{"$f":"INDEX(ByPris,MATCH(EffBy,EFFEKT_BYRUM,0),2)","v":{"$error":"#N/A"}}]
[]
[null,"DRIVMIDLER MV"]
[null,"diesel (inkl. moms)","kr./l",null,null,null,{"$f":"DieselPris","v":8}]
[]
[null,"HVO (inkl. moms)","kr./l",null,null,null,{"$f":"HVOPris","v":13.5}]
[]
[null,"el (inkl. moms)","kr./kWh",null,null,null,{"$f":"ElPris","v":0.8}]
[]
[null,"biogas (inkl. moms)","kr./Nm3",null,null,null,{"$f":"BiogasPris","v":7.5}]
[]
[null,"AdBlue, pris","kr./l",null,null,null,{"$f":"AddBluPris","v":2}]
[]
[null,"AdBlue, forbrug","% dieselforbrug",null,null,null,{"$f":"AddBluFor","v":7.0000000000000007E-2}]
[]
[null,"olie, pris","kr./l",null,null,null,{"$f":"OliePri","v":63}]
[]
[null,"olie, forbrug","% dieselforbrug",null,null,null,{"$f":"OlieFor","v":2E-3}]
[]
[null,"dæk","kr./stk.",null,null,null,{"$f":"DækPri","v":2500}]
[]
[null,"dæk, levetid","km",null,null,null,{"$f":"DækLeve","v":100000}]
[]
[null,"merpris for ønsket løsning","kr./år",null,null,null,{"$f":"MerPrisÅr","v":3573398.8173943907}]
[]
[null,"merpris for ønsket løsning","kr. i projektperiode",null,null,null,{"$f":"MerPrisPer","v":42880785.808732688}]
[]
[null,"støtteberettiget beløb","75% af merpris",null,null,null,{"$f":"StøBel","v":32160589.356549516}]
[]
[null,"egenfinansiering","25% af merpris",null,null,null,{"$f":"EgeFin","v":10720196.452183172}]

{"sheet":"DATA_UDTRÆK","index":2,"n_rows":24,"n_cols":84,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS",null,null,"MERPRIS"]
["merpris for ønsket løsning","kr./år",2668894.5377667248,"merpris for ønsket løsning","kr./år",2745458.2224284038,"merpris for ønsket løsning","kr./år",3024272.7899999991,"merpris for ønsket løsning","kr./år",2931518.1637800038,"merpris for ønsket løsning","kr./år",4111763.1399777681,"merpris for ønsket løsning","kr./år",4272328.2495246455,"merpris for ønsket løsning","kr./år",6113484.4125000089,"merpris for ønsket løsning","kr./år",6012503.6404125094,"merpris for ønsket løsning","kr./år",4775025.733006075,"merpris for ønsket løsning","kr./år",3806932.6430216283,"merpris for ønsket løsning","kr./år",3306232.3732758686,"merpris for ønsket løsning","kr./år",3835975.2455172464,"merpris for ønsket løsning","kr./år",1126180.5342522115,"merpris for ønsket løsning","kr./år",1385590.3554458711,"merpris for ønsket løsning","kr./år",1010091.5549999997,"merpris for ønsket løsning","kr./år",1193435.9485875014,"merpris for ønsket løsning","kr./år",877659.84239370283,"merpris for ønsket løsning","kr./år",737411.05594584532,"merpris for ønsket løsning","kr./år",791095.74624999985,"merpris for ønsket løsning","kr./år",686038.31999999937,"merpris for ønsket løsning","kr./år",3126819.6463296339,"merpris for ønsket løsning","kr./år",4039600.1745745167,"merpris for ønsket løsning","kr./år",3962332.0270270333,"merpris for ønsket løsning","kr./år",3223833.3637621626,"merpris for ønsket løsning","kr./år",5077131.6654828228,"merpris for ønsket løsning","kr./år",4712351.6874419674,"merpris for ønsket løsning","kr./år",1796321.0538549237,"merpris for ønsket løsning","kr./år",2885061.7414395474]
["merpris for ønsket løsning","kr. i projektperiode",32026734.453200698,"merpris for ønsket løsning","kr. i projektperiode",32945498.669140846,"merpris for ønsket løsning","kr. i projektperiode",36291273.479999989,"merpris for ønsket løsning","kr. i projektperiode",35178217.965360045,"merpris for ønsket løsning","kr. i projektperiode",49341157.679733217,"merpris for ønsket løsning","kr. i projektperiode",51267938.994295746,"merpris for ønsket løsning","kr. i projektperiode",73361812.950000107,"merpris for ønsket løsning","kr. i projektperiode",72150043.684950113,"merpris for ønsket løsning","kr. i projektperiode",57300308.7960729,"merpris for ønsket løsning","kr. i projektperiode",45683191.716259539,"merpris for ønsket løsning","kr. i projektperiode",39674788.479310423,"merpris for ønsket løsning","kr. i projektperiode",46031702.946206957,"merpris for ønsket løsning","kr. i projektperiode",13514166.411026537,"merpris for ønsket løsning","kr. i projektperiode",16627084.265350454,"merpris for ønsket løsning","kr. i projektperiode",12121098.659999996,"merpris for ønsket løsning","kr. i projektperiode",14321231.383050017,"merpris for ønsket løsning","kr. i projektperiode",10531918.108724434,"merpris for ønsket løsning","kr. i projektperiode",8848932.6713501438,"merpris for ønsket løsning","kr. i projektperiode",9493148.9549999982,"merpris for ønsket løsning","kr. i projektperiode",8232459.8399999924,"merpris for ønsket løsning","kr. i projektperiode",37521835.755955607,"merpris for ønsket løsning","kr. i projektperiode",48475202.094894201,"merpris for ønsket løsning","kr. i projektperiode",47547984.324324399,"merpris for ønsket løsning","kr. i projektperiode",38686000.365145952,"merpris for ønsket løsning","kr. i projektperiode",40617053.323862582,"merpris for ønsket løsning","kr. i projektperiode",37698813.499535739,"merpris for ønsket løsning","kr. i projektperiode",14370568.43083939,"merpris for ønsket løsning","kr. i projektperiode",23080493.931516379]
["støtteberettiget beløb","75% af merpris",24020050.839900523,"støtteberettiget beløb","75% af merpris",24709124.001855634,"støtteberettiget beløb","75% af merpris",27218455.109999992,"støtteberettiget beløb","75% af merpris",26383663.474020034,"støtteberettiget beløb","75% af merpris",37005868.259799913,"støtteberettiget beløb","75% af merpris",38450954.24572181,"støtteberettiget beløb","75% af merpris",55021359.71250008,"støtteberettiget beløb","75% af merpris",54112532.763712585,"støtteberettiget beløb","75% af merpris",42975231.597054675,"støtteberettiget beløb","75% af merpris",34262393.787194654,"støtteberettiget beløb","75% af merpris",29756091.359482817,"støtteberettiget beløb","75% af merpris",34523777.209655218,"støtteberettiget beløb","75% af merpris",10135624.808269903,"støtteberettiget beløb","75% af merpris",12470313.19901284,"støtteberettiget beløb","75% af merpris",9090823.9949999973,"støtteberettiget beløb","75% af merpris",10740923.537287513,"støtteberettiget beløb","75% af merpris",7898938.5815433254,"støtteberettiget beløb","75% af merpris",6636699.5035126079,"støtteberettiget beløb","75% af merpris",7119861.7162499987,"støtteberettiget beløb","75% af merpris",6174344.8799999943,"støtteberettiget beløb","75% af merpris",28141376.816966705,"støtteberettiget beløb","75% af merpris",36356401.57117065,"støtteberettiget beløb","75% af merpris",35660988.243243299,"støtteberettiget beløb","75% af merpris",29014500.273859464,"støtteberettiget beløb","75% af merpris",30462789.992896937,"støtteberettiget beløb","75% af merpris",28274110.124651805,"støtteberettiget beløb","75% af merpris",10777926.323129542,"støtteberettiget beløb","75% af merpris",17310370.448637284]
["egenfinansiering","25% af merpris",8006683.6133001745,"egenfinansiering","25% af merpris",8236374.6672852114,"egenfinansiering","25% af merpris",9072818.3699999973,"egenfinansiering","25% af merpris",8794554.4913400114,"egenfinansiering","25% af merpris",12335289.419933304,"egenfinansiering","25% af merpris",12816984.748573937,"egenfinansiering","25% af merpris",18340453.237500027,"egenfinansiering","25% af merpris",18037510.921237528,"egenfinansiering","25% af merpris",14325077.199018225,"egenfinansiering","25% af merpris",11420797.929064885,"egenfinansiering","25% af merpris",9918697.1198276058,"egenfinansiering","25% af merpris",11507925.736551739,"egenfinansiering","25% af merpris",3378541.6027566344,"egenfinansiering","25% af merpris",4156771.0663376134,"egenfinansiering","25% af merpris",3030274.6649999991,"egenfinansiering","25% af merpris",3580307.8457625043,"egenfinansiering","25% af merpris",2632979.5271811085,"egenfinansiering","25% af merpris",2212233.167837536,"egenfinansiering","25% af merpris",2373287.2387499996,"egenfinansiering","25% af merpris",2058114.9599999981,"egenfinansiering","25% af merpris",9380458.9389889017,"egenfinansiering","25% af merpris",12118800.52372355,"egenfinansiering","25% af merpris",11886996.0810811,"egenfinansiering","25% af merpris",9671500.0912864879,"egenfinansiering","25% af merpris",10154263.330965646,"egenfinansiering","25% af merpris",9424703.3748839349,"egenfinansiering","25% af merpris",3592642.1077098474,"egenfinansiering","25% af merpris",5770123.4828790948]
[null,"Omkostning ønsket løsning",38705945.514194503,null,"Omkostning ønsket løsning",38563478.233253621,null,"Omkostning ønsket løsning",39061323.766427778,null,"Omkostning ønsket løsning",38749538.174605221,null,"Omkostning ønsket løsning",58196763.011251971,null,"Omkostning ønsket løsning",58066209.167893954,null,"Omkostning ønsket løsning",60198484.283774212,null,"Omkostning ønsket løsning",59806384.558781818,null,"Omkostning ønsket løsning",48534986.615702376,null,"Omkostning ønsket løsning",48753839.749185517,null,"Omkostning ønsket løsning",47066193.255972169,null,"Omkostning ønsket løsning",48782882.351681136,null,"Omkostning ønsket løsning",13062650.023220088,null,"Omkostning ønsket løsning",13836256.035963804,null,"Omkostning ønsket løsning",12946561.043967877,null,"Omkostning ønsket løsning",13644101.629105434,null,"Omkostning ønsket løsning",8970747.2233056203,null,"Omkostning ønsket løsning",9132111.0977606196,null,"Omkostning ønsket løsning",9185795.7880647741,null,"Omkostning ønsket løsning",8779125.7009119168,null,"Omkostning ønsket løsning",42265167.245021366,null,"Omkostning ønsket løsning",40769414.128897995,null,"Omkostning ønsket løsning",43100679.625718765,null,"Omkostning ønsket løsning",39953647.318085641,null,"Omkostning ønsket løsning",33016475.928157572,null,"Omkostning ønsket løsning",32210890.455918826,null,"Omkostning ønsket løsning",29294859.822331782,null,"Omkostning ønsket løsning",30824406.004114296]
[null,"Omkostning dieselreference",36037050.976427779,null,"Omkostning dieselreference",35818020.010825217,null,"Omkostning dieselreference",36037050.976427779,null,"Omkostning dieselreference",35818020.010825217,null,"Omkostning dieselreference",54084999.871274203,null,"Omkostning dieselreference",53793880.918369308,null,"Omkostning dieselreference",54084999.871274203,null,"Omkostning dieselreference",53793880.918369308,null,"Omkostning dieselreference",43759960.882696301,null,"Omkostning dieselreference",44946907.106163889,null,"Omkostning dieselreference",43759960.882696301,null,"Omkostning dieselreference",44946907.106163889,null,"Omkostning dieselreference",11936469.488967877,null,"Omkostning dieselreference",12450665.680517932,null,"Omkostning dieselreference",11936469.488967877,null,"Omkostning dieselreference",12450665.680517932,null,"Omkostning dieselreference",8093087.3809119174,null,"Omkostning dieselreference",8394700.0418147743,null,"Omkostning dieselreference",8394700.0418147743,null,"Omkostning dieselreference",8093087.3809119174,null,"Omkostning dieselreference",39138347.598691732,null,"Omkostning dieselreference",36729813.954323478,null,"Omkostning dieselreference",39138347.598691732,null,"Omkostning dieselreference",36729813.954323478,null,"Omkostning dieselreference",27939344.262674749,null,"Omkostning dieselreference",27498538.768476859,null,"Omkostning dieselreference",27498538.768476859,null,"Omkostning dieselreference",27939344.262674749]
[null,"Merpris i %",7.4059737560447925E-2,null,"Merpris i %",7.6650195114041725E-2,null,"Merpris i %",8.3921206315639096E-2,null,"Merpris i %",8.1844785470944967E-2,null,"Merpris i %",7.6024094476546733E-2,null,"Merpris i %",7.9420338830131679E-2,null,"Merpris i %",0.11303474950634182,null,"Merpris i %",0.11176928560957172,null,"Merpris i %",0.1091186014952365,null,"Merpris i %",8.4698433955193247E-2,null,"Merpris i %",7.5553823782855106E-2,null,"Merpris i %",8.5344587480885678E-2,null,"Merpris i %",9.4347875248461763E-2,null,"Merpris i %",0.11128644772897253,null,"Merpris i %",8.4622304437133894E-2,null,"Merpris i %",9.5853184015286794E-2,null,"Merpris i %",0.10844561550931993,null,"Merpris i %",8.7842454438244719E-2,null,"Merpris i %",9.4237523950764054E-2,null,"Merpris i %",8.4768431095661484E-2,null,"Merpris i %",7.9891457820108716E-2,null,"Merpris i %",0.10998150384312018,null,"Merpris i %",0.10123912403393037,null,"Merpris i %",8.7771568017503784E-2,null,"Merpris i %",0.18171978618215315,null,"Merpris i %",0.17136734890233529,null,"Merpris i %",6.5324236643226619E-2,null,"Merpris i %",0.10326161252445044]
["Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning",null,null,"Anvendte brugerværdier, ønsket løsning"]
["buslinje/kontraktenhed",null,"A16, Roskilde","buslinje/kontraktenhed",null,"A16, Roskilde","buslinje/kontraktenhed",null,"A16, Roskilde","buslinje/kontraktenhed",null,"A16, Roskilde","buslinje/kontraktenhed",null,"A17, 2A","buslinje/kontraktenhed",null,"A17, 2A","buslinje/kontraktenhed",null,"A17, 2A","buslinje/kontraktenhed",null,"A17, 2A","buslinje/kontraktenhed",null,"A17, 18","buslinje/kontraktenhed",null,"A17, 18","buslinje/kontraktenhed",null,"A17, 18","buslinje/kontraktenhed",null,"A17, 18","buslinje/kontraktenhed",null,"A17, Ballerup/Egedal","buslinje/kontraktenhed",null,"A17, Ballerup/Egedal","buslinje/kontraktenhed",null,"A17, Ballerup/Egedal","buslinje/kontraktenhed",null,"A17, Ballerup/Egedal","buslinje/kontraktenhed",null,"A18-2, Glostrup mv","buslinje/kontraktenhed",null,"A18-2, Glostrup mv","buslinje/kontraktenhed",null,"A18-2, Glostrup mv","buslinje/kontraktenhed",null,"A18-2, Glostrup mv","buslinje/kontraktenhed",null,"A18-5, Slagelse","buslinje/kontraktenhed",null,"A18-5, Slagelse","buslinje/kontraktenhed",null,"A18-5, Slagelse","buslinje/kontraktenhed",null,"A18-5, Slagelse","buslinje/kontraktenhed",null,"A18-9+10, Nykøbing Falster","buslinje/kontraktenhed",null,"A18-9+10, Nykøbing Falster","buslinje/kontraktenhed",null,"A18-9+10, Nykøbing Falster","buslinje/kontraktenhed",null,"A18-9+10, Nykøbing Falster"]
["buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"18-18,8","buslængde",null,"18-18,8","buslængde",null,"18-18,8","buslængde",null,"18-18,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8","buslængde",null,"11,9-12,8"]
["kørselstype",null,"Bybusser, provins/forstad","rutekm","km/år",1343192.7440000004,"kørselstype",null,"Bybusser, provins/forstad","rutekm","km/år",1343192.7440000004,"kørselstype",null,"Bybusser, København","rutekm","km/år",1652921.963,"kørselstype",null,"Bybusser, København","rutekm","km/år",1652921.963,"kørselstype",null,"Bybusser, København","rutekm","km/år",1699019.2,"kørselstype",null,"Bybusser, København","rutekm","km/år",1699019.2,"kørselstype",null,"Bybusser, provins/forstad","rutekm","km/år",546820.59499999997,"kørselstype",null,"Bybusser, provins/forstad","rutekm","km/år",546820.59499999997,"kørselstype",null,"Bybusser, provins/forstad","rutekm","km/år",372409.56000000006,"rutekm","km/år",372409.56000000006,"kørselstype",null,"Bybusser, provins/forstad","kørselstype",null,"Landevejsbusser","rutekm","km/år",1756728.0480000002,"kørselstype",null,"Landevejsbusser","rutekm","km/år",1756728.0480000002,"kørselstype",null,"Landevejsbusser","rutekm","km/år",1378853.9980000001,"rutekm","km/år",1378853.9980000001,"kørselstype",null,"Landevejsbusser"]
["kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, provins/forstad","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, provins/forstad","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, København","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, København","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, København","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, København","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, provins/forstad","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Bybusser, provins/forstad","kontraktlængde (afskrivning)","år",12,"tomkørsel","%",5.1181553985885857E-2,"tomkørsel","%",5.1181553985885857E-2,"kontraktlængde (afskrivning)","år",12,"kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Landevejsbusser","kontraktlængde (afskrivning)","år",12,"kørselstype",null,"Landevejsbusser","kontraktlængde (afskrivning)","år",8,"tomkørsel","%",5.6000000000000001E-2,"tomkørsel","%",5.6000000000000001E-2,"kontraktlængde (afskrivning)","år",8]
["projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kørselstype",null,"Bybusser, provins/forstad","kørselstype",null,"Bybusser, provins/forstad","projektlængde","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",12,"kontraktlængde (afskrivning)","år",12,"projektlængde","år",8,"kørselstype",null,"Landevejsbusser","kørselstype",null,"Landevejsbusser","projektlængde","år",8]
["køreplanstimer","t/år",62986,"projektlængde","år",12,"køreplanstimer","t/år",62986,"projektlængde","år",12,"køreplanstimer","t/år",88457,"projektlængde","år",12,"køreplanstimer","t/år",88457,"projektlængde","år",12,"køreplanstimer","t/år",77073,"projektlængde","år",12,"køreplanstimer","t/år",77073,"projektlængde","år",12,"køreplanstimer","t/år",21037,"projektlængde","år",12,"køreplanstimer","t/år",21037,"projektlængde","år",12,"køreplanstimer","t/år",14288,"kontraktlængde (afskrivning)","år",12,"kontraktlængde (afskrivning)","år",12,"køreplanstimer","t/år",14288,"køreplanstimer","t/år",61690,"projektlængde","år",12,"køreplanstimer","t/år",61690,"projektlængde","år",12,"køreplanstimer","t/år",43362,"kontraktlængde (afskrivning)","år",8,"kontraktlængde (afskrivning)","år",8,"køreplanstimer","t/år",43362]
["drivmiddel",null,"Elbus, depot","køreplanstimer","t/år",62986,"drivmiddel",null,"HVO","køreplanstimer","t/år",62986,"drivmiddel",null,"Elbus, endestation","køreplanstimer","t/år",88457,"drivmiddel",null,"HVO","køreplanstimer","t/år",88457,"drivmiddel",null,"Elbus, depot","køreplanstimer","t/år",77073,"drivmiddel",null,"HVO","køreplanstimer","t/år",77073,"drivmiddel",null,"Elbus, depot","køreplanstimer","t/år",21037,"drivmiddel",null,"HVO","køreplanstimer","t/år",21037,"drivmiddel",null,"Elbus, depot","projektlængde","år",12,"projektlængde","år",12,"drivmiddel",null,"HVO","drivmiddel",null,"Elbus, depot","køreplanstimer","t/år",61690,"drivmiddel",null,"HVO","køreplanstimer","t/år",61690,"drivmiddel",null,"Elbus, depot","projektlængde","år",8,"projektlængde","år",8,"drivmiddel",null,"HVO"]
["bus, driftsbusser, antal","stk.",17,"drivmiddel",null,"Elbus, depot","bus, driftsbusser, antal","stk.",17,"drivmiddel",null,"HVO","bus, driftsbusser, antal","stk.",18,"drivmiddel",null,"Elbus, endestation","bus, driftsbusser, antal","stk.",18,"drivmiddel",null,"HVO","bus, driftsbusser, antal","stk.",23,"drivmiddel",null,"Elbus, depot","bus, driftsbusser, antal","stk.",23,"drivmiddel",null,"HVO","bus, driftsbusser, antal","stk.",5,"drivmiddel",null,"Elbus, depot","bus, driftsbusser, antal","stk.",5,"drivmiddel",null,"HVO","bus, driftsbusser, antal","stk.",3,"køreplanstimer","t/år",14288,"køreplanstimer","t/år",14288,"bus, driftsbusser, antal","stk.",3,"bus, driftsbusser, antal","stk.",16,"drivmiddel",null,"Elbus, depot","bus, driftsbusser, antal","stk.",16,"drivmiddel",null,"HVO","bus, driftsbusser, antal","stk.",13,"køreplanstimer","t/år",43362,"køreplanstimer","t/år",43362,"bus, driftsbusser, antal","stk.",13]
["Anvendte brugerværdier, dieselreference",null,null,"bus, driftsbusser, antal","stk.",17,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",17,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",18,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",18,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",23,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",23,"klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",5,"klimaanlæg",null,"nej","bus, driftsbusser, antal","stk.",5,"klimaanlæg",null,"ja","drivmiddel",null,"Elbus, depot","drivmiddel",null,"HVO","klimaanlæg",null,"nej","klimaanlæg",null,"ja","bus, driftsbusser, antal","stk.",16,"klimaanlæg",null,"nej","bus, driftsbusser, antal","stk.",16,"klimaanlæg",null,"ja","drivmiddel",null,"Elbus, depot","drivmiddel",null,"HVO","klimaanlæg",null,"nej"]
[null,null,null,"bus, total, antal","stk.",20,"Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"ja","Anvendte brugerværdier, dieselreference",null,null,"bus, total, antal","stk.",21,"Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"ja","Anvendte brugerværdier, dieselreference",null,null,"bus, total, antal","stk.",27,"Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"ja","Anvendte brugerværdier, dieselreference",null,null,"bus, total, antal","stk.",8,"Anvendte brugerværdier, dieselreference",null,null,"Anvendte brugerværdier, dieselreference",null,null,"Anvendte brugerværdier, dieselreference",null,null,"bus, driftsbusser, antal","stk.",3,"bus, driftsbusser, antal","stk.",3,"Anvendte brugerværdier, dieselreference",null,null,"Anvendte brugerværdier, dieselreference",null,null,"bus, total, antal","stk.",22,"Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"nej","Anvendte brugerværdier, dieselreference",null,null,"bus, driftsbusser, antal","stk.",13,"bus, driftsbusser, antal","stk.",13,"Anvendte brugerværdier, dieselreference"]
[null,null,null,"klimaanlæg",null,"ja",null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"klimaanlæg",null,"ja","klimaanlæg",null,"ja","Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"nej","Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"nej","klimaanlæg",null,"nej","klimaanlæg",null,"nej","bus, total, antal","stk.",5,"klimaanlæg",null,"nej","klimaanlæg",null,"nej","klimaanlæg",null,"nej","klimaanlæg",null,"ja","klimaanlæg",null,"nej","Anvendte brugerværdier, dieselreference",null,null,"buslængde",null,"9-11,8","bus, total, antal","stk.",17,"klimaanlæg",null,"nej","buslængde",null,"9-11,8"]
[null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,"klimaanlæg",null,"nej",null,null,null,null,null,null,null,null,null,"Anvendte brugerværdier, dieselreference",null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,null,null,null,"Anvendte brugerværdier, dieselreference",null,null,null,null,null,"buslængde",null,"11,9-12,8","klimaanlæg",null,"nej","klimaanlæg",null,"ja","Anvendte brugerværdier, dieselreference",null,null,"klimaanlæg",null,"nej"]
[null,null,null,"klimaanlæg",null,"ja",null,null,null,null,null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,null,null,null,null,null,null,"klimaanlæg",null,"ja",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"klimaanlæg",null,"nej","klimaanlæg",null,"nej",null,null,null,null,null,null,"buslængde",null,"11,9-12,8",null,null,null,"klimaanlæg",null,"nej",null,null,null,"Anvendte brugerværdier, dieselreference",null,null,"buslængde",null,"9-11,8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"klimaanlæg",null,"nej",null,null,null,null,null,null,null,null,null,"buslængde",null,"9-11,8","klimaanlæg",null,"nej"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"klimaanlæg",null,"nej"]

{"sheet":"BEREGNINGSARK","index":3,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["RUTEDATA"]
["buslinje/kontraktenhed",null,{"$f":"BusLinVær","v":"A16, Roskilde"}]
["buslængde",null,{"$f":"buslægdeØ","v":"11,9-12,8"},{"$f":"IF(buslægdeRef>0,buslægdeRef,BusLænrefStan)","v":"11,9-12,8"},null,null,"Indtastet værdi"]
["rutekm","km/år",{"$f":"IF(RutKmØnsVær>0,RutKmØnsVær,RutKmØnsStan)","v":1343192.7440000004},{"$f":"IF(RutKmRefVær>0,RutKmRefVær,RutKmRefStan)","v":1343192.7440000004},null,null,"Beregninget værdi"]
["årskørsel","km/bus/år",{"$f":"kmÅrØnsStan","v":75218.793664000026},{"$f":"kmÅrRefStan","v":79177.677541052661},null,null,"Summeret budgetpost (beregnet værdi)"]
["tomkørsel","%",{"$f":"IF(TomKmVær>0,TomKmVær,TomKmStan)","v":0.12},null,null,null,"Total omkostning per år"]
["kørselstype",null,{"$f":"kørselØ","v":"Landevejsbusser"}]
["kontraktlængde (afskrivning)","år",{"$f":"kontraktlængdeØ","v":12},{"$f":"IF(kontraktlængdeRef>0,kontraktlængdeRef,KonLænRef)","v":12}]
["projektlængde","år",{"$f":"ProjLæn","v":12}]
["køreplanstimer","t/år",{"$f":"TimÅrØns","v":62986},{"$f":"IF(TimÅrRef>0,TimÅrRef,TimÅrRefStan)","v":62986}]
["rente","% pa",{"$f":"IF(RentePAVær<>\"\",RentePAVær,RentePAStand)","v":0.02},{"$f":"RentePAStand","v":0.02}]
["drivmiddel",null,{"$f":"drivmiddel","v":"Elbus, depot"},"DIESEL"]
["BUSMATERIEL"]
["bus, driftsbusser, antal","stk.",{"$f":"DriBusVær","v":17}]
["bus, total, antal","stk.",{"$f":"IF(busantalØ>0,busantalØ,BusAntStan)","v":20},{"$f":"IF(busantalRef>0,busantalRef,BusAntRefStan)","v":19}]
["bus, pris","kr./bus",{"$f":"IF(BusØnsPrisVær>0,BusØnsPrisVær,BusØnsPrisRef)","v":3175000},{"$f":"IF(BusrefPrisVær>0,BusrefPrisVær,BusRefPrisStand)","v":1675000}]
["klimaanlæg",null,{"$f":"IF(KlimaØnsVærd<>\"\",KlimaØnsVærd,KlimaØnsStand)","v":"ja"},{"$f":"IF(klimaRef=\"ja\",klimaRef,IF(klimaRef=\"nej\",klimaRef,KlimaRefStand))","v":"ja"}]
["moms","kr./bus",{"$f":"0.25*C16","v":793750},{"$f":"0.25*D16","v":418750}]
["momsfradrag","kr./bus",{"$f":"-IF(MomsFradrVær>0,MomsFradrVær,MomsFradStand)*C18","v":-396875},{"$f":"-IF(MomsFradrVær>0,MomsFradrVær,MomsFradStand)*D18","v":-209375}]
["busser, investering","kr.",{"$f":"(BusPriØns+BusMomØns+BusMomFraØns)*BusAnt","v":71437500},{"$f":"(BusPriRef++BusMomref+BusMomFraRef)*BusAntRef","v":35803125}]
["ydelse","kr./år",{"$f":"-PMT(C11,C8,C20)","v":6755101.1837520963},{"$f":"-PMT($D11,$D8,$D20)","v":3385529.0578411091}]
["restværdi","kr./bus",{"$f":"-IF(RestØnsVær>0,RestØnsVær,RestØnsStand)","v":-279375},{"$f":"-IF(RestRefVær>0,RestRefVær,RestRefStand)","v":-41875}]
["restværdi","kr./år",{"$f":"C15*C22/C8","v":-465625},{"$f":"D15*D22/D8","v":-66302.083333333328}]
["forsikring","kr./år/bus",{"$f":"IF(ForsØnsVær>0,ForsØnsVær,ForsØnsStand)","v":38100},{"$f":"IF(ForsRefVær>0,ForsRefVær,ForsRefStand)","v":20100}]
["forsikring","kr./år",{"$f":"C15*C24","v":762000},{"$f":"D15*D24","v":381900}]
["batteriudskiftning","kr./bus",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),IF(BatUdVær>0,BatUdVær,BatUdStand),0)","v":600000}]
["batteriudskiftning","kr./år",{"$f":"C15*C26/C8","v":1000000}]
["LADE-/FYLDESTATION, DEPOT"]
["ladere, effekt","kW",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),IF(kWdepVær>0,kWdepVær,kWdepStand),0)","v":"150 (2*75)"}]
["ladere","stk.",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),IF(nLadDepVær>0,nLadDepVær,nLadDepStand),0)","v":9}]
["lader, pris","kr./stk.",{"$f":"IF(DepPrisVær>0,DepPrisVær,DepPrisStand)","v":440000}]
["ladere, investering","kr.",{"$f":"C30*C31","v":3960000}]
["1. lader, installation","kr./lader",{"$f":"IF(DepIns1LadVær>0,DepIns1LadVær,DepIns1LadStan)","v":234000}]
["2. lader, installation","kr./lader",{"$f":"IF(DepIns2LadVær>0,DepIns2LadVær,DepIns2LadStan)","v":139000}]
["installation, ladere","kr.",{"$f":"C33+(C30-1)*C34","v":1346000}]
["nettilslutning","Amp.",{"$f":"IF(DepLadEffVær>0,DepLadEffVær,DepLadEffStan)","v":2016}]
["nettilslutning","kr./Amp.",{"$f":"IF(AmpPrisVær>0,AmpPrisVær,AmpPrisStand)","v":1000}]
["nettilslutning","kr.",{"$f":"DepLadEff*C37","v":2016000}]
["pris, anlæg","kr.",{"$f":"C32+C35+C38","v":7322000}]
["moms","kr.",{"$f":"0.25*C39","v":1830500}]
["momsfradrag","kr.",{"$f":"-IF(MomsFradrVær>0,MomsFradrVær,MomsFradStand)*C40","v":-915250}]
["ladere, depot, ydelse","kr./år",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),-PMT(C11,C8,(SUM(C39:C41))),0)","v":778911.03728240705}]
["lader, service","kr./stk./år",{"$f":"IF(DepSerVær>0,DepSerVær,DepSerStan)","v":4000}]
["lader, service","kr./år",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),DepLadStk*C43,0)","v":36000}]
["ladetab","%",{"$f":"IF(LadTabVær>0,LadTabVær,LadTabStan)","v":0.05}]
["LADESTATION, BYRUM"]
["ladestation, byrum, effekt","kW",{"$f":"IF(kWbyVær>0,kWbyVær,kWbyStan)","v":0}]
["ladestation, byrum ","stk.",{"$f":"IF(nLadByVær>0,nLadByVær,nLadByStand)","v":4}]
["ladestation, byrum","kr./stk.",{"$f":"IF(ByPrisVær>0,ByPrisVær,ByPrisStand)","v":{"$error":"#N/A"}}]
["ladestation, byrum, investering","kr.",{"$f":"C48*C49","v":{"$error":"#N/A"}}]
["ladestation, ydelse","kr./år",{"$f":"IF(drivmiddel=ElBy,-PMT(C11,C8,C50),0)","v":0}]
["ladestation, service","kr./lader/år",{"$f":"IF(drivmiddel=ElBy,IF(BySerVær>0,BySerVær,BySerStand),0)","v":0}]
["ladestation, service","kr./år",{"$f":"IF(drivmiddel=ElBy,C48*C52,0)","v":0}]
["DRIVMIDDEL"]
["el, pris (inkl. moms)","kr./kWh",{"$f":"IF(ElVærd>0,ElVærd,ElStand)","v":0.8}]
["el, forbrug","km/kWh",{"$f":"IF(ØnsForBrVæ>0,ØnsForBrVæ,ØnsForStand)*(1+LadTab)","v":1.3886249999999998}]
["el, forbrug","kWh/år",{"$f":"BusAnt*kmÅrØns*ForEl","v":2089013.9470334402}]
["el, omkostning (inkl. moms)","kr./år",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),C57*C55,0)","v":1671211.1576267523}]
["HVO-forbrug, opvarmning","l/km",{"$f":"IF(OR(drivmiddel=ElDep,drivmiddel=ElBy),IF(ForOpvVær>0,ForOpvVær,ForOpvStand),0)","v":1.6666666666666666E-2}]
["HVO-forbrug, opvarmning","l/år",{"$f":"BusAnt*HVOkmOpv*kmÅrØns","v":25072.93122133334}]
["HVO-forbrug, opvarmning","kr./år",{"$f":"IF(ISNUMBER(C60),C60*PriHVO,0)","v":338484.5714880001}]
["diesel, pris (inkl. moms)","kr./l",null,{"$f":"IF(DieselVær>0,DieselVær,DieselStand)","v":8}]
["diesel, forbrug","km/l ",{"$f":"INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),MATCH(buslægdeØ,BUSLÆNGDE,0),5,MATCH(kørselØ,KØRSELSTYPE,0))","v":3.7},{"$f":"IF(RefForBrVæ>0,RefForBrVæ,RefForStand)","v":3.7}]
["diesel, forbrug","l/år",{"$f":"BusAnt*kmÅrØns/DieForØns","v":406588.07385945955},{"$f":"BusAntRef*kmÅrRef/D63","v":406588.0738594596}]
["diesel, omkostning (inkl. moms)","kr./år",null,{"$f":"D64*D62","v":3252704.5908756768}]
["HVO, pris (inkl. moms)","kr./l",{"$f":"IF(HVOVær>0,HVOVær,HVOStand)","v":13.5}]
["HVO, forbrug","km/l ",{"$f":"IF(ØnsForBrVæ>0,ØnsForBrVæ,ØnsForStand)","v":1.3224999999999998}]
["HVO, forbrug","l/år",{"$f":"BusAnt*kmÅrØns/ForHVO","v":1137524.2898147453}]
["HVO, omkostning (inkl. moms)","kr./år",{"$f":"IF(drivmiddel=HVO,PriHVO*C68,0)","v":0}]
["CNG m bionaturgascertifikat, pris (inkl. moms)","kr./Nm3",{"$f":"IF(BioVær>0,BioVær,BioStand)","v":7.5}]
["CNG m bionaturgascertifikat, forbrug","km/Nm3",{"$f":"IF(ØnsForBrVæ>0,ØnsForBrVæ,ØnsForStand)","v":1.3224999999999998}]
["CNG m bionaturgascertifikat, forbrug","Nm3/år",{"$f":"BusAnt*kmÅrØns/C71","v":1137524.2898147453}]
["CNG m bionaturgascertifikat, omkostning (inkl. moms)","kr./år",{"$f":"IF(drivmiddel=Biogas,BEREGNINGSARK!C72*BEREGNINGSARK!C70,0)","v":0}]
["ADDITIV"]
["AdBlue",{"$f":"B66","v":"kr./l"},{"$f":"IF(AdBluVær>0,AdBluVær,AdBluStan)","v":2},{"$f":"IF(AdBluVær>0,AdBluVær,AdBluStan)","v":2}]
["AdBlueforbrug af dieselforbrug (km/l)","%",{"$f":"IF(AdBluForVær>0,AdBluForVær,AdBluForStan)","v":7.0000000000000007E-2},{"$f":"IF(AdBluForVær>0,AdBluForVær,AdBluForStan)","v":7.0000000000000007E-2}]
["AdBlue","l/år",{"$f":"C64*C76","v":28461.16517016217},{"$f":"D64*D76","v":28461.165170162174}]
["AdBlue","kr./år",{"$f":"IF(AND(drivmiddel<>ElDep,drivmiddel<>ElBy),C77*C75,0)","v":0},{"$f":"D77*D75","v":56922.330340324348}]
["OLIE"]
["Olie","kr/l",{"$f":"IF(OliPriVær>0,OliPriVær,OliPriStan)","v":63},{"$f":"IF(OliPriVær>0,OliPriVær,OliPriStan)","v":63}]
["Olieforbrug af dieselforbrug (km/l)","%",{"$f":"IF(OliForVær>0,OliForVær,OliForStan)","v":2E-3},{"$f":"IF(OliForVær>0,OliForVær,OliForStan)","v":2E-3}]
["Olie","l/år",{"$f":"C81*C64","v":813.17614771891908},{"$f":"D81*D64","v":813.1761477189192}]
["Olie","kr/år",{"$f":"IF(AND(drivmiddel<>ElDep,drivmiddel<>ElBy),C82*C80,0)","v":0},{"$f":"D82*D80","v":51230.097306291907}]
["DÆK"]
["Dæk levetid","km",{"$f":"D85","v":100000},{"$f":"IF(DækLevVær>0,DækLevVær,DækLevStand)","v":100000}]
["Pris pr. dæk","kr./stk.",{"$f":"D86","v":2500},{"$f":"IF(DækPriVær>0,DækPriVær,DækPriStan)","v":2500}]
["dæk/køretøj","stk.",{"$f":"INDEX(nDæk,MATCH(buslægdeØ,BUSLÆNGDE,0))","v":6},{"$f":"INDEX(nDæk,MATCH(BusLænRef,BUSLÆNGDE,0))","v":6}]
["Årligt dækforbrug/bus","%",{"$f":"C5/C85","v":0.75218793664000028},{"$f":"D5/D85","v":0.7917767754105266}]
["Dæk  ","kr./år",{"$f":"BusAnt*C86*C87*C88","v":225656.38099200008},{"$f":"BusAntRef*D86*D87*D88","v":225656.38099200008}]
["SERVICE"]
["service","kr./km",{"$f":"IF(SerØnsVær>0,SerØnsVær,SerØnsStan)","v":1.4400000000000002},{"$f":"IF(SerRefVær>0,SerRefVær,SerRefStan)","v":1.6}]
["service","kr./år",{"$f":"BusAnt*C91*C5","v":2166301.2575232009},{"$f":"BusAntRef*D91*D5","v":2407001.3972480008}]
["skader","kr./bus/år",{"$f":"IF(SkaØnsVær>0,SkaØnsVær,SkaØnsStan)","v":15043.758732800006},{"$f":"IF(SkaRefVær>0,SkaRefVær,SkaRefStan)","v":15835.535508210532}]
["skader","kr./år",{"$f":"BusAnt*SkaBusØns","v":300875.1746560001},{"$f":"BusAntRef*SkaBusRef","v":300875.1746560001}]
["CHAUFFØRLØN"]
["chaufførløn","kr./driftstime",{"$f":"IF(ChalønVær>0,ChalønVær,ChaLønStan)","v":400},{"$f":"IF(ChalønVær>0,ChalønVær,ChaLønStan)","v":400}]
["chaufførløn","kr./år",{"$f":"C10*C96","v":25194400},{"$f":"D10*D96","v":25194400}]
["SAMLET"]
["samlet årlig omkostning","kr./år",{"$f":"BusYdeØns+ResVærØns+ForPriØns+BatUdsPri+LadDepPri+LadDepSer+LadByPri+LadBySer+ElPriØns+HVOOpvØns+HVOPriØns+CNGPriØns+AddPriØns+OliPriØns+DækPriØns+SerPriØns+SkaBusÅrØns+ChaPriØns","v":38763315.763320461},{"$f":"BusYdeRef+ResVærRef+ForPriRef+DiePriRef+AddPriRef+OliPriRef+DækPriRef+SerPriRef+SkaBusÅrRef+ChaPriRef","v":35189916.94592607}]
["MERPRIS"]
["merpris for ønsket løsning","kr./år",{"$f":"C99-D99","v":3573398.8173943907}]
["merpris for ønsket løsning","kr. i projektperiode",{"$f":"C9*C101","v":42880785.808732688}]
["støtteberettiget beløb","75% af merpris",{"$f":"0.75*MerPrisPer","v":32160589.356549516}]
["egenfinansiering","25% af merpris",{"$f":"0.25*MerPrisPer","v":10720196.452183172}]

{"sheet":"LISTER","index":4,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["KØRSELSTYPE",null,"ØNSKET LØSNING",null,null,"BUSLÆNGDE",null,"KLIMAANLÆG",null,null,"LADEEFFEKT, DEPOT",null,"LADEEFFEKT, BYRUM"]
["Bybusser, provins/forstad",null,"HVO","km/l",null,"9-11,8",null,"ja",null,null,50,null,150]
["Bybusser, København",null,"Elbus, depot","kWh/km",null,"11,9-12,8",null,"nej",null,null,"60 (2*30)",null,300]
["Landevejsbusser",null,"Elbus, endestation","kWh/km",null,"12,9-13,2",null,null,null,null,80,null,450]
[null,null,"Biogas","km/Nm3",null,"13,7",null,null,null,null,"150 (2*75)"]
[null,null,null,null,null,"14,5-15"]
[null,null,null,null,null,"18-18,8"]

{"sheet":"INPUT_DATA","index":5,"n_rows":199,"n_cols":96,"rows_kept":199,"cut":false,"hidden":false,"merged":[[119,12,119,13],[119,10,119,11],[119,2,119,3],[119,4,119,5],[119,6,119,7],[119,8,119,9]]}
["AFSKRIVNING"]
["år",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["bus",0.6399999999999999,0.54999999999999993,0.47499999999999998,0.39,0.3,0.22,0.16,9.9999999999999992E-2,0.06,0.05,0.04,2.5000000000000001E-2,0.01,0,0]
["batteri",0,0,0,0,0,0,0,0,{"$f":"5/6","v":0.83333333333333337},{"$f":"4/6","v":0.66666666666666663},{"$f":"3/6","v":0.5},{"$f":"2/6","v":0.33333333333333331},{"$f":"1/6","v":0.16666666666666666},0,0]
[]
["BATTERIUDSKIFTNING"]
["år+",8,"9-11,8","11,9-12,8","12,9-13,2",13.7,"14,5-15","18-18,8"]
["kWh",800000,600000,600000,600000,675000,675000,750000]
[]
["BUSPRIS, EKSKL. MOMS",null,null,"300 kW",null,null,"450 kW"]
["BUSLÆNGDE","HVO","Elbus, depot","Elbus, endestation","Biogas","Klimaanlæg","Tillæg til elbus, endestation"]
["9-11,8",1600000,3100000,3100000,{"$f":"B12+250000","v":1850000},75000,200000]
["11,9-12,8",1600000,3100000,3100000,1850000,75000,200000]
["12,9-13,2",1800000,3400000,3400000,2050000,75000,200000]
[13.7,2000000,3800000,3800000,2250000,75000,200000]
["14,5-15",2100000,4000000,4000000,2350000,75000,200000]
["18-18,8",2300000,4500000,4500000,2550000,75000,200000]
[]
[]
["FORSIKRING, % NYPRIS PER ÅR"]
[1.2E-2]
[]
["PRIS, DEPOTLADERE, EKSKL. MOMS"]
["kW","PRIS","INSTALLATION",null,"AMPERE","PRIS AMPERE","SERVICE","LADERE"]
[null,null,"FØRSTE","EFTERFØLGENDE",null,null,null,"stk."]
[50,250000,{"$f":"155000","v":155000},{"$f":"85000","v":85000},80,{"$f":"E26*1000","v":80000},2000,1]
["60 (2*30)",285000,{"$f":"175000","v":175000},{"$f":"90000","v":90000},100,{"$f":"E27*1000","v":100000},3000,0.5]
[80,285000,{"$f":"175000","v":175000},{"$f":"90000","v":90000},125,125000,3000,1]
["150 (2*75)",440000,{"$f":"234000","v":234000},{"$f":"139000","v":139000},224,224000,4000,0.5]
[]
["AMPERE, PRIS , kr./Amp., ekskl. moms"]
[1000]
[]
["LADETABt"]
[null,"Depot","By"]
["%",0.05,0.05]
[]
["PRIS, BYRUMSLADERE"]
["kW","PRIS, kr./stk., inkl. installation, inkl. moms","SERVICE,  kr./pr./stk","Ladere/bus, 1+"]
[150,2792000,91500,{"$f":"1/6","v":0.16666666666666666}]
[300,3114000,91500]
[450,3789000,99000]
[]
["BYBUSSER, PROVINS",null,null,null,null,null,"KABINEVARME"]
["BUSLÆNGDE","HVO","Elbus, depot","Elbus, endestation","Biogas","Diesel","l HVO/km (depot)"]
["9-11,8",{"$f":"F46*0.96","v":2.976},1.1000000000000001,1.3,2.6,3.1,{"$f":"0.019/0.96","v":1.9791666666666666E-2}]
["11,9-12,8",2.88,1.1499999999999999,1.4,2.5,3,{"$f":"0.02/0.96","v":2.0833333333333336E-2}]
["12,9-13,2",2.7839999999999998,1.2,1.45,2.4,2.9,{"$f":"0.022/0.96","v":2.2916666666666665E-2}]
[13.7,2.1120000000000001,{"$f":"1.2*1.25","v":1.5},1.75,2.2000000000000002,2.2000000000000002,{"$f":"0.023/0.96","v":2.3958333333333335E-2}]
["14,5-15",2.016,{"$f":"1.6","v":1.6},1.85,2.1,2.1,{"$f":"0.024/0.96","v":2.5000000000000001E-2}]
["18-18,8",1.8239999999999998,1.9,2.2000000000000002,1.8,1.9,{"$f":"0.025/0.96","v":2.6041666666666668E-2}]
[]
["BYBUSSER, KØBENAVN",null,null,null,null,null,"KABINEVARME"]
["BUSLÆNGDE","HVO","Elbus, depot","Elbus, endestation","Biogas","Diesel","l HVO/km (depot)"]
["9-11,8",{"$f":"F55*0.96","v":2.88},1.2,1.4,2.2999999999999998,3,{"$f":"0.019/0.96","v":1.9791666666666666E-2}]
["11,9-12,8",2.7839999999999998,1.25,1.5,2.2000000000000002,2.9,{"$f":"0.02/0.96","v":2.0833333333333336E-2}]
["12,9-13,2",2.6879999999999997,1.3,1.55,2.1,2.8,{"$f":"0.022/0.96","v":2.2916666666666665E-2}]
[13.7,1.92,1.6,1.85,1.9,2,{"$f":"0.023/0.96","v":2.3958333333333335E-2}]
["14,5-15",1.8239999999999998,1.7,2,1.8,1.9,{"$f":"0.024/0.96","v":2.5000000000000001E-2}]
["18-18,8",1.728,2,2.2999999999999998,1.5,1.8,{"$f":"0.025/0.96","v":2.6041666666666668E-2}]
[]
["LANDEVEJSBUSSER",null,null,null,null,null,"KABINEVARME"]
["BUSLÆNGDE","HVO","Elbus, depot","Elbus, endestation","Biogas","Diesel","l HVO/km (depot)"]
["9-11,8",{"$f":"F64*0.96","v":3.6479999999999997},{"$f":"115%*C46","v":1.2649999999999999},{"$f":"115%*D46","v":1.4949999999999999},{"$f":"E46*1.25","v":3.25},3.8,{"$f":"0.8*0.019/0.96","v":1.5833333333333335E-2}]
["11,9-12,8",3.552,{"$f":"115%*C47","v":1.3224999999999998},1.6099999999999999,3.15,3.7,{"$f":"0.8*0.02/0.96","v":1.6666666666666666E-2}]
["12,9-13,2",3.456,1.38,1.6674999999999998,{"$f":"1.25*E48","v":3},3.6,{"$f":"0.8*0.022/0.96","v":1.8333333333333333E-2}]
[13.7,2.6879999999999997,1.7249999999999999,2.0124999999999997,{"$f":"1.25*E49","v":2.75},2.8,{"$f":"0.8*0.023/0.96","v":1.9166666666666669E-2}]
["14,5-15",2.5920000000000001,1.8399999999999999,2.1274999999999999,{"$f":"E50*1.25","v":2.625},2.7,{"$f":"0.8*0.024/0.96","v":2.0000000000000004E-2}]
["18-18,8",2.4,2.1849999999999996,2.5299999999999998,{"$f":"1.25*E51","v":2.25},2.5,{"$f":"0.8*0.025/0.96","v":2.0833333333333339E-2}]
[]
["MOMSFRADRAG"]
["%",0.5]
[]
["9-11,8","m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11,9-12,8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12,9-13,2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14,5-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18-18,8"]
["Service","1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år",null,"1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år",null,"1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år",null,"1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år",null,"1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år",null,"1 år","2 år","3 år","4 år","5 år","6 år","7 år","8 år","9 år","10 år","11 år","12 år","13 år","14 år","15 år"]
["HVO",{"$f":"S_11*R76","v":0.71999999999999986},0.83999999999999986,0.93999999999999984,1.0299999999999998,1.1099999999999999,1.18,1.25,1.32,1.3900000000000001,1.46,1.53,1.6,1.7000000000000002,1.8200000000000003,1.9700000000000002,null,{"$f":"R80","v":0.71999999999999986},{"$f":"S80","v":0.83999999999999986},0.93999999999999984,1.0299999999999998,1.1099999999999999,1.18,1.25,1.32,1.3900000000000001,1.46,1.53,1.6,1.7000000000000002,1.8200000000000003,1.9700000000000002,null,{"$f":"AH80","v":0.71999999999999986},{"$f":"AI80","v":0.83999999999999986},0.93999999999999984,1.0299999999999998,1.1099999999999999,1.18,1.25,1.32,1.3900000000000001,1.46,1.53,1.6,1.7000000000000002,1.8200000000000003,1.9700000000000002,null,{"$f":"AX80","v":0.82799999999999974},{"$f":"AY80","v":0.96599999999999975},1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"BN80","v":0.82799999999999974},{"$f":"BO80","v":0.96599999999999975},1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"CD80","v":0.86399999999999977},{"$f":"CE80","v":1.0079999999999998},1.1279999999999997,1.2359999999999998,1.3319999999999999,1.4159999999999999,1.5,1.5840000000000001,1.6680000000000001,1.752,1.8359999999999999,1.92,2.04,2.1840000000000002,2.3640000000000003]
["Elbus, depot",0.64799999999999991,0.75599999999999989,0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"0.9*R80","v":0.64799999999999991},{"$f":"0.9*S80","v":0.75599999999999989},0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"0.9*AH80","v":0.64799999999999991},{"$f":"0.9*AI80","v":0.75599999999999989},0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"0.9*AX80","v":0.74519999999999975},{"$f":"0.9*AY80","v":0.86939999999999984},0.97289999999999976,1.0660499999999997,1.1488499999999997,1.2212999999999998,1.29375,1.3662000000000001,1.43865,1.5110999999999999,1.5835499999999998,1.6559999999999999,1.7595000000000001,1.8836999999999999,2.0389499999999998,null,{"$f":"0.9*BN80","v":0.74519999999999975},{"$f":"0.9*BO80","v":0.86939999999999984},0.97289999999999976,1.0660499999999997,1.1488499999999997,1.2212999999999998,1.29375,1.3662000000000001,1.43865,1.5110999999999999,1.5835499999999998,1.6559999999999999,1.7595000000000001,1.8836999999999999,2.0389499999999998,null,{"$f":"0.9*CD80","v":0.77759999999999985},{"$f":"0.9*CE80","v":0.90719999999999978},1.0151999999999997,1.1123999999999998,1.1987999999999999,1.2744,1.35,1.4256000000000002,1.5012000000000001,1.5768,1.6523999999999999,1.728,1.8360000000000001,1.9656000000000002,2.1276000000000002]
["Elbus, endestation",0.64799999999999991,0.75599999999999989,0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"R77","v":0.64799999999999991},{"$f":"S77","v":0.75599999999999989},0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"AH77","v":0.64799999999999991},{"$f":"AI77","v":0.75599999999999989},0.84599999999999986,0.92699999999999982,0.99899999999999989,1.0620000000000001,1.125,1.1880000000000002,1.2510000000000001,1.3140000000000001,1.377,1.4400000000000002,1.5300000000000002,1.6380000000000003,1.7730000000000001,null,{"$f":"AX77","v":0.74519999999999975},{"$f":"AY77","v":0.86939999999999984},0.97289999999999976,1.0660499999999997,1.1488499999999997,1.2212999999999998,1.29375,1.3662000000000001,1.43865,1.5110999999999999,1.5835499999999998,1.6559999999999999,1.7595000000000001,1.8836999999999999,2.0389499999999998,null,{"$f":"BN77","v":0.74519999999999975},{"$f":"BO77","v":0.86939999999999984},0.97289999999999976,1.0660499999999997,1.1488499999999997,1.2212999999999998,1.29375,1.3662000000000001,1.43865,1.5110999999999999,1.5835499999999998,1.6559999999999999,1.7595000000000001,1.8836999999999999,2.0389499999999998,null,{"$f":"CD77","v":0.77759999999999985},{"$f":"CE77","v":0.90719999999999978},1.0151999999999997,1.1123999999999998,1.1987999999999999,1.2744,1.35,1.4256000000000002,1.5012000000000001,1.5768,1.6523999999999999,1.728,1.8360000000000001,1.9656000000000002,2.1276000000000002]
["Biogas",0.82799999999999974,0.96599999999999975,1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"115%*R80","v":0.82799999999999974},{"$f":"115%*S80","v":0.96599999999999975},1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"115%*AH80","v":0.82799999999999974},{"$f":"115%*AI80","v":0.96599999999999975},1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"115%*AX80","v":0.9521999999999996},{"$f":"115%*AY80","v":1.1108999999999996},1.2431499999999995,1.3621749999999995,1.4679749999999996,1.5605499999999997,1.653125,1.7456999999999998,1.8382749999999999,1.9308499999999997,2.0234249999999996,2.1159999999999997,2.2482500000000001,2.4069499999999997,2.6053249999999997,null,{"$f":"115%*BN80","v":0.9521999999999996},{"$f":"115%*BO80","v":1.1108999999999996},1.2431499999999995,1.3621749999999995,1.4679749999999996,1.5605499999999997,1.653125,1.7456999999999998,1.8382749999999999,1.9308499999999997,2.0234249999999996,2.1159999999999997,2.2482500000000001,2.4069499999999997,2.6053249999999997,null,{"$f":"115%*CD80","v":0.99359999999999971},{"$f":"115%*CE80","v":1.1591999999999996},1.2971999999999995,1.4213999999999996,1.5317999999999996,1.6283999999999998,1.7249999999999999,1.8215999999999999,1.9182000000000001,2.0147999999999997,2.1113999999999997,2.2079999999999997,2.3459999999999996,2.5116000000000001,2.7186000000000003]
["Diesel",0.71999999999999986,0.83999999999999986,0.93999999999999984,1.0299999999999998,1.1099999999999999,1.18,1.25,1.32,1.3900000000000001,1.46,1.53,1.6,1.7000000000000002,1.8200000000000003,1.9700000000000002,null,{"$f":"S80-0.12","v":0.71999999999999986},{"$f":"T80-0.1","v":0.83999999999999986},{"$f":"U80-0.09","v":0.93999999999999984},{"$f":"V80-0.08","v":1.0299999999999998},{"$f":"$X80-($AC80-$X80)*2/5","v":1.1099999999999999},{"$f":"$X80-($AC80-$X80)*1/5","v":1.18},1.25,{"$f":"($AC80-$X80)*1/5+$X80","v":1.32},{"$f":"($AC80-$X80)*2/5+$X80","v":1.3900000000000001},{"$f":"($AC80-$X80)*3/5+$X80","v":1.46},{"$f":"($AC80-$X80)*4/5+$X80","v":1.53},1.6,{"$f":"AC80+0.1","v":1.7000000000000002},{"$f":"AD80+0.12","v":1.8200000000000003},{"$f":"AE80+0.15","v":1.9700000000000002},null,{"$f":"S_13*R80","v":0.71999999999999986},0.83999999999999986,0.93999999999999984,1.0299999999999998,1.1099999999999999,1.18,1.25,1.32,1.3900000000000001,1.46,1.53,1.6,1.7000000000000002,1.8200000000000003,1.9700000000000002,null,{"$f":"S_137*R80","v":0.82799999999999974},0.96599999999999975,1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"S_15*R80","v":0.82799999999999974},0.96599999999999975,1.0809999999999997,1.1844999999999997,1.2764999999999997,1.3569999999999998,1.4375,1.518,1.5985,1.6789999999999998,1.7594999999999998,1.8399999999999999,1.9550000000000001,2.093,2.2654999999999998,null,{"$f":"S_18*R80","v":0.86399999999999977},1.0079999999999998,1.1279999999999997,1.2359999999999998,1.3319999999999999,1.4159999999999999,1.5,1.5840000000000001,1.6680000000000001,1.752,1.8359999999999999,1.92,2.04,2.1840000000000002,2.3640000000000003]
[]
["BUSLÆNGDE","service pris % ift 12 m","dæk"]
["9-11,8",1,6]
["11,9-12,8",1,6]
["12,9-13,2",1,6]
[13.7,1.1499999999999999,10]
["14,5-15",1.1499999999999999,10]
["18-18,8",1.2,10]
[]
["elbusser, indskudsbusser"]
["per 20 driftsbus",10]
[]
["Servicepris  ift km/år ","% ift 12 m"]
[{"$f":"\"< \"&C94","v":"< 40000"},1.1499999999999999,40000]
[{"$f":"\">=\"&C94&\"; <\"&C95","v":">=40000; <45000"},{"$f":"$B$100+($C$100-C95)/($C$100-$C$94)*($B$94-$B$100)","v":1.125},45000]
[{"$f":"\">=\"&C95&\"; <\"&C96","v":">=45000; <50000"},{"$f":"$B$100+($C$100-C96)/($C$100-$C$94)*($B$94-$B$100)","v":1.0999999999999999},50000]
[">=50000; <55000",{"$f":"$B$100+($C$100-C97)/($C$100-$C$94)*($B$94-$B$100)","v":1.075},55000]
[">=55000; <60000",{"$f":"$B$100+($C$100-C98)/($C$100-$C$94)*($B$94-$B$100)","v":1.05},60000]
[">=60000; <65000",{"$f":"$B$100+($C$100-C99)/($C$100-$C$94)*($B$94-$B$100)","v":1.0249999999999999},65000]
[">=65000; <70000",1,70000]
[">=70000; <75000",1,75000]
[">=75000; <80000",1,80000]
[">=80000; <85000",{"$f":"$B$102+($C$102-C103)/($C$102-$C$108)*($B$108-$B$102)","v":1.0249999999999999},85000]
[">=85000; <90000",{"$f":"$B$101+($C$101-C104)/($C$101-$C$108)*($B$108-$B$101)","v":1.0642857142857143},90000]
[">=90000; <95000",{"$f":"$B$101+($C$101-C105)/($C$101-$C$108)*($B$108-$B$101)","v":1.0857142857142856},95000]
[">=95000; <100000",{"$f":"$B$101+($C$101-C106)/($C$101-$C$108)*($B$108-$B$101)","v":1.107142857142857},100000]
[">=100000; <105000",{"$f":"$B$101+($C$101-C107)/($C$101-$C$108)*($B$108-$B$101)","v":1.1285714285714286},105000]
[">=105000; <110000",1.1499999999999999,110000]
[">=110000; <115000",{"$f":"$B$101+($C$101-C109)/($C$101-$C$108)*($B$108-$B$101)","v":1.1714285714285713},115000]
[">=115000; <120000",{"$f":"$B$101+($C$101-C110)/($C$101-$C$108)*($B$108-$B$101)","v":1.1928571428571428},120000]
[">=120000; <125000",{"$f":"$B$101+($C$101-C111)/($C$101-$C$108)*($B$108-$B$101)","v":1.2142857142857142},125000]
[">=125000; <130000",{"$f":"$B$101+($C$101-C112)/($C$101-$C$108)*($B$108-$B$101)","v":1.2357142857142855},130000]
[">=130000; <135000",{"$f":"B112+B112-B111","v":1.2571428571428569},135000]
[">=135000; <140000",{"$f":"B113+B113-B112","v":1.2785714285714282},140000]
[">=140000; <145000",1.2999999999999996,145000]
[{"$f":"\">\"&C115","v":">145000"},1.321428571428571,150000]
[]
["Ønsket løsning",1]
["Reference",1]
[null,null,"11 m",null,"12 m",null,"13 m",null,"13,7 m",null,"15 m",null,"18 m"]
[null,null,"elbus, depot","elbus, endestation","elbus, depot","elbus, endestation","elbus, depot","elbus, endestation","elbus, depot","elbus, endestation","elbus, depot","elbus, endestation","elbus, depot","elbus, endestation"]
[{"$f":"\"< \"&B122","v":"< 40000"},40000,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"\">=\"&B122&\"; <\"&B123","v":">=40000; <45000"},45000,0,0,0,0,0,0,0,0,0,0,0,0]
[">=45000; <50000",50000,0,0,0,0,0,0,0,0,0,0,0,0]
[">=50000; <55000",55000,0,0,0,0,0,0,0,0,0,0,0,0]
[">=55000; <60000",60000,0,0,0,0,0,0,0,0,0,0,0,0]
[">=60000; <65000",65000,0,0,0,0,0,0,0.5,0.5,0.5,0.5,0.5,0.5]
[">=65000; <70000",70000,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[">=70000; <75000",75000,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[">=75000; <80000",80000,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[">=80000; <85000",85000,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[">=85000; <90000",90000,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[">=90000; <95000",95000,0.5,0.5,0.5,0.5,0.5,0.5,1,0.5,1,0.5,1,0.5]
[">=95000; <100000",100000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=100000; <105000",105000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=105000; <110000",110000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=110000; <115000",115000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=115000; <120000",120000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=120000; <125000",125000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=125000; <130000",130000,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5,1,0.5]
[">=130000; <135000",135000,1,0.5,1,0.5,1,0.5,1.5,0.5,1.5,0.5,1.5,0.5]
[">=135000; <140000",140000,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5]
[">=140000; <145000",145000,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5]
[{"$f":"\">\"&B143","v":">145000"},150000,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5,1.5,0.5]
[]
["Ønsket løsning",90000,{"$f":"MATCH(RutKmÅrØns,RutKmOps,0)","v":11}]
[]
[]
["Tomkørsel","Bybusser, provins/forstad","Bybusser, København","Landevejsbusser"]
["% af rutekm",0.08,0.08,0.12]
[]
["kr/år for skader"]
["km/år",75000]
["Bybusser, provins","kr./år",20000]
["Bybusser, storkøbenhavn","kr./år",25000]
["Landevejsbusser","kr./år",15000]
[]
["Busantal"]
["reservebusser, per x driftsbusser",9.5]
[]
["DIESEL"]
["kr./l, inkl. moms",8]
[]
["HVO"]
["kr./l, inkl. moms",13.5]
[]
["BIOGAS"]
["kr./Nm3, inkl. moms",7.5]
[]
["EL"]
["kr./kWh, inkl. moms",0.8]
[]
["ADBLUE"]
["kr./l, inkl. moms",2]
["forbrug, %-diesel",7.0000000000000007E-2]
[]
["PRIS, OLIE, INKL. MOMS"]
["kr./l",63]
["forbrug, %-diesel",2E-3]
[]
["PRIS, DÆK, INKL. MOMS"]
["kr./stk.",2500]
["dæklevetid, km",100000]
[]
["CHAUFFØRLØN, kr. driftstime"]
["kr./t",400]
[]
["HASTIGHED"]
[null,"Bybusser, provins/forstad","Bybusser, København","Landevejsbusser"]
["km/t",22,19,35]
[]
["Rente"]
["%",0.02]
[]
["Opsalg"]
["Øns. Buslæng. Opslag",{"$f":"MATCH(BusLænØns,BUSLÆNGDE,0)","v":2}]
["Ref. Buslæng. Opslag",{"$f":"MATCH(BusLænRef,BUSLÆNGDE,0)","v":2}]
["Drivmiddel opslag",{"$f":"MATCH(drivmiddel,ØnskLøs,0)","v":2}]
["Kørselstype opslag",{"$f":"MATCH(kørselØ,KØRSELSTYPE,0)","v":3}]