{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cirkulationstab","Rørtab_fælles_vent","rørtab cirk","rørtab","rør"],"not_rendered":{"charts":0,"images":4,"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":"Cirkulationstab","index":0,"n_rows":48,"n_cols":28,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Værktøj til beregning af cirkulationstabet i rørledningen til varmt brugsvand i W pr. lejlighed"]
[]
[]
[null,null,"DT middel varmt brugsvand / kælder og loft",35,"°K"]
[]
[null,null,"DT middel varmt brugsvand / temperatur i lejligheder",25,"°K"]
[]
[null,null,"Bygningslængde L",30,"m"]
[]
[null,null,"Bygningsbredde B",12,"m"]
[]
[null,null,"Bygningshøjde H",12,"m"]
[]
[null,null,"Antal etager",3,"stk."]
[]
[null,null,"Antal lejligheder",10,"stk."]
[]
[null,null,"Antal stigstrenge pr. lejlighed",2,"stk."]
[]
[null,null,"Er stigstrengene isolerede (ja/Nej)","Nej"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja"]
[null,null,"Middel rørdimension kælder ",25,"mm udv.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nej"]
[]
[null,null,"Middel rørdimension stigstrenge",25,"mm"]
[]
[null,null,"Varmtvandsbeholder",600,"l"]
[]
[null,null,"Længde af rør i kælder/loft",{"$f":"2*D10","v":60},"m"]
[]
[null,null,"U-værdi",{"$f":"'rørtab cirk'!C17","v":3.7282371893987603},"W/m"]
[]
[null,null,"Varmetab kælder/loft",{"$f":"D30*D32","v":223.69423136392561},"W"]
[]
[null,null,"Længde af stigstrenge",{"$f":"D14*D18/D16*D20","v":80},"m"]
[]
[null,null,"U-værdi uisolerede stigstrenge",{"$f":"'rørtab cirk'!D17","v":8.3003570183180511},"W/m"]
[]
[null,null,"U-værdi isolerede stigstrenge",{"$f":"'rørtab cirk'!D17","v":8.3003570183180511},"W/m"]
[]
[null,null,"Varmetab stigstrenge",{"$f":"(D40*(D22=\"Ja\") +D38*(D22=\"Nej\"))*D36","v":664.02856146544411},"W"]
[]
[null,null,"Varmtvandsbeholder ECO*2 DT 30 K",{"$f":"(16.66+8.33*D28^0.4)*2*(30/45)^1.3","v":146.73152790322189},"W"]
[]
[null,null,"Varmetab i alt inkl. 20 % kuldebroer",{"$f":"(D44+D42+D34)*1.2","v":1241.3451848791099},"W"]
[]
[null,null,"Varmetab pr. lejlighed",{"$f":"D46/D18","v":124.13451848791098},"W"]

{"sheet":"Rørtab_fælles_vent","index":1,"n_rows":82,"n_cols":28,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Værktøj til beregning af hvor stor en procentdel af rumvarmeforbruget der går til varmetab og opvarmning af fælleslokaler samt forvarmning af ventilationsluft"]
[]
[]
[null,null,"Er der central balanceret ventilation med forvarmning af ventilationsluft (Ja/Nej)","Ja"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja"]
[null,null,"Varmeforbrug",110000,"kWh/år",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nej"]
[]
[null,null,"Varmt vand målt på primærsiden varmtvandsbeholder",25000,"kWh/år"]
[]
[null,null,"Cirka værdi for rørtab",11925.723613336379,"kWh/år",null,"Startværdi"]
[]
[null,null,"Makstimetal",2200," h/år"]
[]
[null,null,"Dimensionerende afkøling",20,"°C"]
[]
[null,null,"Delta T middel centralvarmevand / kælder og loft",45,"°K"]
[]
[null,null,"Delta T middel centralvarmevand / temperatur i lejligheder",40,"°K"]
[]
[null,null,"Bygningslængde L",30,"m"]
[]
[null,null,"Bygningsbredde B",12,"m"]
[]
[null,null,"Bygningshøjde H",12,"m"]
[]
[null,null,"Antal etager",3,"stk."]
[]
[null,null,"Antal lejligheder",10,"stk."]
[]
[null,null,"Antal stigstrenge pr. lejlighed",3,"stk."]
[]
[null,null,"Er stigstrengene isolerede (Ja/Nej)","Ja"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja"]
[null,null,"Driftstimer varmeanlæg",5000,"h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nej"]
[]
[null,null,"Et-strengsanlæg (Ja/Nej)","Nej"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja"]
[null,null,"Radiatorvarme ud",{"$f":"D8-D10-D12","v":73074.276386663623},"kWh/år",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nej"]
[]
[null,null,"Maks. effekt ved -12 °C",{"$f":"D40/D14","v":33.215580175756195},"kW"]
[]
[null,null,"Vandstrøm ved maks",{"$f":"D42/D16*0.86","v":1.4282699475575165},"m3/h"]
[null,null,null,null,null,null,"Indvendig rørdiam. baseret på 1½ m/sek"]
[null,null,"Udvendig diameter ved maks 1,5 m/s",{"$f":"rør!C10","v":33.75},"mm kælderledninger",null,{"$f":"SQRT(1/1*D44*4/3600/PI())*1000","v":22.475479093812481}]
[]
[null,null,"Varmetab for rør i kælder",{"$f":"rørtab!C17","v":6.6704907913621554},"W/m"]
[]
[null,null,"Stigstrenge i kælder, udv. rørdiameter",22,"mm"]
[]
[null,null,"Varmetab for stigstrenge i kælder",{"$f":"rørtab!D17","v":5.2358595646309976},"W/m"]
[]
[null,null,"Stigstrenge i lejligheder udv. rørdiameter",22,"mm"]
[]
[null,null,"Stigstrenge i lejligheder, hvis isolerede",{"$f":"rørtab!E17","v":4.3562762251601814},"W/m "]
[]
[null,null,"Stigstrenge i lejligheder, hvis uisolerede",{"$f":"rørtab!E17","v":4.3562762251601814},"W/m "]
[]
[null,null,"Stigstrenge i lejligheder",{"$f":"(D34=\"Nej\")*D58+(D34=\"Ja\")*D56","v":4.3562762251601814},"W/m"]
[]
[null,null,"Rørlængde hovedledninger",{"$f":"2*D22","v":60},"m"]
[]
[null,null,"Rørlængde stigstrenge på loft / i kælder",{"$f":"+D24*D32*(D30/D28)","v":120},"m"]
[]
[null,null,"Rørlængde stigstrenge i lejligheder",{"$f":"D26*D32*D30/D28*(IF(D38=\"Ja\",1,2))","v":240},"m"]
[]
[null,null,"Varmetab hovedledninger kælder",{"$f":"D62*D48*D36/1000","v":2001.1472374086466},"kWh/år"]
[]
[null,null,"Varmetab stigstrenge på loft/ i kælder",{"$f":"D64*D52*D36/1000","v":3141.5157387785985},"kWh/år"]
[]
[null,null,"Varmetab stigstrenge i lejligheder",{"$f":"D66*D60*D36/1000","v":5227.5314701922171},"kWh/år"]
[]
[null,null,"Varmetab totalt",{"$f":"SUM(D68:D72)","v":10370.194446379461},"kWh/år"]
[]
[null,null,"Varmetab totalt inkl. tillæg for kuldebroer mv + 15 %",{"$f":"D74*1.15","v":11925.723613336379},"kWh/år",{"$f":"D12-D76","v":0}]
[]
[null,null,"Samlet rørvarmetab fra centralvarmerør",{"$f":"D76/(D8-D10)*100","v":14.030263074513385},"%"]
[]
[null,null,"Forvarmning af ventilationsluft",{"$f":"(D6=\"Ja\")*rørtab!C50/(D8-D10)*100","v":6.6023728941176474},"%"]
[]
[null,null,"Rørtab + forvarmning af ventilation",{"$f":"D78+D80","v":20.632635968631032},"%"]

{"sheet":"rørtab cirk","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tvarm",{"$f":"Cirkulationstab!D6","v":35},{"$f":"Cirkulationstab!D8","v":25}]
[null,"Tkold",15,15]
[null,"Lambda",0.04,0.04]
[null,"Di",{"$f":"Cirkulationstab!D24","v":25},{"$f":"Cirkulationstab!D26","v":25}]
[null,"Tykkelse",30,{"$f":"IF(Cirkulationstab!D22=\"y\",30,0.01)","v":0.01}]
[null,"epsilon",1,1]
[]
[null,"Resultater",null,null,null,"Plan"]
[null,"Dy mm, Plan m2",{"$f":"+(C5+2*C6)","v":85},{"$f":"+(D5+2*D6)","v":25.02}]
[null,"Udvendig Temp gæt",16.84915990712712,24.973484795794768,null,19.395732252874971]
[null,"Alfa U W/m2K",{"$f":"(46*((C11+C3)/2+273)^(-0.62)*(C11-C3)^0.33)*(C10/200)^-0.25 +C7*0.0000000567*((273+C11)^4-(273+C3)^4)/(C11-C3)","v":7.5502314884258608},{"$f":"(46*((D11+D3)/2+273)^(-0.62)*(D11-D3)^0.33)*(D10/200)^-0.25 +D7*0.0000000567*((273+D11)^4-(273+D3)^4)/(D11-D3)","v":10.587969091500376},null,{"$f":"(46*((F11+C3)/2+273)^(-0.62)*(F11-C3)^0.33) +C7*0.0000000567*((273+F11)^4-(273+C3)^4)/(F11-C3)","v":7.7719584127202515}]
[null,"Varmestrøm iso, W/m, W/m2",{"$f":"+((PI()/(1/2/C4*LN(C10/C5)+1/C12/(C10/1000))))*(C2-C3)","v":3.7277021939837689},{"$f":"+((PI()/(1/2/D4*LN(D10/D5)+1/D12/(D10/1000))))*(D2-D3)","v":8.3004440982248759},null,{"$f":"+(C2-F11)*C4/C6*1000","v":20.805690329500038}]
[null,"Varmestrøm overfladeW/m W/m2",{"$f":"+PI()*C10/1000*C12*(C11-C3)","v":3.7282371893987603},{"$f":"+PI()*D10/1000*D12*(D11-D3)","v":8.3003570183180511},null,{"$f":"+F12*(F11-C3)","v":34.163448262797381}]
[null,"Kontrol skal være 0",{"$f":"+C14-C13","v":5.3499541499135717E-4},{"$f":"+D14-D13","v":-8.7079906824882869E-5},null,{"$f":"+(F14-F13)^2","v":178.42969700456811}]
[]
[null,"Varmestrøm W/m W/m2",{"$f":"+C14","v":3.7282371893987603},{"$f":"+D14","v":8.3003570183180511},null,{"$f":"+F14","v":34.163448262797381}]
[null,"Plan Varmestrøm W/m2"]
[]
[]
[null,"Tm",{"$f":"(C2+C11)/2","v":25.924579953563558}]
[]
[null,"Lambda",{"$f":"(3.35*10^-2)+(1.273*10^-4)*C21+(3.571*10^-7)*C21","v":3.6809456695590062E-2}]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Udenfor klimaskærm 4°C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",45.7,6.9,6.2,null,{"$f":"((C27-D27)/1000)*6000","v":232.8},{"$f":"((C27-E27)/1000)*6000","v":237}]
[null,"28 mm",56.2,7.8,7,null,{"$f":"((C28-D28)/1000)*6000","v":290.40000000000003},{"$f":"((C28-E28)/1000)*6000","v":295.2}]
[null,"35 mm",68.2,8.8000000000000007,7.9,null,{"$f":"((C29-D29)/1000)*6000","v":356.40000000000003},{"$f":"((C29-E29)/1000)*6000","v":361.8}]
[]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Indenfor klimaskærm 20°C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",28.3,4.5,4.0999999999999996,null,{"$f":"0.5*((C34-D34)/1000)*6000","v":71.400000000000006},{"$f":"0.5*((C34-E34)/1000)*6000","v":72.600000000000009}]
[null,"28 mm",35,5.0999999999999996,4.5999999999999996,null,{"$f":"0.5*((C35-D35)/1000)*6000","v":89.7},{"$f":"0.5*((C35-E35)/1000)*6000","v":91.2}]
[null,"35 mm",42.5,5.8,5.2,null,{"$f":"0.5*((C36-D36)/1000)*6000","v":110.10000000000001},{"$f":"0.5*((C36-E36)/1000)*6000","v":111.9}]
[]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Uopvarmet kælder 10 °C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",39,6,5.4,null,{"$f":"0.5*((C41-D41)/1000)*6000","v":99},{"$f":"0.5*((C41-E41)/1000)*6000","v":100.80000000000001}]
[null,"28 mm",48,6.8,6.1,null,{"$f":"0.5*((C42-D42)/1000)*6000","v":123.60000000000001},{"$f":"0.5*((C42-E42)/1000)*6000","v":125.7}]
[null,"35 mm",58.2,7.7,6.9,null,{"$f":"0.5*((C43-D43)/1000)*6000","v":151.5},{"$f":"0.5*((C43-E43)/1000)*6000","v":153.9}]

{"sheet":"rørtab","index":3,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tvarm",{"$f":"Rørtab_fælles_vent!D18","v":45},{"$f":"Rørtab_fælles_vent!D18","v":45},{"$f":"Rørtab_fælles_vent!D20","v":40}]
[null,"Tkold",15,15,15]
[null,"Lambda",0.04,0.04,0.04]
[null,"Di",{"$f":"Rørtab_fælles_vent!D46","v":33.75},{"$f":"Rørtab_fælles_vent!D50","v":22},{"$f":"Rørtab_fælles_vent!D54","v":22}]
[null,"Tykkelse",30,30,{"$f":"IF(Rørtab_fælles_vent!D34=\"Ja\",30,0.01)","v":30}]
[null,"epsilon",1,1,1]
[]
[null,"Resultater",null,null,null,"Plan"]
[null,"Dy mm, Plan m2",{"$f":"+(C5+2*C6)","v":93.75},{"$f":"+(D5+2*D6)","v":82},82]
[null,"Udvendig Temp gæt",17.885875453730517,17.593668776998658,17.195986441933563,19.395732252874971]
[null,"Alfa U W/m2K",{"$f":"(46*((C11+C3)/2+273)^(-0.62)*(C11-C3)^0.33)*(C10/200)^-0.25 +C7*0.0000000567*((273+C11)^4-(273+C3)^4)/(C11-C3)","v":7.8480011070241069},{"$f":"(46*((D11+D3)/2+273)^(-0.62)*(D11-D3)^0.33)*(D10/200)^-0.25 +D7*0.0000000567*((273+D11)^4-(273+D3)^4)/(D11-D3)","v":7.8362764804485536},7.7005550590659979,{"$f":"(46*((F11+C3)/2+273)^(-0.62)*(F11-C3)^0.33) +C7*0.0000000567*((273+F11)^4-(273+C3)^4)/(F11-C3)","v":7.7719584127202515}]
[null,"Varmestrøm iso, W/m, W/m2",{"$f":"+((PI()/(1/2/C4*LN(C10/C5)+1/C12/(C10/1000))))*(C2-C3)","v":6.6701435818628845},{"$f":"+((PI()/(1/2/D4*LN(D10/D5)+1/D12/(D10/1000))))*(D2-D3)","v":5.2353480863102293},4.3561529419882117,{"$f":"+(C2-F11)*C4/C6*1000","v":34.139023662833374}]
[null,"Varmestrøm overfladeW/m W/m2",{"$f":"+PI()*C10/1000*C12*(C11-C3)","v":6.6704907913621554},{"$f":"+PI()*D10/1000*D12*(D11-D3)","v":5.2358595646309976},4.3562762251601814,{"$f":"+F12*(F11-C3)","v":34.163448262797381}]
[null,"Kontrol skal være 0",{"$f":"+C14-C13","v":3.4720949927091738E-4},{"$f":"+D14-D13","v":5.1147832076825495E-4},1.2328317196974581E-4,{"$f":"+(F14-F13)^2","v":5.9656108340177779E-4}]
[]
[null,"Varmestrøm W/m W/m2",{"$f":"+C14","v":6.6704907913621554},{"$f":"+D14","v":5.2358595646309976},4.3562762251601814,{"$f":"+F14","v":34.163448262797381}]
[null,"Plan Varmestrøm W/m2"]
[]
[]
[null,"Tm",{"$f":"(C2+C11)/2","v":31.44293772686526}]
[]
[null,"Lambda",{"$f":"(3.35*10^-2)+(1.273*10^-4)*C21+(3.571*10^-7)*C21","v":3.7513914245692212E-2}]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Udenfor klimaskærm 4°C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",45.7,6.9,6.2,null,{"$f":"((C27-D27)/1000)*6000","v":232.8},{"$f":"((C27-E27)/1000)*6000","v":237}]
[null,"28 mm",56.2,7.8,7,null,{"$f":"((C28-D28)/1000)*6000","v":290.40000000000003},{"$f":"((C28-E28)/1000)*6000","v":295.2}]
[null,"35 mm",68.2,8.8000000000000007,7.9,null,{"$f":"((C29-D29)/1000)*6000","v":356.40000000000003},{"$f":"((C29-E29)/1000)*6000","v":361.8}]
[]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Indenfor klimaskærm 20°C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",28.3,4.5,4.0999999999999996,null,{"$f":"0.5*((C34-D34)/1000)*6000","v":71.400000000000006},{"$f":"0.5*((C34-E34)/1000)*6000","v":72.600000000000009}]
[null,"28 mm",35,5.0999999999999996,4.5999999999999996,null,{"$f":"0.5*((C35-D35)/1000)*6000","v":89.7},{"$f":"0.5*((C35-E35)/1000)*6000","v":91.2}]
[null,"35 mm",42.5,5.8,5.2,null,{"$f":"0.5*((C36-D36)/1000)*6000","v":110.10000000000001},{"$f":"0.5*((C36-E36)/1000)*6000","v":111.9}]
[]
[]
[null,null,"Tab [W/m]",null,null,null,"Besp [kWh]"]
[null,"Uopvarmet kælder 10 °C","0 mm","40 mm","50 mm",null,"40 mm","50 mm"]
[null,"22 mm",39,6,5.4,null,{"$f":"0.5*((C41-D41)/1000)*6000","v":99},{"$f":"0.5*((C41-E41)/1000)*6000","v":100.80000000000001}]
[null,"28 mm",48,6.8,6.1,null,{"$f":"0.5*((C42-D42)/1000)*6000","v":123.60000000000001},{"$f":"0.5*((C42-E42)/1000)*6000","v":125.7}]
[null,"35 mm",58.2,7.7,6.9,null,{"$f":"0.5*((C43-D43)/1000)*6000","v":151.5},{"$f":"0.5*((C43-E43)/1000)*6000","v":153.9}]
[]
[]
[null,"Ventilation"]
[null,"m2",{"$f":"Rørtab_fælles_vent!D28*Rørtab_fælles_vent!D22*Rørtab_fælles_vent!D24*0.9","v":972}]
[null,"m3/h=",{"$f":"0.3*3600*C47/1000","v":1049.76},"0,3 l/sek /m2"]
[null,"ydelse v -12 kW",{"$f":"0.33*(18-(-12))*C48/1000*(1-0.73)","v":2.80600848},"18 grd indblæsning, eta varmegenvinding = 0,73"]
[null,"Årsforbrug 2000 max timer kWh",{"$f":"C49*2000","v":5612.0169599999999}]

{"sheet":"rør","index":4,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Dy",null,10.6,14,17.5,21.8,27.3,34.200000000000003,42.9,48.8,60.8,76.599999999999994,89.5,115]
[null,null,null,null,9.8000000000000007,13.2,16.7,21,26.5,33.299999999999997,42,47.8,59.7,75.3,88,113.1]
[null,null,"Middel Dy",null,{"$f":"AVERAGE(E2:E3)","v":10.199999999999999},{"$f":"AVERAGE(F2:F3)","v":13.6},17.100000000000001,21.4,26.9,33.75,42.45,48.3,60.25,75.949999999999989,88.75,114.05]
[null,null,"Gods",null,2,2.35,2.35,2.65,2.645,3.25,3.25,3.25,3.65,3.65,4.05,4.5]
[null,null,"Di",5,{"$f":"E4-2*E5","v":6.1999999999999993},{"$f":"F4-2*F5","v":8.8999999999999986},12.400000000000002,16.099999999999998,21.61,27.25,35.950000000000003,41.8,52.95,68.649999999999991,80.650000000000006,105.05,110]
[null,null,"Dber"]
[null,"Di",{"$f":"Rørtab_fælles_vent!G46","v":22.475479093812481},null,{"$f":"($C$8>D6)*($C$8<E6)*E6","v":0},0,0,0,0,27.25,0,0,0,0,0,0,0]
[null,"Dy",null,null,{"$f":"(E8>0)*E4","v":0},{"$f":"(F8>0)*F4","v":0},0,0,0,33.75,0,{"$f":"(L8>0)*L4","v":0},{"$f":"(M8>0)*M4","v":0},{"$f":"(N8>0)*N4","v":0},{"$f":"(O8>0)*O4","v":0},{"$f":"(P8>0)*P4","v":0},0]
[null,"DY",{"$f":"MAX(E9:Q9)","v":33.75}]