Spreadsheet: 160042d1338937585-populating-cell-with-multiple-criteria-book1
Sheet: Wage Rate Analysis

Classification | 2008 - 2010 |  |  | 2010 - 2011 |  |  |  | 2011 - 2012 |  |  |  | 2011 - 2012 |  |  |  | 2011 - 2012
 | VA080032 02/08/2008 |  |  | VA100032 03/12/2010 - BUILDING |  |  |  | VA100214 03/11/2011 - BUILDING |  |  |  | VA100108 03/18/2011 - HIGHWAY |  |  |  | VA100145 09/24/2010 - HEAVY
 | Rate | Fringes | Total | Rate | Fringes | Total | Diff W/2008 | Rate | Fringes | Total | Diff W/2008 | Rate | Fringes | Total |  | Rate | Fringes | Total
[NAME] | 14.5 | 0 |  | 14.5 | 0 |  |  | 22.88 | 5.81 |  |  | N/A |  |  |  | N/A
[NAME] (excluding Drywall Hanging & Acoustical Ceiling Installation) | 12.38 | 2.54 |  | 12.38 | 2.54 |  |  | 16.11 | 2.39 |  |  | 16.07 | 0 |  |  | 17 | 4.61
Drywall Hanger | 11.31 | 2.2 |  | 11.31 | 2.2 |  |  | 0 | 0
Electrician | 17.25 | 4.18 |  | 17.25 | 4.18 |  |  | 28.45 |  |  |  | 25.08 | 0 |  |  | 22.22 | 6.4
Laborers: [NAME], [NAME] | 7.55 | 0 |  | 7.55 | 0 |  |  | 10.9 | 2.35
Laborers: [NAME], Cement / Concrete | 0 | 0 |  | 0 | 0 |  |  | 12.96 | 3.12 |  |  | 14.74 | 0 |  | Const Worker I
Laborers: unskilled - Common or General | 6.67 | 0 |  | 7.25 | 0 |  |  | 8.9 | 2.21 |  |  | 11.79 | 0 |  | Const Worker II | 9.82
Laborers: Landscape | 0 | 0 |  | 0 | 0 |  |  | 10.64 | 0 |  |  | 8.5 | 0 |  |  | 10
Laborers: Pipelayer | 0 | 0 |  | 0 | 0 |  |  | 14.44 | 2.35 |  |  | 11 | 0 |  |  | 11.65 | 1.53
Painter, [NAME], [NAME] and Roller | 12 | 0 |  | 12 | 0 |  |  | 24.1 | 8.04 |  |  | 14 | 0
Painter, Spray Only | 0 | 0 |  | 0 | 0 |  |  | 21.01 | 6.91
[NAME] (including HVAC Pipe & System Installation) | 0 | 0 | 0 | 0 | 0 | 0 |  | 27.4 | 16.65
Plumber | 12.44 | 1.09 |  | 12.44 | 1.09 |  |  | 27.4 | 16.65
Operator: Bobcat / Skid Loader | 0 | 0 | 0 | 0 | 0 |  |  | 15.62 | 2.4 |  |  |  |  |  |  | 11.4
Operator: Bulldozer | 0 | 0 | 0 | 0 | 0 |  |  | 21.5 | 4.8 |  |  | 14.66 | 0 |  |  | 22.52
Operator: Excavator | 0 | 0 | 0 | 0 | 0 |  |  | 18.38 | 4.17 |  |  | 20.36 | 0 |  |  | 25.99
Operator: Forklift | 0 | 0 | 0 | 0 | 0 |  |  | 17.93 | 7.28 |  |  | 11.89 | 0
Operator: Loader | 0 | 0 | 0 | 0 | 0 |  |  | 20.63 | 4.8 |  |  | 18.95 | 0 |  |  | 18.27 | 3.46
Operator: Mechanic | 0 | 0 | 0 | 0 | 0 |  |  | 18.23 | 1.59 |  |  | 15 | 0 |  |  | 26.78 | 6.32
Operator: Roller | 0 | 0 | 0 | 0 | 0 |  |  | 21.5 | 4.8 |  |  | 12.66 | 0
Power Equipment Operator: Backhoes | 8.87 | 0 |  | 8.87 | 0 |  |  | 17.67 | 3.16 |  |  | 17.07 | 0 |  |  | 17.61 | 2.57
Power Equipment Operator: Graders | 9.69 | 0 |  | 9.69 | 0 |  |  | 0 | 0 |  |  | 17.87 | 0
Power Equipment Operator: Cranes under 90 tons | 0 | 0 | 0 | 0 | 0 | 0 |  | 25.99 |  |  |  | 20 | 0 |  |  | 23.15
Power Equipment Operator: Cranes over 90 tons | 0 | 0 | 0 | 0 | 0 | 0 |  | 26.91 |  |  |  | 20 | 0 |  |  | 23.29 | 6.02
[NAME] | 10.27 |  |  | 10.27 | 0 |  |  | 21.55 | 7.01
Sheet Metal Worker | 11.58 | 0.42 |  | 11.58 | 0.42 |  |  | 25.62 | 11.72
Tile Setter | 15 | 0 |  | 15 | 0 |  |  | 21.12 | 7.68
Tile Finisher | 0 | 0 |  | 0 | 0 |  |  | 17.32 | 6.72 |  |  | 16.04 | 0
[NAME], Dump | 7 | 0 |  | 7.25 | 0 |  |  | 13.25 | 1.8
Boilermaker | 0 | 0 |  | 0 | 0 |  |  | 32.91 | 18.42
Elevator Mechanic | 0 | 0 |  | 0 | 0 |  |  | 33.54
Ironworker - Structural | 0 | 0 |  | 0 | 0 |  |  | 23.36 | 12.67 |  |  | 29.8 | 0 |  |  | 20.55 | 8.25
Ironwoker, Ornamental | 0 | 0 |  | 0 | 0 |  |  | 16.45 | 2.28 |  |  | 14 | 0 |  | Reinforcing | 22.45 | 11.85 |  | Reinforcing
Asbestos Worker / Heat & Frost Insulator | 0 | 0 |  | 0 | 0 |  |  | 23.29 | 10.09
Cement Mason / Concrete Finisher | 0 | 0 |  | 0 | 0 |  |  | 13.29 | 0.62 |  |  | 14 | 0 |  |  | 17 | 4.61
Sprinkler Fitter ([NAME]) | 0 | 0 |  | 0 | 0 |  |  | 16.25 | 4.37