User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Link
 
Originally posted by CDZYO
Originally posted by Wrath Of Conor

Ok, I'm having a problem with the projector. I used to use the old Satchmo one back in the day and I'm doing one for the first time in a while.

(snip)


It takes a few games of data before the projector spits out anything usable. The original Satchmo-n-Dizzy projector had the same limitation -- the only difference is that the intraconference game has moved from game 16 to game 1, which doesn't help the calculations, so you can't really count it. I rarely use it to provide predictions before game 5.


Yeah I know that more data means more reliable results, but in this case the projections make sense when I enter in one conference only, the remaining projected scores are reasonable 37-20, 40-21, etc and so on, but when I enter the game 1 results for the second conference (and there no gutted teams are crazy scores in week 1) all of the projected scores turn into 1012-976, 1110-984, etc and so on. That tells me something is wrong somewhere even after double and triple checking my entries and also seeing nothing in the built in error checking. The old Satchmo sheets didn't show 1000 point projections after week 1.
 
CDZYO
offline
Link
 
Originally posted by Wrath Of Conor
Originally posted by CDZYO

Originally posted by Wrath Of Conor


Ok, I'm having a problem with the projector. I used to use the old Satchmo one back in the day and I'm doing one for the first time in a while.

(snip)


It takes a few games of data before the projector spits out anything usable. The original Satchmo-n-Dizzy projector had the same limitation -- the only difference is that the intraconference game has moved from game 16 to game 1, which doesn't help the calculations, so you can't really count it. I rarely use it to provide predictions before game 5.


Yeah I know that more data means more reliable results, but in this case the projections make sense when I enter in one conference only, the remaining projected scores are reasonable 37-20, 40-21, etc and so on, but when I enter the game 1 results for the second conference (and there no gutted teams are crazy scores in week 1) all of the projected scores turn into 1012-976, 1110-984, etc and so on. That tells me something is wrong somewhere even after double and triple checking my entries and also seeing nothing in the built in error checking. The old Satchmo sheets didn't show 1000 point projections after week 1.


Again, the difference is that the intraconference game moved to game 1 -- the old sheets never had to predict a game with intraconference scores in the inputs. Also, with the old sheets, by the second game every team in the conference had played another team in the conference twice, so the spreadsheet could figure out how the teams match up in relation to each other. (The conference schedules are on a 15-team loop, with the 16th team serving as the opponent when a team is "scheduled to play itself.") Because that first game is now with a team that's in an entirely different conference, it doesn't have a frame of reference yet.

You could try leaving the game 1 scores out to see what difference that makes. Come to think of it, that might give better results in the early part of the season. Hmm. I'm running sheets for three leagues, so I'll test that theory.
 
Link
 
Alright, I'll continue to put the scores in as we just played our second games today, if it still looks funky then I'll give it a go without the game 1 scores.
 
usmcfla1
offline
Link
 
I have a question i have everything filled out right as so i think i do, but in the column RPI how do you get it so you can copy it to the league forums?
 
wbudwhite
offline
Link
 
Can you use this just for Alpha...or do you have to fill it out for the whole leauge to work?

John
 
Zumbo
offline
Link
 
I finished entering all of the schedule info and the last column's number still shows up. The number is 136 and after doing the math it SHOULD be 136. Not sure what to do.
Last edited Mar 7, 2009 19:54:54
 
ReadingFC
offline
Link
 
Couldn't this be built into the game? Just have a link called projected standings and Bort can program the spreadsheet code using the data in the database. Sorted.
 
Buer
offline
Link
 
Anyone know why this is happening? I have all the games plugged in for both Alpha and Zeta up to week...10 or whatever it is.

http://i243.photobucket.com/albums/ff191/omgatiger/Picture1-5.png

(In other words, the way it looks for the Irishmen to the left, that's how it looks for all of them, with the correct scores and teams inputted and such).
 
nickies
offline
Link
 
The sheet doesn't work properly in OpenOffice. Already tried it. :/
 
Buer
offline
Link
 
Originally posted by nickies
The sheet doesn't work properly in OpenOffice. Already tried it. :/


http://www.glbwiki.com/index.php?title=Power_Ranking_Spreadsheet

Doesn't this say it does?
 
demogorgon
offline
Link
 
Power Ranking is a different spreadsheet than League Projector.
 
1freebird
offline
Link
 
Hey all that use this fun spreadsheet, I sent a formula to Cedric that helps to auto fill the schedule cells as you put them in. Will help cut down time spent by 50%.
 
nthomas
offline
Link
 
Originally posted by 1freebird
Hey all that use this fun spreadsheet, I sent a formula to Cedric that helps to auto fill the schedule cells as you put them in. Will help cut down time spent by 50%.


That would be a huge time saver if the alternate team schedules and scores filled in when you entered one. Hope it gets implemented.
 
DrkSandman
Baseballs
offline
Link
 
You're just lazy nthomas
 
Octowned
offline
Link
 
That, and entering each game twice, could obviously use improvements, but who is here to complain this spreadsheet is awesome
 
Page:
 


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