BioResource and Agricultural Engineering Department
BS in BioResource and Agricultural Engineering
Daniel J. Howes
This senior project report lays out the production of drip hydraulics software composed in Microsoft Excel and backed by coding in Visual Basic for Applications. The program performs 2 main functions useful in the design of irrigation systems. The first is based on performing single hose computations under three different circumstances. It can solve for the average emitter flow rate given the hose inlet pressure, the inlet pressure given the average emitter flow rate, and can model hose pressures and flow rates while flushing. The second function is to place a manifold in the hydraulically optimum location on a slope. One advantage of this software over its former DOS version is the designer has access to all of the data used in the calculations including the entire Bernoulli tables that model flows and pressures at every emitter in the field. As this could also be a point of weakness, great effort was put into making the software simple to follow and displaying pertinent information in intuitive locations.