WORKSHOP | Event Execution Checklist
Prompt
Create an editable execution checklist XLSX for fictional craft workshops: 5 events with 6 workstreams each, 30 items in total. Record owner role, due date, status, budget, actual spend and risk; automatically calculate completion rate, cost variance and risk priority, and show preparation progress and budget vs. actual on a dashboard. Four worksheets, all labeled "Simulated data · Not real operations". Write all content, headings, labels, sheet names and file names in English.
Result
Craft-Workshop-Execution-Checklist.xlsx — 4 worksheets, every one carrying the banner Simulated data · Not real operations (also in the page header/footer and file properties).
1. Read Me — purpose, workbook map, 5-step usage, conventions, status definitions, risk bands, data notice. 2. Checklist — 30 items (5 events × 6 workstreams), one row each: Item ID, Event, Workstream, Checklist Item, Owner Role, Due Date, Days to Due, Status, Budget, Actual Spend, Cost Variance, Variance %, Risk Likelihood, Risk Impact, Risk Score, Risk Priority, Notes. Blue = input, grey italic = formula. Drop-downs for event/workstream/owner/status, 1–5 validation on both risk ratings, status and risk-band colour coding, freeze panes, autofilter, totals row. 3. Dashboard — six KPI cards, progress and spend by event, progress by workstream, risk mix, and three charts (budget vs. actual by event, completion by workstream, risk priority pie). 4. Lists & Rules — the validation source lists, owner roles by workstream, the 1–5 risk scale, band thresholds and a formula reference.
Calculated logic: completion rate = Complete ÷ 30; cost variance = Budget − Actual (variance % = (Actual−Budget)÷Budget, "n/a" when budget is 0); risk score = Likelihood × Impact, banded 16+ Critical / 10–15 High / 5–9 Medium / 1–4 Low.
Current simulated state: 33.3% complete (10/30) · budget $57,550 · actual $31,010 · variance $26,540 · 11 high/critical risks · 2 blockers. Change any Status, Actual Spend or risk rating and the whole dashboard follows.
Verification: every formula was recalculated by an independent engine and matched the source data (this pass caught and fixed a real defect — workstream totals were summing 5 of 6 rows). No formula-error cells remain. Cached values are stored, so numbers show before any recalculation.
Rendering limit: this Computer has no LibreOffice or Chromium, so the sheets could not be rendered by a real spreadsheet engine. I ran a deterministic geometry audit (zero text-overflow cells) plus the four layout previews attached; the charts appear as placeholder boxes in those previews because they are drawn by Excel, not by the previewer. Please confirm the charts on first open.
Files are editable — no protection is applied.
How it was made
- Mode
- Spreadsheet
Related spreadsheet prompts
City Bike Stations | Operations Dashboard
Spreadsheet
Creative Projects | Budget vs. Actuals
Spreadsheet
TIDE | Clothing Repair Service Capacity Plan
Spreadsheet
OPEN | Shared Kitchen Cash Flow
Spreadsheet
Content Team | 8-Week Publishing Plan
Spreadsheet
Home Energy | Three-Scenario Cost Model
Spreadsheet
FRAME | Gallery Visitor Flow Sample Analysis
Spreadsheet
Independent Bookstore | 14-Day Sales Dashboard
Spreadsheet

