WRIMSII/CalSim II Training Program

This is a table-of-contents for a six-session WRIMS/CalSim II introductory training program, whose goal is to provide the trainee with an overview of WRIMS II and one of its primary applications: CalSim II. Topics covered range from high-level conceptual understanding of CalSim II to ground-level code implementation of facilities, hydrology, regulations and operations in CalSim II.

How to use this document

Those who are new to CalSim II and WRIMS should follow the sessions in this program sequentially, making sure that session objectives are understood and met before moving on. Those who want to explore a particular aspect of the model may navigate to the training session whose training objective corresponds best with their learning objective.

Each session contains several sub-sections to fulfill the parent session’s objectives. Each sub-section consists of the primary training PowerPoint, and (if applicable) a corresponding hands-on exercise and reference materials.

Hands-on: Some sessions contain exercises to demonstrate a key concept. These exercises can be WRIMS II applications, Excel spreadsheets or other post processing tools.

Reference: Documentation for the topics covered in the PowerPoint.

Training objectives:

·  Understand the role of CalSim II and its application as a planning model

·  Obtain an overview of the CVP-SWP system as it is modeled in CalSim II

·  Identify key assumptions and limitations of the model

·  Understand hydrology development in CalSim II, including sources of Input Data

·  Understand how the Delta and its requirements are simulated within CalSim II

·  Understand how reservoirs and allocations are simulated within CalSim II

·  Analyze and Interpret Study results, including post-processing tools

·  Perform QA/QC of a study

The training materials linked in this document are all available in the CalLite Collaboration Portal Library, under the CalSim II Training 2016 folder.

https://callitecollaboration.water.ca.gov/

Software Inventory

The table below contains the required companion software for the hands-on exercises, along with optional (but highly recommended) utilities for CalSim II modeling.

Software / Description
Required[1] / 1. WRIMS GUI/IDE 64 Bit / WRIMS GUI/IDE. This is the primary utility to run, develop, debug and post-process CalSim II studies.
Required / 2. 2015 DCR CalSim II Study / 2015 DCR CalSim II Study: The latest CalSim II benchmark study from the 2015 Delivery Capability Report. Existing conditions (2020 LOD), no climate change, D-1641 and NMFS/FWS Biological Opinions. The hands-on activities will be focused on this model.
Required / 3. XA 16 Driver / Driver for the XA 16 dongle. Required for running CalSim II studies.
Required / 4. HEC DSSVue / Visual utilities program that allows users to plot, tabulate, edit, and manipulate data in a HEC-DSS database file.
Optional for training[2] / 5a. 3.21 DSS Excel Add-in (Install this first)
5b. 3.3 DSS Excel Libraries for double precision (Upgrade from 3.21 to 3.3 by using libraries from this package) / VBA add-in to for retrieving and storing both regular-interval time series and paired data directly from Excel to an HEC-DSS database file. This add-in is required in order to load new DSS files into the Excel tools.
Note: The Excel tools used during the training sessions will have CalSim II studies pre-loaded, so it is not necessary to install the Add-in for training purposes. However, it is highly recommended that you install this Add-in for your future use
Optional for training / CS Diff / Utility to compare two text files or folder structures. Very valuable for determining code changes between two incremental CalSim II studies.
Optional for training / Notepad++ / Text editing utility. User-defined language for WRESL included.
Required / CalLite GUI V3 / Post process CalSim & CalLite Studies

Session 1: Introduction

Session Objectives: Obtain a high-level understanding of CalSim II from both a conceptual and technical standpoint. Conceptually, understand the role of CalSim II and its application as a planning model.

From a technical perspective, understand the principle of linear programming in the context of CalSim II.

“How does linear programming and optimization, formulated in the context of the CalSim II model, lend itself to solving planning and management problems in California’s water?”

1a.  CalSim II Overview

·  Presenter: Erik Reyes (DWR)

1b.  Successful CalSim II applications

·  Presenter: Nancy Parker (BOR)

1c.  WRIMS and linear programming

·  Presenter: Nazrul Islam and Hao Xie (DWR)

·  Hands-on exercise: Two variable LP problem

·  Reference: WRESL Language Reference

·  Reference: WRIMS GUI/IDE Quick Start and WRIMS/IDE Video Demo

1d.  Simple network example (Hands-on exercise)

·  Presenter: Nancy Parker (BOR)

·  Hands-on exercise: WRESL code for the simple network example study

