User Pass
Home Sign Up Contact Log In
Forum > South America > Anybody wish to run an Excel based, score powered Projection for South American Leagues?
Satchmo-n-Dizzy
Moderator
offline
Link
 
I have a fairly simple-to-use Excel 2007 spreadsheet (2003 users have been able to convert it) that is setup and ready to go.

The only data entry required:

1) The league schedules for the 32 teams. (Don't worry, it's not as daunting as it seems. There is a 'schedule assist' to help you, and 15 of the 16 schedules in each conference are identical, just staggered. The 16th team acts as a wildcard to replace a team 'scheduled' to play itself)

2) The scores for each game.


The reports available (all are available upon entry of game 1 scores):

1) Current Standings.

2) Projected Standings. (through game 16)

3) Toughest Remaining Schedule. (ranks conference by difficulty of remaining sched)

4) Easiest Remaining Schedule.

5) Toughest Schedule So Far. (ranks conference by difficulty of sched played to date)

6) Easiest Schedule So Far.

7) Toughest Opponents in Defeats. (ranks conference by difficulty of opponents that have beaten a given team)

8) Easiest Opponents in Defeats.

9) Toughest Opponents in Victories. (ranks conference by difficulty of opponents that have been beaten by a given team)

10) Easiest Opponents in Victories.

11) Points Scored. (most -> least)

12) Projected Points Scored. (over 16 games)

13) Points Allowed. (least -> most)

14) Projected Points Allowed. (over 16 games)


What is the algorithm?

The algorithm is actually very simple. It uses a comparative analysis of scores across all games to arrive at factors for each team (expressed as a %). The analysis will easily determine the SoS that a team has played to date vs what said team will play over the remainder of the season. It becomes more and more accurate as the season wears on. However, it has no ability to recognize or account for significant changes to rosters (gutting, recruiting) that may occur during the season.

There is far too little data to arrive at a consensus for week 16 games against the other conference, so it is not unusual to see the algorithm arrive at considerably different conclusions based on the perspective. But within a given conference, the results has been impressive thus far.

The concept...

A team 'A' that averages 56 PF and 6 PA is to play a team 'B' that averages 21 PF and 4 PA. How does one determine the better team going in? By looking at those numbers relative to the teams played to date. Team A's average opponent scores 36 ppg while allowing 28. Team B's average opponent scores 24 and allows 7. That means that Team A scores 200% of the norm allowed against its opponents while allowing 17%. Team B also scores 300% but allows only 14%.

Simplified, the algorithm would take Team A's 200% and multiply it by the 4 PA by Team B (8), then take the 17% and multiply it by 21 (3.5). For Team B it would take 300% and multipy it by 6 (18), then the 14% multipled by 56 (8). The algorithm would then resolve these numbers by taking the mean of each result = Team A will score... (8 + 8) / 2 = 8. Team B will score... (3.5 + 18) / 2 = 11.75. The projection picks Team B.

In practice, the algorithm will look at each game played by a team independently. So upward (or downward) trends will not be tempered by league averages. The determined percentage is, in essence, an average. And, of course, the projected score is and average as described above. However, the numbers that drive the analysis are much more volitile. This allows for greater accuracy based on trends and will typically gain in strength during the season.



This spreadsheet is available on a first come, first serve basis. There is only one requirement - you must use it to post Projected Standings for at least 1 League. If interested, PM your e-mail and the League/Leagues you are willing to project.


South American Leagues still available:

AAA #1
all AA
 
23yrwej
offline
Link
 
Too much work for me.
 
DWinsRespect
offline
Link
 
Originally posted by jrry32
Too much work for me.


Mr. Law School right here! ROFLMAO.
 
23yrwej
offline
Link
 
Originally posted by DWinsRespect
Originally posted by jrry32

Too much work for me.


Mr. Law School right here! ROFLMAO.


Mr. Bigtime right here, he knows how every school works and likes to instigate fights on forums he has no reason being on.
 
husker4life
GBR
offline
Link
 
i'd be interested unfortunately i never check my email so it's probably full.......
 
Satchmo-n-Dizzy
Moderator
offline
Link
 
Originally posted by husker4life
i'd be interested unfortunately i never check my email so it's probably full.......


You requested and got SA AA #2. The file has been sent. Check you email.
 
husker4life
GBR
offline
Link
 
sweet.....anyone else in aa want to pick one up? if not i might be tempted to do all four just because south america is cool like that
 
OilersNut
offline
Link
 
I would do AA#1, but about to go on week-long vacation
Last edited Jun 22, 2008 13:51:43
 
jeremy042376
offline
Link
 
I would like to do AAA#1. However, I only have MS Works Spreadsheet. Anyway you can convert the file before you send it?
 
Satchmo-n-Dizzy
Moderator
offline
Link
 
Originally posted by jeremy042376
I would like to do AAA#1. However, I only have MS Works Spreadsheet. Anyway you can convert the file before you send it?


I've got the latest version of Excel 2007 and cannot successfully convert the file to .xls (1997-2003 extension). Although those with the latest updates for Excel 2003 have converted it successfully.

I'm guessing that getting the latest updates for MS Works will give you the best chance at making it work. This is not a big file compared to others I have made (less than 250Kb), so if MS Works is capable of handling any of my stuff this would be the most likely candidate.
 
Pheloneus
offline
Link
 
South America AA #3 handled
 
Skanker irl
offline
Link
 
We just flip coins, guess, and estimate. No need for all that work.
 
ShamsTron
offline
Link
 
You can use this site to convert the new 2007 file types to the older ones http://www.zamzar.com/ .
 


You are not logged in. Please log in if you want to post a reply.