User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
nickies
offline
Link
 
I tried the newer version of OpenOffice too. It doesn't help though so maybe I should just sit down and cry instead?

Any chance it will be developed for OpenOffice?
 
goldielax25
offline
Link
 
no its in the 10th spot.

basically it is saying that this team http://goallineblitz.com/game/team.pl?team_id=6124 will lose to the 6th place team 344-37, to the 7th place team 206-62, to the 9th place team 222-50, do the 8th place team 186-31, and to the 2nd place team 225-41. mind you this team is in 3rd place but id call them the 2nd best team by far.

i get the feeling that their points for is correct, it is just the points against that is skewed.
 
demogorgon
offline
Link
 
I got one for that league that works fine but i use office 2003.The weekly predictions i post on the forum are from the same sheet.
 
CDZYO
offline
Link
 
Originally posted by goldielax25
no its in the 10th spot.

basically it is saying that this team http://goallineblitz.com/game/team.pl?team_id=6124 will lose to the 6th place team 344-37, to the 7th place team 206-62, to the 9th place team 222-50, do the 8th place team 186-31, and to the 2nd place team 225-41. mind you this team is in 3rd place but id call them the 2nd best team by far.

i get the feeling that their points for is correct, it is just the points against that is skewed.


Doublecheck your entries in their PA column to make sure that you don't have a number there that shouldn't be. My (new) guess is that you've got a typo somewhere in there that turned a two-digit number into a three-digit number.

Any chance that you could post a screenshot?
 
sdumont
offline
Link
 
Originally posted by goldielax25
no its in the 10th spot.

basically it is saying that this team http://goallineblitz.com/game/team.pl?team_id=6124 will lose to the 6th place team 344-37, to the 7th place team 206-62, to the 9th place team 222-50, do the 8th place team 186-31, and to the 2nd place team 225-41. mind you this team is in 3rd place but id call them the 2nd best team by far.

i get the feeling that their points for is correct, it is just the points against that is skewed.


If that 3rd place team played a CPU or gutted team and they allowed any points it'll throw it off like this, especially if that teams hasn't scored any points in other games.....my suggestion is to look over that's teams schedule and if this is the case just change whatever they have for points allowed in that game to 0....should cure it...if this is not the case then more information is needed
Last edited Jan 29, 2009 05:50:02
 
sdumont
offline
Link
 
Looking at that team it's probably because they allowed 10 points to Capeside Minutemen. If you change the points allowed by Berlin Blitz in that game to 0...your problem will be cured. I wouldn't be surprised if it's messing with Atlanta 404 results as well since that team allowed them to score 7 points...
 
goldielax25
offline
Link
 
Originally posted by sdumont
Looking at that team it's probably because they allowed 10 points to Capeside Minutemen. If you change the points allowed by Berlin Blitz in that game to 0...your problem will be cured. I wouldn't be surprised if it's messing with Atlanta 404 results as well since that team allowed them to score 7 points...


thats what i was thinking too. ill check it out when i get home. after i inputted the week 13 results, it put scores for berlin to a more normal position, although it still has them losing games i think they will win handily. i will try the capeside adjustment and see whats up. thanks!
 
tshizzle
offline
Link
 
can you use this to predict the playoff games somehow? i have all 16 weeks filled in on mine now
 
Narrator
offline
Link
 
Originally posted by tshizzle
can you use this to predict the playoff games somehow? i have all 16 weeks filled in on mine now


+1
 
nthomas
offline
Link
 
FOr the playoffs, what I did was remove the game for the teams playing each other in the playoffs. It will give you a prediction for those games, using the entire season of data. Used it last season with fairly good accuracy
 
Zumbo
offline
Link
 
What is the reference number for each team? How do I figure this out
 
JHight
offline
Link
 
Is there a greasemonkey script to run this without excel?
 
Link
 
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.

I downloaded the Office 2007 file linked in the OP (let me know if there is a newer, better file)

I input the teams for Alpha and Zeta in the correct spots.

I input the schedule reference numbers for both conferences and do not get any errors in the error fields so it indicates that I've done that properly for both conferences.

Then I input the scores in the Alpha page for Game 1 for all 16 teams, everything looks fine. All the remaining projected scores for Alpha teams looks right as well as the projected final standings and PA and PF, etc.

Now, here's where I start having problems.

I'm inputting the game 1 scores into the Zeta page and it's blowing up the Projected scores for all the games.

Here's a sceen shot after I've only entered in the Game 1 scores on the Alpha page: http://i277.photobucket.com/albums/kk57/jbgill/projBef.jpg - everything looks fine

Here's a screen shot after I've entered in just one score in the Zeta page. The score involves the 'West Wales Warriors' from Alpha and they lost 17-53. When I input that score into the winning Zeta's teams schedule it blows up all of the West Wales projections. If I keep going and input all of the scores on the Zeta page then every single projected score to 980-784 for example, and so on. My team is projected to score over 17,000 points. http://i277.photobucket.com/albums/kk57/jbgill/projAfter.jpg - I circled the spots where it shows what happens to the scores.
 
CDZYO
offline
Link
 
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.
 
usmcfla1
offline
Link
 
Just wondering i typed in the whole Alpha Conference to just get started and i noticed that the first 4 teams are not popping up with the schedule? it shows Err:502 for the first line and then #REF! for the rest of the schedule on the first 4 teams the other 12 teams are fine though. Any thoughts?
 
Page:
 


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