#1
|
|||
|
|||
How can I generate Scenarios?
This might be a question far too complex for me to understand as I am still rather new at learning about what Excel can offer in terms of functions and formulas, but I wish to ask and dive in anyway. My hope is that others out there will be able to help me. I would say my skill level with excel is about a 4 from 1-10. I am hoping to make a model for the March Madness basketball tournament. [for those outside the USA, this is a basketball event where 64 teams are put into a bracket format, team 1 plays team 64, 2 plays 63 and so on. After each round, the losing team is eliminated and the winner advances]. Searching the web, I have found many ways to 'host' a March Madness tournament and create a Bracket, but I am looking for more than that. It would be my hope to set different criteria (example: Vegas Odds, Points scored per game, points scored against per game, etc) and assign them each a value. Then, based on those factors and values, have Excel generate the results of the bracket [starting with a bracket having only 64 teams and excel would generate all the winners until it gets to 1 champion, but also generating the teams that advance in each round, including the final game]. If this would be too hard to do in a bracket format, just a linear format showing which teams advance or ranking the teams would be an acceptable alternative. I would like to be able to change the value of the criteria and generate new scenarios based on the weighting. Another version of this, which I would be interested in, if easier, would be to include 'odds of winning'. So for example, there are 32 games in the opening round (64 teams, playing one against another), and based on the criteria and factors, offering a percentage likelihood of winning (example, that team 1 might have a 99.5% chance and team 64 has a 0.5% chance), and so forth. Then I can manually advance the teams and simulate again in the next round, based on the criteria (mentioned in the paragraph above). I do hope I am explaining this correctly, and I welcome any questions that would help me better explain what I am searching for. If anyone could help I would be most appreciative. Thank you in advance. Tom |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using styles to generate content page | TYPO | Word | 2 | 12-20-2015 12:48 PM |
Automatically generate PDF from saved word doc | JamesHusband | Word | 3 | 06-07-2014 08:30 AM |
Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
Generate TOC Without Paragraph Text | sbianco | Word | 8 | 09-22-2012 06:54 AM |
Generate Folder | streng | Excel | 0 | 11-11-2008 11:20 AM |