Welcome to Tesla Motors Club
Discuss Tesla's Model S, Model 3, Model X, Model Y, Cybertruck, Roadster and More.
Register
  • We just completed a significant update, but we still have some fixes and adjustments to make. Please see this thread for more details and to find out how to revert to the old design. Cheers!

Wiki Model 3 Order Tracking Spreadsheet

GaryW

Member
Supporting Member
@mrkymarc,

Try this:
Tesla Model 3 Invites - VIN Reports

On another note, the Tesla gods were kind enough to grant me my VIN today. My case is special as I am the first 19" Sport and the first silver metallic they have granted in a long time.

I am a little ambivalent about being so close to the AWD. But if I change now, I will be back in line behind all those previous deferrals. So I am happy with my VIN for now. My AWD Tesla will have to wait for model Y.

CJ

I think you are about getting back in line. We’re thinking end of year would be the earliest for us.
 
I have doubt with this back of line meme. If the configuration opens to all at once it likely is by order date. I guess we discover this week.

Second Tesla prefers to build expensive first. Likely we will see AWD quickly take priority and this queue will shorten fast especially as quarter draws to end for $$$
 

agastya

Member
Jan 26, 2018
152
2,130
Fort Worth
HI @agastya,
The 'Latest VIN' page have always been broken down by color. Maybe what you really want to see is this:

Tesla Model 3 Invites - VIN Graphs

View attachment 300800

Firstly, thank you for all that you do. I did look at this sheet - this is VIN broken down by date, then color as the second level of granularity.

I was trying to look at it from a different way - all VINs for a specific color, what the ranges are that are being assigned, what states they are going to and such. Something like this

Maybe I was missing it on the webpage, can you please point me to where I could pull down the whole spreadsheet?
 

chojn1

Member
Sep 21, 2017
402
1,098
Sugar Land
@chojn1 want a fun graph to make?

Make a sankey. For each day make 3 nodes: configured, VIN, delivered. Make links for every entry. Thickness of link based on total waiting time but scaled down over time. Give current day another node "waiting"

Bonus: give each link a label or icon showing color/wheel selection.

That would be a nice challenge.
I am not quite sure I can make a live constantly updating version of that though.
 
Reserved 3/31/2016 @ 2pm at Santana Row store
Got invite on 4/10/2018
Configured on 4/23/2018
Deep Blue Metallic
19” Sports Wheels


It is interesting to note that someone configured their M3 with same color and sports wheels a day after mine and already got a VIN while I am still waiting for it. Thought that the Bay Area reserve holder ( 10 miles from Fremont factory) has high priority, but it wasn’t the case. Maybe Tesla gives priority to full options M3
 

Attachments

  • D414045A-A08E-45F9-A8DB-85B968D71D95.jpeg
    D414045A-A08E-45F9-A8DB-85B968D71D95.jpeg
    361.4 KB · Views: 33

RTPEV

Active Member
Mar 21, 2016
1,129
1,333
Durham, NC
I averaged the config -> VIN elapsed time for the last 100 reported VINs and it's 32.5 days. Today is day 33 for me. It's statistically more likely for me to get a VIN than not on a given day, right? I mean, it's a hair over 50% now, right? Anticipation is killing me... :)

