David E Rosenberg

Utah State University | Associate professor

Subject Areas: water management

 Recent Activity

ABSTRACT:

The purpose of this activity is to provoke collaborators to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Collaborators use web spreadsheets (Google Sheets) during a video conference session. In a model session, up to 6 collaborators immerse in water user roles. Then in each time step, collaborators consume, conserve, and trade water in response to their available water, others choices, and real-time discussion of choices. Collaborators also protect critical levels in Lake Powell and Lake Mead and sustain endangered, native fish of the Grand Canyon. Follow the requirements and start directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsInteractImmerseAdaptReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.
6) 1-Page Summary - ColoradoRiverBasinWaterAccounts-1PageSummary-v2.pdf.

Please access the final peer-reviewed, published version of the manuscript at:
+ Rosenberg, D. E. (2024). "Lessons from immersive online collaborative modeling to discuss more adaptive reservoir operations." Journal of Water Resources Planning and Management, 150(7). https://doi.org/10.1061/JWRMD5.WRENG-5893.

Show More

ABSTRACT:

Video #2 in the Research Reproducibility series for the Journal of Water Resources Planning and Management (JWRPM). This video is titled "How to Submit my Reproducible Research?" and describes the process by which authors can opt in to JWRPM's Reproducibility Review program and how they can prepare their manuscript to be successful in this reproducibility review.

Show More

ABSTRACT:

