ARMY LIST CALCULATOR

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

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??

olivier · Post by **olivier** » Fri Jan 11, 2008 7:51 am

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

.

Shem · Post by **Shem** » Thu Jan 24, 2008 9:47 am

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...

carlos · Post by **carlos** » Thu Jan 24, 2008 10:35 am

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

Shem · Post by **Shem** » Thu Jan 24, 2008 3:52 pm

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

Works fine now!

stevoid · Post by **stevoid** » Fri Jan 25, 2008 10:04 pm

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

stevoid · Post by **stevoid** » Mon Feb 04, 2008 5:58 am

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)

olivier · Post by **olivier** » Mon Feb 04, 2008 7:39 pm

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.

stevoid · Post by **stevoid** » Mon Feb 04, 2008 7:48 pm

You're a legend!

nicofig · Post by **nicofig** » Mon Feb 04, 2008 7:59 pm

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.

nikgaukroger · Post by **nikgaukroger** » Mon Feb 04, 2008 8:44 pm

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

stevoid · Post by **stevoid** » Tue Feb 05, 2008 7:30 pm

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

Bugle999 · Post by **Bugle999** » Wed Feb 06, 2008 10:52 am

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,

ars_belli · Post by **ars_belli** » Wed Feb 06, 2008 12:04 pm

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

olivier · Post by **olivier** » Wed Feb 06, 2008 12:17 pm

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

thefrenchjester · Post by **thefrenchjester** » Wed Feb 06, 2008 3:39 pm

well done my Friend !
see you soon ;

thefrenchjester

nicofig · Post by **nicofig** » Thu Feb 07, 2008 6:38 am

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.

spike · Post by **spike** » Thu Feb 07, 2008 1:39 pm

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

olivier · Post by **olivier** » Thu Feb 07, 2008 3:26 pm

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

nicofig · Post by **nicofig** » Fri Feb 08, 2008 7:00 am

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