Project Detail

Auto Assignment Sheet Maker

Operations tool that reduces manual scheduling.

VBA Automation Excel Operations

Overview

Created VBA-powered Excel program that automatically generates shift assignments for all departments.

Integrated staffing rules, time constraints, and improved formatting to quickly create an accurate schedule for the team.

Significantly reduced manual scheduling time and freed up management workload.

Project Notes

Operational Value

This project focused on practical speed and consistency. Instead of treating scheduling as a time-consuming manual task, it reduced workload to the click of a button.

Gallery

Visual references

Technical Highlights

Core decisions

Rule-based assignment logic inside Excel using VBA.
Faster schedule generation with more consistent formatting.
Built for real AMC location and is still used daily during operations.

Lessons Learned

What improved

Self taught the basics of VBA and became more familiar with excel.

Future Work

Next steps

Export scheduling outputs to a web interface or central dashboard.
Track exceptions and staffing history.