PIP & MPG Spreadsheet

Discussion in 'Gen 1 Prius Plug-in 2012-2015' started by ukr2, Apr 5, 2012.

  1. Jonas Studebaker

    Jonas Studebaker Junior Member

    Joined:
    Nov 4, 2012
    93
    13
    0
    Location:
    Maine
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Hard to find a Restaurant between Bangor and the border.

    This is why we have cousins.
     
  2. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Jonas,

    Your last of 2 entries didn't have a date, so I added today's date.
    Also you didn't add the EV info. I added the data anyways.
     
  3. Jonas Studebaker

    Jonas Studebaker Junior Member

    Joined:
    Nov 4, 2012
    93
    13
    0
    Location:
    Maine
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    I was in the process of entering when I took a call. I saw you sweep my numbers! :) I finished both. One was yesterday, the second was today. I do not understand Column I. Where do I look for that data?
     
  4. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    column one is the total miles traveled on that tank of gas. reset trip a or b and 1 or 2 on the hsi each time you fill up and this will give you all the required data for the spreadsheet. you probably need to take a good look at the screen to understand all the data there.
     
  5. Jonas Studebaker

    Jonas Studebaker Junior Member

    Joined:
    Nov 4, 2012
    93
    13
    0
    Location:
    Maine
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Sorry Bisco - It's Column "I" as in Indiana: EV Display Gal. I don't see a number for that on either the HSI or the EVDR displays.
    I think I get all the data I need for the mpg spreadsheet when I toggle through and take photos of two displays:
    - EV Driving Ratio 1
    - Hybrid System Indicator Trip A
    (see two attachments)
    Yes, I always reset Trip A at every fillup. But I never look at "Trip B" as the only difference is it just shows the cumulative odometer mileage for the life of the car because I don't reset B at fillups.
    Likewise I never look at "EV Driving Ratio 2." The data there is the exact same as it is for "EV Driving Ratio 1" so it doesn't look like it helps for this exercise. Please let me know if I'm missing anything. Thx.
    EVDR1.jpg HSI.jpg
     
  6. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    i think you've got it! ev display gallons is in the evdr 1, 140g, but you didn't reset or it would show just the gallons it took to refill, minus the decimal. you reset the evdr by holding the button down until it resets. short button pushes toggle it back and forth between 1 and 2.
     
  7. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Like Bisco states, Column I is Gallons of Gas used since resetting the EV display or in your photo 140 G.
    Since EV + HV = 6355 miles, you probably haven't reset EV1.

    Keep asking any questions you have.
     
  8. Jonas Studebaker

    Jonas Studebaker Junior Member

    Joined:
    Nov 4, 2012
    93
    13
    0
    Location:
    Maine
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Yep, that's exactly it: I had never reset the 1 - 2 toggle. How do you spell "duh" these days?!?! Henceforth at fill ups I'll simply reset Trip A and EVDR1. (And taking a photo is is quicker than sitting there at the pump writing it down.) I'm finding there is a palpable Prius hostility out there among some drivers...slow acceleration and gradual deceleration really irks some people when they're looking at the tail end of a Prius!
    Just a thought... since most gas pumps display two or three decimals on the gallons-pumped meter, Column D gives greater precision for this exercise, but are Columns D and I both necessary?
     
    ukr2 likes this.
  9. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Jonas,

    Column D is from the Gas Pump and Column I is from the EV display. D is 3 decimals and I has none.
    Remember to record your Odometer value on your gas slip too.
     
  10. lensovet

    lensovet former BP Brigade 207

    Joined:
    May 23, 2009
    2,615
    496
    0
    Location:
    Burlington, NJ
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    finally entered all my data into Fuelly and will put it here tonight as well.
    one odd thing I noticed: in one of my fillups, the EV ratio screen showed 0 kWh consumed…and 22 EV miles traveled. Huh? Even if it had consumed 0.99999 kWh … that's still 22 mi/kWh, which is impossible.
     
  11. lensovet

    lensovet former BP Brigade 207

    Joined:
    May 23, 2009
    2,615
    496
    0
    Location:
    Burlington, NJ
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    so i just added all my fillups ever to the spreadsheet.
    Ken, I don't have any of the EV ratio screen data for the first fillup because i didn't think to save it at the time. however, i can obviously "backfill" that data next time I fill up. so…do you want to leave that first tank (650 mi) there to remind me? that way on my next fillup i can have everything completed.
    i don't have a metering device at the charger here so that column will always be blank for now
    and that first 1/6 tank is the one i was talking about above…22 EV miles, "0 kWh". I'm pretty sure what happened here was…the car was in ACC mode while it was charging at a public station, a full charge. so that should probably just read 2.78 or whatever the full usable capacity is.
    cheers
    ps. december was brutal for two reasons. one, drove down to LA and back and had no charging opportunities while driving there for a week (along with the drive there and back – about 800 miles – all in HV mode obviously). two, the garage in my building was flooded, eliminating my opportunity to charge as well. january is already much better – 74 EV miles on my last fillup and probably even more on this upcoming one.
     
  12. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    OK, I'll leave the one fillup without the EV data for you to complete.
     
  13. lensovet

    lensovet former BP Brigade 207

    Joined:
    May 23, 2009
    2,615
    496
    0
    Location:
    Burlington, NJ
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    thanks! looks like my sans-electric mileage is absolutely abysmal…never above 45 mpg, and generally in the 40-42 range. though, i guess that's not surprising – for the most part, the non-electric mileage is on freeways at speeds of 74 mph or so.
     
  14. JimPHL

    JimPHL Member

    Joined:
    Oct 7, 2012
    74
    33
    0
    Location:
    Cinnaminson, NJ
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Ken
    Just updated my data. Thanks for keeping this up.
    Looks like you did OK with snow accumulation. We only got an inch or two.

    PC Gang
    I attached my stats in case anyone is following along.
    Looking forward to spring!

    Jim
     

    Attached Files:

  15. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    i am, thanks jim!
     
  16. lensovet

    lensovet former BP Brigade 207

    Joined:
    May 23, 2009
    2,615
    496
    0
    Location:
    Burlington, NJ
    Vehicle:
    2018 Tesla Model 3
    Model:
    N/A
    so i just tried doing the "reverse" calculation and the numbers come out to be way off…like 6 kWh and 16 gallons, which is completely wrong. so we'll just have to leave that one as is, total miles+total gallons and no other data.
    also added my latest fillup.
     
  17. JimPHL

    JimPHL Member

    Joined:
    Oct 7, 2012
    74
    33
    0
    Location:
    Cinnaminson, NJ
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Wow, I've never gone so long without visiting a gas station!
    Some travel and vacation between fill ups, so that probably explains it.

    I've noticed that my tires are holding air pressure rather well.
    I keep 41 psi in the front and 39 psi in the rear and only lose 1 psi between checks.
    I check them about every two or three weeks. If they start loosing air, I will check more often.

    I've updated Ken's file and attached my tracking worksheet.
    Thanks again Ken for keeping this up!
     

    Attached Files:

  18. CaliforniaBear

    CaliforniaBear Clearwater Blue Metallic

    Joined:
    Oct 9, 2012
    1,179
    289
    0
    Location:
    Northern California
    Vehicle:
    2012 Prius
    Model:
    Plug-in Base
  19. JimPHL

    JimPHL Member

    Joined:
    Oct 7, 2012
    74
    33
    0
    Location:
    Cinnaminson, NJ
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    CalBear
    The file opens to an input page with an example.
    Ensure that you are on the 'enter data here' tab; you can see this at the bottom right area of the screen.
    Then, just input the fields that are in the example. When I open it, the cursor is teed up on the first input field.
    Simply close the window when you complete your input.
    Hope this helps.
    Jim
     
  20. lsac

    lsac Junior Member

    Joined:
    Sep 6, 2012
    7
    1
    0
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    My PIP has got 12,111 mi since 9/1/2012. The PIP gets 84 mpg with avg 24 mph. I am very happy. Last tank got me 96 mpg. My one way leisure radius is 6 mi. Job commute is about 31 mi one-way w/o charging at work, but I only go onsite twice a week. The commute is full of 32 traffic lights and all local driving in 25 - 35 mph zones with plenty local cops strictly enforcing speed limits.

    If the PIP could double the EV range, that would be perfect. Adding 200 lbs battery is not a problem, but cost is just high for now.
     
    john1701a likes this.