Number Tracking Tools Instructions:
Here are the most important things you need to know to get started with the new platform:
- **Important – Use the spreadsheets in the cloud only – Do not download and use in Excel – or formula protections will be lost – resulting in potential additional fees to repair the spreadsheets if needed. We can only support the version kept in the cloud, so be sure not to download it to use it .**
- Google chrome is the recommended browser to use for Google sheets. If you don’t already have Google Chrome downloaded, you may find it at https://www.google.com/chrome/browser/ or simply go to your search bar and type in Google Chrome.
- Your account is secure. We will have access to the backside and data should you need to change a team member name or have other support issues.
- Your data is backed up. One of the main reasons we went to this platform is that on occasion a client might have a virus or malware on their computer resulting in a loss of data. These spreadsheets are always backed up.
- It saves automatically – really. You don’t have to press save, it does it continuously.
- They are accessible – with your secure login, from any computer (Mac or PC) with an Internet connection.
- You must be connected to the Internet to use them.
I. GETTING STARTED
To login, go to accounts.google.com.
You will login with your @dciclient.com user id or the personal gmail account the sheets are shared with. If you haven’t received this or aren’t sure how to proceed, call email email@example.com
Once you are logged in, in the upper right hand corner you will see a grid of boxes. Click it and a window will open.
- Click on Drive
- Click on Shared with me and you will see your folder with your Monitors
Now you are in and ready to begin using your numbers tools.
II. USING THE MONITORS/NUMBERS TOOLS – TIPS
- Use in Google sheets cloud only – monitors will not be supported if downloaded and used in Excel.
- Focus on the purple areas, these are the ones open for data entry
- The area outside the spreadsheet page is not protected, in the event you wish to make notes
- It is not necessary to save the document. Document changes save automatically.
- There will be a slight pause after entering figures in a cell. It is likely you won’t notice this as you will be looking at your practice management reports to get the next data set. Please note this is completely normal.
- As you are entering data, please be sure to click or highlight the cell you are on to be sure you are entering in the area you wish to.
- Note that Sunday is on the monitor, this will help you separate weeks.
- If you desire formula changes, please contact us. Any intentional changes to your worksheet that require us to reprogram are subject to a $50 per hour programming fee.
- If you notice that a cell is unprotected that should be protected or any other suspected issue with setup, please contact us immediately and let us know the sheet name, row/column etc.
III. PRINTING AND SHARING
- You will notice that there is a tab in each month with the word “Totals”. This will be the sheet you may wish to print for each week. To see day to day details it is best to simply view the tab for that month and move the mouse left and right or up and down to see all rows and columns. This can also be done using the up/down and left/right arrow keys.
- Sharing with others for viewing only (other users may view but not edit). We ask that you click here to email and provide specific emails that you would like to have sharing/viewing access with these tools. For example, if the office manager is completing the spreadsheets, and the doctor wants to view, you would send us the doctor’s preferred email for viewing privileges.
- Sharing allows others to view more detailed areas that may not be necessary to print.
To download these instructions, with screenshots, click here.
For video tutorials visit the following links:
1. How To Login
2. Navigating The Weekly Tool
4. Navigating Order Tracking
5. Multi-doctor Patient Tracker
We are so excited about the new format for these tools. Rest assured that your data is secure and if you see any tweaks that need to be addressed or if you would like additional support, contact firstname.lastname@example.org for a one on one screen share.