Spreadsheet: 129255d1321524514-index-match-formula-to-find-average-sample-mpg
Sheet: MPG

 | Drivers names | MPG-AVERAGE
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Trevor
Date | Driver Name | Total KMs Travelled | Total Miles Travelled | MPG
01.11.11 | [NAME] | 463 | 287.5776397515528 | 11.88479954827781
01.11.11 | [NAME] | 24 | 14.90683229813665 | 3.986262331019364
01.11.11 | [NAME] | 214 | 132.9192546583851 | 7.950670153644981
01.11.11 | [NAME] | 578 | 359.0062111801242 | 9.89116506681724
01.11.11 | Trevor | 220 | 136.6459627329193 | 10.01923462232018
01.11.11 | [NAME] | 196 | 121.7391304347826 | 9.223768115942027
01.11.11 | [NAME] | 275 | 170.8074534161491 | 9.355309436503779
01.11.11 | [NAME] | 403 | 250.3105590062112 | 8.88993594720497
01.11.11 | [NAME] | 37 | 22.98136645962733 | 6.14548776032152
01.11.11 | Trevor | 574 | 356.5217391304348 | 10.06675668376992
01.11.11 | [NAME] | 390 | 242.2360248447205 | 9.493146284000856
01.11.11 | [NAME] | 381 | 236.6459627329192 | 9.779932241671371
01.11.11 | [NAME] | 215 | 133.5403726708074 | 9.636103716849059
01.11.11 | [NAME] | 573 | 355.9006211180124 | 9.406536183735376
02.11.11 | Trevor | 504 | 313.0434782608696 | 10.16496894409938
02.11.11 | [NAME] | 108 | 67.0807453416149 | 8.470807453416148
02.11.11 | [NAME] | 346 | 214.9068322981366 | 8.495360518498515
02.11.11 | [NAME] | 384 | 238.5093167701863 | 9.511082052958484
02.11.11 | [NAME] | 38 | 23.60248447204969 | 4.291875776397515
02.11.11 | Trevor | 338 | 209.9378881987577 | 8.676160361377752
02.11.11 | [NAME] | 392 | 243.4782608695652 | 9.301278772378517
02.11.11 | [NAME] | 381 | 236.6459627329192 | 8.675746343418153
02.11.11 | [NAME] | 16 | 9.937888198757763 | 0
02.11.11 | [NAME] | 573 | 355.9006211180124 | 9.573516115991032
02.11.11 | Trevor | 386 | 239.751552795031 | 9.73134427684117
02.11.11 | [NAME] | 38 | 23.60248447204969 | 0
02.11.11 | [NAME] | 410 | 254.6583850931677 | 11.02549541555753
03.11.11 | [NAME] | 454 | 281.9875776397515 | 9.425849470222872
03.11.11 | [NAME] | 355 | 220.4968944099379 | 9.546465542738835
03.11.11 | Trevor | 196 | 121.7391304347826 | 7.379014492753623
03.11.11 | [NAME] | 468 | 290.6832298136646 | 12.01314511575381
03.11.11 | [NAME] | 54 | 33.54037267080745 | 1.675544331444953
03.11.11 | [NAME] | 212 | 131.6770186335404 | 0
03.11.11 | [NAME] | 397 | 246.583850931677 | 10.67590653652766
03.11.11 | Trevor | 393 | 244.0993788819876 | 7.926255545696541
03.11.11 | [NAME] | 570 | 354.0372670807453 | 9.46737303617099
03.11.11 | [NAME] | 389 | 241.6149068322981 | 4.224543717152413
03.11.11 | [NAME] | 51 | 31.67701863354037 | 0
03.11.11 | [NAME] | 36 | 22.36024844720497 | 5.979393496529046
03.11.11 | Trevor | 414 | 257.1428571428571 | 11.68971428571428
04.11.11 | [NAME] | 500 | 310.5590062111801 | 10.77710871935897
04.11.11 | [NAME] | 393 | 244.0993788819876 | 9.247298136645963
04.11.11 | [NAME] | 214 | 132.9192546583851 | 8.75725987937708
04.11.11 | [NAME] | 341 | 211.8012422360248 | 8.915263400046008
04.11.11 | Trevor | 69 | 42.85714285714285 | 0
04.11.11 | [NAME] | 417 | 259.0062111801242 | 9.419537888198757
04.11.11 | [NAME] | 518 | 321.7391304347826 | 10.08707646176912
04.11.11 | [NAME] | 406 | 252.1739130434783 | 9.245021037868163
04.11.11 | [NAME] | 570 | 354.0372670807453 | 9.754263128176172
04.11.11 | Trevor | 394 | 244.7204968944099 | 9.118847367885145
04.11.11 | [NAME] | 395 | 245.3416149068323 | 9.532675054414185
04.11.11 | [NAME] | 48 | 29.81366459627329 | 1.426662307943773
04.11.11 | [NAME] | 49 | 30.43478260869565 | 0
05.11.11 | [NAME] | 398 | 247.2049689440994 | 10.21630717108978
05.11.11 | Trevor | 231 | 143.4782608695652 | 8.81421856639248
05.11.11 | [NAME] | 569 | 353.416149068323 | 9.73715038584604
05.11.11 | [NAME] | 393 | 244.0993788819876 | 10.08796160361378
05.11.11 | [NAME] | 204 | 126.7080745341615 | 8.86176779741997