{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Brugerinput og forudsætninger","Beregninger","Energipriser","Eksempel 1","Eksempel 2","Eksempel 3","Eksempel 4"],"not_rendered":{"charts":10,"images":5,"macros":1,"external_links":12,"defined_names":88,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Brugerinput og forudsætninger","index":0,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":false,"merged":[[66,5,66,6],[73,11,73,12],[1,9,1,10],[1,11,1,15],[4,13,11,15]]}
[]
[null,"Brugerberegning",null,null,null,null,null,null,null,"Bossident",null,"1234578 12345678 1234567812"]
[]
[null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,"RESULTAT:"]
[null,null,"Investeringer i nutidskroner ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((AND(N13=\"Beregningen er totaløkonomisk rentabel\",N24=\"Brugerøkonomien er positiv\")),\"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier.\",IF((AND(N13=\"Beregningen er IKKE totaløkonomisk rentabel\",N24=\"Brugerøkonomien er negativ\")),\"Kravet om totaløkonomisk rentabilitet såvel som en positiv brugerøkonomi er ikke opfyldt.\",IF((AND(N13=\"Beregningen er totaløkonomisk rentabel\",N24=\"Brugerøkonomien er negativ\")),\"Kravet om totaløkonomisk rentabilitet er opfyldt, men brugerøkonomien er negativ.\",IF((AND(N13=\"Beregningen er IKKE totaløkonomisk rentabel\",N24=\"Brugerøkonomien er positiv\")),\"Kravet om totaløkonomisk rentabilitet er ikke opfyldt, men brugerøkonomien er positiv.\",\"-\"))))","v":"-"}]
[null,null,null,null,"Initialinvesteringer ekskl. moms",null,null,null,null,null,{"$f":"-'Brugerinput og forudsætninger'!L64","v":0},"kr."]
[null,null,null,null,"Reinvesteringer ekskl. moms",null,null,null,null,null,{"$f":"Beregninger!H49","v":0},"kr."]
[null,null,null,null,"Ændring i årlige vedligeholdelsesomkostninger, tilslutningsafgifer m.v., ekskl. moms",null,null,null,null,null,{"$f":"Beregninger!I49+Beregninger!J49","v":0},"kr."]
[null,null,null,null,"Scrapværdi,  ekskl. moms",null,null,null,null,null,{"$f":"J64","v":0},"kr."]
[null,null,"Varmebesparelser, ekskl. moms",null,null,null,null,null,null,null,{"$f":"Beregninger!O49","v":0},"kr."]
[null,null,"Elbesparelser, ekskl. moms",null,null,null,null,null,null,null,{"$f":"Beregninger!S49","v":0},"kr."]
[]
[null,null,"Total, ekskl. moms",null,null,null,null,null,null,null,{"$f":"SUM(K6:K11)","v":0},"kr.",null,{"$f":"IF(K13>0,\"Beregningen er totaløkonomisk rentabel\",IF(K13<0,\"Beregningen er IKKE totaløkonomisk rentabel\"))","v":false}]
[]
[]
[]
[null,"Brugerøkonomi"]
[null,null,"Brugerøkonomi det første år"]
[null,null,null,null,"Brugerbetaling, ekskl. moms",null,null,null,null,null,{"$f":"-Beregninger!W9","v":0},"kr."]
[null,null,null,null,"Varmebesparelser det første år, ekskl. moms",null,null,null,null,null,{"$f":"Beregninger!O9","v":0},"kr."," "]
[null,null,null,null,"Elbesparelser det første år, ekskl. moms",null,null,null,null,null,{"$f":"Beregninger!S9","v":0},"kr."]
[null,null,null,null,"Årlige andre besparelser - f.eks. tilslutningsafgifter m.v., ekskl. moms",null,null,null,null,null,{"$f":"-O64","v":0},"kr."]
[]
[null,null,"Total, ekskl. moms",null,null,null,null,null,null,null,{"$f":"SUM(K19:K22)","v":0},"kr.",null,{"$f":"IF(K24<0,\"Brugerøkonomien er negativ\",IF(K24>0,\"Brugerøkonomien er positiv\"))","v":false}]
[]
[]
[]
[]
[null,"Investeringer og levetider - Forbedret bygning (ekskl. moms)"]
[null,null,null,null,null,null,"Levetid","Antal reinvesteringer","Afskrivningsfaktor efter 40 år","Scrapværdi efter 40 år. I nutidskroner","Dokumentation","Initialinvestering - Merpris eller totalpris","Dokumentation","Årlige vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Dokumentation"]
[null,null,null,null,null,"Kort beskrivelse","år",null,null,null,null,"Nutidskroner",null,"Nutidskroner","Nutidskroner"]
[null,"Tiltag 1"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G34)","v":0},{"$f":"IF(G34>0,((G34-(40-H34*G34))/G34),0)","v":0},{"$f":"IF(H34=0,(L34*I34)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G34*H34))*L34*I34)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G35)","v":0},{"$f":"IF(G35>0,((G35-(40-H35*G35))/G35),0)","v":0},{"$f":"IF(H35=0,(L35*I35)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G35*H35))*L35*I35)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 2"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G38)","v":0},{"$f":"IF(G38>0,((G38-(40-H38*G38))/G38),0)","v":0},{"$f":"IF(H38=0,(L38*I38)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G38*H38))*L38*I38)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G39)","v":0},{"$f":"IF(G39>0,((G39-(40-H39*G39))/G39),0)","v":0},{"$f":"IF(H39=0,(L39*I39)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G39*H39))*L39*I39)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 3"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G42)","v":0},{"$f":"IF(G42>0,((G42-(40-H42*G42))/G42),0)","v":0},{"$f":"IF(H42=0,(L42*I42)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G42*H42))*L42*I42)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G43)","v":0},{"$f":"IF(G43>0,((G43-(40-H43*G43))/G43),0)","v":0},{"$f":"IF(H43=0,(L43*I43)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G43*H43))*L43*I43)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 4"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G46)","v":0},{"$f":"IF(G46>0,((G46-(40-H46*G46))/G46),0)","v":0},{"$f":"IF(H46=0,(L46*I46)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G46*H46))*L46*I46)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G47)","v":0},{"$f":"IF(G47>0,((G47-(40-H47*G47))/G47),0)","v":0},{"$f":"IF(H47=0,(L47*I47)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G47*H47))*L47*I47)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 5"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G50)","v":0},{"$f":"IF(G50>0,((G50-(40-H50*G50))/G50),0)","v":0},{"$f":"IF(H50=0,(L50*I50)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G50*H50))*L50*I50)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G51)","v":0},{"$f":"IF(G51>0,((G51-(40-H51*G51))/G51),0)","v":0},{"$f":"IF(H51=0,(L51*I51)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G51*H51))*L51*I51)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 6"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G54)","v":0},{"$f":"IF(G54>0,((G54-(40-H54*G54))/G54),0)","v":0},{"$f":"IF(H54=0,(L54*I54)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G54*H54))*L54*I54)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G55)","v":0},{"$f":"IF(G55>0,((G55-(40-H55*G55))/G55),0)","v":0},{"$f":"IF(H55=0,(L55*I55)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G55*H55))*L55*I55)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 7"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G58)","v":0},{"$f":"IF(G58>0,((G58-(40-H58*G58))/G58),0)","v":0},{"$f":"IF(H58=0,(L58*I58)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G58*H58))*L58*I58)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G59)","v":0},{"$f":"IF(G59>0,((G59-(40-H59*G59))/G59),0)","v":0},{"$f":"IF(H59=0,(L59*I59)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G59*H59))*L59*I59)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 8"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G62)","v":0},{"$f":"IF(G62>0,((G62-(40-H62*G62))/G62),0)","v":0},{"$f":"IF(H62=0,(L62*I62)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G62*H62))*L62*I62)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G63)","v":0},{"$f":"IF(G63>0,((G63-(40-H63*G63))/G63),0)","v":0},{"$f":"IF(H63=0,(L63*I63)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G63*H63))*L63*I63)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,"Totaler",null,null,{"$f":"SUM(J32:J63)","v":0},null,{"$f":"SUM(L32:L63)","v":0},null,{"$f":"SUM(N34:N63)","v":0},{"$f":"SUM(O34:O63)","v":0}]
[]
[null,"Energibesparelser"]
[null,null,null,null,null,"Varme",null,"El","Dokumentation"]
[]
[null,null,null,null,null,"[kWh/m² pr. år]","[KWh/år]","[KWh/år]"]
[null,null,null,null,"Standard",0,0,0,"Afsnit X.X"]
[null,null,null,null,"Lavenergi",0,0,0,"Afsnit X.X"]
[null,null,null,null,"Besparelse",{"$f":"F70-F71","v":0},{"$f":"G70-G71","v":0},{"$f":"H70-H71","v":0}]
[]
[null,"Forudsætninger og mellemregninger",null,null,null,null,null,null,null,null,null,"Dokumentation"]
[null,null,"Totaløkonomiberegning"]
[null,null,null,null,"Faktisk initial merinvestering kr., ekskl. moms",null,null,null,null,null,{"$f":"'Brugerinput og forudsætninger'!L64*-1","v":0},"kr."]
[null,null,null,null,"Reinvesteringer i nutidskroner, ekskl. moms",null,null,null,null,null,{"$f":"Beregninger!H49","v":0},"kr."]
[null,null,null,null,"Scrapværdi, ekskl. moms",null,null,null,null,null,{"$f":"-J64","v":0},"kr."]
[]
[null,null,"Beboerøkonomi"]
[null,null,null,null,"Hovedstol i kr., ekskl. moms",null,null,null,null,null,{"$f":"K76*(1-K88)","v":0},"kr."]
[]
[null,null,"Renteforudsætninger"]
[null,null,null,null,"Nominel tilbagediskonteringsrente",null,null,null,null,null,3.7499999999999999E-2]
[null,null,null,null,"Inflation",null,null,null,null,null,1.7999999999999999E-2]
[null,null,null,null,"Nominel prisstigning på energibesparende tiltag",null,null,null,null,null,8.0000000000000002E-3]
[null,null,null,null,"Beboerbetalingsprocent",null,null,null,null,null,3.1E-2]
[null,null,null,null,"Beboerindskud",null,null,null,null,null,0.02]
[null,null,null,null,"Bidrag på lån",null,null,null,null,null,2.7000000000000001E-3]
[]
[null,null,"Elpriser"]
[null,null,null,null,"Elpris inkl. afgifter men ekskl. faste bidrag og moms",null,null,null,null,null,0,"kr / kWh","Afsnit X.X"]
[null,null,"Varmeforsyning og priser (ekskl. moms)"]
[null,null,null,"Før tiltag"]
[null,null,null,null,"Varmekilde 1:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0,"kr / kWh","Afsnit X.X"]
[null,null,null,"Efter tiltag"]
[null,null,null,null,"Varmekilde 2:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0,"kr / kWh","Afsnit X.X"]

{"sheet":"Beregninger","index":1,"n_rows":49,"n_cols":45,"rows_kept":49,"cut":false,"hidden":true,"merged":[[1,20,1,23],[2,6,2,7],[2,1,2,4],[3,10,3,11],[1,6,1,18],[1,1,1,4],[3,12,3,13],[2,10,2,14],[2,16,2,18]]}
[]
[null,"Stamdata",null,null,null,null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beboerbetaling",null,null,null,null,null,null,"TIL PLOT","TIL PLOT","TIL PLOT","TIL PLOT","TIL PLOT","TIL PLOT","TIL PLOT"]
[null,"År og inflations- og produktivitetsindeks",null,null,null,null,"Reinvesteringer",null,null,null,"Varmebesparelser",null,null,null,null,null,"Elbesparelser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For at 1. årsbetingelsen er overholdt - reduktionen i forsyningsudgifter for en normalforbruger på ibrugtagelsestidspunktet skal opveje betalingen vedr. merinvesteringen - skal denne mindst være lig 1. årsenergibesparelsen.  "]
[null,null,null,null,null,null,null,null,null,null,"Varmepris 1 før energiinvestering",null,"Varmepris 2 efter energiinvestering",null,"Besparelse",null,null,null,null,null,null,null,null,null,null,null,null,"Varmebesparelser - Akkumulerede nutidskroner","Elbesparelser - Akkumulerede nutidskroner","Besparelser på årlige vedligeholdelsesomkostninger samt service og tilsyn - Akkumulerede nutidskroner","Besparelser på årlige udgifter der ikke indeholder service, tilsyn eller vedligehold - Akkumulerede nutidskroner","Scrapværdi af investeringer - Nutidskroner","Initialinvestering + reinvesteringer - Nutidskroner","Resultat",null,null,null,null,null,null,null,"Fastsættelsen af beboerbetaling og bidrag vedr. merinvesteringen tager udgangspunkt i den faktiske initiale merinvestering (dvs. uden korrektioner, som foretages ved nutidsværdiberegningen)."]
[null,"År","År","Inflationsindeks","Produktivitetsindeks",null,"Reinvesteringer (initialpriser)","Reinvesteringer korrigeret for produktivitetsindeks","vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Prisindeks","Pris","Prisindeks","Pris",null,null,"Prisindeks","Pris","Besparelse",null,"Beb.bet","Bidrag","I alt",null,"Besp.-beb.-dv",null,null,"kr","kr","kr","kr",null,"kr","kr"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(EnergiIndeks,B9,$AS$8)","v":"Fjernvarme"},"kr. / kWh",{"$f":"INDEX(EnergiIndeks,B9,$AS$9)","v":"Fjernvarme"},"kr. / kWh",null,null,"El","kr. / kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEDENSTÅENDE KUN TIL BEREGNINGER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brændselsforudsætninger"]
[null,0,2011,{"$f":"(1+Inflation)^(B8)","v":1},{"$f":"(1+Produktivitetsindeks)^(B8)","v":1},null,null,{"$f":"-G8*E8","v":0},0,0,{"$f":"INDEX(EnergiIndeks,B8+3,$AS$8)","v":100},{"$f":"varmepris1","v":0},{"$f":"INDEX(EnergiIndeks,B8+3,$AS$9)","v":100},{"$f":"varmepris2","v":0},0,null,{"$f":"Energipriser!G5","v":100},{"$f":"Elpris","v":0},0,null,0,0,{"$f":"U8+V8","v":0},null,null,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$8:O8))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$8:S8))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$8:I8))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$8:J8))","v":0},null,{"$f":"-('Brugerinput og forudsætninger'!L64)*(1+Tilbagediskonteringsrente)^-(B8)","v":0},{"$f":"AB8+AC8+AD8+AE8+SUM($AF$8:AF8)+SUM($AG$8:AG8)","v":0},null,null,null,null,null,null,null,null,"Brændsel før",{"$f":"Varmekilde1","v":"Fjernvarme"},{"$f":"IF(AR8=AQ15,AR15,IF(AR8=AQ16,AR16,IF(AR8=AQ17,AR17,IF(AR8=AQ18,AR18,IF(AR8=AQ19,AR19)))))","v":1}]
[null,1,{"$f":"C8+1","v":2012},{"$f":"(1+Inflation)^(B9)","v":1.018},{"$f":"(1+Produktivitetsindeks)^(B9)","v":1.008},null,null,{"$f":"-G9*E9","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D9","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D9","v":0},{"$f":"INDEX(EnergiIndeks,B9+3,$AS$8)*D9","v":101.9583203732504},{"$f":"$L$8*K9/100","v":0},{"$f":"INDEX(EnergiIndeks,B9+3,$AS$9)*D9","v":101.9583203732504},{"$f":"$N$8*M9/100","v":0},{"$f":"L9*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N9","v":0},null,{"$f":"Energipriser!G5*D9","v":101.8},{"$f":"$R$8*Q9/100","v":0},{"$f":"R9*Elbesparelse","v":0},null,{"$f":"'Brugerinput og forudsætninger'!K87*'Brugerinput og forudsætninger'!K76","v":0},{"$f":"'Brugerinput og forudsætninger'!K81*'Brugerinput og forudsætninger'!K89","v":0},{"$f":"U9+V9","v":0},null,{"$f":"S9+O9-W9+I9+J9","v":0},null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O9))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S9))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I9))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J9))","v":0},null,{"$f":"H9*(1+Tilbagediskonteringsrente)^-(B9)","v":0},{"$f":"AB9+AC9+AD9+AE9+SUM($AF$8:AF9)+SUM($AG$8:AG9)","v":0},null,null,null,null,null,null,null,null,"Brændesl efter",{"$f":"Varmekilde2","v":"Fjernvarme"},{"$f":"IF(AR9=AQ15,AR15,IF(AR9=AQ16,AR16,IF(AR9=AQ17,AR17,IF(AR9=AQ18,AR18,IF(AR9=AQ19,AR19)))))","v":1}]
[null,2,2013,1.036324,1.0160640000000001,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D10","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D10","v":0},105.72761181959565,{"$f":"$L$8*K10/100","v":0},105.72761181959565,{"$f":"$N$8*M10/100","v":0},{"$f":"L10*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N10","v":0},null,{"$f":"Energipriser!G5*D10","v":103.6324},0,{"$f":"R10*Elbesparelse","v":0},null,{"$f":"U9*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},{"$f":"V9","v":0},{"$f":"U10+V10","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O10))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S10))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I10))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J10))","v":0},null,0,{"$f":"AB10+AC10+AD10+AE10+SUM($AF$8:AF10)+SUM($AG$8:AG10)","v":0},null,null,null,null,null,null,null,null,"Varmepris, før",{"$f":"varmepris1","v":0}]
[null,3,2014,1.0549778320000001,1.0241925120000002,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D11","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D11","v":0},107.79478003483673,0,107.79478003483673,0,{"$f":"L11*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N11","v":0},null,{"$f":"Energipriser!G6*D11","v":108.77993645511113},0,0,null,{"$f":"U10*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},{"$f":"V10","v":0},{"$f":"U11+V11","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O11))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S11))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I11))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J11))","v":0},null,0,{"$f":"AB11+AC11+AD11+AE11+SUM($AF$8:AF11)+SUM($AG$8:AG11)","v":0},null,null,null,null,null,null,null,null,"Varmepris, efter",{"$f":"varmepris2","v":0}]
[null,4,2015,1.0739674329760001,1.0323860520960002,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D12","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D12","v":0},110.06913504373004,0,110.06913504373004,0,{"$f":"L12*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N12","v":0},null,{"$f":"Energipriser!G7*D12","v":109.14691244763497},0,{"$f":"R12*Elbesparelse","v":0},null,{"$f":"U11*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},{"$f":"V11","v":0},{"$f":"U12+V12","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O12))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S12))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I12))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J12))","v":0},null,0,{"$f":"AB12+AC12+AD12+AE12+SUM($AF$8:AF12)+SUM($AG$8:AG12)","v":0}]
[null,5,2016,1.0932988467695681,1.0406451405127681,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D13","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D13","v":0},115.45099797146761,0,115.45099797146761,0,{"$f":"L13*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N13","v":0},null,{"$f":"Energipriser!G8*D13","v":111.11155687169241},0,0,null,{"$f":"U12*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,{"$f":"U13+V13","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O13))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S13))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I13))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J13))","v":0},null,0,{"$f":"AB13+AC13+AD13+AE13+SUM($AF$8:AF13)+SUM($AG$8:AG13)","v":0}]
[null,6,2017,1.1129782260114203,1.0489703016368703,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D14","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D14","v":0},116.31747556449056,0,116.31747556449056,0,{"$f":"L14*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N14","v":0},null,{"$f":"Energipriser!G9*D14","v":116.57416382075172},0,0,null,{"$f":"U13*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O14))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S14))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I14))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J14))","v":0},null,0,{"$f":"AB14+AC14+AD14+AE14+SUM($AF$8:AF14)+SUM($AG$8:AG14)","v":0},null,null,null,null,null,null,null,"Offset (kun til beregninger)"]
[null,7,2018,1.133011834079626,1.0573620640499655,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D15","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D15","v":0},117.88256874016636,0,117.88256874016636,0,{"$f":"L15*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N15","v":0},null,{"$f":"Energipriser!G10*D15","v":120.51888842506244},0,0,null,{"$f":"U14*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O15))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S15))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I15))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J15))","v":0},null,0,{"$f":"AB15+AC15+AD15+AE15+SUM($AF$8:AF15)+SUM($AG$8:AG15)","v":0},null,null,null,null,null,null,null,null,"Fjernvarme",1]
[null,8,2019,1.1534060470930592,1.0658209605623652,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D16","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D16","v":0},121.43948582923809,0,121.43948582923809,0,{"$f":"L16*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N16","v":0},null,{"$f":"Energipriser!G11*D16","v":124.39697811611069},0,0,null,{"$f":"U15*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,{"$f":"U16+V16","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O16))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S16))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I16))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J16))","v":0},null,0,{"$f":"AB16+AC16+AD16+AE16+SUM($AF$8:AF16)+SUM($AG$8:AG16)","v":0},null,null,null,null,null,null,null,null,"El",5]
[null,9,2020,1.1741673559407342,1.0743475282468642,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D17","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D17","v":0},123.62539657416437,0,123.62539657416437,0,{"$f":"L17*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N17","v":0},null,{"$f":"Energipriser!G12*D17","v":124.89661652821441},0,0,null,{"$f":"U16*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O17))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S17))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I17))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J17))","v":0},null,0,{"$f":"AB17+AC17+AD17+AE17+SUM($AF$8:AF17)+SUM($AG$8:AG17)","v":0},null,null,null,null,null,null,null,null,"Naturgas",9]
[null,10,2021,1.1953023683476676,1.0829423084728391,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D18","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D18","v":0},126.40833755465222,0,126.40833755465222,0,{"$f":"L18*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N18","v":0},null,{"$f":"Energipriser!G13*D18","v":127.14475562572228},0,{"$f":"R18*Elbesparelse","v":0},null,{"$f":"U17*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,{"$f":"U18+V18","v":0},null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O18))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S18))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I18))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J18))","v":0},null,0,{"$f":"AB18+AC18+AD18+AE18+SUM($AF$8:AF18)+SUM($AG$8:AG18)","v":0},null,null,null,null,null,null,null,null,"Gasolie",13]
[null,11,2022,1.2168178109779255,1.091605846940622,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D19","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D19","v":0},129.44065049905149,0,129.44065049905149,0,{"$f":"L19*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N19","v":0},null,{"$f":"Energipriser!G14*D19","v":129.43336122698528},0,0,null,{"$f":"U18*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O19))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S19))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I19))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J19))","v":0},null,0,{"$f":"AB19+AC19+AD19+AE19+SUM($AF$8:AF19)+SUM($AG$8:AG19)","v":0},null,null,null,null,null,null,null,null,"Træpiller",17]
[null,12,2023,1.2387205315755281,1.100338693716147,null,null,{"$f":"-G20*E20","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D20","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D20","v":0},132.19997296021617,0,132.19997296021617,0,{"$f":"L20*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N20","v":0},null,{"$f":"Energipriser!G15*D20","v":129.74450604798494},0,0,null,{"$f":"U19*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O20))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S20))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I20))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J20))","v":0},null,0,{"$f":"AB20+AC20+AD20+AE20+SUM($AF$8:AF20)+SUM($AG$8:AG20)","v":0}]
[null,13,2024,1.2610175011438878,1.109141403265876,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D21","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D21","v":0},135.01811666814791,0,135.01811666814791,0,{"$f":"L21*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N21","v":0},null,{"$f":"Energipriser!G16*D21","v":132.07990715684869},0,0,null,{"$f":"U20*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O21))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S21))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I21))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J21))","v":0},null,0,{"$f":"AB21+AC21+AD21+AE21+SUM($AF$8:AF21)+SUM($AG$8:AG21)","v":0}]
[null,14,2025,1.2837158161644777,1.1180145344920032,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D22","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D22","v":0},137.89633553177535,0,137.89633553177535,0,{"$f":"L22*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N22","v":0},null,{"$f":"Energipriser!G16*D22","v":134.45734548567196},0,0,null,{"$f":"U21*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O22))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S22))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I22))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J22))","v":0},null,0,{"$f":"AB22+AC22+AD22+AE22+SUM($AF$8:AF22)+SUM($AG$8:AG22)","v":0}]
[null,15,2026,1.3068227008554385,1.1269586507679392,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D23","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D23","v":0},140.83591018995375,0,140.83591018995375,0,{"$f":"L23*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N23","v":0},null,{"$f":"Energipriser!G17*D23","v":136.87757770441408},0,0,null,{"$f":"U22*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O23))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S23))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I23))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J23))","v":0},null,0,{"$f":"AB23+AC23+AD23+AE23+SUM($AF$8:AF23)+SUM($AG$8:AG23)","v":0}]
[null,16,2027,1.3303455094708363,1.1359743199740828,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D24","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D24","v":0},143.83814858127394,0,143.83814858127394,0,{"$f":"L24*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N24","v":0},null,{"$f":"Energipriser!G18*D24","v":139.34137410309353},0,0,null,{"$f":"U23*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O24))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S24))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I24))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J24))","v":0},null,0,{"$f":"AB24+AC24+AD24+AE24+SUM($AF$8:AF24)+SUM($AG$8:AG24)","v":0}]
[null,17,2028,1.3542917286413114,1.1450621145338755,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D25","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D25","v":0},146.90438652601887,0,146.90438652601887,0,{"$f":"L25*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N25","v":0},null,{"$f":"Energipriser!G19*D25","v":139.84316072044356},0,0,null,{"$f":"U24*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O25))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S25))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I25))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J25))","v":0},null,0,{"$f":"AB25+AC25+AD25+AE25+SUM($AF$8:AF25)+SUM($AG$8:AG25)","v":0}]
[null,18,2029,1.378668979756855,1.1542226114501466,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D26","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D26","v":0},150.03598832052495,0,150.03598832052495,0,{"$f":"L26*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N26","v":0},null,{"$f":"Energipriser!G20*D26","v":144.4028101760143},0,0,null,{"$f":"U25*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O26))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S26))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I26))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J26))","v":0},null,0,{"$f":"AB26+AC26+AD26+AE26+SUM($AF$8:AF26)+SUM($AG$8:AG26)","v":0}]
[null,19,2030,1.4034850213924783,1.1634563923417478,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D27","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D27","v":0},153.23434734421434,0,153.23434734421434,0,{"$f":"L27*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N27","v":0},null,{"$f":"Energipriser!G21*D27","v":147.00206075918254},0,0,null,{"$f":"U26*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O27))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S27))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I27))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J27))","v":0},null,{"$f":"H27*(1+Tilbagediskonteringsrente)^-(B27)","v":0},{"$f":"AB27+AC27+AD27+AE27+SUM($AF$8:AF27)+SUM($AG$8:AG27)","v":0}]
[null,20,2031,1.4287477517775431,1.1727640434804818,null,null,{"$f":"-G28*E28","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D28","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D28","v":0},156.50088667956715,0,156.50088667956715,0,{"$f":"L28*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N28","v":0},null,{"$f":"Energipriser!G22*D28","v":149.64809785284785},0,0,null,{"$f":"U27*(1+'Brugerinput og forudsætninger'!$K$85)","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O28))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S28))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I28))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J28))","v":0},null,0,{"$f":"AB28+AC28+AD28+AE28+SUM($AF$8:AF28)+SUM($AG$8:AG28)","v":0}]
[null,21,2032,1.4544652113095389,1.1821461558283257,null,null,{"$f":"-G29*E29","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D29","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D29","v":0},159.83705974530966,0,159.83705974530966,0,{"$f":"L29*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N29","v":0},null,{"$f":"Energipriser!G23*D29","v":152.34176361419912},0,0,null,{"$f":"U28*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O29))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S29))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I29))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J29))","v":0},null,0,{"$f":"AB29+AC29+AD29+AE29+SUM($AF$8:AF29)+SUM($AG$8:AG29)","v":0}]
[null,22,2033,1.4806455851131104,1.1916033250749523,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D30","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D30","v":0},163.24435094310064,0,163.24435094310064,0,{"$f":"L30*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N30","v":0},null,{"$f":"Energipriser!G24*D30","v":155.08391535925469},0,0,null,{"$f":"U29*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O30))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S30))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I30))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J30))","v":0},null,0,{"$f":"AB30+AC30+AD30+AE30+SUM($AF$8:AF30)+SUM($AG$8:AG30)","v":0}]
[null,23,2034,1.5072972056451468,1.2011361516755521,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D31","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D31","v":0},166.72427631800332,0,166.72427631800332,0,{"$f":"L31*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N31","v":0},null,{"$f":"Energipriser!G25*D31","v":157.8754258357213},0,0,null,{"$f":"U30*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O31))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S31))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I31))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J31))","v":0},null,0,{"$f":"AB31+AC31+AD31+AE31+SUM($AF$8:AF31)+SUM($AG$8:AG31)","v":0}]
[null,24,2035,1.5344285553467591,1.2107452408889565,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D32","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D32","v":0},170.27838423303626,0,170.27838423303626,0,{"$f":"L32*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N32","v":0},null,{"$f":"Energipriser!G26*D32","v":160.71718350076426},0,0,null,{"$f":"U31*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O32))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S32))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I32))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J32))","v":0},null,0,{"$f":"AB32+AC32+AD32+AE32+SUM($AF$8:AF32)+SUM($AG$8:AG32)","v":0}]
[null,25,2036,1.5620482693430009,1.2204312028160682,null,null,{"$f":"-G33*E33","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D33","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D33","v":0},173.90825605810483,0,173.90825605810483,0,{"$f":"L33*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N33","v":0},null,{"$f":"Energipriser!G27*D33","v":164.00942609795874},0,0,null,{"$f":"U32*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O33))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S33))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I33))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J33))","v":0},null,0,{"$f":"AB33+AC33+AD33+AE33+SUM($AF$8:AF33)+SUM($AG$8:AG33)","v":0}]
[null,26,2037,1.590165138191175,1.2301946524385969,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D34","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D34","v":0},177.61550687361759,0,177.61550687361759,0,{"$f":"L34*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N34","v":0},null,{"$f":"Energipriser!G28*D34","v":167.36910928291542},0,0,null,{"$f":"U33*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O34))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S34))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I34))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J34))","v":0},null,0,{"$f":"AB34+AC34+AD34+AE34+SUM($AF$8:AF34)+SUM($AG$8:AG34)","v":0}]
[null,27,2038,1.6187881106786162,1.2400362096581059,null,null,{"$f":"-G35*E35","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D35","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D35","v":0},181.40178618910295,0,181.40178618910295,0,{"$f":"L35*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N35","v":0},null,{"$f":"Energipriser!G29*D35","v":170.79761455555226},0,0,null,{"$f":"U34*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O35))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S35))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I35))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J35))","v":0},null,0,{"$f":"AB35+AC35+AD35+AE35+SUM($AF$8:AF35)+SUM($AG$8:AG35)","v":0}]
[null,28,2039,1.647926296670831,1.2499564993353707,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D36","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D36","v":0},185.26877867714407,0,185.26877867714407,0,{"$f":"L36*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N36","v":0},null,{"$f":"Energipriser!G30*D36","v":174.29635171539249},0,0,null,{"$f":"U35*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O36))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S36))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I36))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J36))","v":0},null,0,{"$f":"AB36+AC36+AD36+AE36+SUM($AF$8:AF36)+SUM($AG$8:AG36)","v":0}]
[null,29,2040,1.6775889700109063,1.2599561513300535,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D37","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D37","v":0},189.21820492295967,0,189.21820492295967,0,{"$f":"L37*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N37","v":0},null,{"$f":"Energipriser!G31*D37","v":177.86675944127376},0,0,null,{"$f":"U36*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O37))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S37))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I37))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J37))","v":0},null,{"$f":"H37*(1+Tilbagediskonteringsrente)^-(B37)","v":0},{"$f":"AB37+AC37+AD37+AE37+SUM($AF$8:AF37)+SUM($AG$8:AG37)","v":0}]
[null,30,2041,1.7077855714711025,1.270035800540694,null,null,{"$f":"-G38*E38","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D38","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D38","v":0},193.25182218996355,0,193.25182218996355,0,{"$f":"L38*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N38","v":0},null,{"$f":"Energipriser!G33*D38","v":181.95332933664321},0,0,null,{"$f":"U37*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},{"$f":"V37","v":0},0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O38))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S38))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I38))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J38))","v":0},null,0,{"$f":"AB38+AC38+AD38+AE38+SUM($AF$8:AF38)+SUM($AG$8:AG38)","v":0}]
[null,31,2042,1.7385257117575825,1.2801960869450197,null,null,{"$f":"-G39*E39","v":0},{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D39","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D39","v":0},197.37142520164403,0,197.37142520164403,0,{"$f":"L39*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N39","v":0},null,{"$f":"Energipriser!G34*D39","v":185.68058791904988},0,0,null,{"$f":"U38*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},{"$f":"V38","v":0},0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O39))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S39))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I39))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J39))","v":0},null,0,{"$f":"AB39+AC39+AD39+AE39+SUM($AF$8:AF39)+SUM($AG$8:AG39)","v":0}]
[null,32,2043,1.7698191745692189,1.2904376556405799,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D40","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D40","v":0},201.57884694011076,0,201.57884694011076,0,{"$f":"L40*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N40","v":0},null,{"$f":"Energipriser!G35*D40","v":189.48419825929889},0,0,null,{"$f":"U39*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O40))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S40))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I40))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J40))","v":0},null,0,{"$f":"AB40+AC40+AD40+AE40+SUM($AF$8:AF40)+SUM($AG$8:AG40)","v":0}]
[null,33,2044,1.8016759197114649,1.3007611568857045,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D41","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D41","v":0},205.87595946166448,0,205.87595946166448,0,{"$f":"L41*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N41","v":0},null,{"$f":"Energipriser!G36*D41","v":193.36572439991559},0,0,null,{"$f":"U40*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O41))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S41))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I41))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J41))","v":0},null,0,{"$f":"AB41+AC41+AD41+AE41+SUM($AF$8:AF41)+SUM($AG$8:AG41)","v":0}]
[null,34,2045,1.8341060862662713,1.3111672461407902,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D42","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D42","v":0},210.2646747297523,0,210.2646747297523,0,{"$f":"L42*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N42","v":0},null,{"$f":"Energipriser!G37*D42","v":197.32676242236039},0,0,null,{"$f":"U41*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O42))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S42))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I42))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J42))","v":0},null,0,{"$f":"AB42+AC42+AD42+AE42+SUM($AF$8:AF42)+SUM($AG$8:AG42)","v":0}]
[null,35,2046,1.8671199958190643,1.3216565841099166,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D43","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D43","v":0},214.74694546567963,0,214.74694546567963,0,{"$f":"L43*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N43","v":0},null,{"$f":"Energipriser!G38*D43","v":201.36894110333685},0,0,null,{"$f":"U42*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O43))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S43))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I43))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J43))","v":0},null,0,{"$f":"AB43+AC43+AD43+AE43+SUM($AF$8:AF43)+SUM($AG$8:AG43)","v":0}]
[null,36,2047,1.9007281557438074,1.3322298367827961,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D44","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D44","v":0},219.3247660174568,0,219.3247660174568,0,{"$f":"L44*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N44","v":0},null,{"$f":"Energipriser!G39*D44","v":205.49392258454353},0,0,null,{"$f":"U43*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O44))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S44))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I44))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J44))","v":0},null,0,{"$f":"AB44+AC44+AD44+AE44+SUM($AF$8:AF44)+SUM($AG$8:AG44)","v":0}]
[null,37,2048,1.934941262547196,1.3428876754770585,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D45","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D45","v":0},224.00017324716706,0,224.00017324716706,0,{"$f":"L45*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N45","v":0},null,{"$f":"Energipriser!G40*D45","v":209.70340305614599},0,0,null,{"$f":"U44*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O45))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S45))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I45))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J45))","v":0},null,0,{"$f":"AB45+AC45+AD45+AE45+SUM($AF$8:AF45)+SUM($AG$8:AG45)","v":0}]
[null,38,2049,1.9697702052730455,1.3536307768808749,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D46","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D46","v":0},228.77524743725098,0,228.77524743725098,0,{"$f":"L46*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N46","v":0},null,{"$f":"Energipriser!G41*D46","v":213.99911345424908},0,0,null,{"$f":"U45*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O46))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S46))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I46))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J46))","v":0},null,0,{"$f":"AB46+AC46+AD46+AE46+SUM($AF$8:AF46)+SUM($AG$8:AG46)","v":0}]
[null,39,{"$f":"C46+1","v":2050},2.0052260689679606,1.3644598230959222,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D47","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D47","v":0},{"$f":"INDEX(EnergiIndeks,B47+2,$AS$8)*D47","v":232.89320189112152},0,{"$f":"INDEX(EnergiIndeks,B47+2,$AS$9)*D47","v":232.89320189112152},0,{"$f":"L47*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N47","v":0},null,{"$f":"Energipriser!G42*D47","v":218.38282017265726},0,0,null,{"$f":"U46*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,{"$f":"S47+O47-W47+I47+J47","v":0},null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O47))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S47))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I47))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J47))","v":0},null,0,{"$f":"AB47+AC47+AD47+AE47+SUM($AF$8:AF47)+SUM($AG$8:AG47)","v":0}]
[null,40,2051,2.0413201382093837,1.3753755016806894,null,null,0,{"$f":"-('Brugerinput og forudsætninger'!$N$64)*D48","v":0},{"$f":"-('Brugerinput og forudsætninger'!$O$64)*D48","v":0},{"$f":"INDEX(EnergiIndeks,B48+1,$AS$8)*D48","v":237.0852795251617},0,{"$f":"INDEX(EnergiIndeks,B48+1,$AS$9)*D48","v":237.0852795251617},0,{"$f":"L48*'Brugerinput og forudsætninger'!$G$70-'Brugerinput og forudsætninger'!$G$71*Beregninger!N48","v":0},null,{"$f":"Energipriser!G43*D48","v":222.8563257892142},0,0,null,{"$f":"U47*(1+(0.75*'Brugerinput og forudsætninger'!$K$85))","v":0},0,0,null,0,null,null,{"$f":"(NPV(Tilbagediskonteringsrente,$O$9:O48))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$S$9:S48))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$I$9:I48))","v":0},{"$f":"(NPV(Tilbagediskonteringsrente,$J$9:J48))","v":0},{"$f":"'Brugerinput og forudsætninger'!J64","v":0},0,{"$f":"AB48+AC48+AD48+AE48+SUM($AF$8:AF48)+SUM($AG$8:AG48)","v":0}]
[null,null,null,null,null,null,null,{"$f":"NPV(Tilbagediskonteringsrente,H9:H48)","v":0},{"$f":"NPV(Tilbagediskonteringsrente,I9:I48)","v":0},{"$f":"NPV(Tilbagediskonteringsrente,J9:J48)","v":0},null,null,null,null,{"$f":"NPV(Tilbagediskonteringsrente,O9:O48)","v":0},null,null,null,{"$f":"NPV(Tilbagediskonteringsrente,S9:S48)","v":0},null,null,null,{"$f":"NPV(Tilbagediskonteringsrente,W9:W48)","v":0},null,{"$f":"NPV(Tilbagediskonteringsrente,Y9:Y48)","v":0}]

