Mattanite's M23 Roster Analysis Spreadsheet

[Mattanite]

Mattanite's Roster Analysis Spreadsheet

Teams - Provides insight into team roster strengths such as off and dev ove, breakdown of dev by team, ovr distribution, age by team, a place to assign team states and filter by promising youth. Features variable settings based on what you look for when choosing a team.

Ratings - Full madden 23 roster ratings with heat map of key ages, modernised automatic groupings and position filters, archetypes, Scoutscore/PhysScore/SkillScore values for each player and an upper and lower bound trade value based on the SMLE trade grid.

Grades - Turn all the ratings into grades based on a 90/80/70/60/50 thresholds and also turn all physical ratings into the M22 scouting style Elite to Poor.

OvrTeam - Display of the highest OVR at a position for every team as well as rank across the league.

OvrDist - This shows a distribution of the OVR and Dev of base rosters and my M22 10yr advance roster distribution on base XP sliders and base dev limits. You can change the XP sliders and dev limits to get a graphical estimate of how your roster distribution will change over 10 years.

Rook - Full list of all draftees by pick with their OVR, dev and Scoutscore/PhysScore values.

SP Arc Simple - My m21/22 XP predictor by player for a full team over 5 years. Enter the player, position, age and dev and it will estimate their OVR each season for 5 seasons as a starter.

Draft Value - The Jimmy Johnstone draft value chart in excel format with ability to change draft pick value by which season you're on (rookies worth less closer you are to ending).

Trade Grid - The SMLE trade grid in excel format so you can edit and capture the image for your own league.

Enjoy!

[Mattanite]

Trying to scrape but the M23 database didn't pull through on my data recipe, I've also got the data available via the api data source going into the online roster (which I can break and sort very easily) but it's limiting me to 65 players. If anyone has a link to a full roster sooner it could be easier/quicker.

[XtremeDunkz]

https://docs.google.com/spreadsheets...t?usp=drivesdk

Sent from my SM-G991U using Tapatalk

[Mattanite]

Quote: Originally Posted by XtremeDunkz

https://docs.google.com/spreadsheets...t?usp=drivesdk Sent from my SM-G991U using Tapatalk

That's exactly it! Thank you. Will crack on now!

[Mattanite]

First version of spreadsheet uploaded.

Missing items

Teams - Fullback adjusted roster ratings (teams without Fullbacks have a higher offense and team ovr than those without), Team States (fill your own in).

Roster - Dev for players (will update if information comes out soon enough).

OVRDist - Was a base 10yr class from M22, will need testing with M23.

[Mattanite]

Quick reupload (sorry to the 2 people who downloaded already), was missing the future 1st and 2nd Saints to Eagles trade in Teams.

[Mattanite]

Had some early feedback, version 1.02 uploaded.

• ScoutScore, PhysScore and SkillScore were not sortable due to same tab name Ratings! causing wrong line to feed into the scores. Now fixed.
• All grades are now sortable as they had a same tab name in formula causing formula to lock onto cells.
• Rookie OVR didn't have a heat map (updated tab name too, in case folks think we're playing chess...)
• Added some cell formatting to help viewing.
• Changed SmallSpeedRusher archetype to SpeedRusher in line with M23 archetypes.

[Mattanite]

Update 1.02.01

• Added X-Factor and Superstar
• Changed all remaining players >85ovr to star (will update later)
• Changed Top16 drafted rookies to star (will update later)
• Added Julio Jones (95ovr Superstar) to Bucs based on M22 ratings
• Added some guide Team states (you may disagree)
• Fixed formula in OVRdist so OL and DE were working properly