Simple Army List calculator

lpgamble · 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 · 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 · 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 · 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 · 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 · Post by **olivier** » Wed Apr 30, 2008 7:19 am

Hello, I'm here!

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

If you have an answer to this problem, I'm more than happy to see it

Olivier

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

olivier wrote:Hello, I'm here!
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
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.