User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Link
 
got the predictions workng!
 
ckshowtime
offline
Link
 
Originally posted by CDZYO
Originally posted by ckshowtime

Originally posted by CDZYO


Originally posted by ckshowtime



If I deleted rows on the predictions tab for Western (Alpha), is there no way to get them back other than starting a new sheet and copying everything?


You can probably copy the rows (or the entire sheet) from a fresh copy. I almost had to do the same thing.


Not having any luck with that so far.


If you still have your Zeta predictions sheet:

1) Delete the Predictions (Alpha) predictions sheet.
2) Make a second copy of the Predictions (Zeta) sheet.
2a) You can do this by right-clicking the Predictions (Zeta) tab, choosing "Move or Copy", checking the "Create a copy" box, and then clicking the "OK" button.
3) Rename the copied Predictions (Zeta) sheet to Predictions (Alpha).
4) On the freshly renamed Predictions (Alpha) sheet, press ctrl-H to bring up the "Find and Replace" dialogue.
4a) Click on the "Replace" tab.
5) In the "Find what:" field, type Zeta. In the "Replace with:" field, type Alpha.
6) Click on the "Replace All" button.

That should do the trick. What you're doing is making a copy of the Zeta predictions sheet, and then changing all of the references from Zeta to Alpha.


Thanks. I will try this when I get to work on Friday.
 
nthomas
offline
Link
 
Originally posted by sdumont
Originally posted by CDZYO

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.



*********ERROR HAS BEEN FOUND********************

Didn't take me long once I finally looked a little harder.

- On both Alpha Conference and Zeta Conference sheets you need to go into cell "DF5"
- The incorrect formula should show "=BF19"
- This formula should be "=BF20"

***This fixes the problem above***



Okay, I may be an idiot, but I am still having problems with team 4 in zeta. How can I find cell DF5. My columns go from CB to DM.

Also, and suggestions for dealing with a team gutted mid season? Obviously, the games they will play post-gutting will be much different than those pre-gutting. Thanks in advance.
 
Caledric
offline
Link
 
you'll need to download the new spreadsheet NT. the column is hidden in part of the spreadsheet that is protected.
 
Caledric
offline
Link
 
As far as dealing with a gutted team... really not much you can do.
 
ckshowtime
offline
Link
 
Originally posted by ckshowtime
Originally posted by CDZYO

Originally posted by ckshowtime


Originally posted by CDZYO



Originally posted by ckshowtime




If I deleted rows on the predictions tab for Western (Alpha), is there no way to get them back other than starting a new sheet and copying everything?


You can probably copy the rows (or the entire sheet) from a fresh copy. I almost had to do the same thing.


Not having any luck with that so far.


If you still have your Zeta predictions sheet:

1) Delete the Predictions (Alpha) predictions sheet.
2) Make a second copy of the Predictions (Zeta) sheet.
2a) You can do this by right-clicking the Predictions (Zeta) tab, choosing "Move or Copy", checking the "Create a copy" box, and then clicking the "OK" button.
3) Rename the copied Predictions (Zeta) sheet to Predictions (Alpha).
4) On the freshly renamed Predictions (Alpha) sheet, press ctrl-H to bring up the "Find and Replace" dialogue.
4a) Click on the "Replace" tab.
5) In the "Find what:" field, type Zeta. In the "Replace with:" field, type Alpha.
6) Click on the "Replace All" button.

That should do the trick. What you're doing is making a copy of the Zeta predictions sheet, and then changing all of the references from Zeta to Alpha.


Thanks. I will try this when I get to work on Friday.


This worked. thanks again.
 
nthomas
offline
Link
 
Originally posted by Caledric
you'll need to download the new spreadsheet NT. the column is hidden in part of the spreadsheet that is protected.


So there is no way to fix the sheet I have. I really don't want to have to re-enter all the team data this far into the season. Thanks.
 
CDZYO
offline
Link
 
No problem, ck. Glad to help.

Originally posted by nthomas
Originally posted by Caledric

you'll need to download the new spreadsheet NT. the column is hidden in part of the spreadsheet that is protected.


So there is no way to fix the sheet I have. I really don't want to have to re-enter all the team data this far into the season. Thanks.


It's a copy and paste -- team names into the GQ column, schedules to the right, and results in the team records. 36 copies and pastes from the old sheet to the new sheet.

I only say it's easy because I'm getting lots of practice doing it.

 
TMW
offline
Link
 
Will there be anyway to predict the playoff games?

The regular season has been fun, it'd be great to predict the playoff games when you typically have better matchups, and a ton of data.
 
Caledric
offline
Link
 
Originally posted by TMW
Will there be anyway to predict the playoff games?

The regular season has been fun, it'd be great to predict the playoff games when you typically have better matchups, and a ton of data.


Playoffs are a whole different beast and I have no plans of even trying to write a predictor for them. Everything is thrown out the window for playoffs because of boosting.
 
LifeJuice
offline
Link
 
bump
 
Caledric
offline
Link
 
Originally posted by LifeJuice
bump


you bumped a sticky?
 
TMW
offline
Link
 
Originally posted by Caledric
Originally posted by TMW

Will there be anyway to predict the playoff games?

The regular season has been fun, it'd be great to predict the playoff games when you typically have better matchups, and a ton of data.


Playoffs are a whole different beast and I have no plans of even trying to write a predictor for them. Everything is thrown out the window for playoffs because of boosting.


That makes sense - buuuuuuut....if you have the time...and want some grateful people...

Would it be possible to sim "hypothetical" matchups with the information available? So for instance, if someone on the forum wanted to know how Team A in Zeta would do against Team B in Alpha? Would that be possible?

Like assign a team number to each team, 1 - 32, and then have the spreadsheet predict a score for team 5 vs team 27, with the data available? You wouldn't need the whole playoff structure, and obviously boosting is taken out, but if we want to predict hypothetical scores, even in the middle of the season, we could do it?

I'm not sure if that is possible, but it'd be really cool.

Thanks for doing this...it's been a lot of fun.
 
CDZYO
offline
Link
 
That would be a pretty cool addition.
 
Snark
offline
Link
 
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
 
Page:
 


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