{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Index","HVAC","Duct Loss","Fan Laws","Misc.","P Loss","Psych","Weight","Calc","Load","Conv.","Plan","U values","Hygro","Process","Process 2","Sound","Pipes","PFEER","Mod Temp","Mod Temp2","temp","Acoustic"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":1,"defined_names":3,"comments":1,"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":"Index","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"WARNING: This spreadsheet contains rules of thumb and should be used for estimating only"]
[]
[]
[null,null,"Press",null,"Ventilation Rate, Sizing of Heating & Cooling Loads",null,null,null,null,null,"Press",null,"Psychrometric Chart"]
[]
[null,null,"Press",null,"Duct Sizing & Estimation of System Pressure Loss",null,null,null,null,null,"Press",null,"Psychrometric Calcs"]
[]
[null,null,"Press",null,"Fan Laws, Changes to Fan Duty",null,null,null,null,null,"Press",null,"Conversions"]
[]
[null,null,"Press",null,"Sizing Pressure Relief Outlets, Door Air Loss",null,null,null,null,null,"Press",null,"Natural Ventilation by Temp Diff."]
[]
[null,null,"Press",null,"Duct Weight & Flange Drilling",null,null,null,null,null,"Press",null,"Load Estimate Sheet"]
[]
[null,null,"Press",null,"Pressure Loss Spreadsheet",null,null,null,null,null,"Press",null,"Date Plan Set Up"]
[]
[null,null,"Press",null,"Sound Attenuation Spreadsheet",null,null,null,null,null,"Press",null,"U Values"]
[]
[null,null,"Press",null,"Preliminary Pipe Sizing",null,null,null,null,null,"Press",null,"Hygrometric Sheet"]
[]
[null,null,"Press",null,"Air Leakage Test Sheet",null,null,null,null,null,"Press",null,"Process"]
[]
[null,null,"Press",null,"Module Temperature",null,null,null,null,null,"Press",null,"Noise Addition"]

{"sheet":"HVAC","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[null,null,null,null,null,"ENTER",null,null,null,"ANSWER"]
[]
[null,null,null,null,"Module Width",4.0,"m",null,"m3/s",{"$f":"(F5*F6*F7*F8)/3600","v":0.055},"supply airflow"]
[null,null,null,null,"Module Length",11.0,"m",null,"deg C",{"$f":"F9*0.00082","v":0.492},"pick up from fan"]
[null,null,null,null,"Module Height",3.0,"m",null,"kW",{"$f":"J5*F9/800","v":0.04125},"typ. Fan power"]
[null,null,null,null,"Required ventilation",1.5,"ac / h"]
[null,null,null,null,"Fan resistance ~ Est.",600.0,"Pa"]
[null,null,null,null,"Required pressurisation",0.0,"Pa",null,"m3/s",{"$f":"J5-(F5*F6*F7-(101325*F5*F6*F7)/(101325+F10))","v":0.055},"Extract airflow"]
[]
[null,null,null,null,"Winter ambient min",-3.0,"deg C",null,"kW",{"$f":"J5*1.2*1.01*(F14-F12)","v":0.86658},"heat loss infiltration"]
[null,null,null,null,"Summer ambient max",35.0,"deg C",null,"kW",{"$f":"J5*1.2*1.01*((F13+J6)-F15)","v":0.49941672},"heat gain infiltration"]
[null,null,null,null,"Internal design Lo",10.0,"deg C"]
[null,null,null,null,"Internal design Hi",28.0,"deg C"]
[]
[null,null,null,null,"U-Value",5.0,"W/m2 deg C",null,"kW",{"$f":"(F17*(F5*F6*F7)*(F14-F12))/1000","v":8.58},"winter fabric loss"]
[null,null,null,null,"Equipment gains",10.0,"kW",null,"kW",{"$f":"(F17*(F6*F7*F8)*(F13-F15))/1000","v":1.7325},"summer fabric gain"]
[null,null,null,null,"Other Gains",5.0,"kW",null,"kW",{"$f":"J12+J17","v":9.44658},"Winter Heating Load"]
[null,null,null,null,null,null,null,null,"kW",{"$f":"J13+J18+F18+F19","v":17.23191672},"Summer Cooling Load"]
[null,null,null,null,"Branch / Duct volume",0.1195,"m3/s"]
[null,null,null,null,"Duct velocity",4.0,"m/s",null,"mm x mm",{"$f":"SQRT(F21/F22)*1000","v":172.8438602},"Square Duct"]

{"sheet":"Duct Loss","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[]
[null,null,null,"ENTER",null,null,null,null,null,"ANSWER"]
[]
[null,null,"Air Volume",25.0," m3/s",null,null,null,"Square mm",{"$f":"SQRT(D6/D8)*1000","v":1767.766953},"x",{"$f":"J6","v":1767.766953}]
[null,null,null,null,null,null,null,null,"or"]
[null,null,"Velocity",8.0," m/s",null,null,null,"Circular mm",{"$f":"1000*SQRT((D6/D8)/0.785)","v":1995.217211},null,"Dia."]
[]
[null,null,null,null,null,null,null,null,"Velocity Pressure",{"$f":"0.6*(D8*D8)","v":38.4},null,"Pa"]
[]
[null,null,null,null,null,null,null,null,"Duct Loss / metre",{"$f":"(0.015624997*D6*D6)/POWER(J8/1000,5)","v":0.3088510255},null,"Pa"]
[]
[]
[]
[null,null,"Sum of \"k\" Factors",250.0]
[]
[null,null,"Duct Length",50.0," m",null,null,null,"System (approx.) loss",{"$f":"(D16*J10)+D18*J12","v":9615.442551},null,"Pa"]
[]
[]
[]
[]
[]
[null,null,"                     CIRCULAR EQUIVALENTS OF RECTANGULAR DUCTS"]
[]
[null,null,null,null,null,null,null,"ENTER",null,null,null,"     ANSWER"]
[]
[null,null,"RECTANGULAR DUCT SIZE, mm",null,null,null,2132.0,"x",2132.0,null,null,{"$f":"1000*SQRT(((G28/1000)*(I28/1000))/0.785)","v":2406.314411},"mm dia."]

{"sheet":"Fan Laws","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[null,null,null,"ENTER"]
[null,null,null,"Original System Data"]
[]
[null,null,"Fan Volume",2.78," m3/s",null,null,"(If you don't know the fan power, it should"]
[null,null,"Fan Pressure",600.0," Pa",null,null,"be around……….",null,{"$f":"D6*D7/(G10*10)","v":2.138461538}," kW)"]
[null,null,"Fan Speed",1350.0," rpm"]
[null,null,"Fan Power",2.0," kW",null,"Fan Effy.% =  {Vol (m3/s) x Total Press. (Pa)} ÷ (Abs. Power (W) x 10)"]
[null,null,null,null,null,null,78.0]
[]
[null,null,null,"CHANGE",null,null,null,null,null,"NEW"]
[]
[null,null,"Fan Volume",2.78," m3/s",null,null,null,"Fan Pressure",{"$f":"POWER(D14/D6,2)*D7","v":600}," Pa"]
[null,null,null,null,null,null,null,null,"Fan Speed",{"$f":"(D14/D6)*D8","v":1350}," rpm"]
[null,null,null,null,null,null,null,null,"Fan Power",{"$f":"POWER(D14/D6,3)*D9","v":2}," kW"]
[]
[null,null,null,null,null,null,null,null,"440v / ….",{"$f":"(J16*1000)/583","v":3.430531732}," Amps"]

{"sheet":"Misc.","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[null,null,null,null,"ENTER",null,null,null,null,"ANSWER"]
[]
[null,null,null,"Airflow Volume",0.1," m3/s",null,"m/s",{"$f":"SQRT(E7/2.5)","v":4.472135955},null,"Velocity through opening"]
[]
[null,null,null,"Required Pressurisation",50.0," Pa",null,"mm",{"$f":"SQRT(E5/I5)*1000","v":149.5348781},"x",{"$f":"I7","v":149.5348781},"Pressure relief outlet"]
[]
[]
[]
[null,null,null,"Perimeter of door",5.9," m",null,"m3/s",{"$f":"0.827*(E12/1000)*E11*SQRT(E13)","v":0.06900372235},null,"Air loss through closed door"]
[null,null,null,"Width of gap",2.0," (typ 2mm)"]
[null,null,null,"Room pressurisation",50.0," Pa"]

{"sheet":"P Loss","index":5,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["<<<Back","DUCTWORK PRESSURE LOSS CALCULATION"]
[]
["System:","Duct size (mm)",null,null,"(or)","Equiv.","Volume","Velocity","Vp","Fitting","Length","Loss"]
["Ductwork Element","W","x","H","Dia","Dia (mm)","(m3/s)","(m/s)","(Pa)","\"k\"","(m)","(Pa)"]
[]
["Supply "]
["Plenum Exit",250.0,"x",250.0,null,{"$f":"IF(B7=0,E8,1000*SQRT(((B7/1000)*(D7/1000))/0.785))","v":282.166324},0.35,{"$f":"G7/(0.785*(F7/1000)*(F7/1000))","v":5.6},{"$f":"(H7*H7)*0.6","v":18.816},4.3,null,{"$f":"IF(K7=0,I7*J7,K7*(0.015624997*(G7*G7)/POWER(F7/1000,5)))","v":80.9088}]
["Duct ",400.0,"x",400.0,null,{"$f":"IF(B8=0,#REF!,1000*SQRT(((B8/1000)*(D8/1000))/0.785))","v":451.4661184},0.525,3.28125,6.459960938,null,15.0,3.444323967]
["Fire Damper",400.0,"x",400.0,null,{"$f":"IF(B9=0,E9,1000*SQRT(((B9/1000)*(D9/1000))/0.785))","v":451.4661184},0.525,3.28125,6.459960938,0.5,null,3.229980469]
["Bend",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.35,null,2.260986328]
["Bend",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.35,null,2.260986328]
["Bend",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.35,null,2.260986328]
["Bend",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.35,null,2.260986328]
["Bend",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.35,null,2.260986328]
["VCD",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.27,null,1.744189453]
["Supply Grille OBD",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,0.52,null,3.359179688]
["Supply Grille",400.0,"x",400.0,null,451.4661184,0.525,3.28125,6.459960938,1.5,null,9.689941406]
[null,null,"x"]
["Supply Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L5:L17)","v":113.6813466}]
["Margin 10%",null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(0.1*L19)","v":11.36813466}]
[]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L19:L20)","v":125.0494813}]
[]
[]
["Exhaust"]
["Exhaust EC Grille",400.0,"x",400.0,null,{"$f":"IF(B26=0,E26,1000*SQRT(((B26/1000)*(D26/1000))/0.785))","v":451.4661184},0.525,{"$f":"G26/(0.785*(F26/1000)*(F26/1000))","v":3.28125},{"$f":"(H26*H26)*0.6","v":6.459960938},2.0,null,{"$f":"IF(K26=0,I26*J26,K26*(0.015624997*(G26*G26)/POWER(F26/1000,5)))","v":12.91992188}]
["Duct",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,null,4.16,4.025313857]
["Pressure Relief Damper",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,2.3,null,46.95833333]
["Fire Damper",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,0.2,null,4.083333333]
["Bend",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,null,1.0,0.9676235234]
["Bend",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,null,1.0,0.9676235234]
["Bend",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,null,1.0,0.9676235234]
["Fire Damper",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,0.2,null,4.083333333]
["Plenum Entry",300.0,"x",300.0,null,338.5995888,0.525,5.833333333,20.41666667,0.33,null,6.7375]
["Plenum Outlet",450.0,"x",200.0,null,338.5995888,0.525,5.833333333,20.41666667,0.23,null,4.695833333]
["Duct",450.0,"x",200.0,null,338.5995888,0.525,5.833333333,20.41666667,null,6.9,6.676602311]
["30o Bend",450.0,"x",200.0,null,338.5995888,0.525,5.833333333,20.41666667,0.41,null,8.370833333]
["30o Bend",450.0,"x",200.0,null,338.5995888,0.525,5.833333333,20.41666667,0.41,null,8.370833333]
["Duct",350.0,"x",250.0,null,333.863697,0.525,6,21.6,null,11.93,12.38605495]
["C/S (450x200) x (350x250)",350.0,"x",250.0,null,333.863697,0.525,6,21.6,0.02,null,0.432]
["Bend",350.0,"x",250.0,null,333.863697,0.525,6,21.6,0.35,null,7.56]
["Bend",350.0,"x",250.0,null,333.863697,0.525,6,21.6,0.35,null,7.56]
["45o Bend",350.0,"x",250.0,null,333.863697,0.525,6,21.6,0.18,null,3.888]
["45o Bend",350.0,"x",250.0,null,333.863697,0.525,6,21.6,0.18,null,3.888]
[]
["Extract Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L26:L45)","v":145.5387636}]
["Manual Entry:-"]
["Pressurisation (incl in PRD)"]
["Windage Factor (>10%)"]
["Margin 10%",null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(0.1*L46)","v":14.55387636}]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L46:L50)","v":160.0926399}]

{"sheet":"Psych","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["<<<Back","Psychrometric Chart"]

{"sheet":"Weight","index":7,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[]
[null,null,null,null,null,"ENTER"]
[null,null,null,null,null,null,null,null,"Flange Drilling"]
[null,null,null,"Duct Width",null,150.0,null,null,"Duct","Backmark","Remnant","Pitches @","Holes /"]
[null,null,null,"Duct Height",null,150.0,"mm",null,"Side","See Note","See Note","150mm","Bolts"]
[null,null,"OR","Duct Dia.",null,200.0,"mm",null,{"$f":"F6","v":150},{"$f":"F29","v":40},{"$f":"F42","v":115},{"$f":"F40","v":0},{"$f":"F44+G44","v":8}]
[null,null,null,"Metal Thickness",null,3.0,"mm",null,150,{"$f":"F29","v":40},{"$f":"G42","v":115},{"$f":"G40","v":0},{"$f":"I37","v":"M12"}]
[]
[null,null,null,"Spool Length",null,60.0,"m",null,"Backmark: Distance from the outer edge of flange to corner hole"]
[null,null,null,null,null,null,null,null,"Remnant: Distance between corner hole and first pitch hole"]
[null,null,null,"Flanges:",null,12.0,"No"]
[null,null,null,"Angle size",null,80.0,"mm",null,"Duct Weight (Rectangular)"]
[null,null,null,"Flg. Thickness",null,5.0,"mm",null,"Item","Material","Weight",null,"Total "]
[null,null,null,null,null,null,null,null,null,"m3","kg",null,"kg"]
[null,null,null,null,null,null,null,null,"Duct",{"$f":"2*F11*((F6/1000)*(F9/1000)+(F7/1000)*(F9/1000))","v":0.108},{"$f":"J17*F18","v":846.72}]
[null,null,null,"Density of Material",null,7840.0,"kg/m3",null,"Flanges",{"$f":"((F6+100+F6+100+F7+100+F7+100)/1000)*(F14/1000)*(F15/1000)*2*F13","v":0.0096},{"$f":"J18*F18","v":75.264},null,{"$f":"K17+K18","v":921.984}]
[null,null,null,"(Mild Steel",null,7840.0,"kg/m3)",null,"Duct Weight (Circular)"]
[null,null,null,"(St/St",null,7900.0,"kg/m3)",null,"Duct Dia.","Area m2","Vol. m3","Weight kg"]
[null,null,null,null,null,null,null,null,{"$f":"F8","v":200},{"$f":"(((F8/1000)*(F8/1000)*22/7)/4)*F11","v":1.885714286},{"$f":"J21*F9/1000","v":0.005657142857},{"$f":"K21*F18","v":44.352}]
[]
[]
[]
[]
[]
[null,null,null,"Duct Size",null,{"$f":"F6","v":150},{"$f":"F7","v":150},null,"M6"]
[null,null,null,"Flange length",null,{"$f":"F6+(2*F14)","v":310},{"$f":"F7+(2*F14)","v":310},null,"M8"]
[null,null,null,"Backmark",null,{"$f":"FLOOR(F14/2,1)","v":40},{"$f":"F29","v":40},null,"M10"]
[null,null,null,"Span",null,{"$f":"F28-(2*F29)","v":230},230,null,"M12"]
[]
[null,null,null,"150mm pitches",null,{"$f":"FLOOR(F30/150,1)","v":1},1]
[null,null,null,"covering",null,{"$f":"F32*150","v":150},150]
[null,null,null,"fill",null,{"$f":"(F30-F33)/2","v":40},40]
[null,null,null,null,null,null,null,null,{"$f":"IF(F14>25,I28,I27)","v":"M8"}]
[null,null,null,"Amended 150 pitches",null,{"$f":"IF(F34<75,F32-1,F32)","v":0},0,null,{"$f":"IF(F14>49,I29,I35)","v":"M10"}]
[null,null,null,"Amended covering",null,{"$f":"F36*150","v":0},0,null,{"$f":"IF(F14>74,I30,I36)","v":"M12"}]
[null,null,null,"Amended fill",null,{"$f":"(F30-F37)/2","v":115},115]
[]
[null,null,null,"Answer 150 pitches",null,{"$f":"IF(F34=0,F36+1,F36)","v":0},0]
[null,null,null,"Answer covering",null,{"$f":"F40*150","v":0},0]
[null,null,null,"Answer fill",null,{"$f":"(F30-F41)/2","v":115},115]
[]
[null,null,null,"Holes",null,{"$f":"2*(IF(F42=0,F40,F40+2))","v":4},4]

{"sheet":"Calc","index":8,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"<<< Back"]
[]
[null,null,null,null,null,null,null,null,null,null,"Air Mix"]
[]
[null,null,null,null,1.0,null,null,null,null,null,null,"Q1","Q2",null,"Q3"]
[]
[null,null,null,"in",null,null,null,null,null,null,"Airflow",3.433,2.456,null,{"$f":"L7+M7","v":5.889},"m3/s"]
[null,null,"Airflow",5.889,"m3/s",null,null,null,null,null,"Mix %",58.3,"41.l7",null,{"$f":"O7/O7%","v":100},"%"]
[]
[null,null,"Sp Vol",0.85,"m3/kg",null,null,null,null,null,"Sp Enthalpy",46.0,59.8,null,{"$f":"((L8*L10)+(M8*M10))/100","v":"#VALUE!"},"KJ/kg"]
[null,null,null,"High",null,"Low",null,null,null,null,"M.Content",0.0115,0.01,null,{"$f":"((L8*L11)+(M8*M11))/100","v":"#VALUE!"},"kg/kg"]
[null,null,"Specific Enthalpy",129.4,null,99.98,"KJ/kg",null,null,null,"Temperature",23.0,23.0,null,{"$f":"((L8*L12)+(M8*M12))/100","v":"#VALUE!"},"OC"]
[]
[null,null,"Moisture Content",0.03673,null,0.02731,"kg/kg"]
[]
[null,null,{"$f":"IF(E5=1,\"HEATING\",\"COOLING\")","v":"HEATING"}]
[]
[null,null,{"$f":"IF(E5=1,\"Sensible Heating\",\"Sensible Cooling\")","v":"Sensible Heating"},null,null,{"$f":"IF(F20<0,\"\",F20-F19)","v":56.46262348},{"$f":"IF(F20<0,\"\",\"kW\")","v":"kW"}]
[null,null,{"$f":"IF(E5=1,\"Humidification\",\"De-humidification\")","v":"Humidification"},null,null,{"$f":"IF(F20<0,\"\",2258*F21)","v":147.3660589},{"$f":"IF(F20<0,\"\",\"kW\")","v":"kW"}]
[null,null,{"$f":"IF(E5=1,\"Total Change\",\"Total Cooling\")","v":"Total Change"},null,null,{"$f":"D8*(D12-F12)/D10","v":203.8286824},{"$f":"IF(F20<0,\"\",\"kW\")","v":"kW"}]
[null,null,{"$f":"IF(E5=1,\"Moisture Added\",\"Moisture Drop out\")","v":"Moisture Added"},null,null,{"$f":"D8*(D14-F14)/D10","v":0.06526397647},{"$f":"IF((D14-F14)>0,\"l/s\",\"\")","v":"l/s"}]
[null,null,null,null,null,{"$f":"IF(F20<0,\"Data incorrect\",\"\")","v":""}]
[null,null,null,null,null,""]

{"sheet":"Load","index":9,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,2,17,4],[18,1,18,4],[19,0,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,2,26,4],[27,1,27,4],[28,0,28,4],[32,1,32,4],[33,0,33,6],[44,8,45,10],[46,8,46,10],[29,8,29,10],[30,8,30,10],[31,8,31,10],[38,8,38,10],[44,7,45,7],[44,11,45,11],[46,11,47,11],[53,8,53,10],[54,8,54,10],[46,7,47,7],[48,7,49,7],[48,11,49,11],[50,7,52,7],[50,8,50,10],[51,8,51,10],[52,8,52,10],[4,0,4,2],[4,3,4,6],[5,0,5,1],[5,2,5,6],[6,4,6,6],[8,1,8,4],[9,1,9,4],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,7,28,11],[34,1,34,2],[40,1,40,4],[41,0,41,6],[45,0,45,6],[46,0,46,4],[47,0,47,4],[48,0,48,4],[55,0,55,1],[56,0,58,2],[59,0,59,11],[49,0,49,4],[50,0,50,4],[51,0,51,4],[52,0,52,4],[53,0,53,4],[54,0,54,2],[54,3,54,4]]}
["<<< Back"]
[]
[null,null,null,null,null,null,"LOAD ESTIMATE SHEET"]
[]
["JOB/REF No.",null,null,null,null,null,null,"ESTIMATED BY:-",null,null,"DATE:-"]
["LOCATION:-",null,null,null,null,null,null,"CHECKED BY:-",null,null,"DATE:-"]
["SHEET",null,"OF",null,null,null,null,"APPROVED BY:-",null,null,"DATE:-"]
["TRANSMITTED HEAT GAINS AND LOSSES"]
["ITEM"," DESCRIPTION",null,null,null,"AREA, ","U","WINTER","HEAT","SUMMER",null,"HEAT"]
["No.",null,null,null,null,"m2","VALUE","TEMP DIFF OC","LOSS, W.","TEMP DIFF OC",null,"GAIN, W."]
[1.0," EXT. WALL GROSS.",null,null,null,400.0,"-","-","-","-",null,"-"]
[2.0," EXT. GLASS.",null,null,null,30.0,null,21.0,{"$f":"F12*G12*H12","v":0},7.0,null,{"$f":"F12*G12*J12","v":0}]
[3.0," EXT. WALL NETT.",null,null,null,{"$f":"F11-F12","v":370},0.6,21.0,4662,7.0,null,1554]
[4.0," INT. WALLS.",null,null,null,190.0,0.8,6.0,912,6.0,null,912]
[5.0," INT. GLASS.",null,null,null,10.0,5.6,6.0,336,6.0,null,336]
[6.0," FLOOR.",null,null,null,200.0,0.36,21.0,1512,0.0,null,0]
[7.0," ROOF.",null,null,null,200.0,1.5,21.0,6300,7.0,null,2100]
[8.0," MISC.",null,null,null,0.0,0.0,0.0,0,null,null,0]
[9.0," TOTAL GAINS AND LOSSES, W.",null,null,null,null,null,null,{"$f":"SUM(I12:I18)","v":13722},null,null,{"$f":"SUM(L12:L18)","v":4902}]
["SOLAR HEAT GAINS",null,null,null,null,"AREA, m2","U         VALUE","teo,oC.","ti,oC.","TEMP DIFF OC",null,"HEAT GAIN, W."]
[10.0," WALL.",null,null,null,370.0,0.6,43.6,21.0,{"$f":"(H21-I21)","v":22.6},null,{"$f":"F21*G21*J21","v":5017.2}]
[11.0," WALL.",null,null,null,40.0,0.6,27.5,21.0,6.5,null,156]
[12.0," GLASS.",null,null,null,30.0,5.6,43.6,21.0,22.6,null,3796.8]
[13.0," GLASS.",null,null,null,null,null,null,null,0,null,0]
[14.0," ROOF.",null,null,null,200.0,1.5,43.2,21.0,{"$f":"H25-I25","v":22.2},null,6660]
[15.0," ROOFLIGHTS.",null,null,null,0.0,5.6,43.2,21.0,22.2,null,0]
[16.0," MISC.",null,null,null,null,null,null,null,0,null,0]
[17.0," TOTAL SOLAR HEAT GAINS, W.",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L21:L27)","v":15630}]
["BODY GAINS",null,null,null,null,"SENS., W.","LAT., W.","HEAT GAIN SUMMARY"]
[18.0," NO.",24.0,"x",100.0,{"$f":"C30*E30","v":2400},null,"ITEM No.","ITEM",null,null,"GAIN, W."]
[19.0," NO.",null,"x",null,0,null,9.0,"TRANSMITTANCE.",null,null,{"$f":"L19","v":4902}]
[20.0," NO.",24.0,"x",50.0,null,{"$f":"C32*E32","v":1200},17.0,"SOLAR.",null,null,{"$f":"L28","v":15630}]
[21.0," TOTAL BODY GAIN.",null,null,null,{"$f":"SUM(F30+F31)","v":2400},{"$f":"C32*E32","v":1200},21.0,"BODY. (SENSIBLE).",null,null,{"$f":"F33","v":2400}]
["EQUIPMENT GAINS",null,null,null,null,null,null,28.0,"EQUIPMENT.",null,null,{"$f":"F41","v":13550}]
[22.0,"LIGHTING.",null,60.0,200.0,{"$f":"D35*E35","v":12000},null,31.0,"INFILTRATION.",null,null,{"$f":"F45","v":4705.555556}]
[23.0,"SMALL MOTORS",null,350.0,1.0,350,null,32.0,"TOTAL SENSIBLE.",null,null,{"$f":"SUM(L31:L35)","v":41187.55556}]
[24.0,"LARGE MOTORS",null,600.0,2.0,1200,null,33.0,"TOTAL LATENT.",null,null,{"$f":"G33","v":1200}]
[25.0,"ELECTRICAL PLANT",null,null,null,{"$f":"E38","v":""},null,34.0,"TOTAL HEAT GAIN.",null,null,{"$f":"L36+L37","v":42387.55556}]
[26.0,"GAS PLANT",null,null,null,{"$f":"D39+E39","v":0},null,35.0,"S.H.R.= (ITEM 32/ITEM 34) %",null,null,{"$f":"(L36/L38)","v":0.9716898041}]
[27.0,"MISC.",null,null,null,{"$f":"SUM(C40+D40+E40)","v":0},null,36.0,"d.b.SUPPLY AIR TEMP.OC",null,null,11.0]
[28.0,"TOTAL EQUIPMENT GAINS, W.",null,null,null,{"$f":"SUM(F35:F40)","v":13550},null,37.0,"w.b. SUPPLY AIR TEMP.OC",null,null,10.0]
["INFILTRATION GAINS",null,null,null,null,null,null,38.0,"d.b. SUPPLY AIR TEMP. RISE OC",null,null,{"$f":"G48-L40","v":10}]
[29.0,"ac/h","HEIGHT","LENGTH","WIDTH",null,null,39.0,"PRELIMINARY S.A.V. (m3/s)",null,null,{"$f":"(L38*0.00083)/L42","v":3.518167111}]
[30.0,0.5,20.0,20.0,10.0,{"$f":"(B44*C44*D44*E44)*(1.21/3.6)*(F48-G48)","v":4705.555556},null,41.0,"DUCT GAIN = SAVx1.21x 2OC, W",null,null,{"$f":"L43*1.21*2*1000","v":8513.964409}]
[31.0,"TOTAL INFILTRATION GAINS.",null,null,null,{"$f":"(B44*C44*D44*E44)*(1.21/3.6)*(F48-G48)","v":4705.555556},null,42.0,"S.A.V. INC. DUCT GAIN (ITEM 32 + ITEM 41)*1.21*ITEM 38",null,null,{"$f":"(L38+L44)/(1000*1.21*L42)","v":4.206737187}]
["DESIGN DATA"]
["SUMMER",null,null,null,null,"To, OC","Ti, OC",43.0,"F.A REQ.=Occupancy.x m3/s/head.",null,null,{"$f":"I48*K48","v":0.36}]
["d.b. TEMPERATURE",null,null,null,null,28.0,21.0,null,24.0,"X",0.015]
["w.b. TEMPERATURE",null,null,null,null,null,null,44.0,"FRESH AIR GAIN, W =",null,null,{"$f":"L47*1.21*(F48-G48)*1000","v":3049.2}]
["DEW POINT",null,null,null,null,null,null,null,"ITEM 43 x 1.21 x (To-Ti) "]
["RELATIVE HUMIDITY",null,null,null,null,0.5,0.5,null,"COOLING LOAD, W"]
["ENTHALPY",null,null,null,null,null,null,null,"ITEM 34",null,null,{"$f":"L38","v":42387.55556}]
["MOISTURE CONTENT",null,null,null,null,null,null,null,"ITEM 41",null,null,{"$f":"L44","v":8513.964409}]
["WINTER d.b. TEMP.",null,null,null,null,0.0,null,45.0,"TOTAL COOLING LOAD, W.",null,null,{"$f":"L52+L53","v":50901.51996}]
["LATITUDE:-",null,null,null,null,null,null,46.0,"EQUIV. COOLING LOAD, T.R.",null,null,{"$f":"L54/3517","v":14.47299402}]
["DATE:-",null,"24th Aug.","TIME:-","12:00:00",null,null,"Notes:","No. of Air Changes per hour =",null,null,{"$f":"(((L38+L44)/(1000*1.21*L42))*3600)/(C44*D44*E44)","v":3.786063468}]
[null,null,null,"WALL:-","LIGHT","MEDIUM","DARK","    All Temperatures, U-Values and other Design Data"]
[null,null,null,"ROOF:-","LIGHT","MEDIUM","DARK","     to be obtained from relevant C.I.B.S.E. Guide. "]
[null,null,null,"GLAZING:-","AWNINGS","SHADE","BARE","    All dimensions in metres."]
[]
[null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,{"$f":"SUM(M41)","v":0}]

{"sheet":"Conv.","index":10,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<Back"]
[null,null,null,"ENTER"]
[null,null,null,"Imperial to Metric"]
[]
[null,null,"cfm",29.0,null,{"$f":"D6/2119","v":0.0136857008},"m3/s",null,null,null,"ENTER"]
[null,null,"gpm",33.0,null,{"$f":"D7/13.2","v":2.5},"l/s",null,null,null,"Pressure","Pa"]
[null,null,"ft/min",1000.0,null,{"$f":"D8/196.75","v":5.082592122},"m/s",null,null,null,1000.0]
[null,null,"Btu/hr",50000.0,null,{"$f":"D9/3412","v":14.65416178},"kW"]
[null,null,"HP",1.0,null,{"$f":"D10/1.36","v":0.7352941176},"kW",null,null,null,"read"]
[null,null,"mph",21.0,null,{"$f":"D11/0.6214","v":33.79465723},"km/h",null,null,null,{"$f":"K8","v":1000},"N/m2"]
[null,null,"knot",1.0,null,{"$f":"D12*0.514","v":0.514},"m/s",null,null,null,{"$f":"K8*0.004015","v":4.015},"\"wg"]
[null,null,"inches",1.0,null,{"$f":"D13*25.4","v":25.4},"mm",null,null,null,{"$f":"K8*0.102","v":102},"mm wg"]
[null,null,"feet",22.0,null,{"$f":"D14*0.3048","v":6.7056},"m",null,null,null,{"$f":"K8*0.0002953","v":0.2953},"\"hg"]
[null,null,"sq. yards",23.0,null,{"$f":"D15/1.196","v":19.23076923},"m2",null,null,null,{"$f":"K8/133","v":7.518796992},"mm hg"]
[null,null,"lbs",2.2,null,{"$f":"D16/2.20462","v":0.9979044008},"kg",null,null,null,{"$f":"K8*0.000145","v":0.145},"psi"]
[null,null,"gallon",1.0,null,{"$f":"D17*4.55","v":4.55},"litres",null,null,null,{"$f":"K15","v":7.518796992},"torr"]
[null,null,"\" water",45.0,null,{"$f":"D18*249.1","v":11209.5},"Pa",null,null,null,{"$f":"K8/100","v":10},"m.bar"]
[null,null,"oF",70.0,null,{"$f":"(5/9)*(D19-32)","v":21.11111111},"oC",null,null,null,{"$f":"K18/1000","v":0.01},"bar"]
[null,null,"oC",50.0,null,{"$f":"((9/5)*(D20))+32","v":122},"oF"]

{"sheet":"Plan","index":11,"n_rows":11,"n_cols":255,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Start Date:","2001-10-22","Days freq.",1.0]
[]
[null,"Days long",13.0,"<<<Back",null,{"$f":"IF(F9=\"\",\"\",CHOOSE(F7,\"M\",\"Tu\",\"W\",\"Th\",\"F\",\"Sa\",\"Su\"))","v":"M"},"Tu","W","Th","F","Sa","Su","M","Tu","W","Th","F","Sa","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",WEEKDAY(F10,2))","v":1},2,3,4,5,6,7,1,2,3,4,5,6,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F9","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"Today's date is:",{"$f":"TODAY()","v":"2023-12-09"},"Day No >>",1.0,{"$f":"IF(F9<Plan!$C$5,F9+Plan!$E$3,\"\")","v":2},{"$f":"IF(G9<Plan!$C$5,G9+Plan!$E$3,\"\")","v":3},{"$f":"IF(H9<Plan!$C$5,H9+Plan!$E$3,\"\")","v":4},{"$f":"IF(I9<Plan!$C$5,I9+Plan!$E$3,\"\")","v":5},{"$f":"IF(J9<Plan!$C$5,J9+Plan!$E$3,\"\")","v":6},{"$f":"IF(K9<Plan!$C$5,K9+Plan!$E$3,\"\")","v":7},{"$f":"IF(L9<Plan!$C$5,L9+Plan!$E$3,\"\")","v":8},{"$f":"IF(M9<Plan!$C$5,M9+Plan!$E$3,\"\")","v":9},{"$f":"IF(N9<Plan!$C$5,N9+Plan!$E$3,\"\")","v":10},{"$f":"IF(O9<Plan!$C$5,O9+Plan!$E$3,\"\")","v":11},{"$f":"IF(P9<Plan!$C$5,P9+Plan!$E$3,\"\")","v":12},{"$f":"IF(Q9<Plan!$C$5,Q9+Plan!$E$3,\"\")","v":13},{"$f":"IF(R9<Plan!$C$5,R9+Plan!$E$3,\"\")","v":""},{"$f":"IF(S9<Plan!$C$5,S9+Plan!$E$3,\"\")","v":""},{"$f":"IF(T9<Plan!$C$5,T9+Plan!$E$3,\"\")","v":""},{"$f":"IF(U9<Plan!$C$5,U9+Plan!$E$3,\"\")","v":""},{"$f":"IF(V9<Plan!$C$5,V9+Plan!$E$3,\"\")","v":""},{"$f":"IF(W9<Plan!$C$5,W9+Plan!$E$3,\"\")","v":""},{"$f":"IF(X9<Plan!$C$5,X9+Plan!$E$3,\"\")","v":""},{"$f":"IF(Y9<Plan!$C$5,Y9+Plan!$E$3,\"\")","v":""},{"$f":"IF(Z9<Plan!$C$5,Z9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AA9<Plan!$C$5,AA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AB9<Plan!$C$5,AB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AC9<Plan!$C$5,AC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AD9<Plan!$C$5,AD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AE9<Plan!$C$5,AE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AF9<Plan!$C$5,AF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AG9<Plan!$C$5,AG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AH9<Plan!$C$5,AH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AI9<Plan!$C$5,AI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AJ9<Plan!$C$5,AJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AK9<Plan!$C$5,AK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AL9<Plan!$C$5,AL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AM9<Plan!$C$5,AM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AN9<Plan!$C$5,AN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AO9<Plan!$C$5,AO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AP9<Plan!$C$5,AP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AQ9<Plan!$C$5,AQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AR9<Plan!$C$5,AR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AS9<Plan!$C$5,AS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AT9<Plan!$C$5,AT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AU9<Plan!$C$5,AU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AV9<Plan!$C$5,AV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AW9<Plan!$C$5,AW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AX9<Plan!$C$5,AX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AY9<Plan!$C$5,AY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(AZ9<Plan!$C$5,AZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BA9<Plan!$C$5,BA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BB9<Plan!$C$5,BB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BC9<Plan!$C$5,BC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BD9<Plan!$C$5,BD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BE9<Plan!$C$5,BE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BF9<Plan!$C$5,BF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BG9<Plan!$C$5,BG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BH9<Plan!$C$5,BH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BI9<Plan!$C$5,BI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BJ9<Plan!$C$5,BJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BK9<Plan!$C$5,BK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BL9<Plan!$C$5,BL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BM9<Plan!$C$5,BM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BN9<Plan!$C$5,BN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BO9<Plan!$C$5,BO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BP9<Plan!$C$5,BP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BQ9<Plan!$C$5,BQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BR9<Plan!$C$5,BR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BS9<Plan!$C$5,BS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BT9<Plan!$C$5,BT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BU9<Plan!$C$5,BU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BV9<Plan!$C$5,BV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BW9<Plan!$C$5,BW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BX9<Plan!$C$5,BX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BY9<Plan!$C$5,BY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(BZ9<Plan!$C$5,BZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CA9<Plan!$C$5,CA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CB9<Plan!$C$5,CB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CC9<Plan!$C$5,CC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CD9<Plan!$C$5,CD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CE9<Plan!$C$5,CE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CF9<Plan!$C$5,CF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CG9<Plan!$C$5,CG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CH9<Plan!$C$5,CH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CI9<Plan!$C$5,CI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CJ9<Plan!$C$5,CJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CK9<Plan!$C$5,CK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CL9<Plan!$C$5,CL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CM9<Plan!$C$5,CM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CN9<Plan!$C$5,CN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CO9<Plan!$C$5,CO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CP9<Plan!$C$5,CP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CQ9<Plan!$C$5,CQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CR9<Plan!$C$5,CR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CS9<Plan!$C$5,CS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CT9<Plan!$C$5,CT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CU9<Plan!$C$5,CU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CV9<Plan!$C$5,CV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CW9<Plan!$C$5,CW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CX9<Plan!$C$5,CX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CY9<Plan!$C$5,CY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(CZ9<Plan!$C$5,CZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DA9<Plan!$C$5,DA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DB9<Plan!$C$5,DB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DC9<Plan!$C$5,DC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DD9<Plan!$C$5,DD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DE9<Plan!$C$5,DE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DF9<Plan!$C$5,DF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DG9<Plan!$C$5,DG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DH9<Plan!$C$5,DH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DI9<Plan!$C$5,DI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DJ9<Plan!$C$5,DJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DK9<Plan!$C$5,DK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DL9<Plan!$C$5,DL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DM9<Plan!$C$5,DM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DN9<Plan!$C$5,DN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DO9<Plan!$C$5,DO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DP9<Plan!$C$5,DP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DQ9<Plan!$C$5,DQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DR9<Plan!$C$5,DR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DS9<Plan!$C$5,DS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DT9<Plan!$C$5,DT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DU9<Plan!$C$5,DU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DV9<Plan!$C$5,DV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DW9<Plan!$C$5,DW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DX9<Plan!$C$5,DX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DY9<Plan!$C$5,DY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(DZ9<Plan!$C$5,DZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EA9<Plan!$C$5,EA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EB9<Plan!$C$5,EB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EC9<Plan!$C$5,EC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(ED9<Plan!$C$5,ED9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EE9<Plan!$C$5,EE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EF9<Plan!$C$5,EF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EG9<Plan!$C$5,EG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EH9<Plan!$C$5,EH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EI9<Plan!$C$5,EI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EJ9<Plan!$C$5,EJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EK9<Plan!$C$5,EK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EL9<Plan!$C$5,EL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EM9<Plan!$C$5,EM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EN9<Plan!$C$5,EN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EO9<Plan!$C$5,EO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EP9<Plan!$C$5,EP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EQ9<Plan!$C$5,EQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(ER9<Plan!$C$5,ER9+Plan!$E$3,\"\")","v":""},{"$f":"IF(ES9<Plan!$C$5,ES9+Plan!$E$3,\"\")","v":""},{"$f":"IF(ET9<Plan!$C$5,ET9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EU9<Plan!$C$5,EU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EV9<Plan!$C$5,EV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EW9<Plan!$C$5,EW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EX9<Plan!$C$5,EX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EY9<Plan!$C$5,EY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(EZ9<Plan!$C$5,EZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FA9<Plan!$C$5,FA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FB9<Plan!$C$5,FB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FC9<Plan!$C$5,FC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FD9<Plan!$C$5,FD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FE9<Plan!$C$5,FE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FF9<Plan!$C$5,FF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FG9<Plan!$C$5,FG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FH9<Plan!$C$5,FH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FI9<Plan!$C$5,FI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FJ9<Plan!$C$5,FJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FK9<Plan!$C$5,FK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FL9<Plan!$C$5,FL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FM9<Plan!$C$5,FM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FN9<Plan!$C$5,FN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FO9<Plan!$C$5,FO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FP9<Plan!$C$5,FP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FQ9<Plan!$C$5,FQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FR9<Plan!$C$5,FR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FS9<Plan!$C$5,FS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FT9<Plan!$C$5,FT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FU9<Plan!$C$5,FU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FV9<Plan!$C$5,FV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FW9<Plan!$C$5,FW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FX9<Plan!$C$5,FX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FY9<Plan!$C$5,FY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(FZ9<Plan!$C$5,FZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GA9<Plan!$C$5,GA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GB9<Plan!$C$5,GB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GC9<Plan!$C$5,GC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GD9<Plan!$C$5,GD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GE9<Plan!$C$5,GE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GF9<Plan!$C$5,GF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GG9<Plan!$C$5,GG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GH9<Plan!$C$5,GH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GI9<Plan!$C$5,GI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GJ9<Plan!$C$5,GJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GK9<Plan!$C$5,GK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GL9<Plan!$C$5,GL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GM9<Plan!$C$5,GM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GN9<Plan!$C$5,GN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GO9<Plan!$C$5,GO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GP9<Plan!$C$5,GP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GQ9<Plan!$C$5,GQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GR9<Plan!$C$5,GR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GS9<Plan!$C$5,GS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GT9<Plan!$C$5,GT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GU9<Plan!$C$5,GU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GV9<Plan!$C$5,GV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GW9<Plan!$C$5,GW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GX9<Plan!$C$5,GX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GY9<Plan!$C$5,GY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(GZ9<Plan!$C$5,GZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HA9<Plan!$C$5,HA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HB9<Plan!$C$5,HB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HC9<Plan!$C$5,HC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HD9<Plan!$C$5,HD9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HE9<Plan!$C$5,HE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HF9<Plan!$C$5,HF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HG9<Plan!$C$5,HG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HH9<Plan!$C$5,HH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HI9<Plan!$C$5,HI9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HJ9<Plan!$C$5,HJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HK9<Plan!$C$5,HK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HL9<Plan!$C$5,HL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HM9<Plan!$C$5,HM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HN9<Plan!$C$5,HN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HO9<Plan!$C$5,HO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HP9<Plan!$C$5,HP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HQ9<Plan!$C$5,HQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HR9<Plan!$C$5,HR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HS9<Plan!$C$5,HS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HT9<Plan!$C$5,HT9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HU9<Plan!$C$5,HU9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HV9<Plan!$C$5,HV9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HW9<Plan!$C$5,HW9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HX9<Plan!$C$5,HX9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HY9<Plan!$C$5,HY9+Plan!$E$3,\"\")","v":""},{"$f":"IF(HZ9<Plan!$C$5,HZ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IA9<Plan!$C$5,IA9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IB9<Plan!$C$5,IB9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IC9<Plan!$C$5,IC9+Plan!$E$3,\"\")","v":""},{"$f":"IF(ID9<Plan!$C$5,ID9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IE9<Plan!$C$5,IE9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IF9<Plan!$C$5,IF9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IG9<Plan!$C$5,IG9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IH9<Plan!$C$5,IH9+Plan!$E$3,\"\")","v":""},{"$f":"IF(II9<Plan!$C$5,II9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IJ9<Plan!$C$5,IJ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IK9<Plan!$C$5,IK9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IL9<Plan!$C$5,IL9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IM9<Plan!$C$5,IM9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IN9<Plan!$C$5,IN9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IO9<Plan!$C$5,IO9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IP9<Plan!$C$5,IP9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IQ9<Plan!$C$5,IQ9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IR9<Plan!$C$5,IR9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IS9<Plan!$C$5,IS9+Plan!$E$3,\"\")","v":""},{"$f":"IF(IT9<Plan!$C$5,IT9+Plan!$E$3,\"\")","v":""}]
["Ref",null,"ACTIVITIES",null,"Date",{"$f":"C3","v":"2001-10-22"},{"$f":"IF(G9=\"\",\"\",F10+$E$3)","v":"2001-10-23"},"2001-10-24","2001-10-25","2001-10-26","2001-10-27","2001-10-28","2001-10-29","2001-10-30","2001-10-31","2001-11-01","2001-11-02","2001-11-03","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F9","v":"1900-01-01"},"1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"U values","index":12,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,11,38,11],[37,12,38,12],[37,13,38,13]]}
["<<<Back"]
[null,null,null,null,null,null,null,"CALCULATION OF THERMAL TRANSMITTANCE (U-VALUE) W/m2oC)"]
[]
[null,null,"Composite Structures With Air Gap",null,null,null,null,null,null,"Composite Structures Without Air Gap"]
[]
[null,null,"Surface:-",null,"Wall",null,null,null,null,"Surface:-",null,"Wall"]
[null,null,null,null,"(Enter description)",null,null,null,null,null,null,"(Enter description)"]
[null,null,"Material",null,null,"Thickness","K value",null,null,"Material",null,null,"Thickness","K value"]
[null,null,"(Enter description)",null,null,"(mm)","(W/moC)",null,null,"(Enter description)",null,null,"(mm)","(W/moC)"]
[null,1.0,"Steel Cladding",null,"L1",5.0,50.0,null,1.0,"Steel Cladding",null,"L1",5.0,50.0]
[null,2.0,"Fibre Board Slabs",null,"L2",100.0,0.057,null,2.0,"Fibre Board Slabs",null,"L2",100.0,0.057]
[null,3.0,"Air Gap",null,"L3",50.0,0.026,null,3.0,null,null,"L3",0.0,1.0]
[null,4.0,"Plasterboard",null,"L4",15.0,0.16,null,4.0,"Plasterboard",null,"L4",15.0,0.16]
[null,null,null,null,"U Value","Heat Flow","(W/m2oC)",null,null,null,null,"U Value","Heat Flow","(W/m2oC)"]
[null,null,null,null,null,"Horiz.",{"$f":"ABS(E38)","v":0.2426411261},null,null,null,null,null,"Horiz.",{"$f":"ABS(L38)","v":0.495482202}]
[null,null,null,null,null,"Up",{"$f":"ABS(F38)","v":0.2480581458},null,null,null,null,null,"Up",{"$f":"ABS(M38)","v":0.5029584102}]
[null,null,null,null,null,"Down",{"$f":"ABS(G38)","v":0.2438243624},null,null,null,null,null,"Down",{"$f":"ABS(N38)","v":0.4858529425}]
[]
[null,null,null,null,null,null,null,"GO TO 'k' Factors>>>"]
[]
[null,null,null,null,null,"HEAT FLOW",null,null,null,null,null,null,"HEAT FLOW"]
[null,null,null,null,"HORIZ.","UP","DOWN",null,null,null,null,"HORIZ.","UP","DOWN"]
[null,null,null,"Rsi",0.13,0.1,0.17,null,null,null,"Rsi",0.13,0.1,0.17]
[null,null,null,"Rso",0.04,0.04,0.04,null,null,null,"Rso",0.04,0.04,0.04]
[null,null,null,"Rsi+Rso",0.17,0.14,0.21,null,null,null,"Rsi+Rso",0.17,0.14,0.21]
[null,null,null,"R air gap",0.18,0.12,0.12,null,null,null,"R air gap",0.0,0.0,0.0]
[null,null,null,"R total",0.52,0.4,0.54,null,null,null,"R total",0.34,0.28,0.42]
[null,null,null,"L1 (m)",{"$f":"(F10/1000)","v":0.005},{"$f":"(F10/1000)","v":0.005},{"$f":"ABS(F10*0.001)","v":0.005},null,null,null,"L1 (m)",{"$f":"(M10/1000)","v":0.005},{"$f":"(M10/1000)","v":0.005},{"$f":"(M10/1000)","v":0.005}]
[null,null,null,"K1",{"$f":"G10","v":50},{"$f":"G10","v":50},{"$f":"G10","v":50},null,null,null,"K1",{"$f":"N10","v":50},{"$f":"N10","v":50},{"$f":"N10","v":50}]
[null,null,null,"L2 (m)",{"$f":"(F11/1000)","v":0.1},{"$f":"(F11/1000)","v":0.1},{"$f":"(F11/1000)","v":0.1},null,null,null,"L2 (m)",{"$f":"(M11/1000)","v":0.1},{"$f":"(M11/1000)","v":0.1},{"$f":"(M11/1000)","v":0.1}]
[null,null,null,"K2",{"$f":"G11","v":0.057},{"$f":"G11","v":0.057},{"$f":"G11","v":0.057},null,null,null,"K2",{"$f":"N11","v":0.057},{"$f":"N11","v":0.057},{"$f":"N11","v":0.057}]
[null,null,null,"L3 (m)",{"$f":"(F12/1000)","v":0.05},{"$f":"(F12/1000)","v":0.05},{"$f":"(F12/1000)","v":0.05},null,null,null,"L3 (m)",{"$f":"(M12/1000)","v":0},{"$f":"(M12/1000)","v":0},{"$f":"(M12/1000)","v":0}]
[null,null,null,"K3",{"$f":"G12","v":0.026},{"$f":"G12","v":0.026},{"$f":"G12","v":0.026},null,null,null,"K3",{"$f":"N12","v":1},{"$f":"N12","v":1},{"$f":"N12","v":1}]
[null,null,null,"L4 (m)",{"$f":"(F13/1000)","v":0.015},{"$f":"(F13/1000)","v":0.015},{"$f":"(F13/1000)","v":0.015},null,null,null,"L4 (m)",{"$f":"(M13/1000)","v":0.015},{"$f":"(M13/1000)","v":0.015},{"$f":"(M13/1000)","v":0.015}]
[null,null,null,"K4",{"$f":"G13","v":0.16},{"$f":"G13","v":0.16},{"$f":"G13","v":0.16},null,null,null,"K4",{"$f":"N13","v":0.16},{"$f":"N13","v":0.16},{"$f":"N13","v":0.16}]
[null,null,null,"N.B:- Enter 'k' from table below.",null,null,null,null,null,null,"N.B:- Enter 'k' from table below."]
[null,null,null,"Where no material is used enter L=0 & K=1.",null,null,null,null,null,null,"Where no material is used enter L=0 & K=1."]
[null,null,null,"U-value =",{"$f":"ABS(1/(E25+E26+(E28/E29)+(E30/E31)+(E32/E33)+(E34/E35)))","v":0.2426411261},0.2480581458,0.2438243624,null,null,null,"U-value =",{"$f":"ABS(1/(L25+L26+(L28/L29)+(L30/L31)+(L32/L33)+(L34/L35)))","v":0.495482202},0.5029584102,0.4858529425]
[null,null,null,"(W/m2oC)",null,null,null,null,null,null,"(W/m2oC)"]
[]
[]
[]
[]
[]
[null,null,"Typical 'k' Factors for Various Materials (W/moC) :- ",null,null,null,null,"Back to Top"]
[]
[null,null,"Walls",null,null,null,null,null,null,"Roofs"]
[null,null,"Brick ",null,0.84,null,null,null,null,"Asphalt",null,0.9]
[null,null,"Dense Plaster",null,0.5,null,null,null,null,"Concrete",null,1.4]
[null,null,"Lightweight Plaster",null,0.16,null,null,null,null,"Lightw't Concrete",null,0.38]
[null,null,"Plasterboard",null,0.16,null,null,null,null,"Dense Plaster",null,0.5]
[null,null,"Exp. Polystyrene",null,0.033,null,null,null,null,"Lightweight Plaster",null,0.1]
[null,null,"Lightw't Concrete",null,0.38,null,null,null,null,"Concrete",null,0.16]
[null,null,"Concrete",null,1.4,null,null,null,null,"Phenolic Foam",null,0.038]
[null,null,"Concrete Block",null,0.19,null,null,null,null,"Fibreboard",null,0.057]
[null,null,"Asbestos Sheet",null,0.36,null,null,null,null,"Exp. Polystyrene",null,0.033]
[null,null,"Woodwool Slab",null,0.09,null,null,null,null,"Tiles",null,0.84]
[null,null,"Glass Fibre",null,0.035,null,null,null,null,"Roofing Felt",null,0.19]
[null,null,"Timber",null,0.14,null,null,null,null,"Glass Fibre",null,0.035]
[null,null,"Weatherboarding",null,0.14,null,null,null,null,"Asbestos Sheet",null,0.36]
[null,null,"Air",null,0.026,null,null,null,null,"Slate",null,2.0]
[]
[null,null,"Miscellaneous Materials"]
[null,null,"Bitumen",null,0.85,null,null,null,null,"Granite",null,2.5]
[null,null,"Carpet - woollen",null,0.055,null,null,null,null,"Wood Chipboard",null,0.15]
[null,null,"Carpet Underlay",null,0.045,null,null,null,null,"Woodwool Slab",null,0.11]
[null,null,"Corkboard",null,0.042,null,null,null,null,"Water",null,0.6]
[null,null,"Glass Sheet",null,1.05,null,null,null,null,"Seawater",null,0.58]
[null,null,"Gravel",null,0.3,null,null,null,null,"Carbon Steel",null,50.0]
[null,null,"Hardboard",null,0.08,null,null,null,null,"High Alloy Steel",null,15.0]
[null,null,"PVC Flooring",null,0.35,null,null,null,null,"Fresh Snow",null,0.17]
[null,null,"Phenolic Foam",null,0.037,null,null,null,null,"Compacted Snow",null,0.43]

{"sheet":"Hygro","index":13,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,1.0]
[]
[null,null,null,null,null,"Airflow",3.62,"m3/s"]
[]
[null,null,"PROCESS ON",null,null,null,null,null,null,"PROCESS OFF"]
[null,null,null,null,null,{"$f":"IF(J7-C7<0,\"Sensible Cooling\",\"Heating\")","v":"Sensible Cooling"},{"$f":"ABS((G3*2/(C13+J13))*(C7-J7)*1.2)","v":42.2635381},"kW"]
[null,null,23.0,"C (db)",null,{"$f":"IF(J12-C12<0,\"De-humidification\",\"Humidification\")","v":"De-humidification"},{"$f":"2258*G9","v":45.9552968},"kW",null,14.8,"C (db)"]
[null,null,80.0,"% rh",null,"Energy Change",{"$f":"ABS(G3*(J14-C14)/C13)","v":89.22515476},"kW",null,95.0,"% rh"]
[null,null,null,null,null,{"$f":"IF(J12-C12<0,\"Water Removed\",\"Water Added\")","v":"Water Removed"},{"$f":"ABS(G3*(J12-C12))/((C13+J13)*500)","v":0.02035221293},"litres/s"]
[null,null,null,null,null,null,{"$f":"ABS(G9*3600)","v":73.26796656},"kg/h"]
[]
[null,null,{"$f":"ABS(C8*C15*0.01)","v":14.248},"g/kg",null,null,"Moisture Content",null,null,{"$f":"ABS(J8*J15*0.01)","v":9.5095},"g/kg"]
[null,null,{"$f":"ABS((C7+273)/1013)*(2.87+(4.61*C15*C8/100000))","v":0.8578107116},"m3/kg",null,null,"Specific Volume",null,null,{"$f":"ABS((J7+273)/1013)*(2.87+(4.61*J15*J8/100000))","v":0.8278408738},"m3/kg"]
[null,null,{"$f":"ABS(C16+(C15*C8/100)*2.55)","v":59.4724},"kJ/kg",null,null,"Specific Enthalpy",null,null,{"$f":"ABS(J16+(J15*J8/100)*2.55)","v":38.329225},"kJ/kg"]
[null,null,{"$f":"VLOOKUP(C7,C34:J79,6)*1000","v":17.81},"g/kg",null,null,"Saturation Moisture Content",null,null,{"$f":"VLOOKUP(J7,C34:J79,6)*1000","v":10.01},"g/kg"]
[null,null,{"$f":"VLOOKUP(C7,C34:J79,7)","v":23.14},"kJ/kg",null,null,"Specific Enthalpy Dry Air",null,null,{"$f":"VLOOKUP(J7,C34:J79,7)","v":14.08},"kJ/kg"]
[null,null,{"$f":"VLOOKUP(C7,C34:K79,8)","v":28.08},"Pa",null,null,"Saturation Vapour Pressure",null,null,{"$f":"VLOOKUP(J7,C34:J79,8)","v":15.98},"Pa"]
[]
[]
[]
[null,null,null,null,null,null,"HYGROMETRIC DATA (0oC to 45oC)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"HYGROMETRIC TABLES"]
[]
[null,null,"DRY BULB","RELATIVE","MOISTURE ","SPECIFIC","SPECIFIC","SATURATED","ENTHALPY ","SATURATED "]
[null,null,"TEMP.","HUMIDITY","CONTENT","VOLUME","ENTHALPY","MOISTURE ","OF DRY AIR","VAPOUR "]
[null,null," oC.","%","kg/kg","m3/kg","kJ/kg","CONTENT, kg/kg","kJ/kg","PRESS, Pa"]
[]
[null,null,0.0,50.0,{"$f":"ABS(D34*H34*0.01)","v":0.0018945},{"$f":"ABS((C34+273)/1013)*(2.87+(4.61*H34*D34/100))","v":0.7758087711},{"$f":"ABS(I34+(H34*D34/100)*2550)","v":4.830975},0.003789,0.0,6.108]
[null,null,1.0,50.0,0.0020375,0.7788288724,6.201625,0.004075,1.006,6.566]
[null,null,2.0,50.0,0.00219,0.7818621644,7.5965,0.00438,2.012,7.055]
[null,null,3.0,50.0,0.002353,0.7849100327,9.01815,0.004706,3.018,7.575]
[null,null,4.0,50.0,0.0025265,0.7879726206,10.466575,0.005053,4.024,8.129]
[null,null,5.0,50.0,0.002711,0.7910507042,11.94305,0.005422,5.03,8.719]
[null,null,6.0,30.0,0.0017448,0.7926694416,10.48524,0.005816,6.036,9.346]
[null,null,7.0,50.0,0.0031175,0.797259693,14.991625,0.006235,7.042,10.013]
[null,null,8.0,50.0,0.0033405,0.8003922183,16.566275,0.006681,8.048,10.72]
[null,null,9.0,50.0,0.0035775,0.8035447399,18.176625,0.007155,9.054,11.47]
[null,null,10.0,95.0,0.00727605,0.8111575055,28.6139275,0.007659,10.06,12.27]
[null,null,11.0,95.0,0.0077843,0.8146806682,30.909965,0.008194,11.06,13.12]
[null,null,12.0,50.0,0.0043815,0.8131358675,23.242825,0.008763,12.07,14.02]
[null,null,13.0,95.0,0.00889865,0.8218682271,35.7715575,0.009367,13.08,14.97]
[null,null,14.0,95.0,0.0095095,0.8255397178,38.329225,0.01001,14.08,15.98]
[null,null,15.0,50.0,0.00535,0.8229645489,28.7325,0.0107,15.09,17.04]
[null,null,16.0,50.0,0.005705,0.826288958,30.64775,0.01141,16.1,18.17]
[null,null,17.0,50.0,0.006085,0.8296495918,32.61675,0.01217,17.1,19.36]
[null,null,18.0,50.0,0.00649,0.8330467916,34.6595,0.01298,18.11,20.63]
[null,null,19.0,50.0,0.00692,0.8364808987,36.756,0.01384,19.11,21.96]
[null,null,20.0,80.0,0.0118,0.8458525311,50.2,0.01475,20.11,23.37]
[null,null,21.0,50.0,0.007855,0.8434612001,41.16025,0.01571,21.13,24.86]
[null,null,22.0,50.0,0.008365,0.8470147895,43.46075,0.01673,22.13,26.43]
[null,null,23.0,50.0,0.008905,0.8506134322,45.84775,0.01781,23.14,28.08]
[null,null,24.0,50.0,0.009475,0.8542575378,48.30125,0.01895,24.14,29.83]
[null,null,25.0,60.0,0.012096,0.860688295,55.9948,0.02016,25.15,31.66]
[null,null,26.0,50.0,0.010715,0.8616973829,53.48325,0.02143,26.16,33.6]
[null,null,27.0,50.0,0.01139,0.8655008588,56.2045,0.02278,27.16,35.64]
[null,null,28.0,50.0,0.012105,0.8693652705,59.03775,0.02421,28.17,37.79]
[null,null,29.0,50.0,0.01286,0.8732911641,61.973,0.02572,29.18,40.05]
[null,null,30.0,50.0,0.013655,0.8772790855,65.00025,0.02731,30.18,42.42]
[null,null,31.0,50.0,0.0145,0.8813434156,68.165,0.029,31.19,44.92]
[null,null,32.0,50.0,0.015385,0.8854709568,71.43175,0.03077,32.2,47.54]
[null,null,33.0,50.0,0.016325,0.8896831436,74.82875,0.03265,33.2,50.29]
[null,null,34.0,50.0,0.017315,0.8939737414,78.36325,0.03463,34.21,53.19]
[null,null,35.0,75.0,0.0275475,0.911228178,105.466125,0.03673,35.22,56.22]
[null,null,36.0,50.0,0.01947,0.9028280556,85.8685,0.03894,36.22,59.4]
[null,null,37.0,50.0,0.02064,0.9074004186,89.862,0.04128,37.23,62.74]
[null,null,38.0,50.0,0.02187,0.9120683492,94.0085,0.04374,38.24,66.24]
[null,null,39.0,50.0,0.023175,0.9168539645,98.33625,0.04635,39.24,69.91]
[null,null,40.0,50.0,0.02455,0.9217511663,102.8525,0.0491,40.25,73.75]
[null,null,41.0,50.0,0.026,0.9267680553,107.56,0.052,41.26,77.78]
[null,null,42.0,50.0,0.0275,0.9318698174,112.385,0.055,42.26,81.99]
[null,null,43.0,50.0,0.02915,0.9372009418,117.6025,0.0583,43.27,86.4]
[null,null,44.0,50.0,0.030865,0.9426408539,122.98575,0.06173,44.28,91.0]
[null,null,45.0,50.0,0.03267,0.9482266205,128.5885,0.06534,45.28,95.82]

{"sheet":"Process","index":14,"n_rows":54,"n_cols":30,"rows_kept":54,"cut":false,"hidden":false,"merged":[[8,8,11,10],[8,13,11,15],[12,9,16,9],[12,12,12,16],[17,8,18,10],[0,13,0,15],[1,13,1,15],[2,13,3,15],[4,7,4,11],[4,14,5,14],[5,7,5,11],[8,4,11,4],[12,3,12,5]]}
["Back"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G30>0,\"Water Added\",\"\")","v":""},{"$f":"S31","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G30>0,G30,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"               HYGROMETRIC TABLES"]
[null,null,"Energy Change",{"$f":"ABS(G31)+ABS(G32)","v":85.05973999},"kW",null,null,null,null,null,null,null,{"$f":"IF(G30>0,\"kg/hr\",\"\")","v":""}]
[null,null,null,null,null,null,"m3/s",{"$f":"SUM(H14:H15)","v":-85.05973999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Bulb",null,"Moisture","Specific","Specific","Saturated","Enthalpy","SATURATED "]
[null,null,null,null,null,null,5.25,"kW Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temp.","R.H.","Content","Volume","Enthalpy","Moisture","of dry air","VAPOUR "]
[null,"Inlet Condition",null,null,{"$f":"IF(G31>0,\"Heating\",\"\")","v":""},null,"Fan",null,null,"Cooling",null,null,null,null,{"$f":"IF(G30>0,\"Humidification\",\"\")","v":""},null,null,"Outlet Condition",null,null,null,null," oC.","%","kg/kg","m3/kg","kJ/kg","Content kg","kJ/kg","PRESS, Pa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S31","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,50.0,{"$f":"ABS(X9*AB9*0.01)","v":0.0018945},{"$f":"ABS((W9+273)/1013)*(2.87+(4.61*AB9*X9/100))","v":0.7758087711},{"$f":"ABS(AC9+(AB9*X9/100)*2550)","v":4.830975},0.003789,0.0,6.108]
[null,20.0,"C (db)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.0,"C (db)",null,null,null,1.0,50.0,0.0020375,0.7788288724,6.201625,0.004075,1.006,6.566]
[null,84.0,"% rh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,95.0,"% rh",null,null,null,2.0,50.0,0.00219,0.7818621644,7.5965,0.00438,2.012,7.055]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0,50.0,0.002353,0.7849100327,9.01815,0.004706,3.018,7.575]
[null,null,null,{"$f":"IF(G31>0,G31,\"\")","v":""},null,null,null,{"$f":"IF(H5<0,\"kW\",\"\")","v":"kW"},null,null,null,null,{"$f":"IF(G30>0,G32,\"\")","v":""},null,null,null,null,null,null,null,null,null,4.0,50.0,0.0025265,0.7879726206,10.466575,0.005053,4.024,8.129]
[null,null,null,null,{"$f":"IF(G31>0,\"kW\",\"\")","v":""},null,null,{"$f":"IF(G31<0,G31,\"\")","v":-38.34764011},null,null,null,{"$f":"IF(G31<0,\"Sensible Cooling\",\"\")","v":"Sensible Cooling"},null,null,{"$f":"IF(G29<=0,\"\",\"kW\")","v":""},null,null,null,null,null,null,null,5.0,50.0,0.002711,0.7910507042,11.94305,0.005422,5.03,8.719]
[null,{"$f":"ABS(B11*B18*0.01)","v":0.01239},"kg/kg","Moisture Content",null,null,null,{"$f":"IF(G32<0,G32,\"0\")","v":-46.71209987},null,null,null,{"$f":"IF(G32<=0,\"Latent Cooling\",\"\")","v":"Latent Cooling"},null,null,null,null,{"$f":"ABS(R11*Q18*0.01)","v":0.0095095},"kg/kg",null,null,null,null,6.0,30.0,0.0017448,0.7926694416,10.48524,0.005816,6.036,9.346]
[null,{"$f":"ABS((B10+273)/1013)*(2.87+(4.61*B18*B11/100))","v":0.8466392346},"m3/kg","Specific Volume",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS((R10+273)/1013)*(2.87+(4.61*Q18*R11/100))","v":0.8255397178},"m3/kg",null,null,null,null,7.0,50.0,0.0031175,0.797259693,14.991625,0.006235,7.042,10.013]
[null,{"$f":"ABS(B19+(B18*B11/100)*2550)","v":51.7045},"kJ/kg","Specific Enthalpy",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(Q19+(Q18*R11/100)*2550)","v":38.329225},"kJ/kg",null,null,null,null,8.0,50.0,0.0033405,0.8003922183,16.566275,0.006681,8.048,10.72]
[null,{"$f":"VLOOKUP(B10,W9:AD54,6)","v":0.01475},"kg","Specific Moisture Conteny",null,null,null,null,{"$f":"S31","v":""},null,null,{"$f":"IF(G30<0,G30,\"\")","v":-58.8773104},{"$f":"IF(G30<0,\"kg/h\",\"\")","v":"kg/h"},null,null,null,{"$f":"VLOOKUP(R10,W9:AD54,6)","v":0.01001},"kg",null,null,null,null,9.0,50.0,0.0035775,0.8035447399,18.176625,0.007155,9.054,11.47]
[null,{"$f":"VLOOKUP(B10,W9:AD54,7)","v":20.11},"kJ/kg","Enthalpy Dry air",null,null,null,null,null,null,null,{"$f":"IF(G30<0,\"Water Removed\",\"\")","v":"Water Removed"},null,null,null,null,{"$f":"VLOOKUP(R10,W9:AD54,7)","v":14.08},"kJ/kg",null,null,null,null,10.0,50.0,0.0038295,0.806718737,19.825225,0.007659,10.06,12.27]
[null,{"$f":"VLOOKUP(B10,W9:AD54,8)","v":23.37},"Pa","Saturated Vapour Pressure",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(R10,W9:AD54,8)","v":15.98},"Pa",null,null,null,null,11.0,50.0,0.004097,0.8099150605,21.50735,0.008194,11.06,13.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.0,50.0,0.0043815,0.8131358675,23.242825,0.008763,12.07,14.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.0,50.0,0.0046835,0.8163820409,25.022925,0.009367,13.08,14.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.0,50.0,0.005005,0.8196564317,26.84275,0.01001,14.08,15.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.0,50.0,0.00535,0.8229645489,28.7325,0.0107,15.09,17.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16.0,50.0,0.005705,0.826288958,30.64775,0.01141,16.1,18.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.0,50.0,0.006085,0.8296495918,32.61675,0.01217,17.1,19.36]
[null,null,null,null,null,"Moisture content At inlet",{"$f":"(G6/B16)*B15","v":0.07683024521},"kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.0,50.0,0.00649,0.8330467916,34.6595,0.01298,18.11,20.63]
[null,null,null,null,null,"Moisture content At outlet",{"$f":"(G6/Q16)*Q15","v":0.06047543676},"kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.0,50.0,0.00692,0.8364808987,36.756,0.01384,19.11,21.96]
[null,null,null,null,null,"Moisture change",{"$f":"G28-G27","v":-0.01635480845},"kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.0,78.0,0.011505,0.8454591793,49.44775,0.01475,20.11,23.37]
[null,null,null,null,null,null,{"$f":"G29*3600","v":-58.8773104},"kg/h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.0,50.0,0.007855,0.8434612001,41.16025,0.01571,21.13,24.86]
[null,null,null,null,null,"Sensible change",{"$f":"(G6/Q16)*(Q19-B19)","v":-38.34764011},"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.0,50.0,0.008365,0.8470147895,43.46075,0.01673,22.13,26.43]
[null,null,null,null,null,"Latent change",{"$f":"($G$6*(($Q$17-$Q$19)-($B$17-$B$19))/(($Q$16)))","v":-46.71209987},"kW",null,null,null,null,{"$f":"IF(Q32<0,ABS(Q32),\"\")","v":""},null,null,null,null,null,null,null,null,null,23.0,50.0,0.008905,0.8506134322,45.84775,0.01781,23.14,28.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.0,50.0,0.009475,0.8542575378,48.30125,0.01895,24.14,29.83]
[null,null,null,null,null,"Total change",{"$f":"G32+G31","v":-85.05973999},"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.0,50.0,0.01008,0.8579542965,50.854,0.02016,25.15,31.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26.0,50.0,0.010715,0.8616973829,53.48325,0.02143,26.16,33.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.0,50.0,0.01139,0.8655008588,56.2045,0.02278,27.16,35.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.0,50.0,0.012105,0.8693652705,59.03775,0.02421,28.17,37.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.0,50.0,0.01286,0.8732911641,61.973,0.02572,29.18,40.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.0,50.0,0.013655,0.8772790855,65.00025,0.02731,30.18,42.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.0,50.0,0.0145,0.8813434156,68.165,0.029,31.19,44.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32.0,50.0,0.015385,0.8854709568,71.43175,0.03077,32.2,47.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33.0,50.0,0.016325,0.8896831436,74.82875,0.03265,33.2,50.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34.0,50.0,0.017315,0.8939737414,78.36325,0.03463,34.21,53.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35.0,50.0,0.018365,0.8983574494,82.05075,0.03673,35.22,56.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36.0,50.0,0.01947,0.9028280556,85.8685,0.03894,36.22,59.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37.0,50.0,0.02064,0.9074004186,89.862,0.04128,37.23,62.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38.0,50.0,0.02187,0.9120683492,94.0085,0.04374,38.24,66.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39.0,50.0,0.023175,0.9168539645,98.33625,0.04635,39.24,69.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.0,50.0,0.02455,0.9217511663,102.8525,0.0491,40.25,73.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.0,50.0,0.026,0.9267680553,107.56,0.052,41.26,77.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42.0,50.0,0.0275,0.9318698174,112.385,0.055,42.26,81.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.0,50.0,0.02915,0.9372009418,117.6025,0.0583,43.27,86.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44.0,50.0,0.030865,0.9426408539,122.98575,0.06173,44.28,91.0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45.0,50.0,0.03267,0.9482266205,128.5885,0.06534,45.28,95.82]

{"sheet":"Process 2","index":15,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["   Specific Enthalpy",null,"Volume","Sp. Vol","       Air on",null,"          Air off"]
["kJ/kg","kjJ/kg","m3/s","m3/kg","db","%","db","%","kW"]
[20.0,54.0,1.0,0.883,10.0,0.5,35.0,0.2,{"$f":"(C3/D3)*(A3-B3)","v":-38.50509626},1.0]
[]
[20.0,30.0,1.0,0.847,10.0,0.5,25.0,0.1,{"$f":"(C5/D5)*(A5-B5)","v":-11.80637544},2.0]
[]
[116.0,76.0,1.0,0.871,40.0,0.6,25.0,1.0,{"$f":"(C7/D7)*(A7-B7)","v":45.92422503},3.0]
[]
[79.0,39.0,1.0,0.839,45.0,0.2,20.0,0.5,{"$f":"(C9/D9)*(A9-B9)","v":47.67580453},4.0]
[]
[79.0,65.0,1.0,0.877,45.0,0.2,30.0,0.5,{"$f":"(C11/D11)*(A11-B11)","v":15.96351197},5.0]
[]
[56.0,44.0,1.0,0.866,42.0,0.1,30.0,0.2,{"$f":"(C13/D13)*(A13-B13)","v":13.85681293},6.0]
[44.0,56.0,1.0,0.866,30.0,0.2,42.0,0.1,-13.85681293]

{"sheet":"Sound","index":16,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["<<<Back",null,null,null,null,null,"REV. NO.","A","B","C","D","Sheet No",null,null,"of"]
[null,null,null," SOUND ATTENUATION",null,null,"CALC. BY",null,null,null,null,"Job","No."]
["JOB:",null,null,"SYSTEM:",null,null,"CHECKED ",null,null,null,null,"Doc.","No."]
[]
[null,null,"        CALCULATIONS",null,null,null,"DATA",null,null,null,"    OCTAVE BAND MID FREQUENCY, Hz",null,null,null,null,"NO."]
[null,null,null,null,null,null,"SOURCE",63.0,125.0,250.0,500.0,1000.0,2000.0,4000.0,8000.0,"OFF"]
[1.0,"MAXIMUM SOUND PRESSURE LEVEL  =      ",null,null,null,"NR 40","TABLE 1",67.0,57.0,49.0,44.0,40.0,37.0,35.0,33.0]
[2.0,"ROOM AND TERMINAL EFFECT",null,null,null,null,"FIG.1",3.0,{"$f":"ABS(H8)","v":3},3,3,3,3,3,3]
[3.0,"ALLOWANCE FOR END REFLECTION",null,null,null,null,"TABLE 2",9.0,5.0,1.0,0.0,0.0,0.0,0.0,0.0]
[4.0,"DUCTWORK ATTENUATION-TERMINAL TO CHECKPOINT",null,null,null,null,"TABLE 3",0.3,0.15,0.03,0.0,0.0,0.0,0.0,0.0,25.0]
[null,"(Duct length given in metres against Table 3 data)",null,null,null,null,null,{"$f":"ABS(H10*P10)","v":7.5},{"$f":"ABS(I10*P10)","v":3.75},{"$f":"ABS(J10*P10)","v":0.75},{"$f":"ABS(K10*P10)","v":0},{"$f":"ABS(L10*P10)","v":0},{"$f":"ABS(M10*P10)","v":0},{"$f":"ABS(N10*P10)","v":0},{"$f":"ABS(O10*P10)","v":0}]
[5.0,"ELBOW ATTENUATION-TERMINAL TO CHECKPOINT",null,null,null,null,"TABLE 4",0.3,0.15,0.03,0.0,0.0,0.0,0.0,0.0,6.0]
[null,"(No. of bends indicated against Table 4 data)",null,null,null,null,null,{"$f":"ABS(H12*P12)","v":1.8},{"$f":"ABS(I12*P12)","v":0.9},{"$f":"ABS(J12*P12)","v":0.18},{"$f":"ABS(K12*P12)","v":0},{"$f":"ABS(L12*P12)","v":0},{"$f":"ABS(M12*P12)","v":0},{"$f":"ABS(N12*P12)","v":0},{"$f":"ABS(O12*P12)","v":0}]
[6.0,"PWL SPLIT-BRANCH TO TERMINALS",null,null,null,null,"TABLE 5",6.0,{"$f":"ABS(H14)","v":6},6,6,6,6,6,6]
[7.0,"PWL SPLIT-MAIN DUCT TO BRANCH",null,null,null,null,"TABLE 6",5.0,{"$f":"ABS(H15)","v":5},5,5,5,5,5,5]
[8.0,"CALCULATED PWL AT CHECKPOINT",null,null,null,null,"TOTAL 1 to 7",{"$f":"SUM(H7,H8,H9,H11,H13,H14,H15)","v":99.3},80.65,64.93,58,54,51,49,47]
[9.0,"DEDUCT 3dB SAFETY FACTOR",null,null,null,null,null,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0]
[10.0,"PERMISSIBLE PWL AT CHECKPOINT",null,null,null,null,null,{"$f":"SUM(H16:H17)","v":96.3},77.65,61.93,55,51,48,46,44]
[11.0,"POWER LEVEL OF NOISE SOURCE AT CHECKPOINT",null,null,null,null,"Manfr's Data",91.0,83.0,77.0,73.0,70.0,68.0,66.0,64.0]
[12.0,"DYNAMIC INSERTION LOSS REQUIRED",null,null,null,null,"11 minus 10",{"$f":"SUM(H19-H18)","v":-5.3},5.35,15.07,18,19,20,20,20]
[]
[null,null,null,"        DESIGN DATA",null,null,"TABLE 1",null,null,null,"      NOISE LEVELS FOR SPACES, dB.",null,null,null,null,"dBA"]
["     LOCATION:",null,null,null,null,null,"NR20",51.0,39.0,31.0,24.0,20.0,17.0,14.0,13.0,30.0]
[null,null,null,null,null,null,"NR25",55.0,44.0,35.0,29.0,25.0,22.0,20.0,18.0,35.0]
["        ROOM DIMENSIONS:",null,null,null,"Volume, m3           =",{"$f":"ABS(B27*C27*D27)","v":240},"NR30",59.0,48.0,40.0,34.0,30.0,27.0,25.0,23.0,39.0]
[null,"Length, m","Width, m","Height, m","Floor Area, m2      =",{"$f":"ABS(B27*C27)","v":60},"NR35",63.0,52.0,45.0,39.0,35.0,32.0,30.0,28.0,44.0]
[null,12.0,5.0,4.0,"Surface Area, m2 =",{"$f":"ABS(((B27+C27)*2)*D27)+2*(B27*C27)","v":256},"NR40",67.0,57.0,49.0,44.0,40.0,37.0,35.0,33.0,48.0]
[null,null,null,null,null,null,"NR45",71.0,61.0,54.0,48.0,45.0,42.0,40.0,38.0,53.0]
[null,null,null,null,null,null,"NR50",75.0,65.0,59.0,53.0,50.0,47.0,45.0,43.0,58.0]
[null,"      MAX. PERMISSIBLE NOISE LEVEL (NR)     =",null,null,null,40.0,"NR55",79.0,70.0,63.0,58.0,55.0,52.0,50.0,49.0,62.0]
[null,null,null,null,null,null,"NR60",83.0,74.0,68.0,63.0,60.0,57.0,55.0,54.0,67.0]
[null,"NO.of TERMINALS =",null,8.0,null,null,"NR65",87.0,78.0,72.0,68.0,65.0,62.0,61.0,59.0,72.0]
[null,null,null,null,null,null,"NR70",91.0,83.0,77.0,73.0,70.0,68.0,66.0,64.0,77.0]
[null,null,"ROOM CHARACTERISTIC"]
[null,"SOFT","AVER'GE","HARD",null,null,"TABLE 2",null,null,null,"ATTENUATION DUE TO END"]
[null,null,"X",null,null,null,"DUCT EQUIV",null,null,null,"     REFLECTION AT DUCT OPENINGS,dB"]
[null,null,null,null,null,null,"DIA, mm. ",null,null,null,"(Select nearest applicable line)"]
[null,null,null,null,null,null,125.0,13.0,9.0,5.0,1.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,250.0,9.0,5.0,1.0,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,500.0,5.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,1000.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[]
[null,null,null,null,null,null,"TABLE 3",null,null,null,"ATTENUATION OF UNLINED"]
[null,null,null,null,null,null,"DUCT SIZE",null,null,null,"     SHEET METAL DUCTS, dB / metre."]
[null,null,null,null,null,null,"150 X 150",0.6,0.45,0.3,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,"600 X 600",0.6,0.3,0.15,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,"850 X 850",0.3,0.15,0.03,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,"<300 Dia.",0.1,0.1,0.0,0.0,0.0,0.0,0.0,0.0]
[null,null,null,null,null,null,">300 Dia.",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0]
[]
[null,null,null,null,null,null,"TABLE 4",null,null,null,"ATTENUATION OF UNLINED"]
[null,null,null,null,null,null,"DUCT DIA.",null,null,null,"SHEET METAL BENDS, dB."]
[null,null,null,null,null,null,"OR WIDTH.",null,null,null,"(Select nearest applicable line)"]
[null,null,null,null,null,null,"250 Max.",0.0,null,null,"1.2.4","2.5.8","3.4.5",3.0,3.0]
[null,null,null,null,null,null,"500 Max.",0.0,null,"1.2.4","2.5.8","3.4.5",3.0,3.0,3.0]
[null,null,null,null,null,null,"1000 Max.",0.0,"1.2.4","2.5.8","3.4.5",3.0,3.0,3.0,3.0]
[null,null,null,null,null,null,"2000 Max.","1.2.4","2.5.8","3.4.5",3.0,3.0,3.0,3.0,3.0]
[null,null,null,null,null,null,"Where 3-values are shown, use 1st for round bends,"]
[null,null,null,null,null,null,"2nd for sq. bends with vanes, 3rd for bends with no vanes."]
[]
[null,null,null,null,null,null,"TABLE 5",null,null,null,"           PWL SPLIT-BRANCH TO TERMINALS"]
[null,null,null,null,null,null,"No. Terminals",1.0,2.0,3.0,4.0,8.0,10.0,20.0,40.0,100.0]
[null,null,null,null,null,null,"dB Allowance",0.0,3.0,5.0,6.0,9.0,10.0,13.0,16.0,20.0]
[]
[null,null,null,null,null,null,"TABLE 6",null,null,null,"   PWL SPLIT-MAIN DUCT TO BRANCH "]
[null,null,null,null,null,null,"dB to add to",null,null,null,"     AREA OF BRANCH EXPRESSED"]
[null,null,null,null,null,null,"branch PWL ",null,null,null,"    AS % OF MAIN BRANCH AREA"]
[null,null,null,null,null,null,"to give main",0.2,0.5,1.0,2.0,5.0,10.0,20.0,50.0]
[null,null,null,null,null,null,"duct PWL.",27.0,23.0,20.0,17.0,13.0,10.0,7.0,3.0]

{"sheet":"Pipes","index":17,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Back"]
[null,null,"     BLACK MILD STEEL PIPE SIZES",null,null,null,null,null,"GALVANISED PIPES"]
[null,null,null,null,"            FOR VARIOUS kW DUTIES.",null,null,"            FOR HWS AND CWS SYSTEMS"]
[]
[null,null,null,null,null,null,null,"Max.","Equivalent","Equivalent ","HWS"]
["    Diameter,",null,"   Max. Water ",null,"             kW Rated Output",null,null,"Simultaneous","Flow Rate","Pressure ","Return Dia."]
["        mm.",null," Flow  Rate, l/s.",null,"      T=5oC.","     T=10oC.","     T=15oC.","Demand Units","l/s.","Drop, Pa.","mm"]
[]
[10.0,null,0.03,null,0.6,1.3,2.0]
[15.0,null,0.07,null,1.5,3.0,4.5,10.0,0.06,200.0,15.0]
[20.0,null,0.16,null,3.4,6.7,10.0,25.0,0.15,220.0,15.0]
[]
[25.0,null,0.35,null,7.0,15.0,22.0,50.0,0.3,250.0,20.0]
[32.0,null,0.71,null,15.0,30.0,45.0,150.0,0.6,210.0,20.0]
[40.0,null,1.0,null,20.0,40.0,60.0,250.0,0.9,200.0,25.0]
[]
[50.0,null,2.0,null,40.0,80.0,120.0,500.0,1.5,150.0,32.0]
[65.0,null,4.0,null,85.0,170.0,250.0,1500.0,3.6,210.0,32.0]
[80.0,null,6.0,null,125.0,250.0,375.0,2500.0,5.5,200.0,40.0]
[100.0,null,13.0,null,275.0,550.0,800.0,5000.0,10.0,160.0,50.0]
[]
[150.0,null,36.0,null,750.0,1500.0,2250.0," TYPICAL PRACTICAL DEMAND UNITS"]
[200.0,null,90.0,null,1850.0,3700.0,5500.0," Basin or Bidet","( Hot & Cold)",3.0,"1.5 ea"]
[null,null,null,null,null,null,null," Sink","( Hot & Cold)",15.0,"7.5 each"]
[null,null," NOTE",null,null,null,null," Bath","( Hot & Cold)",20.0,"10 each"]
[null,null," 1)  For LPHW heating, typical",null,null,"   T= 82oC - 71oC = 11oC.",null," Shower","( Hot & Cold)",8.0,"4 ea"]
[null,null," 2)  For fan coil unit cooling, typical      T= 12oC - 7oC = 5oC.",null,null,null,null," WC","(Cold only)",8.0,"only"]

{"sheet":"PFEER","index":18,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"JOB NO."]
["   MODULE INTEGRITY",null,null,null,null,null,"LOCATION"]
["        TEST RESULTS",null,null,null,null,null,"DATE"]
[null,null,null,null,null,null,"TEST BY"]
[null,null,null,null,null,null,"WITNESS"]
[]
["                           Module / Area Tested:",null,null,null,"Control Room"]
[]
[]
["The following data is used to calculate the actual leakage rate for the module"]
[]
[]
["                      Allowable Leakage Rate =",null,null,null,0.2,"air changes per hour (ac/h)"]
[null,null," "]
[]
[null,null,null,null,"         Volume of Module  =",null,null,548.0,"m3"]
[]
[]
["                  Maximum Permissible Supply (Leakage) Air Volume  =",null,null,null,null,null,null,{"$f":"ABS(E13*H16)","v":109.6},"m3/h"]
["                  (Based on ",null,{"$f":"TEXT( ,E13)","v":"0.20"},"ac/h)",null,null,"(i.e.",{"$f":"ABS((E13*H16)/3600)","v":0.03044444444},"m3/s)"]
[]
[]
[]
[]
[]
[null,null,null,null,"MEASURED RESULTS"]
[]
[]
["           Max Permitted Leakage Rate for",null,null,null,{"$f":"REPT(E7,1)","v":"Control Room"},null,"=",{"$f":"ABS(E13*H16)","v":109.6},"m3/h"]
[]
[]
[null,"           Leakage Rate During Pressurisation",null,null,null,null,"=",110.4,"m3/h"]
[]
[]
[null,"           Leakage Rate During Depressurisation",null,null,null,null,"=",108.2,"m3/h"]
[]
[]
[null,"           Average Measured Air Leakage Rate",null,null,null,null,"=",{"$f":"ABS((H32+H35)/2)","v":109.3},"m3/h"]
[]
[]
[null,null," Final Test Result",null,null,{"$f":"IF(H38>H29,\"FAIL\",IF(H38<H29,\"PASS\",IF(H38=H29,\"PASS\")))","v":"PASS"}]
[]
[]
["Comments:"]

{"sheet":"Mod Temp","index":19,"n_rows":99,"n_cols":8,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["<<Back"]
[]
["Accommodation Module"]
[null,"length",15.0,"m"]
[null,"breadth",15.0,"m"]
[null,"height",30.25,"m"]
[null,"Surface Area (A)",{"$f":"2*(C4*C5)+2*(C4*C6)+2*(C5*C6)","v":2265},"m2"]
[null,"Enclosed Volume",{"$f":"C4*C5*C6","v":6806.25},"m3"]
[null,"U",0.3,"W/m2oC"]
["(initial)","Ti",24.0,"oC"]
[null,"To",35.0,"oC"]
[null,"Gains",24.0,"kW (kJ/s)"]
[]
[]
[]
["Temp @","60 mins",{"$f":"E99","v":36.01404296}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,826.0,"Joules will raise",null,1.0,"m3 air  by",1.0,"deg C"]
[null,{"$f":"B28","v":826},"Joules will raise",null,{"$f":"C8","v":6806.25},"m3 air  by",{"$f":"(E28/E29)","v":0.0001469237833},"deg C"]
[null,{"$f":"C12","v":24},"(Available Heat input Joules / second)"]
[null,{"$f":"B29/B30","v":34.41666667},"(Seconds to raise air temp. by 1deg C.)"]
[null,{"$f":"B31/60","v":0.5736111111},"(Minutes to raise air temp. by 1deg C.)"]
[]
[]
[]
[null,"Elapsed","Module heat","Surplus","Module "]
[null,"Time","Loss","Energy","Temp."]
[null,"Minutes","kJ","kJ","oC"]
[null,0.0,null,null,{"$f":"C10","v":24}]
[null,1.0,{"$f":"($C$9*$C$7*($C$10-$C$11))*0.06","v":-448.47},{"$f":"($C$12*60)-C40","v":1888.47},{"$f":"$C$10+(D40/($C$8*1.2))","v":24.23121763}]
[null,2.0,{"$f":"($C$9*$C$7*(E40-$C$11))*0.06","v":-439.0432572},1879.043257,{"$f":"E40+(D41/($C$8*1.2))","v":24.46128108}]
[null,3.0,-429.6635702,1869.66357,24.69019612]
[null,4.0,-420.3307041,1860.330704,24.91796848]
[null,5.0,-411.0444252,1851.044425,25.14460385]
[null,6.0,-401.804501,1841.804501,25.37010792]
[null,7.0,-392.6107,1832.6107,25.59448634]
[null,8.0,-383.462792,1823.462792,25.81774471]
[null,9.0,-374.360548,1814.360548,26.03988864]
[null,10.0,-365.30374,1805.30374,26.26092369]
[null,11.0,-356.2921412,1796.292141,26.48085539]
[null,12.0,-347.3255258,1787.325526,26.69968924]
[null,13.0,-338.4036695,1778.40367,26.91743074]
[null,14.0,-329.5263487,1769.526349,27.13408533]
[null,15.0,-320.6933411,1760.693341,27.34965843]
[null,16.0,-311.9044256,1751.904426,27.56415546]
[null,17.0,-303.159382,1743.159382,27.77758177]
[null,18.0,-294.4579914,1734.457991,27.98994271]
[null,19.0,-285.8000358,1725.800036,28.2012436]
[null,20.0,-277.1852984,1717.185298,28.41148973]
[null,21.0,-268.6135636,1708.613564,28.62068637]
[null,22.0,-260.0846165,1700.084617,28.82883876]
[null,23.0,-251.5982437,1691.598244,29.03595211]
[null,24.0,-243.1542327,1683.154233,29.2420316]
[null,25.0,-234.7523719,1674.752372,29.44708239]
[null,26.0,-226.3924509,1666.392451,29.65110963]
[null,27.0,-218.0742605,1658.074261,29.85411841]
[null,28.0,-209.7975923,1649.797592,30.05611383]
[null,29.0,-201.562239,1641.562239,30.25710095]
[null,30.0,-193.3679945,1633.367994,30.45708478]
[null,31.0,-185.2146534,1625.214653,30.65607035]
[null,32.0,-177.1020117,1617.102012,30.85406264]
[null,33.0,-169.0298661,1609.029866,31.0510666]
[null,34.0,-160.9980145,1600.998015,31.24708718]
[null,35.0,-153.0062558,1593.006256,31.44212926]
[null,36.0,-145.0543899,1585.05439,31.63619775]
[null,37.0,-137.1422176,1577.142218,31.8292975]
[null,38.0,-129.2695407,1569.269541,32.02143335]
[null,39.0,-121.4361622,1561.436162,32.21261011]
[null,40.0,-113.6418858,1553.641886,32.40283256]
[null,41.0,-105.8865164,1545.886516,32.59210548]
[null,42.0,-98.16985973,1538.16986,32.78043359]
[null,43.0,-90.49172258,1530.491723,32.96782162]
[null,44.0,-82.85191266,1522.851913,33.15427425]
[null,45.0,-75.25023865,1515.250239,33.33979617]
[null,46.0,-67.68651019,1507.68651,33.52439201]
[null,47.0,-60.16053786,1500.160538,33.70806639]
[null,48.0,-52.67213319,1492.672133,33.89082392]
[null,49.0,-45.22110865,1485.221109,34.07266918]
[null,50.0,-37.80727767,1477.807278,34.25360671]
[null,51.0,-30.43045456,1470.430455,34.43364104]
[null,52.0,-23.09045461,1463.090455,34.6127767]
[null,53.0,-15.78709399,1455.787094,34.79101816]
[null,54.0,-8.520189818,1448.52019,34.96836988]
[null,55.0,-1.28956011,1441.28956,35.14483631]
[null,56.0,5.904976206,1434.095024,35.32042186]
[null,57.0,13.0635993,1426.936401,35.49513094]
[null,58.0,20.18648844,1419.813512,35.66896792]
[null,59.0,27.273822,1412.726178,35.84193715]
[null,60.0,34.32577747,1405.674223,36.01404296]

{"sheet":"Mod Temp2","index":20,"n_rows":98,"n_cols":41,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Accommodation Module"]
[null,"length",15.0,"m"]
[null,"breadth",15.0,"m"]
[null,"height",30.25,"m"]
[null,"Surface Area (A)",{"$f":"2*(C2*C3)+2*(C2*C4)+2*(C3*C4)","v":2265},"m2"]
[null,"Enclosed Volume",{"$f":"C2*C3*C4","v":6806.25},"m3"]
[null,"U",0.3,"w/m2degC"]
["(initial)","Ti",24.0,"degC"]
[null,"To",10.0,"degC"]
[null,"Gains",58.35,"kW (kj/s)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"To"]
[null,null,"Module heat","Surplus",null,"Module heat","Surplus",5.0,"Module heat","Surplus",null,"Module heat","Surplus",null,"Module heat","Surplus",null,"Module heat","Surplus",null,"Module heat","Surplus",null,"Module heat","Surplus"]
[null,null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy",null,"Loss","Energy"]
[null,null,"kj","kj",null,"kj","kj",null,"kj","kj",null,"kj","kj",null,"kj","kj",null,"kj","kj",null,"kj","kj",null,"kj","kj"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minutes",0.0,5.0,10.0,15.0,20.0,25.0,30.0,35.0]
[null,null,{"$f":"($C$7*$C$5*($C$8-0))*0.06","v":978.48},{"$f":"($C$10*60)-C38","v":2522.52},null,{"$f":"($C$7*$C$5*($C$8-5))*0.06","v":774.63},{"$f":"($C$10*60)-F38","v":2726.37},null,{"$f":"($C$7*$C$5*($C$8-10))*0.06","v":570.78},{"$f":"($C$10*60)-I38","v":2930.22},null,{"$f":"($C$7*$C$5*($C$8-15)*0.06)","v":366.93},{"$f":"($C$10*60)-L38","v":3134.07},null,{"$f":"($C$7*$C$5*($C$8-20))*0.06","v":163.08},{"$f":"($C$10*60)-O38","v":3337.92},null,{"$f":"($C$7*$C$5*($C$8-25))*0.06","v":-40.77},{"$f":"($C$10*60)-R38","v":3541.77},null,{"$f":"($C$7*$C$5*($C$8-30))*0.06","v":-244.62},{"$f":"($C$10*60)-U38","v":3745.62},null,{"$f":"($C$7*$C$5*($C$8-35))*0.06","v":-448.47},{"$f":"($C$10*60)-X38","v":3949.47},null,null,null,null,null,null,null,0.0,{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24},{"$f":"C8","v":24}]
[null,null,{"$f":"($C$7*$C$5*(AH39-0))*0.06","v":991.0717527},2509.928247,null,{"$f":"($C$7*$C$5*(AI39-5))*0.06","v":788.239318},2712.760682,null,{"$f":"($C$7*$C$5*(AJ39-10))*0.06","v":585.4068833},2915.593117,null,{"$f":"($C$7*$C$5*(AK39-15)*0.06)","v":382.5744486},3118.425551,null,{"$f":"($C$7*$C$5*(AL39-20))*0.06","v":179.7420139},3321.257986,null,{"$f":"($C$7*$C$5*(AM39-25))*0.06","v":-23.09042083},3524.090421,null,{"$f":"($C$7*$C$5*(AN39-30))*0.06","v":-225.9228555},3726.922856,null,{"$f":"($C$7*$C$5*(AO39-35))*0.06","v":-428.7552902},3929.75529,null,null,null,null,null,null,null,1.0,{"$f":"AH38+(D38/($C$6*1.2))","v":24.30884848},{"$f":"$C$8+(G38/($C$6*1.2))","v":24.33380716},{"$f":"$C$8+(J38/($C$6*1.2))","v":24.35876584},{"$f":"$C$8+(M38/($C$6*1.2))","v":24.38372452},{"$f":"$C$8+(P38/($C$6*1.2))","v":24.4086832},{"$f":"$C$8+(S38/($C$6*1.2))","v":24.43364187},{"$f":"$C$8+(V38/($C$6*1.2))","v":24.45860055},{"$f":"$C$8+(Y38/($C$6*1.2))","v":24.48355923}]
[null,null,1003.600651,2497.399349,null,801.7807019,2699.219298,null,599.9607531,2901.039247,null,398.1408042,3102.859196,null,196.3208554,3304.679145,null,-5.499093437,3506.499093,null,-207.3190423,3708.319042,null,-409.1389911,3910.138991,null,null,null,null,null,null,null,2.0,24.61615528,{"$f":"AI39+(G39/($C$6*1.2))","v":24.66594805},{"$f":"AJ39+(J39/($C$6*1.2))","v":24.71574082},{"$f":"AK39+(M39/($C$6*1.2))","v":24.76553358},{"$f":"AL39+(P39/($C$6*1.2))","v":24.81532635},{"$f":"AM39+(S39/($C$6*1.2))","v":24.86511912},{"$f":"AN39+(V39/($C$6*1.2))","v":24.91491189},{"$f":"AO39+(Y39/($C$6*1.2))","v":24.96470466}]
[null,null,1016.067008,2484.932992,null,815.2544908,2685.745509,null,614.4419738,2886.558026,null,413.6294568,3087.370543,null,212.8169397,3288.18306,null,12.0044227,3488.995577,null,-188.8080943,3689.808094,null,-389.6206114,3890.620611,null,null,null,null,null,null,null,3.0,24.92192808,24.99643097,25.07093387,25.14543676,25.21993965,25.29444255,25.36894544,25.44344834]
[null,null,1028.471136,2472.528864,null,828.6610221,2672.338978,null,628.8509081,2872.149092,null,429.040794,3071.959206,null,229.23068,3271.76932,null,29.42056591,3471.579434,null,-170.3895481,3671.389548,null,-370.1996622,3871.199662,null,null,null,null,null,null,null,4.0,25.22617454,25.32526422,25.42435389,25.52344356,25.62253323,25.72162291,25.82071258,25.91980225]
[null,null,1040.813346,2460.186654,null,842.0006316,2658.999368,null,643.1879168,2857.812083,null,444.3752019,3056.624798,null,245.5624871,3255.437513,null,46.74977234,3454.250228,null,-152.0629425,3653.062942,null,-350.8756573,3851.875657,null,null,null,null,null,null,null,5.0,25.52890229,25.65245601,25.77600973,25.89956345,26.02311717,26.14667089,26.27022461,26.39377834]
[null,null,1053.093948,2447.906052,null,855.2736532,2645.726347,null,657.4533589,2843.546641,null,459.6330646,3041.366935,null,261.8127703,3239.18723,null,63.99247596,3437.007524,null,-133.8278184,3634.827818,null,-331.6481127,3832.648113,null,null,null,null,null,null,null,6.0,25.8301189,25.97801455,26.1259102,26.27380585,26.4217015,26.56959715,26.7174928,26.86538846]
[null,null,1065.313247,2435.686753,null,868.4804194,2632.519581,null,671.6475917,2829.352408,null,474.814764,3026.185236,null,277.9819363,3223.018064,null,81.14910856,3419.850891,null,-115.6837192,3616.683719,null,-312.5165469,3813.516547,null,null,null,null,null,null,null,7.0,26.12983191,26.30194799,26.47406406,26.64618013,26.8182962,26.99041228,27.16252835,27.33464442]
[null,null,1077.471551,2423.528449,null,881.621261,2619.378739,null,685.7709707,2815.229029,null,489.9206804,3011.07932,null,294.0703901,3206.92961,null,98.22009978,3402.7799,null,-97.63019051,3598.630191,null,-293.4804808,3794.480481,null,null,null,null,null,null,null,8.0,26.42804884,26.62426443,26.82048003,27.01669562,27.21291121,27.4091268,27.6053424,27.80155799]
[null,null,1089.569164,2411.430836,null,894.6965069,2606.303493,null,699.8238495,2801.176151,null,504.951192,2996.048808,null,310.0785346,3190.921465,null,115.2058771,3385.794123,null,-79.6667803,3580.66678,null,-274.5394377,3775.539438,null,null,null,null,null,null,null,9.0,26.72477715,26.94497196,27.16516678,27.38536159,27.6055564,27.82575122,28.04594603,28.26614085]
[null,null,1101.606389,2399.393611,null,907.7064847,2593.293515,null,713.80658,2787.19342,null,519.9066753,2981.093325,null,326.0067707,3174.993229,null,132.106866,3368.893134,null,-61.79303869,3562.793039,null,-255.6929434,3756.692943,null,null,null,null,null,null,null,10.0,27.02002427,27.2640786,27.50813294,27.75218728,27.99624162,28.24029595,28.48435029,28.72840463]
[null,null,1113.583528,2387.416472,null,920.6515201,2580.34848,null,727.7195124,2773.280488,null,534.7875048,2966.212495,null,341.8554972,3159.144503,null,148.9234896,3352.07651,null,-44.00851807,3545.008518,null,-236.9405257,3737.940526,null,null,null,null,null,null,null,11.0,27.31379759,27.58159235,27.84938711,28.11718187,28.38497663,28.65277139,28.92056615,29.18836091]
[null,null,1125.500879,2375.499121,null,933.5319373,2567.468063,null,741.5629952,2759.437005,null,549.5940531,2951.405947,null,357.6251111,3143.374889,null,165.656169,3335.343831,null,-26.31277307,3527.312773,null,-218.2817151,3719.281715,null,null,null,null,null,null,null,12.0,27.60610447,27.89752115,28.18893783,28.4803545,28.77177118,29.06318786,29.35460454,29.64602121]
[null,null,1137.358743,2363.641257,null,946.3480588,2554.651941,null,755.337375,2745.662625,null,564.3266911,2936.673309,null,373.3160072,3127.683993,null,182.3053233,3318.694677,null,-8.705360547,3509.705361,null,-199.7160444,3700.716044,null,null,null,null,null,null,null,13.0,27.89695224,28.21187292,28.5267936,28.84171428,29.15663496,29.47155564,29.78647632,30.101397]
[null,null,1149.157415,2351.842585,null,959.1002057,2541.899794,null,769.0429967,2731.957003,null,578.9857876,2922.014212,null,388.9285785,3112.071421,null,198.8713695,3302.128631,null,8.814160426,3492.18584,null,-181.2430486,3682.243049,null,null,null,null,null,null,null,14.0,28.18634817,28.52465552,28.86296288,29.20127024,29.53957759,29.87788495,30.21619231,30.55449967]
[null,null,1160.897191,2340.102809,null,971.7886973,2529.211303,null,782.6802035,2718.319796,null,593.5717098,2907.42829,null,404.4632161,3096.536784,null,215.3547223,3285.645278,null,26.24622858,3474.753771,null,-162.8622652,3663.862265,null,null,null,null,null,null,null,15.0,28.47429951,28.8358768,29.1974541,29.55903139,29.92060868,30.28218598,30.64376327,31.00534057]
[null,null,1172.578365,2328.421635,null,984.4138512,2516.586149,null,796.2493371,2704.750663,null,608.0848229,2892.915177,null,419.9203088,3081.079691,null,231.7557946,3269.244205,null,43.59128047,3457.40872,null,-144.5732337,3645.573234,null,null,null,null,null,null,null,16.0,28.76081347,29.14554455,29.53027562,29.91500669,30.29973777,30.68446884,31.06919991,31.45393099]
[null,null,1184.20123,2316.79877,null,996.9759837,2504.024016,null,809.7507371,2691.249263,null,622.5254904,2878.47451,null,435.3002437,3065.699756,null,248.0749971,3252.925003,null,60.84975044,3440.15025,null,-126.3754962,3627.375496,null,null,null,null,null,null,null,17.0,29.04589724,29.45366651,29.86143579,30.26920506,30.67697434,31.08474361,31.49251289,31.90028216]
[null,null,1195.766077,2305.233923,null,1009.475409,2491.524591,null,823.1847416,2677.815258,null,636.8940739,2864.105926,null,450.6034062,3050.396594,null,264.3127384,3236.687262,null,78.02207069,3422.977929,null,-108.268597,3609.268597,null,null,null,null,null,null,null,18.0,29.32955794,29.76025041,30.19094289,30.62163537,31.05232784,31.48302032,31.9137128,32.34440527]
[null,null,1207.273195,2293.726805,null,1021.912441,2479.087559,null,836.5516872,2664.448313,null,651.1909332,2849.809067,null,465.8301792,3035.169821,null,280.4694253,3220.530575,null,95.10867127,3405.891329,null,-90.25208272,3591.252083,null,null,null,null,null,null,null,19.0,29.61180268,30.06530393,30.51880518,30.97230643,31.42580768,31.87930893,32.33281019,32.78631144]
[null,null,1218.722873,2282.277127,null,1034.287391,2466.712609,null,849.8519086,2651.148091,null,665.4164264,2835.583574,null,480.9809443,3020.019056,null,296.5454622,3204.454538,null,112.10998,3388.89002,null,-72.32550208,3573.325502,null,null,null,null,null,null,null,20.0,29.89263853,30.3688347,30.84503087,31.32122704,31.79742321,32.27361938,32.74981555,33.22601172]
[null,null,1230.115397,2270.884603,null,1046.600568,2454.399432,null,863.0857387,2637.914261,null,679.5709097,2821.42909,null,496.0560807,3004.943919,null,312.5412518,3188.458748,null,129.0264228,3371.973577,null,-54.48840619,3555.488406,null,null,null,null,null,null,null,21.0,30.17207252,30.67085032,31.16962813,31.66840593,32.16718373,32.66596153,33.16473934,33.66351714]
[null,null,1241.451052,2259.548948,null,1058.852281,2442.147719,null,876.2535091,2624.746491,null,693.6547376,2807.345262,null,511.0559661,2989.944034,null,328.4571946,3172.542805,null,145.8584231,3355.141577,null,-36.74034836,3537.740348,null,null,null,null,null,null,null,22.0,30.45011165,30.97135837,31.49260508,32.01385179,32.53509851,33.05634522,33.57759193,34.09883865]
[null,null,1252.730123,2248.269877,null,1071.042836,2429.957164,null,889.3555494,2611.644451,null,707.6682627,2793.331737,null,525.980976,2975.019024,null,344.2936893,3156.706311,null,162.6064026,3338.393597,null,-19.08088414,3520.080884,null,null,null,null,null,null,null,23.0,30.72676288,31.27036635,31.81396982,32.35757328,32.90117675,33.44478021,33.98838368,34.53198714]
[null,null,1263.952891,2237.047109,null,1083.17254,2417.82746,null,902.3921878,2598.607812,null,721.611836,2779.388164,null,540.8314842,2960.168516,null,360.0511323,3140.948868,null,179.2707805,3321.729219,null,-1.509571294,3502.509571,null,null,null,null,null,null,null,24.0,31.00203315,31.56788177,32.13373039,32.699579,33.26542762,33.83127624,34.39712486,34.96297348]
[null,null,1275.119639,2225.880361,null,1095.241695,2405.758305,null,915.3637508,2585.636249,null,735.4858067,2765.514193,null,555.6078625,2945.392137,null,375.7299184,3125.270082,null,195.8519743,3305.148026,null,15.9740302,3485.02597,null,null,null,null,null,null,null,25.0,31.27592934,31.86391207,32.45189479,33.03987752,33.62786025,34.21584298,34.80382571,35.39180844]
[null,null,1286.230645,2214.769355,null,1107.250604,2393.749396,null,928.2705631,2572.729437,null,749.2905221,2751.709478,null,570.3104812,2930.689519,null,391.3304402,3109.66956,null,212.3503992,3288.649601,null,33.37035818,3467.629642,null,null,null,null,null,null,null,26.0,31.54845831,32.15846466,32.76847101,33.37847736,33.98848372,34.59849007,35.20849642,35.81850278]
[null,null,1297.286188,2203.713812,null,1119.199568,2381.800432,null,941.1129481,2559.887052,null,763.0263281,2737.973672,null,584.9397082,2916.060292,null,406.8530882,3094.146912,null,228.7664683,3272.233532,null,50.6798483,3450.320152,null,null,null,null,null,null,null,27.0,31.81962688,32.45154692,33.08346696,33.715387,34.34730704,34.97922708,35.61114712,36.24306716]
[null,null,1308.286545,2192.713455,null,1131.088886,2369.911114,null,953.8912273,2547.108773,null,776.6935686,2724.306431,null,599.49591,2901.50409,null,422.2982513,3078.701749,null,245.1005927,3255.899407,null,67.90293401,3433.097066,null,null,null,null,null,null,null,28.0,32.08944186,32.7431662,33.39689054,34.05061488,34.70433922,35.35806356,36.0117879,36.66551224]
[null,null,1319.23199,2181.76801,null,1142.918855,2358.081145,null,966.6057206,2534.394279,null,790.2925858,2710.707414,null,613.979451,2887.020549,null,437.6663162,3063.333684,null,261.3531814,3239.646819,null,85.04004664,3415.959953,null,null,null,null,null,null,null,29.0,32.35790999,33.03332979,33.70874959,34.38416939,35.05958918,35.73500898,36.41042878,37.08584858]
[null,null,1330.122799,2170.877201,null,1154.689773,2346.310227,null,979.2567466,2521.743253,null,803.8237204,2697.17628,null,628.3906941,2872.609306,null,452.9576678,3048.042332,null,277.5246416,3223.475358,null,102.0916153,3398.908385,null,null,null,null,null,null,null,30.0,32.625038,33.32204496,34.01905192,34.71605888,35.41306584,36.11007279,36.80707975,37.50408671]
[null,null,1340.959244,2160.040756,null,1166.401933,2334.598067,null,991.844622,2509.155378,null,817.287311,2683.712689,null,642.7300001,2858.27,null,468.1726891,3032.827311,null,293.6153781,3207.384622,null,119.0580671,3381.941933,null,null,null,null,null,null,null,31.0,32.89083257,33.60931894,34.3278053,35.04629166,35.76477802,36.48326439,37.20175075,37.92023711]
[null,null,1351.741596,2149.258404,null,1178.055629,2322.944371,null,1004.369662,2496.630338,null,830.683695,2670.316305,null,656.997728,2844.002272,null,483.3117609,3017.688239,null,309.6257939,3191.374206,null,135.9398268,3365.060173,null,null,null,null,null,null,null,32.0,33.15530037,33.89515892,34.63501747,35.37487601,36.11473456,36.85459311,37.59445165,38.3343102]
[null,null,1362.470126,2138.529874,null,1189.651153,2311.348847,null,1016.83218,2484.16782,null,844.0132078,2656.986792,null,671.1942352,2829.805765,null,498.3752626,3002.624737,null,325.5562899,3175.44371,null,152.7373173,3348.262683,null,null,null,null,null,null,null,33.0,33.41844802,34.17957207,34.94069611,35.70182016,36.4629442,37.22406825,37.9851923,38.74631634]
[null,null,1373.145101,2127.854899,null,1201.188795,2299.811205,null,1029.232489,2471.767511,null,857.2761832,2643.723817,null,685.3198772,2815.680123,null,513.3635712,2987.636429,null,341.4072651,3159.592735,null,169.4509591,3331.549041,null,null,null,null,null,null,null,34.0,33.6802821,34.4625655,35.24484889,36.02713228,36.80941568,37.59169907,38.37398247,39.15626586]
[null,null,1383.76679,2117.23321,null,1212.668845,2288.331155,null,1041.570899,2459.429101,null,870.4729534,2630.527047,null,699.3750077,2801.624992,null,528.2770621,2972.722938,null,357.1791165,3143.820884,null,186.0811708,3314.918829,null,null,null,null,null,null,null,35.0,33.94080918,34.7441463,35.54748342,36.35082054,37.15415766,37.95749478,38.7608319,39.56416902]
[null,null,1394.335459,2106.664541,null,1224.091589,2276.908411,null,1053.847719,2447.152281,null,883.6038487,2617.396151,null,713.3599788,2787.640021,null,543.1161088,2957.883891,null,372.8722389,3128.127761,null,202.628369,3298.371631,null,null,null,null,null,null,null,36.0,34.20003577,35.02432152,35.84860728,36.67289303,37.49717878,38.32146453,39.14575028,39.97003603]
[null,null,1404.851371,2096.148629,null,1235.457313,2265.542687,null,1066.063256,2434.936744,null,896.6691981,2604.330802,null,727.2751405,2773.724859,null,557.881083,2943.118917,null,388.4870254,3112.512975,null,219.0929679,3281.907032,null,null,null,null,null,null,null,37.0,34.45796838,35.30309819,36.148228,36.99335781,37.83848763,38.68361744,39.52874725,40.37387706]
[null,null,1415.31479,2085.68521,null,1246.766303,2254.233697,null,1078.217816,2422.782184,null,909.6693287,2591.330671,null,741.1208415,2759.879159,null,572.5723543,2928.427646,null,404.023867,3096.976133,null,235.4753798,3265.52462,null,null,null,null,null,null,null,38.0,34.71461345,35.58048328,36.4463531,37.31222293,38.17809275,39.04396258,39.9098324,40.77570223]
[null,null,1425.725979,2075.274021,null,1258.018842,2242.981158,null,1090.311704,2410.688296,null,922.6045661,2578.395434,null,754.8974284,2746.102572,null,587.1902906,2913.809709,null,419.4831529,3081.516847,null,251.7760151,3249.223985,null,null,null,null,null,null,null,39.0,34.96997742,35.85648373,36.74299004,37.62949635,38.51600266,39.40250897,40.28901528,41.17552159]
[null,null,1436.085198,2064.914802,null,1269.21521,2231.78479,null,1102.345222,2398.654778,null,935.4752342,2565.524766,null,768.6052462,2732.394754,null,601.7352581,2899.264742,null,434.86527,3066.13473,null,267.9952819,3233.004718,null,null,null,null,null,null,null,40.0,35.22406668,36.13110646,37.03814624,37.94518602,38.85222581,39.75926559,40.66630537,41.57334515]
[null,null,1446.392707,2054.607293,null,1280.35569,2220.64431,null,1114.318673,2386.681327,null,948.2816554,2552.718345,null,782.2446381,2718.755362,null,616.2076209,2884.792379,null,450.1706037,3050.829396,null,284.1335865,3216.866414,null,null,null,null,null,null,null,41.0,35.47688759,36.40435835,37.3318291,38.25929986,39.18677062,40.11424138,41.04171213,41.96918289]
[null,null,1456.648763,2044.351237,null,1291.440559,2209.559441,null,1126.232355,2374.767645,null,961.0241502,2539.97585,null,795.8159459,2705.184054,null,630.6077416,2870.392258,null,465.3995372,3035.600463,null,300.1913329,3200.808667,null,null,null,null,null,null,null,42.0,35.72844649,36.67624623,37.62404598,38.57184573,39.51964547,40.46744522,41.41524496,42.36304471]
[null,null,1466.853624,2034.146376,null,1302.470095,2198.529905,null,1138.086567,2362.913433,null,973.703038,2527.296962,null,809.3195093,2691.680491,null,644.9359806,2856.064019,null,480.5524519,3020.447548,null,316.1689233,3184.831077,null,null,null,null,null,null,null,43.0,35.97874967,36.94677693,37.91480419,38.88283144,39.8508587,40.81888596,41.78691322,42.75494048]
[null,null,1477.007545,2023.992455,null,1313.444575,2187.555425,null,1149.881606,2351.118394,null,986.318636,2514.681364,null,822.7556664,2678.244334,null,659.1926969,2841.807303,null,495.6297273,3005.370273,null,332.0667577,3168.933242,null,null,null,null,null,null,null,44.0,36.2278034,37.2159572,38.204111,39.1922648,40.1804186,41.1685724,42.1567262,43.14488]
[null,null,1487.11078,2013.88922,null,1324.364273,2176.635727,null,1161.617767,2339.382233,null,998.8712603,2502.12874,null,836.1247539,2664.875246,null,673.3782474,2827.621753,null,510.6317409,2990.368259,null,347.8852344,3153.114766,null,null,null,null,null,null,null,45.0,36.47561393,37.4837938,38.49197368,39.50015355,40.50833343,41.5165133,42.52469318,43.53287305]
[null,null,1497.163582,2003.836418,null,1335.229463,2165.770537,null,1173.295344,2327.704656,null,1011.361225,2489.638775,null,849.4271063,2651.572894,null,687.4929874,2813.507013,null,525.5588684,2975.441132,null,363.6247494,3137.375251,null,null,null,null,null,null,null,46.0,36.72218745,37.75029343,38.77839942,39.8065054,40.83461139,41.86271737,42.89082336,43.91892935]
[null,null,1507.166204,1993.833796,null,1346.040417,2154.959583,null,1184.91463,2316.08537,null,1023.788844,2477.211156,null,862.663057,2638.336943,null,701.5372703,2799.46273,null,540.4114836,2960.588516,null,379.285697,3121.714303,null,null,null,null,null,null,null,47.0,36.96753014,38.01546277,39.0633954,40.11132803,41.15926066,42.20719329,43.25512592,44.30305855]
[null,null,1517.118895,1983.881105,null,1356.797405,2144.202595,null,1196.475916,2304.524084,null,1036.154427,2464.845573,null,875.8329372,2625.167063,null,715.5114479,2785.488552,null,555.1899585,2945.810041,null,394.8684692,3106.131531,null,null,null,null,null,null,null,48.0,37.21164814,38.27930845,39.34696875,40.41462906,41.48228936,42.54994967,43.61760997,44.68527028]
[null,null,1527.021904,1973.978096,null,1367.500698,2133.499302,null,1207.979491,2293.020509,null,1048.458284,2452.541716,null,888.937077,2612.062923,null,729.4158701,2771.58413,null,569.8946632,2931.105337,null,410.3734563,3090.626544,null,null,null,null,null,null,null,49.0,37.45454757,38.54183708,39.62912658,40.71641609,41.80370559,42.8909951,43.9782846,45.06557411]
[null,null,1536.875481,1964.124519,null,1378.150562,2122.849438,null,1219.425643,2281.574357,null,1060.700723,2440.299277,null,901.9758043,2599.024196,null,743.2508851,2757.749115,null,584.5259659,2916.474034,null,425.8010467,3075.198953,null,null,null,null,null,null,null,50.0,37.69623451,38.80305523,39.90987595,41.01669668,42.1235174,43.23033812,44.33715884,45.44397956]
[null,null,1546.679871,1954.320129,null,1388.747265,2112.252735,null,1230.814658,2270.185342,null,1072.882052,2428.117948,null,914.9494457,2586.050554,null,757.0168393,2743.983161,null,599.084233,2901.915767,null,441.1516266,3059.848373,null,null,null,null,null,null,null,51.0,37.93671502,39.06296946,40.1892239,41.31547834,42.44173279,43.56798723,44.69424167,45.82049611]
[null,null,1556.43532,1944.56468,null,1399.291072,2101.708928,null,1242.146823,2258.853177,null,1085.002575,2415.997425,null,927.8583262,2573.141674,null,770.7140776,2730.285922,null,613.569829,2887.430171,null,456.4255804,3044.57442,null,null,null,null,null,null,null,52.0,38.17599511,39.32158626,40.46717742,41.61276857,42.75835973,43.90395089,45.04954204,46.1951332]
[null,null,1566.142073,1934.857927,null,1409.782247,2091.217753,null,1253.422421,2247.577579,null,1097.062595,2403.937405,null,940.7027689,2560.297231,null,784.3429429,2716.657057,null,627.9831168,2873.016883,null,471.6232908,3029.376709,null,null,null,null,null,null,null,53.0,38.41408077,39.57891212,40.74374346,41.90857481,43.07340615,44.2382375,45.40306885,46.56790019]
[null,null,1575.800372,1925.199628,null,1420.221053,2080.778947,null,1264.641734,2236.358266,null,1109.062415,2391.937585,null,953.4830956,2547.516904,null,797.9037764,2703.096224,null,642.3244573,2858.675543,null,486.7451381,3014.254862,null,null,null,null,null,null,null,54.0,38.65097798,39.83495347,41.01892896,42.20290446,43.38687995,44.57085544,45.75483094,46.93880643]
[null,null,1585.41046,1915.58954,null,1430.607751,2070.392249,null,1275.805043,2225.194957,null,1121.002335,2379.997665,null,966.1996262,2534.800374,null,811.3969179,2689.603082,null,656.5942096,2844.40579,null,501.7915013,2999.208499,null,null,null,null,null,null,null,55.0,38.88669266,40.08971673,41.29274081,42.49576489,43.69878897,44.90181305,46.10483713,47.3078612]
[null,null,1594.972576,1906.027424,null,1440.942602,2060.057398,null,1286.912628,2214.087372,null,1132.882654,2368.117346,null,978.8526794,2522.147321,null,824.8227052,2676.177295,null,670.7927311,2830.207269,null,516.7627569,2984.237243,null,null,null,null,null,null,null,56.0,39.12123071,40.34320829,41.56518586,42.78716344,44.00914102,45.2311186,46.45309617,47.67507375]
[null,null,1604.486961,1896.513039,null,1451.225864,2049.774136,null,1297.964766,2203.035234,null,1144.703669,2356.296331,null,991.4425718,2509.557428,null,838.1814745,2662.818525,null,684.9203773,2816.079623,null,531.65928,2969.34072,null,null,null,null,null,null,null,57.0,39.35459801,40.59543447,41.83627094,43.07710741,44.31794387,45.55878034,46.79961681,48.04045327]
[null,null,1613.953852,1887.046148,null,1461.457794,2039.542206,null,1308.961736,2192.038264,null,1156.465677,2344.534323,null,1003.969619,2497.030381,null,851.4735604,2649.52644,null,698.977502,2802.022498,null,546.4814436,2954.518556,null,null,null,null,null,null,null,58.0,39.5868004,40.84640162,42.10600283,43.36560405,44.62520527,45.88480648,47.1444077,48.40400892]
[null,null,1623.373488,1877.626512,null,1471.638649,2029.361351,null,1319.903811,2181.096189,null,1168.168972,2332.831028,null,1016.434134,2484.565866,null,864.6992957,2636.300704,null,712.9644573,2788.035543,null,561.2296189,2939.770381,null,null,null,null,null,null,null,59.0,39.8178437,41.096116,42.3743883,43.65266059,44.93093289,46.20920519,47.48747749,48.76574979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60.0,40.04773369,41.34458387,42.64143405,43.93828423,45.23513441,46.53198459,47.82883476,49.12568494]

{"sheet":"temp","index":21,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"<<<back","Airflow due to temperature difference (CIBSE A4-6)"]
[]
[null,null,null,null,null,null,null,null,null,"Enter"]
[null,null,null,{"$f":"J14","v":40},null,null,null,null,"A1",0.036,"m2","Area of top opening"]
[null,"A1",null,null,null,"A3",null,null,"A3",0.08,"m2","Area of top opening"]
[]
[null,null,null,"ti",null,"to",null,null,"A2",0.036,"m2","Area of bottom opening"]
[null,null,null,{"$f":"AVERAGE(D5,D12)","v":31},null,{"$f":"J16","v":18},null,null,"A4",0.07,"m2","Area of bottom opening"]
[]
[null,"A2",null,null,null,"A4",null,null,"ha",1.5,"m","mean height diff between openings"]
[null,null,null,{"$f":"J15","v":22},null,null,null,null,"Cd",0.61,"f","Discharge co-efficient (typ 0.61)"]
[]
[null,null,null,null,"m3/s",null,null,null,"Th",40.0,"deg C","Temperature at high level"]
[null,null,"Qb displaced air is",null,{"$f":"J12*J20*SQRT((2*J18*J11*9.81)/(J19+273))","v":0.054130106},null,null,null,"Tl",22.0,"deg C","Temperature at low level"]
[null,null,null,null,null,null,null,null,"to",18.0,"deg C","Outside ambient temperature"]
[null,null,"at outlet","m3/s","kW"]
[null,null,"A1",{"$f":"E15*(J5/(J5+J6))","v":0.01679899841},{"$f":"D18*1.2*1.01*(D5-F9)","v":0.4479284937},null,null,null,null,{"$f":"D9-F9","v":13},null,"ti - to"]
[null,null,"A3",{"$f":"E15*(J6/(J6+J5))","v":0.03733110758},{"$f":"D19*1.2*1.01*(D5-F9)","v":0.9953966526},null,null,null,null,{"$f":"AVERAGE(D9,F9)","v":24.5},null,"(ti + to) / 2"]
[null,null,null,null,{"$f":"SUM(E18:E19)","v":1.443325146},null,null,null,null,{"$f":"SQRT(1/(1/POWER(J5+J6,2)+1/POWER(J8+J9,2)))","v":0.07825024759},null,"Ab"]

{"sheet":"Acoustic","index":22,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["<<< Back"]
[null,{"$f":"CHOOSE($J$32,B32,B33,B34,B35,B36,B37,B38,B39,B40,B41,B42)","v":75},65,59,53,50,47,45,43]
[]
[]
[null,null,null,null,"Octave Band Mid-Frequency (Hz)"]
[null,63.0,125.0,250.0,500.0,"1k","2k","4k","8k"]
["Octave Band SPL",{"$f":"B2","v":75},65,59,53,50,47,45,43]
[]
["\"A\" Weighting",-26.0,-16.0,-9.0,-3.0,0.0,1.0,1.0,-1.0,null,null,0.0,3.0]
[null,null,null,null,null,null,null,null,null,null,null,1.0,3.0]
["\"A\" Corrected",{"$f":"B7+B9","v":49},49,50,50,50,48,46,42,null,null,2.0,2.0]
[null,null,null,null,null,null,null,null,null,null,null,3.0,2.0]
["Antilog Lp/10",{"$f":"POWER(10,(B11/10))","v":79432.82347},79432.82347,100000,100000,100000,63095.73445,39810.71706,15848.93192,null,null,4.0,1.0]
[null,null,null,null,null,null,null,null,null,null,null,5.0,1.0]
["Total",null,null,null,null,null,null,"10 log:",{"$f":"B13+C13+D13+E13+F13+G13+H13+I13","v":577621.0304},null,null,6.0,1.0]
[null,null,null,null,null,null,null,null,null,null,null,7.0,1.0]
[null,null,null,null,null,null,null,null,null,null,null,8.0,1.0]
[null,null,null,null,null,null,null,"\"A\" Weighted SPL",{"$f":"10*LOG(I15,10)","v":57.61642997},"dB(A)",null,9.0,1.0]
[null,null,null,null,null,null,null,null,null,null,null,10.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,11.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,12.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,13.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,14.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,15.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,16.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,17.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,18.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,19.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,20.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,21.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,22.0,0.0]
["NR20",51.0,39.0,31.0,24.0,30.0,17.0,14.0,13.0,7.0,null,23.0,0.0]
["NR25",55.0,44.0,35.0,29.0,25.0,22.0,20.0,18.0,null,null,24.0,0.0]
["NR30",59.0,48.0,40.0,34.0,30.0,27.0,25.0,23.0,null,null,25.0,0.0]
["NR35",63.0,52.0,45.0,39.0,35.0,32.0,30.0,28.0,null,null,26.0,0.0]
["NR40",67.0,57.0,49.0,44.0,40.0,37.0,35.0,33.0,null,null,27.0,0.0]
["NR45",71.0,61.0,54.0,48.0,45.0,42.0,40.0,38.0,null,null,28.0,0.0]
["NR50",75.0,65.0,59.0,53.0,50.0,47.0,45.0,43.0,null,null,29.0,0.0]
["NR55",79.0,70.0,63.0,58.0,55.0,52.0,50.0,49.0,null,null,30.0,0.0]
["NR60",83.0,74.0,68.0,63.0,60.0,57.0,55.0,54.0,null,null,31.0,0.0]
["NR65",87.0,78.0,72.0,68.0,65.0,62.0,61.0,59.0,null,null,32.0,0.0]
["NR70",91.0,83.0,77.0,73.0,70.0,68.0,68.0,64.0,null,null,33.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,34.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,35.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,36.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,37.0,0.0]
[null,null,null,null,null,null,null,null,null,{"$f":"POWER(10,(J7/10))","v":1},null,38.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,39.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,40.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,41.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,42.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,43.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,44.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,45.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,46.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,47.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,48.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,49.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,50.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,51.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,52.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,53.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,54.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,55.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,56.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,57.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,58.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,59.0,0.0]
[null,null,null,null,null,null,null,null,null,null,null,60.0,0.0]