The Reference League - Random Debut Historical - Page 2

quillenl · 06-23-2020, 04:00 PM

July 31st 54-52 5GB 4th Place
The team is 50-47 headed towards the trade deadline so time for some changes. I shop Zaza Harvey who I know I cannot sign and nab a catching prospect from the Twins. They are loaded on catchers, and this is their 4th best guy... but he is young, looks solid defensively, and should be able to hit at the Major League level. Has no negative personality traits that leave me concerned about the clubhouse. Buck Ewing's deterioration at th eage of 42 is the stuff of legends and we can't wait any longer.

I sign Don Padgett in Free Agency to fill in at Right the remainder of the season. He had a terrible season in 1901 as a bench player with only 103 at-bats... but he is an 8 Contact (scale of 1-10) hitter with solid ratings and an above-average arm that looks perfect for RF. His range is below average... but it is RF and I can live with it if his hitting catches up to his ratings. All that and he is a captain... the AI got this one wrong I think.

quillenl · 06-23-2020, 04:01 PM

September arrives and Pittsburgh is able to keep it close till the very end in a very tight 4 team race in the National League East. Ultimately the victory goes to the Montreal Expos, led by rookie Tim Flannery and All-Star pitcher 26 yr old Brad Radke, as the Pirates just don't have enough. Mid-Season Free Agent pickup Don Padgett was great hitting 303 with 7 homers in the second half. Young catcher Micky Owen brought on for his glove and game-calling ability batted 321 in the number 8 spot. The team struggled offensively with only one player managing double-digit home runs but was able to compete for a playoff spot to the very end thanks to the team's trademark of Pitching and Defense.

quillenl · 06-23-2020, 04:26 PM

Cleveland Defeats Houston: It was a hard-fought battle for both teams to make it this far. But as the saying goes, "to the victors go the spoils." For the victorious Cleveland Indians, that meant the Major League Baseball World Series trophy.

The Indians took a 7-5 victory over the Houston Astros at Astrodome, winning their 1st championship after taking the series 4-2.

"We've got grit," said Indians right fielder Fred Schulte, who was named MVP of the series. "We know how to win when we have to."

The new titleholders completed the regular season with a first-place finish in the AL East and a 92-70 record.

quillenl · 06-23-2020, 05:03 PM

I present the top 5 picks of the 1902 Amateur Draft

quillenl · 06-23-2020, 05:08 PM

I pick up Bump Hadley late in the 1st round. See that potential 8 curveball rating? That alone is keeping his stuff at 6 of 8. We are talking strikeouts here with that good a curveball. You combine that with high movement and a 9 for Hold Runners and he has the potential to be elite in a couple seasons.

The downside is he is greedy, lacks loyalty, and is completely antagonistic about taking a leadership role. I'm picking in the bottom of the first round, however, and I'm 100% looking at potential.

quillenl · 06-23-2020, 07:09 PM

Signed Free Agent SS John Valentin. Have the budget room due to several guys not being resigned. He has the glove, he has a bat, and he's a great clubhouse presence. He is 33 and was willing to sign for only a 2 year deal so it's a win. Offense was a sore point in the past that this will go a long way towards addressing.

Zaza is gone, and nice a half season as Don Padgett had he was 35. I pick up 31 year old Jason Werth for 3 seasons at 6 million each. He's a great fielder who sported a .334 WOBA. He is solid if not spectacular but can capably start for the next few seasons and add some consistency.

28 yr old Phil Mankowski is signed for 4 years at 5 mil each with the last two team options. Another great fielder who just gets by with the bat. Getting a little younger while hoefully staying competitive.

Charlie Case is a 22 year old closer who signs for 1.5 mil per year over 5. He is a high risk pick, but the cost is low and I have the budget room. He has no pro experience at this time and could potentially be dead weight in a couple seasons. No risk, no reward.

1903 is about to begin. Only 1 of my players (Lefty Chambers) appears in the top 10 on the Preseason Predictions and I am predicted for 85 wins and a 3rd place finish. A chance to overachieve... just the way I like it

quillenl · 07-11-2020, 03:17 PM

While this was fun, I have been distracted by the discovery that I can have a 60 round draft using historical players with enough to last 100 seasons. I am now busily cleaning up the 145K+ player database to make it easy to generate the player lists for draft import.

A historical random debut league with 4 (or more) levels of full minors, and players drafted when they started in the minors (vice fully developed). And all without having to onesies and twosies players with the import tool.'

This could keep me busy a while

luckymann · 07-13-2020, 11:43 AM

Quote:

Originally Posted by quillenl

While this was fun, I have been distracted by the discovery that I can have a 60 round draft using historical players with enough to last 100 seasons. I am now busily cleaning up the 145K+ player database to make it easy to generate the player lists for draft import.

A historical random debut league with 4 (or more) levels of full minors, and players drafted when they started in the minors (vice fully developed). And all without having to onesies and twosies players with the import tool.'

