Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2016, 04:56 PM
tommade tommade is offline How can I generate Scenarios? Windows 10 How can I generate Scenarios? Office 2013
Novice
How can I generate Scenarios?
 
Join Date: Feb 2016
Posts: 1
tommade is on a distinguished road
Default 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
Reply With Quote
Reply

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
How can I generate Scenarios? 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
How can I generate Scenarios? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft