Companion tool for the Order Tracker: see how common your exact build is

[TooManyVehicles]

Is your spreadsheet completely broken now? I downloaded a copy but it fails to function.

"fails to function"

Sponsored

 

[KeinoDoggy]

"fails to function"

 

[JustDoIt]

Not sure what happened, but it is fixed now. Feel free to download a copy now.

 

[KeinoDoggy]

Not sure what happened, but it is fixed now. Feel free to download a copy now.

Thanks, I'll try again.

 

[KeinoDoggy]

So for fun I built another little side sheet...

This takes the data from the official Order List (including any real-time updates!) and lets you see how many other orders there are from this. You can also quickly see what % of this is of the total orders.

For example, if you want to see how many XLT Hybrids, you can. If you want to see how many XLT Hybrids have a build date, you can also. Etc. Or even, what % of XLT Hybrids have a build date. Etc.

----

I plan to evolve this so you can put in your stats and see what the average Order -> Build Date -> Delivery date timeline looks like for similar/selected items. So if you want to see the time for an XLT Hybrid without 360 or with 360, it will pull the data and aggregate each and you can compare.

Any feedback welcome.

NOTE: if more than one person is in this at a time, you may be changing their settings mid-lookup. Sorry, I can't make it "one at a time"

Lookup - Google Sheets

Edit: Have updated to show *IF* your selections have a confirmed build or delivery date AND there are at least 1 result, then it shows you how many beat/missed those dates.

Still not working. Oddly an old one I downloaded when you first posted works fine.

 

[JustDoIt]

Still not working. Oddly an old one I downloaded when you first posted works fine.

Got it updated now...

More orders were added than I had rows, so it was erroring with being able to fill from the main entry sheet. I've added more rows for it to utilize and it SHOULD be good again.

 

[pawalsh610]

Lookup - Google Sheets

Thanks this was fun. Evidently, there are less than 100 orders like mine and only two like mine in the state (different colors). Mine has been buillt and shipped but not delivered (June Order) but it looks like I may be one of the first to get a Hybrid, First Edition, Lariet, lux with 360.

 

[KeinoDoggy]

Lookup - Google Sheets

Thanks this was fun. Evidently, there are less than 100 orders like mine and only two like mine in the state (different colors). Mine has been buillt and shipped but not delivered (June Order) but it looks like I may be one of the first to get a Hybrid, First Edition, Lariet, lux with 360.

Same here. Only 2 Hybrid XLT Carbon Gray, no 360, no tonneau cover in Ohio.

 

[KeinoDoggy]

Got it updated now...

More orders were added than I had rows, so it was erroring with being able to fill from the main entry sheet. I've added more rows for it to utilize and it SHOULD be good again.

Thanks for creating this. Works fine now.

Sponsored