Spreadsheet: 193337d1352806379-trying-to-apply-multiple-entries-with-vlookup-and-use-two-if-statements-adv-comp-project2
Sheet: Crew_Equip Data Base

 |  | Labor Code | Labor Description | [NAME] (LAB) Equip Rate (Daily) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment Rate Table
 |  | 201 | [NAME] | 38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equip Code | Equipment Description | Daily Rate
 |  | 210 | [NAME] | 39.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GVS | Gas Engine, Vibrator | 72
 |  | 301 | Laborer | 32.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CNPS | Concrete Pump, Small | 920
 |  | 310 | [NAME] | 33.25
 |  | 501 | Equipment Operator | 43.5
 |  | 502 | [NAME] | 32.75
 |  | 503 | [NAME] | 35.5
 |  | 1010 | Gas Engine, Vibrator | 72
 |  | 1020 | Concrete Pump, Small | 920
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  | Crew Compositions
 |  | Code | Crew Description |  | Crew Position Description |  | Qty |  | Crew Position Description |  | Qty |  | Crew Position Description |  |  | Qty |  | Crew Position Description | Qty |  | Crew Position Description | Qty |  | Crew Position Description | Qty |  | Crew Position Description | Qty |  | Crew Position Description | Qty
 |  | Form1 | Formwork 1 | 201 |  |  | 3 | 301 |  |  | 1
 |  | [NAME] | Formwork 2 | 201 |  |  | 3 | 301 |  |  | 1
 |  | Conc1 | Concrete 1 | 310 |  |  | 1 | 301 |  |  | 4 | 503 |  |  |  | 1 | 1010 |  | 2
 |  | Conc2 | Concrete 2 | 310 |  |  | 1 | 301 |  |  | 4 | 503 |  |  |  | 1 | 1010 |  | 2 | 501 |  | 1 | 1020 |  | 1
 |  | Finshr1 | Finishing 1 | 503 |  |  | 1
 |  | Carptr1 | Carpenters | 201 |  |  | 1
 |  | Crew Total Hourly / Daily Rates
 |  | Code | Description |  | Labor Total | Equipment Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CREW COMPOSITION TABLE
 |  | Form1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code |  | Description | QTY | MH | Labor Rate | Labor | Equip Rate | EQUIP
 |  | [NAME] |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310 |  |  | 3
 |  | Conc1 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  | 1
 |  | [NAME] |  | 3
 |  | Finshr1
 |  | Conc2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crew Designator |  |  | Form 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laborer |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crew Designator |  |  | Conc 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laborer |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas Engine Vibrator |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment Operator |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crew Designator |  | Conc 1 | Concrete Pump, Small |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  | QTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laborer |  | 4 | Crew Designator |  |  | Carptr 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1 | Description |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas Engine Vibrator |  | 2 | [NAME] |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Crew Designator |  |  | Finshr 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 1