Have a personal or library account? Click to login
RColSim: An R-Based Open-Source Regional Water Management Model for the Columbia River Basin Cover

RColSim: An R-Based Open-Source Regional Water Management Model for the Columbia River Basin

Open Access
|Apr 2026

Figures & Tables

Figure 1

Conceptual schematic of RColSim and the six major sub-basins that RColSim simulates.

Figure 2

Code architecture of RColSim.

Figure 3

Seasonality of system operation and rule curve selection process for operation of the Columbia River Basin. Each week one of these rule curves is selected for the operation of each dam in the CRB water system. Overall, water stored behind dams cannot be more than the flood control URCs. In terms of the minimum operation level (CRC and ORCLL), the rule curves cannot drop below the dam water level during the worst historical water supply year.

Figure 4

Simulated vs. observed long-term mean change in reservoir storage by calendar month, post-processed from on the original weekly time step simulation from 1979 to 2007.

Table 1

Performance metrics for RColSim simulated vs. observed monthly dam outflow. These metrics include the Pearson Correlation Coefficient (r), Mean Error (ME), Kling-Gupta Efficiency (KGE), Normalized Root Mean Square of Error (NRMSE), and Volumetric Efficiency (VE). The simulation period is from August 1979 to September 2007. The original simulation time step was weekly, which was aggregated to monthly to construct this table. The table also provides information about dam location in the basin and acronyms used in RColSim to refer to each dam.

DAM NAMEBASINRColSim_namesMENRMSE%rKGEVE
BonnevilleLower ColumbiaBON2497.9454.30.880.810.85
The DallesLower ColumbiaDA2511.9252.40.880.830.85
John DayLower ColumbiaJD1941.0952.80.880.830.85
McNaryLower ColumbiaMCN2456.0352.90.880.840.84
LibbyKootenayLB–384.66114.40.390.390.51
Bonners FerryKootenayBONF–574.7105.30.490.480.62
Corra LinnKootenayCL–1256.8363.80.810.80.78
DuncanKootenayDU–166.5788.40.570.550.48
BrownleeSnake RiverBR737.6590.20.780.520.6
DworshakSnake RiverDW376.35121.60.340.330.35
Hells CanyonSnake RiverHC758.8486.10.80.540.62
Ice HarborSnake RiverIH–362.3540.20.930.870.8
Little GooseSnake RiverLIG2463.9145.30.930.780.78
Lower MonumentalSnake RiverLM2603.7645.20.930.780.79
Lower GraniteSnake RiverLG2068.1945.10.930.790.79
Grand CouleeMid-ColumbiaGC–3569.2781.80.670.670.81
Priest RapidsMid-ColumbiaPR1786.24710.770.760.82
Rock IslandMid-ColumbiaRI1645.6970.20.770.760.83
Rocky ReachMid-ColumbiaRR1645.9173.70.750.740.82
WanapumMid-ColumbiaWA1599.9170.30.770.760.83
WellsMid-ColumbiaWE1639.4475.20.740.730.82
Chief JosephMid-ColumbiaCJ1547.7881.20.690.690.81
Albeni FallsPend OreilleAF–1068.7149.10.870.80.78
BoundaryPend OreilleBD–941.5646.90.890.840.79
CabinetPend OreilleCB–840.2743.30.90.830.77
Hungry HorsePend OreilleHH–89.69141.50.110.10.27
KerrPend OreilleKE–252.8379.40.640.60.66
Noxon RapidsPend OreilleNOX–774.4845.20.890.810.76
MicaUpper ColumbiaMI–904.0383.80.610.590.67
RevelstokeUpper ColumbiaREV–1173.3495.30.530.520.75
Keenleyside (Arrow)Upper ColumbiaAR–2359.7893.40.560.560.7
Figure 5

Incremental drainage areas for each dam simulated in RColSim. The red triangles mark the location of dams with reservoirs, and the black stars indication the location of run-of-river dams. The light gray boundaries delineate the incremental drainage area between downstream and immediately upstream dam(s).

DescriptionAbbreviation
1Columbia River BasinCRB
2No-Regulation, No-IrrigationNRNI
3Bonneville Power AdministrationBPA
4Critical Rule CurveCRC
5Operating Rule Curves Lower LimitORCLL
6Upper Rule CurveURC
7Assured Rule CurveARC
8Variable Rule CurveVRC
9Pearson Correlation Coefficientr
10Mean ErrorME
11Kling-Gupta EfficiencyKGE
12Normalized Root Mean Square of ErrorNRMSE
13Volumetric EfficiencyVE
DOI: https://doi.org/10.5334/jors.406 | Journal eISSN: 2049-9647
Language: English
Submitted on: Nov 23, 2021
|
Accepted on: Mar 10, 2026
|
Published on: Apr 1, 2026
Published by: Ubiquity Press
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2026 Keyvan Malek, Matthew Yourek, Jennifer Adam, Alan Hamlet, Kirti Rajagopalan, Patrick Reed, published by Ubiquity Press
This work is licensed under the Creative Commons Attribution 4.0 License.