Warrior General Games

I just realized that the schedule part was not completely finished. Make sure to copy HC3:HC17 and paste it in GN3:HB17 before entering the schedule...it'll save time

Okay, I feel dumb but how do I figure out the PF and PA? Is it just the scores? I see a formula on the first instructions page, which I don't get.

Originally posted by Jagmind
Okay, I feel dumb but how do I figure out the PF and PA? Is it just the scores? I see a formula on the first instructions page, which I don't get.

The formula you see is there to just tell you how many scores you'll input throughout the season...all you need to do is enter the schedule accordingly and enter the scores as the games finish each week of the season.

Alright, so how do I go about doing this for the first week? Not much stats to figure this out.

Originally posted by Jagmind
Alright, so how do I go about doing this for the first week? Not much stats to figure this out.

Is your schedule in correctly? If so, then you just need to manually enter in the scores for the 1st week for each team.

Everything except week 16. I just double checked but a number still shows below the last team in week 16.

And I was talking since about what I enter in PF and PA for the first week. No games have been played, so how can I have this data? Do I just enter what I believe will be the score?

Originally posted by Jagmind
Everything except week 16. I just double checked but a number still shows below the last team in week 16.
Then there is something that is off with the schedule. Re-enter week 16 schedule....what number is showing up? Also, which version are you using...are you using the one I uploaded last night or the one that started this thread. I did notice some formulas were not completely corrected in the original one, so you may need to use the one I put up last night


Originally posted by Jagmind
And I was talking since about what I enter in PF and PA for the first week. No games have been played, so how can I have this data? Do I just enter what I believe will be the score?
You don't enter data until you have it. Why would you want to enter scores before they happen?

Strange, downloaded from your link and copy/pasted the info from the OP's link I had before and now there are no numbers below the schedule. Its all good now.

I typed everything in; teams, schedules, scores. The current standings works, but the projected standings won't work, any suggestions?

Edit: Actually, only the current standings work, none of the other options do.

I got everything functioning minus the formatted report. Nothing showing up there but some crazy numbers. No team names or anything. also shows Zeta at the top and Alpha at the bottom.

I can see the reports as I change them on each conference page, just not auto filling in the format sheet.

Thanks

Originally posted by bo0man
I typed everything in; teams, schedules, scores. The current standings works, but the projected standings won't work, any suggestions?

Edit: Actually, only the current standings work, none of the other options do.

I think that's because there needs to be a second frame of reference and a conference game in order to get enough data for formulate projections. Or I could be wrong

I haven't had the opportunity to play any games in the two leagues I'm in. After playing a conference game, let me know if you still have the problem. I may need to go in an tweak something. If you haven't used this spreadsheet in the past, the projection stuff doesn't usually look right until you get to between weeks 5-7...

I just entered scores from 1 league and there are some things that I still need to tweak. I'll post an updated one as soon as I fix the errors I found.

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?