{"text_format":"1","workbook":"xlsx","n_sheets":33,"sheets":["Main","Inst","Q_A","Atrium-Fire-IP","A-Fire-IP","Atrium-Fire-SI","A-Fire-SI","Balcony-IP","Bal-IPW","Balcony-SI","Bal-SIW","Win-IP","Win-IP2","Win-SI","Win-SI2","Plug-IP","Plug-IP-A","Plug1","Plug-IP-B","Plug2","Plug-SI","Plug-SI-A","Plug3","Plug-SI-B","Plug4","Airflow-IP","Air_IP_A","Air_IP_B","Air_IP_C","Airflow-SI","Air_SI_A","Air_SI_B","Air_SI_C"],"not_rendered":{"charts":0,"images":39,"macros":1,"external_links":0,"defined_names":1,"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":"Main","index":0,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,9,49,15],[28,1,55,7],[11,3,11,10]]}
[]
[]
[null,null,null,"AtriumCalc",null,null,null,"Version 1.1"]
[null,null,null,"Atrium Smoke Control Calculator"]
[]
[null,"AtriumCalc consists of a number of routines that are commonly used for analysis of atrium "]
[null,"smoke control systems. For AtriumCalc, the term atrium is used in a generic sense to mean  "]
[null,"any large-volume space. "]
[]
[]
[]
[null,"Enter Project Title:",null,"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"]
[]
[null,"I-P Units",null,null,null,null,"SI Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AtriumCalc Version 1.1        © 2014 John H. Klote"]
[]
[null,"Disclaimer",null,null,null,null,null,null,null,"License Agreement"]
[null,"ASHRAE and John H. Klote have no liability for the use of the AtriumCalc application or the documentation, “AtriumCalc: Atrium Smoke Control Calculator – Technical Information and User Guide.” The appropriateness, correctness, and accuracy of any and all analyses and designs for which the AtriumCalc application is used are the responsibility of the users of the AtriumCalc application. ASHRAE and John H. Klote are not liable to any user of the AtriumCalc application, including the documentation, for any indirect, special, incidental, punitive, cover, or consequential damages (including but not limited to damages for the inability to use equipment or access data, loss of business, loss of profits, business interruption or the like) arising out of the use of or the inability to use the AtriumCalc application and based on any theory of liability including breach of contract, breach of warranty, tort (including negligence), product liability, or otherwise, even if ASHRAE and/or John H. Klote have been advised of the possibility of such damages and even if a remedy set forth herein is found to have failed of its essential purpose. John H. Klote and ASHRAE reserve the right to discontinue support for this product at any time in the future, including without limitation discontinuing support of servers facilitating access to this product. In the event of discontinuation of support, ASHRAE will make a reasonable effort to notify purchasers before support is discontinued.",null,null,null,null,null,null,null,"Using this product indicates your acceptance of the terms and conditions of this agreement. The title and all copyrights and ownership rights are retained by John H. Klote. You assume responsibility for the selection of this product to achieve your intended results and for the installation, use, and results obtained. This product is for personal use only. “Personal use” includes showing the information in a group setting and using pages printed from AtriumCalc in engineering reports; it does not include making copies, in whole or in part, of the information for the purposes of distribution, reusing the information in your own presentation, posting the files on a server for access by others, or using the product on a LAN or WAN. You may use the product on a single machine. You shall not merge, adapt, translate, modify, rent, lease, sell, sublicense, assign, or otherwise transfer any content. Doing so will result in the termination of your license, and the copyright holder will consider options to recover damages from unauthorized use of its intellectual property. Distribution to third parties in print or in electronic form is expressly prohibited unless authorized in writing by the copyright holder. For information on obtaining permissions and licensing, visit www.ashrae.org/permissions."]

