Consumer Unit Builder

Workbook tabs: Products (one row per brand per part — Brand + Key identify it; boards never mix brands, so give each board brand its own rows. Brand only restricts for board brands (Proteus / Whitecliffe) — parts branded by inverter makers (Fox, Sig, Ecoflow) or “Any”, like the meters, fit any board; don't change the Key column — edit descriptions, part codes and prices freely), Inverters (add or remove models; Brand must be “Fox” or “Sig” for brand-specific rules to apply), EV Chargers (one row per charger model: Make, Model, Devices (keys) — comma-separated Product keys for the device(s) that model puts on the board; every key must have a Products row), ASHP (one row per heat pump model: Make, Model, kW, and Devices (keys) — the Product keys for everything that model puts on the board: the heat-pump circuit device(s) plus the immersion RCBO, e.g. rcbo-bidir-c-32, rcbo-typea-16. Key families: rcbo-bidir-A = the inverter-circuit RCBO (plain 1BK range), rcbo-typeb-A = B Curve Type B BD 1BKxB (Cosy), rcbo-bidir-c-A = C Curve Type B BD 1CKxB (Mitsubishi and the other ASHPs), rcbo-typea-A = Type A B-curve (immersion). Leave Devices blank until confirmed and the app warns instead of guessing; every key needs a matching Products row in the board's brand), Enclosures — one row per board you buy, bare or pre-populated. Colour = black / white / grey (or blank) — used by the optional colour preference; while a colour is picked, boards with no colour recorded are hidden. Free Ways = module spaces left for devices (for a bare box that's its total modules). Put Y in the Includes columns if the board ships with the 100A main switch / SPD / busbar — those parts then drop off the buy list and show up as bullet points on the recommended-board tile. If a board also comes with devices fitted (e.g. the Whitecliffe's two 32A RCBOs), list them in Included Devices (keys) using Product keys, e.g. 2x rcbo-bidir-32 — when a job needs that exact device the board supplies it for free; when it needs a different size the app buys the right one and shows the fitted device as leftover spare stock. The app compares every board that fits, cheapest total first.