Spreadsheet: dea9e4e1-bec0-49b2-bb0b-c5043bdac051
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Roller Shade Parameter Calculations
Fabric weight: |  |  | 17.4 | Enter the fabric weight in ounces per square yard.
Fabric thickness: |  |  | 0.03 | Enter the fabric thickness in inches.
Hembar weight: |  |  | 6.72 | Enter the hembar weight in ounces per foot.
Tube diameter: |  |  | 3.25 | Enter the outside tube diameter in inches. |  |  |  |  | Tube technical data
Tube wall thickness: |  |  | 0.075 | Enter the tube wall thickness in inches. |  |  |  |  | Moment of inertia: | Modulus: | Sec area (sq-in): | Density (lbs-ci):
Tube composition: |  |  | A | Enter the tube composition, use "A" for Aluminum or "S" for Steel. |  |  |  |  | 0.9431792558115224 | 10000000 | 0.7477124999999991 | 0.098
Operating friction factor: |  |  | 0.1 | Enter the amount to increase the torque requirement due to friction.
[NAME] deflection factor: |  |  | 0.0014 | The maximum allowed deflection in inches, per inch of tube width. The deflection results are based on a plain round tube. A profiled tube will have less deflection.
W (in) | H (in) | Sq-Ft | Tube dia. | [NAME] (lbs) | [NAME] (lbs) | Total Wt (lbs) | Torque (in-lb) | Torque (Nm) | Roll-up dia. | Tube rotations | Tube deflection | Tube diameter "OK"
v---------v---------- (Enter custom size info on this line)
168 | 120 | 140 | 3.25 | 16.91666666666666 | 5.88 | 22.79666666666666 | 40.74904166666666 | 5.093630208333333 | 3.891120714215073 | 10.68534523691789 | 0.2298085429475494 | OK
Overview of size range data
24 | 24 | 4 | 3.25 | 0.4833333333333333 | 0.84 | 1.323333333333333 | 2.365458333333334 | 0.2956822916666667 | 3.387312714591106 | 2.288545243185099 | 5.881719308199638e-05 | OK
36 | 36 | 9 | 3.25 | 1.0875 | 1.26 | 2.3475 | 4.19615625 | 0.5245195312500001 | 3.454309489565309 | 3.405158159421825 | 0.0003211105973852356 | OK
48 | 48 | 16 | 3.25 | 1.933333333333333 | 1.68 | 3.613333333333333 | 6.458833333333334 | 0.8073541666666667 | 3.520031345452953 | 4.500522424215888 | 0.001088661032431769 | OK
60 | 60 | 25 | 3.25 | 3.020833333333333 | 2.1 | 5.120833333333334 | 9.153489583333336 | 1.144186197916667 | 3.584548408968933 | 5.575806816148887 | 0.002838022470682819 | OK
72 | 72 | 36 | 3.25 | 4.35 | 2.52 | 6.869999999999999 | 12.280125 | 1.535015625 | 3.64792460441716 | 6.632076740286001 | 0.006258500313729954 | OK
84 | 84 | 49 | 3.25 | 5.920833333333333 | 2.94 | 8.860833333333334 | 15.83873958333334 | 1.979842447916667 | 3.710218395564131 | 7.670306592735518 | 0.0122867418477138 | OK
96 | 96 | 64 | 3.25 | 7.733333333333333 | 3.36 | 11.09333333333333 | 19.82933333333333 | 2.478666666666666 | 3.771483417178559 | 8.691390286309312 | 0.02214132669874276 | OK
108 | 108 | 81 | 3.25 | 9.7875 | 3.78 | 13.5675 | 24.25190625 | 3.03148828125 | 3.831769015653637 | 9.696150260893944 | 0.03735735728831171 | OK
120 | 120 | 100 | 3.25 | 12.08333333333333 | 4.2 | 16.28333333333333 | 29.10645833333333 | 3.638307291666667 | 3.891120714215073 | 10.68534523691789 | 0.05982104928872069 | OK
132 | 132 | 121 | 3.25 | 14.62083333333333 | 4.62 | 19.24083333333333 | 34.39298958333333 | 4.299123697916666 | 3.94958061518739 | 11.65967691978984 | 0.09180432207849366 | OK
144 | 144 | 144 | 3.25 | 17.4 | 5.04 | 22.44 | 40.1115 | 5.0139375 | 4.007187749424076 | 12.6197958237346 | 0.1359993891977972 | OK
156 | 156 | 169 | 3.25 | 20.42083333333333 | 5.46 | 25.88083333333334 | 46.26198958333335 | 5.782748697916668 | 4.063978381143873 | 13.56630635239788 | 0.1955533488038592 | OK
168 | 168 | 196 | 3.25 | 23.68333333333333 | 5.88 | 29.56333333333333 | 52.84445833333334 | 6.605557291666667 | 4.119986274937715 | 14.49977124896192 | 0.2741027741263874 | USE LARGER TUBE
180 | 180 | 225 | 3.25 | 27.1875 | 6.3 | 33.4875 | 59.85890625 | 7.48236328125 | 4.175242930530573 | 15.42071550884289 | 0.3758083039229886 | USE LARGER TUBE
192 | 192 | 256 | 3.25 | 30.93333333333333 | 6.72 | 37.65333333333333 | 67.30533333333334 | 8.413166666666667 | 4.229777789933641 | 16.32962983222734 | 0.505389232934587 | USE LARGER TUBE
204 | 204 | 289 | 3.25 | 34.92083333333333 | 7.14 | 42.06083333333333 | 75.18373958333335 | 9.397967447916669 | 4.283618420854769 | 17.22697368091281 | 0.6681581023408426 | USE LARGER TUBE
216 | 216 | 324 | 3.25 | 39.15 | 7.56 | 46.71 | 83.49412500000001 | 10.436765625 | 4.33679067961052 | 18.11317799350867 | 0.8700552902155705 | USE LARGER TUBE
228 | 228 | 361 | 3.25 | 43.62083333333333 | 7.98 | 51.60083333333333 | 92.23648958333332 | 11.52956119791667 | 4.389318856272242 | 18.98864760453737 | 1.117683601982159 | USE LARGER TUBE
240 | 240 | 400 | 3.25 | 48.33333333333333 | 8.4 | 56.73333333333333 | 101.4108333333333 | 12.67635416666667 | 4.441225804358234 | 19.85376340597058 | 1.41834286086899 | USE LARGER TUBE
Notes: | For reference, plain light-filtering vinyl is 12 oz. per sq/yd and Phifer SheerWeave 4400 is 21 oz. per sq/yd.
 | Light filtering vinyl is 0.015" thick and Phifer SheerWeave 4400 is 0.031" thick.
 | Aluminum hembar 1 x 1/4" weighs 4.7 ounces per foot. A Steel hembar 1 x 1/4" weighs 13.6 ounces per foot.
 | The roll-up diameter can vary by as much as 5% depending on the tightness of the roll.
 | These calculations are theoretical and do not account for normal minor friction or friction due to fabrication error.
 | The tube diameter selected may not be suitable for the entire range of sizes. Tube deflection must be considered and varies with weight and the profile design of the tube.
 | Rule of thumb for deflection: According to Hunter Douglas specifications the maximum allowed deflection is = [NAME] (inches) /700, in other words, 0.0014" of deflection per inch of width.
 | Created by [NAME], © 2008 Somfy Systems, Inc.
610 g/m² x 1 oz/28.35 g x 0.83613 m²/yd² = 18 oz/yd²
400 | g/m² | 11.79724867724864 | oz/yd²
17.99 | oz/yd² | 609.9727315130441 | g/m²
The above chart is for reference only and may not be representative of all scenarios.
Results may vary.