As a first step, the input tab is user friendly while carrying a robust VBA script in the background to support the calculations needed to reach the commission for each sale.

A summary of each sale along with it's commission broken down by criteria can be accessed in a different tab.

Backend data tables support both the input process and the calculations. To make building and modifying those data tables as simple as possible, a new tab was created which can pull up any of the data tables (menu on the left) and after edits are made the "Submit Changes" button will record those changes and apply them to the rest of the file.

Lastly, an interactive dashboard shows summarized information based on the criterias selected by the user (Date and Salesperson).