I don't believe the macro has been updated. I never used it personally, so I don't know how it works.
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
tomcollins
offline
offline
Late Satchmo? I knew he was sick/in a coma or something, but did he actually pass?
Stu618
offline
offline
Originally posted by Caledric
So far over 100 downloads and the only complaint is from a guy who can't seem to open it...
Hey man I just need help ok?
You played on one of my teams before remember
So far over 100 downloads and the only complaint is from a guy who can't seem to open it...
Hey man I just need help ok?
You played on one of my teams before remember
Jagmind
offline
offline
Only 7 sheets, maybe I'm imagining here but, weren't there more? I have some free time, so I'll see if I can get this to work properly. btw just save it as "leagueprojector.odf" for open office users.
Caledric
offline
offline
Originally posted by stuartalan618
Originally posted by Caledric
So far over 100 downloads and the only complaint is from a guy who can't seem to open it...
Hey man I just need help ok?
You played on one of my teams before remember
Lets start by asking what program are you trying to use to open it? and which file did you download?
If you hop on the IRC chat and send me a message there I can probably walk you through getting it up and running.
Originally posted by Caledric
So far over 100 downloads and the only complaint is from a guy who can't seem to open it...
Hey man I just need help ok?
You played on one of my teams before remember
Lets start by asking what program are you trying to use to open it? and which file did you download?
If you hop on the IRC chat and send me a message there I can probably walk you through getting it up and running.
Caledric
offline
offline
Originally posted by Jagmind
Only 7 sheets, maybe I'm imagining here but, weren't there more? I have some free time, so I'll see if I can get this to work properly. btw just save it as "leagueprojector.odf" for open office users.
actually there used to be only 6. The last sheet is just a blank sheet that I didn't take off.
Only 7 sheets, maybe I'm imagining here but, weren't there more? I have some free time, so I'll see if I can get this to work properly. btw just save it as "leagueprojector.odf" for open office users.
actually there used to be only 6. The last sheet is just a blank sheet that I didn't take off.
Jack Del Rio
offline
offline
Originally posted by Caledric
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
mikeydz
offline
offline
The week 16 sum didn't go away for me with the second version for one of the conferences, but otherwise, it working up to this point.
CTGuyton
offline
offline
Originally posted by tomcollins
Late Satchmo? I knew he was sick/in a coma or something, but did he actually pass?
Late Satchmo? I knew he was sick/in a coma or something, but did he actually pass?
Caledric
offline
offline
Originally posted by Jack Del Rio
Originally posted by Caledric
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
Hmmm, not sure why its doing that... the 2nd download is just a conversion of the first download. Are people having this issue with the 2007 version as well? If so It may be that I saved it before I swapped the formulas for those two boxes.
Originally posted by Caledric
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
Hmmm, not sure why its doing that... the 2nd download is just a conversion of the first download. Are people having this issue with the 2007 version as well? If so It may be that I saved it before I swapped the formulas for those two boxes.
Jagmind
offline
offline
Just to clarify, is this correct?
http://snipr.com/57uyw
When you say team reference number, you mean team id, right? That's what I did.
http://snipr.com/57uyw
When you say team reference number, you mean team id, right? That's what I did.
Caledric
offline
offline
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
It should look like this.
http://etlebut.openface.ca/~silver/daoc/images/Scorpion/LeagueProj.JPG
Jack Del Rio
offline
offline
Originally posted by Caledric
Originally posted by Jack Del Rio
Originally posted by Caledric
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
Hmmm, not sure why its doing that... the 2nd download is just a conversion of the first download. Are people having this issue with the 2007 version as well? If so It may be that I saved it before I swapped the formulas for those two boxes.
Ah well I'm sure the projector works as you have it, it's just that it still thinks week 16 is the inter-conference game, that's why the sum is showing up below weeks 1 and 16 for alpha, and below week 1 for zeta (because the sum of week 16 zeta is the same as if you were to put 1-16 in the cells from alpha), and the names aren't turning from orange to white as they used to in the old projector.
http://img206.imageshack.us/img206/7393/n31404230326193207200gl0.jpg
Whatever, it just means you have to keep track of what you're doing. if all but those two sums disappear it's probably fine, the rest of the projector should work correctly right?
Originally posted by Jack Del Rio
Originally posted by Caledric
Someone who had the password was kind enough to share with me so I could make the necessary fixes for the projector to work with Bort's changing the interconf matchups to week 1 instead of week 16.
If anyone has any issues with the new spreadsheet please shoot me a PM with full details on what you were doing and what kind of problem occured and I will do my best to troubleshoot.
Here is the link to the new file:
http://files.filefront.com/League+Projectorxlsx/;12276590;/fileinfo.html
This file is for Microsoft Excel 2007
http://files.filefront.com/League+Projectorxls/;12276678;/fileinfo.html
This file is for Microsoft Excel 93-2003 NOT GUARANTEED TO WORK!! This was saved into 93-2003 format from 2007.
The 2nd one is still showing the sum when I input 17-32 in Week 1, while the sum goes away if I put it in week 16 like the old projector, is that just something you didn't get around to changing and it's working as intended or is that why the 2nd download "might not work"?
Hmmm, not sure why its doing that... the 2nd download is just a conversion of the first download. Are people having this issue with the 2007 version as well? If so It may be that I saved it before I swapped the formulas for those two boxes.
Ah well I'm sure the projector works as you have it, it's just that it still thinks week 16 is the inter-conference game, that's why the sum is showing up below weeks 1 and 16 for alpha, and below week 1 for zeta (because the sum of week 16 zeta is the same as if you were to put 1-16 in the cells from alpha), and the names aren't turning from orange to white as they used to in the old projector.
http://img206.imageshack.us/img206/7393/n31404230326193207200gl0.jpg
Whatever, it just means you have to keep track of what you're doing. if all but those two sums disappear it's probably fine, the rest of the projector should work correctly right?
Last edited Nov 7, 2008 16:52:49
Jagmind
offline
offline
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
Ah, now it all makes sense lol. I guess I'll order it alphabetical for more convenience.
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
Ah, now it all makes sense lol. I guess I'll order it alphabetical for more convenience.
You are not logged in. Please log in if you want to post a reply.
