{"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 5: Ejendom med blanding af varmenergimålere og radiatormålere,  varmeenergimåler på varmtvandsbeholderens fjernvarmeside, varmtvandsmå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",20000,"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":60.749999999999993}]
[null,null,"Antal lejligheder",0,"stk.",{"$f":"SUM(F67:F68)/(D5-D7-D27*D42)*100","v":80.999999999999986}]
[null,null,null,"Uden korr.","Med korr.","Prisforhold"]
[null,null,"Boligareal, sum m2 og m2 korrigeret",822,822,{"$f":"E54/D42*100","v":100}]
[]
[null,null,"Værelseshaneandele (VHA)",110]
[]
[null,null,"Antal beboere",0,"stk."]
[]
[null,null,"Cirkulationstab pr. lejlighed",0,"W"]
[]
[null,null,"Sum af varmtvandsmålere m3",270,"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",30,"MWh"]
[]
[null,null,null,"Uden korr.","Med korr."]
[null,null,"Talte enheder MWh aflæst på energimålere (gulv eller hele lejli",42,39]
[]
[null,null,"Talte enheder rad. mål (dimensionsløs) sum",43000,40000,"-"]
[]
[null,null,"Gulvvarme uden målere sum m2 (gulvareal)",18,6,"-"]
[]
[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":666.66666666666663},"kr./MWh"]
[]
[]
[]
[]
[null,null,"Beregning af energibalance og fordelingbeløb"]
[]
[null,null,null,"MWh","Marg.pris","Kr",null,"m2 rumv",{"$f":"F55+F58","v":9000},{"$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":10.961999999999998},{"$f":"D42","v":666.66666666666663},{"$f":"D50*E50","v":7307.9999999999982},null,"energi rumv",{"$f":"F54+F57+F56","v":51000},{"$f":"I50/(I49+I50)*100","v":85}]
[null,null,"Cirkulation og beholdertab",{"$f":"D27-D50","v":19.038000000000004},{"$f":"E50","v":666.66666666666663},{"$f":"D51*E51","v":12692.000000000002},null,"m2 rumv/totrumv",{"$f":"I49/I50*100","v":17.647058823529413}]
[null,null,"Samlet bygningsvarme E1-E2",{"$f":"D9-D27","v":90}]
[]
[null,null,"Rumvarme MWh efter målere",{"$f":"D30","v":42},{"$f":"$D$42*(1-D38/100)","v":666.66666666666663},28000]
[null,null,"Varmetab og fælleslokaler",{"$f":"D25/100*D52","v":13.5},{"$f":"D42","v":666.66666666666663},9000]
[null,null,"Gulvvarme uden måler",{"$f":"D34*D36","v":3.6},{"$f":"E54","v":666.66666666666663},{"$f":"D56*E56","v":2400}]
[null,null,"Rumvarme efter varmefordelingsmålere",{"$f":"D52-D30-D55-D56","v":30.9},{"$f":"$D$42*(1-D38/100)","v":666.66666666666663},20599.999999999996]
[null,null,"Rumvarme efter m2",{"$f":"D38/100*(D57+D54+D56)","v":0},{"$f":"D42","v":666.66666666666663},0]
[null,null,"I alt",null,null,{"$f":"SUM(F50:F58)","v":80000}]
[null,null,"Fast afgift værk",null,null,{"$f":"D7","v":20000}]
[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":270},{"$f":"IF(D21=0,0,F50/D21)","v":27.066666666666659},{"$f":"D64*E64","v":7307.9999999999982}]
[null,null,"Varmetab VVB og cirkulation (m2)",{"$f":"D13","v":822},{"$f":"F51/D13","v":15.440389294403895},{"$f":"D65*E65","v":12692.000000000002}]
[null,null,"Rumvarme (m2)",{"$f":"E13","v":822},{"$f":"F58/D66","v":0},{"$f":"D66*E66","v":0}]
[null,null,"Rumvarme (MWh)",{"$f":"E30","v":39},{"$f":"F54/D67","v":717.9487179487179},{"$f":"D67*E67","v":27999.999999999996}]
[null,null,"Rumvarme VFM",{"$f":"E32","v":40000},{"$f":"F57/D68","v":0.5149999999999999},{"$f":"D68*E68","v":20599.999999999996}]
[null,null,"Gulvarme uden måler",{"$f":"E34","v":6},{"$f":"IF(F56=0,0,F56/D69)","v":400},{"$f":"D69*E69","v":2400}]
[null,null,"Varmetab i varmesystem og varme i fællesareal (m2)",{"$f":"E13","v":822},{"$f":"F55/D70","v":10.948905109489051},{"$f":"D70*E70","v":9000}]
[null,null,"Fast afgift værk (m2)",{"$f":"D13","v":822},{"$f":"F60/D13","v":24.330900243309003},{"$f":"D71*E71","v":20000}]
[null,null,"I alt m2 pris",null,{"$f":"E65+E66+E70+E71","v":50.72019464720195},{"$f":"SUM(F64:F71)","v":100000}]
[]
[]
[]
[]
[null,null,"Varmeregninger"]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,"Lejlighed med energimåler","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":24.330900243309003},null,{"$f":"D80*E80*(100-F80)/100","v":1946.4720194647202}]
[null,null,{"$f":"C70","v":"Varmetab i varmesystem og varme i fællesareal (m2)"},80,{"$f":"$E$70","v":10.948905109489051},{"$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":875.91240875912399}]
[null,null,{"$f":"C68","v":"Rumvarme VFM"},0,{"$f":"$E$68","v":0.5149999999999999},{"$f":"(IF($G$5=\"ja\",I79)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K79))","v":20},0]
[null,null,{"$f":"C67","v":"Rumvarme (MWh)"},7.2,{"$f":"$E$67","v":717.9487179487179},{"$f":"F82","v":20},4135.3846153846152]
[null,null,{"$f":"C65","v":"Varmetab VVB og cirkulation (m2)"},80,{"$f":"$E$65","v":15.440389294403895},null,{"$f":"D84*E84*(100-F84)/100","v":1235.2311435523116}]
[null,null,{"$f":"C66","v":"Rumvarme (m2)"},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)"},30,{"$f":"$E$64","v":27.066666666666659},null,{"$f":"D86*E86*(100-F86)/100","v":811.99999999999966}]
[null,null,{"$f":"C69","v":"Gulvarme uden måler"},0,{"$f":"$E$69","v":400},{"$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":9005.000187160771},null,{"$f":"G82+G83+G81+G85+G87","v":5011.2970241437397}]
[]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,"Forbruger 2","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)"},100,{"$f":"$E$71","v":24.330900243309003},null,{"$f":"D94*E94*(100-F94)/100","v":2433.0900243309002}]
[null,null,{"$f":"C81","v":"Varmetab i varmesystem og varme i fællesareal (m2)"},100,{"$f":"$E$70","v":10.948905109489051},{"$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":1094.8905109489051}]
[null,null,"Rumvarme VFM",7000,{"$f":"$E$68","v":0.5149999999999999},{"$f":"(IF($G$5=\"ja\",I93)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K93))","v":20},2883.9999999999995]
[null,null,"Rumvarme (MWh)",2,{"$f":"$E$67","v":717.9487179487179},{"$f":"F96","v":20},1148.7179487179485]
[null,null,{"$f":"C65","v":"Varmetab VVB og cirkulation (m2)"},80,{"$f":"$E$65","v":15.440389294403895},null,1235.2311435523116]
[null,null,"Rumvarme (m2)",100,{"$f":"$E$66","v":0},{"$f":"F95","v":0},{"$f":"D99*E99*(100-F99)/100","v":0}]
[null,null,"Varmtvandsmåler (m3)",35,{"$f":"$E$64","v":27.066666666666659},null,{"$f":"D100*E100*(100-F100)/100","v":947.33333333333303}]
[null,null,{"$f":"C69","v":"Gulvarme uden måler"},0,{"$f":"$E$69","v":400},{"$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":9743.2629608833959},null,{"$f":"G96+G97+G95+G99+G101","v":5127.6084596668534},{"$f":"I104/I90","v":1.0232098466649933}]
[]
[null,null,null,null,null,null,null,"Korrektion","energi","m2","energi + m2"]
[null,null,3,"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)",70,{"$f":"$E$71","v":24.330900243309003},null,{"$f":"D108*E108*(100-F108)/100","v":1703.1630170316303}]
[null,null,"Varmetab i varmesystem og varme i fællesareal (m2)",70,{"$f":"$E$70","v":10.948905109489051},{"$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":766.42335766423344}]
[null,null,"Rumvarme VFM",2000,{"$f":"$E$68","v":0.5149999999999999},{"$f":"(IF($G$5=\"ja\",I107)+IF($G$6=\"ja\",0)+IF($G$7=\"ja\",K107))","v":20},823.99999999999989]
[null,null,"Rumvarme (MWh)",0,{"$f":"$E$67","v":717.9487179487179},{"$f":"F110","v":20},0]
[null,null,{"$f":"C65","v":"Varmetab VVB og cirkulation (m2)"},80,{"$f":"$E$65","v":15.440389294403895},null,1235.2311435523116]
[null,null,"Rumvarme (m2)",70,{"$f":"$E$66","v":0},{"$f":"F109","v":0},{"$f":"D113*E113*(100-F113)/100","v":0}]
[null,null,"Varmtvandsmåler (m3)",25,{"$f":"$E$64","v":27.066666666666659},null,{"$f":"D114*E114*(100-F114)/100","v":676.66666666666652}]
[null,null,"Gulvarme uden måler",6,{"$f":"$E$69","v":400},{"$f":"F110","v":20},{"$f":"D115*E115*(100-F115)/100","v":1920}]
[]
[null,null,null,null,null,null,null,null,"rumvarme"]
[null,null,null,null,null,"I alt",{"$f":"SUM(G108:G117)","v":7125.4841849148415},null,{"$f":"G110+G111+G109+G113+G115","v":3510.4233576642332},{"$f":"I118/I90","v":0.70050195403535176}]