University | Australia's Global University (AGU) |
Subject | Water Resources Engineering |
CVEN3501: Water Resources Engineering Assignment, AGU, Singapore The objective of the assignment is to use the spreadsheet package Microsoft Excel to investigate
The objective of the assignment is to use the spreadsheet package Microsoft Excel to investigate the effect of changing boundary conditions on a simple rectangular isotropic and homogeneous confined aquifer, firstly without pumping and then including a groundwater pumping bore abstracting or injecting water. The assignment is based on the analysis of Frank and Reilly (1987).
You should set up a model for your unique aquifer. Figure 1 is an example and does not necessarily match your aquifer dimensions. Your aquifer has an area X m wide (AB and CD) by Y m long (BC and DA). Use a finite difference discretisation where ∆x = ∆y = 100 m. Your model will then be X’ nodes wide in the x‐direction along boundaries AB and CD and Y’ nodes long in the y-direction along boundaries BC and DA.
In the example, the aquifer is X = 800 m wide by Y = 1500 m long and ∆x = ∆y = 100 m. This model, therefore, has X’ = 9 nodes in the x‐direction (from node 0 to node 8 along boundaries AB and CD) and Y’ = 16 nodes in the y‐direction (from node 0 to node 15 along boundaries BC and DA). See Figure 1.
Each student will have a unique set of data for the transmissivity, Pumping rate, initial head conditions (h [m]), and an x‐y coordinate pair representing the bore location. Find your data in the excel sheet on Moodle. Figure 1 shows how the bore location x‐y coordinate corresponds to a node in the numerical scheme.
For the spreadsheet to successfully iterate, circular references should be enabled. In Microsoft Excel 2010+ this is done under the menus: ”File” ‐ ”Options” ‐ ”Formulas”: Here you need to tick ”Enable iterative calculation”, set ”Maximum iterations” to 30,000, and ”Maximum change” to 0.0001.
Model the following two sets of aquifer conditions:
Model 1: The problem domain (aquifer) is surrounded by Dirichlet (fixed head) boundary conditions. Use a linear decrease in the head from hm to 0 m along with BC and AD, a fixed head of 0m along boundary CD, and a fixed head of h m along with boundary AB.
Model 2: The problem domain (aquifer) is surrounded by a mix of Dirichlet and Neumann (no flow) boundary conditions. Use a no‐flow boundary condition (with ∂h/∂x = 0) across BC and AD, a fixed head of 0 m along boundary CD, and a fixed head of h m along with boundary AB.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Excel in your Water Resources Engineering studies with expert assistance from our Homework Helper at Australia's Global University (AGU), Singapore! Whether you're working on individual assignments or your Final Year Project (FYP), our dedicated team is here to guide you through every step. Our Assignment Helper is well-versed in using Microsoft Excel to conduct in-depth investigations and analysis for CVEN3501: Water Resources Engineering. Don't let academic challenges hinder your progress – Singapore students can pay our experts to take help on their course and excel in their studies. Embrace academic success with our trusted online Homework Helper and assignment help services at AGU, Singapore
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT