Hydraulic Cylinder Performance Estimator Donald M. Johnson AGME 2903 Fall 2000
Problem Description • Analyzing the performance of a linear hydraulic systems involves repetitive mathematical calculations. • This spreadsheet template was designed to: • Provide accurate results • Automate calculations • Be easy to use • Be usable by persons with limited knowledge of hydraulics
Input Data – User Specified • Cylinder bore (in.) • Cylinder stroke (in.) • Cylinder rod diameter (in.) • Maximum system working pressure (psi) • Pump flow rate (gpm @ max. pressure)
Output – Calculated by Formulas and Functions • Max. extension force (lbs.) • Max. retraction force (lbs.) • Extension time (sec.) • Retraction time (sec.) • Cycle time (sec) • Maximum power output (Fhp)
Layout Output Cells Hyperlink Drawing Input Cells Macro Buttons
Spreadsheet Template Demonstration • Click to open Hydcalc2 spreadsheet template.
Summary • This spreadsheet template meets the specified objectives: • Accurate • Automated • Easy-to-use • Requires little knowledge of hydraulics