This could keep me busy a while

Would you mind explaining the process you are using to do this? Sounds like a winner to me!!

quillenl · 07-13-2020, 02:11 PM

No problem at all, and about to get better (fyi) based on Markus saying a terrible bug/mechanix may be fixed/changed in the next patch.

Important game mechanics...

1) There are two files with their own associated spreadsheets used for importing players. You have Master.csv which references the historical_database.odb and MiLBMaster.csv which references historical_minor_databse.odb. The former consists only of players who reached the Majors and has less than 20K players in it. The latter is a MUCH larger list of players who have stats in the Minors at some point or another This file has over 100K players in it. Most (but not all) players from the first database are in the Minor League database.

2) I make myself a third file that merges these two files into one. I do this so that can include players with no minor league experience. The standard historical file includes debut year for the year they made their debut in the Major Leagues. This year determines the age at which they generate when you use their standard player id. The debut year in the Minor League database is the year at which their first Minor League stats appear. If a player is pulled from there then their age is determined from that value instead. By combining the files I can force the import for MLB players to come from the Minor League database... though this will not be necessary shortly following the next patch if Markus is correct. This large file's first two fields are player id and debut year... so I can always copy and paste any group of players I have filtered out into a 2 field importable file of as many players as I desire.

3) The player import feature can import players via a 2 field CSV file where the first field is player id and the second year is their debut year. By randomizing the players into 100 groups I end up with 100 files I can import that consist of 1400+ real players each. I delete a draft class when it is generated, and replace it with the players in one of these files via the Player import tool. That tool can be found on the drop down menu of the Free Agents screen.

Right now, I am waiting till next patch to rebuild my draft files. If the patch fixes a previous issue, then each of these files will generate players at 18 or 19 when they are pulled into the draft pool

All you do to make this happen is change their debut year in the file to the year they turned 18.

I skipped a lot fo steps and probably made it sound more complicated than it is. The hardest part, honestly, is making files that are clean and as evenly spread out for talent as possible. Everything else is cake after you do it the first time.

luckymann · 07-13-2020, 10:43 PM

Thanks so much for that, I'll wait for that patch before doing anything and then have a play around to see if it works for my Footnote League. As the name suggests, this league bypasses all the superstars to give the lesser lights their time in the sun. But obviously the OOTP engine doesn't know that so I have to sift through the incoming players to get rid of all big names, which is a bit tedious. So any way to clean that process up would be fantastic.

Much obliged, good luck with your Pirates - I'll be following the action!

06-23-2020, 04:00 PM	#21
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	1902 Trade Deadline July 31st 54-52 5GB 4th Place The team is 50-47 headed towards the trade deadline so time for some changes. I shop Zaza Harvey who I know I cannot sign and nab a catching prospect from the Twins. They are loaded on catchers, and this is their 4th best guy... but he is young, looks solid defensively, and should be able to hit at the Major League level. Has no negative personality traits that leave me concerned about the clubhouse. Buck Ewing's deterioration at th eage of 42 is the stuff of legends and we can't wait any longer. I sign Don Padgett in Free Agency to fill in at Right the remainder of the season. He had a terrible season in 1901 as a bench player with only 103 at-bats... but he is an 8 Contact (scale of 1-10) hitter with solid ratings and an above-average arm that looks perfect for RF. His range is below average... but it is RF and I can live with it if his hitting catches up to his ratings. All that and he is a captain... the AI got this one wrong I think. __________________

06-23-2020, 04:01 PM	#22
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	September arrives and Pittsburgh is able to keep it close till the very end in a very tight 4 team race in the National League East. Ultimately the victory goes to the Montreal Expos, led by rookie Tim Flannery and All-Star pitcher 26 yr old Brad Radke, as the Pirates just don't have enough. Mid-Season Free Agent pickup Don Padgett was great hitting 303 with 7 homers in the second half. Young catcher Micky Owen brought on for his glove and game-calling ability batted 321 in the number 8 spot. The team struggled offensively with only one player managing double-digit home runs but was able to compete for a playoff spot to the very end thanks to the team's trademark of Pitching and Defense. Attached Images __________________

06-23-2020, 04:26 PM	#23
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	Cleveland over Houston 4 games to 2 Cleveland Defeats Houston: It was a hard-fought battle for both teams to make it this far. But as the saying goes, "to the victors go the spoils." For the victorious Cleveland Indians, that meant the Major League Baseball World Series trophy. The Indians took a 7-5 victory over the Houston Astros at Astrodome, winning their 1st championship after taking the series 4-2. "We've got grit," said Indians right fielder Fred Schulte, who was named MVP of the series. "We know how to win when we have to." The new titleholders completed the regular season with a first-place finish in the AL East and a 92-70 record. Attached Images __________________

