Officecli Data Dashboard

Build a multi-element Excel dashboard from CSV or tabular input. Produces a single .xlsx with a Dashboard sheet that opens first, containing formula-driven KPI cards, cell-range-linked charts, sparklines, and conditional formatting. Raw data and aggregations live on upstream Data and Summary sheets.

Tasks

Build a 12-month revenue dashboard with four formula-driven KPI cards, a line chart linked to cell ranges, and a sparkline, ensuring the Dashboard sheet opens as the active tab on load
Create an executive summary layout with a KPI strip, stacked charts, conditional formatting rules on numeric columns, and print-ready delivery scoped to the Dashboard sheet

Inputs

CSV files
Tabular data

Outputs

Single .xlsx file with a Dashboard sheet, KPI cards, charts, sparklines, and conditional formatting

Limitations and checks

Not intended for a single-sheet CSV-with-formatting tracker with no Dashboard sheet or KPI cards
Not intended for 3-statement, DCF, or LBO financial models
Not intended for weekly status reports with one summary and one chart over fewer than 10 rows
Inline chart data is for demos only; cell-range references are required for delivered dashboards
LibreOffice does not evaluate formulas in hidden columns or sheets at render time
series1.xValues is unsupported for scatter charts
Verify the KPI formula count matches the planned KPI count using query with a has(formula) selector on the Dashboard sheet
Confirm the Dashboard sheet active tab index by querying the sheet list before setting activeTab

AI Search

Find projects, verify facts, compare options, or turn a complex need into an actionable plan

Try a searchA click only fills the search box; you stay in control

Collection Scenario Project type License Deployment Resource form

Officecli Data Dashboard

Tasks

Inputs

Outputs

Limitations and checks

AI Search

Project Details