Auto Char Sheets and The Formulas

[HonJull]

So I've been making my own Auto Calculating Character Sheets, and I've gotten most of the formulas down. Like the BAB, Saves etc... but for the life of me I can't figure out what the formula for your light, med, heavy push/lift/drag is. Is there one, or is is all random? Any one out there know?

 

[Tabarnak Smokeblower]

erh.

I don't think there's a formula. There's a pattern, but not a formula. You're better off programming a lookup function in the carrying capacity table...

str       capacity  add. weight
1	10	10
2	20	10
3	30	10
4	40	10
5	50	10
6	60	10
7	70	10
8	80	10
9	90	10
10	100	10
11	115	15
12	130	15
13	150	20
14	175	25
15	200	25
16	230	30
17	260	30
18	300	40
19	350	50
20	400	50
21	460	60
22	520	60
23	600	80
24	700	100
25	800	100
26	920	120
27	1040	120
28	1200	160
29	1400	200

You'll notice that the additional weight follows a 2-2-1 pattern, ie that for 2 str levels the weight increases the same, for 2 more str levels, the weight increases the same (but more), then for 1 str level, the weight increase goes up again.

Like I said, if you're working in excel, its just easier to build a vlookup function...

TS

edit: another note: the max weight seems to increase by ~13% for every str point more, starting at 6 str.

 

[Dimwhit]

I've done this in my excel character sheet, but I don't know it offhand. If I remember, I'll try to post the sheet here and you can look at it. Not everything on the sheet auto-calculates (like BAB and saves as you level up), but much of it is.

 

[Lord Rasputin]

At Str 1-10, carrying capacity is just 10 x Str.

Starting at Str 10, the principle is that every 5 points of Str is a doubling of carrying capacity. Thus, the progression is a smoothing out of that principle. I suppose something like ...

If Str < 11, Capacity = 10 x Str

If Str > 10, subtract 10, divide the result by 5, keeping the remainder. Remainder 1 is 115 lbs., Remainder 2 is 130 lbs., Remainder 3 is 150 lbs., Remainder 4 is 175 lbs; no Remainder is 100 lbs. Then for each full number (sans remainder), take 2 to that power and multiply the figure above by it.

 

[LazarusLong42]

if ($str <= 10)
{
    $capacity = 10 * $str;
}
else
{
    $capacity = 100 * (2 ^ (($str - 10) / 5));
    $capacity = round($capacity/5)*5;  //round to the nearest five
}

This'll start to deviate at STR 22... but only because WotC, rather than using actual formulae, just doubles the number every five STR points. If you're worried about that, subtract five until $str is between 10 and 15, then double the value you get once for each five you subtracted.

(Yeah, OK, it's an alogrithm, not a formula. Sue me. )

 

[Tabarnak Smokeblower]

Rasputin, did you deduce it or did you know beforehand?



TS

 

[Lord Rasputin]

Rasputin, did you deduce it or did you know beforehand?



TS

I did know that before you posted it. SKR said on his site that for an attribute, adding 5 to it was a doubling of it, based on the Strength carrying capacity table. I took a look the other day, and lo and behold, that's how the thing worked.