{"sheet":"Inst","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]

{"sheet":"Q_A","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]

{"sheet":"Atrium-Fire-IP","index":3,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 1: Atrium Smoke Exhaust with an Axisymmetric Plume"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",3500,"Btu/s",null,"Output:","Qc =",{"$f":"D24*D19","v":2450},"Btu/s"]
[null,null,"z =",40,"ft",null,null,"zl =",{"$f":"0.533*(I19^0.4)","v":12.08909089002978},"ft"]
[null,null,"To =",92,"oF",null,null,"m =",{"$f":"IF(D20>I20,'A-Fire-IP'!C11,'A-Fire-IP'!C12)","v":149.04373887065228},"lb/s"]
[null,null,"patm =",14.7,"psi",null,null,"Ts =",{"$f":"D21+D23*I19/(I21*0.24)","v":160.49219840219283},"oF"]
[null,null,"Ks =",1,"(See note 2 above)",null,null,null,{"$f":"144*D22/(53.34*(I22+460))","v":6.3957354294333191E-2},"lb/ft3"]
[null,null,null,0.7,"(Almost always 0.70)",null,null,"V =",{"$f":"60*I21/I23","v":139821.67384668504},"cfm"]
[null,null,{"$f":"IF(D23=1,\" \",\"CAUTION: See note 2 above. \")","v":" "}]
[null,null,{"$f":"IF(D24=0.7,\" \",\"CAUTION: See note 3 above. \")","v":" "}]

{"sheet":"A-Fire-IP","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Q =",{"$f":"'Atrium-Fire-IP'!D19","v":3500},"Btu/s"]
["z =",{"$f":"'Atrium-Fire-IP'!D20","v":40},"ft"]
["To =",{"$f":"'Atrium-Fire-IP'!D21","v":92},"oF"]
["patm =",{"$f":"'Atrium-Fire-IP'!D22","v":14.7},"psi"]
[null,{"$f":"'Atrium-Fire-IP'!D24","v":0.7},"(0.70 is almost always used)"]
[]
["Qc =",{"$f":"'Atrium-Fire-IP'!I19","v":2450},"Btu/s"]
["zl =",{"$f":"'Atrium-Fire-IP'!I20","v":12.08909089002978},"ft"]
[]
[]
["For z > zl,   m=",null,{"$f":"0.022*(B7^(1/3))*(B2^(5/3))+0.0042*B7","v":149.04373887065228},"lb/s"]
["For z < zl,   m=",null,{"$f":"0.0208*(B7^0.6)*B2","v":89.871704157344084},"lb/s"]

{"sheet":"Atrium-Fire-SI","index":5,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 1: Atrium Smoke Exhaust with an Axisymmetric Plume"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",4000,"kW",null,"Output:","Qc =",{"$f":"D20*D15","v":2800},"kW"]
[null,null,"z =",12,"m",null,null,"zl =",{"$f":"0.166*(I15^0.4)","v":3.9716530278164801},"m"]
[null,null,"To =",30,"oC",null,null,"m =",{"$f":"IF(D16>I16, 'A-Fire-SI'!C11,'A-Fire-SI'!C12)","v":67.982854695262191},"kg/s"]
[null,null,"patm =",101300,"Pa",null,null,"Ts =",{"$f":"D17+D19*I15/I17","v":71.186855311551597},"oC"]
[null,null,"Ks =",1,"(See note 2 above)",null,null,null,{"$f":"D18/(287*(I18+273))","v":1.0254943413058968},"kg/m3"]
[null,null,null,0.7,"(Almost always 0.70)",null,null,"V =",{"$f":"I17/I19","v":66.292764335189489},"m3/s"]
[null,null,{"$f":"IF(D19=1,\" \",\"CAUTION: See note 2 above. \")","v":" "}]
[null,null,{"$f":"IF(D20=0.7,\" \",\"CAUTION: See note 3 above. \")","v":" "}]

{"sheet":"A-Fire-SI","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Q =",{"$f":"'Atrium-Fire-SI'!D15","v":4000},"kW"]
["z =",{"$f":"'Atrium-Fire-SI'!D16","v":12},"m"]
["To =",{"$f":"'Atrium-Fire-SI'!D17","v":30},"oC"]
["patm =",{"$f":"'Atrium-Fire-SI'!D18","v":101300},"Pa"]
[null,{"$f":"'Atrium-Fire-SI'!D20","v":0.7},"(0.70 is almost always used)"]
[]
[]
["Qc =",{"$f":"'Atrium-Fire-SI'!I15","v":2800},"kW"]
["zl =",{"$f":"'Atrium-Fire-SI'!I16","v":3.9716530278164801},"m"]
[]
["For z > zl,   m=",null,{"$f":"0.071*(B8^(1/3))*(B2^(5/3))+0.0018*B8","v":67.982854695262191},"kg/s"]
["For z < zl,   m=",null,{"$f":"0.032*(B8^0.6)*B2","v":44.93927308099363},"kg/s"]

{"sheet":"Balcony-IP","index":7,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 2: Atrium Smoke Exhaust with a Balcony Spill Plume"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",1000,"Btu/s",null,"Output:","Qc =",{"$f":"D29*D22","v":700},"Btu/s"]
[null,null,"H =",10,"ft",null,null,"m =",{"$f":"'Bal-IPW'!C22","v":269.14988616649526},"lb/s"]
[null,null,"W =",19,"ft (See note 2 above)",null,null,"Ts =",{"$f":"D26+D28*I22/(I23*0.24)","v":93.836588891820767},"oF"]
[null,null,"zb =",29,"ft",null,null,null,{"$f":"144*D27/(53.34*(I24+460))","v":7.1654780789194655E-2},"lb/ft3"]
[null,null,"To =",83,"oF",null,null,"V =",{"$f":"60*I23/I25","v":225372.16626898033},"cfm"]
[null,null,"patm =",14.7,"psi"]
[null,null,"Ks =",1,"(See note 3 above)"]
[null,null,null,0.7,"(Almost always 0.70)"]
[null,null,{"$f":"'Bal-IPW'!C21","v":"Note: Flow is in region 1."}]
[null,null,{"$f":"IF(D28=1,\" \",\"CAUTION: See note 3 above. \")","v":" "},null,null,null,{"$f":"IF(D29=0.7,\" \",\"CAUTION: See note 4 above. \")","v":" "}]

{"sheet":"Bal-IPW","index":8,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"Work Space for Plugholing IP"]
[null,"Q =",{"$f":"'Balcony-IP'!D22","v":1000},"Btu/s"]
[null,"H =",{"$f":"'Balcony-IP'!D23","v":10},"ft"]
[null,"W =",{"$f":"'Balcony-IP'!D24","v":19},"ft"]
[null,"zb =",{"$f":"'Balcony-IP'!D25","v":29},"ft"]
[null,"To =",{"$f":"'Balcony-IP'!D26","v":83},"oF"]
[null,"patm =",{"$f":"'Balcony-IP'!D27","v":14.7},"psi"]
[null,null,{"$f":"'Balcony-IP'!D29","v":0.7}]
[]
[null,"Qc =",{"$f":"C8*C2","v":700},"kW"]
[null,"m1 =",{"$f":"0.12*((C2*(C4^2))^(1/3))*(C5+0.25*C3)","v":269.14988616649526}]
[null,"m2 =",{"$f":"0.32*(C10^(1/3))*(C4^0.2)*(C5+0.098*(C4^(7/15))*C3+19.5*(C4^(7/15))-49.2)","v":310.90864805472478}]
[null,"m3 =",{"$f":"0.062*((C10*(C4^2))^(1/3))*(C5+0.51*C3+52)","v":337.49182302850835}]
[]
[null,"Regions"]
[null,1,"zb < 50 ft"]
[null,2,"zb $ 50 ft and W < 32.8 ft"]
[null,3,"zb $ 50 ft and 32.8 ft $ W $ 45.9 ft"]
[null,"zb =",{"$f":"C5","v":29}]
[null,"W =",{"$f":"C4","v":19}]
[null,"Region ",{"$f":"IF(C19 < 50, \"Note: Flow is in region 1.\", IF(C20 < 32.8, \"Note: Flow is in region 2.\", IF(C20>44.9, \"CAUTION: Flow is beyond region 3, but it is calculated with the region 3 equation.\", \"Note: Flow is in region 3.\")))","v":"Note: Flow is in region 1."}]
[null,"m =",{"$f":"IF(C19 < 50, C11, IF(C20 < 32.8, C12, C13))","v":269.14988616649526}]

{"sheet":"Balcony-SI","index":9,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 2: Atrium Smoke Exhaust with a Balcony Spill Plume"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",1000,"kW",null,"Output:","Qc =",{"$f":"D30*D23","v":700},"kW"]
[null,null,"H =",3.1,"m",null,null,"m =",{"$f":"'Bal-SIW'!C22","v":116.19481988860191},"kg/s"]
[null,null,"W =",6,"m (See note 2 above)",null,null,"Ts =",{"$f":"D27+D29*I23/I24","v":34.024364947345354},"oC"]
[null,null,"zb =",9,"m",null,null,null,{"$f":"D28/(287*(I25+273))","v":1.1496210489170802},"kg/m3"]
[null,null,"To =",28,"oC",null,null,"V =",{"$f":"I24/I26","v":101.07227942464614},"m3/s"]
[null,null,"patm =",101300,"Pa"]
[null,null,"Ks =",1,"(See note 3 above)"]
[null,null,null,0.7,"(Almost always 0.70)"]
[null,null,{"$f":"'Bal-SIW'!C21","v":"Note: Flow is in region 1."}]
[null,null,{"$f":"IF(D29=1,\" \",\"CAUTION: See note 3 above. \")","v":" "},null,null,null,{"$f":"IF(D30=0.7,\" \",\"CAUTION: See note 4 above. \")","v":" "}]

{"sheet":"Bal-SIW","index":10,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"Work Space for Plugholing SI"]
[null,null,{"$f":"E2/1.055","v":947.8672985781991},"Btu/s",{"$f":"'Balcony-SI'!D23","v":1000},"kW"]
[null,null,{"$f":"E3/0.3048","v":10.170603674540683},"ft",{"$f":"'Balcony-SI'!D24","v":3.1},"m"]
[null,null,{"$f":"E4/0.3048","v":19.685039370078741},"ft",{"$f":"'Balcony-SI'!D25","v":6},"m"]
[null,null,{"$f":"E5/0.3048","v":29.527559055118108},"ft",{"$f":"'Balcony-SI'!D26","v":9},"m"]
[null,null,{"$f":"E6*1.8+32","v":82.4},"oF",{"$f":"'Balcony-SI'!D27","v":28},"oC"]
[null,null,{"$f":"E7/6894.8","v":14.692231826884028},"psi",{"$f":"'Balcony-SI'!D28","v":101300},"Pa"]
[null,null,{"$f":"E8","v":0.7},null,{"$f":"'Balcony-SI'!D30","v":0.7}]
[]
[null,null,null,"Qc =",{"$f":"E2*E8","v":700},"kW"]
[null,null,null,"m1 =",{"$f":"0.36*((E2*(E4^2))^(1/3))*(E5+0.25*E3)","v":116.19481988860191},"kg/s"]
[null,null,null,"m2 =",{"$f":"0.59*(E10^(1/3))*(E4^0.2)*(E5+0.17*(E4^(7/15))*E3+10.35*(E4^(7/15))-15)","v":143.16791816212091},"kg/s"]
[null,null,null,"m3 =",{"$f":"0.2*((E10*(E4^2))^(1/3))*(E5+0.51*E3+15.75)","v":154.39415762789147},"kg/s"]
[]
[null,"Regions"]
[null,1,"zb < 15 m"]
[null,2,"zb $ 15 m and W < 10 m"]
[null,3,"zb $ 15 m and 10 m $ W $ 14 m"]
[null,"zb =",{"$f":"E5","v":9}]
[null,"W =",{"$f":"E4","v":6}]
[null,"Region ",{"$f":"IF(C19 < 15, \"Note: Flow is in region 1.\", IF(C20 < 10, \"Note: Flow is in region 2.\", IF(C20>14, \"CAUTION: Flow is beyond region 3, but it is calculated with the region 3 equation.\", \"Note: Flow is in region 3.\")))","v":"Note: Flow is in region 1."}]
[null,"m =",{"$f":"IF(C19 < 15, E11, IF(C20 < 10, E12, E13))","v":116.19481988860191},"kg/s"]

{"sheet":"Win-IP","index":11,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 3: Steady Atrium Smoke Exhaust with a Window Plume "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Hw =",9,"ft",null,"Output:","Q =",{"$f":"61.2*D21*D22*(D21^0.5)","v":11566.800000000001},"Btu/s"]
[null,null,"Ww =",7,"ft",null,null,"Qc =",{"$f":"D27*I21","v":8096.76},"Btu/s"]
[null,null,"zw =",40,"ft",null,null,"m =",{"$f":"'Win-IP2'!B19","v":246.24560655387188},"lb/s"]
[null,null,"To =",80,"oF",null,null,"Ts =",{"$f":"D24+D26*I22/(I23*0.24)","v":217.00345956271659},"oF"]
[null,null,"patm =",14.7,"psi",null,null,null,{"$f":"144*D25/(53.34*(I24+460))","v":5.8618665546719219E-2},"lb/ft3"]
[null,null,"Ks =",1,"(See note 3 above)",null,null,"V =",{"$f":"60*I23/I25","v":252048.32377933976},"cfm"]
[null,null,null,0.7,"(Almost always 0.70)"]
[]
[null,null,{"$f":"IF(D26=1,\" \",\"CAUTION: See note 3 above. \")","v":" "},null,null,null,{"$f":"IF(D27=0.7,\" \",\"CAUTION: See note 4 above. \")","v":" "}]

{"sheet":"Win-IP2","index":12,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
["INPUT"]
["Hw =",{"$f":"'Win-IP'!D21","v":9},"ft"]
["Ww =",{"$f":"'Win-IP'!D22","v":7},"ft"]
["zw =",{"$f":"'Win-IP'!D23","v":40},"ft"]
["To =",{"$f":"'Win-IP'!D24","v":80},"ft"]
["Patm =",{"$f":"'Win-IP'!D25","v":14.7},"psi"]
["Xc =",{"$f":"'Win-IP'!D27","v":0.7}]
[]
["Aw =",{"$f":"B4*B5","v":63},"m2"]
[]
["a = (2.4*(Aw^.4)*(Hw^.2)) - 2.1*Hw",null,null,null,{"$f":"(2.4*(B11^0.4)*(B4^0.2))-2.1*B4","v":0.63421499927235914}]
["A = (Aw*(Hw^0.5))^(1/3)",null,null,null,{"$f":"(B11*(B4^0.5))^(1/3)","v":5.738793548317167}]
["B = (zw + a)^(5/3)",null,null,null,{"$f":"(B6+E13)^(5/3)","v":480.27110320078668}]
["C = Aw*(Hw^.5)",null,null,null,{"$f":"B11*(B4^0.5)","v":189}]
[]
["m = (0.077*A*B)+0.18*C"]
["m =  ",{"$f":"(0.077*E14*E15)+0.18*E16","v":246.24560655387188}]

{"sheet":"Win-SI","index":13,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 3: Steady Atrium Smoke Exhaust with a Window Plume "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Hw =",2.8,"m",null,null,"Output:","Q =",{"$f":"1260*D18*D19*(D18^0.5)","v":12987.640923893763},"kW"]
[null,null,"Ww =",2.2000000000000002,"m",null,null,null,"Qc =",{"$f":"D24*J18","v":9091.3486467256334},"kW"]
[null,null,"zw =",12,"m",null,null,null,"m =",{"$f":"'Win-SI2'!B19","v":112.35906954680708},"kg/s"]
[null,null,"To =",26.666699999999999,"oC",null,null,null,"Ts =",{"$f":"D21+D23*J19/J20","v":107.58004934861057},"oC"]
[null,null,"patm =",101300,"Pa",null,null,null,null,{"$f":"D22/(287*(J21+273))","v":0.92743083374440205},"kg/m3"]
[null,null,"Ks =",1,"(See note 3 above)",null,null,null,"V =",{"$f":"J20/J22","v":121.15088851765844},"m3/s"]
[null,null,null,0.7,"(Almost always 0.70)"]
[]
[null,null,{"$f":"IF(D23=1,\" \",\"CAUTION: See note 3 above. \")","v":" "},null,null,null,null,{"$f":"IF(D24=0.7,\" \",\"CAUTION: See note 4 above. \")","v":" "}]

{"sheet":"Win-SI2","index":14,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
["INPUT"]
["Hw =",{"$f":"'Win-SI'!D18","v":2.8},"m"]
["Ww =",{"$f":"'Win-SI'!D19","v":2.2000000000000002},"m"]
["zw =",{"$f":"'Win-SI'!D20","v":12},"m"]
["To =",{"$f":"'Win-SI'!D21","v":26.666699999999999},"C"]
["Patm =",{"$f":"'Win-SI'!D22","v":101300},"Pa"]
["Xc =",{"$f":"'Win-SI'!D24","v":0.7}]
[]
["Aw =",{"$f":"B4*B5","v":6.16},"m2"]
[]
["a = (2.4*(Aw^.4)*(Hw^.2)) - 2.1*Hw",null,null,null,{"$f":"(2.4*(B11^0.4)*(B4^0.2))-2.1*B4","v":0.2220411612641886}]
["A = (Aw*(Hw^0.5))^(1/3)",null,null,null,{"$f":"(B11*(B4^0.5))^(1/3)","v":2.1763057488653463}]
["B = (zw + a)^(5/3)",null,null,null,{"$f":"(B6+E13)^(5/3)","v":64.849440974939711}]
["C = Aw*(Hw^.5)",null,null,null,{"$f":"B11*(B4^0.5)","v":10.307651526899811}]
[]
["m = (0.68*A*B)+1.59*C"]
["m =  ",{"$f":"(0.68*E14*E15)+1.59*E16","v":112.35906954680708}]

{"sheet":"Plug-IP","index":15,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Preventing Plugholing "]

{"sheet":"Plug-IP-A","index":16,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 4A: Preventing Plugholing with Rectangular Inlets "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Qc =",1400,"Btu/s",null,null,"Output:","Ts =",{"$f":"D19+D24*D18/(D20*0.24)","v":99.079428381522106},"oF"]
[null,null,"To =",70,"oF",null,null,null,"Vmax =",{"$f":"452*D23*(D22^2.5)*(((J18-D19)/(D19+460))^0.5)","v":29840.209069645818},"cfm"]
[null,null,"m =",100.3,"lb/s",null,null,null,"Ve =",{"$f":"D21/D27","v":23150},"cfm"]
[null,null,"V =",92600,"cfm",null,null,null,"Smin =",{"$f":"0.065*(J20^0.5)","v":9.8898306355569119},"ft (See note 6 above.)"]
[null,null,"d =",9.5500000000000007,"ft",null,null,null,"Di =",{"$f":"2*D25*D26/(D25+D26)","v":4.4444444444444446},"ft"]
[null,null,null,1,{"$f":"IF(Plug1!C6 > 1, \"(See notes 1, 2 and 3)\",\"CAUTION see notes 1, 2 & 3.\")","v":"(See notes 1, 2 and 3)"},null,null,null,"d/Di =",{"$f":"D22/J22","v":2.1487500000000002}]
[null,null,"Ks =",0.5,"(See note 7 above)",null,null,null,"vi =",{"$f":"ROUND(J20/(D28*D25*D26),0)","v":2315},"fpm"]
[null,null,"a =",4,"ft"]
[null,null,"b =",5,"ft",null,null,{"$f":"IF(D24=0.5,\" \",\"CAUTION: See note 7 above. \")","v":" "}]
[null,null,"N =",4,"Number of Inlets"]
[null,null,"Ar =",0.5,"(In the absence of better data, 0.5 is suggested.)"]
[null,null,"Check 1:",{"$f":"IF(J23<2,\"CAUTION: The requirement of note 4 above is not satisfied.\",\"The requirement of note 4 above is satisfied.\")","v":"The requirement of note 4 above is satisfied."}]
[null,null,"Check 2:",{"$f":"IF(J19-J20>0,\"The requirement of note 5 above is satisfied.\",\"CAUTION: The requirement of note 5 above is not satisfied.\")","v":"The requirement of note 5 above is satisfied."}]

{"sheet":"Plug1","index":17,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,{"$f":"'Plug-IP-A'!D23","v":1}]
[]
[null,"Ck 1",{"$f":"IF(C2=1,1000,0)","v":1000}]
[null,"Ck 0.5",{"$f":"IF(C2=0.5,1000,0)","v":0}]
[null,"Sum",{"$f":"C4+C5","v":1000}]

{"sheet":"Plug-IP-B","index":18,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 4B: Preventing Plugholing with Round Inlets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Qc =",1400,"Btu/s",null,"Output:","Ts =",{"$f":"D24+D29*D23/(D25*0.24)","v":99.079428381522106},"oF"]
[null,null,"To =",70,"oF",null,null,"Vmax =",{"$f":"ROUND(452*D28*(D27^2.5)*((I23-D24)/(D24+460))^0.5,0)","v":29840},"cfm"]
[null,null,"m =",100.3,"lb/s",null,null,"Ve =",{"$f":"D26/D31","v":18520},"cfm"]
[null,null,"V =",92600,"cfm",null,null,"Smin =",{"$f":"0.065*(I25^0.5)","v":8.8457334348260801},"ft (See note 6 above.)"]
[null,null,"d =",9.5500000000000007,"ft",null,null,"d/Di =",{"$f":"D27/D30","v":2.0105263157894737}]
[null,null,null,1,{"$f":"IF(Plug2!C6 > 1, \"(See notes 1, 2 and 3)\",\"CAUTION see notes 1, 2 & 3.\")","v":"(See notes 1, 2 and 3)"},null,null,"vi =",{"$f":"I25/(D32*3.14156*((D30^2/4)))","v":2090.2507669584484},"fpm"]
[null,null,"Ks =",0.5,"(See note 7 above)"]
[null,null,"Di =",4.75,"ft",null,null,{"$f":"IF(D29=0.5,\" \",\"CAUTION: See note 7 above. \")","v":" "}]
[null,null,"N =",5,"Number of Inlets"]
[null,null,"Ar =",0.5,"(In the absence of better data, 0.5 is suggested.)"]
[null,null,"Check 1:",{"$f":"IF(I27<2,\"CAUTION: The requirement of note 4 above is not satisfied.\",\"The requirement of note 4 above is satisfied.\")","v":"The requirement of note 4 above is satisfied."}]
[null,null,"Check 2:",{"$f":"IF(I24-I25>0,\"The requirement of note 5 above is satisfied.\",\"CAUTION: The requirement of note 5 above is not satisfied.\")","v":"The requirement of note 5 above is satisfied."}]

{"sheet":"Plug2","index":19,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,{"$f":"'Plug-IP-B'!D28","v":1}]
[]
[null,"Ck 1",{"$f":"IF(C2=1,1000,0)","v":1000}]
[null,"Ck 0.5",{"$f":"IF(C2=0.5,1000,0)","v":0}]
[null,"Sum",{"$f":"C4+C5","v":1000}]

{"sheet":"Plug-SI","index":20,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Preventing Plugholing "]

{"sheet":"Plug-SI-A","index":21,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 4A: Preventing Plugholing with Rectangular Inlets "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Qc =",1500,"kW",null,"Output:","Ts =",{"$f":"D25+D30*D24/D26","v":37.483516483516482},"oC"]
[null,null,"To =",21,"oC",null,null,"Vmax =",{"$f":"ROUND(4.16*D29*(D28^2.5)*((I24-D25)/(D25+273))^0.5,2)","v":15.35},"m3/s"]
[null,null,"m =",45.5,"kg/s",null,null,"Ve =",{"$f":"ROUND(D27/D33, 2)","v":10.93},"m3/s"]
[null,null,"V =",43.7,"m3/s",null,null,"Smin =",{"$f":"0.9*(I26^0.5)","v":2.9754495458669772},"m (See note 6 above.)"]
[null,null,"d =",3,"m ",null,null,"Di =",{"$f":"2*D31*D32/(D31+D32)","v":1.3546666666666667},"m"]
[null,null,null,1,{"$f":"IF(Plug3!C6 > 1, \"(See notes 1, 2 and 3)\",\"CAUTION see notes 1, 2 & 3.\")","v":"(See notes 1, 2 and 3)"},null,null,"d/Di =",{"$f":"ROUND(D28/I28,2)","v":2.21}]
[null,null,"Ks =",0.5,"(See note 7 above)",null,null,"vi =",{"$f":"I26/(D34*D31*D32)","v":11.764954085463726},"m/s"]
[null,null,"a =",1.2192000000000001,"m"]
[null,null,"b =",1.524,"m",null,null,{"$f":"IF(D30=0.5,\" \",\"CAUTION: See note 7 above. \")","v":" "}]
[null,null,"N =",4,"Number of Inlets"]
[null,null,"Ar =",0.5,"(In the absence of better data, 0.5 is suggested.)"]
[null,null,"Check 1:",{"$f":"IF(I29<2,\"CAUTION: The requirement of note 4 above is not satisfied.\",\"The requirement of note 4 above is satisfied.\")","v":"The requirement of note 4 above is satisfied."}]
[null,null,"Check 2:",{"$f":"IF(I25-I26>0,\"The requirement of note 5 above is satisfied.\",\"CAUTION: The requirement of note 5 above is not satisfied.\")","v":"The requirement of note 5 above is satisfied."}]

{"sheet":"Plug3","index":22,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,{"$f":"'Plug-SI-A'!D29","v":1}]
[]
[null,"Ck 1",{"$f":"IF(C2=1,1000,0)","v":1000}]
[null,"Ck 0.5",{"$f":"IF(C2=0.5,1000,0)","v":0}]
[null,"Sum",{"$f":"C4+C5","v":1000}]

{"sheet":"Plug-SI-B","index":23,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 4B: Preventing Plugholing with Round Inlets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Qc =",1500,"kW","Output:","Ts =",{"$f":"D21+D26*D20/D22","v":36.483516483516482},"oC"]
[null,null,"To =",20,"oC",null,"Vmax =",{"$f":"ROUND(4.16*D25*(D24^2.5)*((H20-D21)/(D21+273))^0.5,2)","v":15.38},"m3/s"]
[null,null,"m =",45.5,"kg/s",null,"Ve =",{"$f":"ROUND(D23/D28,2)","v":8.74},"m3/s"]
[null,null,"V =",43.7,"m3/s",null,"Smin =",{"$f":"0.9*(H22^0.5)","v":2.660714189837007},"m (See note 6 above.)"]
[null,null,"d =",3,"m ",null,"d/Di =",{"$f":"ROUND(D24/D27,2)","v":2.0699999999999998}]
[null,null,null,1,{"$f":"IF(Plug4!C6 > 1, \"(See notes 1, 2 and 3)\",\"CAUTION see notes 1, 2 & 3.\")","v":"(See notes 1, 2 and 3)"},null,"vi =",{"$f":"H22/(D29*3.14159*D27*D27/4)","v":10.617805588820488},"m/s"]
[null,null,"Ks =",0.5,"(See note 7 above)"]
[null,null,"Di =",1.4478,"m",null,{"$f":"IF(D26=0.5,\" \",\"CAUTION: See note 7 above. \")","v":" "}]
[null,null,"N =",5,"Number of Inlets"]
[null,null,"Ar =",0.5,"(In the absence of better data, 0.5 is suggested.)"]
[null,null,"Check 1:",{"$f":"IF(H24<2,\"CAUTION: The requirement of note 4 above is not satisfied.\",\"The requirement of note 4 above is satisfied.\")","v":"The requirement of note 4 above is satisfied."}]
[null,null,"Check 2:",{"$f":"IF(H21-H22>0,\"The requirement of note 5 above is satisfied.\",\"CAUTION: The requirement of note 5 above is not satisfied.\")","v":"The requirement of note 5 above is satisfied."}]

{"sheet":"Plug4","index":24,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,{"$f":"'Plug-SI-B'!D25","v":1}]
[]
[null,"Ck 1",{"$f":"IF(C2=1,1000,0)","v":1000}]
[null,"Ck 0.5",{"$f":"IF(C2=0.5,1000,0)","v":0}]
[null,"Sum",{"$f":"C4+C5","v":1000}]

{"sheet":"Airflow-IP","index":25,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Airflow to Control Smoke"]

{"sheet":"Air_IP_A","index":26,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5A: Airflow to Control Smoke Flow from a Communicating Space"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","H =",8,"ft","Output:","ve =",{"$f":"ROUND(38*(((32.2*D16*(D18-D17)/(D18+460))^0.5)),1)","v":175.5},"fpm"]
[null,null,"To =",72,"oF",null,"V =",{"$f":"H16*D19","v":5265},"cfm"]
[null,null,"Tf =",120,"oF"]
[null,null,"A =",30,"ft2"]
[null,null,{"$f":"IF(H16>200,\"CAUTION: The limiting average air velocity exceeds the upper limit of 200 fpm.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm."}]
[null,null,{"$f":"IF(H16>200, \"See note 3 above.\",\" \")","v":" "}]

{"sheet":"Air_IP_B","index":27,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5B: Airflow to Control Smoke Flow from the Smoke Layer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: The temperatures, Tf and To, can be determined from routine 1, 2 or 3."]
[]
[null,"Input:","H =",8,"ft","Output:","ve =",{"$f":"ROUND(38*(((32.2*D24*(D26-D25)/(D26+460))^0.5)),1)","v":157.5},"fpm"]
[null,null,"To =",72,"oF",null,"V =",{"$f":"H24*D27","v":7875},"cfm"]
[null,null,"Tf =",110,"oF"]
[null,null,"A =",50,"ft2"]
[null,null,{"$f":"IF(H24>200,\"CAUTION: The limiting average air velocity exceeds the upper limit of 200 fpm.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm."}]
[null,null,{"$f":"IF(H24>200, \"See note 3 above.\",\" \")","v":" "}]

{"sheet":"Air_IP_C","index":28,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5C: Airflow to Control Smoke Flow from the Plume "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",5000,"Btu/s",null,"Output:","ve =",{"$f":"ROUND(17*(D17/D19)^(1/3),1)","v":93.6},"fpm"]
[null,null,"A =",200,"ft2",null,null,"V =",{"$f":"D18*I17","v":18720},"cfm"]
[null,null,"z =",30,"ft"]
[null,null,{"$f":"IF(D19<10,\"CAUTION: The requirement of note 3 above is not satisfied.\", \"Note: The requirement of note 3 above is satisfied. \")","v":"Note: The requirement of note 3 above is satisfied. "}]
[null,null,{"$f":"IF(I17>200,\"CAUTION: The limiting average air velocity exceeds the upper limit of 200 fpm.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 200 fpm."}]
[null,null,{"$f":"IF(I17>200,\"See note 4 above.\",\" \")","v":" "}]

{"sheet":"Airflow-SI","index":29,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Airflow to Control Smoke"]

{"sheet":"Air_SI_A","index":30,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5A: Airflow to Control Smoke Flow from a Communicating Space"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","H =",2.4993599999999998,"m","Output:","ve =",{"$f":"0.64*(((9.81*D22*(D24-D23)/(D24+273))^0.5))","v":0.96282605030240176},"m/s"]
[null,null,"To =",22,"oC",null,"V =",{"$f":"H22*D25","v":2.8884781509072051},"m3/s"]
[null,null,"Tf =",52,"oC"]
[null,null,"A =",3,"m2"]
[null,null,{"$f":"IF(H22>1.02,\"CAUTION: The limiting average air velocity exceeds the upper limit of 1.02 m/s.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s."}]
[null,null,{"$f":"IF(H22>1.02,\"See note 3 above.\",\" \")","v":" "}]

{"sheet":"Air_SI_B","index":31,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5B: Airflow to Control Smoke Flow from the Smoke Layer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: The temperatures, Tf and To, can be determined from routine 1, 2 or 3."]
[]
[null,"Input:","H =",2.5,"m","Output:","ve =",{"$f":"0.64*(((9.81*D23*(D25-D24)/(D25+273))^0.5))","v":0.81705367563016296},"m/s"]
[null,null,"To =",22,"oC",null,"V =",{"$f":"H23*D26","v":4.0852683781508148},"m3/s"]
[null,null,"Tf =",43,"oC"]
[null,null,"A =",5,"m2"]
[null,null,{"$f":"IF(H23>1.02,\"CAUTION: The limiting average air velocity exceeds the upper limit of 1.02 m/s.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s."}]
[null,null,{"$f":"IF(H23>1.02,\"See note 3 above.\",\" \")","v":" "}]

{"sheet":"Air_SI_C","index":32,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Main!B26","v":"AtriumCalc Version 1.1        © 2014 John H. Klote"}]
[]
[null,"Project:",{"$f":"Main!D12","v":"Atrium in Our Favorite Building, 10 Main Street, Kloteville, NY"}]
[null,"Routine 5C: Airflow to Control Smoke Flow from the Plume "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Q =",5000,"kW",null,"Output:","ve =",{"$f":"ROUND(0.057*(D16/D18)^(1/3),3)","v":0.46899999999999997},"m/s"]
[null,null,"A =",60,"m2",null,null,"V =",{"$f":"D17*I16","v":28.139999999999997},"m3/s"]
[null,null,"z =",9,"m"]
[null,null,{"$f":"IF(D18<3,\"CAUTION: The requirement of note 3 above is not satisfied.\", \"Note: The requirement of note 3 above is satisfied. \")","v":"Note: The requirement of note 3 above is satisfied. "}]
[null,null,{"$f":"IF(I16>1.02,\"CAUTION: The limiting average air velocity exceeds the upper limit of 1.02 m/s.\",\"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s.\")","v":"Note: The limiting average air velocity does not the exceed the upper limit of 1.02 m/s."}]
[null,null,{"$f":"IF(I16>1.02,\"See note 4 above.\", \" \")","v":" "}]