From: El Paso, TX
(As noted in Post #4, this new spreadsheet requires a detailed review)
6) Jap Airgroup Upgrades (New): In short, this worksheet will allow you to quickly see ALL Air Unit upgrades, resizes, withdrawals, returns and even the number of times a unit is renamed. For the Japanese player - especially in a "Realistic R&D" and "PDU off" game, it is critical that you determine well in advance whether a particular Air Frame is worth researching. That used to be very hard to do, but now this worksheet puts all the information right at your fingertips. I spent weeks putting this together, based primarily on data pulled from Tracker, but augmented extensively by "one record at a time" reviews of every air unit in the Scenario Database. This is an important addition to the workbook, so first we'll have a brief overview of the most important columns, and then I'll give you a short tutorial on how to use it. As an aside, during the spreadsheet development I spotted a number of apparent database errors (most known others perhaps not). In all cases, I highlighted the appropriate cell and added an Excel comment explaining the issue (you can see one of these in the first screen shot appended below).
Col C & D: Unit IDs - All units have a "Unit ID" (Col C) but when a unit withdraws and returns, it gets a new Unit ID (Col D). To make it easier to visually spot them, Col D also shows the previous Unit ID for those that return. For example, Yamada Det S-1 (143) returns as Kanoya Ku S-1 (40), and you'll see both numbers referenced (rows 116 and 33, respectively)
Col F: Name Changes - Shows the number of different times the unit's name changes. I thought about adding additional columns for each new name, but it would have taken a lot more work (maybe someday). It's helpful to know which units will have name changes, but since the primary purpose of the worksheet is to assist in research planning at game start, it's not as important as other features.
Col I: Split - Tells you if a unit can divide into subcomponents (it's either 3 or 0)
Col J, L, & M: Dates - Col J has the arrival date for any unit not already present on 12/7/41, Col L has the withdrawal date (if the number is "0", the unit does not withdraw), while Col M has the return date (if the number is "0", the unit does not return. Date format is YYMMDD.
Col O: Restriction Level - Indicates the restriction status of units, according to the usual Blue/Gray/Red numeric codes. Interestingly, this status is not directly called out in the Unit Data files, so for arriving units I had to guess based on the Restriction levels of their HQ. Anecdotally, I have never seen a Restricted HQ air unit arrive on map without the ability to "buy it out" with PPs, so all those are listed as "Grey".
Cols P-X: Upgrade Model Names - Col P has the first upgrade model name (if applicable), and the next columns contain the sequential list of per-unit additional upgrades (Yokosuka Ku S-1 has NINE possible upgrades!)
Cols Y-AQ: (Various) - Information pulled from Tracker (not edited). The most useful data is in Col AC (Max Planes). If it makes viewing easier, you could probably hide all the other columns in this group (no screenshot for these).
Cols AR-AZ: Resize number and date - Of the 865 air units, 158 can resize at least once, and these columns capture that information, sequentially showing both the Resize level and date. (Sasebo Ku T-1 can resize FOUR times!) If there is no resize, the Resize Number columns contain "N". For simplicity's sake, the Date uses only YYMM format, since the resizing always takes effect on the first day of the month.