We are seeking a skilled freelancer to create a comprehensive Google Sheets dashboard that effectively monitors key performance indicators (KPIs) for our medical staff. The dashboard should provide clear insights into performance metrics, allowing for easy tracking and analysis. Experience with Google Sheets functionalities such as charts, formulas, and data visualization is essential.
We are a newer practice, and need to start tracking productivity and such.
I need something that tracks each of my providers every day. I want to track new bookings they received for the day Cancellations that occurred same day of bookings Cancellations that occurred over 24 > from booking How many patients the providers saw
I will then need to it to add and subtract the total amount with the given averages for the day. I would like a weekly and monthly view of these, and percent of the outcomes. Patients booking vs actually seen.
Also Here’s an overview of what I’m looking for:
A daily tracker for each provider showing: • New bookings received that day • Same-day cancellations • Cancellations made more than 24 hours in advance • Number of patients actually seen
The tracker should automatically calculate totals and show daily averages.
I’d like to see both weekly and monthly summaries, including percentages of patients booked vs. patients seen. I have a total of 8 providers, would like it easily viewable.
Since my EMR software doesn’t integrate, the system needs to be simple enough for my office staff to enter data manually.
Ideally, it should visually flag (e.g., turn red) when a provider’s numbers go negative. I would like it to turn red if they have gone negative as well.
Separate entry tabs per provider would be ideal
And I want to get a monthly break down by provider as well for a quick glance, as well as distinguish between follow up appointments, and new intake appointments.
I am really trying to see how much its costing in overall marketing, how much a provider is bringing on a day to day, week, monthly and yearly. How much revenue to I make after each day after I payout the provider
And I want to hide certain data from certain people filling it out.
Instagram Reels Ad Video Editor Category: Adobe Premiere Pro, After Effects, Animation, Final Cut Pro, Motion Graphics, Video Ads, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
05-Apr-2026 10:03 GMT
App Media Sosial dengan Pesan Category: Android, App Store Optimization, Backend Development, Flutter, IPhone, Mobile App Development, PhoneGap, React Native Budget: $15 - $25 USD
05-Apr-2026 10:01 GMT
Flat Fuel Finder Icon Design Category: Adobe Illustrator, Photoshop, Graphic Design, Icon Design, Logo Design, UI / User Interface, User Interface / IA, Vector Design Budget: $10 - $30 AUD
05-Apr-2026 09:59 GMT
Cartoon 3rd-Person Mission Game Category: 3D Animation, Animation, Game Design, Game Development, Graphic Design, Illustration, Unity, Unreal Engine Budget: £20 - £250 GBP
Bimbingan Freelance Ilustrasi Online Category: Art Consulting, Content Strategy, Creative Design, Design Thinking, Digital Art, Graphic Design, Illustration, User Experience Research Budget: $250 - $750 USD
05-Apr-2026 09:57 GMT
Viral Instagram Reels Editing Category: Adobe Premiere Pro, After Effects, Animation, CapCut, Final Cut Pro, Motion Graphics, Video Editing, Video Production Budget: ₹400 - ₹750 INR
05-Apr-2026 09:53 GMT
YouTube, Instagram & Wallpaper Edits Category: Adobe Premiere Pro, After Effects, Animation, DaVinci Resolve, Final Cut Pro, Graphic Design, Video Editing, Video Services Budget: ₹12500 - ₹37500 INR
05-Apr-2026 09:50 GMT
Launch New Product Line Store Category: HTML, Inventory Management, PHP, Product Management, Shopify, Shopify Development, Shopify Templates, Web Development Budget: $30 - $250 USD
05-Apr-2026 09:48 GMT
Cross-Platform Mobile App UI/UX Category: Android, Figma, IOS Development, IPhone, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience Budget: $30 - $250 USD
AI Transcription Tool - Content Needed Category: AI Content Writing, Article Writing, Content Writing, Copywriting, Ghostwriting, Product Descriptions, SEO Writing, Technical Writing Budget: £2 - £5 GBP
05-Apr-2026 09:45 GMT
Full-Time YouTube Video Editor (Monthly Salary) Category: Adobe Premiere Pro, After Effects, Commercials, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Production, YouTube Budget: €2 - €6 EUR