User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
CDZYO
offline
Link
 
Thanks to all who put the time into updating this spreadsheet, expanding it, and fixing all the bugs. I appreciate the effort, and we're using the spreadsheet in Canada BBB #12.
 
Tukash
offline
Link
 
Don't quite understand your RPI rankings. How does a team with RPI of .516 get ranked 1st and the team with .698 get ranked 6th. Seems to me it's not putting them in the correct rank order. Actually after looking at the spread sheet some more, it just has them listed in the order that they (teams) are entered into the main spreadsheet. So how do I get it to sort correctly for rank without doing it manually?



Rk______Team_____________________RPI____O%____OO%__W__L__
1..United Pheonix . . . . . . . .516 . . . .667 . . . . .479 . . . . 1 . . 3
2..WashintonMistiCapWizNat . . .370 . . . .417 . . . . .396 . . . . 1 . . 3
3..Little China Jack Burtons . . .453 . . . .500 . . . . .563 . . . . 1 . . 3
4..Camelot Crush. . . . . . . . .589 . . . .583 . . . . .688 . . . . 2 . . 2
5..Frankfurt Slashers . . . . . .667 . . . .667 . . . . .583 . . . . 3 . . 1
6..Sayreville Stampede. . . . . .698 . . . .583 . . . . .625 . . . . 4 . . 0
7..Naples Assassins . . . . . . .646 . . . .500 . . . . .583 . . . . 4 . . 0
8..Siena Saints . . . . . . . . .531 . . . .583 . . . . .458 . . . . 2 . . 2
9..Palermo Preditors. . . . . . .651 . . . .667 . . . . .521 . . . . 3 . . 1
10..D-Town Bushwalkers. . . . . .510 . . . .667 . . . . .458 . . . . 1 . . 3
11..North Yorkshire Federals. . .484 . . . .333 . . . . .521 . . . . 3 . . 1
12..Gothem City Jokers. . . . . .630 . . . .667 . . . . .438 . . . . 3 . . 1
13..Thebes Thundercats. . . . . .510 . . . .500 . . . . .542 . . . . 2 . . 2
14..Naples Bullets. . . . . . . .443 . . . .500 . . . . .521 . . . . 1 . . 3
15..North Georgia Bulldogs. . . .594 . . . .417 . . . . .542 . . . . 4 . . 0
16..Luxemburg Grand Duchy . . . .365 . . . .500 . . . . .458 . . . . 0 . . 4

Grrrr and I did the whole thing of lining up the post, then copying the spaces to get this to line up and that doesn't work for me either.

I to want to thank those that worked on this, my frustration is not with them but with myself for not being able to figure out how to get some of this to work.
Last edited Nov 17, 2008 18:04:22
 
Caledric
offline
Link
 
I think I've put more work into updating this spreadsheet then I did some of the stuff while I was in Iraq lol. For some reason this feels far more rewarding too... most likely because its for something I enjoy rather then to get my OIC another notch on his belt while having my hard work ignored.
 
Caledric
offline
Link
 
Originally posted by Tukash
Don't quite understand your RPI rankings. How does a team with RPI of .516 get ranked 1st and the team with .698 get ranked 6th. Seems to me it's not putting them in the correct rank order. Actually after looking at the spread sheet some more, it just has them listed in the order that they (teams) are entered into the main spreadsheet. So how do I get it to sort correctly for rank without doing it manually?



Rk______Team_____________________RPI____O%____OO%__W__L__
1..United Pheonix . . . . . . . .516 . . . .667 . . . . .479 . . . . 1 . . 3
2..WashintonMistiCapWizNat . . .370 . . . .417 . . . . .396 . . . . 1 . . 3
3..Little China Jack Burtons . . .453 . . . .500 . . . . .563 . . . . 1 . . 3
4..Camelot Crush. . . . . . . . .589 . . . .583 . . . . .688 . . . . 2 . . 2
5..Frankfurt Slashers . . . . . .667 . . . .667 . . . . .583 . . . . 3 . . 1
6..Sayreville Stampede. . . . . .698 . . . .583 . . . . .625 . . . . 4 . . 0
7..Naples Assassins . . . . . . .646 . . . .500 . . . . .583 . . . . 4 . . 0
8..Siena Saints . . . . . . . . .531 . . . .583 . . . . .458 . . . . 2 . . 2
9..Palermo Preditors. . . . . . .651 . . . .667 . . . . .521 . . . . 3 . . 1
10..D-Town Bushwalkers. . . . . .510 . . . .667 . . . . .458 . . . . 1 . . 3
11..North Yorkshire Federals. . .484 . . . .333 . . . . .521 . . . . 3 . . 1
12..Gothem City Jokers. . . . . .630 . . . .667 . . . . .438 . . . . 3 . . 1
13..Thebes Thundercats. . . . . .510 . . . .500 . . . . .542 . . . . 2 . . 2
14..Naples Bullets. . . . . . . .443 . . . .500 . . . . .521 . . . . 1 . . 3
15..North Georgia Bulldogs. . . .594 . . . .417 . . . . .542 . . . . 4 . . 0
16..Luxemburg Grand Duchy . . . .365 . . . .500 . . . . .458 . . . . 0 . . 4


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
 
