Simple Army List calculator

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

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

Post Reply
lpgamble
Administrative Corporal - SdKfz 232 8Rad
Administrative Corporal - SdKfz 232 8Rad
Posts: 153
Joined: Mon Jun 25, 2007 8:00 pm
Location: Houston. Tx

Simple Army List calculator

Post by lpgamble » Thu Apr 24, 2008 3:00 pm

Excel Template to build an army list

Place the file in C:\Documents and Settings\USERID\Application Data\Microsoft\Templates
replace USERID with your logon ID

when your in a workbook right click the worksheet tabs at the bottom and select insert
it should list the template there. Select it and it will place a blank copy of what I use to point up a list

http://groups.yahoo.com/group/NorthAmer ... ogList.XLT

donal
Lance Corporal - Panzer IA
Lance Corporal - Panzer IA
Posts: 11
Joined: Thu Feb 21, 2008 12:32 am

Post by donal » Sun Apr 27, 2008 5:31 pm

you should take a look at olivier's at

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

It's excellent
Don

SirGarnet
Brigadier-General - Elite Grenadier
Brigadier-General - Elite Grenadier
Posts: 2186
Joined: Fri Apr 18, 2008 10:13 am

Post by SirGarnet » Sun Apr 27, 2008 6:51 pm

Olivier's is nicely done, but I found one bug. Heavy Weapon is both Impact and Melee, but it only counts points for it if put in the impact POA box, not the Melee POA box. I understand from an earlier RBS post that HW is exclusive as both an Impact and Melee POA, so if put in either box it should probably pop up automtically in the other box.

Malidor
Corporal - Strongpoint
Corporal - Strongpoint
Posts: 58
Joined: Mon Jan 21, 2008 8:37 am
Location: Brisbane, Australia
Contact:

Post by Malidor » Tue Apr 29, 2008 2:56 am

MikeK wrote:Olivier's is nicely done, but I found one bug. Heavy Weapon is both Impact and Melee, but it only counts points for it if put in the impact POA box, not the Melee POA box. I understand from an earlier RBS post that HW is exclusive as both an Impact and Melee POA, so if put in either box it should probably pop up automtically in the other box.
Please offer this feedback in a place where Olivier will find it (if you haven't already crossposted this elsewhere)

SirGarnet
Brigadier-General - Elite Grenadier
Brigadier-General - Elite Grenadier
Posts: 2186
Joined: Fri Apr 18, 2008 10:13 am

Post by SirGarnet » Tue Apr 29, 2008 3:25 am

Malidor wrote:Please offer this feedback in a place where Olivier will find it (if you haven't already crossposted this elsewhere)
Tis done.

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1126
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Wed Apr 30, 2008 7:19 am

Hello, I'm here! :lol:
It was not really a bug because it was intentional...
It's a bit difficult to put in a same cell a scrolling AND a formulae :? and I don't want use any macro :evil:
If you have an answer to this problem, I'm more than happy to see it :)
Olivier

SirGarnet
Brigadier-General - Elite Grenadier
Brigadier-General - Elite Grenadier
Posts: 2186
Joined: Fri Apr 18, 2008 10:13 am

Post by SirGarnet » Wed Apr 30, 2008 8:45 am

olivier wrote:Hello, I'm here! :lol:
It was not really a bug because it was intentional...
It's a bit difficult to put in a same cell a scrolling AND a formulae :? and I don't want use any macro :evil:
If you have an answer to this problem, I'm more than happy to see it :)
Olivier
Your work is appreciated. How about simply removing HW as an option from the second POA box (Melee)? HW excludes other choices anyway.

Post Reply

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