Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Design Example: Analyzing Capacity Contours for Flood Risk Assessment01:17

Design Example: Analyzing Capacity Contours for Flood Risk Assessment

278
Flood risk assessment involves careful planning and analysis to ensure the safety of communities near water retention structures. Capacity contours are a vital tool in this process, as they illustrate the potential spread of water at specific levels in a given area. In the context of building a bund across a small valley, these contours play a critical role in evaluating the safety of nearby residential areas.In this example, the bund is intended to store stormwater in the valley. The engineers...
278
Simpson's Rule II01:28

Simpson's Rule II

41
In warehouse roofing applications, corrugated or curved metal sheets are commonly used to improve structural strength, water drainage, and ventilation efficiency. To accurately estimate material requirements and optimize design parameters, engineers must determine the curved surface area of these sheets. Because the sheet profiles often repeat smoothly along their length, they can be effectively approximated by parabolic curves, enabling the use of numerical integration techniques for area...
41
Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

1.5K
Regression analysis in Microsoft Excel is a powerful statistical method for examining the relationship between a dependent variable and one or more independent variables. It's used extensively in fields such as economics, biology, and business to predict outcomes, understand relationships, and make data-driven decisions. The most common type is linear regression, which attempts to fit a straight line through the data points to model the relationship between variables.
To perform regression...
1.5K
Precipitation Processes01:12

Precipitation Processes

4.7K
The experimental conditions in a gravimetric analysis should be optimized to maximize the particle size and purity of the obtained precipitate. Ideally, the concentration of the precipitating reagent should be low with effective stirring to maintain low relative supersaturation for the growth of large crystals. In homogeneous precipitation, the precipitant is slowly generated by a chemical reaction in the solution to avoid local reagent excesses. For example, urea decomposes gradually to...
4.7K
Precipitation and Co-precipitation01:17

Precipitation and Co-precipitation

4.0K
Precipitation and coprecipitation methods can be used to separate a mixture of ions in a solution. In qualitative inorganic analysis, ions that form sparingly soluble precipitates with the same reagent are separated based on the differences in solubility products. For example, consider the separation of Cu(II) and Fe(II) ions by precipitation as insoluble sulfides. First, copper(II) sulfide is precipitated by the addition of acidic H2S, where the dissociation of H2S is suppressed. Adding H2S...
4.0K
Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

1.4K
Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and...
1.4K
  1. Home
  3. Research Domains
  5. Built Environment And Design
  7. Urban And Regional Planning
  9. Urban Informatics
  11. An Excel-based Tool To Support Decisions On The Selection Of Outflow Devices For Blue Roofs Using Historical Maximum Rain Events

An excel-based tool to support decisions on the selection of outflow devices for blue roofs using historical maximum rain events

Camillo Bosco1, Stian Bruaset2, Elhadi Abdalla3

  • 1Department of Infrastructure, SINTEF Community, Trondheim, Norway

Water Science and Technology : a Journal of the International Association on Water Pollution Research
|October 31, 2025

Related Experiment Videos

Watershed Planning within a Quantitative Scenario Analysis Framework
12:44

Watershed Planning within a Quantitative Scenario Analysis Framework

Published on: July 24, 2016

8.4K
Design and Optimization Strategies of a High-Performance Vented Box
14:23

Design and Optimization Strategies of a High-Performance Vented Box

Published on: June 9, 2023

1.5K
Parameterizing V-notch Weir Equations for Flow Monitoring in a Drainage Control Structure
07:15

Parameterizing V-notch Weir Equations for Flow Monitoring in a Drainage Control Structure

Published on: April 25, 2025

946

View abstract on PubMed

Summary
This summary is machine-generated.

An Excel tool aids urban stormwater management by simulating blue roof outflow devices for flood risk reduction. It helps select appropriate devices for various rainfall scenarios, improving design and communication in construction.

Area of Science:

  • Urban Hydrology
  • Environmental Engineering
  • Sustainable Infrastructure

Background:

  • Distributed infrastructure, like green and blue roofs, is crucial for urban stormwater management.
  • Climate change exacerbates storm events, challenging traditional centralized systems.
  • Effective design of these systems requires careful selection of design hyetographs and outflow devices.

Purpose of the Study:

  • To develop an Excel-based tool for simulating and selecting outflow devices for multiple blue roofs in decentralized stormwater systems.
  • To enable optimal selection of outflow devices that comply with maximum water levels and flow rates.
  • To support construction sector operators in improving design practices and customer communication.

Main Methods:

  • Development of an Excel-based simulation tool for blue roof outflow dynamics.
Keywords:
Excel toolblue roofsdecision support systemdistributed stormwater management

Related Experiment Videos

Watershed Planning within a Quantitative Scenario Analysis Framework
12:44

Watershed Planning within a Quantitative Scenario Analysis Framework

Published on: July 24, 2016

8.4K
Design and Optimization Strategies of a High-Performance Vented Box
14:23

Design and Optimization Strategies of a High-Performance Vented Box

Published on: June 9, 2023

1.5K
Parameterizing V-notch Weir Equations for Flow Monitoring in a Drainage Control Structure
07:15

Parameterizing V-notch Weir Equations for Flow Monitoring in a Drainage Control Structure

Published on: April 25, 2025

946
  • Analysis of water storage and release characteristics under various rainfall durations.
  • Application of the tool in a design case study in Norway.

    • Main Results:

    • The tool successfully simulates outflow device performance for different rainfall durations.
    • It identifies suitable outflow devices meeting specific performance requirements.
    • A Norwegian case study demonstrated practical application and benefits for design and communication.

    Conclusions:

    • The developed tool enhances the design process for decentralized stormwater systems utilizing blue roofs.
    • It provides a practical solution for selecting appropriate outflow devices, mitigating flood risks.
    • Future work may incorporate green roofs, diverse datasets, and climate change scenarios for broader applicability.
    urban flood mitigation