{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overblik","Forudsætninger","Selskabsøkonomi"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Overblik","index":0,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[[54,1,54,2],[6,3,6,4],[10,3,10,5],[11,3,11,5]]}
[]
[null,"Beregningsredskab"]
[null,"Simpelt værktøj til beregning af selskabsøkonomi"]
[null,"Version 1.0 (September 2022)"]
[null,"Dette er ikke et beslutningsredskab, men viser dynamikker op projekterne økonomiske balancer."]
[]
[null,"Forklaring",null,"Hold musen over denne celle for info"]
[null,"I grønne celler skal der indtastes en værdi"]
[null,"I gule celler skal der vælges fra en liste"]
[null,null,null,null,null,"kr. MWh/år"]
[null,"Varmebehov",null,"Note"]
[null,"Varmegrundlag",0,"Varmegrundlag i det nye by-/forsyningsområde. Kan evt. baseres på data fra Varmeplan Danmark eller BBR"]
[null,"Tilslutningsgrad",0,"Andelen af forsyningsområdet som forventes tilsluttet."]
[null,"Standard boliger á 18,1 MWh/år",{"$f":"(C12*C13)/18.1","v":0},"Beregnes ud fra varmegrundlag for området samt tilslutningsgraden."]
[null,"Ledningstab",0,"Indtast ledningstab i procent. Afhænger af varmebehov i området, afstand mellem bygningerne, rørtype etc."]
[null,"Varmetab i ledningsnet",{"$f":"C12*(C13)*(C15)","v":0},"Beregnes ud fra indstastede procentsats for ledningstab på baggrund af varmegrundlag for området, samt tilslutningsgraden."]
[]
[null,"Investeringer",null,"Note"]
[null,"Investeringer estimeres eller indtastes?","Estimeres","Vil du indtaste et samlet beløb for investeringsomkostninger, eller skal de estimeres på baggrund af indtastede forudstæninger?"]
[null,"Omkostning til fjernvarmenet, pr. ejendom",0,"Omkostning pr. ejendom at udlægge et fjernvarmehovedledningsnet i et nyt område. "]
[null,"Omkostning til stikledning, pr.ejendom",0,"Omkostning pr. ejendom at udlægge en stikledning. Typisk 20 meter á 1.750 kr./meter"]
[null,"Indtast omkostninger til fjernvarmenet",0,"Indstast samlede invsteringsomkostninger til etablering af fjernvarmenet"]
[null,"Indtast omkostninger til stikledninger",0,"Indtast samlede invsteringsomkostninger til etablering af stikledninger"]
[null,"Indtast omkostninger til varmecentral",0,"Indtasts samlede investeringsomkostninger for varmecentral (inkl. bygning, areal, eltilsutning etc.)"]
[null,"Estimerede udgifter til fjernvarmenet",{"$f":"C14*C20","v":0},"Estimeres ud fra indstastet omkostning pr. ejendom i celle C20"]
[null,"Estimerede udgifter til stikledninger",{"$f":"C14*C21","v":0},"Estimeres ud fra indstastet omkostning pr. ejendom i celle C21"]
[null,"Estimerede udgifter til varmecentral",{"$f":"INDEX(Forudsætninger!B3:C8,MATCH(B32,Forudsætninger!B3:B8,0),2)*C32*10^6+INDEX(Forudsætninger!B3:C8,MATCH(B33,Forudsætninger!B3:B8,0),2)*C33*10^6+INDEX(Forudsætninger!B3:C8,MATCH(B34,Forudsætninger!B3:B8,0),2)*C34*10^6+C36*Forudsætninger!C8","v":0},"Estimeres ud fra standard-forudsætninger og indtastet kapacitet i cellerne C32-C36"]
[null,"Diverse og uforudsigelige (5%)",{"$f":"IF(C19=\"Indtastes\",SUM(C22:C24),SUM(C25:C27))*0.05","v":0},"5% til at dække diverse og udforudsete udgifter"]
[null,"I alt",{"$f":"IF(C19=\"Indtastes\",SUM(C22:C24)+C28,SUM(C25:C28))","v":0}]
[]
[null,"Produktionsanlæg","Varmeydelse","Produktionspris","Fordeling","Note"]
[null,"-",0,0,0,"Varmeydelse, produktionspris inkl. drift og vedlighold, samt andel af varmeproduktionen"]
[null,"-",0,0,0,"Varmeydelse, produktionspris inkl. drift og vedlighold, samt andel af varmeproduktionen"]
[null,"-",0,0,0,"Varmeydelse, produktionspris inkl. drift og vedlighold, samt andel af varmeproduktionen"]
[null,"Vægtet gns. produktionsomkostning",{"$f":"SUM(C32:C34)","v":0},{"$f":"(D32*E32+D33*E33+D34*E34)/1","v":0},{"$f":"SUM(E32:E34)","v":0},"Beregnes ud fra produktionspris og fordeling"]
[null,"Akkumuleringstank",0,"-","-","Angiv størrelse på akkumuleringstanken, i m3"]
[]
[null,"Drift- og vedligeholdsomkostninger",null,"Note"]
[null,"Driftsudgifter til ledningsnet",0,"Vedligeholdsomkostninger til ledningsnet, kr./MWh-varme"]
[null,"Driftspersonale og administration",0,"Årlige udgifter til administration, personale etc."]
[null,"Vedligehold af bygninger, målere m.m.",0,"Årlige udgifter til vedligehold af bygninger, målere etc."]
[]
[null,"Afskrivning og renter",null,"Note"]
[null,"Afskrivningsperiode, ledningsnet",0,"Angiv lånets løbetid"]
[null,"Afskrivningsperiode, anlæg (produktion)",0,"Angiv lånets løbetid"]
[null,"Rentesats, ledning",0,"Angiv rente for annuitetslån inkl. garantiprovision"]
[null,"Rentesats, øvrige",0,"Angiv rente for annuitetslån inkl. garantiprovision"]
[]
[null,"Fjernvarmetakster","Ekskl. moms","Note"]
[null,"Variabelt/forbrugs bidrag",0,"Betaling for de forbrugs-afhængige omkostninger (brændsler mm.)"]
[null,"Fast/effekt bidrag",0,"Betaling for de faste forbrugs-uafhængige omkostninger f.eks. afskrivninger og vedligeholdelse."]
[null,"Abonnement, målerbidrag",0,"Betaling for varmemåler og hele eller del af administratioen."]
[null,"Tilslutningsbidrag",0,"Engangsbeløb som betales for at komme på fjernvarme. Modregnes investeringsomkostningerne så lånebeløb nedsættes."]
[]
[null,"Overblik over selskabsøkonomi - Projektperiode 20 år",null,"Gns. Årligt"]
[null,"Indtægter"]
[null,"Salg af varme",{"$f":"SUM(Selskabsøkonomi!AL38:BE38)","v":0},{"$f":"C57/20","v":0}]
[null,"Fast bidrag",{"$f":"SUM(Selskabsøkonomi!AL28:BE28)","v":0},{"$f":"C58/20","v":0}]
[null,"Målerbidrag",{"$f":"SUM(Selskabsøkonomi!AL29:BE29)","v":0},0]
[null,"Indtægter i alt",{"$f":"SUM(C57:C59)","v":0},{"$f":"SUM(D57:D59)","v":0}]
[]
[null,"Udgifter"]
[null,"Investeringer",{"$f":"-SUM(Selskabsøkonomi!AL23:BE23)-SUM(Selskabsøkonomi!AL19:BE19)","v":{"$error":"#DIV/0!"}},{"$f":"C63/20","v":{"$error":"#DIV/0!"}}]
[null,"Produktions- og driftomkostninger",{"$f":"-SUM(Selskabsøkonomi!AL36:BE36)-SUM(Selskabsøkonomi!AL24:BE25)","v":0},{"$f":"C64/20","v":0}]
[null,"Udgifter i alt",{"$f":"SUM(C63:C64)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D63:D64)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Selskabsøkonomisk resultat",{"$f":"C60+C65","v":{"$error":"#DIV/0!"}},{"$f":"D60+D65","v":{"$error":"#DIV/0!"}}]
[null,"Nutidsværdi ",{"$f":"Selskabsøkonomi!AI48","v":{"$error":"#DIV/0!"}}]
[]
[null,"Beregn minimumstilslutning (nutidsværdi = 0)"]
[null,"Bemærk at dette overskriver den indtastede tilslutningsgrad i celle C13"]
[null,"OBS! Den beregnede tilslutningsgrad er over 100%"]
[null,"Beregn tilslutningsbidrag (nutidsværdi = 0)"]
[null,"Bemærk at dette overskriver den indtastede værdi i celle C53"]
[null,"Denne funktion beregner hvor stor tilslutningsbidraget som minimum skal være for at selskabsøkonomien går i 0 i projektperioden."]

{"sheet":"Forudsætninger","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[]
[null,"Forudsætning","Værdi","Enhed","Note/kilde"]
[null,"-"]
[null,"Varmepumpe",7,"mio. kr./MWv","Investeringsomkostning, ENS teknologikatalog"]
[null,"Elkedel",0.6,"mio. kr./MWv","Investeringsomkostning, ENS teknologikatalog"]
[null,"Biomassekedel",5.7,"mio. kr./MWv","Investeringsomkostning, fliskedel ENS teknologikatalog"]
[null,"Naturgaskedel",0.6,"mio. kr./MWv","Investeringsomkostning, ENS teknologikatalog"]
[null,"Akkumuleringstank",1500,"kr./m3","Investeringsomkostning, erfaringstal"]

{"sheet":"Selskabsøkonomi","index":2,"n_rows":52,"n_cols":57,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Varmegrundlag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antal boligenheder","stk.",null,null,{"$f":"ROUND(Overblik!C14,0)","v":0},{"$f":"$AL$9","v":0},{"$f":"$AL$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Areal ",130,null,null,{"$f":"$AI$10*AL9","v":0},{"$f":"$AI$10*AM9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faste udgifter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Anlægsinvestering, stikledninger",{"$f":"IF(Overblik!C19=\"Estimeres\",Overblik!C26,Overblik!C23)","v":0},null,null,{"$f":"AI12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Anlægsinvestering, hovedledninger",{"$f":"IF(Overblik!C19=\"Estimeres\",Overblik!C25,Overblik!C22)","v":0},null,null,{"$f":"AI13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Tilslutningsbidrag",{"$f":"Overblik!C53","v":0},null,null,{"$f":"$AI$14*AL9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Tilskud fra Fjernvarmepuljen",0,null,null,{"$f":"AI15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Lånebeløb, ledninger"," -",null,null,{"$f":"AL12+AL13-AL14-AL15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Afskrivninger, ledninger",{"$f":"Overblik!C44","v":0},null,null,{"$f":"$AL$16/$AI$17","v":{"$error":"#DIV/0!"}},{"$f":"IF(AM5>$AI$17,0,AL17)","v":0},{"$f":"IF(AN5>$AI$17,0,AM17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Renteomkostninger, ledninger",{"$f":"Overblik!C46","v":0},null,null,{"$f":"-PMT(AI18,AI17,AL16)-AL17","v":{"$error":"#NUM!"}},{"$f":"IF(AM5>$AI$17,0,-PMT($AI$18,$AI$17,$AL$16)-AM17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Kapitaludgifter, ledninger"," -",null,null,{"$f":"SUM(AL17:AL18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AM17:AM18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Anlægsinvestering, øvrige (produktionsanlæg)",{"$f":"IF(Overblik!C19=\"Estimeres\",Overblik!C27+Overblik!C28,Overblik!C24+Overblik!C28)","v":0},null,null,{"$f":"AI20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Afskrivninger, øvrige",{"$f":"Overblik!C45","v":0},null,null,{"$f":"AL20/$AI$21","v":{"$error":"#DIV/0!"}},{"$f":"IF(AM5>$AI$21,0,AL21)","v":0},{"$f":"IF(AN5>$AI$21,0,AM21)","v":0},0,{"$f":"IF(AP5>$AI$21,0,AO21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renteomkostninger, øvrige",{"$f":"Overblik!C47","v":0},null,null,{"$f":"-PMT($AI$22,$AI$21,$AL$20)-AL21","v":{"$error":"#NUM!"}},{"$f":"IF(AM5>$AI$21,0,-PMT($AI$22,$AI$21,$AL$20)-AM21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Kapitaludgifter, produktionsanlæg, 20 år"," -",null,null,{"$f":"SUM(AL21:AL22)","v":{"$error":"#DIV/0!"}},{"$f":"AM21+AM22","v":0},{"$f":"AN21+AN22","v":0},0,{"$f":"AP21+AP22","v":0},0,{"$f":"AR21+AR22","v":0},0,{"$f":"AT21+AT22","v":0},0,{"$f":"AV21+AV22","v":0},0,{"$f":"AX21+AX22","v":0},0,{"$f":"AZ21+AZ22","v":0},0,{"$f":"BB21+BB22","v":0},0,{"$f":"BD21+BD22","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omkostninger til personale og administration",{"$f":"Overblik!C40","v":0},null,null,{"$f":"AI24","v":0},{"$f":"AL24","v":0},{"$f":"AM24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vedigehold af bygninger m.m.",{"$f":"Overblik!C41","v":0},null,null,{"$f":"AI25","v":0},{"$f":"AL25","v":0},{"$f":"AM25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Samlede faste udgifter"," -",null,null,{"$f":"AL19+AL23+AL24+AL25","v":{"$error":"#DIV/0!"}},{"$f":"AM19+AM23+AM24+AM25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faste indtægter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Fast bidrag, boligenheder",{"$f":"Overblik!C51","v":0},null,null,{"$f":"$AI$28*AL10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Målerbidrag",{"$f":"Overblik!C52","v":0},null,null,{"$f":"$AI$29*AL9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Samlede faste indtægter"," -",null,null,{"$f":"SUM(AL28:AL29)","v":0},{"$f":"SUM(AM28:AM29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable udgifter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Varmeproduktion til salg",{"$f":"Overblik!C12*(Overblik!C13)","v":0},null,null,{"$f":"AI32","v":0},{"$f":"AL32","v":0},{"$f":"AM32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Varmeproduktion til varmetab",{"$f":"Overblik!C16","v":0},null,null,{"$f":"AI33","v":0},{"$f":"AL33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Varmeproduktionsomkostning",{"$f":"Overblik!D35","v":0},null,null,{"$f":"SUM(AL32:AL33)*$AI$34","v":0},{"$f":"SUM(AM32:AM33)*$AI$34","v":0},{"$f":"SUM(AN32:AN33)*$AI$34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drift og vedligehold, ledningsnet",{"$f":"Overblik!C39","v":0},null,null,{"$f":"$AI$35*(AL32+AL33)","v":0},{"$f":"$AI$35*(AM32+AM33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Samlede variable udgifter"," -",null,null,{"$f":"AL34+AL35","v":0},{"$f":"AM34+AM35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable indtægter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     Variabelt bidrag",{"$f":"Overblik!C50","v":0},null,null,{"$f":"AL32*$AI$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Samlede variable bidrag"," -",null,null,{"$f":"AL38","v":0},{"$f":"AM38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Samlet faste udgifter"," -",null,null,{"$f":"AL30-AL26","v":{"$error":"#DIV/0!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Samlet variable udgifter"," -",null,null,{"$f":"AL39-AL36","v":0},{"$f":"AM39-AM36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultat"," -",null,null,{"$f":"AL41+AL42","v":{"$error":"#DIV/0!"}},{"$f":"AM41+AM42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultat akkumuleret"," -",null,null,{"$f":"AL43","v":{"$error":"#DIV/0!"}},{"$f":"AL44+AM43","v":{"$error":"#DIV/0!"}},{"$f":"AM44+AN43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutidsværdi",{"$f":"Overblik!C46","v":0},null,null,{"$f":"AL43/(1+$AI$46)^AL5","v":{"$error":"#DIV/0!"}},{"$f":"AM43/(1+$AI$46)^AM5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV",{"$f":"SUM(AL46:BE46)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultat (negativt)",null,null,{"$f":"IF(AL43<0,AL43,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AM43<0,AM43,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultat (positivt)",null,null,{"$f":"IF(AL43>0,AL43,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AM43>0,AM43,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]