PIP & MPG Spreadsheet

Done

 

Line 2 shows totals and averages.
If you want to analyze or even sort the data, please select File/Download As to copy and do your work on Your copy.
This file is shared and any change you make affects everyone. THANKS.

 

Right, I've mentioned a few times that the PIP needs a Data Logger.

I used to photograph the displays, but now I write down the screen data while I'm waiting for the pump or right after.

I use a Kill A Watt meter at home and one at work, record the daily kWh at each location on a calender and then reset them. Then I add up the total kWh for the Fillup.

I use Trip B and EV2 for the Fillup Data, then reset them. I use Trip A and EV1 to get daily data when needed.

 

It's there. I change it to point to the "Enter Data Here" tab and it changed the link to "Welcome to Google Docs".

I added a 2nd link at the top of the message too.

So just click on "Welcome to Google Docs".

 

Right, you add you data to the "Enter Data Here" tab and I move it to the MPG tab.

 

Yep,

P3 International P4400 Kill A Watt Electricity Usage Monitor by P3 International

• $50.00
  $18.99
• Order in the next 23 hours and get it by Tuesday, Jan 8.
• More Buying Choices

I bought 3 from Amazon. One for PIP at Home, one for Work and a 3rd to check my other appliances.

Home Depot only has the more expensive EZ Meter.


$28.97
P3 International Kill A Watt EZ Meter

 

External kWh is the value for Column E. It's not required, but we compare it to the PIP value from the EV screen used for Column H.

 

Jonas, You only added 1 entry. I already moved it over. -
1/4/2013 Jonas Studebaker 163Miles 4.4Gallons

 

Glad to do it.