Army List and Label Generator - Download - Version 1.04
Moderators: terrys, hammy, philqw78, Blathergut, Slitherine Core
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Army List and Label Generator - Download - Version 1.04
Hi,
Check out the FOGN Army List and Label Generator which you can download free from the NWA website:
http://www.nwa.org.au/index.php?option= ... Itemid=236
This is to make it easier putting Army Lists together. Uses pull-down lists to help you select troop types, elean, quality and attachments.
Automatically calculates the points cost of your army and the ACV values.
It can also generate labels for your troops, from the army list you have made, with just a single click!
The program runs under Excel 2010 and must have macros enable for it to work. Let me know if you find any errors and I will correct them.
There is a version also saved as Excel 2003 file type.
UPDATED - Version 1.04 has been made available 17-Apr-12 at 9:15pm Australian Eastern Standard Time.
Version 1.04: Changed ACV calculations to nearest 0.5 points due to a removed Spent Cavalry base being worth only 0.5 points.
Version 1.03: This properly fixed points cost for Guards, adds some more nations and also adds ACV values when defender gets the +2 ACV.
Note that although this is endorsed by Slitherine, the program (and any errors) are mine. Let me know in this post of any issues and I will try to help.
Cheers,
John Shaw
Nunawading Wargames Association Inc.
http://www.nwa.org.au
Check out the FOGN Army List and Label Generator which you can download free from the NWA website:
http://www.nwa.org.au/index.php?option= ... Itemid=236
This is to make it easier putting Army Lists together. Uses pull-down lists to help you select troop types, elean, quality and attachments.
Automatically calculates the points cost of your army and the ACV values.
It can also generate labels for your troops, from the army list you have made, with just a single click!
The program runs under Excel 2010 and must have macros enable for it to work. Let me know if you find any errors and I will correct them.
There is a version also saved as Excel 2003 file type.
UPDATED - Version 1.04 has been made available 17-Apr-12 at 9:15pm Australian Eastern Standard Time.
Version 1.04: Changed ACV calculations to nearest 0.5 points due to a removed Spent Cavalry base being worth only 0.5 points.
Version 1.03: This properly fixed points cost for Guards, adds some more nations and also adds ACV values when defender gets the +2 ACV.
Note that although this is endorsed by Slitherine, the program (and any errors) are mine. Let me know in this post of any issues and I will try to help.
Cheers,
John Shaw
Nunawading Wargames Association Inc.
http://www.nwa.org.au
Last edited by Chasseur on Tue Apr 17, 2012 11:25 am, edited 4 times in total.
-
- Sergeant First Class - Elite Panzer IIIL
- Posts: 437
- Joined: Mon Jul 16, 2007 12:42 pm
- Location: Scotland
Re: Army List and Label Generator - for Download
Looks good. Having built a list generator for use by my club (don't worry people, I've sent a copy to JD!) I appreciate just how much work is involved.
Initial questions
1. Can't see how to put two attachments against a unit.
2. Can't see how to allocate attachments to a division (for those armies where attachments aren't allocated until terrain is placed)
Initial questions
1. Can't see how to put two attachments against a unit.
2. Can't see how to allocate attachments to a division (for those armies where attachments aren't allocated until terrain is placed)
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
Re: Army List and Label Generator - for Download
1. It's in the pull down menu for the attachments box! You choose to give the unit the two you want.AlanCutner wrote:Looks good. Having built a list generator for use by my club (don't worry people, I've sent a copy to JD!) I appreciate just how much work is involved.
Initial questions
1. Can't see how to put two attachments against a unit.
2. Can't see how to allocate attachments to a division (for those armies where attachments aren't allocated until terrain is placed)
Re: Army List and Label Generator - for Download
Sounds very useful.
Unfortunately my Excel is 2003.
Unfortunately my Excel is 2003.
-
- Sergeant First Class - Elite Panzer IIIL
- Posts: 437
- Joined: Mon Jul 16, 2007 12:42 pm
- Location: Scotland
Re: Army List and Label Generator - for Download
Should load in earlier versions of Excel and Open Office - at least it does for me.
Still don't see how to add attachments to a division rather than direct to the units.
Still don't see how to add attachments to a division rather than direct to the units.
-
- Lieutenant Colonel - Panther D
- Posts: 1266
- Joined: Tue Jan 20, 2009 8:52 am
- Location: Auckland, NZ
Re: Army List and Label Generator - for Download
Gret work John
One little gliche I can see is that the points for Guard seem to be light. Making a small unit guard in the program adds 8 points, 12 for a large. Should be 16 and 24 respectively (except for artillery of course).
Cheers
Brett
One little gliche I can see is that the points for Guard seem to be light. Making a small unit guard in the program adds 8 points, 12 for a large. Should be 16 and 24 respectively (except for artillery of course).
Cheers
Brett
-
- Field Marshal - Me 410A
- Posts: 5000
- Joined: Mon Oct 20, 2008 12:41 am
Re: Army List and Label Generator - for Download
Thank you for your work this should make coming up with Froggie Blatergut bashing armies much easier.
I tried to make a new army list picking the new army tag and it opened a list of a premade Austrian army, was that intentional and you just change add what you want? I was just wondering before I start clicking cells and go oops
I tried to make a new army list picking the new army tag and it opened a list of a premade Austrian army, was that intentional and you just change add what you want? I was just wondering before I start clicking cells and go oops
Re: Army List and Label Generator - for Download
List + Label = Great idea!
Last edited by SirGarnet on Sun Apr 15, 2012 7:24 am, edited 1 time in total.
-
- Field Marshal - Me 410A
- Posts: 5000
- Joined: Mon Oct 20, 2008 12:41 am
Re: Army List and Label Generator - for Download
I am having some problems with the generator, trying to make a 2 division army with a mixed division with 6 units and 4 attachments in the first division and 6 units in the second division, can't seem to clear it of the pre-made 4 divisions 5 commanders etc that keeps popping up when I click new list. Was this intentional that you can only have 4 units per division? Can't seem to find anything in the rules in regards to what a maximum size would be. Is there a default blank sheet to start with?
Thanks for your help
Thanks for your help
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
Re: Army List and Label Generator - for Download
1. Clear the troop field (use the pull down menu and choose the blank at the top) and the general field to clear the entries.deadtorius wrote:I am having some problems with the generator, trying to make a 2 division army with a mixed division with 6 units and 4 attachments in the first division and 6 units in the second division, can't seem to clear it of the pre-made 4 divisions 5 commanders etc that keeps popping up when I click new list. Was this intentional that you can only have 4 units per division? Can't seem to find anything in the rules in regards to what a maximum size would be. Is there a default blank sheet to start with?
Thanks for your help
2. Right click and insert row to add to a division. Then copy the boxes with the calculations from one of the previous lines (the boxes right of the attachment box) into the matching boxes of your new line.
This is mentioned in the notes but the language initially confused me.
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Re: Army List and Label Generator - for Download
Hi Alan,
2. There is no way to have a divisional attachment in this first version. I will look at adding this. In the mean time, just add it as an attachment to a unit and make a note at the bottom which attachments can be moved around at deployment. The points should be right, but the labels may need editing.
Cheers,
John Shaw
1. Just scroll down in the attachment pull-down list. The first part of the list are the single attachments. The lower part of the list are the allowed 2 attachments.1. Can't see how to put two attachments against a unit.
2. Can't see how to allocate attachments to a division (for those armies where attachments aren't allocated until terrain is placed)
2. There is no way to have a divisional attachment in this first version. I will look at adding this. In the mean time, just add it as an attachment to a unit and make a note at the bottom which attachments can be moved around at deployment. The points should be right, but the labels may need editing.
Cheers,
John Shaw
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Re: Army List and Label Generator - for Download
Hi,
However, if you find a blank canvas better, then what I could do for updated version is to have two choices - a totally blank sheet and also a typical filled out one which you can use as a starting point to modify.
Your thoughts?
John Shaw
The idea was to have a starting point to modify as it is sometimes easier to do this than starting totally from scratch.deadtorius wrote:Thank you for your work this should make coming up with Froggie Blatergut bashing armies much easier.
I tried to make a new army list picking the new army tag and it opened a list of a premade Austrian army, was that intentional and you just change add what you want? I was just wondering before I start clicking cells and go oops
However, if you find a blank canvas better, then what I could do for updated version is to have two choices - a totally blank sheet and also a typical filled out one which you can use as a starting point to modify.
Your thoughts?
John Shaw
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Re: Army List and Label Generator - for Download
Hi,
Cheers,
John Shaw
I shall check this out tonight and fix if it is wrong.BrettPT wrote:One little gliche I can see is that the points for Guard seem to be light. Making a small unit guard in the program adds 8 points, 12 for a large. Should be 16 and 24 respectively (except for artillery of course).
Cheers
Brett
Cheers,
John Shaw
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Re: Army List and Label Generator - for Download
Hi,
Cheers,
John Shaw
I shall check this out tonight and fix if it is wrong.BrettPT wrote:One little gliche I can see is that the points for Guard seem to be light. Making a small unit guard in the program adds 8 points, 12 for a large. Should be 16 and 24 respectively (except for artillery of course).
Cheers
Brett
Cheers,
John Shaw
Re: Army List and Label Generator - for Download
Can't seem to find the "new army list" button.
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
Re: Army List and Label Generator - for Download
It's up in the notes, just below where it mentions "new army list" button.Albion1 wrote:Can't seem to find the "new army list" button.
Re: Army List and Label Generator - for Download
Wouldn't open in 2003 so downloaded Open Office (thanks to Mr. Cutner for the tip).
Maybe it doesn't work perfectly in OO though.
Still can't get new army button - thanks for trying Blathergut.
And on drop down menus, if I try to change something the only other option to the thing written is "o".
Anyone using this successfully in OO?
Maybe it doesn't work perfectly in OO though.
Still can't get new army button - thanks for trying Blathergut.
And on drop down menus, if I try to change something the only other option to the thing written is "o".
Anyone using this successfully in OO?
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
Re: Army List and Label Generator - for Download
Perhaps the designer could save version(s) in Word 2003 format? Does Word 2003 have an option to enable macros? Maybe that's part of the problem. It seems to work fine in Word 2007 here.
-
- Master Sergeant - U-boat
- Posts: 544
- Joined: Wed Jan 21, 2009 7:42 am
- Location: Melbourne, Australia
- Contact:
Re: Army List and Label Generator - for Download - Version 1
Hi,
Have just updated the Army List Generator to Version 1.02. Fixes are:
1. Fixed up the points value for Guard units (thanks for finding that, Brett).
2. Added a unit type called "Attachment (after terrain)". This is if you wish to show attachments that are allocated after terrain placement, but before any units are placed. "Attachment (after terrain)" can be found at the very bottom of the "Troop Type" pull-down list. Make sure columns D, E, F, G and H are blank. Then select the attachment you want from the pull-down list in the "Attachment" column. Of course, a separate label will be generated for this entry which will mean that this label has to be added to the unit along with the iunit's normal label.
3. Excel 2010 uses the same file format as Excel 2007. So the Excel 2010 version of the file should work okay in Excel 2007.
4. I have also saved a copy of the spreadsheet in Excel 2003. Go to the same link above. I do not have this version of Excel any more so I cannot test if Excel 2010 converts it to the earlier version okay. The only indication of a problem it shows when saving as this earlier version, is that some of the conditional formatting does not convert directly. But try it out. Remember to enable macros. Let me know if it works okay.
Note that there are grey buttons near the top of every Army Sheet (in cell I2) and also in the Notes sheet (in cell B20) to generate a new Army sheet. If they are missing when you open the file, then I do not think the program you are using is properly compatible with Excel. You can always just copy one of the existing Army worksheets and change the name. Just make sure you blank out the Label worksheet name in cell I1 - otherwise you will overwrite the labels from the original sheet.
Cheers,
John Shaw
Have just updated the Army List Generator to Version 1.02. Fixes are:
1. Fixed up the points value for Guard units (thanks for finding that, Brett).
2. Added a unit type called "Attachment (after terrain)". This is if you wish to show attachments that are allocated after terrain placement, but before any units are placed. "Attachment (after terrain)" can be found at the very bottom of the "Troop Type" pull-down list. Make sure columns D, E, F, G and H are blank. Then select the attachment you want from the pull-down list in the "Attachment" column. Of course, a separate label will be generated for this entry which will mean that this label has to be added to the unit along with the iunit's normal label.
3. Excel 2010 uses the same file format as Excel 2007. So the Excel 2010 version of the file should work okay in Excel 2007.
4. I have also saved a copy of the spreadsheet in Excel 2003. Go to the same link above. I do not have this version of Excel any more so I cannot test if Excel 2010 converts it to the earlier version okay. The only indication of a problem it shows when saving as this earlier version, is that some of the conditional formatting does not convert directly. But try it out. Remember to enable macros. Let me know if it works okay.
Note that there are grey buttons near the top of every Army Sheet (in cell I2) and also in the Notes sheet (in cell B20) to generate a new Army sheet. If they are missing when you open the file, then I do not think the program you are using is properly compatible with Excel. You can always just copy one of the existing Army worksheets and change the name. Just make sure you blank out the Label worksheet name in cell I1 - otherwise you will overwrite the labels from the original sheet.
Cheers,
John Shaw
Re: Army List and Label Generator - for Download - Version 1
Brilliant John - the 2003 version seems to be fine.