Automatic Sticker and Build Sheet tracking

[Yakpimp]

I just wanted to drop in and say thank you for this.

You are very welcome

Sponsored

 

[ChrisTheGod]

Quicc question when something does say found in green on the website so we just re-enter our information and be able to see something or do we clicc on something. If possible does anyone can direct me to somewhere that shows example of how a spreadsheet actually looks.

 

[Yakpimp]

Quicc question when something does say found in green on the website so we just re-enter our information and be able to see something or do we clicc on something. If possible does anyone can direct me to somewhere that shows example of how a spreadsheet actually looks.

If it says found there are a couple options.
1. You should have received an email with a clickable link
2. You can enter your vin again and search and it will find just your row with clickable links on the page
3. You can go to http://jl.cryptostickers.net?vin=<insertYourVinHere> and it will auto search for you

 

[MoDonPunkn4Dr]

Just found this again and read through the thread.

I also wanted to say thank you very much for creating this tracker.

But even more for continuing to manage and enhance it after your baby was delivered. That is amazing!

Congrats on your delivery. Some day my Punkn will arrive.... I think.

 

[Yakpimp]

Just found this again and read through the thread.

I also wanted to say thank you very much for creating this tracker.

But even more for continuing to manage and enhance it after your baby was delivered. That is amazing!

Congrats on your delivery. Some day my Punkn will arrive.... I think.

You are also very welcome. I like doing this kind of stuff. Finding ways to do things that aren't especially hard, but typically time consuming. Having such a great community also helps

 

[jeremyjeep]

I unfortunately missed the build tracking spreadsheet so I've been manually checking the Window Sticker and Build Sheet pages for my supplied VIN number for the past few weeks religiously.

I finally decided to make a small tool that I run on my PC that just checks it periodically and will notify me when it's available. From what I hear that means it's at least progressing through the build stages.

I wanted to help others, but figured nobody would want to run a random strangers .exe on their computer so instead I made a tracking website that you put in your vin, a nickname and an email. When the sticker and build sheet are available it will email you so you don't have to continuously check yourself.

I hosted it on an old plan I had http://jl.cryptostickers.net/

VIN: This is the vin you are trying to track
Nickname: This is the name that will show next to your partial vin on the homepage
Email: Used to notify you

If you put in your info it will get added to the list for checking. If you then come back later and put in just the VIN it will pull up the full VIN, instead of a partially blocked one, and then also give you status with clickable links. I hope to get the emailing part up and working tonight.

Hopefully some of you find this helpful while we wait.

Here is what it looks like with my VIN and one I got from my dealers lot. Please let me know if there are other features that might make it better to use.

View attachment 11829

**EDIT**
I've fixed the timestamps to show the last time the data was checked on a per-VIN basis. Once both Sticker and Build info are found the date should be the last time it was updated.

Automatic emails should now be working. If either of the items changes you should get an email with links.

I also added some stats to the top of the page for fun

View attachment 11885

Thank you VERY much for this service. Is there a way to add the date found, not just "found" in the existing build sheet and sticker columns? Then add two new rows and subtract the dates to show the amount of days from order to build sheet and days from build sheet to sticker? Then add a new stat at the top and put in averages of amount of days from order to build sheet with the "last 30 days" as the date range?

 

[Yakpimp]

Thank you VERY much for this service. Is there a way to add the date found, not just "found" in the existing build sheet and sticker columns? Then add two new rows and subtract the dates to show the amount of days from order to build sheet and days from build sheet to sticker? Then add a new stat at the top and put in averages of amount of days from order to build sheet with the "last 30 days" as the date range?

Yes that’s possible. However it requires a bit more refactoring. I’ll keep it in mind for the next time I’m awake while my family sleeps.

 

[jeremyjeep]

Yes that’s possible. However it requires a bit more refactoring. I’ll keep it in mind for the next time I’m awake while my family sleeps.

Cool. V2.0

 

[Yakpimp]

Cool. V2.0

The only issue is I don’t already keep track of the found dates unless it’s the last updated found date. Basically not a separate date for sticker and build. I can easily add a colum for total time between order and both items found.

 

[RadicalMatt]

Build sheet found!! So excited.
Thank you, was checking myself 4x a day or so but got an email and was like

 

[jeremyjeep]

The only issue is I don’t already keep track of the found dates unless it’s the last updated found date. Basically not a separate date for sticker and build. I can easily add a colum for total time between order and both items found.

Using the date found as the last updated found date would be fine (should be within 24 hours right)? Not looking for by the hour, minute level of detail. Also, this could be a "going forward" feature where you show only on newly found sticker and builds. But it would be great to retro the data too, so we could get an average history, not just average going forward.

 

[cnyjl]

@Yakpimp

My dealer just notified me that my order failed inspection and they're starting another one. Can you replace my original info?

Order date: 3/28/18
VIN: 1C4HJXFG9JW209636

 

[jeremyjeep]

@Yakpimp

My dealer just notified me that my order failed inspection and they're starting another one. Can you replace my original info?

Order date: 3/28/18
VIN: 1C4HJXFG9JW209636

Ugh. I just got a pit in my stomach after reading that your order failed.... and it isn't even my order. Out of curiosity, what was your original order date?

 

[cnyjl]

Ugh. I just got a pit in my stomach after reading that your order failed.... and it isn't even my order. Out of curiosity, what was your original order date?

Thanks. 1/25. Went into D on 2/1, but was moved back into D without me knowing. Built on 3/3 and stuck in inspection for 25 days and rebuilding as of this morning.

 

[cnyjl]

Ugh. I just got a pit in my stomach after reading that your order failed.... and it isn't even my order. Out of curiosity, what was your original order date?

@Yakpimp I was the first to join when you posted this tracker. Guess I'm supposed to stick around a while longer.

Sponsored