Spreadsheet: 232385d1367416274-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis
Sheet: Galvanized

Material | Gage | Length (ft) | width (ft) | [NAME]. ft. | thickness | tolerance | sheet weight (lb) | Price per 100 weight (lbs) (cwt) | nominal wieght (esitimated pounds ordered) | amount shipped (lbs) | date paid | date invoiced | total estimated price | invoice amount | total price paid or cost | Invoice # | actual cost per sheet | cost per sqft | number of sheets on hand | lbs on hand | total area onhand (ftsq) | dollar amount on hand | total cost/lb on hand actual | cost/sqft on hand | Vendor
Galvanized | 26 | 8 | 4 | 0.906 |  |  | 28.992 | 51.95 | 2000 | 2088 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1084.72 |  | 58218 | 15.06139954022989 | 0.4706687356321839 | 73 | 2116.416 | 2336 | 1099.482166436782 | 0.5195019157088122 | 0.4706687356321839
Galvanized | 26 | 10 | 4 | 0.906 |  |  | 36.24 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Galvanized | 24 | 8 | 4 | 1.156 |  |  | 36.992 | 45.95 | 3000 | 3071 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1411.12 |  | 57609 | 16.9977697948551 | 0.5311803060892217
Galvanized | 24 | 10 | 4 | 1.156 |  |  | 46.23999999999999 | 50.95 | 3000 | 3145 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1602.38 | 1602.3775 | 58587 | 23.55931675675676 | 0.588982918918919
Galvanized | 22 | 8 | 4 | 1.406 |  |  | 44.992 | 49.95 | 2500 | 2390 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1193.81 |  | 58218 | 22.47359812552301 | 0.7022999414225941
Galvanized | 22 | 10 | 4 | 1.406 |  |  | 56.23999999999999 | 49.95 | 3000 | 2981 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1489.01 |  | 58587 | 28.09188943307615 | 0.7022972358269037
Galvanized | 22 | 8 | 4 | 1.406 |  |  | 44.992 | 45.95 | 3000 | 3431 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1576.55 |  | 57609 | 20.67389612357913 | 0.6460592538618477
Galvanized | 22 | 10 | 4 | 1.406 |  |  | 56.23999999999999 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Galvanized | 20 | 8 | 4 | 1.656 |  |  | 52.992 | 44.95 | 2500 | 2414 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1085.09 |  | 57025 | 23.81983814415907 | 0.7443699420049709
Galvanized | 20 | 10 | 4 | 1.656 |  |  | 66.24 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Galvanized | 18 | 8 | 4 | 2.156 |  |  | 68.992 | 44.95 | 2500 | 2422 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1088.69 |  |  | 31.01193248554914 | 0.9691228901734106
Galvanized | 18 | 10 | 4 | 2.156 |  |  | 86.24000000000001 | 48.95 | 2500 | 2415 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1182.14 |  | 58218 | 42.21439072463769 | 1.055359768115942
Galvanized | 16 | 8 | 4 | 2.656 |  |  | 84.992 | 49.5 |  | 1700 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 841.5 |  | 58587 | 42.07104 | 1.31472
Galvanized | 16 | 10 | 4 | 2.656 |  |  | 106.24
Galvanized | 14 | 8 | 4 | 3.281 |  |  | 104.992
Galvanized | 14 | 10 | 4 | 3.281 |  |  | 131.24
Galvanized | 12 | 8 | 4 | 4.531 |  |  | 144.992
Galvanized | 12 | 10 | 4 | 4.531 |  |  | 181.24
Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb)
Galvanized | 26 | 8 | 4 | 0.906 |  |  | 28.992
Galvanized | 26 | 10 | 4 | 0.906 |  |  | 36.24
Galvanized | 24 | 8 | 4 | 1.156 |  |  | 36.992
Galvanized | 24 | 10 | 4 | 1.156 |  |  | 46.23999999999999
Galvanized | 22 | 8 | 4 | 1.406 |  |  | 44.992
Galvanized | 22 | 10 | 4 | 1.406 |  |  | 56.23999999999999
Galvanized | 22 | 8 | 4 | 1.406 |  |  | 44.992
Galvanized | 22 | 10 | 4 | 1.406 |  |  | 56.23999999999999
Galvanized | 20 | 8 | 4 | 1.656 |  |  | 52.992
Galvanized | 20 | 10 | 4 | 1.656 |  |  | 66.24
Galvanized | 18 | 8 | 4 | 2.156 |  |  | 68.992
Galvanized | 18 | 10 | 4 | 2.156 |  |  | 86.24000000000001
Galvanized | 16 | 8 | 4 | 2.656 |  |  | 84.992
Galvanized | 16 | 10 | 4 | 2.656 |  |  | 106.24
Galvanized | 14 | 8 | 4 | 3.281 |  |  | 104.992
Galvanized | 14 | 10 | 4 | 3.281 |  |  | 131.24
Galvanized | 12 | 8 | 4 | 4.531 |  |  | 144.992
Galvanized | 12 | 10 | 4 | 4.531 |  |  | 181.24