EXCEL DEFINED NAMES INSPECTION CHECKLIST

The finished companion workbook is excel_defined_names_workbook.xlsx in this folder.
Open its Start Here and Summary sheets; it is already built. The article explains the setup for readers who want to understand or reproduce it.

EXPECTED BASELINE RESULTS
Media_Budget: 12000
Fee_Rate: 8%
Fixed_Fee: 300
Projected_Total: 13260
Scenario_Budget (Scenario scope): 15000

OPTIONAL CHANGE TEST
Changing Media_Budget to 13000 should produce 14340. Restore 12000 afterward if you want the original example.

INSPECTION CHECKLIST
- Identify the inputs people may change.
- Give those inputs descriptive names.
- Confirm scope and absolute references.
- Document units and calculation assumptions.
- Test one known answer and one changed input.
- Use tables for expanding records.
- Inspect names before handing over the workbook.

The fee example is hypothetical. It is not a recommended pricing or accounting model.