So I've been working on a bit of a spreadsheet the last few days, trying to get a handle on optimizing weapon attacks for DPR. It works for implement attacks too, but not in a very intuitive way, so I'll probably make another sheet for that after getting some feedback on this one. It may have errors in the sheet, but I can't readily spot any. So if anyone wants to stress-test it, here we go.www.thelonelywinds.com/phpBB3/docs/DPR%20Maths.xls
It can't handle more than 99 damage dice in any one field. Not sure how to fix that without an extra layer of references, and I'm sure it's not worth it.
It can't handle percentile dice or larger. If you are rolling d100+ for damage, your name is LDB
and you don't need this.
EDIT: Changed from GoogleDocs to Excel download so that everyone can have their own copy. Right click and save as.
EDIT 2: Fixed a crapton of errors. This is why I should have used named ranges from the beginning. Many thanks to LDB for always showing his work so I could figure out where exactly my errors were.