Compliance Checklist

In the spring of 2017 I was asked to take on extra duties to support the compliance side of the unit more and the first thing I was tasked with was combining a cumbersome set of tools into something more cohesive and easier to manage. Being an Excel fan when it comes to multiple tools in one file I setup a checklist based on the Certification Checklist with show and hide functions for questions that are met or not met in the compliance realm. A little research for the code and within a day or so I had a functional first draft which was taken into the world for testing. A few tweaks and it was ready for the full process. It is still a work in progress as of June 2017 as the Remediation portion of the process is still being developed but the workbook is ready for the challenge of merging the collected data into notices come July thanks to a transpose function.

Bookmark the permalink.