{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Calcs","Materials","Gases","Lookups"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":53,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,3],[5,5,5,6],[9,5,9,6],[1,0,1,3],[5,0,5,3],[10,0,10,3]]}
[]
["Window Dimensions",null,null,null,null,null,null,null,"*Solve on Calcs sheet"]
["Height",1,"m "]
["Width",0.75,"m "]
[]
["Conditions",null,null,null,null,"U Factor"]
["Inside Temperature",70,"F",null,null,{"$f":"Calcs!B7","v":0.17901743849918517},"W/m2"]
["Outside Temperature",0,"F",null,null,{"$f":"F7/5.678","v":3.1528256163998798E-2},"Btu/hr*ft2"]
["Wind Speed",40,"mph"]
[null,null,null,null,null,"Heat Loss"]
["Gas Between Panes",null,null,null,null,{"$f":"F7*B3*B4","v":0.13426307887438887},"W"]
["Gas  ","Argon",null,null,null,null,"Btu/hr"]
["Spacing",10,"mm"]
[]
["Glass"]
[null,"Inner Pane","Outer Pane"]
["Material","Window Glass","Window Glass"]
["Thickness",2,2,"mm"]

{"sheet":"Calcs","index":1,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,8,16,9],[10,0,10,2],[10,4,10,6],[16,0,16,1],[16,4,16,5]]}
[]
["Ti",{"$f":"IF(Cover!C7=\"C\",Cover!B7+273, (5/9 * (Cover!B7 - 32) + 273 ))","v":294.11111111111109},"K",null,"Interior","To",{"$f":"B2","v":294.11111111111109},null,{"$f":"I6*-0.5","v":-7},null,null,null,null,"Error",{"$f":"SUMSQ(B8-B15,B8-F15,B8-B34,B8-F34,B8-J34)","v":2.3649651071610337E-8}]
["To",{"$f":"IF(Cover!C8=\"C\",Cover!B8+273, (5/9 * (Cover!B8 - 32) + 273 ))","v":255.22222222222223},"K",null,"Inner Glass (inside)","T1",{"$f":"$G$2+H3*($G$7-$G$2)","v":289.32822594756726},0.12298847563398395,0]
["V",{"$f":"Cover!B9*VLOOKUP(Cover!C9,speedlook,2,FALSE)","v":17.88},"m/s",null,"Inner Glass (outside)","T2",{"$f":"$G$2+H4*($G$7-$G$2)","v":274.82468684446854},0.49593662399938027,{"$f":"I3+Cover!B18","v":2}]
["H",{"$f":"Cover!B3*VLOOKUP(Cover!C3,lengthlook,2,FALSE)","v":1},"m ",null,"Outer Glass (inside)","T3",270.56450275143055,0.60548421496321403,{"$f":"I4+Cover!B13","v":12}]
["W",{"$f":"Cover!B4*VLOOKUP(Cover!C4,lengthlook,2,FALSE)","v":0.75},"m",null,"Outer Glass (outside)","T4",256.06065277738833,0.97844035715287092,{"$f":"I5+Cover!C18","v":14}]
["U",{"$f":"1/SUM(B14,F14,B33,F33,J33)","v":0.17901743849918517},"W/m2",null,"Exterior ","T5",{"$f":"B3","v":255.22222222222223},null,{"$f":"I6*1.5","v":21}]
["q\"",{"$f":"B7*(G2-G7)","v":6.9617892749683064}]
[]
[]
["Inner Pane",null,null,null,"Outer Pane"]
["t",{"$f":"Cover!B18*VLOOKUP(Cover!D18,lengthlook,2,FALSE)","v":2E-3},"m",null,"t",{"$f":"Cover!C18*VLOOKUP(Cover!D18,lengthlook,2,FALSE)","v":2E-3},"m"]
["k",{"$f":"VLOOKUP(Cover!B17,MaterialProps,2,FALSE)","v":0.96},"W/m*K",null,"k",{"$f":"VLOOKUP(Cover!C17,MaterialProps,2,FALSE)","v":0.96},"W/m*K"]
["R",{"$f":"Cover!B18/B13","v":2.0833333333333335},null,null,"R",{"$f":"Cover!C18/F13","v":2.0833333333333335}]
["q\"",{"$f":"(G3-G4)/B14","v":6.9616987694873833},null,null,"q\"",{"$f":"(G5-G6)/F14","v":6.9618479875402679}]
[]
["Interior of Building",null,null,null,"Between Panes",null,null,null,"Exterior of Building"]
["Tf",{"$f":"AVERAGE(G2:G3)","v":291.71966852933917},null,null,"Tf",{"$f":"AVERAGE(G4:G5)","v":272.69459479794955},null,null,"Tf",{"$f":"AVERAGE(G6:G7)","v":255.64143749980528}]
["ρ",{"$f":"Gases!B5","v":1.2000360266421035},null,null,"ρ",{"$f":"Gases!C5","v":1.8007220202965608},null,null,"ρ",{"$f":"Gases!D5","v":1.3683770526259087}]
["cp",{"$f":"Gases!B6","v":1006.8343933705868},null,null,"cp",{"$f":"Gases!C6","v":521.94504215907114},null,null,"cp",{"$f":"Gases!D6","v":1006.1128287499961}]
["μ",{"$f":"Gases!B7","v":1.8045983426466957E-5},null,null,"μ",{"$f":"Gases!C7","v":2.0969893580675829E-5},null,null,"μ",{"$f":"Gases!D7","v":1.6242071874990265E-5}]
["ν",{"$f":"Gases!B8","v":1.5153050499111185E-5},null,null,"ν",{"$f":"Gases!C8","v":1.1824752016252127E-5},null,null,"ν",{"$f":"Gases!D8","v":1.1942087937482671E-5}]
["k",{"$f":"Gases!B9","v":2.5637573482347135E-2},null,null,"k",{"$f":"Gases!C9","v":1.634160157796714E-2},null,null,"k",{"$f":"Gases!D9","v":2.2751314999984423E-2}]
["α",{"$f":"Gases!B10","v":2.1406996245872773E-5},null,null,"α",{"$f":"Gases!C10","v":1.764331543003169E-5},null,null,"α",{"$f":"Gases!D10","v":1.6644669749974297E-5}]
["β",{"$f":"Gases!B11","v":3.4437377529421445E-3},null,null,"β",{"$f":"Gases!C11","v":3.6953533864809078E-3},null,null,"β",{"$f":"Gases!D11","v":3.9247808333359299E-3}]
["Pr",{"$f":"Gases!B12","v":0.70915288618237182},null,null,"Pr",{"$f":"Gases!C12","v":0.66984364161027443},null,null,"Pr",{"$f":"Gases!D12","v":0.71853322625005056}]
[]
["Ra",{"$f":"9.81*B25*(G2-G3)*(B29)^3/(B24*B22)","v":498119139.5885793},null,null,"Ra",{"$f":"9.81*F25*(G4-G5)*(F29)^3/(F24*F22)","v":740.25459156214583}]
["L",{"$f":"B5","v":1},null,null,"L",{"$f":"Cover!B13*VLOOKUP(Cover!C13,lengthlook,2,FALSE)","v":0.01},null,null,"D",4,"m "]
[null,null,null,null,"H/L",{"$f":"B5/F29","v":100},null,null,"Re",{"$f":"J19*B4*J29/J21","v":6025482.9283510754},{"$f":"J30/500000","v":12.050965856702151}]
["Nu",{"$f":"IF((0.825*0.387*B28^(1/6)/(1+(0.492/B26)^(9/16))^(8/27))^2<1,1,(0.825*0.387*B28^(1/6)/(1+(0.492/B26)^(9/16))^(8/27))^2)","v":56.774999280414072},null,null,"Nu",{"$f":"IF(0.22*(F26/(0.2+F26)*F28)^0.28*(F30)^-0.25<1,1,0.22*(F26/(0.2+F26)*F28)^0.28*(F30)^-0.25)","v":1},null,null,"Nu",{"$f":"0.664*J30^0.5*J26^(1/3)","v":1459.8658901083766}]
["h",{"$f":"B31*B23/B29","v":1.4555732160118215},null,null,"h",{"$f":"F31*F23/F29","v":1.634160157796714},null,null,"h",{"$f":"J23*J31/J29","v":8.3034671808970799}]
["R",{"$f":"1/B32","v":0.68701456512090586},null,null,"R",{"$f":"1/F32","v":0.61193512473604061},null,null,"R",{"$f":"1/J32","v":0.1204316194927097}]
["q\"",{"$f":"(G2-G3)/B33","v":6.9618395393147114},null,null,null,{"$f":"(G4-G5)/F33","v":6.9618231097220162},null,null,null,{"$f":"(G6-G7)/J33","v":6.9618805982830185}]

