Spreadsheet completed showing 6824 possibilities in total. I'll email it to you.

For each lineup/bench possibility I have calculated the number of ways the bench players can be shuffled into the lineup by swapping one player for another of the same positional type. I'll give you one example of how it works:

Look at the sheet row 13. Here's the roster, 3rd lineup bench and calculation:

Roster number 12 = QB QB RB RB RB RB WR WR WR TE PK PK TM TM

Lineup 3 = QB RB RB RB RB WR WR TE PK TM

Bench 3 = QB WR PK TM

Calcs = 24

QB 2 altogether(including the bench), lineup needs 1, so choose 1 from 2 = 2 choices

Four RB, all used so 1 choice

WR 3 altogether, lineup needs 2, so choose 2 from 3 = 3 choices

TE just 1 choice

PK 2 altogether, lineup needs 1, so choose 1 from 2 = 2 choices

TM 2 altogether, lineup needs 1, so choose 1 from 2 = 2 choices

Altogether 2 x 1 x 3 x 1 x 2 x 2 = 24

I have checked a couple dozen entries to make sure the calcs went ok.

Then I totalled the five calcs columns, and then totalled these five to get the final total in cell T49.

Hope that is all ok and I can move on now. Please don't change the rules.

Bob

]]>I'm glad you've got the sheet.

Step 1 was to find all the rosters. I got 46 and I think that's correct. Phro has checked there's no repeats.

Step 2. There are only 5 possible lineups so I inserted those onto the sheet. But some lineups are not possible with some rosters.

eg. With the first roster there are 3 WRs, but the lineup wants 4. So it cannot be done, hence the impossible label. What I did was to run each lineup through each roster, trying to make the lineup and working out what's left on the bench. If there wasn't enough of a position I recorded 'impossible; otherwise I recorded the bench.

You're right that there is one more step to do. I wanted you to cast an eye over my progress so far, in case I'm still missing something in the rules. I suggest you pick a few rosters and think whether the sheet row shows the lineup/bench possibilities. If you cannot find anything wrong I'll do the final step. The code is in my head; so I've just got to implement it.

What I'll do is add another column, after each bench column, that gives the number of player combinations for that lineup/bench. Then it will just be a case of summing up the columns to get the grand total.

Hope that clarifies what I've sent and my plan for the last step.

Bob

]]>Correct me if I'm wrong, but I thought you were going to figure-out the player possibilities as you stated in #2 of Post #36 and as I outlined in Posts #29, #31 & 33.

Am I confused on what I'm seeing? (could be)

]]>Can you send again?

Sorry for the trouble.

]]>I received my Excel file ok, thx.

Only had time to have a quick look at it, and all I did was check for duplications in the columns by using the UNIQUE function that's part of the new Excel Dynamic Arrays family.

Example: Entering '=COUNTA(UNIQUE(B2:B47))' in B48 returns '46' there, confirming that your 46 column B entries are unique. Similarly with Column G.

I'll have to take a closer look at earlier posts to try and understand this thread before examining further. Previously I've only skimmed through the posts.

Might take me a bit of time, though!

]]>Bob

]]>How do I get to your spreadsheet (never used Google Drive) so I can compare your results with mine?

-- Mitch

]]>After a couple of mammoth sessions I think I've cracked it and got a spreadsheet that contains:

roster number

possible rosters

lineup1

bench for lineup1

and same for lineups 2, 3, 4 and 5.

Some cases are impossible because the available players in a roster don't fit with the lineup requirements. These are shown as 'impossible'.

So there are potentially 460 cells of data. I have checked a few at random and all worked out ok … that is to say I could pick a lineup from the roster and have 4 bench players except when there wasn't enough players to fulfil the lineup and got an 'impossible' message.

I've not tried this before so I don't know if I've done it properly, but I have uploaded the sheet to my google drive and shared it with each of you. Please let me know if that has worked and then see if you can find any errors. (Fingers crossed!)

The key to calculating the number of possibilities lies with the bench player options. eg. If the lineup has a QR and there's a second QR on the bench then you have x2 possibilities for who to play. Or if the lineup has 3 WRs and they're all in the team then there are x1 possibilities as you've got no extra WRs you can swap in. I'll start working on a quick way to calculate them all.

In the UK all sporting fixtures have been cancelled so I'm guessing your league won't have any matches at the present. What a disaster!!! Let's hope things can get back to normal soon.

Best wishes, stay healthy,

Bob

]]>--Mitch

]]>Bob

]]>-- Mitch

]]>(1) Find all possible rosters using the allowable position rules. (Done this … it's 46)

(2) For each identify the (up to 5) possible line ups and bench player alternatives.

(3) Now assume you've picked your players (14 for each of the above) label them WR1 WR2 etc.

(4) Work out how many alternative line ups that allows.

Bob

]]>Throwing in the towel?

-- Mitch

]]>In the 'Configuration Spreadsheet" you''ll see a list (I2 thru I9) of 8 Entries [sic combinations) of a Roster that can comprise the lineup.

The 1st Combination (QB1, TE1, PK1) is utilized Group 1; the 2nd Combination (QB1, TE, PK2) is shown in Group 2 and so forth.

One takes the original configuration , multiply by 8 (# of possible combinations of QB1, QB2,TE1, TE2, PK1, PK2 which is 7) to come up with a possible 56 different configuration for the Roster settings.

Make more sense?

]]>