Slitherine

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

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.

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

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

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?

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.

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.

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.

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.

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

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

Sorry, to noob all over.