Re: The Game's Community Ratings Calculator
Any chance of getting this to work in Excel 2003?
Any chance of getting this to work in Excel 2003?
-
Re: The Game's Community Ratings Calculator
Try this: https://www.microsoft.com/en-us/down...ails.aspx?id=3
It's the compatibility pack for new versions of Office files.Comment
-
Re: The Game's Community Ratings Calculator
Bizarre. I'm sorry.
All I can say is there is a ridiculous amount of data in here that is having to pull up that maybe older versions of excel can't handle. Loads for me perfectly in about 3-5 seconds, so I'm unsure why it would be causing others so many issuesComment
-
Re: The Game's Community Ratings Calculator
I'd absolutely be up to check it out.
Here are my main issues I'm trying to address as efficiently as possible.
1. Get bulk data for MILB players for Batter LHP/RHP splits without needing to go team by team
2. Have a method to differentiate between two players of the same name when searching this batch data. Currently, I'm just having to search for duplicates and it's very time consuming. I could do by team, but there are some teams, including minors, with two players with the same name. I could use birthdate, but that is not always included on the stats page to match with the player. Same thing for position.
It's a complex problem. Any suggestions?Comment
-
Re: The Game's Community Ratings Calculator
The BP leaderboards is probably what you're looking for in regards to the first problem. The 2nd I can do my best to help with when you get there."Twelve at-bats is a pretty decent sample size." - Eric ByrnesComment
-
Re: The Game's Community Ratings Calculator
Awesome! Right now, the calc is simply setup where I have to manually look for duplicates, look at the stat page of each duplicate, and then give the name some differentiating value (their specific position in () like (RF)). It's tedious. Incredibly tedious. Honestly, it was the only point when developing this thing that made me furious. Developing the calculations, testing them, organizing the sheets, etc. were all enjoyable. The duplicates? Aaagggghhhh!!! Lol.
If you'd like me to send you an unlocked version of the calc, I'd be happy to. That way you can take a deeper look if you want.Comment
-
Re: The Game's Community Ratings Calculator
V2 has been uploaded.
Ratings calculations have been slightly fixed, as many players with wrong names have been changed as I could possibly find, WTNY's latest Pitch FX edits are included, and fielding and speed ratings have been updated based on stolen bases in each given year (but not entirely based on this) as well as Golden Glove and Fielding Bible Award winners.
Really hope this can spread in the community more. I can't think of an easier way to update rosters, even if you don't like my ratings. It still gives you correct height and weights according to their MLB.com page, almost 100% accurate contracts, accurate birthplaces for many players, pitch fx updates from WTNY, and of course my statistically based ratings.
Let me know if you have any trouble downloading. I used Google Drive this time.Comment
-
Re: The Game's Community Ratings Calculator
The Game, my belief is that a ratings calculator on average should not increase or decrease a players ratings. This way you can use the calculator for a team you wish to play as without giving yourself an advantage or disadvantage over SCEA teams, or having to rerate every team. Similarly you can adjust particular players you think are under rated/over rated without have to adjust every player. With that in mind, while I don't notice a net positive or negative with offensive stats, it does appear this is an issue with defensive stats. For example SCEA does not rate a single MLB player with arm strength less than 40, your calculator rates Ben Revere as a 4 in arm strength. I am not arguing that Ben Revere does not have a weak but it is not 40 points lower than coco crisps arm. I have found that the following formula actually does a good job of converting Fangraphs Defensive ratings to MLB the show ratings. If you want more information on how I developed it feel free to let me know: 0.583 x Rating + 41. The rating would be Fangraphs scouting report arm strength for arm strength, accuracy for accuracy and hands for fielding. (this does not work well with speed).Comment
-
Re: The Game's Community Ratings Calculator
Ok, I re-read your post for the third time, and some of it is at least making sense.
Your first statement is baffling to me though. SCEA stock ratings are notoriously pretty bad. I don't know if anyone has simmed any season, but they don't look that great. I've completed the Astros and Orioles and so far, stats look fantastic for those teams. There are always going to be bizarre things that happen in a given sim, but the rerate helps minimize this substantially.
As for your last statements, sounds interesting. I can always tweak the formula. When you say you are using Fangraphs Defensive Ratings, I'm assuming you mean their Fans Scouting Report. This is exactly what I'm using, and I could either put a minimum number on the arm strength, like 20 or something, or look at using a different formula, which I'm not opposed to.
I need you to flesh out your ideas a bit more and use paragraphs to break up the different topics. It helps with comprehending what you are trying to say.Last edited by TheGame8544; 06-04-2016, 03:41 PM.Comment
-
Re: The Game's Community Ratings Calculator
Perhaps, but new players are not going to come in (and develop) with rerate in mind, but SCEA ratings.
I'd like better sim stats, but ultimately since I'm playing a franchise for multiple seasons (including playing out games, not a sim-only franchise), keeping the roster "SCEA-ish" has importance for me.
I haven't seen Ben Revere (maybe he'd get a 4 in the version I have - I mostly use it for prospects, most of which are close from the ones I wanted to see), but I don't even want to know what a 4 throwing arm would look like in gameplay
"Some people call it butterflies, but to him, it probably feels like pterodactyls in his stomach." --Plesac in MLB18Comment
-
Re: The Game's Community Ratings Calculator
This line of thinking presupposes that the SCEA roster is even internally consistent with itself for drafted players. Remember in the past, their own system didn't jive with their own ratings and there was a mass increase in A potential prospects. The whole idea of Sony being some oracle of ratings is silly. Anyone with a decent quantitative background can duplicate or improve on what they do with ratings (and a few of us have actually).
As someone who's a proponent of re-rating players en masse (hence read this with my bias in mind) especially lesser known players who are way far off in the SCEA rosters, it's not so much about making everyone rated higher or lower, but it's about making them consistent versus each other. For example, you want the right player to have the right attribute rating; you aren't necessarily interested in moving the median rating up or down. In fact, I'd surmise (though I haven't looked at this calculator because I have my own) that most people who do decent re-ratings probably calibrate their ratings to about where Sony has their average rating for precisely this reason.Chicago Cubs | Chicago Bulls | Green Bay Packers | Michigan WolverinesComment
-
Re: The Game's Community Ratings Calculator
I am not saying that the SCEA stock ratings are great, I am merely stating that I don't want to go through and rerate every single team. If this where the case I would use the hybrid roster or in theory your roster when you post it. To me the benefit of a calculator is that it can be used to adjust a single team or specific players to realistic ratings without disadvantaging the players that are re-rated. Obviously individual players ratings will increase or decrease but on average I would like to see them stay the same.
You seem to feel differently, which I respect, and given that it is your calculator, I don't expect you to adjust it just for me.Comment
Comment