Sign in to follow this  
Followers 0
unnownrelic

Warhammer 40kRP Armory

56 posts in this topic

Greetings, denizens of Fantasy Flight Games' forums! Have you ever wanted a handy place to look at equipment? A quick reference for that particular special weapon ability does? A side-by-side comparison of the various hulls of Rogue Trader? One place where you can look at the equipment for a Space Marine and an Acolyte without having to crack open two different books? Look no further than this handy quick reference guide! All included in an easy to use Excel sheet, this covers all four of FFG's 40kRP games: Dark Heresy, Rogue Trader, Deathwatch, and now Black Crusade. It includes nearly every piece of player gear, their upgrades, their qualities, most vehicles, all the starships, and more! I've been posting this to another forum for quite some time now, and didn't even realize that FFG had their own forums, so I come now to you good sirs and ladies and present it, free for use for all!

There are two versions, different only in file extension, and both can be found below.

www.tiny.cc/40kRP_Armory

 

If for some reason clicking on the link doesn't work, feel free to just copy and paste it into your URL bar.

 

If, for some reason, this violates any copyrights, laws, or otherwise, I am more than willing to remove all traces of this from my files should Fantasy Flight Games request it, as well as delete this thread. No harm is intended. Also, I've posted this thread in the other three forums, as it pertains to their systems as well. Good luck, and happy dice rolling!

 

Last Updated: January 21, 2012

Current Version: 4.14.0121

Share this post


Link to post
Share on other sites

Enjoy good sir! I'll be updating it sometime next week or so when Daemon Hunters comes out, as well as whenever the Rogue Trader errata is released for Battlefleet Koronus.

Share this post


Link to post
Share on other sites

Hello again! I've recently updated the armory. Though it doesn't especially pertain to Dark Heresy, the newest Deathwatch errata was released a few days ago, and I finally got time to fix up a few things. So, here it is!

The .xls version for users of Office 97-2003

http://www.mediafire.com/?c2m54iwxjcsmqih

And the .xlsx for users with 2007 or newer

http://www.mediafire.com/?7t710bq1q8csaci

I'll update the first post as well with these new links. Enjoy!

Also, on a slightly related note, if there's anyone with database experience who'd like to help turn this into a functioning and easy-to-use database that can be sorted on the fly and all that, PM me. Thanks!

Share this post


Link to post
Share on other sites

Hate to double post, but I just got bored and had to add the optional stuff to its own sheet. First post has been updated with the new versions!
 

Share this post


Link to post
Share on other sites

Spectacular! Thanks for the hard work and excellent guide, no more flipping through 4 .PDFs while I try to arm my Acolytes.

Just as a note, when using Excel Starter 2010 (comes standard on most HP notebooks sold from Jan 2010 to ~March 2011) you need to enable editting before you can access the frozen panes, which include all of the weaponry.

Share this post


Link to post
Share on other sites

BangBangTequila said:

Spectacular! Thanks for the hard work and excellent guide, no more flipping through 4 .PDFs while I try to arm my Acolytes.

Just as a note, when using Excel Starter 2010 (comes standard on most HP notebooks sold from Jan 2010 to ~March 2011) you need to enable editting before you can access the frozen panes, which include all of the weaponry.

 

Oh really? Well that's problematic. I'll see if I can fix that. In fact, I didn't even know the panes were frozen or protected or anything like that. Thanks for the heads up!

Share this post


Link to post
Share on other sites

I'm gonna add my thanks here, too. Excellent to have all the stuff available in a single document (FFG should add this to their website). I'm going to recommend this to my group. :)

Share this post


Link to post
Share on other sites

This must have taken a very long time.  Please take some pleasure in knowing that it will be well used and totally appreciated. 

BZ

Share this post


Link to post
Share on other sites

Thanks, as always! Enjoy it, and keep an eye on the thread for future updates as FFG releases new books. I may be slightly behind occasionally due to the expense of all them, but they'll get in one way or another!

 

In regards to the frozen panes business, would any of you prefer them to simply not be collapsed as they are? It would vastly increase the scrolling space unfortunately, but it would circumvent any problems without a more complicated fix. Let me know, I'll be working on the fix anyway just in case.

 

@BangBangTequila:

 

What sheets had this problem? All of the ones with collapsed sections? Or just the vehicles sheet with the collapsed header?

Share this post


Link to post
Share on other sites

What happened, and my reactions step by step:

1: Downloaded the up to date .xls file.

2: Opened file, clicked the various tabs with increasing frequency and frustration, no expansion anywhere.

3: Deleted with extreme prejudice and mutter profanity.

4: Rinse and repeat with louder profanity and the 97-2003 version.

5: Re-downloaded the 2007+, mucked about for about 5 minutes until I saw the little yellow-ish bar at the top that says I have to enable editing.

6: Clicked the little "Enable" button, opened the expandable tabs.

7: Tactical facepalm.

As you can see, it was my inexperience with Excel and lack of observation that made it an issue, anyone with a similar problem need only look to the top of their screen to enable the editting. As an opinion, I'd say don't bother doing anything, unless you with to release a non-tabbed version, which I would probably also like to have simply for a single, large table, as per the Inquisitor's Handbook, but the 'fix' is a single click on a button that automatically pops up when the file is opened.

Share this post


Link to post
Share on other sites

unnownrelic said:

In regards to the frozen panes business, would any of you prefer them to simply not be collapsed as they are? It would vastly increase the scrolling space unfortunately, but it would circumvent any problems without a more complicated fix.
Hard to say. In my case, there's nothing frozen, but for some reason I find myself occasionally expanding the wrong table as the [+] icons don't seem to be displayed in the same row but always a bit lower - so much so that they're closer to the next entry. It's no big deal, but I figured I should point it out since you asked.

