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

Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb) | Price per 100 weight (lbs) (cwt) | nominal wieght (esitimated pounds ordered)/amount purchased | 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 | $XX.XX | 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
Cold-Roll | 26 | 8 | 4 | 0.75 |  |  | 24
Cold-Roll | 26 | 10 | 4 | 0.75 |  |  | 30
Cold-Roll | 24 | 8 | 4 | 1 |  |  | 32
Cold-Roll | 24 | 10 | 4 | 1 |  |  | 40
Cold-Roll | 22 | 8 | 4 | 1.25 |  |  | 40
Cold-Roll | 22 | 10 | 4 | 1.25 |  |  | 50
Cold-Roll | 20 | 8 | 4 | 1.5 |  |  | 48
Cold-Roll | 20 | 10 | 4 | 1.5 |  |  | 60
Cold-Roll | 18 | 8 | 4 | 2 |  |  | 64
Cold-Roll | 18 | 10 | 4 | 2 |  |  | 80
Cold-Roll | 16 | 8 | 4 | 2.5 |  |  | 80
Cold-Roll | 16 | 10 | 4 | 2.5 |  |  | 100
Cold-Roll | 14 | 8 | 4 | 3.125 |  |  | 100
Cold-Roll | 14 | 10 | 4 | 3.125 |  |  | 125
Cold-Roll | 12 | 8 | 4 | 4.375 |  |  | 140
Cold-Roll | 12 | 10 | 4 | 4.375 |  |  | 175
Stainless | 26 | 8 | 4 | 0.7476 | 0.0178 |  | 23.9232
Stainless | 26 | 10 | 4 | 0.7476 | 0.0178 |  | 29.904
Stainless | 24 | 8 | 4 | 0.987 | 0.0235 |  | 31.584
Stainless | 24 | 10 | 4 | 0.987 | 0.0235 |  | 39.48
Stainless | 22 | 8 | 4 | 1.231 | 0.0293 |  | 39.392
Stainless | 22 | 10 | 4 | 1.231 | 0.0293 |  | 49.24
Stainless | 20 | 8 | 4 | 1.491 | 0.0355 |  | 47.712
Stainless | 20 | 10 | 4 | 1.491 | 0.0355 |  | 59.64
Stainless | 18 | 8 | 4 | 2.016 | 0.048 |  | 64.512
Stainless | 18 | 10 | 4 | 2.016 | 0.048 |  | 80.64
Stainless | 16 | 8 | 4 | 2.499 | 0.0595 |  | 79.968
Stainless | 16 | 10 | 4 | 2.499 | 0.0595 |  | 99.96000000000001
Stainless | 14 | 8 | 4 | 3.154 | 0.0751 |  | 100.928
Stainless | 14 | 10 | 4 | 3.154 | 0.0751 |  | 126.16
Stainless | 12 | 8 | 4 | 4.427 | 0.1054 |  | 141.664
Stainless | 12 | 10 | 4 | 4.427 | 0.1054 |  | 177.08
Notes: | did not use Invoive # 057646