User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
sdumont
offline
Link
 
Originally posted by crzyblue
LOL I found the predictions to be off... but if you look it might be the colored boxes that are wrong... if you lose does it show one in black and one number in red? I got mine to work except for the predicted score.


This has been fixed....as long as you don't copy and paste your scores into the new one
 
sdumont
offline
Link
 
Also...the predicted score really won't work itself out until it has more data to go on...you will notice around week 5,6,7....give or take the predictions will be more accurate....assuming no teams get gutted during the season...
Last edited Nov 14, 2008 13:38:07
 
maizenhops
offline
Link
 
how long does this all take, i started and its taking foreeevvverrr
 
Tukash
offline
Link
 
Hmmm RPI still blank for me with the latest version.
 
Toccata6767
offline
Link
 
I can get both the alpha and zeta pages to show projections and all, seems to work pretty well. RPI shows up fine. But the format page isn't working. I want to be able to paste this into my league forum. Is anyone else having this problem?
 
Caledric
offline
Link
 
Its an error in the code he used... I fixed it and have now uploaded it and updated the front page for the updated file.
 
Tukash
offline
Link
 
Originally posted by Caledric
Its an error in the code he used... I fixed it and have now uploaded it and updated the front page for the updated file.


O.K. RPI report still doesn't show anything for me, and the format page is a bunch of decimals. This is using the latest that sdumont posted. I only copied and pasted the actual schedule, typed in the team names and scores. Is the updated version on the front page going to fix that. It's getting old retyping info in LOL.

Oh and the red and green boxes still not working right. For my team it says the records of the teams we have beat are 2-1-0. We won both our games and both of those teams went 1-1, so shouldn't the red box say 2-2-0 or am I looking at it totally wrong?
Last edited Nov 14, 2008 17:09:57
 
Caledric
offline
Link
 
download the one from the very first post in this thread... that will fix the issue with the format page. as far as the RPI report... I don't have a clue about that. Sdu will have to help you out there.
 
Strykr
offline
Link
 
Anyone that is savvy enough in excel, I am trying to create something to add to the projector. Since you enter in all the scores for all 32 teams and it creates the predictions for the upcoming games, I would like to create a pull-down box that you can select Game 1 - Game 16 (Or game 2-16) And with each one of those, it will generate a list of the 2 conferences and who they are playing and show the projection for that selected week.

I can't imagine it is too hard to make if you have a clue how to program something like that. If anyone has any ideas, shoot me a PM and we can figure this thing out. I would like to avoid having to cut and paste so many projections for my conference every 2 days.
 
Caledric
offline
Link
 
sdu any chance you can get it to format like the standings do so comes out a bit nicer on the forums? Also can you add in an explanation of what everything means? I like many others have no clue what RPI is or how it works.
 
sdumont
offline
Link
 
Originally posted by Tukash
Hmmm RPI still blank for me with the latest version.


If you only have played 1 week so far, the RPI won't reflect anything. You'll need to have at least 2 weeks entered...her is the reason...RPI rankings are based on your winning pct...and average of your opponents winning pct...and an average of your opponents opponents winning pct....but it doesn't take your win or loss in your opponents winning pct in calculating the RPI

It's a difficult formula to explain without getting a million questions...just look at it this way...Team A finished 15-1...Team B 10-6....during the season when these two teams played Team A beat Team B...when you calculate the opponents winning pct you wouldn't use the 15-1 or 10-6 record you would use there record had that not played that game...so Team A winning pct would be on a 14-1 record and Team B would be 10-5...then you take each Teams opponent Team C,D,E,F and so on and average them. Your Opponents, Opponents winning pct is done the same way......

This is the reason when you enter scores for week 1 you won't have any data...Team A is 1-0 because they beat Team B who is now 0-1.....when you take the result of there game out and neither team has played any other opponent, there opponents record is 0-0....

If you have questions on RPI....there are different ways to calculate them...you'll have to look it up...there isn't an easy way to explain it
Last edited Nov 14, 2008 20:12:23
 
sdumont
offline
Link
 
Originally posted by Caledric
Its an error in the code he used... I fixed it and have now uploaded it and updated the front page for the updated file.


Which one wasn't correct?
 
sdumont
offline
Link
 
Originally posted by Caledric
sdu any chance you can get it to format like the standings do so comes out a bit nicer on the forums? Also can you add in an explanation of what everything means? I like many others have no clue what RPI is or how it works.


Whats up with the format?
 
Caledric
offline
Link
 
Originally posted by sdumont
Originally posted by Caledric

Its an error in the code he used... I fixed it and have now uploaded it and updated the front page for the updated file.


Which one wasn't correct?


blocks A1 and A21... you have it pointing at YOUR file when instead the code should be this: =RIGHT(CELL("filename",'Alpha Conference'!$A$1), LEN(CELL("filename",'Alpha Conference'!$A$1))-FIND("]", CELL("filename",'Alpha Conference'!$A$1), 1))

As far as what's up with the Format... When you copy and paste it smooshes itself all together. The current format sheet fixes that for the standings, but your RPI sheet does not. I could take an hour to format that part each week, but just not worth it to me, would be better to have it automated.

http://goallineblitz.com/game/forum_thread.pl?thread_id=1437293

 
Tukash
offline
Link
 
Originally posted by sdumont
Originally posted by Tukash

Hmmm RPI still blank for me with the latest version.


If you only have played 1 week so far, the RPI won't reflect anything. You'll need to have at least 2 weeks entered...her is the reason...RPI rankings are based on your winning pct...and average of your opponents winning pct...and an average of your opponents opponents winning pct....but it doesn't take your win or loss in your opponents winning pct in calculating the RPI

It's a difficult formula to explain without getting a million questions...just look at it this way...Team A finished 15-1...Team B 10-6....during the season when these two teams played Team A beat Team B...when you calculate the opponents winning pct you wouldn't use the 15-1 or 10-6 record you would use there record had that not played that game...so Team A winning pct would be on a 14-1 record and Team B would be 10-5...then you take each Teams opponent Team C,D,E,F and so on and average them. Your Opponents, Opponents winning pct is done the same way......

This is the reason when you enter scores for week 1 you won't have any data...Team A is 1-0 because they beat Team B who is now 0-1.....when you take the result of there game out and neither team has played any other opponent, there opponents record is 0-0....

If you have questions on RPI....there are different ways to calculate them...you'll have to look it up...there isn't an easy way to explain it


I did have 2 weeks entered. still didn't show a report for RPI. I have downloaded the new update by caledric that he put on the first page. The RPI now works (it's under it's own tab). I'm getting realistic projections now instead of 0 to 800 or teams that aren't projected to score for the rest of the season.

 
Page:
 


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