{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Introduktion","Konfiguration","Input","Beregninger","Ventilation","Gulvvarme","Data fra producenter","Regression","Regression - bøjninger","Drop-down"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Introduktion","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Konfiguration","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Valg","Indtastning","Kommentarer"]
["Hustype","2-plan"]
["Tagtype","Sadeltag"]
["Brutto areal",135]
["Netto areal",115]
["Loftshøjde",2.95]
["Antal værelser",6]
["Antal wc-rum uden bad",0]
["Antal bade- og wc-rum",1]
["Antal depot/bryggers/viktualierum",1]
["Antal køkkener",1]
["Køkkenalrum","Ja"]

{"sheet":"Input","index":2,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,5],[1,6,1,11],[6,0,6,5]]}
[]
["Ventilation",null,null,null,null,null,"Bolig information"]
[]
[null,"Ækvivalent længde af Ø125mm ventilationskanal ",null,null,{"$f":"Beregninger!G33","v":50.672002836397169},"m",null,"Hustype",null,null,{"$f":"Konfiguration!B2","v":"2-plan"}]
[null,"Ækvivalent materialemængde af Ø125mm ventilationskanal",null,null,{"$f":"Beregninger!G34","v":74.687929979792443},"kg",null,"Tagtype",null,null,{"$f":"Konfiguration!B3","v":"Sadeltag"}]
[null,null,null,null,null,null,null,"Rumfang",null,null,{"$f":"Konfiguration!B5*Konfiguration!B6","v":339.25},"m3"]
["Yderligere information vedr. ventilation",null,null,null,null,null,null,"Antal værelser",null,null,{"$f":"Konfiguration!B7","v":6},"stk"]
[null,null,null,null,null,null,null,"Antal wc-rum uden bad",null,null,{"$f":"Konfiguration!B8","v":0},"stk"]
[null,"Antal udsugningsarmaturer",null,null,{"$f":"Beregninger!L9","v":3},"stk",null,"Antal bade- og wc-rum",null,null,{"$f":"Konfiguration!B9","v":1},"stk"]
[null,"Antal indblæsningsarmaturer",null,null,{"$f":"Beregninger!L10","v":7},"stk",null,"Antal depoter/bryggers/viktualierum",null,null,{"$f":"Konfiguration!B10","v":1},"stk"]
[null,"Antal aggregater",null,null,{"$f":"Beregninger!L11","v":1},"stk",null,"Antal køkkener",null,null,{"$f":"Konfiguration!B11","v":1},"stk"]
[null,null,null,null,null,null,null,"Brutto areal",null,null,{"$f":"Konfiguration!B4","v":135},"m2"]
[null,"Basis ventilation",null,null,{"$f":"Beregninger!G9","v":145.80000000000001},"m3/h",null,"Netto areal",null,null,{"$f":"Konfiguration!B5","v":115},"m2"]
[null,"Forceret ventilation",null,null,{"$f":"Beregninger!G10","v":162},"m3/h",null,"Loftshøjde",null,null,{"$f":"Konfiguration!B6","v":2.95},"m"]
[null,"Basis luftskifte",null,null,{"$f":"Beregninger!G11","v":0.42977155490051588},"h-1"]
[null,"Forceret luftskifte",null,null,{"$f":"Beregninger!G12","v":0.47752394988946206},"h-1"]

