{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Omkostningseffektivitet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Omkostningseffektivitet","index":0,"n_rows":149,"n_cols":11,"rows_kept":149,"cut":false,"hidden":false,"merged":[[12,6,12,8]]}
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt."]
[null," Oplysninger om omkostninger til anlæg og drift samt projekternes levetid skal indtastes i de røde celler."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[null,"OBS: Ved det alternative klimatilpasningsprojekt er det kun selskabets andel af anlægsomkostninger der skal indtastes. Dvs. at et anlæg til f.eks. 100 kr. som er finansieret med 25 % fra kommunen skal indtastes som 75 kr."]
[]
[null,"Rente","Inflation",null,null,"Resultater"]
[null,3.5000000000000003E-2,0]
[null,null,null,null,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$30:$D$149)>0,($B$9*SUM($J$30:$J$149)/(1-(1+$B$9)^(-($C$19-$C$18+1)))),\"\")","v":""}]
[null,null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($G$30:$H$149)>0,($B$9*SUM($K$30:$K$149)/(1-(1+$B$9)^(-($G$19-$G$18+1)))),\"\")","v":""}]
[]
[null,null,null,null,null,"Konklusion:",{"$f":"IF($G$10>0,IF($G$10<>$G$11,IF($G$10<$G$11,\"Sædvanlig afhjælpning er mest omkostningseffektivt\",\"Alternativt projekt er mest omkostningseffektivt\"),\"Sædvanlig afhjælpning og alternativt projekt er lige omkostningseffektivt\"),\"\")","v":"Sædvanlig afhjælpning og alternativt projekt er lige omkostningseffektivt"}]
[]
[]
[null,"Klimatilpasning ved sædvanlig afhjælpning",null,null,null,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",0,null,null,"Projektets startår",0,null,null,null,{"$f":" IF($F18>=$G$18,IF($F18<=$G$19,SUM($G18:$H18),\"\"),\"\")","v":""}]
[null,"Projektets slutår",0,null,null,"Projektets slutår",0]
[null,"Periodelængde",{"$f":"C19-C18","v":0},null,null,"Periodelængde",{"$f":"G19-G18","v":0}]
[]
[null,"Samlede anlægsomkostninger",0,null,null,"Selskabets samlede anlægsomkostninger",0]
[null,"Periodelængde for anlægsomkostninger",{"$f":"G23","v":0},null,null,"Periodelængde for anlægsomkostninger",0]
[]
[null,"Startår for drift",0,null,null,"Startår for drift",0]
[null,"Driftsomkostninger i det første år",0,null,null,"Driftsomkostninger i det første år",0]
[]
[]
[null,"År","Tilskud til anlægsomkostninger betalt i år t","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Forventede driftsomkostninger i år t",null,"Tilbagediskonteret cash-flow sædvanlig projekt","Tilbagediskonteret cash-flow alternativt projekt"]
[null,{"$f":"C18","v":0},null,0,null,{"$f":"G18","v":0},null,0,null,{"$f":"IF($C$18>$G$18,SUM($C30:$D30)/((1+$B$9)^($B30-$G$18+1)),SUM($C30:$D30)/((1+$B$9)^($B30-$C$18+1)))","v":0},{"$f":"IF($G$18>$C$18,SUM($G30:$H30)/((1+$B$9)^($F30-$C$18+1)),SUM($G30:$H30)/((1+$B$9)^($F30-$G$18+1)))","v":0}]
[null,{"$f":"B30+1","v":1},null,null,null,{"$f":"F30+1","v":1},null,null,null,{"$f":"IF($C$18>$G$18,SUM($C31:$D31)/((1+$B$9)^($B31-$G$18+1)),SUM($C31:$D31)/((1+$B$9)^($B31-$C$18+1)))","v":0},{"$f":"IF($G$18>$C$18,SUM($G31:$H31)/((1+$B$9)^($F31-$C$18+1)),SUM($G31:$H31)/((1+$B$9)^($F31-$G$18+1)))","v":0}]
[null,{"$f":"B31+1","v":2},null,null,null,2,null,null,null,0,0]
[null,3,null,null,null,3,null,null,null,0,0]
[null,4,null,null,null,4,null,null,null,0,0]
[null,5,null,null,null,5,null,null,null,0,0]
[null,6,null,null,null,6,null,null,null,0,0]
[null,7,null,null,null,7,null,null,null,0,0]
[null,8,null,null,null,8,null,null,null,0,0]
[null,9,null,null,null,9,null,null,null,0,0]
[null,10,null,null,null,10,null,null,null,0,0]
[null,11,null,null,null,11,null,null,null,0,0]
[null,12,null,null,null,12,null,null,null,0,0]
[null,13,null,null,null,13,null,null,null,0,0]
[null,14,null,null,null,14,null,null,null,0,0]
[null,15,null,null,null,15,null,null,null,0,0]
[null,16,null,null,null,16,null,null,null,0,0]
[null,17,null,null,null,17,null,null,null,0,0]
[null,18,null,null,null,18,null,null,null,0,0]
[null,19,null,null,null,19,null,null,null,0,0]
[null,20,null,null,null,20,null,null,null,0,0]
[null,21,null,null,null,21,null,null,null,0,0]
[null,22,null,null,null,22,null,null,null,0,0]
[null,23,null,null,null,23,null,null,null,0,0]
[null,24,null,null,null,24,null,null,null,0,0]
[null,25,null,null,null,25,null,null,null,0,0]
[null,26,null,null,null,26,null,null,null,0,0]
[null,27,null,null,null,27,null,null,null,0,0]
[null,28,null,null,null,28,null,null,null,0,0]
[null,29,null,null,null,29,null,null,null,0,0]
[null,30,null,null,null,30,null,null,null,0,0]
[null,31,null,null,null,31,null,null,null,0,0]
[null,32,null,null,null,32,null,null,null,0,0]
[null,33,null,null,null,{"$f":"F62+1","v":33},null,null,null,0,0]
[null,34,null,null,null,34,null,null,null,0,0]
[null,35,null,null,null,35,null,null,null,0,0]
[null,36,null,null,null,36,null,null,null,0,0]
[null,37,null,null,null,37,null,null,null,0,0]
[null,38,null,null,null,38,null,null,null,0,0]
[null,39,null,null,null,39,null,null,null,0,0]
[null,40,null,null,null,40,null,null,null,0,0]
[null,41,null,null,null,41,null,null,null,0,0]
[null,42,null,null,null,42,null,null,null,0,0]
[null,43,null,null,null,43,null,null,null,0,0]
[null,44,null,null,null,44,null,null,null,0,0]
[null,45,null,null,null,45,null,null,null,0,0]
[null,46,null,null,null,46,null,null,null,0,0]
[null,47,null,null,null,47,null,null,null,0,0]
[null,48,null,null,null,48,null,null,null,0,0]
[null,49,null,null,null,49,null,null,null,0,0]
[null,50,null,null,null,50,null,null,null,0,0]
[null,51,null,null,null,51,null,null,null,0,0]
[null,52,null,null,null,52,null,null,null,0,0]
[null,53,null,null,null,53,null,null,null,0,0]
[null,54,null,null,null,54,null,null,null,0,0]
[null,55,null,null,null,55,null,null,null,0,0]
[null,56,null,null,null,56,null,null,null,0,0]
[null,57,null,null,null,57,null,null,null,0,0]
[null,58,null,null,null,58,null,null,null,0,0]
[null,59,null,null,null,59,null,null,null,0,0]
[null,60,null,null,null,60,null,null,null,0,0]
[null,61,null,null,null,61,null,null,null,0,0]
[null,62,null,null,null,62,null,null,null,0,0]
[null,63,null,null,null,63,null,null,null,0,0]
[null,64,null,null,null,64,null,null,null,0,0]
[null,65,null,null,null,65,null,null,null,{"$f":"IF($C$18>$G$18,SUM($C95:$D95)/((1+$B$9)^($B95-$G$18+1)),SUM($C95:$D95)/((1+$B$9)^($B95-$C$18+1)))","v":0},{"$f":"IF($G$18>$C$18,SUM($G95:$H95)/((1+$B$9)^($F95-$C$18+1)),SUM($G95:$H95)/((1+$B$9)^($F95-$G$18+1)))","v":0}]
[null,{"$f":"B95+1","v":66},null,null,null,66,null,null,null,0,0]
[null,{"$f":"B96+1","v":67},null,null,null,67,null,null,null,0,0]
[null,{"$f":"B97+1","v":68},null,null,null,68,null,null,null,0,0]
[null,{"$f":"B98+1","v":69},null,null,null,{"$f":"F98+1","v":69},null,null,null,0,0]
[null,70,null,null,null,70,null,null,null,0,0]
[null,71,null,null,null,71,null,null,null,0,0]
[null,72,null,null,null,72,null,null,null,0,0]
[null,73,null,null,null,73,null,null,null,0,0]
[null,74,null,null,null,74,null,null,null,0,0]
[null,75,null,null,null,75,null,null,null,0,0]
[null,76,null,null,null,76,null,null,null,0,0]
[null,77,null,null,null,77,null,null,null,0,0]
[null,78,null,null,null,78,null,null,null,0,0]
[null,{"$f":"B108+1","v":79},null,null,null,{"$f":"F108+1","v":79},null,null,null,0,0]
[null,{"$f":"B109+1","v":80},null,null,null,{"$f":"F109+1","v":80},null,null,null,0,0]
[null,81,null,null,null,81,null,null,null,0,0]
[null,82,null,null,null,82,null,null,null,0,0]
[null,83,null,null,null,83,null,null,null,0,0]
[null,84,null,null,null,84,null,null,null,0,0]
[null,85,null,null,null,85,null,null,null,0,0]
[null,86,null,null,null,86,null,null,null,0,0]
[null,{"$f":"B116+1","v":87},null,null,null,{"$f":"F116+1","v":87},null,null,null,0,0]
[null,88,null,null,null,88,null,null,null,0,0]
[null,89,null,null,null,89,null,null,null,0,0]
[null,90,null,null,null,90,null,null,null,0,0]
[null,91,null,null,null,91,null,null,null,0,0]
[null,92,null,null,null,92,null,null,null,0,0]
[null,93,null,null,null,93,null,null,null,0,0]
[null,94,null,null,null,94,null,null,null,0,0]
[null,95,null,null,null,95,null,null,null,0,0]
[null,96,null,null,null,96,null,null,null,0,0]
[null,97,null,null,null,97,null,null,null,0,0]
[null,98,null,null,null,98,null,null,null,0,0]
[null,99,null,null,null,99,null,null,null,0,0]
[null,100,null,null,null,100,null,null,null,0,0]
[null,101,null,null,null,101,null,null,null,0,0]
[null,102,null,null,null,102,null,null,null,0,0]
[null,103,null,null,null,103,null,null,null,0,0]
[null,104,null,null,null,104,null,null,null,0,0]
[null,105,null,null,null,105,null,null,null,0,0]
[null,106,null,null,null,106,null,null,null,0,0]
[null,107,null,null,null,107,null,null,null,0,0]
[null,108,null,null,null,108,null,null,null,0,0]
[null,109,null,null,null,109,null,null,null,0,0]
[null,110,null,null,null,110,null,null,null,0,0]
[null,111,null,null,null,111,null,null,null,0,0]
[null,112,null,null,null,112,null,null,null,0,0]
[null,113,null,null,null,113,null,null,null,0,0]
[null,114,null,null,null,114,null,null,null,0,0]
[null,115,null,null,null,115,null,null,null,0,0]
[null,116,null,null,null,116,null,null,null,0,0]
[null,117,null,null,null,117,null,null,null,0,0]
[null,118,null,null,null,118,null,null,null,0,0]
[null,119,null,null,null,119,null,null,null,0,0]