User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Stu618
offline
Link
 
Originally posted by Caledric
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.


Where can I get Microsoft Excel 2007?
 
CDZYO
offline
Link
 
Originally posted by Caledric
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.


Email sent. Dunno what you'll find, but it's worth the look-see.
 
Caledric
offline
Link
 
Originally posted by stuartalan618
Originally posted by Caledric

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.


Where can I get Microsoft Excel 2007?


download the office suite trial from MS then buy it.
 
ckshowtime
offline
Link
 
I fixed the weekly score projections, you can disregard my initial email. Once I got the schedule and game results in for the Eastern Conference everything scoring projections on each teams schedule is fine.

However the predictions tabs are showing the #VALUE! in columns G and H.

New email sent.
 
CDZYO
offline
Link
 
Originally posted by ckshowtime
I fixed the weekly score projections, you can disregard my initial email. Once I got the schedule and game results in for the Eastern Conference everything scoring projections on each teams schedule is fine.

However the predictions tabs are showing the #VALUE! in columns G and H.

New email sent.


Did you change the game number on the predictions tabs? It's the B2 cell on both sheets.
 
ckshowtime
offline
Link
 
Originally posted by CDZYO

Did you change the game number on the predictions tabs? It's the B2 cell on both sheets.


I can honestly say that no I did not. I will try that when I get to work in the morning.
 
sdumont
offline
Link
 
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***

 
Caledric
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***



when I get up tomorrow I'll make the fix to the master file and upload a new version.
 
CDZYO
offline
Link
 
Thanks, y'all! Will that fix all of the team 4 projections?
 
Caledric
offline
Link
 
fix has been made, and new files uploaded for future downloads. And yes this fixes all of Team 4's projections.
 
ckshowtime
offline
Link
 
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?
 
CDZYO
offline
Link
 
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.
 
ckshowtime
offline
Link
 
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.
 
Link
 
Predictions still not working for me.
Assuming it's automated, other tan changing the week #.

Projections have worked a while.

TY again!!!!!!
 
CDZYO
offline
Link
 
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.
 
Page:
 


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