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.