Serani
13th September 2004, 02:14 PM
Many of us can't afford another $10 (even a one-time thing), so I put this together for those of us who can't afford StatTracker (or just don't want to pay the extra $10 for something like this).
Here is the new Poor Man's StatTracker for this year. Very much like the one I did a couple of years ago. The only differences so far is the sheet for your opponent and a listing of the scoring.
On the opponent sheet, I only listed the positions, rather than including a space to put the players name, as I discovered last year that it got to be a pain to change those every week. It was enough to have to put the stats in.
On both sheets, the defense points will reflect 10 points for "points allowed" until something is entered into that cell.
Also, when you go to clear out the old data, be sure to delete the columns individually as the formulas are in hidden columns between the columns you enter data in. The sheet is protected witha password of pepis and won't allow you to delete the forumulas. You'll have to unprotect to get it to allow you to edit those. I only did that because I can't tell you how easy it is to delete all of it by accident.
The spreadsheet is here. (http://mysite.verizon.net/crystal.brook/pmst.xls)
Here is the new Poor Man's StatTracker for this year. Very much like the one I did a couple of years ago. The only differences so far is the sheet for your opponent and a listing of the scoring.
On the opponent sheet, I only listed the positions, rather than including a space to put the players name, as I discovered last year that it got to be a pain to change those every week. It was enough to have to put the stats in.
On both sheets, the defense points will reflect 10 points for "points allowed" until something is entered into that cell.
Also, when you go to clear out the old data, be sure to delete the columns individually as the formulas are in hidden columns between the columns you enter data in. The sheet is protected witha password of pepis and won't allow you to delete the forumulas. You'll have to unprotect to get it to allow you to edit those. I only did that because I can't tell you how easy it is to delete all of it by accident.
The spreadsheet is here. (http://mysite.verizon.net/crystal.brook/pmst.xls)