Tacoma inventory spreadsheet

This is a great spreadsheet. Why are there thousands of white trucks being built, but only ONE Voodoo Blue? One. Damn!

P.S. I love that when I click the links it says "Kiss My Grits". It reminds me of this:

 

This is one of the best threads I've seen in a long time. And you put it on Github, awesome.

 

Find dealer ID #s for the state you are looking in from the second worksheet. Import the production worksheet into Excel. Under "Data" tab use "Filter" function to display only dealers, models and colors you want.

 

Is it just me or does the sheet not pull PRO tacomas?

 

Pros are scheduled to start being built in February, IIRC. There are no Pros in inventory

 

What a great thread and spreadsheet(s), many thanks to @_kmg_ !

Wish there was a way to pull data for Hawaii as well, but obviously not likely since Servco Hawaii is its own little empire over here and not a part of Toyota USA. Still, really nice to see how many of my exact build are out there in CONUS (2 as of this post)!

 

This is great!

 

Thanks for the info. I have a temporary Vin on a PRO the dealer said was being built next week, with a delivery of mid Feb. Unfortunately it's an automatic and I'm still looking 4 my manual. I'm guessing once they show up. This sheet will be very helpful.

Thank you

 

Then you have a vin for one of the first 2022 Pros to be built.
IIRC manuals are built in batches and someone said next manual batch will be in March?

 

I have a manual on “order” here in Hawaii (non Pro), and the build is confirmed for April according to my dealer. Not sure if the Hawaii thing makes a difference, just throwing it out there.

 

Cool, I won't bother checking the sheet until March. That will give me about 2 weeks to fall in love with the automatic. Lol

 

Really is AMAZINGLY helpful. Thanks!

 

I pulled every other day. Why not. Gives you a good idea what is coming.

 

Your right get good at navigation and usage. Plus, I should be able to see my automatic on the list right? Once they "build" it.

 

Yep. Even you do not know the Perm VIN. You know dealer and options.

 

I don't see a dealer ID for a shop in Greely CO. Anyone know their ID? I have a PRO in allocation from them I want to track.

https://www.googleadservices.com/pa...=2ahUKEwjw58u_5Mr1AhU_IDQIHZFkA1oQ0Qx6BAgFEAE

 

List is by Dealer name. If they do not have a city in the official name, then city will not on the spreadsheet.
Quick look shows that half of CO dealers do not have city name. It is "Phil Long Toyota" or "Ehrlich Toyota"

 

The dealerships name is McDonald toyota

 

Same as Ehrlich toyota, #5064
https://www.mcdonaldtoyotagreeley.com/

 

I owe you a latte