{"sheet":"Energipriser","index":2,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[[61,5,61,8],[1,17,1,19],[1,13,1,16],[1,1,1,4],[1,5,1,8],[1,9,1,12]]}
["3: Energistyrelsens fremskrivninger"]
["Reference:Samfundsøkonomiske beregningsforudsætninger for energipriser og emissioner, Maj 2017","Fjernvarme",null,null,null,"El",null,null,null,"Naturgas",null,null,null,"Gasolie",null,null,null,"Træpiller"]
[null,"2009-Kr./GJ","Fjernvarme",null,null,"2019-Kr./MWh","El",null,null,"2019-Kr./GJ","Naturgas",null,null,"2019-Kr./GJ","Gasolie",null,null,"2019-Kr./GJ","Gasolie"]
[null,"An forbruger","Indeks","% stigning","Beregningstjek","An forbruger","Indeks","% stigning","Beregningstjek","An forbruger","Indeks","% stigning","Beregningstjek","An forbruger","Indeks","% stigning","Beregningstjek","An forbruger","Indeks","% stigning"]
[2019," 64,3 ",100,0,{"$f":"C5","v":100},675,100,0,{"$f":"G5","v":100},53.9,100,0,{"$f":"K5","v":100},118.1,100,0,{"$f":"O5","v":100},104.8,100,0,{"$f":"#REF!*(1+$T$23/100)","v":{"$error":"#REF!"}}]
[{"$f":"A5+1","v":2020}," 64,4 ",{"$f":"C5*(100+D6)/100","v":100.15552099533438},{"$f":"(B6/B5-1)*100","v":0.15552099533437946},{"$f":"E5*(1+$D$23/100)","v":100.32586237761618},696,{"$f":"G5*(100+H6)/100","v":103.11111111111111},{"$f":"(F6/F5-1)*100","v":3.1111111111111089},{"$f":"I5*(1+$H$23/100)","v":100},48,{"$f":"K5*(100+L6)/100","v":89.053803339517629},{"$f":"(J6/J5-1)*100","v":-10.946196660482377},{"$f":"M5*(1+$L$23/100)","v":101.07142857142857},120.1,{"$f":"O5*(100+P6)/100","v":101.69348010160883},{"$f":"(N6/N5-1)*100","v":1.693480101608813},{"$f":"Q5*(1+$P$23/100)","v":100.95693779904305},105.7,{"$f":"S5*(100+T6)/100","v":100.8587786259542},{"$f":"(R6/R5-1)*100","v":0.85877862595420407},{"$f":"U5*(1+$T$23/100)","v":{"$error":"#REF!"}}]
[{"$f":"A6+1","v":2021}," 65,6 ",102.02177293934682,{"$f":"(B7/B6-1)*100","v":1.8633540372670732},100.65278661812381,686,101.62962962962963,-1.4367816091954033,100,40.6,75.324675324675326,-15.416666666666668,102.15433673469387,121.9,103.21761219305678,1.498751040799351,101.92303289759846,108,103.05343511450383,{"$f":"(R7/R6-1)*100","v":2.1759697256386046},{"$error":"#REF!"}]
[2022," 65,7 ",102.1772939346812,0.15243902439026069,100.98077618173457,686,101.62962962962963,0,100,40.299999999999997,74.768089053803337,-0.73891625615765122,103.24884748542273,123.5,104.57239627434383,1.3125512715340459,102.89837292532665,107.3,102.3854961832061,-0.64814814814815325,{"$error":"#REF!"}]
[2023," 65,9 ",102.48833592534994,0.30441400304415112,101.30983453993565,707,104.74074074074073,3.0612244897959107,100,41.3,76.623376623376615,2.4813895781637729,104.35508513705226,125.2,106.01185436071131,1.3765182186234792,103.88304635044938,107.3,102.3854961832061,0,{"$error":"#REF!"}]
[2024," 67,9 ",105.59875583203733,3.0349013657056112,101.6399651755265,718,106.37037037037037,1.5558698727015541,100,42.4,78.664192949907232,2.6634382566586012,105.47317533494925,126.9,107.45131244707881,1.3578274760383424,104.87714248777424,107.3,102.3854961832061,0,{"$error":"#REF!"}]
[2025," 67,2 ",104.51010886469672,-1.0309278350515538,101.97117158265573,728,107.85185185185186,1.3927576601671321,100,43.4,80.519480519480524,2.3584905660377409,106.60324507068084,128.19999999999999,108.55207451312452,1.0244286840031425,105.88075150679597,107.4,102.48091603053436,9.3196644920801042E-2,{"$error":"#REF!"}]
[2026," 66,9 ",104.04354587869361,-0.44642857142856984,102.30345726685805,718,106.37037037037038,-1.3736263736263687,100,44.6,82.745825602968466,2.7649769585253559,107.74542269643813,130.9,110.83827265029642,2.1060842433697546,106.89396443987535,107.6,102.67175572519083,0.18621973929235924,{"$error":"#REF!"}]
[2027," 67,7 ",105.28771384136857,1.195814648729443,102.63682574509139,718,106.37037037037038,0,100,45.8,84.972170686456394,2.6905829596412412,108.89983793961424,132.4,112.10838272650302,1.1459129106187849,107.91687319049615,107.7,102.76717557251908,9.2936802973975219E-2,{"$error":"#REF!"}]
[2028," 67,7 ",105.28771384136857,0,102.97128054577412,718,106.37037037037038,0,100,47,87.19851576994435,2.6200873362445476,110.06662191753868,133.80000000000001,113.29381879762919,1.0574018126888296,108.94957054160136,108.1,103.14885496183204,0.3714020427112219,{"$error":"#REF!"}]
[{"$f":"A14+1","v":2029}," 68,0 ",105.75427682737167,{"$f":"(B15/B14-1)*100","v":0.44313146233381229},103.3068252088224,707,104.74074074074075,{"$f":"(F15/F14-1)*100","v":-1.5320334261838431},100,48,89.053803339517629,{"$f":"(J15/J14-1)*100","v":2.1276595744680771},111.24590715236945,135.1,114.39458086367489,0.97159940209265994,109.992150164009,108.5,103.53053435114504,{"$f":"(R15/R14-1)*100","v":0.37002775208141436},{"$error":"#REF!"}]
[{"$f":"A15+1","v":2030}," 68,4 ",106.37636080870917,{"$f":"(B16/B15-1)*100","v":0.58823529411764497},103.64346328568766,707,104.74074074074075,{"$f":"(F16/F15-1)*100","v":0},100,49.1,91.094619666048231,{"$f":"(J16/J15-1)*100","v":2.2916666666666696},112.43782758614483,136.30000000000001,115.41066892464019,0.88823094004442105,111.0447066249086,108.8,103.81679389312978,{"$f":"(R16/R15-1)*100","v":0.27649769585254003},{"$f":"#REF!*(1+$T$23/100)","v":{"$error":"#REF!"}}]
[{"$f":"A16+1","v":2031},null,106.72300134726198,{"$f":" ((C16/100)^(1/19)-1)*100","v":0.32586237761618175},103.98119833939415,707,104.74074074074075,{"$f":"(F17/F16-1)*100","v":0},100,50.2,93.135435992578834,{"$f":"(J17/J16-1)*100","v":2.2403258655804503},113.64251859599638,137.9,116.76545300592724,1.1738811445341168,112.1073353964388,109.2,104.19847328244276,{"$f":"(R17/R16-1)*100","v":0.36764705882352811},{"$f":"U16*(1+$T$23/100)","v":{"$error":"#REF!"}}]
[{"$f":"A17+1","v":2032},null,107.07077145691552,{"$f":"D17","v":0.32586237761618175},104.32003394457671,707,104.74074074074075,{"$f":"(F18/F17-1)*100","v":0},100,51.3,95.176252319109437,{"$f":"(J18/J17-1)*100","v":2.1912350597609542},114.86011700952491,139.69999999999999,118.28958509737515,1.305293691080478,113.18013286434729,109.6,104.58015267175573,{"$f":"(R18/R17-1)*100","v":0.366300366300365},{"$error":"#REF!"}]
[2033,null,107.41967481851701,{"$f":"D18","v":0.32586237761618175},104.65997368751852,697,103.25925925925927,-1.4144271570014189,100,52.4,97.21706864564004,2.1442495126705596,116.09076112034124,141.5,119.81371718882309,1.2884753042233354,114.26319633673336,109.9,104.86641221374047,0.27372262773723843,{"$error":"#REF!"}]
[2034,null,107.7697151249082,{"$f":"D19","v":0.32586237761618175},105.00102116618913,707,104.74074074074075,1.4347202295552419,100,53.4,99.072356215213318,1.9083969465648831,117.33459070377346,143.19999999999999,121.25317527519057,1.2014134275618371,115.35662405287432,110.2,105.15267175572521,0.27297543221109777,{"$error":"#REF!"}]
[2035,null,108.12089608096441,{"$f":"D20","v":0.32586237761618175},105.34317999028255,707,104.74074074074075,0,100,54.4,100.92764378478661,1.8726591760299671,118.59174703274246,144.80000000000001,122.60795935647762,1.1173184357541999,116.46051519213626,110.5,105.43893129770996,0.27223230490018846,{"$error":"#REF!"}]
[2036,null,108.47322140363376,0.32586237761618175,105.68645378125538,707,104.74074074074075,0,100,56,103.89610389610387,2.941176470588247,119.86237289380756,146.30000000000001,123.87806943268424,1.035911602209949,117.57496988297008,110.8,105.72519083969469,0.27149321266968229,{"$error":"#REF!"}]
[{"$f":"A22+1","v":2037},null,108.82669482197649,0.32586237761618175,106.0308461723652,707,104.74074074074075,0,100,56.6,105.00927643784784,1.0714285714285676,121.14661260338407,147.69999999999999,125.06350550381039,0.95693779904304499,118.7000892119937,111.1,{"$f":"S22*(100+T23)/100","v":106.01145038167942},0.27075812274368616]
[{"$f":"A23+1","v":2038},null,109.18132007720448,0.32586237761618175,106.37636080870902,707,104.74074074074075,0,100,57.2,106.12244897959182,1.0600706713780994,122.44461202413461,149.1,126.24894157493657,0.94786729857820884,119.83597523316108,111.4,{"$f":"S23*(100+T24)/100","v":106.29770992366417},0.27002700270029045]
[2039,null,109.53710092272078,0.32586237761618175,106.72300134726186,707,104.74074074074075,0,100,57.7,107.05009276437848,0.87412587412587506,123.75651858153606,150.30000000000001,127.26502963590184,0.80482897384306362,120.98273097701906,111.7,{"$f":"S24*(100+T25)/100","v":106.58396946564888},0.26929982046677292]
[2040,null,109.8940411241594,0.32586237761618175,null,707,{"$f":"G25*(100+H26)/100","v":104.74074074074075},0,null,58.2,{"$f":"K25*(100+L26)/100","v":107.97773654916512},0.86655112651645716,null,151.5,{"$f":"O25*(100+P26)/100","v":128.28111769686711},0.79840319361277334,null,111.9,106.77480916030538,0.17905102954343111]
[2041,null,110.2521444594251,0.32586237761618175,null,null,104.99638795857523,{"$f":" ((G26/100)^(1/19)-1)*100","v":0.24407619807393921},null,null,108.41481974432162,{"$f":" ((K26/100)^(1/19)-1)*100","v":0.40479010685456895},null,null,129.97370851714905,{"$f":" ((O26/100)^(1/19)-1)*100","v":1.3194387846554356},null,null,107.14382882226329,{"$f":" ((S26/100)^(1/19)-1)*100","v":0.34560554578364489}]
[2042,null,110.6114147187334,0.32586237761618175,null,null,105.25265915041948,{"$f":"H27","v":0.24407619807393921},null,null,108.85367220901084,{"$f":"L27","v":0.40479010685456895},null,null,131.68863203717933,{"$f":"P27","v":1.3194387846554356},null,null,107.51412383663795,{"$f":"T27","v":0.34560554578364489}]
[2043,null,110.97185570465075,0.32586237761618175,null,null,105.50955583924555,0.24407619807393921,null,null,109.29430110506081,0.40479010685456895,null,null,133.42618292326006,1.3194387846554356,null,null,107.88569861111806,0.34560554578364489]
[2044,null,111.33347123213473,0.32586237761618175,null,null,105.76707955174268,0.24407619807393921,null,null,109.73671362328994,0.40479010685456895,null,null,135.18665972963484,1.3194387846554356,null,null,108.25855756862551,0.34560554578364489]
[2045,null,111.69626512857438,0.32586237761618175,null,null,106.0252318183264,0.24407619807393921,null,null,110.18091698362434,0.40479010685456895,null,null,136.97036494978781,1.3194387846554356,null,null,108.63270514736806,0.34560554578364489]
[{"$f":"A31+1","v":2046},null,112.06024123383082,0.32586237761618175,null,null,106.28401417314767,{"$f":"H31","v":0.24407619807393921},null,null,110.62691843521569,{"$f":"L31","v":0.40479010685456895},null,null,138.7776050684194,{"$f":"P31","v":1.3194387846554356},null,null,109.00814580089214,{"$f":"T31","v":0.34560554578364489}]
[{"$f":"A32+1","v":2047},null,112.42540340027782,0.32586237761618175,null,null,106.54342815410186,{"$f":"H32","v":0.24407619807393921},null,null,111.0747252565595,{"$f":"L32","v":0.40479010685456895},null,null,140.60869061410807,{"$f":"P32","v":1.3194387846554356},null,null,109.38488399813593,{"$f":"T32","v":0.34560554578364489}]
[{"$f":"A33+1","v":2048},null,112.79175549284253,0.32586237761618175,null,null,106.80347530283804,{"$f":"H33","v":0.24407619807393921},null,null,111.52434475561395,{"$f":"L33","v":0.40479010685456895},null,null,142.46393621266677,{"$f":"P33","v":1.3194387846554356},null,null,109.7629242234825,{"$f":"T33","v":0.34560554578364489}]
[{"$f":"A34+1","v":2049},null,113.15930138904652,0.32586237761618175,null,null,107.06415716476803,{"$f":"H34","v":0.24407619807393921},null,null,111.97578426991906,{"$f":"L34","v":0.40479010685456895},null,null,144.34366064120346,{"$f":"P34","v":1.3194387846554356},null,null,110.14227097681314,{"$f":"T34","v":0.34560554578364489}]
[2050,null,113.52804497904671,0.32586237761618175,null,null,107.32547528907571,0.24407619807393921,null,null,112.4290511667165,0.40479010685456895,null,null,146.24818688289491,1.3194387846554356,null,null,110.52292877356105,0.34560554578364489]
[2051,null,113.8979901656766,0.32586237761618175,null,null,107.58743122872608,0.24407619807393921,null,null,112.88415284306983,0.40479010685456895,null,null,148.17784218248318,1.3194387846554356,null,null,110.90490214476499,0.34560554578364489]
[2052,null,114.26914086448751,0.32586237761618175,null,null,107.85002654047457,0.24407619807393921,null,null,113.34109672598515,0.40479010685456895,null,null,150.13295810250438,1.3194387846554356,null,null,111.28819563712322,0.34560554578364489]
[2053,null,114.64150100379011,0.32586237761618175,null,null,108.1132627848763,0.24407619807393921,null,null,113.79989027253239,0.40479010685456895,null,null,152.11387058025929,1.3194387846554356,null,null,111.67281381304767,0.34560554578364489]
[{"$f":"A39+1","v":2054},null,115.01507452469593,0.32586237761618175,null,null,108.3771415262953,0.24407619807393921,null,null,114.26054096996695,0.40479010685456895,null,null,154.12091998553581,1.3194387846554356,null,null,112.05876125071819,0.34560554578364489]
[{"$f":"A40+1","v":2055},null,115.38986538115913,0.32586237761618175,null,null,108.64166433291389,0.24407619807393921,null,null,114.72305633585189,0.40479010685456895,null,null,156.15445117909275,1.3194387846554356,null,null,112.44604254413713,0.34560554578364489]
[{"$f":"A41+1","v":2056},null,115.76587754001828,0.32586237761618175,null,null,108.90683277674192,0.24407619807393921,null,null,115.18744391818062,0.40479010685456895,null,null,158.21481357191553,1.3194387846554356,null,null,112.8346623031839,0.34560554578364489]
[{"$f":"A42+1","v":2057},null,116.14311498103842,0.32586237761618175,null,null,109.17264843362615,0.24407619807393921,null,null,115.65371129550007,{"$f":"L42","v":0.40479010685456895},null,null,160.30236118525366,1.3194387846554356,null,null,113.22462515366995,0.34560554578364489]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]

