ARMY LIST CALCULATOR

olivier · Post by **olivier** » Fri Dec 07, 2007 8:15 pm

As the rule treat camelry as funny horse, I assume ( rightly ?) that cataphract camel don't count for initiative...

felix · Post by **felix** » Sun Dec 09, 2007 2:49 pm

carlos wrote:Pity it doesn't work with OpenOffice, but that's life.

Changing the values of two names in Insert->Names->Define makes it work properly with OpenOffice.
"Zone_Traduction" as =Traduction!$A$1:$E$80 and "Local_Language" as ='liste armée'!$E$3. This changes don't have any effect if you use Excel.

carlos · Post by **carlos** » Sun Dec 09, 2007 3:16 pm

felix, I get an "Invalid Expression" error. Do you know what is going on? Thanks

felix · Post by **felix** » Mon Dec 10, 2007 12:20 am

carlos wrote:felix, I get an "Invalid Expression" error. Do you know what is going on? Thanks

The values of the previous post are valid if you use Excel. If you made the changes directly on OpenOffice the correct values are:
"Zone_traduction" assigned to $Traduction.$A$1:$E$80 and "Local_language" assigned to $'liste armée'.$E$3

carlos · Post by **carlos** » Mon Dec 10, 2007 1:55 am

Et voilá! Everything works now, brilliant!

olivier · Post by **olivier** » Mon Dec 17, 2007 2:57 pm

new version soon on the net.
automatic computing for 25% and autobreak

nicofig · Post by **nicofig** » Tue Dec 18, 2007 6:45 am

It's online here :

http://fieldofglory.fr/spip.php?article2

ars_belli · Post by **ars_belli** » Tue Dec 18, 2007 2:02 pm

Wonderful... many thanks, Olivier!

Cheers,
Scott

hammy · Post by **hammy** » Wed Jan 02, 2008 11:18 am

I have a minor problem with the spreadsheet. I have just produced an army with less than 10 cavalry but with an IC and for some reason the system thinks I have a pre battle initiative of +0

EDIT: Ah, sorted... it helps if you nominate a CinC

EDIT AGAIN: Hmm, how do I do mixed BG's. I tried 4a and 4b for order of march and I tried 4 and 4 for order of march but neither wanted to work.

olivier · Post by **olivier** » Wed Jan 02, 2008 12:36 pm

EDIT AGAIN: Hmm, how do I do mixed BG's. I tried 4a and 4b for order of march and I tried 4 and 4 for order of march but neither wanted to work

Try 4 and 4bis. It's work but sometimes when you sort the 4bis goes to the end of the list.

Olivier

kustenjaeger · Post by **kustenjaeger** » Sun Jan 06, 2008 4:03 pm

Greetings

This is a very useful tool. I'm operating a bit in the dark with the rules until I get them in February but I've managed to generate a Greek hoplite army which looks reasonable from a historical viewpoint.

Regards

Edward

nicofig · Post by **nicofig** » Wed Jan 09, 2008 5:11 pm

Update : version 2.3

http://fieldofglory.fr/spip.php?article2

Thank you Olivier

kustenjaeger · Post by **kustenjaeger** » Wed Jan 09, 2008 6:02 pm

Greetings

nicofig wrote:Update : version 2.3

http://fieldofglory.fr/spip.php?article2

Thank you Olivier

Do you know what the changes are? I couldn't see the v.2.3 improvements listed in the readme.

Regards

Edward

nikgaukroger · Post by **nikgaukroger** » Wed Jan 09, 2008 9:27 pm

On another topic it has been pointed out that the spreadsheet does not allow Protected Mob - which the Sasanids can have.

Can this be corrected please.

olivier · Post by **olivier** » Thu Jan 10, 2008 12:47 pm

On another topic it has been pointed out that the spreadsheet does not allow Protected Mob

Done today!

I wasn't aware that Mob can have POA and in my sassanid version mob are unprotected

Do you know what the changes are? I couldn't see the v.2.3 improvements listed in the readme.

OH, a miracle! someone who read a "read me"

Yesterday, I haven't had any time to write and translate the read me. I promise to work on it today.

Major change :

I debugged the problem with mixed BG. Now you must write the same number on the order of march for the two part of mixed BG.
The "number of BG" cell count only different number.
The "25%" cells and "autobreak" cells calculate real level number for mixed BG with the help of "order of march" cells.
You have the real number only after write your order of march.

Today I put the official score sheet on the attrition point cell, add protected mob and, normally, complete the read me.

nikgaukroger · Post by **nikgaukroger** » Thu Jan 10, 2008 2:25 pm

olivier wrote:
On another topic it has been pointed out that the spreadsheet does not allow Protected Mob
Done today! I wasn't aware that Mob can have POA and in my sassanid version mob are unprotected

FoG is full of surprises

FWIW in theory Mob can have any PoA, armour, etc. However, in practice I don't think any will ever be better than Protected or have any combat capability other than Light Spear impact PoA.

nicofig · Post by **nicofig** » Thu Jan 10, 2008 3:08 pm

The v.2.3.1 (10 january 2008) is online.

improvement with 2.3.1 :
- real counting of BG in the BG number
- Correction of mixed BG bug. Autobreack and 25% are calculated with the help of "order of march " cells. All counting are made on the first line of the mixed BG.
- "Mob" can be "protected" now
- Attrition score is taken from the official scoring sheet.

http://www.fieldofglory.fr/spip.php?article2

andy63 · Post by **andy63** » Thu Jan 10, 2008 5:21 pm

Hi,

Having problems with the new spreadsheet with the auto break and the 25%.
An example!

1st order of march 4 Average Lh comes up correctly as auto break 2 & 1 for 25% but when put next unit of same underneith it comes up auto break 5 & 0 for 25%.

Help what am i doing wrong!

Andy.

hammy · Post by **hammy** » Thu Jan 10, 2008 6:00 pm

I think that the 25% figures and autobreak only work when all all BG's in your list have an order of march entry. I thought it was going a bit wierd to start with but when I put in all the order of march numbers it fixed itself.

andy63 · Post by **andy63** » Thu Jan 10, 2008 6:09 pm

Cheers James will try it.

Andy.