{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Skift til Fjernvarme","med Investering","Udtrædelse"],"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":"Skift til Fjernvarme","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,5,1,6],[10,0,10,2],[17,0,17,2],[18,0,18,1],[8,5,8,6],[9,5,9,6]]}
["Sammenligning af opvarmnings omkostninger.",null,null,null,null,null,null,null,null,"Ctrl+c"]
[null,null,null,null,"COP","Sæt et X ved jeres opvarmningsform"]
["Forbrug",null,null,null,3,"X"]
["Areal beboelse",130,"m²","Fjernvarme","Varmepumpe","Gas","Olie"]
["Forbrug Mwh",{"$f":"(F8*F12)+(G8*G12)","v":16.000000014400001},"Mwh",{"$f":"L17","v":687.5},2.1,12,12.5]
["Fast bidrag",{"$f":"(_xlfn.IFS(B4<200,L14*B4,B4>199,L14*200,B4>500,L16*B4))+(_xlfn.IFS(B4<200,\"0\",B4=200,L15*(B4-200),B4>200,L15*(B4-200)))","v":4712.5},"kr.",{"$f":"B6","v":4712.5},"Dags pris","Dags pris","Dags pris"]
["Enheder",null,null,"Mwh","Kwh","m³","L"]
["Produceret Mvh:",null,null,{"$f":"D9","v":16.000000014400001},{"$f":"D8","v":16.000000014400001},{"$f":"F9*10/1000","v":16},{"$f":"F9*9/1000","v":14.4}]
["Forbrug pr. år",null,null,{"$f":"B5","v":16.000000014400001},{"$f":"E8/E3","v":5.3333333381333334},1600]
["Investering ved indtrædelse i SHKV fjernvarme:",null,null,null,null,"Skriv forbrug i M³ gas eller L. olie."]
["Indmeldelses gebyr",null,null,25000,null,0,0]
[null,null,null,null,null,{"$f":"IF(F3=\"X\",1,0.000000001)","v":1},{"$f":"IF(G3=\"X\",1,0.000000001)","v":1.0000000000000001E-9}]
["Varmekilde",null,null,"Fjernvarme",null,"Gaskedel","Oliefyr",null,null,"Fjernvarme tariffer",null,"m. Moms"]
["Energi køb",null,null,{"$f":"D5*B5+D6","v":15712.500009900001},{"$f":"E9*E5*1000","v":11200.000010080001},{"$f":"F5*F9","v":19200},{"$f":"G5*F9","v":20000},null,null,"Fastafgift","0-199 m²",{"$f":"29*1.25","v":36.25},null,"De første 200m2"]
["Måleleje",null,null,{"$f":"L20","v":2500},null,0,0,null,null,"Bolig:","200-499 m²",{"$f":"14.5*1.25","v":18.125},null,"200->499m2"]
["Skorstensfejer",null,null,0,null,null,2000]
["Ekstra strømforbrug",null,null,null,null,300,300,null,null,"Forbrug","Mwh",{"$f":"550*1.25","v":687.5}]
["Vedligeholdelse",null,null,0,2000,2500,2500,null,null,null,"m³",0]
["Unit leje                               Ja/Nej",null,"Nej",{"$f":"L19*C24","v":2.3875E-6},null,null,null,null,null,"Unit","Leasing",{"$f":"1910*1.25","v":2387.5}]
["Samlet pris pr. år for opvarmning:",null,null,{"$f":"SUM(D14:D18)+D19","v":18212.500012287503},{"$f":"SUM(E14:E18)","v":13200.000010080001},{"$f":"SUM(F14:F18)","v":22000},{"$f":"SUM(G14:G18)","v":24800},null,null,"Måler","Leje",2500]
[]
["Investering i ny varme kilde:",null,null,{"$f":"'med Investering'!D13","v":25000},{"$f":"'med Investering'!E13","v":85000},{"$f":"'med Investering'!G13","v":50000},{"$f":"'med Investering'!H13","v":50000}]
[]
[null,null,{"$f":"IF(C19=\"Ja\",1,0.000000001)","v":1.0000000000000001E-9}]
[null,null,{"$f":"IF(C23=\"Ja\",1,0.000000001)","v":1.0000000000000001E-9}]

