WAFLEX¶
An open spreadsheet framework that propagates river-basin demand upstream and water supply downstream through reach, demand, and rule-curve reservoir cells.
Core Idea¶
WAFLEX—the Water Allocation Flow model in Excel—is an open, spreadsheet-based river-basin simulation framework that represents a basin as linked reaches, inflows, demand nodes, and reservoirs, then couples two directional calculations: a demand module propagates required releases upstream, while a supply module propagates available water and actual allocations downstream. Reservoir cells apply declared operating rule curves and losses. Repeated time steps produce flow, storage, abstraction, shortage, and satisfaction series for comparing development, allocation, and dam-operation scenarios.
The name denotes a reproducible modeling architecture, not one immutable workbook or a vendor application. Each application schematizes a particular basin and can extend the spreadsheet formulas and macros.
Scope of Application¶
WAFLEX applies to basin-scale planning problems in which the main concern is how exogenous inflow and declared operating policies distribute water among reservoirs, users, transfers, environmental requirements, and downstream obligations. It is especially suited to scenario questions whose topology can be schematized as a directed river network and whose relevant dynamics can be represented at a coarse time step.
The Komati application compared present and future demand, five principal use classes, cross-border flow obligations, and new dam effects. Its independently built WAFLEX model reproduced the trend of a comparison model and projected shortages under expanded demand.
Clarity¶
A purported WAFLEX analysis should answer six concrete questions. What basin nodes and links were represented? What flow series entered at the boundary? How did the demand pass aggregate downstream requirements? How did the supply pass allocate available flow? What reservoir curves and rationing rules governed release? Which outputs were calibrated or checked against observations?
Manages Complexity¶
River-basin planning couples a physical network, storage over time, heterogeneous demands, environmental constraints, operating policies, uncertain inflow, and political boundaries. WAFLEX compresses that complexity into an editable dependency network whose cells correspond to meaningful basin roles. A modeler can trace a shortage backward through downstream demand, reservoir release, storage limits, and upstream inflow rather than treating a system result as an opaque solver output.
Abstract Reasoning¶
The framework licenses conditional deductions once topology, boundary data, and rules are fixed.
Conservation diagnosis. If the sum of storage change, releases, abstractions, spill, losses, and downstream flow does not close against inflow, then a link, loss, return, formula, or boundary term is missing or inconsistent. This is the Reservoir-Flux Network inference inherited by WAFLEX.
Knowledge Transfer¶
WAFLEX transfers literally among river basins by remapping the same roles. An inflow series in the Komati maps to an inflow series in the Umbeluzi or Zambezi; a municipal demand maps to irrigation, hydropower, cross-border minimum flow, or environmental release; a reservoir's curves map to the locally declared operating zones. The formulas remain recognizable while topology and policies change.
Relationships to Other Abstractions¶
Current abstraction WAFLEX Domain-specific
Parents (1) — more general patterns this builds on
-
WAFLEX is a kind of Reservoir-Flux Network Prime
WAFLEX strictly specializes Reservoir-Flux Network.
Hierarchy path (1) — routes to 1 parentless root
- WAFLEX → Reservoir-Flux Network → Conservation Laws → Invariance
Neighborhood in Abstraction Space¶
WAFLEX sits in a sparse region of the domain-specific corpus (97th percentile for distinctiveness): few abstractions share its structure, so a faithful description tends to retrieve it precisely.
Family — Unclustered & Miscellaneous (1565 abstractions)
Nearest neighbors
- Watershed — 0.77
- Isolated System — 0.76
- Tier 1 Network — 0.76
- Automatic Differentiation — 0.75
- Logic Model (Program Evaluation) — 0.75
Computed from structural-signature embeddings · 2026-09-08