Bring advanced statistics to your basketball program! This calculator allows you to keep game and season efficiency numbers for your team for up to a 45 game season. It helps you see which players score the most points when you are on offense, and give up the fewest points when you are on defense. You can evaluate your players more effectively by seeing who is best on both offense and defense.
College and pro teams use points per possession as a valuable metric in finding out how efficient they are as a team. This calculator will automatically figure out offensive, defensive, and net points per possession for your team and each player. You will also get a running score and true plus-minus numbers for each player, and number of possessions each player plays.
The calculator is very easy to use, and can be entered by anyone who has access to a device that runs Excel or Open Office. Coaches, parents, or managers can enter the numbers, and it updates in real time, giving the coach the opportunity to use the numbers during the game if you would like.
This does not need to be updated, nor is this a subscription service. Once you buy it you may use it for multiple seasons, and for multiple levels. Use it with your boys and girls teams.
Instructions for Efficiency Calculator
1. Go to Game 1 tab, and enter the numbers of your players in the red area from cells A2 to O2. The numbers you enter will automatically transfer to cells R3-R17. You will need to enter the numbers of the players in the same position for each game if you want the season statistics totals to work.
2. Starting in the yellow area in line 3, put the number 1 under each of the 5 players that are in the game. For each possession they are in the game for, they need to have a 1 entered under their number.
3. For each possession, enter the number of points each team scores in the green area.
4. When your team substitutes, enter a 1 for the players who enter in the yellow area, and leave the yellow area blank for everyone on the bench.
5. Your statistical totals for the game (and season) will automatically update if you correctly input the information. Refer to the example for how the calculator should look.
6. After a substitution, if the team with the ball doesn't match up leave a green space blank. See the example worksheet for an example.
Explanation of Statistics
1. Off Eff- Points per possession on offense
2. Def Eff- Points per possession on defense
3. Nef Eff- Offensive efficiency minus defensive efficiency
4. Off & Def Points- total points scored and given up while in the game
5. Possessions- number of possessions player was in for
6. Plus-minus- Points scored minus points given up while in game