This collection shares pre-prints of videos with tips, how-to, lessons, and other content to help researchers make their results more reproducible. Authors create a new Hydroshare resource that includes meta data and the video file. Authors request the Collection Owners add their resource to this collection. Then authors submit a short brief in the Editorial Manager system of the American Society of Civil Engineers (ASCE) Journal of Water Resources Planning and Management (https://ascelibrary.org/journal/jwrmd5) for publication. The brief includes a one-sentence citation to the Hydroshare resource containing the video content. The video undergoes a peer-review process. On acceptance, ASCE Publishing will attach branding to the video. The content will receive a digital object identifier (DOI) and be published in the Journal -- same as regular articles, case studies, etc. ASCE will also push videos out on their video and social media feeds.

The intent of collection of videos and the review process is to make peer-reviewed videos findable, accessible, interoperable, and repeatable (FAIR). This process also provides authors of reproducibility content an incentive to create and share new videos and content -- a peer-reviewed publication in the Journal of Water Resources Planning and Management.

Show More

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use an interactive, online spreadsheet (Google Sheet) to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsInteractImmerseAdaptReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More

ABSTRACT:

Steady low reservoir releases allow downstream aquatic invertebrates (bugs) to lay and hatch eggs and increase production. These releases also reduce revenue from hydropeaking operations, increase costs to hydropower customers, reduce funds to maintain project infrastructure, repay project loans, and exacerbate hydropower production-ecosystem conflicts. This paper has the purpose to (1) quantify tradeoffs between the number of days of bug flows and hydropower revenue, (2) identify ways to reduce costs to hydropower customers, and (3) inform the design of a financial instrument to increase bug production, compensate hydropower customers for costs, and reduce conflict. A linear program identified tradeoffs between hydropower revenue and number of days of steady low releases per month for different contract and market energy prices and monthly release volumes across March to October months when bugs are most productive. We found that bug flows on 8 weekend days per summer month in 2018 from Glen Canyon Dam, Arizona reduced hydropower revenue by $300,000 (June) to $600,000 (August). Shifting bug flow days to Spring/Fall months reduced costs. To reduce conflict, we suggest to create a new financial instrument funded by the Federal Treasury for ~$300,000 to $600,000 per month. The instrument can give ecosystem managers more flexibility to choose days for steady low releases that advantage bugs and pay hydropower producers for costs. Next steps are to engage Federal agencies on benefits and limitations of the proposed instrument and expand to steady high releases that mobilize sediment, build sandbars, and disadvantage non-native, invasive fish populations.

This resource contains the following items:

+ README.md - Markdown file with documentation for this resource including directions to reproduce results in the manuscript
+ GCD_BugFlowExperiment-main - Folder with sub-folders that contain the data, models, and code to reproduce figures, tables, and results in the manuscript
+ RindRosenberg-BugsPayForDaysOfSteadyReservoirReleases.docx -- Word document with manuscript for work.
+ Rosenberg-BugsPayForSteadyFlows-AprilAMP.pptx - Power point presentation with overview of work presented at April 12/13, 2023 meeting of the Technical Work Group (TWG) of Glen Canyon Dam Adaptive Management Program (GCD-AMP).
+ KeyFeedbackFromTechnicalWorkGroup-April12-2023.docx - Key feedback from presentation to GCD-AMP Technical Work Group on April 12, 2023.

Show More

 Contact

Resources
All 0
Collection 0
Resource 0
App Connector 0
Resource Resource
RFA 3 Model Inventory
Created: July 16, 2016, 4:11 p.m.
Authors: David Rosenberg

ABSTRACT:

This dataset contains raw data, scripts, and plots used to analyze responses to the iUTAH Research Focus Area (RFA) 3 model inventory. The inventory was conducted via a Google Survey Form among RFA3 researchers on the RFA email list from August 2015 to October 2015. The purpose of the survey/inventory was to overview iUTAH RFA3 team's modeling efforts, map current efforts onto iSAW conceptual model (doi:10.1002/2014EF000295), and identify further opportunities to couple models as part of the RFA3 team's mission. Results herein are intended to help visualize results from the survey and productively encourage further discussion + coupling work.

Show More
Resource Resource
Blended Near Optimal Tools
Created: Feb. 20, 2017, 5:53 a.m.
Authors: David Rosenberg

ABSTRACT:

Links to the repository (https://github.com/dzeke/Blended-Near-Optimal-Tools) that stores the Matlab 2013a source code and (1) Documentation for blended near-optimal tools that (2) generate alternatives, (3) visualize alternatives, and allow a user to interactively explore the near-optimal region from which alternatives are generated. Also contains the data and model files for a (4) linear programming example application to manage water quality for Echo Reservoir, Utah, (5) mixed-integer programming example application to manage water supply and demands in Amman, Jordan, and (6) multi-objective linear programming reservoir operations problem.

Near-optimal alternatives perform within a (near-optimal) tolerable deviation of the optimal objective function value and are of interest to managers and decision makers because they can address un-modelled objectives, preferences, limits, uncertainties, or issues that are not considered by the original optimization model or it's optimal solution. Mathematically, the region of near-optimal alternatives is defined by the constraints for the original optimization model as well as a constraint that limits alternatives to those with objective function values that are within a tolerable deviation of the optimal objective function value. The code and tools within this repository allow users to generate and visualize the structure and full extent of the near-optimal region to an optimization problem. The tools also allow users to interactively explore region features of most interest, streamline the process to elicit un-modelled issues, and update the model formulation with new information. The tools and their use are described here for generating, visualizing, and interactively exploring near-optimal alternatives to optimization problems, but the tools are general and can be used to generate and visualize points within any high-dimensional, closed, bounded region that can be defined by a system of constraints. The parallel coordinate visualization and several interaction tools can also be used for any high-dimensional data set.

Show More
Resource Resource

ABSTRACT:

This resource describes the data and script files used to mine text from 40 water resources systems analysis course syllabi and generate the results presented in Rosenberg et al (2017) "Towards More Integrated Formal Education and Practice in the Water Resources Systems Analysis." ASCE-Journal of Water Resources Planning and Management. The original course syllabi are available on a repository of water resources systems analysis teaching materials at http://ecstatic.usu.edu. The ReadMe file below further describes each file. This work is part of a larger effort to review 40 WRSA course syllabi, interview 10 practitioners, and compare skills taught to the skills practitioners say they need. A preprint of the acticle is provided in the .docx file.

Show More
Resource Resource

ABSTRACT:

This resource describes the data and script files used to mine text from 40 water resources systems analysis course syllabi and generate the results presented in Rosenberg et al (2017) "Towards More Integrated Formal Education and Practice in the Water Resources Systems Analysis." ASCE-Journal of Water Resources Planning and Management. The original course syllabi are available on a repository of water resources systems analysis teaching materials at http://ecstatic.usu.edu. The ReadMe file below further describes each file. This work is part of a larger effort to review 40 WRSA course syllabi, interview 10 practitioners, and compare skills taught to the skills practitioners say they need. A preprint of the acticle is provided in the .docx file.

Show More
Resource Resource
Value Landscape Engineering Lifecycle Model (VLE)
Created: April 16, 2018, 6:12 p.m.
Authors: David Rosenberg · Kelly Kopp · Heidi Kratsch · Larry Rupp · Paul Johnson · Roger Kjelgren

ABSTRACT:

The Value Landscape Engineering (VLE) spreadsheet program identifies the costs, labor, water, fertilizers, pesticides, energy, and fuel required to install and maintain a residential or commercial landscape in Utah. The program also identifies the carbon footprint and particulates generated from landscape installation and maintenance activities. VLE considers all activities associated with a particular landscape over its life with the goal to maximize value and reduce required inputs. The VLE spreadsheet program tabulates all onsite costs, inputs, and impacts over the life of the landscape including preparing the site, purchasing and installing materials, annual maintenance and operations, and replacing landscape features and components that wear out or die. A variety of program options allow the user to select the planting and mulch materials and coverage, structures, irrigation systems, equipment, and to tailor the analysis to site-specific conditions. Users can simultaneously compare up to three different landscapes.
Data to support the spreadsheet program was gathered from the scientific literature, nurseries, websites of manufacturers and home building supply stores, extension publications, and landscape cost estimate reports. Cache Valley and Wasatch Front arborists, landscapers, and Cooperative Extension professionals also provided information specific to their expertise. Because urban landscapes are complex systems, the spreadsheet program makes several simplifying assumptions. Thus, spreadsheet program estimates of required inputs and impacts are accurate to within 30%. Users should verify cost estimates with bids from landscape companies. Given these estimation levels, use the spreadsheet program to compare the relative advantages and tradeoffs among different landscapes. We demonstrate use of the spreadsheet program for three landscapes at the Jordan Valley Water Conservancy District (JVWCD) conservation garden. These landscapes are the Traditional Landscape that has a large area of cool-season turfgrass, shrubs, perennials, ground cover, and common shade trees; the Perennial Landscape that has mostly drought-tolerant perennials and annuals; and the Woodland Landscape that consists largely of drought-tolerant shrubs and trees. To verify spreadsheet program results, we compare spreadsheet program estimates of water, labor, fertilizer, and fuel use in each landscape to observations made over 8 years by JVWCD garden staff. Generally, spreadsheet program estimates and JVWCD staff observations agree within the 30% estimation level for the spreadsheet program. Homeowners, commercial property owners, and landscapers can use the spreadsheet program to identify the total costs, water use, and other required inputs for their landscape choices. The program can identify tradeoffs in costs, inputs, and impacts among an existing (or planned) landscape and modifications to it. By examining results and changing the landscape design, the user can develop a landscape plan that should cost less and require less water, labor, fertilizers, and other inputs.

The published version of the work is available at: Rosenberg, D. E., Kopp, K., Kratsch, H. A., Rupp, L., Johnson, P., and Kjelgren, R. (2011). "Value Landscape Engineering: Identifying Costs, Water Use, Labor, and Impacts to Support Landscape Choice." JAWRA Journal of the American Water Resources Association, 47(3), 635-649. http://dx.doi.org/10.1111/j.1752-1688.2011.00530.x.

Description of file contents:
1) VLE_Manual_Sept2011.pdf: Model manual including quick start guide and directions to use the spreadsheet model
2) ModelDataFiles.zip: Zip folder with files for the different versions of the model.
3) FileDescriptions.txt: Explanation of files in ModelDataFiles.zip and list of model versions

