*
*
Home
Help
Login
Register
Welcome, Guest. Please login or register.
November 26, 2014, 05:54:48 AM

Login with username, password and session length
Forum changes: Editing of posts has been turned off until further notice.
Search:     Advanced search
46709 Posts in 5588 Topics by 13297 Members Latest Member: - Shane786 Most online today: 132 - most online ever: 429 (November 03, 2007, 04:35:43 AM)
Pages: [1]
Print
Author Topic: Doing game probabilities in Excel  (Read 1203 times)
Ry
Member

Posts: 216


« on: June 20, 2008, 01:40:06 PM »

Hey Vincent, you mentioned a few times that you had an excel sheet you used to check on probabilities for IAWA. 

How did you go about constructing that?  I know how to calculate a simple probability but the multiple-but-variable round structure of IAWA, possibility of one-vs-many, and the way previous rounds change subsequent rounds defeats me.
Logged
lumpley
Administrator
Member
*
Posts: 3656


WWW
« Reply #1 on: June 23, 2008, 09:03:16 AM »

Oh I didn't even.

All I checked was whether, like, d8d8d6 or d12d8 was more likely to win any given single comparison. I didn't check for whole fights at all.

I didn't even use statistics-math. I did it by writing macros to cycle through all the possible rolls for each and spit out the number of times each result came up.

-Vincent
Logged
Ry
Member

Posts: 216


« Reply #2 on: June 23, 2008, 09:58:08 AM »

Alright, that means I have a challenge ahead of me.
Logged
Pages: [1]
Print
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines
Oxygen design by Bloc
Valid XHTML 1.0! Valid CSS!