← Back to all products

Balance Settlement Analytics Accelerator

$1990

Internal balance settlement for Balance Responsible Parties at 15-minute resolution: imbalance volumes/costs, volume fees, and production-unit attribution with hierarchical drill-down.

16 filesv1.0.0
PythonMarkdownSQLYAMLJSONDatabricksExcel

Product Preview

Try the interactive reader and demo tools below, or get the full product with all content unlocked.

⚙ Try Demo Tools

File Structure 16 files

balance-settlement-accelerator/ ├── LICENSE ├── README.md ├── conftest.py ├── databricks.yml ├── guide/ │ ├── 01_what-you-get.md │ ├── 02_getting-started.md │ ├── 03_architecture.md │ └── 04_support.md ├── guides/ │ └── balance-settlement-methodology.md ├── lib/ │ └── settlement.py ├── resources/ │ └── jobs.yml ├── src/ │ ├── 01_balance_settlement.sql │ ├── 02_volume_fees.sql │ └── 03_energy_metering_split.sql └── tests/ └── test_settlement.py

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.

Code Sample .py preview

conftest.py import os,sys sys.path.insert(0, os.path.dirname(__file__))