{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main","Quick Notes","Instructions & Training","Calculations","Tables","Revision Notes","Other"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":46,"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":"Main","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,74,6],[5,10,6,10],[5,11,6,11],[5,9,7,9],[26,2,27,2],[8,9,8,11],[24,9,24,11],[25,11,28,11],[25,10,28,10],[22,10,23,10],[22,11,23,11],[14,11,21,11],[14,10,21,10],[9,11,13,11],[9,10,13,10],[8,1,8,3],[14,1,14,3],[19,1,19,3],[5,1,5,3],[32,1,32,4],[26,1,27,1],[30,1,30,4],[29,1,29,4],[33,1,33,4],[22,1,22,4],[26,3,27,3],[26,4,27,4],[31,1,31,4]]}
[null,null,null,null,null,null,"Version 4"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-02"}]
[null,null,null,null,null,"Customer Name:"]
[null,null,null,null,null,"PO Number:"]
[null,null,null,null,null,"AGI Westeel Sales Order Number:"]
[null,"Location Usage",null,null,null,null,null,null,null,"Bin Series","Standard Peak Load","Higher Rated Peak Load"]
[null,"Location Type","*",{"$f":"INDEX(Tables!$F$8:$F$10,Tables!L19)","v":" "},null,"* - Mandatory Fields"]
[null,null,null,null,null,null,null,null,null,null,"lbs (kN)","lbs (kN)"]
[null,"Bin Requirements",null,null,null,null,null,null,null,"Non-Structural Roof"]
[null,"Bin Type","*",{"$f":"INDEX(Tables!$F$13:$F$20,Tables!L20)","v":" "},null,null,null,null,null,15,"4000 (17.8)","8000 (35.6)"]
[null,"Diameter [ft.]","*",{"$f":"INDEX(Tables!$A$2:$A$18,Tables!L21)","v":" "},null,null,null,null,null,16]
[null,"Tier","*",{"$f":"INDEX(Tables!$H$2:$H$16,Tables!L22)","v":" "},null,null,null,null,null,18]
[null,"Peak Load [lbs.]","*",{"$f":"INDEX(Tables!$J$2:$J$5,Tables!L23)","v":" "},null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,24]
[null,"Bin Location",null,null,null,null,null,null,null,27,"5000 (22.2)","10000 (44.5)"]
[null,"Location Name","*",null,null,null,null,null,null,30]
[null,"Wind Speed [mph]","*",null,null,null,null,null,null,33]
[null,"Ground Snow Load [psf]","*",null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,39]
[null,"Cable Monitoring System",null,null,null,null,null,null,null,42]
[null,"Cable Type","*",{"$f":"INDEX(Tables!$F$2:$F$5,Tables!L24)","v":" "},null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,48]
[null,"Results",null,null,null,null,null,null,null,51,"8000 (35.6)","12000 (53.4)"]
[null,"Roof Requirements",null,"Description","Part Number",null,null,null,null,54]
[null,"Standard Roof",null,{"$f":"IF(D21=\" \",\"-\",IFERROR(INDEX(Tables!$V$1:$V$17,MATCH(nDia,Tables!$U$1:$U$17,0)),\"-\"))","v":"-"},{"$f":"IF(D21=\" \",\"-\",IFERROR(INDEX(Tables!$W$1:$W$17,MATCH(nDia,Tables!$U$1:$U$17,0)),\"-\"))","v":"-"},null,null,null,null,"Structural Roof"]
[null,"Roof Upgrade Required",null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"-\",INDEX(Tables!$V$18:$V$42,MATCH($E$26,Tables!$W$18:$W$42,0))),\"-\")","v":"-"},{"$f":"IF(Tables!N24=\" \",\"-\",IF(OR(BT=\"Westeel EasyDry SGL Fan Inlet\",BT=\"Westeel EasyDry DBL Fan Inlet\"),IFERROR(INDEX(Tables!Y1:AC5,MATCH(nDia,Tables!Y1:Y16,0),MATCH(HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE),Tables!L1:P1,0)),\"-\"),IFERROR(INDEX(Tables!L1:P16,MATCH(nDia,Tables!L1:L16,0),MATCH(HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE),Tables!L1:P1,0)),\"-\")))","v":"-"},null,null,null,null,48,"20000 (89.0)","60000 (266.9)"]
[null,"Required Monitoring Cable Hanger System",null,{"$f":"IF(RCBLTYPE=\"None\",\"-\",IF(OR(E25=212601,E26=212610,E26=212599,E26=212598),Calculations!E18,\"-\"))","v":"-"},{"$f":"IFERROR(IF(OR(E25=212601,E26=212610,E26=212599,E26=212598),Calculations!D18,\"-\"),\"-\")","v":"-"},null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,54]
[null,"Remaining Peak Load",null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"-\",ROUNDDOWN(RPL,0)&\" lbs (\"&ROUNDDOWN(RPL/224.80894387096,1)&\" kN)\"),\"\")","v":"-"},null,null,null,null,null,60]
[null,{"$f":"IF(COUNTIF($D$26,\"*Structural Roof\")=1,\"Structural roof replaces standard roof. You will need to purchase \"&E26&\" instead of the standard roof.\",\"\")","v":""}]
[null,{"$f":"IF(LT=\"Commercial\", \"Please contact AGI Westeel Customer Service about seismic considerations.\", \"\")","v":""}]
[null,{"$f":"IF(D21=\" \",\"\",IFERROR(IF(WS>107,\"Please contact AGI Westeel Customer Service for potential wind upgrades.\",\"\"),\"\"))","v":""}]
[null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"\",IF(AND(RCBLTYPE=\"None\", nDia<=21, MIN(Calculations!C28:F29)<>9999), \"\",IF(MIN(Calculations!C28:F29)=9999,\"ROOF IS OVERLOADED. Neither the standard roof nor any standard roof upgrades will accommodate the loads. Please contact AGI Westeel Customer Service for potential further roof upgrades.\",\"\"))),\"\")","v":""}]
[null,{"$f":"IF(D21=\" \",\"\",IF(BT=\"Stiffened AGI Westeel Hopper\",\"Currently AGI Westeel 15'-27' welded hopper bottoms are manufactured for unstiffened bins only. Please ensure the third-party hopper you are using will work with AGI Westeel Products.\",\"\"))","v":""}]
[]
[]
[]
[null,"Important Notes\n- Standard AGI Westeel Bins are rated for 107 mph as per ASCE 7-16.\n\n- For Flat Bottom Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables end 2ft. up from the floor.\n- For Hopper Bottom Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables attach to the hopper cone.\n- For SSK Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables attach to the hopper cone.\n- If your Monitoring Cable System does not fall under these parameters please contact AGI Westeel Customer Service for a custom analysis.\n- Monitoring Cable Systems are not available for AGI Westeel EasyDry Bins.\n\n- If your bin is using an AGI SureTrack Monitoring System Package, the package will come with a standard AGI SureTrack hanger system.\n- If your Monitoring Cable Hanger System is different from the one this tool has recommended, please contact AGI Westeel Customer Service for further information.\n\n- For SSK Hoppers the angle of the hopper sheets are 45° for 15'-21' bins and 40° for 24'-27' bins.\n- For Welded Hoppers the angle of the hopper sheets are 35° for 15'-27' bins."]

