I was playing a game yesterday and was wondering how many armies it would take to get a specific territory. I did not want to just try and fail. I needed to see what the chances were I would win. I looked on google for a program that would simulate d6 dice rolls (3 attacker against 2 defender) until one of them loses. I could not find any. So, I made one.
The link below is an excel file at allows you to simulate attacking and defending with any number of armies. I uses a few macros. Not overly complex. Just thought I would share this with anyone who wanted it. Feel free to give input on possible improvements to it.
I just downloaded the 2003 trial. You need to install the analysis toolpack in the Tools> Add-ins section. That enables some of the functions that I used. Let me know if this works. Also I noticed that Microsoft had an update for excel 2003 related to the randbetween function i used.
i have excel 2000. dont know if that works. i opened the thing and when i set the number of armies and pressed roll dice, i got #NAME in all the cells.
Any ideas why?
I am cricket, the cricket playing cricketer. The Master Blaster is the best in the world.
Highest Score - 1888 Highest Place - 292 Current Rank - Lieutenant Current Score - 1630
It's not supposed to tell you whether you'll win or lose - it just tells you what the odds are. And it can, and probably will, be wrong a fair amount of the time - odds, after all, deal with chance.
I added the Random.org data to the excel program. The file takes requests data from random.org for 3 attacking dice and 2 defending. Then it determines the number of dice each player can roll. It the sorts tem highest to lowest and determines the winner.
There are two versions because excel apparently changed the way they sort data between the two versions.
