The Reluctant Admiral

[John 3rd]

Like the idea.  Go ahead and see what you can do with it.
 

[John 3rd]

I've added the 6 Moon and 16 Yugumo to the Order-of-Battle. I simply had to find space in the ship list, click on the enpty line, write the DD's Name, tie it to the ship class and appropriate upgrade version, Nationality, HQ assigned, Location, and deployment date.

Results:

[John 3rd]

I've sent the files to Juan where he will install Kawachi and do his other changes to Ammo, Sub Torps, etc...
 
THANKS!
 

[JuanG]

Sometimes the AE editor, as wonderful as it is, doesn't cut it. For those times theres MS Excel. [:D]




Hmm...1700+ ship classes to redo ammo for...this might be a long night. [8D] Might have to leave out the AK's and other lesser craft.

[PaxMondo]

ORIGINAL: JuanG


Sometimes the AE editor, as wonderful as it is, doesn't cut it. For those times theres MS Excel. [:D]

How do you move the data from Excel to the game file? Are the files just text delimited? (I have never taken a look).

[JuanG]

WitploadAE is provided in the SCEN folder to extract and package the scenario data to and from .csv files. There a whole range of programs that can work with .csv, but I prefer Excel personally.

[bklooste]

ORIGINAL: FatR

As I said before, if Mitsubishi focuses on A7M2 early, there should be no A6M9. I'd slightly adjust some numbers. Is G3M4 supposed to be created to utilize the now-widely-produced engine? If so, we might have another answer to the problem of ASW plane (G3M3, accidentally, already is the best patrol aicraft IJN has in AE) but IRL G3M lacked speed, ceiling and defensive armament, compared to G4M, so, if the idea above catches on, it isn't inconceivable that Navy planners will decide to create a dedicated patrol plane on the basis of an outdated airframe, instead of pushing this airframe out of production.

G3M4 was based on 2 points
1) A lot of extra people on the Mitsubishi zero team with less to do in late 42 / early 43 ( the George being private) and i couldnt
2) The large production of the Kinsei 62 ( instead of just for the Dinahs until they decided the more complex engines were too hard in 45) and these being a slot in replacement for the Kinsei4x and 5x the Nells use. I would have preffered the G4M but these use the Kasei. Power to weight should be better for the same aerodynamics. Whether the engines are better used on Zeros is an issue for the player ( ie set factory to not upgrade ) .
eg
G3M2 2 * 1075
G3M3 2 * 1300hp June 1942 and February 1943
G3M4 2*1580 hp

The changes i made i was pretty brutal on the range and speed. Speed would prob be ~275 to 290 mph depending on fuel load and armour which compares well with the larger G4. I cut the range in half to give self sealing tanks.

Would a patrol varient have armour 1 ? Do you want range , speed or protection ? EMily is about 290 mph.

I think both a shorter ranged armoured version ( to go with zeros against heavy defended targets eg CVs) and a patrol varient are both viable. Maybe even G3M4 1/43+ upgrades to G3M5 ASW/Patrol plane 6/43+ . Is this too late ? Can LBA upgrade to Patrol or do they need seperate Daitai ?

[bklooste]

ORIGINAL: Red Lancer

The A6M8 is already in the Editor / Stock Artwork - Slot 619 / BMP 20

This is not the A6M8 62 though ... the 62 has a 4" larger engine and 2 wing mounted 13.2 mm ( as well as the cannons).

[bklooste]

ORIGINAL: FatR

Just to note, I intend to take into account bklooste's proposals in the posts from #259 to #267 in the old thread. Except those that aren't technically possible (factories, AFAIK, always upgrade when the next plane in the tree is available, unles the upgrade is set to OFF).

P.S. John, I'll need to work on the locations file too, factories are there.

No issues with this players can just choose to leave the M5 on most factories setting the factory upgrade to off. They will have to work hard to build up Kinsei 62s..it may be wise to research this from the start with the idea if you get it 1 month earlier you will have time to grow the factory. [Just player tips here]

[RedLancer]

This is not the A6M8 62 though ... the 62 has a 4" larger engine and 2 wing mounted 13.2 mm ( as well as the cannons).

Is that 4" longer or wider? How would the 13.2 mm effect the wingshape. As I've said I need a bit of help or the artwork might end up looking like this....

[bklooste]

ORIGINAL: Red Lancer

This is not the A6M8 62 though ... the 62 has a 4" larger engine and 2 wing mounted 13.2 mm ( as well as the cannons).

Is that 4" longer or wider? How would the 13.2 mm effect the wingshape. As I've said I need a bit of help or the artwork might end up looking like this....

4" more circumfrence so 8" wider ( just the engine ) , im not 100% sure whtehr the A6M8 in game is the 62 model. The A6m8 62 should have 2 cannon on each wing , it shouldnt affect mush.


Regarding our A6M4 this is not based on the histrocal A6M4 but is a A6M8 62 with A6M3 non foldable wings

[Smeulders]

ORIGINAL: JuanG

WitploadAE is provided in the SCEN folder to extract and package the scenario data to and from .csv files. There a whole range of programs that can work with .csv, but I prefer Excel personally.

Are you simply changing the ammo by set parameter (ex. all x2) ? If so there is a pretty easy way of doing this.

