Build a basketball team shooting percentage spreadsheet

Coaching notes often record whether a player made a bucket, but a shooting percentage shows how consistently those attempts were converted. A well-built spreadsheet turns scattered game notes into useful evidence for rotation decisions, skill sessions and player feedback. It also gives volunteers a repeatable way to check totals after every game.

This template suits grassroots basketball in Australia, where clubs commonly rely on volunteer scorers, council grants, sponsors and fundraising. It works for teams playing at council courts in North Sydney, community centres in Melbourne’s Box Hill or school gyms in Toowoomba. Australian shorthand such as “bucket” and “shoot hoops” may appear in notes, while the spreadsheet itself keeps every recorded attempt consistent.

Set up the player and game log

Build the workbook with three worksheet tabs: “Shot Log”, “Player Summary” and “Team Summary”. The Shot Log should contain one row per attempt. Use these columns: Game ID, Date, Player, Period, Shot Clock, Shot Type, Result, Points, Venue and Notes. Free-throw shot-clock cells can remain blank, while every other field should follow the same format.

Give each player a consistent name or identifier in the Player Summary tab. If two players have similar names, use a player code such as “U14-07” in a separate ID column. Add columns for two-point attempts and makes, three-point attempts and makes, free-throw attempts and makes, points, total field-goal attempts and total field-goal makes. Reserve the final columns for field-goal, two-point, three-point, free-throw, effective field-goal and true-shooting percentages.

Enter shooting data cleanly

Choose a reliable match-day process. One volunteer can enter attempts during timeouts, while another records the result. A shot is an attempt whenever play resumes with a try, including a missed three-pointer. For shorter youth games, each player’s attempts can still be recorded individually; avoid mixing individual totals with shot-level rows in the same log.

Use dropdown lists for Player, Shot Type and Result. Shot Type should contain “2-point”, “3-point” and “Free throw”, while Result should contain “Made” and “Missed”. A points formula can then populate column H automatically: =IF(G2="Made",IF(F2="3-point",3,IF(F2="2-point",2,1)),0). This reduces typing errors when scorers enter the same shot repeatedly.

After each match, use a Game ID that includes the competition, round and venue, such as “U14-R3-BOX-HILL”. Check for blank player names, invalid shot types and totals that do not match the score sheet. Southern clubs often schedule their main competitions during the Australian winter, while northern schedules may span more of the year, so include dates when comparing performance across different stages of the season.

Calculate team and player percentages

On the Player Summary tab, calculate attempts directly from the Shot Log. For example, in B2 use =COUNTIFS('Shot Log'!$C:$C,$A2,'Shot Log'!$F:$F,"2-point") to count two-point attempts. In C2, add the same criteria plus "Made" to count successful two-point shots: =COUNTIFS('Shot Log'!$C:$C,$A2,'Shot Log'!$F:$F,"2-point",'Shot Log'!$G:$G,"Made"). Copy these patterns for three-point and free-throw columns.

Complete the supporting fields with =SUMIFS('Shot Log'!$H:$H,'Shot Log'!$C:$C,$A2) for points, =B2+D2 for field-goal attempts and =C2+E2 for field-goal makes. The basic percentages then become =IFERROR(J2/I2,0) for field-goal percentage, =IFERROR(C2/B2,0) for two-point percentage, =IFERROR(E2/D2,0) for three-point percentage and =IFERROR(G2/F2,0) for free-throw percentage. Format these cells as percentages rather than multiplying by 100.

Add effective field-goal percentage with =IFERROR((J2+0.5*E2)/I2,0). This credits a three-pointer slightly more than a two-pointer. True shooting percentage uses =IFERROR(H2/(2*(I2+0.5*F2)),0), combining field goals, free throws and total points. In the Team Summary row, sum the made and attempted columns before recalculating each percentage. Averaging player percentages would give a small-volume shooter the same influence as a regular starter, so team efficiency must be calculated from team totals.

Compare scoring efficiency

Raw percentages answer only part of the coaching question. Two-point percentage reveals close-range accuracy, three-point percentage measures perimeter conversion, and free-throw percentage adds another scoring route. Volume matters too: a 60 per cent shooter with four attempts has less evidence behind that figure than a player making 48 per cent of 50 attempts.

For example, consider a player who shoots 4-for-8 from three-point range and 2-for-4 from two-point range. The overall field-goal percentage is 6-for-12, or 50 per cent. Effective field-goal percentage becomes (6 + 0.5 × 4) ÷ 12, or 66.7 per cent. Another player shooting 8-for-16 from two-point range also has a 50 per cent field-goal percentage, but its lower effective value reflects the different value of each attempt.

Compare players within the same team, age group and role. A centre taking most shots near the basket should not be judged against a guard whose attempts come from beyond the arc. Rolling five-game and ten-game views can reveal improvement, while filters for home and away venues may expose differences in playing style. Treat early-season results as descriptive rather than predictive, especially when a player has limited attempts.

Turn the stats into a useful dashboard

Conditional formatting can place data bars beside attempts, giving coaches an immediate view of shot volume. A sorted bar chart can compare effective field-goal percentage by player, while a line chart can show the team’s weekly trend. Keep percentage charts separate from attempt charts so accurate but low-volume results do not dominate the display.

For a club presentation background, designers can browse Net Art Commons and check each item’s licence before reuse. Use visual assets sparingly, and make sure they do not obscure player names or numerical results. Colour-blind-safe colours, direct labels and an A4 landscape layout will keep the dashboard readable when printed for a committee meeting.

Make the dashboard actionable by showing the team total, the leading percentage in each shot category and a short comparison with the previous five games. Include games played and attempts beside every percentage. If the team uses tablets during matches, keep a printable score sheet as a backup and nominate one person to reconcile it with the spreadsheet each week.

Publish a season snapshot

Before sharing the results, check the date range, competition stage and player list. A season summary should identify whether the figures cover the full season, a selected round or the latest ten games. For junior competitions, publish player names only with appropriate consent and avoid adding unnecessary notes from the Shot Log.

Metric	Calculation	What it shows	Main consideration
Field-goal percentage	Field goals made ÷ field goals attempted	Overall accuracy from the floor	Compare players with similar roles
Two-point percentage	Two-point makes ÷ two-point attempts	Close-range and mid-range accuracy	Attempt volume matters
Three-point percentage	Three-point makes ÷ three-point attempts	Perimeter shooting accuracy	Small samples can fluctuate sharply
Free-throw percentage	Free throws made ÷ free throws attempted	Accuracy from the line	Pressure situations may differ from practice
Effective field-goal percentage	(Field goals made + 0.5 × three-pointers made) ÷ field goals attempted	Shot value adjusted for three-pointers	Use for cross-role comparison
True shooting percentage	Points ÷ [2 × (field-goal attempts + 0.5 × free-throw attempts)]	Scoring efficiency including free throws	Keep the same scoring definition throughout

Present each figure with its sample size and a plain-English note about what it indicates. Avoid labelling a player “accurate” or “inefficient” without context, since opponent quality, shot location and playing time also affect the result. Keeping the formulas and source rows intact allows coaches to refresh the snapshot whenever new games are added.

Download the basketball team shooting percentage spreadsheet from the free resource hub, copy it into your club’s shared drive and assign one scorer to update it after every game. Share the finished snapshot with coaches and parents so every player can review progress through consistent statistics rather than match-day memory.