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:
    899
    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