Announcement

Collapse
No announcement yet.

Week 12 Power Rankings from around the Editorial world*12/1*

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Week 12 Power Rankings from around the Editorial world*12/1*

    ***UPDATED 12/01/04 8:50 PM EST***

    I keep these updated every week, just for my own enjoyment. And I present them to you all for your enjoyment.

    What:
    Its in an excel document. Its the power rankings in a nice excel document without the need to visit all 10 of these sites individually to get the power rankings from the site. Hey, its easier to compare that way, right? They are all listed side by side. I would make it an HTM but for some reason the borders around the boxes become crooked due to the inclusion of pictures (you will see). Besides the fact that the pictures seem to escalate the HTM to about three times the size of the XLS format.

    How:
    It was made using Microsoft Excel...using pictures from the ESPN power rankings ...those little 51x51 images of the NFL logos.

    Why:
    My brother once told me that he knew a site that did just this; List off all the power rankings from around the web in a nice viewable way. That site has since disappeared, and I thought to myself "Man i really hate going to ESPN, CNNSI, etc. and downloading all those crap ass adds just to read the opinions of a so called 'experts' with their little blobs which are usually negative towards the eagles anyway."

    Who:
    Heres the people I included:
    ESPN Staff Power Rankings
    Dr.Z's Power Rankings on CNNSI
    Pete Prisco's Power Rankings on SportsLine.com
    CBS Staff's Team Rankings available at SportsLine.com
    Vic Carucci's Power Poll on NFL.com (he only ranks 12 teams)
    The War Room's Power Rankings available on Fox Sports.com and Sporting News.com
    James Alder's Power Rankings available on About.com
    Jeff Sagarin's calculated Rankings on USAToday.com...his rankings are less opinionated, more of a performance base.
    The Commish's Rankings on AskTheCommish.com
    Brad Oremland on Sports-Central.org
    Staff here at Sportscolumn.com
    Averaged Troy Aikman's Defense/Offense Efficiency Ratings
    TSN.ca power rankings.


    I didnt want to include rankings from biased unknown people from newspapers. I know of rankings in the Boston globe and on some Minnesota Vikings site due to searches on google , but those are probably more biased than the ones i have listed...

    You will see a blank column for football.com...im still waiting for updated rankings on that site...
    You will also see a few pages in the book for Week 3 and 4 which of course arent out yet. Well the Week 3 is for this week and the week 4 i have for a template so i can make new copies of the base template.

    You will also see a column for Troy Aikman separate from the other 10 columns. Every week over at NFL.com, he posts these wacky ratings for defense and offense based on some equation that he came up with. He is pissed off with the NFL's means on ratings Defenses and Offenses (ratings by yards and points) so he has emailed the NFL and just for his own amusement he is doing his own ratings. So what I did was take the average of the two values he posted for each team's offense and defense, and arranged them high to low. The order of the teams are reflected in the excel document in that column .

    And here I present for you, exclusive to this forum only (maybe try to keep it that way?)...Power Rankings in an Excel Document:
    zipped up to save as much of the 1 GB im allotted in download quota on earthlink's free webserver
    http://home.earthlink.net/~tokar/rate.zip
    The file size is a tad under 75 KB

  • #2
    New Update just completed for Week 3.

    9/30/04 4:30 AM EST

    Comment


    • #3
      Tokar,

      Are you goign to include Sportscolumn?

      By the way, do you know HTML? Just translate that excel file into HTML and you can create a weekly column here. I think most people would be interested to see that info but don't want to download a potentially hazardous zip file.
      Support Sportscolumn.com! Tell a friend!

      Comment


      • #4
        i dont know HTML (i hate programming), but i know EXCEL does do automatic creation of HTML files from the content in an XLS document.

        Ive tried it with the XLS's i make but i find i run into 2 problems:
        1) the lines come out all crooked...i know its due to the pictures, but i cant figure out why. They are all aligned properly. Note: its like 80-85% of the lines come out fine...the other 15% are crooked.
        2) file size. All the pictures escalated the size of everything about 6 fold. Zipped up, the excel file is about 250 KB. In HTML, the excel file is like 1.2 MB.

        Comment


        • #5
          Originally posted by Fantasy Guru
          Tokar,

          Are you goign to include Sportscolumn?

          I didnt include it cause i didnt see Rankings from the 3 previous weeks.

          Comment


          • #6
            Originally posted by Tokar
            Originally posted by Fantasy Guru
            Tokar,

            Are you goign to include Sportscolumn?

            I didnt include it cause i didnt see Rankings from the 3 previous weeks.
            yeah, I just started doing it after week 3...
            Support Sportscolumn.com! Tell a friend!

            Comment


            • #7
              How the hell does Troy Aikman come up with his rankings....Steelers at #6...above the Pats?????
              Whatcha Gonna Do Brother, When the Eagles run wild on you?

              Comment


              • #8
                Originally posted by leifdawg
                How the hell does Troy Aikman come up with his rankings....Steelers at #6...above the Pats?????
                8 concussions.
                Support Sportscolumn.com! Tell a friend!

                Comment


                • #9
                  Originally posted by leifdawg
                  How the hell does Troy Aikman come up with his rankings....Steelers at #6...above the Pats?????
                  What the shit is that? The Pats are better than the Steelers in every way...

                  Comment


                  • #10
                    his ratings are on NFL.com


                    basically he calculates a defensive ranking and an offensive ranking on some equation cause he hates the NFL method of ranking offenses and defenses. It looks to me to be comparable to the QB Ranking equation.

                    I just took the value for each teams' defense and offense...anywhere from 50-110 depending on a lot of factors other than just yards and points...averaged them and organized by best values first.

                    I didnt put them next to the other 8 columns because they arent necessarily accurate .

                    Comment


                    • #11
                      ive been a little slow with the ratings...

                      aikman never put out his ratings for week 4...i waited until tonite and have seen nothing.

                      So i didnt get to add them

                      Sportscolumn's rankings are now included .

                      Updated: 10/09 9:20 PM

                      Comment


                      • #12
                        Ok all of week 5's power rankings are in.

                        I just added TSN.ca's rankings.
                        TSN is Canada's ESPN .

                        They say their power rankings are based of an equation, but it sure dont look it.

                        Ive made things a little clearer, separating the equation based ratings from the "opinion" based ratings.

                        Trpy Aikman, CBS Player Rankings and Jeff Sagarin's rankings are all equation based.

                        Updated: 10/14/04 7:26 PM EST

                        Comment


                        • #13
                          Alright all of week 6's rankings are in.

                          the file has been updated.

                          Updated: 10/22/04 1:45 AM EST

                          Comment


                          • #14
                            Week 8's rankings are now up in the file.

                            No, I didnt forget about Week 7. I was a little too busy too remember to make a post here to let people know Week 7's rankings were up. So I did in fact update the file...just a little silently .

                            Updated: 11/04/04 5:34 PM EST

                            Comment


                            • #15
                              Originally posted by leifdawg
                              How the hell does Troy Aikman come up with his rankings....Steelers at #6...above the Pats?????
                              Maybe Troy boy was on to something here....
                              Whatcha Gonna Do Brother, When the Eagles run wild on you?

                              Comment

                              Working...
                              X