Data report with spreadsheet
Turn a dataset or export into a report: the working spreadsheet with formulas, and a short document with charts that says what the numbers mean.
In Lobstack: Skills › Library › Add
What your agent will do.
Someone has numbers — an export, a table, query results, figures pasted in chat — and wants to know what they say, with the data in a form they can keep using.
- 01
State the question the report answers, the period and the unit at the top.
- 02
Check the data first: rows, blanks, duplicates, dates out of range, totals that do not add up. Report what you found before any conclusion.
- 03
Build the spreadsheet with post_spreadsheet: the cleaned data on one sheet, a summary sheet whose totals, changes and rates are formulas pointing at the data, a format on every number column, and a totals row.
- 04
Write the report with post_document: the answer in the first sentence, then three to five findings, each with its number and a chart block where it compares or changes over time.
- 05
Say what the data cannot tell you and what you would need to find out.
- 06
Never estimate a missing figure to fill a gap; mark it missing.
Read only. Never change the source data, and ask before sending the report on.
The whole SKILL.md: 29 lines of Markdown.
Add it in the app from Skills › Library, or copy it and paste it into Skills › Add a skill.
---name: data-reportdescription: "Turn a dataset or export into a report: the working spreadsheet with formulas, and a short document with charts that says what the numbers mean."metadata: title: "Data report with spreadsheet" category: data tags: [data, spreadsheet, charts]--- ## When to use this Someone has numbers -- an export, a table, query results, figures pasted in chat --and wants to know what they say, with the data in a form they can keep using. ## How 1. State the question the report answers, the period and the unit at the top.2. Check the data first: rows, blanks, duplicates, dates out of range, totals that do not add up. Report what you found before any conclusion.3. Build the spreadsheet with post_spreadsheet: the cleaned data on one sheet, a summary sheet whose totals, changes and rates are formulas pointing at the data, a format on every number column, and a totals row.4. Write the report with post_document: the answer in the first sentence, then three to five findings, each with its number and a chart block where it compares or changes over time.5. Say what the data cannot tell you and what you would need to find out.6. Never estimate a missing figure to fill a gap; mark it missing. Read only. Never change the source data, and ask before sending the report on.
- Data
Answer a question from data
Answer a question from a database or table: read the schema, write a read-only query, sanity-check the result, and answer with the query shown.
SKILL.md · App - Data
What changed in the numbers
Check a set of numbers for what changed: compare to the usual range, find the biggest moves, and say which ones are real.
SKILL.md · App - Data
What the launch did
Read how a campaign did per channel — clicks, signups, replies — from analytics and the Distribution table, and say which channel to repeat and which to drop, with the numbers.
SKILL.md · App - Engineering
Commit message from a diff
Write a commit message from a diff: a subject line that states what was found, then prose explaining why the change was made.
SKILL.md · App - Engineering
Triage a failing build
Triage a red CI run: find the first real failure, attribute it to a change, and say whether the code is wrong or the runner was.
SKILL.md · App - Engineering
Review what a linter cannot
Review a change for what a linter cannot see: whether it is correct, what it breaks elsewhere, and which parallel list it forgot to update.
SKILL.md · App