PIP & MPG Spreadsheet

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

Page 8 of 20
  1. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    I found rows 8 thru 21 blank. Checked old backups and it doesn't look like any data was lost. Someone just added some blank rows. Not sure why.

    So I deleted them and re-Sorted the sheet by Member name.

    Please be carefull when adding data.
     
    #141 ukr2, Oct 2, 2012
  2. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    ken, i had three entries, i don't see them anymore?:eek: i might have been in those rows.
     
    #142 bisco, Oct 2, 2012
  3. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    All,

    We need more members to add their Gas Fillup data to the PIP MPG Spreadsheet.

    Only 41 members have entered data.
    Only 125 total entries.
    Only 4 members with 8 or more entries.

    Please add your data. Thanks.
     
    #143 ukr2, Oct 3, 2012
  4. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    i'll be filling my fourth tank tomorrow.:cry:
     
    #144 bisco, Oct 3, 2012
  5. John H

    John H Senior Member

    Joined:
    Jun 4, 2012
    2,208
    558
    0
    Vehicle:
    2007 Prius
    Model:
    N/A
    Has anyone considered using google forms for collecting the data and then adding it to the spreadsheet?
     
    #145 John H, Oct 3, 2012
  6. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    John,
    We are using Google Doc Spreadsheet.
    What is Google Forms? How will it help streamline the process?
     
    #146 ukr2, Oct 4, 2012
  7. Tracksyde

    Tracksyde Member

    Joined:
    Sep 21, 2011
    1,429
    761
    0
    Location:
    So Cal
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    Check out this page:

    Create, send, share, and edit a form - Google Docs Help

    I opened the spreadsheet and clicked on Tools, but I didnt see a Form option. Maybe only you can see it since you're one of the owners?
     
    #147 Tracksyde, Oct 5, 2012
  8. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    OK, I created the FORM.

    It seems to just be another Tab of the Shreadsheet, requiring me to Move the Info to the MPG Tab before backing it up.

    The advantage, I guess, is that everyone wouldn't be in the MPG tab, after I protect it.
     
    #148 ukr2, Oct 6, 2012
    John Hatchett likes this.
  9. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    All,

    We want to get more Members of PC to enter your Gas Fillup data to the MPG Spreadsheet.
    However, the spreadsheet keeps getting messsed up and needs correction.

    Therefore, I created an "Enter Data Here" Form as the first tab.
    Please enter your new data there and NOT the MPG tab.
    I'll then move your data to the MPG tab.

    Thanks,
     
    #149 ukr2, Oct 8, 2012
    John Hatchett likes this.
  10. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    thanks ken, any chance of finding my lost data?
     
    #150 bisco, Oct 8, 2012
  11. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    I found 3 in the backup
    6/18/2012
    7/29/2012
    8/28/2012

    Was that it?
     
    #151 ukr2, Oct 8, 2012
  12. John H

    John H Senior Member

    Joined:
    Jun 4, 2012
    2,208
    558
    0
    Vehicle:
    2007 Prius
    Model:
    N/A
    Can I make another suggestion?

    In addition to the Fleet averages calculated and displayed on the top row, calculate and display a "mean".

    To add a bit of recognition/reward for participation, highlight the members/rows that are above the "mean".
     
    #152 John H, Oct 8, 2012
  13. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    those are they!:) thanks ken!!! i'll add my fourth today.
     
    #153 bisco, Oct 9, 2012
  14. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    ken, how do i move data from 'add data here' to the spreadsheet? thanks!
     
    #154 bisco, Oct 14, 2012
  15. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    I'll do it. Thanks.
     
    #155 ukr2, Oct 14, 2012
  16. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    ken, can you move my new data please?
     
    #156 bisco, Nov 5, 2012
  17. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    Done. Thanks Bisco.

    Hopefully others will also add their new Fillup Data to the 1st Tab labeled Enter Data Here and NOT to the MPG Sheet.

    Then I'll move it to the MPG Sheet to keep the sheet clean of errors.
     
    #157 ukr2, Nov 5, 2012
  18. bisco

    bisco cookie crumbler

    Joined:
    May 11, 2005
    110,571
    50,262
    0
    Location:
    boston
    Vehicle:
    2012 Prius Plug-in
    Model:
    Plug-in Base
    thank you ken!
     
    #158 bisco, Nov 5, 2012
  19. Econ

    Econ Member

    Joined:
    Sep 4, 2009
    329
    26
    14
    Location:
    East of the Berkshires - MA
    Vehicle:
    2010 Prius
    Model:
    Five
    Yes, that is a good feature. works well.
     
    #159 Econ, Nov 12, 2012
  20. ukr2

    ukr2 Senior Member

    Joined:
    Feb 5, 2007
    1,009
    275
    31
    Location:
    Victor, NY
    Vehicle:
    2021 Prius Prime
    Model:
    XLE
    PLEASE DON'T Restore a Past Version !!!
     
    #160 ukr2, Nov 12, 2012
(You must log in or sign up to post here.)
Page 8 of 20