SAM
Well-Known Member
- First Name
- SAM
- Joined
- Dec 29, 2020
- Threads
- 3
- Messages
- 333
- Reaction score
- 362
- Vehicles
- Premium MME4X Iconic Silver
- Thread starter
- #31
Thanks for the link. I will give it a try. I also fixed the transposed dates but I just excluded the entries with reservation dates (older than June 2020). There weren't that many and I didn't want to make assumptions on when after June 2020 they placed their orders. I too am trying not to be obsessed with looking at this data. People who have their cars don't care about this thread ?.Thanks for the summary - I did some similar graphing a while back and saw the same trends. I hope that the Order -> Build really starts getting shorter, it is heavily weighted now by people who ordered long before production began. As those early orders get completed the value should reduce and settle down at some shorter number of days.
If it helps, here is the direct link to the actual Google Spreadsheet (view only), which might make it easier to copy/paste out of (in particular for grabbing only new rows):
https://docs.google.com/spreadsheets/d/1lBgAEQVufjImIIq3wllYvqupRNTZD3wfSoiRZRrJlAg
I had the same issues you did with some data cleanup - mostly transposing "2020" and "2021" in dates so your durations are either WAY too long, or a negative number. I also improved the data a bit in my copy by moving any order date from prior to 6/22/2020 up to that date - anything earlier and the user entered their reservation date (which isn't the same as the order date).
Happy analyzing - I'm sure I'll be looking at this closely right up until I get my car, at which point I will promptly forget all about it.
EDIT: Had to change to code to display the URL - the forum software VERY BADLY wants to make that spreadsheet link an embedded view...
Sponsored