Spreadsheet: 232492d1367433360-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis-solution
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 |  |  |  | 51.95 | 2000 | 2088 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1084.72 |  | 58218 |  |  | 73
Galvanized | 26 | 10 | 4 | 0.906
Galvanized | 24 | 8 | 4 | 1.156 |  |  |  | 45.95 | 3000 | 3071 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1411.12 |  | 57609
Galvanized | 24 | 10 | 4 | 1.156 |  |  |  | 50.95 | 3000 | 3145 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1602.38 |  | 58587
Galvanized | 22 | 8 | 4 | 1.406 |  |  |  | 49.95 | 2500 | 2390 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1193.81 |  | 58218
Galvanized | 22 | 10 | 4 | 1.406 |  |  |  | 49.95 | 3000 | 2981 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 1489.01 |  | 58587
Galvanized | 22 | 8 | 4 | 1.406 |  |  |  | 45.95 | 3000 | 3431 | 2006-04-25 00:00:00 | 2006-03-24 00:00:00 |  | 1576.55 |  | 57609
Galvanized | 22 | 10 | 4 | 1.406
Galvanized | 20 | 8 | 4 | 1.656 |  |  |  | 44.95 | 2500 | 2414 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1085.09 |  | 57025
Galvanized | 20 | 10 | 4 | 1.656
Galvanized | 18 | 8 | 4 | 2.156 |  |  |  | 44.95 | 2500 | 2422 | 2006-01-27 00:00:00 | 2006-01-06 00:00:00 |  | 1088.69
Galvanized | 18 | 10 | 4 | 2.156 |  |  |  | 48.95 | 2500 | 2415 | 2006-07-23 00:00:00 | 2006-06-09 00:00:00 |  | 1182.14 |  | 58218
Galvanized | 16 | 8 | 4 | 2.656 |  |  |  | 49.5 | $XX.XX | 1700 | 2006-08-23 00:00:00 | 2006-07-27 00:00:00 |  | 841.5 |  | 58587
Galvanized | 16 | 10 | 4 | 2.656
Galvanized | 14 | 8 | 4 | 3.281
Galvanized | 14 | 10 | 4 | 3.281
Galvanized | 12 | 8 | 4 | 4.531
Galvanized | 12 | 10 | 4 | 4.531
Cold-Roll | 26 | 8 | 4 | 0.75
Cold-Roll | 26 | 10 | 4 | 0.75
Cold-Roll | 24 | 8 | 4 | 1
Cold-Roll | 24 | 10 | 4 | 1
Cold-Roll | 22 | 8 | 4 | 1.25
Cold-Roll | 22 | 10 | 4 | 1.25
Cold-Roll | 20 | 8 | 4 | 1.5
Cold-Roll | 20 | 10 | 4 | 1.5
Cold-Roll | 18 | 8 | 4 | 2
Cold-Roll | 18 | 10 | 4 | 2
Cold-Roll | 16 | 8 | 4 | 2.5
Cold-Roll | 16 | 10 | 4 | 2.5
Cold-Roll | 14 | 8 | 4 | 3.125
Cold-Roll | 14 | 10 | 4 | 3.125
Cold-Roll | 12 | 8 | 4 | 4.375
Cold-Roll | 12 | 10 | 4 | 4.375
Stainless | 26 | 8 | 4 | 0.7476 | 0.0178
Stainless | 26 | 10 | 4 | 0.7476 | 0.0178
Stainless | 24 | 8 | 4 | 0.987 | 0.0235
Stainless | 24 | 10 | 4 | 0.987 | 0.0235
Stainless | 22 | 8 | 4 | 1.231 | 0.0293
Stainless | 22 | 10 | 4 | 1.231 | 0.0293
Stainless | 20 | 8 | 4 | 1.491 | 0.0355
Stainless | 20 | 10 | 4 | 1.491 | 0.0355
Stainless | 18 | 8 | 4 | 2.016 | 0.048
Stainless | 18 | 10 | 4 | 2.016 | 0.048
Stainless | 16 | 8 | 4 | 2.499 | 0.0595
Stainless | 16 | 10 | 4 | 2.499 | 0.0595
Stainless | 14 | 8 | 4 | 3.154 | 0.0751
Stainless | 14 | 10 | 4 | 3.154 | 0.0751
Stainless | 12 | 8 | 4 | 4.427 | 0.1054
Stainless | 12 | 10 | 4 | 4.427 | 0.1054
Notes: | did not use Invoive # 057646