Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

Code Efforts Supporting 'Immersive Model for Lake Mead Based on the Principle of Division of Reservoir Inflow'


A newer version of this resource http://www.hydroshare.org/resource/27efb472ec9f4632910719b1f0c74fa2 is available that replaces this version.
Authors:
Owners: This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Type: Resource
Storage: The size of this resource is 3.4 MB
Created: Jul 22, 2025 at 10:37 p.m. (UTC)
Last updated: Jul 29, 2025 at 10:12 p.m. (UTC)
Citation: See how to cite this resource
Sharing Status: Public
Views: 101
Downloads: 0
+1 Votes: Be the first one to 
 this.
Comments: No comments (yet)

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

Subject Keywords

Coverage

Spatial

Coordinate System/Geographic Projection:
WGS 84 EPSG:4326
Coordinate Units:
Decimal degrees
Place/Area Name:
Colorado River Lower Basin
North Latitude
36.4136°
East Longitude
-110.1270°
South Latitude
30.5162°
West Longitude
-120.6299°

Content

README.md

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 furthur 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 cosecutive 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.

Software Needed

The software applications needed to reproduce these results are Microsoft Excel, and PyCharm.

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.

Reproducibility

To reproduce the results for MinimumThreeHydrologyScenariosCode, follow the directions below. 1. Install Microsoft Excel and Pycharm. 2. Download HydrologicScenarios.xlsx 3. Open MinimumThreeHydrologyScenariosCode with Pycharm. 4. Select a Python interpreter. 5. Open settings in Pycharm. a. Select "Project:MinimumThreeHydrologyScenariosCode", "Python Interpreter", then "+". b. In the search bar, type, "pandas". Select "pandas" then "Install Package". c. Repeat step 5b. with "openpyxl" instead of "pandas". 6. Change the value for "excel_path" to the path were HydrologyScenarios.xlsx is stored. Ensure all back slashes are changed to forward slashes and that 'C:' is deleted. 7. Change the value for "output_path" to desired path to an excel book. Ensure all back slashes are changed to forward slashes and that 'C:' is deleted. 8. Click the play arrow to run the code. 9. The results will be stored in a created excel file in the output path specified above. 10. To reproduce results for MinimumFourHydrologyScenariosCode and MinimumFiveHydrologyScenariosCode, follow steps follow steps 1-9, but use the desired code in place of MinimumThreeHydrologyScenariosCode.

Contact Information

Authors

Anabelle Myers. Email: A02369941@aggies.usu.edu.

David E. Rosenberg. Email: david.rosenberg@usu.edu

Related Resources

This resource has been replaced by a newer version Myers, A., D. E. Rosenberg (2025). Code Efforts Supporting 'Immersive Model for Lake Mead Based on the Principle of Division of Reservoir Inflow', HydroShare, http://www.hydroshare.org/resource/27efb472ec9f4632910719b1f0c74fa2

How to Cite

Myers, A., D. E. Rosenberg (2025). Code Efforts Supporting 'Immersive Model for Lake Mead Based on the Principle of Division of Reservoir Inflow', HydroShare, http://www.hydroshare.org/resource/6623ca4699f2485b9772f4daded15dd4

This resource is shared under the Creative Commons Attribution CC BY.

http://creativecommons.org/licenses/by/4.0/
CC-BY

Comments

There are currently no comments

New Comment

required