Ford Focus RS Forum banner

1 - 20 of 49 Posts

·
Registered
Joined
·
205 Posts
Discussion Starter #1 (Edited)
Hello members,

Sorry this is for NA only. Maybe I can get a dataset for other regions to add in the future?

I've been working on a way to view @Shoey's VIN spreadsheet, which he is scrubbing from ETIS (in a basement somewhere in Mexico) :wink-new:. So I created a dashboard, basically what I do in real life, to breakdown his google spreadsheet which he posts here

Here is the link to my dashboard.
Desktop:
https://public.tableau.com/views/Tracker_2/Dashboard1?:embed=y&:display_count=yes&:showTabs=y

Mobile Version:
https://public.tableau.com/views/NAVINTrackingforFocusRSmobile/Dashboardmobile?:embed=y&:display_count=yes&:showTabs=y

Currently it only tracks VINs that have been built. I didn't think it would be helpfull to list all 1,755 VINs since those that aren't produced don't have any other info other than date vin was assigned. You can type in your VIN in the search box, located on the top right, and select it from the list below if it is available to check out your order.

There is some cool info like the a table that shows the breakdown of cars produced by color, seat option, moonroof option. Unfortunately the dataset doesn't contain wheel options, so i couldn't add that.
Of course, Rs2 w/ Moonroof w/ NB color is the most popular :victorious:

You can also see things like how long did it take to move from date VIN was assigned to being built. Average time it took for currently built orders is about 2 weeks.

Let me know your thoughts. Likes\Dislikes....etc.

-KB

Report Updated On: 4-19-2016
 

·
Registered
Joined
·
262 Posts
+1 for Tableau

We're currently stuck on a legacy version of JasperReports D:
 

·
Registered
Joined
·
892 Posts
Currently it only tracks VINs that have been built. I didn't think it would be helpfull to list all 1,755 VINs since those that aren't produced don't have any other info other than date vin was assigned. You can type in your VIN in the search box, located on the top right, and select it from the list below if it is available to check out your order.
Thanks for doing this! Looks cool as hell.

Mine has been built, but the VIN (13692) doesn't pop up when I type it in the search field. Am I doing it wrong?
 

·
Registered
Joined
·
205 Posts
Discussion Starter #10
I was able to see your VIN.
Hit the [Enter] key after typing in your VIN to see your vin appear in the list. Let me know if you still can't see it and i'll post a pic.

Thanks for doing this! Looks cool as hell.

Mine has been built, but the VIN (13692) doesn't pop up when I type it in the search field. Am I doing it wrong?
 

·
Registered
Joined
·
268 Posts
Great job dude. The most interesting thing I noticed while looking at the figures (because mine hasnt been built yet) is that the NB colour is by far and away the most popular on the RS2 w/moonroof cars. It is the most popular choice on other versions but not by nearly the same overwhelming margin. Made me go hmmmmm.
 

·
Registered
Joined
·
205 Posts
Discussion Starter #15
Thanks for the positive feedback everyone.

I made an edit to the dashboard. Now it shows the actual Focus RS, in its appropriate color, for the Color option.
Implemented in DB.png
 

·
Registered
Joined
·
205 Posts
Discussion Starter #17

·
Registered
Joined
·
627 Posts
I don't see my Vin on there but I was on shoeys list and I am produced awaiting shipment. 4193
 

·
Registered
Joined
·
205 Posts
Discussion Starter #19
Have you tried typing in your partial vin in the search box? It's located above the List of VIN #s on the top right.
I've posted a pic of your VIN.
VIN search2.PNG
I don't see my Vin on there but I was on shoeys list and I am produced awaiting shipment. 4193
 

·
Registered
Joined
·
627 Posts
Have you tried typing in your partial vin in the search box? It's located above the List of VIN #s on the top right.
I've posted a pic of your VIN.
View attachment 7736
Yea literally typed the same exact thing you did and it came up with nothing
The stats are wrong though. I have a moonroof
 
1 - 20 of 49 Posts
Top