LEAFfan
Posts: 4828
Joined: Fri Apr 23, 2010 6:08 pm
Delivery Date: 08 Jun 2011
Leaf Number: 1855
Location: Phoenix Area

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

Sat May 14, 2011 7:47 pm

BlueSL wrote:2. It looks like Nissan is moving heaven and earth to deliver Leafs to the Forgotten September orderers before it delivers to January and February orderers.
You have to be joking, right? There are many January's that have already received their cars, not just the ones on this forum. Moving heaven and earth has taken them over 2 months! This is how long it has been in LB before estimated delivery.
2013 LEAF SV Del. 2/28/13
2013 LEAF World Record for Most Miles Driven On One Charge-188 miles/8.8 m/kW h
4.8 kW DC PV ($ .91/W fully installed)/ Dec., 2010

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

Sat May 14, 2011 10:04 pm

Now much of the formatting is shot on the spreadsheet.
What a royal pita.
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

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

Sat May 14, 2011 11:19 pm

Formatting looks fine to me. What do you mean?
Silver SL-e
Ford F450 Crew Cab Hybrid Conversion

User avatar
planet4ever
Posts: 4674
Joined: Sat Apr 03, 2010 9:53 pm
Delivery Date: 02 May 2011
Leaf Number: 1537
Location: Morgan Hill, CA, south of San Jose

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

Sun May 15, 2011 3:28 am

Many dates are being formatted as numbers. The values are correct (number of days since Dec 31,1899) but our brains aren't used to seeing 40677 instead of 5/15/2011 (or the much more reasonable 2011-05-15 that I prefer to use).

Ray
End of April 2013: Traded my 2011 SL for a 2013 S with charge pkg.

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 6:45 am

Ok this is really pissing me off. I fixed this last night. I even went back and checked it again after smkettner's post and it all looked fine. Now I look again and it's all screwed up.
Silver SL-e
Ford F450 Crew Cab Hybrid Conversion

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 6:55 am

I fixed it again. Let me know if you see anything wrong since there seems to be some caching issue.
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 8:42 am

Looks good now :)

Although if the two guys from TX can figure out that they did not order on 4/20/2010
And the rest that have no idea what their order date is could please figure it out and give some updates.

What is the point of having your name up and no useful info or posting complete errors.
It is not Turbo2lr's problem to correct all the junk. Get with it people or don't participate.

We expect so much from Nissan and so little of ourselves.

(just my rant for the day) ;)
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

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

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

Sun May 15, 2011 12:50 pm

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?

User avatar
ElectricVehicle
Posts: 631
Joined: Thu Jul 15, 2010 1:05 pm
Delivery Date: 18 Jul 2011

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

Sun May 15, 2011 1:12 pm

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!

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:24 pm

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?
If there is clearly incorrect data such as missing or bad order date and there is no update in the last 30 days.... I say delete the entry.
If there is an update in the last 30 days then maybe send a PM for submitting a correction. Still 30 days old and zap.
Or just send a PM why it was deleted and let them re add correct info.

Entries that are incorrect and abondoned should be deleted. Worst case scenario is they can add themselves back with some real and correct info.

Bad data tends to wreck real information.
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

Return to “News & Main LEAF Discussion”