Use case B19 · Business
Gym owners use ChatGPT for Excel formulas that cut contract work from hours to minutes
- Operations
- Beginner
- ChatGPT Premium
- Source checked · news article
The short version
What they did
After taking over a New Hampshire gym in 2024, Bennett Camarda and her husband, Bill, used ChatGPT Premium to write Excel formulas for their client contracts. They also used it to write operations manuals, build heatmaps of their busiest times to decide where to add training sessions, and refine the brand’s tone and messaging.
Result (as claimed)
The article reports the Excel formulas “helped them streamline contract operations from an hours-long process to one that takes minutes.” Camarda: “Gen AI has freed up our time to invest in our community and focus on opening a second location, rather than being stuck in the day-to-day operational weeds.”
Prompt
I run a personal-training gym and need Excel formulas for our contract sheet. The workbook or sample rows are [attach or paste], the column headings are [paste], and my Excel version is [version]. Our rules for counting sessions, renewals and monthly revenue are [describe].
1. Write formulas for sessions remaining and a flag for contracts expiring in the next 30 days.
2. Show how to total monthly revenue by trainer using our stated rules. Ask if the sheet lacks the dates or amounts needed.
3. For each formula, say which cell it belongs in, explain it in one line, and give a test using my sample rows.Use plain instructions I can follow on a copy of the workbook. Don’t guess column names or treat package sales as monthly earned revenue without confirming our method. Flag blank or inconsistent dates.
Do it yourself
These steps are my suggested way in, not the Camardas’ setup.
What you need
- Your client contract spreadsheet.
- A chat assistant such as ChatGPT or Claude.
- A booking or check-in export if you want to see busy times.
Start simple
- Save a copy of your contract spreadsheet. Work on the copy.
- Paste the column names and a few made-up rows into a chat with the Prompt.
- Add the formulas it gives you one at a time and read its one-line explanation.
- Check the results on three clients you know well.
- Switch to the new sheet once it’s right.
Take it further
- Upload a month of check-ins and ask for a heatmap of busy hours by day.
- Use that to decide where to add sessions or trainers.
- Ask for a first draft of an operations manual from your notes on opening, closing and new clients.
Check your work
- Compare sessions remaining and renewal dates with what clients and trainers say.
- Test the expiring-soon flag by changing a date and watching it update.
- Keep client health notes and payment details out of the chat.
Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: More than 10 trainers and 150 active one-on-one clients. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.