Spreadsheet: 64835d1265660290-isolating-data-example-two
Sheet: ATHWAL, H.

AGENCY: | FIFTH WHEEL
NAME: | ATHWAL, HARJINDER
WEEK ENDING: | 2010-01-30 00:00:00
CHEQUE DATE: | 2010-01-29 00:00:00
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Flat Rate | Flat Rate | Flat Rate | Flat Rate | Flat Rate | Flat Rate | Flat Rate | Flat Rate | Extra Del, P/U, [NAME], Hourly | 0 | 0 | 0 | Canadian Tire, Flatbed | 0 | [NAME] | [NAME]
DATE
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57 | 62 | 67 | 71 | 80 | 90 | 100 | 114 | 17 | 0 | 0 | 25.5 | 19 | 0 | 0.38 | 0.43
Adjustments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 2 | 1 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 42 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REGULAR TIME: | 0 |  |  | GROSS EARNINGS: | 639.96
AGENCY: | FIFTH WHEEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME: | 0
NAME: | ATHWAL, HARJINDER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CANADIAN TIRE | 0
WEEK ENDING: | 2010-01-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLATBED | 0
CHEQUE DATE: | 2010-01-29 00:00:00
Trip Number | Trip Delivery Date | Driver Name | Work Type | Work Description | Qty | Rate | Amount
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | City Hourly | City Hourly | 1 | 17 | 17
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | Extra Stop | 0 | 1 | 17 | 17
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | [NAME] | BRAMPTON,ON to BURLINGTON,ON | 1 | 71 | 71
0 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | City Hourly | City Hourly | 1 | 17 | 17
266411 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | BRAMPTON,ON to REXDALE,ON | 1 | 57 | 57
266324 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | BRAMPTON,ON to ANCASTER,ON | 1 | 80 | 80
266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | BRAMPTON,ON to BURLINGTON,ON | 1 | 71 | 71
266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | Hourly Pay | 0.75 | 17 | 12.75
266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | City Hourly | 2.25 | 17 | 38.25
266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Pickup | City Pickup | 1 | 17 | 17
266881 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | BRAMPTON,ON to REXDALE,ON | 1 | 57 | 57
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | City Hourly | City Hourly | 1 | 17 | 17
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | [NAME] | REXDALE,ON TO MARKHAM,ON | 1 | 67 | 67
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Extra Stop | Extra Stop | 5 | 17 | 85
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Offroute Miles | Offroute Miles | 42 | 0.38 | 15.96
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  | GROSS EARNINGS |  |  | 639.96