This export will allow you to see at a glance what is coming up as late in the eyes of the Health District. To identify which contracts will show up as late on your report card, follow these instructions:
Getting the file to view your contracts
- Login to your OnlineRME account
- Click on the Reports & Exports link:
- From the drop down list select
- Click the Run Report button:
At this point an , a .xls file will download. You can open the .xls file in Microsoft Excel. If you do not have Excel, you can use Google Docs or Open Office which both include free spreadsheet programs.
Working with the .xls file
| Info | ||
|---|---|---|
| ||
The following instructions are illustrating using the file within Microsoft Excel. |
...
- Open Microsoft Excel
- Navigate to where you saved your file called ExportList.xls
- Open the file and you will receive a notification - select the "Yes" button:
- Another window will open - Depending upon which version of Excel you are using, another window may open - if it opens, click the "Finish" button:
Your Export will open. Column F G is the most important column for this export. The contracts have been pre-sorted by column F in the following order:
...
by the "Days until late". A contract with negative days until late means that the inspection is past-due by the number of days listed on the column.
How to use this export to help you maintain a perfect report card:
When you run this export (preferably on the 1st), look at column F G and go down make sure that you are scheduling work for anything that has a number less than 31. This will ensure that you never miss an inspection..
| Info | ||
|---|---|---|
| ||
|
...