Page 1 of 1

Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:36 am
by titanu
Where can I get an army list spreadsheet?

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:42 am
by kevinj
From the Downloads page on the Burton site:

http://www.badwargamers.org.uk/

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:46 am
by titanu
kevinj wrote:From the Downloads page on the Burton site:

http://www.badwargamers.org.uk/
How do you enter Commanded shot or are they just MF?

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:47 am
by rbodleyscott
titanu wrote:
kevinj wrote:From the Downloads page on the Burton site:

http://www.badwargamers.org.uk/
How do you enter Commanded shot or are they just MF?
They are MF and then you put commanded shot in the BG Type column.

You joining the band of the righteous Bob? Best check out the errata before you get too excited about commanded shot.

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:52 am
by titanu
rbodleyscott wrote:
titanu wrote:
kevinj wrote:From the Downloads page on the Burton site:

http://www.badwargamers.org.uk/
How do you enter Commanded shot or are they just MF?
They are MF and then you put commanded shot in the BG Type column.

You joining the band of the righteous Bob? Best check out the errata before you get too excited about commanded shot.
That was my query in the type drop down box 'Commanded shot' do not appear only 'MF'.

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 10:53 am
by titanu
rbodleyscott wrote:You joining the band of the righteous Bob? Best check out the errata before you get too excited about commanded shot.
Most certainly I was a George Gush player for years and I like the period.

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 11:02 am
by kevinj
That was my query in the type drop down box 'Commanded shot' do not appear only 'MF'.
There is a Type column where you select the MF/HF etc. There is also a BG Type column just to the left of the Points per Base. This allows you to select other stuff like Commanded Shot. Realistically, the only ones you need to populate there are Commanded Shot and Swedish Brigade because they have a points cost, the others are more for information.

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 12:09 pm
by titanu
kevinj wrote:
That was my query in the type drop down box 'Commanded shot' do not appear only 'MF'.
There is a Type column where you select the MF/HF etc. There is also a BG Type column just to the left of the Points per Base. This allows you to select other stuff like Commanded Shot. Realistically, the only ones you need to populate there are Commanded Shot and Swedish Brigade because they have a points cost, the others are more for information.
Kevin

That's great - thanks.

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 12:13 pm
by kevinj
No Problem. It will be good to see you back in the world of Renaissance. :)

Re: Army List Spreadsheet

Posted: Thu Apr 11, 2013 2:21 pm
by quackstheking
Hi Bob,

Welcome back!

I look forward to renewing our rivalry from the Gush era!! :D

Don

Re: Army List Spreadsheet

Posted: Fri Apr 12, 2013 6:16 am
by titanu
Image

I am trying to create a TYW German Catholic list and I cannot get the superior musketers to by 11 points as per list only 10 points - see above.

Whay am I doind wrong?

Re: Army List Spreadsheet

Posted: Fri Apr 12, 2013 6:30 am
by kevinj
Give the 3 parts of the BG the same BG#. Also, a 2+4 pike and shot BG is not a Late Tercio. It doesn't make any difference on the spreadsheet but is relevant when you play.

Re: Army List Spreadsheet

Posted: Fri Apr 12, 2013 6:52 am
by titanu
kevinj wrote:Give the 3 parts of the BG the same BG#. Also, a 2+4 pike and shot BG is not a Late Tercio. It doesn't make any difference on the spreadsheet but is relevant when you play.
Kevin you're a genius!

Re: Army List Spreadsheet

Posted: Fri Apr 12, 2013 7:11 am
by kevinj
No, I've just been through all of these things myself! Incidentally, I've just started trying this one:

http://www.littlearmybuilder.com/lang/en/

It doesn't do Copy and Paste but the way it handles the multi-part BGs is good.

Re: Army List Spreadsheet

Posted: Mon Apr 15, 2013 9:49 am
by Three
kevinj wrote:No, I've just been through all of these things myself! Incidentally, I've just started trying this one:

http://www.littlearmybuilder.com/lang/en/

It doesn't do Copy and Paste but the way it handles the multi-part BGs is good.
Thanks for the hint on the Little Army Builder, I've been giving it a whirl and I rather like it, especially when you print, the text size is better for my eyesight. I can copy and paste without any problem. I rather like that it remembers what you have previously typed and saved, and fills in for you when you use the same Unit name.

There are some minor issues I've stumbled across so far though - funnily enough all to do with the Japanese list - Samurai with Teppo autofills as unarmoured and won't allow the armoured version and Ashigaru with Yumi autofills as Bow* but the points are correct.

Re: Army List Spreadsheet

Posted: Mon Apr 15, 2013 10:01 am
by kevinj
Yes, there's a general issue with Warriors and missile weapons but I've reported it. Alain who creates the tool is very responsive. Some of the defaults are not particularly intitive, but if you create one instance of each BG type and then save the autofill is excellent.