Tip Sheet Tracker Project Overview

This project involved designing a comprehensive and automated tip sheet tracker for a restaurant. The system calculates tipout splits for employees based on key variables such as hours worked, location, and job type. In addition to tip distribution, the tracker also summarizes essential metrics like total sales. The system leverages multiple macros to streamline processes, including automatically archiving the sheet, clearing relevant data, and resetting the sheet for the next week. This automation ensures efficiency with minimal user input, making it a valuable tool for restaurant management.

Key Features:

1. Automates tipout calculations based on employee hours, location, and job type.

2. Summarizes key metrics like total sales and tip distribution.

3. Includes macros for archiving, clearing data, and resetting the sheet for the following week, reducing manual input.

4. Enhances efficiency, saving time and ensuring accuracy in weekly tip tracking and reporting.