Slitherine

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

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.

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

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

Et voilá! Everything works now, brilliant!

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

It's online here :

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

Wonderful... many thanks, Olivier!

Cheers,
Scott

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.

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

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

Update : version 2.3

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

Thank you Olivier

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

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.

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.

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.

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

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.

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.

Cheers James will try it.

Andy.