Independent Bookstore | 14-Day Sales Dashboard

Bookstore_Sales_Dashboard_Simulated.xlsx — five sheets, 56 simulated records (14 days × 4 categories, 1–14 Oct 2026). Every sheet carries the banner "Simulated data · Not real business results" (row 2, plus print header/footer).

Sheets

• Dashboard — 8 KPI cards (net sales, gross profit, margin, units, best category, peak day, avg daily net sales, avg discount rate), a SUMIFS category table with share and rank, a daily line chart, a category column chart and a doughnut share chart.
• Sales Detail — the 56-row table. Inputs: Units Sold, Unit Price, Discount %, Unit Cost. Formulas: Weekday (TEXT), Gross Revenue, Discount Amount, Net Sales, COGS, Gross Profit, Gross Margin; frozen header, autofilter, totals row.
• Category Summary — SUMIFS on units, gross revenue, discounts, net sales, COGS and gross profit per category, with margin, share and RANK; bar chart.
• Daily Trend — SUMIFS by date for units, net sales, gross profit, margin, the four category splits and a running cumulative; two line charts.
• Data Definitions — dataset overview, 14-field dictionary, calculated-field formula patterns, assumptions/limits.

Checks run on the saved file: 56 rows and every cached value matched an independent pandas recomputation from the source CSV; category totals matched a groupby; daily totals matched a pivot; all 56 rows carry live formulas; dashboard KPIs and table reconcile to the detail totals; no formula-error tokens; 6 charts present. Results: net sales $13,313.94, gross profit $6,729.94 (50.5% margin), 680 units.

Limit: no spreadsheet renderer is installed in this environment, so I verified layout with a deterministic width/height audit (text measured against every column and merged span, wrapped-line heights checked) rather than a rendered page — it now reports zero clipping risks. Do open it once to confirm fonts and charts look right on your machine.