1. Attachments are working again! Check out this thread for more details and to report any other bugs.

Top 20 - MPG Record Holders

Discussion in 'Gen 3 Prius Fuel Economy' started by F8L, Jul 25, 2012.

  1. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    Hummmm, now I'm confused. Are we supposed to use the calculated or the MFD mileage?

    We're all aware that the MFD mileage is off but due to an early tire replacement, I traced my error to the tires as it was also proportional to the tripmeter and odometer distance error. With replacement tires, our distance and speed error measures less than 1%.

    I am pretty sure holding the pump handle upside down, reaching across the rear of the car, led to a short tank fill on the 1,000 mile tank. But on the refill after the 1000 mile tank, I was in the correct lane and the pump handle was in the correct orientation. Regardless, here is the updated list:
    username model miles gal MPG mph hrs
    1 ufourya (Prius_c) 501.1 5.02 99.9 19 26.37
    2 vincent1449p (Prius_c) 871.8 9.61 97.1 28 31.14
    3 bwilson4web (GenIII) 1000.8 10.90 91.8 22 45.49
    4 CHACHYONTOP (Prius_c) 607.9 7.50 81.1 26 23.38
    5 Ferls80 (GenIII) 750.0 9.25 81.1 25 30.00
    6 Mark57 (GenIII) 805.2 10.15 79.3 22 36.60
    7 markabele (GenIII) 818.7 10.35 79.1 24 34.11
    8 Kore971 (GenIII) 830.9 10.65 78.0 26 31.96
    9 kalome (GenIII) 703.6 9.10 77.3 27 26.06
    10 nfujii (GenIII) 550.9 7.25 76.0 21 26.23
    11 Kore971 (GenIII) 813.4 10.76 75.6 28 29.05
    12 kdkuhns3 (GenIII) 703.1 9.36 75.1 23 30.57
    13 mozdzen (GenIII) 701.9 9.55 73.5 30 23.40
    14 walter_lee (GenIII) 800.1 10.90 73.4 19 42.11
    15 hcpc (Prius_c) 548.9 7.49 73.3 31 17.71
    16 Tony_Schaefer (GenII) 662.0 9.17 72.2 25 26.48
    17 F8L (GenIII) 702.5 9.80 71.7 37 18.99
    18 Codyroo (GenIII) 752.3 10.55 71.3 35 21.49
    19 MattPersman (GenIII) 531.5 7.53 70.6 25 21.26
    20 Agent_J (GenII) 808.7 11.52 70.2 25 32.35
    21 Optical_Illusions (Prius_c) 582.1 8.39 69.4 25 23.28
    22 eliteconcept (GenIII) 541.5 7.93 68.3 43 12.59
    23 rokibler (GenIII) 626.3 9.28 67.5 31 20.20

    Source: "Top 20 thread"

    "vincent1449p" say the word and I'll use your displayed, not calculated, MPG. It just means we 'swap' positions in the list. <grins>

    Bob Wilson
     
    #701 bwilson4web, Jul 22, 2013
    Last edited: Jan 25, 2016
  2. F8L

    F8L Protecting Habitat & AG Lands

    Joined:
    Aug 14, 2006
    19,011
    4,081
    50
    Location:
    Grass Valley, CA.
    Vehicle:
    Other Non-Hybrid
    Model:
    N/A
    I'm bringing my laptop home tonight. Shall I create the separate lists for Prius, Prius c and Prius v?
     
    minkus likes this.
  3. F8L

    F8L Protecting Habitat & AG Lands

    Joined:
    Aug 14, 2006
    19,011
    4,081
    50
    Location:
    Grass Valley, CA.
    Vehicle:
    Other Non-Hybrid
    Model:
    N/A
    Bob,

    We use MFD indicated mpg. We break ties with the number of miles driven.
     
    bwilson4web likes this.
  4. minkus

    minkus Active Member

    Joined:
    Jan 4, 2013
    369
    125
    0
    Location:
    Cleveland, OH
    Vehicle:
    2012 Prius c
    Model:
    Two
    My vote is to have separate lists for each, then maybe a combined list (until the listback/c takes over the entire list). Of course, this means extra work for you, so it's totally up to you :D
     
  5. markabele

    markabele owner of PiP, then Leaf, then Model 3

    Joined:
    Mar 27, 2012
    5,084
    1,782
    1
    Location:
    Nebraska
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    Yes please!!!!
    And make a column for PiP without plugging in! :)
     
  6. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    Let me suggest a single, unified list, but with a standard, separate column for each model. That way a chart similar to this one can be generated:
    [​IMG]

    BTW, now that we understand it is the MFD mileage, Vincent's data point moves up.

    Bob Wilson
     
  7. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    The "Top 20" list provides useful information when it compares the different models. So let me suggest an approach:
    • one workbook with multiple worksheets, one for each model
    • within a worksheet, sort by descending, indicated MPG with the minimum 500 mile tank
    • then a summary worksheet takes the top "N" from each model
    • make a chart that shows the top "N" models together
    But this is discussing the technical aspects. Perhaps we might ask what other useful information this could provide to the community?
    1. Identify mileage mentors?
    2. Comparative vehicle performance?
    3. Is this something we can get from other sources such as Fuel Economy and fuelly.com?
    One of the things Jason's GreenHybrid.com provided was a vehicle performance metric by tossing out the upper and lower entries, the outliers. His average was credible with upper and lower bounds that matched what folks were achieving. It also pulled the fangs of mileage-trolls, not that there is any evidence they exist.

    Several years ago, PriusChat opened a thread discussing what sort of mileage database they might provide. A lot of good ideas but nothing showed up. Perhaps it is time to dust off the old thread and look again at what value added engineering it might provide.

    Bob Wilson
     
  8. MattPersman

    MattPersman Member

    Joined:
    Jan 29, 2012
    110
    33
    0
    Location:
    Indiana
    Vehicle:
    2011 Prius
    Model:
    Two
    I was thinking of pushing this tank to 800 but the first 150 miles of it were at 75 mph been playing catch up ever since the 0 miles till empty came on this morning at 740 miles I would still have to push it another 60 miles not sure if that is easy or not would only be like .7-.8 gallons

    72.9 mpg

    ImageUploadedByTapatalk1374596950.264974.jpg

    I have been in the mid to high 70s avg on my daily 26 mile commute touching in the low 80s on occasion
     
  9. retired4999

    retired4999 Prius driver since 2005

    Joined:
    Aug 11, 2011
    2,652
    625
    15
    Location:
    Eau Claire, Wi.
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Nice Job! :D
     
  10. rokibler

    rokibler Member

    Joined:
    May 16, 2008
    88
    31
    0
    Location:
    Cabin John, Md.
    Vehicle:
    2010 Prius
    Model:
    III
    I vote for 3 separate lists
     
  11. jsfabb

    jsfabb Active Member

    Joined:
    Aug 2, 2010
    617
    156
    0
    Location:
    Medford, NY
    Vehicle:
    2012 Prius
    Model:
    Three

    Should X axis be mph and not mpg?
     
    bwilson4web likes this.
  12. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    You're right . . . <sigh> Fix it tonight.

    Bob Wilson
     
  13. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    Column 1
    0 [tr][th]username[th]model[th]miles[th]gal[th]MPG[th]mph[th]hrs
    1 [tr][td2]ufourya[td2](Prius_c)[td2]501.1[td2]5.02[td2]99.9[td2]19[td2]26.37
    2 [tr][td2]vincent1449p[td2](Prius_c)[td2]871.8[td2]8.98[td2]97.1[td2]28[td2]31.14
    3 [tr][td2]bwilson4web[td2](GenIII)[td2]1000.8[td2]10.90[td2]91.8[td2]22[td2]45.49
    4 [tr][td2]CHACHYONTOP[td2](Prius_c)[td2]607.9[td2]7.50[td2]81.1[td2]26[td2]23.38
    5 [tr][td2]Ferls80[td2](GenIII)[td2]750.0[td2]9.25[td2]81.1[td2]25[td2]30.00
    6 [tr][td2]Mark57[td2](GenIII)[td2]805.2[td2]10.15[td2]79.3[td2]22[td2]36.60
    7 [tr][td2]markabele[td2](GenIII)[td2]818.7[td2]10.35[td2]79.1[td2]24[td2]34.11
    8 [tr][td2]Kore971[td2](GenIII)[td2]830.9[td2]10.65[td2]78.0[td2]26[td2]31.96
    9 [tr][td2]kalome[td2](GenIII)[td2]703.6[td2]9.10[td2]77.3[td2]27[td2]26.06
    10 [tr][td2]nfujii[td2](GenIII)[td2]550.9[td2]7.25[td2]76.0[td2]21[td2]26.23
    11 [tr][td2]Kore971[td2](GenIII)[td2]813.4[td2]10.76[td2]75.6[td2]28[td2]29.05
    12 [tr][td2]kdkuhns3[td2](GenIII)[td2]703.1[td2]9.36[td2]75.1[td2]23[td2]30.57
    13 [tr][td2]mozdzen[td2](GenIII)[td2]701.9[td2]9.55[td2]73.5[td2]30[td2]23.40
    14 [tr][td2]walter_lee[td2](GenIII)[td2]800.1[td2]10.90[td2]73.4[td2]19[td2]42.11
    15 [tr][td2]hcpc[td2](Prius_c)[td2]548.9[td2]7.49[td2]73.3[td2]31[td2]17.71
    16 [tr][td2]MattPersman[td2](GenII)[td2]746.7[td2]10.24[td2]72.9[td2]27[td2]27.66
    17 [tr][td2]Tony_Schaefer[td2](GenII)[td2]662.0[td2]9.17[td2]72.2[td2]25[td2]26.48
    18 [tr][td2]F8L[td2](GenIII)[td2]702.5[td2]9.80[td2]71.7[td2]37[td2]18.99
    19 [tr][td2]Codyroo[td2](GenIII)[td2]752.3[td2]10.55[td2]71.3[td2]35[td2]21.49
    20 [tr][td2]MattPersman[td2](GenIII)[td2]531.5[td2]7.53[td2]70.6[td2]25[td2]21.26
    21 [tr][td2]Agent_J[td2](GenII)[td2]808.7[td2]11.52[td2]70.2[td2]25[td2]32.35
    22 [tr][td2]Optical_Illusions[td2](Prius_c)[td2]582.1[td2]8.39[td2]69.4[td2]25[td2]23.28
    23 [tr][td2]eliteconcept[td2](GenIII)[td2]541.5[td2]7.93[td2]68.3[td2]43[td2]12.59
    24 [tr][td2]rokibler[td2](GenIII)[td2]626.3[td2]9.28[td2]67.5[td2]31[td2]20.20


    [​IMG]

    I think what makes sense is to try and move the excel spreadsheet to Google where anyone can pick up a copy and update. The advantage is we no longer would have to rely upon me or others to keep it current.

    Bob Wilson
     
  14. eliteconcept

    eliteconcept 700 mile club, top tank mpg 69.5

    Joined:
    Aug 18, 2010
    449
    186
    0
    Location:
    Indiana
    Vehicle:
    2022 Prius Prime
    Model:
    Limited
    Look at me on that chart way over at 43 mph! I'm a statically anomaly!!!!
     
  15. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus


    We're making progress in moving the spreadsheet to Goggle Docs:

    Column 1
    0 [tr][th]username[th]model[th]miles[th]MPG[th]mph[th]gal[th]hrs
    1 [tr][td2]ufourya[td2](Prius_c)[td2]501.1[td2]99.9[td2]19[td2]5.02[td2]26.4
    2 [tr][td2]vincent1449p[td2](Prius_c)[td2]871.8[td2]97.1[td2]28[td2]8.98[td2]31.1
    3 [tr][td2]bwilson4web[td2](GenIII)[td2]1000.8[td2]91.8[td2]22[td2]10.90[td2]45.5
    4 [tr][td2]Ferls80[td2](GenIII)[td2]750.0[td2]81.1[td2]25[td2]9.25[td2]30.0
    5 [tr][td2]CHACHYONTOP[td2](Prius_c)[td2]607.9[td2]81.1[td2]26[td2]7.50[td2]23.4
    6 [tr][td2]Mark57[td2](GenIII)[td2]805.2[td2]79.3[td2]22[td2]10.15[td2]36.6
    7 [tr][td2]markabele[td2](GenIII)[td2]818.7[td2]79.1[td2]24[td2]10.35[td2]34.1
    8 [tr][td2]Kore971[td2](GenIII)[td2]830.9[td2]78.0[td2]26[td2]10.65[td2]32.0
    9 [tr][td2]kalome[td2](GenIII)[td2]703.6[td2]77.3[td2]27[td2]9.10[td2]26.1
    10 [tr][td2]nfujii[td2](GenIII)[td2]550.9[td2]76.0[td2]21[td2]7.25[td2]26.2
    11 [tr][td2]kdkuhns3[td2](GenIII)[td2]703.1[td2]75.1[td2]23[td2]9.36[td2]30.6
    12 [tr][td2]mozdzen[td2](GenIII)[td2]701.9[td2]73.5[td2]30[td2]9.55[td2]23.4
    13 [tr][td2]walter_lee[td2](GenIII)[td2]800.1[td2]73.4[td2]19[td2]10.90[td2]42.1
    14 [tr][td2]hcpc[td2](Prius_c)[td2]548.9[td2]73.3[td2]31[td2]7.49[td2]17.7
    15 [tr][td2]MattPersman[td2](GenIII)[td2]746.7[td2]72.9[td2]27[td2]10.24[td2]27.7
    16 [tr][td2]tony_Schaefer[td2](GenII)[td2]662.0[td2]72.2[td2]25[td2]9.17[td2]26.5
    17 [tr][td2]F8L[td2](GenII)[td2]702.5[td2]71.7[td2]37[td2]9.80[td2]19.0
    18 [tr][td2]Codyroo[td2](GenIII)[td2]752.3[td2]71.3[td2]35[td2]10.55[td2]21.5
    19 [tr][td2]MattPersman[td2](GenIII)[td2]531.5[td2]70.6[td2]25[td2]7.53[td2]21.3
    20 [tr][td2]Agent_J[td2](GenIII)[td2]808.7[td2]70.2[td2]25[td2]11.52[td2]32.3
    21 [tr][td2]Optical_Illusions[td2](Prius_c)[td2]582.1[td2]69.4[td2]25[td2]8.39[td2]23.3
    22 [tr][td2]Eliteconcept[td2](GenIII)[td2]541.5[td2]68.3[td2]43[td2]7.93[td2]12.6
    23 [tr][td2]Rokibler[td2](GenIII)[td2]626.3[td2]67.5[td2]31[td2]9.28[td2]20.2

    Testing links to the sheet and the chart:


    I'm collaborating with a team interested in helping to carry this project forward.

    Bob Wilson
     
  16. markabele

    markabele owner of PiP, then Leaf, then Model 3

    Joined:
    Mar 27, 2012
    5,084
    1,782
    1
    Location:
    Nebraska
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    Thanks for all your work you are doing on this, Bob!

    Are PiP's welcome if we never plug in during the 500 miles and start with no charge?
     
  17. bwilson4web

    bwilson4web BMW i3 and Model 3

    Joined:
    Nov 25, 2005
    27,665
    15,664
    0
    Location:
    Huntsville AL
    Vehicle:
    2018 Tesla Model 3
    Model:
    Prime Plus
    No problem. I figured a collaborative effort would help 'share the work' so no one person is nailed. A team effort makes it a lot easier to keep current.

    Not my call but I am concerned about the Y-axis scale. The current Prius have only had 99.9 MPG as the maximum scale.

    Let me suggest we might make a model-specific version sheet and chart for each Prius model. Then we can let the different model sheets draw upon the others for a comparative chart.

    Would you be OK with hosting a thread for the "Top 20" in the Plug-In forum?

    What we can do is start the Plug-In chart with yours and build up from there. We need model specific charts so each has its own advocate.

    Bob Wilson
     
  18. markabele

    markabele owner of PiP, then Leaf, then Model 3

    Joined:
    Mar 27, 2012
    5,084
    1,782
    1
    Location:
    Nebraska
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    We already have a Top 10 MPGe thread but I don't think a thread encouraging people to go a large distance without charging would go super well over there, ha. I may be the only one crazy enough to do it which is why I thought it might be a better fit over here.
     
  19. mozdzen

    mozdzen Active Member

    Joined:
    Jan 17, 2011
    719
    295
    0
    Location:
    Phoenix
    Vehicle:
    2015 Tesla Model S
    I would like to see what a PiP could do for 500 miles. I would however, like to see it fully charged in the beginning. I think that is fair considering you'll probably only use a fraction of the charge. Even 10 miles out of 500 is only 2%. So whether it counts or not, please give it your best shot and report back.
     
  20. markabele

    markabele owner of PiP, then Leaf, then Model 3

    Joined:
    Mar 27, 2012
    5,084
    1,782
    1
    Location:
    Nebraska
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    I am so tempted to do it. Should I just do my daily commutes or try to find a loop and cheat?