Excel in Excel – Revisiting #3 – The Associate Profitability Calculator

Spreadsheets (rather like bikes) will suffer wear and tear over time and, unless you are fastidious about cleaning them up and servicing them from time to time, problems will happen.
Back in February, one of my “spreadsheets of the week” was the Associate Profitability Calculator that I have used for over 10 years to argue the case for win:win solutions in remuneration for associates and profits for owners.
I’m indebted to Stephen Murray from Swords Orthodontics in Ireland for a detailed and lengthy exchange of emails, demonstrating that the attachment to my February post contained a couple of glitches that could lead the unwary to a false conclusion.
The differences were pence not pounds but Stephen’s eagle eye and my subsequent investigation revealed that the glitches were real and the spreadsheet itself required a service and repair.
So, without the background explanation (see the original post HERE) I’m attaching the new version of the spreadsheet below for you to download and play with.
Here is a link to download the new version:
The New Associate Profitability Calculator

0 Shares
0 Shares

Published by

Chris Barrow

Chris Barrow has been active as a consultant, trainer and coach to the UK dental profession for over 20 years. As a writer, his blog enjoys a strong following and he is a regular contributor to the dental press. Naturally direct, assertive and determined, he has the ability to reach conclusions quickly, as well as the sharp reflexes and lightness of touch to innovate, change tack and push boundaries. In 2014 he appeared as a “castaway” in the first season of the popular reality TV show “The Island with Bear Grylls”. His main professional focus is as Coach Barrow, providing coaching and mentorship to independent dentistry.