Show More
Resource Resource

ABSTRACT:

This report uses linear optimization to identify a monthly reservoir release strategy that maximizes end-of-water-year storage in Island Park Reservoir, while also satisfying habitat and flow requirements for fish and anglers. Using historic data, I explore how these strategies change across different hydrologic regimes and which fishery constraints are the most limiting.

Show More
Resource Resource

ABSTRACT:

For my term project for the Water Resources Systems Analysis course (CEE 6410), I will use systems analysis approach for improving aquatic habitat for Bonneville cutthroat trout (BCT) in the Bear River watershed in Utah. My goal is to maximize water depth for BCT habitat while meeting the electricity demand produced by hydropower in the watershed.

Show More
Collection Collection
Climate Adaptation Science Project Work
Created: Dec. 7, 2018, 7:03 p.m.
Authors: CAS Coordinator · David E Rosenberg

ABSTRACT:

This collection contains all resources generated as part of the Climate Adaptation Science (CAS) project (https://climateadaptation.usu.edu/). Resources include student course projects, research projects, internship work, assessments of educational outcomes, and other project materials. When creating resources, CAS participants will make all input data, models, code, results, instructions, and other digital artifacts developed for the project available for others to use, with the exception of sensitive human subjects data (expected level of reproducibility of at least Artifacts available). The steps at http://climateadaptation.usu.edu/project-data-models-code/ provide instructions for CAS participants to create a Hydroshare resource and request to add the resource to this collection. These steps were approved by the CAS Leadership Team on Nov. 15, 2018 and will be updated as needed. This collection is maintained by the CAS project coordinator.

Show More
Resource Resource

ABSTRACT:

This resource shares raw and processed pressure transducer, river stage, river flow, river temperature, and channel cross-section data collected and estimated at the Morton Bear River Bottoms on the Bear River, Utah by undergraduate Freshmen Bear River Fellows participating in the Bear River Fellows program between August 14, 2013 and November 18, 2017 (http://BearRiverFellows.usu.edu).

A full description of resource contents is provided in the meta-data file MortonBearRiverFellowsRepositoryText.docx

Show More
Resource Resource

ABSTRACT:

The Colorado River Compact apportions water between upper and lower basin and requires the upper basin to deliver a total of 7.5 MAF to lower basin each year. The Colorado river system has been very reliable in past and has survived many dry periods without failing to meet the demand requirements of both basins. The drought that began in the region at the turn of the century has rendered it very difficult for the upper basin to meet the delivery requirements to the lower basin. Many management options have been explored and some have been implemented to maintain increase the reliability of the system. This report focuses on creating a pareto front for the reliability of the Colorado river supply in response to demands to upper and lower basin. This could help in identify what would be the tradeoffs for reliability of one basin if the system is managed to meet the requirements of the other basin.

Show More
Resource Resource
CAS Data Collection Plan Template
Created: Jan. 17, 2019, 5:31 a.m.
Authors: David Rosenberg · CAS Coordinator

ABSTRACT:

Each Climate Adaptation Science (CAS) project participant/group will complete a Data Collection Plan prior to starting project work. A data collection plan template is provided.

Complete the following for each data collection effort that has funding support from CAS or involves a CAS project participant. All fields are required. “Data” are interpreted broadly to mean all data, models, code, directions, and other artifacts developed and used as part of the effort. Note that if there are substantive changes to the types of data, methods, data formats, products, or availability of data, an updated plan should be submitted.

Show More
Resource Resource
Test Resource
Created: April 6, 2020, 4:26 a.m.
Authors: Rosenberg, David E

ABSTRACT:

My test resources

Show More
Resource Resource
Value Landscape Engineering Lifecycle Model (VLE)
Created: May 4, 2020, 7:26 p.m.
Authors: David Rosenberg · Kelly Kopp · Heidi Kratsch · Larry Rupp · Paul Johnson · Roger Kjelgren

ABSTRACT:

The Value Landscape Engineering (VLE) spreadsheet program identifies the costs, labor, water, fertilizers, pesticides, energy, and fuel required to install and maintain a residential or commercial landscape in Utah. The program also identifies the carbon footprint and particulates generated from landscape installation and maintenance activities. VLE considers all activities associated with a particular landscape over its life with the goal to maximize value and reduce required inputs. The VLE spreadsheet program tabulates all onsite costs, inputs, and impacts over the life of the landscape including preparing the site, purchasing and installing materials, annual maintenance and operations, and replacing landscape features and components that wear out or die. A variety of program options allow the user to select the planting and mulch materials and coverage, structures, irrigation systems, equipment, and to tailor the analysis to site-specific conditions. Users can simultaneously compare up to three different landscapes.
Data to support the spreadsheet program was gathered from the scientific literature, nurseries, websites of manufacturers and home building supply stores, extension publications, and landscape cost estimate reports. Cache Valley and Wasatch Front arborists, landscapers, and Cooperative Extension professionals also provided information specific to their expertise. Because urban landscapes are complex systems, the spreadsheet program makes several simplifying assumptions. Thus, spreadsheet program estimates of required inputs and impacts are accurate to within 30%. Users should verify cost estimates with bids from landscape companies. Given these estimation levels, use the spreadsheet program to compare the relative advantages and tradeoffs among different landscapes. We demonstrate use of the spreadsheet program for three landscapes at the Jordan Valley Water Conservancy District (JVWCD) conservation garden. These landscapes are the Traditional Landscape that has a large area of cool-season turfgrass, shrubs, perennials, ground cover, and common shade trees; the Perennial Landscape that has mostly drought-tolerant perennials and annuals; and the Woodland Landscape that consists largely of drought-tolerant shrubs and trees. To verify spreadsheet program results, we compare spreadsheet program estimates of water, labor, fertilizer, and fuel use in each landscape to observations made over 8 years by JVWCD garden staff. Generally, spreadsheet program estimates and JVWCD staff observations agree within the 30% estimation level for the spreadsheet program. Homeowners, commercial property owners, and landscapers can use the spreadsheet program to identify the total costs, water use, and other required inputs for their landscape choices. The program can identify tradeoffs in costs, inputs, and impacts among an existing (or planned) landscape and modifications to it. By examining results and changing the landscape design, the user can develop a landscape plan that should cost less and require less water, labor, fertilizers, and other inputs.

The published version of the work is available at: Rosenberg, D. E., Kopp, K., Kratsch, H. A., Rupp, L., Johnson, P., and Kjelgren, R. (2011). "Value Landscape Engineering: Identifying Costs, Water Use, Labor, and Impacts to Support Landscape Choice." JAWRA Journal of the American Water Resources Association, 47(3), 635-649. http://dx.doi.org/10.1111/j.1752-1688.2011.00530.x.

Description of file contents:
1) VLE_Manual_Sept2011.pdf: Model manual including quick start guide and directions to use the spreadsheet model
2) ModelDataFiles.zip: Zip folder with files for the different versions of the model.
3) FileDescriptions.txt: Explanation of files in ModelDataFiles.zip and list of model versions

