For instructio ns in the use of this spreadsh eet, and basic Microsoft Excel informatio n, use the tabs below to find the workshee t labeled "Instructio ns" and click on it.
This product brought to you free of charge from www.FBf
orYouth.c om. Feel free to copy it for friends and distribute it to anyone that can be helped by it.
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.
Sam Willie Mike Clyde Frank
Position
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
LOLB ROLB MLB RCB FS
9 7 13 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 1 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 8 16 2 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Fu Rec
23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
Position
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
RDT
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Bubba Gump
Fu Rec
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
D efe nsi ve Stat isti
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Position
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 7 13 1 2
3 1 5 1 0
6 8 16 2 9
3 1 0 0 0
1 0 0 0 0
Fu Rec
cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
___ 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5.
___ ______ ____ _____ _____
Position
____ ____ ___ ___ __
6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42.
Position
0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
43. 44. 45.
0 0 0
0 0 0
0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
D efe nsi ve Stat
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
___ 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5.
___ ______ ____ _____ _____
Position
____ ____ ___ ___ __
6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42.
Position
0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
43. 44. 45.
0 0 0
0 0 0
0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
D efe nsi ve Stat
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
___ 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5.
___ ______ ____ _____ _____
Position
____ ____ ___ ___ __
6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42.
Position
0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
43. 44. 45.
0 0 0
0 0 0
0 0 0
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22.
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
D efe nsi ve Stat isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
D efe nsi ve Stat isti cs Player Name
1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33.
D efe nsi ve Stat
Position
___ ______ ____ _____ _____ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
____ ____ ___ ___ __ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
isti cs, Con tinu ed Player Name
35. __________ 36. 37. 38. 39. 40. 41. 42. 43. 44. 45.
Welcome to the Youth Football Defensiv e Stat Keeper by Coach Wade. Stat Keeper is a simple spreadsh eet written on Microsoft Excel. It's designed
Position
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
___ 0 0 0 0 0 0 0 0 0 0
Tackles
Tackles For Loss
Assists
Sacks
Fumbles Caused
Fu Rec
with the scaled down youth defense in mind, but can be customiz ed with a little knowledg e to be used with more complex systems.
Here's how to use Stat Keeper: Step One: Adding Players
1. 2. 3.
Player Name Sam Willie Mike
Click on the tab below labeled "Total Defense". You'll see a section of the page that looks similar to what is above.
Position
Tackles
LOLB ROLB MLB
0 0 0
Tackles For Loss 0 0 0
Anything you type in the blue and green squares will be repeated on every game page. Type the names of your defensive players and the position they play on defense in on THIS PAGE ONLY. If you type them on the game day pages, the program won't work. They'll appear automatic ally on those pages. (Note: These colors appear only on this page. The normal Stat Keeper page is grey with white fill boxes.)
Player Name 1. 2. 3.
Sam Willie Mike
Don't type anything in the areas marked in red. These stats will be updated automatic ally from your game pages. After your first game, click on the tab labeled "Game One" and enter your defensive totals for the game. (You can rename these tabs by double clicking on them. Then you can
Position
Tackles
Tackles For Loss
LOLB ROLB MLB
0 0 0
0 0 0
change the name of the tab to the name of your opponent .)
Feel free to type over the player names and stats already listed. They're just there as examples to show you how Stat Keeper works.
You may find the following table useful for decipheri ng a standard abbreviati on for defensive position names: Position
Abbrevia tion
Left Defensiv
LDE
e End Left Defensiv e Tackle Left Defensiv e Guard Nose Tackle Right Defensiv e Guard Right Defensiv e Tackle Right Defensiv e End Left Outside Lineback er Left Inside Lineback er Middle Lineback er Right Inside Lineback er Right Outside Lineback er Strong Lineback er Weak Lineback er Left Corner Back Right Corner Back Free Safety Strong Safety
LDT LDG NT RDG RDT RDE LOLB
LILB
MLB/MIK E RILB
ROLB
SAM WIL/WIL LIE LCB RCB FS SS/$
Step Two: Game Day Stats Once you are on the "Game One" tab, you should see a list of your players. Type in your defensive stats, such as number of tackles, fumbles recovere d, etc. that each player made. Stat Keeper will automatic ally transfer these numbers to the "Total Defense" tab.
Player Name 1. 2. 3.
Sam Willie Mike
Position
Tackles
Tackles For Loss
SOLB WOLB MLB
0 0 0
0 0 0
On the Game sheets, type only in the areas shown in red in the diagram above. Until you place a number in each square, Stat Tracker will show "0" in the equivalen t box on the "Total Defense" tab. This is because it has no values to compute yet.
Step Three: Figuring Season Totals Like Stat Tracker does for offense, Stat Keeper automatic ally keeps track of your player's progress througho
ut the season. If Mike, your middle linebacke r, makes nine tackles in game one, and seven tackles in game three, when you enter the data for those games into the tabs, the "Total Defense" sheet will be automatic ally updated to reflect his new numbers. This way, figuring season and game day goals and awards is a snap.
If you have any questions , feel free to contact Coach Wade at CoachWa
de@infos ports.net for assistanc e.