Environmental Systems
Modelling Prompt: Spreadsheet Simulation
A spreadsheet integration will introduce the computational concept for simulations based on stocks and flows.
After completing this modelling prompt you should be able to explain the role of stocks and flows in temporal integration. In addition, you should become aware that model time steps matter.
Software you need for this modelling prompt:
After completing this modelling prompt you should be able to explain the role of stocks and flows in temporal integration. In addition, you should become aware that model time steps matter.
Software you need for this modelling prompt:
A bathtub, a faucet, a leak and a spreadsheet
In stock and flow models, the accumulation (or integration) over time takes place in the stocks. The change in stocks is a function of the incoming and outgoing flows.
Please compute the status of the systems explained below for each minute of their lifetime (i.e. 10 minutes or until equilibrium is reached). Use a set of equations which can be used for every time step (i.e. do not calculate 10l/min x 1 min etc.). You are already familiar with the systems from the Bathtub Quiz.
Setup 01: Constant inflow
Consider a simple system from daily life: a bathtub and a faucet.
The facts are these:
Setup 02: Constant inflow and constant outflow
We stay with the bathtub and the faucet but now the bathtub has a leak.
The facts are these:
Setup 03: Variable inflow and constant outflow
We stay with the bathtub, the faucet and the leak but now we vary the inflow.
The facts are these:
Setup 04: Constant inflow and volume dependent outflow
We stay with the bathtub, the faucet and the leak but now the leak shows a variable flux.
The facts are these:
Please compute the status of the systems explained below for each minute of their lifetime (i.e. 10 minutes or until equilibrium is reached). Use a set of equations which can be used for every time step (i.e. do not calculate 10l/min x 1 min etc.). You are already familiar with the systems from the Bathtub Quiz.
Setup 01: Constant inflow
Consider a simple system from daily life: a bathtub and a faucet.
The facts are these:
- At time 0, there is no water in the bathtub and the faucet is closed.
- The faucet is opened for 10 minutes (and shut afterwards). It has a constant flux of 10 l/min.
- The water from the faucet is running into the bathtub.
- The bathtub has no leak.
Setup 02: Constant inflow and constant outflow
We stay with the bathtub and the faucet but now the bathtub has a leak.
The facts are these:
- At time 0, there is no water in the bathtub and the faucet is closed.
- The faucet is opened for 10 minutes (and shut afterwards). It has a constant flux of 10 l/min.
- The water from the faucet is running into the bathtub.
- The bathtub has a leak with a constant flux of 5 l/min.
Setup 03: Variable inflow and constant outflow
We stay with the bathtub, the faucet and the leak but now we vary the inflow.
The facts are these:
- At time 0, there is no water in the bathtub and the faucet is closed.
- The water flux from its faucet can be regulated between 0 and 10 l/min.
- The bathtub has a leak with a constant flux of 5 l/min.
- The faucet (its water is running in the bathtub) is fully opened until the water level in the tub reaches 100 l. Afterwards, the inflow is adjusted to level the outflow.
Setup 04: Constant inflow and volume dependent outflow
We stay with the bathtub, the faucet and the leak but now the leak shows a variable flux.
The facts are these:
- At time 0, there is no water in the bathtub and the faucet is closed.
- The faucet is opened. It has a constant flux of 10 l/min.
- The water from the faucet is running into the bathtub.
- The bathtub has a leak with a water level depending flux of 0.5 times the water volume in the bathtub per min.