*
*
Home
Help
Login
Register
Welcome, Guest. Please login or register.
December 03, 2021, 05:46:50 PM

Login with username, password and session length
Forum changes: Editing of posts has been turned off until further notice.
Search:     Advanced search
275647 Posts in 27717 Topics by 4285 Members Latest Member: - Jason DAngelo Most online today: 93 - most online ever: 565 (October 17, 2020, 02:08:06 PM)
Pages: [1]
Print
Author Topic: Doing game probabilities in Excel  (Read 1977 times)
Ry
Member

Posts: 215


« 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: 3453


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: 215


« 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.11 | SMF © 2006-2009, Simple Machines LLC
Oxygen design by Bloc
Valid XHTML 1.0! Valid CSS!