PDA

View Full Version : My spreadsheets on character progression



fangthane
2006-09-22, 11:21 PM
It took a lot more work than I'd anticipated to get this going, since the board appears to have some very touchy limitations, but these are the charts I developed to determine at about what level a fighter and rogue would end up gaining specific weapon, armor and stat bonuses as well as factoring in the cost of mithral items. The one thing I haven't factored into the cost is shield bonus, other than the obvious basic equipment. It's easy enough to do, I just haven't added the new column and modded the formulae to accommodate it because I'm lazy.

{table]
Ftr lvlStrDex
ConIntWis
ChaArmor
ShieldDefl'nNat'l
DodgeWpnBAB
Atk featsCostMax
Feat dmgStr Bonus
Dex BonusCon Bonus
HP
11815
16141210
52
1
10
13
21815
16141210
52
2
10900
21
31815
16141210
52
13
120002700
30
41915
16141210
621
14
1500054002
38
51915
16141210
621
115
1800090002
47
61915
16141210
621
116
112000130002
255
71915
16141210
631
117
115000190002
264
82015
16141210
731
128
224000270002
272
92015
16141210
742
129
234000360002
2290
102015
16141210
742
1210
24600049000
242
99
112015
16141210
842
2211
26200066000
2422
109
122016
16141210
952
2312
27800088000
4422
118
132016
16141210
952
2313
278000110000
4422
128
142016
17141210
953
21314
2147500150000
4624
151
152016
17141210
1063
21315
2169500200000
4644
162
162016
18141210
1183
31416
2227500260000
4844
188
172216
18141210
1283
31417
2309500340000
4846
217
182216
19141210
1394
41418
2403000440000
4866
229
192216
19141210
1394
41419
2431000580000
4868
261
202216
20141210
1395
51520
2513000760000
4888
294

[/table]

Several things are in need of explanation: Armor/shield is the total bonus provided by armor worn, including magic; at level 11 the fighter is presumed to upgrade to Mithral plate (for the +11 net AC min/max), and to a tower shield (generally also mithral, cost not factored) at level 16. At 14 I presumed the Dodge feat (or equivalent) and put priority on weapons, strength and constitution in that order. Cost is calculated based on the price of all stat boosts including intrinsic (those are red on the initial sheet) plus the price of all special materials (other than weaponry) and the price of all enhancement bonuses except on the shield. I've tried to leave some leeway for special weapons and basic gear to an extent, though I'm not entirely happy with level 4-5

{table]
Rog lvlStr
DexConInt
WisCha
ArmorShieldDefl'n
Nat'lDodgeWpn
BABAtk featsCost
MaxFeat dmgStr Bonus
Dex BonusCon Bonus
HP
11518
121610
144
1
0
3.5
7
21518
121610
1441

10
9003.5
11
31518
12161014
41
1
20
27007
16
41618
121610
1441
11
134000
54007
20
51618
12161014
421
11
137000
900010.5
25
6161812
161014
5211
1
148000
1300010.5
29
7161812
161014
52111
1516000
19000142
34
8161912
161014
53111
2625000
27000142
38
9161912
161014
532
11
2631000
3600017.5
243
10161912
161014
63221
2744000
4900017.522
47
11161912
161014
63221
2860000
66000212
4263
12162012
161014
643
21
39185000
88000212
4268
131620
12161014
6
4321
39197000
11000024.544
274
14172012
161014
6
4331
3101146500
15000024.544
493
15172012
161014
753
31
3111178500
2000002846
4100
16182012
161014
7
5431
4121226500
2600002866
4106
17182212
161014
8
5441
4121302500
34000031.5
66
4113
1818
2213
161014
8
644
1
4131387000
44000031.568
6137
19182213
161014
96441
4141424000
5800003588
6145
20182214
161014
965
51
5151506000
7600003588
8192
[/table]

The rogue chart is much similar to the fighter in many ways; I've incorporated the sneak damage into Feat damage and factored in Weapon Finesse as of creation and Focus as of level 12 which may be more or less aggressive than normal but which seems reasonable to me.

I use these charts in combination with another sheet which calculates dex bonus to AC, stat bonus to attack and damage rolls as well as sneak damage (assuming 50% of attacks are potential sneaks where possible) and reads out for me the base attack, total attack bonus, and any AC I might need to check. I have another page which does combat probability calcs based on 1- and 2-handed attacks for fighters, 1- and 2-weapon style for rogues (both with and without sneak) and applies the numbers against an opponent AC and DR I can set. Makes it much simpler to determine the average flow of damage in a combat. :)

If anyone wants me to post the formulae I use (with reference to where they're used) let me know - if I had hosting, I'd post a link to the spreadsheet :)

Edit - Damn, just noticed a mistake in allowing space for the shield cost; the con bonus should go to +4 only at level 15; they can't afford it at 14 (less than 4k for +2 shield bonus)