Spreadsheet Named Range Planner — illustrative example

INPUT
Workbook repeatedly uses the approved hourly rate at Settings!B2. Propose a workbook-scoped name; no existing-name conflicts supplied.

RESULT
Proposed name: HourlyRate
Scope: workbook
Refers to: =Settings!$B$2
Meaning: approved hourly rate used by this workbook.
Before applying: check for existing names and confirm formulas should reference this one setting. Verify a known calculation after replacement.

REVIEW
Named ranges should express stable business meaning and avoid ambiguity. Keep scope and maintenance requirements visible.

This is a teaching example, not a live execution record.