PIP & MPG Spreadsheet

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

  1. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    I am looking at it from a Mac, OS X 10.6.8 on Firefox browser.
     
  2. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    no idea, i'm looking from dell/windows. it's a little confusing. the tabs are on the bottom, one for entry which is a blank spreadsheet with headers, and one for observation which has everyone's stats and a scroll bar on the right and bottom.
    try pm'ing ken and see if he can help.
     
  3. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    Ah, now I can see diff. things by clicking tabs at bottom. I sent Ken a PM if there is a tutorial or how to link.
    Tks
     
  4. 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
    Just put your data in the first tab, following the example, and leave it there. If you have a google account, you can sign in with it since the spreadsheet is a Google Doc.
     
  5. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    I just entered all my data via my wifes Android phone.:)
     
  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
  7. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    I understand Ken needs to load the data (I PM'ed him I had just added some data), so no worries whenever he has a chance to do that. I see the MPG sheet with all and your info. Looks like you drive about 1250 miles /mo at 68% EV (last tank). Cool to have lots of short runs beween charges! :eek:) Do you have a separate 240V metered line for your car? (how you know your 'Metered kWh's'?)
     
  8. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    I see many use the Kill A Watt meter. I just ordered a P4460 from Amazon. It will be nice not to have to run out to my PG&E smart meter to see how kW draw changes!
     
  9. 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 have an L2 evse, but no meter. i just add 15% to the car's reading which seems to be the consensus, but i'm not positive.
     
  10. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    Ken,
    Yesterday I added the data for my first tank of gas on your spread sheet. Would it be possible to change my column 'U' data to reflect my actual costs, so the info would be more accurate? Or do you prefer to keep all on the same rates for apples to apples comparison (if so, no worries), even though 0.12/kWh rate may be significantly lower that what many actually pay. And $4.17/ gal. may be more than many pay for gas.

    My specific data is: 0.231/ kWh (avg), $3.75/ gal of gas

    Thanks for all your work compiling and maintaining the MPG sheet! :)
     
  11. davekro

    davekro Member

    Joined:
    Oct 23, 2013
    486
    67
    0
    Location:
    SF Bay Area, East Bay
    Vehicle:
    2013 Prius Plug-in
    Model:
    Plug-in Base
    Ken, Thanks for entering my data. :)
     
  12. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    stealth ken.:cool:
     
  13. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Yes, I move the data you enter on the 1st tab whenever it see it. I left data of blift and Gizmoz, hopeing they will add the remaining info.
     
  14. 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
    Ken, I'm wondering if setting up a really easy to use Google Form would make the entering process much more efficient and user friendly.

    How many people are actively using your spreadsheet?
     
  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
    looks like around eight to me.
     
  16. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Not as active as I hoped.
     
  17. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    me too.:( i do enjoy having all my records in one place tho!(y)
     
  18. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    ken, if you please? thank you!
     
  19. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,443
    50,202
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    hi ken, once again please! thanks!
     
  20. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,994
    1,369
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    I just requested today
    in charlotte
    I still need an elm, but which one,
    checking the list again.
    rampup maybe slow with other pressing projects :(