DataWindows app
Weekly Trend Snapshot
Import a weekly KPI Excel; auto-compute WoW change, render sparklines, and draft a one-paragraph commentary.
The problem
Mondays: pull from BI, reformat, chart, write commentary. Half a morning gone.
The solution approach
A local tool: import the weekly Excel; auto WoW + sparkline + drafted commentary per metric.
What you will end up with
- Import: each row = one metric, columns = past N weeks.
- Per-metric card: current value, WoW change, sparkline.
- WoW beyond a threshold flagged red/green with a one-line commentary.
- One-click export of weekly Markdown.
Ready-to-use prompt
You are a senior engineer building local desktop tools. The user is a data analyst, light coding.
[Goal]
Compress weekly KPI-report grind into five minutes.
[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; SheetJS; tiny inline SVG sparkline
[Core Features]
1. Import Excel; detect metric column + past-N-week columns; rightmost = this week.
2. Per-metric card: current value, WoW, 4–8-week sparkline.
3. Editable thresholds: +5% green "up"; -5% red "down"; near zero gray "flat".
4. Editable commentary template auto-filled per direction; the user can tweak per metric.
5. One-click export of the report as Markdown.
[Visual Style]
- Light background, white cards, radius 16, generous whitespace.
- Primary button muted dark; secondary light gray.
- Follows system dark mode; system fonts.
[Robustness]
- All data stays on the local machine. Offline.
- Autosave; 7-day rolling backups.
- Friendly messages on bad input, never raw stack traces.
[Delivery]
1. Outline project structure + plain-text wireframe first; wait for confirmation.
2. Deliver in modules; run each one for me to see.
3. Package a Windows .exe and macOS .dmg, ship a 500-word plain-language user guide, list known limits.
Start with structure and wireframe.After copying
1
Open Codex Desktop and create a new project
2
Paste the prompt and send
3
Wait for Codex to finish; tweak company names, column names, button text as needed