1)Create a text file, put a number in it somewhere.
2)Open that text file with a spreadsheet program, I know this is possible in Open Office
3)Copy and paste the lines with the ammo amounts into the txt.
4)Apply the formula, creating a new row for the changed amounts
5)Save the txt. file and close it
6)Import it into excel again. Now here is the fun part, because it was saved as a .txt it only saves the values and not the formulas, so you now have a row with the original values and a row with the new values, which are no longer tied to the original values.
7)Copy and paste the row with your new values into the AE database spreadsheet, voila, thousands of changes in but a couple of minutes.

[FatR]

I decided to include N1K4-A (carrier-capable George, 45/5) and A7M3 (Sam with 6x20mm, 45/9) while I'm at it, to give the player more planes to look forward for 1945. Both of these models were developed but not produced in RL (N1K4-A got to prototype stage, while the incomplete prototype for A7M3 was destroyed when the plant got bombed). A7M2 will upgrade to A7M3, A7M3-J will have its own microfactory.

EDIT: I'm also thinking about D4Y5. In RL this MK9-powered plane remained under development at the time of Japan's capitulation. As in this scenario Mitshubishi MK9 is available earlier, it might enter production around 45/7-45/8.


As a side note, with PDU OFF no Japanese CVLs, assuming any survive to 1945, will ever carry Georges or Sams (with PDU ON, as far as I understand, groups can always be upgraded to any fighters of a particular class). "No fighters but Zeros on CVLs" can be included as a recommended houserule.

[FatR]

A question: if I understand correctly, in a game with PDU OFF upgrades cannot be skipped, by waiting until the next model is available?

[FatR]

And another question: anyone knows why E16A Paul has such limited combat range in the game? Its maximum range is superior to Jake, but the combat range is much inferior.

[JuanG]

ORIGINAL: Smeulders

ORIGINAL: JuanG

WitploadAE is provided in the SCEN folder to extract and package the scenario data to and from .csv files. There a whole range of programs that can work with .csv, but I prefer Excel personally.

Are you simply changing the ammo by set parameter (ex. all x2) ? If so there is a pretty easy way of doing this.

1)Create a text file, put a number in it somewhere.
2)Open that text file with a spreadsheet program, I know this is possible in Open Office
3)Copy and paste the lines with the ammo amounts into the txt.
4)Apply the formula, creating a new row for the changed amounts
5)Save the txt. file and close it
6)Import it into excel again. Now here is the fun part, because it was saved as a .txt it only saves the values and not the formulas, so you now have a row with the original values and a row with the new values, which are no longer tied to the original values.
7)Copy and paste the row with your new values into the AE database spreadsheet, voila, thousands of changes in but a couple of minutes.

Brilliant approach, but sadly it wont work here as the changes have no relation to the original values, only on the rounds carried for each gun and its rate of fire.


John, on a related note - I mentioned the issue with Japanese DD's all carrying DP guns in stock; do you want me to correct these to what they should be (ie only Type-B and Type-D 12.7cm mounts are DP), or shall I leave them as is? On one hand changing this can really hurt your fleets AA, forcing you to rely on cruisers and BBs for AA, but on the otherhand it really makes those new DDs with proper DP weaponry invalueble.

I've got the sub changes and RN ammo down to DD's done, but I might not be able to finish everything today, sorry.

[John 3rd]

I wake up and find tons of commentary:
 
1.  FatR--Keep up the work on the aircraft and, more importantly, keep up the questions on specific aircraft so we can get comments.
2.  BK--Good to see you back with us!
3.  I've got no issues with anything discussed regarding aircraft.  It all sounds reasonable to me.
4.  Red Lancer--I appreciate the attention to detail you are taking regarding your artwork.  NICE!
5.  Juan--Keep at the changes.  It sounds like a bear to do.
 
Smeulders--Thanks for the suggestion.  Brainstorming is a great thing and I really enjoy the synergy that comes with it.
 
Juan--As much as it pains me to say, go ahead and make those DDs guns RIGHT for the scenario.  Which classes of Japanese DDs actually have true DP guns?  I assume the Yugumos as well as Moon-Class.  Are there any others?
 
We've turned into a Scenario Design Team!  How about that?

[John 3rd]

Might be wise to begin a House Rules line of discussion on this Thread:
 
1.  No planes other then Zeros on Japanese CVLs.
 

[JuanG]

Ayanami (Fubuki II), Akatsuki (Fubuki III) and Hatsuharu have the Type-B mounts, which were capable of DP but had rather slow train and elevation rates.

Yugumo and Shimakaze had the more modern Type-D mounts. Obviously the Akizuki (Moon-class) had excellent DP capable mounts.

How far do you want me to go with this? I can probably get everything above DE and SS done today, but if you want me to go beyond that and do AKs, PCs and SCs, etc as well, it might take a few days.

As for the HRs, I'd revise it to have the same form as I use;

No A7M Sam, B7A Grace or N1K-A George on Japanese CVLs or CVEs, except for transfer purposes.

[ny59giants]

Since Japan will get a small Chutai of Judy for recon, can the American CVs get a small squadron (3 or 4 planes) of the Wildcat recon planes?? Would they upgrade to a Hellcat version later on??

I'm not into the "nuts and bolts" like others, but did see in the G'canal scenario the Americans having recon Wildcats.

EDIT - John and wife are going to Las Vegas over weekend, Juan. So take your time. [:D]