Warband Record sheet excel spreadsheet

[Polkovnik]

I've created a Warband Record sheet for Frostgrave in excel, so I thought I'd share it. It provides a one page document with stats, spells and equipment list for your wizard, apprentice and soldiers.
In its current form it is mainly aimed at starting warbands, and does not account for the Wizards level, but this could be easily adjusted. Once we start playing a campaign I will alter the spreadsheet to include this.

You can download the spreadsheet here:
https://www.dropbox.com/s/1xe1f8d9h9wxux3/Frostgrave%20Warband%20Record%20Sheet.xlsx?dl=0 

[racm32]

Only thing I'd add would be a 'Blank' option under the working tab in case you are not using 8 members. Also Current health runs out of its cell across the next 2. Other then those two I really like it and have saved a copy for my use.

[Curadh]

Nice job with the spreadsheet- your Vlookup tables are nicely done- and the print output is right on the money!  I saved it and will be using it soon

[JohnDSD2]

Great work!

Can't wait for the expanded version for experienced Warbands (hint)
Two extra soldier slots (for the Inn and the Kennel) and somewhere to put your new spells would do it I think.

Once again top stuff

[Polkovnik]

Also Current health runs out of its cell across the next 2.

I'm not sure what you mean by this.

[Polkovnik]

I've added two extra soldier slots, although these won't print on one page with the rest unless you change the print range. I've added a blank option on the drop-down box for soldiers, and I've added sections for Wizard level, experience and vault. I've added another line to record spells, but if you need more you can just insert extra rows in the spells section.

[Westfalia Chris]

Interesting approach. Have you considered making the dropdown lists specific to the spell schools?

[racm32]

I'm not sure what you mean by this.

On the copy I downloaded the words current health did not stay in their cell but extended over top the 2 to the right

[Cymril]

Thank you for posting this helpful tool!

[Polkovnik]

Interesting approach. Have you considered making the dropdown lists specific to the spell schools?

I didn't think it was possible to have conditional drop-downs, so I googled it and found that you can do this, so I have updated it so that now the drop-downs only show the spells available for each school.