Army List Spreadsheet

Moderators: terrys, Slitherine Core, FOGR Design

Post Reply
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Army List Spreadsheet

Post by titanu »

Where can I get an army list spreadsheet?
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post by kevinj »

From the Downloads page on the Burton site:

http://www.badwargamers.org.uk/
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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?
rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 28423
Joined: Sun Dec 04, 2005 6:25 pm

Re: Army List Spreadsheet

Post 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.
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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'.
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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.
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post 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.
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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.
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post by kevinj »

No Problem. It will be good to see you back in the world of Renaissance. :)
quackstheking
1st Lieutenant - 15 cm sFH 18
1st Lieutenant - 15 cm sFH 18
Posts: 844
Joined: Tue Jul 20, 2010 2:41 pm
Location: Hertfordshire, England

Re: Army List Spreadsheet

Post by quackstheking »

Hi Bob,

Welcome back!

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

Don
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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?
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post 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.
titanu
Major - Jagdpanther
Major - Jagdpanther
Posts: 1089
Joined: Wed Nov 01, 2006 7:26 am

Re: Army List Spreadsheet

Post 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!
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post 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.
Three
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 216
Joined: Fri Apr 25, 2008 7:30 pm

Re: Army List Spreadsheet

Post 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.
kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Re: Army List Spreadsheet

Post 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.
Post Reply

Return to “Army Design”