{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Priser årsbasis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"Priser årsbasis","index":0,"n_rows":118,"n_cols":22,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Princip 1: Ejendom med kun varmefordelingsmålere"]
[]
[null,null,"Regning fra varmeværk",100000,"Kr.","Korrektion energi","ja"]
[null,null,null,null,null,"Korrektion m2",null,null,null,null,null,null,null,null,null,null,null,null,null,"ja","ja","ja"]
[null,null,"Heraf faste afgifter",40000,"Kr.","Energi + m2"]
[]
[null,null,"Totalt varmeforbrug (hovedvarmemåler)",120,"MWh","Kontrol 40/60"]
[null,null,null,null,null,{"$f":"(F67+F68)/(D5-D7)*100","v":58.692499999161541}]
[null,null,"Antal lejligheder",10,"stk.",{"$f":"SUM(F67:F68)/(D5-D7-D27*D42)*100","v":84.999999998785725}]
[null,null,null,"Uden korr.","Med korr.","Prisforhold"]
[null,null,"Boligareal, sum m2 og m2 korrigeret",822,780,{"$f":"E57/D42*100","v":100}]
[]
[null,null,"Værelseshaneandele (VHA)",0,"stk."]
[]
[null,null,"Antal beboere",30,"stk."]
[]
[null,null,"Cirkulationstab pr. lejlighed",150,"W"]
[]
[null,null,"Sum af varmtvandsmålere m3",0,"m3"]
[]
[null,null,"Skønnet opvarmning af varmt brugsvand",35,"°K"]
[]
[null,null,"% af rumvarme til varmetab og opv. af fælleslokaler",15,"%"]
[]
[null,null,"Måler/skøn på varmtvandsbeholders primærside",{"$f":"D17*0.8+D11*D19/1000*8760/1000","v":37.14},"MWh"]
[]
[null,null,null,"Uden korr.","Med korr."]
[null,null,"Talte enheder MWh aflæst på energimålere (gulv eller hele lejli",null,null,"MWh"]
[]
[null,null,"Talte enheder rad. mål (dimensionsløs) sum",80000,70000,"-"]
[]
[null,null,"Gulvvarme uden målere sum m2 (gulvareal)",null,null,"-"]
[]
[null,null,"Antaget MWh pr år pr m2 gulvvarme",0.2,"MWh"]
[]
[null,null,"Rumvarme efter m2 %",0,"%"]
[]
[null,null,"Gennemsnitspris pr. MWh",{"$f":"D5/D9","v":833.33333333333337},"kr./MWh"]
[]
[null,null,"Marginalpris pr. MWh",{"$f":"(D5-D7)/D9","v":500},"kr./MWh"]
[]
[]
[]
[]
[null,null,"Beregning af energibalance og fordelingbeløb"]
[]
[null,null,null,"MWh","Marg.pris","Kr",null,"m2 rumv",{"$f":"F55+F58","v":6214.5},{"$f":"I49/(I49+I50)*100","v":15},{"$f":"J49/100","v":0.15}]
[null,null,"Nettoforbrug Varmt vand",{"$f":"1.16*D23*D21/1000","v":0},{"$f":"D42","v":500},{"$f":"D50*E50","v":0},null,"energi rumv",{"$f":"F54+F57+F56","v":35215.5},{"$f":"I50/(I49+I50)*100","v":85}]
[null,null,"Cirkulation, beholdertab og opvarmning af vandet",{"$f":"D27-D50","v":37.14},{"$f":"E50","v":500},{"$f":"D51*E51","v":18570},null,"m2 rumv/totrumv",{"$f":"I49/(I49+I50)*100","v":15}]
[null,null,"Samlet bygningsvarme E1-E2, E2 skønnet",{"$f":"D9-D27","v":82.86}]
[]
[null,null,"Rumvarme MWh efter målere",{"$f":"D30","v":0},{"$f":"$D$42*(1-D38/100)","v":500},0]
[null,null,"Varmetab og fælleslokaler",{"$f":"D25*D52/100","v":12.429},{"$f":"D42","v":500},6214.5]
[null,null,"Gulvvarme uden måler",{"$f":"D34*D36","v":0},{"$f":"E54","v":500},{"$f":"D56*E56","v":0}]
[null,null,"Rumvarme efter varmefordelingsmålere",{"$f":"D52-D30-D55-D56","v":70.430999999999997},{"$f":"$D$42*(1-D38/100)","v":500},35215.5]
[null,null,"Rumvarme efter m2",{"$f":"D38/100*(D57+D54+D56)","v":0},{"$f":"D42","v":500},0]
[null,null,"I alt",null,null,{"$f":"SUM(F50:F58)","v":60000}]
[null,null,"Fast afgift værk",null,null,{"$f":"D7","v":40000}]
[null,null,"Regning i alt",null,null,{"$f":"SUM(F59:F60)","v":100000}]
[]
[null,null,"Enhedspriser","Enheder","Kr/enhed","I alt"]
[null,null,"Varmtvandsmåler (m3)",{"$f":"D21","v":0},{"$f":"IF(D21=0,0,F50/D21)","v":0},{"$f":"D64*E64","v":0}]
[null,null,"Varmetab VVB og cirkulation (m2)",{"$f":"D13","v":822},{"$f":"F51/D13","v":22.591240875912408},{"$f":"D65*E65","v":18570}]
[null,null,"Rumvarme (m2)",{"$f":"E13","v":780},{"$f":"F58/D66","v":0},{"$f":"D66*E66","v":0}]
[null,null,"Rumvarme (MWh)",{"$f":"E30","v":0},{"$f":"F54/(D67+0.000001)","v":0},{"$f":"D67*E67","v":0}]
[null,null,"Rumvarme VFM",{"$f":"E32","v":70000},{"$f":"F57/(D68+0.000001)","v":0.50307857142138468},{"$f":"D68*E68","v":35215.499999496926}]
[null,null,"Gulvarme uden måler",{"$f":"E34","v":0},{"$f":"IF(F56=0,0,F56/D69)","v":0},{"$f":"D69*E69","v":0}]
[null,null,"Varmetab i varmesystem og varme i fællesareal (m2)",{"$f":"E13","v":780},{"$f":"F55/D70","v":7.967307692307692},{"$f":"D70*E70","v":6214.5}]
[null,null,"Fast afgift værk (m2)",{"$f":"D13","v":822},{"$f":"F60/D13","v":48.661800486618006},{"$f":"D71*E71","v":40000}]
[null,null,"I alt m2 pris",null,{"$f":"E65+E66+E70+E71","v":79.22034905483811},{"$f":"SUM(F64:F71)","v":99999.999999496926}]
[]
[]
[]
[]
[null,null,"Varmeregninger"]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,"middel forbrug","Enheder","Pris","Korrektion","Beløb inkl moms",20,{"$f":"H79","v":20},{"$f":"(9.4*$K$49^2-13.5*$K$49+5.34)*I79","v":70.53},{"$f":"$J$50/100*I79","v":17}]
[null,null,{"$f":"C71","v":"Fast afgift værk (m2)"},80,{"$f":"$E$71","v":48.661800486618006},null,{"$f":"D80*E80*(100-F80)/100","v":3892.9440389294405}]
[null,null,{"$f":"C70","v":"Varmetab i varmesystem og varme i fællesareal (m2)"},{"$f":"D80","v":80},{"$f":"$E$70","v":7.967307692307692},{"$f":"(IF($G$5=\"ja\",0)+IF($G$6=\"ja\",J79)+IF($G$7=\"ja\",K79))","v":0},{"$f":"D81*E81*(100-F81)/100","v":637.38461538461536}]
[null,null,{"$f":"C68","v":"Rumvarme VFM"},7800,{"$f":"$E$68","v":0.50307857142138468},{"$f":"(IF($G$5=\"ja\",I79)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K79))","v":20},3139.2102856694405]
[null,null,{"$f":"C67","v":"Rumvarme (MWh)"},0,{"$f":"$E$67","v":0},{"$f":"F82","v":20},0]
[null,null,{"$f":"C65","v":"Varmetab VVB og cirkulation (m2)"},{"$f":"D80","v":80},{"$f":"$E$65","v":22.591240875912408},null,{"$f":"D84*E84*(100-F84)/100","v":1807.2992700729926}]
[null,null,{"$f":"C66","v":"Rumvarme (m2)"},{"$f":"D80","v":80},{"$f":"$E$66","v":0},{"$f":"F81","v":0},{"$f":"D85*E85*(100-F85)/100","v":0}]
[null,null,{"$f":"C64","v":"Varmtvandsmåler (m3)"},0,{"$f":"$E$64","v":0},null,{"$f":"D86*E86*(100-F86)/100","v":0}]
[null,null,{"$f":"C69","v":"Gulvarme uden måler"},0,{"$f":"$E$69","v":0},{"$f":"F82","v":20},{"$f":"D87*E87*(100-F87)/100","v":0}]
[]
[null,null,null,null,null,null,null,null,"rumvarme"]
[null,null,null,null,null,"I alt",{"$f":"SUM(G80:G89)","v":9476.8382100564886},null,{"$f":"G82+G83+G81+G85+G87","v":3776.5949010540558}]
[]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,"stort forbrug","Enheder","Pris","Korrektion","Beløb inkl moms",20,{"$f":"H93","v":20},{"$f":"(9.4*$K$49^2-13.5*$K$49+5.34)*I93","v":70.53},{"$f":"$J$50/100*I93","v":17}]
[null,null,{"$f":"C80","v":"Fast afgift værk (m2)"},80,{"$f":"$E$71","v":48.661800486618006},null,{"$f":"D94*E94*(100-F94)/100","v":3892.9440389294405}]
[null,null,{"$f":"C81","v":"Varmetab i varmesystem og varme i fællesareal (m2)"},{"$f":"D94","v":80},{"$f":"$E$70","v":7.967307692307692},{"$f":"(IF($G$5=\"ja\",0)+IF($G$6=\"ja\",J93)+IF($G$7=\"ja\",K93))","v":0},{"$f":"D95*E95*(100-F95)/100","v":637.38461538461536}]
[null,null,"Rumvarme VFM",{"$f":"D82*1.3","v":10140},{"$f":"$E$68","v":0.50307857142138468},{"$f":"(IF($G$5=\"ja\",I93)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K93))","v":20},4080.9733713702731]
[null,null,"Rumvarme (MWh)",0,{"$f":"$E$67","v":0},{"$f":"F96","v":20},0]
[null,null,"Varmetab VVB og cirkulation (m2)",{"$f":"D80","v":80},{"$f":"$E$65","v":22.591240875912408},null,1807.2992700729926]
[null,null,"Rumvarme (m2)",{"$f":"D94","v":80},{"$f":"$E$66","v":0},{"$f":"F95","v":0},{"$f":"D99*E99*(100-F99)/100","v":0}]
[null,null,"Varmtvandsmåler (m3)",0,{"$f":"$E$64","v":0},null,{"$f":"D100*E100*(100-F100)/100","v":0}]
[null,null,{"$f":"C69","v":"Gulvarme uden måler"},0,{"$f":"$E$69","v":0},{"$f":"F96","v":20},{"$f":"D101*E101*(100-F101)/100","v":0}]
[]
[null,null,null,null,null,null,null,null,"rumvarme"]
[null,null,null,null,null,"I alt",{"$f":"SUM(G94:G103)","v":10418.60129575732},null,{"$f":"G96+G97+G95+G99+G101","v":4718.3579867548888},{"$f":"I104/I90","v":1.2493683093831389}]
[]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,"lille forbrug","Enheder","Pris","Korrektion","Beløb inkl moms",20,{"$f":"H107","v":20},{"$f":"(9.4*$K$49^2-13.5*$K$49+5.34)*I107","v":70.53},{"$f":"$J$50/100*I107","v":17}]
[null,null,"Fast afgift værk (m2)",80,{"$f":"$E$71","v":48.661800486618006},null,{"$f":"D108*E108*(100-F108)/100","v":3892.9440389294405}]
[null,null,"Varmetab i varmesystem og varme i fællesareal (m2)",{"$f":"D108","v":80},{"$f":"$E$70","v":7.967307692307692},{"$f":"(IF($G$5=\"ja\",0)+IF($G$6=\"ja\",J107)+IF($G$7=\"ja\",K107))","v":0},{"$f":"D109*E109*(100-F109)/100","v":637.38461538461536}]
[null,null,"Rumvarme VFM",3900,{"$f":"$E$68","v":0.50307857142138468},{"$f":"(IF($G$5=\"ja\",I107)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K107))","v":20},1569.6051428347203]
[null,null,"Rumvarme (MWh)",0,{"$f":"$E$67","v":0},{"$f":"F110","v":20},0]
[null,null,"Varmetab VVB og cirkulation (m2)",{"$f":"D80","v":80},{"$f":"$E$65","v":22.591240875912408},null,1807.2992700729926]
[null,null,"Rumvarme (m2)",{"$f":"D108","v":80},{"$f":"$E$66","v":0},{"$f":"F109","v":0},{"$f":"D113*E113*(100-F113)/100","v":0}]
[null,null,"Varmtvandsmåler (m3)",0,{"$f":"$E$64","v":0},null,{"$f":"D114*E114*(100-F114)/100","v":0}]
[null,null,"Gulvarme uden måler",0,{"$f":"$E$69","v":0},{"$f":"F110","v":20},{"$f":"D115*E115*(100-F115)/100","v":0}]
[]
[null,null,null,null,null,null,null,null,"rumvarme"]
[null,null,null,null,null,"I alt",{"$f":"SUM(G108:G117)","v":7907.2330672217686},null,{"$f":"G110+G111+G109+G113+G115","v":2206.9897582193357},{"$f":"I118/I90","v":0.5843861510281021}]