Army List Calculator

Blathergut · Post by **Blathergut** » Sun Nov 28, 2010 4:14 am

Musket* seems to cost 6pts the same as musket. Should it not be 5 pts?

deadtorius · Post by **deadtorius** » Sun Nov 28, 2010 11:20 pm

Musket* is costing the same points as a regular musket in the spread sheet. It should cost one point less, 10 points for superior, 7 points for average 5 points for poor.

MixusMaximus · Post by **MixusMaximus** » Thu Dec 02, 2010 6:42 pm

Thank you guys, after I swapped musket* and musket in the list it should work!

MixusMaximus · Post by **MixusMaximus** » Tue Jan 18, 2011 5:55 am

Feeling to be "non-sticky" a little discriminating, I thought I should give my little tool a push in the index!

SirGarnet · Post by **SirGarnet** » Thu Feb 03, 2011 9:12 am

There are some protections which make it hard to format, but I've posted an example list with the minor changes I like in the Yahoo group. http://games.groups.yahoo.com/group/FOG_R/files/ Note the doctrine/tactical box includes the Commanded Out list as well as a first draft doctrine for further development, as is the order of march which will need to be resorted once changes are made. Does the coding support a resort of the actual BG lines by order of march?

MixusMaximus · Post by **MixusMaximus** » Thu Feb 03, 2011 8:36 pm

Hello Mike,

I am not on the yahoo group, so I can't see the file. As Ia m not a native English speaker, don't quite understand the changes you would like!

If it helps the file is not pw-protected, you can simply unlock the sheet.

SirGarnet · Post by **SirGarnet** » Fri Feb 04, 2011 6:02 am

If you don't have an interest in the group, please send me a private message with an email address and I'll email you the file and more of an explanation. The main concepts are a clear printout, having the points total visible on screen when working (even zoomed in), and having the tournament info up top easily hidden when not needed to leave more of the page open for practical purposes.

MixusMaximus · Post by **MixusMaximus** » Fri Feb 04, 2011 3:24 pm

Hello Mike,

I joined the group and had a look on your mod. It's good to see that you configured it the way it's most useful for you. That's the reason why there is no password-protection.
As I said before, I designed it for my needs and still prefer the "original". But if you like to develop it further, go ahead! just a tip: all the real calculating is done on the hidden sheet "Basis1", which is
also unprotected an can be altered to your needs.

bkehrman · Post by **bkehrman** » Fri Jun 03, 2011 4:11 am

Brand new and sorry to be a hack...

I was using the sheet to see what the minimums point out to in Wars of Religion. Our club is considering an escalation league and we wanted to see where our first level should be.

I noticed that on a fairly regular basis, foot units with musket and salvo come up a point short per base in the spreadsheet vs the book. Pike is fine as is shooting horse (karbinryttare for example)

By way of example, in the Early TYW Swedish, the Medium foot in a Veteran "color regiment" (Unarmored / Superior / Salvo / Salvo / -) is 10 points on the spreadsheet, but 11 points in the book. Superior commanded shot also comes up a point short. This applies across several armies: Germans, New Model Army, ECW Royalists and Parliamentarians, etc.

From the looks of the generic format on page 190 of the rule book, your numbers seem right (7 points for superior unarmored foot + 3 points for musket / salvo = 10 points).

What brings about this extra point, then?

I am assuming it is something I'M doing wrong, though I can't figure out what.

marty · Post by **marty** » Fri Jun 03, 2011 5:22 am

It costs a point for musket to be in the same unit as pike. I suspect you havent numbered the shot and Pike as the same unit (one of the left hand columns) so the sreadsheet knows to charge you this point.

Martin

bkehrman · Post by **bkehrman** » Fri Jun 03, 2011 5:43 am

Ah, yes, thank you, column K. And commanded shot is in column J. Everything lines up.

Sorry, to noob all over.