{"sheet":"Beregninger","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[5,2,6,12],[14,2,15,12]]}
[]
[]
[]
[]
[]
[null,null,"Luftmængder, luftskifte og armaturer"]
[]
[]
[null,null,"Basis ventilation",null,null,null,{"$f":"Input!K12*0.3*3.6","v":145.80000000000001},"m3/h",null,"Antal udsugningsarmaturer",null,{"$f":"IF(Input!K10>2,Input!K8+Input!K9+Input!K10+Input!K11-1,Input!K8+Input!K9+Input!K10+Input!K11)","v":3}]
[null,null,"Forceret ventilation",null,null,null,{"$f":"(MAX(G9,Input!K11*72+Input!K9*54+Input!K10*36+Input!K8*36))","v":162},"m3/h",null,"Antal indblæsningsarmaturer",null,{"$f":"IF(Konfiguration!B12=\"Ja\",Input!K7+1,Input!K7)","v":7}]
[null,null,"Basis luftskifte",null,null,null,{"$f":"Input!E13/Input!K6","v":0.42977155490051588},"h-1",null,"Antal aggregater",null,{"$f":"IF(Konfiguration!B4*0.3*3.6<MAX(('Data fra producenter'!AT38:'Data fra producenter'!AE36)),1,IF(Konfiguration!B4<'Data fra producenter'!AT38,1,ROUND((Konfiguration!B4/'Data fra producenter'!AT38)+0.25,0)))","v":1}]
[null,null,"Forceret luftskifte",null,null,null,{"$f":"(MAX(G11,Input!E14/Input!K6))","v":0.47752394988946206},"h-1"]
[]
[]
[null,null,"Kanallængder og -mængder"]
[]
[]
[null,null,"Kanaldimensioner",null,"øD [mm]",100,125,160]
[null,null,"Procentvis længder",null,null,{"$f":"IF((Input!K8+Input!K9+Input!K10)>3,9.45,8.45)","v":8.4499999999999993},{"$f":"100-(F19+H19)","v":83.41},{"$f":"IF(G9<(0.034*3600),7.14,8.14)","v":8.14}]
[]
[null,null,"Længde af ventilationskanal",null,null,null,{"$f":"Regression!O23","v":40.745295000000006},"m"]
[null,null,"Ækvivalent mængde af ventilationskanal",null,null,null,{"$f":"((((F19/100)*G21)*Ventilation!G7)*Ventilation!H7)+(((G19/100)*G21)*Ventilation!G8)+((((H19/100)*G21)*Ventilation!G9)*Ventilation!H9)","v":60.691271930472446},"kg"]
[null,null,"Ækvivalent længde af ventilationskanal",null,null,null,{"$f":"Beregninger!G22/Ventilation!G8","v":43.043455269838617},"m"]
[]
[null,null,"Antal af bøjninger",null,null,null,{"$f":"Regression!T23","v":21.250202000000002},"stk"]
[null,null,"Ækvivalent mængde af bøjninger",null,null,null,{"$f":"((((F19/100)*G25)*Ventilation!N7)*Ventilation!O7)+(((G19/100)*G25)*Ventilation!N8)+((((H19/100)*G25)*Ventilation!N9)*Ventilation!O9)","v":13.996658049320001},"kg"]
[null,null,"Ækvivalent længde af ventilationskanal",null,null,null,{"$f":"G26/Ventilation!G8","v":9.9267078363971635},"m"]
[]
[null,null,"Længde af emhættekanal",null,null,null,{"$f":"IF(Input!K4=\"2-plan\",'Data fra producenter'!AT32,'Data fra producenter'!AT31)","v":1.35},"m"]
[null,null,"Ækvivalænt mængde af emhættekanal",null,null,null,{"$f":"(G29*Ventilation!G8)*Ventilation!H9","v":2.7269999999999999},"kg"]
[null,null,"Ækvivalent længde af emhættekanal",null,null,null,{"$f":"G30/Ventilation!G8","v":1.9340425531914893},"m"]
[]
[null,null,"Samlet ækvivalent kanallængde",null,null,null,{"$f":"G21+G27","v":50.672002836397169},"m"]
[null,null,"Samlet ækvivalent kanalmængde",null,null,null,{"$f":"G22+G26","v":74.687929979792443},"kg"]

{"sheet":"Ventilation","index":4,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":true,"merged":[[11,12,11,13],[11,15,11,16],[1,11,2,17],[1,1,2,8],[4,2,4,7],[4,12,4,14]]}
[]
[null,"Mateialedata på kanal.",null,null,null,null,null,null,null,null,null,"Materialedata på bøjninger og samlinger. "]
[]
[]
[null,null,"Rør - Lindab",null,null,null,null,null,null,null,null,null,"Bøjninger - Air2Trust"]
[null,null,"Ød [mm]","Omkr. [m]","Areal [m2]","t [mm]","vægt [kg/m]","Forhold",null,null,null,null,"Ød [mm]","vægt [kg]","Forhold"]
[null,null,100,0.314,8.0000000000000002E-3,0.45,1.1399999999999999,{"$f":"G7/G8","v":0.80851063829787229},null,null,null,null,100,0.4,{"$f":"N7/N8","v":0.66666666666666674}]
[null,null,125,0.39300000000000002,1.2E-2,0.45,1.41,{"$f":"G8/G8","v":1},null,null,null,null,125,0.6,{"$f":"N8/N8","v":1}]
[null,null,160,0.503,0.02,0.5,2.02,{"$f":"G9/G8","v":1.4326241134751774},null,null,null,null,160,1,{"$f":"N9/N8","v":1.6666666666666667}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Samlinger / Nippel - Lindab",null,null,"Samlinger / Muffe - Lindab"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ød [mm]","vægt [kg]",null,"Ød [mm]","vægt [kg]"]
[null,null,null,null,null,null,null,null,null,null,null,null,100,0.12,null,100,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,125,0.15,null,125,0.14000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,160,0.19,null,160,0.21]

{"sheet":"Gulvvarme","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[3,2,3,9],[1,1,1,10]]}
[]
[null,"Materialedata på gulvvarmerør"]
[]
[null,null,"Gulvvarmerør - Uponor/Wirsbo"]
[null,null,"Ød [mm]","t [mm]","Areal [mm2]","Rørtype","Centerafstand [mm]","Max kredslængde [m]","Rørforbrug [m/m2]","kg/m"]
[null,null,12,1.7,{"$f":"(C6-(2*D6))*PI()","v":27.017696820872221},"evalPEX",125,70,8.1999999999999993,6.8000000000000005E-2]
[null,null,15,2.5,{"$f":"(C7-(2*D7))*PI()","v":31.415926535897931},"evalPEX",200,75,5,9.4E-2]
[null,null,16,2,37.699111843077517,"Unipipe",250,80,4,8.5000000000000006E-2]
[null,null,17,2,40.840704496667314,"pePEX",200,80,5,{"$f":"11.3/100","v":0.113}]
[null,null,20,2,50.26548245743669,"pePEX",300,120,3.3,{"$f":"11.7/100","v":0.11699999999999999}]
[null,null,20,2,50.26548245743669,"pePEX",300,120,3.3,{"$f":"11.7/100","v":0.11699999999999999}]

{"sheet":"Data fra producenter","index":6,"n_rows":110,"n_cols":68,"rows_kept":110,"cut":false,"hidden":true,"merged":[[56,44,57,45],[1,38,2,39],[23,38,24,39],[1,42,2,46],[34,44,35,45],[45,44,46,45]]}
[]
[null,"Huse","Producent","Type","Tag","Type-værdi","Tag-værdi","Antal værelser","Brutto","Netto","B/N","Kanallængde pr. kvdm","Højde","Samlet kanallængde [m","Antal bøjninger","Køkkenalrum","Gulvvarme - c.afstand","Gulvvarme længde","Gulvvarme m/m2","Gulvvarme kg","Gulvvarme kg/m2","Gulvvarme m2","Gulvvarme m2/m2","Gulvvarme antal kredse","Indblæsning","Udsugning","Emhætte ","Emhætte - kanallængde","Kanal - Ind","Kanal - Ud","Kanal - Indtag/afkast","Aggregat","Aggregat - placering","Aggregat - luftmin","Aggregat - luftmax","kvmd/værelse forhold",null,null,"Værdier fra producenter (Skal udbygges med mere data for at blive mere retvisende)",null,null,null,"Gulvarme"]
[null,"Bygning 2","pro_13","1 plans","Ensidig hældning",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":2},6,166,135.30000000000001,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2269031781226902},{"$f":"(AC3+AD3+Table1[[#This Row],[Kanal - Indtag/afkast]])/I3","v":0.27710843373493976},2.75,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":48.25},18,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,5,4,1,2.25,22.5,16,7.5,"Danfoss Air W2","Væg",50,300,{"$f":"J3/H3","v":22.55}]
[null,"Bygning 6 ","pro_13","1 plans","Ensidig hældning",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":2},7,168,150.9,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1133200795228628},{"$f":"(AC4+AD4+Table1[[#This Row],[Kanal - Indtag/afkast]])/I4","v":0.27976190476190477},3.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":49.75},23,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,4,1,2.75,25,16,6,"Dantherm HCV400P2","Skab",70,290,21.557142857142857]
[null,"Bygning 7","pro_14","1 plans","Ensidig hældning",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":2},6,182.4,151.9,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2007899934167214},{"$f":"(AC5+AD5+Table1[[#This Row],[Kanal - Indtag/afkast]])/I5","v":0.34375},2.75,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":65.3},22,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":2.7649769585253456},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.32350230414746545},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,6,1,2.6,25,32,5.7,"Nilan CT300LR","Skab",100,400,25.316666666666666,null,null,null,null,null,null,"Gennemsnit - m/m2",{"$f":"AVERAGE(Table1[Gulvvarme m/m2])","v":2.319966870592411},null,"Gennemsnit - kg",{"$f":"AVERAGE(Table1[Gulvvarme kg])","v":32.368333333333332}]
[null,"Type 1 - Bygning 2","pro_12","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,170,{"$f":"7.7+10+8.1+10+11.9+5.6+37.9+2.8+24.1+7.5+12.1+3.4","v":141.1},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2048192771084338},{"$f":"(AC6+AD6+Table1[[#This Row],[Kanal - Indtag/afkast]])/I6","v":0.35588235294117648},{"$f":"((37.9/J6)*3+(1-(37.9/J6))*2.5)","v":2.6343019135364991},{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":60.5},23,"Ja",300,{"$f":"28.7+43.3+45.3+36.3+33.3+109.3+70.3+60+83+79+27.7+47.7+31","v":694.90000000000009},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":4.9248759744861808},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":81.303300000000007},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.57621048901488314},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":210.57575757575762},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.4923866589352064},13,6,4,0,0,{"$f":"((4335-1570)+(1170)+(3800-780)+(780)+(780)+(580)+((12120+8270)-(1250+435)))/1000","v":27.8},{"$f":"((3030+1210)+900+450+450+225+12100+(1125+2000+2500)+(2000+3000+1210))/1000","v":30.2},2.5,"Nilan CT300","Skab",100,400,23.516666666666666,null,null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Kanallængde pr. kvdm])","v":0.31992865218159339},null,null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme m/m2])","v":5.0583194095575692},null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme kg])","v":82.29}]
[null,"Type 2 - Bygning 4","pro_12","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,150,{"$f":"6.6+13.5+21.5+33.1+8+2.1+10.1+10+7.7+5.3+7.7","v":125.6},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1942675159235669},{"$f":"(AC7+AD7+Table1[[#This Row],[Kanal - Indtag/afkast]])/I7","v":0.30613333333333337},2.5499999999999998,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":45.92},{"$f":"6+10+7","v":23},"Ja",300,{"$f":"36+40+25+55+55+70+85+75+120+20+45+30","v":656},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":5.2229299363057331},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":76.751999999999995},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.6110828025477707},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":198.78787878787881},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.5827060413047678},12,6,4,0,0,{"$f":"((6500+2500+500)+900+300+300+300+(5710-900-1500)+900+(600+600+2860+1120)+3080)/1000","v":23.77},{"$f":"((5650+3550)+2850+900+200+3250+3250)/1000","v":19.649999999999999},2.5,"Nilan CT300LR","Loft",100,400,20.933333333333334,null,null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Kanallængde pr. kvdm])","v":0.34794630798400084},null,null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme m/m2])","v":4.349774040237703},null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme kg])","v":34.212500000000006}]
[null,"Type 3 - Bygning 5","pro_12","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,185,{"$f":"8.6+11+11+6.5+7.9+4.5+11+3.5+38.9+23.3+10.2+7.9+6.7","v":151},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2251655629139073},{"$f":"(AC8+AD8+Table1[[#This Row],[Kanal - Indtag/afkast]])/I8","v":0.29777027027027025},2.5499999999999998,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":55.087499999999999},22,"Ja",300,{"$f":"23.7+31.7+40.3+46.7+109.7+83.5+62.3+88.8+100.3+55.7+33+52.7+30.7","v":759.10000000000014},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":5.0271523178807955},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":88.814700000000016},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.58817682119205306},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":230.03030303030309},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.5233794902669078},13,6,5,0,0,{"$f":"((900)+550+550+550+(900+1300+800)+(600+1610+4860)+(800+1920+200+500)+800+200+(3500)+3250)/1000","v":23.79},{"$f":"((1800)+(17.5*453)+(22*453)+(950)+(8.5*453)+(9.5*453))/1000","v":28.797499999999999},2.5,"Nilan CT300LR","Loft",100,400,25.166666666666668,null,null,"pro_13 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_13\",Table1[Kanallængde pr. kvdm])","v":0.32635881939370948},null,null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme m/m2])","v":2.232089592130289},null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme kg])","v":31.470000000000002}]
[null,"Bygning 1 ","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,180,145,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2413793103448276},{"$f":"(AC9+AD9+Table1[[#This Row],[Kanal - Indtag/afkast]])/I9","v":0.35833333333333334},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":66},22,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,4,1,1.5,27.5,31.5,5.5,"Dantherm HCV400P2","Skab",70,290,24.166666666666668,null,null,"pro_14 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_14\",Table1[Kanallængde pr. kvdm])","v":0.34775887188507937},null,null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme m/m2])","v":3.2866169336757571},null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme kg])","v":42.25}]
[null,"Bygning 4","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,160,154.1,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.0382868267358858},{"$f":"(AC10+AD10+Table1[[#This Row],[Kanal - Indtag/afkast]])/I10","v":0.4},2.41,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":66},22,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,5,4,1,2,31.5,27,5.5,"Dantherm HCV400P2","Skab",70,290,25.683333333333334]
[null,"Bygning 5","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},5,174,145.6,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.195054945054945},{"$f":"(AC11+AD11+Table1[[#This Row],[Kanal - Indtag/afkast]])/I11","v":0.32758620689655171},2.7,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":59.6},22,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,5,4,1,2.6,29,21.5,6.5,"Dantherm HCV400P2","Skab",70,290,29.119999999999997,null,null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Kanallængde pr. kvdm])","v":0.3379493657507544},null,null,"Median - m/m2",{"$f":"MEDIAN(Table1[Gulvvarme m/m2])","v":2.7199038647800773},null,"Median - kg",{"$f":"MEDIAN(Table1[Gulvvarme kg])","v":35.615000000000002}]
[null,"Bygning 7","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,160,146,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.095890410958904},{"$f":"(AC12+AD12+Table1[[#This Row],[Kanal - Indtag/afkast]])/I12","v":0.29375000000000001},2.6,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":49},22,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,4,1,2,24.5,16.5,6,"Dantherm HCV400P2","Skab",70,290,24.333333333333332,null,null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Kanallængde pr. kvdm])","v":0.31799274579410408},null,null,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme m/m2] ))","v":5.0271523178807955},null,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme kg] ))","v":81.303300000000007}]
[null,"Bygning 8","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},7,224,169,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.3254437869822486},{"$f":"(AC13+AD13+Table1[[#This Row],[Kanal - Indtag/afkast]])/I13","v":0.2924107142857143},2.6,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":67.5},23,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,7,4,1,2,33,26.5,6,"Dantherm HCV400P2","Skab",70,290,24.142857142857142,null,null,null,null,null,null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme m/m2] ))","v":4.3782811121496144},null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme kg] ))","v":35.445}]
[null,"Bygning 9","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,171,130.9,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.3063407181054238},{"$f":"(AC14+AD14+Table1[[#This Row],[Kanal - Indtag/afkast]])/I14","v":0.35380116959064328},2.7,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":62.75},23,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,4,1,2.25,29.5,24,7,"Dantherm HCV400P2","Skab",70,290,21.816666666666666,null,null,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Kanallængde pr. kvdm] ))","v":0.30613333333333337},null,null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme m/m2] ))","v":2.7199038647800773},null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme kg] ))","v":35.615000000000002}]
[null,"Bygning 4","pro_14","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,189,156.69999999999999,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2061263560944482},{"$f":"(AC15+AD15+Table1[[#This Row],[Kanal - Indtag/afkast]])/I15","v":0.35449735449735448},2.75,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":69.099999999999994},24,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":2.6802807913209956},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.31359285258455649},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,6,1,2.1,28,36,3,"Nilan CT350TOP","Loft",100,400,26.116666666666664,null,null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Kanallængde pr. kvdm] ))","v":0.34024044205495818},null,null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme m/m2] ))","v":3.2866169336757571},null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme kg] ))","v":42.25}]
[null,"Bygning 5","pro_14","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,160,135.65,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1795060818282344},{"$f":"(AC16+AD16+Table1[[#This Row],[Kanal - Indtag/afkast]])/I16","v":0.33374999999999999},2.7,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":55.4},19,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":3.0962034647991152},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.36225580538149649},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,4,1,2,18.399999999999999,30.4,4.5999999999999996,"Nilan CT300LR","Skab",100,400,22.608333333333334,null,null,"pro_13 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_13\",Table1[Kanallængde pr. kvdm] ))","v":0.32758620689655171}]
[null,"Bygning 6","pro_14","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},6,182,152.19999999999999,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1957950065703022},{"$f":"(AC17+AD17+Table1[[#This Row],[Kanal - Indtag/afkast]])/I17","v":0.34340659340659346},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":64.75},21,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":2.7595269382391594},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.3228646517739816},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,6,1,2.25,30.8,28.1,3.6,"Nilan CT300LR","Skab",100,400,25.366666666666664,null,null,"pro_14 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_14\",Table1[Kanallængde pr. kvdm] ))","v":0.34357829670329676},null,null,"Gennemsnit - m/m2 - 200mm",{"$f":"AVERAGEIF(Table1[Gulvvarme - c.afstand], \"200\",Table1[Gulvvarme m/m2])","v":{"$error":"#DIV/0!"}},null,"Gennemsnit - kg/m2",{"$f":"AVERAGE(Table1[Gulvvarme kg/m2])","v":0.2482373289780444}]
[null,"Bygning 3","pro_13","1 plans","Fladt",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":3},5,134,121.3,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.104699093157461},{"$f":"(AC18+AD18+Table1[[#This Row],[Kanal - Indtag/afkast]])/I18","v":0.35447761194029853},2.42,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":49.65},21,"Ja",null,null,{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":0},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,3,1,2.15,23,18,6.5,"Dantherm HCV400P2","Skab",70,290,24.259999999999998,null,null,null,null,null,null,"Gennemsnit - m/m2 - 250mm",{"$f":"AVERAGEIF(Table1[Gulvvarme - c.afstand], \"250\",Table1[Gulvvarme m/m2])","v":4.349774040237703},null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme kg/m2])","v":0.59182337091823567}]
[null,"Type 1  BB - Bolig 1-7 - 1 plan","pro_11","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},3,108,{"$f":"10.8+6.8+57.8+6+5+9.4","v":95.800000000000011},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1273486430062629},{"$f":"(AC19+AD19+Table1[[#This Row],[Kanal - Indtag/afkast]])/I19","v":0.36435185185185187},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":42.5},{"$f":"(1*Y19+Z19)+(2*Y19+Z19)","v":19},"Ja",250,{"$f":"86+95+60+43+44+35+55","v":418},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":4.3632567849686845},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":35.53},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.37087682672233818},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":104.5},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.0908141962421711},7,5,2,1,3.15,{"$f":"2+1+6.25+8.25+9+1.5","v":28},{"$f":"2.25+5+1","v":8.25},3.1,"Dantherm HCH5U","Loft",70,280,31.933333333333337,null,null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Kanallængde pr. kvdm] ))","v":0.34357829670329676},null,null,"Gennemsnit - m/m2 - 300mm",{"$f":"AVERAGEIF(Table1[Gulvvarme - c.afstand], \"300\",Table1[Gulvvarme m/m2])","v":5.0583194095575692},null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme kg/m2])","v":0.36973079342020476}]
[null,"Type 2 A - Bolig 1-7 - 1 plan","pro_11","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},3,95,{"$f":"3.7+6.2+9.7+10.9+2.9+44.6","v":78},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2179487179487178},{"$f":"(AC20+AD20+Table1[[#This Row],[Kanal - Indtag/afkast]])/I20","v":0.48000000000000004},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":48.75},{"$f":"(1*Y20+Z20)+(2*Y20+Z20)","v":19},"Ja",250,{"$f":"78+69+44+42+29+40+54","v":356},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":4.5641025641025639},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":30.26},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.38794871794871799},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":89},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.141025641025641},7,5,2,1,3.15,{"$f":"1.5+2+3+8+9+1.5","v":25},{"$f":"6.5+10+1","v":17.5},3.1,"Dantherm HCH5U","Loft",70,280,26,null,null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Kanallængde pr. kvdm] ))","v":0.31799274579410408},null,null,"Median - m/m2 - 200mm",{"$f":"MEDIAN(IF(Table1[Gulvvarme - c.afstand]=200,Table1[Gulvvarme m/m2] ))","v":{"$error":"#NUM!"}},null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme kg/m2])","v":0.24177896985975034}]
[null,"Type 3 B - Bolig 8-11 - 1 plan","pro_11","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},3,115,{"$f":"9.4+12+5+6+6.8+56.4","v":95.6},{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2029288702928871},{"$f":"(AC21+AD21+Table1[[#This Row],[Kanal - Indtag/afkast]])/I21","v":0.23130434782608697},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":29.75},{"$f":"(1*Y21+Z21)+(2*Y21+Z21)","v":16},"Ja",250,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":4.3933054393305442},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":35.700000000000003},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.37343096234309631},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":105},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.098326359832636},7,4,2,1,3.15,{"$f":"1.5+1+2+4.5+6.5","v":15.5},{"$f":"1+2.5+4.5","v":8},3.1,"Dantherm HCH5U","Loft",70,280,31.866666666666664,null,null,null,null,null,null,"Median - m/m2 - 250mm",{"$f":"MEDIAN(IF(Table1[Gulvvarme - c.afstand]=250,Table1[Gulvvarme m/m2] ))","v":4.3782811121496144},null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme kg/m2])","v":0.31927927927927929}]
[null,"Bygning 1 ","pro_14","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},6,154,129.80000000000001,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1864406779661016},{"$f":"(AC22+AD22+Table1[[#This Row],[Kanal - Indtag/afkast]])/I22","v":0.32467532467532467},2.4700000000000002,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":54.75},24,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":3.2357473035439135},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.37858243451463786},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,5,1,4.75,29,16,5,"Nilan CT300LR","Loft",100,400,21.633333333333336,null,null,null,null,null,null,"Median - m/m2 - 300mm",{"$f":"MEDIAN(IF(Table1[Gulvvarme - c.afstand]=300,Table1[Gulvvarme m/m2] ))","v":5.0271523178807955}]
[null,"Bygning 2","pro_14","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},6,190,160.5,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.1838006230529594},{"$f":"(AC23+AD23+Table1[[#This Row],[Kanal - Indtag/afkast]])/I23","v":0.37289473684210522},2.67,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":75.349999999999994},22,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":2.6168224299065419},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.30616822429906543},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,5,1,4.5,37,28.1,5.75,"Nilan CT300LR","Loft",100,400,26.75,null,null,null,null,null,null,null,null,null,"Median - kg/m2",{"$f":"MEDIAN(Table1[Gulvvarme kg/m2])","v":0.31822875217926905}]
[null,"Bygning 3","pro_14","1 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":1},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},6,158,121.5,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.3004115226337449},{"$f":"(AC24+AD24+Table1[[#This Row],[Kanal - Indtag/afkast]])/I24","v":0.38924050632911394},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":66.3},23,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":3.4567901234567899},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.40444444444444444},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,6,5,1,4.8,33.5,23.25,4.75,"Nilan CT300LR","Loft",100,400,20.25,null,null,"Emhætte - kanallængder ( Foreløbig version - mangler data)",null,null,null,"Gennemsnit - kredse",{"$f":"AVERAGE(Table1[Gulvvarme antal kredse])","v":9.7142857142857135},null,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme kg/m2] ))","v":0.58817682119205306}]
[null,"Type 4  - 2 plan","pro_11","2 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":2},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},5,124,102,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2156862745098038},{"$f":"(AC25+AD25+Table1[[#This Row],[Kanal - Indtag/afkast]])/I25","v":0.31612903225806455},2.5,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":40.399999999999991},21,"Ja",250,{"$f":"12+77+30+85+40+41+32+30+69","v":416},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":4.0784313725490193},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":35.36},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.34666666666666668},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":104},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":1.0196078431372548},9,4,3,1,1.2,{"$f":"IF(Konfiguration!B2 = \"2-plan\",Input!K14,0)+12.5","v":15.45},{"$f":"IF(Konfiguration!B2 = \"2-plan\",Input!K14,0)+12.5","v":15.45},8.3000000000000007,"Dantherm HCH5V","Skab",70,380,20.399999999999999,null,null,null,null,null,null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme antal kredse])","v":12.666666666666666},null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme kg/m2] ))","v":0.37215389453271724}]
[null,"Bygning 8","pro_14","2 plans","Sadel",{"$f":"IF(Table1[[#This Row],[Type]]=\"1 plans\",1,IF(Table1[[#This Row],[Type]]=\"2 plans\",2,0))","v":2},{"$f":"IF(Table1[[#This Row],[Tag]]=\"Ensidig hældning\",2,IF(Table1[[#This Row],[Tag]]=\"Fladt\",3,IF(Table1[[#This Row],[Tag]]=\"Sadel\",1,0)))","v":1},7,209,168.35,{"$f":"IF(Table1[[#This Row],[Netto]]=\" \",\" \",Table1[[#This Row],[Brutto]]/Table1[[#This Row],[Netto]])","v":1.2414612414612416},{"$f":"(AC26+AD26+Table1[[#This Row],[Kanal - Indtag/afkast]])/I26","v":0.31985645933014356},2.4500000000000002,{"$f":"Table1[[#This Row],[Emhætte - kanallængde]]+Table1[[#This Row],[Kanal - Ind]]+Table1[[#This Row],[Kanal - Ud]]+Table1[[#This Row],[Kanal - Indtag/afkast]]","v":68.350000000000009},21,"Ja",null,{"$f":"(36+55+44+87+95+43+60)","v":420},{"$f":"Table1[[#This Row],[Gulvvarme længde]]/Table1[[#This Row],[Netto]]","v":2.4948024948024949},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=200,(Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$9),IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$8,Table1[[#This Row],[Gulvvarme længde]]*Gulvvarme!J$10))","v":49.14},{"$f":"Table1[[#This Row],[Gulvvarme kg]]/Table1[[#This Row],[Netto]]","v":0.29189189189189191},{"$f":"IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=250,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$8,IF(Table1[[#This Row],[Gulvvarme - c.afstand]]=300,Table1[[#This Row],[Gulvvarme længde]]/Gulvvarme!I$10,\"\"))","v":""},{"$f":"Table1[[#This Row],[Gulvvarme m2]]/Table1[[#This Row],[Netto]]","v":{"$error":"#VALUE!"}},null,7,5,1,1.5,31.1,29.55,6.2,"Nilan CT300LR","Loft",100,400,24.05,null,null,null,null,null,null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme antal kredse])","v":7.5},null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme kg/m2] ))","v":0.31822875217926905}]
[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,"Gennemsnit",{"$f":"AVERAGEIF(Table1[[Emhætte ]], \"1\",Table1[Emhætte - kanallængde])","v":2.6023809523809525},null,null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme antal kredse])","v":9.8333333333333339},null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme kg/m2] ))","v":0.31927927927927929}]
[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,"Median",{"$f":"MEDIAN(IF(Table1[[Emhætte ]]=1,Table1[Emhætte - kanallængde] ))","v":2.25},null,null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme antal kredse])","v":9}]
[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,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Emhætte - kanallængde])","v":2.3613636363636363},null,null,null,null,null,"Gennemsnit - m2",{"$f":"AVERAGE(Table1[Gulvvarme m2])","v":148.84199134199136},null,"Ensidig hældning","Fladt","Sadel"]
[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,"2-plan - gennemsnit ",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Emhætte - kanallængde])","v":1.35},null,null,"Median - kredse",{"$f":"MEDIAN(Table1[Gulvvarme antal kredse])","v":9},null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme m2])","v":213.13131313131316}]
[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,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Emhætte - kanallængde] ))","v":2.25},null,null,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme antal kredse] ))","v":13},null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme m2])","v":100.625}]
[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,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Emhætte - kanallængde] ))","v":1.35},null,null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme antal kredse] ))","v":7},null,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme m2])","v":156.31565656565658}]
[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,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme antal kredse] ))","v":0},null,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme m2])","v":104}]
[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,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme antal kredse] ))","v":4.5}]
[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,"Aggregat (max. Luftmængde)",null,null,null,null,null,null,"Median - m2",{"$f":"MEDIAN(Table1[Gulvvarme m2])","v":105}]
[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,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme m2] ))","v":210.57575757575762}]
[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,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme m2] ))","v":104.25}]
[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,"Gennemsnit",{"$f":"AVERAGE(Table1[Aggregat - luftmax])","v":343.33333333333331},null,null,null,null,null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme m2] ))","v":151.89393939393941}]
[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,"Median",{"$f":"MEDIAN(Table1[Aggregat - luftmax])","v":340},null,null,null,null,null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme m2] ))","v":104}]
[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,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Aggregat - luftmax])","v":339.09090909090907}]
[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,"2-plan - gennemsnit ",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Aggregat - luftmax])","v":390},null,null,null,null,null,"Gennemsnit - m2/m2",{"$f":"AVERAGE(Table1[Gulvvarme m2/m2])","v":{"$error":"#VALUE!"}}]
[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,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Aggregat - luftmax] ))","v":295},null,null,null,null,null,"pro_12 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_12\",Table1[Gulvvarme m2/m2])","v":1.5328240635022941}]
[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,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Aggregat - luftmax] ))","v":390},null,null,null,null,null,"pro_11 - gennemsnit",{"$f":"AVERAGEIF(Table1[Producent], \"pro_11\",Table1[Gulvvarme m2/m2])","v":1.0874435100594257}]
[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,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Gulvvarme m2/m2])","v":{"$error":"#VALUE!"}}]
[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,"2-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Gulvvarme m2/m2])","v":{"$error":"#VALUE!"}}]
[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,"Bøjninger (antal)"]
[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,"Median - m2/m2",{"$f":"MEDIAN(Table1[Gulvvarme m2/m2])","v":{"$error":"#VALUE!"}}]
[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,"pro_12 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_12\",Table1[Gulvvarme m2/m2] ))","v":1.5233794902669078}]
[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,"Gennemsnit",{"$f":"AVERAGE(Table1[Antal bøjninger])","v":21.458333333333332},null,null,null,null,null,"pro_11 - median",{"$f":"MEDIAN(IF(Table1[Producent]=\"pro_11\",Table1[Gulvvarme m2/m2] ))","v":1.0945702780374036}]
[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,"Median",{"$f":"MEDIAN(Table1[Antal bøjninger])","v":22},null,null,null,null,null,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Gulvvarme m2/m2] ))","v":{"$error":"#VALUE!"}}]
[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,"1-plan - gennemsnit",{"$f":"AVERAGEIF(Table1[Type], \"1 plans\",Table1[Antal bøjninger])","v":21.5},null,null,null,null,null,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Gulvvarme m2/m2] ))","v":{"$error":"#VALUE!"}}]
[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,"2-plan - gennemsnit ",{"$f":"AVERAGEIF(Table1[Type], \"2 plans\",Table1[Antal bøjninger])","v":21},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ensidig","Fladt","Sadel","Indtastet"]
[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,"1-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"1 plans\",Table1[Antal bøjninger] ))","v":22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I tilfælde af kvdm lighed",null,null,{"$f":"VLOOKUP(BJ60,BB60:BE110,2,FALSE)","v":15.271000000000015},{"$f":"VLOOKUP(BJ60,BB60:BE110,3,FALSE)","v":50.230499999999999},{"$f":"VLOOKUP(BJ60,BB60:BE110,4,FALSE)","v":49.484400000000001},{"$f":"VLOOKUP(BL60,BB60:BF110,5,FALSE)","v":46.383070054945065}]
[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,"2-plan - median",{"$f":"MEDIAN(IF(Table1[Type]=\"2 plans\",Table1[Antal bøjninger] ))","v":21}]
[]
[]
[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,"Tagtype - Kanallængde"]
[]
[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,"M2","Ensidig hældning","Fladt","Sadel","Indtastet",null,null,null,"Tagtype",null,"Hustype",null,"Forskel","Tilføjelse"]
[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,"Gennemsnit - Sadel",{"$f":"AVERAGEIF(Table1[Tag], \"Sadel\",Table1[Kanallængde pr. kvdm])","v":0.34980653238908632},null,null,null,null,null,null,null,50,{"$f":"1.0546*BB60-127.1","v":-74.37},{"$f":"0.2445*BB60+17.223","v":29.448},{"$f":"0.3335*BB60+4.4619","v":21.136900000000001},{"$f":"$AN$19*BB60","v":17.178914835164839},null,null,"x",{"$f":"Konfiguration!B4","v":135},null,{"$f":"Konfiguration!B4","v":135}]
[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,"Median - Sadel",{"$f":"MEDIAN(IF(Table1[Tag]=\"Sadel\",Table1[Kanallængde pr. kvdm] ))","v":0.34451358826358824},null,null,null,null,null,null,null,55,{"$f":"1.0546*BB61-127.1","v":-69.096999999999994},{"$f":"0.2445*BB61+17.223","v":30.670499999999997},{"$f":"0.3335*BB61+4.4619","v":22.804400000000001},{"$f":"$AN$19*BB61","v":18.896806318681321},null,null,"x1",{"$f":"_xlfn.XLOOKUP(BJ60,BB60:BB110,BB60:BB110,,1,1)","v":135},null,{"$f":"_xlfn.XLOOKUP(BL60,BB60:BB110,BB60:BB110,,1,1)","v":135}]
[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,"Gennemsnit - Fladt",{"$f":"AVERAGEIF(Table1[Tag], \"Fladt\",Table1[Kanallængde pr. kvdm])","v":0.33629222619194377},null,null,null,null,null,null,null,60,-63.823999999999998,31.893000000000001,24.471900000000002,20.614697802197806,null,null,"x2",{"$f":"_xlfn.XLOOKUP(BJ60,BB60:BB110,BB60:BB110,,-1,1)","v":135},null,{"$f":"_xlfn.XLOOKUP(BL60,BB60:BB110,BB60:BB110,,-1,1)","v":135}]
[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,"Median - Fladt",{"$f":"MEDIAN(IF(Table1[Tag]=\"Fladt\",Table1[Kanallængde pr. kvdm] ))","v":0.34340659340659346},null,null,null,null,null,null,null,65,-58.551000000000002,33.115499999999997,26.139400000000002,22.332589285714288,null,null,"y1",{"$f":"IF(Konfiguration!B3=\"Sadeltag\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BE60:BE110,,-1,1),IF(Konfiguration!B3=\"Fladt tag\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BD60:BD110,,-1,1),IF(Konfiguration!B3=\"Ensidig hældning\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BC60:BC110,,-1,1),0)))","v":49.484400000000001},null,{"$f":"_xlfn.XLOOKUP(BL60,BB60:BB110,BF60:BF110,,-1,1)","v":46.383070054945065}]
[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,"Gennemsnit - Ensidig",{"$f":"AVERAGEIF(Table1[Tag], \"Ensidig hældning\",Table1[Kanallængde pr. kvdm])","v":0.3002067794989482},null,null,null,null,null,null,null,70,-53.277999999999992,34.337999999999994,27.806900000000002,24.050480769230774,null,null,"y2",{"$f":"IF(Konfiguration!B3=\"Sadeltag\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BE60:BE110,,1,1),IF(Konfiguration!B3=\"Fladt tag\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BD60:BD110,,1,1),IF(Konfiguration!B3=\"Ensidig hældning\",_xlfn.XLOOKUP('Data fra producenter'!BJ60,'Data fra producenter'!BB60:BB110,'Data fra producenter'!BC60:BC110,,1,1),0)))","v":49.484400000000001},null,{"$f":"_xlfn.XLOOKUP(BL61,BB61:BB111,BF61:BF111,,1,1)","v":46.383070054945065}]
[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,"Median - Ensidig",{"$f":"MEDIAN(IF(Table1[Tag]=\"Ensidig hældning\",Table1[Kanallængde pr. kvdm] ))","v":0.27976190476190477},null,null,null,null,null,null,null,75,-48.004999999999995,35.560499999999998,29.474400000000003,25.768372252747255]
[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,80,-42.731999999999999,36.783000000000001,31.1419,27.486263736263741,null,null,"y",{"$f":"IF(BI67=FALSE,FORECAST(BJ60,BJ63:BJ64,BJ61:BJ62),(IF(Konfiguration!B3=\"Ensidig hældning\",'Data fra producenter'!BL53,IF(Konfiguration!B3=\"Fladt tag\",'Data fra producenter'!BM53,IF(Konfiguration!B3=\"Sadeltag\",'Data fra producenter'!BN53,)))))","v":49.484400000000001},null,{"$f":"IF(BI67=FALSE,FORECAST(BL60,BL63:BL64,BL61:BL62),BO53)","v":46.383070054945065},null,{"$f":"BL66-BJ66","v":-3.1013299450549354},{"$f":"IF(BN66<0,IF(ABS(BN66)>5,-ABS(BN66/2),-ABS(BN66)),IF(ABS(BN66>5),ABS(BN66)/2,ABS(BN66)))","v":-3.1013299450549354},{"$f":"IF(ABS(BO66)>5,5,BO66)","v":-3.1013299450549354}]
[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,85,-37.458999999999989,38.005499999999998,32.809399999999997,29.204155219780226,null,null,{"$f":"COUNTIF(BB60:BB110,BJ60)>0","v":true}]
[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,90,-32.185999999999993,39.227999999999994,34.476900000000001,30.922046703296708]
[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,95,-26.912999999999997,40.450499999999998,36.144400000000005,32.63993818681319]
[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,100,-21.64,41.673000000000002,37.811900000000001,34.357829670329679]
[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,105,-16.36699999999999,42.895499999999998,39.479400000000005,36.07572115384616]
[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,110,-11.093999999999994,44.117999999999995,41.146900000000002,37.793612637362642]
[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,115,-5.820999999999998,45.340499999999999,42.814399999999999,39.511504120879124]
[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,120,-0.54800000000000182,46.563000000000002,44.481900000000003,41.229395604395613]
[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,125,4.7249999999999943,47.785499999999999,46.1494,42.947287087912095]
[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,130,9.9979999999999905,49.007999999999996,47.816900000000004,44.665178571428577]
[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,135,15.271000000000015,50.230499999999999,49.484400000000001,46.383070054945065]
[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,140,20.544000000000011,51.452999999999996,51.151900000000005,48.100961538461547]
[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,145,25.817000000000007,52.6755,52.819400000000002,49.818853021978029]
[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,150,31.090000000000003,53.897999999999996,54.486900000000006,51.536744505494511]
[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,155,36.363,55.1205,56.154400000000003,53.254635989011]
[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,160,41.635999999999996,56.342999999999996,57.821899999999999,54.972527472527482]
[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,165,46.908999999999992,57.5655,59.489400000000003,56.690418956043963]
[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,170,52.182000000000016,58.787999999999997,61.1569,58.408310439560452]
[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,175,57.455000000000013,60.0105,62.824400000000004,60.126201923076934]
[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,180,62.728000000000009,61.232999999999997,64.491900000000001,61.844093406593416]
[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,185,68.001000000000005,62.455500000000001,66.159400000000005,63.561984890109898]
[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,190,73.274000000000001,63.677999999999997,67.826899999999995,65.279876373626379]
[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,195,78.546999999999997,64.900499999999994,69.494399999999999,66.997767857142861]
[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,200,{"$f":"1.0546*BB90-127.1","v":83.82},66.12299999999999,71.161900000000003,68.715659340659357]
[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,205,89.092999999999989,67.345500000000001,72.829400000000007,70.433550824175839]
[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,210,94.366000000000014,68.567999999999998,74.496900000000011,72.151442307692321]
[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,215,99.63900000000001,69.790499999999994,76.164400000000001,73.869333791208803]
[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,220,104.91200000000001,71.013000000000005,77.831900000000005,75.587225274725284]
[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,225,110.185,72.235500000000002,79.499400000000009,77.305116758241766]
[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,230,115.458,73.457999999999998,81.166899999999998,79.023008241758248]
[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,235,120.73099999999999,74.680499999999995,82.834400000000002,80.740899725274744]
[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,240,126.00399999999999,75.902999999999992,84.501900000000006,82.458791208791226]
[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,245,131.27700000000002,77.125499999999988,86.16940000000001,84.176682692307708]
[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,250,136.54999999999998,78.347999999999999,87.8369,85.894574175824189]
[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,255,141.82300000000001,79.570499999999996,89.504400000000004,87.612465659340671]
[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,260,147.09599999999998,80.793000000000006,91.171900000000008,89.330357142857153]
[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,265,152.369,82.015500000000003,92.839400000000012,91.048248626373635]
[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,270,157.64200000000002,83.238,94.506900000000002,92.766140109890131]
[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,275,162.91499999999999,84.460499999999996,96.174400000000006,94.484031593406613]
[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,280,168.18800000000002,85.682999999999993,97.84190000000001,96.201923076923094]
[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,285,173.46099999999998,86.905500000000004,99.509399999999999,97.919814560439576]
[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,290,178.73400000000001,88.128,101.1769,99.637706043956058]
[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,295,184.00699999999998,89.350499999999997,102.84440000000001,101.35559752747254]
[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,300,189.28,90.572999999999993,104.51190000000001,103.07348901098902]

{"sheet":"Regression","index":7,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.80706772627625534]
["R Square",0.65135831479672457]
["Adjusted R Square",0.55451340224025925]
["Standard Error",7.6895633101014074]
["Observations",24]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",5,1988.4583937052114,397.69167874104227,6.7257876289263034,1.0680167505814045E-3]
["Residual",18,1064.3289102010388,59.129383900057711]
["Total",23,3052.7873039062501]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95,0%","Upper 95,0%"]
["Intercept",17.315226891368489,11.573821069439356,1.4960683068696561,0.1519637643447399,-7.0004688832227515,41.63092266595973,-7.0004688832227515,41.63092266595973]
["Type-værdi",-8.9835650428969771,6.5535845108638089,-1.3707864799797751,0.18729355986537893,-22.752135184353037,4.7850050985590808,-22.752135184353037,4.7850050985590808]
["Tag-værdi",-2.2010936651206423,2.2106161684889498,-0.99569237595198778,0.33259735000731872,-6.8454258960122729,2.4432385657709883,-6.8454258960122729,2.4432385657709883]
["Antal værelser",-0.89343379385586064,2.8962105278184191,-0.30848371873326585,0.76125592091170857,-6.9781463249277067,5.1912787372159848,-6.9781463249277067,5.1912787372159848]
["Brutto",0.26746917100710493,0.17268923642622164,1.5488467986907586,0.13882124184779504,-9.5337451913139581E-2,0.63027579392734945,-9.5337451913139581E-2,0.63027579392734945]
["Netto",0.11174390715737588,0.2342437852958342,0.47704107503322152,0.63907337626069838,-0.38038402416013173,0.60387183847488346,-0.38038402416013173,0.60387183847488346]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kanallængde fra regression:",null,{"$f":"(N25*(-8.98357))+(N26*(-2.20109))+(N27*(-0.89343))+(N28*(0.267469))+(N29*(0.111744))+N30","v":40.745295000000006},null,null,"Antal bøjninger: ",null,{"$f":"(N25*(-0.94526))+(N26*(0.099158))+(N27*(1.370884))+(N28*(0.000762))+(N29*(-0.0136))+S30","v":21.250202000000002}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type-værdi",{"$f":"IF(Konfiguration!B2=\"1-plan\",1,IF(Konfiguration!B2=\"2-plan\",2,0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tag-værdi",{"$f":"IF(Konfiguration!B3=\"Ensidig hældning\",2,IF(Konfiguration!B3=\"Fladt tag\",3,IF(Konfiguration!B3=\"Sadeltag\",1,0)))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Antal værelser",{"$f":"Konfiguration!B7","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Brutto-areal",{"$f":"Konfiguration!B4","v":135}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Netto-areal",{"$f":"Konfiguration!B5","v":115}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Intercept",17.31523,null,null,null,"Intercept",16.27739]

{"sheet":"Regression - bøjninger","index":8,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.68016435316418578]
["R Square",0.46262354731525523]
["Adjusted R Square",0.31335231045838163]
["Standard Error",1.6387917306509441]
["Observations",24]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",5,41.616843277234835,8.3233686554469664,3.0992142696508558,3.4314375840163384E-2]
["Residual",18,48.341490056098493,2.6856383364499163]
["Total",23,89.958333333333329]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95,0%","Upper 95,0%"]
["Intercept",16.277386001976136,2.4666007022420642,6.5991167468575247,3.3830581029486838E-6,11.095250222161763,21.45952178179051,11.095250222161763,21.45952178179051]
["Type-værdi",-0.9452574505807908,1.3966931110921679,-0.67678249650822053,0.50714884162969209,-3.8796007911271504,1.989085889965569,-3.8796007911271504,1.989085889965569]
["Tag-værdi",9.9157579395482934E-2,0.47112421739267651,0.21047013873378589,0.83566492173218632,-0.89063767261610116,1.0889528314070671,-0.89063767261610116,1.0889528314070671]
["Antal værelser",1.3708839373550674,0.61723737380223731,2.2209995627942942,3.9421010121300303E-2,7.4116334673451023E-2,2.667651540036684,7.4116334673451023E-2,2.667651540036684]
["Brutto",7.6193207065716382E-4,3.6803350361385573E-2,2.0702791000696236E-2,0.98371051188496195,-7.655903785829074E-2,7.8082901999605075E-2,-7.655903785829074E-2,7.8082901999605075E-2]
["Netto",-1.3598623962307099E-2,4.9921791760906366E-2,-0.27239855547324621,0.78841577682039699,-0.11848041656111873,9.1283168636504528E-2,-0.11848041656111873,9.1283168636504528E-2]

{"sheet":"Drop-down","index":9,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Hustype","Antal","Værelser","Tagtype","Bool"]
["1-plan",0,0,"Sadeltag","Ja"]
["2-plan",1,1,"Fladt tag","Nej"]
[null,2,2,"Ensidig hældning"]
[null,3,3]
[null,4,4]
[null,5,5]
[null,6,6]
[null,7,7]
[null,8,8]
[null,9,9]
[null,10,10]