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 vb.net 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.
This tool built to support the Settings changes was one of many tools used to gather the data that helped push legislation to make change. One of the services this tool collects data for is Supported Employment which typically underpays the clients significantly but as of April 2018 that is no longer the case. Alaska now has legislation for Equal Pay for the Disabled and they are paid at least minimum wage now!