Any MS Excel Masters?

#1
VolinArizona

VolinArizona

not in Arizona anymore
Joined
Feb 16, 2006
Messages
21,302
Likes
1,643
#1
I am a pretty big newb when it comes to Excel, but I need someone's help.

I want to create my own NCAAF power rankings. I know what I want to include in it, and I THINK I know the general equation. However, I don't know how to get all the info into the spreadsheet in a timely manner and for it to be easily updated and what not.



Soooooooooooo, if anyone is ever bored, send me a PM and I'll try to explain what I'm looking to do. If nobody wants to, I understand that, too. :)
 
#4
#4
A few questions for you -

Tell me a bit more about the stats you are needing and where you've found them at this point.

How much are you wanting to automate? How much are you willing to do? Do you mind doing a copy and paste of the data or parts?

How intricate is the math behind this and have you thought about it from a forumla side? This is obviously the hardest part.

I might be willing to help you out. It's really how difficult the logic and math is behind it that would determine the time needed.
 
#5
#5
Well, the stats are easy to obtain, but I think the Excel formulas make it difficult. I guess I can post the formula idea I had. It's simple. Nobody should steal it.

[Winning % + (Opp Win% x Their Opp Win%)] x Avg. Margin of Victory = x

Then I would like to order each team's X in descending order from best to worst. From there, I am going to apply extra points to each team's X for a win over a top 40 team. I have not quite figured out the values for each rank a team beats, but for instance, a win over the team with the 10th ranked X would be worth more than the 30th ranked X. Does that make sense?

Once that were done, the rankings would be done.

Honestly, the formula needs work. Basically, I want to involve the specific team's win %, their opponents' win %, then THEIR opponents' opponents' win %, average MOV, and then add in points for quality wins.
 
#6
#6
Oh, and for the other questions.

I am willing to do quite a bit to get it to the point where I can just adjust the 119 teams' records each week and get new outputs.

What I mean is that I'd be very willing to work hard to set it up as long as over the course of the season, if I just update the records each week, I'll get a ranking.
 
#7
#7
The longest part would be inputting all 119 schedules.

None of this would be hard, but it's time consuming. Plus, you'd have to type in all the scores each week. Not sure if you'd be able to copy and paste in any sort of fashion.

The long part would be setting up each page to map to the master page which holds each week's results. This helps having to update both team's individual page.

From there, you have a calc page, which simple pulls all the results off the individual pages and gets them ready for additional points added/sub.

This sound like something doable? I could work up a working model with 4 teams. You could then expand it to all 119 teams. This is obviously just me thinking quickly off the top of my head. I probably think of something much better tomorrow.

Access would probably be better if I could think of a method for doing it.
 
#8
#8
DrRosenRosen said:
The longest part would be inputting all 119 schedules.

None of this would be hard, but it's time consuming. Plus, you'd have to type in all the scores each week. Not sure if you'd be able to copy and paste in any sort of fashion.

The long part would be setting up each page to map to the master page which holds each week's results. This helps having to update both team's individual page.

From there, you have a calc page, which simple pulls all the results off the individual pages and gets them ready for additional points added/sub.

This sound like something doable? I could work up a working model with 4 teams. You could then expand it to all 119 teams. This is obviously just me thinking quickly off the top of my head. I probably think of something much better tomorrow.

Access would probably be better if I could think of a method for doing it.
Click to expand...

It sounds like jibberish to me, but I'll learn!
 
New posts
You must log in or register to reply here.
Advertisement



Back
Top