Thanks for the information, Cutter and Yuritau. Yeah I was thinking for purposes of fortresses, cities, and ships. I wanted to know how close PCs would need to get to a fortress/town/ship to start bombarding it. The numbers and comments here will work great for my purposes. Thanks!
I revisited my spreadsheet in a spare moment at work and found that I zigged when I should have zagged on one of the calculations that threw everything else off, so here are my revised figures, for you consideration.
SC CN HP SP EP SR MR LR
I Falcon 1d6 (x10) 250 25 300 600 3,000
II Minion 2d6 (x10) 500 50 750 1,500 7,500
III Saker 3d6 (x10) 750 75 1,500 3,000 15,000
IV Demi Culverin 4d6 (x10) 1,000 100 2,250 4,500 25,000
V Culverin 5d6 (x10) 1,250 125 4,000 8,000 40,000
VI Split Cannon 6d6 (x10) 1,500 150 4,000 8,000 30,000
VII Demi Cannon 7d6 (x10) 1,750 175 3,000 6,000 30,000
VIII Cannon 8d6 (x10) 2,000 200 2,000 4,000 20,000
Sorry it's a bit of a mess, my forum-fu is weak.
SC Size Category
CN Common Name
HP Hit Points
SP Silver Pieces
EP Encumbrance Points
SR Short Range (feet)
MR Medium Range (feet)
LR Long Range (feet)