spreadsheets and templates in Excel & Google Sheets. Calculation – includes construction cost schedule, profit forecast, depreciation, debt schedule, waterfall
## Most Viewed Posts. # SMALL HYDRO POWER DESIGNER v1.1. SMALL HYDRO POWER DESIGNER V1.1 is an excel workbook equipped with useful design tools for feasibility level analyses / designs of high and medium head hydropower projects (upto 15 MW). However, the user can modify the workbook to include additional modules suited for larger projects. SHPD can assist in quickly producing layout alternatives, making reasonable cost estimates / cost comparisons for these alternatives and preparing concrete outline drawings of major structures using AutoCAD. SHPD is a freeware intended for engineering students as well as practising hydropower engineers. A user interface is also provided for assisstance of new users. The workbook and interface both have been created using Excel 2007 Professional Plus (vista) and are ensured to work correctly only for the same version. Typical layout of small hydro components adopted in SHPD is like this;. ### Related posts:. ### Civil Engineering Spreadsheets. Copyright © 2026 The Engineering Community | The Engineering Community.
This document describes using Microsoft Excel to simulate the performance of a 350 MW steam power plant. Key points: 1) Excel add-ins are used to calculate
This course provides Excel spread sheets to calculate a range of basic power cycle parameters. All variables can be adjusted to optimize design goals.
... table. Example Case: Small Hydro-power Plant Investments: € 500 000 Amortization time: 40 years Generating power: 375 kW Electricity price
Engineering ToolBox - Resources, Tools and Basic Information for Engineering and Design of Technical Applications! ## Power potential vs. ### Online Hydro-power Calculator. The calculator below can be used to calculate available hydroelectricity power. The theoretically power available from falling water can be expressed as. *Pth = ρ q g h (1)*. *ρ = density (kg/m3) (~ 1000 kg/m3 for water)*. *q = water flow (m3/s)*. Download and print Hydro Power vs. The theoretically power available from a flow of *1 m3/s* water with a fall of *100 m* can be calculated as. *P = (1000 kg/m3) (1 m3/s) (9.81 m/s2) (100 m)*. Due to energy loss the practically available power will be less than the theoretically power. Practically available power can be expressed as. ### Energy from Hydro-power. The potential theoretical energy in a volume of elevated water can be calculated. *V = volume of water (m3)*. The potential energy in the water volume can be calculated as.
This simple spreadsheet model estimates either the flow rate required to produce a specified level of power output, or the power output that can be produced from a specified flow rate. The User defined temperatures for both the resource and the heat sink are used to calculate the geothermal fluid's available energy; this is the maximum power that could be produced by an ideal power cycle. The 2nd law efficiency is the fraction of that available energy that a power cycle is able to convert to electrical power (net, excluding the geothermal pumping power). This value and the either the User defined flow rate or the User defined Power (assumed to be power sales) is used to calculate either Power Sales or Flow rate required. **Do you want to estimate the flow rate required or the power output****Power Output**either the flow required to produce a defined level of output, or the power produced from a defined flow rate.
Page 10.602.3 “Proceedings of the 2005 American Society for Engineering Education Annual Conference & Exposition Copyright © 2005, American Society for Engineering Education” Project Analysis Cadets were arranged in teams of two, and each team was tasked with analyzing the plant at the baseline (prescribed) conditions using an Excel™ spreadsheet template provided by the instructor—whenever thermophysical properties were required, the Thermal Fluids Toolbox was to be utilized, so that no manual data retrieval was required. Page 10.602.6 “Proceedings of the 2005 American Society for Engineering Education Annual Conference & Exposition Copyright © 2005, American Society for Engineering Education” Conclusion Incorporation of the Thermal Fluids Toolbox add-in to Excel™ allows students to focus on the more important aspects of a design, rather than becoming mired in the minutiae of property “look-ups.” With the proper introduction and orientation to the Toolbox, cadets can gain familiarity and confidence in its use, which will ultimately facilitate their understanding of the functioning of the thermal system(s) under consideration.