Excel Inspection Form

Closed - This job posting has been filled and work has been completed.

Job Description

We are looking for an Excel form developer/designer. We have an MS Word Inspection Form that is used to inspect Healthcare laundries. The form contains over 600 standards and is very tedious for our inspectors to use and for our inspection committee to review. We would like to turn this MS Word document into an MS Excel (or other) form where inspectors could simply click on a standard if it passed or failed or was not applicable. If the standard was failed, then the row would light up red and the failure would be listed on another form along with its severity and any comments. If this standard was passed then the row would light up green. If this standard was NA then the row would light up yellow. I believe the best way to accomplish this is with check boxes. A different form on the spreadsheet would have some statistics including:

1. All standard failures listed along with inspector comments and if they were a "Must" "Shall" or "Should" failure
2. A count of all "Must" "Shall" or "Should" failures
3. Key contact information of the laundry
4. The inspector performing the inspection

If this form could be made compatible with an IPAD, that would be even better.

Skills: mobile-application-development