+ Reply to Thread
Results 1 to 4 of 4

How to Model Permutations?

  1. #1
    Registered User
    Join Date
    04-09-2017
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    3

    Question How to Model Permutations?

    I'm trying to model all of the possible outcomes for a competition I'm putting on this summer and get insight on the different types of scoring systems we can use.

    We have 8 teams and 6 different games. Points are scored based on how someone places in each game and the team with the most points at the end of all 6 competitions wins.

    I have included an excel sheet that has everything that I am trying to do, but essentially I want to model all of the different scenarios and have them in a filterable list in excel.

    I have an example of what I want to create in the 'Simulation Database' tab in my excel sheet. The problem is I don't now how to automate this. All of those values were entered in by hand. I would also like to make them calculations so if I wanted to test out different point systems I can just change one or two cells then the whole model changes.

    Apologies if this question should be in a different thread. This is my first post on this forum.

    I've never used VBAs or macros, but maybe I would need to for this..?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,772

    Re: How to Model Permutations?

    Welcome to the forum!

    This looks like an entire project. Might I suggest considering the Commercial Services section, where you can offer f=some financial recompense for whoever takes it on.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-09-2017
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: How to Model Permutations?

    Thanks for the suggestion Ali, I'll do that!

  4. #4
    Registered User
    Join Date
    04-09-2017
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: How to Model Permutations?

    I took a look at the Commercial Services section and I'm a bit confused. How many points (which subscription) would I need for this project? I'm assuming I would pay someone with points after I gain access to that section? Is there somewhere in the forum that explains the Commercial section in more detail?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make a time period a variable for this model? (automating the model)
    By pigment01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2015, 12:47 PM
  2. VBA Model : Two Stage Gordon Model
    By elaph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 11:37 AM
  3. Create a model that will generate a column of numbers based on model parameters
    By tncanoeguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 05:47 PM
  4. Permutations
    By kajabiwan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2012, 01:08 PM
  5. Permutations
    By Christopher_1 in forum Excel General
    Replies: 7
    Last Post: 07-05-2010, 02:28 PM
  6. [SOLVED] permutations
    By newyorkjoy in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 06:17 PM
  7. [SOLVED] Permutations
    By RedChequer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1