drees wrote:turbo has been gracious enough to give me access to the sheet along with detailed instructions, so I will also be assisting with keeping things updated as I have time.
I do agree that some of the bad entries should be cleaned up: Robertwray and mckemie for example which contains clearly erroneous data - how should we deal with them?
For the moment, color code them as erroneous and put them at the end (last rows) of the spreadheet. If the errors are so bad as to make the entire entry useless, and there have been no updates to it in the last 3? months, then delete it.
Entries that seem mostly correct, have some value, but are maybe a bit stale, I think still add some value and should be left in order. You could color code entries that haven't been updated for over 1? 2? months as stale.
If an entry appears to have a valid VIN, it's probably worth keeping for VIN tracking, especially if there is an associated valid forum id. Entries that we want to keep but are too erroneous or incomplete to be useful in order tracking could be moved to a new tab in the spreadsheet, "Partial entries" or "Incomplete entries". Preserving partials may be useful for at least a short time, in case someone submits the change form with not enough information, sees the feedback in the spreadsheet that their entry is partial and can see that they need to improve it.
Blue Nissan Leaf SL+QC rsrvd 4/21/10 order 11/24/10 delivered 5/29/11 (Apr May Jun Jul Jun May Jun) Polar Bear Hug 12/11/2010
1999 Green GM EV1, 7.2kW Solar Electric (PV); 2002 RAV4 EV; Carbon Neutral since 2010
It's time to LEAF! LEAF Oil behind!