{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Table of Contents","Tensioned_Advantage_Deluxe","Advantage_Deluxe","Tensioned_Advantage","Advantage","Tensioned_Contour","Contour","Tensioned_Cosmopolitan","Cosmopolitan","Tensioned_Large_Cosmopolitan","Large Cosmopolitan","Tensioned_Large_Advantage_Delux","Large_Advantage_Deluxe","Tensioned_Large_Advantage","Large_Advantage","Tensioned_Professional","Professional"],"not_rendered":{"charts":0,"images":0,"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":"Table of Contents","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[3,4,3,6],[4,4,4,6],[5,4,5,6],[6,4,6,6],[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[0,0,0,6],[1,0,1,6],[3,0,3,2],[2,0,2,2],[2,4,2,6]]}
["Max Sizes and Hanging Weights"]
["Table of Contents"]
["Tensioned",null,null,null,"Non-Tensioned"]
["Tensioned Advantage® (with Closure Door)",null,null,null,"Advantage® (with Closure Door)"]
["Tensioned Advantage ",null,null,null,"Advantage"]
["Tensioned Contour",null,null,null,"Contour Electrol"]
["Tensioned Cosmopolitan",null,null,null,"Cosmopolitan"]
["Tensioned Large Cosmo",null,null,null,"Large Cosmo "]
["Tensioned Advantage (over 14' W with Closure Door)",null,null,null,"Advantage (over 14' W with Closure Door)"]
["Tensioned Advantage (over 16' W)",null,null,null,"Advantage (over 16’ W)"]
["Tensioned Professional",null,null,null,"Professional"]

{"sheet":"Tensioned_Advantage_Deluxe","index":1,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,1],[37,7,37,8],[38,7,38,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[26,7,26,8],[28,7,28,8],[27,7,27,8],[29,7,29,8],[33,7,33,8],[34,7,34,8],[36,7,36,8],[30,7,30,8],[13,0,13,1],[6,0,8,0],[31,7,31,8],[32,7,32,8],[25,7,25,8],[1,3,1,4],[1,5,1,12]]}
["Tensioned Advantage® (with Closure Door)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",12,"inches",30.5,"cm"]
["Enter Bottom Black Drop:",2,"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15<=192,B16<=172.5,B15>=25,B16>=36.5),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(OR(B11=\"Not Feasible\",B12=\"TOO MUCH TOP BLACK DROP\",B13=\"TOO MUCH BTM BLACK DROP\"),\"Not Feasible\",(IF(OR(B11=\"SELECT FABRIC\",B12=\"SELECT FABRIC\",B13=\"SELECT FABRIC\"),\"SELECT FABRIC\",ROUNDUP(J37,0)&\" LBS / \"&ROUNDUP(J37*0.453592,0)&\" KG\"))))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5+B6","v":14}]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",B60,\"\")))","v":2.25}]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J22+(J25*2))*(J23+J24+25)/144)","v":1.21875}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Fabric",null,{"$f":"((J26*2.5)/16)","v":0.1904296875}]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,"Weight of Slat",null,{"$f":"((J22+(J25*2)+0.5)/12)*(0.69)","v":0.28749999999999998}]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Case",null,{"$f":"(((J22+(J25*2)+15)/12)*6.2)","v":10.075000000000001}]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,"Weight of Roller",null,{"$f":"((J22+(J25*2)+4.25)/12)*1.7","v":1.2395833333333333}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Miscellanous Items",null,22]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m",null,null,null,null,"Weight of Access Door",null,{"$f":"((J22+(J25*2)+14.88) / 12) * 0.7707","v":1.2446805000000003}]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m",null,null,null,null,"Weight of Fabric Door",null,{"$f":"((J22+(J25*2)+14.88) / 12) * 0.7224","v":1.1666760000000003}]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577}]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J27:J35)","v":36.203869520833337}]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75}]
["r",1175]
["n",{"$f":"B52 * B52","v":162.5625}]
["P",{"$f":"B53*B53","v":1380625}]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869}]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2}]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2}]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Advantage_Deluxe","index":2,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[25,7,25,8],[30,7,30,8],[31,7,31,8],[29,7,29,8],[23,7,23,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[0,0,0,1],[21,7,21,8],[20,7,20,8],[19,7,19,8],[24,7,24,8],[22,7,22,8],[1,3,1,4],[1,5,1,14]]}
["Advantage® (with Closure Door)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13<=156,B14<=164,B6<=6,B13>=25,B14>=39.5),\"Feasible\",\"Not Feasible\"))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13<=156,B14<=164,B6<=6,B13>=25,B14>=39.5),ROUNDUP(J36,0)&\" LBS / \"&ROUNDUP(J36*0.453592,0)&\" KG\",\"Not Feasible\"))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":1.7835542217881084E-3},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":1.7835542217881084E-3},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5","v":2}]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"B6","v":2}]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":8},null,null,null,null,null,"Enter Amount of Bottom Drop",null,{"$f":"B7","v":0}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J20+(J23*2))*(J21+J22+19+J24)/144)","v":0.58333333333333337}]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":1.0802469135802469E-2},"lbs.",null,null,null,null,"Weight of Fabric",null,{"$f":"((J25*2.5)/16)","v":9.1145833333333343E-2}]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Slat",null,{"$f":"((J20+(J23*2)+0.5)/12)*0.3565","v":0.13368749999999999}]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.32870509259259262},"lbs.",null,null,null,null,"Weight of Case",null,{"$f":"(((J20+(J23*2)+12)/12)*6.2)","v":8.2666666666666657}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Weight of Roller",null,{"$f":"((J20+(J23*2)+1.25)/12)*2.16","v":0.94500000000000006}]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":6.1540249898911312E-2},"N/m",null,null,null,null,"Miscellanous Items",null,20]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,"Weight of Access Door",null,{"$f":"((J20+(J23*2)+11.88) / 12) * 0.7707","v":1.0198930000000002}]
[null,null,null,null,null,null,null,"Weight of Fabric Door",null,{"$f":"((J20+(J23*2)+11.88) / 12) * 0.7224","v":0.95597600000000016}]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.7509756106846908}]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75097561068469076}]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J26:J34)","v":31.412368999999998}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":11}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":1.4853395061728395E-2},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.43874606481481487},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":8.2142148324829786E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B13*0.75","v":1.5}]
["r",1175]
["n",{"$f":"B50 * B50","v":2.25}]
["P",{"$f":"B51*B51","v":1380625}]
["s",{"$f":"SQRT(B53-B52)","v":1174.9990425528015}]
[null,{"$f":"B51-B54","v":9.5744719851609261E-4}]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":9.5744719851609261E-4}]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":8}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":1.0802469135802469E-2},"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.32870509259259262},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":6.1540249898911312E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":-4}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":0.14115077617808514},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":-4.0509259259259266E-3},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":0.14395484276476717},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Advantage","index":3,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[28,6,28,8],[1,3,1,4],[29,6,29,8],[30,6,30,8],[25,6,25,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[1,10,1,14],[6,0,8,0],[0,0,0,1],[27,6,27,8],[26,6,26,8],[1,0,1,1],[13,0,13,1]]}
["TENSIONED ADVANTAGE"]
[null,null,null,"Centimeters",null,null,null,null,null,null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",12,"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(F8=0,\"SELECT FABRIC\",IF(AND(B15>=25,B15<=192,B16>=36.5,B16<=174),\"Feasible\",IF(AND(B16<=205,B16>174,B15<=137),\"Feasible\",\"Not Feasible\"))))","v":"Enter VA"}]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(F8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(OR(B11=\"Not Feasible\",B12=\"TOO MUCH TOP BLACK DROP\",B13=\"TOO MUCH BTM BLACK DROP\"),\"Not Feasible\",(IF(OR(B11=\"SELECT FABRIC\",B12=\"SELECT FABRIC\",B13=\"SELECT FABRIC\"),\"SELECT FABRIC\",ROUNDUP(J37,0)&\" LBS / \"&ROUNDUP(J37*0.453592,0)&\" KG\"))))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(F8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(F3=\"Small_Curve\",B25,IF(F3=\"Medium_Curve\",B40,IF(F3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,"FORMULAS","DIMENSIONS"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,"Enter Viewing Area Width",null,null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,"Enter Viewing Area Height",null,null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,"Enter Amount Black Drop",null,null,{"$f":"B5+B6","v":14}]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,"Enter Amount of Side Border",null,null,{"$f":"IF(F3=\"Small_Curve\",B24,IF(F3=\"Medium_Curve\",B39,IF(F3=\"Large_Curve\",B60,\"\")))","v":2.25}]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((J22+(J25*2))*(J23+J24+21+4.5)/144)","v":1.234375}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,"Weight of Fabric",null,null,{"$f":"((J26*2.5)/16)","v":0.19287109375}]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,"Weight of Slat",null,null,{"$f":"((J22+0.5+(J25*2))/12)*0.693856479","v":0.28910686625000004}]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,"(0.806 / lbs. ft.)","Weight of Case",null,null,{"$f":"(((J22+(J25*2)+8.5)/12)*4.5674)","v":4.9480166666666667}]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,"Weight of Roller",null,null,{"$f":"((J22+(J25*2)+2)/12)*1.7","v":0.92083333333333328}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,"Miscellanous Items",null,null,15.55]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m",null,null,null,null,"Weight of Door",null,{"$f":"((J22+(J25*2)+8)/12)*0.56","v":0.58333333333333348}]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577}]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J27:J31)*1.05","v":22.995869358}]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75}]
["r",1175]
["n",{"$f":"B52 * B52","v":162.5625}]
["P",{"$f":"B53*B53","v":1380625}]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869}]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2}]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2}]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(F8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(F8=1,48,24)","v":24}]

{"sheet":"Advantage","index":4,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,5,1,14],[0,0,0,1],[29,7,29,8],[30,7,30,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[1,3,1,4]]}
["ADVANTAGE"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",2,"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13<=168,B13>=25,B14>=39.5,B14<=164,B6<=6),\"Feasible\",IF(AND(B13<=132,B14<=196,B14>=168,B6<=6),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(A9=\"Feasible\",ROUNDUP(J37,0)&\" LBS / \"&ROUNDUP(J37*0.453592,0)&\" KG\",IF(A9=\"Enter VA\",\"Enter VA\",\"Not Feasible\"))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":1.7835542217881084E-3},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":1.7835542217881084E-3},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5","v":2}]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"B6","v":2}]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":8},null,null,null,null,null,"Enter Amount of Bottom Drop",null,{"$f":"B7","v":0}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J20+(J23*2))*(J21+J22+19+J24)/144)","v":0.58333333333333337}]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":1.0802469135802469E-2},"lbs.",null,null,null,null,"Weight of Fabric",null,{"$f":"((J25*2)/16)","v":7.2916666666666671E-2}]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Slat",null,{"$f":"((J20+(J23*2)+0.5)/12)*(0.36)","v":0.13500000000000001}]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.32870509259259262},"lbs.",null,null,null,null,"Weight of Case",null,{"$f":"((J20+(J23*2)+5.25)/12)*4.4","v":3.3916666666666671}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Weight of Door",null,{"$f":"((J20+(J23*2)+5)/12)*0.56","v":0.42000000000000004}]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":6.1540249898911312E-2},"N/m",null,null,null,null,"Weight of Roller",null,{"$f":"((J20+(J23*2)+1.25)/12)*2","v":0.875}]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,"Miscellanous Items",null,15]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.7509756106846908}]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75097561068469076}]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J26:J35)*1.05","v":20.889312499999999}]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":11}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":1.4853395061728395E-2},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.43874606481481487},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":8.2142148324829786E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B13*0.75","v":1.5}]
["r",1175]
["n",{"$f":"B50 * B50","v":2.25}]
["P",{"$f":"B51*B51","v":1380625}]
["s",{"$f":"SQRT(B53-B52)","v":1174.9990425528015}]
[null,{"$f":"B51-B54","v":9.5744719851609261E-4}]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":9.5744719851609261E-4}]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":8}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":1.0802469135802469E-2},"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.32870509259259262},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":6.1540249898911312E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":-4}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":0.14115077617808514},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":-4.0509259259259266E-3},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":0.14395484276476717},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Contour","index":5,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[6,0,8,0],[0,0,0,1],[24,7,24,8],[26,7,26,8],[28,7,28,8],[1,3,1,4],[1,5,1,12],[13,0,13,1],[35,7,35,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[25,7,25,8],[27,7,27,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8]]}
["TENSIONED CONTOUR ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":12},"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>25,B16>=39.5,B15<=168,B16<=174),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>25,B16>=39.5,B15<=168,B16<=174),ROUNDUP(J36,0)&\" LBS / \"&ROUNDUP(J36*0.453592,0)&\" KG\",\"Not Feasible\")))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5+B6","v":14}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",B60,\"\")))","v":2.25}]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J21+(J24*2))*(J22+J23+25+15)/144)","v":1.6875}]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,"Weight of Fabric",null,{"$f":"((J25*2)/16)","v":0.2109375}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Slat",null,{"$f":"((J21+(J24*2))/12)*(0.69+0.141)","v":0.31162499999999999}]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,"Weight of Case",null,{"$f":"(((J21+(J24*2)+11.75)/12)*2.43)","v":3.2906250000000004}]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Roller",null,{"$f":"((J21+(J24*2)+4.25)/12)*2.16","v":1.575}]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,"Miscellanous Items",null,10]
["Roller Diameter",{"$f":"3.25","v":3.25}]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m"]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J26:J34)","v":15.388187500000001}]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769}]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75}]
["r",1175]
["n",{"$f":"B52 * B52","v":162.5625}]
["P",{"$f":"B53*B53","v":1380625}]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869}]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2}]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2}]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Contour","index":6,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[30,7,30,8],[31,7,31,8],[32,7,32,8],[34,7,34,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[23,7,23,8],[0,0,0,1],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[1,3,1,4],[1,5,1,12],[1,0,1,1]]}
["CONTOUR ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13>25,B14>39.5,B13<=168,B14<=164,B6<=6),\"Feasible\",\"Not Feasible\"))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13>25,B14>39.5,B13<=168,B14<=164,B6<=6),ROUNDUP(J35,0)&\" LBS / \"&ROUNDUP(J35*0.453592,0)&\" KG\",\"Not Feasible\"))","v":"Enter VA"}]
[]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":1.7835542217881084E-3},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":1.7835542217881084E-3},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5+B7","v":2}]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"B6","v":2}]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":8},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J20+(J23*2))*(J21+J22+32)/144)","v":0.94444444444444442}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Fabric",null,{"$f":"((J24*2)/16)","v":0.11805555555555555}]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":1.0802469135802469E-2},"lbs.",null,null,null,null,"Weight of Slat",null,{"$f":"((J20+(J23*2)+0.5)/12)*0.3565","v":0.13368749999999999}]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Case",null,{"$f":"(((J20+(J23*2)+11.75)/12)*2.43)","v":3.1893750000000001}]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.32870509259259262},"lbs.",null,null,null,null,"Weight of Roller",null,{"$f":"((J20+(J23*2)+4.25)/12)*2.16","v":1.4850000000000001}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Miscellanous Items",null,10]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":6.1540249898911312E-2},"N/m",null,null,null,null,"Hanger Bracket",null,{"$f":"IF((J20+(J23*2)+11.75) > 152,7.205,IF((J20+(J23*2)+11.75) > 117.75,4.804,2.399))","v":2.399}]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.7509756106846908}]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75097561068469076},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J25:J33)","v":17.325118055555556}]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":11}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":1.4853395061728395E-2},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.43874606481481487},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":8.2142148324829786E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B13*0.75","v":1.5}]
["r",1175]
["n",{"$f":"B50 * B50","v":2.25}]
["P",{"$f":"B51*B51","v":1380625}]
["s",{"$f":"SQRT(B53-B52)","v":1174.9990425528015}]
[null,{"$f":"B51-B54","v":9.5744719851609261E-4}]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":9.5744719851609261E-4}]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":8}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":1.0802469135802469E-2},"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.32870509259259262},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":6.1540249898911312E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":-4}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":0.14115077617808514},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":-4.0509259259259266E-3},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":0.14395484276476717},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]
["Table of Contents"]

