User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
pat2007
offline
Link
 
Originally posted by Warhawk
I'm using this in USA A #5.

http://goallineblitz.com/game/forum_thread.pl?thread_id=1469535


hahaha!

Well, I am using it in USA AA3 and I will maybe do it for USA AAA2 as well.

http://goallineblitz.com/game/forum_thread.pl?thread_id=1472304
 
ckshowtime
offline
Link
 
OK...this thing is driving me crazy. I just started on the thing today, I have the "Alpha" conference schedule entered, and all orange cells are now white. I still have #'s in row 18 with the exception of Wk 2 & 15.

WTF am I doing wrong here? I guess I should mention that I am USA BBB9, if that matters.

**edit** I got the schedules done (but row 18 still has #'s). I also entered all game scores and these projections are WACK!! It actually projects a 1-4 team to be 12-4 because the one game they won was 160-0?

Weird. I like this thing so i will keep messing with it.
Last edited Nov 20, 2008 19:28:17
 
TMW
offline
Link
 
This is a lot of fun, but the in game projections are way off base. Still in week 6, it has a that hasn't scored more than 24 points this season, playing a team that allowed 42 points to the projected 16-0 winner of the division, to beat it by a score of 113-55.
 
CDZYO
offline
Link
 
A bug has popped up with the game 7 projection for Zeta 4 vs 13. I'll double-check my work, and then peek at the formulas to see if something's missing, but if someone else has seen this (or has a fix), I'd love to hear about it.
 
Jack Del Rio
offline
Link
 
Can anyone confirm that the "Microsoft Excel 93-2003" one is working now?
 
CDZYO
offline
Link
 
Originally posted by Jack Del Rio
Can anyone confirm that the "Microsoft Excel 93-2003" one is working now?


Except for the bug that I just reported (and which also shows up in some later games), I can. The particular formula is in a hidden column, so I can't see what it's doing to pull up the mixed message.

Edit: Sorry about not identifying the bug -- the sheet reported two different projected scores, with each team winning.
Last edited Nov 24, 2008 06:13:11
 
Caledric
offline
Link
 
I can't seem to duplicate the bug so I'm not sure what is wrong.
 
ckshowtime
offline
Link
 
I am not happy at all with the projections. All games are now projected as single digits to zero for every game?

I like the concept of this sheet but it is apparently not worth the time I have spent.
 
Caledric
offline
Link
 
what a constructive post that details the issue for me to try and troubleshoot it...
 
sdumont
offline
Link
 
Originally posted by Caledric
I can't seem to duplicate the bug so I'm not sure what is wrong.


It's a bug that has always happened. It's only with team 4. What I have found in the past that the team 4 projection is the correct one.
 
CDZYO
offline
Link
 
I'm on dial-up right now (hello, rural area!), but I'll post my copy of the spreadsheet tomorrow so that y'all can have a look-see if y'all want. I've been working around it, so no pressure for a quick fix from here.
 
ckshowtime
offline
Link
 
Originally posted by Caledric
what a constructive post that details the issue for me to try and troubleshoot it...


The issue is that all the projected games show scores similar to 4-0, basically they are no where near realistic. I would be more than happy to email you my sheet for you to look at if that would help. Just PM me an email address, or give me some place to upload it to.

thanks.
Last edited Nov 25, 2008 08:11:35
 
dbreeze
offline
Link
 
Is it possible to get this working in .ods format? I've tried both of the available formats with OpenOffice and can't get the line 18 #s to disappear even though all of the totals appear correct. Also, the schedules in Oceania A5 are not the usual repeat order for each team with apparently 2-3 variations. Would the spreadsheet be able to handle this? I suspect this to be the cause of my problems.
Last edited Nov 25, 2008 11:04:38
 
ckshowtime
offline
Link
 
Originally posted by dbreeze
Is it possible to get this working in .ods format? I've tried both of the available formats with OpenOffice and can't get the line 18 #s to disappear even though all of the totals appear correct. Also, the schedules in Oceania A5 are not the usual repeat order for each team with apparently 2-3 variations. Would the spreadsheet be able to handle this? I suspect this to be the cause of my problems.


It took me a couple of tries to get my row 18 fixed, turns out that the patten for schedules wasn't quite true. Now only columns 1 and 16 have a number in row 18, I can live with that.
 
Caledric
offline
Link
 
anyone who is having issues with their spreadsheet is free to email it to me at caledric@gmail.com and I'll look it over and see what I can find.
 
Page:
 


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