ABSTRACT:

The purpose of this code is to identify periods of three-, four-, and 10-year extreme low natural flow at Lee Ferry. The code also identifies when the rolling sum of ten consecutive values sums to less than 75 million acre-feet (maf). These values are pulled out from the traces and ensembles in the HydrologyScenarios.xlsx file (Salehabadi, 2024). The results of this code are used to create scenarios of extreme low inflow to Lake Mead.

Description of Contents
1.HydrologyScenarios.xlsx is the input for all three codes. This workbook comes from Salehabadi et al, 2024).
2. MinimumHydrologyScenarios - Folder contains the Python code (MinimumHydrologyScenarios.py) used to find 3-, 4-, and 10-year minimum flows.
3. Old - Folder with older versions of Python code.
4. MinimumHydrologyScenarios/Results - Subfolder that contains results in Excel files, e.g., 3yearsMinimumHydrologyResults.xlsx.

The README.md file below shows an in-depth description of the contents and reproducibility.

Contact Information
Authors
Anabelle Myers. Email: A02369941@aggies.usu.edu.
David E. Rosenberg. Email: david.rosenberg@usu.edu

ABSTRACT:

The purpose of this immersive online collaborative model is to give collaborators the opportunity to immerse in and personify water user roles for a Lake Mead model based on the principle of division of reservoir inflow. The model works on the principles of A) Divide reservoir inflow, B) Subtract evaporation, and C) Users consume and conserve within their available water, others choices, and real-time discussion of choices. There are six users in the model - Reclamation, California, Arizona, Nevada, Mexico, and Tribal Nations of the Lower Colorado River Basin. We see uses of the tool for two purposes:

1) As researchers we want to learn: Why basin partners choose assumptions and how extreme; Why and how basin partners manage their risk of uncertain future water supply; Which new insights they take from a model session.
2) Provoke thought and discussion to: i) Stabilize and recover reservoir storage under conditions of low storage and low inflow, and ii) Give users more autonomy to manage their conflicting vulnerabilities to water shortages.

The README file below provides more background on the model, the 3 key ideas, and instructions to download the model file, move into Google Drive, invite colleagues/co-workers/friends/family, and guide an immersive model session.

Contents of this resource:
1) ImmersiveModelLakeMeadDivideInflow-LetsStart.pdf - Visualization of the 3 key ideas for the model and directions to start a model session.
2) ImmersiveModelLakeMeadDivideInflow-LetsStart.pptx - Powerpoint version of the LetsStart pdf file.
3) LakeMeadWaterBankDivideInflow.xlsx - Model file in Excel. Download, move into Google Drive, invite people to join, and follow the remaining instructions on the ReadMe-Directions worksheet.
4) LakeMeadWaterConservationProgramAnalysis.docx - Draft manuscript for the immersive model in Word format. This manuscript also shares 10 successes of the current Lake Mead water conservation (Intentionally Created Surplus) program.
5) README.md - Markdown file with more information about the model including the 3 key ideas, requirements to use, directions to guide a model session, and further reading.

Folders
6) IRB - documents required to share with potential collaborators that are required by Utah State University's Institutional Review Board (IRB).
7) ModelGuide - Model guide in MS Word (.docx) and Markdown (.md). The file includes help, background, suggestions for each row in the model, and supporting figures and tables. Links in Column N on the "Master" worksheet of the model file lead directly to sections in the Markdown file.

ABSTRACT:

The purpose of this immersive online collaborative model is to give collaborators the opportunity to immerse in and personify water user roles for a Lake Mead model based on the principle of division of reservoir inflow. The model works on the principles of A) Divide reservoir inflow, B) Subtract evaporation, and C) Users consume and conserve within their available water, others choices, and real-time discussion of choices. There are six users in the model - Reclamation, California, Arizona, Nevada, Mexico, and Tribal Nations of the Lower Colorado River Basin. We see uses of the tool for two purposes:

1) As researchers we want to learn: Why basin partners choose assumptions and how extreme; Why and how basin partners manage their risk of uncertain future water supply; Which new insights they take from a model session.
2) Provoke thought and discussion to: i) Stabilize and recover reservoir storage under conditions of low storage and low inflow, and ii) Give users more autonomy to manage their conflicting vulnerabilities to water shortages.

The README file below provides more background on the model, the 3 key ideas, and instructions to download the model file, move into Google Drive, invite colleagues/co-workers/friends/family, and guide an immersive model session.

