40k army roster template

Only issue is the check boxes dont appear for me, instead I just have "True" or "False" and I can only edit the text. This has only been tested on android mobile at this stage.

Never mind, self-resolved! I was selecting "Save As" rather than "Make a copy" and saving it as a excel spreadsheet rather than a google sheet. Self-resolved technical errors are my favourite technical errors :D Enjoy! I just want to say my whole crew now uses this and we have an amazing crusade business going! Thank you so much! Post a Comment. Automated 40K Crusade Roster. By Charlie September 06, I honestly started this quixotic endeavour with the intention of making a simple spreadsheet to track my Crusade tallies.

I'd never written an IF function in a spreadsheet before. I didn't even know IF functions were a thing in Google Sheets. Neither had I considered making something that could be used to make army lists in seconds via some tick boxes.

Today's post is intended as a useful resource for anyone using the Crusade Rules in 9th edition 40K, but honestly, I think it's pretty useful for anyone who regularly changes their list between games. It's a digital version of the army roster for Warhammer 40, Crusade. It has been designed to suit tracking your Crusade force on your mobile phone using Google Sheets, so the sheets are formatted to be easily navigable on a small screen rather than a PC.

Because it's a Google Sheet, you can update it on either your computer or your phone, and any changes you make will update across those platforms. There is a sheet called 'Order of Battle' that has various automated cells that calculate things like points, supply usage, crusade points, and so on.

There are then sheets for each unit to store information like their experience, abilities, combat tallies, relics, and so on. When you have entered the details for your individual units, you can use the tick boxes on the Order of Battle sheet to quickly tot up the value of the force you want to use for the next game. The sheet displays both Power Level and Points, so you can use whichever you prefer. It doesn't matter either way - it's just as quick to add up either one.

Because I'm unaware of any resource that does this in a phone-friendly manner. Arguably it would be better as an app, but at least with Google Sheets this means you can change it to your liking. Once I'd gotten things like the tick boxes working, it seemed silly to have put all that effort in and then not make it available for other people.

I couldn't have made this without the assistance of Tom occasional Bunker contributor and actual programmer. He pointed me in the direction of the formulas I needed to make this work, and badgered me about keeping the formulas consistent and tidy.

Regular Bunker author Andy also made some good suggestions for further refinements, and even embarked on a crazed quest to code some scripts that would automate even more stuff, but ultimately they proved too crunchy for poor ol' Google Sheets.

Thanks also to the other Bunker dwellers, as well as the Independent Characters podcast community who provided excellent feedback. First thing's first: click this link to go to the sheet , or click either of the images below.

It's probably best to do this, and the other initial setup, on a PC rather than your phone. That way it'll be much easier to change the colours, fonts and pretty much anything else you want to change.

Enter the appropriate information on the sheet for each unit. When you enter a number in a unit's Points, Power Level or Crusade Points, this will automatically update in the Order of Battle sheet. It might also be worth deleting any lines you don't need - most units don't have psychic powers, for example!

If you want to change the name of the tabs from Unit 1, 2, 3 etc, go ahead. Google Sheets is less buggy if you rename the unit sheet first, then update the name in the Order of Battle sheet. If you get the above steps and get a REF error in the formulae, delete the sheet name on the Order of Battle.

Then, enter the sheet name again - that should force a refresh and clear the problem. If you delete any unit sheets, you'll want to delete its name from the Order of Battle sheet. Likewise if you need to add sheets for new units, you'll need to enter the new sheet name in the Order of Battle. The easiest way to add a new unit is to right click on a unit card and duplicate it. If you end up having more than 20 units, add some rows to the bottom of the Order of Battle sheet, merge whatever cells you need to merge, then extrapolate the formulae down.

It's also worth noting that if you want to de-clutter your Order of Battle, you can just delete the unit name and that line will go blank.

One of the gamers in our group, Harvey, suggested it would be cool if there was space to add an image of each unit on its card.

Obviously this will bloat your filsize, which is something to consider when accessing it with mobile data, but I've added an empty cell at the top of each tab. There are instructions in that box on how to add an image. Since I'm a rampant obsessive, I have created a simple Photoshop file that's x pixels.

Obviously you'll need to adjust the row height in the sheet when you first add the image; I didn't want to put a massive empty box on everyone's sheet just because some people might want to add images.

Here are some examples:. If you want said template, go here. Of course you could also chuck in an army symbol or whatever else on your Order of Battle, as I've done here for my Cobalt Scions. Hopefully this is of use; obviously you'll still need to manually enter all your units' points and power levels in their unit cards, and update those whenever GW put out any changes, but after that initial setup I hope you'll find this easier than the many clicks needed to create a list in Battlescribe.

I've chosen not to try and get this spreadsheet to contain all your units' rules and stats - this is just a Crusade Roster. Personally I find Battlescribe's output a bit visually bloaty, and the 40K app isn't yet ready to be an in-game thing, so I've made my own summary sheet for my Space Marines.

I'll put that out in a future post after the new Codex drops. Edit: click here for my Space Marine summary sheet, plus other tips for streamlining the 9th edition in-game experience. If this roster is beneficial, or something didn't make sense, or if there are changes you'd like to suggest, leave a comment on this post and let me know!

The unit cards were updated to automatically display the unit's rank based on their total XP. Several new features this time, several of which were suggested by extremely helpful reader Jonathan jjarcher89 on Instagram. He suggested some changes to the unit card tallies section and the addition of a requisition log. The requisition log was a great idea, so that was a no brainer. It's just so much easier being able to track where your requisition points went, and much easier to figure out if you screwed up.

I simplified Jonathan's design somewhat, as I realised this was also a good place to store a minimalist campaign diary With the unit tallies, I had faithfully reproduced GW's original design but it turns out this omits things the rules explicitly tell you to track, such as the number of times a unit is marked for greatness. It has a fine balance of room for unit entries yet not long enough to be a pain to look through. Nicely done! Dakka 5. Member List. Recent Topics. Top Rated Topics. Forum Tools Forum Tools Search.

New 40K Army Roster Sheet. Forum Index » 40K General Discussion. Subject: Advert. Very cool. I'll wind up playing with this all day at work Dude, this is great. Bumping this thread for awesomeness. This is where you put your tanks, missile launchers and giant ramshackle scrap-metal energy cannons. The one with all the fast-movers. Hulking gun-strapped motorcycles, floating jetbikes, green dudes with incredibly unstable-looking jetpacks, shoals of bat-winged alien monstrosities — they all live here.

There are no unifying traits across these, as they each serve a very specific purpose. Compact combat: Read our 40K Combat Patrol guide. This was also in 8th edition, but the rules have been fixed to prevent exploitation. Fortifications have had their ups and downs through successive editions of 40k, but have never really played a starring role in the game — whether it be the Star Wars-y floating, shielded platforms of the Tau or the suitably ridiculous, vehicle-repairing Mekboy Workshop that the Orks sometimes bring to battle.

Worth avoiding unless absolutely necessary. Don't be afraid to join the fray! Be part of the conversation by heading over to our Facebook page, Discord , or forum.

To stay informed on all the latest wargaming and tabletop games guides, news, and reviews, follow Wargamer on Twitter and Steam News Hub. We sometimes include relevant affiliate links in articles, from which we earn a small commission.