140M Teammate Draft, 2019 Topic

dippedncrack
Posts: 5170 (0)
Hall of Famer
447 2 1
Rookie
Tony Peña
10/27/2019 12:02 AM
brianjw
Posts: 1260 (0)
Hall of Famer
292
Veteran
Posted by schwarze on 10/26/2019 9:49:00 PM (view original):
If there aren't enough high salaried players in this theme and most teams won't get close to 140M (without wasting salary on innings or expensive pinch hitters), then the few people who are lucky enough to randomly draw an early pick have a huge advantage. Not sure that was the intention of this league. Maybe you could at least align the division alignment based on team salary.
Or just by draft order.
10/27/2019 9:23 AM
This post has a rating of , which is below the default threshold.
Show
redcped
Posts: 7474 (3)
Hall of Famer
621
Pro
Posted by ozomatli on 10/26/2019 9:16:00 PM (view original):
After dippedncrack makes his pick, I will post a list of eligible teams and players. Also, I need two volunteers to help generate the random draft order for Round 1. Please sitemail me if you can help.

Remember that we will be off the clock until next weekend but, once we have the draft order, the draft can begin
Just a list of names and seasons? I started trying to build a spreadsheet but it’s really a slow process.
10/27/2019 12:12 PM
wink0094
Posts: 310 (0)
Hall of Famer
331 6 4
Rookie
Posted by redcped on 10/27/2019 12:12:00 PM (view original):
Posted by ozomatli on 10/26/2019 9:16:00 PM (view original):
After dippedncrack makes his pick, I will post a list of eligible teams and players. Also, I need two volunteers to help generate the random draft order for Round 1. Please sitemail me if you can help.

Remember that we will be off the clock until next weekend but, once we have the draft order, the draft can begin
Just a list of names and seasons? I started trying to build a spreadsheet but it’s really a slow process.
If you're doing it manually, it will indeed take forever. There's 399 eligible teams. I was surprised to see only 31 teams nominated twice.
10/27/2019 1:05 PM
daddyzander
Posts: 1560 (0)
Hall of Famer
306
Rookie
I’ll volunteer to randomize whatever it is you need as well.
10/27/2019 5:28 PM
redcped
Posts: 7474 (3)
Hall of Famer
621
Pro
Posted by wink0094 on 10/27/2019 1:05:00 PM (view original):
Posted by redcped on 10/27/2019 12:12:00 PM (view original):
Posted by ozomatli on 10/26/2019 9:16:00 PM (view original):
After dippedncrack makes his pick, I will post a list of eligible teams and players. Also, I need two volunteers to help generate the random draft order for Round 1. Please sitemail me if you can help.

Remember that we will be off the clock until next weekend but, once we have the draft order, the draft can begin
Just a list of names and seasons? I started trying to build a spreadsheet but it’s really a slow process.
If you're doing it manually, it will indeed take forever. There's 399 eligible teams. I was surprised to see only 31 teams nominated twice.
Is there a way not to do it manually?
10/27/2019 7:38 PM
wink0094
Posts: 310 (0)
Hall of Famer
331 6 4
Rookie
Posted by redcped on 10/27/2019 7:38:00 PM (view original):
Posted by wink0094 on 10/27/2019 1:05:00 PM (view original):
Posted by redcped on 10/27/2019 12:12:00 PM (view original):
Posted by ozomatli on 10/26/2019 9:16:00 PM (view original):
After dippedncrack makes his pick, I will post a list of eligible teams and players. Also, I need two volunteers to help generate the random draft order for Round 1. Please sitemail me if you can help.

Remember that we will be off the clock until next weekend but, once we have the draft order, the draft can begin
Just a list of names and seasons? I started trying to build a spreadsheet but it’s really a slow process.
If you're doing it manually, it will indeed take forever. There's 399 eligible teams. I was surprised to see only 31 teams nominated twice.
Is there a way not to do it manually?
Of course. With the WIS hitter and pitches salaries databases and excel, you can build a spreadsheet in under an hour with all the draft eligible players. A couple lookups and a pivot table is all that's required.
10/27/2019 8:08 PM
redcped
Posts: 7474 (3)
Hall of Famer
621
Pro
I don’t know how to use pivot tables.
10/27/2019 8:42 PM
redcped
Posts: 7474 (3)
Hall of Famer
621
Pro
Well it occurs to me it would be faster to learn pivot tables than keep pasting like I started doing. Anyone know if they work with Google Sheets? I keep my WIS files in there so I can draft from anywhere.
10/27/2019 10:03 PM
BigScungil
Posts: 240 (0)
Hall of Famer
137
Prospect
Posted by wink0094 on 10/27/2019 8:08:00 PM (view original):
Posted by redcped on 10/27/2019 7:38:00 PM (view original):
Posted by wink0094 on 10/27/2019 1:05:00 PM (view original):
Posted by redcped on 10/27/2019 12:12:00 PM (view original):
Posted by ozomatli on 10/26/2019 9:16:00 PM (view original):
After dippedncrack makes his pick, I will post a list of eligible teams and players. Also, I need two volunteers to help generate the random draft order for Round 1. Please sitemail me if you can help.

Remember that we will be off the clock until next weekend but, once we have the draft order, the draft can begin
Just a list of names and seasons? I started trying to build a spreadsheet but it’s really a slow process.
If you're doing it manually, it will indeed take forever. There's 399 eligible teams. I was surprised to see only 31 teams nominated twice.
Is there a way not to do it manually?
Of course. With the WIS hitter and pitches salaries databases and excel, you can build a spreadsheet in under an hour with all the draft eligible players. A couple lookups and a pivot table is all that's required.
I think you can combine Ozo's data with the 2019 spreadsheets provided by WIS using a query. The query allows you to link common fields like names and years. You should be able to merge the 2 data sets and exclude unwanted years and player combinations. This will get you 90% there.
10/28/2019 8:42 AM
BigScungil
Posts: 240 (0)
Hall of Famer
137
Prospect
Thinking aloud here. Can we use the 25th pick as a wild card pick? Say we can draft any player not on the blacklist or linked to a blacklisted player or something like that. This may help us reach the 140M salary and help adjust for goofiness associated with the order of GM draft order.
10/28/2019 8:48 AM
odalisgagne
Posts: 11879 (0)
Hall of Famer
1397 7 7
Veteran
Posted by redcped on 10/27/2019 10:03:00 PM (view original):
Well it occurs to me it would be faster to learn pivot tables than keep pasting like I started doing. Anyone know if they work with Google Sheets? I keep my WIS files in there so I can draft from anywhere.
Just make sure not to switch pivot tables once you establish your first pivot table. That's traveling.
10/28/2019 12:10 PM
ozomatli
Posts: 10694 (0)
Hall of Famer
1108 1 1
Veteran
Posted by daddyzander on 10/27/2019 5:28:00 PM (view original):
I’ll volunteer to randomize whatever it is you need as well.
Still need one more volunteer
10/28/2019 1:25 PM
ozomatli
Posts: 10694 (0)
Hall of Famer
1108 1 1
Veteran
Posted by BigScungil on 10/28/2019 8:48:00 AM (view original):
Thinking aloud here. Can we use the 25th pick as a wild card pick? Say we can draft any player not on the blacklist or linked to a blacklisted player or something like that. This may help us reach the 140M salary and help adjust for goofiness associated with the order of GM draft order.
Not changing the rules at this point, sorry.
10/28/2019 1:26 PM
◂ Prev 1...7|8|9|10|11...92 Next ▸
140M Teammate Draft, 2019 Topic
△Top△Bottom

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.