Page 1 of 4

Army List Generator

Posted: Fri Nov 12, 2010 9:04 pm
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.

Posted: Fri Nov 12, 2010 10:10 pm
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.

Posted: Sat Nov 13, 2010 9:01 pm
by shangtuming
oops. :oops:

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

I will sort it.

Army list generator

Posted: Sat Nov 13, 2010 10:57 pm
by shangtuming
Bug fixed see v2.2 sorry :cry:

Posted: Sun Nov 14, 2010 8:42 am
by shangtuming
Problem with the uploaded version last night but correct version now on website: http://www.badwargamers.org.uk

Cheers

Posted: Sun Nov 14, 2010 11:04 pm
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.

Posted: Mon Nov 15, 2010 12:41 pm
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?

Posted: Mon Nov 15, 2010 2:19 pm
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?).

Posted: Mon Nov 15, 2010 7:53 pm
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.

Posted: Mon Nov 15, 2010 10:09 pm
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. :)

Posted: Fri Dec 31, 2010 8:36 am
by bertalucci
Shangtuming

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

Bert

Posted: Fri Dec 31, 2010 11:16 am
by shangtuming
Thanks Bert

I am happy that people find it useful. :D

Posted: Sat Jan 01, 2011 7:49 am
by bertalucci
And thanks to the moderators for making this a sticky.

Wow

Posted: Sat Jan 01, 2011 5:51 pm
by shangtuming
I too would like to thank them for givng me the honour.
Many Thanks

Posted: Fri Jan 14, 2011 8:07 pm
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

Posted: Wed Jan 19, 2011 7:53 pm
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!

Posted: Thu Jan 20, 2011 1:37 pm
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)

Posted: Thu Jan 20, 2011 5:23 pm
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.

Posted: Mon Jan 24, 2011 11:17 pm
by rbodleyscott
I cannot find Mob in the list of troop-types.

Posted: Wed Jan 26, 2011 7:49 pm
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