Spreadsheet: 64835d1265660290-isolating-data-example-two
Sheet: Summary

Trip Number | Trip Delivery Date | Resource Name | Agency Pay Rate | Qty | Amount | Work Description | FW Rate | DR Rate | Amount | FW Total | DR Total | DR Ind | FW Ind | 0
266012 | 2010-01-25 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to MISSISSAUGA,ON | 81 | 62 | 62 | 81 | 62 | 62 | 81
266011 | 2010-01-25 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to WHITBY,ON | 81 | 62 | 62 | 162 | 124 | 124 | 162
266229 | 2010-01-26 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 148 | REXDALE,ON to BUFFALO,NY | 148 | 114 | 114 | 310 | 238 | 238 | 310
266229 | 2010-01-26 00:00:00 | ATHWAL,GURDIP | Canadian Linehaul Hourly | 1.75 | 37.19 | Hourly Pay | 21.25142857142857 | 17 | 29.75 | 347.19 | 267.75 | 267.75 | 347.19
266984 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | BRAMPTON,ON to REXDALE,ON | 81 | 62 | 62 | 428.19 | 329.75 | 329.75 | 428.19
266741 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 106 | BRAMPTON,ON to ANCASTER,ON | 106 | 80 | 80 | 534.19 | 409.75 | 409.75 | 534.19
266894 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Hourly | 0.5 | 10.63 | Hourly Pay | 21.26 | 17 | 8.5 | 544.82 | 418.25 | 418.25 | 544.82
266894 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Pickup | 1 | 21.25 | City Pickup | 21.25 | 17 | 17 | 566.07 | 435.25 | 435.25 | 566.07
266408 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Hourly | 1.75 | 37.19 | Hourly Pay | 21.25142857142857 | 17 | 29.75 | 603.26 | 465 | 465 | 603.26
266408 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 92 | REXDALE,ON to AJAX,ON | 92 | 71 | 71 | 695.26 | 536 | 536 | 695.26
266655 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | Extra Stop | 5 | 106.25 | Extra Stop | 21.25 | 17 | 85 | 801.51 | 621 | 621 | 801.51
266655 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | City Pickup | 1 | 119 | City Pickup | 119 | 90 | 90 | 920.51 | 711 | 711 | 920.51
266702 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to MISSISSAUGA,ON | 81 | 62 | 62 | 1001.51 | 773 | 773 | 1001.51
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | 1001.51 | #N/A | #N/A | 0
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | 1001.51 | #N/A | #N/A | 0
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | 1001.51 | #N/A | #N/A | 0
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | 1001.51 | #N/A | #N/A | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1001.51 | #N/A | 0 | 0
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1022.76 | #N/A | 17 | 21.25
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | Extra Stop | 1 | 21.25 |  | 21.25 | 17 | 17 | 1044.01 | #N/A | 34 | 42.5
266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 92 | BRAMPTON,ON to BURLINGTON,ON | 92 | 71 | 71 | 1136.01 | #N/A | 105 | 134.5
0 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1157.26 | #N/A | 122 | 155.75
266411 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 74 | BRAMPTON,ON to REXDALE,ON | 74 | 57 | 57 | 1231.26 | #N/A | 179 | 229.75
266324 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 106 | BRAMPTON,ON to ANCASTER,ON | 106 | 80 | 80 | 1337.26 | #N/A | 259 | 335.75
266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 92 | BRAMPTON,ON to BURLINGTON,ON | 92 | 71 | 71 | 1429.26 | #N/A | 330 | 427.75
266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | 0.75 | 15.94 | Hourly Pay | 21.25333333333333 | 17 | 12.75 | 1445.2 | #N/A | 342.75 | 443.69
266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | 2.25 | 47.82 | City Hourly | 21.25333333333333 | 17 | 38.25 | 1493.02 | #N/A | 381 | 491.51
266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Pickup | 1 | 21.25 | City Pickup | 21.25 | 17 | 17 | 1514.27 | #N/A | 398 | 512.76
266881 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 74 | BRAMPTON,ON to REXDALE,ON | 74 | 57 | 57 | 1588.27 | #N/A | 455 | 586.76
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1609.52 | #N/A | 472 | 608.01
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 86 | REXDALE,ON TO MARKHAM,ON | 86 | 67 | 67 | 1695.52 | #N/A | 539 | 694.01
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Extra Stop | 5 | 106.25 | Extra Stop | 21.25 | 17 | 85 | 1801.77 | #N/A | 624 | 800.26
266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Offroute Miles | 42 | 19.32 | Offroute Miles | 0.46 | 0.38 | 15.96 | 1821.09 | #N/A | 639.96 | 819.58
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1821.09 | #N/A | 0 | 0
266355 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 1907.09 | #N/A | 67 | 86
266351 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 1993.09 | #N/A | 134 | 172
266353 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2079.09 | #N/A | 201 | 258
266572 | 2010-01-26 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2165.09 | #N/A | 268 | 344
266571 | 2010-01-26 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2251.09 | #N/A | 335 | 430
266778 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2337.09 | #N/A | 402 | 516
266781 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2423.09 | #N/A | 469 | 602
266779 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2509.09 | #N/A | 536 | 688
266780 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2595.09 | #N/A | 603 | 774
266962 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2681.09 | #N/A | 670 | 860
266963 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | Spot Empty | 1 | 21.25 |  | 21.25 | 17 | 17 | 2702.34 | #N/A | 687 | 881.25
266963 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2788.34 | #N/A | 754 | 967.25
266961 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2874.34 | #N/A | 821 | 1053.25
267106 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2960.34 | #N/A | 888 | 1139.25
267107 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 3046.34 | #N/A | 955 | 1225.25
267108 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 3132.34 | #N/A | 1022 | 1311.25
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0