Spreadsheet: 156047d1337161467-pivot-table-help-needed-calcuated-item-not-sure-pivot
Sheet: Log (2)

Number | ID | Completion Date | MMM-YY | Recorded Mileage
AB56NNE | 2311 | 2010-12-14 00:00:00 |  | 183589
AB56NNE | 2391 | 2011-01-03 00:00:00 |  | 184558
AB56NNE | 2413 | 2010-12-26 00:00:00 |  | 184155
AB56NNE | 2469 | 2011-01-13 00:00:00 |  | 187505
AB56NNE | 2505 | 2011-01-20 00:00:00 |  | 188369
AB56NNE | 2561 | 2011-01-29 00:00:00 |  | 189885
AB56NNE | 2606 | 2011-02-07 00:00:00 |  | 190085
AB56NNE | 2656 | 2011-02-14 00:00:00 |  | 190642
AB56NNE | 2669 | 2011-02-24 00:00:00 |  | 191409
AB56NNE | 2721 | 2011-03-02 00:00:00 |  | 191757
AB56NNE | 2760 | 2011-03-09 00:00:00 |  | 194192
AB56NNE | 2809 | 2011-03-17 00:00:00 |  | 196134
AB56NNE | 2848 | 2011-03-25 00:00:00 |  | 198577
AB56NNE | 2917 | 2011-04-01 00:00:00 |  | 199532
AB56NNE | 2963 | 2011-04-09 00:00:00 |  | 199957
AB56NNE | 2999 | 2011-04-16 00:00:00 |  | 201791
AB56NNE | 3063 | 2011-04-22 00:00:00 |  | 202209
AB56NNE | 3094 | 2011-04-29 00:00:00 |  | 202209
AB56NNE | 3133 | 2011-05-06 00:00:00 |  | 203066
AB56NNE | 3177 | 2011-05-13 00:00:00 |  | 204132
AB56NNE | 3236 | 2011-05-23 00:00:00 |  | 206018
AB56NNE | 3291 | 2011-05-27 00:00:00 |  | 207914
AB56NNE | 3306 | 2011-06-02 00:00:00 |  | 208347
AB56NNE | 3786 | 2011-08-29 00:00:00 |  | 212119
AB56NNE | 3810 | 2011-08-09 00:00:00 |  | 210641
AB56NNE | 3905 | 2011-09-06 00:00:00 |  | 215078
AB56NNE | 3949 | 2011-08-16 00:00:00 |  | 210641
AB56NNE | 3966 | 2011-08-22 00:00:00 |  | 211271
AB56NNE | 3984 | 2011-09-12 00:00:00 |  | 216511
AB56NNE | 4079 | 2011-08-02 00:00:00 |  | 208887
AB56NNE | 4114 | 2011-09-21 00:00:00 |  | 217973
AB56NNE | 4191 | 2011-10-04 00:00:00 |  | 217982
AB56NNE | 4214 | 2011-10-12 00:00:00 |  | 219121
AB56NNE | 4294 | 2011-11-21 00:00:00 |  | 230887
AB56NNE | 4295 | 2011-11-12 00:00:00 |  | 229031
AB56NNE | 4342 | 2011-11-05 00:00:00 |  | 226755
AB56NNE | 4343 | 2011-10-28 00:00:00 |  | 224461
AB56NNE | 4344 | 2011-10-19 00:00:00 |  | 221722
AB56NNE | 4513 | 2011-12-16 00:00:00 |  | 237118
AB56NNE | 4575 | 2011-12-07 00:00:00 |  | 235323
AB56NNE | 4782 | 2011-12-31 00:00:00 |  | 240130
AB56NNE | 4783 | 2011-12-23 00:00:00 |  | 237773
AB56NNE | 4814 | 2012-01-09 00:00:00 |  | 241632
AB56NNE | 4842 | 2012-01-17 00:00:00 |  | 12449
AB56NNE | 5017 | 2012-02-26 11:16:00 |  | 251110
AB56NNE | 5023 | 2012-03-05 10:45:00 |  | 252922
AB56NNE | 5027 | 2012-02-19 00:00:00 |  | 251109
AB56NNE | 5088 | 2012-01-29 00:00:00 |  | 248229
AB56NNE | 5108 | 2012-01-24 00:00:00 |  | 246683
AB56NNE | 5152 | 2012-02-06 00:00:00 |  | 249584
AB56NNE | 5364 | 2012-04-20 10:00:00 |  | 254923
AB56NNE | 5417 | 2012-05-01 00:05:00 |  | 254923
AB56NNE | 5500 | 2012-05-12 00:00:00 |  | 258530
PX51ABC | 2384 | 2010-12-28 00:00:00 |  | 114855
PX51ABC | 2423 | 2011-01-06 00:00:00 |  | 118059
PX51ABC | 2433 | 2010-12-21 00:00:00 |  | 114516
PX51ABC | 2495 | 2011-01-12 00:00:00 |  | 118620
PX51ABC | 2529 | 2011-01-19 00:00:00 |  | 119189
PX51ABC | 2586 | 2011-01-26 00:00:00 |  | 119194
PX51ABC | 2589 | 2011-02-03 00:00:00 |  | 119611
PX51ABC | 2653 | 2011-02-15 00:00:00 |  | 120673
PX51ABC | 2681 | 2011-02-23 00:00:00 |  | 122138
PX51ABC | 2720 | 2011-03-02 00:00:00 |  | 123166
PX51ABC | 2753 | 2011-03-10 00:00:00 |  | 125526
PX51ABC | 2810 | 2011-03-17 00:00:00 |  | 125950
PX51ABC | 2845 | 2011-03-28 00:00:00 |  | 127352
PX51ABC | 2927 | 2011-04-04 00:00:00 |  | 128734
PX51ABC | 2962 | 2011-04-12 00:00:00 |  | 132256
PX51ABC | 3226 | 2011-05-12 00:00:00 |  | 133230
PX51ABC | 3231 | 2011-05-19 00:00:00 |  | 134828
PX51ABC | 3297 | 2011-06-01 00:00:00 |  | 136071
PX51ABC | 3356 | 2011-06-10 00:00:00 |  | 137433
PX51ABC | 3467 | 2011-06-22 00:00:00 |  | 139141
PX51ABC | 3776 | 2011-08-26 00:00:00 |  | 151778
PX51ABC | 3812 | 2011-08-05 00:00:00 |  | 146210
PX51ABC | 3826 | 2011-08-11 00:00:00 |  | 147446
PX51ABC | 3840 | 2011-07-07 00:00:00 |  | 140686
PX51ABC | 3863 | 2011-07-14 00:00:00 |  | 141589
PX51ABC | 3916 | 2011-09-02 00:00:00 |  | 153682
PX51ABC | 3963 | 2011-08-19 00:00:00 |  | 149891
PX51ABC | 3983 | 2011-09-12 00:00:00 |  | 154967
PX51ABC | 4047 | 2011-09-28 00:00:00 |  | 159870
PX51ABC | 4071 | 2011-07-20 00:00:00 |  | 142452
PX51ABC | 4074 | 2011-07-28 00:00:00 |  | 145361
PX51ABC | 4139 | 2011-09-19 00:00:00 |  | 157174
PX51ABC | 4213 | 2011-10-11 00:00:00 |  | 162287
PX51ABC | 4302 | 2011-12-04 00:00:00 |  | 175964
PX51ABC | 4303 | 2011-11-16 00:00:00 |  | 170299
PX51ABC | 4354 | 2011-11-24 00:00:00 |  | 173032
PX51ABC | 4355 | 2011-11-07 00:00:00 |  | 167451
PX51ABC | 4356 | 2011-10-27 00:00:00 |  | 165025
PX51ABC | 4357 | 2011-10-20 00:00:00 |  | 162961
PX51ABC | 4478 | 2011-12-19 00:00:00 |  | 178043
PX51ABC | 4525 | 2011-12-12 00:00:00 |  | 177043
PX51ABC | 4535 | 2011-12-29 00:00:00 |  | 179313
PX51ABC | 4820 | 2012-01-06 00:00:00 |  | 181238
PX51ABC | 4838 | 2012-01-14 00:00:00 |  | 184107
PX51ABC | 5036 | 2012-02-25 03:50:00 |  | 196035
PX51ABC | 5064 | 2012-02-18 00:00:00 |  | 193373
PX51ABC | 5083 | 2012-01-27 00:00:00 |  | 186918
PX51ABC | 5084 | 2012-02-03 00:00:00 |  | 189468
PX51ABC | 5113 | 2012-01-20 00:00:00 |  | 184965
PX51ABC | 5126 | 2012-03-09 18:00:00 |  | 197920
PX51ABC | 5158 | 2012-02-10 00:00:00 |  | 191556
PX51ABC | 5186 | 2012-03-16 00:50:00 |  | 197927
PX51ABC | 5225 | 2012-03-23 04:10:00 |  | 19845
PX51ABC | 5275 | 2012-04-09 11:20:00 |  | 201394
PX51ABC | 5331 | 2012-04-02 14:45:00 |  | 200444
PX51ABC | 5358 | 2012-04-16 11:00:00 |  | 202332
PX51ABC | 5382 | 2012-04-23 00:00:00 |  | 202544
PX51ABC | 5416 | 2012-04-30 10:45:00 |  | 204402
PX51ABC | 5481 | 2012-05-08 05:00:00 |  | 207528
PY52DRS | 2369 | 2010-12-21 00:00:00 |  | 120631
PY52DRS | 2382 | 2010-12-28 00:00:00 |  | 121215
PY52DRS | 2409 | 2011-01-04 00:00:00 |  | 122249
PY52DRS | 2477 | 2011-01-11 00:00:00 |  | 122805
PY52DRS | 2533 | 2011-01-18 00:00:00 |  | 123565
PY52DRS | 2543 | 2011-01-25 00:00:00 |  | 123684
PY52DRS | 2644 | 2011-02-17 00:00:00 |  | 124630
PY52DRS | 2703 | 2011-02-25 00:00:00 |  | 127455
PY52DRS | 2747 | 2011-03-07 00:00:00 |  | 129152
PY52DRS | 2779 | 2011-03-14 00:00:00 |  | 129664
PY52DRS | 2831 | 2011-03-22 00:00:00 |  | 132209
PY52DRS | 2873 | 2011-03-29 00:00:00 |  | 134763
PY52DRS | 2926 | 2011-04-05 00:00:00 |  | 137047
PY52DRS | 2991 | 2011-04-14 00:00:00 |  | 140117
PY52DRS | 3070 | 2011-04-22 00:00:00 |  | 141491
PY52DRS | 3088 | 2011-05-01 00:00:00 |  | 142355
PY52DRS | 3159 | 2011-05-10 00:00:00 |  | 142871
PY52DRS | 3245 | 2011-05-17 00:00:00 |  | 142884
PY52DRS | 3272 | 2011-05-24 00:00:00 |  | 143798
PY52DRS | 3290 | 2011-05-31 00:00:00 |  | 145085
PY52DRS | 3328 | 2011-06-08 00:00:00 |  | 147716
PY52DRS | 3448 | 2011-06-18 00:00:00 |  | 149849
PY52DRS | 3494 | 2011-06-27 00:00:00 |  | 151696
PY52DRS | 3814 | 2011-08-09 00:00:00 |  | 159616
PY52DRS | 3844 | 2011-07-11 00:00:00 |  | 155418
PY52DRS | 3873 | 2011-07-04 00:00:00 |  | 153567
PY52DRS | 3922 | 2011-08-16 00:00:00 |  | 161886
PY52DRS | 3969 | 2011-08-23 00:00:00 |  | 163591
PY52DRS | 3977 | 2011-09-01 00:00:00 |  | 166377
PY52DRS | 3987 | 2011-09-13 00:00:00 |  | 168807
PY52DRS | 3992 | 2011-07-29 00:00:00 |  | 158462
PY52DRS | 4023 | 2011-07-18 00:00:00 |  | 157295
PY52DRS | 4042 | 2011-09-26 00:00:00 |  | 169857
PY52DRS | 4088 | 2011-09-06 00:00:00 |  | 166377
PY52DRS | 4136 | 2011-09-19 00:00:00 |  | 169267
PY52DRS | 4193 | 2011-10-05 00:00:00 |  | 172550
PY52DRS | 4217 | 2011-10-12 00:00:00 |  | 173482
PY52DRS | 4311 | 2011-11-28 00:00:00 |  | 192742
PY52DRS | 4312 | 2011-11-12 00:00:00 |  | 185346
PY52DRS | 4313 | 2011-11-21 00:00:00 |  | 189323
PY52DRS | 4314 | 2011-11-05 00:00:00 |  | 181887
PY52DRS | 4315 | 2011-10-28 00:00:00 |  | 129010
PY52DRS | 4316 | 2011-10-21 00:00:00 |  | 175846
PY52DRS | 4843 | 2012-01-18 00:00:00 |  | 193875
PY52DRS | 4956 | 2012-03-12 14:20:00 |  | 207024
PY52DRS | 5018 | 2012-03-03 04:15:00 |  | 204821
PY52DRS | 5034 | 2012-02-24 01:00:00 |  | 202596
PY52DRS | 5099 | 2012-01-27 00:00:00 |  | 195558
PY52DRS | 5100 | 2012-02-03 00:00:00 |  | 197782
PY52DRS | 5131 | 2012-02-17 00:00:00 |  | 201344
PY52DRS | 5154 | 2012-02-10 00:00:00 |  | 199314
PY52DRS | 5183 | 2012-03-21 04:05:00 |  | 209399
PY52DRS | 5273 | 2012-03-31 04:00:00 |  | 212103
PY52DRS | 5359 | 2012-04-14 14:00:00 |  | 212267
PY52DRS | 5387 | 2012-04-23 11:15:00 |  | 2134
PY52DRS | 5469 | 2012-05-01 00:01:00 |  | 213762
PY53EEA | 2838 | 2011-03-21 00:00:00 |  | 96816
PY53EEA | 2875 | 2009-01-09 00:00:00 |  | 0
PY53EEA | 2876 | 2009-06-22 00:00:00 |  | 0
PY53EEA | 2877 | 2010-01-22 00:00:00 |  | 0
PY53EEA | 2905 | 2011-03-31 00:00:00 |  | 97753
PY53EEA | 2992 | 2011-04-12 00:00:00 |  | 99100
PY53EEA | 3051 | 2011-04-12 00:00:00 |  | 99100
PY53EEA | 3073 | 2011-04-22 00:00:00 |  | 101742
PY53EEA | 3089 | 2011-05-03 00:00:00 |  | 103942
PY53EEA | 3141 | 2011-05-13 00:00:00 |  | 107463
PY53EEA | 3241 | 2011-05-20 00:00:00 |  | 109536
PY53EEA | 3287 | 2011-06-01 00:00:00 |  | 112460
PY53EEA | 3341 | 2011-06-09 00:00:00 |  | 115493
PY53EEA | 3384 | 2011-06-16 00:00:00 |  | 115877
PY53EEA | 3787 | 2011-08-29 00:00:00 |  | 119666
PY53EEA | 3921 | 2011-07-21 00:00:00 |  | 117655
PY53EEA | 3925 | 2011-07-29 00:00:00 |  | 117678
PY53EEA | 3937 | 2011-08-05 00:00:00 |  | 117679
PY53EEA | 3940 | 2011-08-12 00:00:00 |  | 118225
PY53EEA | 3972 | 2011-08-22 00:00:00 |  | 119666
PY53EEA | 3978 | 2011-09-12 00:00:00 |  | 119669
PY53EEA | 4038 | 2011-09-22 00:00:00 |  | 120978
PY53EEA | 4046 | 2011-09-29 00:00:00 |  | 122470
PY53EEA | 4199 | 2011-10-05 00:00:00 |  | 124195
PY53EEA | 4368 | 2011-11-29 00:00:00 |  | 139423
PY53EEA | 4372 | 2011-10-17 00:00:00 |  | 126660
PY53EEA | 4395 | 2011-11-23 00:00:00 |  | 136601
PY53EEA | 4396 | 2011-11-16 00:00:00 |  | 133797
PY53EEA | 4397 | 2011-11-08 00:00:00 |  | 131497
PY53EEA | 4398 | 2011-10-31 00:00:00 |  | 129165
PY53EEA | 4402 | 2011-10-24 00:00:00 |  | 128321
PY53EEA | 4546 | 2011-12-13 00:00:00 |  | 145477
PY53EEA | 4558 | 2011-12-06 00:00:00 |  | 142402
PY53EEA | 4730 | 2012-01-12 00:00:00 |  | 152340
PY53EEA | 4751 | 2012-01-05 00:00:00 |  | 150884
PY53EEA | 4775 | 2011-12-29 00:00:00 |  | 149760
PY53EEA | 5022 | 2012-03-05 09:55:00 |  | 166573
PY53EEA | 5063 | 2012-02-17 00:00:00 |  | 162025
PY53EEA | 5081 | 2012-02-02 00:00:00 |  | 158516
PY53EEA | 5116 | 2012-01-19 00:00:00 |  | 154878
PY53EEA | 5133 | 2012-02-25 00:03:00 |  | 163970
PY53EEA | 5151 | 2012-02-09 00:00:00 |  | 159567
PY53EEA | 5209 | 2012-03-16 05:35:00 |  | 169349
PY53EEA | 5231 | 2012-03-26 10:30:00 |  | 171237
PY53EEA | 5289 | 2012-04-03 04:00:00 |  | 173927
PY53EEA | 5320 | 2012-04-11 05:00:00 |  | 175305
PY53EEA | 5426 | 2012-03-13 22:30:00 |  | 168715
PY53EEA | 5483 | 2012-04-19 10:00:00 |  | 178153
ZX04LMA | 2387 | 2010-12-28 00:00:00 |  | 246269
ZX04LMA | 2401 | 2010-12-17 00:00:00 |  | 243818
ZX04LMA | 2407 | 2011-01-04 00:00:00 |  | 246855
ZX04LMA | 2467 | 2011-01-14 00:00:00 |  | 247781
ZX04LMA | 2509 | 2011-01-21 00:00:00 |  | 249978
ZX04LMA | 2550 | 2011-01-28 00:00:00 |  | 250810
ZX04LMA | 2575 | 2011-02-04 00:00:00 |  | 252454
ZX04LMA | 2652 | 2011-02-15 00:00:00 |  | 253910
ZX04LMA | 2680 | 2011-02-22 00:00:00 |  | 253916
ZX04LMA | 2728 | 2011-03-02 00:00:00 |  | 253917
ZX04LMA | 2824 | 2011-03-19 00:00:00 |  | 255335
ZX04LMA | 2846 | 2011-03-24 00:00:00 |  | 225806
ZX04LMA | 2906 | 2011-03-31 00:00:00 |  | 257650
ZX04LMA | 2957 | 2011-04-07 00:00:00 |  | 259160
ZX04LMA | 2998 | 2011-04-14 00:00:00 |  | 261439
ZX04LMA | 3061 | 2011-04-22 00:00:00 |  | 262272
ZX04LMA | 3095 | 2011-04-29 00:00:00 |  | 264347
ZX04LMA | 3127 | 2011-05-09 00:00:00 |  | 266544
ZX04LMA | 3211 | 2011-05-17 00:00:00 |  | 0
ZX04LMA | 3292 | 2011-05-28 00:00:00 |  | 269909
ZX04LMA | 3323 | 2011-06-04 00:00:00 |  | 271581
ZX04LMA | 3385 | 2011-06-16 00:00:00 |  | 274133
ZX04LMA | 3468 | 2011-06-23 00:00:00 |  | 276084
ZX04LMA | 3516 | 2011-06-30 00:00:00 |  | 276085
ZX04LMA | 3816 | 2011-08-04 00:00:00 |  | 282360
ZX04LMA | 3828 | 2011-08-11 00:00:00 |  | 284108
ZX04LMA | 3835 | 2011-07-06 00:00:00 |  | 276842
ZX04LMA | 3894 | 2011-09-06 00:00:00 |  | 288296
ZX04LMA | 3964 | 2011-08-18 00:00:00 |  | 284109
ZX04LMA | 3980 | 2011-09-12 00:00:00 |  | 290237
ZX04LMA | 3996 | 2011-07-28 00:00:00 |  | 281403
ZX04LMA | 4011 | 2011-07-22 00:00:00 |  | 279446
ZX04LMA | 4033 | 2011-07-15 00:00:00 |  | 278604
ZX04LMA | 4036 | 2011-09-20 00:00:00 |  | 292153
ZX04LMA | 4099 | 2011-10-06 00:00:00 |  | 294420
ZX04LMA | 4134 | 2011-08-28 00:00:00 |  | 286710