Page 1 of 1

Simple Army List calculator

Posted: Thu Apr 24, 2008 3:00 pm
by lpgamble
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

Posted: Sun Apr 27, 2008 5:31 pm
by donal
you should take a look at olivier's at

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

It's excellent
Don

Posted: Sun Apr 27, 2008 6:51 pm
by SirGarnet
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.

Posted: Tue Apr 29, 2008 2:56 am
by Malidor
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)

Posted: Tue Apr 29, 2008 3:25 am
by SirGarnet
Malidor wrote:Please offer this feedback in a place where Olivier will find it (if you haven't already crossposted this elsewhere)
Tis done.

Posted: Wed Apr 30, 2008 7:19 am
by olivier
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

Posted: Wed Apr 30, 2008 8:45 am
by SirGarnet
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.