#OSFM 17: Chicago Cubs World Series Champions

[trackstar121388]

Quote: Originally Posted by Figment

I'll just end up editing him myself. If anyone is interested I have a spreadsheet that I work on every year that has every player on the team and their ratings from The Show 14, 15, 16, and 17 to start and end the season and/or their OSFM ratings if they were included in those rosters as well. It's great for editing players that you believe have been rating incorrectly and want to edit them. I should have it done by the end of the weekend if anyone is interested.

I'm interested. I feel like they really underrated some of the cubs defensives ratings too.

[Figment]

Quote: Originally Posted by trackstar121388

I'm interested. I feel like they really underrated some of the cubs defensives ratings too.

I just finished updating the excel file I was telling you about. The players are separated by position tabs at the bottom. It has at least the beginning and end of season ratings for each player whether it was for OSFM or SCEA. Each player has listed the high, low, median, and average rating of every attribute plus another formula that averages out all of those:

(((High+Low)/2)+Median+average)/3=Some combination of all of these.

I use this to re-rate any players on the roster who I feel deserves to have their ratings changed. I hope it helps, if enough people like it enough I may just turn it in to a working google sheets so everyone can see and use it any time.

[trackstar121388]

Quote: Originally Posted by Figment

I just finished updating the excel file I was telling you about. The players are separated by position tabs at the bottom. It has at least the beginning and end of season ratings for each player whether it was for OSFM or SCEA. Each player has listed the high, low, median, and average rating of every attribute plus another formula that averages out all of those: (((High+Low)/2)+Median+average)/3=Some combination of all of these. I use this to re-rate any players on the roster who I feel deserves to have their ratings changed. I hope it helps, if enough people like it enough I may just turn it in to a working google sheets so everyone can see and use it any time.

Wow, sounds like you put in a lot of work. I'm having trouble opening it though

[Figment]

Quote: Originally Posted by trackstar121388

Wow, sounds like you put in a lot of work. I'm having trouble opening it though

I've been doing this excel sheet probably for close to the last ten years, I get bothered by bad ratings, but I also don't think I know enough to make ratings changes myself, so I use this.

Sounds like a dumb question, but did you decompress the file? It is compressed as a .rar so it's file size will be small enough. Use winrar or winzip to open it.

[trackstar121388]

Quote: Originally Posted by Figment

I've been doing this excel sheet probably for close to the last ten years, I get bothered by bad ratings, but I also don't think I know enough to make ratings changes myself, so I use this. Sounds like a dumb question, but did you decompress the file? It is compressed as a .rar so it's file size will be small enough. Use winrar or winzip to open it.

You know I didn't even realize it was a zipped file thank you for point that out.

[trackstar121388]

Quote: Originally Posted by Figment

I just finished updating the excel file I was telling you about. The players are separated by position tabs at the bottom. It has at least the beginning and end of season ratings for each player whether it was for OSFM or SCEA. Each player has listed the high, low, median, and average rating of every attribute plus another formula that averages out all of those: (((High+Low)/2)+Median+average)/3=Some combination of all of these. I use this to re-rate any players on the roster who I feel deserves to have their ratings changed. I hope it helps, if enough people like it enough I may just turn it in to a working google sheets so everyone can see and use it any time.

Are you going to be altering Baez's defensive ratings more than in your sheet? Since most consider him the top defensive second baseman and some even think he's one of the top defenders in the league

[Figment]

Quote: Originally Posted by trackstar121388

Are you going to be altering Baez's defensive ratings more than in your sheet? Since most consider him the top defensive second baseman and some even think he's one of the top defenders in the league

Yeah, he is the main person that I can't really give him an update to because he is already at his max. What I did with him last year was just gave him a 20% increase of his fielding and reaction ratings, I'll also probably update his base running and stealing.

[trackstar121388]

Quote: Originally Posted by Figment

Yeah, he is the main person that I can't really give him an update to because he is already at his max. What I did with him last year was just gave him a 20% increase of his fielding and reaction ratings, I'll also probably update his base running and stealing.

That makes sense. So just multiplying his reaction and fielding by .2 then adding that many points. Do you use Jros22's updated speed ratings? He has Beaz at a 74 in speed.