Page 144 of 144 FirstFirst ... 4494134140141142143144
Results 1,431 to 1,438 of 1438

Thread: Model X Tally

  1. #1431
    Model X mod Paul Carter's Avatar
    Join Date
    Apr 2013
    Location
    Vancouver, BC, Canada
    Posts
    502
    Blog Entries
    1
    Hello fellow tally watchers! Was thinking of evolving the monthly tally a bit.

    Here's what I've come up with so far (as of March 18).

    Version 6.1

    Name:  Model X Global Tally mid March 2015.png
Views: 501
Size:  284.5 KB

    Let me know what you think.

    I think version 6.2 will have accurate predictions up to a quarter in advance.
    |Model X Moderator|Model X Sig # 3 Canada|Model S 60|Dolphin Grey|19" Cyclone|Gray Leather|Piano Black/Yacht|Tech|Park Sensors|DC/SC|VIN 33117|Dep 5/9/14|Delivered 5/14/14|Front/Rear lighted Ts|appliqué coming soon|


  2. #1432
    Middle-aged Member dirkhh's Avatar
    Join Date
    Jul 2013
    Location
    Portland, OR, USA
    Posts
    1,956
    Instead of a full average (blue) it might be more interesting to have something like a 3 months (or 6 months) moving average. Because all we see in the blue line is flattening out and a tiny dip, but I think that underrepresents what has happened since the peak in late summer 14.
    S60 gray/gray tech/19 - 2013-7-12 - traded in 2015-2-16 for
    P85D mcred/gray(nextgen) tech/19/subzero - ordered 2015-1-7, delivered 2015-3-6
    X105D
    mcred/gray reservation #6218

  3. #1433
    Model X mod Paul Carter's Avatar
    Join Date
    Apr 2013
    Location
    Vancouver, BC, Canada
    Posts
    502
    Blog Entries
    1
    Quote Originally Posted by dirkhh View Post
    Instead of a full average (blue) it might be more interesting to have something like a 3 months (or 6 months) moving average. Because all we see in the blue line is flattening out and a tiny dip, but I think that underrepresents what has happened since the peak in late summer 14.
    That might be more interesting for sure. I'll try 6 months to smooth out the monthly spikes better.
    |Model X Moderator|Model X Sig # 3 Canada|Model S 60|Dolphin Grey|19" Cyclone|Gray Leather|Piano Black/Yacht|Tech|Park Sensors|DC/SC|VIN 33117|Dep 5/9/14|Delivered 5/14/14|Front/Rear lighted Ts|appliqué coming soon|


  4. #1434
    Middle-aged Member dirkhh's Avatar
    Join Date
    Jul 2013
    Location
    Portland, OR, USA
    Posts
    1,956
    Quote Originally Posted by Paul Carter View Post
    That might be more interesting for sure. I'll try 6 months to smooth out the monthly spikes better.
    Yeah, it's that balance - smooth out the spikes but still show the trend. You could try overlaying 3 and 6 and see what seems more appropriate.
    S60 gray/gray tech/19 - 2013-7-12 - traded in 2015-2-16 for
    P85D mcred/gray(nextgen) tech/19/subzero - ordered 2015-1-7, delivered 2015-3-6
    X105D
    mcred/gray reservation #6218

  5. #1435
    Model X mod Paul Carter's Avatar
    Join Date
    Apr 2013
    Location
    Vancouver, BC, Canada
    Posts
    502
    Blog Entries
    1
    Quote Originally Posted by dirkhh View Post
    Yeah, it's that balance - smooth out the spikes but still show the trend. You could try overlaying 3 and 6 and see what seems more appropriate.
    Tried 6, 3, and then 12. 12 seems to actually smooth it out. We have a lot of gaps/spikes in monthly numbers. So think this might work and does show the peak in Oct 2014.
    Name:  Model X Global Tally mid March 2015 12 month rolling average.png
Views: 418
Size:  290.5 KB
    |Model X Moderator|Model X Sig # 3 Canada|Model S 60|Dolphin Grey|19" Cyclone|Gray Leather|Piano Black/Yacht|Tech|Park Sensors|DC/SC|VIN 33117|Dep 5/9/14|Delivered 5/14/14|Front/Rear lighted Ts|appliqué coming soon|


  6. #1436
    Middle-aged Member dirkhh's Avatar
    Join Date
    Jul 2013
    Location
    Portland, OR, USA
    Posts
    1,956
    Yeah, better. Thanks, Paul. I'm blocked from giving you more reputation right now. I'm sure others will make up for it.
    S60 gray/gray tech/19 - 2013-7-12 - traded in 2015-2-16 for
    P85D mcred/gray(nextgen) tech/19/subzero - ordered 2015-1-7, delivered 2015-3-6
    X105D
    mcred/gray reservation #6218

  7. #1437
    Model X mod Paul Carter's Avatar
    Join Date
    Apr 2013
    Location
    Vancouver, BC, Canada
    Posts
    502
    Blog Entries
    1
    A few people have asked on what tool I used to do it, so I thought I share it. Note to the recent people giving me rep points, thanks for the very kind comments. One had just asked this question. I don't know your name (unless you add that in the comments I can't tell). Hope you see this!

    Anyhow...

    Its a basic MS Excel 2013 line chart with Style 6 or Style 9 to start (I think it was 9) and everything you see is built with standard functionality. A few custom colours for the data, axis, data labels, etc..

    I do a lot of this in my line of work (and in lots of different tools). The only difference is most of my source data usually comes from files or databases. Then just a basic cropped screenshot to create the image.

    Here is a basic one:
    Name:  Excel Basic Graph.png
Views: 351
Size:  87.0 KB

    Turns into this after a few colour tweaks and standard formatting to get it to the desired result.

    Name:  Tally Graph Build 6.1.png
Views: 345
Size:  407.5 KB
    Attached Images Attached Images  
    Last edited by Paul Carter; 2015-03-22 at 11:25 AM. Reason: spelling
    |Model X Moderator|Model X Sig # 3 Canada|Model S 60|Dolphin Grey|19" Cyclone|Gray Leather|Piano Black/Yacht|Tech|Park Sensors|DC/SC|VIN 33117|Dep 5/9/14|Delivered 5/14/14|Front/Rear lighted Ts|appliqué coming soon|


  8. #1438
    Senior Member bonnie's Avatar
    Join Date
    Feb 2011
    Location
    California
    Posts
    10,607
    Blog Entries
    4
    You do the community a great service with this, Paul. Thanks!
    PLEASE NOTE: Posts are the copyrighted intellectual property of the author, and are intended as part of a conversation within this forum. My words may NOT be quoted outside this forum, without my expressed consent.
    --------------------------
    Roadster Sport 2.5 (#1194) --- Happily anticipating delivery of Model X Signature (#2) --- Follow me on twitter and and follow TMC, too!

Page 144 of 144 FirstFirst ... 4494134140141142143144

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Model S Reservation Tally
    By michiganmodels in forum Model S: Ordering, Production, Delivery
    Replies: 2753
    Last Post: 2015-02-06, 12:48 AM
  2. Model X Tally
    By michiganmodels in forum Model X
    Replies: 0
    Last Post: 2012-02-10, 12:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •