Slitherine

There looks to be a problem with the 25% and autobreak for 2 base BG's. I think a 2 base BG should have a 25% of 1 and an autobreak of 1 but it shows as 1 and 0??

I think that the 25% figures and autobreak only work when all all BG's in your list have an order of march entry

Exact

There looks to be a problem with the 25% and autobreak for 2 base BG's. I think a 2 base BG should have a 25% of 1 and an autobreak of 1 but it shows as 1 and 0??

I verified and I have only this result when I don't put a quality for my BG. I even have an autobreak of 2 for elite and superior BG .

Hello,
is there a way to use this exel sheet with open office? I only get a sheet full of errors, but I'm new to that program and don't know if I can fix this somehow...

Check page 3 of this topic because I asked the exact same thing.

Changing the values of two names in Insert->Names->Define makes it work properly with OpenOffice.
"Zone_traduction" assigned to $Traduction.$A$1:$E$80 and "Local_language" assigned to $'liste armée'.$E$3

Ah thanks! I read the beginning and the end of the thread, skipping page 3...

Works fine now!

nicofig wrote: 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

Just 'bumping' the link to the latest page

Thanks for the great work on this.

PS - to users of previous versions, read the read me, especially with regard to new approach for mixed BGs

Hi,

Not sure if I'm reading it right but I think the spreadsheet includes scythed chariots in the FOG attrition point table and ideally they wouldn't count for that purpose

Steve (feeling bad for pointing out a problem with a great resource)

Not sure if I'm reading it right but I think the spreadsheet includes scythed chariots in the FOG attrition point table and ideally they wouldn't count for that purpose Smile

You're right, I corrected today as for BG numbers. The last version will be uploadable soon at the site of my friend.

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

Thank for your support.

You're a legend!

New update. This is the version 2.3.2 (04 february 2008).

Improvement with 2.3.2 :

- Setting of columns of troops types in the order of the lists
- Correction of the bug with Scythed chariots

Any comments are welcome.
Thank you Olivier.

Hardly world shattering but any chance, in the English version, of getting "Offensive Spear" in the impact drop down instead of "Offensif Spear" - defensive was managed but the poor offensive types missed out

Feeling a bit like the Oilver from Dickens here, but - is there a way to easily move lists from an older version of the spreadsheets to the newer? Copy and paste does not work too well as the order of some columns seems to have changed.

Steve

Many thanks for this excellent tool...
Can you explain the cell labelled 'Attrition Point Value' (numbers 1-10) - the actual Text for the Title of this cell is not fully visible as it has not been compressed onto one line - currently disappears from view?
TIA for advice.
Regards,

Bugle999 wrote:Many thanks for this excellent tool...
Can you explain the cell labelled 'Attrition Point Value' (numbers 1-10) - the actual Text for the Title of this cell is not fully visible as it has not been compressed onto one line - currently disappears from view?
TIA for advice.
Regards,

In earlier versions of the spreadsheet, the cells 9 c-j are merged, so the text is centered across the space. The "merge and center" function does not appear to work in my copy, so if Olivier can merge the cells and repost the file, that should take care of the problem.

Cheers,
Scott

Hello,

Copy and paste does not work too well as the order of some columns seems to have changed.

You must copy and paste on 3 segment: before armour clumn, the armour column and after armour column. Only "Armour" column had changed to follow the order of lists.
It work for me!

PostPosted: 04 Feb 2008 20:44 Post subject:
Hardly world shattering but any chance, in the English version, of getting "Offensive Spear" in the impact drop down instead of "Offensif Spear"

Done.

Can you explain the cell labelled 'Attrition Point Value' (numbers 1-10) - the actual Text for the Title of this cell is not fully visible as it has not been compressed onto one line - currently disappears from view?

It's only linked with the official scoring sheet. this is an automatic counting of the value of point loses in conjonction with your attrition level.
I forget to merge and center after the translation of the armour column. Now it's done and effective in the next version.
Rgds,
Olivier

well done my Friend !
see you soon ;

thefrenchjester

New update. This is the version 2.3.3 (07 february 2008).

Improvement with 2.3.3 :

- Change of the graphic charter
- Correction of some détails
- Arrangement of the back office

Any comments are welcome.
Thank you Olivier.

nicofig wrote:New update. This is the version 2.3.3 (07 february 2008).

Improvement with 2.3.3 :

- Change of the graphic charter
- Correction of some détails
- Arrangement of the back office

Any comments are welcome.
Thank you Olivier.

It is not calculating correctly- I tested it at lunch, and it is not adding in the points for any of the POA's

Steve

Oops!
I forget to rename a cell with his sheet name!
One little thing and a world crash !
It's OK now and I send soon (After the work session) a correct version to be uploaded
Olivier

It's corrected on the website. You can upload the new version.