{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Curve Calculator","Circle Formulas","Limitations"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":0,"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":"Curve Calculator","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,6,15,10],[1,6,1,9],[24,6,24,7],[3,1,3,2],[9,1,9,2],[1,1,1,2],[2,8,2,9],[2,6,2,7],[15,2,15,3]]}
[]
[null,"Instructions:\n1. Make sure to enable macros by selecting  \"Enable Content\" when a prompt pops up (if the prompt was accidentally closed, reopen the excel file)\n2. Select the known dimensions from the drop down options (yellow cell)\n3. Enter the known dimensions under inputs (green cells)",null,null,null,null,"LIMITATIONS \nIf the radius is below the stated values, contact wpgquotes@priceindustries.com and provide a full linestring and dimensions (Radius and Arc/Chord length) of the curved product."]
["Angle (A) & Arc Length (L)","Known Dimensions","Angle (A) & Rise (S)",null,null,null,null,null,"Min. Radius"]
["Angle (A) & Radius (R) "," Inputs",null,"Units",null,null,"Slot Width","No. Slots","EF Frame","CMF Frame"]
["Angle (A) & Chord Length (C) ","Angle",30,"degree",null,null,"1\"",1,"60\"","112\""]
["Angle (A) & Rise (S)","Arc Length",null,"inches",null,null,"1\"",2,"60\"","112\""]
["Arc Length (L) & Radius (R) ","Chord Length",null,"inches",null,null,"1 1/2\"",1,"60\"","144\""]
["Radius (R) & Chord Length (C) ","Radius",null,"inches",null,null,"1 1/2\"",2,"84\"","144\""]
["Radius (R) & Rise (S)","Rise",4.18,"inches",null,null,"2\"",1,"156\"","385\""]
["Chord Length (C)  & Rise (S)"," Outputs",null,"Units",null,null,"2\"",2,"312\"","385\""]
[null,"Angle",{"$f":"'Circle Formulas'!L19","v":30},"degree",null,null,"2 1/2\"",1,"360\"","Special Quote Required"]
[null,"Arc Length",{"$f":"'Circle Formulas'!H19","v":64.231722845819931},"inches",null,null,"2 1/2\"",2,"1000\"","Special Quote Required"]
[null,"Chord Length",{"$f":"'Circle Formulas'!J19","v":63.50050438238226},"inches",null,null,"3\"",1,"576\"","Special Quote Required"]
[null,"Radius",{"$f":"'Circle Formulas'!I19","v":122.6735543306504},"inches",null,null,"3\"",2,"1625\"","Special Quote Required"]
[null,"Rise",{"$f":"'Circle Formulas'!K19","v":4.18},"inches"]
[]
[null,null,null,null,null,null,"Slot Width","No. Slots","Model","Nom. Duct Width","Min. Radius \n(inside edge)"]
[null,null,null,null,null,null,"1/2\"",1,"SDS50","2\"","72\""]
[null,null,null,null,null,null,"1/2\"",2,"SDS50","3 1/4\"","72\""]
[null,null,null,null,null,null,"3/4\"",1,"SDS75","2 1/4\"","72\""]
[null,null,null,null,null,null,"3/4\"",2,"SDS75","3 3/4\"","72\""]
[null,null,null,null,null,null,"1\"",1,"SDS100","2 1/2\"","72\""]
[null,null,null,null,null,null,"1\"",2,"SDS100","4 1/4\"","72\""]
[]
[]
[null,null,null,null,null,null,"Nom. Duct Width ","Min. Radius \n(inside edge)"]
[null,null,null,null,null,null,"2\" to 24\"","48\""]

{"sheet":"Circle Formulas","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Inputs",null,null,null,null,null,"Error Message","Outputs"]
[null,null,null,null,null,null,null,"Arc Length","Radius","Chord Length","Rise","Angle"]
["Angle",{"$f":"'Curve Calculator'!$C$5","v":30},"in","Arc Length ",{"$f":"'Curve Calculator'!$C$6","v":0},"in",null,{"$f":"E3","v":0},{"$f":"IF(OR($B$3=0,$E$3=0),0,(180*E3)/(PI()*B3))","v":0},{"$f":"IF(OR($B$3=0,$E$3=0),0,((360*E3)/(PI()*B3))*SIN(B3*(PI()/180)/2))","v":0},{"$f":"IF(OR($B$3=0,$E$3=0),0,((360*E3)/(PI()*B3))*(SIN(B3*(PI()/180)/4))^2)","v":0},{"$f":"B3","v":30}]
[]
["Angle",{"$f":"'Curve Calculator'!$C$5","v":30},"in","Radius  ",{"$f":"'Curve Calculator'!$C$8","v":0},"in",null,{"$f":"IF(OR($B$5=0,$E$5=0),0,(PI()*E5*B5)/180)","v":0},{"$f":"E5","v":0},{"$f":"IF(OR($B$5=0,$E$5=0),0,2*E5*SIN((B5*PI()/180)/2))","v":0},{"$f":"IF(OR($B$5=0,$E$5=0),0,2*E5*(SIN((B5*PI()/180)/4))^2)","v":0},{"$f":"B5","v":30}]
[]
["Angle",{"$f":"'Curve Calculator'!$C$5","v":30},"in","Chord Length  ",{"$f":"'Curve Calculator'!$C$7","v":0},"in",null,{"$f":"IF(OR($B$7=0,$E$7=0),0,(PI()*E7*B7)/(360*SIN((B7*(PI()/180))/2)))","v":0},{"$f":"IF(OR($B$7=0,$E$7=0),0,E7/(2*SIN(B7*(PI()/180)/2)))","v":0},{"$f":"E7","v":0},{"$f":"IF(OR($B$7=0,$E$7=0),0,(E7/2)*TAN((B7*(PI()/180))/4))","v":0},{"$f":"B7","v":30}]
[]
["Angle",{"$f":"'Curve Calculator'!$C$5","v":30},"in","Rise ",{"$f":"'Curve Calculator'!$C$9","v":4.18},"in",null,{"$f":"IF(OR($B$9=0,$E$9=0),0,(PI()*B9*E9)/(360*(SIN((B9*(PI()/180))/4))^2))","v":64.231722845819931},{"$f":"IF(OR($B$9=0,$E$9=0),0,E9/(2*(SIN((B9*PI()/180)/4))^2))","v":122.6735543306504},{"$f":"IF(OR($B$9=0,$E$9=0),0,(2*E9)/(TAN(B9*(PI()/180)/4)))","v":63.50050438238226},{"$f":"E9","v":4.18},{"$f":"B9","v":30}]
[]
["Arc Length",{"$f":"'Curve Calculator'!$C$6","v":0},"in","Radius  ",{"$f":"'Curve Calculator'!$C$8","v":0},"in",null,{"$f":"B11","v":0},{"$f":"E11","v":0},{"$f":"IF(OR($B$11=0,$E$11=0),0,2*E11*SIN(B11/(2*E11)))","v":0},{"$f":"IF(OR($B$11=0,$E$11=0),0,2*E11*(SIN(B11/(4*E11)))^2)","v":0},{"$f":"IF(OR($B$11=0,$E$11=0),0,180*B11/(PI()*E11))","v":0}]
[]
["Radius  ",{"$f":"'Curve Calculator'!$C$8","v":0},"in","Chord Length ",{"$f":"'Curve Calculator'!$C$7","v":0},"in",null,{"$f":"IF(OR($B$13=0,$E$13=0),0,2*B13*ASIN(E13/(B13*2)))","v":0},{"$f":"B13","v":0},{"$f":"E13","v":0},{"$f":"IF(OR($B$13=0,$E$13=0),0,(E13/2)*TAN(ASIN(E13/(2*B13))/2))","v":0},{"$f":"IF(OR($B$13=0,$E$13=0),0,(360/PI())*ASIN(E13/(2*B13)))","v":0}]
[]
["Radius  ",{"$f":"'Curve Calculator'!$C$8","v":0},"in","Rise ",{"$f":"'Curve Calculator'!$C$9","v":4.18},"in",null,{"$f":"IF(OR($B$15=0,$E$15=0),0,4*B15*ASIN(SQRT(E15/(2*B15))))","v":0},{"$f":"B15","v":0},{"$f":"IF(OR($B$15=0,$E$15=0),0,2*SQRT((2*E15*B15)-E15^2))","v":0},{"$f":"E15","v":4.18},{"$f":"IF(OR($B$15=0,$E$15=0),0,4*ASIN(SQRT(E15/(2*B15)))*180/PI())","v":0}]
[]
["Chord Length  ",{"$f":"'Curve Calculator'!$C$7","v":0},"in","Rise ",{"$f":"'Curve Calculator'!$C$9","v":4.18},"in",null,{"$f":"IF(OR($B$17=0,$E$17=0),0,((4*E17^2+B17^2)/(8*E17))*4*ATAN(2*E17/B17))","v":0},{"$f":"IF(OR($B$17=0,$E$17=0),0,(4*E17^2+B17^2)/(8*E17))","v":0},{"$f":"B17","v":0},{"$f":"E17","v":4.18},{"$f":"IF(OR($B$17=0,$E$17=0),0,4*ATAN(2*E17/B17)*(180/PI()))","v":0}]
[]
[null,null,null,null,null,null,"Outputs",{"$f":"AVERAGEIF(H3:H17,\"<>0\")","v":64.231722845819931},{"$f":"AVERAGEIF(I3:I17,\"<>0\")","v":122.6735543306504},{"$f":"AVERAGEIF(J3:J17,\"<>0\")","v":63.50050438238226},{"$f":"AVERAGEIF(K3:K17,\"<>0\")","v":4.18},{"$f":"AVERAGEIF(L3:L17,\"<>0\")","v":30}]

{"sheet":"Limitations","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
["CF",null,"Min Radius "]
["Slot Width","No. Slots","EF Frame","CMF Frame"]
[1,1,60,112]
[1,2,60,112]
[1.5,1,60,144]
[1.5,2,84,144]
[2,1,156,385]
[2,2,312,385]
[2.5,1,360,"Special Quote"]
[2.5,2,1000,"Special Quote"]
[3,1,576,"Special Quote"]
[3,2,1625,"Special Quote"]
[]
["LBM"]
["Nom Duct Width ","Min Radius (inside edge)"]
["2-24",48]
[]
[]
[]
[]
[]
[]
[]
[]
["SDS"]
["Slot Width","No. Slots","Model","Nom Duct Width","Min. Radius (inside edge)"]
[0.5,1,"SDS50",2,72]
[0.5,2,"SDS50",3.25,72]
[0.75,1,"SDS75",2.25,72]
[0.75,2,"SDS75",3.75,72]
[1,1,"SDS100",2.5,72]
[1,2,"SDS100",4.25,72]
[]
["Potential suggestions\""]
["Add SDSC limits"]
["Include links to curved submittals"]
["Dynamic images"]
["(Dynamic Name Range - Linked Image)"]
["Show image and limits for specific model selection"]
["Highlight selected dimensions"]