# Crimson BEC – product description and readiness

Written in plain English so a new reader can follow it.

## What the finished product does

A solicitor (or a lead provider working for one) has a pile of energy paperwork for a business. The pile may include contracts, welcome letters, bills, letters of authority, emails and earlier reports.

The product:

1. Accepts that pile (one case or many).
2. Sorts energy documents from mortgage documents and from junk files.
3. Copies the numbers and names that are actually on the pages into a structured Excel workbook called the Data Bridge.
4. Lists every important blank and what must be asked for.
5. Can load the completed Bridge into the Calculator.
6. Can write a valuation report that shows the figures, the documents, the blanks, and the published cases that describe the method.

It does not tell the solicitor what to plead. It does not fill missing commission or “fair” rates.

## The five parts, explained

**1. Crimson Extract (the Agent)**  
Software. You point it at a folder or a zip. It classifies each file and, when the layout is known, copies fields such as MPAN, start date, unit rate and kWh.

**2. Crimson Data Bridge**  
An Excel file with sheets for contracts, bills, a document list, blanks and actions, a glossary, and a weekly improvement log. This is the single place a human checks before any money figure is treated as ready.

**3. Crimson Calculator**  
The repaired Business Energy Calculator workbook. It only calculates from Bridge values. If a fair rate is blank, Method 1 is not invented.

**4. Crimson Quantum Valuation**  
The Word report. Hybrid style: clear English, short tables, document schedule, observed issues, next steps. Assertions are tied to a document or to a named case. Empty appendices are not issued.

**5. Weekly Calculator review**  
Once a week the system proposes updates (for example whether to add a documented SONIA option). You agree, set a later date, or reject for this week only. A rejection does not kill the idea; it comes back the following week.

## What is still blocked on the Agent

- Automatic reading of every supplier layout. Patterns exist for British Gas, Opus/welcome, CNG. Other suppliers (Yu, SSE, Drax, E.ON, Engie, Haven, Gazprom) need the next raw packs to lock.
- Automatic fill of the Calculator .xlsm (openpyxl can write values; VBA macros stay in the original file).
- Batch of 20 live cases until more complete contract + bill sets arrive.
- .msg email bodies (files can be listed; full parse still to be added).

One case at a time can be run now: classify → Bridge with blanks → human complete the blanks → Calculator → report.

## Documents needed for a complete energy case

- Signed contract or welcome / award schedule
- Letter of Authority if a broker was used
- Consecutive bills covering the period claimed
- Any renewal quote or switch email that shows rates
- Any earlier valuation or opinion already obtained (used as reference, not as a source of invented rates)

## Mortgage files

If a mortgage SAR arrives in the same upload it is labelled and held out. It is not written into Contracts_Import or Bills_Import.