Army List and Label Generator - Download - Version 1.04

General discussion forum for anything related to Field of Glory Napoleonics.

Moderators: hammy, terrys, Blathergut, Slitherine Core, hammy, Blathergut, terrys, Slitherine Core

thefrenchjester
Lieutenant Colonel - Elite Panther D
Lieutenant Colonel - Elite Panther D
Posts: 1376
Joined: Sun Apr 01, 2007 12:23 pm
Location: the wilderness of mirrors

Re: Army List and Label Generator - for Download - Version 1

Post by thefrenchjester » Sat Apr 14, 2012 4:18 pm

Hi John,

it works very well with excel 2010, just built my French Army 1813 for the battle of Kulm on it, the labels are very cool;

thanks a lot for all the work you've done on it;

Best regards

thefrenchjester

paris
Lance Corporal - Panzer IA
Lance Corporal - Panzer IA
Posts: 18
Joined: Fri Nov 09, 2007 2:25 pm

Re: Army List and Label Generator - for Download - Version 1

Post by paris » Sat Apr 14, 2012 7:02 pm

Superb! A great many thanks and greetings from all of us (Hoplon Patras club - Greece) :D

BrettPT
Lieutenant Colonel - Panther D
Lieutenant Colonel - Panther D
Posts: 1262
Joined: Tue Jan 20, 2009 8:52 am
Location: Auckland, NZ

Re: Army List and Label Generator - for Download - Version 1

Post by BrettPT » Sat Apr 14, 2012 7:32 pm

Chasseur wrote: Fixed up the points value for Guard units (thanks for finding that, Brett).
My pleasure - great little program! I'm just in the process of putting together a French Guard list for my next game, and thought I had a unit too many.

Problem fixed now - however it looks to have caused a follow-on glich with Guard artillery, which are coming up as an additonal 16/24 points for small/large guards rather than an additonal 8/12. ...

Also, if it's an easy thing to do, maybe Poland, Saxony and the Netherlands could also get their own colour and little flag?
Cheers
Brett

Philip
Administrative Corporal - SdKfz 232 8Rad
Administrative Corporal - SdKfz 232 8Rad
Posts: 168
Joined: Wed Jan 21, 2009 6:21 pm
Location: Auckland, New Zealand

Re: Army List and Label Generator - for Download - Version 1

Post by Philip » Sun Apr 15, 2012 12:20 am

Great work with the list generator!

I would find it useful to list not just the ACV, but also the adjusted ACV when defending with a +2 modifier, eg

ACV: 34 ACV +2
10% 3.4 3.6
20% 6.8 7.2
30% 10.2 10.8
40% 13.6 14.4
50% 17 18

cheers,
Philip

KendallB
Sergeant First Class - Elite Panzer IIIL
Sergeant First Class - Elite Panzer IIIL
Posts: 416
Joined: Fri Sep 18, 2009 9:01 pm
Location: North Shore, New Zealand

Re: Army List and Label Generator - for Download - Version 1

Post by KendallB » Sun Apr 15, 2012 1:07 am

Hi John

Great work but could you add Saxony in the drop-down for nations please. My lads are feeling left out. :cry:
Last edited by KendallB on Sun Apr 15, 2012 3:40 am, edited 1 time in total.

deadtorius
General - Elite King Tiger
General - Elite King Tiger
Posts: 4173
Joined: Mon Oct 20, 2008 12:41 am

Re: Army List and Label Generator - for Download - Version 1

Post by deadtorius » Sun Apr 15, 2012 1:25 am

Great work thanks for the second version and thanks to Blathergut I managed to clear all those extra points in those fields. Todays army was very short on what it should have had due to not noticing that 2 generals in blank divisions at 30 points each and accidentally making Grenadiers superior cost me over 60 points of troops I should have had on table....
One thing I had noticed and am still noticing is that the initiative stays at 1 regardless of nation or type of commander you choose. Austrians should have a +1 for nationality and I had chosen and exceptional corps commander but initiative still shows 1.
Thank you for your hard work and effort really makes putting these armies together a lot easier than doing it all manually.

Chasseur
Master Sergeant - U-boat
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

Post by Chasseur » Sun Apr 15, 2012 2:14 am

Hi,
Initiative: Free form. Usually you type in the army initiative which can be found in the FOGN army lists. This value is used in the determination of who will be the attacker and who will be the defender.
As it mentions on the instruction page (but who ever likes reading instructions :D ) the initiative is a free form field. That means you have to fill it in yourself. When the army list books come out there will be lots of different armies from the same country, but their initiative may be different for some years. Hence it is not possible to automate this bit - particularly as the books are not available yet. Certainly looking forward to seeing them.

I will blank this out in the default Army worksheet to save confusion.

Cheers,
John Shaw

Philip
Administrative Corporal - SdKfz 232 8Rad
Administrative Corporal - SdKfz 232 8Rad
Posts: 168
Joined: Wed Jan 21, 2009 6:21 pm
Location: Auckland, New Zealand

Re: Army List and Label Generator - for Download - Version 1

Post by Philip » Sun Apr 15, 2012 3:26 am

Another request for the generator - could we have cavalry which are half lancer and half non-lancer. I don't think there are any in the current lists, but sure to be some in the final lists or in historical scenarios.
Thanks for all your work on this :)

Chasseur
Master Sergeant - U-boat
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

Post by Chasseur » Sun Apr 15, 2012 4:06 am

