User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Himewad
offline
Link
 
Originally posted by Caledric
no, that's incorrect. Team ref # refers to the number sitting to the left of the teams name on the spreadsheet.

It should look like this.

http://etlebut.openface.ca/~silver/daoc/images/Scorpion/LeagueProj.JPG


Can someone please post the "Zeta Conference" page as it should look? I entered the schedules for each team. Weeks 1 and 16 tie out, but weeks 2 through 15 all have "392" at the bottom. I have double-checked, and everything appears to be entered correctly. Help!

BTW, I'm using the 97 version, not the 93 version.
 
Himewad
offline
Link
 
Nevermind. I just realized that the Zeta Conference schedule needs to be numbered 1-16 instead of 17-32. Problem solved.
 
1freebird
offline
Link
 
Here is the formula; I tested it and didn't see any issues with the rest of the spreadsheet. ENJOY.

This of course as you can see goes into the GS Column of the spread sheet starting with the cell in row 3 then so on down to row 17. Once you get the GS column cells filled you can do a copy of that cell then highlight the rest of the columns in that row and paste it in. I know this season is already more then half over. so if Cedric doesn't get this in before next season, I thought I would place it out here for everyone that wants to use it.

Example of use : =IF(GS2=2,1,) basically if team 1 plays team 2 and you put the 2 in whichever week they play them, then in team 2s row a 1 is automatically filled in for that same week, this is true all the way down to row 17. That is why team16's formula is so big, it has to watch all the other rows looking for its number to be filled in.

=IF(GS2=2,1,)
=IF(GS2=3,1,(IF(GS3=3,2,)))
=IF(GS2=4,1,(IF(GS3=4,2,(IF(GS4=4,3)))))
=IF(GS2=5,1,(IF(GS3=5,2,(IF(GS4=5,3,(IF(GS5=5,4)))))))
=IF(GS2=6,1,(IF(GS3=6,2,(IF(GS4=6,3,(IF(GS5=6,4,(IF(GS6=6,5)))))))))
=IF(GS2=7,1,(IF(GS3=7,2,(IF(GS4=7,3,(IF(GS5=7,4,(IF(GS6=7,5,(IF(GS7=7,6)))))))))))
=IF(GS2=8,1,(IF(GS3=8,2,(IF(GS4=8,3,(IF(GS5=8,4,(IF(GS6=8,5,(IF(GS7=8,6,(IF(GS8=8,7)))))))))))))
=IF(GS2=9,1,(IF(GS3=9,2,(IF(GS4=9,3,(IF(GS5=9,4,(IF(GS6=9,5,(IF(GS7=9,6,(IF(GS8=9,7,(IF(GS9=9,8)))))))))))))))
=IF(GS2=10,1,(IF(GS3=10,2,(IF(GS4=10,3,(IF(GS5=10,4,(IF(GS6=10,5,(IF(GS7=10,6,(IF(GS8=10,7,(IF(GS9=10,8,(IF(GS10=10,9)))))))))))))))))
=IF(GS2=11,1,(IF(GS3=11,2,(IF(GS4=11,3,(IF(GS5=11,4,(IF(GS6=11,5,(IF(GS7=11,6,(IF(GS8=11,7,(IF(GS9=11,8,(IF(GS10=11,9,(IF(GS11=11,10)))))))))))))))))))
=IF(GS2=12,1,(IF(GS3=12,2,(IF(GS4=12,3,(IF(GS5=12,4,(IF(GS6=12,5,(IF(GS7=12,6,(IF(GS8=12,7,(IF(GS9=12,8,(IF(GS10=12,9,(IF(GS11=12,10,(IF(GS12=12,11)))))))))))))))))))))
=IF(GS2=13,1,(IF(GS3=13,2,(IF(GS4=13,3,(IF(GS5=13,4,(IF(GS6=13,5,(IF(GS7=13,6,(IF(GS8=13,7,(IF(GS9=13,8,(IF(GS10=13,9,(IF(GS11=13,10,(IF(GS12=13,11,(IF(GS13=13,12)))))))))))))))))))))))
=IF(GS2=14,1,(IF(GS3=14,2,(IF(GS4=14,3,(IF(GS5=14,4,(IF(GS6=14,5,(IF(GS7=14,6,(IF(GS8=14,7,(IF(GS9=14,8,(IF(GS10=14,9,(IF(GS11=14,10,(IF(GS12=14,11,(IF(GS13=14,12,(IF(GS14=14,13)))))))))))))))))))))))))
=IF(GS2=15,1,(IF(GS3=15,2,(IF(GS4=15,3,(IF(GS5=15,4,(IF(GS6=15,5,(IF(GS7=15,6,(IF(GS8=15,7,(IF(GS9=15,8,(IF(GS10=15,9,(IF(GS11=15,10,(IF(GS12=15,11,(IF(GS13=15,12,(IF(GS14=15,13,(IF(GS15=15,14)))))))))))))))))))))))))))
=IF(GS2=16,1,(IF(GS3=16,2,(IF(GS4=16,3,(IF(GS5=16,4,(IF(GS6=16,5,(IF(GS7=16,6,(IF(GS8=16,7,(IF(GS9=16,8,(IF(GS10=16,9,(IF(GS11=16,10,(IF(GS12=16,11,(IF(GS13=16,12,(IF(GS14=16,13,(IF(GS15=16,14,(IF(GS16=16,15)))))))))))))))))))))))))))))
 
TheBear
Roll Tide
offline
Link
 
I can't delete the team names for the new season. What am I doing wrong?

I deleted all the scores and schedule reference numbers, but it wont let me delete the team names? Does anyone know the password to unlok it?

EDIT: The link to download a new copy doesn't work anymore. Bummer.
Edited by TheBear on Jun 17, 2009 23:06:36
Edited by TheBear on Jun 17, 2009 23:05:37
 
dragonslade
offline
Link
 
Originally posted by TheBear
The link to download a new copy doesn't work anymore. Bummer.


I'd like to download this, does anyone have a working link?
 
Juan Fiddy
offline
Link
 
Originally posted by dragonslade
Originally posted by TheBear

The link to download a new copy doesn't work anymore. Bummer.


I'd like to download this, does anyone have a working link?


You just ruined some poor mans only means for redemption.
 
GmanV2
Lead Mod
offline
Link
 
Originally posted by dragonslade
I'd like to download this, does anyone have a working link?


 
jpjn94
doc ock
offline
Link
 
Originally posted by GmanV2
Originally posted by dragonslade

I'd like to download this, does anyone have a working link?




PM Sent

 
robbbeck
offline
Link
 
Originally posted by dragonslade
I'd like to download this, does anyone have a working link?


I would like a copy of this xls file also.
 
mahleumon
offline
Link
 
I also would like a copy of this in xls.

Thankyou
 
Splat
offline
Link
 
Anyone have a copy of this lying around?
 
TheBear
Roll Tide
offline
Link
 
I have it and still use it every season. Not sure how I could send it to you though. I'm open to suggestions.
 
The_Warden
offline
Link
 
Is it something a person can put up on google docs?
 
TheBear
Roll Tide
offline
Link
 
Try this link. Let me know if it doesn't work.

http://www.mediafire.com/?s97wx7w7176i7ye
 
peeti
offline
Link
 
what exactly does this and how do you use it?^^
 
Page:
 


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