Caledric
offline
Link
 
Originally posted by Tukash

Grrrr and I did the whole thing of lining up the post, then copying the spaces to get this to line up and that doesn't work for me either.

I to want to thank those that worked on this, my frustration is not with them but with myself for not being able to figure out how to get some of this to work.


What I do for this... is I take each table, and paste it into my private forum. Then I add and subtract the dots until it looks pretty in the forum. Then I copy and paste from the dots from the forum to the spreadsheet.

The spreadsheet will through you off because it uses a different font size and also has all the BBCODE Markup in it.
 
Tukash
offline
Link
 
Originally posted by Caledric
Originally posted by Tukash


Grrrr and I did the whole thing of lining up the post, then copying the spaces to get this to line up and that doesn't work for me either.

I to want to thank those that worked on this, my frustration is not with them but with myself for not being able to figure out how to get some of this to work.


What I do for this... is I take each table, and paste it into my private forum. Then I add and subtract the dots until it looks pretty in the forum. Then I copy and paste from the dots from the forum to the spreadsheet.

The spreadsheet will through you off because it uses a different font size and also has all the BBCODE Markup in it.


Yea I did that, still no joy. Here's what I did.

1. Copied O19-O35, this is the Zeta teams from my league.
2. Pasted to a forum post.
3. Lined everything up the way I wanted it.
4. Copied the space between the end of the team name to the RPI number
5. Pasted this to the corresponding team in column K. Pasted it between the "" in the function box.
6. Then pasted it into another forum post. Things still aren't lined up correctly not sure what I'm doing wrong.


And even if I get that to work, how is that going to fix the spacing between RPI and O%, O% and OO%, etc. We haven't pasted any new spacing for those, so I don't understand how it is going to correct those.

And finally what is O% and OO% LOL
Last edited Nov 17, 2008 18:29:52
 
Toccata6767
offline
Link
 
In the alpha page where you can select what type of data to list(current standings, projected standings, etc) where it shows the column headers, there's no 'W' for the wins column.
 
Caledric
offline
Link
 
Originally posted by Toccata6767
In the alpha page where you can select what type of data to list(current standings, projected standings, etc) where it shows the column headers, there's no 'W' for the wins column.


I'll get that fixed for the next version, its not worth an update on its own though.
 
josh2otter
offline
Link
 
Originally posted by Tukash


And finally what is O% and OO% LOL


Opponents win % and opponents opponents win %
 
sdumont
offline
Link
 
Originally posted by Caledric
Originally posted by Tukash

Don't quite understand your RPI rankings. How does a team with RPI of .516 get ranked 1st and the team with .698 get ranked 6th. Seems to me it's not putting them in the correct rank order. Actually after looking at the spread sheet some more, it just has them listed in the order that they (teams) are entered into the main spreadsheet. So how do I get it to sort correctly for rank without doing it manually?



Rk______Team_____________________RPI____O%____OO%__W__L__
1..United Pheonix . . . . . . . .516 . . . .667 . . . . .479 . . . . 1 . . 3
2..WashintonMistiCapWizNat . . .370 . . . .417 . . . . .396 . . . . 1 . . 3
3..Little China Jack Burtons . . .453 . . . .500 . . . . .563 . . . . 1 . . 3
4..Camelot Crush. . . . . . . . .589 . . . .583 . . . . .688 . . . . 2 . . 2
5..Frankfurt Slashers . . . . . .667 . . . .667 . . . . .583 . . . . 3 . . 1
6..Sayreville Stampede. . . . . .698 . . . .583 . . . . .625 . . . . 4 . . 0
7..Naples Assassins . . . . . . .646 . . . .500 . . . . .583 . . . . 4 . . 0
8..Siena Saints . . . . . . . . .531 . . . .583 . . . . .458 . . . . 2 . . 2
9..Palermo Preditors. . . . . . .651 . . . .667 . . . . .521 . . . . 3 . . 1
10..D-Town Bushwalkers. . . . . .510 . . . .667 . . . . .458 . . . . 1 . . 3
11..North Yorkshire Federals. . .484 . . . .333 . . . . .521 . . . . 3 . . 1
12..Gothem City Jokers. . . . . .630 . . . .667 . . . . .438 . . . . 3 . . 1
13..Thebes Thundercats. . . . . .510 . . . .500 . . . . .542 . . . . 2 . . 2
14..Naples Bullets. . . . . . . .443 . . . .500 . . . . .521 . . . . 1 . . 3
15..North Georgia Bulldogs. . . .594 . . . .417 . . . . .542 . . . . 4 . . 0
16..Luxemburg Grand Duchy . . . .365 . . . .500 . . . . .458 . . . . 0 . . 4


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


