Yes, in Excel select the entire sheet and then select the Data tab, and Filter symbol to enable filtering on the column headings.Anyone know how to filter it down better? or is there a command? I.e : Just TRD ORP and without a sunroof?
You're a lifesaver. Thank you!Yes, in Excel select the entire sheet and then select the Data tab, and Filter symbol to enable filtering on the column headings.
Then on the "Model" column drop down select just the "TRD Off-Road Premium ..." , and on the "Options" column drop down click on "Text Filters" --> "Does not contain" and use the word "Moonroof"
Note: In the "Model" column drop down select any line with "TRD Off-Road Premium ..." in it as I don't know if those are only PT4WD or if they can be other drivetrains (i.e. may be more than one line with "TRD Off-Road Premium" in it)You're a lifesaver. Thank you!
These spreadsheets have helped me so much in locating a Platinum. I'm in NH and the dealerships close by have not had any allocations since March when I originally put a deposit down. Finally got tired of waiting and broadened my search. I had a deposit on one that should be arriving 8/8-8/17 and I believe just got into port today (8/5) outside of Pittsburgh, PA, but I ended up finding yet another one in GA that was already at the dealership and willing to sell out of state. So, if you're looking for a Wind Chill Pearl Platinum 4Runner in PA, I just called Cochran Toyota and gave up my hold on one that should be there soon!
Put some serious miles on the car driving from GA to NH, but it was a great drive!
Yeah, that is weird.I have used the sheet to locate my Everest ORP and I have been eagerly checking every few days and checking my dealers site. Last week the dealer went from Build Phase to In Transit and the sheet said Port to Dealer.... but today I check and the dealer now shows Build Phase and the sheet shows Factory to Port again with no estimated delivery date.
I did call my dealer last week to see if it was actually at the port and the salesman said yes. But now I do not know what to believe! Is it possible for the status to back to Build Phase if Port Installed Options are being installed?
I really hope that is the case!Yeah, that is weird.
"Factory to port" - Allocated, or in production, or on the ship, or sitting at the port
"Port to dealer" - Checked in at the port and in the process of moving from the port to the dealership lot.
So it's most likely at the port still and I'm guessing they either missed installing something at the port, or it got held up for that QC hold issue.
Not currently. I have done some rough tests of Lexus allocation spreadsheet runs but have not fully formalized it yet.Hi, Is there a list of allocations for 2025 Lexus GX550?
Looks like the ETA dates have reappeared and the shipping status is Port to DealerI really hope that is the case!
Here is the Vin but I will check its status in the morning and see what it says: JTEVA5BR7S5040203
So the Options in a cell are ordered case insensitive ascending order. Each option has a "| " preceding it (except the very first one) and a " " at the end of it (except the very last one).This is an incredible resource. Thank you for all the work you've done on it. I read all 22 pages to see if it has been asked, but is it possible to break out the Options into separate columns. I may be one of the odd ones, but I care less about trim and color. I want the Tow Tech Package with the Hybrid. I can save the spreadsheet as a separate file and break it down, but new ones are being added, it would be time consuming.