For instructions in the use of this spreadsheet, and basic Microsoft Excel information, use the tabs below to find the worksheet labeled "Instructions" and click o n it.
This product brought to you free of charge from www.FBforYouth.com. Feel free to copy it for friends and distribute it to anyone that can be helped by it.
Rushing Play 1. I-Right Pro 32 Dive 2. Tight Rip 88 SP 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. Totals:
Attempts
Yards
Avg gain.
2 7 0 0 0 0 0 0 0 0 0 0 0 0 0
16 51 0 0 0 0 0 0 0 0 0 0 0 0 0
8.00 7.29 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
9
67
7.44
Passing Play
Attempts
Com.
Yards
Avg gain.
2 3 0 0 0 0 0 0 0 0
1 1 0 0 0 0 0 0 0 0
54 13 0 0 0 0 0 0 0 0
27.00 4.33 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals: %:
5 40.00%
2
67
13.40
Total Offense:
Plays 14
Yards 134
Avg gain 9.57
1. Trips Left Option Pass 2. Wing Left 345-X 3. 4. 5. 6. 7. 8. 9. 10.
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Avg gain.
3 2 0 0 0 0 0 0 0 0 0
6 18 0 0 0 0 0 0 0 0 0
1 2 0 0 0 0 0 0 0 0 0
1 1 0 0 0 0 0 0 0 0 0
2.00 9.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Attempts
Com.
%
Yards
TDs
INTs
5 0 0 0 0
4 0 0 0 0
68 0 0 0 0
2 0 0 0 0
1 0 0 0 0
1. Toby 2. Bobby 3. 4. 5. 6. 7. 8. 9. 10. 11. Passing (Personnel) Player Name 1. Mike 2. 3. 4. 5.
80.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Rushing Play I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0 Totals:
Attempts
Yards
Avg gain.
2 7
16 51
8.00 7.29 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
9
67
7.44
Passing Play
Attempts
Com.
Yards
Avg gain.
2 3
1 1
54 13
27.00 4.33 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals: %:
5 40.00%
2
67
13.40
Total Offense:
Plays 14
Yards 134
Avg gain 9.57
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Avg gain.
3 2
6 18
1 2
1 1
2.00 9.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Attempts
Com.
%
Yards
TDs
INTs
5
4
68
2
1
Toby Bobby 0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
80.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0
Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Rushing Play
Attempts
Yards
I-Right Pro 32 Dive Tight Rip 88 SP 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Totals:
0
0
#DIV/0!
Yards
Avg gain.
Passing Play
Attempts
Com.
Trips Left Option Pass Wing Left 345-X 0 0 0 0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Totals: %:
0 #DIV/0!
Total Offense:
Plays 0
0
0
#DIV/0!
Yards 0
Avg gain #DIV/0!
Individual Statistics
Rushing (Personnel) Player Name
Attempts
Yards
TDs
Fumbles
Toby Bobby
Avg gain. #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 Passing (Personnel) Player Name Mike 0 0 0 0
Attempts
Com.
% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Yards
TDs
INTs
Welcome to the Youth Football Stat Tracker by Coach Wade. Stat Tracker is a simple spreadsheet written on Microsoft Excel. It's designed with the scaled down youth offense in mind, but can be customized with a little knowledge to be used with more complex systems. Here's how to use Stat Tracker: Step One: Adding Rushing Plays Rushing Play 1. I-Right Pro 32 Dive 2. Tight Rip 88 SP 3. 4.
Attempts
Yards
Avg gain.
0 7 0 0
0 51 0 0
#NUM! 7.29 #NUM! #NUM!
Click on the tab below labeled "Total Offense". You'll see a section of the page that looks similar to what is above. Anything you type in the yellow squares will be repeated on every game page. Type your plays in on THIS PAGE ONLY. If you type them on the game day pages, the program won't work. They'll appear automatically on those pages. (Note: These colors appear only on this page. The normal Stat Tracker page is grey with white fill boxes.)
Rushing Play 1. I-Right Pro 32 Dive 2. Tight Rip 88 SP 3. 4.
Attempts
Yards
Avg gain.
2 7 0 0
16 51 0 0
8.00 7.29 #NUM! #NUM!
Don't type anything in the areas marked in blue. These stats will be updated automatically from your game pages. After your first game, click on the tab labeled "Game One" and enter your rushing totals for the game. (You can rename these tabs by double clicking on them. Then you can change the name of the tab to the name of your opponent.)
Feel free to type over the plays already listed. They're just there as examples to show you how Stat Tracker works. Step Two: Game Day Stats Once you are on the "Game One" tab, you should see a list of your plays. Type in the number of times you ran each play in the "Attempts" column, and the total yards gained with that play under "Yards." Stat Tracker will automatically compute your average gain.
Rushing Play
Attempts
Yards
Avg gain.
2 7 0 0
16 51 0 0
8.00 7.29 #NUM! #NUM!
1. I-Right Pro 32 Dive 2. Tight Rip 88 SP 3. 4.
Type only in the areas marked in green on the game sheets. Until you place a number in each square, Stat Tracker will show "#DIV/0!" in the Avg. Gain box. This is because it has no values to compute yet. Step Three: Adding Passing Plays The procedure for adding passing plays is very similar to the procedure for adding running plays. Make sure you only type your play names in the blue boxes on the tab "Total Offense", and do not type anything in the red boxes. Passing Play 1. Trips Left Option Pass 2.
Attempts
Com.
Yards
Avg gain.
0 0
0 0
0 0
#NUM! #NUM!
On the "Game One" tab, you should see a list of your passing plays now. Remember, if you need to change a play name, you must do it from the "Total Offense" tab, and not from any of the "Games" tabs. Passing
Play 1. Trips Left Option Pass 2.
Attempts
Com.
Yards
Avg gain.
2 0
1 0
54 0
27.00 #NUM!
Put the number of times you ran each passing play under the "Attempts" column, the number of times it was completed under "Com." and the total yards gained under "Yards". Don't put anything in the red boxes. Stat Tracker will fill those in automatically for you.
Step Four: Figuring Totals Stat Tracker provides several different totals for you that can assist in determining which of your plays are the most successful, as well as an overall season long offensive picture.
At the bottom of the rushing section of each game page is a section that looks something like this:
Totals:
Attempts
Yards
Avg. Gain
9
67
7.44
These numbers are filled in automatically as you enter your game day data. For example, if you run I-Right Pro 32 Dive six times for eighteen yards, Tight Rip 88 SP four times for ten yards, your totals would look like this:
Totals:
Attempts
Yards
Avg. Gain
10
28
2.80
What if you want to track your total offensive stats throughout the season? No problem. As you enter each game, week by week, the tab "Total Offense" will automatically be updated. So, lets say in week two you ran I-Right Pro 32 Dive nine times for 51 yards, and Tight Rip 88 SP 12 times for 94 yards. That's what you'll put into your "Game Two" rushing totals, and when you check the "Total Offense" tab, you'll see this:
Attempts
Yards
Avg. Gain
Totals:
31
173
5.58
This means that you should always have an accurate representation of how well each of your plays did, as well as how your entire offense is working. Passing stats are computed the same way. You need only update the numbers on the game day tabs,and Stat Tracker will take care of the rest for you.
Totals: %:
Attempts
Com.
Yards
Avg. Gain
2 50.00%
1
54
27.00
There is something important to note about passing statistics, though. The average gain is computed using pass attempts. This is a more accurate representation of how well the pass works. Computing passing stats for completions only can skew your numbers.
Total Offense:
Plays 11
Yards 121
Avg gain 11.00
Total offensive stats are also provided both on the "Total Offense" and game tabs. The "Total Offense" tab shows your entire offensive success for the season, and includes both passing and running plays.
Step Five: Personnel Stats; Rushing Rushing (Personnel) Player Name 1. Toby 2. Bobby 3.
Attempts
Yards
TDs
Fumbles
Avg gain.
3 2 0
6 18 0
1 7 0
1 3 0
2.00 9.00 #NUM!
Personnel stats are tracked in exactly the same way as team stats. Enter the players' names on the "Total Offense" tab in the boxes marked in green. Don't type anything in the red boxes. On the game day tabs, the players' names will appear automatically. After each game, enter the players' rushing totals. Stat Tracker will compute average gain for you, and update the "Total Offense" tab with the player's new information.
On the game day tabs, the players' names will appear automatically. After each game, enter the players' rushing totals. Stat Tracker will compute average gain for you, and update the "Total Offense" tab with the player's new information.
Passing (Personnel) Player Name Attempts 1. Mike 2. 3. 4. 5.
5 0 0 0 0
Com. 4 0 0 0 0
%
Yards
TDs
INTs
68 0 0 0 0
2 0 0 0 0
3 0 0 0 0
80.00% #NUM! #NUM! #NUM! #NUM!
Passing stats are tracked and updated the same way as the rushing stats.
If you have any questions about using Stat Tracker feel free to contact Coach Wade at
[email protected].