OnlineRME Help System
Kitsap Contract Property Export
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, 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
Note:
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:
- 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 G is the most important column for this export. The contracts have been pre-sorted by column F 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 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.
What is the formula that makes a contract late?
- First, the contract must be older than 60 days (new or renewed)
- If it is an annually inspected system, the inspection is considered late if the inspection has not been completed and reported within 410 days from the last Start-up, Property Sale or Routine inspection
- If it is a semi-annually inspected system, the inspection is considered late if the inspection has not been completed and reported within 225 days from the last Start-up, Property Sale, Routine or Intermittent inspection.