Warhammer 40k Data Sheets

Posted on September 12, 2017 By

I wrote last week about my renewed fascination with Warhammer 40,000. This week, I thought I’d follow up on that with a look at a side project I’ve picked up related to that topic.

In looking at the stats found in the data sheets in Index: Xenos 2, I found that I wanted the ability to customize the data sheet to reflect only the wargear that the unit actually had for that battle. To that end, I opened up a spreadsheet and hammered out a pair of quick templates–one for large monsters with stats that degrade with damage, and one for regular units. These looked pretty good, and printed in landscape mode with 2 pages per sheet they scaled nicely. With that done I began cloning and populating the templates with Tyranid units.

Tervigon Datasheet for Warhammer 40k

Tervigon Datasheet for Warhammer 40k


Termagants datasheet for Warhammer 40k

Termagants Datasheet for Warhammer 40k.

When I was about done with the Heavy Support section I decided that, since I know just enough about spreadsheets to get myself in trouble, I could do more. I revised my template to accommodate some cells devoted to calculating the points value of the unit in question. Because I am a geek who enjoys writing code, and because project creep is always a danger for me, this snowballed into the creation of a pair of templates that will automatically populate themselves with all the relevant data for a given unit type, will calculate the points costs of all the wargear for that unit, and will be easy to convert for the use of any other army in the game.

Hive Tyrant datasheet for Warhammer 40k.

Hive Tyrant Datasheet for Warhammer 40k.

Here is an example of what it looks like for a Tyranid Hive Tyrant. I’m not quite done with the implementation for it (I still have to automate the other template, and there are a couple of things I want it to do that I haven’t figured out how to implement yet), but in general I think it’s turning out quite nice. I think I’ll post a link to a publicly accessible version of it when I’m done.

Games     , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *