Round 2 90M Roster Analysis, 2018 Topic

$90M: Pentagon Franchise Puzzle
Pick five franchises. You must roster one player who played their entire career for each franchise. You must also roster two players who played for every pair of franchises. Here is a helpful tool.

Example: You pick the Astros, Mariners, Giants, Red Sox and Cubs. Your roster must be made up of the following:

1 lifetime Cub
1 lifetime Red Sox
1 lifetime Giant
1 lifetime Mariner
1 lifetime Astro
2 HOU / SEA players
2 HOU / Giants players
2 HOU / BOS players
2 HOU / CHC players
2 SEA / Giants players
2 SEA / BOS players
2 SEA / CHC players
2 Giants / BOS players
2 Giants / CHC players
2 BOS / CHC players

Other Specifics
Seasons: 1920 - 2017
DH: No
WW: No
AAA: No
Trades: No
Clones: No
Injuries: Turned On
Multi-team players: No restrictions (i.e., you can use partial or combined)
Ballpark: Use a stadium that was used by one of your chosen franchises
300K Exception: No
Team Name: Reference your franchises
Division Alignment: Random
1/26/2019 10:40 PM
Owner_________ Team 1___ Team 2___ Team 3___ Team 4___ Team 5
brianjw Cardinals Dodgers Pirates Red Sox Tigers
discodemo Red Sox Giants White Sox Yankees Cardinals
rbow923 Yankees Athletics Dodgers Giants Cardinals
schwarze Cardinals Yankees Giants Indians Dodgers
ozomatli Cardinals Athletics Astros Pirates Dodgers
jbohrman Pirates Cubs Athletics Dodgers Indians
buddhagamer Yankees Dodgers Mariners Indians Padres
mildnhazy Athletics Astros Dodgers Giants Red Sox
jfranco77 Tigers Athletics Braves Giants Cardinals
jmissirlis Dodgers Cardinals Braves Indians Giants
dougpalm Red Sox White Sox Giants Indians Athletics
justinlee_24 Cardinals Indians Giants Orioles Red Sox
crystalao Braves Indians Twins Giants Padres
mdc2276 Red Sox Cardinals Orioles Pirates Yankees
redcped Red Sox Dodgers Yankees Cubs Braves
newarkwilder Cubs Dodgers Astros Athletics Cardinals
Donburgh Pirates Braves Dodgers Astros Yankees
magicdreamer Yankees Dodgers Athletics Blue Jays Indians
mpitt76 Tigers Giants Yankees Red Sox Indians
wink0094 Red Sox Dodgers Twins Yankees Pirates
ejstockman Red Sox Astros Yankees Cardinals Tigers
odalisgagne Braves Yankees Dodgers Astros Pirates
Jdh34 Athletics Reds Cardinals Dodgers Nationals
Humdogs Cardinals Giants Red Sox Dodgers Braves
1/26/2019 10:41 PM
Owner_________ Team
brianjw Cardinals
brianjw Dodgers
brianjw Pirates
brianjw Red Sox
brianjw Tigers
buddhagamer Dodgers
buddhagamer Indians
buddhagamer Mariners
buddhagamer Padres
buddhagamer Yankees
crystalao Braves
crystalao Giants
crystalao Indians
crystalao Padres
crystalao Twins
discodemo Cardinals
discodemo Giants
discodemo Red Sox
discodemo White Sox
discodemo Yankees
Donburgh Astros
Donburgh Braves
Donburgh Dodgers
Donburgh Pirates
Donburgh Yankees
dougpalm Athletics
dougpalm Giants
dougpalm Indians
dougpalm Red Sox
dougpalm White Sox
ejstockman Astros
ejstockman Cardinals
ejstockman Red Sox
ejstockman Tigers
ejstockman Yankees
Humdogs Braves
Humdogs Cardinals
Humdogs Dodgers
Humdogs Giants
Humdogs Red Sox
jbohrman Athletics
jbohrman Cubs
jbohrman Dodgers
jbohrman Indians
jbohrman Pirates
Jdh34 Athletics
Jdh34 Cardinals
Jdh34 Dodgers
Jdh34 Nationals
Jdh34 Reds
jfranco77 Athletics
jfranco77 Braves
jfranco77 Cardinals
jfranco77 Giants
jfranco77 Tigers
jmissirlis Braves
jmissirlis Cardinals
jmissirlis Dodgers
jmissirlis Giants
jmissirlis Indians
justinlee_24 Cardinals
justinlee_24 Giants
justinlee_24 Indians
justinlee_24 Orioles
justinlee_24 Red Sox
magicdreamer Athletics
magicdreamer Blue Jays
magicdreamer Dodgers
magicdreamer Indians
magicdreamer Yankees
mdc2276 Cardinals
mdc2276 Orioles
mdc2276 Pirates
mdc2276 Red Sox
mdc2276 Yankees
mildnhazy Astros
mildnhazy Athletics
mildnhazy Dodgers
mildnhazy Giants
mildnhazy Red Sox
mpitt76 Giants
mpitt76 Indians
mpitt76 Red Sox
mpitt76 Tigers
mpitt76 Yankees
newarkwilder Astros
newarkwilder Athletics
newarkwilder Cardinals
newarkwilder Cubs
newarkwilder Dodgers
odalisgagne Astros
odalisgagne Braves
odalisgagne Dodgers
odalisgagne Pirates
odalisgagne Yankees
ozomatli Astros
ozomatli Athletics
ozomatli Cardinals
ozomatli Dodgers
ozomatli Pirates
rbow923 Athletics
rbow923 Cardinals
rbow923 Dodgers
rbow923 Giants
rbow923 Yankees
redcped Braves
redcped Cubs
redcped Dodgers
redcped Red Sox
redcped Yankees
schwarze Cardinals
schwarze Dodgers
schwarze Giants
schwarze Indians
schwarze Yankees
wink0094 Dodgers
wink0094 Pirates
wink0094 Red Sox
wink0094 Twins
wink0094 Yankees
1/26/2019 10:43 PM
Owner__________ Team
Donburgh Astros
ejstockman Astros
mildnhazy Astros
newarkwilder Astros
odalisgagne Astros
ozomatli Astros
dougpalm Athletics
jbohrman Athletics
Jdh34 Athletics
jfranco77 Athletics
magicdreamer Athletics
mildnhazy Athletics
newarkwilder Athletics
ozomatli Athletics
rbow923 Athletics
magicdreamer Blue Jays
crystalao Braves
Donburgh Braves
Humdogs Braves
jfranco77 Braves
jmissirlis Braves
odalisgagne Braves
redcped Braves
brianjw Cardinals
discodemo Cardinals
ejstockman Cardinals
Humdogs Cardinals
Jdh34 Cardinals
jfranco77 Cardinals
jmissirlis Cardinals
justinlee_24 Cardinals
mdc2276 Cardinals
newarkwilder Cardinals
ozomatli Cardinals
rbow923 Cardinals
schwarze Cardinals
jbohrman Cubs
newarkwilder Cubs
redcped Cubs
brianjw Dodgers
buddhagamer Dodgers
Donburgh Dodgers
Humdogs Dodgers
jbohrman Dodgers
Jdh34 Dodgers
jmissirlis Dodgers
magicdreamer Dodgers
mildnhazy Dodgers
newarkwilder Dodgers
odalisgagne Dodgers
ozomatli Dodgers
rbow923 Dodgers
redcped Dodgers
schwarze Dodgers
wink0094 Dodgers
crystalao Giants
discodemo Giants
dougpalm Giants
Humdogs Giants
jfranco77 Giants
jmissirlis Giants
justinlee_24 Giants
mildnhazy Giants
mpitt76 Giants
rbow923 Giants
schwarze Giants
buddhagamer Indians
crystalao Indians
dougpalm Indians
jbohrman Indians
jmissirlis Indians
justinlee_24 Indians
magicdreamer Indians
mpitt76 Indians
schwarze Indians
buddhagamer Mariners
Jdh34 Nationals
justinlee_24 Orioles
mdc2276 Orioles
buddhagamer Padres
crystalao Padres
brianjw Pirates
Donburgh Pirates
jbohrman Pirates
mdc2276 Pirates
odalisgagne Pirates
ozomatli Pirates
wink0094 Pirates
brianjw Red Sox
discodemo Red Sox
dougpalm Red Sox
ejstockman Red Sox
Humdogs Red Sox
justinlee_24 Red Sox
mdc2276 Red Sox
mildnhazy Red Sox
mpitt76 Red Sox
redcped Red Sox
wink0094 Red Sox
Jdh34 Reds
brianjw Tigers
ejstockman Tigers
jfranco77 Tigers
mpitt76 Tigers
crystalao Twins
wink0094 Twins
discodemo White Sox
dougpalm White Sox
buddhagamer Yankees
discodemo Yankees
Donburgh Yankees
ejstockman Yankees
magicdreamer Yankees
mdc2276 Yankees
mpitt76 Yankees
odalisgagne Yankees
rbow923 Yankees
redcped Yankees
schwarze Yankees
wink0094 Yankees
1/26/2019 10:43 PM
Sorted by times used
Franchise___ Times Used___ Franchise Rank___ Avg Owner Rank
Dodgers 16 1 12.3
Cardinals 13 2 12.9
Yankees 12 3 15.6
Giants 11 4 10.4
Red Sox 11 4 12.6
Athletics 9 6 11.6
Indians 9 6 11.4
Pirates 7 8 10.9
Braves 7 8 11.9
Astros 6 10 14.8
Tigers 4 11 11.0
Cubs 3 12 15.3
White Sox 2 13 9.5
Padres 2 13 8.0
Orioles 2 13 17.0
Twins 2 13 9.5
Mariners 1 17 6.0
Blue Jays 1 17 20.0
Nationals 1 17 21.0
Reds 1 17 21.0
1/26/2019 10:48 PM (edited)
Sorted by avg owner rank

Franchise___ Times Used___ Franchise Rank___ Avg Owner Rank
Mariners 1 17 6.0
Padres 2 13 8.0
White Sox 2 13 9.5
Twins 2 13 9.5
Giants 11 4 10.4
Pirates 7 8 10.9
Tigers 4 11 11.0
Indians 9 6 11.4
Athletics 9 6 11.6
Braves 7 8 11.9
Dodgers 16 1 12.3
Red Sox 11 4 12.6
Cardinals 13 2 12.9
Astros 6 10 14.8
Cubs 3 12 15.3
Yankees 12 3 15.6
Orioles 2 13 17.0
Blue Jays 1 17 20.0
Nationals 1 17 21.0
Reds 1 17 21.0
1/26/2019 10:47 PM
I'd love to create some kind of similarity score to see a ranking or who had the most selections that were the same as someone else, but I don't think there's an easy way to do this from this kind of list in Excel. Does anyone know?
1/26/2019 10:48 PM
I can do it by writing 24 formulas in 24 columns.

https://docs.google.com/spreadsheets/d/1jWptU68arIkYmDfiub9YR1PRvKrJvxfzPFxbnrObziQ/edit?usp=sharing

So you can make a "brianjw" column where the formula is =countif(B2:F2,"Cardinals")+countif(B2:F2,"Dodgers")+countif(B2:F2,"Pirates")+Countif(B2:F2,"Red Sox")+countif(B2:F2,"Tigers")

