A&E Weapons Spreadsheet

[PhilHibbs]

http://mrqwiki.com/wiki/images/f/f6/Weapons.zip
*Update:* Now includes ranged weapons, I found a much quicker way to populate the spreadsheet so it only took me 5 minutes rather than about an hour to do the close combat. Ranged weapons are in a new spreadsheet, as OOo only allows one tab per workbook to have an AutoFilter.

There's conditional highlighting of the STR and DEX requirements - enter your stats at the top, and it will highlight in red any requirements that you do not meet, so only rows with both STR and DEX values in white background are usable.

I originally created this from the A&E PDF, then realised that the errata changed loads of the stats so I've gone through manually amending it as per the errata, I don't think I've missed anything...

 

[PhilHibbs]

I fumbled the upload of the new version including ranged weapons. Fixed now, the same original link now should give the new version.

 

[cerebrolator]

Looks great, Phil!

Thanks for all the work.

 

[PhilHibbs]

Just updated this file - AP and HP are in separate columns so can be filtered and sorted, also it calculates the maximum damage of a weapon so you can sort by that as well! Both sets of data are in one file now, I worked out how to get both filters working at the same time.