Update: MBA Key Metrics Spreadsheet Project Version 2 Released!

Version 2 of the MBA Key Metrics Spreadsheet Project is here! Request Access

Thank you everyone for your interest, I did not expect this to be so popular!  There are over 200 of you using this spreadsheet.  I’ve worked very hard since December to interpret additional data into the spreadsheet format.  I put it together as best as I could, but I still need your help!  Please let me know if you find any errors or have any suggestions.  Here are the exciting new features:

**New** Automatically Generated Charts
I’ve created several new automatically generated charts that also now display both the 2015 and 2014 results.


***NEW*** Automatically Generated Recommended Actions
I went through all the necessary actions in the MBA Key Metrics guide and created an automatically generated recommended action list
  • These were the setup formulas:
  • The Recommended Actions list is automatically generated into a simple, one-column, easy-to-read list.

Changes In Automatically Generated Reports
  • The colors for Cost changes have been updated to reflect positive results in reduction of costs.
  • Added OD compensation per hour

Future features
  • Automatically Generated Recommended Action Links:  In the future, I plan to link the recommended action list to relevant articles that expand on the recommended actions.

Interested?
For those who have requested access to the first version of the Key Metrics Spreadsheet, you will automatically be granted access to Version 2 shortly.

For those who have not used this spreadsheet before, here is a little more information:  
  • The current spreadsheet is in Google Sheets format and is currently under development.  
  • I released the first versions in order to get feedback on making a better Key Metrics Spreadsheet.  
  • If you are interested in obtaining an early version of the spreadsheet, please read this article on how HERE.

DISCLAIMERS:
  • I am not affiliated with the Management & Business Academy.
  • I am offering this spreadsheet without any guarantee or support (I will not respond to basic spreadsheet support requests).

Thanks again for your interest and support!

Popular posts from this blog

4 Steps to Creating your Procedure Manual in Google Docs

Image
Looking to create your own Procedure Manual? In my last article, A "Clickable" Procedure Manual ,  I showed you how a clickable manual could be used in your office.  This guide will show you how you can make a procedure manual from scratch using Google Documents. It is a fairly simple (but lengthy) process and you will need to be familiar with my previous Guide on Making a Guide on Google Docs  before proceeding. Click to Download or Print your FREE Guide: 4 Steps to Creating Your Procedure Manual in Google Docs
Read more

A "Clickable" Procedure Manual

Image
***Update April 18,2016*** Learn how to make your own! A new post on 4 Steps to Creating your Procedure Manual in Google Docs I recently read an article by Neil B. Gailmard, OD on Your Office Procedure Manual (2010) which has a lot of good tips on: Why you should have a procedure manual How to Start a Manual What to Exclude What you might Include However, I did not agree with the line in his last paragraph where he states that, “every office is so different that I strongly recommend that you write your own from scratch.”  It’s true, every office has their own unique workflow- but every office shares the ability to categorize duties by either patient workflow and/or department . Think about all the duties in your practice.  They can either involve interaction with a patient or a specialized duty performed by a department in your practice.  Although these duties may coincide in both patient workflow and department, categorizing them in this manner will force yo
Read more

Metrics - Patient Response Button Fix

Image
A Patient Response Button (aka "The Clicker") for our Zeiss FDT went out again at our office and I decided to see what the problem was.   When I took it apart, I found that it was a very simple fix.  In this post, I will show a quick fix to get your Patient Response Button back up and running.  A quick fix if you’re waiting for the replacement from Zeiss ($35 plus shipping).  Disclaimer:  Although this is a VERY simple electronic fix, please do so at your own risk.  I will not be held responsible for any damage caused by using this fix. The Problem: the most common failure of the button is caused from normal wear and tear and occurs when the rubber end-piece separates and causes the jumper to separate from the jumper cable (displayed below). What you need Heatshrink (works wonders on temporary frame repairs also) - a half inch piece of the second from the biggest size should be perfect Super glue Lighter or other heatsource A Phillips Screwdriver
Read more

A Guide On Making A Guide in Google Docs

Image
I love making guides.  I make guides at work in order to provide step by step instructions on how to perform new tasks on new features.  I have over 50 guides that cover most departments in our office. I like to show exactly where to click, what fields need to be filled out and in which order they need to be done.  Making guides are not only informative for the individuals they are intended for, but are very helpful for those creating them to further evaluate the system into a well-thought-out, streamlined process. A Skitch Screenshot What You Need To create a guide you will need three things: A Word Processor  (i.e. Microsoft Word , Google Docs , LibreOffice ) A Method to take a Screenshot  (i.e.   Skitch , Greenshot , PrintScreen Button, or Windows Snipping Tool) A Method to Annotate Your Screenshot (i.e. Skitch , Greenshot , or Microsoft Paint) For this article, I will use Google Docs, Skitch, and the PrintScreen Button.  The reason I love this trio is bec
Read more