07-19-2018, 09:08 PM | #21 |
Join Date: Mar 2017
|
Re: ST damage formula
Awesome, that helped me write this little formula for my google sheet that displays the swing and thrust damage based on the strength number in another cell on the same sheet. It displays as "2d-1" type notation. Assuming B7 is the cell your Strength number is contained in.
SWING: =IF(MOD((($B$7-10)+4)/4,1) = 0,(($B$7-10)+4)/4&"d",IF(MOD((($B$7-10)+4)/4,1) <= 0.25,ROUNDDOWN((($B$7-10)+4)/4)&"d"&"+1",IF(MOD((($B$7-10)+4)/4,1) <= 0.5,ROUNDDOWN((($B$7-10)+4)/4)&"d"&"+2",ROUNDDOWN((($B$7-10)+4)/4)+1&"d"&"-1"))) THRUST: =IF(MOD((($B$7-10)+4)/8,1) = 0,(($B$7-10)+4)/8&"d",IF(MOD((($B$7-10)+4)/8,1) <= 0.25,ROUNDDOWN((($B$7-10)+4)/8)&"d"&"+1",IF(MOD((($B$7-10)+4)/8,1) <= 0.5,ROUNDDOWN((($B$7-10)+4)/8)&"d"&"+2",ROUNDDOWN((($B$7-10)+4)/8)+1&"d"&"-1"))) Now, if you happen to know how to calculate punch and kick, I would gladly post the google sheet/excel/libra office translation. :-D |
07-19-2018, 11:53 PM | #22 |
Join Date: Oct 2010
Location: earth....I think.
|
Re: ST damage formula
Wow, this was an old post lol, I use a different house rule now, which I hope I did not post because I want to someday have it published officially.
For punch and kicks, you are looking at -2 damage and -1 damage. |
Tags |
damage, modifying damage |
|
|