{"sheet":"Materials","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Material","Thermal Conductivity (W/m*K)"]
["Glass Plate (Lime Soda)",1.4]
["Pyrex",1.4]
["Window Glass",0.96,"http://www.engineeringtoolbox.com/thermal-conductivity-d_429.html"]

{"sheet":"Gases","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Data"]
[null,null,{"$f":"Cover!B12","v":"Argon"}]
[null,"T1","T2","T3"]
["T",{"$f":"Calcs!B18","v":291.71966852933917},null,{"$f":"Calcs!J18","v":255.64143749980528}]
["ρ",{"$f":"LinearInterp($F$14:$J$14,$F15:$J15,B$4)","v":1.2000360266421035},{"$f":"IF($C$2=\"Argon\",C24,C15)","v":1.8007220202965608},{"$f":"LinearInterp($F$14:$J$14,$F15:$J15,D$4)","v":1.3683770526259087}]
["cp",1006.8343933705868,{"$f":"IF($C$2=\"Argon\",C25,C16)","v":521.94504215907114},1006.1128287499961]
["μ",1.8045983426466957E-5,2.0969893580675829E-5,1.6242071874990265E-5]
["ν",1.5153050499111185E-5,1.1824752016252127E-5,1.1942087937482671E-5]
["k",2.5637573482347135E-2,1.634160157796714E-2,2.2751314999984423E-2]
["α",2.1406996245872773E-5,1.764331543003169E-5,1.6644669749974297E-5]
["β",3.4437377529421445E-3,3.6953533864809078E-3,3.9247808333359299E-3]
["Pr",0.70915288618237182,0.66984364161027443,0.71853322625005056]
[null,null,null,null,"Air","Heat Transfer"]
[null,null,{"$f":"Calcs!F18","v":272.69459479794955},null,"T",200,250,300,350,400]
[null,null,{"$f":"LinearInterp($F$14:$J$14,$F15:$J15,C$14)","v":1.2888070206727675},null,"ρ",1.7458,1.3947000000000001,1.1614,0.995,0.87109999999999999]
[null,null,1006.453891895959,null,"cp",1007,1006,1007,1009,1014]
[null,null,1.7094729739897476E-5,null,"μ",1.325E-5,1.596E-5,1.8459999999999999E-5,2.0820000000000001E-5,2.3010000000000002E-5]
[null,null,1.345981893701751E-5,null,"ν",7.5900000000000002E-6,1.1440000000000001E-5,1.5889999999999999E-5,2.092E-5,2.641E-5]
[null,null,2.4115567583835963E-2,null,"k",1.8100000000000002E-2,2.23E-2,2.63E-2,0.03,3.3799999999999997E-2]
[null,null,1.889568651332934E-5,null,"α",1.03E-5,1.59E-5,2.2500000000000001E-5,2.9899999999999998E-5,3.8300000000000003E-5]
[null,null,3.6974054026940061E-3,null,"β",{"$f":"1/F14","v":5.0000000000000001E-3},{"$f":"1/G14","v":4.0000000000000001E-3},3.3333333333333335E-3,2.8571428571428571E-3,2.5000000000000001E-3]
[null,null,0.71409940535253313,null,"Pr",0.73699999999999999,0.72,0.70699999999999996,0.7,0.69]
[null,null,null,null,"Argon","http://www.mhtl.uwaterloo.ca/old/onlinetools/airprop/airprop.html"]
[null,null,{"$f":"LinearInterp($F$14:$J$14,$F24:$J24,C$14)","v":1.8007220202965608},null,"ρ",2.4379,1.9486000000000001,1.6228,1.3903000000000001,1.2177]
[null,null,521.94504215907114,null,"cp",523.41999999999996,522.29,521.53,521.14,521.12]
[null,null,2.0969893580675829E-5,null,"μ",1.6010000000000001E-5,1.9507000000000001E-5,2.2730000000000001E-5,2.5721999999999999E-5,2.849E-5]
[null,null,1.1824752016252127E-5,null,"ν",6.5671000000000002E-6,1.0011E-5,1.4007E-5,1.8499999999999999E-5,2.3397E-5]
[null,null,1.634160157796714E-2,null,"k",1.2416E-2,1.5181E-2,1.7738E-2,2.0115999999999998E-2,2.232E-2]
[null,null,1.764331543003169E-5,null,"α",9.7566999999999993E-6,1.4895000000000001E-5,2.0950000000000001E-5,2.7778000000000001E-5,3.5160000000000002E-5]
[null,null,3.6953533864809078E-3,null,"β",4.9963000000000004E-3,3.9975999999999996E-3,3.3316999999999999E-3,2.8559000000000002E-3,2.5022E-3]
[null,null,0.66984364161027443,null,"Pr",0.67491999999999996,0.67110999999999998,0.66832000000000003,0.66637000000000002,0.66517999999999999]

{"sheet":"Lookups","index":4,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4]]}
["Temperature",null,null,"Speed",null,"Length"]
["C",null,null,"m/s",1,"in",2.5399999999999999E-2]
["F",null,null,"mph",0.44700000000000001,"m ",1]
[null,null,null,null,null,"mm",1E-3]
["Air"]
["Argon"]