I have some questions with the Maddies Team Mgmt v.07.26.07 spreadsheet after the Recuits came in the roster. I am using Excel 2007 and have enabled Macros and everything else.
In the initial file I received I changed the TEAM ID, COACH ID and WORLD to my settings and it updated the INFO Sheet and it displayed correctly.
I then went to the GROUNDZERO sheet.
Here it says to go to the ROSTER Sheet and Copy the players and data and Paste Special/Values.
Questions:
There are two ROSTER sheets (Roster & Roster(2)).
The ROSTER Sheet contains my players.
The ROSTER(2) contains unkown players (which I assume where in the inital file).
I went to ROSTER sheet and copied starting at the cell with the first players name all the way down to the last cell (TOT) in the TEAM AVERAGES row and then went to GROUNDZERO and Highlighted the existing players and did the Paste Special/Value.
After coping my data into GROUNDZERO I have the Attribute Description row then the AVERAGES and TEAM AVERAGES from the previous data is still displayed.
#1 - Can I delete ROSTER(2) sheet?
#2 - In GROUNDZERO all of the players show.
I then go to the ATTIMPRV and am missing a number of players?
QB - 1
RB - 1
WR - 1
TE - 1
For example QB's - I previously had 2 QB's and recruited 3 more for a Total of 5 QB's. I updated today and they all show on the ROSTER sheet.
All 5 show in the ROSTER sheet.
All 5 show in the GROUNDZERO sheet.
In the ATTIMPRV sheet I am missing 1 QB. It is the 5th one.
I notice what maybe the problem.
In the ROSTER sheet after the 4th row there is a BOLD line and it looks like it seperates the 5th row.
I thought this maybe the issue but in my RB's I have a Total of 7. I initally had 4 then recuited 3 for a total of 7. Here the 3 Freshmen are there then there is a bold line then the 4 existing rows.
In the ATTIMPR it only displays 6 RB's. It dropped the last one.
Also in the RB section the first 4 rows are blank and in the Attribute cells is says #N/A?
Also, before I updated the file with the new recuits I had some values in the cells of the ATTIMPR that were either -1, 0, 1. Now they are all zeros?
Finally I am missing the same data in the DEPTHCHART sheet?
Any ideas?
Doug