TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker and becoming a Supporting Member. For more info: Support TMC
Start a Discussionhttps://teslamotorsclub.com/tmc/tags/

Model S Delivery Spreadsheet Analysis (as of Nov 2016)

Discussion in 'Model S: Ordering, Production, Delivery' started by Dstrohl, Nov 23, 2016.

  1. Dstrohl

    Dstrohl Member

    Joined:
    Oct 13, 2016
    Messages:
    232
    Location:
    Seattle Area
    So, after looking at the Model S Order & Delivery 2016, and being interested in seeing what it meant over time, I took the data and imported it into Tableau, (a data visualization tool), and played with it to see what I could gleam from it.

    First I took the data sheets and combined them into one sheet to show all of the cars in the system. I also tried to clean it up a little where things were obvious (places where states were in the country field, etc...)
    then I took that data set, removed usernames and comments, and imported it into Tableau and started playing with the charts.

    What I ended up with is a set of charts that show:
    • Average delivery times to states and countries
    • Distribution of features (and breakdown by country, state, and model)
    • Production numbers and times
    • Production pattern (shows international cars being pushed to earlier in quarter)
    • Numbers of colors, models, and interiors (how uncommon is YOUR choice in options?)
    • Begin and end dates and VINs for models, colors and features.
    Take a look:

    Note: Since this data is based on information that the members of this group submitted, it is not intended to be 100% accurate, however I suspect it is probably representative of reality in many cases.
     
    • Informative x 2
  2. sdorn

    sdorn Director of Awesome

    Joined:
    Oct 9, 2016
    Messages:
    912
    Location:
    Georgia
    That's pretty cool.
     
  3. grayguy

    grayguy Member

    Joined:
    Nov 8, 2016
    Messages:
    58
    Location:
    Orange County, CA
    Very cool. I didn't see any information regarding time from order to delivery. Judging from looking at the spreadsheet myself, I'm assuming there wasn't a large enough sample size to extract any statistically significant data?
     
  4. pslawing

    pslawing Member

    Joined:
    Oct 17, 2016
    Messages:
    53
    Location:
    North Carolina
    I need to edit my info, how do you do that?
     
  5. Dstrohl

    Dstrohl Member

    Joined:
    Oct 13, 2016
    Messages:
    232
    Location:
    Seattle Area
    Go to your profile page, should be the 4th icon from the right on the upper left of the page.
     
    • Like x 1

Share This Page

  • 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