{"sheet":"med Investering","index":1,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[10,0,10,2],[11,0,11,2]]}
["Sammenligning af opvarmnings omkostninger."]
["Forbrug",null,null,"Priser:","er alle med moms"]
["Areal beboelse",{"$f":"'Skift til Fjernvarme'!B4","v":130},"m²","Fjernvarme","El / Kwh","Træpiller","Gas","Olie",null,null,"Fjernvarme tariffer",null,"m. Moms"]
["Forbrug Mwh",{"$f":"'Skift til Fjernvarme'!B5","v":16.000000014400001},"Mwh",{"$f":"'Skift til Fjernvarme'!L17","v":687.5},{"$f":"'Skift til Fjernvarme'!E5","v":2.1},2,{"$f":"'Skift til Fjernvarme'!F5","v":12},{"$f":"'Skift til Fjernvarme'!G5","v":12.5},null,null,"Fastafgift",{"$f":"'Skift til Fjernvarme'!K14","v":"0-199 m²"},6800]
[null,null,null,null,"Sidste 30 dage","Dags pris","Dags pris","Dags pris",null,null,"Bolig:",{"$f":"'Skift til Fjernvarme'!K15","v":"200-499 m²"},7000]
["Fast bidrag",{"$f":"'Skift til Fjernvarme'!B6","v":4712.5},"kr.",{"$f":"B6","v":4712.5},"COP Værdi",null,null,null,null,null,null,null,7200]
["Enheder",null,null,"Mwh",3,"Kg","m³","L",null,null,"Forbrug","Mwh",937.5]
["Forbrug pr produceret Mvh:",null,null,1,{"$f":"D8/E7","v":0.33333333333333331},240,100,{"$f":"1/0.9*100","v":111.11111111111111},null,null,null,"m³",3.75]
["Forbrug pr. år",null,null,{"$f":"B4","v":16.000000014400001},{"$f":"D9*E8","v":5.3333333381333334},{"$f":"D9*F8","v":3840.0000034560003},{"$f":"'Skift til Fjernvarme'!F9","v":1600},{"$f":"'Skift til Fjernvarme'!F9","v":1600},null,null,"Måler","Leje",{"$f":"'Skift til Fjernvarme'!L20","v":2500}]
["Investering for ny varmekilde:",null,null,"Fjernvarme","Varmepumpe","Pillefyr","Gaskedel","Oliefyr"]
[null,null,null,{"$f":"C11","v":0},0,0,{"$f":"E11","v":0},{"$f":"F11","v":0},null,null,"Udtrædelsesgebyr:"]
[null,null,null,0,0,0,{"$f":"E12","v":0},{"$f":"F12","v":0},null,null,null,"0-99 m²",16356]
["Ny varmekilde","Kw behov",{"$f":"H9*8/1064*0.6","v":7.2180451127819545},25000,85000,60000,50000,50000,null,null,null,"100-169 m²",25607]
["Samlede investering for varmekilde:",null,null,{"$f":"D11+D12+D13","v":25000},{"$f":"E11+E12+E13","v":85000},{"$f":"F11+F12+F13","v":60000},50000,50000,null,null,null,"170-400m²",43599]
[]
["Varmekilde",null,null,"Fjernvarme","Varmepumpe","Pillefyr","Gaskedel","Oliefyr"]
["Energi køb",null,null,{"$f":"D4*B4+D5*B5+D6","v":15712.500009900001},{"$f":"B4*E4*E8*1000","v":11200.000010080001},{"$f":"F9*F4","v":7680.0000069120006},{"$f":"G4*G9","v":19200},{"$f":"H4*H9","v":20000},null,null,"Info vedr COP værdi på varmepumper:"]
["Måleleje",null,null,{"$f":"'Skift til Fjernvarme'!L20","v":2500},0,0,0,0,null,null,"1. For luft til vand varmepumper forudsætter man en "]
["Skorstensfejer",null,null,0,0,2000,null,2000,null,null,"udendørstemperatur på 7 grader og ligeledes en "]
["Ekstra strømforbrug",null,null,null,0,800,300,300,null,null,"fremløbstemperatur på 45 grader"]
["Vedligeholdelse",null,null,375,2000,2000,{"$f":"'Skift til Fjernvarme'!F18","v":2500},{"$f":"'Skift til Fjernvarme'!G18","v":2500}]
["Samlet pris pr. år for opvarmning:",null,null,{"$f":"SUM(D17:D21)","v":18587.500009900003},{"$f":"SUM(E17:E21)","v":13200.000010080001},12480.000006912,22000,{"$f":"SUM(H17:H21)","v":24800},null,null,"2.  Bedste udnyttelse ved gulvarme, eller ekstra store"]
["Tilbagebetaling.",null,null,null,null,null,null,null,null,null,"radiatore, så høj fremløbs temperatur undgås."]
["Investering",null,null,{"$f":"D13","v":25000},{"$f":"E11+E12+E13","v":85000},{"$f":"F11+F12+F13","v":60000},{"$f":"G11+G12+G13","v":50000},{"$f":"H11+H12+H13","v":50000}]
["Besparelse",null,null,0,{"$f":"D22-E22","v":5387.4999998200019},{"$f":"D22-F22","v":6107.500002988003},{"$f":"D22-G22","v":-3412.4999900999974},{"$f":"E22-H22","v":-11599.999989919999},null,null,"3. Middel levetid 12-13 År, De bedste op mod 20 år,"]
["Simpel tilbagebetaling",null,null,"År",{"$f":"E24/E25","v":15.777262181501602},{"$f":"F24/F25","v":9.8239868965445591},{"$f":"G24/G25","v":-14.652014694521608},{"$f":"H24/H25","v":-4.3103448313317481},null,null,"gennemsnitsstørrelse."]
["Tilbagebetaling incl. financering"]
["Egen financering",null,null,null,0,0,0,0,null,null,"Info hentet fra hjemmesiden Varmepumpefakta.dk"]
["Nødvendig lånebeløb",null,null,null,{"$f":"E24-E28+0.00001","v":85000.000010000003},{"$f":"F24-F28+0.00001","v":60000.000010000003},{"$f":"G24-G28+0.00001","v":50000.000010000003},{"$f":"H24-H28+0.00001","v":50000.000010000003}]
["Låne periode, antal måneder",null,null,null,24,24,24,24]
["Forentning af banklån %",null,null,null,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2]
["Renteudgift i perioden",null,null,null,{"$f":"-(CUMIPMT(E31/12,E30,E29,1,E30,0))","v":4041.5355667256954},{"$f":"-(CUMIPMT(F31/12,F30,F29,1,F30,0))","v":2852.8486354756315},{"$f":"-(CUMIPMT(G31/12,G30,G29,1,G30,0))","v":2377.3738629756117},{"$f":"-(CUMIPMT(H31/12,H30,H29,1,H30,0))","v":2377.3738629756117}]
["Samlede investering incl renter",null,null,null,{"$f":"E29+E32","v":89041.535576725699},{"$f":"F29+F32","v":62852.848645475635},{"$f":"G29+G32","v":52377.373872975615},{"$f":"H29+H32","v":52377.373872975615}]
["Besparelse",null,null,null,{"$f":"E25","v":5387.4999998200019},{"$f":"F25","v":6107.500002988003},{"$f":"G25","v":-3412.4999900999974},{"$f":"H25","v":-11599.999989919999}]
["Tilbagebetalingstid incl. forrentning",null,null,"År",{"$f":"(E33/E25)+(E28/E25)","v":16.52743119808828},{"$f":"(F33/F25)+(F28/F25)","v":10.291092691727519},{"$f":"(G33/G25)+(G28/G25)","v":-15.348681032945816},{"$f":"(H33/H25)+(H28/H25)","v":-4.5152908550422195}]

