Commission Calculator
Nicolas Jusid
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).
Like this project
Posted Feb 14, 2024
Developed a Commission Calculation spreadsheet with automatic features to easily capture each sale and calculate the corresponding commission for the seller.
