Welcome to FearlessFriday.com! Today is Wednesday, December 12th, 2018.
With a 3-0 weekend, kk2 comes from behind to win the Pick'em championship. kk2 292 ISU7 291 Coach Jones 291 RamblinWest 290 hill
Fearless Friday
Championship Capsules Posted

Author Topic: HS Football Rankings Spreadsheet  (Read 748 times)

0 Members and 1 Guest are viewing this topic.

Offline vintagemustang

  • Band Nerd
  • *
  • Posts: 4
  • Karma: +1/-0
  • Fearless Friday--The Online Home of Arkansas High School Sports!
HS Football Rankings Spreadsheet
« on: October 23, 2017, 09:03:55 pm »
I just started a spreadsheet with the goal of ranking all of Arkansas's high school football teams across all classifications. I would love for some of you to peruse it and provide some feedback to improve its overall usefulness. I have inputted all of the schedules and scores for all 7A, 6A, and 5A teams and am about to begin on 4A teams. I used several metrics that I came up with to try to create a ranking system. Any feedback is appreciated! The file can be viewed with the following link:

https://docs.google.com/spreadsheets/d/1BNnqNsESOToITI2cqcOcr8buF_fObG0_1UtFuj-0Cko/edit?usp=sharing

Offline Almatrackster

  • Fearless Friday Moderator
  • Hall of Famer
  • ******
  • Posts: 11,604
  • Karma: +753/-249
  • Gender: Male
Re: HS Football Rankings Spreadsheet
« Reply #1 on: October 23, 2017, 09:53:03 pm »
I like your work, vintage. I have a few things after examining it. I, of course, look at Alma first and see White Hall above them and just don't see how. What makes WH rank so high in your rankings do you think?

Offline vintagemustang

  • Band Nerd
  • *
  • Posts: 4
  • Karma: +1/-0
  • Fearless Friday--The Online Home of Arkansas High School Sports!
Re: HS Football Rankings Spreadsheet
« Reply #2 on: October 23, 2017, 09:59:20 pm »
Thanks for looking through it! As for Alma and White Hall, it looks like the reason I have WH higher on my RANK1 formula is due to White Hall's higher point differential. I should probably change that so the formula weighs more heavily on a team's Average Gamescore (stat I came up with to judge how well a team did against another team based on the opponent's Win %). Going by Average Gamescore, Alma should be higher up than White Hall.

Offline vintagemustang

  • Band Nerd
  • *
  • Posts: 4
  • Karma: +1/-0
  • Fearless Friday--The Online Home of Arkansas High School Sports!
Re: HS Football Rankings Spreadsheet
« Reply #3 on: October 23, 2017, 10:00:55 pm »
Also, I have included several different rankings (RANK1, RANK2, RANK3, and so forth) and in some of them Alma has a higher rating than WH. I'm still trying to sort out which metric I like best and will continue to create them until I find it.

Offline Almatrackster

  • Fearless Friday Moderator
  • Hall of Famer
  • ******
  • Posts: 11,604
  • Karma: +753/-249
  • Gender: Male
Re: HS Football Rankings Spreadsheet
« Reply #4 on: October 23, 2017, 10:03:36 pm »
Good answer. I'll have to look at it more in the coming week. I think White Hall's non conference schedule hurt them a little in the fact you weight what classification they play, but not enough to offset their big margin of victories against subpart opponents.


 

Baptist Health Orthopedic Center