{"sheet":"Udtrædelse","index":2,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[[10,0,10,2],[11,0,11,2]]}
["Sammenligning af opvarmnings omkostninger."]
["Forbrug",null,null,"Priser:","er alle med moms"]
["Areal beboelse",130,"m²","Fjernvarme","El / Kwh","Træpiller","Gas","Olie",null,null,"Fjernvarme tariffer",null,"m. Moms"]
["Forbrug Mwh",18,"Mwh",{"$f":"M7","v":937.5},2.42,2.9,{"$f":"4.46+3.42","v":7.88},12.5,null,null,"Fastafgift","0-99 m²",6800]
["Forbrug m³",435,"m³",{"$f":"M8","v":3.75},"Sidste 30 dage","Dags pris","Dags pris","Dags pris",null,null,"Bolig:","100-169 m²",7000]
["Fast bidrag",{"$f":"_xlfn.IFS(B3<100,M4,B3<170,M5,B3>169,M6)","v":7000},"kr.",{"$f":"B6","v":7000},"COP Værdi",null,null,null,null,null,null,"170-400m²",7200]
["Enheder",null,null,"Mwh",2.5,"Kg","m³","L",null,null,"Forbrug","Mwh",937.5]
["Forbrug pr produceret Mvh:",null,null,1,{"$f":"D8/E7","v":0.4},240,100,{"$f":"1/0.9*100","v":111.11111111111111},null,null,null,"m³",3.75]
["Forbrug pr. år",null,null,{"$f":"B4","v":18},{"$f":"D9*E8","v":7.2},{"$f":"D9*F8","v":4320},{"$f":"D9*G8","v":1800},{"$f":"D9*H8","v":2000},null,null,"Måler","Leje",500]
["Investering ved udtrædelse af SHKV fjernvarme i:",null,null,null,"Varmepumpe","Pillefyr","Gaskedel","Oliefyr"]
["Udtrædelses gebyr:",null,null,{"$f":"_xlfn.IFS(B3<100,M12,B3<170,M13,B3>169,M14)","v":25607},{"$f":"D11","v":25607},{"$f":"E11","v":25607},{"$f":"E11","v":25607},{"$f":"F11","v":25607},null,null,"Udtrædelsesgebyr:"]
["Omkostning for afkobling:",null,null,30000,{"$f":"D12","v":30000},{"$f":"E12","v":30000},{"$f":"E12","v":30000},{"$f":"F12","v":30000},null,null,null,"0-99 m²",16356]
["Ny varmekilde","behov",{"$f":"H9*8/1064*0.6","v":9.022556390977444},"Kw",85000,55000,50000,50000,null,null,null,"100-169 m²",25607]
["Samlede investering for skift af varmekilde:",null,null,null,{"$f":"E11+E12+E13","v":140607},{"$f":"F11+F12+F13","v":110607},105607,105607,null,null,null,"170-400m²",43599]
[]
["Varmekilde",null,null,"Fjernvarme","Varmepumpe","Pillefyr","Gaskedel","Oliefyr"]
["Energi køb",null,null,{"$f":"D4*B4+D5*B5+D6","v":25506.25},{"$f":"B4*E4*E8*1000","v":17424.000000000004},{"$f":"F9*F4","v":12528},{"$f":"G4*G9","v":14184},{"$f":"H4*H9","v":25000},null,null,"Info vedr COP værdi på varmepumper:"]
["Måleleje",null,null,{"$f":"M9","v":500},0,0,0,0,null,null,"1. For luft til vand varmepumper forudsætter man en "]
["Skorstensfejer",null,null,0,0,2000,2000,2000,null,null,"udendørstemperatur på 7 grader og ligeledes en "]
["Ekstra strømforbrug",null,null,null,0,800,300,300,null,null,"fremløbstemperatur på 45 grader"]
["Vedligeholdelse",null,null,0,2000,2000,1500,1500]
["Samlet pris pr. år for opvarmning:",null,null,{"$f":"SUM(D17:D21)","v":26006.25},{"$f":"SUM(E17:E21)","v":19424.000000000004},17328,17984,28800,null,null,"2.  Bedste udnyttelse ved gulvarme, eller ekstra store"]
["Tilbagebetaling.",null,null,null,null,null,null,null,null,null,"radiatore, så høj fremløbs temperatur undgås."]
["Investering",null,null,{"$f":"D13","v":"Kw"},{"$f":"E11+E12+E13","v":140607},{"$f":"F11+F12+F13","v":110607},{"$f":"G11+G12+G13","v":105607},{"$f":"H11+H12+H13","v":105607}]
["Besparelse",null,null,0,{"$f":"D22-E22","v":6582.2499999999964},{"$f":"D22-F22","v":8678.25},{"$f":"D22-G22","v":8022.25},{"$f":"E22-H22","v":-9375.9999999999964},null,null,"3. Middel levetid 12-13 År, De bedste op mod 20 år,"]
["Simpel tilbagebetaling",null,null,"År",{"$f":"E24/E25","v":21.361540506665666},{"$f":"F24/F25","v":12.745311554748941},{"$f":"G24/G25","v":13.164261896600081},{"$f":"H24/H25","v":-11.263545221843009},null,null,"gennemsnitsstørrelse."]
["Tilbagebetaling incl. financering"]
["Egen financering",null,null,null,0,0,0,0,null,null,"Info hentet fra hjemmesiden Varmepumpefakta.dk"]
["Nødvendig lånebeløb",null,null,null,{"$f":"E24-E28+0.00001","v":140607.00000999999},{"$f":"F24-F28+0.00001","v":110607.00001},{"$f":"G24-G28+0.00001","v":105607.00001},{"$f":"H24-H28+0.00001","v":105607.00001}]
["Låne periode, antal måneder",null,null,null,24,24,24,24]
["Forentning af banklån %",null,null,null,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2]
["Renteudgift i perioden",null,null,null,{"$f":"-(CUMIPMT(E31/12,E30,E29,1,E30,0))","v":6685.5081341666228},{"$f":"-(CUMIPMT(F31/12,F30,F29,1,F30,0))","v":5259.0838166665199},{"$f":"-(CUMIPMT(G31/12,G30,G29,1,G30,0))","v":5021.34643041651},{"$f":"-(CUMIPMT(H31/12,H30,H29,1,H30,0))","v":5021.34643041651}]
["Samlede investering incl renter",null,null,null,{"$f":"E29+E32","v":147292.50814416661},{"$f":"F29+F32","v":115866.08382666652},{"$f":"G29+G32","v":110628.34644041651},{"$f":"H29+H32","v":110628.34644041651}]
["Besparelse",null,null,null,{"$f":"E25","v":6582.2499999999964},{"$f":"F25","v":8678.25},{"$f":"G25","v":8022.25},{"$f":"H25","v":-9375.9999999999964}]
["Tilbagebetalingstid incl. forrentning",null,null,"År",{"$f":"(E33/E25)+(E28/E25)","v":22.377227869522837},{"$f":"(F33/F25)+(F28/F25)","v":13.351318967149659},{"$f":"(G33/G25)+(G28/G25)","v":13.790189340947554},{"$f":"(H33/H25)+(H28/H25)","v":-11.799098383150231}]