Spreadsheet: 64934d1265738460-isolating-data-example-three
Sheet: Summary

DR #1 | DR #2 | 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 | Vlookup
1 | 1 | 266229 | 2010-01-26 00:00:00 | ATHWAL,GURDIP | Canadian Linehaul Hourly | 1.75 | 37.19 | Hourly Pay | 21.25 | 17 | 29.75 | 37.19 | 29.75 | 29.75 | 37.19 | 2
1 | 2 | 266894 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Hourly | 0.5 | 10.63 | Hourly Pay | 21.26 | 17 | 8.5 | 47.82 | 38.25 | 38.25 | 47.82 | 3
1 | 3 | 266894 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Pickup | 1 | 21.25 | City Pickup | 21.25 | 17 | 17 | 69.07 | 55.25 | 55.25 | 69.07 | 4
1 | 4 | 266408 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | City Hourly | 1.75 | 37.19 | Hourly Pay | 21.25 | 17 | 29.75 | 106.26 | 85 | 85 | 106.26 | 5
1 | 5 | 266655 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | Extra Stop | 5 | 106.25 | Extra Stop | 21.25 | 17 | 85 | 212.51 | 170 | 170 | 212.51 | 6
1 | 6 | 266012 | 2010-01-25 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to MISSISSAUGA,ON | 81 | 62 | 62 | 293.51 | 232 | 232 | 293.51 | 7
1 | 7 | 266011 | 2010-01-25 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to WHITBY,ON | 81 | 62 | 62 | 374.51 | 294 | 294 | 374.51 | 8
1 | 8 | 266984 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | BRAMPTON,ON to REXDALE,ON | 81 | 62 | 62 | 455.51 | 356 | 356 | 455.51 | 9
1 | 9 | 266702 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 81 | REXDALE,ON to MISSISSAUGA,ON | 81 | 62 | 62 | 536.51 | 418 | 418 | 536.51 | 10
1 | 10 | 266408 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 92 | REXDALE,ON to AJAX,ON | 92 | 71 | 71 | 628.51 | 489 | 489 | 628.51 | 11
1 | 11 | 266741 | 2010-01-28 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 106 | BRAMPTON,ON to ANCASTER,ON | 106 | 80 | 80 | 734.51 | 569 | 569 | 734.51 | 12
1 | 12 | 266655 | 2010-01-29 00:00:00 | ATHWAL,GURDIP | City Pickup | 1 | 119 | City Pickup | 119 | 90 | 90 | 853.51 | 659 | 659 | 853.51
1 | 13 | 266229 | 2010-01-26 00:00:00 | ATHWAL,GURDIP | [NAME] | 1 | 148 | REXDALE,ON to BUFFALO,NY | 148 | 114 | 114 | 1001.51 | 773 | 773 | 1001.51
100 | 100 | 266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Offroute Miles | 42 | 19.32 | Offroute Miles | 0.46 | 0.38 | 15.96 | 1020.83 | 788.96 | 15.96 | 19.32
100 | 101 | 266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1042.08 | 805.96 | 32.96 | 40.57
100 | 102 | 266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | Extra Stop | 1 | 21.25 |  | 21.25 | 17 | 17 | 1063.33 | 822.96 | 49.96 | 61.82
100 | 103 | 0 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1084.58 | 839.96 | 66.96000000000001 | 83.07
100 | 104 | 266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | 0.75 | 15.94 | Hourly Pay | 21.25 | 17 | 12.75 | 1100.52 | 852.71 | 79.71000000000001 | 99.00999999999999
100 | 105 | 266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Hourly | 2.25 | 47.82 | City Hourly | 21.25 | 17 | 38.25 | 1148.34 | 890.96 | 117.96 | 146.83
100 | 106 | 266808 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | City Pickup | 1 | 21.25 | City Pickup | 21.25 | 17 | 17 | 1169.59 | 907.96 | 134.96 | 168.08
100 | 107 | 266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | City Hourly | 1 | 21.25 | City Hourly | 21.25 | 17 | 17 | 1190.84 | 924.96 | 151.96 | 189.33
100 | 108 | 266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | Extra Stop | 5 | 106.25 | Extra Stop | 21.25 | 17 | 85 | 1297.09 | 1009.96 | 236.96 | 295.58
100 | 109 | 266411 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 74 | BRAMPTON,ON to REXDALE,ON | 74 | 57 | 57 | 1371.09 | 1066.96 | 293.96 | 369.58
100 | 110 | 266881 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 74 | BRAMPTON,ON to REXDALE,ON | 74 | 57 | 57 | 1445.09 | 1123.96 | 350.96 | 443.58
100 | 111 | 266032 | 2010-01-29 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 86 | REXDALE,ON TO MARKHAM,ON | 86 | 67 | 67 | 1531.09 | 1190.96 | 417.96 | 529.5799999999999
100 | 112 | 266266 | 2010-01-24 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 92 | BRAMPTON,ON to BURLINGTON,ON | 92 | 71 | 71 | 1623.09 | 1261.96 | 488.96 | 621.5799999999999
100 | 113 | 266727 | 2010-01-28 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 92 | BRAMPTON,ON to BURLINGTON,ON | 92 | 71 | 71 | 1715.09 | 1332.96 | 559.96 | 713.5799999999999
100 | 114 | 266324 | 2010-01-26 00:00:00 | ATHWAL,HARJINDER | [NAME] | 1 | 106 | BRAMPTON,ON to ANCASTER,ON | 106 | 80 | 80 | 1821.09 | 1412.96 | 639.96 | 819.5799999999999
200 | 200 | 266963 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | Spot Empty | 1 | 21.25 |  | 21.25 | 17 | 17 | 1842.34 | 1429.96 | 17 | 21.25
200 | 201 | 266355 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 1928.34 | 1496.96 | 84 | 107.25
200 | 202 | 266351 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2014.34 | 1563.96 | 151 | 193.25
200 | 203 | 266353 | 2010-01-25 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2100.34 | 1630.96 | 218 | 279.25
200 | 204 | 266572 | 2010-01-26 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2186.34 | 1697.96 | 285 | 365.25
200 | 205 | 266571 | 2010-01-26 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2272.34 | 1764.96 | 352 | 451.25
200 | 206 | 266778 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2358.34 | 1831.96 | 419 | 537.25
200 | 207 | 266781 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2444.34 | 1898.96 | 486 | 623.25
200 | 208 | 266779 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2530.34 | 1965.96 | 553 | 709.25
200 | 209 | 266780 | 2010-01-27 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2616.34 | 2032.96 | 620 | 795.25
200 | 210 | 266962 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2702.34 | 2099.96 | 687 | 881.25
200 | 211 | 266963 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2788.34 | 2166.96 | 754 | 967.25
200 | 212 | 266961 | 2010-01-28 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2874.34 | 2233.96 | 821 | 1053.25
200 | 213 | 267106 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 2960.34 | 2300.96 | 888 | 1139.25
200 | 214 | 267107 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 3046.34 | 2367.96 | 955 | 1225.25
200 | 215 | 267108 | 2010-01-29 00:00:00 | ATHWAL,PARAMJIT | [NAME] | 1 | 86 | BRAMPTON,ON to SCARBOROUGH,ON | 86 | 67 | 67 | 3132.34 | 2434.96 | 1022 | 1311.25
2000 | 2000 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | 3132.34 | #N/A | #N/A | 0
2000 | 2001 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | 3132.34 | #N/A | #N/A | 0
2000 | 2002 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | 3132.34 | #N/A | #N/A | 0
2000 | 2003 |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | 3132.34 | #N/A | #N/A | 0
2000 | 2004 |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0
#N/A | #N/A |  |  |  |  |  |  |  |  |  |  | 3132.34 | #N/A | 0 | 0