Forum adverts like this one are shown to any user who is not logged in. Join us by filling out a tiny 3 field form and you will get your own, free, dakka user account which gives a good range of benefits to you: No adverts like this in the forums anymore. Times and dates in your local timezone. Full tracking of what you have read so you can skip to your first unread post, easily see what has changed since you last logged in, and easily see what is new at a glance. Email notifications for threads you want to watch closely. Being a part of the oldest wargaming community on the net. If you are already a member then feel free to login now.

So I found this thread that had the sheet formatted for SM 5th ed. But I'm going to be playing space wolves and I'm curious if there's a similar one for SW or if someone could explain how to edit. I have experience programming from school (CompSci Major) so VB should be easy enough to edit if I need to.

It's just editing a spreadsheet. No programming of any kind required.

You add stuff by typing and delete stuff with the delete key.

What editing does it need to make it work for space wolves? (it should work for pretty much everything except IG - since they can buy lots of units for a single troop choice it breaks down)

Whoops, guess I didn't read it. I thought someone programmed the stats for units into it. You know with drop-down menus and such. I've seen my dad make them before when doing taxes for clients and work.

Its really nifty. I am glad someone necroed that thread.

Anyways, one with pull down menus and such would be awesome to have, but the way it is now is awesome.

Portaljacker wrote:Whoops, guess I didn't read it. I thought someone programmed the stats for units into it. You know with drop-down menus and such. I've seen my dad make them before when doing taxes for clients and work.

If it had unit names and points values then distributing it would be of extremely dubious legality.

Use Army Builder.

Scott-S6 wrote:If it had unit names and points values then distributing it would be of extremely dubious legality.

True. But there is nothing stopping someone from putting the functionality in it to basically have an 'Input' sheet you fill out yourself with the stats. The other builder sheets could draw their lists from that input sheet. I.e. you type out the units and stats into a tab, and those appear as drop downs in other sections. Basically it is all about creating Range Names (For the lists) and Validations (For the drop downs in cells).

That is the easy part. If you want to get more complicated you can do Macros. But for something simple like this that would be overkill. A good Dark Heresy character generator however would probably need some Macros. The sky is the limit if you know what you are doing.

Quick crash course if you do want to put lists in there (Which would at least save you having to type out a unit name each time);
Select the cells you want to have drop down lists in. You want data validations. In Excel 07 and 10 shortcut is Alt-A-V-V (Can't remember older versions, check in the 'Data' menu or similar). Change the 'Allow' to list. Then click the funky little button in the 'Source' part. This is prompting you to select the area that has the list you want to utilise. Select the cells for said list (must be a single column or row, i.e. can't be something like A1 to B5, but A1 to A5 or A1 to B1 is fine). Now those cells have a drop down list when you click on them.

If you want to still be able to type over it (with something that doesn't appear in the list) then once you have the data validation menu open, go to the Error Alerts tab and uncheck the box saying to display an error when invalid data is entered.

Hopefully this has been of some use to someone.