Show More
Resource Resource
Colorado River Coding
Created: April 7, 2022, 1:49 a.m.
Authors: Rosenberg, David E

ABSTRACT:

Small and bigger coding efforts to support Colorado River work. See Folder contents #1-20 below. Most of these efforts are beginning coding efforts and works in progress.

Download data, models, code, and directions at https://doi.org/10.5281/zenodo.5501466.

Find current versions at https://github.com/dzeke/ColoradoRiverCoding.
## Explanation of Contents

1. **500PlusPlan** - Total costs for different 500,000 acre-feet plan for Lake Mead prices and volumes.
2. **BlogDrafts** - Preprints of blogs in the series "Encouraging more water conservation in the Colorado River Basin".
3. **CombinedPowellMead** - Plots of combined Lake Powell and Lake Mead storage over time.
4. **EvapCalcs** - Plots to show reservoir evaporation for Lakes Mead and Powell as a function of reservoir storage/level. This supports
an alternative management paradigm where reservoir evaporation is counted as part of lower basin users consumptive use.
5. **GrandCanyonInterveningFlow** - Plots of Grand Canyon intervening flow between Lake Powell and Lake Mead to help characterize inflows to Lake Mead.
6. **HeadwatersReservoirs** - Storage for Upper Basin headwaters reservoirs (Fontenelle, Flaming Gorge).
7. **ICS** - Plots of intentionally created surplus (ICS) for Lake Mead account balances, puts and takes, limits, and comparison of ICS efforts to mandatory Drought Contigency Plan contributions.
8. **InterimShortageGuidelines** - Plots of cutbacks in deliveries as a function of Lake Mead level. Both for the Interim Guidelines and newly released Drought Contingency Plan.
9. **LakePowellTemperatureScenarios** - Calcualtes the Lake Powell release temperatures for different lake levels. Assigns release temperatures to different fish scenarios.
10. **LowerBasinAgUses** - Plots of CRSS consumptive use input data for Lower Basin states.
11. **MeadInflowSimulations** - Adapt Lake Mead releases to reservoir inflow. Smulations of Lake Mead draw down, stabilization, and recover for different scenarios of Lake Mead inflow and addition water conservation beyond mandatory targets.
12. **MeadPowellPlots** - Visualization of the Lake Powell-Lake Mead Equalization rules. This is Powell annual release as a function of Powell storage and Mead storage. Also includes plots that show the reservoir zones.
13. **ModelMusings** - Pilot flex accounting to encourage more water conservation in a combined Lake Powell-Lake Mead system. Cloud-based interactive model for the Colorado River basin. When participants synchronously connect, they can role play Upper Basin, Lower Basin, Mexico, and other parties. Participants make
year-to-year water conservation, consumption, purchase, and sale decisions for their party while they track other players' choices, account balances, reservoir storage, and impacts to Grand Canyon fish.
14. **Powell10Year** - Plots showing Lake Powell 10-year releases in comparison to Colorado River Compact Article III(d) requirement
15. **Pre1922CompactWaterUse** - Table of Pre-1922 Compact water use by state.
16. **ProtectLakePowell** - Figure of tools to protect Lake Powell elevations of 3,525 and 3,490 feet.
17. **Runge_MCDM_Analysis** - interactive parallel coordinate plot visualization of the 18 objectives use in the analysis by Runge et al of Glend Canyon Dam management alternatives. Runge, M. C., et al. (2015). "Decision analysis to support development of the Glen Canyon Dam long-term experimental and management plan." 2015-5176, U.S. Geological Survey, Reston, VA. http://pubs.er.usgs.gov/publication/sir20155176.
18. **TimeToDeadPool** - a steady deterministic scenario analysis of the number of years to hit Lake Mead dead pool (or other target elevation) given a starting storage volume and steady reservoir inflow. Used to explore scenarios of inflow from 7 to 14 maf per year every year and identify potential effects of additional voluntary water conservation.
19. **TribalWater** - Digitizes some of the data in the Tribal Water Study by the USBR.
20. **UpperBasinAgriculture** - Costs of demand management in Upper Basin.

