These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 9, 2010

The Olive Garden Scheduler!

Description of the Business

I am a server at Olive Garden, and one of the great advantages of working as a server is that it allows you a very flexible schedule. Being a busy BYU student I often find myself looking for servers to “pick-up” my shifts. Olive Garden employs a website called “Dish” that is used for a variety of tasks such as posting messages from the managers, employee purchases and schedules. However, the schedules site is something of a mess and doesn’t give me the immediate info I need in order to find someone to work for me. For example, there are roughly 30 different job classes and about 300 employees, but only certain employees can work certain job classes (e.g. server, bartender, grill, prep, etc.).

Overview of the System

What I did was create a VBA program that will work for any user with an Olive Garden “Dish” login. The program takes the user’s login credentials and first downloads and displays that user’s schedule. Following that, the program looks at that user’s job codes that are displayed in their weekly schedule and finds those correlated job schedules. For examples, if I am a server and a line cook, the program sees that I am scheduled as a server and a line cook and then goes and downloads the server and line cook schedules from “Dish”. Those schedules are then organized and displayed in their own worksheets.

The user is then left with their job class schedules available and their weekly schedule displayed. The user can then click a button that will search the related job code schedules and will find every person that is not scheduled to work that job code that day. Under each day that the user is scheduled, there is a list of people who are available to work that job code and are available to work that day.

No comments:

Post a Comment

Blog Archive