{"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":3689838.2885852573}]
[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":1971304.3649014451}]
[]
[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":"Alternativt projekt er mest omkostningseffektivt"}]
[]
[]
[null,"Klimatilpasning ved sædvanlig afhjælpning",null,null,null,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2022,null,null,"Projektets startår",2022,null,null,null,{"$f":" IF($F18>=$G$18,IF($F18<=$G$19,SUM($G18:$H18),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2072,null,null,"Projektets slutår",2072]
[null,"Periodelængde",{"$f":"C19-C18","v":50},null,null,"Periodelængde",{"$f":"G19-G18","v":50}]
[]
[null,"Samlede anlægsomkostninger",70300000,null,null,"Selskabets samlede anlægsomkostninger",40000000]
[null,"Periodelængde for anlægsomkostninger",{"$f":"G23","v":1},null,null,"Periodelængde for anlægsomkostninger",1]
[]
[null,"Startår for drift",2023,null,null,"Startår for drift",2023]
[null,"Driftsomkostninger i det første år",850000,null,null,"Driftsomkostninger i det første år",350000]
[]
[]
[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":2022},70300000,null,null,{"$f":"G18","v":2022},40000000,null,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":67922705.314009666},{"$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":38647342.995169088}]
[null,{"$f":"B30+1","v":2023},null,850000,null,{"$f":"F30+1","v":2023},null,350000,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":793484.09531144262},{"$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":326728.74512824108}]
[null,{"$f":"B31+1","v":2024},null,850000,null,2024,null,350000,null,766651.29981781903,315679.94698380784]
[null,2025,null,850000,null,2025,null,350000,null,740725.89354378649,305004.77969450032]
[null,2026,null,850000,null,2026,null,350000,null,715677.19182974554,294690.60840048344]
[null,2027,null,850000,null,2027,null,350000,null,691475.54766158981,284725.22550771345]
[null,2028,null,850000,null,2028,null,350000,null,668092.31658124633,275096.8362393367]
[null,2029,null,850000,null,2029,null,350000,null,645499.822783813,265794.04467568768]
[null,2030,null,850000,null,2030,null,350000,null,623671.32636117202,256805.84026636495]
[null,2031,null,850000,null,2031,null,350000,null,602580.99165330641,248121.58479842026]
[null,2032,null,850000,null,2032,null,350000,null,582203.85666986124,239730.99980523696]
[null,2033,null,850000,null,2033,null,350000,null,562515.80354575964,231624.15440119515]
[null,2034,null,850000,null,2034,null,350000,null,543493.52999590314,223791.45352772484]
[null,2035,null,850000,null,2035,null,350000,null,525114.52173517202,216223.62659683556]
[null,2036,null,850000,null,2036,null,350000,null,507357.02583108417,208911.71651868173]
[null,2037,null,850000,null,2037,null,350000,null,490200.02495756937,201847.06910017563]
[null,2038,null,850000,null,2038,null,350000,null,473623.21251939068,195021.32280210205]
[null,2039,null,850000,null,2039,null,350000,null,457606.96861776884,188426.39884261071]
[null,2040,null,850000,null,2040,null,350000,null,442132.3368287622,182054.49163537269]
[null,2041,null,850000,null,2041,null,350000,null,427181.00176692003,175898.05955108473]
[null,2042,null,850000,null,2042,null,350000,null,412735.26740765228,169949.81599138625]
[null,2043,null,850000,null,2043,null,350000,null,398778.0361426592,164202.72076462439]
[null,2044,null,850000,null,2044,null,350000,null,385292.78854363208,158649.97175326027]
[null,2045,null,850000,null,2045,null,350000,null,372263.56381027261,153284.99686305344]
[null,2046,null,850000,null,2046,null,350000,null,359674.94087949052,148101.4462444961]
[null,2047,null,850000,null,2047,null,350000,null,347512.02017342078,143093.18477729091]
[null,2048,null,850000,null,2048,null,350000,null,335760.40596465778,138254.28480897672]
[null,2049,null,850000,null,2049,null,350000,null,324406.18933783361,133579.01913910796]
[null,2050,null,850000,null,2050,null,350000,null,313435.93172737554,129061.85424068404]
[null,2051,null,850000,null,2051,null,350000,null,302836.64901195699,124697.44371080582]
[null,2052,null,850000,null,2052,null,350000,null,292595.79614681838,120480.62194280757]
[null,2053,null,850000,null,2053,null,350000,null,282701.25231576664,116406.3980123745]
[null,2054,null,850000,null,2054,null,350000,null,273141.3065852818,112469.94977041015]
[null,2055,null,850000,null,{"$f":"F62+1","v":2055},null,350000,null,263904.64404375054,108666.61813566198]
[null,2056,null,850000,null,2056,null,350000,null,254980.33240942084,104991.90158034976]
[null,2057,null,850000,null,2057,null,350000,null,246357.80909122786,101441.45080227029]
[null,2058,null,850000,null,2058,null,350000,null,238026.8686871767,98011.063577072768]
[null,2059,null,850000,null,2059,null,350000,null,229977.65090548474,94696.679784611362]
[null,2060,null,850000,null,2060,null,350000,null,222200.62889418818,91494.376603489247]
[null,2061,null,850000,null,2061,null,350000,null,214686.59796539924,88400.363868105575]
[null,2062,null,850000,null,2062,null,350000,null,207426.66470086889,85410.979582710715]
[null,2063,null,850000,null,2063,null,350000,null,200412.23642596026,82522.685587160115]
[null,2064,null,850000,null,2064,null,350000,null,193635.01103957513,79732.063369236814]
[null,2065,null,850000,null,2065,null,350000,null,187086.96718799532,77035.8100185863]
[null,2066,null,850000,null,2066,null,350000,null,180760.35477101,74430.734317474693]
[null,2067,null,850000,null,2067,null,350000,null,174647.68576909174,71913.752963743667]
[null,2068,null,850000,null,2068,null,350000,null,168741.72538076501,69481.886921491474]
[null,2069,null,850000,null,2069,null,350000,null,163035.48345967638,67132.257895160859]
[null,2070,null,850000,null,2070,null,350000,null,157522.20624123322,64862.08492286074]
[null,2071,null,850000,null,2071,null,350000,null,152195.3683490176,62668.681084889606]
[null,2072,null,850000,null,2072,null,350000,null,147048.66507151464,60549.450323564844]
[null,2073,null,null,null,2073,null,null,null,0,0]
[null,2074,null,null,null,2074,null,null,null,0,0]
[null,2075,null,null,null,2075,null,null,null,0,0]
[null,2076,null,null,null,2076,null,null,null,0,0]
[null,2077,null,null,null,2077,null,null,null,0,0]
[null,2078,null,null,null,2078,null,null,null,0,0]
[null,2079,null,null,null,2079,null,null,null,0,0]
[null,2080,null,null,null,2080,null,null,null,0,0]
[null,2081,null,null,null,2081,null,null,null,0,0]
[null,2082,null,null,null,2082,null,null,null,0,0]
[null,2083,null,null,null,2083,null,null,null,0,0]
[null,2084,null,null,null,2084,null,null,null,0,0]
[null,2085,null,null,null,2085,null,null,null,0,0]
[null,2086,null,null,null,2086,null,null,null,0,0]
[null,2087,null,null,null,2087,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":2088},null,null,null,2088,null,null,null,0,0]
[null,{"$f":"B96+1","v":2089},null,null,null,2089,null,null,null,0,0]
[null,{"$f":"B97+1","v":2090},null,null,null,2090,null,null,null,0,0]
[null,{"$f":"B98+1","v":2091},null,null,null,{"$f":"F98+1","v":2091},null,null,null,0,0]
[null,2092,null,null,null,2092,null,null,null,0,0]
[null,2093,null,null,null,2093,null,null,null,0,0]
[null,2094,null,null,null,2094,null,null,null,0,0]
[null,2095,null,null,null,2095,null,null,null,0,0]
[null,2096,null,null,null,2096,null,null,null,0,0]
[null,2097,null,null,null,2097,null,null,null,0,0]
[null,2098,null,null,null,2098,null,null,null,0,0]
[null,2099,null,null,null,2099,null,null,null,0,0]
[null,2100,null,null,null,2100,null,null,null,0,0]
[null,{"$f":"B108+1","v":2101},null,null,null,{"$f":"F108+1","v":2101},null,null,null,0,0]
[null,{"$f":"B109+1","v":2102},null,null,null,{"$f":"F109+1","v":2102},null,null,null,0,0]
[null,2103,null,null,null,2103,null,null,null,0,0]
[null,2104,null,null,null,2104,null,null,null,0,0]
[null,2105,null,null,null,2105,null,null,null,0,0]
[null,2106,null,null,null,2106,null,null,null,0,0]
[null,2107,null,null,null,2107,null,null,null,0,0]
[null,2108,null,null,null,2108,null,null,null,0,0]
[null,{"$f":"B116+1","v":2109},null,null,null,{"$f":"F116+1","v":2109},null,null,null,0,0]
[null,2110,null,null,null,2110,null,null,null,0,0]
[null,2111,null,null,null,2111,null,null,null,0,0]
[null,2112,null,null,null,2112,null,null,null,0,0]
[null,2113,null,null,null,2113,null,null,null,0,0]
[null,2114,null,null,null,2114,null,null,null,0,0]
[null,2115,null,null,null,2115,null,null,null,0,0]
[null,2116,null,null,null,2116,null,null,null,0,0]
[null,2117,null,null,null,2117,null,null,null,0,0]
[null,2118,null,null,null,2118,null,null,null,0,0]
[null,2119,null,null,null,2119,null,null,null,0,0]
[null,2120,null,null,null,2120,null,null,null,0,0]
[null,2121,null,null,null,2121,null,null,null,0,0]
[null,2122,null,null,null,2122,null,null,null,0,0]
[null,2123,null,null,null,2123,null,null,null,0,0]
[null,2124,null,null,null,2124,null,null,null,0,0]
[null,2125,null,null,null,2125,null,null,null,0,0]
[null,2126,null,null,null,2126,null,null,null,0,0]
[null,2127,null,null,null,2127,null,null,null,0,0]
[null,2128,null,null,null,2128,null,null,null,0,0]
[null,2129,null,null,null,2129,null,null,null,0,0]
[null,2130,null,null,null,2130,null,null,null,0,0]
[null,2131,null,null,null,2131,null,null,null,0,0]
[null,2132,null,null,null,2132,null,null,null,0,0]
[null,2133,null,null,null,2133,null,null,null,0,0]
[null,2134,null,null,null,2134,null,null,null,0,0]
[null,2135,null,null,null,2135,null,null,null,0,0]
[null,2136,null,null,null,2136,null,null,null,0,0]
[null,2137,null,null,null,2137,null,null,null,0,0]
[null,2138,null,null,null,2138,null,null,null,0,0]
[null,2139,null,null,null,2139,null,null,null,0,0]
[null,2140,null,null,null,2140,null,null,null,0,0]
[null,2141,null,null,null,2141,null,null,null,0,0]