{"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,2.2599999999999999E-2]
[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":382728.59470568813}]
[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":179946.08521829845}]
[]
[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",2020,null,null,"Projektets startår",2020,null,null,null,{"$f":" IF($F18>=$G$18,IF($F18<=$G$19,SUM($G18:$H18),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2095,null,null,"Projektets slutår",2095]
[null,"Periodelængde",{"$f":"C19-C18","v":75},null,null,"Periodelængde",{"$f":"G19-G18","v":75}]
[]
[null,"Samlede anlægsomkostninger",9220000,null,null,"Selskabets samlede anlægsomkostninger",3730000]
[null,"Periodelængde for anlægsomkostninger",{"$f":"G23","v":1},null,null,"Periodelængde for anlægsomkostninger",1]
[]
[null,"Startår for drift",2020,null,null,"Startår for drift",2020]
[null,"Driftsomkostninger i det første år",25350,null,null,"Driftsomkostninger i det første år",24000]
[]
[]
[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":2020},9220000,25350,null,{"$f":"G18","v":2020},3730000,24000,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":8932705.3140096627},{"$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":3627053.1400966188}]
[null,{"$f":"B30+1","v":2021},null,25922.91,null,{"$f":"F30+1","v":2021},null,24542.399999999998,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":24199.313869635233},{"$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":22910.593012672409}]
[null,{"$f":"B31+1","v":2022},null,26508.767765999997,null,2022,null,25097.058239999998,null,23909.389722791293,22636.108613293534]
[null,2023,null,27107.865917511601,null,2023,null,25664.251756223999,null,23622.939063310514,22364.91272266084]
[null,2024,null,27720.503687247354,null,2024,null,26244.263845914655,null,23339.920276465051,22096.965942215433]
[null,2025,null,28346.987070579144,null,2025,null,26837.384208832325,null,23060.292246099671,21832.229345419808]
[null,2026,null,28987.628978374236,null,2026,null,27443.90909195194,null,22784.014348658482,21570.664472102704]
[null,2027,null,29642.749393285492,null,2027,null,28064.141437430051,null,22511.046447283254,21312.233322871718]
[null,2028,null,30312.675529573742,null,2028,null,28698.39103391597,null,22241.348885982468,21056.898353592871]
[null,2029,null,30997.741996542107,null,2029,null,29346.974671282467,null,21974.882483870217,20804.622469936297]
[null,2030,null,31698.290965663953,null,2030,null,30010.216298853447,null,21711.608529474084,20555.369021987299]
[null,2031,null,32414.67234148796,null,2031,null,30688.447187207534,null,21451.488775111306,20309.101798921944]
[null,2032,null,33147.24393640559,null,2032,null,31382.006093638425,null,21194.485431332199,20065.785023746459]
[null,2033,null,33896.371649368346,null,2033,null,32091.23943135465,null,20940.56116143024,19825.383348099636]
[null,2034,null,34662.429648644073,null,2034,null,32816.501442503264,null,20689.679076017939,19587.861847117576]
[null,2035,null,35445.800558703428,null,2035,null,33558.154375103833,null,20441.802727667586,19353.186014359842]
[null,2036,null,36246.875651330127,null,2036,null,34316.568663981183,null,20196.896105616303,19121.321756796497]
[null,2037,null,37066.055041050182,null,2037,null,35092.123115787152,null,19954.923630534522,18892.235389855166]
[null,2038,null,37903.747884977915,null,2038,null,35885.205098203944,null,19715.850149357106,18665.893632527437]
[null,2039,null,38760.372587178412,null,2039,null,36696.210733423351,null,19479.6409301764,18442.263602533872]
[null,2040,null,39636.357007648643,null,2040,null,37525.545095998714,null,19246.261657196512,18221.312811546992]
[null,2041,null,40532.138676021503,null,2041,null,38373.622415168284,null,19015.678425747974,18003.009160471454]
[null,2042,null,41448.16501009959,null,2042,null,39240.866281751092,null,18787.857737362203,17787.320934780782]
[null,2043,null,42384.893539327837,null,2043,null,40127.709859718663,null,18562.766494904918,17574.216799909984]
[null,2044,null,43342.792133316645,null,2044,null,41034.596102548297,null,18340.371997767896,17363.665796703332]
[null,2045,null,44322.339235529595,null,2045,null,41961.977974465888,null,18120.641937118307,17155.637336916738]
[null,2046,null,45324.024102252566,null,2046,null,42910.318676688818,null,17903.544391205007,16950.101198773969]
[null,2047,null,46348.34704696347,null,2047,null,43880.091878781983,null,17689.047820721004,16747.027522576096]
[null,2048,null,47395.819690224838,null,2048,null,44871.781955242455,null,17477.121064221545,16546.386806363593]
[null,2049,null,48466.965215223921,null,2049,null,45885.884227430935,null,17267.733333597054,16348.149901630348]
[null,2050,null,49562.318629087982,null,2050,null,46922.905210970865,null,17060.854209600337,16152.288009089074]
[null,2051,null,50682.427030105362,null,2051,null,47983.362868738805,null,16856.453637427348,15958.772674487431]
[null,2052,null,51827.849880985741,null,2052,null,49067.786869572301,null,16654.501922350926,15767.575784474249]
[null,2053,null,52999.159288296018,null,{"$f":"F62+1","v":2053},null,50176.718852824633,null,16454.96972540682,15578.669562515332]
[null,2054,null,54196.940288211503,null,2054,null,51310.71269889846,null,16257.828059131412,15392.026564858141]
[null,2055,null,55421.791138725086,null,2055,null,52470.334805893574,null,16063.048283350518,15207.619676544868]
[null,2056,null,56674.323618460265,null,2056,null,53656.164372506755,null,15870.602101018587,15025.422107473218]
[null,2057,null,57955.163332237469,null,2057,null,54868.793687325415,null,15680.461554107833,14845.407388504456]
[null,2058,null,59264.950023546036,null,2058,null,56108.828424658968,null,15492.599019546544,14667.549367618029]
[null,2059,null,60604.337894078169,null,2059,null,57376.887947056261,null,15306.987205206084,14491.822206112271]
[null,2060,null,61973.995930484329,null,2060,null,58673.605614659718,null,15123.599145935983,14318.200374850634]
[null,2061,null,63374.608238513276,null,2061,null,59999.629101551036,null,14942.408199646508,14146.658650552909]
[null,2062,null,64806.874384703682,null,2062,null,61355.620719246086,null,14763.388043438183,13977.172112130824]
[null,2063,null,66271.509745797972,null,2063,null,62742.25774750104,null,14586.512669777667,13809.716137067615]
[null,2064,null,67769.24586605301,null,2064,null,64160.232772594565,null,14411.756382719463,13644.266397840911]
[null,2065,null,69300.830822625794,null,2065,null,65610.254033255187,null,14239.093794172868,13480.798858388513]
[null,2066,null,70867.029599217145,null,2066,null,67093.045774406768,null,14068.499820213701,13319.289770616522]
[null,2067,null,72468.62446815944,null,2067,null,68609.348608908345,null,13899.949677440125,13159.715670949232]
[null,2068,null,74106.415381139843,null,2068,null,70159.919887469674,null,13733.418879372246,13002.053376920469]
[null,2069,null,75781.220368753609,null,2069,null,71745.534076926488,null,13568.883232894743,12846.279983805673]
[null,2070,null,77493.875949087436,null,2070,null,73366.983147065024,null,13406.318834742189,12692.37286129438]
[null,2071,null,79245.237545536802,null,2071,null,75025.076966188688,null,13245.702068026436,12540.309650202544]
[null,2072,null,81036.179914065928,null,2072,null,76720.643705624549,null,13087.009598805638,12390.068259224274]
[null,2073,null,82867.597580123809,null,2073,null,78454.53025337166,null,12930.218372694342,12241.626861722456]
[null,2074,null,84740.405285434608,null,2074,null,80227.602637097865,null,12775.305611514235,12094.963892557857]
[null,2075,null,86655.538444885431,null,2075,null,82040.746456696259,null,12622.248809984987,11950.058044956199]
[null,2076,null,88613.953613739839,null,2076,null,83894.86732661759,null,12471.025732454733,11806.888267412764]
[null,2077,null,90616.628965410346,null,2077,null,85790.891328199141,null,12321.614409669764,11665.433760634098]
[null,2078,null,92664.564780028624,null,2078,null,87729.765472216444,null,12173.993135582899,11525.673974516354]
[null,2079,null,94758.783944057272,null,2079,null,89712.458171888531,null,12028.140464200073,11387.58860515983]
[null,2080,null,96900.332461192957,null,2080,null,91739.959726573215,null,11884.03520646473,11251.157591919273]
[null,2081,null,99090.279974815916,null,2081,null,93813.282816393767,null,11741.656427179549,11116.361114489513]
[null,2082,null,101329.72030224674,null,2082,null,95933.463008044244,null,11600.983441965031,10983.179590026062]
[null,2083,null,103619.77198107752,null,2083,null,98101.559272026047,null,11461.995814254533,10851.59367030015]
[null,2084,null,105961.57882784985,null,2084,null,100318.65451157383,null,11324.673352325299,10721.584238887857]
[null,2085,null,108356.31050935926,null,2085,null,102585.85610353539,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":11188.996106365075},{"$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":10593.13240839297}]
[null,{"$f":"B95+1","v":2086},null,110805.16312687079,null,2086,null,104904.2964514753,null,11054.944365573841,10466.219517703046]
[null,{"$f":"B96+1","v":2087},null,113309.35981353805,null,2087,null,107275.13355127862,null,10922.498655300298,10340.827129278388]
[null,{"$f":"B97+1","v":2088},null,115870.151345324,null,2088,null,109699.55156953752,null,10791.639734212646,10216.93702647351]
[null,{"$f":"B98+1","v":2089},null,118488.81676572833,null,{"$f":"F98+1","v":2089},null,112178.76143500907,null,10662.348591503236,10094.531210890638]
[null,2090,null,121166.66402463378,null,2090,null,114714.00144344027,null,10534.606444126774,9973.5918997649933]
[null,2091,null,123905.0306315905,null,2091,null,117306.53787606202,null,10408.394734071537,9854.1015233813359]
[null,2092,null,126705.28432386443,null,2092,null,119957.66563206101,null,10283.695125663335,9736.0427225215026]
[null,2093,null,129568.82374958377,null,2093,null,122668.70887534558,null,10160.489502901766,9619.3983459425017]
[null,2094,null,132497.07916632437,null,2094,null,125441.02169592839,null,10038.759966828355,9504.1514478848312]
[null,2095,null,135491.51315548326,null,2095,null,128275.98878625635,null,9918.488832926254,9390.2852856106547]
[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,{"$f":"B108+1","v":2099},null,null,null,{"$f":"F108+1","v":2099},null,null,null,0,0]
[null,{"$f":"B109+1","v":2100},null,null,null,{"$f":"F109+1","v":2100},null,null,null,0,0]
[null,2101,null,null,null,2101,null,null,null,0,0]
[null,2102,null,null,null,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,{"$f":"B116+1","v":2107},null,null,null,{"$f":"F116+1","v":2107},null,null,null,0,0]
[null,2108,null,null,null,2108,null,null,null,0,0]
[null,2109,null,null,null,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]