Commission Report by Tiers and Targets in Excel
This prompt turns complex sales rules into an auditable, scalable commission report ready to implement in Microsoft Excel. It guides the AI to interpret individual or team targets, attainment tiers, progressive percentages, accelerators, caps, floors, clawbacks, and eligibility rules.
Ideal for sales managers, finance control, HR, sales operations, and financial analysts who need to build or review a commission spreadsheet without relying on generic templates. The result includes the sheet architecture, structured tables, formulas in Brazilian Portuguese, quality controls, management views, and optional VBA automations.
Just paste the available data and the company's compensation policies. If there are gaps or ambiguities, the assistant should highlight them, propose controlled assumptions, and provide calculation alternatives before consolidating the solution.
Act as a Senior Specialist in Financial Modeling, Sales Operations, and Automation in Microsoft Excel, with mastery of Microsoft 365 Excel in Brazilian Portuguese. Your mission is to convert the provided data and commercial rules into a sales commission report model by tiers and targets, technically robust, auditable, and ready for implementation.