{"sheet":"Eksempel 1","index":3,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":false,"merged":[[66,5,66,6],[73,11,73,12],[1,9,1,10],[1,11,1,15],[4,13,6,15],[7,13,8,15]]}
[]
[null,"Brugerberegning",null,null,null,null,null,null,null,"Bossident",null,"1234578 12345678 1234567812"]
[]
[null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,"RESULTAT:"]
[null,null,"Investeringer i nutidskroner",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N13=\"Beregningen er totaløkonomisk\",N24=\"Brugerøkonomien er positiv\"),\"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier.\",\"-\")","v":"-"}]
[null,null,null,null,"Initialinvesteringer",null,null,null,null,null,{"$f":"-'[7]Brugerinput og forudsætninger'!L64","v":-250000},"kr."]
[null,null,null,null,"Reinvesteringer",null,null,null,null,null,{"$f":"[7]Beregninger!H49","v":-140328.54635708701},"kr."]
[null,null,null,null,"Ændring i årlige vedligeholdelsesomkostninger, tilslutningsafgifer m.v.",null,null,null,null,null,{"$f":"[7]Beregninger!I49+[7]Beregninger!J49","v":-8329.5575433225295},"kr.",null,{"$f":"IF(AND(N13=\"Beregningen er IKKE totaløkonomisk\",N24=\"Brugerøkonomien er negativ\"),\"Kravet om totaløkonomisk rentabilitet såvel som en positiv brugerøkonomi er ikke opfyldt.\",\"-\")","v":"-"}]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"J64","v":57348.247501468322},"kr."]
[null,null,"Varmebesparelser",null,null,null,null,null,null,null,{"$f":"[7]Beregninger!O49","v":198606.38071426548},"kr."]
[null,null,"Elbesparelser",null,null,null,null,null,null,null,{"$f":"[7]Beregninger!S49","v":-5504.7776913474627},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K6:K11)","v":-148208.25337602312},"kr.",null,{"$f":"IF(K13>0,\"Beregningen er totaløkonomisk rentabel\",IF(K13<0,\"Beregningen er IKKE totaløkonomisk rentabel\"))","v":"Beregningen er IKKE totaløkonomisk rentabel"}]
[]
[]
[]
[null,"Brugerøkonomi"]
[null,null,"Brugerøkonomi det første år"]
[null,null,null,null,"Brugerbetaling",null,null,null,null,null,{"$f":"-[7]Beregninger!W9","v":8411.5},"kr."]
[null,null,null,null,"Varmebesparelser det første år",null,null,null,null,null,{"$f":"[7]Beregninger!O9","v":6967.915220130637},"kr."]
[null,null,null,null,"Elbesparelser det første år",null,null,null,null,null,{"$f":"[7]Beregninger!S9","v":-204.24500479999898},"kr."]
[null,null,null,null,"Årlige andre besparelser - f.eks. tilslutningsafgifter m.v.",null,null,null,null,null,{"$f":"-O64","v":0},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K19:K22)","v":15175.170215330638},"kr.",null,{"$f":"IF(K24<0,\"Brugerøkonomien er negativ\",IF(K24>0,\"Brugerøkonomien er positiv\"))","v":"Brugerøkonomien er positiv"}]
[]
[]
[]
[]
[null,"Investeringer og levetider - Forbedret bygning"]
[null,null,null,null,null,null,"Levetid","Antal reinvesteringer","Afskrivningsfaktor efter 40 år","Scrapværdi efter 40 år. I nutidskroner","Dokumentation","Initialinvestering - Merpris eller totalpris","Dokumentation","Årlige vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Dokumentation"]
[null,null,null,null,null,"Kort beskrivelse","år",null,null,null,null,"Nutidskroner",null,"Nutidskroner","Nutidskroner"]
[null,"Tiltag 1"]
[null,null,"Titel",null,null,"Forbedret tæthed - ned til lavenergi krav"]
[null,null,null,null,"Tættere bygning",null,60,{"$f":"calcReinvestments(G34)","v":0},{"$f":"IF(G34>0,((G34-(40-H34*G34))/G34),0)","v":0.33333333333333331},{"$f":"IF(H34=0,(L34*I34)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G34*H34))*L34*I34)/(1+Tilbagediskonteringsrente)^40)","v":6880.136258430015},"Afsnit X.X",90000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,0,{"$f":"calcReinvestments(G35)","v":0},{"$f":"IF(G35>0,((G35-(40-H35*G35))/G35),0)","v":0},{"$f":"IF(H35=0,(L35*I35)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G35*H35))*L35*I35)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 2"]
[null,null,"Titel",null,null,"Solvarmeanlæg til varmt brugsvand"]
[null,null,null,null,"Solvarmeanlæg",null,20,{"$f":"calcReinvestments(G38)","v":2},{"$f":"IF(G38>0,((G38-(40-H38*G38))/G38),0)","v":1},{"$f":"IF(H38=0,(L38*I38)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G38*H38))*L38*I38)/(1+Tilbagediskonteringsrente)^40)","v":50468.111243038307},"Afsnit X.X",160000,"Afsnit X.X",300,0,"Afsnit X.X"]
[null,null,null,null,null,null,0,{"$f":"calcReinvestments(G39)","v":0},{"$f":"IF(G39>0,((G39-(40-H39*G39))/G39),0)","v":0},{"$f":"IF(H39=0,(L39*I39)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G39*H39))*L39*I39)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 3"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G42)","v":0},{"$f":"IF(G42>0,((G42-(40-H42*G42))/G42),0)","v":0},{"$f":"IF(H42=0,(L42*I42)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G42*H42))*L42*I42)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G43)","v":0},{"$f":"IF(G43>0,((G43-(40-H43*G43))/G43),0)","v":0},{"$f":"IF(H43=0,(L43*I43)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G43*H43))*L43*I43)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 4"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G46)","v":0},{"$f":"IF(G46>0,((G46-(40-H46*G46))/G46),0)","v":0},{"$f":"IF(H46=0,(L46*I46)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G46*H46))*L46*I46)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G47)","v":0},{"$f":"IF(G47>0,((G47-(40-H47*G47))/G47),0)","v":0},{"$f":"IF(H47=0,(L47*I47)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G47*H47))*L47*I47)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 5"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G50)","v":0},{"$f":"IF(G50>0,((G50-(40-H50*G50))/G50),0)","v":0},{"$f":"IF(H50=0,(L50*I50)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G50*H50))*L50*I50)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G51)","v":0},{"$f":"IF(G51>0,((G51-(40-H51*G51))/G51),0)","v":0},{"$f":"IF(H51=0,(L51*I51)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G51*H51))*L51*I51)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 6"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G54)","v":0},{"$f":"IF(G54>0,((G54-(40-H54*G54))/G54),0)","v":0},{"$f":"IF(H54=0,(L54*I54)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G54*H54))*L54*I54)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G55)","v":0},{"$f":"IF(G55>0,((G55-(40-H55*G55))/G55),0)","v":0},{"$f":"IF(H55=0,(L55*I55)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G55*H55))*L55*I55)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 7"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G58)","v":0},{"$f":"IF(G58>0,((G58-(40-H58*G58))/G58),0)","v":0},{"$f":"IF(H58=0,(L58*I58)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G58*H58))*L58*I58)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G59)","v":0},{"$f":"IF(G59>0,((G59-(40-H59*G59))/G59),0)","v":0},{"$f":"IF(H59=0,(L59*I59)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G59*H59))*L59*I59)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 8"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G62)","v":0},{"$f":"IF(G62>0,((G62-(40-H62*G62))/G62),0)","v":0},{"$f":"IF(H62=0,(L62*I62)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G62*H62))*L62*I62)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G63)","v":0},{"$f":"IF(G63>0,((G63-(40-H63*G63))/G63),0)","v":0},{"$f":"IF(H63=0,(L63*I63)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G63*H63))*L63*I63)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,"Totaler",null,null,{"$f":"SUM(J32:J63)","v":57348.247501468322},null,{"$f":"SUM(L32:L63)","v":250000},null,{"$f":"SUM(N34:N63)","v":300},{"$f":"SUM(O34:O63)","v":0}]
[]
[null,"Energibesparelser"]
[null,null,null,null,null,"Varme",null,"El","Dokumentation"]
[]
[null,null,null,null,null,"[kWh/m² pr. år]","[KWh/år]","[KWh/år]"]
[null,null,null,null,"Standard",26.1,{"$f":"1081*F70","v":28214.100000000002},{"$f":"4.4*1081","v":4756.4000000000005},"Afsnit X.X"]
[null,null,null,null,"Lavenergi",15.2,{"$f":"1081*F71","v":16431.2},{"$f":"4.5*1081","v":4864.5},"Afsnit X.X"]
[null,null,null,null,"Besparelse",{"$f":"F70-F71","v":10.900000000000002},{"$f":"G70-G71","v":11782.900000000001},{"$f":"H70-H71","v":-108.09999999999945}]
[]
[null,"Forudsætninger og mellemregninger",null,null,null,null,null,null,null,null,null,"Dokumentation"]
[null,null,"Totaløkonomiberegning"]
[null,null,null,null,"Faktisk initial merinvestering kr.",null,null,null,null,null,{"$f":"'[7]Brugerinput og forudsætninger'!L64*-1","v":-250000},"kr."]
[null,null,null,null,"Reinvesteringer i nutidskroner",null,null,null,null,null,{"$f":"[7]Beregninger!H49","v":-140328.54635708701},"kr."]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"-J64","v":-57348.247501468322},"kr."]
[]
[null,null,"Beboerøkonomi"]
[null,null,null,null,"Hovedstol i kr.",null,null,null,null,null,{"$f":"K76*(1-K88)","v":-245000},"kr."]
[]
[null,null,"Renteforudsætninger"]
[null,null,null,null,"Nominel tilbagediskonteringsrente",null,null,null,null,null,3.7499999999999999E-2]
[null,null,null,null,"Inflation",null,null,null,null,null,1.7999999999999999E-2]
[null,null,null,null,"Nominel prisstigning på energibesparende tiltag",null,null,null,null,null,8.0000000000000002E-3]
[null,null,null,null,"Beboerbetalingsprocent",null,null,null,null,null,3.1E-2]
[null,null,null,null,"Beboerindskud",null,null,null,null,null,0.02]
[null,null,null,null,"Bidrag på lån",null,null,null,null,null,2.7000000000000001E-3]
[]
[null,null,"Elpriser"]
[null,null,null,null,"Elpris inklusive afgifter men eksklusive faste bidrag og moms",null,null,null,null,null,1.8,"kr / kWh","Afsnit X.X"]
[null,null,"Varmeforsyning og priser"]
[null,null,null,"Før tiltag"]
[null,null,null,null,"Varmekilde 1:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]
[null,null,null,"Efter tiltag"]
[null,null,null,null,"Varmekilde 2:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]

{"sheet":"Eksempel 2","index":4,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":false,"merged":[[66,5,66,6],[73,11,73,12],[1,9,1,10],[1,11,1,15],[4,13,6,15],[7,13,8,15]]}
[]
[null,"Brugerberegning",null,null,null,null,null,null,null,"Bossident",null,"1234578 12345678 1234567812"]
[]
[null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,"RESULTAT:"]
[null,null,"Investeringer i nutidskroner",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N13=\"Beregningen er totaløkonomisk\",N24=\"Brugerøkonomien er positiv\"),\"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier.\",\"-\")","v":"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier."}]
[null,null,null,null,"Initialinvesteringer",null,null,null,null,null,{"$f":"-'[3]Brugerinput og forudsætninger'!L64","v":-230000},"kr."]
[null,null,null,null,"Reinvesteringer",null,null,null,null,null,{"$f":"[3]Beregninger!H49","v":-87705.341473179375},"kr."]
[null,null,null,null,"Ændring i årlige vedligeholdelsesomkostninger, tilslutningsafgifer m.v.",null,null,null,null,null,{"$f":"[3]Beregninger!I49+[3]Beregninger!J49","v":-6941.2979527687767},"kr.",null,{"$f":"IF(AND(N13=\"Beregningen er IKKE totaløkonomisk\",N24=\"Brugerøkonomien er negativ\"),\"Kravet om totaløkonomisk rentabilitet såvel som en positiv brugerøkonomi er ikke opfyldt.\",\"-\")","v":"-"}]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"J64","v":41480.544122408959},"kr."]
[null,null,"Varmebesparelser",null,null,null,null,null,null,null,{"$f":"[3]Beregninger!O49","v":140439.82076664147},"kr."]
[null,null,"Elbesparelser",null,null,null,null,null,null,null,{"$f":"[3]Beregninger!S49","v":172421.48653402468},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K6:K11)","v":29695.211997126898},"kr.",null,{"$f":"IF(K13>0,\"Beregningen er totaløkonomisk\",IF(K13<0,\"Beregningen er IKKE totaløkonomisk\"))","v":"Beregningen er totaløkonomisk"}]
[]
[]
[]
[null,"Brugerøkonomi"]
[null,null,"Brugerøkonomi det første år"]
[null,null,null,null,"Brugerbetaling",null,null,null,null,null,{"$f":"-[3]Beregninger!W9","v":7738.58},"kr."]
[null,null,null,null,"Varmebesparelser det første år",null,null,null,null,null,{"$f":"[3]Beregninger!O9","v":4927.1970070295502},"kr."]
[null,null,null,null,"Elbesparelser det første år",null,null,null,null,null,{"$f":"[3]Beregninger!S9","v":6107.022719999999},"kr."]
[null,null,null,null,"Årlige andre besparelser - f.eks. tilslutningsafgifter m.v.",null,null,null,null,null,{"$f":"-O64","v":0},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K19:K22)","v":18772.799727029549},"kr.",null,{"$f":"IF(K24<0,\"Brugerøkonomien er negativ\",IF(K24>0,\"Brugerøkonomien er positiv\"))","v":"Brugerøkonomien er positiv"}]
[]
[]
[]
[]
[null,"Investeringer og levetider - Forbedret bygning"]
[null,null,null,null,null,null,"Levetid","Antal reinvesteringer","Afskrivningsfaktor efter 40 år","Scrapværdi efter 40 år. I nutidskroner","Dokumentation","Initialinvestering - Merpris eller totalpris","Dokumentation","Årlige vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Dokumentation"]
[null,null,null,null,null,"Kort beskrivelse","år",null,null,null,null,"Nutidskroner",null,"Nutidskroner","Nutidskroner"]
[null,"Tiltag 1"]
[null,null,"Titel",null,null,"Forbedret tæthed - ned til lavenergi krav"]
[null,null,null,null,"Tættere bygning",null,60,{"$f":"calcReinvestments(G34)","v":0},{"$f":"IF(G34>0,((G34-(40-H34*G34))/G34),0)","v":0.33333333333333331},{"$f":"IF(H34=0,(L34*I34)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G34*H34))*L34*I34)/(1+Tilbagediskonteringsrente)^40)","v":9937.9745955100207},"Afsnit X.X",130000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,0,{"$f":"calcReinvestments(G35)","v":0},{"$f":"IF(G35>0,((G35-(40-H35*G35))/G35),0)","v":0},{"$f":"IF(H35=0,(L35*I35)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G35*H35))*L35*I35)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 2"]
[null,null,"Titel",null,null,"SEL-forbedring fra 1,5 til 1,2"]
[null,null,null,null,"Bedre SEL-værdi",null,20,{"$f":"calcReinvestments(G38)","v":2},{"$f":"IF(G38>0,((G38-(40-H38*G38))/G38),0)","v":1},{"$f":"IF(H38=0,(L38*I38)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G38*H38))*L38*I38)/(1+Tilbagediskonteringsrente)^40)","v":31542.56952689894},"Afsnit X.X",100000,"Afsnit X.X",250,0,"Afsnit X.X"]
[null,null,null,null,null,null,0,{"$f":"calcReinvestments(G39)","v":0},{"$f":"IF(G39>0,((G39-(40-H39*G39))/G39),0)","v":0},{"$f":"IF(H39=0,(L39*I39)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G39*H39))*L39*I39)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 3"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G42)","v":0},{"$f":"IF(G42>0,((G42-(40-H42*G42))/G42),0)","v":0},{"$f":"IF(H42=0,(L42*I42)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G42*H42))*L42*I42)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G43)","v":0},{"$f":"IF(G43>0,((G43-(40-H43*G43))/G43),0)","v":0},{"$f":"IF(H43=0,(L43*I43)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G43*H43))*L43*I43)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 4"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G46)","v":0},{"$f":"IF(G46>0,((G46-(40-H46*G46))/G46),0)","v":0},{"$f":"IF(H46=0,(L46*I46)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G46*H46))*L46*I46)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G47)","v":0},{"$f":"IF(G47>0,((G47-(40-H47*G47))/G47),0)","v":0},{"$f":"IF(H47=0,(L47*I47)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G47*H47))*L47*I47)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 5"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G50)","v":0},{"$f":"IF(G50>0,((G50-(40-H50*G50))/G50),0)","v":0},{"$f":"IF(H50=0,(L50*I50)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G50*H50))*L50*I50)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G51)","v":0},{"$f":"IF(G51>0,((G51-(40-H51*G51))/G51),0)","v":0},{"$f":"IF(H51=0,(L51*I51)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G51*H51))*L51*I51)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 6"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G54)","v":0},{"$f":"IF(G54>0,((G54-(40-H54*G54))/G54),0)","v":0},{"$f":"IF(H54=0,(L54*I54)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G54*H54))*L54*I54)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G55)","v":0},{"$f":"IF(G55>0,((G55-(40-H55*G55))/G55),0)","v":0},{"$f":"IF(H55=0,(L55*I55)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G55*H55))*L55*I55)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 7"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G58)","v":0},{"$f":"IF(G58>0,((G58-(40-H58*G58))/G58),0)","v":0},{"$f":"IF(H58=0,(L58*I58)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G58*H58))*L58*I58)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G59)","v":0},{"$f":"IF(G59>0,((G59-(40-H59*G59))/G59),0)","v":0},{"$f":"IF(H59=0,(L59*I59)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G59*H59))*L59*I59)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 8"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G62)","v":0},{"$f":"IF(G62>0,((G62-(40-H62*G62))/G62),0)","v":0},{"$f":"IF(H62=0,(L62*I62)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G62*H62))*L62*I62)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G63)","v":0},{"$f":"IF(G63>0,((G63-(40-H63*G63))/G63),0)","v":0},{"$f":"IF(H63=0,(L63*I63)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G63*H63))*L63*I63)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,"Totaler",null,null,{"$f":"SUM(J32:J63)","v":41480.544122408959},null,{"$f":"SUM(L32:L63)","v":230000},null,{"$f":"SUM(N34:N63)","v":250},{"$f":"SUM(O34:O63)","v":0}]
[]
[null,"Energibesparelser"]
[null,null,null,null,null,"Varme",null,"El","Dokumentation"]
[]
[null,null,null,null,null,"[kWh/m² pr. år]","[KWh/år]","[KWh/år]"]
[null,null,null,null,"Standard",25.8,{"$f":"4166*F70","v":107482.8},{"$f":"4.3*4166","v":17913.8},"Afsnit X.X"]
[null,null,null,null,"Lavenergi",23.8,{"$f":"4166*F71","v":99150.8},{"$f":"3.5*4166","v":14581},"Afsnit X.X"]
[null,null,null,null,"Besparelse",{"$f":"F70-F71","v":2},{"$f":"G70-G71","v":8332},{"$f":"H70-H71","v":3332.7999999999993}]
[]
[null,"Forudsætninger og mellemregninger",null,null,null,null,null,null,null,null,null,"Dokumentation"]
[null,null,"Totaløkonomiberegning"]
[null,null,null,null,"Faktisk initial merinvestering kr.",null,null,null,null,null,{"$f":"'[3]Brugerinput og forudsætninger'!L64*-1","v":-230000},"kr."]
[null,null,null,null,"Reinvesteringer i nutidskroner",null,null,null,null,null,{"$f":"[3]Beregninger!H49","v":-87705.341473179375},"kr."]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"-J64","v":-41480.544122408959},"kr."]
[]
[null,null,"Beboerøkonomi"]
[null,null,null,null,"Hovedstol i kr.",null,null,null,null,null,{"$f":"K76*(1-K88)","v":-225400},"kr."]
[]
[null,null,"Renteforudsætninger"]
[null,null,null,null,"Nominel tilbagediskonteringsrente",null,null,null,null,null,3.7499999999999999E-2]
[null,null,null,null,"Inflation",null,null,null,null,null,1.7999999999999999E-2]
[null,null,null,null,"Nominel prisstigning på energibesparende tiltag",null,null,null,null,null,8.0000000000000002E-3]
[null,null,null,null,"Beboerbetalingsprocent",null,null,null,null,null,3.1E-2]
[null,null,null,null,"Beboerindskud",null,null,null,null,null,0.02]
[null,null,null,null,"Bidrag på lån",null,null,null,null,null,2.7000000000000001E-3]
[]
[null,null,"Elpriser"]
[null,null,null,null,"Elpris inklusive afgifter men eksklusive faste bidrag og moms",null,null,null,null,null,1.8,"kr / kWh","Afsnit X.X"]
[null,null,"Varmeforsyning og priser"]
[null,null,null,"Før tiltag"]
[null,null,null,null,"Varmekilde 1:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]
[null,null,null,"Efter tiltag"]
[null,null,null,null,"Varmekilde 2:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]

{"sheet":"Eksempel 3","index":5,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":false,"merged":[[66,5,66,6],[73,11,73,12],[1,9,1,10],[1,11,1,15],[4,13,6,15],[7,13,8,15]]}
[]
[null,"Brugerberegning",null,null,null,null,null,null,null,"Bossident",null,"1234578 12345678 1234567812"]
[]
[null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,"RESULTAT:"]
[null,null,"Investeringer i nutidskroner",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N13=\"Beregningen er totaløkonomisk\",N24=\"Brugerøkonomien er positiv\"),\"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier.\",\"-\")","v":"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier."}]
[null,null,null,null,"Initialinvesteringer",null,null,null,null,null,{"$f":"-'[9]Brugerinput og forudsætninger'!L64","v":-305000},"kr."]
[null,null,null,null,"Reinvesteringer",null,null,null,null,null,{"$f":"[9]Beregninger!H49","v":-163983.18106843813},"kr."]
[null,null,null,null,"Ændring i årlige vedligeholdelsesomkostninger, tilslutningsafgifer m.v.",null,null,null,null,null,{"$f":"[9]Beregninger!I49+[9]Beregninger!J49","v":312358.40787459497},"kr.",null,{"$f":"IF(AND(N13=\"Beregningen er IKKE totaløkonomisk\",N24=\"Brugerøkonomien er negativ\"),\"Kravet om totaløkonomisk rentabilitet såvel som en positiv brugerøkonomi er ikke opfyldt.\",\"-\")","v":"-"}]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"J64","v":64270.504184295351},"kr."]
[null,null,"Varmebesparelser",null,null,null,null,null,null,null,{"$f":"[9]Beregninger!O49","v":1110944.3815085618},"kr."]
[null,null,"Elbesparelser",null,null,null,null,null,null,null,{"$f":"[9]Beregninger!S49","v":-585119.72296562046},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K6:K11)","v":433470.38953339355},"kr.",null,{"$f":"IF(K13>0,\"Beregningen er totaløkonomisk\",IF(K13<0,\"Beregningen er IKKE totaløkonomisk\"))","v":"Beregningen er totaløkonomisk"}]
[]
[]
[]
[null,"Brugerøkonomi"]
[null,null,"Brugerøkonomi det første år"]
[null,null,null,null,"Brugerbetaling",null,null,null,null,null,{"$f":"-[9]Beregninger!W9","v":10262.030000000001},"kr."]
[null,null,null,null,"Varmebesparelser det første år",null,null,null,null,null,{"$f":"[9]Beregninger!O9","v":38976.42279564542},"kr."]
[null,null,null,null,"Elbesparelser det første år",null,null,null,null,null,{"$f":"[9]Beregninger!S9","v":-20724.444},"kr."]
[null,null,null,null,"Årlige andre besparelser - f.eks. tilslutningsafgifter m.v.",null,null,null,null,null,{"$f":"-O64","v":13000},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K19:K22)","v":41514.008795645423},"kr.",null,{"$f":"IF(K24<0,\"Brugerøkonomien er negativ\",IF(K24>0,\"Brugerøkonomien er positiv\"))","v":"Brugerøkonomien er positiv"}]
[]
[]
[]
[]
[null,"Investeringer og levetider - Forbedret bygning"]
[null,null,null,null,null,null,"Levetid","Antal reinvesteringer","Afskrivningsfaktor efter 40 år","Scrapværdi efter 40 år. I nutidskroner","Dokumentation","Initialinvestering - Merpris eller totalpris","Dokumentation","Årlige vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Dokumentation"]
[null,null,null,null,null,"Kort beskrivelse","år",null,null,null,null,"Nutidskroner",null,"Nutidskroner","Nutidskroner"]
[null,"Tiltag 1"]
[null,null,"Titel",null,null,"Jordvarmeanlæg"]
[null,null,null,null,"Jordvarmeanlæg",null,50,{"$f":"calcReinvestments(G34)","v":0},{"$f":"IF(G34>0,((G34-(40-H34*G34))/G34),0)","v":0.2},{"$f":"IF(H34=0,(L34*I34)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G34*H34))*L34*I34)/(1+Tilbagediskonteringsrente)^40)","v":8256.1635101160173},"Afsnit X.X",180000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Varmepumpe",null,20,{"$f":"calcReinvestments(G35)","v":2},{"$f":"IF(G35>0,((G35-(40-H35*G35))/G35),0)","v":1},{"$f":"IF(H35=0,(L35*I35)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G35*H35))*L35*I35)/(1+Tilbagediskonteringsrente)^40)","v":78856.423817247356},"Afsnit X.X",250000,"Afsnit X.X",1500,0,"Afsnit X.X"]
[null,"Tiltag 2"]
[null,null,"Titel",null,null,"Oprindelig fjernvarmeinstallation"]
[null,null,null,null,"Fjernvarmeinstallation",null,20,{"$f":"calcReinvestments(G38)","v":2},{"$f":"IF(G38>0,((G38-(40-H38*G38))/G38),0)","v":1},{"$f":"IF(H38=0,(L38*I38)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G38*H38))*L38*I38)/(1+Tilbagediskonteringsrente)^40)","v":-26811.184097864105},"Afsnit X.X",-85000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Tilslutningsafgift",null,0,{"$f":"calcReinvestments(G39)","v":0},{"$f":"IF(G39>0,((G39-(40-H39*G39))/G39),0)","v":0},{"$f":"IF(H39=0,(L39*I39)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G39*H39))*L39*I39)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",-70000,"Afsnit X.X",0,-13000,"Afsnit X.X"]
[null,"Tiltag 3"]
[null,null,"Titel",null,null,"Forøgelse af solcelleanlæg med 20 m²"]
[null,null,null,null,"Paneler",null,25,{"$f":"calcReinvestments(G42)","v":1},{"$f":"IF(G42>0,((G42-(40-H42*G42))/G42),0)","v":0.4},{"$f":"IF(H42=0,(L42*I42)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G42*H42))*L42*I42)/(1+Tilbagediskonteringsrente)^40)","v":3022.8238689891073},"Afsnit X.X",27000,"Afsnit X.X",250,0,"Afsnit X.X"]
[null,null,null,null,"Inverter",null,10,{"$f":"calcReinvestments(G43)","v":4},{"$f":"IF(G43>0,((G43-(40-H43*G43))/G43),0)","v":1},{"$f":"IF(H43=0,(L43*I43)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G43*H43))*L43*I43)/(1+Tilbagediskonteringsrente)^40)","v":946.27708580696822},"Afsnit X.X",3000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 4"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G46)","v":0},{"$f":"IF(G46>0,((G46-(40-H46*G46))/G46),0)","v":0},{"$f":"IF(H46=0,(L46*I46)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G46*H46))*L46*I46)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G47)","v":0},{"$f":"IF(G47>0,((G47-(40-H47*G47))/G47),0)","v":0},{"$f":"IF(H47=0,(L47*I47)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G47*H47))*L47*I47)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 5"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G50)","v":0},{"$f":"IF(G50>0,((G50-(40-H50*G50))/G50),0)","v":0},{"$f":"IF(H50=0,(L50*I50)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G50*H50))*L50*I50)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G51)","v":0},{"$f":"IF(G51>0,((G51-(40-H51*G51))/G51),0)","v":0},{"$f":"IF(H51=0,(L51*I51)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G51*H51))*L51*I51)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 6"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G54)","v":0},{"$f":"IF(G54>0,((G54-(40-H54*G54))/G54),0)","v":0},{"$f":"IF(H54=0,(L54*I54)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G54*H54))*L54*I54)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G55)","v":0},{"$f":"IF(G55>0,((G55-(40-H55*G55))/G55),0)","v":0},{"$f":"IF(H55=0,(L55*I55)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G55*H55))*L55*I55)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 7"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G58)","v":0},{"$f":"IF(G58>0,((G58-(40-H58*G58))/G58),0)","v":0},{"$f":"IF(H58=0,(L58*I58)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G58*H58))*L58*I58)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G59)","v":0},{"$f":"IF(G59>0,((G59-(40-H59*G59))/G59),0)","v":0},{"$f":"IF(H59=0,(L59*I59)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G59*H59))*L59*I59)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 8"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G62)","v":0},{"$f":"IF(G62>0,((G62-(40-H62*G62))/G62),0)","v":0},{"$f":"IF(H62=0,(L62*I62)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G62*H62))*L62*I62)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G63)","v":0},{"$f":"IF(G63>0,((G63-(40-H63*G63))/G63),0)","v":0},{"$f":"IF(H63=0,(L63*I63)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G63*H63))*L63*I63)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,"Totaler",null,null,{"$f":"SUM(J32:J63)","v":64270.504184295351},null,{"$f":"SUM(L32:L63)","v":305000},null,{"$f":"SUM(N34:N63)","v":1750},{"$f":"SUM(O34:O63)","v":-13000}]
[]
[null,"Energibesparelser"]
[null,null,null,null,null,"Varme",null,"El","Dokumentation"]
[]
[null,null,null,null,null,"[kWh/m² pr. år]","[KWh/år]","[KWh/år]"]
[null,null,null,null,"Standard",33.799999999999997,{"$f":"1950*F70","v":65910},{"$f":"1950*0.6","v":1170},"Afsnit X.X"]
[null,null,null,null,"Lavenergi",0,{"$f":"4166*F71","v":0},{"$f":"1950*6.4","v":12480},"Afsnit X.X"]
[null,null,null,null,"Besparelse",{"$f":"F70-F71","v":33.799999999999997},{"$f":"G70-G71","v":65910},{"$f":"H70-H71","v":-11310}]
[]
[null,"Forudsætninger og mellemregninger",null,null,null,null,null,null,null,null,null,"Dokumentation"]
[null,null,"Totaløkonomiberegning"]
[null,null,null,null,"Faktisk initial merinvestering kr.",null,null,null,null,null,{"$f":"'[9]Brugerinput og forudsætninger'!L64*-1","v":-305000},"kr."]
[null,null,null,null,"Reinvesteringer i nutidskroner",null,null,null,null,null,{"$f":"[9]Beregninger!H49","v":-163983.18106843813},"kr."]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"-J64","v":-64270.504184295351},"kr."]
[]
[null,null,"Beboerøkonomi"]
[null,null,null,null,"Hovedstol i kr.",null,null,null,null,null,{"$f":"K76*(1-K88)","v":-298900},"kr."]
[]
[null,null,"Renteforudsætninger"]
[null,null,null,null,"Nominel tilbagediskonteringsrente",null,null,null,null,null,3.7499999999999999E-2]
[null,null,null,null,"Inflation",null,null,null,null,null,1.7999999999999999E-2]
[null,null,null,null,"Nominel prisstigning på energibesparende tiltag",null,null,null,null,null,8.0000000000000002E-3]
[null,null,null,null,"Beboerbetalingsprocent",null,null,null,null,null,3.1E-2]
[null,null,null,null,"Beboerindskud",null,null,null,null,null,0.02]
[null,null,null,null,"Bidrag på lån",null,null,null,null,null,2.7000000000000001E-3]
[]
[null,null,"Elpriser"]
[null,null,null,null,"Elpris inklusive afgifter men eksklusive faste bidrag og moms",null,null,null,null,null,1.8,"kr / kWh","Afsnit X.X"]
[null,null,"Varmeforsyning og priser"]
[null,null,null,"Før tiltag"]
[null,null,null,null,"Varmekilde 1:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]
[null,null,null,"Efter tiltag"]
[null,null,null,null,"Varmekilde 2:",null,null,null,null,null,"El"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]

{"sheet":"Eksempel 4","index":6,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":false,"merged":[[66,5,66,6],[73,11,73,12],[1,9,1,10],[1,11,1,15],[4,13,6,15],[7,13,8,15]]}
[]
[null,"Brugerberegning",null,null,null,null,null,null,null,"Bossident",null,"1234578 12345678 1234567812"]
[]
[null,"Totaløkonomiberegning",null,null,null,null,null,null,null,null,null,null,null,"RESULTAT:"]
[null,null,"Investeringer i nutidskroner",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N13=\"Beregningen er totaløkonomisk rentabel\",N24=\"Brugerøkonomien er positiv\"),\"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier.\",\"-\")","v":"Kravet om totaløkonomisk såvel som brugerøkonomisk rentabilitet er opfyldt, og projektet opfylder dermed de krævede økonomiske kriterier."}]
[null,null,null,null,"Initialinvesteringer",null,null,null,null,null,{"$f":"-'[11]Brugerinput og forudsætninger'!L64","v":-40000},"kr."]
[null,null,null,null,"Reinvesteringer",null,null,null,null,null,{"$f":"[11]Beregninger!H49","v":-25692.490183589602},"kr."]
[null,null,null,null,"Ændring i årlige vedligeholdelsesomkostninger, tilslutningsafgifer m.v.",null,null,null,null,null,{"$f":"[11]Beregninger!I49+[11]Beregninger!J49","v":-4164.7787716612647},"kr.",null,{"$f":"IF(AND(N13=\"Beregningen er IKKE totaløkonomisk rentabel\",N24=\"Brugerøkonomien er negativ\"),\"Kravet om totaløkonomisk rentabilitet såvel som en positiv brugerøkonomi er ikke opfyldt.\",\"-\")","v":"-"}]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"J64","v":5292.1346063947676},"kr."]
[null,null,"Varmebesparelser",null,null,null,null,null,null,null,{"$f":"[11]Beregninger!O49","v":-29581.359270938021},"kr."]
[null,null,"Elbesparelser",null,null,null,null,null,null,null,{"$f":"[11]Beregninger!S49","v":232030.2349691253},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K6:K11)","v":137883.74134933119},"kr.",null,{"$f":"IF(K13>0,\"Beregningen er totaløkonomisk rentabel\",IF(K13<0,\"Beregningen er IKKE totaløkonomisk rentabel\"))","v":"Beregningen er totaløkonomisk rentabel"}]
[]
[]
[]
[null,"Brugerøkonomi"]
[null,null,"Brugerøkonomi det første år"]
[null,null,null,null,"Brugerbetaling",null,null,null,null,null,{"$f":"-[11]Beregninger!W9","v":-1345.84},"kr."]
[null,null,null,null,"Varmebesparelser det første år",null,null,null,null,null,{"$f":"[11]Beregninger!O9","v":-1037.8337430793108},"kr."]
[null,null,null,null,"Elbesparelser det første år",null,null,null,null,null,{"$f":"[11]Beregninger!S9","v":8218.3140000000003},"kr."]
[null,null,null,null,"Årlige andre besparelser - f.eks. tilslutningsafgifter m.v.",null,null,null,null,null,{"$f":"-O64","v":0},"kr."]
[]
[null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(K19:K22)","v":5834.6402569206894},"kr.",null,{"$f":"IF(K24<0,\"Brugerøkonomien er negativ\",IF(K24>0,\"Brugerøkonomien er positiv\"))","v":"Brugerøkonomien er positiv"}]
[]
[]
[]
[]
[null,"Investeringer og levetider - Forbedret bygning"]
[null,null,null,null,null,null,"Levetid","Antal reinvesteringer","Afskrivningsfaktor efter 40 år","Scrapværdi efter 40 år. I nutidskroner","Dokumentation","Initialinvestering - Merpris eller totalpris","Dokumentation","Årlige vedligeholdelsesomkostninger samt service og tilsyn","Årlige udgifter der ikke indeholder service, tilsyn eller vedligehold. ","Dokumentation"]
[null,null,null,null,null,"Kort beskrivelse","år",null,null,null,null,"Nutidskroner",null,"Nutidskroner","Nutidskroner"]
[null,"Tiltag 1"]
[null,null,"Titel",null,null,"Oprindelig solcelleanlæg - 35 m2"]
[null,null,null,null,"Paneler",null,25,{"$f":"calcReinvestments(G34)","v":1},{"$f":"IF(G34>0,((G34-(40-H34*G34))/G34),0)","v":0.4},{"$f":"IF(H34=0,(L34*I34)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G34*H34))*L34*I34)/(1+Tilbagediskonteringsrente)^40)","v":-7053.2556943079162},"Afsnit X.X",-63000,"Afsnit X.X",-250,0,"Afsnit X.X"]
[null,null,null,null,"Inverter",null,10,{"$f":"calcReinvestments(G35)","v":4},{"$f":"IF(G35>0,((G35-(40-H35*G35))/G35),0)","v":1},{"$f":"IF(H35=0,(L35*I35)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G35*H35))*L35*I35)/(1+Tilbagediskonteringsrente)^40)","v":-2207.9798668829262},"Afsnit X.X",-7000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 2"]
[null,null,"Titel",null,null,"Udvidet solcelleanlæg - 55 m2"]
[null,null,null,null,"Paneler",null,25,{"$f":"calcReinvestments(G38)","v":1},{"$f":"IF(G38>0,((G38-(40-H38*G38))/G38),0)","v":0.4},{"$f":"IF(H38=0,(L38*I38)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G38*H38))*L38*I38)/(1+Tilbagediskonteringsrente)^40)","v":11083.687519626726},"Afsnit X.X",99000,"Afsnit X.X",400,0,"Afsnit X.X"]
[null,null,null,null,"Inverter",null,10,{"$f":"calcReinvestments(G39)","v":4},{"$f":"IF(G39>0,((G39-(40-H39*G39))/G39),0)","v":1},{"$f":"IF(H39=0,(L39*I39)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G39*H39))*L39*I39)/(1+Tilbagediskonteringsrente)^40)","v":3469.682647958884},"Afsnit X.X",11000,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 3"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G42)","v":0},{"$f":"IF(G42>0,((G42-(40-H42*G42))/G42),0)","v":0},{"$f":"IF(H42=0,(L42*I42)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G42*H42))*L42*I42)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G43)","v":0},{"$f":"IF(G43>0,((G43-(40-H43*G43))/G43),0)","v":0},{"$f":"IF(H43=0,(L43*I43)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G43*H43))*L43*I43)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 4"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G46)","v":0},{"$f":"IF(G46>0,((G46-(40-H46*G46))/G46),0)","v":0},{"$f":"IF(H46=0,(L46*I46)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G46*H46))*L46*I46)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G47)","v":0},{"$f":"IF(G47>0,((G47-(40-H47*G47))/G47),0)","v":0},{"$f":"IF(H47=0,(L47*I47)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G47*H47))*L47*I47)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 5"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G50)","v":0},{"$f":"IF(G50>0,((G50-(40-H50*G50))/G50),0)","v":0},{"$f":"IF(H50=0,(L50*I50)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G50*H50))*L50*I50)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G51)","v":0},{"$f":"IF(G51>0,((G51-(40-H51*G51))/G51),0)","v":0},{"$f":"IF(H51=0,(L51*I51)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G51*H51))*L51*I51)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 6"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G54)","v":0},{"$f":"IF(G54>0,((G54-(40-H54*G54))/G54),0)","v":0},{"$f":"IF(H54=0,(L54*I54)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G54*H54))*L54*I54)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G55)","v":0},{"$f":"IF(G55>0,((G55-(40-H55*G55))/G55),0)","v":0},{"$f":"IF(H55=0,(L55*I55)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G55*H55))*L55*I55)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 7"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G58)","v":0},{"$f":"IF(G58>0,((G58-(40-H58*G58))/G58),0)","v":0},{"$f":"IF(H58=0,(L58*I58)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G58*H58))*L58*I58)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G59)","v":0},{"$f":"IF(G59>0,((G59-(40-H59*G59))/G59),0)","v":0},{"$f":"IF(H59=0,(L59*I59)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G59*H59))*L59*I59)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,"Tiltag 8"]
[null,null,"Titel",null,null,"Intet tiltag"]
[null,null,null,null,"Hovedkomponent 1",null,0,{"$f":"calcReinvestments(G62)","v":0},{"$f":"IF(G62>0,((G62-(40-H62*G62))/G62),0)","v":0},{"$f":"IF(H62=0,(L62*I62)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G62*H62))*L62*I62)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,"Hovedkomponent 2",null,0,{"$f":"calcReinvestments(G63)","v":0},{"$f":"IF(G63>0,((G63-(40-H63*G63))/G63),0)","v":0},{"$f":"IF(H63=0,(L63*I63)/(1+Tilbagediskonteringsrente)^40,(((1+Produktivitetsindeks)^(G63*H63))*L63*I63)/(1+Tilbagediskonteringsrente)^40)","v":0},"Afsnit X.X",0,"Afsnit X.X",0,0,"Afsnit X.X"]
[null,null,null,null,null,null,"Totaler",null,null,{"$f":"SUM(J32:J63)","v":5292.1346063947676},null,{"$f":"SUM(L32:L63)","v":40000},null,{"$f":"SUM(N34:N63)","v":150},{"$f":"SUM(O34:O63)","v":0}]
[]
[null,"Energibesparelser"]
[null,null,null,null,null,"Varme",null,"El","Dokumentation"]
[]
[null,null,null,null,null,"[kWh/m² pr. år]","[KWh/år]","[KWh/år]"]
[null,null,null,null,"Standard",33.799999999999997,{"$f":"1950*F70","v":65910},{"$f":"1950*0.6","v":1170},"Afsnit X.X"]
[null,null,null,null,"Lavenergi",34.700000000000003,{"$f":"1950*F71","v":67665},{"$f":"1950*(-1.7)","v":-3315},"Afsnit X.X"]
[null,null,null,null,"Besparelse",{"$f":"F70-F71","v":-0.90000000000000568},{"$f":"G70-G71","v":-1755},{"$f":"H70-H71","v":4485}]
[]
[null,"Forudsætninger og mellemregninger",null,null,null,null,null,null,null,null,null,"Dokumentation"]
[null,null,"Totaløkonomiberegning"]
[null,null,null,null,"Faktisk initial merinvestering kr.",null,null,null,null,null,{"$f":"'[11]Brugerinput og forudsætninger'!L64","v":40000},"kr."]
[null,null,null,null,"Reinvesteringer i nutidskroner",null,null,null,null,null,{"$f":"[11]Beregninger!H49","v":-25692.490183589602},"kr."]
[null,null,null,null,"Scrapværdi",null,null,null,null,null,{"$f":"-J64","v":-5292.1346063947676},"kr."]
[]
[null,null,"Beboerøkonomi"]
[null,null,null,null,"Hovedstol i kr.",null,null,null,null,null,{"$f":"K76*(1-K88)","v":39200},"kr."]
[]
[null,null,"Renteforudsætninger"]
[null,null,null,null,"Nominel tilbagediskonteringsrente",null,null,null,null,null,3.7499999999999999E-2]
[null,null,null,null,"Inflation",null,null,null,null,null,1.7999999999999999E-2]
[null,null,null,null,"Nominel prisstigning på energibesparende tiltag",null,null,null,null,null,8.0000000000000002E-3]
[null,null,null,null,"Beboerbetalingsprocent",null,null,null,null,null,3.1E-2]
[null,null,null,null,"Beboerindskud",null,null,null,null,null,0.02]
[null,null,null,null,"Bidrag på lån",null,null,null,null,null,2.7000000000000001E-3]
[]
[null,null,"Elpriser"]
[null,null,null,null,"Elpris inklusive afgifter men eksklusive faste bidrag og moms",null,null,null,null,null,1.8,"kr / kWh","Afsnit X.X"]
[null,null,"Varmeforsyning og priser"]
[null,null,null,"Før tiltag"]
[null,null,null,null,"Varmekilde 1:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]
[null,null,null,"Efter tiltag"]
[null,null,null,null,"Varmekilde 2:",null,null,null,null,null,"Fjernvarme"]
[null,null,null,null,"Varmepris",null,null,null,null,null,0.57999999999999996,"kr / kWh","Afsnit X.X"]