Latest Google Docs spreadsheet (It still needs more sprucing up, but that wil be later.
Looks good to me. I would add in a section for the melee weapons that can be used as ranged weapons (that calculates their ranged scores, since those are lower than their melee scores, so they can be compared to other ranged weapons), but it looks good to me.
Nice work!
"Final" Google Docs spreadsheet.
I cleaned it up about as much as I am going to.
I copied the ranged melee weapons, and added them to the appropriate ranged categories (removing the ranged melee bonus, and brace abilities of the Spear and trident).
I even added two more modifiers; -5% for needing a feat to get iterative attacks with a ranged weapon, and -5% (-10% total) for needing 2 or more feats to get it (the Heavy Crossbow is the only I know of). Unfortunately, that isn't enough to make the Repeating Heavy Crossbow "better" than the Heavy... But it does get them close.
I can easily tweak numbers from here, but I am pretty much considering it done.
Ages ago, the good folks in the WotC boards community put together a couple of formula for this stuff which can be found here.
Almost all the weapons in 3.5's PHB fell into a workable range that showed that most of them were actually pretty balanced. I wonder how the PFRPG Spiked Chain would rate now...
"Final" Google Docs spreadsheet.
I cleaned it up about as much as I am going to.
I copied the ranged melee weapons, and added them to the appropriate ranged categories (removing the ranged melee bonus, and brace abilities of the Spear and trident).
I even added two more modifiers; -5% for needing a feat to get iterative attacks with a ranged weapon, and -5% (-10% total) for needing 2 or more feats to get it (the Heavy Crossbow is the only I know of). Unfortunately, that isn't enough to make the Repeating Heavy Crossbow "better" than the Heavy... But it does get them close.
I can easily tweak numbers from here, but I am pretty much considering it done.
Looks good to me. It's not perfect (the scale system itself, not the sheet), but it's 'good nuff for govmint work'.
As a slight aside,
How would everyone handle the classic 'Bayonet' concept? For default D&D I would think something like an attachment on a crossbow. I personally envision a pair of wickedly curved and sharp blades, one attached to either side of the stock, both pointing forward from the foremost part of the bowed section (so that a bolt is centered between them when it's knocked and ready to fire).
So, you'd use it as a crossbow, and then if someone closes up you'd ram it into their chest.
There's no rule for this, obviously, but I think you could treat it as a spiked shield for attacking (except not off-hand). A two-handed weapon obviously.