Balance Settlement Analytics Accelerator
Internal balance settlement for Balance Responsible Parties at 15-minute resolution: imbalance volumes/costs, volume fees, and production-unit attribution with hierarchical drill-down.
Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
⚙ Try Demo ToolsFile Structure 16 files
Documentation Preview README excerpt
Balance Settlement Analytics Accelerator
Internal balance settlement for Balance Responsible Parties (BRPs) at
15-minute resolution: imbalance volumes and costs, volume fees, and
production-unit attribution with hierarchical drill-down. Replaces
Excel-based settlement with a deploy-ready Databricks Asset Bundle.
Fully generic and currency-neutral: configure your own catalog/schema, map
your metering and trade sources, and point at your imbalance-price series.
What it computes
- Internal balance per business unit: production + purchases − consumption −
sales, at 15-min resolution.
- Imbalance cost at the TSO imbalance price.
- Volume fees: imbalance (on absolute imbalance), production, and
consumption fees.
- Energy split: metered energy attributed across production units by weight,
with spot-value attribution.
What's inside
- Databricks Asset Bundle — daily settlement job (3 dependent SQL tasks).
- Three parameterized SQL steps — settlement, volume fees, energy split.
- A dependency-free settlement library (
lib/settlement.py) mirroring the
SQL, with an offline test suite (5 tests).
Quickstart
pip install pytest && pytest tests/ -v # validate settlement logic offline
databricks bundle deploy -t dev -p <profile>
Provide settlement_entries, fee_rates, production_unit_shares, and the
imbalance/spot price series (schemas in guide/03_architecture.md).
License
MIT — see LICENSE.