{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Beregning","Rør","Info","Heat emitters","Definitions","Beregn","Ark2","Ark3"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Beregning","index":0,"n_rows":117,"n_cols":28,"rows_kept":117,"cut":false,"hidden":true,"merged":[[75,1,75,4],[3,1,3,12],[4,1,6,18],[1,1,2,19]]}
[]
[null,"Vurdering af radiatorerernes og gulvvarmens (varmeafgiveres) egnethed til varmepumpe    "]
[]
[]
[null,"Bemærk, at der er flere faneblade i regnearket. Der indtastes kun i gule felter i varmeafgivere, beregning og rør. Data for varmeanlægget indtastes i fanebladet \"Beregning\". Her ses også beregningsresultater i de orange og grønne felter. Orange felter sammenlignes: Er husets varmebehov større end den installerede radiatoreffekt? Hvis ja, så er varmegiverne ikke egnet til det ønskede varmeanlæg, med mindre der udvides med flere radiatorer eller gulvvarme. Alle gule felter skal udfyldes (indeholder p.t. eksempeltekst)."]
[]
[]
[]
[null,"Data for radiatorer skal udfyldes i fanebladet \"Varmeafgivere\". Billeder af de forskellige radiatorer ses i fanebladet \"Billeder\"."]
[null,"Der kan skiftes mellem fanebladene nederst på arket."]
[null,"Både arket \"Beregning\" og arket \"Varmegivere\" skal være udfyldt, før din beregning er foretaget. "]
[]
[null,"Arket kan anvendes til både en- og tostrengs varmeanlæg, dog skal særskilt vurdering af flowforholdene foretages i tilfælde, hvor særlige en-strengsarmaturer er anvendt."]
[null,"Varmepumper dimensioneres ofte til - 7 °C udetemperatur, men der angives også data for - 12 °C. Den nødvendige varmepumpeydelse skal være svare til husets varmebehov ved - 7 °C tillagt 500 W aht. varmtvandsproduktion."]
[null,"Under rør beregnes tryktabet for rørene tættest på varmepumpen. Dette bør næppe være større end ca 10 kPa. Der er typisk 15 kPa over kondensatoren og der skal være ca 10 kPa over radiatorventilerne. "]
[null,"Fordelingsrørene kan godt være begrænsende for flowet."]
[null,"Husets varmebehov ved -7°C ude og effekten af varmeanlæg inkl. gulvvarme ved radiator-middeltemperaturen, som begge er markeret med orange skal være så tætte på hinanden som muligt."]
[null,"Hvis effekten af varmeanlæg inkl. gulvvarme ved middeltemperaturen er lavere end husets varmebehov ved -7°C ude betyder det, at varmeanlægget kapacitet er for lille."]
[null,"Dette betyder, at fremløbstemperaturen (maks. fremløbstemperatur) bliver højere end den ønskede."]
[]
[null,"Hvis max flowkapacitet er mindre end nødvendig flowkapacitet bør der foretages en grundigere analyse af rørsystemet. Der kræves muligvis en større pumpe og der kan opstå støj i radiatorventiler mm."]
[]
[]
[null,"Nuværende varmekilde ",null,null,null,null,"Input"]
[]
[null,"Type (gammel olie- eller gaskedel)",null,null,null,null,"Oliefyr"]
[]
[]
[null,"Nuværende forbrug",null,null,null,null,"Input",null,null,"Beregningsresultater"]
[]
[null,"Brændselsforbrug pr år, skal være større end 600",null,null,null,null,2000,{"$f":"IF($G$26=\"gaskedel\",\"m³\",IF($G$26=\"oliefyr\",\"liter olie\",\"\"))","v":"liter olie"}]
[null,null,null,null,null,null,null,null,null,"-12°C",null,null,"-7 °C"]
[null,"Huset varmebehov ved -12/ -7 °C ude",null,null,null,null,null,null,null,{"$f":"(G31*IF(G26=\"gaskedel\",11*0.85,10*0.85)-G76)/2.2","v":6818.181818181818},"Watt",null,{"$f":"J33*27/32","v":5752.840909090909},"Watt"]
[]
[null,"Nuværende varmeafgivere - er det OK?",null,null,{"$f":"IF(J54>95,\"kontroller indtastningerne, varmebehovet er langt større end varmegivernes kapacitet!\",\"\")","v":""},null,null,null,null,"Beregningsresultater"]
[]
[null,"Maks. fremløbstemperatur fra varmepumpe datablad",null,null,null,null,55,"°C"]
[]
[null,"Ønsket returtemperatur, svarende til ovenstående",null,null,null,null,45,"°C"]
[]
[null,"Gulvvarme fremløbstemperatur dimensionerende",null,null,null,null,36,"°C"]
[]
[null,"Gulvvarme returtemperatur dimensionerende",null,null,null,null,30,"°C"]
[]
[null,"Radiatormiddeltemperatur ved max varmepumpetemperaturer",null,null,null,null,null,null,null,{"$f":"(G37-G39)/LN((G37-20)/(G39-20))+20","v":49.720134119884619},"°C"]
[]
[null,"Installeret radiatoreffekt ved max varmepumpetemperaturer",null,null,null,null,null,null,null,{"$f":"((J45-20)/Beregn!C5)^1.3*Beregn!F8+0.01","v":11692.116895781273},"Watt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"°"]
[null,"Installeret gulvvarmeeffekt",null,null,null,null,null,null,null,{"$f":"'Heat emitters'!BV15","v":500},"Watt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J51<J33)*1+(J51>M33)*(J51<J33)*2+(J51>J33)*3","v":3}]
[null,"Effekt af varmeanlæg inkl. gulvvarme ved Max varmepumpemperatur",null,null,null,null,null,null,null,{"$f":"+J47+J49","v":12192.116895781273},"Watt",null,{"$f":"_xlfn.IFS(J51<M33,\"Ikke tilstrækkelig varmeflade\",AND(J51>M33,J51<J33),\"Tilstrækkelig varmeflade ved - 7\",J51>J33,\"Tilstrækkelig varmeflade ved -12°C og derfor rigelig ved -7°C\")","v":"Tilstrækkelig varmeflade ved -12°C og derfor rigelig ved -7°C"}]
[]
[]
[null,"Tilstrækkelig fremløbstemperatur ved -12 °C ude",null,null,null,null,null,null,null,{"$f":"Beregn!D19","v":41.213110997017672},"°C"]
[]
[null,"Returtemperatur ved -12 °C ude inkl gulvvarme",null,null,null,null,null,null,null,{"$f":"Beregn!D24","v":35.595901712016932},"°C"]
[]
[null,"Varmeanlægget kan dække andel af varmebehov ved -12 °C",null,null,null,null,null,null,null,{"$f":"J51/J33*100","v":178.81771447145869},"%",null,{"$f":"J54-J56","v":5.6172092850007402}]
[]
[null,"Dette svarer til varmebehov ned til udetemperatur",null,null,null,null,null,null,null,{"$f":"20-J58/100*32","v":-37.22166863086678},"°C"]
[]
[null,"Tilstrækkelig fremløbstemperatur ved -7",null,null,null,null,null,null,null,{"$f":"Beregn!D30","v":38.306267858596122},"°C"]
[null,"Afkøling rad"]
[null,"Nødvendig flowkapacitet ved -7",null,null,null,null,null,null,null,{"$f":"Beregn!D37/1000","v":1.0573019139542936},"m3/h",null,"korrekt flow pr radiator"]
[]
[null,"Max flowkapacitet, overslag",null,null,null,null,null,null,null,{"$f":"(Beregn!D33*0.86+'Heat emitters'!AZ46)/1000","v":1.2517681354996268},"m3/h",null,"100 l pr radiator + gulvvarme, tommelfingerregel"]
[]
[null,"Dimensionerende varmepumpeeffekt ved-7 °C/ suppleringseffekt op til -12°C, inkl. varmt vand",null,null,null,null,null,null,null,{"$f":"M33+500","v":6252.840909090909},"Watt",null,{"$f":"J70-J68","v":1065.340909090909},"W"]
[]
[null,"Dimensionerende varmepumpeeffekt ved -12° inkl varmt vand",null,null,null,null,null,null,null,{"$f":"J33+500","v":7318.181818181818},"Watt"]
[]
[]
[]
[]
[]
[null,"Varmtvandsforbrug fast værdi!",null,null,null,null,2000,"kWh/år"]
[null,"Obs. Varmebrug inkl. varmt vand",null,null,null,null,null,null,null,{"$f":"J33*2.2+3000","v":18000},{"$f":"IF($G$26=\"gaskedel\",\"kWh/år\",IF($G$26=\"oliefyr\",\"kWh/år\",\"\"))","v":"kWh/år"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Kedel"]
[]
[null,null,null,"Gaskedel"]
[null,null,null,"Oliefyr"]

{"sheet":"Rør","index":1,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"rel Ru",{"$f":"0.05/F2","v":2.5000000000000001E-3}]
[null,"Rørdiameter indvendig",null,null,null,20,"mm",null,null,null,null,null,null,"ny",{"$f":"vi(AVERAGE(Beregning!J45))","v":5.3663398254555465E-7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Re",{"$f":"H8*(F2/1000)/O2","v":34841.630405581542}]
[null,"Rørlængde ",null,null,null,20,"m",null,null,null,null,null,null,"Fric",{"$f":"fricfac(O3,O1)","v":2.8561423123939382E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hjælpestørrelser"]
[null,"Sum zeta",null,null,null,5]
[]
[null,"Hastighed",null,null,null,null,null,{"$f":"Beregning!J64/3600/(PI()/4*(F2/1000)^2)","v":0.93486014414637564}]
[]
[null,"Pdyn Pa",null,null,null,null,null,{"$f":"0.5*1000*H8^2","v":436.98174455669113}]
[]
[null,"Tryktab enkeltmodstande Pa",null,null,null,null,null,{"$f":"H10*F6","v":2184.9087227834557}]
[]
[null,"Tryktab rør Pa",null,null,null,null,null,{"$f":"O4*F4/(F2/1000)*H10","v":12480.820503720852}]
[]
[null,"Tryktab Pa",null,null,null,null,null,{"$f":"H12+H14","v":14665.729226504307},"=",{"$f":"H16/1000","v":14.665729226504308},"kPa","=",{"$f":"J16/9.81","v":1.4949774950565042},"mVS"]
[]
[]
[null,"Varmepumpe kondensator",null,null,15,"kPa"]
[null,"Termostatventiler",null,null,10]
[null,"Hovedledning",null,null,{"$f":"J16","v":14.665729226504308}]
[null,"Sum",null,null,{"$f":"SUM(E19:E21)","v":39.665729226504311}]
[null,"Sikkerhed +50%",null,null,{"$f":"E22*1.5","v":59.498593839756467}]
[]
[null,"Pumpecheck, se fx Grundfos webcaps eller Wilo.com:"]
[]
[null,"Flow",{"$f":"MAX(Beregning!J64,Beregning!J66)","v":1.2517681354996268},"m3/h"]
[null,"Tryk",{"$f":"E23","v":59.498593839756467}]
[]
[null,null,null,null,null,null,null,null,null,"25-6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"25/60"]

{"sheet":"Info","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Info"]

{"sheet":"Heat emitters","index":3,"n_rows":46,"n_cols":84,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,27,6,27],[2,1,2,17],[11,15,11,17],[11,19,11,21],[11,9,11,13],[4,25,6,25]]}
[]
[null,{"$f":"IF(AR5=\"Dansk\",\"Opmåling af radiatorers (varmegiveres) og gulvvarmes ydelse\",\"Measuring the performance (thermal output) of radiators (emitters) and underfloor heating\")","v":"Measuring the performance (thermal output) of radiators (emitters) and underfloor heating"}]
[]
[]
[null,{"$f":"IF(AR5=\"Dansk\",\"Dimensionerende fremløbstemperatur\",\"Design forward temperature\")","v":"Design forward temperature"},null,null,null,null,60,null,null,"°C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Samlet reference ydelse\",\"Total reference performance\")","v":"Total reference performance"},null,{"$f":"IF(AR5=\"Dansk\",\"Samlet design ydelse\",\"Total design performance\")","v":"Total design performance"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Vælg sprog\",\"Choose language\")","v":"Choose language"},null,null,null,null,"Engelsk"]
[]
[null,{"$f":"IF(AR5=\"Dansk\",\"Dimensionerende returtemperatur\",\"Design return temperature\")","v":"Design return temperature"},null,null,null,null,40,null,null,"°C"]
[]
[null,{"$f":"IF(AR5=\"Dansk\",\"Dimensionerende rumtemperatur\",\"Design room temperature\")","v":"Design room temperature"},null,null,null,null,20,null,null,"°C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z17:Z41)","v":12192.066283161455},null,{"$f":"SUM(AB17:AB41)","v":5069.3263250457567}]
[]
[]
[null,{"$f":"IF(AR5=\"Dansk\",\"Rum\",\"Room\")","v":"Room"},null,"Type",null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Panelradiator/konvektor\",\"Panel radiator/convector\")","v":"Panel radiator/convector"},null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Planradiator\",\"Planar radiator\")","v":"Planar radiator"},null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Søjleradiator\",\"Column radiator\")","v":"Column radiator"},null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Gulvvarme\",\"Underfloor heating\")","v":"Underfloor heating"},null,{"$f":"IF(AR5=\"Dansk\",\"Reference ydelse\",\"Reference performance\")","v":"Reference performance"},null,{"$f":"IF(AR5=\"Dansk\",\"Design ydelse\",\"Design performance\")","v":"Design performance"},null,null,null,null,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. plade","2. plade","3. plade","1. konvektorblik","2. til … konvektorblik","randeffekt",null,"1. plade","2. plade","3. plade","konvektorer",null,"enkelt","dobbelt",null,null,null,null,null,null,"konvektor","Plan","søjle","gulvvarme"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kedeltype",null,"Type",null,"Panel",null,"Konvektor",null,"Plan",null,"Sprog"]
[null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Højde\",\"Height\")","v":"Height"},null,null,{"$f":"IF(AR5=\"Dansk\",\"Bredde/længde\",\"With/Length\")","v":"With/Length"},null,{"$f":"IF(AR5=\"Dansk\",\"Antal paneler\",\"Number of panels\")","v":"Number of panels"},null,{"$f":"IF(AR5=\"Dansk\",\"Konvektorslør\",\"Convector veiling\")","v":"Convector veiling"},null,{"$f":"IF(AR5=\"Dansk\",\"Dybde\",\"Debth\")","v":"Debth"},null,"Type",null,{"$f":"IF(AR5=\"Dansk\",\"Søjlens dybde\",\"Column debth\")","v":"Column debth"},null,{"$f":"IF(AR5=\"Dansk\",\"Antal elementer\",\"Number of elements\")","v":"Number of elements"},null,{"$f":"IF(AR5=\"Dansk\",\"Areal\",\"Area\")","v":"Area"},null,{"$f":"IF(AR5=\"Dansk\",\"Ved 90/70/20 °C\",\"At 90/70/20 °C\")","v":"At 90/70/20 °C"},null,{"$f":"IF(AR5=\"Dansk\",\"Ved middeltemp.\",\"At middle temp.\")","v":"At middle temp."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"cm",null,null,"cm",null,{"$f":"IF(AR5=\"Dansk\",\"stk.\",\"pieces\")","v":"pieces"},null,{"$f":"IF(AR5=\"Dansk\",\"stk.\",\"pieces\")","v":"pieces"},null,"mm",null,{"$f":"IF(AR5=\"Dansk\",\"Antal lag\",\"Number of plates\")","v":"Number of plates"},null,"mm",null,{"$f":"IF(AR5=\"Dansk\",\"stk.\",\"pieces\")","v":"pieces"},null,"m²",null,"Watt",null,"Watt",null,null,null,null,null,null,null,null,null,null,"Gaskedel",null,{"$f":"IF(AR5=\"Dansk\",\"Panelradiator\",\"Panel radiator/convector\")","v":"Panel radiator/convector"},null,1,null,1,null,"enkelt",null,"Dansk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BV17:BV98)","v":500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oliefyr",null,{"$f":"IF(AR5=\"Dansk\",\"Søjleradiator\",\"Column radiator\")","v":"Column radiator"},null,2,null,2,null,"dobbelt",null,"Engelsk"]
[null,"Living room 1",null,"Column radiator",{"$f":"G17/100","v":0.37},null,37,{"$f":"J17/100","v":0},null,null,null,2,null,2,null,58,null,"dobbelt",null,190,null,29,null,6,null,{"$f":"IF(SUM(BD17:BV17)=0,\" \",IF(CF17=\"Gulvvarme\",SUM(BD17:BV17),SUM(BD17:BV17)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD17:BV17)=0,\" \",IF(CF17=\"Gulvvarme\",SUM(BD17:BV17),SUM(BD17:BV17)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Planradiator\",\"Planar radiator\")","v":"Planar radiator"},null,3,null,3,null,null,null,null,null,null,{"$f":"100*($CF17<>\"Gulvvarme\")*($CF17<>0)","v":100},{"$f":"IF($CF17<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF17<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"IF($CF17=\"Panelradiator\",$E17*$H17*(-132.68*($E17^3)+801.68*($E17^2)-1099.6*$E17+1790.8),0)","v":0},{"$f":"IF($CF17=\"Panelradiator\",IF($L17>1,$E17*$H17*(-4178.9*($E17^3)+7784.1*($E17^2)-4877.7*$E17+2023.7),0))","v":false},{"$f":"IF($CF17=\"Panelradiator\",IF($L17>2,($L17-2)*$E17*$H17*(2439.3*($E17^3)-3252.2*($E17^2)+583.01*$E17+1150.4),0))","v":false},{"$f":"IF($CF17=\"Panelradiator\",IF($N17>0.5,$E17*$H17*(-1085.5*($E17^3)+1428.6*($E17^2)-532.97*$E17+688.74),0),0)","v":0},{"$f":"IF($CF17=\"Panelradiator\",IF($N17>1.5,($N17-1)*$E17*$H17*(6322*($E17^3)-12424*($E17^2)+7584.6*$E17-593.91),0),0)","v":0},{"$f":"IF($CF17=\"Panelradiator\",IF($L17>$N17,IF($N17>0.5,$H17*40,0),0),0)","v":0},null,{"$f":"IF($CF17=\"Konvektor\",$E17*$H17*457.27*($E17^-0.5155),0)","v":0},{"$f":"IF($CF17=\"Konvektor\",IF($L17>1,$E17*$H17*355.73*($E17^-0.4981),0))","v":false},{"$f":"IF($CF17=\"Konvektor\",IF($L17>2,($L17-2)*$E17*$H17*152.96*($E17^-0.8625),0),0)","v":0},{"$f":"IF($CF17=\"Konvektor\",$N17*$E17*$H17*455.51*($E17^-0.5469),0)","v":0},null,{"$f":"IF($CF17=\"Planradiator\",IF($R17=\"enkelt\",$E17*$H17*(-488.27*($E17^3)+1099.6*($E17^2)-835.09*$E17+394.42)*($P17^0.605),0))","v":false},{"$f":"IF($CF17=\"Planradiator\",IF($R17=\"dobbelt\",$E17*$H17*(-23.595*($E17^3)+70.632*($E17^2)-120.62*$E17+202.02)*($P17^0.725),0),0)","v":0},null,{"$f":"IF($CF17=\"søjleradiator\",0.83*V17*(957.42*$T17/1000*$E17+18.244),0)","v":0},null,{"$f":"IF($CF17=\"Gulvvarme\",$X17*50,0)","v":0},null,null,{"$f":"IF($CF17=\"Konvektor\",-999999999,IF($CF17=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF17=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF17=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF17=\"Gulvvarme\",-999999999,999999999)","v":999999999},{"$f":"+SUM(BD17:BV17)","v":0},null,null,{"$f":"IF(OR(D17=\"Panelradiator\",D17=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D17=\"Søjleradiator\",D17=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D17=\"Planradiator\",D17=\"Planar radiator\"),\"Planradiator\",IF(OR(D17=\"Konvektor\",D17=\"Convector\"),\"Konvektor\",IF(OR(D17=\"Gulvvarme\",D17=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Konvektor\",\"Convector\")","v":"Convector"},null,null,null,4]
[null,null,null,null,0.6,null,60,{"$f":"J19/100","v":1.2},null,120,null,3,null,3,null,82,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD19:BV19)=0,\" \",IF(CF19=\"Gulvvarme\",SUM(BD19:BV19),SUM(BD19:BV19)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD19:BV19)=0,\" \",IF(CF19=\"Gulvvarme\",SUM(BD19:BV19),SUM(BD19:BV19)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR5=\"Dansk\",\"Gulvvarme\",\"Underfloor heating\")","v":"Underfloor heating"},null,null,null,5,null,null,null,null,null,null,{"$f":"100*($CF19<>\"Gulvvarme\")*($CF19<>0)","v":100},{"$f":"IF($CF19<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF19<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D17<>\"\",\"\",\"tom\")","v":""},{"$f":"IF(B17<>\"\",\"\",\"tom\")","v":""},{"$f":"IF($CF19=\"Panelradiator\",$E19*$H19*(-132.68*($E19^3)+801.68*($E19^2)-1099.6*$E19+1790.8),0)","v":0},{"$f":"IF($CF19=\"Panelradiator\",IF($L19>1,$E19*$H19*(-4178.9*($E19^3)+7784.1*($E19^2)-4877.7*$E19+2023.7),0))","v":false},{"$f":"IF($CF19=\"Panelradiator\",IF($L19>2,($L19-2)*$E19*$H19*(2439.3*($E19^3)-3252.2*($E19^2)+583.01*$E19+1150.4),0))","v":false},{"$f":"IF($CF19=\"Panelradiator\",IF($N19>0.5,$E19*$H19*(-1085.5*($E19^3)+1428.6*($E19^2)-532.97*$E19+688.74),0),0)","v":0},{"$f":"IF($CF19=\"Panelradiator\",IF($N19>1.5,($N19-1)*$E19*$H19*(6322*($E19^3)-12424*($E19^2)+7584.6*$E19-593.91),0),0)","v":0},{"$f":"IF($CF19=\"Panelradiator\",IF($L19>$N19,IF($N19>0.5,$H19*40,0),0),0)","v":0},null,{"$f":"IF($CF19=\"Konvektor\",$E19*$H19*457.27*($E19^-0.5155),0)","v":0},{"$f":"IF($CF19=\"Konvektor\",IF($L19>1,$E19*$H19*355.73*($E19^-0.4981),0))","v":false},{"$f":"IF($CF19=\"Konvektor\",IF($L19>2,($L19-2)*$E19*$H19*152.96*($E19^-0.8625),0),0)","v":0},{"$f":"IF($CF19=\"Konvektor\",$N19*$E19*$H19*455.51*($E19^-0.5469),0)","v":0},null,{"$f":"IF($CF19=\"Planradiator\",IF($R19=\"enkelt\",$E19*$H19*(-488.27*($E19^3)+1099.6*($E19^2)-835.09*$E19+394.42)*($P19^0.605),0))","v":false},{"$f":"IF($CF19=\"Planradiator\",IF($R19=\"dobbelt\",$E19*$H19*(-23.595*($E19^3)+70.632*($E19^2)-120.62*$E19+202.02)*($P19^0.725),0),0)","v":0},null,{"$f":"IF($CF19=\"søjleradiator\",0.83*V19*(957.42*$T19/1000*$E19+18.244),0)","v":0},null,{"$f":"IF($CF19=\"Gulvvarme\",$X19*50,0)","v":0},null,null,{"$f":"IF($CF19=\"Konvektor\",-999999999,IF($CF19=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF19=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF19=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF19=\"Gulvvarme\",-999999999,999999999)","v":999999999},null,null,null,{"$f":"IF(OR(D19=\"Panelradiator\",D19=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D19=\"Søjleradiator\",D19=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D19=\"Planradiator\",D19=\"Planar radiator\"),\"Planradiator\",IF(OR(D19=\"Konvektor\",D19=\"Convector\"),\"Konvektor\",IF(OR(D19=\"Gulvvarme\",D19=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"Bathroom 1",null,"Panel radiator/convector",0.6,null,60,{"$f":"J21/100","v":2},null,200,null,2,null,2,null,55,null,"enkelt",null,230,null,34,null,20,null,{"$f":"IF(SUM(BD21:BV21)=0,\" \",IF(CF21=\"Gulvvarme\",SUM(BD21:BV21),SUM(BD21:BV21)*((Beregn!C5)/Beregn!C5)^1.3))","v":4663.4970240000002},null,{"$f":"IF(SUM(BD21:BV21)=0,\" \",IF(CF21=\"Gulvvarme\",SUM(BD21:BV21),SUM(BD21:BV21)*((Beregn!J5)/Beregn!C5)^1.3))","v":1822.5212894340457},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF21<>\"Gulvvarme\")*($CF21<>0)","v":100},{"$f":"IF($CF21<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF21<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D19<>\"\",\"\",\"tom\")","v":"tom"},{"$f":"IF(B19<>\"\",\"\",\"tom\")","v":"tom"},{"$f":"IF($CF21=\"Panelradiator\",$E21*$H21*(-132.68*($E21^3)+801.68*($E21^2)-1099.6*$E21+1790.8),0)","v":1669.183104},{"$f":"IF($CF21=\"Panelradiator\",IF($L21>1,$E21*$H21*(-4178.9*($E21^3)+7784.1*($E21^2)-4877.7*$E21+2023.7),0))","v":1196.0563199999999},{"$f":"IF($CF21=\"Panelradiator\",IF($L21>2,($L21-2)*$E21*$H21*(2439.3*($E21^3)-3252.2*($E21^2)+583.01*$E21+1150.4),0))","v":0},{"$f":"IF($CF21=\"Panelradiator\",IF($N21>0.5,$E21*$H21*(-1085.5*($E21^3)+1428.6*($E21^2)-532.97*$E21+688.74),0),0)","v":778.54320000000007},{"$f":"IF($CF21=\"Panelradiator\",IF($N21>1.5,($N21-1)*$E21*$H21*(6322*($E21^3)-12424*($E21^2)+7584.6*$E21-593.91),0),0)","v":1019.7144000000005},{"$f":"IF($CF21=\"Panelradiator\",IF($L21>$N21,IF($N21>0.5,$H21*40,0),0),0)","v":0},null,{"$f":"IF($CF21=\"Konvektor\",$E21*$H21*457.27*($E21^-0.5155),0)","v":0},{"$f":"IF($CF21=\"Konvektor\",IF($L21>1,$E21*$H21*355.73*($E21^-0.4981),0))","v":false},{"$f":"IF($CF21=\"Konvektor\",IF($L21>2,($L21-2)*$E21*$H21*152.96*($E21^-0.8625),0),0)","v":0},{"$f":"IF($CF21=\"Konvektor\",$N21*$E21*$H21*455.51*($E21^-0.5469),0)","v":0},null,{"$f":"IF($CF21=\"Planradiator\",IF($R21=\"enkelt\",$E21*$H21*(-488.27*($E21^3)+1099.6*($E21^2)-835.09*$E21+394.42)*($P21^0.605),0))","v":false},{"$f":"IF($CF21=\"Planradiator\",IF($R21=\"dobbelt\",$E21*$H21*(-23.595*($E21^3)+70.632*($E21^2)-120.62*$E21+202.02)*($P21^0.725),0),0)","v":0},null,{"$f":"IF($CF21=\"søjleradiator\",0.83*V21*(957.42*$T21/1000*$E21+18.244),0)","v":0},null,{"$f":"IF($CF21=\"Gulvvarme\",$X21*50,0)","v":0},null,null,{"$f":"IF($CF21=\"Konvektor\",-999999999,IF($CF21=\"Panelradiator\",-999999999,999999999))","v":-999999999},{"$f":"IF($CF21=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF21=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF21=\"Gulvvarme\",-999999999,999999999)","v":999999999},null,null,null,{"$f":"IF(OR(D21=\"Panelradiator\",D21=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D21=\"Søjleradiator\",D21=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D21=\"Planradiator\",D21=\"Planar radiator\"),\"Planradiator\",IF(OR(D21=\"Konvektor\",D21=\"Convector\"),\"Konvektor\",IF(OR(D21=\"Gulvvarme\",D21=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Panelradiator"}]
[]
[null,"Bathroom 2",null,"Underfloor heating",0.14000000000000001,null,14,{"$f":"J23/100","v":2},null,200,null,1,null,2,null,82,null,"enkelt",null,230,null,34,null,10,null,{"$f":"IF(SUM(BD23:BV23)=0,\" \",IF(CF23=\"Gulvvarme\",SUM(BD23:BV23),SUM(BD23:BV23)*((Beregn!C5)/Beregn!C5)^1.3))","v":500},null,{"$f":"IF(SUM(BD23:BV23)=0,\" \",IF(CF23=\"Gulvvarme\",SUM(BD23:BV23),SUM(BD23:BV23)*((Beregn!J5)/Beregn!C5)^1.3))","v":500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF23<>\"Gulvvarme\")*($CF23<>0)","v":0},{"$f":"IF($CF23<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF23<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D21<>\"\",\"\",\"tom\")","v":""},{"$f":"IF(B21<>\"\",\"\",\"tom\")","v":""},{"$f":"IF($CF23=\"Panelradiator\",$E23*$H23*(-132.68*($E23^3)+801.68*($E23^2)-1099.6*$E23+1790.8),0)","v":0},{"$f":"IF($CF23=\"Panelradiator\",IF($L23>1,$E23*$H23*(-4178.9*($E23^3)+7784.1*($E23^2)-4877.7*$E23+2023.7),0))","v":false},{"$f":"IF($CF23=\"Panelradiator\",IF($L23>2,($L23-2)*$E23*$H23*(2439.3*($E23^3)-3252.2*($E23^2)+583.01*$E23+1150.4),0))","v":false},{"$f":"IF($CF23=\"Panelradiator\",IF($N23>0.5,$E23*$H23*(-1085.5*($E23^3)+1428.6*($E23^2)-532.97*$E23+688.74),0),0)","v":0},{"$f":"IF($CF23=\"Panelradiator\",IF($N23>1.5,($N23-1)*$E23*$H23*(6322*($E23^3)-12424*($E23^2)+7584.6*$E23-593.91),0),0)","v":0},{"$f":"IF($CF23=\"Panelradiator\",IF($L23>$N23,IF($N23>0.5,$H23*40,0),0),0)","v":0},null,{"$f":"IF($CF23=\"Konvektor\",$E23*$H23*457.27*($E23^-0.5155),0)","v":0},{"$f":"IF($CF23=\"Konvektor\",IF($L23>1,$E23*$H23*355.73*($E23^-0.4981),0))","v":false},{"$f":"IF($CF23=\"Konvektor\",IF($L23>2,($L23-2)*$E23*$H23*152.96*($E23^-0.8625),0),0)","v":0},{"$f":"IF($CF23=\"Konvektor\",$N23*$E23*$H23*455.51*($E23^-0.5469),0)","v":0},null,{"$f":"IF($CF23=\"Planradiator\",IF($R23=\"enkelt\",$E23*$H23*(-488.27*($E23^3)+1099.6*($E23^2)-835.09*$E23+394.42)*($P23^0.605),0))","v":false},{"$f":"IF($CF23=\"Planradiator\",IF($R23=\"dobbelt\",$E23*$H23*(-23.595*($E23^3)+70.632*($E23^2)-120.62*$E23+202.02)*($P23^0.725),0),0)","v":0},null,{"$f":"IF($CF23=\"søjleradiator\",0.83*V23*(957.42*$T23/1000*$E23+18.244),0)","v":0},null,{"$f":"IF($CF23=\"Gulvvarme\",$X23*50,0)","v":500},null,null,{"$f":"IF($CF23=\"Konvektor\",-999999999,IF($CF23=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF23=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF23=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF23=\"Gulvvarme\",-999999999,999999999)","v":-999999999},null,null,null,{"$f":"IF(OR(D23=\"Panelradiator\",D23=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D23=\"Søjleradiator\",D23=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D23=\"Planradiator\",D23=\"Planar radiator\"),\"Planradiator\",IF(OR(D23=\"Konvektor\",D23=\"Convector\"),\"Konvektor\",IF(OR(D23=\"Gulvvarme\",D23=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Gulvvarme"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,"enkelt",null,155,null,1,null,6,null,{"$f":"IF(SUM(BD25:BV25)=0,\" \",IF(CF25=\"Gulvvarme\",SUM(BD25:BV25),SUM(BD25:BV25)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD25:BV25)=0,\" \",IF(CF25=\"Gulvvarme\",SUM(BD25:BV25),SUM(BD25:BV25)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF25<>\"Gulvvarme\")*($CF25<>0)","v":100},{"$f":"IF($CF25<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF25<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D23<>\"\",\"\",\"tom\")","v":""},{"$f":"IF(B23<>\"\",\"\",\"tom\")","v":""},{"$f":"IF($CF25=\"Panelradiator\",$E25*$H25*(-132.68*($E25^3)+801.68*($E25^2)-1099.6*$E25+1790.8),0)","v":0},{"$f":"IF($CF25=\"Panelradiator\",IF($L25>1,$E25*$H25*(-4178.9*($E25^3)+7784.1*($E25^2)-4877.7*$E25+2023.7),0))","v":false},{"$f":"IF($CF25=\"Panelradiator\",IF($L25>2,($L25-2)*$E25*$H25*(2439.3*($E25^3)-3252.2*($E25^2)+583.01*$E25+1150.4),0))","v":false},{"$f":"IF($CF25=\"Panelradiator\",IF($N25>0.5,$E25*$H25*(-1085.5*($E25^3)+1428.6*($E25^2)-532.97*$E25+688.74),0),0)","v":0},{"$f":"IF($CF25=\"Panelradiator\",IF($N25>1.5,($N25-1)*$E25*$H25*(6322*($E25^3)-12424*($E25^2)+7584.6*$E25-593.91),0),0)","v":0},{"$f":"IF($CF25=\"Panelradiator\",IF($L25>$N25,IF($N25>0.5,$H25*40,0),0),0)","v":0},null,{"$f":"IF($CF25=\"Konvektor\",$E25*$H25*457.27*($E25^-0.5155),0)","v":0},{"$f":"IF($CF25=\"Konvektor\",IF($L25>1,$E25*$H25*355.73*($E25^-0.4981),0))","v":false},{"$f":"IF($CF25=\"Konvektor\",IF($L25>2,($L25-2)*$E25*$H25*152.96*($E25^-0.8625),0),0)","v":0},{"$f":"IF($CF25=\"Konvektor\",$N25*$E25*$H25*455.51*($E25^-0.5469),0)","v":0},null,{"$f":"IF($CF25=\"Planradiator\",IF($R25=\"enkelt\",$E25*$H25*(-488.27*($E25^3)+1099.6*($E25^2)-835.09*$E25+394.42)*($P25^0.605),0))","v":false},{"$f":"IF($CF25=\"Planradiator\",IF($R25=\"dobbelt\",$E25*$H25*(-23.595*($E25^3)+70.632*($E25^2)-120.62*$E25+202.02)*($P25^0.725),0),0)","v":0},null,{"$f":"IF($CF25=\"søjleradiator\",0.83*V25*(957.42*$T25/1000*$E25+18.244),0)","v":0},null,{"$f":"IF($CF25=\"Gulvvarme\",$X25*50,0)","v":0},null,null,{"$f":"IF($CF25=\"Konvektor\",-999999999,IF($CF25=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF25=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF25=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF25=\"Gulvvarme\",-999999999,999999999)","v":999999999},null,null,null,{"$f":"IF(OR(D25=\"Panelradiator\",D25=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D25=\"Søjleradiator\",D25=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D25=\"Planradiator\",D25=\"Planar radiator\"),\"Planradiator\",IF(OR(D25=\"Konvektor\",D25=\"Convector\"),\"Konvektor\",IF(OR(D25=\"Gulvvarme\",D25=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[]
[null,"Bedroom",null,"Planar radiator",0.45,null,45,{"$f":"J27/100","v":1.2},null,120,null,2,null,2,null,82,null,"dobbelt",null,230,null,34,null,40,null,{"$f":"IF(SUM(BD27:BV27)=0,\" \",IF(CF27=\"Gulvvarme\",SUM(BD27:BV27),SUM(BD27:BV27)*((Beregn!C5)/Beregn!C5)^1.3))","v":2107.3693502882488},null,{"$f":"IF(SUM(BD27:BV27)=0,\" \",IF(CF27=\"Gulvvarme\",SUM(BD27:BV27),SUM(BD27:BV27)*((Beregn!J5)/Beregn!C5)^1.3))","v":823.57198596576745},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF27<>\"Gulvvarme\")*($CF27<>0)","v":100},{"$f":"IF($CF27<>\"Planradiator\",\"enkelt\",\"\")","v":""},{"$f":"IF($CF27<>\"Planradiator\",\"dobbelt\",\"\")","v":""},{"$f":"IF(D25<>\"\",\"\",\"tom\")","v":"tom"},{"$f":"IF(B25<>\"\",\"\",\"tom\")","v":"tom"},{"$f":"IF($CF27=\"Panelradiator\",$E27*$H27*(-132.68*($E27^3)+801.68*($E27^2)-1099.6*$E27+1790.8),0)","v":0},{"$f":"IF($CF27=\"Panelradiator\",IF($L27>1,$E27*$H27*(-4178.9*($E27^3)+7784.1*($E27^2)-4877.7*$E27+2023.7),0))","v":false},{"$f":"IF($CF27=\"Panelradiator\",IF($L27>2,($L27-2)*$E27*$H27*(2439.3*($E27^3)-3252.2*($E27^2)+583.01*$E27+1150.4),0))","v":false},{"$f":"IF($CF27=\"Panelradiator\",IF($N27>0.5,$E27*$H27*(-1085.5*($E27^3)+1428.6*($E27^2)-532.97*$E27+688.74),0),0)","v":0},{"$f":"IF($CF27=\"Panelradiator\",IF($N27>1.5,($N27-1)*$E27*$H27*(6322*($E27^3)-12424*($E27^2)+7584.6*$E27-593.91),0),0)","v":0},{"$f":"IF($CF27=\"Panelradiator\",IF($L27>$N27,IF($N27>0.5,$H27*40,0),0),0)","v":0},null,{"$f":"IF($CF27=\"Konvektor\",$E27*$H27*457.27*($E27^-0.5155),0)","v":0},{"$f":"IF($CF27=\"Konvektor\",IF($L27>1,$E27*$H27*355.73*($E27^-0.4981),0))","v":false},{"$f":"IF($CF27=\"Konvektor\",IF($L27>2,($L27-2)*$E27*$H27*152.96*($E27^-0.8625),0),0)","v":0},{"$f":"IF($CF27=\"Konvektor\",$N27*$E27*$H27*455.51*($E27^-0.5469),0)","v":0},null,{"$f":"IF($CF27=\"Planradiator\",IF($R27=\"enkelt\",$E27*$H27*(-488.27*($E27^3)+1099.6*($E27^2)-835.09*$E27+394.42)*($P27^0.605),0))","v":0},{"$f":"IF($CF27=\"Planradiator\",IF($R27=\"dobbelt\",$E27*$H27*(-23.595*($E27^3)+70.632*($E27^2)-120.62*$E27+202.02)*($P27^0.725),0),0)","v":2107.3693502882488},null,{"$f":"IF($CF27=\"søjleradiator\",0.83*V27*(957.42*$T27/1000*$E27+18.244),0)","v":0},null,{"$f":"IF($CF27=\"Gulvvarme\",$X27*50,0)","v":0},null,null,{"$f":"IF($CF27=\"Konvektor\",-999999999,IF($CF27=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF27=\"Planradiator\",-999999999,999999999)","v":-999999999},{"$f":"IF($CF27=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF27=\"Gulvvarme\",-999999999,999999999)","v":999999999},null,null,null,{"$f":"IF(OR(D27=\"Panelradiator\",D27=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D27=\"Søjleradiator\",D27=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D27=\"Planradiator\",D27=\"Planar radiator\"),\"Planradiator\",IF(OR(D27=\"Konvektor\",D27=\"Convector\"),\"Konvektor\",IF(OR(D27=\"Gulvvarme\",D27=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Planradiator"}]
[]
[null,"Home office",null,"Panel radiator/convector",0.6,null,60,{"$f":"J29/100","v":1},null,100,null,2,null,2,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD29:BV29)=0,\" \",IF(CF29=\"Gulvvarme\",SUM(BD29:BV29),SUM(BD29:BV29)*((Beregn!C5)/Beregn!C5)^1.3))","v":2331.7485120000001},null,{"$f":"IF(SUM(BD29:BV29)=0,\" \",IF(CF29=\"Gulvvarme\",SUM(BD29:BV29),SUM(BD29:BV29)*((Beregn!J5)/Beregn!C5)^1.3))","v":911.26064471702284},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF29<>\"Gulvvarme\")*($CF29<>0)","v":100},{"$f":"IF($CF29<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF29<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D27<>\"\",\"\",\"tom\")","v":""},{"$f":"IF(B27<>\"\",\"\",\"tom\")","v":""},{"$f":"IF($CF29=\"Panelradiator\",$E29*$H29*(-132.68*($E29^3)+801.68*($E29^2)-1099.6*$E29+1790.8),0)","v":834.59155199999998},{"$f":"IF($CF29=\"Panelradiator\",IF($L29>1,$E29*$H29*(-4178.9*($E29^3)+7784.1*($E29^2)-4877.7*$E29+2023.7),0))","v":598.02815999999996},{"$f":"IF($CF29=\"Panelradiator\",IF($L29>2,($L29-2)*$E29*$H29*(2439.3*($E29^3)-3252.2*($E29^2)+583.01*$E29+1150.4),0))","v":0},{"$f":"IF($CF29=\"Panelradiator\",IF($N29>0.5,$E29*$H29*(-1085.5*($E29^3)+1428.6*($E29^2)-532.97*$E29+688.74),0),0)","v":389.27160000000003},{"$f":"IF($CF29=\"Panelradiator\",IF($N29>1.5,($N29-1)*$E29*$H29*(6322*($E29^3)-12424*($E29^2)+7584.6*$E29-593.91),0),0)","v":509.85720000000026},{"$f":"IF($CF29=\"Panelradiator\",IF($L29>$N29,IF($N29>0.5,$H29*40,0),0),0)","v":0},null,{"$f":"IF($CF29=\"Konvektor\",$E29*$H29*457.27*($E29^-0.5155),0)","v":0},{"$f":"IF($CF29=\"Konvektor\",IF($L29>1,$E29*$H29*355.73*($E29^-0.4981),0))","v":false},{"$f":"IF($CF29=\"Konvektor\",IF($L29>2,($L29-2)*$E29*$H29*152.96*($E29^-0.8625),0),0)","v":0},{"$f":"IF($CF29=\"Konvektor\",$N29*$E29*$H29*455.51*($E29^-0.5469),0)","v":0},null,{"$f":"IF($CF29=\"Planradiator\",IF($R29=\"enkelt\",$E29*$H29*(-488.27*($E29^3)+1099.6*($E29^2)-835.09*$E29+394.42)*($P29^0.605),0))","v":false},{"$f":"IF($CF29=\"Planradiator\",IF($R29=\"dobbelt\",$E29*$H29*(-23.595*($E29^3)+70.632*($E29^2)-120.62*$E29+202.02)*($P29^0.725),0),0)","v":0},null,{"$f":"IF($CF29=\"søjleradiator\",0.83*V29*(957.42*$T29/1000*$E29+18.244),0)","v":0},null,{"$f":"IF($CF29=\"Gulvvarme\",$X29*50,0)","v":0},null,null,{"$f":"IF($CF29=\"Konvektor\",-999999999,IF($CF29=\"Panelradiator\",-999999999,999999999))","v":-999999999},{"$f":"IF($CF29=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF29=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF29=\"Gulvvarme\",-999999999,999999999)","v":999999999},null,null,null,{"$f":"IF(OR(D29=\"Panelradiator\",D29=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D29=\"Søjleradiator\",D29=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D29=\"Planradiator\",D29=\"Planar radiator\"),\"Planradiator\",IF(OR(D29=\"Konvektor\",D29=\"Convector\"),\"Konvektor\",IF(OR(D29=\"Gulvvarme\",D29=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Panelradiator"}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD30:BV30)=0,\" \",IF(D30=\"gulvvarme\",SUM(BD30:BV30),SUM(BD30:BV30)*((Beregning!J45-20)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BF30:BX30)=0,\" \",IF(F30=\"gulvvarme\",SUM(BF30:BX30),SUM(BF30:BX30)*((Beregning!L45-20)/Beregn!E5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*($CF30<>\"Gulvvarme\")*($CF30<>0)","v":0},{"$f":"IF($CF30<>\"Planradiator\",\"enkelt\",\"\")","v":"enkelt"},{"$f":"IF($CF30<>\"Planradiator\",\"dobbelt\",\"\")","v":"dobbelt"},{"$f":"IF(D29<>\"\",\"\",\"tom\")","v":""},{"$f":"IF(B29<>\"\",\"\",\"tom\")","v":""},{"$f":"IF($CF30=\"Panelradiator\",$E30*$H30*(-132.68*($E30^3)+801.68*($E30^2)-1099.6*$E30+1790.8),0)","v":0},{"$f":"IF($CF30=\"Panelradiator\",IF($L30>1,$E30*$H30*(-4178.9*($E30^3)+7784.1*($E30^2)-4877.7*$E30+2023.7),0))","v":false},{"$f":"IF($CF30=\"Panelradiator\",IF($L30>2,($L30-2)*$E30*$H30*(2439.3*($E30^3)-3252.2*($E30^2)+583.01*$E30+1150.4),0))","v":false},{"$f":"IF($CF30=\"Panelradiator\",IF($N30>0.5,$E30*$H30*(-1085.5*($E30^3)+1428.6*($E30^2)-532.97*$E30+688.74),0),0)","v":0},{"$f":"IF($CF30=\"Panelradiator\",IF($N30>1.5,($N30-1)*$E30*$H30*(6322*($E30^3)-12424*($E30^2)+7584.6*$E30-593.91),0),0)","v":0},{"$f":"IF($CF30=\"Panelradiator\",IF($L30>$N30,IF($N30>0.5,$H30*40,0),0),0)","v":0},null,{"$f":"IF($CF30=\"Konvektor\",$E30*$H30*457.27*($E30^-0.5155),0)","v":0},{"$f":"IF($CF30=\"Konvektor\",IF($L30>1,$E30*$H30*355.73*($E30^-0.4981),0))","v":false},{"$f":"IF($CF30=\"Konvektor\",IF($L30>2,($L30-2)*$E30*$H30*152.96*($E30^-0.8625),0),0)","v":0},{"$f":"IF($CF30=\"Konvektor\",$N30*$E30*$H30*455.51*($E30^-0.5469),0)","v":0},null,{"$f":"IF($CF30=\"Planradiator\",IF($R30=\"enkelt\",$E30*$H30*(-488.27*($E30^3)+1099.6*($E30^2)-835.09*$E30+394.42)*($P30^0.605),0))","v":false},{"$f":"IF($CF30=\"Planradiator\",IF($R30=\"dobbelt\",$E30*$H30*(-23.595*($E30^3)+70.632*($E30^2)-120.62*$E30+202.02)*($P30^0.725),0),0)","v":0},null,{"$f":"IF($CF30=\"søjleradiator\",0.83*V30*(957.42*$T30/1000*$E30+18.244),0)","v":0},null,{"$f":"IF($CF30=\"Gulvvarme\",$X30*50,0)","v":0},null,null,{"$f":"IF($CF30=\"Konvektor\",-999999999,IF($CF30=\"Panelradiator\",-999999999,999999999))","v":999999999},{"$f":"IF($CF30=\"Planradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF30=\"Søjleradiator\",-999999999,999999999)","v":999999999},{"$f":"IF($CF30=\"Gulvvarme\",-999999999,999999999)","v":999999999}]
[null,"Children's room 1",null,"Convector",0.14000000000000001,null,14,{"$f":"J31/100","v":2},null,200,null,2,null,2,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD31:BV31)=0,\" \",IF(CF31=\"Gulvvarme\",SUM(BD31:BV31),SUM(BD31:BV31)*((Beregn!C5)/Beregn!C5)^1.3))","v":1365.5882448732059},null,{"$f":"IF(SUM(BD31:BV31)=0,\" \",IF(CF31=\"Gulvvarme\",SUM(BD31:BV31),SUM(BD31:BV31)*((Beregn!J5)/Beregn!C5)^1.3))","v":533.67969059998916},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,352.77819889579519,265.21137620199045,0,747.59866977542038,null,false,0,null,0,null,0,null,null,-999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D31=\"Panelradiator\",D31=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D31=\"Søjleradiator\",D31=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D31=\"Planradiator\",D31=\"Planar radiator\"),\"Planradiator\",IF(OR(D31=\"Konvektor\",D31=\"Convector\"),\"Konvektor\",IF(OR(D31=\"Gulvvarme\",D31=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Konvektor"}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD32:BV32)=0,\" \",IF(D32=\"gulvvarme\",SUM(BD32:BV32),SUM(BD32:BV32)*((Beregning!J47-20)/Beregn!C7)^1.3))","v":" "},null,{"$f":"IF(SUM(BF32:BX32)=0,\" \",IF(F32=\"gulvvarme\",SUM(BF32:BX32),SUM(BF32:BX32)*((Beregning!L47-20)/Beregn!E7)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","","",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,"Children's room 2",null,"Panel radiator/convector",0.6,null,60,{"$f":"J33/100","v":1},null,100,null,1,null,1,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD33:BV33)=0,\" \",IF(CF33=\"Gulvvarme\",SUM(BD33:BV33),SUM(BD33:BV33)*((Beregn!C5)/Beregn!C5)^1.3))","v":1223.8631519999999},null,{"$f":"IF(SUM(BD33:BV33)=0,\" \",IF(CF33=\"Gulvvarme\",SUM(BD33:BV33),SUM(BD33:BV33)*((Beregn!J5)/Beregn!C5)^1.3))","v":478.29271432893171},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",834.59155199999998,0,0,389.27160000000003,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,-999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D33=\"Panelradiator\",D33=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D33=\"Søjleradiator\",D33=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D33=\"Planradiator\",D33=\"Planar radiator\"),\"Planradiator\",IF(OR(D33=\"Konvektor\",D33=\"Convector\"),\"Konvektor\",IF(OR(D33=\"Gulvvarme\",D33=\"Underfloor heating\"),\"Gulvvarme\")))))","v":"Panelradiator"}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD34:BV34)=0,\" \",IF(D34=\"gulvvarme\",SUM(BD34:BV34),SUM(BD34:BV34)*((Beregning!J50-20)/Beregn!C9)^1.3))","v":" "},null,{"$f":"IF(SUM(BF34:BX34)=0,\" \",IF(F34=\"gulvvarme\",SUM(BF34:BX34),SUM(BF34:BX34)*((Beregning!L50-20)/Beregn!E9)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","","",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,null,null,null,0.14000000000000001,null,14,{"$f":"J35/100","v":2},null,200,null,1,null,2,null,55,null,"enkelt",null,null,null,null,null,6,null,{"$f":"IF(SUM(BD35:BV35)=0,\" \",IF(CF35=\"Gulvvarme\",SUM(BD35:BV35),SUM(BD35:BV35)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD35:BV35)=0,\" \",IF(CF35=\"Gulvvarme\",SUM(BD35:BV35),SUM(BD35:BV35)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D35=\"Panelradiator\",D35=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D35=\"Søjleradiator\",D35=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D35=\"Planradiator\",D35=\"Planar radiator\"),\"Planradiator\",IF(OR(D35=\"Konvektor\",D35=\"Convector\"),\"Konvektor\",IF(OR(D35=\"Gulvvarme\",D35=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD36:BV36)=0,\" \",IF(D36=\"gulvvarme\",SUM(BD36:BV36),SUM(BD36:BV36)*((Beregning!J52-20)/Beregn!C11)^1.3))","v":" "},null,{"$f":"IF(SUM(BF36:BX36)=0,\" \",IF(F36=\"gulvvarme\",SUM(BF36:BX36),SUM(BF36:BX36)*((Beregning!L52-20)/Beregn!E11)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,null,null,null,0.14000000000000001,null,14,{"$f":"J37/100","v":2},null,200,null,1,null,2,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD37:BV37)=0,\" \",IF(CF37=\"Gulvvarme\",SUM(BD37:BV37),SUM(BD37:BV37)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD37:BV37)=0,\" \",IF(CF37=\"Gulvvarme\",SUM(BD37:BV37),SUM(BD37:BV37)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D37=\"Panelradiator\",D37=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D37=\"Søjleradiator\",D37=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D37=\"Planradiator\",D37=\"Planar radiator\"),\"Planradiator\",IF(OR(D37=\"Konvektor\",D37=\"Convector\"),\"Konvektor\",IF(OR(D37=\"Gulvvarme\",D37=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD38:BV38)=0,\" \",IF(D38=\"gulvvarme\",SUM(BD38:BV38),SUM(BD38:BV38)*((Beregning!J54-20)/Beregn!C13)^1.3))","v":" "},null,{"$f":"IF(SUM(BF38:BX38)=0,\" \",IF(F38=\"gulvvarme\",SUM(BF38:BX38),SUM(BF38:BX38)*((Beregning!L54-20)/Beregn!E13)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,null,null,null,0.14000000000000001,null,14,{"$f":"J39/100","v":2},null,200,null,1,null,2,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD39:BV39)=0,\" \",IF(CF39=\"Gulvvarme\",SUM(BD39:BV39),SUM(BD39:BV39)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD39:BV39)=0,\" \",IF(CF39=\"Gulvvarme\",SUM(BD39:BV39),SUM(BD39:BV39)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D39=\"Panelradiator\",D39=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D39=\"Søjleradiator\",D39=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D39=\"Planradiator\",D39=\"Planar radiator\"),\"Planradiator\",IF(OR(D39=\"Konvektor\",D39=\"Convector\"),\"Konvektor\",IF(OR(D39=\"Gulvvarme\",D39=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD40:BV40)=0,\" \",IF(D40=\"gulvvarme\",SUM(BD40:BV40),SUM(BD40:BV40)*((Beregning!J56-20)/Beregn!#REF!)^1.3))","v":" "},null,{"$f":"IF(SUM(BF40:BX40)=0,\" \",IF(F40=\"gulvvarme\",SUM(BF40:BX40),SUM(BF40:BX40)*((Beregning!L56-20)/Beregn!#REF!)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,null,null,null,0.14000000000000001,null,14,{"$f":"J41/100","v":2},null,200,null,1,null,2,null,55,null,"enkelt",null,230,null,34,null,6,null,{"$f":"IF(SUM(BD41:BV41)=0,\" \",IF(CF41=\"Gulvvarme\",SUM(BD41:BV41),SUM(BD41:BV41)*((Beregn!C5)/Beregn!C5)^1.3))","v":" "},null,{"$f":"IF(SUM(BD41:BV41)=0,\" \",IF(CF41=\"Gulvvarme\",SUM(BD41:BV41),SUM(BD41:BV41)*((Beregn!J5)/Beregn!C5)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999,null,null,null,{"$f":"IF(OR(D41=\"Panelradiator\",D41=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D41=\"Søjleradiator\",D41=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D41=\"Planradiator\",D41=\"Planar radiator\"),\"Planradiator\",IF(OR(D41=\"Konvektor\",D41=\"Convector\"),\"Konvektor\",IF(OR(D41=\"Gulvvarme\",D41=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD42:BV42)=0,\" \",IF(D42=\"gulvvarme\",SUM(BD42:BV42),SUM(BD42:BV42)*((Beregning!#REF!-20)/Beregn!#REF!)^1.3))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"enkelt","dobbelt","tom","tom",0,false,false,0,0,0,null,0,false,0,0,null,false,0,null,0,null,0,null,null,999999999,999999999,999999999,999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(Z17:Z32)","v":10968.203131161456},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D43=\"Panelradiator\",D43=\"Panel radiator/convector\"),\"Panelradiator\",IF(OR(D43=\"Søjleradiator\",D43=\"Pillar radiator\"),\"Søjleradiator\",IF(OR(D43=\"Planradiator\",D43=\"Planar radiator\"),\"Planradiator\",IF(OR(D43=\"Konvektor\",D43=\"Convector\"),\"Konvektor\",IF(OR(D43=\"Gulvvarme\",D43=\"Underfloor heating\"),\"Gulvvarme\")))))","v":false}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(D17:D42,\"<>gulvvarme\",AZ17:AZ42)","v":1200}]

{"sheet":"Definitions","index":4,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,6,13,8],[24,6,26,8],[30,6,32,7],[24,10,26,14]]}
[]
[null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Panelradiator/konvektor\",\"Panel radiator/convector\")","v":"Panel radiator/convector"},null,null,null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Planradiator\",\"Planar radiator\")","v":"Planar radiator"},null,null,null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Søjleradiator\",\"Column radiator\")","v":"Column radiator"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Panel-radiator med 3 paneler og  2 stk. konvektorblik\",\"Panel radiator/convector with 3 panels and 2 pcs. of convector veilings\")","v":"Panel radiator/convector with 3 panels and 2 pcs. of convector veilings"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Gulvarme\",\"Underfloor heating\")","v":"Underfloor heating"}]
[]
[null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Konvektorblik (her ses 2 stk.)\",\"Convector veilings (2 pcs. Are shown here\")","v":"Convector veilings (2 pcs. Are shown here"},null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"For gulvarme regnes som standard med en varmeafgivelse på 50 W pr. kvadratmeter\",\"For underfloor heating, the thermal output is by default set to 50 Watt per square meter\")","v":"For underfloor heating, the thermal output is by default set to 50 Watt per square meter"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF('Heat emitters'!AR5=\"Dansk\",\"Paneler\",\"Panel radiator/convector\")","v":"Panel radiator/convector"}]