Perhaps try that IH-like uncollapsed table with a slightly smaller font?

The deluxe variant could even feature a DH-style background and come in PDF-format (circumventing any potential excel hassles for the readers), though I'm unsure how some of the other players managed to create such documents. I'd actually be very interesting in replicating this "book-lookalike" style myself.

Share this post


Link to post
Share on other sites

Lynata said:

The deluxe variant could even feature a DH-style background and come in PDF-format (circumventing any potential excel hassles for the readers), though I'm unsure how some of the other players managed to create such documents. I'd actually be very interesting in replicating this "book-lookalike" style myself.

+1. I'd love to see that as well, and i far prefer PDFs (Adobe makes a fine reader)

Share this post


Link to post
Share on other sites

Looks very nice! impressive work. I noticed a couple of flaws at first glace:

gear: some descriptions are cut off mid sentence, looks like a copy paste error e.g. H161

ship upgrades: you have two identical headers ITS Specific, I'm guessing one should be rites of battle

One thing I unfortunately miss is the page number and the source of the items, this is really valuable. I'm also wondering how many people are doing the same job over and over again. E.g. I have also an excel sheet with well nearly everything though with a completely different setup. I've also come accross more than one sheet generator that again has (usually a slightly different set) of all the armoury entries. On the one hand I'm thinking 'can't we try to work together so its less work for all of us' on the other hand I do realise that we all do it differently anyway, my version can be found here. Maybe its usefull to you.

Share this post


Link to post
Share on other sites

wolph42 said:

One thing I unfortunately miss is the page number and the source of the items, this is really valuable.
That's true. I should have mentioned that. Would make a good feature for a future version - perhaps the page numbers can be extracted from another player's sheet to make it less of a hassle to look everything up again...

Also: Interesting tool. o_o

Share this post


Link to post
Share on other sites

Page numbers? I can do page numbers!

 

@Wolph42: I'll get on those mistakes asap, thanks for the heads up! As for anything particularly fancy, I'm at a complete loss. Things like compressed rows are pretty much the extent of my excel ability. I'll see what I can do though! Also, I think I've looked into that stuff before for actually playing. I always thought it was neat how you could do the game table that way.

 

@Lynata: That's how excel is unfortunately. All the + signs are exactly one row lower than the header they expand. When I first added the feature I tried to find a way around it, but apart from putting the headers actually underneath the sections they cover, there's no way to move that higher. That said, if I'm mistaken and someone does know how, let me know! I'm always willing to learn.

 

@BangBangTequila: Good lord, that's terrible. I'm truly sorry that happened. In the future, I'll look into the pdf suggestion the others had. With any luck, that will prevent such a thing from happening, not to mention it's usually nicer to scroll through a PDF than an excel sheet that's just rows and rows of rectangles.

Share this post


Link to post
Share on other sites

? I can't remember asking for anything fancy *checking post* nope, nothing there. As I said I like it and maybe my own xls might be usefull for you (e.g. to get the page numbers and references from).

 

As for the + signs. there is an alternative (wel two actually, and prolly more, the second being pivot tables): autofilters. I think that's way more usefull for your excel setup but that is a matter of opinion. If you're using filters you need to put all the info on one line and then the lot beneath each other. What you get is quite similar to my own sheet but yours has different (and quite usefull btw) info. This way you can e.g. filter for all 'hive world' weapons or all 'launch' weapons etc.

You keep basically the same but make it more condensed and easier to access. I've done services of your xls file to give you an idea of what I mean. You can find it here

It's a lot less fancy, but way more practical (it usually seems that these two are mutually exclusive)

Share this post


Link to post
Share on other sites

Thanks very much for this index, its next to bloody invaluable when as a poor beleagured GM you often have to trawl through 3 different games and all the **** books for some piece of crap or another a PC wants, or simply to belt them around with on a whim.

Share this post


Link to post
Share on other sites

Thanks for this, I can see it being really useful, a little while back though I did my own list of every single ammo type from pretty much almost every book, including exotic and some useful fanmade ones, as well as some IRL ammo that was missing. It isn't as indepth as yours, but works well for my metallican arbites who prefers SP weapons.

Share this post


Link to post
Share on other sites

Hello everyone! I'm back, and in a couple days I'll be updating the armory with the new equipment from Daemon Hunters, both regular acolyte gear and Grey Knight equipment! Furthermore, I've changed how updates are numbered. The first grouping is the series, i.e. Dark Heresy Core, the second is the included source books, such as Inquisitor's Handbook and Rites of Battle. The third is the date of the release in MMDD format, which should account for updates to errata, as well as minor updates and corrections. That said, the next version will be 3.11.07xx, depending on when I finally get it done. Thanks for praise, and happy gaming!

Share this post


Link to post
Share on other sites

 Just a helpful tip for those that use Office 2007 (and probably 2010):

To get the + sign to display on the header row, go into the Data menu, click the small icon at the bottom right of the Outline group, and deselect the two options shown there. Don't do anything with the Automatic Styles though.

For 2003 versions, from memory it's Data -> Grouping ->Group Options. Don't hold me to it, as it's been a while since I've used the old version. If I'm wrong it should at least give you an idea where to start.

It would be possible to use autofilters with very little changes. You would need to create a new column (to the far left probably), highlight the first row (the frozen one at the top), and go to the Data tab then select the Filter option. For those who use 2003 versions it's nowhere near as good as the later one, but it is compatible and useable.

 

unnownrelic: Thanks for putting this together. A very handy reference. As for putting it into a database, what sort were you thinking of? A web (XML or similar) thing, or Access?

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0