Question About Leader Database

[Anthropoid]

Thanks to Helpless, I have DLed Michael's witpload.exe, and have figured out how to export databases. I have a question that the Reference Tables.csv file does not fully answer for me.

What does "CommandsType" column in the Leader database file mean? The Reference Table file provides the following key:
1 Headquarters
2 Large ground unit
3 Small ground unit
4 Task force
5 Ship
6 Air unit

I'm playing around with the Super Dreadnoughts 1926-1930 single player version, and I've got a game going where I'm playing Japan against allied AI.

So I've exported all the databases for this scenario (SCEN 006) and pulled out the Leader Data. When I isolate the Nationality = 2 guys (IJ Navy guys) I see that Vice Adm Adachi, E. has "CommandsType = 1." Opening up my test game, when I open up a couple TF floating in Tokyo I get interesting results when I try to switch commanders out from different task forces.

When I open up a sub TF in Tokyo, I can see Adachi E. there in the available leaders, and his numbers match up (Ldr=48; Insp=49, etc.) and he is "best qualified to command a sub fleet."

When I open up a mine warfare TF in Tokyo and go into the Leader selection window I can again see VADM Adachi, E. and this time it says he is best qualified to command a surface fleet.

Same thing when I open up a tanker TF in Nagasaki. Adachi is qualified to command it, and he is "best qualified to command a surface fleet."

Same thing when I open up a tanker TF docked at the island of Amami (b/w Formosa and Kyushu). All this is making me think that what CommandsType means is = "where is the guy or what type of unit is the guy in at the start of the scenario." However a bit more checking brings this conclusion into question . . .

Strangely, when I dock the Air Combat TF that is in Takao, and open up the Hosho, VADM Adachi is NOT listed as one of the available commanders [&:]. Nor is he available as a commander for any of the other ships in this Air Combat TF 18.

However, when I open up other TFs in Takao and other bases on Formosa I get strange things. It seems Adachi shows up as being available to command TFs that DO not include ships that qualify for surface combat operations (BB, BC, CA, CL, etc.). This is true whether such a TF is set to Air Combat, Bombardment, Surface Combat, Transport, or Escort. But Adachi DOES show up as being available as long as a TF does not includes such a surface combat capable vessel in it.

So my hypothesis is that this variable "CommandsType" indicates the limitations on what type of vessels/units an officer can be in charge of? With "CommandsType = 1 meaning command of any naval vessel that cannot be set to surface combat.

[BigJ62]

Type 1 = HQ type leader.
He is eligible to command HQ type lcu and can also command ANY TF.

[Anthropoid]

Great editor BigJ62! If I were making scenarios this would be absolutely indispensable.
 
What I've been trying to do is use the actual CSV files in excel to sort the leaders and pick which ones I want using excel instead of clicking endlessly in the game window.
 
For example, I wanna really high Nav Skill guy to command BC Akagi. I pull out the section of the IJ Navy section of the spreadsheet (Nationality = 2) and then I pull out the section of IJ Navy that corresponds to TF and ship commanders (CommandsType = 4 or 5). I sort these guys by Nav Section and I come up with Tomusaki = 89 Nav Skill in the Commandstype=5 and Asakura =91 in the other set.
 
Then I go into my ongoing game to try to get one of these two guys in my leaders list. I was having trouble finding the guys I wanted, but I think it was just me not using sort command in the leaders lists correctly.

[BigJ62]

Thanks.
In scen#6 I was able to find both leaders however if they have already been assigned then you probably will not see them listed. Also Tomusaki is for TF only but you could put him in charge of the tf and put the other guy in charge of the ship.

[Anthropoid]

ORIGINAL: BigJ62

Thanks.
In scen#6 I was able to find both leaders however if they have already been assigned then you probably will not see them listed. Also Tomusaki is for TF only but you could put him in charge of the tf and put the other guy in charge of the ship.

I've been trying to figure out a way to identify which ship a leader is assigned to without scanning through all the ships, but without much success. I see each leader has a "Unit ID" so I tried to search for some of these in the "CaptainID" column in the ships & crews sheet, but did not find all the same corresponding numbers. Maybe I'm just blundering.

[engineer]

In EditorX there is a "Validate" function.  For leaders and pilots it it will point out errors, like when a general is assigned to captain a ship of a major is commanding a corp, or a leader has multiple commands, and it will also list the free pilots and leaders that are unassigned.  So you can substitute a free free leader for one that is already assigned.