Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| الإجماليات | |
|---|---|
| مباريات مسجلة | 14 |
| فوز | 9 |
| خسارة | 5 |
| نسبة الفوز | 64.3% |
| نقاط فريقك | 1,112 |
| نقاط المنافسين | 1,058 |
| مجموع الدقائق | 409 |
| نقاط اللاعب | 237 |
| ريباوند | 58 |
| أسيست | 92 |
| سرقات | 27 |
| بلوك | 6 |
| فقدان كرة | 47 |
| أخطاء شخصية | 35 |
| المتوسط في المباراة | |
| نقاط / مباراة | 16.93 |
| ريباوند / مباراة | 4.14 |
| أسيست / مباراة | 6.57 |
| سرقات / مباراة | 1.93 |
| بلوك / مباراة | 0.43 |
| فقدان كرة / مباراة | 3.36 |
| أخطاء / مباراة | 2.50 |
| دقائق / مباراة | 29.2 |
| متوسط تقييمي | 6.93 |
Example from the “الملخص” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- «الإعدادات» (Settings): The player's name, position, team and season, and the list of competitions the team plays in (up to 8).
- «المباريات» (Games): For each game: date, competition from the list, opponent and venue, your team's points and the opponent's points. Then the player's numbers: minutes, points, rebounds, assists, steals, blocks, turnovers and fouls, field goals, threes and free throws, and your rating from 1 to 10. For each row it calculates the result, the percentages and points per 36 minutes, and it warns you if a number does not add up. It holds 300 games.
- «الملخص» (Summary): Totals, averages and per-36-minute figures, shooting percentages, the best game, the form of the last 5 games, a home vs away comparison, and a table for each competition.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Record each game once and get averages, percentages and recent form out of it, so you can see whether a player's shooting is really improving and where they play best, instead of relying on how a game felt afterwards.
How to use it
- In the «الإعدادات» (Settings) sheet, enter the player's name, position, team and season, then list the competitions the team plays in (up to 8).
- In the «المباريات» (Games) sheet, log each game in one row: the date, the competition from the list, the opponent and whether you played home or away.
- Enter your team's points and the opponent's points, then the player's numbers: minutes, points, rebounds, assists, steals, blocks, turnovers and fouls.
- Enter field goals (made and attempted), threes and free throws, and your rating of your performance from 1 to 10. The result and the percentages are calculated automatically.
- Open the «الملخص» (Summary) sheet for averages, per-36-minute figures, shooting percentages, the best game and the form of the last 5 games.
- Check the "تنبيه" (Alert) column in «المباريات»: it appears if you enter a number that does not add up, such as points that do not match shots or more threes than field goals.
Before you start:
- Field goals (FGM/FGA) include threes. Expected points = 2 x field goals made + threes made + free throws made.
- eFG% = (FGM + 0.5 x 3PM) / FGA, TS% = points / (2 x (FGA + 0.44 x FTA)), and points per 36 minutes = points / minutes x 36.
- The form of the last 5 games is calculated by game date; if two dates are the same, the lower row is treated as later. There are no ties in basketball, so a game with equal scores counts as neither a win nor a loss.
- A game whose competition is not in «الإعدادات» (Settings) is included in the totals and appears in an "unregistered competition" row in the competitions table.
- The rating is your own opinion of your performance, not an official rating. The numbers are tracking tools, not technical or medical advice, and do not replace the coach's view.
- The sheet holds 300 games and eight competitions, and is for one player; for a whole team you need a sheet per player or a custom program.
Free cheat sheet for this field
Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
What is the difference between FG%, eFG% and TS%?
FG% is the share of shot attempts that go in, and counts a three like any other shot. eFG% = (FGM + 0.5 x 3PM) / FGA, which gives threes their extra value. TS% = points / (2 x (FGA + 0.44 x FTA)) also takes free throws into account. The higher the percentage, the more efficient the scoring.
What does points per 36 minutes mean and why use it?
It is points / minutes x 36, and it puts a game where the player played 18 minutes on the same footing as one where they played 35. It is a calculated estimate of what would happen at the same pace over 36 minutes, not a number the player will necessarily reach.
What does the "points do not match shots" alert mean?
The expected points = 2 x field goals made + threes made + free throws made. If what you entered does not match this formula, the alert appears at the end of the row, so check the wrong number.
Can the sheet replace a coach?
No. The sheet only tracks your numbers. It is not a technical assessment or medical or fitness advice, and your rating is your own opinion. Show your numbers to your coach and ask where to improve, and see a doctor for any injury.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Gyms and fitness
More free templates
- Gym memberships tracker (Excel)
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Swimming times and personal bests
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Padel and 5-a-side court booking sheet (hourly)
- Ad budget media plan across platforms
- Ad campaign performance tracker
- Ads A/B test log
- Ads break-even and unit economics sheet
- Ad agency client management and reports
- UTM link builder and campaign naming
- Ad account audit checklist
- Ads creative production calendar





