I seem to have jumped ahead too fast....As I sat with this trying to customize it for my use I realized the calculations are incorrect.
For example, the first sheet on line 19 - 15% off 500.00 should be 425.00, not 485.00. What am I missing here?

The discount amount is correct but the total is not. It's taking off $15 instead of 15%.