I would like to hire an Excel Expert
$30-250 AUD
Betales ved levering
Hi i'm a Physiotherapist and i run an allied health clinic with 10 therapists and 3 admin staff. We currently use a good clinic management software that produces good reports but i need to give meaning to the numbers this report produces in order to see trends and make decisions.
I would like to produce monthly reports that can be displayed in table form and in a graph form to track progress for each therapist, to compare performance between each therapist and to view the performance of the clinic overall.
The KPI's that i would like to track for each therapist are:
1) Total Clients (shows the number of patients the therapist has seen in the month)
2) Total Sales
3) Total Inventory sales
4) Monthly wage
5) Profit Generated (Total sales - monthly wage)
6) Average Client Spend (Shows on average how much each client is spending with them $)
7) Forward Booking Average (shows how many sessions they're booking a patient in after they finish their session)
8) Client Visit Average (shows how many time a client sees them)
9) New Clients (shows number of new clients for the month)
10) Cancellations (shows number of cancellations for the month)
11) DNA (shows the number of patients that simply DID NOT ATTEND for the month)
12) Utilisation Rate (this is a % value which shows how busy the therapist is: the software produces this result)
When viewing this data in a graph format i would like to achieve 2 views:
1) GOAL BASED VIEW that can compare how the therapist performed against his own goal via a column graph.
- Ability to compare how the therapist performed in comparison with the goal we have set together for the month E.g In January the therapist's goal for "total sales" for the month was $2000 (i would like this column to show in blue). When the "Total sales" is calculated i would like this to show as a column right next to the goal column, that either shows up in green if they meet or exceed the goal, or in red if they fall behind.
- I would like the graph above to show for all therapist so i can compare between therapists
- Are we able to have one page that has all the 12 KPI graphs showing?
2) LINE GRAPH of a Month to month view for the year for each individual therapist to see how they're progressing for each KPI
CLINIC KPI'S for the month
1) Total Clients
2) Number of new clients
3) Total Revenue
4) Total Practice Payments
5) Expenses breakdown (therapist wages, admin wages, stationary, products, etc - would want to be able to modify this list) I would also be interested to know what %of the gross income each expense takes. I would also like to add up all the expenses for the year
6) Performance Profit (Total Revenue - Expenses). I would also be interested to know what % of the gross income this profit represents takes. I would also like to add up all the profits of each month for the year.
7) Real Profit (Total Practice Payments - Expenses) I would also be interested to know what % of the gross income this profit represents takes
8) Ageing debts (shows total owing for the clinic to date)
9) Total Cancellations
10) Total DNA
11) How many marketing things done social media posts/events attended/blogs/dr visits (This will be like a tally, can we also write notes here to write down what we've done)
12) Total social media likes
13) Total Social media Shares
I would like to achieve the 2 views as mentioned above (that is the GOAL BASED VIEW and the month-month view for the year) for the clinic KPI's
QUESTION: Could this data be aggregated to compare year to year? This isn't very important. If not i guess i can initiate a new file for each year to keep the size of the file small, and for backup purposes?
Can we use this file on google docs?
Will we be able to print these statistics?
Thankyou,
Abdul-Raouf Baghdadi
Prosjekt-ID: #12144417
Om prosjektet
Tildelt til:
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.
32 frilansere byr i gjennomsnitt $172 for denne jobben
Hi, I have a few questions about your project. Please send me a message so that we can discuss more about details like price, task, duration thanks....
Hi Abdul-Raouf Baghdadi, I have gone through the detailed description. I have got the attached excel sheet. Looking forward to discuss with you. It is mostly to deal with pivot tables. It is possible to make yea Mer
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Mer
I have sound Knowledge of Excel, Please provide me more details so I will back to you with quotes. Please provide me sample file.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Mer
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Mer
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Mer
Hello, I can create an Excel dashboard with all required info. The file will also work on Google sheets. Please open a chat with me if interested. Kind regards, Sorin
Hi I am Master of Science and have 7 years of research and writing experience. I have worked on PhD level thesis projects, published papers in peer reviewed journals and have also worked with several companies on creat Mer
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Mer
Qualified finance professional with more than a decade of experience in the finance and accounting domains including book keeping, closing books of accounts, financial analysis, report writing and taxation. I have w Mer
Native English speaker. Excel/VBA expert. I've done such tasks before and can definitely take care of this for you. I have recently built a system with a similar scope Having looked at your sheet, I would like to Mer
Hi sir, I am new in this field. However I have an excellent experience with Microsoft Office (Word, Excel, PowerPoint ....etc.), I can also type very quickly on the keyboard and I have the ability of data processing.I Mer
I a confident reliable and an enthusiastic person who enjoys challenges. And also got 99% of attitude & 1% of aptitude. I think it makes me the better not best.
Hi this Ravi. I am working in testing from last 5 years. I use the excel macros every day to day work. till now I created different types excel VBA macros. I would like work with you if you are interested. please let Mer
I will deliver a satisfactory job that will impress you. I crave for a chance to prove to you my worth and abilities.