## License
BSD-3-Clause (https://github.com/dzeke/ColoradoRiverFutures/blob/master/LICENSE). Available to use, modify, distribute, etc. for free.
All modified or derivative products must use the same BSD-3-Clause license. This license keeps this work in the public domain forever.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more flexible and sustainable Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsUseGoogleSheetsZoomToDiscussMoreFlexibleSustainableColoradoRiverOperations.docx. Write up for publication as a journal article.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more flexible and sustainable Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsUseGoogleSheetsZoomToDiscussMoreFlexibleSustainableColoradoRiverOperations.docx. Write up for publication as a journal article.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more flexible and sustainable Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsUseGoogleSheetsZoomToDiscussMoreFlexibleSustainableColoradoRiverOperations.docx. Write up for publication as a journal article.

Show More
Resource Resource

ABSTRACT:

We believe that reproducing results accelerates our science and engineering and increases the number of people who can access, learn by doing, and extend research. To accelerate our fields and increase impact, we partnered with the Environmental Water Resources Institute (EWRI), American Society of Civil Engineering (ASCE) Publishing, and the Journal of Water Resources Planning and Management. We launched a new program where authors opted in, shared all research materials in a public repository, then asked the Journal to use materials to independently reproduce all figures, tables, and results. One year in, we published the first papers with reproduced results free open access to the authors (Journal special collection on articles with reproducible results). The papers were also published with bronze and silver badges because they shared all materials in a public repository and the Journal reproduced results. We also recognized outstanding author and reviewer efforts to make results reproducible and reproduce results. Want to publish a paper with more impact, learn by doing, or expand the program to a new journal? Attend this plenary talk.

Bio - David E. Rosenberg is a professor at Utah State University. He started the reproducible results program with David Watkins (Michigan Technological University), Jim Stagge (Ohio State University), Adel Abdallah (Western States Water Council), Amber Spackman Jones (Utah State University), Yves Filon (Queen’s University), Rebecca Teasley (University of Minnesota Duluth), Samuel Sandoval-Solis (University of California, Davis), Anthony Castronova (CUAHSI), and Avi Ostfeld (Technion—Israel Institute of Technology) to increase the number of persons who can access, use, and extend work published in an ASCE journal.

Talk is June 7, 2022, 9 am at Environmental Water Resources Institute World Congress, Atlanta, GA. https://www.ewricongress.org/

This resource contains the powerpoint presentation for the talk and the MS Word version of the abstract.

Show More
Resource Resource

ABSTRACT:

Quick links:
+ Sign up to help reproduce results (learn by do): https://tinyurl.com/ReproduceResults
+ Reproduce pledge: https://tinyurl.com/ReproducePledge

We believe that reproducing results accelerates our science and engineering and increases the number of people who can access, learn by doing, and extend research. To accelerate our fields and increase impact, we partnered with the Environmental Water Resources Institute (EWRI), American Society of Civil Engineering (ASCE) Publishing, and the Journal of Water Resources Planning and Management. We launched a new program where authors opted in, shared all research materials in a public repository, then asked the Journal to use materials to independently reproduce all figures, tables, and results. One year in, we published the first papers with reproduced results free open access to the authors (Journal special collection on articles with reproducible results). The papers were also published with bronze and silver badges because they shared all materials in a public repository and the Journal reproduced results. We also recognized outstanding author and reviewer efforts to make results reproducible and reproduce results. Want to publish a paper with more impact, learn by doing, or expand the program to a new journal? Attend this plenary talk.

Bio - David E. Rosenberg is a professor at Utah State University. He started the reproducible results program with David Watkins (Michigan Technological University), Jim Stagge (Ohio State University), Adel Abdallah (Western States Water Council), Amber Spackman Jones (Utah State University), Yves Filon (Queen’s University), Rebecca Teasley (University of Minnesota Duluth), Samuel Sandoval-Solis (University of California, Davis), Anthony Castronova (CUAHSI), and Avi Ostfeld (Technion—Israel Institute of Technology) to increase the number of persons who can access, use, and extend work published in an ASCE journal.

Talk is June 7, 2022, 9 am at Environmental Water Resources Institute World Congress, Atlanta, GA. https://www.ewricongress.org/

This resource contains the powerpoint presentation for the talk and the MS Word version of the abstract.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsUseGoogleSheetsZoomToDiscussMoreAdaptiveColoradoRiverOperations.docx. Write up for publication as a journal article. Cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsUseGoogleSheetsZoomToDiscussMoreAdaptiveColoradoRiverOperations.docx. Write up for publication as a journal article. Cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Resource Resource

ABSTRACT:

Existing models fail to represent future drought-like hydrologic inflow conditions in the Upper Colorado River Basin (UCRB) based on intensifying basin aridification. Hence, this study uses the Colorado River Simulation System (CRSS) model to investigate the effects of intensifying drought and changes in conservation and consumption of the UCRB on Lake Powell storage. The study also investigated the impact of linking Lake Powell’s outflow to UCRB’s hydrology using a new rule. The intensifying drought-like conditions in the URCB were simulated using the natural inflow data taken during the (2000 - 2018) drought period. The data was decreased by 20%, 35%, and 50%, respectively, portraying future intensifying drought responses to climate change. Changes in demand scenarios were simulated by changing the amounts of flow diverted from Lake Powell (increased consumption) and to Lake Powell (increased conservation). Model results were also utilized to predict the amount of time until Lake Powell storage levels reach the power pool elevation of 3490 feet. The results clearly show that under the 2016 Upper and Lower Basins Demands, the intensifying drought would greatly decrease Lake Powell storage and shorten the time until storage levels drop below the power pool elevation of 3490 feet. Additionally, having the outflow linked to the basin’s hydrology would save storage from reaching alarming levels. Saving some water as low as 5 % would stabilize the elevation. The CRSS outcomes also showed that increasing consumption in the UCRB would reduce the amount of storage in Lake Powell, whereas increasing conservation would increase the storage of Lake Powell.

See readme file for instructions on how to use this resource.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use a Google Sheet to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsRealTimeOnlineModelingToDiscussMoreAdaptableReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use an interactive, online spreadsheet (Google Sheet) to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsRealTimeOnlineModelingToDiscussMoreAdaptableReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use an interactive, online spreadsheet (Google Sheet) to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsRealTimeModelAdaptiveReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Resource Resource

ABSTRACT:

This resource contains raw data collected for the project "Increasing the Water Conservation Impact of Utah State University’s (USU) Extension Water Check Program with 5 Second Metering" (https://uwrl.usu.edu/water-check-study). The data is for ~ 78 households in Logan and Hyde Park, Utah collected in Summer and Fall 2022. 5-second water use data was collected over the entire period using a Flume Smart Home Water Monitoring Device. After ~ two weeks, a USU Extension Water Check was conducted during a site visit. There are 6 data sets in this resource. Data are anonymized and can be linked -- joined -- by the SiteID field.

1_Database_CSVFiles/
1) FlumePropertyData.csv => Metadata for the households collected by Flume when a device is installed and the Flume phone App was installed.
2) Sites.csv => Metadata for the households including city, state, and zipcode.
3) WaterCheckData.csv => Parcel, landscape, and irrigation system data collected as part of the USU Extension Water Check during a 1-hour visit to the household. Data also include Water Check recommendations to reduce irrigation water use.
4) RawWaterUseData/SITE_XXX.csv => Raw 5-second water use data collected by Flume Smart Home Water Monitoring Devices (http:/FlumeWater.com). One file for each household/SiteID. XXX is the SiteID.
5) daily_WeatherData_GVFarm.csv => Weather data from the nearest station - Greenville Farm, Cache Valley, Utah.
6) TrainingData.csv => Irrigation events identified by duration (minutes), volume_gal (gallons), average_fr_GPM (gallons per minute), label (type of event). These data are used to train a model that uses the raw 5-second data to classify irrigation events.
The code to classify the raw 5-second water use data is in a separate code repository - https://github.com/cjbas22/HelpUSUExtensionP.

