PIP & MPG Spreadsheet

Hard to find a Restaurant between Bangor and the border.

This is why we have cousins.

 

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?

 

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.

 

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.

 

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.

 

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?

 

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.

 

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.

 

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.

 

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

 

i am, thanks jim!

 

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.

 

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!

 

I see only one entry on the spreadsheet referenced at top of the first posting in this thread.
PIP & MPG Spreadsheet | PriusChat
Am I missing something?

 

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

 

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.