smkettner
Posts: 7501
Joined: Mon Aug 09, 2010 10:13 pm
Delivery Date: 26 Feb 2014
Location: Orange County, CA

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 3:29 pm

And the canceled orders can be deleted.... what is the point?
1 bar lost at 21,451 miles, 16 months.
2 bar lost at 35,339 miles, 25 months.
LEAF traded at 45,400 miles for a RAV4-EV
RAV4 traded in for I-Pace Dec 2018

derkraut
Posts: 1519
Joined: Fri Jul 16, 2010 7:39 pm
Delivery Date: 14 Jun 2011
Leaf Number: 004248
Location: San Diego vicinity

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 3:42 pm

Please remove my data from the spreadsheet. Thanks. :)
Derkraut
Color: Cayenne SLE, ETEC trim
reserved: 5/15/2010
Leaf del. 6/14/2011
New Traction battery installed on 7/28/2017:

User avatar
turbo2ltr
Posts: 1376
Joined: Fri Jul 30, 2010 11:13 pm
Delivery Date: 04 Feb 2011
Leaf Number: 185
Location: Phoenix, AZ

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 4:50 pm

My philosophy in maintaining the sheet has been that some data is better than no data. I don't think anything should be deleted, with the exception of entries that don't have a corresponding account on MNL. Almost every entry has been updated at least once since Jan. To delete people that haven't updated in 30 days is way overkill. I updated a LOT of entries recently of people that just got their car but haven't updated in several months. I see no reason people should be deleted just because they don't visit the spreadsheet every 30 days to update their information that may or may not have changed.

If you really want to have such a small dataset, then download a copy of the current spreadsheet, make the changes you want to make and post it back up in your own account.

The entries with obviously wrong order date...sure we can delete their order date to bump them to the bottom of the list.

Please just accept that no one has time to chase after people to update their entry. Hey if someone want's to do so, go for it but I believe it's futile. The spreadsheet is 'user generated', so it is what the users make it. It will be useless when the masses make it useless. But the fact is, a few people can't make up for non-participation of tens or hundreds of others. It just isn't going to happen.

Canceled orders are noted and kept as a placeholder for the VIN. It's just another datapoint. The more data, the better. It's not polluting the dataset. Especially since they represent like .01% of all entries.
Silver SL-e
Ford F450 Crew Cab Hybrid Conversion

smkettner
Posts: 7501
Joined: Mon Aug 09, 2010 10:13 pm
Delivery Date: 26 Feb 2014
Location: Orange County, CA

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 5:09 pm

Sorry I did not mean to say to delete all entries not updated in the last 30 days. Only to scrutinize for errors that only confuse the issue or basically provide nothing. Then of this error group check if the person has made any recent effort to stay updated.
1 bar lost at 21,451 miles, 16 months.
2 bar lost at 35,339 miles, 25 months.
LEAF traded at 45,400 miles for a RAV4-EV
RAV4 traded in for I-Pace Dec 2018

smkettner
Posts: 7501
Joined: Mon Aug 09, 2010 10:13 pm
Delivery Date: 26 Feb 2014
Location: Orange County, CA

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 5:13 pm

I can also see holding onto all data if that is best.
I guess I primarily see the sheet as driving the wheresmyleaf page.
The other stuff is important also to someone.
1 bar lost at 21,451 miles, 16 months.
2 bar lost at 35,339 miles, 25 months.
LEAF traded at 45,400 miles for a RAV4-EV
RAV4 traded in for I-Pace Dec 2018

smkettner
Posts: 7501
Joined: Mon Aug 09, 2010 10:13 pm
Delivery Date: 26 Feb 2014
Location: Orange County, CA

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sun May 15, 2011 5:15 pm

With any luck I will make a final update this next week and let this thing morph around on its own.
1 bar lost at 21,451 miles, 16 months.
2 bar lost at 35,339 miles, 25 months.
LEAF traded at 45,400 miles for a RAV4-EV
RAV4 traded in for I-Pace Dec 2018

stanley
Posts: 607
Joined: Tue Jul 13, 2010 3:48 pm

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sat May 21, 2011 8:24 am

Thank you for keeping the Spreadsheet frequently up to date. It is very useful when kept current.

opencar
Posts: 177
Joined: Thu Aug 19, 2010 7:31 am
Delivery Date: 01 Jun 2011
Location: San Diego Coastal

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Sat May 21, 2011 8:46 am

smkettner wrote:With any luck I will make a final update this next week and let this thing morph around on its own.

smkettner - much thanks for the update; it's very helpful to see the recent deliveries!
1st bar- 22K, 27mo, Ah=55.29
2nd- 33K, 37mo, Ah=51.54
3rd- 41K, 46mo, Ah=47.47
4th- 49K, 53mo, Ah=43.28
Warranty Lizard- 50K, Oct'15
1st bar- 34K, 44mo, Ah=55.25, Jun'19

stanley
Posts: 607
Joined: Tue Jul 13, 2010 3:48 pm

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Wed May 25, 2011 6:37 pm

Are the spreadsheets still being updated?

User avatar
DaveEV
Posts: 6251
Joined: Fri Apr 23, 2010 3:51 pm
Location: San Diego

Re: Spreadsheet : VINs, Delivery Dates, Order Dates etc

Wed May 25, 2011 6:58 pm

stanley wrote:Are the spreadsheets still being updated?
Yes - you can see the last updated date on the update form itself.

Return to “News & Main LEAF Discussion”