{"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":247448.52378947157}]
[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":47435.884439861155}]
[]
[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",2021,null,null,"Projektets startår",2021,null,null,null,{"$f":" IF($F18>=$G$18,IF($F18<=$G$19,SUM($G18:$H18),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2096,null,null,"Projektets slutår",2096]
[null,"Periodelængde",{"$f":"C19-C18","v":75},null,null,"Periodelængde",{"$f":"G19-G18","v":75}]
[]
[null,"Samlede anlægsomkostninger",1995000,null,null,"Selskabets samlede anlægsomkostninger",1069433]
[null,"Periodelængde for anlægsomkostninger",{"$f":"G23","v":1},null,null,"Periodelængde for anlægsomkostninger",1]
[]
[null,"Startår for drift",2022,null,null,"Startår for drift",2022]
[null,"Driftsomkostninger i det første år",99750,null,null,"Driftsomkostninger i det første år",4806]
[]
[]
[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":2021},1995000,null,null,{"$f":"G18","v":2021},1069433,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":1927536.2318840581},{"$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":1033268.5990338165}]
[null,{"$f":"B30+1","v":2022},null,99750,null,{"$f":"F30+1","v":2022},null,4806,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":93117.692361548703},{"$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":4486.4524259609334}]
[null,{"$f":"B31+1","v":2023},null,102004.34999999999,null,2023,null,4914.6156000000001,null,92002.079428907935,4432.7016915822715]
[null,2024,null,104309.64830999999,null,2024,null,5025.6859125599995,null,90899.832293721018,4379.5949273546184]
[null,2025,null,106667.046361806,null,2025,null,5139.2664141838559,null,89810.790824694821,4327.1244180800331]
[null,2026,null,109077.72160958279,null,2026,null,5255.4138351444099,null,88734.796809017294,4275.282540993855]
[null,2027,null,111542.87811795935,null,2027,null,5374.1861878186728,null,87671.693929373025,4224.0617646573101]
[null,2028,null,114063.74716342524,null,2028,null,5495.6427956633761,null,86621.327741233705,4173.4546478633501]
[null,2029,null,116641.58784931865,null,2029,null,5619.844322845368,null,85583.545650420856,4123.4538385556161]
[null,2030,null,119277.68773471325,null,2030,null,5746.8528045416733,null,84558.196890937557,4074.0520727603603]
[null,2031,null,121973.36347751775,null,2031,null,5876.7316779243138,null,83545.132503065441,4025.2421735311532]
[null,2032,null,124729.96149210965,null,2032,null,6009.5458138454032,null,82544.205311724378,3977.0170499062388]
[null,2033,null,127548.85862183131,null,2033,null,6145.3615492383087,null,81555.269905091161,3929.3696958783771]
[null,2034,null,130431.4628266847,null,2034,null,6284.2467202510943,null,80578.182613474593,3882.2931893770319]
[null,2035,null,133379.21388656777,null,2035,null,6426.2706961287686,null,79612.801488443612,3835.7806912627566]
[null,2036,null,136393.58412040418,null,2036,null,6571.5044138612784,null,78658.986282205253,3789.8254443336186]
[null,2037,null,139476.07912152531,null,2037,null,6720.020413614543,null,77716.598427230041,3744.4207723435347]
[null,2038,null,142628.23850967179,null,2038,null,6871.8928749622319,null,76785.501016121212,3699.5600790323665]
[null,2039,null,145851.63669999037,null,2039,null,7027.1976539363777,null,75865.55878172518,3655.2368471676309]
[null,2040,null,149147.88368941014,null,2040,null,7186.0123209153398,null,74956.638077480355,3611.4446375977]
[null,2041,null,152518.62586079081,null,2041,null,7348.4161993680254,null,74058.606858001367,3568.1770883163363]
[null,2042,null,155965.54680524467,null,2042,null,7514.4904054737426,null,73171.334659895845,3525.42791353844]
[null,2043,null,159490.3681630432,null,2043,null,7684.317888637449,null,72294.692582811098,3483.1909027868683]
[null,2044,null,163094.85048352796,null,2044,null,7857.9834729206559,null,71428.553270707867,3441.4599199901959]
[null,2045,null,166780.79410445568,null,2045,null,8035.5738994086623,null,70572.790893358324,3400.2289025912796]
[null,2046,null,170550.04005121638,null,2046,null,8217.1778695352968,null,69727.281128065923,3359.4918606665142]
[null,2047,null,174404.47095637384,null,2047,null,8402.886089386795,null,68891.901141604045,3319.2428760556304]
[null,2048,null,178346.01199998791,null,2048,null,8592.7913150069362,null,68066.529572371321,3279.4761015019203]
[null,2049,null,182376.63187118759,null,2049,null,8786.988398726091,null,67251.046512760295,3240.1857598027668]
[null,2050,null,186498.34375147644,null,2050,null,8985.5743365373019,null,66445.333491737852,3201.3661429703475]
[null,2051,null,190713.20632025981,null,2051,null,9188.6483165430436,null,65649.273457633943,3163.0116114023931]
[null,2052,null,195023.32478309766,null,2052,null,9396.3117684969166,null,64862.750761136704,3125.1165930628872]
[null,2053,null,199430.85192319567,null,2053,null,9608.6684144649462,null,64085.651138491208,3087.6755826725685]
[null,2054,null,203937.98917665987,null,{"$f":"F62+1","v":2054},null,9825.824320631853,null,63317.861694899613,3050.6831409091483]
[null,2055,null,208546.98773205237,null,2055,null,10047.887950278133,null,62559.27088812014,3014.1338936170969]
[null,2056,null,213260.14965479673,null,2056,null,10274.970217954417,null,61809.768512262468,2978.0225310269016]
[null,2057,null,218079.82903699519,null,2057,null,10507.184544880189,null,61069.245681777415,2942.3438069836816]
[null,2058,null,223008.43317323123,null,2058,null,10744.646915594478,null,60337.594815638222,2907.0925381850352]
[null,2059,null,228048.42376294624,null,2059,null,10987.475935886914,null,59614.709621711743,2872.2636034280367]
[null,2060,null,233202.31813998884,null,2060,null,11235.792892037958,null,58900.485081316372,2837.851942865228]
[null,2061,null,238472.69052995258,null,2061,null,11489.721811398016,null,58194.817433965349,2803.8525572695485]
[null,2062,null,243862.17333592946,null,2062,null,11749.389524335609,null,57497.6041622927,2770.2605073080576]
[null,2063,null,249373.45845332148,null,2063,null,12014.925727585594,null,56808.743977159917,2737.0709128243666]
[null,2064,null,255009.29861436656,null,2064,null,12286.463049029029,null,56128.136802940819,2704.27895212966]
[null,2065,null,260772.50876305121,null,2065,null,12564.137113937084,null,55455.683762982881,2671.8798613022127]
[null,2066,null,266665.96746109618,null,2066,null,12848.086612712061,null,54791.287165242786,2639.8689334953065]
[null,2067,null,272692.61832571687,null,2067,null,13138.453370159352,null,54134.850488093987,2608.2415182534305]
[null,2068,null,278855.4714998781,null,2068,null,13435.382416324954,null,53486.278366304272,2576.993020836675]
[null,2069,null,285157.60515577532,null,2069,null,13739.022058933897,null,52845.476577181405,2546.1189015532213]
[null,2070,null,291602.16703229584,null,2070,null,14049.523957465803,null,52212.352026884735,2515.61467509983]
[null,2071,null,298192.37600722571,null,2071,null,14367.04319890453,null,51586.812736900807,2485.4759099102289]
[null,2072,null,304931.523704989,null,2072,null,14691.738375199771,null,50968.767830680932,2455.6982275113041]
[null,2073,null,311822.9761407217,null,2073,null,15023.771662479285,null,50358.12752043896,2426.2773018870143]
[null,2074,null,318870.17540150206,null,2074,null,15363.308902051316,null,49754.803094107141,2397.2088588499137]
[null,2075,null,326076.64136557595,null,2075,null,15710.519683237673,null,49158.706902448263,2368.4886754202139]
[null,2076,null,333445.97346043796,null,2076,null,16065.577428078846,null,48569.752346322326,2340.1125792122816]
[null,2077,null,340981.85246064386,null,2077,null,16428.659477953428,null,47987.85386410552,2312.0764478284827]
[null,2078,null,348688.04232625436,null,2078,null,16799.947182155174,null,47412.926919260186,2284.3762082602957]
[null,2079,null,356568.39208282769,null,2079,null,17179.625988471878,null,46844.88798805359,2257.0078362965969]
[null,2080,null,364626.83774389961,null,2080,null,17567.885535811343,null,46283.654547423772,2229.967355939034]
[null,2081,null,372867.40427691175,null,2081,null,17964.919748920678,null,45729.145062990887,2203.2508388244028]
[null,2082,null,381294.20761356992,null,2082,null,18370.926935246287,null,45181.278977212052,2176.8544036539461]
[null,2083,null,389911.45670563658,null,2083,null,18786.109883982852,null,44639.976697678299,2150.774215629493]
[null,2084,null,398723.4556271839,null,2084,null,19210.675967360861,null,44105.159585551526,2125.0064858963474]
[null,2085,null,407734.60572435823,null,2085,null,19644.837244223214,null,43576.749944140094,2099.5474709928549]
[null,2086,null,416949.40781372873,null,2086,null,20088.810565942658,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":43054.671007611272},{"$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":2074.393472306564}]
[null,{"$f":"B95+1","v":2087},null,426372.46443031897,null,2087,null,20542.817684732963,null,42538.846929838917,2049.5408355369009]
[null,{"$f":"B96+1","v":2088},null,436008.48212644423,null,2088,null,21007.085364407929,null,42029.202773384815,2024.985950164285]
[null,{"$f":"B97+1","v":2089},null,445862.27382250177,null,2089,null,21481.845493643545,null,41525.664498611899,2000.7252489256018]
[null,{"$f":"B98+1","v":2090},null,455938.76121089031,null,{"$f":"F98+1","v":2090},null,21967.335201799888,null,41028.158952928039,1976.7552072959613]
[null,2091,null,466242.97721425648,null,2091,null,22463.796977360566,null,40536.613860158672,1953.0723429766672]
[null,2092,null,476780.06849929859,null,2092,null,22971.478789048913,null,40050.957810046624,1929.673215389314]
[null,2093,null,487555.29804738273,null,2093,null,23490.634209681419,null,39571.120247877952,1906.5544251759543]
[null,2094,null,498574.04778325354,null,2094,null,24021.522542820214,null,39097.031464231884,1883.7126137052471]
[null,2095,null,509841.82126315509,null,2095,null,24564.408952287951,null,38628.622584853641,1861.1444625845272]
[null,2096,null,521364.2464237024,null,2096,null,25119.564594609659,null,38165.825560648635,1838.8466931777175]
[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,{"$f":"B108+1","v":2100},null,null,null,{"$f":"F108+1","v":2100},null,null,null,0,0]
[null,{"$f":"B109+1","v":2101},null,null,null,{"$f":"F109+1","v":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,2107,null,null,null,2107,null,null,null,0,0]
[null,{"$f":"B116+1","v":2108},null,null,null,{"$f":"F116+1","v":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]
[null,2140,null,null,null,2140,null,null,null,0,0]