Carrying Capacity for Excel

[Aeron]

I'm currently working towards making an excel character sheet that will do all of the maths in game for you, and I noticed no one seems to have found a one cell equation to get carry capacity from strength, which really frustrated me, so I made one, and here you go.


=IF(A1>10,IF(ISERROR(POWER(-1,(A1)/5))=FALSE,200*POWER(2,ROUNDUP(A1/5,0)-3),IF(ISERROR(POWER(-1,(A1+1)/5))=FALSE,175*POWER(2,ROUNDUP(A1/5,0)-3),IF(ISERROR(POWER(-1,(A1+2)/5))=FALSE,150*POWER(2,ROUNDUP(A1/5,0)-3),IF(ISERROR(POWER(-1,(A1+3)/5))=FALSE,130*POWER(2,ROUNDUP(A1/5,0)-3),IF(ISERROR(POWER(-1,(A1+4)/5))=FALSE,115*POWER(2,ROUNDUP(A1/5,0)-3),"ERROR"))))),A1*10)

Copy this string of text into a cell, and replace A1 with the cell for your strength value, and you will get the heavy load carrying capacity, from which you can then use nice equations such as /3 for light load, x2 for large or x1.5 for quadrupeds.

I hope many of you find this useful, and I hope to share my completed spreadsheet in the future.

p.s. this was made using excel 2007 have no idea if this is backwards compatible

EDIT: simplified the equation

[dascarletm]

I shall bookmark this!

[Cranthis]

Well you could have just took a peek in the phb, but there you have it. Also, there is an interactive character sheet for 3.5. The only thing it doesn't do for you mathwise is carry weight though haha.

[Duke of Urrel]

Aeron, you deserve a special honor for undertaking this ambitious work. I have tried out your formula on an Excel document of my own, and it works!

[Kumori]

Your formula is effective, but it gives me a headache to look at. I'm trying to make one that is more elegant, but that is also giving me a headache.... I'm forced to give you props on yours, so job well done!