Session 2: CalSim II Model Domain/Facilities

Session Objectives:

·  Understand the CalSim II file structure and modeling framework

·  Understand the physical and institutional model domain of CalSim II, including the geographical coverage, physical features and demands modeled (including modeling abstractions).

·  View results from CalSim II runs

2a.  Main.wresl, Cycles, & CalSim folder structure

·  Presenter: Nancy Parker (BOR)

2b.  North-of-Delta

·  Presenter: Nancy Parker (BOR)

2c.  San Joaquin

·  Presenter: Nancy Parker (BOR)

2d.  Delta and South-of-Delta

·  Presenter: Raymond Hoang (DWR)

2e.  Hands-on comparison of CalSim studies

·  Presenter: Karandev Singh (DWR)

·  Hands-on exercise: Post-processing with CalLite GUI

2f.  Demands

·  Presenter: Karandev Singh (DWR)

·  Reference: Model Inputs

Session 3: Hydrology

Session Objectives: Understand the sources of hydrologic model inputs for the Delta and Sacramento Valley.

3a.  Delta Hydrology

·  Presenter: Idy Lui (DWR)

3b.  Sacramento Valley Hydrology

·  Presenter: Richard Chen (DWR)

3c.  Setting up a scenario for unimpaired flow

·  Presenter: Nancy Parker (BOR)

·  Hands-on exercise: Unimpaired flow example study

Session 4: Regulations

Session Objectives:

·  Understand what regulations are (and are not) modeled in CalSim II, along with how they are implemented in WRESL code.

·  View and post-process results from CalSim II runs

4a.  D-1641 and Biological Opinions

·  Presenter: Raymond Hoang (DWR)

·  Reference: SWRCB Decision 1641

·  Reference: 2009 NMFS Salmon Biological Opinions

·  Reference: 2008 FWS Biological Opinions

4b.  Artificial Neural Networks

·  Presenter: Nazrul Islam (DWR)

·  Hands-on exercise: Swapping the ANN Dynamic Link Library (DLL)

4c.  CVPIA (b)(2) Actions

·  Presenter: Nancy Parker (BOR)

4d.  Delta Post processing tool

·  Presenter: Raymond Hoang (DWR)

·  Hands-on exercise: CalSim II Operations Control Post-Processing Spreadsheet

Session 5: Operations

Session Objectives: Understand how reservoir and allocation logic is represented for each project individually and recognize how the CVP and SWP operations are related through the implementation of the Coordinated Operations Agreement.

5a.  Coordinated Operations Agreement (COA)

·  Presenter: Nazrul Islam (DWR)

·  Reference: Coordinated Operations Agreement between SWP and CVP

5b.  CVP Allocations and Reservoirs

·  Presenter: Nancy Parker (BOR)

5c.  SWP Allocations and Reservoirs

·  Presenter: Karandev Singh (DWR)

Session 6: Technical

Session Objectives: Introduce methods of debugging CalSim II model runs with both the xa.log file and through the WRIMS GUI/IDE.

6a.  Introduction to xa.log, weights and QA/QC

·  Presenter: Nancy Parker (BOR)

·  Reference: XA Solver Documentation

6b.  Debugging (Presentation not available)

·  Presenter: Hao Xie (DWR)

·  Hands-on exercise: Debugging using the WRIMS II GUI/IDE

Note: The training material presented in this document is designed for a three-day workshop, with instruction through both lectures and hands-on exercises. Presenting the material in a self-guided training program inevitably will omit some aspects captured during the original training, including question/answer sessions with the instructors. The contact information for the trainers is below, should questions arise.

Contact Information:

Erik Reyes, DWR () / Nancy Parker, BOR ()
Nazrul Islam, DWR () / Hao Xie, DWR ()
Richard Chen, DWR () / Idy Lui, DWR ()
Karandev Singh, DWR () / Raymond Hoang, DWR ()

Other References

CalLite Schematic

CalSim II Schematic

CalSim Benchmark Assumptions and Appendices

2015 Delivery Capability Report

CalLite Reference Manual

CalLite User’s Guide

WRIMS/CalSim II Trainingpg. 4

[1] Required software will be used over the course of the training sessions and should be installed prior to arriving at training sessions.

[2] Optional for training: this software will not be directly used during the training sessions, but are extremely valuable utilities for developing, debugging and post-processing models. These tools are commonly used in day-to-day CalSim II modelling; they are provided here for your convenience.