2_AdditionalData => Folder with duplicate copies of the weather station and training data.

3_Database => Empty folder. Code in the repository https://github.com/cjbas22/HelpUSUExtensionP reads the raw csv files and creates a database with tables for each data file.

Show More
Resource Resource

ABSTRACT:

Steady low reservoir releases allow downstream aquatic invertebrates (bugs) to lay and hatch eggs and increase production. These releases also reduce revenue from hydropeaking operations, increase costs to hydropower customers, reduce funds to maintain project infrastructure, repay project loans, and exacerbate hydropower production-ecosystem conflicts. This paper has the purpose to (1) quantify tradeoffs between the number of days of bug flows and hydropower revenue, (2) identify ways to reduce costs to hydropower customers, and (3) inform the design of a financial instrument to increase bug production, compensate hydropower customers for costs, and reduce conflict. A linear program identified tradeoffs between hydropower revenue and number of days of steady low releases per month for different contract and market energy prices and monthly release volumes across March to October months when bugs are most productive. We found that bug flows on 8 weekend days per summer month in 2018 from Glen Canyon Dam, Arizona reduced hydropower revenue by $300,000 (June) to $600,000 (August). Shifting bug flow days to Spring/Fall months reduced costs. To reduce conflict, we suggest to create a new financial instrument funded by the Federal Treasury for ~$300,000 to $600,000 per month. The instrument can give ecosystem managers more flexibility to choose days for steady low releases that advantage bugs and pay hydropower producers for costs. Next steps are to engage Federal agencies on benefits and limitations of the proposed instrument and expand to steady high releases that mobilize sediment, build sandbars, and disadvantage non-native, invasive fish populations.

