ARMY LIST CALCULATOR

General discussion forum for anything related to Field of Glory Ancients & Medieval.

Moderators: hammy, Slitherine Core, Field of Glory Moderators, Field of Glory Design

hammy
Field of Glory Team
Field of Glory Team
Posts: 5440
Joined: Tue Aug 22, 2006 2:11 pm
Location: Stockport
Contact:

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
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

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??
:shock: 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 :wink: .

Shem
Lance Corporal - SdKfz 222
Lance Corporal - SdKfz 222
Posts: 26
Joined: Thu Dec 27, 2007 3:53 pm

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
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 516
Joined: Tue Aug 29, 2006 9:27 am

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
Lance Corporal - SdKfz 222
Lance Corporal - SdKfz 222
Posts: 26
Joined: Thu Dec 27, 2007 3:53 pm

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

Works fine now!

stevoid
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 285
Joined: Sun Oct 21, 2007 9:03 pm
Location: Wellington, New Zealand

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

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

:wink:
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
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 285
Joined: Sun Oct 21, 2007 9:03 pm
Location: Wellington, New Zealand

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
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

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
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 285
Joined: Sun Oct 21, 2007 9:03 pm
Location: Wellington, New Zealand

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

You're a legend!

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

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. :wink:
ImageImage

nikgaukroger
Field of Glory Moderator
Field of Glory Moderator
Posts: 10265
Joined: Tue Aug 22, 2006 9:30 am
Location: LarryWorld

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 :shock:

stevoid
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 285
Joined: Sun Oct 21, 2007 9:03 pm
Location: Wellington, New Zealand

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
Senior Corporal - Ju 87G
Senior Corporal - Ju 87G
Posts: 80
Joined: Tue May 08, 2007 11:16 am
Location: London (S.E.) UK

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
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 540
Joined: Mon Feb 12, 2007 10:18 pm
Location: USA

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
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

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! :wink:


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. 8)
Rgds,
Olivier

thefrenchjester
Lieutenant Colonel - Elite Panther D
Lieutenant Colonel - Elite Panther D
Posts: 1376
Joined: Sun Apr 01, 2007 12:23 pm
Location: the wilderness of mirrors

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

well done my Friend !
see you soon ;

thefrenchjester

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

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. :wink:
Last edited by nicofig on Wed Feb 20, 2008 6:05 am, edited 1 time in total.
ImageImage

spike
Sergeant Major - Armoured Train
Sergeant Major - Armoured Train
Posts: 554
Joined: Wed Jan 31, 2007 4:12 pm
Location: Category 2

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


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
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

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

Oops! :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 :P
Olivier

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

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

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

Post Reply

Return to “Field of Glory : Ancient & Medieval Era 3000 BC-1500 AD : General Discussion”