User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
CDZYO
offline
Link
 
Originally posted by Snark
Hey folks,

I admit I couldn't bring myself to read every post in this thread, so apologies if this has been asked and answered, but:

In my projections (for Oceania AAA#1), there are some ties predicted for the next round of games. The ties seem to be registering as wins in the projected standings, though. It's not a huge deal, but it seems like it'd be relatively easy to fix?

Thanks in advance for any advice,

S


"ties" are only ties because of rounding. For example, a 24-24 projection might really be a 24.078-23.856 projection.

Speaking of ties... the RPI sheet doesn't acknowledge them.

Edit: Added quote because of page jump.
Last edited Dec 7, 2008 20:04:43
 
Snark
offline
Link
 
Originally posted by CDZYO
Originally posted by Snark

Hey folks,

I admit I couldn't bring myself to read every post in this thread, so apologies if this has been asked and answered, but:

In my projections (for Oceania AAA#1), there are some ties predicted for the next round of games. The ties seem to be registering as wins in the projected standings, though. It's not a huge deal, but it seems like it'd be relatively easy to fix?

Thanks in advance for any advice,

S


"ties" are only ties because of rounding. For example, a 24-24 projection might really be a 24.078-23.856 projection.

Speaking of ties... the RPI sheet doesn't acknowledge them.

Edit: Added quote because of page jump.


Ah, I should've noticed that one of the teams had the "tie" registering as a loss. Read twice, post once (or, in this case, not at all)... Anyhow, thanks for pointing that out.
 
nthomas
offline
Link
 
Anyone have a variation on the spreadsheet that uses the 16 games of the regular season to predict playoff games? I am sure it would not be too hard, since it would be adding on a few lines (making a 20 game schedule instead of 16), but I am not skilled enough to do it.
 
CDZYO
offline
Link
 
Originally posted by nthomas
Anyone have a variation on the spreadsheet that uses the 16 games of the regular season to predict playoff games? I am sure it would not be too hard, since it would be adding on a few lines (making a 20 game schedule instead of 16), but I am not skilled enough to do it.


I've been using a workaround -- if you wipe out the scores of the previous meeting (for both teams), the sheet will give you a prediction. Plug the original numbers back in, repeat. I don't know what I'll do for the 2nd round, though -- options are to do the same thing, or to add the first round scores by replacing the previous scores.
 
nthomas
offline
Link
 
Thanks. I will try that.
 
sdumont
offline
Link
 
Originally posted by nthomas
Anyone have a variation on the spreadsheet that uses the 16 games of the regular season to predict playoff games? I am sure it would not be too hard, since it would be adding on a few lines (making a 20 game schedule instead of 16), but I am not skilled enough to do it.


I cleared one sheet and then put all playoff teams on it. Then I adjusted the schedule and only put games against other playoff teams on it and entered the scores for those games. Some teams played a playoff team in there out of conference game...i used those too...so some teams on the schedule had 7 games, but a few had 8. After you get the scores entered, you should be able to put Round 1 of the playoff games in Week 9...
Last edited Dec 13, 2008 21:27:27
 
StewDog
offline
Link
 
Is there a way to do pre season predictions??
 
glassmatica
offline
Link
 
http://www.bobceres.com/public/glb/ <--more permanent home for the files. If anyone has any other glb related files that need a permanent hosted home, let me know and I'd be happy to upload them to my ftp as well.

Also, for those of you who do not have Excel, you can download Excel Viewer for free. It allows you to view any excel sheet, you just cannot make any edits.
Last edited Dec 27, 2008 11:58:46
 
carrmanda
offline
Link
 
can anyone pm me and explain to me how to use this please?
 
Coach79
offline
Link
 
In cell L30 it says that there are formulae in rows 3-17, but I checked and they are not present.
 
Caledric
offline
Link
 
Originally posted by Coach79
In cell L30 it says that there are formulae in rows 3-17, but I checked and they are not present.


let me check into this... anyone else having issues with the projector? I can't garuntee a quick fix like last season as I don't have as much free season this season, but I'll do my best to get any and all issues fixed up as fast as possible.

Coach do you know what or anything L30 effects so I can have a better understanding what I'm looking for?
 
Coach79
offline
Link
 
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....

It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.

-C
 
fliphusker
offline
Link
 
i think i have something really screwy going on. I put the teams in, the schedule in, right, and just added the scores in. What I get is some weird things. The pf and pa simply can not be like this. the odd thing is that in the spreadsheet, most of them just are listed as #####. is there something that i need to change, as I am a complete nub at this

Rk Team W L T % PF PA
1 Ottawa Beavers 15 1 0 94% 57,228 0
2 Skaro Daleks 15 1 0 94% 41,164 0
3 Arrowhead Fanatics 14 2 0 88% 108,405 3,871
4 Guam Carabao 13 3 0 81% 28,920 14,240
5 Bangkok Bangers 12 4 0 75% 17,460 12,512
6 Kuala Lumpur Pit Vipers 11 5 0 69% 26,070 20,076
7 PCE Pissed Drunk PubCrawlers 9 7 0 56% 8,211 14,345
8 Laos Warmachine 8 8 0 50% 11,400 20,196
9 Lumpinee Stadium Maine-iacs 7 9 0 44% 13,950 27,454
10 Phuket "Happy Endings" 6 10 0 38% 19,184 48,048
11 Easter Island Terror 5 11 0 31% 6,266 15,180
12 Johor Bahru Beach Bums 4 12 0 25% 8,007 23,405
13 Holiday In Cambodia 3 13 0 19% 10,920 35,156
14 Yokohama Samurai Warriors 2 14 0 13% 9,180 32,336
15 Blue City Bruisers 1 15 0 6% 4,190 63,246
16 Singapore Canes 0 16 0 0% 2,676 42,896
 
CDZYO
offline
Link
 
Originally posted by fliphusker
i think i have something really screwy going on. I put the teams in, the schedule in, right, and just added the scores in. What I get is some weird things. The pf and pa simply can not be like this. the odd thing is that in the spreadsheet, most of them just are listed as #####. is there something that i need to change, as I am a complete nub at this

Rk Team W L T % PF PA
1 Ottawa Beavers 15 1 0 94% 57,228 0
2 Skaro Daleks 15 1 0 94% 41,164 0
3 Arrowhead Fanatics 14 2 0 88% 108,405 3,871
4 Guam Carabao 13 3 0 81% 28,920 14,240
5 Bangkok Bangers 12 4 0 75% 17,460 12,512
6 Kuala Lumpur Pit Vipers 11 5 0 69% 26,070 20,076
7 PCE Pissed Drunk PubCrawlers 9 7 0 56% 8,211 14,345
8 Laos Warmachine 8 8 0 50% 11,400 20,196
9 Lumpinee Stadium Maine-iacs 7 9 0 44% 13,950 27,454
10 Phuket "Happy Endings" 6 10 0 38% 19,184 48,048
11 Easter Island Terror 5 11 0 31% 6,266 15,180
12 Johor Bahru Beach Bums 4 12 0 25% 8,007 23,405
13 Holiday In Cambodia 3 13 0 19% 10,920 35,156
14 Yokohama Samurai Warriors 2 14 0 13% 9,180 32,336
15 Blue City Bruisers 1 15 0 6% 4,190 63,246
16 Singapore Canes 0 16 0 0% 2,676 42,896


Wild guess -- because the intraconference games were moved to Game 1, the spreadsheet is having trouble figuring out how the games relate to each other. Personally, I'm no't worrying about it until Game 3 or so.
 
Caledric
offline
Link
 
Originally posted by Coach79
On the instructions page it says " Note: start with team 1 and work across the rows. There are formulae located in rows 3-17 that will assist you in filling the table." On "your" sheet there are no formulas, but on a sheet that I downloaded else where there are formulas present in the cells but they aren't working....

It would make it so much easier if I had those formulas, so I could figure out why my scheduling is off.

-C


ahh that yes... I I'm not exactly sure what broke there or why the formulas went missing. All they do is change the highlight of the cell though.
 
Page:
 


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