{"sheet":"Tensioned_Cosmopolitan","index":7,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[6,0,8,0],[0,0,0,1],[25,8,25,9],[27,8,27,9],[1,3,1,4],[1,5,1,12],[13,0,13,1]]}
["TENSIONED COSMOPOLITAN ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":12},"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15<=144,B16<=154.5,B15>=25,B16>=36.5),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15<=144,B16<=154.5,B15>=25,B16>=36.5),ROUNDUP(K37,0)&\" LBS / \"&ROUNDUP(K37*0.453592,0)&\" KG\",\"Not Feasible\")))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,"FORMULAS","DIMENSIONS"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14}]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",B60,\"\")))","v":2.25}]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K22+(K25*2))*(K23+K24+21+4.5)/144)","v":1.234375}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K26*3)/16)","v":0.2314453125}]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,"Weight of Slat",null,null,{"$f":"((K22+0.5+(K25*2))/12)*(0.693856479)","v":0.28910686625000004}]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Case",null,null,{"$f":"(((K22+(K25*2)+8.5)/12)*1.71)","v":1.8524999999999998}]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,"Weight of Roller",null,null,{"$f":"((K22+(K25*2)+2)/12)*2.16","v":1.17}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Miscellanous Items",null,null,13]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m"]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577}]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K27:K35)","v":16.543052178749999}]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75}]
["r",1175]
["n",{"$f":"B52 * B52","v":162.5625}]
["P",{"$f":"B53*B53","v":1380625}]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869}]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2}]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2}]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Cosmopolitan","index":8,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,1],[27,7,27,8],[28,7,28,8],[29,7,29,8],[20,7,20,8],[19,7,19,8],[23,7,23,8],[25,7,25,8],[21,7,21,8],[22,7,22,8],[24,7,24,8],[26,7,26,8],[1,3,1,4],[1,5,1,14]]}
["COSMOPOLITAN ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13<=156,B14<=144,B6<=6,B13>=25,B14>=39.5),\"Feasible\",\"Not Feasible\"))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B14<=144,B13<=156,B6<=6,B13>=25,B14>=39.5),ROUNDUP(J36,0)&\" LBS / \"&ROUNDUP(J36*0.453592,0)&\" KG\",\"Not Feasible\"))","v":"Enter VA"}]
["Table of Contents"]
["Fabric Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":1.7835542217881084E-3},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":1.7835542217881084E-3},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5","v":2}]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"B6","v":2}]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":8},null,null,null,null,null,"Enter Amount of Bottom Drop",null,{"$f":"B7","v":0}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J20+(J23*2))*(J21+J22+21+4.5)/144)","v":0.76388888888888884}]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":1.0802469135802469E-2},"lbs.",null,null,null,null,"Weight of Fabric",null,{"$f":"((J25*2.5)/16)","v":0.11935763888888888}]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Slat",null,{"$f":"((J20+0.5+(J23*2))/12)*0.3565","v":0.13368749999999999}]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.32870509259259262},"lbs.",null,null,null,null,"Weight of Case",null,{"$f":"(((J20+(J23*2)+8.5)/12)*1.7341046)","v":1.8063589583333335}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Weight of Roller",null,{"$f":"((J20+(J23*2)+2)/12)*2","v":1}]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":6.1540249898911312E-2},"N/m",null,null,null,null,"Miscellanous Items",null,9.27]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.7509756106846908}]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75097561068469076}]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J26:J30)","v":12.329404097222222}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":11}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":1.4853395061728395E-2},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.43874606481481487},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":8.2142148324829786E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B13*0.75","v":1.5}]
["r",1175]
["n",{"$f":"B50 * B50","v":2.25}]
["P",{"$f":"B51*B51","v":1380625}]
["s",{"$f":"SQRT(B53-B52)","v":1174.9990425528015}]
[null,{"$f":"B51-B54","v":9.5744719851609261E-4}]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":9.5744719851609261E-4}]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":8}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":1.0802469135802469E-2},"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.32870509259259262},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":6.1540249898911312E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":-4}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":0.14115077617808514},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":-4.0509259259259266E-3},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":0.14395484276476717},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Large_Cosmopolitan","index":9,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[29,7,29,9],[30,7,30,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[28,7,28,9],[6,0,8,0],[0,0,0,1],[21,7,21,9],[22,7,22,9],[23,7,23,9],[1,3,1,4],[1,5,1,12],[13,0,13,1]]}
["TENSIONED LARGE COSMOPOLITAN ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":12},"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>=60,B16>=99,B15<=192,B16<=211.75),IF(AND(B15>161,B16>192),\"SEE DESIGN CENTER\",\"Feasible\"),\"Not Feasible\")))","v":"Enter VA"}]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>60,B16>99,B15<=192,B5<=B82,B6<=B83,B16<=211.75),ROUNDUP(K37,0)&\" LBS / \"&ROUNDUP(K37*0.453592,0)&\" KG\",\"Not Feasible\")))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,"FORMULAS","DIMENSIONS"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,"Enter Viewing Area Width",null,null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,"Enter Viewing Area Height",null,null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,"Enter Amount Black Drop",null,null,{"$f":"B5+B6","v":14}]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,"Enter Amount of Side Border",null,null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",B60,\"\")))","v":2.25}]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K22+(K25*2))*(K23+K24+31)/144)","v":1.40625}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K26/9) * 32)/16","v":0.3125}]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,"Weight of Slat",null,null,{"$f":"((K22+0.5+(K25*2))/12)*0.9435","v":0.393125}]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Case",null,null,{"$f":"(((K22+(K25*2)+8.5)/12)*1.95791231253)+(((K22+(K25*2)+8.5)/12)*2.5022633719)","v":4.8318569914658331}]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,"Weight of Roller",null,null,{"$f":"((K22+(K25*2)+2)/12)*2.19","v":1.1862499999999998}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Miscellanous Items",null,null,33]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m"]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m"]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577}]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K27:K31)","v":39.723731991465833}]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75}]
["r",1175]
["n",{"$f":"B52 * B52","v":162.5625}]
["P",{"$f":"B53*B53","v":1380625}]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869}]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2}]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2}]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Large Cosmopolitan","index":10,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[31,7,31,8],[32,7,32,8],[33,7,33,8],[0,0,0,1],[1,3,1,4],[1,5,1,14]]}
["LARGE COSMOPOLITAN ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13>60,B14>99,B13<=196.25,B14<=192,B6<=6),\"Feasible\",\"Not Feasible\"))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B13>60,B14>99,B13<=192,B14<=192,B6<=6),ROUNDUP(J34,0)&\" LBS / \"&ROUNDUP((J34*0.453592),0)&\" KG\",\"Not Feasible\"))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":1.7835542217881084E-3},null,null,null,null,null,"DIMENSIONS"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":1.7835542217881084E-3},null,null,null,null,null,"Enter Viewing Area Width",null,{"$f":"B4","v":0}]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Viewing Area Height",null,{"$f":"B3","v":0}]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount Black Drop",null,{"$f":"B5","v":2}]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Enter Amount of Side Border",null,{"$f":"B6","v":2}]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":8},null,null,null,null,null,"Enter Amount of Bottom Drop",null,{"$f":"B7","v":0}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Square Feet of Fabric",null,{"$f":"((J20+(J23*2))*(J21+J22+32+2+J24)/144)","v":1}]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":1.0802469135802469E-2},"lbs.",null,null,null,null,"Weight of Fabric",null,{"$f":"((J25/9) * 32)/16","v":0.22222222222222221}]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Slat",null,{"$f":"((J20+0.5+(J23*2))/12)*0.3565","v":0.13368749999999999}]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.32870509259259262},"lbs.",null,null,null,null,"Weight of Case",null,{"$f":"(((J20+(J23*2)+8.5)/12)*1.95791231253)+(((J20+(J23*2)+8.5)/12)*2.5022633719)","v":4.6460163379479162}]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Weight of Roller",null,{"$f":"((J20+(J23*2)+2)/12)*2.19","v":1.095}]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":6.1540249898911312E-2},"N/m",null,null,null,null,"Miscellanous Items",null,33.65]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,"Weight of Ironing Board",null,{"$f":"((J20+(J23*2))/12)*0.1365","v":4.5499999999999999E-2}]
[]
["**** Equations for Medium Curve Border *******"]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.7509756106846908},null,null,null,null,null,"Total Weight",null,{"$f":"SUM(J26:J32)","v":39.792426060170136}]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75097561068469076}]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75}]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75}]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5}]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":11}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":1.4853395061728395E-2},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.43874606481481487},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":8.2142148324829786E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[]
[]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B13*0.75","v":1.5}]
["r",1175]
["n",{"$f":"B50 * B50","v":2.25}]
["P",{"$f":"B51*B51","v":1380625}]
["s",{"$f":"SQRT(B53-B52)","v":1174.9990425528015}]
[null,{"$f":"B51-B54","v":9.5744719851609261E-4}]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":9.5744719851609261E-4}]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0}]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2}]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4}]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":8}]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2}]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":1.0802469135802469E-2},"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)"]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.32870509259259262},"lbs."]
["Roller_Diameter",3.25]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":6.1540249898911312E-2},"N/m"]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m"]
[]
[]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":-4}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":0.14115077617808514},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":-4.0509259259259266E-3},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":0.14395484276476717},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Large_Advantage_Delux","index":11,"n_rows":83,"n_cols":41,"rows_kept":83,"cut":false,"hidden":false,"merged":[[6,0,8,0],[0,0,0,1],[19,8,19,11],[21,18,21,21],[21,24,21,27],[1,3,1,4],[1,5,1,13],[13,0,13,1],[21,36,21,39],[10,8,10,9],[37,9,37,10],[38,9,38,10],[39,9,39,10],[21,30,21,34],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[24,9,24,10],[26,9,26,10],[28,9,28,10],[30,9,30,10],[31,9,31,10]]}
["Tensioned Advantage (over 14' W with Closure Door)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":12},"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>60,B16>100,B15<=215),IF(B16<=285.75,IF(OR(B15>195,B4>260),\"SEE DESIGN CENTER\",IF(AND(B15>169,B16>192),\"SEE DESIGN CENTER\",\"Feasible\")),\"Not Feasible\"),\"Not Feasible\")))","v":"Enter VA"},null,null,null,null,null,null,"Test Calculations:"]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"},null,null,null,null,null,null,"Roller Diameter:",{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),5.75, 7)","v":5.75}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(OR(B11=\"Not Feasible\",B12=\"TOO MUCH TOP BLACK DROP\",B13=\"TOO MUCH BTM BLACK DROP\"),\"Not Feasible\",ROUNDUP(L40,0)&\" LBS / \"&ROUNDUP(L40*0.453592,0)&\" KG\")))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"},null,null,null,null,null,null,"Roller Asm Parts",{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),AB73,AN73)","v":11.9922}]
["Table of Contents",null,null,null,null,null,null,null,"7\" Roller weight",{"$f":"(((L22+(L26*2))+4.25)/12)*4.02","v":2.9312499999999995}]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17},null,null,null,null,null,null,"5.75\" Roller Weight",{"$f":"(((L22+(L26*2))+4.25)/12)*2.536","v":1.8491666666666666}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,null,"Weight of 5.75\" & 7\" Diameter Roller Screen Calculator"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,null,"FORMULAS","DIMENSIONS"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,null,"5.75\" Roller Assembly Miscellanous Items",null,null,null,null,null,"Closing Door Assembly Miscellanous Items",null,null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,null,null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:"]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14},null,null,null,null,null,null,"EndCap Bolt #35907",1.7000000000000001E-2,8,{"$f":"U24*T24","v":0.13600000000000001},"lbs.",null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"AA24*Z24","v":1.1237999999999999},"lbs.",null,"Door Bracket #23336",0.1207,5,{"$f":"AG24*AF24","v":0.60350000000000004},"lbs.",null,"Roller Hub #95515",1.3221000000000001,1,{"$f":"AM24*AL24","v":1.3221000000000001},"lbs."]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,null,"Enter Bottom Fabric Width","Enter Bottom Fabric Width",null,{"$f":"B4+L26","v":2.25},null,null,null,null,null,null,"EndCap #35885",6.4264000000000001,1,6.4264000000000001,"lbs.",null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AA25*Z25","v":2.8799999999999999E-2},"lbs.",null,"Hex Bolt #24270",8.9800000000000005E-2,5,{"$f":"AG25*AF25","v":0.44900000000000001},"lbs.",null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AM25*AL25","v":2.8799999999999999E-2},"lbs."]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",(B60/1.9),\"\")))","v":2.25},null,null,null,null,null,null,"Stud #6167",7.7000000000000002E-3,6,4.6200000000000005E-2,"lbs.",null,"Mtr Adaptor #81649",4.8445999999999998,1,{"$f":"AA26*Z26","v":4.8445999999999998},"lbs.",null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs.",null,"Mtr Adaptor #88799",5.42,1,{"$f":"AM26*AL26","v":5.42},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((L22+(L26*2))*(L23+L24+28+4.5)/144)","v":1.453125},"sq. ft.",null,null,null,null,null,"Endcap #35883",5.9645000000000001,1,5.9645000000000001,"lbs.",null,"Screen Mtr Asm #39875",5.9950000000000001,1,{"$f":"AA27*Z27","v":5.9950000000000001},"lbs.",null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs.",null,"Screen Mtr Asm #39875",5.5540000000000003,1,{"$f":"AM27*AL27","v":5.5540000000000003},"lbs."]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((L27/9) * 26)/16","v":0.26236979166666669},"lbs.",null,null,null,null,null,"J-Box Cover #35915",0.1406,1,0.1406,"lbs.",null,null,null,null,{"$f":"AA28*Z28","v":0},"lbs.",null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs.",null,null,null,null,{"$f":"AM28*AL28","v":0},"lbs."]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,"Weight of Slat",null,null,{"$f":"((L25+0.5)/12) * 0.9435","v":0.21621874999999999},"lbs.","0.9435 lbs. / ft.",null,null,null,null,"J-Box #35914",0.41520000000000001,1,0.41520000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Door Slide #24269",2.1899999999999999E-2,5,0.1095,"lbs.",null,null,null,null,0,"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,null,"Weight of Case",null,null,{"$f":"(((L22+(L26*2))+17.25)/12)*8.9606","v":16.241087499999999},"lbs.","8.961 lbs. / ft.",null,null,null,null,"Pin End Brkt #35917",2.5829,1,2.5829,"lbs.",null,null,null,null,0,"lbs.",null,"Screw Mach #77459",8.9999999999999993E-3,10,0.09,"lbs.",null,null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,null,"Weight of Roller",null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),(((L22+(L26*2))+4.25)/12)*2.536,(((L22+(L26*2))+4.25)/12)*4.02)","v":1.8491666666666666},"lbs.","2.536 lbs. / ft. or 4.02",null,null,null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Mtr Bracket #35886",0.222,1,0.222,"lbs.",null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m",null,null,null,null,null,"Weight of Access Door",null,null,{"$f":"(((L22+(L26*2))+17)/12)*1.548","v":2.7735000000000003},"lbs.","1.548 lbs. / ft.",null,null,null,null,"Hex Bolt #44731",4.7E-2,2,9.4E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Pin Bracket #35887",0.224,1,0.224,"lbs.",null,null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m",null,null,null,null,null,"Weight of Spring Door",null,null,{"$f":"(((L22+(L26*2))+17)/12)*0.562","v":1.0069166666666669},"lbs.","0.562 lbs. / ft.",null,null,null,null,"Hex Bolt #35905",2.7799999999999998E-2,10,0.27799999999999997,"lbs.",null,null,null,null,0,"lbs.",null,"Screw Mach #87059",5.1000000000000004E-3,15,7.6500000000000012E-2,"lbs.",null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Spring Door Parts / Hardware",null,null,{"$f":"AH73","v":20.490500000000001},"lbs.",null,null,null,null,null,"Bearing #83107",0.2046,1,0.2046,"lbs.",null,null,null,null,0,"lbs.",null,"Square Nut #35903",0.02,1,0.02,"lbs.",null,null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null,"Screen Parts / Hardware",null,null,{"$f":"V73","v":31.420499999999993},"lbs.",null,null,null,null,null,"Square Nut #35903",0.02,9,0.18,"lbs.",null,null,null,null,0,"lbs.",null,"Washer Lock #95073",4.0000000000000001E-3,2,8.0000000000000002E-3,"lbs.",null,null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577},null,null,null,null,null,null,"Roller Asm Parts",null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),AB73,AN73)","v":11.9922},"lbs.",null,null,null,null,null,"LockWasher #95073",4.0000000000000001E-3,10,0.04,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #72537",6.0000000000000001E-3,1,6.0000000000000001E-3,"lbs.",null,null,null,null,0,"lbs."]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,null,null,null,null,null,"lbs.",null,null,null,null,null,"Motor Bracket #35916",3.0455000000000001,1,3.0455000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Door Bracket #11317",4.5100000000000001E-2,1,4.5100000000000001E-2,"lbs.",null,null,null,null,0,"lbs."]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Adaptor Brkt #37866",0.24340000000000001,1,0.24340000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Nut Clinch #11321",1E-3,4,4.0000000000000001E-3,"lbs.",null,null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #38739",3.6799999999999999E-2,2,7.3599999999999999E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Bracket #11316",6.3100000000000003E-2,1,6.3100000000000003E-2,"lbs.",null,null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5},null,null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(L28:L38)*1.05","v":90.565082343749992},null,null,null,null,null,null,"Nylon Lock Nut #44753",1.4E-2,2,2.8000000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #11319",1.9E-3,4,7.6E-3,"lbs.",null,null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35888",0.20039999999999999,2,0.40079999999999999,"lbs.",null,null,null,null,0,"lbs.",null,"Clamp #92301",2.5000000000000001E-3,5,1.2500000000000001E-2,"lbs.",null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #5013",1.46E-2,4,5.8400000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #52703",2.0999999999999999E-3,5,1.0499999999999999E-2,"lbs.",null,null,null,null,0,"lbs."]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J-Box Cover #35906",0.1188,1,0.1188,"lbs.",null,null,null,null,null,null,null,"Pin Hub #80764",2.3199999999999998E-2,1,2.3199999999999998E-2,"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,"Strain Relief #95443",8.9999999999999998E-4,1,8.9999999999999998E-4,"lbs.",null,null,null,null,null,null,null,"Pin Cotter #97290",6.3E-3,1,6.3E-3,"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35889",0.61099999999999999,2,1.222,"lbs.",null,null,null,null,null,null,null,"Tube Steel #32258",10.804500000000001,1,10.804500000000001,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,4,0.188,"lbs.",null,null,null,null,null,null,null,"Alum. Bar #33300",1.2669999999999999,1,1.2669999999999999,"lbs."]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,4,4.24E-2,"lbs.",null,null,null,null,null,null,null,"Fabric Strip #69186",2.9,1,2.9,"lbs."]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #87059",5.1000000000000004E-3,6,3.0600000000000002E-2,"lbs.",null,null,null,null,null,null,null,"Roll Pin #72567",2.0000000000000001E-4,2,4.0000000000000002E-4,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #94082",3.0000000000000001E-3,6,1.8000000000000002E-2,"lbs.",null,null,null,null,null,null,null,"Drive Wheel #99621",5.7299999999999997E-2,1,5.7299999999999997E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keps Nut #80874",8.0000000000000002E-3,6,4.8000000000000001E-2,"lbs.",null,null,null,null,null,null,null,"Motor Asm",3.11,1,3.11,"lbs."]
["**** Equations for Large Top Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Hinge #75846",8.2199999999999995E-2,7,0.57539999999999991,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["y",{"$f":"B15*0.75","v":12.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,15,0.09,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["r",1175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #52703",2E-3,14,2.8000000000000001E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["n",{"$f":"B52 * B52","v":162.5625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket Hanger #35882",0.94720000000000004,7,6.6303999999999998,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["P",{"$f":"B53*B53","v":1380625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Carriage #38040",6.5000000000000002E-2,14,0.91,"lbs."]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Nut #38041",3.1E-2,14,0.434,"lbs."]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,14,0.1484,"lbs."]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs."]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs."]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs."]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,{"$f":"U64*T64","v":1.2E-2},"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,{"$f":"U65*T65","v":7.4000000000000003E-3},"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U66*T66","v":0},"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(V24:V70)","v":31.420499999999993},null,null,null,"Total:",null,{"$f":"SUM(AB24:AB66)","v":11.9922},null,null,null,"Total:",null,{"$f":"SUM(AH24:AH68)","v":20.490500000000001},null,null,null,"Total:",null,{"$f":"SUM(AN24:AN66)","v":12.3249}]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Large_Advantage_Deluxe","index":12,"n_rows":81,"n_cols":39,"rows_kept":81,"cut":false,"hidden":false,"merged":[[17,34,17,37],[21,8,21,9],[29,8,29,9],[0,0,0,1],[17,17,17,20],[17,23,17,26],[17,29,17,33],[23,8,23,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[1,3,1,4],[1,5,1,12],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9]]}
["Advantage (over 14' W with Closure Door)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",2,"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B6<=B6,B16>=264,B16<=288,B15<=216),\"Feasible\",IF(AND(B6<=6,B16>=100,B16<=264,B15>=60,B15<=264.25),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B6<=6,B16>=264,B16<=288,B15<=216),ROUNDUP(K35,0)&\" LBS / \"&ROUNDUP(K35*0.453592,0)&\" KG\",IF(AND(B6<=6,B16>=100,B16<=264,B15>=60,B15<=264),ROUNDUP(K35,0)&\" LBS / \"&ROUNDUP(K35*0.453592,0)&\" KG\",\"Not Feasible\")))","v":"Enter VA"}]
["Table of Contents"]
[]
[]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[null,null,null,null,null,null,null,"FORMULAS","DIMENSIONS"]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,null,"5.75\" Roller Assembly Miscellanous Items",null,null,null,null,null,"Closing Door Assembly Miscellanous Items",null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":0},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,null,null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,"Part","Weight","Qty.","Total:"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":0},null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B7","v":2},null,null,null,null,null,null,"EndCap Bolt #35907",1.7000000000000001E-2,8,{"$f":"T20*S20","v":0.13600000000000001},"lbs.",null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"Z20*Y20","v":1.1237999999999999},"lbs.",null,"Door Bracket #23336",0.1207,5,{"$f":"AF20*AE20","v":0.60350000000000004},"lbs.","Roller Hub #95515",1.3221000000000001,1,{"$f":"AK20*AJ20","v":1.3221000000000001},"lbs."]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"B6","v":2},null,null,null,null,null,null,"EndCap #35885",6.4264000000000001,1,{"$f":"T21*S21","v":6.4264000000000001},"lbs.",null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"Z21*Y21","v":2.8799999999999999E-2},"lbs.",null,"Hex Bolt #24270",8.9800000000000005E-2,5,{"$f":"AF21*AE21","v":0.44900000000000001},"lbs.","Screw #89592",3.5999999999999999E-3,8,{"$f":"AK21*AJ21","v":2.8799999999999999E-2},"lbs."]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K18+(K21*2))*(K19+K20+28+2.25)/144)","v":0.89583333333333337},"sq. ft.",null,null,null,null,null,"Stud #6167",7.7000000000000002E-3,6,4.6200000000000005E-2,"lbs.",null,"Mtr Adaptor #81649",4.8445999999999998,1,4.8445999999999998,"lbs.",null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs.","Mtr Adaptor #88799",5.42,1,5.42,"lbs."]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K22/9) * 32)/16","v":0.19907407407407407},"lbs.",null,null,null,null,null,"Endcap #35883",5.9645000000000001,1,5.9645000000000001,"lbs.",null,"Screen Mtr Asm #39875",5.9950000000000001,1,5.9950000000000001,"lbs.",null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs.","Screen Mtr Asm #39875",5.5540000000000003,1,5.5540000000000003,"lbs."]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":0},null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((K18+(K21*2))/12)*0.6974","v":0.23246666666666665},"lbs.","0.6974 lbs. / ft.",null,null,null,null,"J-Box Cover #35915",0.1406,1,0.1406,"lbs.",null,null,null,null,0,"lbs.",null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs.",null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Case",null,null,{"$f":"(((K18+(K21*2))+17.25)/12)*8.9606","v":15.867729166666665},"lbs.","8.961 lbs. / ft.",null,null,null,null,"J-Box #35914",0.41520000000000001,1,0.41520000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Door Slide #24269",2.1899999999999999E-2,5,0.1095,"lbs.",null,null,null,0,"lbs."]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":0},"lbs.",null,null,null,null,"Weight of Roller",null,null,{"$f":"IF(K18+(K21*2) < 240, (((K18+(K21*2))+2)/12)*2.536,(((K18+(K21*2))+2)/12)*4.02)","v":1.268},"lbs.","(5.75) - 2.536 lbs. / ft. (7.00) - 4.02 lbs. / ft.",null,null,null,null,"Pin End Brkt #35917",2.5829,1,2.5829,"lbs.",null,null,null,null,0,"lbs.",null,"Screw Mach #77459",8.9999999999999993E-3,10,0.09,"lbs.",null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Access Door",null,null,{"$f":"(((K18+(K21*2))+17)/12)*1.548","v":2.7090000000000001},"lbs.","1.548 lbs. / ft.",null,null,null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Mtr Bracket #35886",0.222,1,0.222,"lbs.",null,null,null,0,"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,"Weight of Spring Door",null,null,{"$f":"(((K18+(K21*2))+17)/12)*0.562","v":0.98350000000000004},"lbs.","0.562 lbs. / ft.",null,null,null,null,"Hex Bolt #44731",4.7E-2,2,9.4E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Pin Bracket #35887",0.224,1,0.224,"lbs.",null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Spring Door Parts / Hardware",null,null,{"$f":"AG69","v":20.490500000000001},"lbs.",null,null,null,null,null,"Hex Bolt #35905",2.7799999999999998E-2,10,0.27799999999999997,"lbs.",null,null,null,null,0,"lbs.",null,"Screw Mach #87059",5.1000000000000004E-3,15,7.6500000000000012E-2,"lbs.",null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,"Screen Parts / Hardware",null,null,{"$f":"U69","v":31.420499999999993},"lbs.",null,null,null,null,null,"Bearing #83107",0.2046,1,0.2046,"lbs.",null,null,null,null,0,"lbs.",null,"Square Nut #35903",0.02,1,0.02,"lbs.",null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,"Roller Assembly Parts",null,null,{"$f":"IF(K18+(K21*2) < 240,AA69,AL69)","v":11.9922},"lbs.",null,null,null,null,null,"Square Nut #35903",0.02,9,0.18,"lbs.",null,null,null,null,0,"lbs.",null,"Washer Lock #95073",4.0000000000000001E-3,2,8.0000000000000002E-3,"lbs.",null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockWasher #95073",4.0000000000000001E-3,10,0.04,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #72537",6.0000000000000001E-3,1,6.0000000000000001E-3,"lbs.",null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Bracket #35916",3.0455000000000001,1,3.0455000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Door Bracket #11317",4.5100000000000001E-2,1,4.5100000000000001E-2,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Adaptor Brkt #37866",0.24340000000000001,1,0.24340000000000001,"lbs.",null,null,null,null,0,"lbs.",null,"Nut Clinch #11321",1E-3,4,4.0000000000000001E-3,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75},null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K23:K33)","v":85.162969907407401},null,null,null,null,null,null,"Hex Bolt #38739",3.6799999999999999E-2,2,7.3599999999999999E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Door Bracket #11316",6.3100000000000003E-2,1,6.3100000000000003E-2,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44753",1.4E-2,2,2.8000000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #11319",1.9E-3,4,7.6E-3,"lbs.",null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35888",0.20039999999999999,2,0.40079999999999999,"lbs.",null,null,null,null,0,"lbs.",null,"Clamp #92301",2.5000000000000001E-3,5,1.2500000000000001E-2,"lbs.",null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #5013",1.46E-2,4,5.8400000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,"Screw #52703",2.0999999999999999E-3,5,1.0499999999999999E-2,"lbs.",null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J-Box Cover #35906",0.1188,1,0.1188,"lbs.",null,null,null,null,null,null,null,"Pin Hub #80764",2.3199999999999998E-2,1,2.3199999999999998E-2,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strain Relief #95443",8.9999999999999998E-4,1,8.9999999999999998E-4,"lbs.",null,null,null,null,null,null,null,"Pin Cotter #97290",6.3E-3,1,6.3E-3,"lbs."]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35889",0.61099999999999999,2,1.222,"lbs.",null,null,null,null,null,null,null,"Tube Steel #32258",10.804500000000001,1,10.804500000000001,"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,4,0.188,"lbs.",null,null,null,null,null,null,null,"Alum. Bar #33300",1.2669999999999999,1,1.2669999999999999,"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.42315000000000003},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,4,4.24E-2,"lbs.",null,null,null,null,null,null,null,"Fabric Strip #69186",2.9,1,2.9,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #87059",5.1000000000000004E-3,6,3.0600000000000002E-2,"lbs.",null,null,null,null,null,null,null,"Roll Pin #72567",2.0000000000000001E-4,2,4.0000000000000002E-4,"lbs."]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":7.9222249157545166E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #94082",3.0000000000000001E-3,6,1.8000000000000002E-2,"lbs.",null,null,null,null,null,null,null,"Drive Wheel #99621",5.7299999999999997E-2,1,5.7299999999999997E-2,"lbs."]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keps Nut #80874",8.0000000000000002E-3,6,4.8000000000000001E-2,"lbs.",null,null,null,null,null,null,null,"Motor Asm",3.11,1,3.11,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Hinge #75846",8.2199999999999995E-2,7,0.57539999999999991,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,15,0.09,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["**** Equations for Large Top Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #52703",2E-3,14,2.8000000000000001E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["y",{"$f":"B13*0.75","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket Hanger #35882",0.94720000000000004,7,6.6303999999999998,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["r",1175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Carriage #38040",6.5000000000000002E-2,14,0.91,"lbs."]
["n",{"$f":"B50 * B50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Nut #38041",3.1E-2,14,0.434,"lbs."]
["P",{"$f":"B51*B51","v":1380625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,14,0.1484,"lbs."]
["s",{"$f":"SQRT(B53-B52)","v":1175},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs."]
[null,{"$f":"B51-B54","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs."]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs."]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs."]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,1.2E-2,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,7.4000000000000003E-3,"lbs."]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(U20:U66)","v":31.420499999999993},null,null,null,"Total:",null,{"$f":"SUM(AA20:AA62)","v":11.9922},null,null,null,"Total:",null,{"$f":"SUM(AG20:AG64)","v":20.490500000000001},null,null,"Total:",null,{"$f":"SUM(AL20:AL62)","v":12.3249}]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":0}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":1.5683419575342795E-2},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":0},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":1.6467590554109936E-2},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Large_Advantage","index":13,"n_rows":83,"n_cols":34,"rows_kept":83,"cut":false,"hidden":false,"merged":[[6,0,8,0],[0,0,0,1],[20,8,20,11],[22,18,22,21],[22,24,22,27],[1,3,1,4],[1,5,1,13],[13,0,13,1],[22,29,22,32],[25,9,25,10],[27,9,27,10],[29,9,29,10],[31,9,31,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10]]}
["Tensioned Advantage (over 16' W)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":12},"inches",30.5,"cm"]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Material:"]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Height = 212\" Tall Max"]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>60,B15<=215),IF(AND(B16>100,B16<=285.75),IF(OR(B15>195,B4>260),\"SEE DESIGN CENTER\",IF(AND(B15>169,B16>192),\"SEE DESIGN CENTER\",\"Feasible\")),\"Not Feasible\"),\"Not Feasible\")))","v":"Enter VA"},null,null,null,null,null,"if OVH > 169 and the width has to be greater VAW > 260 should be DC"]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B82,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"},null,null,null,null,null,"Same for Large Advantage Deluxe"]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(OR(B11=\"Not Feasible\",B12=\"TOO MUCH TOP BLACK DROP\",B13=\"TOO MUCH BTM BLACK DROP\"),\"Not Feasible\",ROUNDUP(L41,0)&\" LBS / \"&ROUNDUP(L41*0.453592,0)&\" KG\")))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B83,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents",null,null,null,null,null,null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),5.75, 7)","v":5.75},{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),(((L23+(L27*2))+4.25)/12)*2.536,(((L23+(L27*2))+4.25)/12)*4.02)","v":1.8491666666666666}]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17},null,null,null,null,null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),AB74,AG74)","v":11.9922}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
[]
[]
[]
["**** Equations for Small Curve Border *******"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,null,"Weight of 5.75\" & 7\" Diameter Roller Screen Calculator"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,null,"FORMULAS","DIMENSIONS"]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,null,"5.75\" Roller Assembly Miscellanous Items",null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,null,null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,"Part","Weight","Qty.","Total:"]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14},null,null,null,null,null,null,"EndCap Bolt #35907",1.7000000000000001E-2,8,{"$f":"U25*T25","v":0.13600000000000001},"lbs.",null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"AA25*Z25","v":1.1237999999999999},"lbs.","Roller Hub #95515",1.3221000000000001,1,{"$f":"AF25*AE25","v":1.3221000000000001},"lbs."]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,null,"Enter Bottom Fabric Width","Enter Bottom Fabric Width",null,{"$f":"B4+(L27*2)","v":4.5},null,null,null,null,null,null,"EndCap #35885",6.4264000000000001,1,6.4264000000000001,"lbs.",null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AA26*Z26","v":2.8799999999999999E-2},"lbs.","Screw #89592",3.5999999999999999E-3,8,{"$f":"AF26*AE26","v":2.8799999999999999E-2},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",(B60/1.9),\"\")))","v":2.25},null,null,null,null,null,null,"Stud #6167",7.7000000000000002E-3,6,4.6200000000000005E-2,"lbs.",null,"Mtr Adaptor #81649",4.8445999999999998,1,{"$f":"AA27*Z27","v":4.8445999999999998},"lbs.","Mtr Adaptor #88799",5.42,1,{"$f":"AF27*AE27","v":5.42},"lbs."]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((L23+(L27*2))*(L24+L25+28+4.5)/144)","v":1.453125},"sq. ft.",null,null,null,null,null,"Endcap #35883",5.9645000000000001,1,5.9645000000000001,"lbs.",null,"Screen Mtr Asm #39875",5.9950000000000001,1,{"$f":"AA28*Z28","v":5.9950000000000001},"lbs.","Screen Mtr Asm #39875",5.5540000000000003,1,{"$f":"AF28*AE28","v":5.5540000000000003},"lbs."]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,"Weight of Fabric",null,null,{"$f":"((L28/9) * 26)/16","v":0.26236979166666669},"lbs.",null,null,null,null,null,"J-Box Cover #35915",0.1406,1,0.1406,"lbs.",null,null,null,null,{"$f":"AA29*Z29","v":0},"lbs.",null,null,null,{"$f":"AF29*AE29","v":0},"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((L26+0.5)/12) * 0.9435","v":0.393125},"lbs.","0.9435 lbs. / ft.",null,null,null,null,"J-Box #35914",0.41520000000000001,1,0.41520000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,null,"Weight of Case",null,null,{"$f":"(((L23+(L27*2))+17.25)/12)*8.9606","v":16.241087499999999},"lbs.","8.961 lbs. / ft.",null,null,null,null,"Pin End Brkt #35917",2.5829,1,2.5829,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m",null,null,null,null,null,"Weight of Roller",null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),(((L23+(L27*2))+4.25)/12)*2.536,(((L23+(L27*2))+4.25)/12)*4.02)","v":1.8491666666666666},"lbs.","5.75\" R = 2.536 lbs. / ft.:: 7\" R = 4.02 lbs. / ft. ",null,null,null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m",null,null,null,null,null,"Weight of Access Door",null,null,{"$f":"(((L23+(L27*2))+17)/12)*1.548","v":2.7735000000000003},"lbs.","1.548 lbs. / ft.",null,null,null,null,"Hex Bolt #44731",4.7E-2,2,9.4E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Screen Parts / Hardware",null,null,{"$f":"V74","v":31.420499999999993},"lbs.",null,null,null,null,null,"Hex Bolt #35905",2.7799999999999998E-2,10,0.27799999999999997,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null," Roller Asm Parts",null,null,{"$f":"IF(AND(B4<=260,(((B3+B5)*(B4+4))/144<350)),AB74,AG74)","v":11.9922},"lbs.",null,null,null,null,null,"Bearing #83107",0.2046,1,0.2046,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Nut #35903",0.02,9,0.18,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockWasher #95073",4.0000000000000001E-3,10,0.04,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Bracket #35916",3.0455000000000001,1,3.0455000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Adaptor Brkt #37866",0.24340000000000001,1,0.24340000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #38739",3.6799999999999999E-2,2,7.3599999999999999E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5},null,null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(L29:L39)","v":64.931948958333322},null,null,null,null,null,null,"Nylon Lock Nut #44753",1.4E-2,2,2.8000000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35888",0.20039999999999999,2,0.40079999999999999,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #5013",1.46E-2,4,5.8400000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,"J-Box Cover #35906",0.1188,1,0.1188,"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strain Relief #95443",8.9999999999999998E-4,1,8.9999999999999998E-4,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35889",0.61099999999999999,2,1.222,"lbs."]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,4,0.188,"lbs."]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,4,4.24E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #87059",5.1000000000000004E-3,6,3.0600000000000002E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #94082",3.0000000000000001E-3,6,1.8000000000000002E-2,"lbs."]
["**** Equations for Large Top Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keps Nut #80874",8.0000000000000002E-3,6,4.8000000000000001E-2,"lbs."]
["y",{"$f":"B15*0.75","v":12.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Hinge #75846",8.2199999999999995E-2,7,0.57539999999999991,"lbs."]
["r",1175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,15,0.09,"lbs."]
["n",{"$f":"B52 * B52","v":162.5625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #52703",2E-3,14,2.8000000000000001E-2,"lbs."]
["P",{"$f":"B53*B53","v":1380625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket Hanger #35882",0.94720000000000004,7,6.6303999999999998,"lbs."]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Carriage #38040",6.5000000000000002E-2,14,0.91,"lbs."]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Nut #38041",3.1E-2,14,0.434,"lbs."]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,14,0.1484,"lbs."]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs."]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs."]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,{"$f":"U65*T65","v":1.2E-2},"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,{"$f":"U66*T66","v":7.4000000000000003E-3},"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U67*T67","v":0},"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":7.7466972629554653E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(V25:V71)","v":31.420499999999993},null,null,null,"Total:",null,{"$f":"SUM(AB25:AB67)","v":11.9922},null,null,"Total:",null,{"$f":"SUM(AG25:AG67)","v":12.3249}]
["Fabric_Weight ",{"$f":"B72*B74*0.0625","v":6.3802083333333343E-2},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B73+B75)*1.05","v":0.23166809304109937},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B77<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B78*25.4/2) * (B76/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B79 >= 10,20,IF(B79>6,10,IF(B79>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(G8=1,84,60)","v":60}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,24)","v":24}]

{"sheet":"Large_Advantage","index":14,"n_rows":81,"n_cols":39,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,1],[17,17,17,20],[17,23,17,26],[21,8,21,9],[23,8,23,9],[1,3,1,4],[1,5,1,12],[33,8,33,9],[34,8,34,9],[17,29,17,33],[17,34,17,37],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[25,8,25,9],[26,8,26,9]]}
["Advantage (over 16' W)"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",{"$f":"ROUND((D3/2.54)*4,0)/4","v":0},"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",{"$f":"ROUND((D4/2.54)*4,0)/4","v":0},"inches",0,"cm"]
["Enter Top Black Drop:",{"$f":"ROUND((D5/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Border Width:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm"]
["Enter Bottom Black Drop: (not including pocket)",{"$f":"ROUND((D7/2.54)*4,0)/4","v":0},"inches",0,"cm"]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B6<=6,B16>=264,B16<=288,B15<=216),\"Feasible\",IF(AND(B6<=6,B16>=100,B16<=264,B15>=60,B15<=266.25),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B6<=6,B16>=264,B16<=288,B15<=216),ROUNDUP(K35,0)&\" LBS / \"&ROUNDUP(K35*0.453592,0)&\" KG\",IF(AND(B6<=6,B16>=100,B16<=264,B15>=60,B15<=264),ROUNDUP(K35,0)&\" LBS / \"&ROUNDUP(K35*0.453592,0)&\" KG\",\"Not Feasible\")))","v":"Enter VA"},null,null,null,null,null,null,{"$f":"IF(AND(B16>=264,B16<=288),IF(B15<=216,\"Feasible\",\"Not Feasible\"),\"Not Feasible\")","v":"Not Feasible"}]
["Table of Contents"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(B16>=264,B16<=288,B15<=216),\"Feasible\",IF(AND(B16>=100,B16<=264,B15>=60,B15<=266.25),\"Feasible\",\"Not Feasible\"))","v":"Not Feasible"}]
[]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[null,null,null,null,null,null,null,"FORMULAS","DIMENSIONS"]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,null,"5.75\" Roller Assembly Miscellanous Items",null,null,null,null,null,null,null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":0},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,null,null,null,"Part","Weight","Qty.","Total:",null,null,"Part","Weight","Qty.","Total:",null,null,null,null,null,null,null,"Part","Weight","Qty.","Total:"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":0},null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B7","v":2},null,null,null,null,null,null,"EndCap Bolt #35907",1.7000000000000001E-2,8,{"$f":"T20*S20","v":0.13600000000000001},"lbs.",null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"Z20*Y20","v":1.1237999999999999},"lbs.",null,null,null,null,null,null,"Roller Hub #95515",1.3221000000000001,1,{"$f":"AK20*AJ20","v":1.3221000000000001},"lbs."]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"B7","v":0},null,null,null,null,null,null,"EndCap #35885",6.4264000000000001,1,{"$f":"T21*S21","v":6.4264000000000001},"lbs.",null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"Z21*Y21","v":2.8799999999999999E-2},"lbs.",null,null,null,null,null,null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AK21*AJ21","v":2.8799999999999999E-2},"lbs."]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K18+(K21*2))*(K19+K20+28+4.5)/144)","v":0},"sq. ft.",null,null,null,null,null,"Stud #6167",7.7000000000000002E-3,6,4.6200000000000005E-2,"lbs.",null,"Mtr Adaptor #81649",4.8445999999999998,1,4.8445999999999998,"lbs.",null,null,null,null,null,null,"Mtr Adaptor #88799",5.42,1,5.42,"lbs."]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K22/9) * 32)/16","v":0},"lbs.",null,null,null,null,null,"Endcap #35883",5.9645000000000001,1,5.9645000000000001,"lbs.",null,"Screen Mtr Asm #39875",5.9950000000000001,1,5.9950000000000001,"lbs.",null,null,null,null,null,null,"Screen Mtr Asm #39875",5.5540000000000003,1,5.5540000000000003,"lbs."]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":0},null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((K18+(K21*2))/12)*0.6974","v":0},"lbs.","0.6974 lbs. / ft.",null,null,null,null,"J-Box Cover #35915",0.1406,1,0.1406,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Case",null,null,{"$f":"(((K18+(K21*2))+17.25)/12)*8.9606","v":12.880862499999999},"lbs.","8.961 lbs. / ft.",null,null,null,null,"J-Box #35914",0.41520000000000001,1,0.41520000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":0},"lbs.",null,null,null,null,"Weight of Roller",null,null,{"$f":"IF(K18+(K21*2) < 240, (((K18+(K21*2))+2)/12)*2.536,(((K18+(K21*2))+2)/12)*4.02)","v":0.42266666666666663},"lbs.","(5.75) - 2.536 lbs. / ft. (7.00) - 4.02 lbs. / ft.",null,null,null,null,"Pin End Brkt #35917",2.5829,1,2.5829,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Access Door",null,null,{"$f":"(((K18+(K21*2))+17)/12)*1.548","v":2.1930000000000001},"lbs.","1.548 lbs. / ft.",null,null,null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,"Screen Parts / Hardware",null,null,{"$f":"U69","v":31.420499999999993},"lbs.",null,null,null,null,null,"Hex Bolt #44731",4.7E-2,2,9.4E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"Roller Assembly Parts",null,null,{"$f":"IF(K18+(K21*2) < 240,AA69,AL69)","v":11.9922},"lbs.",null,null,null,null,null,"Hex Bolt #35905",2.7799999999999998E-2,10,0.27799999999999997,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing #83107",0.2046,1,0.2046,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Square Nut #35903",0.02,9,0.18,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LockWasher #95073",4.0000000000000001E-3,10,0.04,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Bracket #35916",3.0455000000000001,1,3.0455000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor Adaptor Brkt #37866",0.24340000000000001,1,0.24340000000000001,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75},null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K23:K33)","v":58.909229166666663},null,null,null,null,null,null,"Hex Bolt #38739",3.6799999999999999E-2,2,7.3599999999999999E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44753",1.4E-2,2,2.8000000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35888",0.20039999999999999,2,0.40079999999999999,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #5013",1.46E-2,4,5.8400000000000001E-2,"lbs.",null,null,null,null,0,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J-Box Cover #35906",0.1188,1,0.1188,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strain Relief #95443",8.9999999999999998E-4,1,8.9999999999999998E-4,"lbs."]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35889",0.61099999999999999,2,1.222,"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,4,0.188,"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.42315000000000003},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,4,4.24E-2,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #87059",5.1000000000000004E-3,6,3.0600000000000002E-2,"lbs."]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":7.9222249157545166E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #94082",3.0000000000000001E-3,6,1.8000000000000002E-2,"lbs."]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keps Nut #80874",8.0000000000000002E-3,6,4.8000000000000001E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Hinge #75846",8.2199999999999995E-2,7,0.57539999999999991,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,15,0.09,"lbs."]
["**** Equations for Large Top Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #52703",2E-3,14,2.8000000000000001E-2,"lbs."]
["y",{"$f":"B13*0.75","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket Hanger #35882",0.94720000000000004,7,6.6303999999999998,"lbs."]
["r",1175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Carriage #38040",6.5000000000000002E-2,14,0.91,"lbs."]
["n",{"$f":"B50 * B50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Nut #38041",3.1E-2,14,0.434,"lbs."]
["P",{"$f":"B51*B51","v":1380625},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washer #44842",1.06E-2,14,0.1484,"lbs."]
["s",{"$f":"SQRT(B53-B52)","v":1175},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Door Bracket #35910",0.31830000000000003,1,0.31830000000000003,"lbs."]
[null,{"$f":"B51-B54","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Clinch #4372",6.1000000000000004E-3,2,1.2200000000000001E-2,"lbs."]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs."]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs."]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,1.2E-2,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,7.4000000000000003E-3,"lbs."]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(U20:U66)","v":31.420499999999993},null,null,null,"Total:",null,{"$f":"SUM(AA20:AA62)","v":11.9922},null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(AL20:AL62)","v":12.3249}]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":0}]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":1.5683419575342795E-2},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2}]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":0},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":1.6467590554109936E-2},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m"]
[]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}}]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}}]

