---
name: turn-regulator-price-notices-into-a-traceable
description: "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."
license: CC-BY-4.0
compatibility: "Needs access to: PDF files, Spreadsheet, Browser, Docs."
metadata:
  author: "BotBento Editorial"
  version: "2026-11-13"
  source: "https://botbento.com/usecases/turn-regulator-price-notices-into-a-traceable/"
  kind: workflow
  hermes:
    tags: ["data-extraction", "visualization", "documents", "finance", "reporting"]
    category: ops
---
# Turn regulator price notices into a traceable price-breakdown chart

Extract published price rows faithfully and chart them without invented splits

## When to use

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.

## Steps

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

## Instructions

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.

## Source

Summarized in our own words from [A 1580 Map Shows Why Data Visualization Is Never Neutral](https://news.ycombinator.com/item?id=50304718) (Hacker News, checked 2026-11-13). Any results described there are the authors’ own.

From the BotBento use-case directory: https://botbento.com/usecases/turn-regulator-price-notices-into-a-traceable/. Licence: [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/).
