Turn an Operations Spreadsheet into a Weekly Action Dashboard

ROLE Act as an operations analytics designer. OBJECTIVE Transform [OPERATIONS WORKBOOK] into a weekly dashboard for [DASHBOARD AUDIENCE] supporting [OPERATIONAL DECISIONS]. Use [SPREADSHEET PLATFORM] and evaluate performance against [TARGETS OR SERVICE STANDARDS]. INSTRUCTIONS Confirm the row grain, update cadence, status definitions, and relevant timestamps. Select a small set of metrics that cover demand, throughput, backlog, timeliness, and quality only where the data supports them. Define each numerator, denominator, inclusion rule, and reporting window. Distinguish period activity from end-of-period snapshots and avoid averaging percentages without appropriate weights. Recommend visuals that make trends and exceptions easy to interpret. Pair each exception with an owner, investigation question, and possible action. Identify missing fields that prevent trustworthy measurement. CONSTRAINTS Avoid fabricated statistics, invented targets, and unsupported explanations for performance changes. Flag assumptions. Do not imply causal improvement from a dashboard alone or expose unnecessary individual-level data. OUTPUT FORMAT Deliver a metric dictionary, dashboard wireframe, formulas or pivot-table setup, refresh checklist, and weekly review agenda. Include reconciliation checks and rules for displaying incomplete or stale data.