kurayveth~
New Member
- Joined
- Apr 3, 2019
- Messages
- 1
Hi, i really need a help here asap by tomorrow. I would appreciate if someone could send me the VBA codes for this question i have as an assignment.
The criteria of the assignment is as below :
For this problem you will be provided with your own set of pump and system curves. You must therefore:
When putting together your code, you should keep the following points in mind:
The data is given as below
<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>
</tbody>
The criteria of the assignment is as below :
For this problem you will be provided with your own set of pump and system curves. You must therefore:
- Find suitable polynomial expressions for the system and pump curves
- Write a Newton Raphson function that returns the flowrate at the duty point
- Write a function for the Newton Raphson to solve – this may include the first derivative as well.
When putting together your code, you should keep the following points in mind:
- You will need at least 3 separate functions; the Newton Raphson function itself and the two others that return values of f(x) and f’(x)
- That you have a single function call that takes the specified coefficients of the pump and system curve, along with any other values you see fit.
The data is given as below
Flowrate | System head | Pump head |
m3/hr | m | m |
0 | 15.35 | 33.22 |
10 | 15.26 | 33.10 |
20 | 15.27 | 33.08 |
60 | 15.80 | 32.79 |
90 | 16.76 | 32.46 |
100 | 17.22 | 32.34 |
110 | 17.72 | 32.20 |
170 | 22.34 | 30.95 |
210 | 27.10 | 29.50 |
220 | 28.51 | 29.08 |
230 | 30.01 | 28.58 |
<colgroup><col width="70" span="3" style="width:53pt"> </colgroup><tbody>
</tbody>