Then make one for disco, one for rbow, etc. Does that make sense? I put the link above to a google sheet, hopefully it works.
1/28/2019 12:25 PM
Ah, yeah, that would work! I'll spin it up
1/28/2019 12:55 PM
Here is a really poorly formatted table where you can take a quick look at who made similar choices to you. I'll put together a better presented chart tonight

brianjw discodemo rbow923 schwarze ozomatli jbohrman buddhagamer mildnhazy jfranco77 jmissirlis dougpalm justinlee_24 crystalao mdc2276 redcped newarkwilder Donburgh magicdreamer mpitt76 wink0094 ejstockman odalisgagne Jdh34 Humdogs
brianjw 2 2 2 3 2 1 2 2 2 1 2 0 3 2 2 2 1 2 3 3 2 2 3
discodemo 2 3 3 1 0 1 2 2 2 3 3 1 3 2 1 1 1 3 2 3 1 1 3
rbow923 2 3 4 3 2 2 3 3 3 2 2 1 2 2 3 2 3 2 2 2 2 3 3
schwarze 2 3 4 2 2 3 2 2 4 2 3 2 2 2 2 2 3 3 2 2 2 2 3
ozomatli 3 1 3 2 3 1 3 2 2 1 1 0 2 1 4 3 2 0 2 2 3 3 2
jbohrman 2 0 2 2 3 2 2 1 2 2 1 1 1 2 3 2 3 1 2 0 2 2 1
buddhagamer 1 1 2 3 1 2 1 0 2 1 1 2 1 2 1 2 3 2 2 1 2 1 1
mildnhazy 2 2 3 2 3 2 1 2 2 3 2 1 1 2 3 2 2 2 2 2 2 2 3
jfranco77 2 2 3 2 2 1 0 2 3 2 2 2 1 1 2 1 1 2 0 2 1 2 3
jmissirlis 2 2 3 4 2 2 2 2 3 2 3 3 1 2 2 2 2 2 1 1 2 2 4
dougpalm 1 3 2 2 1 2 1 3 2 2 3 2 1 1 1 0 2 3 1 1 0 1 2
justinlee_24 2 3 2 3 1 1 1 2 2 3 3 2 3 1 1 0 1 3 1 2 0 1 3
crystalao 0 1 1 2 0 1 2 1 2 3 2 2 0 1 0 1 1 2 1 0 1 0 2
mdc2276 3 3 2 2 2 1 1 1 1 1 1 3 0 2 1 2 1 2 3 3 2 1 2
redcped 2 2 2 2 1 2 2 2 1 2 1 1 1 2 2 3 2 2 3 2 3 1 3
newarkwilder 2 1 3 2 4 3 1 3 2 2 1 1 0 1 2 2 2 0 1 2 2 3 2
Donburgh 2 1 2 2 3 2 2 2 1 2 0 0 1 2 3 2 2 1 3 2 5 1 2
magicdreamer 1 1 3 3 2 3 3 2 1 2 2 1 1 1 2 2 2 2 2 1 2 2 1
mpitt76 2 3 2 3 0 1 2 2 2 2 3 3 2 2 2 0 1 2 2 3 1 0 2
wink0094 3 2 2 2 2 2 2 2 0 1 1 1 1 3 3 1 3 2 2 2 3 1 2
ejstockman 3 3 2 2 2 0 1 2 2 1 1 2 0 3 2 2 2 1 3 2 2 1 2
odalisgagne 2 1 2 2 3 2 2 2 1 2 0 0 1 2 3 2 5 2 1 3 2 1 2
Jdh34 2 1 3 2 3 2 1 2 2 2 1 1 0 1 1 3 1 2 0 1 1 1 2
Humdogs 3 3 3 3 2 1 1 3 3 4 2 3 2 2 3 2 2 1 2 2 2 2 2
1/28/2019 2:25 PM
The only pair that used the same 5 teams is odalisgagne and Donburgh. They have similar records at 52-58 and 55-55, respectively.
1/28/2019 2:26 PM
Can connect each teams W-L record with their teams, then you can figure out which teams have the highest win%.
1/29/2019 9:38 PM
I think I am the only person that has a minimum of two identical teams with every other person. Does that mean I have the highest "cookie" score?

