when you see a ##### it means the value is to large to display in the cell.. if you zoom in or out on the sheet to make the cell bigger it will show up. This early in the season you have teams projected to score 1000 points every game hehe.
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
CDZYO
offline
offline
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
Coach79
offline
offline
Originally posted by CDZYO
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
That would be a huge help!!!
EE BBB #5 http://goallineblitz.com/game/league.pl?league_id=205
My team is the "Warsaw Wolfpack" in Zeta
Here is what I have so far, http://www.4shared.com/file/78694060/6aa174b6/LP_2007_Wolfpack.html
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
That would be a huge help!!!
EE BBB #5 http://goallineblitz.com/game/league.pl?league_id=205
My team is the "Warsaw Wolfpack" in Zeta
Here is what I have so far, http://www.4shared.com/file/78694060/6aa174b6/LP_2007_Wolfpack.html
CDZYO
offline
offline
Originally posted by Coach79
Originally posted by CDZYO
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
That would be a huge help!!!
EE BBB #5 http://goallineblitz.com/game/league.pl?league_id=205
My team is the "Warsaw Wolfpack" in Zeta
Here is what I have so far, http://www.4shared.com/file/78694060/6aa174b6/LP_2007_Wolfpack.html
Must be my lucky day -- I've got a player on the Esgares Death Knights, so you've saved me the trouble of putting a sheet together from scratch.
I'll send you a PM with a link to my corrected version of the sheet. The basic problem was that you used the team's ID in the schedule box instead of the number in the orange box next to the team name. It'll make more sense when you see it. I also added the Zeta schedules for you, but you'll want to double-check my work with at least one of the schedules.
GL with the sheet! The first games are happening... what? NOW?! Gotta go watch!
Originally posted by CDZYO
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....
It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.
-C
The instructions need to be updated -- the teams go into GQ now, not FQ, and the games go into columns GR through HG.
Which league are you trying to do, and which team is your #1 for each conference? I can take a shot at setting up the sheet if you want.
That would be a huge help!!!
EE BBB #5 http://goallineblitz.com/game/league.pl?league_id=205
My team is the "Warsaw Wolfpack" in Zeta
Here is what I have so far, http://www.4shared.com/file/78694060/6aa174b6/LP_2007_Wolfpack.html
Must be my lucky day -- I've got a player on the Esgares Death Knights, so you've saved me the trouble of putting a sheet together from scratch.

