User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
josh2otter
offline
Link
 
Nice job, I like the RPI rankings, can't wait for the projections to actually be feasible.
 
Link
 
OK, game projections working - no long term? projection (RPI) yet
 
Link
 
P.S. Thank you for what you are doing!!!!!!!!!!!!!!!!!
 
Link
 
Any new reason why the season team Summary report isn't working?

My format page has nothing - but, my predition for each team does on the Alpha & Zeta pages.
 
Link
 
I see the Zeta page has season predictions & the Alpha has current. Of course, I'm in the Alpha...

Anyone?
Last edited Nov 16, 2008 20:25:54
 
BLAZER13
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


Article explaining RPI: http://www.washingtonpost.com/wp-dyn/content/article/2006/03/04/AR2006030401311.html
 
Caledric
offline
Link
 
Originally posted by This is SPARTA!
I see the Zeta page has season predictions & the Alpha has current. Of course, I'm in the Alpha...

Anyone?


change your drop down menus on the alpha and zeta tabs so they are matching. What shows up on the format page is based off of what is selected from the drop down menu on each tab.
 
Caledric
offline
Link
 
http://goallineblitz.com/game/forum_thread.pl?thread_id=1376433&page=1

Spreadsheet has been updated to add in a score predictor sheet to make it easier to post score predictions. Check the very first page for the new files plz. These sheets were written by Groucho.

If you renamed your conference sheets from alpha and zeta you will need to do a replace all on the prediction sheets with the new names of the conference or it will not work correctly.

IE: If you renamed Alpha to East... on Predictions (Alpha) do a ctrl-F, Replace, Find: Alpha, Replace with: East, Replace all.

Any questions as usual do not hesitate to ask. I'm also working on a formating for the RPI Page much like the formating done on the Format page to make it a little more readable. I'll update again when I have a finished and working product.
Last edited Nov 17, 2008 06:13:51
 
Caledric
offline
Link
 
You can copy and paste from your old version to the new version without any errors.
 
Caledric
offline
Link
 
RPI Sheet now has a forum friendly format added to it.

Just like on the other format sheet, simply edit the " . . " in Column K to get your desired spacing. Then Copy and paste column O to the boards.
 
crzyblue
offline
Link
 
The projector doesn't work... we are 4 - 0 and still have to face a team that's given up 100 point each game and is 0 - 4 and it says the score will be 3 - 0?
 
Caledric
offline
Link
 
Whoops I just noticed an error on the score predictor sheets... In column D... anywhere it says BF change it to BH. This sheet is not protected so making the change should be doable by everyone. I will update base sheet and reupload it.
 
crzyblue
offline
Link
 
I'm still looking at the projected score... which is displaying wrong.
 
Link
 
OK, predictions working!

Any fix for the "#" symbol in place of where scores over 100 happen?

Once again Thank You for hehelp and free IT help!
 
Caledric
offline
Link
 
the # symbol just represents that the cell is to small to display the number. When you copy and paste it out it displays the whole number.
 
Page:
 


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