User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Caledric
offline
Link
 
the rpi sorting is still on my list of things to do atm, also I'll look into it not ranking based on Bort's tie breaker rules as well.

looks like all the other questions got answered. None of this is major stuff that makes the sheet not work so due to my current time constraints it currently ranks below Working and Spending time with my girl.
 
Squicken
offline
Link
 
No! GLB is way more important than any girl!!!
 
fliphusker
offline
Link
 
as a team has been sold and its name has changed, do you just change the teams name in the schedule and it will be fixed?
 
Jack Del Rio
offline
Link
 
Originally posted by fliphusker
as a team has been sold and its name has changed, do you just change the teams name in the schedule and it will be fixed?


Yes
 
fliphusker
offline
Link
 
cool thx, just did not want it to implode on me, haha
 
CDZYO
offline
Link
 
Bug note: Open Office 3.0 under Vista appears to bungle some of the indirect formulas in both versions of the spreadsheet. "Err. 502" is common. This mostly affects the reporting and anything related to it -- the score predictions appear to be unaffected.

(I use the weasel word "appear" because I can't tell -- the affected formulas are hidden.)

Edit: Excel can read the sheet just fine after an Open Office save, so my best guess is that OO has trouble with the translation. It's probably better to let OO "catch up" than to make any changes to the sheet.
Last edited Jan 19, 2009 01:36:46
 
sdumont
offline
Link
 
Originally posted by Caledric
the rpi sorting is still on my list of things to do atm, also I'll look into it not ranking based on Bort's tie breaker rules as well.

looks like all the other questions got answered. None of this is major stuff that makes the sheet not work so due to my current time constraints it currently ranks below Working and Spending time with my girl.


Sorry I can't help out right now, too much on my plate as well
 
nickies
offline
Link
 
Hi guys.

This sheet is simply amazing, really nice job. I think it's just me and technology but something just seems to be wrong in my sheet. I've put up some screenshots to point out my problem:

http://img517.imageshack.us/my.php?image=standingsqk6.jpg
http://img297.imageshack.us/my.php?image=projectedstandingske8.jpg
http://img297.imageshack.us/my.php?image=formatlz3.jpg
http://img246.imageshack.us/my.php?image=predictionsyj2.jpg

Don't know if I did something wrong, cause I have already double-checked and I didn't seem to find any flaws.
 
CDZYO
offline
Link
 
Originally posted by nickies
Hi guys.
<snip>


Links are broken, so I can't see your screenshots. Are you using Excel or OpenOffice?

 
nickies
offline
Link
 
Originally posted by CDZYO

Links are broken, so I can't see your screenshots. Are you using Excel or OpenOffice?



Hmm, I'm at another computer right now and it works fine here. I'm using OpenOffice.

I put in all the info for the schedule and the results until week 10, but in the Format-sheet it just says "Value"
Last edited Jan 22, 2009 00:18:52
 
BigCowboysFan
offline
Link
 
Originally posted by nickies
Originally posted by CDZYO


Links are broken, so I can't see your screenshots. Are you using Excel or OpenOffice?



Hmm, I'm at another computer right now and it works fine here. I'm using OpenOffice.

I put in all the info for the schedule and the results until week 10, but in the Format-sheet it just says "Value"


Open office is the problem. I've noticed that it never works very well with open office. At least I couldn't get it to work. Although, there is a newer version of open office out that may help resolve the problem.

Also, unless I'm mistaken, the schedule has to be filled out for the entire season at the start, then updated with scores each week in order for it to work properly. So if you haven't entered in the entire schedule that may be the problem.
Last edited Jan 22, 2009 14:03:53
 
nickies
offline
Link
 
Hmm I'll see if I missed something with the updating of OpenOffice, and then I'll tell you the outcome. Thx
 
Caledric
offline
Link
 
I use excel 2007 and thus do not do Open office support.
 
goldielax25
offline
Link
 
everything works fine on my spreadsheet, except for one thing... the 2nd best team in my conference for some reason is projected to give up 200+ points in each of their next 5 games, all of them in games they should dominate. like i said, everything else works fine, and all of the scores are 100% inputted correctly for the entire season, but for some reason this one team has projected points allowed that are just waaay out of wack. anyone else have a history with this problem?
 
CDZYO
offline
Link
 
Originally posted by goldielax25
everything works fine on my spreadsheet, except for one thing... the 2nd best team in my conference for some reason is projected to give up 200+ points in each of their next 5 games, all of them in games they should dominate. like i said, everything else works fine, and all of the scores are 100% inputted correctly for the entire season, but for some reason this one team has projected points allowed that are just waaay out of wack. anyone else have a history with this problem?


Yes. Is the 2nd best team in the fourth team slot? There was a bug with that particular team slot that has since been fixed, so you might have an obsolete version of the sheet.

If not, I'll brainstorm some other possibilities.
 
Page:
 


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