User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > League Projector Spreadsheet Updated for changes to schedule.
Page:
 
Caledric
offline
Link
 
Originally posted by nheeren
Originally posted by sdumont

Originally posted by Office 2007 Version


http://files.filefront.com/League+ProjectorOffice+07xlsx/;12317431;/fileinfo.html


Originally posted by Office 97-03 Version ***Can't Guarantee Working Copy***


http://files.filefront.com/League+ProjectorOffice+973xls/;12317432;/fileinfo.html




Is this office 2007 file different than the one at the beginning of the thread?


Yes, Sdu made some tweaks to the formulas and added in RPI to the projection menu.
 
Tukash
offline
Link
 
I can't get it to work. After I enter all the teams in and their schedules. When you look under each team, the 1st game doesn't show the team they are to be playing, it just says "#value". Weeks 2 - 16 are fine with the correct team in the cell. This is on every team.
 
nheeren
offline
Link
 
My formatting doesn't show anything...

a bunch of numbers with long decimals...
 
LiamVengeance
offline
Link
 
Originally posted by LiamVengeance
http://img367.imageshack.us/my.php?image=pic1bo3.jpg
Whats with the purple boxes?

http://img227.imageshack.us/my.php?image=pic2ng5.jpg

http://img161.imageshack.us/my.php?image=pic3yy3.jpg
This page is blank unlike A-Wad's :S


Help pleaseee


any help yet?
 
sdumont
offline
Link
 
Originally posted by nheeren
My formatting doesn't show anything...

a bunch of numbers with long decimals...


The RPI Rankings I added screwed it up...I'm currently fix it...I need to pull out the RPI rankings to get that to correct itself and I'll place the RPI rankings another way.
 
sdumont
offline
Link
 
Originally posted by LiamVengeance
Originally posted by LiamVengeance

http://img367.imageshack.us/my.php?image=pic1bo3.jpg
Whats with the purple boxes?

http://img227.imageshack.us/my.php?image=pic2ng5.jpg

http://img161.imageshack.us/my.php?image=pic3yy3.jpg
This page is blank unlike A-Wad's :S


Help pleaseee


any help yet?


The purple boxes are there when no score is entered....this was originally setup by the creator so you knew what boxes you could enter information in.

Your page could be blank for several reasons. I see you have the teams entered on the schedule, but it doesn't appear that any scores have been inputted. The format screen has nothing to go on without a data entered.
 
sdumont
offline
Link
 
Originally posted by Tukash
I can't get it to work. After I enter all the teams in and their schedules. When you look under each team, the 1st game doesn't show the team they are to be playing, it just says "#value". Weeks 2 - 16 are fine with the correct team in the cell. This is on every team.


Make sure you have the schedule entered correctly for week 1. You won't be using the numbers 1-16 for week 1. Your numbers should be ranging for 17-32... If you have them entered correctly...
 
_SaAnTo_
offline
Link
 
After many Weeks the prediction is avaiable?
 
sdumont
offline
Link
 
The predictions should be available after entering the scores for Week 1...but honestly you won't see any decent predictions until after the first several weeks
 
Jagmind
offline
Link
 
How soon should it be fixed? I got some other things to do but I want to get this spreadsheet over with.
 
sdumont
offline
Link
 
I won't be able to do it until late tonight....the changes I make won't be huge, so all you'll need to do is copy and paste your schedule and scores you've already entered in the one you are using
 
nheeren
offline
Link
 
Originally posted by sdumont
I won't be able to do it until late tonight....the changes I make won't be huge, so all you'll need to do is copy and paste your schedule and scores you've already entered in the one you are using


Thank god!
 
Tukash
offline
Link
 
Grrr I kind of got it working now, the schedules are correct, BUT... the green and red boxes that show the record of the teams beaten and victorious aren't correct. We have only played 2 games, but some of them end up showing records of 3 games played, or only 1 game played. So I'm not sure what's up with that. Other than that it seems to be working, except for the fact it predicts we won't win another game (we won the 1st 2) not only that it says we won't score the rest of the season. LOL
 
crzyblue
offline
Link
 
LOL I found the predictions to be off... but if you look it might be the colored boxes that are wrong... if you lose does it show one in black and one number in red? I got mine to work except for the predicted score.
 
sdumont
offline
Link
 
Originally posted by Office 2007
http://files.filefront.com/League+ProjectorOffice+07xlsx/;12352196;/fileinfo.html

Originally posted by Office 97-03
http://files.filefront.com/League+ProjectorOffice+973xls/;12352198;/fileinfo.html


Ok...so I originally said that copying and paste would be ok, but it won't be for everything. I believe I worked out all of the bugs now, but I'm not 100% positive. RPI Rankings are still available, but I put them on there own sheet. It does not automatically sort, so if you want them in order, you will need to use the sort feature. Also, the RPI feature is no longer in the drop down list and the format feature is now fixed.

Type in your teams in the appropriate area for the schedule. DO NOT copy and paste the team names from a previous version....assuming you TYPED all the teams in the same order as before, you can copy the schedule(numbers you entered) and paste them from the old one...just make sure you don't copy the team names, just the numbers.

For the scores you entered on the previous version...just like the team names...DO NOT copy and paste....unfortunately you will need to type in the scores manually again...if you copy and paste, it'll mess it up....

Just some notes to answer questions that will more than likely come in. Because the non-conference games are in week 1, the RPI and projections will look like they are not working correctly, but they are. Once you enter your Week 2 games, you will see everything start coming into shape.

The Macro will not work on this Version without tweaking the macro itself. If anyone knows anything at Visual Basic feel free, but I don't plan on fixing it myself.

 
Page:
 


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