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