INFO: C3C Unit Summary Spreadsheet

[Theseus]

Just what the title says. Mucho thanks to Nethog for creating the original PTW summary.

As a little bonus, I've also included an Army combat bonus summary for all the relevant units.

Please feel free to PM or post any corrections.

Enjoy.

[Edit: Updated to Rev1.01]

[MrWhereItsAt]

Hope you don't mind Theseus - have added the lethal sea and lethal sea+land bombard traits for Fighters and Bombers respectively that appear in the editor.

[Slax]

Its a good thing.

Thanx

[kermit_the_frog]

wow thanks

[Theseus]

Good job, MWIA!

Other people feel free to do the same... do us all a favor though, and rename the file with an updated revision number. So, MWIA's version should be considered rev 1.01.

[TimHobbit]

Really dumb question:
Did someone overlook the Mayan UU, Javelin Thrower?

It should be listed under archer along with Bowman.

[Theseus]

You are correct... I'll make the change, using MWIA's version.

[Rubychaser]

Interesting work. Yes very interesting.

[steven8r]

Theseus,

I don't get the version w/ the Jav Chucker listed.

Edit: I've d/l 1.01

Also, where did you get the info for the Army bonuses? It seems that some Army make-ups are stronger than others w/ similar stats.

Edit2: How about a Conquistador Army?

Thanks

[Theseus]

steven8r, which stats seemwrong?

I'll put up rev 1.03 with any corrections and Conquistadors, but first, a question:

Can Explorers be loaded into Armies?

BTW, aren;t some of the stats just friggin' STUNNING??!!

[steven8r]

Originally posted by Theseus
steven8r, which stats seemwrong?

I don't necessarily think anything's wrong, but there are some things currious:

It seems that any unit w/ a stat of 1 (excepting movement) retains that 1 even in an army. But if the stat is more than 1, then it gets boosted. Perhaps this is just the way it works.

For example, Hoplite vs NumMerc armies.
Hoplite 1/3/1
NumMerc 2/3/1
Put these in a 3x army and the Hoplite still has only 1 attack, but the NumMerc gets attack AND defense boost.

Some units get attack/defense increase of 1, some get increase of 2 or more in an Army.

What determins which stats get increased or not and by how much? Is there a formula for this?

Thanks,

(Don't know about the 'loadability' of Explorers, yet)

Steven

[steven8r]

Theseus,

I just played as Japan and have a (several, actually) 4x Elite Samurai Army w/ the Military Academy. When it shows the Army in the Infobox, it only says 4/4/3. Where does the 8/8/3 show up? (although these guys don't even break a sweat vs Tanks.)

Thanks,

Steven

[Theseus]

Sorry, I don;t check this forum enough (having a grand total of one file ever in here. )

Answer #1: Pre-Mil Academy, C3C Armies add 1/6 of total strength, rounded. So, yes, 3xNMs get 1 added to attack, while 3xHoplites get nothing on attack.

Answer #2: Bonuses don;t show on the "Army" stats (nor do appropriate mixed unit stats).

[steven8r]

Originally posted by Theseus
Sorry, I don;t check this forum enough (having a grand total of one file ever in here. )

Perspire Not. (in other words, 'Don't sweat it.')

I appreciate your answer, however, I was able to find where you (and Catt) had answered the same question in Phobos' 'Help w/ Armies' thread.

So, Army gets +1/6 added to attack/defense, and w/ MilAc gets +1/4 added. This is in the case of homogenous Armies. Mixed Armies get 'averaged' stats or something.

And don't even bother looking at the 'Stats' in the InfoBox cause they're so off it's pathetic.

I think I got it now. Thanks.

(and my appologies if this info was already explained in your thread, 'On the Use and Utility of Armies'. That thread is at least 7 pages long and I got too lazy to look through it all.)

And thanks again for your Unit Summary Spreadsheet (I really like the 'Army' tab.)

Steven