Canonical: https://botbento.com/usecases/turn-regulator-price-notices-into-a-traceable/
Format: Markdown representation of the public HTML page.

# Turn regulator price notices into a traceable price-breakdown chart

[Operations](https://botbento.com/usecases/ops/) · Intermediate

Extract published price rows faithfully and chart them without invented splits

A recurring job to pull published price notices, map each line to the component it explicitly names, and publish a chart where missing lines stay empty instead of becoming zeros. The bot records which groupings came from the document and which were chosen, so readers can tell source facts apart from presentation choices.

## Quick answers

**What does it do?** Extract published price rows faithfully and chart them without invented splits. Result: Draft chart with grouping notes.

**What does it need?** Tools: PDF files, Spreadsheet, Browser, Docs. Intermediate: some setup. The prompt includes an approval step.

**How do I run it?** On a schedule: Weekly notice check. Copy the prompt below into a bot in BotBento.

## How it works

1. On a schedule: Weekly notice check
2. Then: Parse price lines, mark gaps empty
3. Result: Draft chart with grouping notes

## Prompt to start with

```text
Each run, check the regulator's published price notices for new or revised documents. Extract line items exactly as printed, and map each to the component the document explicitly names; if a component is not listed, leave the cell empty rather than writing zero. Keep a short note beside every grouping or split explaining whether it came from the source or from your own arrangement. Produce an updated dataset and a draft chart, then stop and wait for the user's approval before publishing, emailing or posting anything, and never delete or overwrite earlier versions.
```

## Tools it uses

PDF files, Spreadsheet, Browser, Docs

## Works with

BotBento

## Tags

data-extraction, visualization, documents, finance, reporting

## Source

[A 1580 Map Shows Why Data Visualization Is Never Neutral](https://news.ycombinator.com/item?id=50304718) — Hacker News · checked 2026-11-13

Summarized in our own words. Any results described there are the authors’ own, not measured by BotBento.

Verified 2026-11-13: passed every automated gate and a second-model review (kimi-code/k3.1-pro). Automated, not human review. [How verification works](https://botbento.com/usecases/verification/)

By BotBento Editorial · Added 2026-11-13 · Updated 2026-11-13 · [Suggest a correction](https://botbento.com/contact/)

## Related use cases

- [Automated Financial Report Pipeline Builder](https://botbento.com/usecases/automated-financial-report-pipeline-builder/) — Assemble multi-source accounting and macro data into audit-ready monthly reporting packs
- [Review a draft tax return against supporting documents](https://botbento.com/usecases/review-a-draft-tax-return-against-supporting/) — Cross-check figures, rates and inconsistencies before filing
- [Underwriting document intake and fraud screening](https://botbento.com/usecases/underwriting-document-intake-and-fraud-screening/) — Extract financial figures from messy applicant documents and spot inconsistencies
