English English.   Español  Español.

The application of Appropriate Technology

Articles for Keyword "spreadsheet"

Natural Flow Calculator Spreadsheet

Posted on Oct 25, 2011

This spreadsheet allows the user to calculate the natural flow rate (LPS) of any combination of up to 4 pipes of different diameters (in) for given pipe lengths (m) and known head (m). Microsoft Excel Spreadsheet (165KB) *** Note: this spreadsheet contains macros, and you may get a security warning.

Read More

Pump Calculator Spreadsheet

Posted on Oct 25, 2011

This spreadsheet allows the user to find the pump power requirement (Watts or Brake Horse Power) for various feeder pipe diameters (in) and given a known flow rate (LPS), pipe length (m) and head (m) and then select a suitable pump based upon available pump characteristic data. Microsoft Excel (192KB)

Read More

Rain Water Harvesting Spreadsheet

Posted on Oct 25, 2011

This spreadsheet allows the user to size a DRWH storage tank, with a given surface catchment area (m2), and daily demand (litres). The spreadsheet contains rainfall data for Chiapas, Mexico, but this can be easily substituted for rainfall data in any given location. Microsoft Excel Spreadsheet (137KB)

Read More

Reservoir Tank Sizing Spreadsheet

Posted on Oct 25, 2011

This spreadsheet allows the user to calculate the required volume of a reservoir tank (Litres) based upon the overall daily demand of a community (Litres) and the flow rate into the tank (LPS). It also allows the user to calculate the material requirements (sand, gravel, cement etc) for the construction of a circular, curved roof ferro-cement reservoir tank given a known capacity (Litres) and tank wall height (m). Microsoft Excel...

Read More

Solar Pump Calculation Sheet

Posted on Oct 25, 2011

PDF calculation sheet for designing solar pumping systems. Download this sheet as a PDF file (92 kb)

Read More