{"sheet":"Beregn","index":5,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Frem",90,75,60,60,60,60,null,{"$f":"'Heat emitters'!G5","v":60}]
[null,"Retur",70,65,50,50,50,50,null,{"$f":"'Heat emitters'!G7","v":40}]
[null,"Rum",20,20,20,20,20,20,null,{"$f":"'Heat emitters'!G9","v":20}]
[null,"Logmid",{"$f":"(C2-C3)/LN((C2-C4)/(C3-C4))","v":59.440268239769239},{"$f":"(D2-D3)/LN((D2-D4)/(D3-D4))","v":49.83288654563971},34.76059496782208,{"$f":"(F2-F3)/LN((F2-F4)/(F3-F4))","v":34.76059496782208},34.76059496782208,34.76059496782208,null,{"$f":"(J2-J3)/LN((J2-J4)/(J3-J4))","v":28.85390081777927}]
[]
[]
[null,"Installeret radiatoreffekt ved 90/70/20 °C",null,null,null,{"$f":"(SUM('Heat emitters'!$Z17:$Z64)-'Heat emitters'!BV15)/(((Beregning!J45-20)/Beregn!C5)^1.3)+0.1","v":28789.344169945372},null,null,{"$f":"F8*(D5/C5)^1.3","v":22892.732851572317}]
[]
[null,"Gulvvarme ved - 12 og ved -7",null,{"$f":"'Heat emitters'!BV15","v":500}]
[null,"GV andel",null,{"$f":"D10/Beregning!J33","v":7.3333333333333334E-2}]
[null,"Gv frem",null,{"$f":"Beregning!G41","v":36}]
[null,"GV retur ved -12",null,{"$f":"Beregning!G43","v":30}]
[]
[null,"Situation -12:"]
[null,"Ved -12 skal rad yde",null,{"$f":"MAX(0,Beregning!J33-Beregn!D10)","v":6318.181818181818}]
[null,"Nødvendig middel",null,{"$f":"(D16/$F$8)^(1/1.3)*$C$5+20","v":38.511212840122951}]
[]
[null,"Frem rad",null,{"$f":"MAX(D17+(Beregning!G37-Beregning!G39)/2*D16/Beregning!J47,D12)","v":41.213110997017672},null,{"$f":"D19-D16/Beregning!J47*(Beregning!G37-Beregning!G39)","v":35.809314683228223}]
[null,"Retur",null,{"$f":"D19-2*(D19-D17)","v":35.80931468322823},null,{"$f":"D19-2*(D19-D17)","v":35.80931468322823}]
[null,"mcrad",null,{"$f":"D16/(D19-D20)","v":1169.2116895781287}]
[null,"mc gulv",null,{"$f":"D10/(D19-D13)","v":44.590658215457239},null,{"$f":"D10/(D19-D13)","v":44.590658215457239}]
[null,"mc sum",null,{"$f":"D21+D22","v":1213.802347793586},null,null,{"$f":"D23/4186*3600","v":1043.8816177871261}]
[null,"Samlet retur",null,{"$f":"(D21*D20+D22*D13)/D23","v":35.595901712016932}]
[]
[]
[null,"Situation -7 "]
[null,"Nødvendig ydelse",null,{"$f":"MAX(0,Beregning!M33-Beregn!D10)","v":5252.840909090909}]
[null,"Nødvendig middel ved -7",null,{"$f":"(D28/$F$8)^(1/1.3)*$C$5+20","v":36.059950550997947}]
[null,"Frem",null,{"$f":"MAX(D29+(Beregning!G37-Beregning!G39)*Beregn!D28/Beregning!J47/2,37)","v":38.306267858596122}]
[null,"ret",null,{"$f":"D30-2*(D30-D29)","v":33.813633243399771}]
[null,"Flow W/K rad",null,{"$f":"D28/(D30-D31+0.0000001)","v":1169.2116635530499}]
[null,"Flow gulv W/K",null,{"$f":"D10/(D30-D13)","v":60.195506394915022}]
[null,null,"tot",{"$f":"D32+D33","v":1229.407169947965},null,null,{"$f":"D34/4186*3600","v":1057.3019139542937}]
[]
[]
[null,"ved  -12",null,{"$f":"D34/4186*3600","v":1057.3019139542937},null,null,null,","]

{"sheet":"Ark2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ark3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}