{"sheet":"Quick Notes","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions & Training","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculations","index":3,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Radial Cable Loads",null,null,null,null,null,null,null,null,null,"Roof Snow Load (RSL)"]
["Central Cable Radial Distance [ft]","rc =",{"$f":"INDEX(STCCL,MATCH(nDia,DIAMETER,0))","v":0},"(SureTrack Central Cable locations)",null,null,null,null,null,null,"Average Slope Factor","Cs =",0.75]
["Maximum Calculated Cable Length for Flat Bottom Bins [ft]","Lcf =",{"$f":"IF(RCBLTYPE=\"None\",0,IF(OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),((1.25+nT*44)/12-2)+(nDia/2-rcable)*TAN(RADIANS(30)),0))","v":0},"(Length of cable from roof sheet to bin floor)",null,null,null,null,null,null,"Exposure Factor","Ce =",1]
["Maximum Calculated Cable Length for Hopper Bottom and SSK Bins [ft]","Lch =",{"$f":"IF(OR(RCBLTYPE=\"None\",BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),0,((1.25+nT*44)/12)+(nDia/2-rcable)*TAN(RADIANS(30))+(nDia/2-rcable)*TAN(RADIANS(45)))","v":{"$error":"#VALUE!"}},"(Length of cable from roof sheet to hopper cone, assumes angle of hopper is 45°)",null,null,null,null,null,null,"Thermal Factor","Ct =",1.2]
["Cable Length [ft]","L =",{"$f":"IF(RCBLTYPE=\" \",NA(),IF(RCBLTYPE=\"None\",0,IF(OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),Lcf,IF(OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),Lch))))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Importance Factor","I =",0.8]
["Product Density [lb/ft3]","p =",{"$f":"CONVERT(772*1000,\"g\",\"lbm\")/(CONVERT(1,\"m\",\"ft\"))^3","v":48.194385564783637},"(Assume product used is wheat = 772 kg/m3)",null,null,null,null,null,null,"Roof Snow Load (psf)","RSL =",{"$f":"IF(GSL=\"\",\"\",Cs*0.7*Ce*Ct*I*GSL)","v":""}]
["Coefficient of Friction","u =",0.37]
["Lateral to Vertical Pressure Ratio","k =",0.5,null,"Coefficients of OPI radial cable loads"]
["Sensor Spacing [ft]","ss =",6,"(OPI)","OPI","C1","C2"]
["Sensor Weight [lbs/sensor]","Ps =",45,"(OPI)","MDR",2.38402777777778E-2,0.75819999999999999]
["Radial Temperature Cable Force [lbs]","PRT =",{"$f":"COEFFC1*p*(nDia/2)^2/(mu^2*k)*(-1+EXP(-mu*k*L/(nDia/2)))+(COEFFC1*p*nDia/(mu*2)+COEFFC2)*L","v":{"$error":"#N/A"}},null,"CDR",3.3191666666666668E-2,1.4527000000000001]
["Radial Moisture Cable Force [lbs]","PRM =",{"$f":"MOISTC1*p*(nDia/2)^2/(mu^2*k)*(-1+EXP(-mu*k*L/(nDia/2)))+(MOISTC1*p*nDia/(mu*2)+MOISTC2)*L + Ps/ss*L","v":{"$error":"#VALUE!"}},null,"C, DUE TO L",{"$f":"IF(L>80,F11,MDRC1)","v":{"$error":"#N/A"}},{"$f":"IF(L>80,G11,MDRC2)","v":{"$error":"#N/A"}}]
["Chosen Radial Cable Force [lbs]",{"$f":"IF(RCBLTYPE=\"None\",\"None\",IF(RCBLTYPE=\"Temperature\",B11,B12))","v":"PRM ="},{"$f":"IF(RCBLTYPE=\"AGI SureTrack Temp\",PRT,IF(RCBLTYPE=\"AGI SureTrack Moist/Moist & Temp\",PRM,0))","v":0},null,"MOIST.",1.3513194444444444E-2,5.6208000000000001E-2]
[]
["Determining Cable Support System",null,null,"Indicator","PN","Cost","Logic"]
["Rib Caps",null,{"$f":"IF(AND(nDia<60,nDia>11),1,0)","v":0},"1 if used","Varies by Dia","Varies by Dia","12' - 54' non-structural roofs, 16 tiers or less for flat bottom bins, 14 tiers or less for hopper bins"]
["Internal Bracket Hanging under Rafters, 48'-108' Diameter Roof",null,{"$f":"IF(OR(nDia=\" \",nT=\" \"),NA(),IF(AND(BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>=48),2,0))","v":{"$error":"#N/A"}},"2 if used",212777,null,"structural roof, stiffened bin"]
["Radial Cable Support Chosen:",null,{"$f":"IF(OR(RCBLTYPE=\"None\",RCBLTYPE=\" \"),\"\",IF(OR(Main!E25=212601,Main!E26=212610,Main!E26=212599,Main!E26=212598),2,MAX(C16)))","v":""},{"$f":"INDEX($E$16:$E$17,MATCH($C$18,CBLSPT,0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($A$16:$A$17,MATCH($C$18,CBLSPT,0)),\"\")","v":""}]
[]
["Determining Remaining Peak Load","RPL =",{"$f":"ROUNDDOWN(IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia=60),INDEX(Peak_Loads[HRSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",nDia=60),INDEX(Peak_Loads[STDSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia>47,nDia<55,OR(Tables!S2=212598,Tables!S2=212599,Tables!S2=212610)),INDEX(Peak_Loads[HRSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",nDia>47,nDia<55,OR(Tables!S2=212598,Tables!S2=212599,Tables!S2=212610)),INDEX(Peak_Loads[STDSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),OR(nDia<22,AND(nDia>35,nDia<55))),INDEX(Peak_Loads[HR],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",OR(nDia<22,AND(nDia>35,nDia<55))),INDEX(Peak_Loads[STD],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia>22,nDia<35),INDEX(Peak_Loads[HR],MATCH(nDia,Peak_Loads[DIAMETER]),0),INDEX(Peak_Loads[STD],MATCH(nDia,Peak_Loads[DIAMETER]),0)))))))),0)","v":{"$error":"#N/A"}}]
[]
["Max Roof Cap. w/ Rad. Cables, RSL, & Std Peak Load Applied","CBLSPT","STD","UP1","UP2","UP3","Formulas"]
["Rib Caps [psf]",{"$f":"$C$16","v":0},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[STD],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[STD],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP1],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP1],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP2],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP2],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP3],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP3],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},"= Rs - RSL"]
["Hanging Bracket [psf]",{"$f":"$C$17","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[STD],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[STD],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP1],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP1],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP2],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP2],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP3],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP3],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},"= Rs - RSL"]
[]
[null,null,10,20,30,40]
["Determining Roof Upgrade","CBLSPT","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3"]
["Rib Caps",{"$f":"$C$16","v":0},{"$f":"IF(AND($B28>0,C23>0,C23<>\"N/A\"),C$26,9999)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Hanging Bracket",{"$f":"$C$17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Tables","index":4,"n_rows":142,"n_cols":29,"rows_kept":142,"cut":false,"hidden":true,"merged":[[105,0,122,0],[124,0,141,0],[17,11,17,13],[25,6,25,10],[44,6,44,10],[25,13,25,17],[103,0,103,5],[103,14,103,19],[65,0,82,0],[63,0,63,5],[84,0,101,0]]}
["DIAMETER","AGI SURETRACK CABLE QTY CENTRE","AGI SURETRACK CABLE QTY RAD 1","AGI SURETRACK CENTER CABLE RADIAL DISTANCE",null,"Cable Type",null,"TIER",null,"Peak Load",null,"Roof","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3",null,"Roof Upgrade Required",{"$f":"HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE)","v":{"$error":"#N/A"}},null,"Size","Description","Part Number",null,"EasyDry\nRoof","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),15,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(7.1*COS(RADIANS(30))))/12","v":1.887398363905793},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(WS)=FALSE,ISBLANK(GSL)=FALSE)),\"None\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia=16),\"\",IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia>0,nDia<30),3,\"\"))","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Standard\",\"\")","v":""},null,15,"-",null,null,null,null,"Roof Upgrade Part Number",{"$f":"INDEX(Tables!L1:P16,MATCH(nDia,Tables!L1:L16,0),MATCH($S$1,Tables!L1:P1,0))","v":{"$error":"#N/A"}},null,15,{"$f":"U2&\"' \"&\"Non-Structural Roof\"","v":"15' Non-Structural Roof"},212015,null,24,"-","212024U1-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\"),16,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(7.1*COS(RADIANS(30))))/12","v":1.887398363905793},null,{"$f":"IF(OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),\"\",IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(WS)=FALSE,ISBLANK(GSL)=FALSE)),\"AGI SureTrack Temp\",\"\"))","v":""},null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia=16),AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia=39)),\"\",IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>0,nDia<54),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),4,\"\"))","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Higher Rated\",\"\")","v":""},null,16,"-",null,null,null,null,"Cable Support Required",{"$f":"Calculations!$E$18","v":""},null,16,"16' Non-Structural Roof",212016,null,27,"-","212027U1"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),18,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(11.55*COS(RADIANS(30))))/12","v":2.2085494511425221},null,{"$f":"IF(OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),\"\",IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(WS)=FALSE,ISBLANK(GSL)=FALSE)),\"AGI SureTrack Moist/Moist & Temp\",\"\"))","v":""},null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),5,\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Unknown\",\"\")","v":""},null,18,"-",null,null,null,null,"Support Part Number",{"$f":"Calculations!$D$18","v":{"$error":"#N/A"}},null,18,"18' Non-Structural Roof",212018,null,30,"-","212030U1","212030U2-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),21,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(15.75*COS(RADIANS(30))))/12","v":2.5116583424670758},null," ",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),6,\"\")","v":""},null," ",null,21,"-","212021U1",null,null,null,null,null,null,21,"21' Non-Structural Roof",212021,null,36,"-","212036U1","212036U2-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),24,\"\")","v":""},null,3,{"$f":"((33/2)+(19.94*COS(RADIANS(30))))/12","v":2.8140455459551426},null,null,null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",OR(nDia=15,nDia=16,nDia=18)),\"\",IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<30)),7,\"\"))","v":""},null," ",null,24,"-","212024U1",null,null,null,null,null,null,24,"24' Non-Structural Roof",212024]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),27,\"\")","v":""},null,3,{"$f":"((33/2)+(24.14*COS(RADIANS(30))))/12","v":3.1171544372796958},null,"Location Type",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",OR(nDia=15,nDia=16,nDia=18,nDia=24))),\"\",IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>18,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),8,\"\"))","v":""},null," ",null,27,"-","212027U1",null,null,null,null,null,null,27,"27' Non-Structural Roof",212027]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\")),30,\"\")","v":""},null,3,{"$f":"((52/2)+(17.36*COS(RADIANS(30))))/12","v":3.4195167508081545},null,"Farm (Price List)",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>24,nDia<60),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel SSK\",nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),9,\"\")","v":""},null," ",null,30,"-","212030U1","212030U2",null,null,null,null,null,30,"30' Non-Structural Roof",212030]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\")),33,\"\")","v":""},null,3,{"$f":"((52/2)+(21.55*COS(RADIANS(30))))/12","v":3.7219039542962213},null,"Commercial",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel SSK\",nDia>0,nDia<27),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),10,\"\")","v":""},null," ",null,33,"-","212033U1","212033U2",null,null,null,null,null,33,"33' Non-Structural Roof",212033]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\")),36,\"\")","v":""},1,3,{"$f":"((52/2)+(25.75*COS(RADIANS(30))))/12","v":4.0250128456207745},null," ",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>24,nDia<39)),11,\"\")","v":""},null," ",null,36,"-","212036U1","212036U2",null,null,null,null,null,36,"36' Non-Structural Roof",212036]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),39,\"\")","v":""},1,3,{"$f":"((52/2)+(30*COS(RADIANS(30))))/12","v":4.3317301761277633},null,null,null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia=27),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>24,nDia<39)),12,\"\")","v":""},null," ",null,39,"-","212039U1","212039U2",null,null,null,null,null,39,"39' Non-Structural Roof",212039]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),42,\"\")","v":""},1,4,{"$f":"((52/2)+(34.1*COS(RADIANS(30))))/12","v":4.6276221890874467},null,"Bin Type",null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),13,\"\")","v":""},null," ",null,42,"-","212042U1","212042U2",null,null,null,null,null,42,"42' Non-Structural Roof",212042]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),45,\"\")","v":""},1,4,{"$f":"((52/2)+(38.32*COS(RADIANS(30))))/12","v":4.9321744560849741},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Unstiffened AGI Westeel Flat Bottom\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),14,\"\")","v":""},null," ",null,45,"-","212045U1","212045U2",null,null,null,null,null,45,"45' Non-Structural Roof",212045]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),48,\"\")","v":""},1,5,{"$f":"((52/2)+(42.51*COS(RADIANS(30))))/12","v":5.2345616595730409},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel Flat Bottom\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>21,nDia<66),15,\"\")","v":""},null," ",null,48,"-","212048U1","212048U2",212598,null,null,null,null,48,"48' Non-Structural Roof",212048]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),51,\"\")","v":""},1,6,{"$f":"((60/2)+(42.09*COS(RADIANS(30))))/12","v":5.5375841037739191},null,{"$f":"IF(LT=\"Farm (Price List)\",\"AGI Westeel EasyDry SGL Fan Inlet\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>21,nDia<66),16,\"\")","v":""},null,null,null,51,"-","212051U1",212599,null,null,null,null,null,51,"51' Non-Structural Roof",212051]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),54,\"\")","v":""},1,6,{"$f":"((60/2)+(46.28*COS(RADIANS(30))))/12","v":5.8399713072619859},null,{"$f":"IF(LT=\"Farm (Price List)\",\"AGI Westeel EasyDry DBL Fan Inlet\",\"\")","v":""},null," ",null,null,null,54,"-","212054U1",212610,null,null,null,null,null,54,"54' Non-Structural Roof",212054]
[{"$f":"IF(AND(LT=\"Farm (Price List)\", BT=\"Stiffened AGI Westeel Flat Bottom\"),60,\"\")","v":""},1,7,{"$f":"((52/2)+(17.36*COS(RADIANS(30))))/12","v":3.4195167508081545},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Unstiffened AGI Westeel Hopper\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,{"$f":"U17&\"' \"&\"Structural Roof\"","v":"60' Structural Roof"},212601]
[" ",null,null,null,null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel Hopper\",\"\")","v":""},null,null,null,null,null,"Developer Drop Down Lists",null,null,null,null,null,null,null,null,null,"21' Upgrade 1","212021U1"]
[null,null,null,null,null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel SSK\",\"\")","v":""},null,null,null,null,null,3,null,{"$f":"INDEX(Tables!$F$8:$F$10,Tables!L19)","v":" "},null,null,null,null,null,null,null,"24' Upgrade 1","212024U1"]
[null,null,null,null,null," ",null,null,null,null,null,8,null,{"$f":"INDEX(Tables!$F$13:$F$20,Tables!L20)","v":" "},null,null,null,null,null,null,null,"24' EasyDry Upgrade 1","212024U1-ED"]
[null,null,null,null,null," ",null,null,null,null,null,17,null,{"$f":"INDEX(Tables!$A$2:$A$18,Tables!L21)","v":" "},null,null,null,null,null,null,null,"27' Upgrade 1","212027U1"]
[null,null,null,null,null,null,null,null,null,null,null,15,null,{"$f":"INDEX(Tables!$H$2:$H$16,Tables!L22)","v":" "},null,null,null,null,null,null,null,"30' Upgrade 1","212030U1"]
[null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"INDEX(Tables!$J$2:$J$5,Tables!L23)","v":" "},null,null,null,null,null,null,null,"33' Upgrade 1","212033U1"]
[null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"INDEX(Tables!$F$2:$F$5,Tables!L24)","v":" "},null,null,null,null,null,null,null,"36' Upgrade 1","212036U1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39' Upgrade 1","212039U1"]
["(Rs, psf) Max Roof Snow Load @ Standard Peak Load",null,null,null,null,null,"(U, psf) Ultimate FEA Roof Snow Load Capacities\n@ Standard Peak Load",null,null,null,null,null,null,"Peak Loads",null,null,null,null,null,null,null,"42' Upgrade 1","212042U1"]
["DIAMETER","STD","UP1","UP2","UP3",null,"DIAMETER","STD","UP1","UP2","UP3",null,null,"DIAMETER","STD","HR","STDSTRUCTURAL","HRSTRUCTURAL",null,null,null,"45' Upgrade 1","212045U1"]
[15,45,"N/A","N/A","N/A",null,15,75.48,"N/A","N/A","N/A",null,null,15,4000,8000,"N/A","N/A",null,null,null,"48' Upgrade 1","212048U1"]
[16,45,"N/A","N/A","N/A",null,16,75.48,"N/A","N/A","N/A",null,null,16,4000,8000,"N/A","N/A",null,null,null,"51' Upgrade 1","212051U1"]
[18,45,"N/A","N/A","N/A",null,18,75.48,"N/A","N/A","N/A",null,null,18,4000,8000,"N/A","N/A",null,null,null,"54' Upgrade 1","212054U1"]
[21,30,49,"N/A","N/A",null,21,51.55,81.67,"N/A","N/A",null,null,21,4000,8000,"N/A","N/A",null,null,null,"30' Upgrade 2","212030U2"]
[24,21,40,"N/A","N/A",null,24,36.58,67.84,"N/A","N/A",null,null,24,4000,8000,"N/A","N/A",null,null,null,"30' EasyDry Upgrade 2","212030U2-ED"]
[27,24,39,"N/A","N/A",null,27,40.56,65.17,"N/A","N/A",null,null,27,5000,10000,"N/A","N/A",null,null,null,"33' Upgrade 2","212033U2"]
[30,20,32,40,"N/A",null,30,34.58,53.53,67.17,"N/A",null,null,30,5000,10000,"N/A","N/A",null,null,null,"36' Upgrade 2","212036U2"]
[33,23,33,44,"N/A",null,33,39.909999999999997,56.53,73.819999999999993,"N/A",null,null,33,5000,10000,"N/A","N/A",null,null,null,"36' EasyDry Upgrade 2","212036U2-ED"]
[36,24,30,38,"N/A",null,36,41.23,51.55,64.849999999999994,"N/A",null,null,36,5000,10000,"N/A","N/A",null,null,null,"39' Upgrade 2","212039U2"]
[39,22,27,36,"N/A",null,39,37.24,45.22,61.52,"N/A",null,null,39,5000,10000,"N/A","N/A",null,null,null,"42' Upgrade 2","212042U2"]
[42,19,24,34,"N/A",null,42,33.26,41.57,58.2,"N/A",null,null,42,5000,10000,"N/A","N/A",null,null,null,"45' Upgrade 2","212045U2"]
[45,16,23,32,"N/A",null,45,28.27,39.909999999999997,53.87,"N/A",null,null,45,5000,10000,"N/A","N/A",null,null,null,"48' Upgrade 2","212048U2"]
[48,21,26,33,39,null,48,35.9,44.23,55.53,73.16,null,null,48,5000,10000,20000,60000,null,null,null,"48' Structural Roof",212598]
[51,20,28,39,"N/A",null,51,34.25,48.22,73.16,"N/A",null,null,51,8000,12000,20000,60000,null,null,null,"51' Structural Roof",212599]
[54,17,27,39,"N/A",null,54,29.93,46.26,73.16,"N/A",null,null,54,8000,12000,20000,60000,null,null,null,"54' Structural Roof",212610]
[60,39,"N/A","N/A","N/A",null,60,73.16,"N/A","N/A","N/A",null,null,60,"N/A","N/A",20000,60000]
[]
["(Rs, psf) Max Roof Snow Load @ Upgraded Peak Load",null,null,null,null,null,"(U, psf) Ultimate FEA Roof Snow Load Capacities\n@ Upgraded Peak Load"]
["DIAMETER","STD","UP1","UP2","UP3",null,"DIAMETER","STD","UP1","UP2","UP3"]
[15,29,"N/A","N/A","N/A",null,15,58.91,"N/A","N/A","N/A",null,null,null,"Rs*Rlf*Sif <= U*Rfs","- this can be rearranged to give the maximum roof snow load capacity of the roof: Rs = U*Rfs/(Rlf*Sif)"]
[16,29,"N/A","N/A","N/A",null,16,58.91,"N/A","N/A","N/A",null,null,null,null,"Rs = "," the maximum roof snow load capacity of the roof"]
[18,29,"N/A","N/A","N/A",null,18,58.91,"N/A","N/A","N/A",null,null,null,null,"U = "," the ultimate roof snow load capacity as found by our FEA models"]
[21,24,40,"N/A","N/A",null,21,49.55,81.8,"N/A","N/A",null,null,null,0.9,"= Rfs = "," the roof steel resistance factor.  We use 0.9 following CSA S136"]
[24,17,27,"N/A","N/A",null,24,34.92,55.54,"N/A","N/A",null,null,null,1.5,"= Rlf = "," the roof snow load factor.  We use 1.5 as per NBCC 2015 load combination 3"]
[27,19,28,"N/A","N/A",null,27,38.24,56.53,"N/A","N/A",null,null,null,0.8,"= Sif = "," the snow load importance factor (Occupancy).  We use 0.8 as per NBCC 4.1.6.2"]
[30,15,24,33,"N/A",null,30,31.26,48.17,67.84,"N/A"]
[33,18,24,36,"N/A",null,33,37.909999999999997,48.22,72.78,"N/A"]
[36,18,23,31,"N/A",null,36,36.9,46.38,63.19,"N/A"]
[39,16,21,30,"N/A",null,39,33.51,42.9,60.52,"N/A"]
[42,14,19,27,"N/A",null,42,29.93,39.909999999999997,55.29,"N/A"]
[45,13,18,25,"N/A",null,45,26.27,36.58,50.54,"N/A"]
[48,16,21,26,38,null,48,33.26,42.9,52.54,71.5]
[51,14,21,38,"N/A",null,51,29.93,43.32,71.5,"N/A"]
[54,13,20,38,"N/A",null,54,26.27,40.9,71.5,"N/A"]
[60,38,"N/A","N/A","N/A",null,60,71.5,"N/A","N/A","N/A"]
[]
["Left Over Roof Snow Load @ Standard Peak Load With:\nRS = U*Rfs/(Rlf*Sif)-RSL"]
[]
["Rib Caps",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,{"$f":"B28-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A","N/A"]
[null,16,{"$error":"#VALUE!"},"N/A","N/A",{"$f":"M70","v":0}]
[null,18,{"$error":"#VALUE!"},"N/A","N/A","N/A"]
[null,21,{"$error":"#VALUE!"},{"$f":"C31-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A"]
[null,24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"D34-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,45,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,60,"N/A","N/A","N/A","N/A"]
[]
["Hanging Bracket Support System",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,"N/A","N/A","N/A","N/A"]
[null,16,"N/A","N/A","N/A","N/A"]
[null,18,"N/A","N/A","N/A","N/A"]
[null,21,"N/A","N/A","N/A","N/A"]
[null,24,"N/A","N/A","N/A","N/A"]
[null,27,"N/A","N/A","N/A","N/A"]
[null,30,"N/A","N/A","N/A","N/A"]
[null,33,"N/A","N/A","N/A","N/A"]
[null,36,"N/A","N/A","N/A","N/A"]
[null,39,"N/A","N/A","N/A","N/A"]
[null,42,"N/A","N/A","N/A","N/A"]
[null,45,"N/A","N/A","N/A","N/A"]
[null,48,"N/A","N/A","N/A",{"$f":"E40-RSL","v":{"$error":"#VALUE!"}}]
[null,51,"N/A","N/A",{"$f":"D41-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,54,"N/A","N/A",{"$f":"D42-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,60,{"$f":"B43-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A","N/A"]
[]
["Left Over Roof Snow Load @ Upgraded Peak Load With:\nRS = U*Rfs/(Rlf*Sif)-RSL"]
[]
["Rib Caps",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,{"$f":"B47-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A","N/A"]
[null,16,{"$error":"#VALUE!"},"N/A","N/A","N/A"]
[null,18,{"$error":"#VALUE!"},"N/A","N/A","N/A"]
[null,21,{"$error":"#VALUE!"},{"$f":"C50-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A"]
[null,24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"D53-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,45,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A"]
[null,51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"N/A","N/A"]
[null,60,"N/A","N/A","N/A","N/A"]
[]
["Hanging Bracket Support System",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,"N/A","N/A","N/A","N/A"]
[null,16,"N/A","N/A","N/A","N/A"]
[null,18,"N/A","N/A","N/A","N/A"]
[null,21,"N/A","N/A","N/A","N/A"]
[null,24,"N/A","N/A","N/A","N/A"]
[null,27,"N/A","N/A","N/A","N/A"]
[null,30,"N/A","N/A","N/A","N/A"]
[null,33,"N/A","N/A","N/A","N/A"]
[null,36,"N/A","N/A","N/A","N/A"]
[null,39,"N/A","N/A","N/A","N/A"]
[null,42,"N/A","N/A","N/A","N/A"]
[null,45,"N/A","N/A","N/A","N/A"]
[null,48,"N/A","N/A","N/A",{"$f":"E59-RSL","v":{"$error":"#VALUE!"}}]
[null,51,"N/A","N/A",{"$f":"D60-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,54,"N/A","N/A",{"$f":"D61-RSL","v":{"$error":"#VALUE!"}},"N/A"]
[null,60,{"$f":"B62-RSL","v":{"$error":"#VALUE!"}},"N/A","N/A","N/A"]

{"sheet":"Revision Notes","index":5,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,0,2,0],[3,0,4,0],[5,0,10,0],[11,0,16,0],[17,0,20,0]]}
["Version Number","Details"]
[1.1000000000000001,"- Updating version number to match Westeel Roof Tool - Canada upon release."]
[null,"- Changed code so print area was set better."]
[1.2,"- Updating version number to match Westeel Roof Tool - Canada upon release."]
[null,"- Changed code so print area was set better."]
[1.3,"- Changed main page to not show any results until all mandatory fields are filled in."]
[null,"- Updated 21' and 24' Upgrade 1 roof capacities."]
[null,"- Changed wording on Westeel hopper availability."]
[null,"- Updated logic for choosing the 42'-54' - 4-rib bracket system."]
[null,"- Updated equations for choosing hangar brackets and tri-pod systems to better reflect logic statements."]
[null,"- Added in Westeel EasyDry SGL Fan Inlet and DBL Fan Inlet bin type options."]
["2.0","- Changed all Guardian naming to SureTrack."]
[null,"- Non-structural roofs that will receive monitoring cables will now be supplied with Rib Caps. Rib Caps will take all of the cable load, therefore the cable load will no longer affect Roof Upgrades by reducing the capacity of the roof."]
[null,"- Main tab will now show how much Peak Load is available if a Central Monitoring Cable is installed in the bin."]
[null,"- Removed Unstiffened SSK offering, and updated Stiffened SSK offering."]
[null,"- The calculation to determine the cable length in Flat Bottom Bins has changed from a clearance of 3' to 2' to match SureTrack's worst case scenario."]
[null,"- Important notes updated to reflect change to SureTrack offering."]
["3.0","- Updated Remaing Peak Load to correctly read Unknown Peak Load Type rating as the Higher Rated Peak Load Type rating."]
[null,"- Changed all Westeel and SureTrack naming to AGI Westeel and AGI SureTrack."]
[null,"- Added Quick Notes and Instructions & Training tabs."]
[null,"- Changed Main tab logo from AGI Westeel to AGI."]
[4,"- Updated Stiffened AGI Westeel Hopper to include 2710 & 2712, 3004-10, and 3304-10 models (ECR A8635)"]

{"sheet":"Other","index":6,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":true,"merged":[[2,1,2,10],[3,1,5,1],[3,2,5,2],[3,3,5,4],[3,5,5,6],[3,7,5,8],[3,9,5,10],[7,2,10,2],[11,2,18,2],[14,9,20,10],[19,2,20,2],[19,7,20,8],[7,5,8,6],[7,7,11,8],[7,9,12,10]]}
[]
[null,"Non-Structural Roof Capacity Chart:"]
[null,"Maximum Roof Snow Load @ Standard Peak Load"]
[null,"Bin Series","Standard Peak Load","Standard Roof",null,"Upgrade 1",null,"Upgrade 2",null,"Upgrade 3"]
[]
[]
[null,null,"lbs (kN)","psf","kPa","psf","kPa","psf","kPa","psf","kPa",null,null,"Bin Series","R","H","L","3 rad cbl","+4 rad cbl",null,null,null,null,"Bin Series"]
[null,15,"4000 (17.8)",49,2.35,"n/a",null,"n/a",null,"n/a",null,null,null,24,{"$f":"N8/2/COS(RADIANS(30))","v":13.856406460551018},{"$f":"N8/2*TAN(RADIANS(30))","v":6.9282032302755088},{"$f":"O8/2","v":6.9282032302755088},{"$f":"N8/2/2","v":6},null,{"$f":"Q8*COS(RADIANS(30))","v":6},{"$f":"T8*12","v":72},null,null,24]
[null,18,null,49,2.35,null,null,null,null,null,null,null,null,27,15.588457268119894,{"$f":"N9/2*TAN(RADIANS(30))","v":7.7942286340599471},{"$f":"O9/2","v":7.7942286340599471},{"$f":"N9/2/2","v":6.75},null,6.75,{"$f":"T9*12","v":81},null,null,27]
[null,21,null,33,1.58,50,2.39,null,null,null,null,null,null,30,17.320508075688771,8.6602540378443855,8.6602540378443855,7.5,null,7.5,90,null,null,30]
[null,24,null,23,1.1000000000000001,36,1.72,null,null,null,null,null,null,33,19.05255888325765,9.5262794416288248,9.5262794416288248,8.25,null,8.25,99,null,null,33]
[null,27,"5000 (22.2)",26,1.24,42,2.0099999999999998,null,null,null,null,null,null,36,20.784609690826525,10.392304845413264,{"$f":"O12/3","v":6.9282032302755079},null,{"$f":"N12/2/3","v":6},{"$f":"Q12*COS(RADIANS(30))","v":5.9999999999999991},71.999999999999986,{"$f":"N12*12/2-U12","v":144},{"$f":"V12/12","v":12},36]
[null,30,null,22,1.05,34,1.63,43,2.06,null,null,null,null,39,22.516660498395403,11.258330249197702,{"$f":"O13/3","v":7.5055534994651341},null,{"$f":"N13/2/3","v":6.5},{"$f":"Q13*COS(RADIANS(30))","v":6.5},78,{"$f":"N13*12/2-U13","v":156},{"$f":"V13/12","v":13},39]
[null,33,null,16,0.77,26,1.24,36,1.72,47,2.25,null,null,42,24.248711305964282,12.124355652982141,8.0829037686547611,null,7,7.0000000000000009,84.000000000000014,168,14,42]
[null,36,null,26,1.24,33,1.58,42,2.0099999999999998,"n/a",null,null,null,45,25.980762113533157,12.990381056766578,8.6602540378443855,null,7.5,7.5,90,180,15,45]
[null,39,null,24,1.1499999999999999,29,1.39,39,1.87,null,null,null,null,48,27.712812921102035,13.856406460551018,9.2376043070340117,null,8,8,96,192,16,48]
[null,42,null,21,1.01,27,1.29,37,1.77,null,null,null,null,51,29.444863728670914,14.722431864335457,9.8149545762236379,null,8.5,8.5,102,204,17,51]
[null,45,null,18,0.86,26,1.24,35,1.68,null,null,null,null,54,31.176914536239789,15.588457268119894,10.392304845413262,null,9,9,108,216,18,54]
[null,48,null,23,1.1000000000000001,28,1.34,36,1.72]
[null,51,"8000 (35.6)",22,1.05,31,1.48,"n/a",null,null,null,null,null,"Guardian"]
[null,54,null,19,0.91,30,1.44,null,null,null,null,null,null,"Diameter","centre","radius 1","radius 2","radius 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"3 @ 7.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,"3 @ 7.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"3 @ 7.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,"3 @ 8.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,1,"3 @ 9.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,1,"3 @ 11.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,42,1,"4 @ 14.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,1,"4 @ 15.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,1,"5 @ 16.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,51,1,"6 @ 16.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,54,1,"6 @ 18.67 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,60,1,"7 @ 20.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,"3 @ 10.00 ft","8 @ 25.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,"4 @ 10.00 ft","9 @ 27.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,"4 @ 10.00 ft","10 @ 28.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,78,null,"4 @ 10.00 ft","10 @ 29.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,84,1,"5 @ 16.00 ft","10 @ 32.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,90,1,"6 @ 18.00 ft","12 @ 36.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,96,null,"3 @ 10.00 ft","8 @ 23.83 ft","12 @ 40.17 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,102,null,"3 @ 10.00 ft","8 @ 25.83 ft","17 @ 43.17 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,105,null,"3 @ 9.00 ft","9 @ 26.50 ft","16 @ 44.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,108,null,"3 @ 9.00 ft","9 @ 27.00 ft","18 @ 45.00 ft"]