Army List Generator

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

Moderators: terrys, 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 »

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 »

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 »

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 »

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 »

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

Cheers
deadtorius
General - Carrier
General - Carrier
Posts: 4960
Joined: Mon Oct 20, 2008 12:41 am

Post by deadtorius »

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 »

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: 5875
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Post by Blathergut »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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: 10287
Joined: Tue Aug 22, 2006 9:30 am
Location: LarryWorld

Post by nikgaukroger »

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: 28014
Joined: Sun Dec 04, 2005 6:25 pm

Post by rbodleyscott »

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: 28014
Joined: Sun Dec 04, 2005 6:25 pm

Post by rbodleyscott »

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 »

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”