I'll send you a PM with a link to my corrected version of the sheet. The basic problem was that you used the team's ID in the schedule box instead of the number in the orange box next to the team name. It'll make more sense when you see it. I also added the Zeta schedules for you, but you'll want to double-check my work with at least one of the schedules.
GL with the sheet! The first games are happening... what? NOW?! Gotta go watch!
CDZYO
offline
offline
Bug in the RPI formulas -- it looks like the O% doesn't include the intraconference game.
Edit: nm. I just remembered why O% can't be figured out for the first game. <facepalm>
Edit: nm. I just remembered why O% can't be figured out for the first game. <facepalm>
Last edited Jan 3, 2009 21:06:58
About2 Break
offline
offline
I entered all teams schedules and scores after two games everything is correct why wont it give me any numbers for projections!!!
CDZYO
offline
offline
Originally posted by cigtyme
I entered all teams schedules and scores after two games everything is correct why wont it give me any numbers for projections!!!
did you change the number of the week on the projections tab? There's a number that's just above the teams on the far left of the sheet -- it's used for setting the week that's being projected.
I entered all teams schedules and scores after two games everything is correct why wont it give me any numbers for projections!!!
did you change the number of the week on the projections tab? There's a number that's just above the teams on the far left of the sheet -- it's used for setting the week that's being projected.
Squicken
offline
offline
Is it supposed to order the teams on the RPI page based on their actual RPI rating? I think all the data is in correctly, but it just keeps the teams all in the same order that I entered them into the program.
CDZYO
offline
offline
Originally posted by BigCowboysFan
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
Originally posted by Squicken
Is it supposed to order the teams on the RPI page based on their actual RPI rating? I think all the data is in correctly, but it just keeps the teams all in the same order that I entered them into the program.
It doesn't automatically sort yet. I don't know if that's on the books to be added. When you do the manual sort, make sure that you include the teams and the formatting dots to the right. There are some hidden columns between those two that need to be sorted. I sort by D-descending (RPI) and then by H-descending (wins).
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
Originally posted by Squicken
Is it supposed to order the teams on the RPI page based on their actual RPI rating? I think all the data is in correctly, but it just keeps the teams all in the same order that I entered them into the program.
It doesn't automatically sort yet. I don't know if that's on the books to be added. When you do the manual sort, make sure that you include the teams and the formatting dots to the right. There are some hidden columns between those two that need to be sorted. I sort by D-descending (RPI) and then by H-descending (wins).
BigCowboysFan
offline
offline
Originally posted by CDZYO
Originally posted by BigCowboysFan
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
That's what I was guessing. I've used the league projector for ever, but just came across the updated version. I am curious however what numbers are used...etc.
Originally posted by BigCowboysFan
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
That's what I was guessing. I've used the league projector for ever, but just came across the updated version. I am curious however what numbers are used...etc.
CDZYO
offline
offline
Originally posted by Squicken
Ok. So re-sorting the RPI page won't screw anything up?
As long as you're not trying to sort both conferences at once, it won't screw anything up. The column that gives you the rankings formatted for posting is fairly independent of the input data on the right. Worst case scenario: you oversort, realize it, and use the "undo" command to undo it.
Edit: Here's some directions from earlier in the thread:
Originally posted by Caledric
atm it looks like you will have to manually sort them. You can make the spread sheet do it for you though, I just need to take some time to look into coding it to auto sort and maybe even add in a drop down menu for it. Or maybe that is something sdu can work on since the RPI is his baby.
Quick fix for now. For 2007 users columns C through K for one of the conferences (You must do each one seperately) So for Alpha highlight C2 through K17... Then click on Data, click on Sort. Sort by Column D. Largest to smallest.
This will order it correctly and the format should still work. Make sure you do not highlight column A or it will mess up the numbering in the formatted table.
For Zeta repeat just using Columsn C20 to K35
Ok. So re-sorting the RPI page won't screw anything up?
As long as you're not trying to sort both conferences at once, it won't screw anything up. The column that gives you the rankings formatted for posting is fairly independent of the input data on the right. Worst case scenario: you oversort, realize it, and use the "undo" command to undo it.
Edit: Here's some directions from earlier in the thread:
Originally posted by Caledric
atm it looks like you will have to manually sort them. You can make the spread sheet do it for you though, I just need to take some time to look into coding it to auto sort and maybe even add in a drop down menu for it. Or maybe that is something sdu can work on since the RPI is his baby.
Quick fix for now. For 2007 users columns C through K for one of the conferences (You must do each one seperately) So for Alpha highlight C2 through K17... Then click on Data, click on Sort. Sort by Column D. Largest to smallest.
This will order it correctly and the format should still work. Make sure you do not highlight column A or it will mess up the numbering in the formatted table.
For Zeta repeat just using Columsn C20 to K35
Last edited Jan 9, 2009 12:13:35
CDZYO
offline
offline
Originally posted by BigCowboysFan
Originally posted by CDZYO
Originally posted by BigCowboysFan
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
That's what I was guessing. I've used the league projector for ever, but just came across the updated version. I am curious however what numbers are used...etc.
I'm using a custom RPI, so I don't remember the original formula myself. Here's sdumont's explanation from earlier in the thread:
Originally posted by sdumont
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...here 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 their game out and neither team has played any other opponent, their opponent's 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
Originally posted by CDZYO
Originally posted by BigCowboysFan
What are the RPI formulas used for?
They're used for calculating power rankings. sdumont can probably tell you more about how they work.
That's what I was guessing. I've used the league projector for ever, but just came across the updated version. I am curious however what numbers are used...etc.
I'm using a custom RPI, so I don't remember the original formula myself. Here's sdumont's explanation from earlier in the thread:
Originally posted by sdumont
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...here 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 their game out and neither team has played any other opponent, their opponent's 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
CDZYO
offline
offline
May or may not be a bug: the current version of the spreadsheet appears to sort Projected Standings using something other than the tiebreaker system. It's been suggested to me that some earlier versions were sorting correctly; it's possible that the sorting was either broken with the intraconference game change or with a "recent" change to the tiebreaker system.
You are not logged in. Please log in if you want to post a reply.





