Hi,

I have just uploaded version 1.03. Link is the same as in the first message in this subject.

Brett, I have corrected the Guard calculations properly this time for all units. Thanks for checking. (So much for trying to do programming quickly after midnight last night).

I have also:
- Added flags for Netherlands, Poland (Duchy of Warsaw flag) and Saxony.
- Blanked out sample Initiative value of 1 in "Blank Army" worksheet to save confusion, as this value needs to be manually entered.
- Changed ACV formula so Fieldworks do not count towards ACV total (I assume this is right Terry? Let me know if it is not).
- Added the ACV values in brackets for when defender gets the +2 ACV if attacker has gained the +40 points for units.

Sorry to keep uploading versions so quickly, but I want to get rid of the errors (and add the useful features you suggest) before too many people have downloaded the file. Thanks to all those that have provided feedback.

Cheers,
John Shaw

BrettPT
Lieutenant Colonel - Panther D
Lieutenant Colonel - Panther D
Posts: 1262
Joined: Tue Jan 20, 2009 8:52 am
Location: Auckland, NZ

Re: Army List and Label Generator - Download - Version 1.03

Post by BrettPT » Sun Apr 15, 2012 8:50 pm

Splendid work John.

Just one little change that would be useful. It appears (I think) that the % ACV cells round up to the next whole number. However because there are 1/2 point ACV losses (spent cavalry) we often have to deal with .5's.

ie 40% losses on the French 1813 list of 33 ACV is 13.2. The program rounds this up to 14, however (assuming that the opponent had taken under 20% losses) this French force would break at 13.5, not 14.

Maybe it would be better to have the % round up to the next 0.5 (rather than whole number), or if this is too tricky, have the % round to 1 decimal place rather than a whole number?

Cheers
Brett

Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.03

Post by Chasseur » Tue Apr 17, 2012 10:42 am

Hi Philip,

I can certainly add for part units, but it would be best to add all possible part units in one go.

Terry and Mike, what part units are going to be needed in the Army List generator?

Cheers,
John Shaw

Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.04

Post by Chasseur » Tue Apr 17, 2012 11:28 am

Hi Brett,

I have created version 1.04 which changes the calculated ACV values to the nearest 0.5 points.
Thanks for "pointing" that out.
As usual it can be loaded from the hyperlink in the first post within this topic (go to top of page 1).

Cheers,
John Shaw

Blathergut
Field Marshal - Elefant
Field Marshal - Elefant
Posts: 5660
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Re: Army List and Label Generator - Download - Version 1.04

Post by Blathergut » Sun Apr 22, 2012 3:09 am

Thanks for the update(s). This should be stickied to the top of the list.

Imeon
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 201
Joined: Sat May 21, 2011 9:34 am
Location: Roma

Re: Army List and Label Generator - Download - Version 1.04

Post by Imeon » Thu Apr 26, 2012 6:42 am

Hi

I try army list with open office, but I don't have a lot of functions.

Is possible that you can make a version for Open Office?

Thanks for your job.


Giorgio
Giorgio Fumo

"....è meglio osare che vivere la vita senza conoscere vittoria o sconfitta..."

Blathergut
Field Marshal - Elefant
Field Marshal - Elefant
Posts: 5660
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Re: Army List and Label Generator - Download - Version 1.04

Post by Blathergut » Sun May 06, 2012 2:46 pm

Bumping this to top. Could some demigod with the power sticky it? 8)

jdm
Slitherine
Slitherine
Posts: 1139
Joined: Mon Apr 04, 2005 10:41 am

Re: Army List and Label Generator - Download - Version 1.04

Post by jdm » Mon May 14, 2012 10:14 pm

John can you send over the upgrade
JDM

Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.04

Post by Chasseur » Mon May 28, 2012 9:30 pm

Hi JDM,

I have been off forum for a couple of weeks, madly rebasing troops and doing terrain for a Waterloo game that was held a Little Wars Melbourne last Sunday. I am working on the part unit selection so will have another version soon. I did send you the latest copy by email (back on April 21st). Currently 1.04 is the latest version, but that will be updated by next week to version 1.05 with selection of mixed Cavalry units.

Cheers,
John Shaw

SirGarnet
Brigadier-General - Elite Grenadier
Brigadier-General - Elite Grenadier
Posts: 2148
Joined: Fri Apr 18, 2008 10:13 am

Re: Army List and Label Generator - Download - Version 1.04

Post by SirGarnet » Thu Jun 07, 2012 2:55 am

Just a thought.

One thing (2003 version, maybe in the 2010 as well) is the preset print format which is portrait rather than landscape. I find setting it to landscape, reducing top and bottom margins, and only including the top 2 lines of notes yields a printout with nicely bigger text and better use of the page, and still accommodating 4 divisions and over 20 units.

Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.04

Post by Chasseur » Sat Jun 16, 2012 1:10 pm

Hi Mike,

Thanks. I'll look at this as default in next version. This will be soon. I am just finishing off easier way to choose part units (e.g. mixed cavalry types).

Cheers,
John Shaw

CutEmUp
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 208
Joined: Fri May 28, 2010 3:50 pm

Re: Army List and Label Generator - Download - Version 1.04

Post by CutEmUp » Sat Jun 16, 2012 10:19 pm

need an update for units which are half lancers

Post Reply

Return to “Field of Glory : Napoleonic Era 1792-1815 : General Discussion”