Technically you have to count all the people who configured that HAVEN'T received VINs yet as well. Even if you assume they will all receive VINs today, adding those people into your average will raise your average. Granted, if the spreadsheet/database is your source of this data, then for sure some of those old data points are stale. But some aren't. :(
 

RTPEV

Active Member
Mar 21, 2016
1,129
1,333
Durham, NC
Reserved 3/31/2016 @ 2pm at Santana Row store
Got invite on 4/10/2018
Configured on 4/23/2018
Deep Blue Metallic
19” Sports Wheels


It is interesting to note that someone configured their M3 with same color and sports wheels a day after mine and already got a VIN while I am still waiting for it. Thought that the Bay Area reserve holder ( 10 miles from Fremont factory) has high priority, but it wasn’t the case. Maybe Tesla gives priority to full options M3

Clearly they are making a play into Canada...whether this is to help the Ontarians meet their tax credit deadline, avoid crossing 200K in the US before July, or some other reason, Canadian orders are taking priority for now. Same for Washington state a week or so ago as they too are facing a tax credit deadline.
 

RenMan68

Member
Aug 24, 2017
101
55
Atlanta, Ga
Technically you have to count all the people who configured that HAVEN'T received VINs yet as well. Even if you assume they will all receive VINs today, adding those people into your average will raise your average. Granted, if the spreadsheet/database is your source of this data, then for sure some of those old data points are stale. But some aren't. :(
That's a really good point. Darnit.
 

RenMan68

Member
Aug 24, 2017
101
55
Atlanta, Ga
Interesting though... I've thought about this some more (with the benefit of a couple of glasses of wine :) Does it make a difference? That is, if we consider the population who have configured but not received VINs, does it change the average? Here's my thinking: for the people who have config'ed but not VIN'ed, the most optimistic prediction is that they all get VINs tomorrow. If this is the case, then the average config2vin time would be, I expect, quite small since many people have config'ed quite recently, driving the average down. That is, I suspect more have config'ed in the last 32 days than more than 32 days ago. (based on the only applicable data we have). Since we don't know when they (we, in my case) will get a VIN, it's all supposition (except that it can be no earlier than tomorrow). The best way to predict when we will get our VINs is based on the past config2vin elapsed time. The only really useful clue would be if there were 50,000 people who config'ed months ago and have not gotten a VIN but I don't think that's the case. Isn't that available in the master spreadsheet? (I know there are two now... but, somebody?)
 

chojn1

Member
Sep 21, 2017
402
1,098
Sugar Land
Reserved 3/31/2016 @ 2pm at Santana Row store
Got invite on 4/10/2018
Configured on 4/23/2018
Deep Blue Metallic
19” Sports Wheels


It is interesting to note that someone configured their M3 with same color and sports wheels a day after mine and already got a VIN while I am still waiting for it. Thought that the Bay Area reserve holder ( 10 miles from Fremont factory) has high priority, but it wasn’t the case. Maybe Tesla gives priority to full options M3


Being in the Bay Area is a disadvantage as there are more reservations that must be filled in that area than anywhere else. So as delivery capacity there is maxed, it becomes a problem for the one still waiting there. Our data suggests that options is not a priority. Wheel and color choice does affect your delivery time, but only because they don't match production with demand precisely.
 
Last edited:
  • Like
  • Informative
Reactions: RTPEV and RenMan68

chojn1

Member
Sep 21, 2017
402
1,098
Sugar Land
Interesting though... I've thought about this some more (with the benefit of a couple of glasses of wine :) Does it make a difference? That is, if we consider the population who have configured but not received VINs, does it change the average? Here's my thinking: for the people who have config'ed but not VIN'ed, the most optimistic prediction is that they all get VINs tomorrow. If this is the case, then the average config2vin time would be, I expect, quite small since many people have config'ed quite recently, driving the average down. That is, I suspect more have config'ed in the last 32 days than more than 32 days ago. (based on the only applicable data we have). Since we don't know when they (we, in my case) will get a VIN, it's all supposition (except that it can be no earlier than tomorrow). The best way to predict when we will get our VINs is based on the past config2vin elapsed time. The only really useful clue would be if there were 50,000 people who config'ed months ago and have not gotten a VIN but I don't think that's the case. Isn't that available in the master spreadsheet? (I know there are two now... but, somebody?)

Unfortunate past times does not translate well to future predictions.
The problem is the stochastic pattern of production thus far. Look at a list of 100 reservations for example. Assume all are arranged in the exact order that they will be VIN'ed. What happens when the first 10 cars take 100 day to build and the last 10 cars take 1 day to build. You cannot use VIN time of the first ten to predict VIN time of the last 10.

Also what happens when there is a gap in production between car 30 and car 31? VIN time for car 30 will be significantly different than for car 31.

To use the data for prediction, you must have a uniform repeatable pattern which we do not have.
 

Products we're discussing on TMC...

About Us

Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.

Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


SUPPORT TMC
Top