Army List Generator

General discussion forum for anything related to Field of Glory Renaissance Wars.

Moderators: hammy, Slitherine Core, FOGR Design

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Army List Generator

Post by shangtuming » Fri Nov 12, 2010 9:04 pm

Hi All

Having slaved away at my PC I have come up with a FoG Rennaisance army list generator which should help with some of the maths

Just follow the link to the badwargamers website http://www.badwargamers.org.uk and then go the Downloads page.

I have done most of the testing but as all the list are not yet published I am not sure if I have covered all the eventualities.

I am releasing this so you can all have a go at breaking it. I would truely appreciate your feedback on this.

Regards
Paul

Sorry if this appears twice.

Scrumpy
Colonel - Fallschirmjäger
Colonel - Fallschirmjäger
Posts: 1423
Joined: Sat Nov 10, 2007 7:27 pm
Location: NoVa

Post by Scrumpy » Fri Nov 12, 2010 10:10 pm

Thanks for posting the link, when I tried it though, it claimed that Cuirassier horse heavy armour superior -- pistol pistol are worth 14.5 points each and their armoured counterpart only 11.5 points each.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Sat Nov 13, 2010 9:01 pm

oops. :oops:

Last minute fix to cover an obscure weapon combo seems to have backfired.

I will sort it.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Army list generator

Post by shangtuming » Sat Nov 13, 2010 10:57 pm

Bug fixed see v2.2 sorry :cry:

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Sun Nov 14, 2010 8:42 am

Problem with the uploaded version last night but correct version now on website: http://www.badwargamers.org.uk

Cheers

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

Post by deadtorius » Sun Nov 14, 2010 11:04 pm

One thing I miss from the other sheets is the 25% and auto break in the far right column, comes in very handy to have it at hand just in case.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Mon Nov 15, 2010 12:41 pm

Thanks for the feedback

I will include this on a later version.

I need to make sure the points system is bug free before adding too many additional features so if anyone finds a problem please let me know.

Also how useful do people think it would be to have a second sheet mirrored from the main list that can be used as a Detached Shot alternative list, or are we happy to copy and paste?

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

Post by Blathergut » Mon Nov 15, 2010 2:19 pm

I couldn't see how to add in the pts for muskets in BG with pike (or is this just the commanded shot option combined into one?).

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Mon Nov 15, 2010 7:53 pm

It does this automatically.

All you have to do is give the Pike and Shot the same number in the BG# column.

It should also do a similar thing for Bayonets without Pike.

This is valid for up to 4 rows forming a single BG. - Apparently they can happen.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Mon Nov 15, 2010 10:09 pm

V2.4 Now ready for download - Portable defences and regimental guns can now be assigned to BG without affecting BG size. http://www.badwargamers.org.uk then go to downloads. :)

bertalucci
Administrative Corporal - SdKfz 232 8Rad
Administrative Corporal - SdKfz 232 8Rad
Posts: 171
Joined: Sat Jan 19, 2008 9:43 am

Post by bertalucci » Fri Dec 31, 2010 8:36 am

Shangtuming

Just a brief note to say thanks for the work and keep this posting near the top of the table

Bert

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Fri Dec 31, 2010 11:16 am

Thanks Bert

I am happy that people find it useful. :D

bertalucci
Administrative Corporal - SdKfz 232 8Rad
Administrative Corporal - SdKfz 232 8Rad
Posts: 171
Joined: Sat Jan 19, 2008 9:43 am

Post by bertalucci » Sat Jan 01, 2011 7:49 am

And thanks to the moderators for making this a sticky.

Wow

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Sat Jan 01, 2011 5:51 pm

I too would like to thank them for givng me the honour.
Many Thanks

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Fri Jan 14, 2011 8:07 pm

Version 2.6 now uploaded. I have now altered the deployment cell to properly reflect Grand Battle groups.
i.e. it counts BG equivalence.

Plus Some minor formatting improvements.

Pleas check it out.
Paul

footslogger
Sergeant First Class - Elite Panzer IIIL
Sergeant First Class - Elite Panzer IIIL
Posts: 412
Joined: Fri Aug 29, 2008 5:50 pm

Post by footslogger » Wed Jan 19, 2011 7:53 pm

I tried it and it's great.

A couple of suggestions: I tried to copy and paste a BG and it wouldn't allow me to paste because it said the cells were protected. But I could type into the same cells. I can't explain this. But copy and paste is handy if you have a few battle groups that are 4 MF, musket, 2 HF pike, and a battalion gun.

I like to leave a blank line between BGs, but there isn't enough space to do that, so more writable lines would be good. (I have 6 battle groups like the above, plus 3 bgs that are the same without battalion guns, and a few other groups).

Thanks for putting in the effort to do this!

nikgaukroger
Field of Glory Moderator
Field of Glory Moderator
Posts: 10278
Joined: Tue Aug 22, 2006 9:30 am
Location: LarryWorld

Post by nikgaukroger » Thu Jan 20, 2011 1:37 pm

Firstly, thanks for all the hard work - very useful tool.

But, and there was bound to be one :D , I do find it annoying that I cannot select the portion of the sheet that contains my list and set just that as my print area (at least I can't) and so have to print out a whole load of empty lines.

I'm sure you have a reason, however, it is feedback 8)
Nik Gaukroger

"Never ask a man if he comes from Yorkshire. If he does, he will tell you.
If he does not, why humiliate him?" - Canon Sydney Smith

nikgaukroger@blueyonder.co.uk

rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 22425
Joined: Sun Dec 04, 2005 6:25 pm

Post by rbodleyscott » Thu Jan 20, 2011 5:23 pm

nikgaukroger wrote:Firstly, thanks for all the hard work - very useful tool.

But, and there was bound to be one :D , I do find it annoying that I cannot select the portion of the sheet that contains my list and set just that as my print area (at least I can't) and so have to print out a whole load of empty lines.

I'm sure you have a reason, however, it is feedback 8)
I already fed this back. I must admit I did not really understand the reason why it isn't possible to correct the issue. (You can do it on Olivier's sheet, despite many cells having formulaes etc).

I would say that this has a high priority for correction because small print is bad for ageing wargamers' eyes.

rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 22425
Joined: Sun Dec 04, 2005 6:25 pm

Post by rbodleyscott » Mon Jan 24, 2011 11:17 pm

I cannot find Mob in the list of troop-types.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Wed Jan 26, 2011 7:49 pm

Sorry Missed Mob in initial lists. It has now been added in V2.7
Can you confirm that there will only be Unarmarmoured Mob, or is there an armoured variety!

Richard - Thanks for organising Usk again this year I enjoyed it, as we are all getting older I have enabled the print area selction on the sheet also.

Paul

PS the V2.6 has a bug so bin it and use 2.7

Post Reply

Return to “Field of Glory : Renaissance Wars : General Discussion”