{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Louver_Calculator","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Louver_Calculator","index":0,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,13,6,17],[1,11,1,12],[2,11,2,12],[3,11,3,12],[4,11,4,12],[5,11,5,12],[6,11,6,12],[1,13,1,17],[2,13,2,17],[3,13,3,17],[4,13,4,17],[5,13,5,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Project: "]
[null,null,null,null,null,null,null,null,null,null,null,"Project Number:"]
[null,null,null,null,null,null,null,null,null,null,null,"Engineered by:"]
[null,null,"LOUVER PERFORMANCE",null,null,null,null,null,null,null,null,"Calculated by: "]
[null,null,"Holyoake Louver Calculator",null,null,null,null,null,null,null,null,"Comments: "]
[null,null,"Version 6.5",null,null,null,null,null,null,null,null,"Date / Time: ",null,{"$f":" NOW()","v":"2023-07-20T11:19:23.440"}]
[null,null,"Louver Number","Louver\nModel","Volume\n(L/S)","Volume\n(M3S)","Width\n(mm)","Height\n(mm)","Exhaust or Intake\n(E / I)","Effective Pressure\nArea","Free Area\n(%)","Area Velocity\n(m/s)","Louver\nVelocity\n(m/s)","Pressure Drop\n(Pa)","Discharge Coefficient\n(CDv)","Estimated Weight\n(Kg)","Wind Loading","Efficiency Class"]
[]
[null,null,1,null,null,{"$f":"E10/1000","v":0},null,null,null,{"$f":"IF(OR(D10=\"\",F10=0,G10=0,H10=0),0,((($H10-VLOOKUP(D10,louverData,3,FALSE))*VLOOKUP(D10,louverData,4,FALSE))*($G10-VLOOKUP(D10,louverData,2,FALSE)))/1000000)","v":0},{"$f":"IF(OR(D10=\"\",G10=0,H10=0,J10=0),0,SUM(J10/SUM(G10*H10/1000000)))","v":0},{"$f":"IF(OR(F10=0,G10=0,D10=0,H10=0),0,F10/((G10*H10)/1000000))","v":0},{"$f":"IF(OR(F10=0,J10=0,D10=0),0,SUM(F10/J10))","v":0},{"$f":"IF(OR(I10=\"\",F10=0,J10=0),0,IF(D10=\"AHL-150\",(0.5753*(F10/J10)^2+0.002*(F10/J10)+0.0358),IF(D10=\"Acoustic Trap\",\"N/A\",IF(I10=\"E\",(($F10/J10)/0.9104977079)^2,IF(I10=\"I\",((F10/J10)/0.7427843551)^2,\" \")))))","v":0},{"$f":"IF(OR(H10=\"\",I10=\"\",L10=0,$N10=\" \"),\" \",IF($N10=\"N/A\",\"N/A\",($F10/(($G10/1000)*($H10/1000)))*SQRT((1.19/(2*$N10)))))","v":" "},{"$f":"IF(OR(D10=\"\",G10=0,H10=0),0,IF(OR(D10=\"AHL-150\",D10=\"Acoustic Trap\"),SUM((ROUNDUP(($H10-VLOOKUP(D10,louverData,3,FALSE))/VLOOKUP(D10,louverData,7,FALSE),0)+1)*($G10-VLOOKUP(D10,louverData,2,FALSE))*VLOOKUP(D10,louverData,6,FALSE),(2*($H10+$G10-VLOOKUP(D10,louverData,2,FALSE))*VLOOKUP(D10,louverData,5,FALSE))),SUM(((($H10/VLOOKUP(D10,louverData,7,FALSE))*$G10)*VLOOKUP(D10,louverData,6,FALSE))+(($G10+$H10)*2)*(VLOOKUP(D10,louverData,5,FALSE)))*1.05))","v":0},{"$f":"IF(D10=\"\",0,IF(D10=\"AHL-150\",\"N/A\",VLOOKUP(D10,louverData,8,FALSE)))","v":0},{"$f":"IF(D10=\"\",0,VLOOKUP(D10,louverData,12,FALSE))","v":0}]
[null,null,2,null,null,{"$f":"E11/1000","v":0},null,null,null,{"$f":"IF(OR(D11=\"\",F11=0,G11=0,H11=0),0,((($H11-VLOOKUP(D11,louverData,3,FALSE))*VLOOKUP(D11,louverData,4,FALSE))*($G11-VLOOKUP(D11,louverData,2,FALSE)))/1000000)","v":0},{"$f":"IF(OR(D11=\"\",G11=0,H11=0,J11=0),0,SUM(J11/SUM(G11*H11/1000000)))","v":0},{"$f":"IF(OR(F11=0,G11=0,D11=0,H11=0),0,F11/((G11*H11)/1000000))","v":0},0,{"$f":"IF(OR(I11=\"\",F11=0,J11=0),0,IF(D11=\"AHL-150\",(0.5753*(F11/J11)^2+0.002*(F11/J11)+0.0358),IF(D11=\"Acoustic Trap\",\"N/A\",IF(I11=\"E\",(($F11/J11)/0.9104977079)^2,IF(I11=\"I\",((F11/J11)/0.7427843551)^2,\" \")))))","v":0},{"$f":"IF(OR(H11=\"\",I11=\"\",L11=0,$N11=\" \"),\" \",IF($N11=\"N/A\",\"N/A\",($F11/(($G11/1000)*($H11/1000)))*SQRT((1.19/(2*$N11)))))","v":" "},{"$f":"IF(OR(D11=\"\",G11=0,H11=0),0,IF(OR(D11=\"AHL-150\",D11=\"Acoustic Trap\"),SUM((ROUNDUP(($H11-VLOOKUP(D11,louverData,3,FALSE))/VLOOKUP(D11,louverData,7,FALSE),0)+1)*($G11-VLOOKUP(D11,louverData,2,FALSE))*VLOOKUP(D11,louverData,6,FALSE),(2*($H11+$G11-VLOOKUP(D11,louverData,2,FALSE))*VLOOKUP(D11,louverData,5,FALSE))),SUM(((($H11/VLOOKUP(D11,louverData,7,FALSE))*$G11)*VLOOKUP(D11,louverData,6,FALSE))+(($G11+$H11)*2)*(VLOOKUP(D11,louverData,5,FALSE)))*1.05))","v":0},{"$f":"IF(D11=\"\",0,IF(D11=\"AHL-150\",\"N/A\",VLOOKUP(D11,louverData,8,FALSE)))","v":0},0]
[null,null,3,null,null,0,null,null,null,{"$f":"IF(OR(D12=\"\",F12=0,G12=0,H12=0),0,((($H12-VLOOKUP(D12,louverData,3,FALSE))*VLOOKUP(D12,louverData,4,FALSE))*($G12-VLOOKUP(D12,louverData,2,FALSE)))/1000000)","v":0},{"$f":"IF(OR(D12=\"\",G12=0,H12=0,J12=0),0,SUM(J12/SUM(G12*H12/1000000)))","v":0},0,0,{"$f":"IF(OR(I12=\"\",F12=0,J12=0),0,IF(D12=\"AHL-150\",(0.5753*(F12/J12)^2+0.002*(F12/J12)+0.0358),IF(D12=\"Acoustic Trap\",\"N/A\",IF(I12=\"E\",(($F12/J12)/0.9104977079)^2,IF(I12=\"I\",((F12/J12)/0.7427843551)^2,\" \")))))","v":0},{"$f":"IF(OR(H12=\"\",I12=\"\",L12=0,$N12=\" \"),\" \",IF($N12=\"N/A\",\"N/A\",($F12/(($G12/1000)*($H12/1000)))*SQRT((1.19/(2*$N12)))))","v":" "},0,0,0]
[null,null,4,null,null,0,null,null,null,0,0,0,0,0,{"$f":"IF(OR(H13=\"\",I13=\"\",L13=0,$N13=\" \"),\" \",IF($N13=\"N/A\",\"N/A\",($F13/(($G13/1000)*($H13/1000)))*SQRT((1.19/(2*$N13)))))","v":" "},0,0,0]
[null,null,5,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,6,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,7,null,null,0,null,null,null,0,0,0,{"$f":"IF(OR(F16=0,J16=0,D16=0),0,SUM(F16/J16))","v":0},0," ",0,0,0]
[null,null,8,null,null,0,null,null,null,{"$f":"IF(OR(D17=\"\",F17=0,G17=0,H17=0),0,((($H17-VLOOKUP(D17,louverData,3,FALSE))*VLOOKUP(D17,louverData,4,FALSE))*($G17-VLOOKUP(D17,louverData,2,FALSE)))/1000000)","v":0},{"$f":"IF(OR(D17=\"\",G17=0,H17=0,J17=0),0,SUM(J17/SUM(G17*H17/1000000)))","v":0},0,0,0," ",0,0,0]
[null,null,9,null,null,0,null,null,null,0,{"$f":"IF(OR(D18=\"\",G18=0,H18=0,J18=0),0,SUM(J18/SUM(G18*H18/1000000)))","v":0},0,0,0," ",0,0,0]
[null,null,10,null,null,0,null,null,null,0,{"$f":"IF(OR(D19=\"\",G19=0,H19=0,J19=0),0,SUM(J19/SUM(G19*H19/1000000)))","v":0},{"$f":"IF(OR(F19=0,G19=0,D19=0,H19=0),0,F19/((G19*H19)/1000000))","v":0},{"$f":"IF(OR(F19=0,J19=0,D19=0),0,SUM(F19/J19))","v":0},{"$f":"IF(OR(I19=\"\",F19=0,J19=0),0,IF(D19=\"AHL-150\",(0.5753*(F19/J19)^2+0.002*(F19/J19)+0.0358),IF(D19=\"Acoustic Trap\",\"N/A\",IF(I19=\"E\",(($F19/J19)/0.9104977079)^2,IF(I19=\"I\",((F19/J19)/0.7427843551)^2,\" \")))))","v":0},{"$f":"IF(OR(H19=\"\",I19=\"\",L19=0,$N19=\" \"),\" \",IF($N19=\"N/A\",\"N/A\",($F19/(($G19/1000)*($H19/1000)))*SQRT((1.19/(2*$N19)))))","v":" "},0,{"$f":"IF(D19=\"\",0,IF(D19=\"AHL-150\",\"N/A\",VLOOKUP(D19,louverData,8,FALSE)))","v":0},{"$f":"IF(D19=\"\",0,VLOOKUP(D19,louverData,12,FALSE))","v":0}]
[null,null,11,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,12,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,13,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,14,null,null,0,null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,15,null,0,{"$f":"E24/1000","v":0},null,null,null,0,0,0,0,0," ",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The CDv Value assumes an Air Density of 1.19 kg/m3"]
[]
[null,"Note: All Holyoake Louvers have been tested and classified in accordance with:"]
[]
[null,"AS/NZS 4740:2000"]
[null,"Natural Ventilators - Classification and Performance"]
[]
[null,"BS.EN 13030:2001 "]
[null,"Ventilation for Buildings. Terminal Performance testing of louvers subjected to simulated rain."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,0,0]

{"sheet":"Data","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Type","Width Deduction","Height Deduction","Multiplier","Frame Weight","Blade Weight","Blade Spacing","Wind Load","Efficiency Class A","Efficiency Class B","Efficiency Class C","Base Class"]
[null,"AHL-150",76,296,0.383523,2.1080000000000001E-3,3.8920000000000001E-3,152,"N/A",null,null,null,"N/A"]
[null,"Acoustic Trap",76,296,0.54545399999999999,1.428E-3,2.2399999999999998E-3,152,"N/A",null,null,null,"N/A"]
["E","OHL-KD100",57,193,0.505,1.7390000000000001E-3,1.023E-3,102,"Level 1",null,0.5,7,"Class B"]
["I","OHCL-102",57,193,0.505,1.7390000000000001E-3,{"$f":"0.001172+0.000544","v":1.7160000000000001E-3},102,"Level 1",null,null,6.5,"Class C"]
[null,"OHCL-124",60,160,0.49,1.7390000000000001E-3,{"$f":"0.00091+0.000435","v":1.3450000000000001E-3},76.2,"Level 1",null,0.5,7.5,"Class B"]
[null,"OHL-DRC",57,193,0.505,{"$f":"0.001739*2","v":3.4780000000000002E-3},6.7000000000000002E-4,76.2,"Level 1",null,7,7.5,"Class B"]
[null,"OHL-100WT",57,193,{"$f":"0.505*0.73","v":0.36864999999999998},1.7390000000000001E-3,{"$f":"G9+G14","v":1.9710000000000001E-3},64,"Level 1",7.5,null,null,"Class A"]
[null,"OHL-102",57,193,0.505,1.7390000000000001E-3,1.1720000000000001E-3,102,"Level 1",null,null,6.5,"Class C"]
[null,"OHL-124",57,150,0.58799999999999997,1.7390000000000001E-3,9.1E-4,76.2,"Level 1",null,0.5,7.5,"Class B"]
[null,"OHL-34",11,63,0.316,4.7100000000000001E-4,3.5599999999999998E-4,38,"Level 1",null,5.5,7.5,"Class B"]
[null,"OHL-45",11,69,0.5,4.37E-4,4.2400000000000001E-4,50,"Level 1",null,null,7.5,"Class C"]
[null,"OHL-D",57,150,0.58799999999999997,1.7390000000000001E-3,6.7000000000000002E-4,76.2,"Level 1",null,0.5,7.5,"Class B"]
[null,"OVL-99",11,63,0.316,1.7390000000000001E-3,7.9900000000000001E-4,64,"Level 1",null,0.5,5,"Class B"]