My 5 teams were selected a total of 61 times. Gotta think that's near the top.
1/29/2019 9:42 PM (edited)
Cookie Score in this case is the average amount of teams the owner shared with other owners (effectively their total amount of times selected - 5 from the owner himself)
Owner_________ "Cookie Score"
rbow923 2.4
schwarze 2.4
Humdogs 2.3
jmissirlis 2.2
mildnhazy 2.1
brianjw 2.0
ozomatli 2.0
discodemo 1.9
redcped 1.9
Donburgh 1.9
wink0094 1.9
odalisgagne 1.9
newarkwilder 1.8
magicdreamer 1.8
mpitt76 1.8
justinlee_24 1.8
ejstockman 1.8
mdc2276 1.7
jbohrman 1.7
jfranco77 1.7
dougpalm 1.6
buddhagamer 1.5
Jdh34 1.5
crystalao 1.1
1/30/2019 9:00 PM
There is no real dominant team choice, which is probably expected in this format
Franchise___ Times Used___ Avg Wins
Nationals 1 63
Reds 1 63
Orioles 2 62
Cardinals 13 61
Giants 11 60
White Sox 2 60
Pirates 7 59
Indians 9 59
Athletics 9 58
Dodgers 16 58
Astros 6 57
Red Sox 11 57
Braves 7 57
Tigers 4 57
Yankees 12 56
Twins 2 56
Cubs 3 54
Padres 2 53
Mariners 1 52
Blue Jays 1 46
1/30/2019 9:07 PM
Round 2 90M Roster Analysis, 2018 Topic

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2025 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.