tag:blogger.com,1999:blog-3871409676946408069.post2272134424686145903..comments2023-10-14T03:58:59.333-06:00Comments on The Tao of D&D: Easy ProgrammingAlexis Smolenskhttp://www.blogger.com/profile/10539170107563075967noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3871409676946408069.post-17006776785044082962009-12-13T17:40:25.588-07:002009-12-13T17:40:25.588-07:00Excel 2007 has a Randbetween(low, high) function. ...Excel 2007 has a Randbetween(low, high) function. Just pass it the inclusive endpoints and it gives you a random integer between the two. Rolling a d20 is simple: =RANDBETWEEN(1,20)skoormithttps://www.blogger.com/profile/17297504834792748549noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-26072505620367117992009-12-07T14:59:13.177-07:002009-12-07T14:59:13.177-07:00I use the following excel formula to roll a d20
=...I use the following excel formula to roll a d20<br /><br />=TRUNC(RAND()*20)+1<br /><br />Saves time by not having to edit the cell formats.<br /><br />You could take it a step further and use Vlookup to keep track of each attackers and defenders hit points and then have excel "kill" them when their hit points reach zero (i.e., multiply their damage and Attacker Rank # by 0 so they're removed from effecting anyone else).Rhttps://www.blogger.com/profile/00433823836676600019noreply@blogger.com