Spreadsheet: 160221d1339010237-dependent-drop-down-list-wage-comparison-v1-modified-by-tigeravatar-
Sheet: Wage Rate Analysis

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