{"sheet":"Tensioned_Professional","index":15,"n_rows":125,"n_cols":32,"rows_kept":125,"cut":false,"hidden":false,"merged":[[6,0,8,0],[0,0,0,1],[19,8,19,11],[20,15,20,18],[20,20,20,24],[3,10,3,13],[4,10,4,13],[5,10,5,13],[1,3,1,4],[1,5,1,22],[13,0,13,1],[20,26,20,29],[25,9,25,10],[27,9,27,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[51,8,51,11],[52,15,52,18],[52,20,52,24],[64,9,64,10],[65,9,65,10],[66,9,66,10],[68,9,68,10],[52,26,52,29],[80,9,80,10],[81,9,81,10],[94,8,94,11],[95,15,95,18],[95,20,95,24],[95,27,95,30],[99,9,99,10],[101,9,101,10],[103,9,103,10],[105,9,105,10],[112,9,112,10],[113,9,113,10],[114,9,114,10],[106,9,106,10],[107,9,107,10],[108,9,108,10],[109,9,109,10],[110,9,110,10]]}
["TENSIONED PROFESSIONAL ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B15 < 93,\"Small_Curve\",IF(AND(B15<145,B4<160),\"Medium_Curve\",IF(OR(B15>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm",null,null,null,null,null,"FORMULA TO DETERMINE ROLLER WEIGHT"]
["Enter Top Black Drop:",12,"inches",30.5,"cm",null,null,null,null,null,{"$f":"IF(AND((((B3+B5)*(B4+4)/144))<350,B4<=192),ROUNDUP(L37*1.05,0) & \" LBS\", IF(AND(B4>144,B4<=260,(((B3+B5)*(B4+4)/144))<350),ROUNDUP(L69*1.05,0) & \" LBS\",IF(OR((((B3+B5)*(B4+4)/144))>=350,B4>260),ROUNDUP(L113,0) & \" LBS\",\"Not Feasible\")))","v":"54 LBS"}]
["Enter Bottom Black Drop:",{"$f":"ROUND((D6/2.54)*4,0)/4","v":2},"inches",5,"cm",null,null,null,null,null,{"$f":"IF(AND((((B3+B5)*(B4+4)/144))<350,B4<=192),ROUNDUP((L37*1.05) * 0.453592,0) & \" KG\", IF(AND(B4>144,B4<=260,(((B3+B5)*(B4+4)/144))<350),ROUNDUP((L69*1.05) * 0.453592,0) & \" KG\",IF(OR((((B3+B5)*(B4+4)/144))>=350,B4>260),ROUNDUP(L113*0.453592,0) & \" KG\",\"Not Feasible\")))","v":"25 KG"}]
["Material:"]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"If OVH > 192 DC",null,null,null,"add 3 inches to all heights.",null,null,null,null,null,null,null,{"$f":"((B3+B5)*(B4+4)/144)","v":0.33333333333333331}]
["\"ALL THREE FIELDS TO THE RIGHT MUST BE GREEN\"",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(AND(B15>60,B16>100,B15<=264),IF(B16<=319.5,IF(OR(B15>195,B4>260),\"SEE DESIGN CENTER\",IF(AND(B15>169,B16>192),\"SEE DESIGN CENTER\",\"Feasible\")),\"Not Feasible\"),\"Not Feasible\")))","v":"Enter VA"},null,null,null,null,null,"if OVH > 166 and the width has to be greater VAW > 260 should be DC"]
["APPROX. HANGING WEIGHT",{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B5<=B93,\"TOP BLACK DROP OK\",\"TOO MUCH TOP BLACK DROP\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(OR(B11=\"Not Feasible\",B12=\"TOO MUCH TOP BLACK DROP\",B13=\"TOO MUCH BTM BLACK DROP\"),\"Not Feasible\",(IF(OR(B11=\"SELECT FABRIC\",B12=\"SELECT FABRIC\",B13=\"SELECT FABRIC\"),\"SELECT FABRIC\",K5&\" / \"&K6)))))","v":"Enter VA"},{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(G8=0,\"SELECT FABRIC\",IF(B6<=B94,\"BTM BLACK DROP OK\",\"TOO MUCH BTM BLACK DROP\")))","v":"Enter VA"}]
["Table of Contents"]
["Total_Screen_Height",{"$f":"B3+B5+B6+3","v":17}]
["Fabric Width",{"$f":"IF(G3=\"Small_Curve\",B25,IF(G3=\"Medium_Curve\",B40,IF(G3=\"Large_Curve\",B61,0)))","v":4.5}]
["Bottom Fabric Width",{"$f":"B90","v":{"$error":"#DIV/0!"}}]
[]
[]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,null,"Weight of 4.50\" Diameter Roller Screen Calculator"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B15*B15)","v":0.12889101250823387},null,null,null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,"4.50\" Roller Assembly Parts"]
[null,{"$f":"B21-ROUNDDOWN(B21,0)","v":0.12889101250823387},null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",1.5974999999999999,"lbs.",null,null,null,"Part","Weight","Qty.","Total:"]
[null,{"$f":"IF(B22>=0.875,1,IF(B22>=0.625,0.75,IF(B22>=0.375,0.5,IF(B22>=0.125,0.25,0))))","v":0.25},null,null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #83010",1.6454599999999999,1,{"$f":"R23*Q23","v":1.6454599999999999},"lbs.","Pin End Board",1.5642,"lbs.",null,null,null,"#33304-Mtr Assy",6.3449999999999998,1,{"$f":"AC23*AB23","v":6.3449999999999998},"lbs."]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B21,0)+B23+2","v":2.25},null,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14},null,null,null,"Bearing #83107",0.2046,1,{"$f":"R24*Q24","v":0.2046},"lbs.","Ends and Top",{"$f":"(((L22+(L25*2))+12.25)/12)*7.05566","v":9.848525416666666},"lbs.","7.05566 lbs. / ft.",null,null,"#96131 - Plug Pin",0.34799999999999998,1,{"$f":"AC24*AB24","v":0.34799999999999998},"lbs."]
["Small_Curve_Fabric_Width",{"$f":"(B24*2)+B4","v":4.5},null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",B60,\"\")))","v":2.25},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.","False Top",{"$f":"(((L22+(L25*2))+10.75)/12)*1.82082","v":2.3139587499999998},"lbs.","1.82082 lbs. / ft.",null,null,"#82998 - Screw",2.3E-3,3,{"$f":"AC25*AB25","v":6.8999999999999999E-3},"lbs."]
["Square_Inches_Small_Curve",{"$f":"B25*B15","v":76.5},null,null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((L22+(L25*2))*(L23+L24+3+25+2.5)/144)","v":1.390625},"sq. ft.",null,null,"Mtr Brkt #93205",1.7798099999999999,1,1.7798099999999999,"lbs.","Runners",{"$f":"INT((L22+(L25*2)+2.5)/14)+4","v":4},null,null,null,null,null,null,null,{"$f":"AC26*AB26","v":0},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((L26/9) * 26)/16","v":0.25108506944444448},"lbs.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"V26*0.1105","v":0.442},"lbs.",".1105 lbs / per pc",null,null,null,null,null,{"$f":"AC27*AB27","v":0},"lbs."]
["Fabric_Weight ",{"$f":"B26*B27*0.0625","v":0.1032986111111111},"lbs.",null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((L22+(L25*2)+0.5)/12) * 0.9435","v":0.393125},"lbs.","0.9435 lbs. / ft.",null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((L22+(L25*2)+12.25)*2)+16)/12)*0.1707","v":0.70413749999999997},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,{"$f":"AC28*AB28","v":0},"lbs."]
["Slat_Weight",{"$f":"((B25+0.5)/12)*0.806","v":0.33583333333333337},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,"Weight of Case",null,null,{"$f":"V50","v":20.470321666666667},"lbs.",null,null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(L22+(L25*2)+8.5>169,1.29551,0)","v":0},"lbs.","1.29551 lbs / per splice",null,null,null,null,null,0,"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B28+B29)*1.05","v":0.46108854166666674},"lbs.",null,null,null,null,null,"Weight of Roller",null,null,{"$f":"(((L22+(L25*2)+4.25)/12)*2.19)","v":1.5968749999999998},"lbs.","2.19 lbs. / ft.",null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,null,"Miscellanous Items",null,null,{"$f":"S50","v":21.339702799999998},"lbs.",null,null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B31*25.4/2) * (B30/2.20462262) / 100","v":8.6325112446191218E-2},"N/m",null,null,null,null,null,"4.50\" Roller Items",null,null,{"$f":"AD50","v":6.6998999999999995},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B32 >= 10,20,IF(B32>6,10,IF(B32>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B15*B15)+1.75","v":1.8204926528918577},null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"B36-ROUNDDOWN(B36,0)","v":0.82049265289185769},null,null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(L27:L35)","v":50.751009536111113},"lbs.",null,null,"Brkt Hanger #46358",1.7122999999999999,3,5.1368999999999998,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"IF(B37>=0.875,1,IF(B37>=0.625,0.75,IF(B37>=0.375,0.5,IF(B37>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46356",2.6964000000000001,3,8.0891999999999999,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B36,0)+B38","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,3,2.5644,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B39*2)+B4+2","v":5.5},null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,3,6.4500000000000002E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B40*B15","v":93.5},null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,3,0.14100000000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC42*AB42","v":0},"lbs."]
["Fabric_Weight",{"$f":"B41*B42*0.0625","v":0.12625385802469136},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC43*AB43","v":0},"lbs."]
["Slat_Weight",{"$f":"((B40+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC44*AB44","v":0},"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B43+B44)*1.05","v":0.55571655092592598},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC45*AB45","v":0},"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,1.2E-2,"lbs."]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B46*25.4/2) * (B45/2.20462262) / 100","v":0.10404139207946436},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,7.4000000000000003E-3,"lbs."]
["Motor_Torque_Medium_Curve",{"$f":"IF(B47 >= 10,20,IF(B47>6,10,IF(B47>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(S23:S47)","v":21.339702799999998},null,"Total:",{"$f":"SUM(V22:V30)","v":20.470321666666667},null,null,null,null,null,"Total:",null,{"$f":"SUM(AD23:AD47)","v":6.6998999999999995}]
["**** Equations for Large Top Curve Border *******"]
["y",{"$f":"B15*0.75","v":12.75},null,null,null,null,null,null,"Weight of 5.75\" Diameter Roller Screen Calculator"]
["r",1175,null,null,null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,"5.75\" Roller Assembly Parts"]
["n",{"$f":"B52 * B52","v":162.5625},null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",1.5974999999999999,"lbs.",null,null,null,"Part","Weight","Qty.","Total:"]
["P",{"$f":"B53*B53","v":1380625},null,null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #83010",1.6454599999999999,1,{"$f":"R55*Q55","v":1.6454599999999999},"lbs.","Pin End Board",1.5642,"lbs.",null,null,null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"AC55*AB55","v":1.1237999999999999},"lbs."]
["s",{"$f":"SQRT(B55-B54)","v":1174.9308224316869},null,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14},null,null,null,"Bearing #83107",0.2046,1,{"$f":"R56*Q56","v":0.2046},"lbs.","Ends and Top",{"$f":"(((L54+(L57*2))+12.25)/12)*7.05566","v":9.848525416666666},"lbs.","7.05566 lbs. / ft.",null,null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AC56*AB56","v":2.8799999999999999E-2},"lbs."]
[null,{"$f":"B53-B56","v":6.9177568313079973E-2},null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",(B60/2),\"\")))","v":2.25},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.",null,null,null,null,null,null,"Mtr Adaptor #81649",4.8445999999999998,1,{"$f":"AC57*AB57","v":4.8445999999999998},"lbs."]
[null,{"$f":"B57-ROUNDDOWN(B57,0)","v":6.9177568313079973E-2},null,null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((L54+(L57*2))*(L55+L56+3+25)/144)","v":1.3125},"sq. ft.",null,null,"Mtr Brkt #93205",1.7798099999999999,1,1.7798099999999999,"lbs.","Runners",{"$f":"INT((L54+(L57*2)+2.5)/14)+4","v":4},null,null,null,null,"Screen Mtr Asm #39875",5.9950000000000001,1,{"$f":"AC58*AB58","v":5.9950000000000001},"lbs."]
[null,{"$f":"IF(B58>=0.875,1,IF(B58>=0.625,0.75,IF(B58>=0.375,0.5,IF(B58>=0.125,0.25,0))))","v":0},null,null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((L58/9) * 26)/16","v":0.23697916666666669},"lbs.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"V58*0.1105","v":0.442},"lbs.",".1105 lbs / per pc",null,null,null,null,null,{"$f":"AC59*AB59","v":0},"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B57,0)+B59+2","v":2},null,null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((L54+(L57*2)+0.5)/12) * 0.9435","v":0.393125},"lbs.","0.9435 lbs. / ft.",null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((L54+(L57*2)+12.25)*2)+16)/12)*0.1707","v":0.70413749999999997},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,{"$f":"AC60*AB60","v":0},"lbs."]
["Large_Curve_Top_Width",{"$f":"(B60*2)+B4","v":4},null,null,null,null,null,null,"Weight of Case",null,null,{"$f":"V93","v":18.156362916666666},"lbs.",null,null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(L54+(L57*2)+8.5>169,1.29551,0)","v":0},"lbs.","1.29551 lbs / per splice",null,null,null,null,null,0,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B61*B15","v":68},null,null,null,null,null,null,"Weight of Roller",null,null,{"$f":"(((L54+(L57*2)+2)/12)*2.536)","v":1.3736666666666666},"lbs.","2.536 lbs. / ft.",null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,"Miscellanous Items",null,null,{"$f":"S93","v":26.671702799999998},"lbs.",null,null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight",{"$f":"B62*B63*0.0625","v":9.1820987654320979E-2},"lbs.",null,null,null,null,null,"5.75\" Roller Items",null,null,{"$f":"AD93","v":11.9922},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B61+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B64+B65)*1.05","v":0.41377453703703709},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller_Diameter",7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B67*25.4/2) * (B66/2.20462262) / 100","v":0.16685194104827153},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B68 >= 10,20,IF(B68>6,10,IF(B68>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(L59:L67)","v":58.824036549999988},"lbs.",null,null,"Brkt Hanger #46358",1.7122999999999999,4,6.8491999999999997,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["g",{"$f":"B15*0.25","v":4.25}]
["r1",350]
["n1",{"$f":"B70*B70","v":18.0625}]
["p1",{"$f":"B71*B71","v":122500}]
["s1",{"$f":"SQRT(B73-B72)","v":349.97419547732375}]
[null,{"$f":"B71-B74","v":2.5804522676253328E-2}]
[null,{"$f":"B75-ROUNDDOWN(B75,0)","v":2.5804522676253328E-2}]
[null,{"$f":"IF(B76>=0.875,1,IF(B76>=0.625,0.75,IF(B76>=0.375,0.5,IF(B76>=0.125,0.25,0))))","v":0}]
["Large_Curve_Btm_Border",{"$f":"2+ROUNDDOWN(B75,0)+B77","v":2}]
["Large_Curve_Btm_Width",{"$f":"B4+(B78*2)","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46356",2.6964000000000001,4,10.785600000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,4,3.4192,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Non_Tensioned",{"$f":"B16*(B15-3)","v":63},null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,4,8.5999999999999993E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B16+0.5))*0.284","v":0.15683419575342794},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,4,0.188,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,0.04,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC85*AB85","v":0},"lbs."]
["Fabric_Weight ",{"$f":"B83*B85*0.0625","v":6.3802083333333343E-2},"lbs.",null,null,null,null,null,null,null,{"$f":"L64+L62+L60+L59","v":13.995970833333333},null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC86*AB86","v":0},"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B84+B86)*1.05","v":0.23166809304109937},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC87*AB87","v":0},"lbs."]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AC88*AB88","v":0},"lbs."]
["Roller Diameter",{"$f":"IF(AND(B16<=108,B88<1.45),3,3.25)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,1.2E-2,"lbs."]
["Motor_Torque_Required_N/m",{"$f":"(B89*25.4/2) * (B87/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,7.4000000000000003E-3,"lbs."]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B90 >= 10,20,IF(B90>6,10,IF(B90>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Max Top Black Drop",{"$f":"IF(G8=1,84,(IF(G8=2,60,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(S55:S92)","v":26.671702799999998},null,"Total:",{"$f":"SUM(V54:V62)","v":18.156362916666666},null,null,null,null,null,"Total:",null,{"$f":"SUM(AD55:AD92)","v":11.9922}]
["Max Bottom Black Drop",{"$f":"IF(G8=1,48,(IF(G8=2,24,0)))","v":0}]
[null,null,null,null,null,null,null,null,"Weight of 7\" Diameter Roller Screen Calculator"]
[null,null,null,null,null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
[null,null,null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",2.0720000000000001,"lbs.",null,null,null,null,"Part","Weight","Qty.","Total:"]
[null,null,null,null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #89038",1.8656999999999999,1,{"$f":"R98*Q98","v":1.8656999999999999},"lbs.","Pin End Board",2.0383,"lbs.",null,null,null,null,"Roller Hub #95515",1.3221000000000001,1,{"$f":"AD98*AC98","v":1.3221000000000001},"lbs."]
[null,null,null,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B6","v":14},null,null,null,"Bearing #83107",0.2046,1,{"$f":"R99*Q99","v":0.2046},"lbs.","Ends and Top",{"$f":"(((L97+(L101*2))+10)/12)*7.909169153","v":9.5569127265416665},"lbs.","7.909169 lbs. / ft.",null,null,null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AD99*AC99","v":2.8799999999999999E-2},"lbs."]
[null,null,null,null,null,null,null,null,"Enter Bottom Fabric Width","Enter Bottom Fabric Width",null,{"$f":"B4+(L101*2)","v":4.5},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.","False Top",{"$f":"((L97+(L101*2)+8.5)/12)*2.1053184","v":2.2807615999999995},"lbs.","2.1053184 lbs. / ft.",null,null,null,"Mtr Adaptor #88799",5.42,1,5.42,"lbs."]
[null,null,null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"IF(G3=\"Small_Curve\",B24,IF(G3=\"Medium_Curve\",B39,IF(G3=\"Large_Curve\",(B60/1.9),\"\")))","v":2.25},null,null,null,"Mtr Brkt #93207",2.0013000000000001,1,2.0013000000000001,"lbs.","Runners",{"$f":"INT((L97+(L101*2)+2.5)/14)+4","v":4},null,null,null,null,null,"Screen Mtr Asm #39875",5.5540000000000003,1,5.5540000000000003,"lbs."]
[null,null,null,null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((L97+(L101*2))*(L98+L99+36+4.5)/144)","v":1.703125},"sq. ft.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"V101*0.12782","v":0.51127999999999996},"lbs.",".12782 lbs / per pc",null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((L102/9) * 26)/16","v":0.30750868055555552},"lbs.",null,null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((L97+(L101*2)+10)*2)+18.5)/12)*0.1707","v":0.6756875},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((L100+0.5)/12)*0.9435","v":0.393125},"lbs.","0.9435 lbs. / ft.",null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(L97+(L101*2)+8.5>169,1.36478,0)","v":0},"lbs.","1.36478 lbs / per splice",null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Weight of Case",null,null,{"$f":"V125","v":21.134941826541667},"lbs.",null,null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Weight of Roller",null,null,{"$f":"(((L97+(L101*2)+4.25)/12)*4.02)","v":2.9312499999999995},"lbs.","4.02 lbs. / ft.",null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Miscellanous Items",null,null,{"$f":"S125","v":28.799832799999997},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"7.00\" Roller Items",null,null,{"$f":"AE125","v":12.3249},"lbs.",null,null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #88788",1.8562000000000001,4,7.4248000000000003,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(L103:L111)","v":65.891558307097213},"lbs.",null,null,"Brkt Hanger #88786",2.9741,4,11.8964,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,4,3.4192,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,4,8.5999999999999993E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,4,{"$f":"R116*Q116","v":0.188},"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw Hex Cap #35913",0.02,2,{"$f":"R117*Q117","v":0.04},"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slat Cap #97788",2.9899999999999999E-2,2,5.9799999999999999E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hex Bolt #33621",2.3099999999999999E-2,2,4.6199999999999998E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj. Tube #98215",3.4799999999999998E-2,2,6.9599999999999995E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #44839",3.0000000000000001E-3,4,1.2E-2,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring #81707",3.7000000000000002E-3,2,7.4000000000000003E-3,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(S98:S123)","v":28.799832799999997},null,"Total:",{"$f":"SUM(V97:V105)","v":21.134941826541667},null,null,null,null,null,null,"Total:",null,{"$f":"SUM(AE98:AE123)","v":12.3249}]

{"sheet":"Professional","index":16,"n_rows":104,"n_cols":31,"rows_kept":104,"cut":false,"hidden":false,"merged":[[94,8,94,9],[95,8,95,9],[4,10,4,13],[5,10,5,13],[87,8,87,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[93,8,93,9],[86,8,86,9],[60,8,60,9],[61,8,61,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[77,14,77,17],[77,19,77,23],[77,25,77,28],[82,8,82,9],[84,8,84,9],[47,14,47,17],[47,19,47,23],[76,7,76,10],[52,8,52,9],[54,8,54,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[28,8,28,9],[29,8,29,9],[35,8,35,9],[16,7,16,10],[46,7,46,10],[1,3,1,4],[1,5,1,16],[6,10,6,13],[0,0,0,1],[47,26,47,29],[17,14,17,17],[17,19,17,23],[17,25,17,28],[22,8,22,9],[24,8,24,9],[30,8,30,9],[31,8,31,9],[33,8,33,9],[34,8,34,9],[26,8,26,9],[27,8,27,9]]}
["PROFESSIONAL ELECTROL"]
[null,null,null,"Centimeters",null,"Note: cm will update inches, inches will not update cm"]
["Enter Viewing Area Height:",0,"inches",0,"cm",null,{"$f":"IF(B13 < 93,\"Small_Curve\",IF(AND(B13<145,B4<160),\"Medium_Curve\",IF(OR(B13>=145,B4>=160),\"Large_Curve\",0)))","v":"Small_Curve"}]
["Enter Viewing Area Width:",0,"inches",0,"cm"]
["Enter Top Black Drop:",2,"inches",5,"cm",null,null,null,null,null,"Formula to determine which roller weight"]
["Enter Border Width:",2,"inches",5,"cm",null,null,null,null,null,{"$f":"IF(AND(B15<220,B16<=144),ROUNDUP(K94,0) & \" LBS\", IF(AND(B16>144,B16<220),ROUNDUP(K34,0) & \" LBS\",IF(OR(B15>=220,AND(B16>=220,B16<=288)),ROUNDUP(K64,0) & \" LBS\",\"Not Feasible\")))","v":"49 LBS"}]
["Enter Bottom Black Drop: (not including pocket)",0,"inches",0,"cm",null,null,null,null,null,{"$f":"IF(AND(B15<220,B16<=144),ROUNDUP(K94,0) & \" LBS\", IF(AND(B16>144,B16<220),ROUNDUP(K34*0.453592,0) & \" KG\",IF(OR(B15>=220,AND(B16>=220,B16<=288)),ROUNDUP(K64*0.453592,0) & \" KG\",\"Not Feasible\")))","v":"49 LBS"}]
[]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(AND(B6<=6,B15>60,B16>100,B16>=264,B16<=288,B15<=216),\"Feasible\",IF(AND(B6<=6,B16>=100,B16<=264,B15>=60,B15<=264.25),\"Feasible\",\"Not Feasible\")))","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",\"APPROX. HANGING WEIGHT\")","v":"Enter VA"}]
[{"$f":"IF(OR(B3=0,B4=0),\"Enter VA\",IF(A9=\"Not Feasible\",\"Not Feasible\",K6&\" / \"&K7))","v":"Enter VA"}]
["Table of Contents"]
[]
[]
["Total_Screen_Height",{"$f":"B3+B5+B7","v":2}]
["Fabric Width",{"$f":"B4+(B6*2)","v":4}]
[null,null,null,null,null,null,null,"5.75\" Diameter weights"]
["**** Equations for Small Curve Border *******",null,null,null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,"5.75\" Roller Assembly Parts"]
[null,{"$f":"280.34-SQRT(280.34*280.34-0.25*B13*B13)","v":0},null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",1.5974999999999999,"lbs.",null,null,null,"Part","Weight","Qty.","Total:"]
[null,{"$f":"B19-ROUNDDOWN(B19,0)","v":0},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #83010",1.6454599999999999,1,{"$f":"Q20*P20","v":1.6454599999999999},"lbs.","Pin End Board",1.5642,"lbs.",null,null,null,"Roller Hub #73525",1.1237999999999999,1,{"$f":"AB20*AA20","v":1.1237999999999999},"lbs."]
[null,{"$f":"IF(B20>=0.875,1,IF(B20>=0.625,0.75,IF(B20>=0.375,0.5,IF(B20>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B7","v":2},null,null,null,"Bearing #83107",0.2046,1,{"$f":"Q21*P21","v":0.2046},"lbs.","Ends and Top",{"$f":"(((K19+(K22*2))+10)/12)*7.05566","v":8.231603333333334},"lbs.","7.05566 lbs. / ft.",null,null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AB21*AA21","v":2.8799999999999999E-2},"lbs."]
["Small_Curve_Border",{"$f":"ROUNDDOWN(B19,0)+B21+2","v":2},null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"B6","v":2},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.",null,null,null,null,null,null,"Mtr Adaptor #81649",4.8445999999999998,1,{"$f":"AB22*AA22","v":4.8445999999999998},"lbs."]
["Small_Curve_Fabric_Width",{"$f":"(B22*2)+B4","v":4},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K19+(K22*2))*(K20+K21+36+4.5)/144)","v":1.1805555555555556},"sq. ft.",null,null,"Mtr Brkt #93205",1.7798099999999999,1,1.7798099999999999,"lbs.","Runners",{"$f":"INT((K19+(K22*2)+2.5)/14)+4","v":4},null,null,null,null,"Screen Mtr Asm #39875",5.9950000000000001,1,{"$f":"AB23*AA23","v":5.9950000000000001},"lbs."]
["Square_Inches_Small_Curve",{"$f":"B23*B13","v":0},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K23/9) * 32)/16","v":0.26234567901234568},"lbs.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"U23*0.1105","v":0.442},"lbs.",".1105 lbs / per pc",null,null,null,null,null,{"$f":"AB24*AA24","v":0},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((PI()*(0.1875^2))*((K19+(K22*2))+0.75))*0.284","v":0.14899248596575654},"lbs.",null,null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((K19+(K22*2)+10)*2)+16)/12)*0.1707","v":0.6258999999999999},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,{"$f":"AB25*AA25","v":0},"lbs."]
["Fabric_Weight ",{"$f":"B24*B25*0.0625","v":0},"lbs.",null,null,null,null,"Weight of Case",null,null,{"$f":"U44","v":16.461203333333334},"lbs.",null,null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(K19+(K22*2)+8.5>169,1.29551,0)","v":0},"lbs.","1.29551 lbs / per splice",null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B23+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)","Weight of Roller",null,null,{"$f":"(((K19+(K22*2)+2)/12)*2.536)","v":1.268},"lbs.","2.536 lbs. / ft.",null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Small_Curve_Weight",{"$f":"(B26+B27)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,"Miscellanous Items",null,null,{"$f":"R44","v":24.317282799999997},"lbs.",null,null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller Diameter",{"$f":"3.25","v":3.25},null,null,null,null,null,"5.75\" Roller Items",null,null,{"$f":"AC44","v":11.9922},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Small_Curve",{"$f":"(B29*25.4/2) * (B28/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,"Ironing Board",null,null,{"$f":"((K19+(K22*2)+2)/12)*0.3353","v":0.16764999999999999},"lbs.",".3353 lbs. / ft.",null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Small_Curve",{"$f":"IF(B30 >= 10,20,IF(B30>6,10,IF(B30>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["**** Equations for Medium Curve Border *******",null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"512.5-SQRT(512.5*512.5-0.25*B13*B13)+1.75","v":1.75},null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K24:K32)","v":54.617674298311435},"lbs.",null,null,"Brkt Hanger #46358",1.7122999999999999,3,5.1368999999999998,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"B34-ROUNDDOWN(B34,0)","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46356",2.6964000000000001,3,8.0891999999999999,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"IF(B35>=0.875,1,IF(B35>=0.625,0.75,IF(B35>=0.375,0.5,IF(B35>=0.125,0.25,0))))","v":0.75},null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,3,2.5644,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Border",{"$f":"ROUNDDOWN(B34,0)+B36","v":1.75},null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,3,6.4500000000000002E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Medium_Curve_Fabric_Width",{"$f":"(B37*2)+B4+2","v":5.5},null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,3,{"$f":"Q38*P38","v":0.14100000000000001},"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Medium_Curve",{"$f":"B38*B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Bracket #97724 - Iron Board",0.13200000000000001,7,0.92400000000000004,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB39*AA39","v":0},"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83702",1.184E-2,7,8.2879999999999995E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB40*AA40","v":0},"lbs."]
["Fabric_Weight",{"$f":"B39*B40*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,"Nut Weld #50877",0.29599999999999999,7,2.0720000000000001,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB41*AA41","v":0},"lbs."]
["Slat_Weight",{"$f":"((B38+0.5)/12)*0.806","v":0.40300000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,"Bolt #44777",1.9099999999999999E-2,7,0.13369999999999999,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB42*AA42","v":0},"lbs."]
["Total_Medium_Curve_Weight",{"$f":"(B41+B42)*1.05","v":0.42315000000000003},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(R20:R43)","v":24.317282799999997},null,"Total:",{"$f":"SUM(U19:U27)","v":16.461203333333334},null,null,null,null,null,"Total:",null,{"$f":"SUM(AC20:AC43)","v":11.9922}]
["Motor_Torque_Required_Medium_Curve",{"$f":"(B44*25.4/2) * (B43/2.20462262) / 100","v":7.9222249157545166E-2},"N/m"]
["Motor_Torque_Medium_Curve",{"$f":"IF(B45 >= 10,20,IF(B45>6,10,IF(B45>3,6,3)))","v":3},"N/m"]
[null,null,null,null,null,null,null,"Weight of 7\" Diameter Roller Screen Calculator"]
[null,null,null,null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,null,"7.00\" Roller Assembly Miscellanous Items"]
["**** Equations for Large Top Curve Border *******",null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",2.0720000000000001,"lbs.",null,null,null,null,"Part","Weight","Qty.","Total:"]
["y",{"$f":"B13*0.75","v":0},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #89038",1.8656999999999999,1,{"$f":"Q50*P50","v":1.8656999999999999},"lbs.","Pin End Board",2.0383,"lbs.",null,null,null,null,"Roller Hub #95515",1.3221000000000001,1,{"$f":"AC50*AB50","v":1.3221000000000001},"lbs."]
["r",1175,null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B7","v":2},null,null,null,"Bearing #83107",0.2046,1,{"$f":"Q51*P51","v":0.2046},"lbs.","Ends and Top",{"$f":"(((K49+(K52*2))+10)/12)*7.909169153","v":9.227364011833334},"lbs.","7.909169 lbs. / ft.",null,null,null,"Screw #89592",3.5999999999999999E-3,8,{"$f":"AC51*AB51","v":2.8799999999999999E-2},"lbs."]
["n",{"$f":"B50 * B50","v":0},null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"B6","v":2},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.",null,null,null,null,null,null,null,"Mtr Adaptor #88799",5.42,1,5.42,"lbs."]
["P",{"$f":"B51*B51","v":1380625},null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K49+(K52*2))*(K50+K51+36+4.5)/144)","v":1.1805555555555556},"sq. ft.",null,null,"Mtr Brkt #93207",2.0013000000000001,1,2.0013000000000001,"lbs.","Runners",{"$f":"INT((K49+(K52*2)+2.5)/14)+4","v":4},null,null,null,null,null,"Screen Mtr Asm #39875",5.5540000000000003,1,5.5540000000000003,"lbs."]
["s",{"$f":"SQRT(B53-B52)","v":1175},null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K53/9) * 32)/16","v":0.26234567901234568},"lbs.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"U53*0.12782","v":0.51127999999999996},"lbs.",".12782 lbs / per pc",null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"B51-B54","v":0},null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((PI()*(0.25^2))*((K49+(K52*2))+0.75))*0.284","v":0.26487553060578939},"lbs.",null,null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((K49+(K52*2)+10)*2)+18.5)/12)*0.1707","v":0.66146249999999995},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"B55-ROUNDDOWN(B55,0)","v":0},null,null,null,null,null,"Weight of Case",null,null,{"$f":"U74","v":18.510406511833331},"lbs.",null,null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(K49+(K52*2)+8.5>169,1.36478,0)","v":0},"lbs.","1.36478 lbs / per splice",null,null,null,null,null,null,0,"lbs."]
[null,{"$f":"IF(B56>=0.875,1,IF(B56>=0.625,0.75,IF(B56>=0.375,0.5,IF(B56>=0.125,0.25,0))))","v":0},null,null,null,null,null,"Weight of Roller",null,null,{"$f":"(((K49+(K52*2)+2)/12)*4.02)","v":2.0099999999999998},"lbs.","4.02 lbs. / ft.",null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Large_Curve_Top_Border",{"$f":"ROUNDDOWN(B55,0)+B57+2","v":2},null,null,null,null,null,"Miscellanous Items",null,null,{"$f":"R74","v":31.777412799999997},"lbs.",null,null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Large_Curve_Top_Width",{"$f":"(B58*2)+B4","v":4},null,null,null,null,null,"7.00\" Roller Items",null,null,{"$f":"AD74","v":12.3249},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Square_Inches_Large_Curve",{"$f":"B59*B13","v":0},null,null,null,null,null,"Ironing Board",null,null,{"$f":"((K49+(K52*2)+2)/12)*0.3353","v":0.16764999999999999},"lbs.",".3353 lbs. / ft.",null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"28/9/144","v":2.1604938271604937E-2},null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Fabric_Weight",{"$f":"B60*B61*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Slat_Weight",{"$f":"((B59+0.5)/12)*0.806","v":0.30225000000000002},"lbs.",null,null,null,"(0.806 / lbs. ft.)",null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Large_Curve_Weight",{"$f":"(B62+B63)*1.05","v":0.31736250000000005},"lbs.",null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K54:K62)","v":65.31759052145145},"lbs.",null,null,"Brkt Hanger #88788",1.8562000000000001,4,7.4248000000000003,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Roller_Diameter",3.25,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #88786",2.9741,4,11.8964,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Required_Large_Curve",{"$f":"(B65*25.4/2) * (B64/2.20462262) / 100","v":5.9416686868158888E-2},"N/m",null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,4,3.4192,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Motor_Torque_Large_Curve",{"$f":"IF(B66 >= 10,20,IF(B66>6,10,IF(B66>3,6,3)))","v":3},"N/m",null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,4,8.5999999999999993E-2,"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,4,{"$f":"Q68*P68","v":0.188},"lbs.",null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket #97724 - Iron Board",0.13200000000000001,7,0.92400000000000004,"lbs."]
["Square_Inches_Non_Tensioned",{"$f":"B14*(B13-3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83702",1.184E-2,7,8.2879999999999995E-2,"lbs."]
["3/8_Slat_Weight",{"$f":"(PI()*(0.1875*0.1875)*(B14+0.5))*0.284","v":1.5683419575342795E-2},"lbs.",null,null,null,null,null,null,null,null,null,null,null,"Nut Weld #50877",0.29599999999999999,7,2.0720000000000001,"lbs."]
["Fabric_Weight_oz/sq in.",{"$f":"21/9/144","v":1.6203703703703706E-2},null,null,null,null,null,null,null,null,null,null,null,null,"Bolt #44777",1.9099999999999999E-2,7,0.13369999999999999,"lbs."]
["Fabric_Weight ",{"$f":"B70*B72*0.0625","v":0},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
["Total_Non_Tens_Weight",{"$f":"(B71+B73)*1.05","v":1.6467590554109936E-2},"lbs.",null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(R50:R73)","v":31.777412799999997},null,"Total:",{"$f":"SUM(U49:U57)","v":18.510406511833331},null,null,null,null,null,null,"Total:",null,{"$f":"SUM(AD50:AD73)","v":12.3249}]
["Aspect Ratio",{"$f":"B4/B3","v":{"$error":"#DIV/0!"}}]
["Roller Diameter",{"$f":"IF(AND(B14<=108,B75<1.45),3,3.25)","v":{"$error":"#DIV/0!"}}]
["Motor_Torque_Required_N/m",{"$f":"(B76*25.4/2) * (B74/2.20462262) / 100","v":{"$error":"#DIV/0!"}},"N/m",null,null,null,null,"3.25\" Diameter weights"]
["Motor_Torque_Non_Tensioned",{"$f":"IF(B77 >= 10,20,IF(B77>6,10,IF(B77>3,6,3)))","v":{"$error":"#DIV/0!"}},"N/m",null,null,null,null,"FORMULAS","DIMENSIONS",null,null,null,null,null,"Screen Housing Miscellanous Items",null,null,null,null,"Case Weight Calculation",null,null,null,null,null,"3.25\" Roller Assembly Parts"]
[null,null,null,null,null,null,null,"Viewing Area Width","Enter Viewing Area Width",null,{"$f":"B4","v":0},null,null,null,"Part","Weight","Qty.","Total:",null,"End Board Motor",1.5974999999999999,"lbs.",null,null,null,"Part","Weight","Qty.","Total:"]
["Max Top Black Drop",{"$f":"IF(#REF!=1,84,60)","v":{"$error":"#REF!"}},null,null,null,null,null,"Viewing Area Height","Enter Viewing Area Height",null,{"$f":"B3","v":0},null,null,null,"Pin Brkt #83010",1.6454599999999999,1,{"$f":"Q80*P80","v":1.6454599999999999},"lbs.","Pin End Board",1.5642,"lbs.",null,null,null,"Screen Mtr Asm",5.9950000000000001,1,{"$f":"AB80*AA80","v":5.9950000000000001},"lbs."]
["Max Bottom Black Drop",{"$f":"IF(#REF!=1,48,24)","v":{"$error":"#REF!"}},null,null,null,null,null,"Enter Amount Black Drop","Enter Amount Black Drop",null,{"$f":"B5+B7","v":2},null,null,null,"Bearing #83107",0.2046,1,{"$f":"Q81*P81","v":0.2046},"lbs.","Ends and Top",{"$f":"(((K79+(K82*2))+10)/12)*7.05566","v":8.231603333333334},"lbs.","7.05566 lbs. / ft.",null,null,"Roller Plug #99136",0.15620000000000001,1,{"$f":"AB81*AA81","v":0.15620000000000001},"lbs."]
[null,null,null,null,null,null,null,"Enter Amount of Side Border","Enter Amount of Side Border",null,{"$f":"B6","v":2},null,null,null,"Washer #44725",1.864E-4,2,3.7280000000000001E-4,"lbs.",null,null,null,null,null,null,"Screw #82998",2E-3,3,{"$f":"AB82*AA82","v":6.0000000000000001E-3},"lbs."]
[null,null,null,null,null,null,null,"Square Feet of Fabric",null,null,{"$f":"((K79+(K82*2))*(K80+K81+36+4.5)/144)","v":1.1805555555555556},"sq. ft.",null,null,"Mtr Brkt #93205",1.7798099999999999,1,1.7798099999999999,"lbs.","Runners",{"$f":"INT((K79+(K82*2)+2.5)/14)+4","v":4},null,null,null,null,null,null,null,{"$f":"AB83*AA83","v":0},"lbs."]
[null,null,null,null,null,null,null,"Weight of Fabric",null,null,{"$f":"((K83/9) * 32)/16","v":0.26234567901234568},"lbs.",null,null,"Cover J-Box #81657",9.7600000000000006E-2,1,9.7600000000000006E-2,"lbs.","Runners Weight ",{"$f":"U83*0.1105","v":0.442},"lbs.",".1105 lbs / per pc",null,null,null,null,null,{"$f":"AB84*AA84","v":0},"lbs."]
[null,null,null,null,null,null,null,"Weight of Slat",null,null,{"$f":"((PI()*(0.1875^2))*((K79+(K82*2))+0.75))*0.284","v":0.14899248596575654},"lbs.",null,null,"Junction Box #94077",0.32400000000000001,1,0.32400000000000001,"lbs.","Shipping Strips",{"$f":"((((K79+(K82*2)+10)*2)+16)/12)*0.1707","v":0.6258999999999999},"lbs.",".17070 lbs. / per ft.",null,null,null,null,null,{"$f":"AB85*AA85","v":0},"lbs."]
[null,null,null,null,null,null,null,"Weight of Case",null,null,{"$f":"U104","v":16.461203333333334},"lbs.",null,null,"Screw #44799",6.0299999999999998E-3,2,1.206E-2,"lbs.","Splice_Connector",{"$f":"IF(K79+(K82*2)+8.5>169,1.29551,0)","v":0},"lbs.","1.29551 lbs / per splice",null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,"Weight of Roller",null,null,{"$f":"(((K79+(K82*2)+2)/12)*2.21)","v":1.105},"lbs.","2.210 lbs. / ft.",null,"Nut Tee #44824",9.1000000000000004E-3,20,0.182,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,"Miscellanous Items",null,null,{"$f":"R104","v":24.317282799999997},"lbs.",null,null,"End Brkt #82875",0.3957,1,0.3957,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,"3.25\" Roller Items",null,null,{"$f":"AC104","v":6.1572000000000005},"lbs.",null,null,"LockWasher #44733",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,"Ironing Board",null,null,{"$f":"((K79+(K82*2)+2)/12)*0.3353","v":0.16764999999999999},"lbs.",".3353 lbs. / ft.",null,"Hex Bolt #44731",4.7E-2,6,0.28200000000000003,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83501",1.9800000000000002E-2,8,0.15840000000000001,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bushing #46458",2.7000000000000001E-3,1,2.7000000000000001E-3,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #72537",6.0000000000000001E-3,2,1.2E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,"Total Weight",null,{"$f":"SUM(K84:K92)","v":48.619674298311438},"lbs.",null,null,"Brkt Hanger #46358",1.7122999999999999,3,5.1368999999999998,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46356",2.6964000000000001,3,8.0891999999999999,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brkt Hanger #46354",0.8548,3,2.5644,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nylon Lock Nut #44732",2.1499999999999998E-2,3,6.4500000000000002E-2,"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt Hex #44731",4.7E-2,3,{"$f":"Q98*P98","v":0.14100000000000001},"lbs.",null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bracket #97724 - Iron Board",0.13200000000000001,7,0.92400000000000004,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB99*AA99","v":0},"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Screw #83702",1.184E-2,7,8.2879999999999995E-2,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB100*AA100","v":0},"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nut Weld #50877",0.29599999999999999,7,2.0720000000000001,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB101*AA101","v":0},"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bolt #44777",1.9099999999999999E-2,7,0.13369999999999999,"lbs.",null,null,null,null,null,null,null,null,null,{"$f":"AB102*AA102","v":0},"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"lbs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(R80:R103)","v":24.317282799999997},null,"Total:",{"$f":"SUM(U79:U87)","v":16.461203333333334},null,null,null,null,null,"Total:",null,{"$f":"SUM(AC80:AC103)","v":6.1572000000000005}]