How is Carrying Capacity defined?

[Aioran]

I can't figure out how to get the carrying capacity values without looking at the table. 1-10 is easy but 11-n is where things get hard. I was hoping someone knew an equation I could type into excel? D:

[Davick]

If the value is 10 or greater then if you add 10 the capacity increases by 4. Sometimes it's off by one, probably due to off screen rounding. Before ten I think each point adds 3.33... pounds.

[Aioran]

Ahah! I found someone had done an incredibly ugly, but effective, equation for just such a thing already.

[Aioran]

Light and Medium Loads are just 33% (down) and 67% (up) of Heavy Load. Heavy load is the one determined directly by the Strength score. It's very much not a linear relationship, though >_>"

[Davick]

Aioran wrote:

Light and Medium Loads are just 33% (down) and 67% (up) of Heavy Load. Heavy load is the one determined directly by the Strength score. It's very much not a linear relationship, though >_>"

Ah, I always go by light load. That's an interesting factoid.

[Cevah]

Aioran wrote:

Ahah! I found someone had done an incredibly ugly, but effective, equation for just such a thing already.

I got a simpler one:

I am looking for the math behind carrying capacity.
Formulas are:

• A1: <strength value>
  
• E1: =IF(A1<10,10*A1,CHOOSE(1+A1-10*INT(A1/10),25,28.75,32.5,37.5,43.75,50,57 .5,65,75,87.5)*POWER(4,INT(A1/10)))

See the above link for the details.

/cevah

[Drake Brimstone]

I just copied the table into a separate tab as a lookup table. I'm assuming that works in Excel, I'm using Open Office. I also have the bonus spells in the table and just copy and modify the same file for all my characters of different classes.

[Hety]

Thanks for formula from 2017. Incorporated it into my charsheet :)

/soz for necroing.