Thanks Caledric for adding updates into this....I haven't had time to mess with it lately...I think there is still something wrong with some of the score predicitions...I just updated my league through week 4 and a team that is 4-0 is expected to finish 8-8 and give up almost 100 points each game...something doesn't make sense there....not sure where the error is yet...
 
Caledric
offline
Link
 
Originally posted by sdumont
Originally posted by Caledric

Originally posted by Tukash


Don't quite understand your RPI rankings. How does a team with RPI of .516 get ranked 1st and the team with .698 get ranked 6th. Seems to me it's not putting them in the correct rank order. Actually after looking at the spread sheet some more, it just has them listed in the order that they (teams) are entered into the main spreadsheet. So how do I get it to sort correctly for rank without doing it manually?



Rk______Team_____________________RPI____O%____OO%__W__L__
1..United Pheonix . . . . . . . .516 . . . .667 . . . . .479 . . . . 1 . . 3
2..WashintonMistiCapWizNat . . .370 . . . .417 . . . . .396 . . . . 1 . . 3
3..Little China Jack Burtons . . .453 . . . .500 . . . . .563 . . . . 1 . . 3
4..Camelot Crush. . . . . . . . .589 . . . .583 . . . . .688 . . . . 2 . . 2
5..Frankfurt Slashers . . . . . .667 . . . .667 . . . . .583 . . . . 3 . . 1
6..Sayreville Stampede. . . . . .698 . . . .583 . . . . .625 . . . . 4 . . 0
7..Naples Assassins . . . . . . .646 . . . .500 . . . . .583 . . . . 4 . . 0
8..Siena Saints . . . . . . . . .531 . . . .583 . . . . .458 . . . . 2 . . 2
9..Palermo Preditors. . . . . . .651 . . . .667 . . . . .521 . . . . 3 . . 1
10..D-Town Bushwalkers. . . . . .510 . . . .667 . . . . .458 . . . . 1 . . 3
11..North Yorkshire Federals. . .484 . . . .333 . . . . .521 . . . . 3 . . 1
12..Gothem City Jokers. . . . . .630 . . . .667 . . . . .438 . . . . 3 . . 1
13..Thebes Thundercats. . . . . .510 . . . .500 . . . . .542 . . . . 2 . . 2
14..Naples Bullets. . . . . . . .443 . . . .500 . . . . .521 . . . . 1 . . 3
15..North Georgia Bulldogs. . . .594 . . . .417 . . . . .542 . . . . 4 . . 0
16..Luxemburg Grand Duchy . . . .365 . . . .500 . . . . .458 . . . . 0 . . 4


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


Thanks Caledric for adding updates into this....I haven't had time to mess with it lately...I think there is still something wrong with some of the score predicitions...I just updated my league through week 4 and a team that is 4-0 is expected to finish 8-8 and give up almost 100 points each game...something doesn't make sense there....not sure where the error is yet...


I have that in one of my leagues too, I looked into it a bit and it has to do with fucking cruise control. The 4-0 team gave up points to an 0-4 team that everyone has scored 255+ on... Well because of cruise control and stamina the 0-4 team managed to return a punt for a TD... since everyone else shut them out... it predicts that they aren't gonna do so hot. they play more even match ups it will start to ignore that score and focus on the ass kicking they are giving.
 
sdumont
offline
Link
 
Originally posted by Caledric

I have that in one of my leagues too, I looked into it a bit and it has to do with fucking cruise control. The 4-0 team gave up points to an 0-4 team that everyone has scored 255+ on... Well because of cruise control and stamina the 0-4 team managed to return a punt for a TD... since everyone else shut them out... it predicts that they aren't gonna do so hot. they play more even match ups it will start to ignore that score and focus on the ass kicking they are giving.


Yeah, I just looked at the team it was happening too and they allowed 7 points to a team that hasn't scored and has been beat by an average of 185-0
 
Warhawk
Moderator
offline
Link
 
I'm using this in USA A #5.

http://goallineblitz.com/game/forum_thread.pl?thread_id=1469535
 
bamaplaya1
offline
Link
 
how about a link to a free download of excel
 
CDZYO
offline
Link
 
Originally posted by bamaplaya1
how about a link to a free download of excel


It works in OpenOffice, and that's free. http://www.openoffice.org/
 
Page:
 


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