{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["1. Forside","2. Samlet prisloft","3. Driftsomkostninger","4. Historiske investeringer","5. Gennemførte investeringer","6. Korrektion investeringer","7. Planlagte investeringer","8. 1-1 omkostninger","9. Miljø- og servicemål","10. Klimatilpasning","11. Nettofinansielle poster","12. Over- eller underdækning","13. Kontrol med indtægtsrammen","14. EAA","15. EAA","16. EAA","17. EAA"],"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":"1. Forside","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[26,3,26,5],[25,3,25,5],[24,3,24,5],[23,3,23,5],[22,3,22,5],[21,3,21,5],[20,3,20,5],[19,3,19,5],[18,3,18,5],[7,3,7,5],[12,3,12,5],[15,3,15,5],[16,3,16,5],[17,3,17,5]]}
["HOFOR Spildevand København A/S"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Bilag A"]
[]
[]
[]
[]
[null,null,null,"Indholdsfortegnelse"]
[]
[]
[null,null,"Fane nr. 2","Samlet prisloft "]
[null,null,"Fane nr. 3","Driftsomkostninger"]
[null,null,"Fane nr. 4","Historiske investeringer "]
[null,null,"Fane nr. 5","Gennemførte investeringer"]
[null,null,"Fane nr. 6","Korrektion investeringer"]
[null,null,"Fane nr. 7","Planlagte investeringer"]
[null,null,"Fane nr. 8","1:1 omkostninger"]
[null,null,"Fane nr. 9","Miljø- og servicemål"]
[null,null,"Fane nr. 10","Klimatilpasning"]
[null,null,"Fane nr. 11","Nettofinansielle poster"]
[null,null,"Fane nr. 12","Over- eller underdækning"]
[null,null,"Fane nr. 13","Kontrol med indtægtsrammen og oversigt over ekstraordinære effektiviseringsgevinster"]
[null,null,"Fane nr. 14","EAA-beregning"]
[null,null,"Fane nr. 15","EAA-beregning"]
[null,null,"Fane nr. 16","EAA-beregning"]
[null,null,"Fane nr. 17","EAA-beregning"]

{"sheet":"2. Samlet prisloft","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,5]]}
[{"$f":"'1. Forside'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 2. Samlet prisloft for 2015"]
[]
[null,"Driftsomkostninger"]
[null,"Driftsomkostninger i prisloftet for 2014",{"$f":"'3. Driftsomkostninger'!C19","v":130405000.66557695},"kr."]
[null,"Bortfald af væsentlige omkostninger",{"$f":"-'3. Driftsomkostninger'!C24","v":0},"kr."]
[null,"Korrektion for prisudviklingen 2014-2015",{"$f":"'3. Driftsomkostninger'!C30","v":104324.00053246156},"kr."]
[null,"Forhøjelse til effektivt niveau iht. benchmarkingen",{"$f":"'3. Driftsomkostninger'!C36","v":0},"kr."]
[null,"Korrektion for generelt effektiviseringskrav",{"$f":"-'3. Driftsomkostninger'!C42","v":-573782.0029285386},"kr."]
[null,"Korrektion for individuelt effektiviseringskrav",{"$f":"-'3. Driftsomkostninger'!C51","v":-6520250.033278848},"kr."]
[null,"Driftsomkostninger i alt",{"$f":"SUM(C7:C12)","v":123415292.62990202},"kr.",{"$f":"C13","v":123415292.62990202}," kr."]
[null,"Investeringer"]
[null,"Tillæg for historiske investeringer",{"$f":"'4. Historiske investeringer'!C9","v":115540516.58069028},"kr."]
[null,"Tillæg for gennemførte investeringer i 2011-2013",{"$f":"'5. Gennemførte investeringer'!F31","v":8726337.8533333335},"kr."]
[null,"Korrektion af tillæg for planlagte investeringer vedrørende 2013  ",{"$f":"'6. Korrektion investeringer'!C10","v":-3059476.7333333343},"kr."]
[null,"Tillæg for planlagte investeringer i 2014 og 2015",{"$f":"'7. Planlagte investeringer'!F34","v":6575138.4000000004},"kr."]
[null,"Investeringstillæg i alt",{"$f":"SUM(C15:C18)","v":127782516.10069029},"kr.",{"$f":"C19","v":127782516.10069029}," kr."]
[null,"Øvrige omkostninger mv."]
[null,"Tillæg for 1:1 omkostninger i 2015",{"$f":"'8. 1-1 omkostninger'!C10","v":254908596},"kr."]
[null,"Tillæg vedr. revisorerklæringer og DANVA/FVD-kontingent",{"$f":"'8. 1-1 omkostninger'!C18","v":169000},"kr."]
[null,"Korrektion ift. faktiske 1:1 omkostninger i 2013",{"$f":"'8. 1-1 omkostninger'!C24","v":-40910366},"kr."]
[null,"Tillæg for driftsomkostninger til miljø- og servicemål i 2015",{"$f":"'9. Miljø- og servicemål'!C9","v":5170000},"kr."]
[null,"Korrektion ift. faktiske driftsomkostninger til miljø- og servicemål i 2013",{"$f":"'9. Miljø- og servicemål'!C16","v":-197273},"kr."]
[null,"Tillæg for driftsomkostninger til medfinansiering af klimatilpasningsprojekter i 2015",{"$f":"'10. Klimatilpasning'!C16","v":3359073},"kr."]
[null,"Korrektion ift. faktiske omkostninger til medfinansiering af klimatilpasningsprojekter i 2013",{"$f":"'10. Klimatilpasning'!C23","v":0},"kr."]
[null,"Tillæg/fradrag for nettofinansielle poster i 2015",{"$f":"'11. Nettofinansielle poster'!C9","v":2775000},"kr."]
[null,"Korrektion ift. faktiske nettofinansielle poster i 2013",{"$f":"'11. Nettofinansielle poster'!C16","v":2402162},"kr."]
[null,"Øvrige omkostninger mv. i alt",{"$f":"SUM(C21:C29)","v":227676192},"kr.",{"$f":"C30","v":227676192}," kr."]
[null,"Historisk over- eller underdækning"]
[null,"Tillæg/fradrag for over- eller underdækning til og med 2010",{"$f":"'12. Over- eller underdækning'!C11","v":-18533681},"kr.",{"$f":"C32","v":-18533681}," kr."]
[null,"Korrektion i forhold til tidligere indtægtsramme "]
[null,"Korrektion for overholdelse af indtægtsramme i prisloft 2013",{"$f":"'13. Kontrol med indtægtsrammen'!E27","v":-11959378.870293975},"kr.",{"$f":"C34","v":-11959378.870293975}," kr."]
[null,"Samlet prisloft"]
[null,"Indtægtsramme i 2015 ",null,null,{"$f":"SUM(E13:E34)","v":448380940.86029834}," kr."]
[null,"Debiteret vandmængde i 2013",null,null,29554588," m3"]
[null,"Prisloft 2015",null,null,{"$f":"E36/E37","v":15.171280373128475}," kr./m3"]

{"sheet":"3. Driftsomkostninger","index":2,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'1. Forside'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 3. Driftsomkostninger "]
[]
[null,"Driftsomkostningerne i prisloftet for 2014"]
[null,"Korrigerede driftsomkostninger i prisloftet for 2013 (DOiPL 2013)",125759820.17153333,"kr."]
[null,"Prisfremskrivning 1,5 pct.",{"$f":"0.015*SUM(C7:C7)","v":1886397.3025729998},"kr."]
[null,"Generelt effektiviseringskrav (0 pct.)",0,"kr."]
[null,"Individuelt effektiviseringskrav ",-4633941,"kr."]
[null,"Tillæg i henhold til § 8, stk. 2, pkt. 1",17937199,"kr."]
[null,"Driftsomkostningerne i prisloftet for 2014 (DOiPL 2014)",{"$f":"SUM(C7:C11)","v":140949475.47410631},"kr."]
[]
[]
[null,"Forskel i § 8, stk. 2, pkt. 1 - tillæg"]
[null,"Godkendt tillæg i PL2014 angivet i 2014-niveau",17937199,"kr."]
[null,"Godkendt tillæg i PL2015 angivet i 2014-niveau",7392724.1914706398,"kr."]
[null,"Forskel",{"$f":"C17-C16","v":-10544474.80852936},"kr."]
[null,"Korrigerede driftsomkostninger i prisloftet for 2014",{"$f":"C12+C18","v":130405000.66557695},"kr."]
[]
[]
[null,"Korrektion for forventet bortfald af væsentlige omkostninger"]
[null,"Selskabets indberettede bortfald af væsentlige omkostninger inden 2015",0,"kr."]
[null,"Korrektion for forventet bortfald ",{"$f":"SUM(C23:C23)","v":0},"kr."]
[]
[]
[null,"Korrektion for prisudviklingen fra 2014-2015"]
[null,"Driftsomkostningerne i prisloftet for 2014",{"$f":"C19-C24","v":130405000.66557695},"kr."]
[null,"Prisudvikling 2014 - 2015 ",0.08,"pct."]
[null,"Korrektion for prisudvikling",{"$f":"C28*(C29/100)","v":104324.00053246156},"kr."]
[]
[]
[null,"Eventuel forhøjelse til effektivt niveau iht. benchmarkingen"]
[null,"Selskabets effektive driftsomkostninger iht. benchmarkingen",86302029.440478832,"kr."]
[null,"Selskabets pristalskorrigerede driftsomkostninger i 2015-niveau",{"$f":"C28+C30","v":130509324.66610941},"kr."]
[null,"Eventuel forhøjelse til effektivt niveau",{"$f":"IF(C35>C34,0,C34-C35)","v":0},"kr."]
[]
[]
[null,"Korrektion for generelt effektiviseringskrav"]
[null,"Driftsomkostningerne i prisloftet for 2014",{"$f":"C28","v":130405000.66557695},"kr. "]
[null,"Generelt effektiviseringskrav ",0.44,"pct."]
[null,"Endeligt generelt effektiviseringskrav",{"$f":"C40*(C41/100)","v":573782.0029285386},"kr. "]
[]
[]
[null,"Korrektion for individuelt effektiviseringskrav"]
[null,"Rå effektiviseringspotentiale",48614984.248127095,"kr."]
[null,"Effektiviseringspotentiale efter eventuel korrektion for særlige forhold",42251220.215646937,"kr."]
[null,"Effektiviseringspotentiale efter forsigtighedshensyn",26146202.633448184,"kr."]
[null,"Effektiviseringspotentiale efter eventuel korrektion for sammensætning af signifikante costdrivere",26146202.633448184,"kr. "]
[null,"Umiddelbart effektiviseringskrav",{"$f":"C49/4","v":6536550.6583620459},"kr."]
[null,"Endeligt individuelt effektiviseringskrav",{"$f":"IF(C50>0.05*C28,0.05*C28,IF(C50<0.01*C28,0,C50))","v":6520250.033278848},"kr. "]

{"sheet":"4. Historiske investeringer","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[{"$f":"'3. Driftsomkostninger'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 4. Historiske investeringer "]
[]
[null,"Tillæg for historiske investeringer "]
[null,"Værdi af selskabets materielle anlægsaktiver pr. 1. januar 2010",4786534652.9017687,"kr."]
[null,"Den årlige standardafskrivning på de materielle anlægsaktiver iht. POLKA",115540516.58069028,"kr."]
[null,"Tillæg i alt i 2015",{"$f":"C8","v":115540516.58069028},"kr."]

{"sheet":"5. Gennemførte investeringer","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,1,3,5],[6,5,6,6]]}
[{"$f":"'4. Historiske investeringer'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 5. Gennemførte investeringer i 2010 - 2013 "]
[]
[null,"Tillæg for gennemførte investeringer i 2013"]
[null," Beskrivelse af investeringen   ","Årstal ","Std. levetid (år)   "," Anskaffelses-pris (kr.)","Afskrivning "]
[null,"Pumpeinstallation Miljøklasse A (1.000-1.500 l/s) - Mek/EL",2013,20,1336753,{"$f":"E8/D8","v":66837.649999999994},"kr."]
[null,"Pumpeinstallation Miljøklasse A (1.000-1.500 l/s) - Mek/EL",2013,20,1274601,{"$f":"E9/D9","v":63730.05},"kr."]
[null,"Pumpestationer i brønde (< 6,25 m2), SRO",2013,10,645377,64537.7,"kr."]
[null,"Pumpestationer i underjordiske bygværker (",2013,50,1538902,30778.04,"kr."]
[null,"Pumpestationer i underjordiske bygværker (",2013,20,396000,19800,"kr."]
[null,"Pumpestationer i underjordiske bygværker (",2013,10,300610,30061,"kr."]
[null,"Stik",2013,75,25799619,343994.92,"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), SRO",2013,10,4514755,451475.5,"kr."]
[null,"Strømpeforing Ø 500 mm < Ledningsnet = Ø 800 mm",2013,50,2489433,49788.66,"kr."]
[null,"Ø 200 mm < Ledningsnet = Ø 500 mm",2013,75,-218240,-2909.8666666666668,"kr."]
[null,"Ø 500 mm < Ledningsnet = Ø 800 mm",2013,75,6039523,80526.973333333328,"kr."]
[null,"Ø 800 mm < Ledningsnet = Ø 1000 mm",2013,75,1715570,22874.266666666666,"kr."]
[null,"Pumpeinstallation Miljøklasse A (100-300 l/s) - SRO",2013,10,80000,8000,"kr."]
[null,"Andre bygninger (tekniske installationer, målere mv.)",2013,75,1283255,17110.066666666666,"kr."]
[null,"Administrationbygninger",2013,75,1519653,20262.04,"kr."]
[null,"Brønde",2013,75,2049614,27328.186666666668,"kr."]
[null,"Forsinkelsesbassiner, lukkede med automatisk rensning og SRO Miljøklasse A (1.000-3.000 m3) - SRO",2013,10,1271922,127192.2,"kr."]
[null,"Kælder",2013,75,446584,5954.4533333333329,"kr."]
[null,"Kælder (7 - 20 m2)",2013,75,12875460,171672.8,"kr."]
[null,"Overbygning",2013,75,1359022,18120.293333333335,"kr."]
[null,"Oversvømmelseskort",2013,5,3127991,625598.19999999995,"kr."]
[null,"Tillæg for 2013 ",null,null,null,{"$f":"SUM(F8:F28)","v":2242733.1333333328},"kr."]
[null,"Tillæg for 2010 - 2012",null,null,null,6483604.7200000007,"kr."]
[null,"Samlet tillæg for gennemførte investeringer",null,null,null,{"$f":"F29+F30","v":8726337.8533333335},"kr."]

{"sheet":"6. Korrektion investeringer","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'5. Gennemførte investeringer'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 6. Korrektion af tillæg for planlagte investeringer"]
[]
[null,"Korrektion af tillæg for planlagte investeringer vedr. 2013"]
[null,"Tillæg for planlagte investeringer i 2013 i prisloft 2013",4200000,"kr."]
[null,"Tillæg for planlagte investeringer i 2013 i prisloft 2014",3344943,"kr."]
[null,"Selskabets faktiske afskrivninger på gennemførte investeringer i 2013",{"$f":"'5. Gennemførte investeringer'!F29","v":2242733.1333333328},"kr."]
[null,"Korrektion af tillæg for planlagte investeringer vedr. 2013",{"$f":"C9-C7+C9-C8","v":-3059476.7333333343},"kr."]

{"sheet":"7. Planlagte investeringer","index":6,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,5,6,6],[3,1,3,6]]}
[{"$f":"'6. Korrektion investeringer'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 7. Planlagte investeringer "]
[]
[null,"Tillæg for planlagte investeringer i 2014 og 2015"]
[null,"Beskrivelse af investeringen   ","Årstal ","Std. levetid (år)   ","Anskaffelses-pris (kr.)   ","Afskrivning"]
[null,"Forsinkelsesbassiner, lukkede med automatisk rensning og SRO Miljøklasse A (1.000-3.000 m3) - Mek/EL",2014,20,150000,{"$f":"E8/D8","v":7500},"kr."]
[null,"Overbygning",2014,75,6600000,{"$f":"E9/D9","v":88000},"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), Mek/EL",2014,20,2100000,{"$f":"E10/D10","v":105000},"kr."]
[null,"Pumpestationer m. overbygning (< 20 m2), SRO",2014,10,3000000,300000,"kr."]
[null,"Ø 200 mm < Ledningsnet = Ø 500 mm",2014,75,36700000,489333.33333333331,"kr."]
[null,"Ø 500 mm < Ledningsnet = Ø800 mm",2014,75,54385000,725133.33333333337,"kr."]
[null,"Stik",2014,75,19450000,259333.33333333334,"kr."]
[null,"Strømpeforing Ø 200 mm < Ledningsnet = Ø 500 mm",2014,50,5200000,104000,"kr."]
[null,"Ø 800 mm < Ledningsnet = Ø 1000 mm",2014,75,6750000,90000,"kr."]
[null,"Kælder",2015,75,720000,9600,"kr."]
[null,"Ledningsnet > Ø 1600 mm (rørbassiner og transportledninger)",2015,75,93359700,1244796,"kr."]
[null,"Mindre renseanlæg < 5.000 PE uden mulighed for opdeling",2015,40,450000,11250,"kr."]
[null,"Pumpeinstallation Miljøklasse B (1.000-1.500 l/s) - Mek/EL",2015,20,2664000,133200,"kr."]
[null,"Pumpeinstallation Miljøklasse A (1.000-1.500 l/s) - Mek/EL",2015,20,27630000,1381500,"kr."]
[null,"Pumpeinstallation Miljøklasse B (1.000-1.500 l/s) - SRO",2015,10,751156,75115.600000000006,"kr."]
[null,"Stik",2015,75,15345000,204600,"kr."]
[null,"Ø 1200 mm < Ledningsnet = Ø 1600 mm",2015,75,70124760,934996.8,"kr."]
[null,"Administrationbygninger",2015,75,3150000,42000,"kr."]
[null,"Brønde",2015,75,1350000,18000,"kr."]
[null,"Forsinkelsesbassiner, lukkede med automatisk rensning og SRO Miljøklasse A (større end 10.000 m3) - Konstruktioner",2015,75,558000,7440,"kr."]
[null,"Faskiner",2015,5,664200,132840,"kr."]
[null,"Hydraulisk model",2015,5,450000,90000,"kr."]
[null,"GIS Datasystem",2015,30,3375000,112500,"kr."]
[null,"Jordbassin Klasse B",2015,50,450000,9000,"kr."]
[null,"Tillæg for 2014",null,null,null,{"$f":"SUMIF(C8:C31,\"2014\",F8:F31)","v":2168300},"kr."]
[null,"Tillæg for 2015",null,null,null,{"$f":"SUMIF(C8:C31,\"2015\",F8:F31)","v":4406838.4000000004},"kr."]
[null,"Tillæg i alt",null,null,null,{"$f":"F32+F33","v":6575138.4000000004},"kr."]

{"sheet":"8. 1-1 omkostninger","index":7,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,3],[14,1,14,3],[20,1,20,3]]}
[{"$f":"'7. Planlagte investeringer'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 8. 1:1 omkostninger"]
[]
[null,"Tillæg for budgetterede 1:1 omkostninger i 2015"]
[null,"Betaling til Forsyningssekretariatet",35000,"kr."]
[null,"Køb af varer og tjenesteydelser hos et andet prisloftreguleret vandselskab",249873596,"kr."]
[null,"Ejendomsskatter",5000000,"kr."]
[null,"Tillæg i alt ",{"$f":"SUM(C7:C9)","v":254908596},"kr."]
[]
[]
[]
[]
[null,"Tillæg for budgetterede nødvendige udgifter til revisorerklæringer samt ordinært medlemskab af DANVA og FVD i 2015"]
[null,"Betaling for ordinært medlemskab af DANVA/FVD",145000,"kr."]
[null,"Betaling for revisorerklæringer",24000,"kr."]
[null,"Tillæg i alt ",{"$f":"SUM(C16:C17)","v":169000},"kr."]
[]
[]
[null,"Korrektion af tillæg for faktiske 1:1 omkostninger (inkl. revisorerklæringer og ordinært medlemskab af DANVA/FVD) i 2013"]
[null,"Selskabets faktiske 1:1 omkostninger mv. i 2013, jf. reguleringsregnskabet",195090082,"kr."]
[null,"Tillæg for budgetterede 1:1 omkostninger mv. i prisloft 2013",236000448,"kr."]
[null,"Korrektion af tillæg for budgetterede 1:1 omkostninger mv. i 2013",{"$f":"C22-C23","v":-40910366},"kr."]

{"sheet":"9. Miljø- og servicemål","index":8,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'8. 1-1 omkostninger'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 9. Driftsomkostninger til miljø- og servicemål "]
[]
[null,"Tillæg for budgetterede driftsomkostninger til miljø- og servicemål i 2015"]
[null,"DSS",1370000,"kr."]
[null,"Klimaunderstøttende tiltag",3800000,"kr."]
[null,"Tillæg i alt",{"$f":"SUM(C7:C8)","v":5170000},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske driftsomkostninger til miljø- og servicemål i 2013"]
[null,"Selskabets faktiske driftsomkostninger til miljø- og servicemål i 2013, jf. reguleringsregnskabet",302727,"kr."]
[null,"Tillæg for budgetterede driftsomkostninger til miljø- og servicemål i prisloft 2013",500000,"kr."]
[null,"Korrektion af tillæg for budgetterede driftsomkostninger til miljø- og servicemål i 2013",{"$f":"C14-C15","v":-197273},"kr."]

{"sheet":"10. Klimatilpasning","index":9,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,3],[19,1,19,3],[6,1,6,3]]}
[{"$f":"'9. Miljø- og servicemål'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 10. Medfinansiering af klimatilpasningsprojekter"]
[]
[]
[null,"Tillæg for budgetterede omkostninger til medfinansiering af klimatilpasningsprojekter i 2015"]
[null,"Ryparken (godkendt i PL2013)",0,"kr."]
[null,"Tåsinge Plads (godkendt i PL2014)",280521,"kr."]
[null,"Amagerbanen (godkendt i PL2014)",303766,"kr."]
[null,"Sankt Annæ Plads (godkendt i PL2014)",160030,"kr."]
[null,"Strandstræderne (godkendt i PL2015)",247150,"kr."]
[null,"Enghave Park (godkendt i PL2015)",2216707,"kr."]
[null,"Skt. Kjelds Kvarteret (godkendt i PL2015)",0,"kr."]
[null,"Grundejerforeningen Øresund (godkendt i PL2015)",150899,"kr."]
[null,"Tillæg i alt",{"$f":" SUM(C8:C15)","v":3359073},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske omkostninger til medfinansiering af klimatilpasningsprojekter i 2013"]
[null,"Selskabets faktiske driftsomkostninger til klimatilpasningsprojekter i 2013, jf. reguleringsregnskabet",0,"kr."]
[null,"Tillæg for budgetterede driftsomkostninger til klimatilpasningsprojekter i prisloft 2013",0,"kr."]
[null,"Korrektion af tillæg for budgetterede omkostninger til klimatilpasningsprojekter i 2013",{"$f":"C21-C22","v":0},"kr."]

{"sheet":"11. Nettofinansielle poster","index":10,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'10. Klimatilpasning'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 11. Nettofinansielle poster"]
[]
[null,"Tillæg for budgetterede nettofinansielle poster i 2015"]
[null,"Budgetterede renteudgifter og gebyrer i 2015",4000000,"kr."]
[null,"Budgetterede renteindtægter i 2015",1225000,"kr."]
[null,"Tillæg/fradrag i alt",{"$f":"C7-C8","v":2775000},"kr."]
[]
[]
[]
[null,"Korrektion af tillæg for faktiske nettofinansielle poster i 2013"]
[null,"Selskabets faktiske nettofinansielle poster i 2013, jf. reguleringsregnskabet",-1256838,"kr."]
[null,"Tillæg for budgetterede nettofinansielle poster i prisloft 2013",-3659000,"kr."]
[null,"Korrektion af tillæg for budgetterede nettofinansielle poster i 2013",{"$f":"C14-C15","v":2402162},"kr."]

{"sheet":"12. Over- eller underdækning","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[{"$f":"'11. Nettofinansielle poster'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 12. Over- eller underdækning til og med 2010"]
[]
[null,"Tillæg/fradrag for over- eller underdækning til og med 2010"]
[null,"Opgjort over- eller underdækning per 31. december 2010",-118441000,"kr."]
[null,"Heraf beløb indregnet i prislofterne for 2011 - 2014",-81373638,"kr."]
[null,"Endnu ikke indregnet over- eller underdækning",{"$f":"C7-C8","v":-37067362},"kr."]
[null,"Resterende indregningsperiode (fastsat i prisloftet for 2012)",2,"år"]
[null,"Tillæg/fradrag i alt",{"$f":"IF(C7=0,0,C9/C10)","v":-18533681},"kr."]

{"sheet":"13. Kontrol med indtægtsrammen","index":12,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,5],[30,1,30,4],[5,1,5,5]]}
[{"$f":"'12. Over- eller underdækning'!A1","v":"HOFOR Spildevand København A/S"}]
[]
[]
[null,"Fane 13. Korrektion for overholdelse af indtægtsrammen i prisloftet for 2013"]
[]
[null,"Samlet opgørelse vedrørende overholdelse af indtægtsrammen i prisloftet for 2013"]
[null,"Indtægtsramme i prisloftet for 2013",null,null,571196426.12970603,"kr."]
[null,"Ikke anvendt likviditet vedrørende investeringer i 2013"]
[null,"Tillæg for historiske investeringer ",116772658.56302749,"kr."]
[null,"Tillæg for gennemførte investeringer i 2011",6901531,"kr."]
[null,"Korrektion af tillæg for planlagte investeringer i 2011",103042,"kr."]
[null,"Tillæg for planlagte investeringer i 2012 og 2013",4492113,"kr."]
[null,"Indtægter fra tilslutningsbidrag",6731973,"kr."]
[null,"Indtægter fra salg af anlægsaktiver",0,"kr."]
[null,"Erstatninger vedr. anlægsaktiver mv.",0,"kr."]
[null,"Ekstraordinær effektiviseringsgevinst anvendt til investeringer",0,"kr."]
[null,"Udgifter til investeringer",-135001318,"kr."]
[null,"Ikke anvendt likviditet vedr. investeringer i alt",{"$f":"SUM(C9:C17)","v":-0.43697249889373779},"kr.",{"$f":"IF(C18<0,0,-C18)","v":0},"kr."]
[null,"Ekstraordinære effektiviseringsgevinster anvendt til takstnedsættelse"]
[null,"Ekstraordinær effektiviseringsgevinst anvendt til takstnedsættelse",0,"kr.",{"$f":"-C20","v":0},"kr."]
[null,"Korrektion af ikke opkrævet tillæg fra 2011 i prisloft 2013"]
[null,"Korrektion af ikke opkrævet tillæg fra 2011 i prisloft 2013",0,"kr.",{"$f":"-C22","v":0},"kr."]
[null,"Indtægter fra primære aktiviteter mv."]
[null,"Indtægter fra kubikmetertakster, faste takster, særbidrag, målergebyrer samt andre takster og gebyrer",583155805,"kr."]
[null,"Andre indtægter i prisloftåret, som selskabet har opnået i forbindelse med eller som følge af selskabets primære aktiviteter",0,"kr."]
[null,"Indtægter fra primære aktiviteter mv. i alt",{"$f":"SUM(C24:C25)","v":583155805},"kr.",{"$f":"-C26","v":-583155805},"kr."]
[null,"Tillæg/fradrag i prisloftet for 2015 i alt",null,null,{"$f":"E7+E18+E20+E22+E26","v":-11959378.870293975},"kr."]
[]
[]
[]
[null,"Oversigt over ekstraordinære effektiviseringsgevinster"]
[]
[null,null,2012,null,2013,null,2014,null,2015,null,2016]
[null,"Indhentet ekstraordinær effektiviseringsgevinst",38019010,"kr.",36954432,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Gevinst anvendt til investeringer",0,"kr.",0,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Gevinst anvendt til takstnedsættelse",0,"kr.",0,"kr.",null,"kr.",null,"kr.",null,"kr."]
[null,"Korrektion for  effektiviseringsgevinst der ikke er anvendt inden 4 år",0,"kr.",0,"kr.",null,"kr.",null,"kr.",{"$f":"IF(C38>SUM(E35:I36),C38-SUM(E35:I36),0)*-1","v":-38019010},"kr."]
[null,"Resterende gevinst",{"$f":"C34-C35-C36","v":38019010},"kr.",{"$f":"C38+E34-E35-E36","v":74973442},"kr.",{"$f":"E38+G34-G35-G36","v":74973442},"kr.",{"$f":"G38+I34-I35-I36","v":74973442},"kr.",{"$f":"I38+K34-K35-K36+K37","v":36954432},"kr."]

{"sheet":"14. EAA","index":13,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Fane 14. EAA-beregning for projekt Strandstræderne"]
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt. Oplysninger om forventet årlig effektiv rente"]
[null,"samt omkostninger til anlæg og drift skal indtastes i de orange celler. Det bemærkes, at omkostninger indgår som negative tal."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[]
[]
[null,"Rente",null,null,"Resultater"]
[]
[null,"Forventet årlig effektiv rente",0.04,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$24:$C$147)<0,($C$13*SUM($K$28:$K$147)/(1-(1+$C$13)^(-($C$22-$C$21+1)))),\"\")","v":-650275.79360276682}]
[null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($F$28:$G$147)<0,($C$13*SUM($L$28:$L$147)/(1-(1+$C$13)^(-($F$22-$F$21+1)))),\"\")","v":-181040.61954864534}]
[]
[null,null,null,null,"Konklusion",{"$f":"IF($F$13<0,IF($F$13<>$F$14,IF($F$13>$F$14,\"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,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2015,null,"Projektets startår",2015,null,null,null,null,null,{"$f":" IF($E21>=$F$21,IF($E21<=$F$22,SUM($F21:$G21),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2089,null,"Projektets slutår",2089,null,null,null,null,null,{"$f":" IF($E22>=$F$21,IF($E22<=$F$22,SUM($F22:$G22),\"\"),\"\")","v":""}]
[]
[null,"Samlede anlægsomkostninger",-15000000]
[]
[]
[null,"År","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Tilskud til driftsomkostninger betalt i år t",null,"Sædvanlig afhjælpning: Cash-flow for anlæg","Sædvanlig afhjælpning: Cash-flow for drift","Tilbagediskonteret cash-flow for sædvanlig afhjælpning","Tilbagediskonteret cash-flow for alternativt projekt"]
[null,2015,-10000,null,2015,-237149.80069435397,-10000,null,{"$f":" IF($B28=$C$21,$C$24,\"\")","v":-15000000},{"$f":" IF($B28>=$C$21,IF($B28<=$C$22,$C28,\"\"),\"\")","v":-10000},{"$f":" IF(SUM($I28:$J28)/((1+$C$13)^($B28-$C$21))<0,SUM($I28:$J28)/((1+$C$13)^($B28-$C$21)),\"\")","v":-15010000},{"$f":" IF($E28>=$F$21,IF($E28<=$F$22,IF(SUM($F28:$G28)/((1+$C$13)^($E28-$F$21))<0,SUM($F28:$G28)/((1+$C$13)^($E28-$F$21)),\"\"),\"\"),\"\")","v":-247149.80069435397}]
[null,2016,-10200,null,2016,-237149.80069435397,-10200,null,{"$f":" IF($B29=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B29>=$C$21,IF($B29<=$C$22,$C29,\"\"),\"\")","v":-10200},{"$f":" IF(SUM($I29:$J29)/((1+$C$13)^($B29-$C$21))<0,SUM($I29:$J29)/((1+$C$13)^($B29-$C$21)),\"\")","v":-9807.6923076923067},{"$f":" IF($E29>=$F$21,IF($E29<=$F$22,IF(SUM($F29:$G29)/((1+$C$13)^($E29-$F$21))<0,SUM($F29:$G29)/((1+$C$13)^($E29-$F$21)),\"\"),\"\"),\"\")","v":-237836.3468214942}]
[null,{"$f":"B29+1","v":2017},-10404,null,{"$f":"E29+1","v":2017},-237149.80069435397,-10404,null,"",-10404,-9619.082840236686,-228877.40448812308]
[null,{"$f":"B30+1","v":2018},-10612.08,null,{"$f":"E30+1","v":2018},-237149.80069435397,-10612.08,null,"",-10612.08,-9434.1004779244413,-220259.4097547383]
[null,2019,-10824.321599999999,null,2019,-237149.80069435397,-10824.321599999999,null,"",-10824.321599999999,-9252.6754687335851,-211969.31900413151]
[null,2020,-11040.808031999999,null,2020,-237149.80069435397,-11040.808031999999,null,"",-11040.808031999999,-9074.7394020271695,-203994.58895529437]
[null,2021,-11261.62419264,null,2021,-237149.80069435397,-11261.62419264,null,"",-11261.62419264,-8900.2251827574164,-196323.15744551437]
[null,2022,-11486.8566764928,null,2022,-237149.80069435397,-11486.8566764928,null,"",-11486.8566764928,-8729.0670061659293,-188943.42495112456]
[null,2023,-11716.593810022656,null,2023,-237149.80069435397,-11716.593810022656,null,"",-11716.593810022656,-8561.2003329704294,-181844.23681850752]
[null,2024,-11950.925686223109,null,2024,-237149.80069435397,-23901.851372446217,null,"",-11950.925686223109,-8396.5618650286888,-183411.4280430738]
[null,2025,-12189.944199947571,null,2025,-237149.80069435397,-12189.944199947571,null,"",-12189.944199947571,-8235.0895214704451,-168444.99751475547]
[null,2026,-12433.743083946523,null,2026,-237149.80069435397,-12433.743083946523,null,"",-12433.743083946523,-8076.7224152883218,-162124.71087037009]
[null,2027,-12682.417945625453,null,2027,-237149.80069435397,-12682.417945625453,null,"",-12682.417945625453,-7921.4008303789287,-156044.46665257291]
[null,2028,-12936.066304537962,null,2028,-237149.80069435397,-12936.066304537962,null,"",-12936.066304537962,-7769.0661990254885,-150195.09102805814]
[null,2029,-13194.787630628722,null,2029,-237149.80069435397,-13194.787630628722,null,"",-13194.787630628722,-7619.6610798134598,-144567.76187696026]
[null,2030,-13458.683383241296,null,2030,-237149.80069435397,-13458.683383241296,null,"",-13458.683383241296,-7473.129135970893,-139153.99528707357]
[null,2031,-13727.857050906123,null,2031,-237149.80069435397,-13727.857050906123,null,"",-13727.857050906123,-7329.4151141252987,-133945.63256710861]
[null,2032,-14002.414191924245,null,2032,-237149.80069435397,-14002.414191924245,null,"",-14002.414191924245,-7188.4648234690421,-128934.82775902993]
[null,2033,-14282.46247576273,null,2033,-237149.80069435397,-14282.46247576273,null,"",-14282.46247576273,-7050.2251153254056,-124114.03563028779]
[null,2034,-14568.111725277984,null,2034,-237149.80069435397,-29136.223450555968,null,"",-14568.111725277984,-6914.6438631076098,-126390.64399060213]
[null,2035,-14859.473959783543,null,2035,-237149.80069435397,-14859.473959783543,null,"",-14859.473959783543,-6781.6699426632322,-115013.74327380449]
[null,2036,-15156.663438979214,null,2036,-237149.80069435397,-15156.663438979214,null,"",-15156.663438979214,-6651.2532129966303,-110720.55449294012]
[null,2037,-15459.796707758798,null,2037,-237149.80069435397,-15459.796707758798,null,"",-15459.796707758798,-6523.3444973620799,-106589.98034346159]
[null,2038,-15768.992641913974,null,2038,-237149.80069435397,-15768.992641913974,null,"",-15768.992641913974,-6397.8955647205021,-102615.81464750851]
[null,2039,-16084.372494752253,null,2039,-237149.80069435397,-16084.372494752253,null,"",-16084.372494752253,-6274.8591115527988,-98792.088998848951]
[null,2040,-16406.059944647299,null,2040,null,-16406.059944647299,null,"",-16406.059944647299,-6154.1887440229366,-6154.1887440229366]
[null,2041,-16734.181143540245,null,2041,null,-16734.181143540245,null,"",-16734.181143540245,-6035.8389604840349,-6035.8389604840349]
[null,2042,-17068.86476641105,null,2042,null,-17068.86476641105,null,"",-17068.86476641105,-5919.76513432088,-5919.76513432088]
[null,2043,-17410.242061739271,null,2043,null,-17410.242061739271,null,"",-17410.242061739271,-5805.9234971224005,-5805.9234971224005]
[null,2044,-17758.446902974058,null,2044,null,-35516.893805948115,null,"",-17758.446902974058,-5694.271122177739,-11388.542244355478]
[null,2045,-18113.615841033537,null,2045,null,-18113.615841033537,null,"",-18113.615841033537,-5584.7659082897062,-5584.7659082897062]
[null,2046,-18475.88815785421,null,2046,null,-18475.88815785421,null,"",-18475.88815785421,-5477.366563899519,-5477.366563899519]
[null,2047,-18845.405921011294,null,2047,null,-18845.405921011294,null,"",-18845.405921011294,-5372.032591516836,-5372.032591516836]
[null,2048,-19222.31403943152,null,2048,null,-19222.31403943152,null,"",-19222.31403943152,-5268.7242724492044,-5268.7242724492044]
[null,2049,-19606.76032022015,null,2049,null,-19606.76032022015,null,"",-19606.76032022015,-5167.4026518251803,-5167.4026518251803]
[null,2050,-19998.895526624554,null,2050,null,-19998.895526624554,null,"",-19998.895526624554,-5068.0295239054658,-5068.0295239054658]
[null,2051,-20398.873437157046,null,2051,null,-20398.873437157046,null,"",-20398.873437157046,-4970.5674176765151,-4970.5674176765151]
[null,2052,-20806.850905900188,null,2052,null,-20806.850905900188,null,"",-20806.850905900188,-4874.9795827211965,-4874.9795827211965]
[null,2053,-21222.987924018191,null,2053,null,-21222.987924018191,null,"",-21222.987924018191,-4781.2299753611742,-4781.2299753611742]
[null,2054,-21647.447682498554,null,2054,null,-43294.895364997108,null,"",-21647.447682498554,-4689.283245065767,-9378.566490131534]
[null,2055,-22080.396636148525,null,2055,null,-22080.396636148525,null,"",-22080.396636148525,-4599.104721122193,-4599.104721122193]
[null,2056,-22522.004568871496,null,2056,null,-22522.004568871496,null,"",-22522.004568871496,-4510.6603995621508,-4510.6603995621508]
[null,2057,-22972.444660248926,null,2057,null,-22972.444660248926,null,"",-22972.444660248926,-4423.9169303398021,-4423.9169303398021]
[null,2058,-23431.893553453905,null,2058,null,-23431.893553453905,null,"",-23431.893553453905,-4338.8416047563442,-4338.8416047563442]
[null,2059,-23900.531424522982,null,2059,null,-23900.531424522982,null,"",-23900.531424522982,-4255.4023431264141,-4255.4023431264141]
[null,2060,-24378.542053013443,null,2060,null,-24378.542053013443,null,"",-24378.542053013443,-4173.5676826816753,-4173.5676826816753]
[null,2061,-24866.112894073714,null,2061,null,-24866.112894073714,null,"",-24866.112894073714,-4093.3067657070278,-4093.3067657070278]
[null,2062,-25363.435151955189,null,2062,null,-25363.435151955189,null,"",-25363.435151955189,-4014.5893279049697,-4014.5893279049697]
[null,2063,-25870.703854994292,null,2063,null,-25870.703854994292,null,"",-25870.703854994292,-3937.3856869837196,-3937.3856869837196]
[null,2064,-26388.117932094177,null,2064,null,-52776.235864188355,null,"",-26388.117932094177,-3861.6667314648016,-7723.3334629296032]
[null,2065,-26915.880290736062,null,2065,null,-26915.880290736062,null,"",-26915.880290736062,-3787.403909705863,-3787.403909705863]
[null,2066,-27454.197896550784,null,2066,null,-27454.197896550784,null,"",-27454.197896550784,-3714.5692191345966,-3714.5692191345966]
[null,2067,-28003.2818544818,null,2067,null,-28003.2818544818,null,"",-28003.2818544818,-3643.1351956897006,-3643.1351956897006]
[null,2068,-28563.347491571436,null,2068,null,-28563.347491571436,null,"",-28563.347491571436,-3573.0749034648979,-3573.0749034648979]
[null,2069,-29134.614441402864,null,2069,null,-29134.614441402864,null,"",-29134.614441402864,-3504.3619245521113,-3504.3619245521113]
[null,2070,-29717.306730230921,null,2070,null,-29717.306730230921,null,"",-29717.306730230921,-3436.9703490799557,-3436.9703490799557]
[null,2071,-30311.652864835542,null,2071,null,-30311.652864835542,null,"",-30311.652864835542,-3370.8747654438025,-3370.8747654438025]
[null,2072,-30917.885922132253,null,2072,null,-30917.885922132253,null,"",-30917.885922132253,-3306.0502507237284,-3306.0502507237284]
[null,2073,-31536.243640574899,null,2073,null,-31536.243640574899,null,"",-31536.243640574899,-3242.4723612867347,-3242.4723612867347]
[null,2074,-32166.968513386397,null,2074,null,-64333.937026772794,null,"",-32166.968513386397,-3180.117123569682,-6360.234247139364]
[null,2075,-32810.307883654124,null,2075,null,-32810.307883654124,null,"",-32810.307883654124,-3118.9610250394949,-3118.9610250394949]
[null,2076,-33466.514041327209,null,2076,null,-33466.514041327209,null,"",-33466.514041327209,-3058.9810053271967,-3058.9810053271967]
[null,2077,-34135.844322153753,null,2077,null,-34135.844322153753,null,"",-34135.844322153753,-3000.1544475324436,-3000.1544475324436]
[null,2078,-34818.561208596831,null,2078,null,-34818.561208596831,null,"",-34818.561208596831,-2942.4591696952816,-2942.4591696952816]
[null,2079,-35514.932432768772,null,2079,null,-35514.932432768772,null,"",-35514.932432768772,-2885.8734164319108,-2885.8734164319108]
[null,2080,-36225.23108142415,null,2080,null,-36225.23108142415,null,{"$f":" IF($B93=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B93>=$C$21,IF($B93<=$C$22,$C93,\"\"),\"\")","v":-36225.23108142415},{"$f":" IF(SUM($I93:$J93)/((1+$C$13)^($B93-$C$21))<0,SUM($I93:$J93)/((1+$C$13)^($B93-$C$21)),\"\")","v":-2830.3758507312969},{"$f":" IF($E93>=$F$21,IF($E93<=$F$22,IF(SUM($F93:$G93)/((1+$C$13)^($E93-$F$21))<0,SUM($F93:$G93)/((1+$C$13)^($E93-$F$21)),\"\"),\"\"),\"\")","v":-2830.3758507312969}]
[null,2081,-36949.735703052633,null,2081,null,-36949.735703052633,null,"",-36949.735703052633,-2775.9455459095411,-2775.9455459095411]
[null,{"$f":"B94+1","v":2082},-37688.730417113686,null,{"$f":"E94+1","v":2082},null,-37688.730417113686,null,"",-37688.730417113686,-2722.5619777189731,-2722.5619777189731]
[null,{"$f":"B95+1","v":2083},-38442.505025455961,null,{"$f":"E95+1","v":2083},null,-38442.505025455961,null,"",-38442.505025455961,-2670.2050166089925,-2670.2050166089925]
[null,{"$f":"B96+1","v":2084},-39211.355125965078,null,{"$f":"E96+1","v":2084},null,-78422.710251930155,null,"",-39211.355125965078,-2618.8549201357423,-5237.7098402714846]
[null,{"$f":"B97+1","v":2085},-39995.582228484382,null,{"$f":"E97+1","v":2085},null,-39995.582228484382,null,"",-39995.582228484382,-2568.4923255177473,-2568.4923255177473]
[null,2086,-40795.493873054067,null,2086,null,-40795.493873054067,null,"",-40795.493873054067,-2519.0982423347141,-2519.0982423347141]
[null,2087,-41611.40375051515,null,2087,null,-41611.40375051515,null,"",-41611.40375051515,-2470.6540453667385,-2470.6540453667385]
[null,2088,-42443.631825525452,null,2088,null,-42443.631825525452,null,"",-42443.631825525452,-2423.141467571224,-2423.141467571224]
[null,2089,-43292.504462035962,null,2089,null,-43292.504462035962,null,"",-43292.504462035962,-2376.5425931948544,-2376.5425931948544]
[null,2090,null,null,2090,null,null,null,"","","",""]
[null,2091,null,null,2091,null,null,null,"","","",""]
[null,2092,null,null,2092,null,null,null,"","","",""]
[null,2093,null,null,2093,null,null,null,"","","",""]
[null,2094,null,null,2094,null,null,null,"","","",""]
[null,{"$f":"B107+1","v":2095},null,null,{"$f":"E107+1","v":2095},null,null,null,"","","",""]
[null,{"$f":"B108+1","v":2096},null,null,{"$f":"E108+1","v":2096},null,null,null,"","","",""]
[null,2097,null,null,2097,null,null,null,"","","",""]
[null,2098,null,null,2098,null,null,null,"","","",""]
[null,2099,null,null,2099,null,null,null,"","","",""]
[null,2100,null,null,2100,null,null,null,"","","",""]
[null,2101,null,null,2101,null,null,null,"","","",""]
[null,2102,null,null,2102,null,null,null,"","","",""]
[null,2103,null,null,2103,null,null,null,"","","",""]
[null,2104,null,null,2104,null,null,null,"","","",""]
[null,2105,null,null,2105,null,null,null,"","","",""]
[null,2106,null,null,2106,null,null,null,"","","",""]
[null,2107,null,null,2107,null,null,null,"","","",""]
[null,2108,null,null,2108,null,null,null,"","","",""]
[null,2109,null,null,2109,null,null,null,"","","",""]
[null,2110,null,null,2110,null,null,null,"","","",""]
[null,2111,null,null,2111,null,null,null,"","","",""]
[null,2112,null,null,2112,null,null,null,"","","",""]
[null,2113,null,null,2113,null,null,null,"","","",""]
[null,2114,null,null,2114,null,null,null,"","","",""]
[null,2115,null,null,2115,null,null,null,"","","",""]
[null,2116,null,null,2116,null,null,null,"","","",""]
[null,2117,null,null,2117,null,null,null,"","","",""]
[null,2118,null,null,2118,null,null,null,"","","",""]
[null,2119,null,null,2119,null,null,null,"","","",""]
[null,2120,null,null,2120,null,null,null,"","","",""]
[null,2121,null,null,2121,null,null,null,"","","",""]
[null,2122,null,null,2122,null,null,null,"","","",""]
[null,2123,null,null,2123,null,null,null,"","","",""]
[null,2124,null,null,2124,null,null,null,"","","",""]
[null,2125,null,null,2125,null,null,null,"","","",""]
[null,2126,null,null,2126,null,null,null,"","","",""]
[null,2127,null,null,2127,null,null,null,"","","",""]
[null,2128,null,null,2128,null,null,null,"","","",""]
[null,2129,null,null,2129,null,null,null,"","","",""]
[null,2130,null,null,2130,null,null,null,"","","",""]
[null,2131,null,null,2131,null,null,null,"","","",""]
[null,2132,null,null,2132,null,null,null,"","","",""]
[null,2133,null,null,2133,null,null,null,"","","",""]
[null,2134,null,null,2134,null,null,null,"","","",""]

{"sheet":"15. EAA","index":14,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Fane 15. EAA-beregning for projekt Enghave Park"]
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt. Oplysninger om forventet årlig effektiv rente"]
[null,"samt omkostninger til anlæg og drift skal indtastes i de orange celler. Det bemærkes, at omkostninger indgår som negative tal."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[]
[]
[null,"Rente",null,null,"Resultater"]
[]
[null,"Forventet årlig effektiv rente",0.04,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$24:$C$147)<0,($C$13*SUM($K$28:$K$147)/(1-(1+$C$13)^(-($C$22-$C$21+1)))),\"\")","v":-10129877.378184294}]
[null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($F$28:$G$147)<0,($C$13*SUM($L$28:$L$147)/(1-(1+$C$13)^(-($F$22-$F$21+1)))),\"\")","v":-1728330.5524656577}]
[]
[null,null,null,null,"Konklusion",{"$f":"IF($F$13<0,IF($F$13<>$F$14,IF($F$13>$F$14,\"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,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2015,null,"Projektets startår",2015,null,null,null,null,null,{"$f":" IF($E21>=$F$21,IF($E21<=$F$22,SUM($F21:$G21),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2089,null,"Projektets slutår",2064,null,null,null,null,null,{"$f":" IF($E22>=$F$21,IF($E22<=$F$22,SUM($F22:$G22),\"\"),\"\")","v":""}]
[]
[null,"Samlede anlægsomkostninger",-200000000]
[]
[]
[null,"År","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Tilskud til driftsomkostninger betalt i år t",null,"Sædvanlig afhjælpning: Cash-flow for anlæg","Sædvanlig afhjælpning: Cash-flow for drift","Tilbagediskonteret cash-flow for sædvanlig afhjælpning","Tilbagediskonteret cash-flow for alternativt projekt"]
[null,2015,-1000000,null,2015,-2166707.0073000817,-50000,null,{"$f":" IF($B28=$C$21,$C$24,\"\")","v":-200000000},{"$f":" IF($B28>=$C$21,IF($B28<=$C$22,$C28,\"\"),\"\")","v":-1000000},{"$f":" IF(SUM($I28:$J28)/((1+$C$13)^($B28-$C$21))<0,SUM($I28:$J28)/((1+$C$13)^($B28-$C$21)),\"\")","v":-201000000},{"$f":" IF($E28>=$F$21,IF($E28<=$F$22,IF(SUM($F28:$G28)/((1+$C$13)^($E28-$F$21))<0,SUM($F28:$G28)/((1+$C$13)^($E28-$F$21)),\"\"),\"\"),\"\")","v":-2216707.0073000817}]
[null,2016,-1020000,null,2016,-2166707.0073000817,-51000,null,{"$f":" IF($B29=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B29>=$C$21,IF($B29<=$C$22,$C29,\"\"),\"\")","v":-1020000},{"$f":" IF(SUM($I29:$J29)/((1+$C$13)^($B29-$C$21))<0,SUM($I29:$J29)/((1+$C$13)^($B29-$C$21)),\"\")","v":-980769.23076923075},{"$f":" IF($E29>=$F$21,IF($E29<=$F$22,IF(SUM($F29:$G29)/((1+$C$13)^($E29-$F$21))<0,SUM($F29:$G29)/((1+$C$13)^($E29-$F$21)),\"\"),\"\"),\"\")","v":-2132410.5839423863}]
[null,{"$f":"B29+1","v":2017},-1040400,null,{"$f":"E29+1","v":2017},-2166707.0073000817,-52020,null,"",-1040400,-961908.2840236685,-2051337.8395895723]
[null,{"$f":"B30+1","v":2018},-1061208,null,{"$f":"E30+1","v":2018},-2166707.0073000817,-53060.4,null,"",-1061208,-943410.04779244412,-1973365.14218615]
[null,2019,-1082432.1599999999,null,2019,-2166707.0073000817,-108243.216,null,"",-1082432.1599999999,-925267.54687335854,-1944636.9852609201]
[null,2020,-1104080.8032,null,2020,-2166707.0073000817,-55204.040160000004,null,"",-1104080.8032,-907473.94020271697,-1826248.9187155049]
[null,2021,-1126162.4192639999,null,2021,-2166707.0073000817,-56308.120963200003,null,"",-1126162.4192639999,-890022.5182757416,-1756881.1467843344]
[null,2022,-1148685.6676492798,null,2022,-2166707.0073000817,-57434.283382464004,null,"",-1148685.6676492798,-872906.70061659277,-1690164.5858678948]
[null,2023,-1171659.3810022655,null,2023,-2166707.0073000817,-58582.969050113286,null,"",-1171659.3810022655,-856120.03329704283,-1625997.5890081835]
[null,2024,-1195092.5686223109,null,2024,-2166707.0073000817,-119509.25686223111,null,"",-1195092.5686223109,-839656.18650286889,-1606265.2218650286]
[null,2025,-1218994.419994757,null,2025,-2166707.0073000817,-60949.720999737867,null,"",-1218994.419994757,-823508.95214704447,-1504925.0660830652]
[null,2026,-1243374.3083946521,null,2026,-2166707.0073000817,-62168.715419732624,null,"",-1243374.3083946521,-807672.241528832,-1447835.1683030888]
[null,2027,-1268241.7945625451,null,2027,-2166707.0073000817,-63412.089728127277,null,"",-1268241.7945625451,-792140.08303789282,-1392925.8082159783]
[null,2028,-1293606.6304537961,null,2028,-2166707.0073000817,-64680.331522689827,null,"",-1293606.6304537961,-776906.61990254873,-1340113.411825977]
[null,2029,-1319478.763062872,null,2029,-2166707.0073000817,-131947.87630628725,null,"",-1319478.763062872,-761966.10798134585,-1327415.9192893361]
[null,2030,-1345868.3383241293,null,2030,-2166707.0073000817,-67293.416916206494,null,"",-1345868.3383241293,-747312.91359708912,-1240461.1346137021]
[null,2031,-1372785.7050906119,null,2031,-2166707.0073000817,-68639.285254530623,null,"",-1372785.7050906119,-732941.51141252962,-1193469.6610839413]
[null,2032,-1400241.4191924243,null,2032,-2166707.0073000817,-70012.07095962124,null,"",-1400241.4191924243,-718846.48234690411,-1148271.7332647634]
[null,2033,-1428246.2475762728,null,2033,-2166707.0073000817,-71412.312378813673,null,"",-1428246.2475762728,-705022.51153254055,-1104798.6343722213]
[null,2034,-1456811.1725277982,null,2034,-2166707.0073000817,-145681.11725277989,null,"",-1456811.1725277982,-691464.38631076086,-1097557.5047806862]
[null,2035,-1485947.3959783542,null,2035,-2166707.0073000817,-74297.369798917745,null,"",-1485947.3959783542,-678166.99426632316,-1022765.144087941]
[null,2036,-1515666.3438979213,null,2036,-2166707.0073000817,-75783.317194896095,null,"",-1515666.3438979213,-665125.32129966293,-984080.10680981469]
[null,2037,-1545979.6707758796,null,2037,-2166707.0073000817,-77298.983538794026,null,"",-1545979.6707758796,-652334.44973620784,-946870.4155106867]
[null,2038,-1576899.2641913972,null,2038,-2166707.0073000817,-78844.963209569905,null,"",-1576899.2641913972,-639789.55647205014,-911079.5672696376]
[null,2039,-1608437.2494752251,null,2039,-2166707.0073000817,-160843.7249475226,null,"",-1608437.2494752251,-627485.91115527984,-908027.52327517699]
[null,2040,-1640605.9944647297,null,2040,null,-82030.299723236531,null,"",-1640605.9944647297,-615418.87440229359,-30770.943720114697]
[null,2041,-1673418.1143540244,null,2041,null,-83670.905717701258,null,"",-1673418.1143540244,-603583.89604840346,-30179.194802420185]
[null,2042,-1706886.476641105,null,2042,null,-85344.323832055292,null,"",-1706886.476641105,-591976.51343208796,-29598.825671604416]
[null,2043,-1741024.2061739271,null,2043,null,-87051.210308696405,null,"",-1741024.2061739271,-580592.34971224004,-29029.61748561202]
[null,2044,-1775844.6902974057,null,2044,null,-177584.46902974066,null,"",-1775844.6902974057,-569427.11221777392,-56942.711221777419]
[null,2045,-1811361.5841033538,null,2045,null,-90568.079205167742,null,"",-1811361.5841033538,-558476.59082897054,-27923.829541448547]
[null,2046,-1847588.8157854208,null,2046,null,-92379.440789271102,null,"",-1847588.8157854208,-547736.65638995194,-27386.832819497613]
[null,2047,-1884540.5921011292,null,2047,null,-94227.029605056523,null,"",-1884540.5921011292,-537203.25915168354,-26860.162957584194]
[null,2048,-1922231.4039431519,null,2048,null,-96111.570197157649,null,"",-1922231.4039431519,-526872.4272449204,-26343.621362246035]
[null,2049,-1960676.032022015,null,2049,null,-196067.6032022016,null,"",-1960676.032022015,-516740.26518251805,-51674.026518251834]
[null,2050,-1999889.5526624552,null,2050,null,-99994.47763312282,null,"",-1999889.5526624552,-506802.95239054656,-25340.147619527343]
[null,2051,-2039887.3437157043,null,2051,null,-101994.36718578528,null,"",-2039887.3437157043,-497056.7417676514,-24852.837088382585]
[null,2052,-2080685.0905900183,null,2052,null,-104034.25452950098,null,"",-2080685.0905900183,-487497.95827211952,-24374.89791360599]
[null,2053,-2122298.7924018186,null,2053,null,-106114.939620091,null,"",-2122298.7924018186,-478122.99753611727,-23906.149876805877]
[null,2054,-2164744.7682498549,null,2054,null,-216474.47682498564,null,"",-2164744.7682498549,-468928.32450657658,-46892.83245065769]
[null,2055,-2208039.6636148519,null,2055,null,-110401.98318074268,null,"",-2208039.6636148519,-459910.47211221914,-22995.523605610975]
[null,2056,-2252200.4568871488,null,2056,null,-112610.02284435753,null,"",-2252200.4568871488,-451066.0399562149,-22553.301997810766]
[null,2057,-2297244.4660248919,null,2057,null,-114862.22330124468,null,"",-2297244.4660248919,-442391.69303398009,-22119.58465169902]
[null,2058,-2343189.3553453898,null,2058,null,-117159.46776726958,null,"",-2343189.3553453898,-433884.16047563427,-21694.208023781732]
[null,2059,-2390053.1424522977,null,2059,null,-239005.31424522997,null,"",-2390053.1424522977,-425540.23431264126,-42554.023431264162]
[null,2060,-2437854.2053013439,null,2060,null,-121892.71026506729,null,"",-2437854.2053013439,-417356.76826816745,-20867.83841340839]
[null,2061,-2486611.2894073711,null,2061,null,-124330.56447036864,null,"",-2486611.2894073711,-409330.67657070275,-20466.53382853515]
[null,2062,-2536343.5151955187,null,2062,null,-126817.17575977602,null,"",-2536343.5151955187,-401458.93279049697,-20072.94663952486]
[null,2063,-2587070.385499429,null,2063,null,-129353.51927497154,null,"",-2587070.385499429,-393738.56869837194,-19686.928434918609]
[null,2064,-2638811.7932094177,null,2064,null,-263881.17932094191,null,"",-2638811.7932094177,-386166.67314648017,-38616.667314648039]
[null,2065,-2691588.0290736062,null,2065,null,null,null,"",-2691588.0290736062,-378740.39097058633,""]
[null,2066,-2745419.7896550782,null,2066,null,null,null,"",-2745419.7896550782,-371456.92191345961,""]
[null,2067,-2800328.18544818,null,2067,null,null,null,"",-2800328.18544818,-364313.51956897002,""]
[null,2068,-2856334.7491571438,null,2068,null,null,null,"",-2856334.7491571438,-357307.49034648982,""]
[null,2069,-2913461.4441402867,null,2069,null,null,null,"",-2913461.4441402867,-350436.19245521113,""]
[null,2070,-2971730.6730230926,null,2070,null,null,null,"",-2971730.6730230926,-343697.03490799561,""]
[null,2071,-3031165.2864835546,null,2071,null,null,null,"",-3031165.2864835546,-337087.4765443803,""]
[null,2072,-3091788.5922132256,null,2072,null,null,null,"",-3091788.5922132256,-330605.02507237287,""]
[null,2073,-3153624.3640574901,null,2073,null,null,null,"",-3153624.3640574901,-324247.23612867348,""]
[null,2074,-3216696.8513386399,null,2074,null,null,null,"",-3216696.8513386399,-318011.7123569682,""]
[null,2075,-3281030.7883654125,null,2075,null,null,null,"",-3281030.7883654125,-311896.10250394949,""]
[null,2076,-3346651.404132721,null,2076,null,null,null,"",-3346651.404132721,-305898.10053271969,""]
[null,2077,-3413584.4322153754,null,2077,null,null,null,"",-3413584.4322153754,-300015.44475324434,""]
[null,2078,-3481856.120859683,null,2078,null,null,null,"",-3481856.120859683,-294245.91696952813,""]
[null,2079,-3551493.2432768769,null,2079,null,null,null,"",-3551493.2432768769,-288587.34164319106,""]
[null,2080,-3622523.1081424146,null,2080,null,null,null,{"$f":" IF($B93=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B93>=$C$21,IF($B93<=$C$22,$C93,\"\"),\"\")","v":-3622523.1081424146},{"$f":" IF(SUM($I93:$J93)/((1+$C$13)^($B93-$C$21))<0,SUM($I93:$J93)/((1+$C$13)^($B93-$C$21)),\"\")","v":-283037.58507312968},{"$f":" IF($E93>=$F$21,IF($E93<=$F$22,IF(SUM($F93:$G93)/((1+$C$13)^($E93-$F$21))<0,SUM($F93:$G93)/((1+$C$13)^($E93-$F$21)),\"\"),\"\"),\"\")","v":""}]
[null,2081,-3694973.5703052632,null,2081,null,null,null,"",-3694973.5703052632,-277594.5545909541,""]
[null,{"$f":"B94+1","v":2082},-3768873.0417113686,null,{"$f":"E94+1","v":2082},null,null,null,"",-3768873.0417113686,-272256.19777189731,""]
[null,{"$f":"B95+1","v":2083},-3844250.5025455961,null,{"$f":"E95+1","v":2083},null,null,null,"",-3844250.5025455961,-267020.50166089926,""]
[null,{"$f":"B96+1","v":2084},-3921135.512596508,null,{"$f":"E96+1","v":2084},null,null,null,"",-3921135.512596508,-261885.49201357426,""]
[null,{"$f":"B97+1","v":2085},-3999558.2228484382,null,{"$f":"E97+1","v":2085},null,null,null,"",-3999558.2228484382,-256849.23255177474,""]
[null,2086,-4079549.3873054069,null,2086,null,null,null,"",-4079549.3873054069,-251909.82423347142,""]
[null,2087,-4161140.3750515152,null,2087,null,null,null,"",-4161140.3750515152,-247065.40453667386,""]
[null,2088,-4244363.1825525453,null,2088,null,null,null,"",-4244363.1825525453,-242314.14675712242,""]
[null,2089,-4329250.446203596,null,2089,null,null,null,"",-4329250.446203596,-237654.2593194854,""]
[null,2090,null,null,2090,null,null,null,"","","",""]
[null,2091,null,null,2091,null,null,null,"","","",""]
[null,2092,null,null,2092,null,null,null,"","","",""]
[null,2093,null,null,2093,null,null,null,"","","",""]
[null,2094,null,null,2094,null,null,null,"","","",""]
[null,{"$f":"B107+1","v":2095},null,null,{"$f":"E107+1","v":2095},null,null,null,"","","",""]
[null,{"$f":"B108+1","v":2096},null,null,{"$f":"E108+1","v":2096},null,null,null,"","","",""]
[null,2097,null,null,2097,null,null,null,"","","",""]
[null,2098,null,null,2098,null,null,null,"","","",""]
[null,2099,null,null,2099,null,null,null,"","","",""]
[null,2100,null,null,2100,null,null,null,"","","",""]
[null,2101,null,null,2101,null,null,null,"","","",""]
[null,2102,null,null,2102,null,null,null,"","","",""]
[null,2103,null,null,2103,null,null,null,"","","",""]
[null,2104,null,null,2104,null,null,null,"","","",""]
[null,2105,null,null,2105,null,null,null,"","","",""]
[null,2106,null,null,2106,null,null,null,"","","",""]
[null,2107,null,null,2107,null,null,null,"","","",""]
[null,2108,null,null,2108,null,null,null,"","","",""]
[null,2109,null,null,2109,null,null,null,"","","",""]
[null,2110,null,null,2110,null,null,null,"","","",""]
[null,2111,null,null,2111,null,null,null,"","","",""]
[null,2112,null,null,2112,null,null,null,"","","",""]
[null,2113,null,null,2113,null,null,null,"","","",""]
[null,2114,null,null,2114,null,null,null,"","","",""]
[null,2115,null,null,2115,null,null,null,"","","",""]
[null,2116,null,null,2116,null,null,null,"","","",""]
[null,2117,null,null,2117,null,null,null,"","","",""]
[null,2118,null,null,2118,null,null,null,"","","",""]
[null,2119,null,null,2119,null,null,null,"","","",""]
[null,2120,null,null,2120,null,null,null,"","","",""]
[null,2121,null,null,2121,null,null,null,"","","",""]
[null,2122,null,null,2122,null,null,null,"","","",""]
[null,2123,null,null,2123,null,null,null,"","","",""]
[null,2124,null,null,2124,null,null,null,"","","",""]
[null,2125,null,null,2125,null,null,null,"","","",""]
[null,2126,null,null,2126,null,null,null,"","","",""]
[null,2127,null,null,2127,null,null,null,"","","",""]
[null,2128,null,null,2128,null,null,null,"","","",""]
[null,2129,null,null,2129,null,null,null,"","","",""]
[null,2130,null,null,2130,null,null,null,"","","",""]
[null,2131,null,null,2131,null,null,null,"","","",""]
[null,2132,null,null,2132,null,null,null,"","","",""]
[null,2133,null,null,2133,null,null,null,"","","",""]
[null,2134,null,null,2134,null,null,null,"","","",""]

{"sheet":"16. EAA","index":15,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Fane 16. EAA-beregning for projekt Skt. Kjelds Projektet"]
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt. Oplysninger om forventet årlig effektiv rente"]
[null,"samt omkostninger til anlæg og drift skal indtastes i de orange celler. Det bemærkes, at omkostninger indgår som negative tal."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[]
[]
[null,"Rente",null,null,"Resultater"]
[]
[null,"Forventet årlig effektiv rente",0.04,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$24:$C$147)<0,($C$13*SUM($K$28:$K$147)/(1-(1+$C$13)^(-($C$22-$C$21+1)))),\"\")","v":-650275.79360276682}]
[null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($F$28:$G$147)<0,($C$13*SUM($L$28:$L$147)/(1-(1+$C$13)^(-($F$22-$F$21+1)))),\"\")","v":-181040.61954864534}]
[]
[null,null,null,null,"Konklusion",{"$f":"IF($F$13<0,IF($F$13<>$F$14,IF($F$13>$F$14,\"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,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2015,null,"Projektets startår",2015,null,null,null,null,null,{"$f":" IF($E21>=$F$21,IF($E21<=$F$22,SUM($F21:$G21),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2089,null,"Projektets slutår",2089,null,null,null,null,null,{"$f":" IF($E22>=$F$21,IF($E22<=$F$22,SUM($F22:$G22),\"\"),\"\")","v":""}]
[]
[null,"Samlede anlægsomkostninger",-15000000]
[]
[]
[null,"År","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Tilskud til driftsomkostninger betalt i år t",null,"Sædvanlig afhjælpning: Cash-flow for anlæg","Sædvanlig afhjælpning: Cash-flow for drift","Tilbagediskonteret cash-flow for sædvanlig afhjælpning","Tilbagediskonteret cash-flow for alternativt projekt"]
[null,2015,-10000,null,2015,-237149.80069435397,-10000,null,{"$f":" IF($B28=$C$21,$C$24,\"\")","v":-15000000},{"$f":" IF($B28>=$C$21,IF($B28<=$C$22,$C28,\"\"),\"\")","v":-10000},{"$f":" IF(SUM($I28:$J28)/((1+$C$13)^($B28-$C$21))<0,SUM($I28:$J28)/((1+$C$13)^($B28-$C$21)),\"\")","v":-15010000},{"$f":" IF($E28>=$F$21,IF($E28<=$F$22,IF(SUM($F28:$G28)/((1+$C$13)^($E28-$F$21))<0,SUM($F28:$G28)/((1+$C$13)^($E28-$F$21)),\"\"),\"\"),\"\")","v":-247149.80069435397}]
[null,2016,-10200,null,2016,-237149.80069435397,-10200,null,{"$f":" IF($B29=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B29>=$C$21,IF($B29<=$C$22,$C29,\"\"),\"\")","v":-10200},{"$f":" IF(SUM($I29:$J29)/((1+$C$13)^($B29-$C$21))<0,SUM($I29:$J29)/((1+$C$13)^($B29-$C$21)),\"\")","v":-9807.6923076923067},{"$f":" IF($E29>=$F$21,IF($E29<=$F$22,IF(SUM($F29:$G29)/((1+$C$13)^($E29-$F$21))<0,SUM($F29:$G29)/((1+$C$13)^($E29-$F$21)),\"\"),\"\"),\"\")","v":-237836.3468214942}]
[null,{"$f":"B29+1","v":2017},-10404,null,{"$f":"E29+1","v":2017},-237149.80069435397,-10404,null,"",-10404,-9619.082840236686,-228877.40448812308]
[null,{"$f":"B30+1","v":2018},-10612.08,null,{"$f":"E30+1","v":2018},-237149.80069435397,-10612.08,null,"",-10612.08,-9434.1004779244413,-220259.4097547383]
[null,2019,-10824.321599999999,null,2019,-237149.80069435397,-10824.321599999999,null,"",-10824.321599999999,-9252.6754687335851,-211969.31900413151]
[null,2020,-11040.808031999999,null,2020,-237149.80069435397,-11040.808031999999,null,"",-11040.808031999999,-9074.7394020271695,-203994.58895529437]
[null,2021,-11261.62419264,null,2021,-237149.80069435397,-11261.62419264,null,"",-11261.62419264,-8900.2251827574164,-196323.15744551437]
[null,2022,-11486.8566764928,null,2022,-237149.80069435397,-11486.8566764928,null,"",-11486.8566764928,-8729.0670061659293,-188943.42495112456]
[null,2023,-11716.593810022656,null,2023,-237149.80069435397,-11716.593810022656,null,"",-11716.593810022656,-8561.2003329704294,-181844.23681850752]
[null,2024,-11950.925686223109,null,2024,-237149.80069435397,-23901.851372446217,null,"",-11950.925686223109,-8396.5618650286888,-183411.4280430738]
[null,2025,-12189.944199947571,null,2025,-237149.80069435397,-12189.944199947571,null,"",-12189.944199947571,-8235.0895214704451,-168444.99751475547]
[null,2026,-12433.743083946523,null,2026,-237149.80069435397,-12433.743083946523,null,"",-12433.743083946523,-8076.7224152883218,-162124.71087037009]
[null,2027,-12682.417945625453,null,2027,-237149.80069435397,-12682.417945625453,null,"",-12682.417945625453,-7921.4008303789287,-156044.46665257291]
[null,2028,-12936.066304537962,null,2028,-237149.80069435397,-12936.066304537962,null,"",-12936.066304537962,-7769.0661990254885,-150195.09102805814]
[null,2029,-13194.787630628722,null,2029,-237149.80069435397,-13194.787630628722,null,"",-13194.787630628722,-7619.6610798134598,-144567.76187696026]
[null,2030,-13458.683383241296,null,2030,-237149.80069435397,-13458.683383241296,null,"",-13458.683383241296,-7473.129135970893,-139153.99528707357]
[null,2031,-13727.857050906123,null,2031,-237149.80069435397,-13727.857050906123,null,"",-13727.857050906123,-7329.4151141252987,-133945.63256710861]
[null,2032,-14002.414191924245,null,2032,-237149.80069435397,-14002.414191924245,null,"",-14002.414191924245,-7188.4648234690421,-128934.82775902993]
[null,2033,-14282.46247576273,null,2033,-237149.80069435397,-14282.46247576273,null,"",-14282.46247576273,-7050.2251153254056,-124114.03563028779]
[null,2034,-14568.111725277984,null,2034,-237149.80069435397,-29136.223450555968,null,"",-14568.111725277984,-6914.6438631076098,-126390.64399060213]
[null,2035,-14859.473959783543,null,2035,-237149.80069435397,-14859.473959783543,null,"",-14859.473959783543,-6781.6699426632322,-115013.74327380449]
[null,2036,-15156.663438979214,null,2036,-237149.80069435397,-15156.663438979214,null,"",-15156.663438979214,-6651.2532129966303,-110720.55449294012]
[null,2037,-15459.796707758798,null,2037,-237149.80069435397,-15459.796707758798,null,"",-15459.796707758798,-6523.3444973620799,-106589.98034346159]
[null,2038,-15768.992641913974,null,2038,-237149.80069435397,-15768.992641913974,null,"",-15768.992641913974,-6397.8955647205021,-102615.81464750851]
[null,2039,-16084.372494752253,null,2039,-237149.80069435397,-16084.372494752253,null,"",-16084.372494752253,-6274.8591115527988,-98792.088998848951]
[null,2040,-16406.059944647299,null,2040,null,-16406.059944647299,null,"",-16406.059944647299,-6154.1887440229366,-6154.1887440229366]
[null,2041,-16734.181143540245,null,2041,null,-16734.181143540245,null,"",-16734.181143540245,-6035.8389604840349,-6035.8389604840349]
[null,2042,-17068.86476641105,null,2042,null,-17068.86476641105,null,"",-17068.86476641105,-5919.76513432088,-5919.76513432088]
[null,2043,-17410.242061739271,null,2043,null,-17410.242061739271,null,"",-17410.242061739271,-5805.9234971224005,-5805.9234971224005]
[null,2044,-17758.446902974058,null,2044,null,-35516.893805948115,null,"",-17758.446902974058,-5694.271122177739,-11388.542244355478]
[null,2045,-18113.615841033537,null,2045,null,-18113.615841033537,null,"",-18113.615841033537,-5584.7659082897062,-5584.7659082897062]
[null,2046,-18475.88815785421,null,2046,null,-18475.88815785421,null,"",-18475.88815785421,-5477.366563899519,-5477.366563899519]
[null,2047,-18845.405921011294,null,2047,null,-18845.405921011294,null,"",-18845.405921011294,-5372.032591516836,-5372.032591516836]
[null,2048,-19222.31403943152,null,2048,null,-19222.31403943152,null,"",-19222.31403943152,-5268.7242724492044,-5268.7242724492044]
[null,2049,-19606.76032022015,null,2049,null,-19606.76032022015,null,"",-19606.76032022015,-5167.4026518251803,-5167.4026518251803]
[null,2050,-19998.895526624554,null,2050,null,-19998.895526624554,null,"",-19998.895526624554,-5068.0295239054658,-5068.0295239054658]
[null,2051,-20398.873437157046,null,2051,null,-20398.873437157046,null,"",-20398.873437157046,-4970.5674176765151,-4970.5674176765151]
[null,2052,-20806.850905900188,null,2052,null,-20806.850905900188,null,"",-20806.850905900188,-4874.9795827211965,-4874.9795827211965]
[null,2053,-21222.987924018191,null,2053,null,-21222.987924018191,null,"",-21222.987924018191,-4781.2299753611742,-4781.2299753611742]
[null,2054,-21647.447682498554,null,2054,null,-43294.895364997108,null,"",-21647.447682498554,-4689.283245065767,-9378.566490131534]
[null,2055,-22080.396636148525,null,2055,null,-22080.396636148525,null,"",-22080.396636148525,-4599.104721122193,-4599.104721122193]
[null,2056,-22522.004568871496,null,2056,null,-22522.004568871496,null,"",-22522.004568871496,-4510.6603995621508,-4510.6603995621508]
[null,2057,-22972.444660248926,null,2057,null,-22972.444660248926,null,"",-22972.444660248926,-4423.9169303398021,-4423.9169303398021]
[null,2058,-23431.893553453905,null,2058,null,-23431.893553453905,null,"",-23431.893553453905,-4338.8416047563442,-4338.8416047563442]
[null,2059,-23900.531424522982,null,2059,null,-23900.531424522982,null,"",-23900.531424522982,-4255.4023431264141,-4255.4023431264141]
[null,2060,-24378.542053013443,null,2060,null,-24378.542053013443,null,"",-24378.542053013443,-4173.5676826816753,-4173.5676826816753]
[null,2061,-24866.112894073714,null,2061,null,-24866.112894073714,null,"",-24866.112894073714,-4093.3067657070278,-4093.3067657070278]
[null,2062,-25363.435151955189,null,2062,null,-25363.435151955189,null,"",-25363.435151955189,-4014.5893279049697,-4014.5893279049697]
[null,2063,-25870.703854994292,null,2063,null,-25870.703854994292,null,"",-25870.703854994292,-3937.3856869837196,-3937.3856869837196]
[null,2064,-26388.117932094177,null,2064,null,-52776.235864188355,null,"",-26388.117932094177,-3861.6667314648016,-7723.3334629296032]
[null,2065,-26915.880290736062,null,2065,null,-26915.880290736062,null,"",-26915.880290736062,-3787.403909705863,-3787.403909705863]
[null,2066,-27454.197896550784,null,2066,null,-27454.197896550784,null,"",-27454.197896550784,-3714.5692191345966,-3714.5692191345966]
[null,2067,-28003.2818544818,null,2067,null,-28003.2818544818,null,"",-28003.2818544818,-3643.1351956897006,-3643.1351956897006]
[null,2068,-28563.347491571436,null,2068,null,-28563.347491571436,null,"",-28563.347491571436,-3573.0749034648979,-3573.0749034648979]
[null,2069,-29134.614441402864,null,2069,null,-29134.614441402864,null,"",-29134.614441402864,-3504.3619245521113,-3504.3619245521113]
[null,2070,-29717.306730230921,null,2070,null,-29717.306730230921,null,"",-29717.306730230921,-3436.9703490799557,-3436.9703490799557]
[null,2071,-30311.652864835542,null,2071,null,-30311.652864835542,null,"",-30311.652864835542,-3370.8747654438025,-3370.8747654438025]
[null,2072,-30917.885922132253,null,2072,null,-30917.885922132253,null,"",-30917.885922132253,-3306.0502507237284,-3306.0502507237284]
[null,2073,-31536.243640574899,null,2073,null,-31536.243640574899,null,"",-31536.243640574899,-3242.4723612867347,-3242.4723612867347]
[null,2074,-32166.968513386397,null,2074,null,-64333.937026772794,null,"",-32166.968513386397,-3180.117123569682,-6360.234247139364]
[null,2075,-32810.307883654124,null,2075,null,-32810.307883654124,null,"",-32810.307883654124,-3118.9610250394949,-3118.9610250394949]
[null,2076,-33466.514041327209,null,2076,null,-33466.514041327209,null,"",-33466.514041327209,-3058.9810053271967,-3058.9810053271967]
[null,2077,-34135.844322153753,null,2077,null,-34135.844322153753,null,"",-34135.844322153753,-3000.1544475324436,-3000.1544475324436]
[null,2078,-34818.561208596831,null,2078,null,-34818.561208596831,null,"",-34818.561208596831,-2942.4591696952816,-2942.4591696952816]
[null,2079,-35514.932432768772,null,2079,null,-35514.932432768772,null,"",-35514.932432768772,-2885.8734164319108,-2885.8734164319108]
[null,2080,-36225.23108142415,null,2080,null,-36225.23108142415,null,{"$f":" IF($B93=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B93>=$C$21,IF($B93<=$C$22,$C93,\"\"),\"\")","v":-36225.23108142415},{"$f":" IF(SUM($I93:$J93)/((1+$C$13)^($B93-$C$21))<0,SUM($I93:$J93)/((1+$C$13)^($B93-$C$21)),\"\")","v":-2830.3758507312969},{"$f":" IF($E93>=$F$21,IF($E93<=$F$22,IF(SUM($F93:$G93)/((1+$C$13)^($E93-$F$21))<0,SUM($F93:$G93)/((1+$C$13)^($E93-$F$21)),\"\"),\"\"),\"\")","v":-2830.3758507312969}]
[null,2081,-36949.735703052633,null,2081,null,-36949.735703052633,null,"",-36949.735703052633,-2775.9455459095411,-2775.9455459095411]
[null,{"$f":"B94+1","v":2082},-37688.730417113686,null,{"$f":"E94+1","v":2082},null,-37688.730417113686,null,"",-37688.730417113686,-2722.5619777189731,-2722.5619777189731]
[null,{"$f":"B95+1","v":2083},-38442.505025455961,null,{"$f":"E95+1","v":2083},null,-38442.505025455961,null,"",-38442.505025455961,-2670.2050166089925,-2670.2050166089925]
[null,{"$f":"B96+1","v":2084},-39211.355125965078,null,{"$f":"E96+1","v":2084},null,-78422.710251930155,null,"",-39211.355125965078,-2618.8549201357423,-5237.7098402714846]
[null,{"$f":"B97+1","v":2085},-39995.582228484382,null,{"$f":"E97+1","v":2085},null,-39995.582228484382,null,"",-39995.582228484382,-2568.4923255177473,-2568.4923255177473]
[null,2086,-40795.493873054067,null,2086,null,-40795.493873054067,null,"",-40795.493873054067,-2519.0982423347141,-2519.0982423347141]
[null,2087,-41611.40375051515,null,2087,null,-41611.40375051515,null,"",-41611.40375051515,-2470.6540453667385,-2470.6540453667385]
[null,2088,-42443.631825525452,null,2088,null,-42443.631825525452,null,"",-42443.631825525452,-2423.141467571224,-2423.141467571224]
[null,2089,-43292.504462035962,null,2089,null,-43292.504462035962,null,"",-43292.504462035962,-2376.5425931948544,-2376.5425931948544]
[null,2090,null,null,2090,null,null,null,"","","",""]
[null,2091,null,null,2091,null,null,null,"","","",""]
[null,2092,null,null,2092,null,null,null,"","","",""]
[null,2093,null,null,2093,null,null,null,"","","",""]
[null,2094,null,null,2094,null,null,null,"","","",""]
[null,{"$f":"B107+1","v":2095},null,null,{"$f":"E107+1","v":2095},null,null,null,"","","",""]
[null,{"$f":"B108+1","v":2096},null,null,{"$f":"E108+1","v":2096},null,null,null,"","","",""]
[null,2097,null,null,2097,null,null,null,"","","",""]
[null,2098,null,null,2098,null,null,null,"","","",""]
[null,2099,null,null,2099,null,null,null,"","","",""]
[null,2100,null,null,2100,null,null,null,"","","",""]
[null,2101,null,null,2101,null,null,null,"","","",""]
[null,2102,null,null,2102,null,null,null,"","","",""]
[null,2103,null,null,2103,null,null,null,"","","",""]
[null,2104,null,null,2104,null,null,null,"","","",""]
[null,2105,null,null,2105,null,null,null,"","","",""]
[null,2106,null,null,2106,null,null,null,"","","",""]
[null,2107,null,null,2107,null,null,null,"","","",""]
[null,2108,null,null,2108,null,null,null,"","","",""]
[null,2109,null,null,2109,null,null,null,"","","",""]
[null,2110,null,null,2110,null,null,null,"","","",""]
[null,2111,null,null,2111,null,null,null,"","","",""]
[null,2112,null,null,2112,null,null,null,"","","",""]
[null,2113,null,null,2113,null,null,null,"","","",""]
[null,2114,null,null,2114,null,null,null,"","","",""]
[null,2115,null,null,2115,null,null,null,"","","",""]
[null,2116,null,null,2116,null,null,null,"","","",""]
[null,2117,null,null,2117,null,null,null,"","","",""]
[null,2118,null,null,2118,null,null,null,"","","",""]
[null,2119,null,null,2119,null,null,null,"","","",""]
[null,2120,null,null,2120,null,null,null,"","","",""]
[null,2121,null,null,2121,null,null,null,"","","",""]
[null,2122,null,null,2122,null,null,null,"","","",""]
[null,2123,null,null,2123,null,null,null,"","","",""]
[null,2124,null,null,2124,null,null,null,"","","",""]
[null,2125,null,null,2125,null,null,null,"","","",""]
[null,2126,null,null,2126,null,null,null,"","","",""]
[null,2127,null,null,2127,null,null,null,"","","",""]
[null,2128,null,null,2128,null,null,null,"","","",""]
[null,2129,null,null,2129,null,null,null,"","","",""]
[null,2130,null,null,2130,null,null,null,"","","",""]
[null,2131,null,null,2131,null,null,null,"","","",""]
[null,2132,null,null,2132,null,null,null,"","","",""]
[null,2133,null,null,2133,null,null,null,"","","",""]
[null,2134,null,null,2134,null,null,null,"","","",""]

{"sheet":"17. EAA","index":16,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Fane 17. EAA-beregning for projekt Grundejerforeningen Øresund"]
[]
[null,"Vejledning:"]
[null,"Dette dokument kan anvendes til at vurdere, hvorvidt klimatilpasning ved hhv. sædvanlig afhjælpning eller alternativt projekt er mest omkostningseffektivt. Oplysninger om forventet årlig effektiv rente"]
[null,"samt omkostninger til anlæg og drift skal indtastes i de orange celler. Det bemærkes, at omkostninger indgår som negative tal."]
[null,"Herefter beregnes den årlige ækvivalente annuitet ved de to typer klimatilpasningsinitiativer. Sidst beregnes hvilket klimatilpasningsinitiativ, som er mest omkostningseffektivt"]
[]
[]
[null,"Rente",null,null,"Resultater"]
[]
[null,"Forventet årlig effektiv rente",0.04,null,"Årlig ækvivalent annuitet ved sædvanlig afhjælpning",{"$f":"IF(SUM($C$24:$C$147)<0,($C$13*SUM($K$28:$K$147)/(1-(1+$C$13)^(-($C$22-$C$21+1)))),\"\")","v":-547165.86805416562}]
[null,null,null,null,"Årlig ækvivalent annuitet ved alternativt klimatilpasningsprojekt",{"$f":"IF(SUM($F$28:$G$147)<0,($C$13*SUM($L$28:$L$147)/(1-(1+$C$13)^(-($F$22-$F$21+1)))),\"\")","v":-107461.07113627068}]
[]
[null,null,null,null,"Konklusion",{"$f":"IF($F$13<0,IF($F$13<>$F$14,IF($F$13>$F$14,\"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,"Klimatilpasning ved alternativt klimatilpasningsprojekt"]
[]
[null,"Projektets startår",2015,null,"Projektets startår",2015,null,null,null,null,null,{"$f":" IF($E21>=$F$21,IF($E21<=$F$22,SUM($F21:$G21),\"\"),\"\")","v":""}]
[null,"Projektets slutår",2089,null,"Projektets slutår",2089,null,null,null,null,null,{"$f":" IF($E22>=$F$21,IF($E22<=$F$22,SUM($F22:$G22),\"\"),\"\")","v":""}]
[]
[null,"Samlede anlægsomkostninger",-12000000]
[]
[]
[null,"År","Forventede driftsomkostninger i år t",null,"År ","Tilskud til anlægsomkostninger betalt i år t","Tilskud til driftsomkostninger betalt i år t",null,"Sædvanlig afhjælpning: Cash-flow for anlæg","Sædvanlig afhjælpning: Cash-flow for drift","Tilbagediskonteret cash-flow for sædvanlig afhjælpning","Tilbagediskonteret cash-flow for alternativt projekt"]
[null,2015,-24000,null,2015,-134898.54931731493,-16000,null,{"$f":" IF($B28=$C$21,$C$24,\"\")","v":-12000000},{"$f":" IF($B28>=$C$21,IF($B28<=$C$22,$C28,\"\"),\"\")","v":-24000},{"$f":" IF(SUM($I28:$J28)/((1+$C$13)^($B28-$C$21))<0,SUM($I28:$J28)/((1+$C$13)^($B28-$C$21)),\"\")","v":-12024000},{"$f":" IF($E28>=$F$21,IF($E28<=$F$22,IF(SUM($F28:$G28)/((1+$C$13)^($E28-$F$21))<0,SUM($F28:$G28)/((1+$C$13)^($E28-$F$21)),\"\"),\"\"),\"\")","v":-150898.54931731493}]
[null,2016,-24480,null,2016,-134898.54931731493,-16320,null,{"$f":" IF($B29=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B29>=$C$21,IF($B29<=$C$22,$C29,\"\"),\"\")","v":-24480},{"$f":" IF(SUM($I29:$J29)/((1+$C$13)^($B29-$C$21))<0,SUM($I29:$J29)/((1+$C$13)^($B29-$C$21)),\"\")","v":-23538.461538461539},{"$f":" IF($E29>=$F$21,IF($E29<=$F$22,IF(SUM($F29:$G29)/((1+$C$13)^($E29-$F$21))<0,SUM($F29:$G29)/((1+$C$13)^($E29-$F$21)),\"\"),\"\"),\"\")","v":-145402.45126664898}]
[null,{"$f":"B29+1","v":2017},-24969.600000000002,null,{"$f":"E29+1","v":2017},-134898.54931731493,-16646.400000000001,null,"",-24969.600000000002,-23085.798816568047,-140111.82444278375]
[null,{"$f":"B30+1","v":2018},-25468.992000000002,null,{"$f":"E30+1","v":2018},-134898.54931731493,-16979.328000000001,null,"",-25468.992000000002,-22641.841147018662,-135018.8798977609]
[null,2019,-25978.371840000003,null,2019,-134898.54931731493,-17318.914560000001,null,"",-25978.371840000003,-22206.421124960609,-130116.12607024469]
[null,2020,-26497.939276800003,null,2020,-134898.54931731493,-17665.2928512,null,"",-26497.939276800003,-21779.374564865211,-125396.35738965783]
[null,2021,-27027.898062336004,null,2021,-134898.54931731493,-18018.598708223999,null,"",-27027.898062336004,-21360.540438617802,-120852.64331781027]
[null,2022,-27568.456023582723,null,2022,-134898.54931731493,-18378.970682388481,null,"",-27568.456023582723,-20949.760814798232,-116478.31781121015]
[null,2023,-28119.825144054379,null,2023,-134898.54931731493,-18746.550096036251,null,"",-28119.825144054379,-20546.88079912903,-112266.96918789175]
[null,2024,-28682.221646935468,null,2024,-134898.54931731493,-19121.481097956977,null,"",-28682.221646935468,-20151.748476068857,-108212.43038321807]
[null,2025,-29255.866079874177,null,2025,-134898.54931731493,-19503.910719916119,null,"",-29255.866079874177,-19764.214851529072,-104308.76957971057]
[null,2026,-29840.983401471662,null,2026,-134898.54931731493,-19893.988934314442,null,"",-29840.983401471662,-19384.133796691978,-100550.28119653618]
[null,2027,-30437.803069501097,null,2027,-134898.54931731493,-20291.868713000731,null,"",-30437.803069501097,-19011.361992909435,-96931.47722483211]
[null,2028,-31046.559130891121,null,2028,-134898.54931731493,-20697.706087260747,null,"",-31046.559130891121,-18645.758877661177,-93447.078895580984]
[null,2029,-31667.490313508944,null,2029,-134898.54931731493,-21111.660209005964,null,"",-31667.490313508944,-18287.186591552309,-90092.008667259433]
[null,2030,-32300.840119779125,null,2030,-134898.54931731493,-21533.893413186084,null,"",-32300.840119779125,-17935.509926330153,-86861.382520974483]
[null,2031,-32946.856922174709,null,2031,-134898.54931731493,-21964.571281449807,null,"",-32946.856922174709,-17590.596273900723,-83750.502551274563]
[null,2032,-33605.794060618202,null,2032,-134898.54931731493,-22403.862707078802,null,"",-33605.794060618202,-17252.315576325709,-80754.849841275543]
[null,2033,-34277.909941830563,null,2033,-134898.54931731493,-22851.939961220378,null,"",-34277.909941830563,-16920.540276780979,-77870.077611179368]
[null,2034,-34963.468140667173,null,2034,-134898.54931731493,-23308.978760444785,null,"",-34963.468140667173,-16595.14527145827,-75092.004629682488]
[null,2035,-35662.737503480515,null,2035,null,-23775.158335653679,null,"",-35662.737503480515,-16276.007862391763,-10850.671908261176]
[null,2036,-36375.992253550125,null,2036,null,-24250.661502366755,null,"",-36375.992253550125,-15963.007711191916,-10642.005140794614]
[null,2037,-37103.512098621126,null,2037,null,-24735.674732414089,null,"",-37103.512098621126,-15656.026793668996,-10437.351195779333]
[null,2038,-37845.582340593552,null,2038,null,-25230.388227062373,null,"",-37845.582340593552,-15354.94935532921,-10236.632903552809]
[null,2039,-38602.493987405425,null,2039,null,-25734.99599160362,null,"",-38602.493987405425,-15059.661867726725,-10039.774578484485]
[null,2040,-39374.543867153538,null,2040,null,-26249.695911435694,null,"",-39374.543867153538,-14770.052985655055,-9846.7019904367044]
[null,2041,-40162.03474449661,null,2041,null,-26774.689829664407,null,"",-40162.03474449661,-14486.013505161691,-9657.3423367744617]
[null,2042,-40965.27543938654,null,2042,null,-27310.183626257694,null,"",-40965.27543938654,-14207.436322370118,-9471.6242149134123]
[null,2043,-41784.580948174269,null,2043,null,-27856.387298782847,null,"",-41784.580948174269,-13934.216393093768,-9289.4775953958451]
[null,2044,-42620.272567137756,null,2044,null,-28413.515044758504,null,"",-42620.272567137756,-13666.250693226579,-9110.8337954843864]
[null,2045,-43472.67801848051,null,2045,null,-28981.785345653676,null,"",-43472.67801848051,-13403.4381798953,-8935.6254532635339]
[null,2046,-44342.131578850123,null,2046,null,-29561.421052566751,null,"",-44342.131578850123,-13145.679753358852,-8763.7865022392361]
[null,2047,-45228.974210427128,null,2047,null,-30152.649473618087,null,"",-45228.974210427128,-12892.878219640412,-8595.2521464269412]
[null,2048,-46133.553694635673,null,2048,null,-30755.702463090449,null,"",-46133.553694635673,-12644.938253878097,-8429.958835918731]
[null,2049,-47056.224768528387,null,2049,null,-31370.816512352259,null,"",-47056.224768528387,-12401.766364380441,-8267.8442429202951]
[null,2050,-47997.349263898956,null,2050,null,-31998.232842599304,null,"",-47997.349263898956,-12163.270857373125,-8108.8472382487498]
[null,2051,-48957.296249176936,null,2051,null,-32638.197499451289,null,"",-48957.296249176936,-11929.361802423642,-7952.9078682824274]
[null,2052,-49936.442174160475,null,2052,null,-33290.961449440314,null,"",-49936.442174160475,-11699.950998530876,-7799.9673323539173]
[null,2053,-50935.171017643683,null,2053,null,-33956.780678429124,null,"",-50935.171017643683,-11474.951940866822,-7649.967960577882]
[null,2054,-51953.874437996557,null,2054,null,-34635.91629199771,null,"",-51953.874437996557,-11254.279788157846,-7502.8531921052318]
[null,2055,-52992.95192675649,null,2055,null,-35328.634617837663,null,"",-52992.95192675649,-11037.851330693269,-7358.567553795513]
[null,2056,-54052.810965291617,null,2056,null,-36035.207310194419,null,"",-54052.810965291617,-10825.584958949168,-7217.056639299446]
[null,2057,-55133.867184597453,null,2057,null,-36755.911456398309,null,"",-55133.867184597453,-10617.40063281553,-7078.2670885436892]
[null,2058,-56236.5445282894,null,2058,null,-37491.029685526279,null,"",-56236.5445282894,-10413.219851415231,-6942.1465676101561]
[null,2059,-57361.275418855192,null,2059,null,-38240.850279236802,null,"",-57361.275418855192,-10212.965623503398,-6808.6437490022672]
[null,2060,-58508.500927232293,null,2060,null,-39005.667284821538,null,"",-58508.500927232293,-10016.562438436025,-6677.7082922906857]
[null,2061,-59678.670945776939,null,2061,null,-39785.780630517969,null,"",-59678.670945776939,-9823.9362376968711,-6549.2908251312492]
[null,2062,-60872.24436469248,null,2062,null,-40581.496243128327,null,"",-60872.24436469248,-9635.0143869719323,-6423.3429246479554]
[null,2063,-62089.689251986332,null,2063,null,-41393.126167990893,null,"",-62089.689251986332,-9449.725648760932,-6299.8170991739553]
[null,2064,-63331.483037026061,null,2064,null,-42220.988691350714,null,"",-63331.483037026061,-9268.0001555155286,-6178.6667703436869]
[null,2065,-64598.112697766584,null,2065,null,-43065.40846517773,null,"",-64598.112697766584,-9089.7693832940768,-6059.8462555293854]
[null,2066,-65890.074951721923,null,2066,null,-43926.716634481287,null,"",-65890.074951721923,-8914.9661259230361,-5943.3107506153583]
[null,2067,-67207.876450756361,null,2067,null,-44805.250967170912,null,"",-67207.876450756361,-8743.5244696552872,-5829.0163131035251]
[null,2068,-68552.033979771484,null,2068,null,-45701.355986514332,null,"",-68552.033979771484,-8575.3797683157591,-5716.9198455438409]
[null,2069,-69923.074659366917,null,2069,null,-46615.383106244619,null,"",-69923.074659366917,-8410.4686189250715,-5606.9790792833828]
[null,2070,-71321.536152554254,null,2070,null,-47547.69076836951,null,"",-71321.536152554254,-8248.7288377918976,-5499.1525585279333]
[null,2071,-72747.966875605343,null,2071,null,-48498.644583736903,null,"",-72747.966875605343,-8090.0994370651315,-5393.3996247100886]
[null,2072,-74202.926213117447,null,2072,null,-49468.617475411644,null,"",-74202.926213117447,-7934.5206017369528,-5289.6804011579698]
[null,2073,-75686.984737379797,null,2073,null,-50457.989824919874,null,"",-75686.984737379797,-7781.9336670881676,-5187.9557780587793]
[null,2074,-77200.72443212739,null,2074,null,-51467.14962141827,null,"",-77200.72443212739,-7632.2810965672406,-5088.1873977114947]
[null,2075,-78744.738920769945,null,2075,null,-52496.492613846633,null,"",-78744.738920769945,-7485.5064600947917,-4990.3376400631951]
[null,2076,-80319.633699185346,null,2076,null,-53546.422466123564,null,"",-80319.633699185346,-7341.5544127852763,-4894.3696085235179]
[null,2077,-81926.02637316905,null,2077,null,-54617.350915446033,null,"",-81926.02637316905,-7200.3706740778689,-4800.2471160519126]
[null,2078,-83564.546900632427,null,2078,null,-55709.697933754956,null,"",-83564.546900632427,-7061.9020072686781,-4707.934671512453]
[null,2079,-85235.837838645079,null,2079,null,-56823.89189243006,null,"",-85235.837838645079,-6926.096199436588,-4617.3974662910587]
[null,2080,-86940.554595417983,null,2080,null,-57960.36973027866,null,{"$f":" IF($B93=$C$21,$C$24,\"\")","v":""},{"$f":" IF($B93>=$C$21,IF($B93<=$C$22,$C93,\"\"),\"\")","v":-86940.554595417983},{"$f":" IF(SUM($I93:$J93)/((1+$C$13)^($B93-$C$21))<0,SUM($I93:$J93)/((1+$C$13)^($B93-$C$21)),\"\")","v":-6792.9020417551146},{"$f":" IF($E93>=$F$21,IF($E93<=$F$22,IF(SUM($F93:$G93)/((1+$C$13)^($E93-$F$21))<0,SUM($F93:$G93)/((1+$C$13)^($E93-$F$21)),\"\"),\"\"),\"\")","v":-4528.6013611700764}]
[null,2081,-88679.365687326339,null,2081,null,-59119.577124884236,null,"",-88679.365687326339,-6662.2693101829,-4441.5128734552673]
[null,{"$f":"B94+1","v":2082},-90452.953001072863,null,{"$f":"E94+1","v":2082},null,-60301.968667381923,null,"",-90452.953001072863,-6534.1487465255368,-4356.0991643503594]
[null,{"$f":"B95+1","v":2083},-92262.012061094327,null,{"$f":"E95+1","v":2083},null,-61508.008040729561,null,"",-92262.012061094327,-6408.4920398615841,-4272.3280265743897]
[null,{"$f":"B96+1","v":2084},-94107.252302316221,null,{"$f":"E96+1","v":2084},null,-62738.168201544155,null,"",-94107.252302316221,-6285.2518083257846,-4190.1678722171901]
[null,{"$f":"B97+1","v":2085},-95989.397348362545,null,{"$f":"E97+1","v":2085},null,-63992.93156557504,null,"",-95989.397348362545,-6164.3815812425955,-4109.5877208283973]
[null,2086,-97909.185295329793,null,2086,null,-65272.790196886541,null,"",-97909.185295329793,-6045.8357816033158,-4030.5571877355446]
[null,2087,-99867.369001236395,null,2087,null,-66578.246000824278,null,"",-99867.369001236395,-5929.5697088801744,-3953.0464725867837]
[null,2088,-101864.71638126113,null,2088,null,-67909.81092084077,null,"",-101864.71638126113,-5815.5395221709405,-3877.0263481139614]
[null,2089,-103902.01070888634,null,2089,null,-69268.007139257592,null,"",-103902.01070888634,-5703.7022236676521,-3802.4681491117694]
[null,2090,null,null,2090,null,null,null,"","","",""]
[null,2091,null,null,2091,null,null,null,"","","",""]
[null,2092,null,null,2092,null,null,null,"","","",""]
[null,2093,null,null,2093,null,null,null,"","","",""]
[null,2094,null,null,2094,null,null,null,"","","",""]
[null,{"$f":"B107+1","v":2095},null,null,{"$f":"E107+1","v":2095},null,null,null,"","","",""]
[null,{"$f":"B108+1","v":2096},null,null,{"$f":"E108+1","v":2096},null,null,null,"","","",""]
[null,2097,null,null,2097,null,null,null,"","","",""]
[null,2098,null,null,2098,null,null,null,"","","",""]
[null,2099,null,null,2099,null,null,null,"","","",""]
[null,2100,null,null,2100,null,null,null,"","","",""]
[null,2101,null,null,2101,null,null,null,"","","",""]
[null,2102,null,null,2102,null,null,null,"","","",""]
[null,2103,null,null,2103,null,null,null,"","","",""]
[null,2104,null,null,2104,null,null,null,"","","",""]
[null,2105,null,null,2105,null,null,null,"","","",""]
[null,2106,null,null,2106,null,null,null,"","","",""]
[null,2107,null,null,2107,null,null,null,"","","",""]
[null,2108,null,null,2108,null,null,null,"","","",""]
[null,2109,null,null,2109,null,null,null,"","","",""]
[null,2110,null,null,2110,null,null,null,"","","",""]
[null,2111,null,null,2111,null,null,null,"","","",""]
[null,2112,null,null,2112,null,null,null,"","","",""]
[null,2113,null,null,2113,null,null,null,"","","",""]
[null,2114,null,null,2114,null,null,null,"","","",""]
[null,2115,null,null,2115,null,null,null,"","","",""]
[null,2116,null,null,2116,null,null,null,"","","",""]
[null,2117,null,null,2117,null,null,null,"","","",""]
[null,2118,null,null,2118,null,null,null,"","","",""]
[null,2119,null,null,2119,null,null,null,"","","",""]
[null,2120,null,null,2120,null,null,null,"","","",""]
[null,2121,null,null,2121,null,null,null,"","","",""]
[null,2122,null,null,2122,null,null,null,"","","",""]
[null,2123,null,null,2123,null,null,null,"","","",""]
[null,2124,null,null,2124,null,null,null,"","","",""]
[null,2125,null,null,2125,null,null,null,"","","",""]
[null,2126,null,null,2126,null,null,null,"","","",""]
[null,2127,null,null,2127,null,null,null,"","","",""]
[null,2128,null,null,2128,null,null,null,"","","",""]
[null,2129,null,null,2129,null,null,null,"","","",""]
[null,2130,null,null,2130,null,null,null,"","","",""]
[null,2131,null,null,2131,null,null,null,"","","",""]
[null,2132,null,null,2132,null,null,null,"","","",""]
[null,2133,null,null,2133,null,null,null,"","","",""]
[null,2134,null,null,2134,null,null,null,"","","",""]