Welcome my friends to the show that never ends!
Today we display for delectation and delight a device that shall take all the stress, woe and arithmetic from your cogitations.
This simple marvel shall allow you to not only calculate the cost of a figure with a few strokes of your cursor, but also the cost for the company entire!
Obtain this fiendish engine from the tent marked Bonus Material and open it. Within you shall find, in a tabular arrangement…
Oh tosh, shall we talk English?
Righty-ho, this spreadsheet is the sole reason that Charles and I have not had to issue more errata regarding points costs. Created by our friend Kate Winson it does indeed calculate the cost of individual figures and the whole company.
So let’s get down to business.
The Multiple column is where you write how many of this figure type you want in your company. Usually I do not complete this until I am calculating a company list for an evening’s play.
The next column is where you input the figure type.
The Cost column is where the final cost of your figure is displayed.
The next few columns all have drop down lists (click the top right corner of the cell) in them from which you select the desired value for say Pluck or FV, or the Equipment, Talents and Powers you want the figure to have. You will note that all the equipment, talents and powers from the three books is in these lists, so you may have to scroll down a bit to get what you want.
Figures have multiple rows for such things as equipment, talents and powers. This is so they can have more than one. The first two figures have more than the rest as these are the leaders or special characters who often have more stuff.
Grenades have their own column so you can choose from a number of variants and quantities.
The Additional Equipment column is where all the weird science, personal transportation and even walkers are.
The Misc other column allows you put in the cost of any custom kit you have created yourself, so that cost can be added into the total.
Kate has also included a second worksheet with two tables in for you to calculate the costs of any custom weapons and armour you might create.
We have used versions of this device to calculate all the costs for HVF, SDRS, Gothic and the various blog companies and it has proved both robust and accurate.
We suggest that you open a new sheet for each company you create and save it to that company’s name. Then when you want to create a company from that list to an agreed points limit just put in the number of each figure type in the multiple column and bob’s your uncle!
On a personal note we would both like to thank Kate and acknowledge the important part she has played in producing accurate books for you all.