2022 GR86s Allocation Spreadsheet (Updated as of 6/30/2022)

	A	B
1	Trim	Last Updated
2	AT	6/30/2022
3	MT	6/30/2022
4	Premium AT	6/30/2022
5	Premium MT	6/30/2022
6	Now including Southeast Dealerships!
7
8	Next Update:	unknown
9	Status: Toyota API blocked as of 10pm PST June 30th, 2022. Seems the API now possibly requires a hash signature. If anyone is familiar with this and knows how to retreieve or generate the signature, please DM me on Reddit at /u/LordKing65
10	Update (7/6/2022): Currently working on "Inventory" Spreadsheets using different means. This may not show full allocations, but it should show current invetory of dealerships.
11
12	Like this spreadsheet? Buy me a coffee :)
13
14	What is this sheet? This spreadsheet shows the available allocation data for GR86s from Toyota's database up to being sold (when their database is no longer returning data for that VIN I am checking). Allocated VINs are planned vehicles to be delivered to dealerships. This data being scraped so there will be discrepancy, meaning I am not taking this data directly from their servers, nor do I have direct access them, but generating a random vin, and checking against Toyota's DB.
15
16	Other Allocations Sheets:
17	RAV4 Prime	Prius Prime
18	NX 450h+	Sienna Hybrid
19	IONIQ 5	Highlander Hybrid (Coming Soon)
20	bZ4X	NX 350h (Coming Soon)
21	Rav4 Hybrid	Camery Hybrid (Coming Soon)
22
23	NOTES:
24	This is ONLY for 2022 models in the US (Sorry Canada)
25	Toyota data can change every minute. Do not expect this sheet to be updated to the minute.
26	Status Guide: "A" Status (in production, on the ship, or sitting at the port) -> "F" (Checked in at the port and in the process of moving from the port to the dealership lot. Usually From and To Date will now appear) -> "G" (At the dealership lot)
27	If you find any VINs missing with a valid online spec sheet, please DM me on reddit /u/LordKing64 and I'll take a look at it. It is most likely already sold if it does not have a valid online spec sheet.
28
29	Recommendation on searching:
30	1. Download the file and save it as an Excel file, or save it into your Drive
31	2. Filter by location, state, and or city.
32	3. Filter by your chosen color.
33	4. Starting with VINs that are BLANK under Hold Status, call each dealer individually and ask for that specific VIN.
34	5. Continue with VINs with "Available" Hold Status, then "DealerHold" (These are most likely taken but doesnt hurt to try)
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100