Jump to content
The Gridiron Digest

Gatorguy

Member
  • Posts

    4
  • Joined

  • Last visited

Personal Information

  • School
    Sheridan
  • Affiliation
    Fan

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Gatorguy's Achievements

Newbie

Newbie (1/14)

  • One Month Later
  • Conversation Starter
  • Week One Done
  • Dedicated
  • First Post

Recent Badges

  1. I have completed my 1st step of the "Blue Bloods Spreadsheet". It's currently 8 pages and has a lot of data in it so I'll try to cover what it does and does not do. Each class has a page tab at the bottom, with the current class assignments sorted alphabetically. (Thanks to the IHSAA for reclassifying after I started working on this). 😒 On each page it lists all the success factor points each team accumulated per year using the current success factor formula since the all in tournament started in the fall of 1985. It then totals all the points and gives you a yearly average. You will see yearly averages and points earned for the following time frames - ALL YEARS, 1st 28 years 85-2012, past 25 years, past 20 years, past 15 years, past 10 years, past 9 years- the addition of the 6th class, and past 5 years. It does not care what class points were earned in, you carry all earned points to your current class. Unfortunately I don't think the data is sortable in it's current form without copying it into a new spreadsheet, which is what I did for the 6A leaders page. This is due to how many changes and merges of the cells so I apologize for that, but I plan to eventually do a leaders page for each class. Finally I'm sure there are mistakes, errors or omissions. I've probably fat fingered some info into cells it does not belong, or screwed up a formula somewhere. If you see something questionable, let me know and I'll research it and get it corrected. Also some schools have not played in every tournament or new schools have opened since 1985 and I'll have to make adjustments for them in some of the formulas. I've done some, but not all. So here you go.......SUCCESS FACTOR BLUE BLOODSxlsx.xlsx
  2. I'm currently working on some spreadsheets which will show how teams have fared over the years. I hope to have them all completed and posted here in the next couple of days.
  3. Here is the spreadsheet I created. I did it on the fly here at work, and copied the numbers from the IHSAA and John Harrells sites. But there could be some mistakes since I had to manually enter a lot of the info. It gives points for each title won, but it's formulated different from the IHSAA success factor points. It gives 1 point for Sectionals won, 2 points for Regionals won, 3 points for a Semi State, and 4 for winning the state. However it totals all the points for the same season, so if you win State, it's actually giving you 10 points. (1+2+3+4) State runner up would be 6 points (1+2+3) etc..... I didn't have the time to go year by year to just award points on the furthest step a team advanced to. FB SUCCESS POINTS.xlsx
  4. I threw together a spreadsheet tabulating schools points by number of sectional, regional etc. titles. Is there an easy way to post an excel spreadsheet here?
×
×
  • Create New...