Spreadsheet: 128664d1321171528-help-with-combination-of-if-and-vlookup-formula-test-example-sept-2011
Sheet: Offer

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for Mass Calculation
 | PRODUCT | MATERIAL | GRADE | [NAME] (MM) |  | [NAME] (MM) |  | THICKNESS |  | QTY REQD | UOM | APPROX WEIGHT KGS |  | Product | Mass (kg/m)
1 | Flat | Sheet | 444 | 1.219 | WIDTH | 2.438 | LEN. | 3 | THK. | 10 | EA |  |  | Round bar and wire
2 | Tubular | AWA Tube | 304L | 50.8 | O.D. | 6000 | LEN. | 1.6 | W.T. | 200 | MT |  |  | Hexagonal bar
3 | Tubular | Square Tube | 316/316L | 31.8 | O.D. | 6000 | LEN. | 2 | W.T. | 100 | MT |  |  | Octagonal bar
4 | Bar | Round Bar | 303 | 63.5 | DIA | 6000 | LEN. |  | - | 300 | MT |  |  | Hollow round - tube and pipe
5 | Bar | [NAME] | 2205 | 15 | WIDTH | 4000 | WIDTH | 5 | THK. | 200 | MT |  |  | Square / Rectangular tube or hollow section
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hollow bar
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat product
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | Angle bar
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | D - Diameter or Outside Diameter ([NAME]) | d - Inside Diameter ([NAME])
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | S1 and S2 - side dimensions of square or rectangular hollows ([NAME])
11 |  |  |  |  |  |  |  |  |  |  |  |  |  | t - Wall Thickness of tube or pipe ([NAME])
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | T - flat product Thickness ([NAME]) | W - flat product [NAME] ([NAME])
13 |  |  |  |  |  |  |  |  |  |  |  |  |  | F - Across Flats of a Hexagon or Octagon (mm)
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | L1 & L2 - Angle bar Leg lengths ([NAME]) | t - Angle bar leg thickness (mm)
15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. These are approximate and actual weights may vary due to specific grade and dimension tolerances.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Austenitic stainless steels have slightly higher densities than carbon steels. Consult tables for exact calculations.
 | Grade, Cell D4 has different weight factors depending on grade that are required when calculating weight. Refer cells [NAME] to P23 in data |  |  |  |  |  |  |  |  |  |  |  |  | 3. Dimensional tolerances are particularly wide for hot rolled products, such as plate, pipe.and black bar.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Theoretical densities are used for all calculations, and the result is a theoretical mass. This takes no account
 |  |  |  |  |  |  |  |  |  |  |  |  |  | of dimensional tolerances.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. "Billing weights" are often used in commercial quotations - such as 8177 for austenitic stainless steel.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | This value accounts for a predominantly + tolerance for plate. It's justification for other products is less obvious.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6. Hollow round includes pipe and tube (specified by OD and WT).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7. Flat product includes plate, sheet, strip, coil and flat bar
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Densities
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Carbon steel 7800
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Stainless steel (austenitic) 7900
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Aluminium alloys 2700
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper (alloy 385) 8470