Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Login to your OnlineRME account
  2. Click on the Reports & Exports link:
  3. From the drop down list select 
  4. 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. 

...

  1. Open Microsoft Excel
  2. Navigate to where you saved your file called ExportList.xls
  3. Open the file and you will receive a notification - select the "Yes" button:
  4. 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
title What is the formula that makes a contract late?
  1. First, the contract must be older than 60 days (new or renewed)
  2. 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
  3. 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.

...