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

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

felix
Private First Class - Opel Blitz
Private First Class - Opel Blitz
Posts: 2
Joined: Thu Nov 08, 2007 6:39 pm

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

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
Private First Class - Opel Blitz
Private First Class - Opel Blitz
Posts: 2
Joined: Thu Nov 08, 2007 6:39 pm

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

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

Et voilá! Everything works now, brilliant!

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 Dec 17, 2007 2:57 pm

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

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 » Tue Dec 18, 2007 6:45 am

ImageImage

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 » Tue Dec 18, 2007 2:02 pm

Wonderful... many thanks, Olivier!

Cheers,
Scott

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

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
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 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
Senior Corporal - Destroyer
Senior Corporal - Destroyer
Posts: 116
Joined: Thu Jan 03, 2008 8:13 pm
Location: Farnham, UK

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
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

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

Update : version 2.3

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

Thank you Olivier :wink:
ImageImage

kustenjaeger
Senior Corporal - Destroyer
Senior Corporal - Destroyer
Posts: 116
Joined: Thu Jan 03, 2008 8:13 pm
Location: Farnham, UK

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 :wink:
Do you know what the changes are? I couldn't see the v.2.3 improvements listed in the readme.

Regards

Edward

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

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

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.

:wink:

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

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 :shock:
FoG is full of surprises 8)

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
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 Jan 10, 2008 3:08 pm

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

andy63
Administrative Corporal - SdKfz 251/1
Administrative Corporal - SdKfz  251/1
Posts: 140
Joined: Mon Feb 05, 2007 11:59 am
Location: Mansfield. Notts.

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

Andy.

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: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
Administrative Corporal - SdKfz 251/1
Administrative Corporal - SdKfz  251/1
Posts: 140
Joined: Mon Feb 05, 2007 11:59 am
Location: Mansfield. Notts.

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

Cheers James will try it.

Andy.

Post Reply

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