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

Spreadsheet : VINs, Delivery Dates, Order Dates etc

Discussion in 'Gen 1 Prius Plug-in 2012-2015' started by csriram45, Nov 18, 2011.

  1. csriram45

    csriram45 New Member

    Joined:
    Nov 13, 2011
    37
    5
    0
    Location:
    CA - California
    Vehicle:
    2012 Prius Plug-in
    Model:
    N/A
    Hello All,

    I have created a Spreadsheet with the basic information about PIP order. Such a sheet was of great success during the initial stages of Nissan Leaf as it gave a much wider visibility on deliveries and a better estimates.

    I am also working on the form to make updates to the sheet easier. They both will need some tweaking. I will need some volunteers who can help in managing the sheet so that the information is more upto date.

    Form to enter

    https://docs.google.com/spreadsheet...mkey=dGF0WWdUZEpqWWdJOGhDWlFsWDBUdGc6MQ#gid=0

    Spreadsheet to View.

    https://docs.google.com/spreadsheet/ccc?key=0AptkktKEhdz9dGF0WWdUZEpqWWdJOGhDWlFsWDBUdGc

    Let me know if you are having any trouble entering info or suggestions or questions or comments.

    Thank you
    Sam
     
    5 people like this.
  2. jbrad4

    jbrad4 Active Member

    Joined:
    Jul 20, 2011
    474
    148
    11
    Location:
    Rowlett, TX
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Sam,

    Thanks for putting the spreadsheet together. I like seeing where other purchasers are located and what vehicle they ordered.
     
  3. csriram45

    csriram45 New Member

    Joined:
    Nov 13, 2011
    37
    5
    0
    Location:
    CA - California
    Vehicle:
    2012 Prius Plug-in
    Model:
    N/A
    Jim,

    yw. The sheet worked wonders for the Leaf orders and so I thought would be great for PIP as well since the order process is identical. The sheet is only useful when people actually enter the info. :)
     
  4. rogerv

    rogerv Senior Member

    Joined:
    Dec 10, 2008
    1,639
    317
    14
    Location:
    Simi Valley, California
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Sam,
    I filled in the time of the confirmation, but only the date shows. Seems to be true for a lot of posters, with only a couple showing the time info. Can we go back and correct it?
    Thanks,
    Roger
     
  5. csriram45

    csriram45 New Member

    Joined:
    Nov 13, 2011
    37
    5
    0
    Location:
    CA - California
    Vehicle:
    2012 Prius Plug-in
    Model:
    N/A
    Yeah I noticed that too. Although when you select the field the time is present. I believe it just does not show up. I will look at it later today to figure out whats wrong. Good thing is that the info isn't lost.

    Thanks
     
  6. pfile

    pfile Member

    Joined:
    Dec 28, 2005
    319
    35
    0
    Location:
    bay area, ca
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    thanks for making this. i've filled in my line.
     
  7. JeffFromNE

    JeffFromNE JeffTheVillagesFL

    Joined:
    Feb 7, 2008
    6
    2
    0
    Location:
    Central FL
    Vehicle:
    2017 Prius Prime
    Model:
    Prime Advanced
    Great spreadsheet. I notice there's no column for the state the dealership is located; this might be useful data.
     
  8. essaunders

    essaunders Member

    Joined:
    May 29, 2007
    195
    17
    0
    Location:
    NH
    Vehicle:
    2007 Prius
    Model:
    N/A
    I know I was shown a date of "early 2012" but now I can't find it. Where is the delivery estimate to be found?
     
  9. H2OSkier

    H2OSkier Member

    Joined:
    Jan 20, 2006
    276
    16
    0
    Location:
    Los Angeles, CA
    Thanks, added mine. From looking at the data so far, I think Dianne sold WAY more than I thought :)
     
  10. mrbigh

    mrbigh Prius Absolutum Dominium

    Joined:
    Sep 6, 2005
    3,686
    699
    2
    Location:
    Long Island, NY
    Vehicle:
    Other Electric Vehicle
    did my part also
     
  11. csriram45

    csriram45 New Member

    Joined:
    Nov 13, 2011
    37
    5
    0
    Location:
    CA - California
    Vehicle:
    2012 Prius Plug-in
    Model:
    N/A
    glad the sheet is getting some attention and traction. As days go by, I am sure the benefits will start showing up especially when its get closer to delivery. I made slight changes

    - Time in PST
    - Time in Military format.
    - Explained EVSE
     
  12. jbrad4

    jbrad4 Active Member

    Joined:
    Jul 20, 2011
    474
    148
    11
    Location:
    Rowlett, TX
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Sam,

    How does one update a field in their entry?

    When you reply, please repost your links for the spreadsheet.
     
  13. jbrad4

    jbrad4 Active Member

    Joined:
    Jul 20, 2011
    474
    148
    11
    Location:
    Rowlett, TX
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Never mind about re-posting your links. I just quoted your original post.

     
  14. rogerv

    rogerv Senior Member

    Joined:
    Dec 10, 2008
    1,639
    317
    14
    Location:
    Simi Valley, California
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Sam,
    When I entered my info, yours was in position #1, and mine was #2. Now we have moved down the list, with about six or seven ahead of us. What happened? I thought maybe it automatically adjusted the list based on the time of the order, but that doesn't appear to be true either.
     
  15. csriram45

    csriram45 New Member

    Joined:
    Nov 13, 2011
    37
    5
    0
    Location:
    CA - California
    Vehicle:
    2012 Prius Plug-in
    Model:
    N/A
    I believe its currently sorted alphabetically by username. I didn't change it but it seems to be doing it that way. We can always change it to sort by order time or order #.
     
  16. John in LB

    John in LB Life is good

    Joined:
    Aug 5, 2006
    399
    27
    0
    Location:
    Orange County
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    So where is everybody else? What happened to the hundreds / thousands of orders that were completed over the weekend?

    We are waiting.....
     
  17. radiocycle

    radiocycle Active Member

    Joined:
    May 10, 2007
    550
    78
    0
    Location:
    Vallejo, CA
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Sam, how do I edit a flub I made while entering my data??

    Tnx,
    radio
     
  18. mrbigh

    mrbigh Prius Absolutum Dominium

    Joined:
    Sep 6, 2005
    3,686
    699
    2
    Location:
    Long Island, NY
    Vehicle:
    Other Electric Vehicle
    Type over the cell that you wish to correct
     
  19. jbrad4

    jbrad4 Active Member

    Joined:
    Jul 20, 2011
    474
    148
    11
    Location:
    Rowlett, TX
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    I had to Double-Click on my entry, and then change it.
     
  20. John in LB

    John in LB Life is good

    Joined:
    Aug 5, 2006
    399
    27
    0
    Location:
    Orange County
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Advanced
    Here are some statistics from the spreadsheet.

    To date (11/21 9AM PST), 49 people filled out the form.

    • 30 (61%) are Base models
    • 31 (63%) ordered from California
    • Blizzard Pearl is the most popular color with 33%
    • It appears that approximately 2000 registrants placed an order on the very first day. We do not know how many of those actually completed their orders - It is something less than that.
    • Carson Toyota (Dianne Whitmire) must be getting a boat load of PIPs !! Her dealership has 22 of the sales (45%) - I can't help but say that she made sales because she worked the program!:cheer2:
    Alright, lets keep filling the spreadsheet. And when you do, please follow the designated patterns (e.g., for Blizzard Pearl, don't type in WHITE...)

    Enjoy. :)
     
    1 person likes this.