Thanks for clarifying that.
If you look at the code for upg(total) you may also want to look at the code for TBO.YTA because I guess it's not on purpose that the values leave out all groups that are on ships.
Here my detailed feedback for version 1.9.1
-Stop tooltip from disappearing(maybe by clicking on cell?).
-Mark columns that have tooltip so user knows he has to "wait" for additional info(maybe underline title).
-Add coordinates to destination on alert type "LCU arrived".
-Sort regions, logically or alphabetically.
-Sorting for different values of columns that have more than one value, like port, airfield, troop capacity, etc. so that you can sort by one or the other value.
-Remove items that are not used, for example mines with a low ID number that aren't used in game.
-Movable columns on the "Regional Ind/Repair" sheet should be checked for item they represent before giving out the sub-info so that the "OilRef" column gives out Oil Refinery and not resources because the OilRef column was replaced where to Resources column was.
-Sheet "CS Cargo Planning" should have the bases sorted logically or alphabetically.
-What's the Resources screen there for? All that it shows is also on the industry screen or do I miss something?
-Sort the regions, logically or alphabetically
-Sorting and filter options on the Formations sheet.
-What does the ID color on the LCU production screen stand for? Add tooltip.
"Aircraft Production" screen
-Change name of TBO.YTA column, name doesn't really give a clue what the values stand for, also a tooltip with more detail would be good.
-Change name of upg(total) name doesn't really give a clue what the values stand for, also a tooltip with more detail would be good.
-Add tooltip to Grp planes column to make clear this is the number of ALL planes(ready, repairing & reserve) in active groups.
-Change "Next" to "Arrival of next group"(or a short form of it) so players know what column is for or add that as tooltip.
-Rework Frame Stats, extend text elements so player knows better what is meant in each line.
"Aircraft comparison" screen
-Make it keep the set aircraft, when changing to other screen.
-Add the same filters that are on the aircraft screen.
-Expand screen by at least on more plane to compare, overall 5 would be better.
"Air Groups & Pilots screen
-On airgroup sheet the nation filter should filter available models & types so those lists get shorter.
-The special filter "Upgrade to" should be named "Upgrade from", at least I get all groups that are using the set plane and upgrade to a different plane when using this filter.
-Split Withdrawal filter to show ships that have to be withdrawn and those that are already withdrawn.
"Ship classes" screen
-Add filter to suppress unavailable classes.
-Add filter to show a specific class and all there upgrades so future upgrades can be compared.
"Ship Upgrades" screen
-Add filter for ship classes on upgrades sheet.
-Add "convert to class" so a general class can be set(like DE) instead of a specific class(like Clemson DE LR).
-Add filter to show all classes of a specific upgrade path, for example all Colorado BB (ID 335-339-340-343-344).
"Ship repairs" screen
-Expand region filter so that all regions can be filtered.
"Victory Points" screen
-Add a general note why those values differ from the values in the intelligence report. I guess FoW somehow plays in, but how?