APPENDIX A – Non-uniform Spatial Grid
Surge Analysis and the Wave Plan Method
Supplementary Material: Example Problems and Solutions
Appendix A – Problem 8
A.8 Setup an Excel spreadsheet that computes results (specifically ∆HT, ∆HR, and H4) to track a pressure wave generated at the end of a long pipe divided into smaller sections shown in Tables A.1 through A.4. The input variables for the spreadsheet should be the total length of pipe, number pipe sections, flowrate before the wave action (Qx), and pipe frictional characteristics to determine the initial pressure conditions, initial pressure heads at the ends of the pipe sections, and the magnitude of the pressure wave approaching from one end of pipeline. You may want to refer to Figures 1.25 and 1.26, and Eqs. 1.42, 1.43, 1.44, 1.48 through 1.64 for this task. You should be able to use a quadratic equation solver, if the exponent “a” in Eqs. 1.57 and 1.64 is 2. If the exponent “a” is not 2, you should be able to force it to 2 using the equivalent resistance method Eq. 1.44.
Summary of revisions to this page:
Date/Revision