06-23-2020, 05:03 PM	#24
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	1902 Offseason Draft I present the top 5 picks of the 1902 Amateur Draft Attached Images __________________

06-23-2020, 05:08 PM	#25
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	I pick up Bump Hadley late in the 1st round. See that potential 8 curveball rating? That alone is keeping his stuff at 6 of 8. We are talking strikeouts here with that good a curveball. You combine that with high movement and a 9 for Hold Runners and he has the potential to be elite in a couple seasons. The downside is he is greedy, lacks loyalty, and is completely antagonistic about taking a leadership role. I'm picking in the bottom of the first round, however, and I'm 100% looking at potential. Attached Images __________________

06-23-2020, 07:09 PM	#26
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	1903 Season Start Signed Free Agent SS John Valentin. Have the budget room due to several guys not being resigned. He has the glove, he has a bat, and he's a great clubhouse presence. He is 33 and was willing to sign for only a 2 year deal so it's a win. Offense was a sore point in the past that this will go a long way towards addressing. Zaza is gone, and nice a half season as Don Padgett had he was 35. I pick up 31 year old Jason Werth for 3 seasons at 6 million each. He's a great fielder who sported a .334 WOBA. He is solid if not spectacular but can capably start for the next few seasons and add some consistency. 28 yr old Phil Mankowski is signed for 4 years at 5 mil each with the last two team options. Another great fielder who just gets by with the bat. Getting a little younger while hoefully staying competitive. Charlie Case is a 22 year old closer who signs for 1.5 mil per year over 5. He is a high risk pick, but the cost is low and I have the budget room. He has no pro experience at this time and could potentially be dead weight in a couple seasons. No risk, no reward. 1903 is about to begin. Only 1 of my players (Lefty Chambers) appears in the top 10 on the Preseason Predictions and I am predicted for 85 wins and a 3rd place finish. A chance to overachieve... just the way I like it Attached Images __________________

07-11-2020, 03:17 PM	#27
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	While this was fun, I have been distracted by the discovery that I can have a 60 round draft using historical players with enough to last 100 seasons. I am now busily cleaning up the 145K+ player database to make it easy to generate the player lists for draft import. A historical random debut league with 4 (or more) levels of full minors, and players drafted when they started in the minors (vice fully developed). And all without having to onesies and twosies players with the import tool.' This could keep me busy a while __________________

07-13-2020, 02:11 PM	#29
quillenl All Star Reserve Join Date: Apr 2015 Posts: 581	No problem at all, and about to get better (fyi) based on Markus saying a terrible bug/mechanix may be fixed/changed in the next patch. Important game mechanics... 1) There are two files with their own associated spreadsheets used for importing players. You have Master.csv which references the historical_database.odb and MiLBMaster.csv which references historical_minor_databse.odb. The former consists only of players who reached the Majors and has less than 20K players in it. The latter is a MUCH larger list of players who have stats in the Minors at some point or another This file has over 100K players in it. Most (but not all) players from the first database are in the Minor League database. 2) I make myself a third file that merges these two files into one. I do this so that can include players with no minor league experience. The standard historical file includes debut year for the year they made their debut in the Major Leagues. This year determines the age at which they generate when you use their standard player id. The debut year in the Minor League database is the year at which their first Minor League stats appear. If a player is pulled from there then their age is determined from that value instead. By combining the files I can force the import for MLB players to come from the Minor League database... though this will not be necessary shortly following the next patch if Markus is correct. This large file's first two fields are player id and debut year... so I can always copy and paste any group of players I have filtered out into a 2 field importable file of as many players as I desire. 3) The player import feature can import players via a 2 field CSV file where the first field is player id and the second year is their debut year. By randomizing the players into 100 groups I end up with 100 files I can import that consist of 1400+ real players each. I delete a draft class when it is generated, and replace it with the players in one of these files via the Player import tool. That tool can be found on the drop down menu of the Free Agents screen. Right now, I am waiting till next patch to rebuild my draft files. If the patch fixes a previous issue, then each of these files will generate players at 18 or 19 when they are pulled into the draft pool All you do to make this happen is change their debut year in the file to the year they turned 18. I skipped a lot fo steps and probably made it sound more complicated than it is. The hardest part, honestly, is making files that are clean and as evenly spread out for talent as possible. Everything else is cake after you do it the first time. __________________ Last edited by quillenl; 07-14-2020 at 07:30 AM.

07-13-2020, 10:43 PM	#30
luckymann Hall Of Famer Join Date: Nov 2019 Posts: 13,434	Thanks so much for that, I'll wait for that patch before doing anything and then have a play around to see if it works for my Footnote League. As the name suggests, this league bypasses all the superstars to give the lesser lights their time in the sun. But obviously the OOTP engine doesn't know that so I have to sift through the incoming players to get rid of all big names, which is a bit tedious. So any way to clean that process up would be fantastic. Much obliged, good luck with your Pirates - I'll be following the action!