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

PIP & MPG Spreadsheet

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

  1. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    excuse me?(n)
     
  2. stacey

    stacey ☆☆☆☆☆

    Joined:
    Aug 2, 2004
    115
    23
    0
    Location:
    Lancaster, PA
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Advanced
    Has something happened to the spreadsheet? I went to add some fillups and it tells me that I need to ask for permission. I did that last week I think, but no luck getting permission so far.

    upload_2014-8-6_16-7-23.png
     
  3. 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 still would be open to making a form for people to very easily input their data. It would have an accompanying spreadsheet.
     
  4. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    sagebrush tried to look at my stats, and it wouldn't even let him look.
     
  5. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,492
    1,231
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    I'm fine with it either way.
    Waiting for ukr2 ( lives a half hour drive away from me) to get back to my access request. He probably has a lot of them, even though he posted that there are really not that many users yet.
    Or adding data on a new spreadsheet you put together.
     
  6. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    hey ken, what up with the password? pm sent.
     
  7. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    All, It looks like Google made a change, but I Removed any need for a password. Try Again.
     
  8. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    that's better, thanks ken!(y)
     
  9. Will Stewart

    Will Stewart Junior Member

    Joined:
    May 27, 2014
    45
    11
    4
    Location:
    Northern Virginia
    Vehicle:
    2014 Prius Plug-in
    Model:
    Plug-in Base
    I get this for both the spreadsheet and the input form;

    Sorry, the file you have requested does not exist.

    Please check the address and try again.​

    Is this a new problem?
     
  10. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    i pm'ed ken, i don't get the sign in anymore, but it won't let me add my new info. hopefully, he can figure it out. i wonder if google has locked us out?
     
  11. Will Stewart

    Will Stewart Junior Member

    Joined:
    May 27, 2014
    45
    11
    4
    Location:
    Northern Virginia
    Vehicle:
    2014 Prius Plug-in
    Model:
    Plug-in Base
    Ok, I can access it now, was hitting the wrong links (thought the first link was a Google Docs Welcome message).

    Questions, as the instructions in the 1st post don't agree with the way the spreadsheet is laid out;

    1. What is the difference between Metered kWh and kWh columns? I don't have anything but the 110v EVSE that came with the car, so perhaps this refers to a wall mount unit that retains kWh history.
    2. Do we enter our data on line 4, then someone takes it and puts it somewhere else?

    I would suggest updating the original post so that people don't have to look through 18 pages of comments to understand what's going on.
     
    #351 Will Stewart, Aug 21, 2014
    Last edited: Aug 21, 2014
  12. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    yes, ken (UKR2) got it fixed this week. metered kWh are about 15% higher than what is shown on the car screen. people who have measured it at the wall came up with that because it takes into account charging losses which the car doesn't. enter your info in the 'enter data here' tab under ken's example. he will move it when he see's it, or you can pm and ask him to.
     
  13. gallde

    gallde Active Member

    Joined:
    Jul 29, 2004
    238
    130
    0
    Location:
    Tarrytown, NY
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    How does one find their PIP "order number"? I don't see it on my 11/2011 order confirmation from Toyota.
     
  14. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    can you provide us with more background info? why are you in the spreadsheet thread?
     
  15. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,492
    1,231
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    Has anyone else ever gotten their - HSI and Ratio screen - trips out of sync?:eek:
     
  16. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    oh ya, ya.
     
  17. vvillovv

    vvillovv Senior Member

    Joined:
    Mar 19, 2013
    3,492
    1,231
    1
    Location:
    NY
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Plus
    I added july 10th and sept 13th and I think they add up.
    But if I screwed up, sorry ...

    my HSI (Trip A) is currently at 716.9 mi
    and it's going to take me a while to find where it was reset
    and my HSI (Trip B) was reset jul 10th
    I'm starting to get how they are setup, but ....
     
    #357 vvillovv, Sep 18, 2014
    Last edited: Sep 18, 2014
  18. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    looking good ken, thank you.
     
  19. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    107,571
    48,862
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    hi ken, please move my fill up in, thank you!
     
  20. Tracksyde

    Tracksyde Member

    Joined:
    Sep 21, 2011
    1,429
    761
    0
    Location:
    So Cal
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    I was just looking through the PiP Order worksheet for old time's sake and it looks like some data for shuffled around.. when I look down my row (120), towards the end, with build date n' stuff like that, its all messed up. I see some of my information a few rows up and in other columns, its a few rows down or something..

    Not a big deal, but just wanted to point that out