This resource contains the following items:

+ README.md - Markdown file with documentation for this resource including directions to reproduce results in the manuscript
+ GCD_BugFlowExperiment-main - Folder with sub-folders that contain the data, models, and code to reproduce figures, tables, and results in the manuscript
+ RindRosenberg-BugsPayForDaysOfSteadyReservoirReleases.docx -- Word document with manuscript for work.
+ Rosenberg-BugsPayForSteadyFlows-AprilAMP.pptx - Power point presentation with overview of work presented at April 12/13, 2023 meeting of the Technical Work Group (TWG) of Glen Canyon Dam Adaptive Management Program (GCD-AMP).
+ KeyFeedbackFromTechnicalWorkGroup-April12-2023.docx - Key feedback from presentation to GCD-AMP Technical Work Group on April 12, 2023.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke participants to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Participants use an interactive, online spreadsheet (Google Sheet) to consume, save, and trade water in 6 basin accounts, protect Lake Powell and Lake Mead, sustain endangered, native fish of the Grand Canyon, and discuss. Follow the requirements and facilitation directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsInteractImmerseAdaptReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.

Show More
Collection Collection

ABSTRACT:

This collection shares pre-prints of videos with tips, how-to, lessons, and other content to help researchers make their results more reproducible. Authors create a new Hydroshare resource that includes meta data and the video file. Authors request the Collection Owners add their resource to this collection. Then authors submit a short brief in the Editorial Manager system of the American Society of Civil Engineers (ASCE) Journal of Water Resources Planning and Management (https://ascelibrary.org/journal/jwrmd5) for publication. The brief includes a one-sentence citation to the Hydroshare resource containing the video content. The video undergoes a peer-review process. On acceptance, ASCE Publishing will attach branding to the video. The content will receive a digital object identifier (DOI) and be published in the Journal -- same as regular articles, case studies, etc. ASCE will also push videos out on their video and social media feeds.

The intent of collection of videos and the review process is to make peer-reviewed videos findable, accessible, interoperable, and repeatable (FAIR). This process also provides authors of reproducibility content an incentive to create and share new videos and content -- a peer-reviewed publication in the Journal of Water Resources Planning and Management.

Show More
Resource Resource

ABSTRACT:

Video #2 in the Research Reproducibility series for the Journal of Water Resources Planning and Management (JWRPM). This video is titled "How to Submit my Reproducible Research?" and describes the process by which authors can opt in to JWRPM's Reproducibility Review program and how they can prepare their manuscript to be successful in this reproducibility review.

Show More
Resource Resource

ABSTRACT:

The purpose of this activity is to provoke collaborators to discuss more adaptive Colorado River operations than existing operations that equalize reservoirs and expire in 2026. Collaborators use web spreadsheets (Google Sheets) during a video conference session. In a model session, up to 6 collaborators immerse in water user roles. Then in each time step, collaborators consume, conserve, and trade water in response to their available water, others choices, and real-time discussion of choices. Collaborators also protect critical levels in Lake Powell and Lake Mead and sustain endangered, native fish of the Grand Canyon. Follow the requirements and start directions in the readme.md file.

CONTENTS:
1) readme.md - Requirements, facilitation directions, publications, file contents, and more.
2) Basin Water Accounts Tool - ColoradoRiverBasinAccounts.xlsx. Move into Google Sheets and follow Facilitation Directions (in readme.md). Or open ReadMe-Directions Worksheet.
3) Lets Start - ColoradoRiverBasinAccounts-LetsStart.pdf. Visual directions.
4) Model Guide - https://github.com/dzeke/ColoradoRiverCoding/blob/main/ModelMusings/Support/ModelGuide/ModelGuide-CombinedLakePowellLakeMead.md. Online.
5) Manuscript - 3-LessonsInteractImmerseAdaptReservoirOperations.docx. Write up for publication as a journal article. Earlier cite-able version at https://digitalcommons.usu.edu/cee_facpub/3778/.
6) 1-Page Summary - ColoradoRiverBasinWaterAccounts-1PageSummary-v2.pdf.

Please access the final peer-reviewed, published version of the manuscript at:
+ Rosenberg, D. E. (2024). "Lessons from immersive online collaborative modeling to discuss more adaptive reservoir operations." Journal of Water Resources Planning and Management, 150(7). https://doi.org/10.1061/JWRMD5.WRENG-5893.

Show More