{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["VEJLEDNING","COCKPIT","BEREGNINGSARK","INPUT_DATA","LISTER"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":467,"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 Trafikstyrelsen."]
[null,"Værktøjet er udviklet til beregning af merpris ved anvendelse af emissionsfri busser sammenholdt med diesel"]
[null,"Værktøjet består af fanebladene: COCKPIT, BEREGNINGSARK, INPUT_DATA 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,"Værktøjets brugerværdier kan nulstilles ved at trykke \"Nulstil alle værdier\"-knappen."]
[null,"Alle beregninger foretages i beregningsarket."]
[null,"Værktøjet understøtter følgende bustyper: dieselbusser, som anvender diesel, elbusser med HVO-fyr til kabineopvarmning (elbus, HVO-fyr), elbusser med emissionsfri kabineopvarmning (elbus, 0-emis. kabineopv.), endestationsopladte elbusser (elbus, endestation) og brintbusser."]
[null,"Ved anvendelse af brintbusser og endestationsopladte elbusser, anbefales det at indhente faktiske priser fra leverandører, da modelberegnerens datagrundlag er usikkert.  "]
[null,"Drivmiddelpriser er baseret på operatørernes omkostninger til drivmidler i foråret 2024."]
[null,"Det kan variere fra projekt til projekt, hvad der er den billigste løsning. For at finde den løsning med den laveste modelberegede pris, er det nødvendigt at sammenligne beregningerne for de forskellige løsninger. Den billigste løsning vil normalt være elbus med HVO-fyr og elbusser med emissionsfri kabineopvarmning."]
[null,"NB. Undlad at benytte programmet med ekstern monitor, da det kan forstyrre knapper mv."]
[null,"Værktøjet benytter makroer. Du skal derfor aktivere makroer."]
[]
[null,"Version 4"]
[null,"Opdateret 13. juni 2024"]

{"sheet":"COCKPIT","index":1,"n_rows":135,"n_cols":28,"rows_kept":135,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,11,1,13],[2,11,2,13],[2,4,2,6]]}
[]
[]
[null,null,"Kode til ark:TBB2023",null,"ØNSKET LØSNING",null,null,null,null,null,null,"REFERENCE LØSNING"]
[null,null,null,null,"BRUGERVÆRDI",null,"STANDARDVÆRDI",null,null,null,null,"BRUGERVÆRDI",null,"STANDARDVÆRDI"]
[null,"PROJEKTTYPE"]
[]
[null,"drivmiddel",null,"?",null,null,null,null,"drivmiddel",null,null,null,null,"diesel",null,"Elbus, HVO-fyr"]
[]
[null,"kørselstype",null,"?",null,null,null,null,"kørselstype",null,null,null,null,{"$f":"KørTyp","v":"Bybusser, provins/forstad"},null,"Bybusser, provins/forstad"]
[]
[null,"kontraktlængde","år","?",null,null,null,null,"kontraktlængde","år",null,null,null,{"$f":"ÅrØns","v":0}]
[]
[null,"projektlængde","år","?"]
[]
[null,"linje/kontraktenhed"]
[]
[null,"BUSDATA"]
[null,"driftsbusser","stk.","?"]
[]
[null,"buslængde","m","?",null,null,null,null,"buslængde","m",null,null,null,{"$f":"BusLænØns","v":"11,9-12,8"},null,"11,9-12,8"]
[]
[null,"køreplanstimer","timer/år","?!",null,null,null,null,"årskørsel","timer/år",null,null,null,{"$f":"TimÅrØns","v":0}]
[]
[null,"rutekm ","km/år","!",null,null,{"$f":"TimÅrØns*INDEX(kmT,1,KørTypOps)","v":0},null,"årskørsel","km/år",null,null,null,{"$f":"IF(RutKmØnsVær>0,RutKmØnsVær,TimRef*INDEX(kmT,1,KørTypOps))","v":0}]
[]
[null,"tomkørsel","km/år",null,null,null,{"$f":"INDEX(TomKmOps,1,MATCH(KørTyp,KØRSELSTYPE,0))*RutKmØns","v":0},null,"tomkørsel","km",null,null,null,{"$f":"INDEX(TomKmOps,1,MATCH(KørTyp,KØRSELSTYPE,0))*RutkmRef","v":0}]
[]
[null,"total busser (inkl. reserve og indskud)","stk.","!",null,null,{"$f":"DriBusVær+ROUNDUP((DriBusVær+1)/ResBusAnd,0)+IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),ROUNDUP(DriBusVær/EksBusFak,0)*INDEX((Ind_10m,Ind_12m,Ind_13m,Ind_15m,Ind_18m),MATCH(RutKmPrDri,RutKmOps,1),KørTypOps,BusLænOps),0)","v":{"$error":"#DIV/0!"}},null,"antal busser","stk.",null,null,null,{"$f":"DriBusVær+ROUNDUP((DriBusVær+1)/ResBusAnd,0)","v":1}]
[]
[null,"årskørsel (inkl. tomkørsel)","km/år/bus",null,null,null,{"$f":"(RutKmØns+TomKmØns)/BusAnt","v":{"$error":"#DIV/0!"}},null,"årskørsel (inkl. tomkørsel)","km/år/bus",null,null,null,{"$f":"(RutkmRef+TomKmRef)/BusAntRef","v":0}]
[]
[null,"rente","% pa",null,null,null,{"$f":"Rente","v":0.05}]
[]
[null,"klimaanlæg",null,null,null,null,{"$f":"JA","v":"ja"},null,"klimaanlæg",null,null,null,null,{"$f":"IF(ØnsKlima=\"\",\"nej\",ØnsKlima)","v":"ja"}]
[]
[null,"buspris (ekskl. moms)","kr./bus",null,null,null,{"$f":"IF(ISNUMBER(INDEX(BUSPRIS,BusLænOps,DriOps)+IF(ØnsKlima=JA,INDEX(KlimaanlægPris,BusLænOps,DriOps),0)),INDEX(BUSPRIS,BusLænOps,DriOps)+IF(ØnsKlima=JA,INDEX(KlimaanlægPris,BusLænOps,DriOps),0),\"INGEN DATA\")","v":3350000},null,"buspris","kr./bus",null,null,null,{"$f":"INDEX(DIESELBUSPRIS,BusLænOps,KørTypOps)+IF(RefKlima=JA,INDEX(KlimaAnlægDiesel,BusLænOps,KørTypOps),0)","v":1700000}]
[]
[null,"moms, fradragsret busser","% af moms",null,null,null,{"$f":"MomsFraBus","v":{"$error":"#DIV/0!"}}]
[]
[null,"restværdi","kr./bus",null,null,null,{"$f":"INDEX(Restværdi,DriOps,ROUNDUP(ÅrØns,0))*BusPriØns+IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),INDEX(Restværdi,6,ÅrØns)*BatUds,0)","v":{"$error":"#VALUE!"}},null,"restværdi","kr./bus",null,null,null,{"$f":"INDEX(Restværdi,5,ÅrRef)*BusPriRef","v":1190000},1020000,849999.99999999988,680000,510000,340000,286166.66666666669,232333.33333333337,178500.00000000003,124666.66666666667,70833.333333333343,17000,0,0,0]
[]
[null,"forsikring","kr./bus/år",null,null,null,{"$f":"BusPriØns*Forsikring","v":41875},null,"forsikring","kr./bus/år",null,null,null,{"$f":"BusPriRef*Forsikring","v":21250}]
[]
[null,"service (inkl. moms)","kr./km",null,null,null,{"$f":"ÅrsKm*INDEX((SerP11,SerP12,SerP13,SerP15,SerP18),DriOps,ROUND(ÅrØns,0),BusLænOps)","v":{"$error":"#VALUE!"}},null,"service","kr./km",null,null,null,{"$f":"ÅrsKmRef*INDEX((SerP11,SerP12,SerP13,SerP15,SerP18),5,ROUND(ÅrRef,0),BusLænRefOps)","v":{"$error":"#VALUE!"}}]
[]
[null,"skader (inkl. moms)","kr./år/bus",null,null,null,{"$f":"INDEX(SkaMat,KørTypOps)*kmÅrØns/SkaKmÅr","v":{"$error":"#DIV/0!"}},null,"skader","kr./år/bus",null,null,null,{"$f":"INDEX(SkaMat,KørTypOps)*kmÅrØns/SkaKmÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"dæk, levetid","km",null,null,null,{"$f":"INDEX(dæklevetid__km,1,DriOps)","v":76000},null,null,null,null,null,null,{"$f":"DækLeve","v":95000}]
[]
[null,"dæk (inkl. moms)","kr./stk.",null,null,null,{"$f":"DækPri","v":3000}]
[]
[null,"forbrug, fremdrift + opvarmning",{"$f":"INDEX(FORBRUG,DriOps,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},null,"forbrug, fremdrift + opvarmning","km/l","!",null,null,{"$f":"INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),BusLænRefOps,5,KørTypOps)","v":3.2711428571428565}]
[]
[null,"forbrug, opvarmning","liter HVO/km",null,null,null,{"$f":"IF(drivmiddel=El_fyr,INDEX((FORB_BY_PROV,FORB_BY_KØB,FORB_LAND),BusLænOps,6,KørTypOps),0)","v":1.3636363636363636E-2}]
[]
[null,"garageanlæg (inkl. moms)","kr./år",null,null,null,{"$f":"INDEX(GarKrPrBusPrÅr,1,KørTypOps)*INDEX(BusLænPct,1,BusLænOps)*DriBus","v":0},null,"garageanlæg (inkl. moms)","kr./år",null,null,null,{"$f":"INDEX(GarKrPrBusPrÅr,1,KørTypOps)*INDEX(BusLænPct,1,BusLænRefOps)*DriBus","v":0}]
[]
[null,"chaufførløn","kr./køreplanstime",null,null,null,{"$f":"INDEX((KplKrMatPro,KplKrMatKbh,KplKrMatLan),1,MATCH(TimØns/DriBusVær,KplKr,1),KørTypOps)","v":{"$error":"#DIV/0!"}}]
[]
[null,"pausefaciliteter (inkl. moms)","kr./driftsbus/år",null,null,null,{"$f":"PauFacPris","v":17000}]
[]
[null,"busrengøring (inkl. moms)","kr./driftsbus/år",null,null,null,{"$f":"RenBusPris","v":30000}]
[]
[null,"batteriudskiftning (ekskl. moms)","kr./bus",null,null,null,{"$f":"IF(ForEl*kmÅrØns*ÅrØns>kWhBatUds,INDEX(BatPris,1,BusLænOps),0)","v":{"$error":"#DIV/0!"}}]
[]
[null,"LADEINFRASTRUKTUR"]
[null,"ladeeffekt, depot","kW/lader",null,null,null,{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el),Eff_150,IF(drivmiddel=ElBy,LISTER!K3,0))","v":"150 (2*75)"}]
[]
[null,"ladetab, depot","%",null,null,null,{"$f":"LadTabDep","v":0.12}]
[]
[null,"antal ladere, depot","stk.",null,null,null,{"$f":"(BusAnt-ROUND(BusAnt/ResBusAnd,0))*INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),8)","v":{"$error":"#DIV/0!"}}]
[]
[null,"depotlader, pris (ekskl. moms)","kr./stk.",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),1)","v":375000}]
[]
[null,"depotlader, installation (ekskl. moms)","kr./første lader",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),2)","v":275000}]
[]
[null,"depotlader, installation (ekskl. moms)","kr./anden lader",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),3)","v":200000}]
[]
[null,"depotlader, nettilslutning","Ampere",null,null,null,{"$f":"INDEX(AmpOpsMat,1,MATCH(AmpBer,AmpOpsMat,-1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"depotlader, nettilslutning (ekskl. moms)","kr./Amp.",null,null,null,{"$f":"AmpPris","v":1330}]
[]
[null,"moms, fradragsret ladeinfrastruktur","% af moms",null,null,null,{"$f":"MomsFraGar","v":0}]
[]
[null,"depotlader, service (inkl. moms)","kr./stk./år",null,null,null,{"$f":"INDEX(DepPris,MATCH(EffDepLad,EFFEKT_DEPOT,0),7)","v":16250}]
[]
[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":{"$error":"#DIV/0!"}}]
[]
[null,"byrumlader, pris (ex moms)","kr./lader",null,null,null,{"$f":"INDEX(ByPris,MATCH(EffBy,EFFEKT_BYRUM,0),1)","v":{"$error":"#N/A"}}]
[]
[null,"moms, fradragsret","% af moms",null,null,null,{"$f":"MomsFraBy","v":0}]
[]
[null,"byrumlader, service (inkl. 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":11.3},null,"Baseret på 2024-priser inkl. afgiftsstigning i 2025 på 0,5 kr./l"]
[]
[null,"HVO (inkl. moms)","kr./l",null,null,null,{"$f":"HVOPris","v":19.100000000000001},null,"Baseret på 2024-priser"]
[]
[null,"el (inkl. moms)","kr./kWh",null,null,null,{"$f":"ElPris","v":1.2},null,"Baseret på 2024-priser"]
[]
[null,"brint (inkl. moms)","kr./kg H2",null,null,null,{"$f":"INDEX(BrintKrMat,1,MATCH(RutKmPrDri,BrintKmMat,1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"AdBlue, pris","kr./l",null,null,null,{"$f":"AddBluPris","v":5}]
[]
[null,"AdBlue, forbrug","% dieselforbrug",null,null,null,{"$f":"AddBluFor","v":7.0000000000000007E-2}]
[]
[null,"olie, pris","kr./l",null,null,null,{"$f":"OliePri","v":75}]
[]
[null,"olie, forbrug","% dieselforbrug",null,null,null,{"$f":"OlieFor","v":2E-3}]
[]
[]
[null,"chaufførbiler (inkl. moms)","kr./år",null,null,null,{"$f":"DriBus*PbilPrPus*kmPrPbil*PBilKrPrKm","v":0}]
[]
[null,"afkastningsgrad inkl. risikotillæg","%",null,null,null,{"$f":"Afkast","v":0.05}]
[]
[null,"STØTTEBELØB MV"]
[]
[null,"merpris for ønsket løsning","kr./år",null,null,null,{"$f":"MerPrisÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"merpris for ønsket løsning","kr. i projektperiode",null,null,null,{"$f":"MerPrisPer","v":{"$error":"#DIV/0!"}}]
[]
[null,"støtteprocent","%",null,null,null,0.5]
[]
[null,"støttebeløb","kr.",null,null,null,{"$f":"StøBel","v":{"$error":"#DIV/0!"}}]
[]
[null,"egenfinansiering","kr.",null,null,null,{"$f":"EgeFin","v":{"$error":"#DIV/0!"}}]
[]
[null,"Reduktion, udledning CO2 (tank-til-hjul)","tons/år",null,null,null,{"$f":"RedCO2Ton","v":{"$error":"#DIV/0!"}}]
[]
[null,"Reduktion, udledning CO2 (tank-til-hjul)","tons/projektperiode",null,null,null,{"$f":"RedCO2TonPro","v":{"$error":"#DIV/0!"}}]
[]
[null,"Omkostning, reduktion CO2 (tank-til-hjul)","kr./tons",null,null,null,{"$f":"RedCO2Kr","v":{"$error":"#DIV/0!"}}]

{"sheet":"BEREGNINGSARK","index":2,"n_rows":147,"n_cols":7,"rows_kept":147,"cut":false,"hidden":false,"merged":[[8,2,8,3],[10,2,10,3]]}
["RUTEDATA",null,"ØNSKET LØSNING","DIESELREFERANCE"]
["buslinje/kontraktenhed",null,{"$f":"BusLinVær","v":0}]
["buslængde",null,{"$f":"buslægdeØ","v":"11,9-12,8"},{"$f":"IF(ISTEXT(buslægdeRef),buslægdeRef,BusLænrefStan)","v":"11,9-12,8"},null,null,"Indtastet værdi"]
["rutekm","km/år",{"$f":"IF(ISNUMBER(RutKmØnsVær),RutKmØnsVær,RutKmØnsStan)","v":0},{"$f":"IF(ISNUMBER(RutKmRefVær),RutKmRefVær,RutKmRefStan)","v":0},null,null,"Beregninget værdi"]
["tomkørsel","km/år",{"$f":"IF(ISNUMBER(TomKmØnsVær),TomKmØnsVær,TomKmØnsStan)","v":0},{"$f":"IF(ISNUMBER(TomKmRefVær),TomKmRefVær,TomKmRefStan)","v":0},null,null,"Summeret budgetpost (beregnet værdi)"]
["rutekm","km/år/driftsbus",{"$f":"RutKmØns/DriBusVær","v":{"$error":"#DIV/0!"}},{"$f":"RutkmRef/DriBus","v":{"$error":"#DIV/0!"}},null,null,"Total omkostning per år"]
["årskørsel","km/bus/år",{"$f":"kmÅrØnsStan","v":{"$error":"#DIV/0!"}},{"$f":"kmÅrRefStan","v":0}]
[{"$f":"COCKPIT!B115","v":"chaufførbiler (inkl. moms)"},"kr./år",{"$f":"IF(ISNUMBER(PBilKmØnsVær),PBilKmØnsVær,PBilKmØnsStan)","v":0}]
["kørselstype",null,{"$f":"kørselØ","v":"Bybusser, provins/forstad"}]
["kontraktlængde (afskrivning)","år",{"$f":"kontraktlængdeØ","v":0},{"$f":"IF(ISNUMBER(kontraktlængdeRef),kontraktlængdeRef,KonLænRef)","v":0}]
["projektlængde","år",{"$f":"ProjLæn","v":0}]
["køreplanstimer","timer/år",{"$f":"TimÅrØns","v":0},{"$f":"IF(ISNUMBER(TimÅrRef),TimÅrRef,TimÅrRefStan)","v":0}]
["rente","% pa",{"$f":"IF(ISNUMBER(RentePAVær),RentePAVær,RentePAStand)","v":0.05},{"$f":"RenØns","v":0.05}]
["drivmiddel",null,{"$f":"drivmiddel","v":"Elbus, HVO-fyr"},"DIESEL"]
["BUSMATERIEL"]
["bus, driftsbusser, antal","stk.",{"$f":"DriBusVær","v":0}]
["bus, total, antal","stk.",{"$f":"IF(ISNUMBER(busantalØ),busantalØ,BusAntStan)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(busantalRef),busantalRef,BusAntRefStan)","v":1}]
["bus, pris","kr./bus",{"$f":"IF(ISNUMBER(BusØnsPrisVær),BusØnsPrisVær,BusØnsPrisRef)","v":3350000},{"$f":"IF(ISNUMBER(BusrefPrisVær),BusrefPrisVær,BusRefPrisStand)","v":1700000}]
["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"}]
["busser, investering","kr.",{"$f":"BusPriØns*BusAnt","v":{"$error":"#DIV/0!"}},{"$f":"BusPriRef*BusAntRef","v":1700000}]
["ydelse","kr./år",{"$f":"-PMT(C13,C10,C20)","v":{"$error":"#DIV/0!"}},{"$f":"-PMT($D13,$D10,$D20)","v":{"$error":"#NUM!"}}]
["moms","kr./bus",{"$f":"0.25*C18","v":837500},{"$f":"0.25*D18","v":425000}]
[{"$f":"COCKPIT!B38","v":"moms, fradragsret busser"},"%",{"$f":"IF(ISNUMBER(MomsBusFraVær),MomsBusFraVær,MomsBusFraStand)","v":{"$error":"#DIV/0!"}}]
[{"$f":"COCKPIT!B38","v":"moms, fradragsret busser"},"kr./bus",{"$f":"-BusMomFraØnsPct*BusMomØns","v":{"$error":"#DIV/0!"}},{"$f":"-IF(ISNUMBER(MomsBusFraVær),MomsBusFraVær,MomsBusFraStand)*D22","v":{"$error":"#DIV/0!"}}]
["moms","kr./år",{"$f":"BusAnt*(BusMomØns+BusMomFraØns)/ÅrØns","v":{"$error":"#DIV/0!"}},{"$f":"BusAntRef*(BusMomref+BusMomFraRef)/ÅrRef","v":{"$error":"#DIV/0!"}}]
["restværdi","kr./bus",{"$f":"-IF(ISNUMBER(RestØnsVær),RestØnsVær,RestØnsStand)","v":{"$error":"#VALUE!"}},{"$f":"-IF(ISNUMBER(RestRefVær),RestRefVær,RestRefStand)","v":-1190000}]
["restværdi","kr./år",{"$f":"BusAnt*ResBusØnsAnv/ÅrØns","v":{"$error":"#DIV/0!"}},{"$f":"BusAntRef*ResBusRefAnv/ÅrRef","v":{"$error":"#DIV/0!"}}]
["forsikring","kr./år/bus",{"$f":"IF(ISNUMBER(ForsØnsVær),ForsØnsVær,ForsØnsStand)","v":41875},{"$f":"IF(ISNUMBER(ForsRefVær),ForsRefVær,ForsRefStand)","v":21250}]
["forsikring","kr./år",{"$f":"BusAnt*C28","v":{"$error":"#DIV/0!"}},{"$f":"BusAntRef*D28","v":21250}]
["batteriudskiftning","kr./bus",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),IF(ISNUMBER(BatUdVær),BatUdVær,BatUdStand),0)","v":{"$error":"#DIV/0!"}}]
["moms","kr./bus",{"$f":"BatUds*25%","v":{"$error":"#DIV/0!"}}]
[{"$f":"A24","v":"moms, fradragsret busser"},"kr./bus",{"$f":"-BusMomFraØnsPct*BatUdsMoms","v":{"$error":"#DIV/0!"}}]
["batteriudskiftning","kr./år",{"$f":"BusAnt*(BatUds+BatUdsMoms+BatUdsFraMoms)/ÅrØns","v":{"$error":"#DIV/0!"}}]
["LADE-/FYLDESTATION, DEPOT"]
["ladere, effekt","kW",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),IF(kWdepVær>0,kWdepVær,kWdepStand),0)","v":"150 (2*75)"}]
["ladere","stk.",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),IF(ISNUMBER(nLadDepVær),nLadDepVær,nLadDepStand),0)","v":{"$error":"#DIV/0!"}}]
["lader, pris","kr./stk.",{"$f":"IF(ISNUMBER(DepPrisVær),DepPrisVær,DepPrisStand)","v":375000}]
["ladere, investering","kr.",{"$f":"DepLadStk*C37","v":{"$error":"#DIV/0!"}}]
["1. lader, installation","kr./lader",{"$f":"IF(ISNUMBER(DepIns1LadVær),DepIns1LadVær,DepIns1LadStan)","v":275000}]
["2. lader, installation","kr./lader",{"$f":"IF(ISNUMBER(DepIns2LadVær),DepIns2LadVær,DepIns2LadStan)","v":200000}]
["installation, ladere","kr.",{"$f":"C39+(DepLadStk-1)*C40","v":{"$error":"#DIV/0!"}}]
["pris ladere+installation","kr.",{"$f":"C38+C41+C48","v":{"$error":"#DIV/0!"}}]
["moms ladere+installation","kr.",{"$f":"0.25*C42","v":{"$error":"#DIV/0!"}}]
["momsfradrag ladere+installation","kr.",{"$f":"-IF(ISNUMBER(MomsGarFraVær),MomsGarFraVær,MomsGarFraStand)*C43","v":{"$error":"#DIV/0!"}}]
["ladere+installation, ydelse","kr./år",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),-PMT(RenØns,ÅrØns,(SUM(C42:C44))),0)","v":{"$error":"#DIV/0!"}}]
["nettilslutning","Amp.",{"$f":"IF(ISNUMBER(DepLadEffVær),DepLadEffVær,DepLadEffStan)","v":{"$error":"#DIV/0!"}}]
["nettilslutning","kr./Amp.",{"$f":"IF(ISNUMBER(AmpPrisVær),AmpPrisVær,AmpPrisStand)","v":1330}]
["nettilslutning","kr.",{"$f":"DepLadEff*C47","v":{"$error":"#DIV/0!"}}]
["moms nettilslutning","kr.",{"$f":"0.25*C48","v":{"$error":"#DIV/0!"}}]
["momsfradrag nettilslutning","%",{"$f":"IF(ISNUMBER(MomsGarFraVær),MomsGarFraVær,MomsGarFraStand)","v":0}]
["momsfradrag nettilslutning","kr.",{"$f":"-C50*C49","v":{"$error":"#DIV/0!"}}]
["nettilslutning, ydelse","kr./år",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),-PMT(RenØns,30,(SUM(C48:C51))),0)","v":{"$error":"#DIV/0!"}}]
["lader, service","kr./stk./år",{"$f":"IF(ISNUMBER(DepSerVær),DepSerVær,DepSerStan)","v":16250}]
["lader, service","kr./år",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),DepLadStk*C53,0)","v":{"$error":"#DIV/0!"}}]
["ladetab","%",{"$f":"IF(ISNUMBER(LadTabGarVær),LadTabGarVær,LadTabGarStan)","v":0.12}]
["LADESTATION, BYRUM"]
["ladestation, byrum, effekt","kW",{"$f":"IF(ISNUMBER(kWbyVær),kWbyVær,kWbyStan)","v":0}]
["ladestation, byrum ","stk.",{"$f":"IF(ISNUMBER(nLadByVær),nLadByVær,nLadByStand)","v":{"$error":"#DIV/0!"}}]
["ladestation, byrum","kr./stk.",{"$f":"IF(ISNUMBER(ByPrisVær),ByPrisVær,ByPrisStand)","v":{"$error":"#N/A"}}]
["ladestation, byrum, investering","kr.",{"$f":"C58*C59","v":{"$error":"#DIV/0!"}}]
["moms","kr./bus",{"$f":"0.25*ByLadPriSum","v":{"$error":"#DIV/0!"}}]
["momsfradrag byrumslader","%",{"$f":"IF(ISNUMBER(MomsByFraVær),MomsByFraVær,MomsByFraStand)","v":0}]
["momsfradrag byrumslader","kr./bus",{"$f":"-C62*ByLadMoms","v":{"$error":"#DIV/0!"}}]
["ladestation, ydelse","kr./år",{"$f":"IF(drivmiddel=ElBy,-PMT(RenØns,ÅrØns,ByLadPriSum),0)","v":0}]
["ladestation, service","kr./lader/år",{"$f":"_xlfn.SINGLE(IF(drivmiddel=ElBy,IF(ISNUMBER(_xlfn.SINGLE(BySerVær)),BySerVær,BySerStand),0))","v":0}]
["ladestation, service","kr./år",{"$f":"IF(drivmiddel=ElBy,C58*C65,0)","v":0}]
["DRIVMIDDEL"]
["el, pris (inkl. moms)","kr./kWh",{"$f":"IF(ISNUMBER(ElVærd),ElVærd,ElStand)","v":1.2}]
["el, forbrug bus","kWh/bus",{"$f":"ForEl*kmÅrØns*ÅrØns/BusAnt","v":{"$error":"#DIV/0!"}}]
["el, forbrug fremdrift + opvarmning","kWh/km",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),IF(ISNUMBER(ØnsForBrVæ),ØnsForBrVæ,ØnsForStand),0)","v":1}]
["el, forbrug fremdrift + opvarmning, inkl. ladetab","kWh/km",{"$f":"(1+LadTab)*ForEl","v":1.1200000000000001}]
["el, forbrug","kWh/år",{"$f":"BusAnt*kmÅrØns*ForElMedTab","v":{"$error":"#DIV/0!"}}]
["el, omkostning (inkl. moms)","kr./år",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),C72*C68,0)","v":{"$error":"#DIV/0!"}}]
["brint, pris (inkl. moms)","kr./kg H2",{"$f":"IF(ISNUMBER(H2Vær),H2Vær,H2Stan)","v":{"$error":"#DIV/0!"}}]
["brint, forbrug","kg H2/100 km",{"$f":"IF(drivmiddel=Brintbus,IF(ISNUMBER(ØnsForBrVæ),ØnsForBrVæ,ØnsForStand),0)","v":0}]
["brint, forbrug","kg H2/år",{"$f":"BusAnt*kmÅrØns*H2For/100","v":{"$error":"#DIV/0!"}}]
["brint, omkostning (inkl. moms)","kr./år",{"$f":"IF(drivmiddel=Brintbus,C76*C74,0)","v":0}]
["HVO, pris (inkl. moms)","kr./l",{"$f":"IF(ISNUMBER(HVOVær),HVOVær,HVOStand)","v":19.100000000000001}]
["HVO-forbrug, opvarmning","l/km",{"$f":"IF(ISNUMBER(ForOpvVær),ForOpvVær,ForOpvStand)","v":1.3636363636363636E-2}]
["HVO-forbrug, opvarmning","l/år",{"$f":"BusAnt*HVOkmOpv*kmÅrØns","v":{"$error":"#DIV/0!"}}]
["HVO-forbrug, opvarmning","kr./år",{"$f":"IF(OR(drivmiddel=El_fyr,drivmiddel=ElBy,drivmiddel=Brintbus),C80*PriHVO,0)","v":{"$error":"#DIV/0!"}}]
["diesel, pris (inkl. moms)","kr./l",null,{"$f":"IF(ISNUMBER(DieselVær),DieselVær,DieselStand)","v":11.3}]
["diesel, forbrug","km/l ",null,{"$f":"IF(ISNUMBER(RefForBrVæ),RefForBrVæ,RefForStand)","v":3.2711428571428565}]
["diesel, forbrug","l/år",null,{"$f":"BusAntRef*kmÅrRef/D83","v":0}]
["diesel, omkostning (inkl. moms)","kr./år",null,{"$f":"D84*D82","v":0}]
["chaufførbiler ","kWh/år",{"$f":"PbilKwPrkm*kmPrPbil*PbilPrPus*DriBus","v":0},{"$f":"PBilKWhÅr","v":0}]
[{"$f":"COCKPIT!B$115","v":"chaufførbiler (inkl. moms)"},"kr./år",{"$f":"IF(ISNUMBER(PBilKmØnsVær),PBilKmØnsVær,PBilKmØnsStan)","v":0},{"$f":"C87","v":0}]
[{"$f":"COCKPIT!B$115","v":"chaufførbiler (inkl. moms)"},"kr./år",{"$f":"C87","v":0},{"$f":"D87","v":0}]
["ADDITIV"]
["AdBlue",{"$f":"B78","v":"kr./l"},null,{"$f":"IF(ISNUMBER(AdBluVær),AdBluVær,AdBluStan)","v":5}]
["AdBlueforbrug af dieselforbrug (km/l)","%",null,{"$f":"IF(ISNUMBER(AdBluForVær),AdBluForVær,AdBluForStan)","v":7.0000000000000007E-2}]
["AdBlue","l/år",null,{"$f":"D84*D91","v":0}]
["AdBlue","kr./år",null,{"$f":"D92*D90","v":0}]
["OLIE"]
["Olie","kr./l",null,{"$f":"IF(ISNUMBER(OliPriVær),OliPriVær,OliPriStan)","v":75}]
["Olieforbrug af dieselforbrug (km/l)","%",null,{"$f":"IF(ISNUMBER(OliForVær),OliForVær,OliForStan)","v":2E-3}]
["Olie","l/år",null,{"$f":"D96*D84","v":0}]
["Olie","kr/år",null,{"$f":"D97*D95","v":0}]
["DÆK"]
["Dæk levetid","km",{"$f":"IF(ISNUMBER(DækLevØnsVær),DækLevØnsVær,DækLevØnsStand)","v":76000},{"$f":"IF(ISNUMBER(DækLevRefVærVær),DækLevØnsVær,DækLevRefStand)","v":95000}]
["Pris pr. dæk","kr./stk.",{"$f":"D101","v":3000},{"$f":"IF(ISNUMBER(DækPriVær),DækPriVær,DækPriStan)","v":3000}]
["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":"C7/C100","v":{"$error":"#DIV/0!"}},{"$f":"D7/D100","v":0}]
["Dæk  ","kr./år",{"$f":"BusAnt*C101*C102*C103","v":{"$error":"#DIV/0!"}},{"$f":"BusAntRef*D101*D102*D103","v":0}]
["SERVICE"]
["service","kr./km",{"$f":"IF(ISNUMBER(SerØnsVær),SerØnsVær,SerØnsStan)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISNUMBER(SerRefVær),SerRefVær,SerRefStan)","v":{"$error":"#VALUE!"}}]
["service","kr./år",{"$f":"BusAnt*SerØns*kmÅrØns","v":{"$error":"#DIV/0!"}},{"$f":"BusAntRef*SerRef*D7","v":{"$error":"#VALUE!"}}]
["skader","kr./bus/år",{"$f":"IF(ISNUMBER(SkaØnsVær),SkaØnsVær,SkaØnsStan)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISNUMBER(SkaRefVær),SkaRefVær,SkaRefStan)","v":{"$error":"#DIV/0!"}}]
["skader","kr./år",{"$f":"DriBus*SkaBusØns","v":{"$error":"#DIV/0!"}},{"$f":"DriBus*SkaBusRef","v":{"$error":"#DIV/0!"}}]
["CHAUFFØRLØN"]
["chaufførløn","kr./driftstime",{"$f":"IF(ISNUMBER(ChalønVær),ChalønVær,ChaLønStan)","v":{"$error":"#DIV/0!"}},{"$f":"C111","v":{"$error":"#DIV/0!"}}]
["chaufførløn","kr./år",{"$f":"C12*C111","v":{"$error":"#DIV/0!"}},{"$f":"D12*D111","v":{"$error":"#DIV/0!"}}]
["GARAGEANLÆG"]
["Garageanlæg","kr./år",{"$f":"IF(ISNUMBER(GarAnlVærØns),GarAnlVærØns,GarAnlØnsStan)","v":0},{"$f":"IF(ISNUMBER(GarAnlVærØns),GarAnlVærØns,GarAnlØnsStan)","v":0}]
["Garageanlæg","kr./år",{"$f":"C114","v":0},{"$f":"D114","v":0}]
["Rengøring","kr./driftsbus/år",{"$f":"IF(ISNUMBER(RenBusVær),RenBusVær,RenBusStan)","v":30000},{"$f":"C116","v":30000}]
["Rengøring","kr./år",{"$f":"C116*DriBus","v":0},{"$f":"DriBus*D116","v":0}]
["PAUSEFACILITETER"]
["Pausefaciliteter","kr./driftsbus/år",{"$f":"IF(ISNUMBER(PauVær),PauVær,PauStan)","v":17000},{"$f":"C119","v":17000}]
["Pausefaciliteter","kr./år",{"$f":"C119*DriBus","v":0},{"$f":"DriBus*D119","v":0}]
["AFKAST"]
["afkastningsgrad inkl. risikotillæg","%",{"$f":"IF(ISNUMBER(AfkØns),AfkØns,AfkStan)","v":0.05},{"$f":"C122","v":0.05}]
["afkastningsgrad inkl. risikotillæg","kr./år",{"$f":"C122*(BusYdeØns+ResVærØns+ForPriØns+BatUdsPri+LadDepPri+NetDepPri+LadDepSer+LadByPri+LadBySer+ElPriØns+BrintPrisØnsk+HVOOpvØns+PBilØns+DækPriØns+SerPriØns+SkaBusÅrØns+ChaPriØns+GarØns+RengØsk+PauØns+MomsØns)","v":{"$error":"#DIV/0!"}},{"$f":"D122*(BusYdeRef+ResVærRef+ForPriRef+DiePriRef+PBilRef+AddPriRef+OliPriRef+DækPriRef+SerPriRef+SkaBusÅrRef+ChaPriRef+GarRef+RengRef+PauRef+MomsRef)","v":{"$error":"#NUM!"}}]
["SAMLET"]
["samlet årlig omkostning","kr./år",{"$f":"BusYdeØns+ResVærØns+ForPriØns+BatUdsPri+LadDepPri+NetDepPri+LadDepSer+LadByPri+LadBySer+ElPriØns+BrintPrisØnsk+HVOOpvØns+PBilØns+DækPriØns+SerPriØns+SkaBusÅrØns+ChaPriØns+AfkKrØns+GarØns+RengØsk+MomsØns+PauØns","v":{"$error":"#DIV/0!"}},{"$f":"BusYdeRef+ResVærRef+ForPriRef+DiePriRef+PBilRef+AddPriRef+OliPriRef+DækPriRef+SerPriRef+SkaBusÅrRef+ChaPriRef+GarRef+AfkKrRef+RengRef+MomsRef+PauRef","v":{"$error":"#NUM!"}}]
["MERPRIS"]
["merpris for ønsket løsning","kr./år",{"$f":"SamÅrØns-SamÅrRef","v":{"$error":"#DIV/0!"}}]
["merpris for ønsket løsning","kr. i projektperiode",{"$f":"C11*C127","v":{"$error":"#DIV/0!"}}]
["støtteprocent","%",{"$f":"IF(ISNUMBER(StøPctØns),StøPctØns,StøPctRef)","v":0.5}]
["støttebeløb","50% af merpris",{"$f":"C129*MerPrisPer","v":{"$error":"#DIV/0!"}}]
["egenfinansiering","50% af merpris",{"$f":"(1-C129)*MerPrisPer","v":{"$error":"#DIV/0!"}}]
["CO2e"]
["El",{"$f":"INPUT_DATA!B225","v":"kg CO2e/kWh"},{"$f":"KgCO2ekWh","v":0},{"$f":"KgCO2ekWh","v":0}]
["Brint",{"$f":"INPUT_DATA!C225","v":"kg CO2e/kg H2"},{"$f":"KgCO2eH2","v":0}]
["HVO",{"$f":"INPUT_DATA!D225","v":"kg CO2e/l"},{"$f":"kgCO2eHVO","v":0}]
["Diesel",{"$f":"INPUT_DATA!E225","v":"kg CO2e/l"},null,{"$f":"kgCO2eB7","v":2.44}]
["Emission","ton CO2e/år",{"$f":"PBilKWhÅr*$C$133+ForHVOTot*$C$135+IF(OR(drivmiddel=El_fyr,drivmiddel=El_el,drivmiddel=ElBy),ForElTot*$C$133,ForH2Tot*$C$134)","v":{"$error":"#DIV/0!"}},{"$f":"(PBilKWhÅrRef*D133+ForB7Tot*D136)/1000","v":0}]
["Reduktion","ton CO2e/år",{"$f":"D137-C137","v":{"$error":"#DIV/0!"}}]
["Reduktion","ton CO2e/projektperi.",{"$f":"C11*RedCO2Ton","v":{"$error":"#DIV/0!"}}]
["Reduktion","kr./ton CO2e",{"$f":"MerPrisÅr/C138","v":{"$error":"#DIV/0!"}}]
["timepris","kr./t",{"$f":"SamÅrØns/TimØns","v":{"$error":"#DIV/0!"}},{"$f":"SamÅrRef/TimRef","v":{"$error":"#NUM!"}}]
["KØREPLANTIMEAFHÆNGIGE","kr./år",{"$f":"(ForPriØns+ElPriØns+BrintPrisØnsk+HVOOpvØns+C85+DækPriØns+(1-BatBusAfhPct)*BatUdsPri+(1-PctFasSerØns)*SerPriØns+SkaBusÅrØns+ChaPriØns)*(1+C122)","v":{"$error":"#DIV/0!"}},{"$f":"(ForPriRef+D33+D73+D77+D81+DiePriRef+AddPriRef+OliPriRef+DækPriRef+(1-PctFasSerRef)*SerPriRef+SkaBusÅrRef+ChaPriRef)*(1+AfkPrc)","v":{"$error":"#VALUE!"}}]
["KØREPLANTIMEAFHÆNGIGE","kr./t",{"$f":"C142/TimØns","v":{"$error":"#DIV/0!"}},{"$f":"D142/TimRef","v":{"$error":"#VALUE!"}}]
["BUSAFHÆNGIGE","kr./år",{"$f":"(BusYdeØns+ResVærØns+BatBusAfhPct*BatUdsPri+PctFasSerØns*SerPriØns)*(1+D122)","v":{"$error":"#DIV/0!"}},{"$f":"(BusYdeRef+ResVærRef+PctFasSerRef*SerPriRef)*(1+AfkPrc)","v":{"$error":"#NUM!"}}]
["BUSAFHÆNGIGE","kr./t",{"$f":"C144/TimØns","v":{"$error":"#DIV/0!"}},{"$f":"D144/TimRef","v":{"$error":"#NUM!"}}]
["FASTE","kr./år",{"$f":"(LadDepPri+NetDepPri+LadDepSer+LadByPri+LadBySer+PBilØns+GarØns)*(1+AfkPrc)","v":{"$error":"#DIV/0!"}},{"$f":"(D45+D52+D54+D64+D66+PBilRef+GarRef)*(1+AfkPrc)","v":0}]
["FASTE","kr./t",{"$f":"C146/TimØns","v":{"$error":"#DIV/0!"}},{"$f":"D146/TimRef","v":{"$error":"#DIV/0!"}}]

