kuraki
Fimbulvetr Knifeworks
- Joined
- Jun 17, 2016
- Messages
- 4,679
You may find this handy. A while back I had a project for work that had me running hydraulic output and HP requirement calculations repeatedly, so I built this simple Excel spreadsheet to do it for me.
Essentially, the yellow boxes are results, the white boxes are fields you enter data into.
The first section will tell you how many GPM (output of pump you need) to move a cylinder of a particular size, a particular distance, in an amount of time. For example, enter the cylinder area (for a 5" cylinder, pie * 2.5^2=61.86), enter the distance you want your ram to travel in inches( 1" ) and the amount of time you want it to travel that distance ( 1 sec ) and get your result: 16.0368 GPM required.
The second section will tell you how much HP you need to make a given pressure, for a given GPM output. The GPM will autofill your result from the first block. So if you want to get 16.0368 GPM at 2500 PSI, you'll require 23.39 HP. (Understand this is a constant HP equation - moving 16 GPM at 2500 PSI requires that high HP. When your ram connects with your work and pressure builds, the ram will slow down from the calculated 1" per second speed if you don't have 24 hp driving your pump. For most of us this is OK. A more practical way to use this equation would be to use a lower system PSI than peak capability of your pump.)
The third block will tell you how many tons a particular ram will make in a push/pull situation. Enter the dimensions of your ram, and the pressure your pump is capable of making. In this case we're looking at a 5" cylinder with a 1.25" shaft at 2500psi - this will push 24.5 tons, or pull 23 tons.
The fourth block will simply calculate how much hydraulic fluid in gallons your cylinder will consume at full stroke.
The 5th block will do circular area calculations for you.
Hope this is useful for someone!
You can download the excel file from my google drive using this link (you either need Microsoft Office Excel or free Open Office "Calc"): https://drive.google.com/file/d/0B1q0edBhnQ3FRTJtSWptZlJSZE0/view?usp=sharing
Essentially, the yellow boxes are results, the white boxes are fields you enter data into.
The first section will tell you how many GPM (output of pump you need) to move a cylinder of a particular size, a particular distance, in an amount of time. For example, enter the cylinder area (for a 5" cylinder, pie * 2.5^2=61.86), enter the distance you want your ram to travel in inches( 1" ) and the amount of time you want it to travel that distance ( 1 sec ) and get your result: 16.0368 GPM required.
The second section will tell you how much HP you need to make a given pressure, for a given GPM output. The GPM will autofill your result from the first block. So if you want to get 16.0368 GPM at 2500 PSI, you'll require 23.39 HP. (Understand this is a constant HP equation - moving 16 GPM at 2500 PSI requires that high HP. When your ram connects with your work and pressure builds, the ram will slow down from the calculated 1" per second speed if you don't have 24 hp driving your pump. For most of us this is OK. A more practical way to use this equation would be to use a lower system PSI than peak capability of your pump.)
The third block will tell you how many tons a particular ram will make in a push/pull situation. Enter the dimensions of your ram, and the pressure your pump is capable of making. In this case we're looking at a 5" cylinder with a 1.25" shaft at 2500psi - this will push 24.5 tons, or pull 23 tons.
The fourth block will simply calculate how much hydraulic fluid in gallons your cylinder will consume at full stroke.
The 5th block will do circular area calculations for you.
Hope this is useful for someone!
You can download the excel file from my google drive using this link (you either need Microsoft Office Excel or free Open Office "Calc"): https://drive.google.com/file/d/0B1q0edBhnQ3FRTJtSWptZlJSZE0/view?usp=sharing