Contents of this resource:
1) ImmersiveModelLakeMeadDivideInflow-LetsStart.pdf - Visualization of the 3 key ideas for the model and directions to start a model session.
2) ImmersiveModelLakeMeadDivideInflow-LetsStart.pptx - Powerpoint version of the LetsStart pdf file.
3) LakeMeadWaterBankDivideInflow.xlsx - Model file in Excel. Download, move into Google Drive, invite people to join, and follow the remaining instructions on the ReadMe-Directions worksheet.
4) LakeMeadWaterConservationProgramAnalysis.docx - Draft manuscript for the immersive model in Word format. This manuscript also shares 10 successes of the current Lake Mead water conservation (Intentionally Created Surplus) program.
5) README.md - Markdown file with more information about the model including the 3 key ideas, requirements to use, directions to guide a model session, and further reading.

Folders
6) IRB - documents required to share with potential collaborators that are required by Utah State University's Institutional Review Board (IRB).
7) ModelGuide - Model guide in MS Word (.docx) and Markdown (.md). The file includes help, background, suggestions for each row in the model, and supporting figures and tables. Links in Column N on the "Master" worksheet of the model file lead directly to sections in the Markdown file.

ABSTRACT:

ImmersiveModelLakeMead
This code identifies three, four, and five lowest consecutive annual scenarios of natural inflow to Lake Powell. These values are pulled out from the traces and ensembles in the HydrologyScenarios.xlsx file (Salehabadi, 2023). The results of this code are used to create scenarios of extreme low inflow to Lake Mead.

Description of Contents
The HydrologyScenarios.xlsx is the input for all three codes. A further description can be found below in the Input section. The file "ThreeMinimumHydrologyScenarios" includes the code used to find the the three most minimum consecutive values in each ensemble in the input. The results of this code are in this folder. Two near identical folders, "FourMinimumHydrologyScenarios" and "FiveMinimumHydrologyScenarios" include similar contents. "FourMinimumHydrologyScenarios" contains code and results for four most minimum consecutive values in each ensemble and "FiveMinimumHydrologyScenarios" contains code and results for five most minimum consecutive values in each ensemble.

Input
This excel workbook, created by Homa Salehabadi using different hydrologic scenarios, shows inflow values to Lee's Ferry for differing hydrologic scenarios. Values from these ensembles and traces were used as input to the ImmersiveModelLakeMead code.

Output
Three different excel workbooks were written with the results from three slightly different python code. The output shows three, four, or five overall consecutive minimum values from each ensemble from the input. These results are written from the Python code into Excel workbooks.

Contact Information
Authors
Anabelle Myers. Email: A02369941@aggies.usu.edu.
David E. Rosenberg. Email: david.rosenberg@usu.edu

ABSTRACT:

The purpose of this immersive online collaborative model is to give collaborators the opportunity to immerse in and personify water user roles for a Lake Mead model based on the principle of division of reservoir inflow. The model works on the principles of A) Divide reservoir inflow, B) Subtract evaporation, and C) Users consume and conserve within their available water, others choices, and real-time discussion of choices. There are six users in the model - Reclamation, California, Arizona, Nevada, Mexico, and Tribal Nations of the Lower Colorado River Basin. We see uses of the tool for two purposes:

1) As researchers we want to learn: Why basin partners choose assumptions and how extreme; Why and how basin partners manage their risk of uncertain future water supply; Which new insights they take from a model session.
2) Provoke thought and discussion to: i) Stabilize and recover reservoir storage under conditions of low storage and low inflow, and ii) Give users more autonomy to manage their conflicting vulnerabilities to water shortages.

The README file below provides more background on the model, the 3 key ideas, and instructions to download the model file, move into Google Drive, invite colleagues/co-workers/friends/family, and guide an immersive model session.

Contents of this resource:
1) ImmersiveModelLakeMeadDivideInflow-LetsStart.pdf - Visualization of the 3 key ideas for the model and directions to start a model session.
2) ImmersiveModelLakeMeadDivideInflow-LetsStart.pptx - Powerpoint version of the LetsStart pdf file.
3) LakeMeadWaterBankDivideInflow.xlsx - Model file in Excel. Download, move into Google Drive, invite people to join, and follow the remaining instructions on the ReadMe-Directions worksheet.
4) LakeMeadWaterConservationProgramAnalysis.docx - Draft manuscript for the immersive model in Word format. This manuscript also shares 10 successes of the current Lake Mead water conservation (Intentionally Created Surplus) program.
5) README.md - Markdown file with more information about the model including the 3 key ideas, requirements to use, directions to guide a model session, and further reading.

Folders
6) IRB - documents required to share with potential collaborators that are required by Utah State University's Institutional Review Board (IRB).
7) ModelGuide - Model guide in MS Word (.docx) and Markdown (.md). The file includes help, background, suggestions for each row in the model, and supporting figures and tables. Links in Column N on the "Master" worksheet of the model file lead directly to sections in the Markdown file.