VBA Scheduling

There isn't much to share for the AAH projects as the internship I was employed for ended in August 2022. But one of the projects I can share is that I needed help scheduling at the MSOE IT department, so I created some VBA where I was able to ensure that there are adequate staff during all working hours and that they are spread out appropriately. This started off simple where it would tally the hours worked, to then being able to tally the hours based on the color they were highlighted as. Since then, this tool has made scheduling so much easier, where I plan on adding more features to account for the addition or loss of employees and adjusting the schedule for that.

During all of my VBA projects, I spent most of my time as the sole developer with a manager as a stakeholder giving guidance when needed. I was given problem statements varying from issues with adjusting schedules, creating schedules, or issues with tracking what tickets are ours and being able to find them accordingly and easily. All of the projects were completed and then given a couple pages of documentation with instructions on how to update it for more/less people, how to update the code if necessary, as well as ensuring that the project was future proofed.

One thing I can say that I learned is VBA itself. I never knew that Microsoft products had this feature for their office suite. It was cool to learn how it worked as well as the things you were able to do. You could have on-update functions or even on-button press. These allowed you almost complete creativity when creating documents or even just schedules using Excel.

Most of the projects never had a deadline so it was easy to get caught in a development block where I was trying to tweak or add new things that were not always necessary but were nice to have. By going down these paths, I learned more in-depth functions like copy entire columns over and preserving the order. An example being the ticketing program I made. You could give it the columns and headers of the parts of the ticket and it would format it all the same. This allowed you to keep your preferred order for the headers in the ticketing system and it not affect the program since it would format it all the same.

Because of these skills learned from AAH, I can apply those towards my scheduling tools for MSOE to create the new features to help make scheduling easier for the next Student Manager. These will also help with formatting and simple functions for anything else Excel going forward since sometimes the default functions they have cannot do what I need.