|
|
Post by CSCommish on Dec 18, 2022 13:37:44 GMT -5
docs.google.com/spreadsheets/d/1ZQT4_-7Vwt0T7bs9uMqVuFX30zjQgGgl/edit?usp=sharing&ouid=112875789398995973502&rtpof=true&sd=trueThis is the master file we've been working with --- I have 2 spreadsheets. The first spreadsheet (not shared) is a Ratings Generator where we import data from baseball-reference and a "row of data" is generated based on top 5 seasons, as well as other information (how many teams the player played with, etc.). Each row of data for each player is input into the second spreadsheet (shared, linked above). In that spreadsheet, on the right side, there are columns of formulas that display the primary position, character, batter, secondary and pitching ratings. This allows us to tweak the formula and the ratings would change for ALL of the players. We're hoping to use this to be able to rate players in advance, including re-rating players in prior seasons for whenever we do the restart league. Let us know your thoughts or ask questions on "how did you figure out a rating for..." Also looking for volunteers to start to look at the 2004 season, so that Matt doesn't have to do it all. In addition to using the first spreadsheet to add data to the second spreadsheet, we'll need help figuring out duplicates and add missing players. This will be more important as we get closer to 2012 and beyond (when the OOTP5 STATS database was created for when the league started back in 2013).
|
|
|
|
Post by CSCommish on Dec 18, 2022 15:01:24 GMT -5
Looks like the file no longer is asking for real players to import, so it has all fake players. We'll have to delete them all and then create players from scratch. Good thing we have the list...
|
|
Reddington
General Manager 
Atlanta Braves
Posts: 17,853 
|
Post by Reddington on Dec 19, 2022 7:23:12 GMT -5
Looks like the file no longer is asking for real players to import, so it has all fake players. We'll have to delete them all and then create players from scratch. Good thing we have the list... wouldn't it be easier to just adjust the fake players to real ones? |
|
|
|
Post by Boston Red Sox on Dec 19, 2022 9:17:39 GMT -5
Looks like the file no longer is asking for real players to import, so it has all fake players. We'll have to delete them all and then create players from scratch. Good thing we have the list... wouldn't it be easier to just adjust the fake players to real ones? this is probably the better way I think there's also a glitch for created players that fucks them up in spring training |
|
|
|
Post by CSCommish on Dec 19, 2022 12:26:47 GMT -5
wouldn't it be easier to just adjust the fake players to real ones? this is probably the better way I think there's also a glitch for created players that fucks them up in spring training You're right. I would change everyone to a DH, start making edits to existing players and move them to their correct positions. This will help us track the changes and not create players from scratch for the reasons break stated. A little trickier for pitchers but can make them all closers for now and go from there. Next question is how many players do we need. Obviously we need at least 90 for 3 full rounds. Do we do 120? 150? Not more than that i hope. |
|
greeme
General Manager
New York Mets
Posts: 843
|
Post by greeme on Dec 19, 2022 12:55:48 GMT -5
this is probably the better way I think there's also a glitch for created players that fucks them up in spring training You're right. I would change everyone to a DH, start making edits to existing players and move them to their correct positions. This will help us track the changes and not create players from scratch for the reasons break stated. A little trickier for pitchers but can make them all closers for now and go from there. Next question is how many players do we need. Obviously we need at least 90 for 3 full rounds. Do we do 120? 150? Not more than that i hope. 120 |
|
|
|
Post by Boston Red Sox on Dec 19, 2022 15:30:35 GMT -5
this is probably the better way I think there's also a glitch for created players that fucks them up in spring training You're right. I would change everyone to a DH, start making edits to existing players and move them to their correct positions. This will help us track the changes and not create players from scratch for the reasons break stated. A little trickier for pitchers but can make them all closers for now and go from there. Next question is how many players do we need. Obviously we need at least 90 for 3 full rounds. Do we do 120? 150? Not more than that i hope. I never did more than 120ish there are so many relievers you can dump from the draft |
|
Reddington
General Manager
Atlanta Braves
Posts: 17,853
|
Post by Reddington on Dec 19, 2022 15:56:13 GMT -5
You're right. I would change everyone to a DH, start making edits to existing players and move them to their correct positions. This will help us track the changes and not create players from scratch for the reasons break stated. A little trickier for pitchers but can make them all closers for now and go from there. Next question is how many players do we need. Obviously we need at least 90 for 3 full rounds. Do we do 120? 150? Not more than that i hope. 120 |
|
bub6708
Other 
Tampa Bay Devil Rays
Posts: 998
|
Post by bub6708 on Dec 21, 2022 1:23:15 GMT -5
We are close to 120. The color code is red already in game, blue didn't qualify on the spreadsheet, green is added to the list. In case people were wondering why the different colors. I double check on this with everyone. www.hoffbl.com/leaguesite/players.html |
|
Reddington
General Manager
Atlanta Braves
Posts: 17,853
|
Post by Reddington on Dec 22, 2022 21:11:37 GMT -5
what?
|
|
bub6708
Other
Tampa Bay Devil Rays
Posts: 998
|
Post by bub6708 on Dec 23, 2022 17:03:08 GMT -5
tell me you didn’t click the link in the Chris’ post without telling me you didn’t click the link. |
|
|
|
Post by marlinsgm on Dec 23, 2022 19:44:57 GMT -5
Some of the batters ratings seem to be low in the power department. Kemp specifically, maybe a few others??
|
|
|
|
Post by marlinsgm on Dec 24, 2022 10:48:25 GMT -5
OF Adam Jones should be much better defensively. He won 4 GG's in CF
|
|
bub6708
Other
Tampa Bay Devil Rays
Posts: 998
|
Post by bub6708 on Dec 24, 2022 11:25:47 GMT -5
OF Adam Jones should be much better defensively. He won 4 GG's in CF Agree with this. I sent Chris the file with batters. I think Chris said he will fix the top 5-10 from actual draft. Pitchers are really good this year if I remember right.. |
|
|
|
Post by marlinsgm on Dec 24, 2022 11:39:16 GMT -5
OF Adam Jones should be much better defensively. He won 4 GG's in CF Agree with this. I sent Chris the file with batters. I think Chris said he will fix the top 5-10 from actual draft. Pitchers are really good this year if I remember right.. King Felix then some mid to back of rotation guys. Some really good relievers |
|
bub6708
Other
Tampa Bay Devil Rays
Posts: 998
|
Post by bub6708 on Dec 24, 2022 11:57:20 GMT -5
Agree with this. I sent Chris the file with batters. I think Chris said he will fix the top 5-10 from actual draft. Pitchers are really good this year if I remember right.. King Felix then some mid to back of rotation guys. Some really good relievers Josh Johnson is good too - last check he was a Marlin  |
|
|
|
Post by CSCommish on Dec 27, 2022 8:16:22 GMT -5
So the batters are up; based on the spreadsheet we use for consistent rating, they are technically rated "correctly" but obviously not a great pool of talent. Please give feedback on the ratings, including which players to consider boosting due to a good 2-3 year run, stud marred by injuries, etc. Will want to have a couple 5, 4.5 star guys to make the draft pool reasonable, but note that pitchers should be very good.
|
|
dgfred
General Manager
Oakland A's
Posts: 927
|
Post by dgfred on Dec 27, 2022 9:26:04 GMT -5
I think Kinsler should be better hitting. Maybe even Markakis?
|
|
|
|
Post by marlinsgm on Dec 27, 2022 10:30:35 GMT -5
Matt Kemp averaged 25 HR/550 AB, including seasons of 28, 35 and 39. Pretty compelling argument for GOOD in HR's
Ian Kinsler hit a lot of doubles, averaged over 30/550 AB, 3 seasons with more than 40, he should be GOOD in doubles
Adam Jones CF defense rating should be much better than C. 4 time GG winner. Also his HR's could be bumped to GOOD. 4 times he hit more than 29 and 3 other times he hit between 25-27.
|
|
dougiejays
General Manager
Toronto Blue Jays
Posts: 4,350
|
Post by dougiejays on Dec 27, 2022 12:53:48 GMT -5
Gross. Kemp and Kinsler seem crazy low, but it seems like most of the guys in this class sort of flamed out after 3-4 good years.
|
|
dougiejays
General Manager
Toronto Blue Jays
Posts: 4,350
|
Post by dougiejays on Dec 27, 2022 12:56:32 GMT -5
Kinsler should definitely be better though. 14-yr career as an above-average hitter and fielder, and that's brought down by a few crappy years late. The only problem is that his "good" years were all over the map - some were OBP-driven, some were power-driven, he didn't really excel in one single skill. Still needs a few "good"s on there somewhere though.
|
|
bigmark
General Manager
Chicago White Sox
Posts: 6,176
|
Post by bigmark on Dec 27, 2022 13:55:23 GMT -5
Dionar Navarro is already in the league on my team
|
|
Bish
General Manager
Philadelphia Phillies
Posts: 3,271
|
Post by Bish on Dec 27, 2022 13:55:48 GMT -5
Lmao
|
|
Bish
General Manager
Philadelphia Phillies
Posts: 3,271
|
Post by Bish on Dec 27, 2022 13:59:58 GMT -5
When will y’all realize the system you use is garbage?
|
|
jahallstar
General Manager
Baltimore Orioles
Posts: 963
|
Post by jahallstar on Dec 27, 2022 14:13:13 GMT -5
Why is adam jones not at least good in hr .....at least b in cf if not a... at least c speed
4x gold glove
Peak 7 was like 29 hr a year...career like 25ish
|
|