{"sheet":"INPUT_DATA","index":3,"n_rows":253,"n_cols":174,"rows_kept":253,"cut":false,"hidden":false,"merged":[[132,18,132,19],[36,2,36,3],[132,5,132,7],[132,14,132,16],[132,2,132,4],[132,8,132,10],[132,11,132,13],[36,4,36,6]]}
["AFSKRIVNING"]
["år",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[{"$f":"El_fyr","v":"Elbus, HVO-fyr"},0.7,{"$f":"($B3-$G3)*4/5+$G3","v":0.62999999999999989},{"$f":"($B3-$G3)*3/5+$G3","v":0.55999999999999994},{"$f":"($B3-$G3)*2/5+$G3","v":0.49},{"$f":"($B3-$G3)*1/5+$G3","v":0.42},0.35,{"$f":"($G3-$M3)*5/6+$M3","v":0.29499999999999998},{"$f":"($G3-$M3)*4/6+$M3","v":0.23999999999999996},{"$f":"($G3-$M3)*3/6+$M3","v":0.18499999999999997},{"$f":"($G3-$M3)*2/6+$M3","v":0.12999999999999998},{"$f":"($G3-$M3)*1/6+$M3","v":7.4999999999999997E-2},0.02,0.01,0,0]
[{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},{"$f":"B$3","v":0.7},0.62999999999999989,0.55999999999999994,0.49,0.42,0.35,0.29499999999999998,{"$f":"($G4-$M4)*4/6+$M4","v":0.23999999999999996},{"$f":"($G4-$M4)*3/6+$M4","v":0.18499999999999997},{"$f":"($G4-$M4)*2/6+$M4","v":0.12999999999999998},{"$f":"($G4-$M4)*1/6+$M4","v":7.4999999999999997E-2},{"$f":"M$3","v":0.02},0.01,0,0]
[{"$f":"ElBy","v":"Elbus, endestation"},{"$f":"B$3","v":0.7},0.62999999999999989,0.55999999999999994,0.49,0.42,0.35,0.29499999999999998,0.23999999999999996,0.18499999999999997,0.12999999999999998,7.4999999999999997E-2,0.02,0.01,0,0]
[{"$f":"Brintbus","v":"Brintbus"},0.7,0.62999999999999989,0.55999999999999994,0.49,0.42,0.35,0.29499999999999998,0.23999999999999996,0.18499999999999997,0.12999999999999998,7.4999999999999997E-2,0.02,0.01,0,0]
["Dieselbus",0.7,{"$f":"($B7-$G7)*4/5+$G7","v":0.6},{"$f":"($B7-$G7)*3/5+$G7","v":0.49999999999999994},{"$f":"($B7-$G7)*2/5+$G7","v":0.4},{"$f":"($B7-$G7)*1/5+$G7","v":0.3},0.2,{"$f":"($G7-$M7)*5/6+$M7","v":0.16833333333333333},0.13666666666666669,0.10500000000000001,7.3333333333333334E-2,4.1666666666666671E-2,0.01,0,0,0]
["Batteri",0,0,0,0,0,0,0,0,{"$f":"6/7","v":0.8571428571428571},{"$f":"5/7","v":0.7142857142857143},{"$f":"4/7","v":0.5714285714285714},{"$f":"3/7","v":0.42857142857142855},{"$f":"2/7","v":0.2857142857142857},{"$f":"1/7","v":0.14285714285714285},0]
[]
["BATTERIUDSKIFTNING"]
["år+",8,"9-11,8","11,9-12,8","12,9-13,2","14,5-15","18-18,8"]
["kr. inkl moms",800000,{"$f":"4000*kWh10m*0.2*1.25","v":430000},{"$f":"4000*kWh12m*0.2*1.25","v":430000},{"$f":"4000*kWh13m*0.2*1.25","v":430000},{"$f":"4000*kWh15m*0.2*1.25","v":560000},{"$f":"4000*kWh18m*0.2*1.25","v":560000}]
["kWh",null,430,430,430,560,560]
[]
["Busafhængige",0.6]
[]
["BUSPRIS, EKSKL. MOMS"]
["BUSLÆNGDE",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},{"$f":"ElBy","v":"Elbus, endestation"},{"$f":"Brintbus","v":"Brintbus"},"Diesel, provins","Diesel, København","Diesel, landevej"]
["9-11,8",3275000,3275000,3275000,"INGEN DATA",1625000,1625000,1625000]
["11,9-12,8",3275000,3275000,3275000,4175000,1625000,1625000,1625000]
["12,9-13,2",3475000,3475000,3475000,"INGEN DATA",1825000,1825000,1825000]
["14,5-15",3675000,3675000,3675000,"INGEN DATA",2150000,2150000,2150000]
["18-18,8",4570000,4570000,4570000,5250000,2375000,2375000,2375000]
[]
["KLIMAANLÆG PRIS, EKSKL. MOMS"]
["BUSLÆNGDE",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},{"$f":"ElBy","v":"Elbus, endestation"},{"$f":"Brintbus","v":"Brintbus"},"Diesel, provins","Diesel, København","Diesel, landevej"]
["9-11,8",75000,250000,75000,"INGEN DATA",75000,75000,75000]
["11,9-12,8",75000,250000,75000,75000,75000,75000,75000]
["12,9-13,2",75000,250000,75000,"INGEN DATA",75000,75000,75000]
["14,5-15",75000,250000,75000,"INGEN DATA",75000,75000,75000]
["18-18,8",150000,500000,150000,150000,150000,150000,150000]
[]
["FORSIKRING, % NYPRIS PER ÅR"]
[1.2500000000000001E-2]
[]
["PRIS, DEPOTLADERE, EKSKL. MOMS"]
["kW","PRIS","INSTALLATION",null,"AMPERE",null,null,"SERVICE","LADERE"]
[null,null,"første (kr.)","efterfølgende (kr.)",150000,3,1,"kr./år","stk."]
[null,"kr. ekskl. moms","kr. ekskl. moms","kr. ekskl. moms","Amp/lader","Amp/lader","Amp/lader"]
[50,165000,{"$f":"150000","v":150000},100000,76.08695652173914,79.710144927536234,100,{"$f":"6000*1.25","v":7500},1]
["60 (2*30)",200000,{"$f":"150000","v":150000},100000,91.304347826086968,95.652173913043484,100,{"$f":"1.25*9000","v":11250},0.5]
[75,240000,200000,125000,114.1304347826087,119.56521739130436,125,{"$f":"1.25*9000","v":11250},1]
["150 (2*75)",375000,275000,200000,228.2608695652174,239.13043478260872,250,{"$f":"1.25*13000","v":16250},0.5]
["240 (2*120)",450000,300000,200000,365.21739130434787,382.60869565217394,400,{"$f":"13000*1.25","v":16250},0.5]
[]
["AMPERE"]
["kr./Amp., ekskl. moms",1330]
["A ",{"$f":"DepLadStk*INDEX(AmpLaderMat,LadOps,MATCH(DepLadStk,LadNMat,-1))","v":{"$error":"#DIV/0!"}}]
["trin",16200,16100,16000,15900,15800,15700,15600,15500,15400,15300,15200,15100,15000,14900,14800,14700,14600,14500,14400,14300,14200,14100,14000,13900,13800,13700,13600,13500,13400,13300,13200,13100,13000,12900,12800,12700,12600,12500,12400,12300,12200,12100,12000,11900,11800,11700,11600,11500,11400,11300,11200,11100,11000,10900,10800,10700,10600,10500,10400,10300,10200,10100,10000,9900,9800,9700,9600,9500,9400,9300,9200,9100,9000,8900,8800,8700,8600,8500,8400,8300,8200,8100,8000,7900,7800,7700,7600,7500,7400,7300,7200,7100,7000,6900,6800,6700,6600,6500,6400,6300,6200,6100,6000,5900,5800,5700,5600,5500,5400,5300,5200,5100,5000,4900,4800,4700,4600,4500,4400,4300,4200,4100,4000,3900,3800,3700,3600,3500,3400,3300,3200,3100,3000,2900,2800,2700,2600,2500,2400,2300,2200,2100,2000,1900,1800,1700,1600,1500,1400,1300,1200,1100,1000,900,800,710,670,630,560,500,425,400,355,315,300,275,250,225,200,175,150,125,100]
[]
["LADETAB"]
["%",0.12]
[]
["PRIS, BYRUMSLADERE"]
["kW","PRIS, kr./stk., inkl. installation, inkl. moms","SERVICE,  kr./pr./stk","Ladere/bus, 1+"]
[150,3000000,105000,{"$f":"1/6","v":0.16666666666666666}]
[300,3500000,105000]
[450,4000000,115500]
[600,4500000,115500]
[]
["BYBUSSER, PROVINS",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},"Elbus, endestation",{"$f":"Brintbus","v":"Brintbus"},"Diesel","KABINEVARME"]
["BUSLÆNGDE","kWh/km","kWh/km","kWh/km","kg H2/100km","km/l","l HVO/km (HVO-fyr)"]
["9-11,8",0.95,{"$f":"C$64*B63/B$64","v":1.0069999999999999},{"$f":"D$64*C63/C$64","v":1.0069999999999999},"INGEN DATA",3.3725000000000005,1.1363636363636362E-2]
["11,9-12,8",1,1.06,1.06,7.8,3.2711428571428565,1.3636363636363636E-2]
["12,9-13,2",1.02,{"$f":"C$64*B65/B$64","v":1.0812000000000002},{"$f":"D$64*C65/C$64","v":1.0812000000000002},"INGEN DATA",2.9,1.4772727272727272E-2]
["14,5-15",{"$f":"B64*1.35","v":1.35},{"$f":"C$64*B66/B$64","v":1.4310000000000003},1.4310000000000003,"INGEN DATA",2.1,1.7045454545454544E-2]
["18-18,8",{"$f":"B64*1.47","v":1.47},1.5582,1.5582,{"$f":"E$64*B67/B$64","v":11.465999999999999},1.9,2.0454545454545454E-2]
[]
["BYBUSSER, KØBENAVN",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},"Elbus, endestation",{"$f":"Brintbus","v":"Brintbus"},"Diesel","KABINEVARME"]
["BUSLÆNGDE","kWh/km","kWh/km","kWh/km","kg H2/100 km","l/km","l HVO/km (depot)"]
["9-11,8",{"$f":"B63*1.05","v":0.99749999999999994},{"$f":"1.05*C63","v":1.05735},{"$f":"C71","v":1.05735},"INGEN DATA",3,1.3157894736842105E-2]
["11,9-12,8",1.05,{"$f":"1.05*C64","v":1.1130000000000002},{"$f":"C72","v":1.1130000000000002},{"$f":"E64*1.05","v":8.19},2.9,1.5789473684210527E-2]
["12,9-13,2",{"$f":"B65*1.05","v":1.0710000000000002},{"$f":"1.05*C65","v":1.1352600000000002},1.1352600000000002,"INGEN DATA",2.8,1.7105263157894738E-2]
["14,5-15",{"$f":"B66*1.05","v":1.4175000000000002},1.5025500000000003,1.5025500000000003,"INGEN DATA",1.9,1.973684210526316E-2]
["18-18,8",{"$f":"B67*1.05","v":1.5435000000000001},1.6361100000000002,1.6361100000000002,{"$f":"E67*1.05","v":12.039299999999999},1.8,2.368421052631579E-2]
[]
["LANDEVEJSBUSSER",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},"Elbus, endestation",{"$f":"Brintbus","v":"Brintbus"},"Diesel","KABINEVARME"]
["BUSLÆNGDE","kWh/km","kWh/km","kWh/km","kg H2/km","l/km","l HVO/km (depot)"]
["9-11,8",{"$f":"B63","v":0.95},{"$f":"C63*B79/B63","v":1.0069999999999999},{"$f":"C79","v":1.0069999999999999},"INGEN DATA",3.9,7.1428571428571426E-3]
["11,9-12,8",{"$f":"B64","v":1},{"$f":"C64*B80/B64","v":1.06},{"$f":"C80","v":1.06},{"$f":"E64","v":7.8},3.7,8.5714285714285719E-3]
["12,9-13,2",{"$f":"B65","v":1.02},1.0812000000000002,1.0812000000000002,"INGEN DATA",3.6,9.285714285714286E-3]
["14,5-15",{"$f":"B66","v":1.35},1.4310000000000003,1.4310000000000003,"INGEN DATA",2.7,1.0714285714285716E-2]
["18-18,8",{"$f":"B67","v":1.47},1.5582000000000003,1.5582000000000003,{"$f":"E67","v":11.465999999999999},2.4,1.2857142857142859E-2]
[]
["MOMSFRADRAG","Busmateriel","Ladere, garage","Ladere, byrum"]
["%",{"$f":"IF((ÅrØns-5)/ÅrØns>=0,(ÅrØns-5)/ÅrØns,0)","v":{"$error":"#DIV/0!"}},0,0,"kontraktperiode (x-5)/x"]
[null,null,"minus på ladere","jord og grit det kan man ikke",null,"bedre med 0"]
[null,"m",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,"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","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"]
[{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"0.6*B94","v":0.49349999999999983},0.56549999999999989,0.62549999999999983,0.72749999999999992,0.79499999999999993,0.86249999999999993,0.92999999999999994,0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,{"$f":"0.6*O94","v":1.2},null,{"$f":"0.6*Q94","v":0.49349999999999983},0.56549999999999989,0.62549999999999983,0.67949999999999988,0.72749999999999992,0.79499999999999993,{"$f":"0.6*W94","v":0.86249999999999993},{"$f":"0.6*X94","v":0.92999999999999994},0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,1.2,null,{"$f":"0.75*AG94","v":0.61687499999999984},0.70687499999999981,0.78187499999999988,0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1625000000000001,1.2468750000000002,1.3312499999999998,1.4156249999999999,{"$f":"0.75*AR94","v":1.5},1.5,1.5,1.5,null,{"$f":"0.6*AW94","v":0.56752499999999984},{"$f":"0.6*AX94","v":0.65032499999999982},0.71932499999999977,0.7814249999999997,0.83662499999999984,0.9142499999999999,0.99187499999999995,1.0694999999999999,1.147125,1.2247499999999998,1.3023749999999998,1.38,1.38,1.38,1.38,null,{"$f":"0.6*BM94","v":0.61687499999999984},{"$f":"0.6*BN94","v":0.70687499999999981},0.78187499999999976,0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1624999999999999,1.246875,1.33125,1.4156249999999999,1.5,1.5,1.5,1.5]
[{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},{"$f":"B90","v":0.49349999999999983},{"$f":"C90","v":0.56549999999999989},0.62549999999999983,0.72749999999999992,0.79499999999999993,0.86249999999999993,0.92999999999999994,0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,1.2,null,0.49349999999999983,0.56549999999999989,0.62549999999999983,0.67949999999999988,0.72749999999999992,0.79499999999999993,0.86249999999999993,0.92999999999999994,0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,1.2,null,0.61687499999999984,0.70687499999999981,0.78187499999999988,0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1625000000000001,1.2468750000000002,1.3312499999999998,1.4156249999999999,1.5,1.5,1.5,1.5,null,0.56752499999999984,0.65032499999999982,0.71932499999999977,0.7814249999999997,0.83662499999999984,0.9142499999999999,0.99187499999999995,1.0694999999999999,1.147125,1.2247499999999998,1.3023749999999998,1.38,1.38,1.38,1.38,null,0.61687499999999984,0.70687499999999981,{"$f":"BO90","v":0.78187499999999976},0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1624999999999999,1.246875,1.33125,1.4156249999999999,1.5,1.5,1.5,1.5]
[{"$f":"ElBy","v":"Elbus, endestation"},{"$f":"B90","v":0.49349999999999983},{"$f":"C90","v":0.56549999999999989},0.62549999999999983,0.72749999999999992,0.79499999999999993,0.86249999999999993,0.92999999999999994,0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,1.2,null,0.49349999999999983,0.56549999999999989,0.62549999999999983,0.67949999999999988,0.72749999999999992,0.79499999999999993,0.86249999999999993,0.92999999999999994,0.99750000000000005,1.0649999999999999,1.1324999999999998,1.2,1.2,1.2,1.2,null,0.61687499999999984,0.70687499999999981,0.78187499999999988,0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1625000000000001,1.2468750000000002,1.3312499999999998,1.4156249999999999,1.5,1.5,1.5,1.5,null,0.56752499999999984,0.65032499999999982,0.71932499999999977,0.7814249999999997,0.83662499999999984,0.9142499999999999,0.99187499999999995,1.0694999999999999,1.147125,1.2247499999999998,1.3023749999999998,1.38,1.38,1.38,1.38,null,0.61687499999999984,0.70687499999999981,{"$f":"BO90","v":0.78187499999999976},0.84937499999999988,0.90937499999999993,0.99374999999999991,1.078125,1.1624999999999999,1.246875,1.33125,1.4156249999999999,1.5,1.5,1.5,1.5]
[{"$f":"Brintbus","v":"Brintbus"},{"$f":"S_11*Q93","v":0.98699999999999966},{"$f":"S_11*R93","v":1.1309999999999998},{"$f":"S_11*S93","v":1.2509999999999997},{"$f":"S_11*U93","v":1.4549999999999998},{"$f":"S_11*V93","v":1.5899999999999999},{"$f":"S_11*W93","v":1.7249999999999999},{"$f":"S_11*X93","v":1.8599999999999999},{"$f":"S_11*Y93","v":1.9950000000000001},{"$f":"S_11*Z93","v":2.13},{"$f":"S_11*AA93","v":2.2649999999999997},{"$f":"S_11*AB93","v":2.4},{"$f":"S_11*AC93","v":2.4},{"$f":"S_11*AD93","v":2.4},{"$f":"S_11*AE93","v":2.4},null,{"$f":"Q94*1.2","v":0.98699999999999966},{"$f":"R94*1.2","v":1.1309999999999998},1.2509999999999997,1.3589999999999998,1.4549999999999998,1.5899999999999999,1.7249999999999999,1.8599999999999999,1.9950000000000001,2.13,2.2649999999999997,2.4,2.4,2.4,2.4,null,{"$f":"S_13*Q93","v":0.98699999999999966},{"$f":"S_13*R93","v":1.1309999999999998},{"$f":"S_13*S93","v":1.2509999999999997},{"$f":"S_13*T93","v":1.3589999999999998},{"$f":"S_13*U93","v":1.4549999999999998},{"$f":"S_13*V93","v":1.5899999999999999},{"$f":"S_13*W93","v":1.7249999999999999},{"$f":"S_13*X93","v":1.8599999999999999},{"$f":"S_13*Y93","v":1.9950000000000001},{"$f":"S_13*Z93","v":2.13},{"$f":"S_13*AA93","v":2.2649999999999997},{"$f":"S_13*AB93","v":2.4},{"$f":"S_13*AC93","v":2.4},{"$f":"S_13*AD93","v":2.4},{"$f":"S_13*AE93","v":2.4},null,{"$f":"S_15*Q93","v":1.1350499999999994},{"$f":"S_15*R93","v":1.3006499999999996},{"$f":"S_15*S93","v":1.4386499999999995},{"$f":"S_15*T93","v":1.5628499999999996},{"$f":"S_15*U93","v":1.6732499999999997},{"$f":"S_15*V93","v":1.8284999999999998},{"$f":"S_15*W93","v":1.9837499999999997},{"$f":"S_15*X93","v":2.1389999999999998},{"$f":"S_15*Y93","v":2.2942499999999999},{"$f":"S_15*Z93","v":2.4494999999999996},{"$f":"S_15*AA93","v":2.6047499999999992},{"$f":"S_15*AB93","v":2.76},{"$f":"S_15*AC93","v":2.76},{"$f":"S_15*AD93","v":2.76},{"$f":"S_15*AE93","v":2.76},null,{"$f":"S_18*Q93","v":1.2337499999999997},{"$f":"S_18*R93","v":1.4137499999999998},{"$f":"S_18*S93","v":1.5637499999999995},{"$f":"S_18*T93","v":1.6987499999999998},{"$f":"S_18*U93","v":1.8187499999999999},{"$f":"S_18*V93","v":1.9874999999999998},{"$f":"S_18*W93","v":2.15625},{"$f":"S_18*X93","v":2.3249999999999997},{"$f":"S_18*Y93","v":2.4937500000000004},{"$f":"S_18*Z93","v":2.6624999999999996},{"$f":"S_18*AA93","v":2.8312499999999998},{"$f":"S_18*AB93","v":3},{"$f":"S_18*AC93","v":3},{"$f":"S_18*AD93","v":3},{"$f":"S_18*AE93","v":3}]
["Diesel",{"$f":"S_11*Q94","v":0.82249999999999979},{"$f":"S_11*R94","v":0.94249999999999978},1.0424999999999998,{"$f":"S_11*U94","v":1.2124999999999999},{"$f":"S_11*V94","v":1.325},1.4375,1.55,1.6625000000000001,1.7749999999999999,1.8875,2,2,2,2,null,{"$f":"R94-0.12","v":0.82249999999999979},{"$f":"S94-0.1","v":0.94249999999999978},{"$f":"T94-0.09","v":1.0424999999999998},{"$f":"U94-0.08","v":1.1324999999999998},{"$f":"$W94-($AB94-$W94)*2/5","v":1.2124999999999999},{"$f":"$W94-($AB94-$W94)*1/5","v":1.325},{"$f":"1.25*1.15","v":1.4375},{"$f":"($AB94-$W94)*1/5+$W94","v":1.55},{"$f":"($AB94-$W94)*2/5+$W94","v":1.6625000000000001},{"$f":"($AB94-$W94)*3/5+$W94","v":1.7749999999999999},{"$f":"($AB94-$W94)*4/5+$W94","v":1.8875},{"$f":"1.6*1.25","v":2},{"$f":"AB94","v":2},{"$f":"AC94","v":2},2,null,{"$f":"S_13*Q94","v":0.82249999999999979},0.94249999999999978,1.0424999999999998,1.1324999999999998,1.2124999999999999,1.325,1.4375,1.55,1.6625000000000001,1.7749999999999999,1.8875,2,2,2,2,null,{"$f":"S_15*Q94","v":0.94587499999999969},1.0838749999999997,1.1988749999999997,1.3023749999999996,1.3943749999999997,1.5237499999999999,1.653125,1.7825,1.911875,2.0412499999999998,2.1706249999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,null,{"$f":"S_18*Q94","v":1.0281249999999997},1.1781249999999996,1.3031249999999996,1.4156249999999999,1.515625,1.65625,1.796875,1.9375,2.078125,2.21875,2.359375,2.5,2.5,2.5,2.5]
[]
["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]
["14,5-15",1.1499999999999999,8]
["18-18,8",1.25,8]
[]
["Servicepris  ift km/år ","% ift 12 m"]
[{"$f":"\"< \"&B104","v":"< 40000"},40000,1.1499999999999999]
[{"$f":"\">=\"&B104&\"; <\"&B105","v":">=40000; <45000"},45000,{"$f":"$C$110+($B$110-B105)/($B$110-$B$104)*($C$104-$C$110)","v":1.125}]
[">=45000; <50000",50000,{"$f":"$C$110+($B$110-B106)/($B$110-$B$104)*($C$104-$C$110)","v":1.0999999999999999}]
[">=50000; <55000",55000,{"$f":"$C$110+($B$110-B107)/($B$110-$B$104)*($C$104-$C$110)","v":1.075}]
[">=55000; <60000",60000,{"$f":"$C$110+($B$110-B108)/($B$110-$B$104)*($C$104-$C$110)","v":1.05}]
[">=60000; <65000",65000,{"$f":"$C$110+($B$110-B109)/($B$110-$B$104)*($C$104-$C$110)","v":1.0249999999999999}]
[">=65000; <70000",70000,1]
[">=70000; <75000",75000,1]
[">=75000; <80000",80000,1]
[">=80000; <85000",85000,1]
[">=85000; <90000",90000,1]
[">=90000; <95000",95000,1]
[">=95000; <100000",100000,1]
[">=100000; <105000",105000,1]
[">=105000; <110000",110000,1]
[">=110000; <115000",115000,1]
[">=115000; <120000",120000,1]
[">=120000; <125000",125000,1]
[">=125000; <130000",130000,1]
[">=130000; <135000",135000,1]
[">=135000; <140000",140000,1]
[">=140000; <145000",145000,1]
[{"$f":"\">\"&B125","v":">145000"},150000,1]
[]
["Ønsket løsning",1.1499999999999999]
["Reference",1.1499999999999999]
["% faste omkost, Ønsløsning",{"$f":"ÅrsKm-60%","v":0.54999999999999993}]
["% faste omkost, Ref løsning",{"$f":"ÅrsKmRef-60%","v":0.54999999999999993}]
[]
[null,"m","10 m",null,null,"12 m",null,null,"13 m",null,null,"15 m",null,null,"18 m"]
[null,null,{"$f":"ByPro","v":"Bybusser, provins/forstad"},{"$f":"ByKøb","v":"Bybusser, København"},{"$f":"Land","v":"Landevejsbusser"},{"$f":"ByPro","v":"Bybusser, provins/forstad"},{"$f":"ByKøb","v":"Bybusser, København"},{"$f":"Land","v":"Landevejsbusser"},{"$f":"ByPro","v":"Bybusser, provins/forstad"},{"$f":"ByKøb","v":"Bybusser, København"},{"$f":"Land","v":"Landevejsbusser"},{"$f":"ByPro","v":"Bybusser, provins/forstad"},{"$f":"ByKøb","v":"Bybusser, København"},{"$f":"Land","v":"Landevejsbusser"},{"$f":"ByKøb","v":"Bybusser, København"},{"$f":"ByPro","v":"Bybusser, provins/forstad"},{"$f":"Land","v":"Landevejsbusser"}]
["<40000",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"\">=\"&B135&\"; <\"&B136","v":">=0; <45000"},45000,0,0,0,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,0,0,0]
[">=50000; <55000",55000,0,0,0,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,0,0,0]
[">=60000; <65000",65000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[">=65000; <70000",70000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[">=70000; <75000",75000,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0]
[">=75000; <80000",80000,0,1,0,0,1,0,0,1,0,0,1,0,0,1,0]
[">=80000; <85000",85000,1,1,0,0,1,0,0,1,0,0,1,0,1,1,0]
[">=85000; <90000",90000,1,1,0,1,1,0,1,1,0,1,1,0,1,1,0]
[">=90000; <95000",95000,1,1,1,1,1,0,1,1,0,1,1,0,1,1,1]
[">=95000; <100000",100000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=100000; <105000",105000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=105000; <110000",110000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=110000; <115000",115000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=115000; <120000",120000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=120000; <125000",125000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=125000; <130000",130000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=130000; <135000",135000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=135000; <140000",140000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[">=140000; <145000",145000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$f":"\">\"&B156","v":">145000"},150000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["Ekstrabusfaktor",29]
[]
["Tomkørsel","Bybusser, provins/forstad","Bybusser, København","Landevejsbusser"]
["% af rutekm",0.09,0.1,0.11]
[]
[]
["Chaufførkørsel i p-bil"]
["kWh/km",0.18]
["kr./km",2.5]
["Antal p-biler/bus",0.3]
["km/p-bil",30000]
[]
["Garageanlæg","Bybusser, provins/forstad","Bybusser, København","Landevejsbusser"]
["kr./bus/år",70000,100000,70000]
[null,"9-11,8","11,9-12,8","12,9-13,2","14,5-15","18-18,8"]
[null,1,1,1,1.1499999999999999,1.4]
["kr/år for skader"]
[null,"km/år",75000]
["Bybusser, provins","kr./år",35000]
["Bybusser, storkøbenhavn","kr./år",45000]
["Landevejsbusser","kr./år",25000]
[]
["Busantal"]
["reservebusser, per x driftsbusser",10]
[]
["Pausefaciliteter"]
["kr./driftsbus/år",17000]
[]
["Busrengøring"]
["kr./driftsbus/år",30000]
[]
["DIESEL"]
["kr./l, inkl. moms",11.3]
[]
["HVO"]
["kr./l, inkl. moms",19.100000000000001]
[]
["EL"]
["kr./kWh, inkl. moms",1.2]
[]
["Brint",0,45000,50000,55000,60000,65000,70000,75000,80000,85000,90000,95000,100000,105000,110000,115000,120000,125000,130000,135000,140000,145000,150000]
["kr./kg, inkl. moms",39.1721,38.978400000000001,38.784700000000001,38.591000000000001,38.397300000000001,38.203600000000002,38.009900000000002,37.816200000000002,37.622500000000002,37.503300000000003,37.384100000000004,37.264899999999997,37.145699999999998,37.026499999999999,36.966499999999996,36.906499999999994,36.846499999999992,36.78649999999999,36.726499999999987,36.666499999999985,36.666499999999985,36.666499999999985,36.666499999999985]
[]
["ADBLUE"]
["kr./l, inkl. moms",5]
["forbrug, %-diesel",7.0000000000000007E-2]
[]
["PRIS, OLIE, INKL. MOMS"]
["kr./l",75]
["forbrug, %-diesel",2E-3]
[]
["PRIS, DÆK, INKL. MOMS",{"$f":"El_fyr","v":"Elbus, HVO-fyr"},{"$f":"El_el","v":"Elbus, 0-emis. opvarm."},"Elbus, endestation",{"$f":"Brintbus","v":"Brintbus"},"Diesel"]
["dæklevetid, km",{"$f":"0.8*DækLeve","v":76000},{"$f":"0.8*DækLeve","v":76000},{"$f":"0.8*DækLeve","v":76000},{"$f":"DækLeve","v":95000},95000]
["kr./stk.",3000]
[]
["CHAUFFØRLØN",1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["kr./t",0,1500,2000,2200,2500,2750,3000,3250,3500,3750,4000,4250,4500,100000]
["Bybusser, provins/forstad",400,400,400,400,400,400,400,400,400,400,400,400,400,400]
["Bybusser, København",430,430,430,430,430,430,430,430,430,430,430,430,430,430]
["Landevejsbusser",390,390,390,390,390,390,390,390,390,390,390,390,390,390]
[]
["AFKASTNINGSGRAD/PROFIT"]
["%",0.05]
[]
["CO2-udledning"]
["tank-til-hjul","El","Brint","HVO","Diesel"]
[null,"kg CO2e/kWh","kg CO2e/kg H2","kg CO2e/l","kg CO2e/l"]
["CO2 ",0,0,0,2.44]
[]
["HASTIGHED","Bybusser, provins/forstad","Bybusser, København","Landevejsbusser"]
["km/t",22,19,35]
[]
["Rente"]
["%",0.05]
[]
["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":1}]
["Kørselstype opslag",{"$f":"MATCH(kørselØ,KØRSELSTYPE,0)","v":1}]
["Laderopsplag",{"$f":"MATCH(EffDepLad,EFFEKT_DEPOT,0)","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,900,1000,1100,1200]

{"sheet":"LISTER","index":4,"n_rows":6,"n_cols":13,"rows_kept":6,"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,"Elbus, HVO-fyr","kWh/km",null,"9-11,8",null,"ja",null,null,50,null,150]
["Bybusser, København",null,"Elbus, 0-emis. opvarm.","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,75,null,450]
[null,null,"Brintbus","kg H2/100 km",null,"14,5-15",null,null,null,null,"150 (2*75)",null,600]
[null,null,null,null,null,"18-18,8",null,null,null,null,"240 (2*120)"]