GF3 Stat Generator

Naval warfare from 1890 through 1940

Moderator: underling

Ruckdog
Posts: 5
Joined: Thu Apr 13, 2017 11:09 am

GF3 Stat Generator

Postby Ruckdog » Mon Apr 17, 2017 10:44 pm

Greetings! I've been having a good time learning GF3 lately. I was very impressed with the conversion rules in the book which inspired me to create a stat generator using Excel that automates the stat card generation process! Here it is, in all of its Excel glory:

www.manbattlestations.com/hostedfiles/G ... er1.1.xlsx

Please download it and let me know what you think! I had to learn a few new tricks when it comes to Excel functions to make this, so its entirely possible I've got some errors in there somewhere!

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3585
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: GF3 Stat Generator

Postby mj12games » Tue Apr 18, 2017 1:17 am

Wow... this is quite impressive!

I'll put it through some paces when I get the chance. :)
Daniel Kast
Majestic Twelve Games
www.mj12games.com

Ruckdog
Posts: 5
Joined: Thu Apr 13, 2017 11:09 am

Re: GF3 Stat Generator

Postby Ruckdog » Tue Apr 18, 2017 11:25 am

Please do! I'm very interested in hearing about your perspective as the games designer on this thing. It seems like I'm able to replicate fairly closely a few of the stat cards included in the base rule book, so I think it's fairly close. One think I'm not sure about is if the DP modifiers for the secondary guns are being calculated correctly. It seems the math is set up right, but my generator is producing larger modifiers than what appears in the official MJ12 stats. For example, my generator reruns a -8 modifier for the IJN Myoko, while the official stats peg her modifier at a -3 IIRC.

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3585
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: GF3 Stat Generator

Postby mj12games » Tue Apr 18, 2017 7:18 pm

Ruckdog wrote:For example, my generator reruns a -8 modifier for the IJN Myoko, while the official stats peg her modifier at a -3 IIRC.

The value on the "official" ship card is derived from 8x 127mm DP guns, 8x 25mm AA guns, and 4x 13mm MGs. If your source material gives more anti-aircraft guns, your modifier will be higher.
Daniel Kast
Majestic Twelve Games
www.mj12games.com

Marauder
Commander
Commander
Posts: 300
Joined: Mon Nov 15, 2010 10:40 pm
Location: Vancouver, BC

Re: GF3 Stat Generator

Postby Marauder » Wed Apr 19, 2017 12:09 pm

This is impressive. I started one a couple years back, but hit a snag and never managed to wrap it up.

I'll try out some Kriegsmarine when I get a chance.

Ruckdog
Posts: 5
Joined: Thu Apr 13, 2017 11:09 am

Re: GF3 Stat Generator

Postby Ruckdog » Wed Apr 26, 2017 9:08 pm

mj12games wrote:
Ruckdog wrote:For example, my generator reruns a -8 modifier for the IJN Myoko, while the official stats peg her modifier at a -3 IIRC.

The value on the "official" ship card is derived from 8x 127mm DP guns, 8x 25mm AA guns, and 4x 13mm MGs. If your source material gives more anti-aircraft guns, your modifier will be higher.


Ahh, got it, thanks. I re-ran the Myoko's stats with those AA gun nubmers, and got the -3 I was supposed to. The first time I just went to Wikipedia to get a quick set of numbers, and those do not reflect the 25mm mounts.


Return to “Grand Fleets”

Who is online

Users browsing this forum: No registered users and 2 guests