New madden ratings (Madden 13)

sportznut
Posts: 1159
Joined: Wed Jul 11, 2007 5:09 pm

Re: New madden ratings (Madden 13)

Post by sportznut »

Ben C. wrote:
lucky7jc wrote:I thought you guys might want a sortable chart broken down by position. All the numbers and letters tend to run together when looking at it all at once. The only problem is no matter what extension I try to upload it in, it tells me that it's not allowed.

Any advice?
You can already do this using the excel sheet provided by EA. Just use the sort/filter functions in your spreadsheet software.
Yep. Already done.
AFFL- Raiders
MLBSA- Tigers
WLSB- Marlins
lucky7jc
Posts: 163
Joined: Wed Aug 08, 2007 10:01 pm
Location: Tennessee

Re: New madden ratings (Madden 13)

Post by lucky7jc »

Unless I am missing something, that sheet only allows me to expand by sorting the column of my choice. So yes I could sort by position, but then the overall grade is mixed up. I consider myself pretty savvy w/ Excel spreadsheets too being that's all we work with. Now I'm only using OpenOffice on this computer, so that may be it. But.... nevertheless, I created my own booklet w/ the positions on their own page, and then allows you to sort based on whatever row.
AFFL Champion - 2019
AFC Champion - 2019
Ben C.
Posts: 1040
Joined: Thu Sep 20, 2007 4:27 pm
Location: Chicago, IL

Re: New madden ratings (Madden 13)

Post by Ben C. »

lucky: Here's how to sort and filter using openoffice - http://openoffice.blogs.com/bookresourc ... tering.pdf

I don't use that program (I use google docs or excel), but usually the trick when using a quick sort button is to select a single cell or the entire table before clicking the sort button. If you select a column and then hit sort, it will only sort that column.

Also, auto-filter is an incredibly useful tool in spreadsheets. Once you have your auto-filter set up, you can use drop downs from each header cell to select what you want to display, or to sort by that column's data.
AFFL Arizona - General Manager
Regular Season Record - 174-66-1
Playoff Record - 13-12
AFFL Bowl Record - 0-2

2x NFC Champions - 2010, 2016
11x NFC West Champions - 2007-12, 2014-15, 2017-18, 2021
AFFL History
RyanM
Posts: 336
Joined: Wed Aug 01, 2007 10:33 pm

Re: New madden ratings (Madden 13)

Post by RyanM »

Okay, I somewhat understand Mike Peterson not having a grade as he was just signed July 23. Gary Brackett hasn't signed anywhere yet, so I get no grade on him (he should have one as he's likely to sign once injuries happen). But how the hell does Ovie Mughelli not get a rating?
Ryan McKnight
Seattle GM - AFFL
Seattle GM - EFFL
Ben C.
Posts: 1040
Joined: Thu Sep 20, 2007 4:27 pm
Location: Chicago, IL

Re: New madden ratings (Madden 13)

Post by Ben C. »

RyanM wrote:Okay, I somewhat understand Mike Peterson not having a grade as he was just signed July 23. Gary Brackett hasn't signed anywhere yet, so I get no grade on him (he should have one as he's likely to sign once injuries happen). But how the hell does Ovie Mughelli not get a rating?
Mughelli was just signed at the end of July by the Rams. So it was probably after these ratings were finalized. I expect a number of changes in the first week update.
AFFL Arizona - General Manager
Regular Season Record - 174-66-1
Playoff Record - 13-12
AFFL Bowl Record - 0-2

2x NFC Champions - 2010, 2016
11x NFC West Champions - 2007-12, 2014-15, 2017-18, 2021
AFFL History
Adam K
Posts: 300
Joined: Tue Aug 28, 2007 9:07 pm

Re: New madden ratings (Madden 13)

Post by Adam K »

Ben C. wrote:
RyanM wrote:Okay, I somewhat understand Mike Peterson not having a grade as he was just signed July 23. Gary Brackett hasn't signed anywhere yet, so I get no grade on him (he should have one as he's likely to sign once injuries happen). But how the hell does Ovie Mughelli not get a rating?
Mughelli was just signed at the end of July by the Rams. So it was probably after these ratings were finalized. I expect a number of changes in the first week update.
I have noticed a few others missing. My advice is to hold onto any player that wasn't rated that you want. I assume you should be able to guess what the rating will be.
RebelFan
Posts: 469
Joined: Fri Apr 10, 2009 5:01 pm
Location: MS

Re: New madden ratings (Madden 13)

Post by RebelFan »

Got the game today & updated the roster through EA.
Austin Howard is a 61 & aubrayo franklin - 82.
Those were the only ones I was concerned with, but I can look up someone if you have any questions.
GM - Chicago Bears - AFFL
GM - San Francisco 49ers - DFFL

"Talent Hoarder"
Adam K
Posts: 300
Joined: Tue Aug 28, 2007 9:07 pm

Re: New madden ratings (Madden 13)

Post by Adam K »

RebelFan wrote:Got the game today & updated the roster through EA.
Austin Howard is a 61 & aubrayo franklin - 82.
Those were the only ones I was concerned with, but I can look up someone if you have any questions.
I need grades for Max Starks, Chris Cocker and Jim Leonhard – are they listed as FAs in the game?
RebelFan
Posts: 469
Joined: Fri Apr 10, 2009 5:01 pm
Location: MS

Re: New madden ratings (Madden 13)

Post by RebelFan »

Adam K wrote:
RebelFan wrote:Got the game today & updated the roster through EA.
Austin Howard is a 61 & aubrayo franklin - 82.
Those were the only ones I was concerned with, but I can look up someone if you have any questions.
I need grades for Max Starks, Chris Cocker and Jim Leonhard – are they listed as FAs in the game?
After the initial update Starks is with the Steelers (78) & Leonhard is listed with Broncos (79). Not sure about Crocker. Didn't see him in the free agent pool. Is he with a team this year?
GM - Chicago Bears - AFFL
GM - San Francisco 49ers - DFFL

"Talent Hoarder"
Adam K
Posts: 300
Joined: Tue Aug 28, 2007 9:07 pm

Re: New madden ratings (Madden 13)

Post by Adam K »

RebelFan wrote:
Adam K wrote:
RebelFan wrote:Got the game today & updated the roster through EA.
Austin Howard is a 61 & aubrayo franklin - 82.
Those were the only ones I was concerned with, but I can look up someone if you have any questions.
I need grades for Max Starks, Chris Cocker and Jim Leonhard – are they listed as FAs in the game?
After the initial update Starks is with the Steelers (78) & Leonhard is listed with Broncos (79). Not sure about Crocker. Didn't see him in the free agent pool. Is he with a team this year?
Thank you! Crocker, I don't believe is one a team this season. I appreciate the Starks and Leonhard updates.
Post Reply