Kitsap Contract Status 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

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 .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

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 - click the "Finish" button:
   
   
   

Your Export will open.  Column F is the most important column for this export.  The contracts have been pre-sorted by column F in the following order:

1. New Or Renewed Contract - This means that the contract will not count on your report card until it has become older than 60 days.
2. After the New Or Renewed Contracts will come contracts that are due.  Anything that is negative or zero is considered late and will be shown on your report card.  

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 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..