Chart · GRF-009 · v1.0
Small multiples
Compare categories with shared months and scales.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
5 sections, in this order
- 01Action title about the difference between panels
- 02One panel per category, from largest to smallest in the latest month
- 03Same zero-based scale in every panel; the latest month labeled
- 04Under each panel: 12-month change, share and, if there is a plan, «vs plan ▲▼»
- 05Note with what the total adds up, «Other», source and seal
Controls 4/4
What it checks before writing a single figure
C1Complete data: recognized headers, numeric figures, no repeated category-month rows and valid units.
C2Income statement subtotals tie if the table includes them (N/A for a matrix by category).
C3Sign convention: costs and expenses with a single sign.
C4Figures in the title, subtitle, note and alt text traceable to calculo.json, and a title consistent with the key figure.
If the script ran
Repporti controls 4/4 · GRF-009 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}
If it did not run
UNVERIFIED: code not run. Review Control in Excel.
What the prompt contains, block by block
Prompt outline
- 0Before you pasteFixed330
- 1Role, audience and business context408
- 2Parameters345
- 3Repporti standard232
- 4Data contract: serie.csv or .xlsx566
- 5Questions first253
- 6Validation with a stop500
- 7Calculation and drawing by code514
- 7-bisNo-code modeFixed289
- 8Numeric rules344
- 9Chart structure565
- 10Title and texts323
- 11Notation (IBCS / ISO 24896:2026) and accessibility254
- 12QA, traceability and seal464
Core available in: Spanish · English
It comes out adapted to your report profile
Repporti Standard
Your profile sets country, framework, language, currency, scale and year-end.
See the Repporti StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Profitability and costs
- Frequency
- Whenever you need it
- Industry
- All
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel with Control sheet; UNVERIFIED until cuadre.py runs. |
Questions
About this chart
Why the same scale if one category is much smaller?
Because relative size is information: if a line looks small, it is small. With one scale per panel, a tiny change looks huge.
How many panels fit?
From 2 to 9. If you have more categories, the prompt shows the 8 largest and groups the rest in «Other» in the ninth panel.
Does it work for sites, channels or customers?
Yes: any monthly measure split by category. Customers appear as codes, never by name.
What if I have no plan by category?
The panels are drawn the same way, without the plan marker, and the note says so.
Profitability and costs