I want to create a tool in Excel that can use to calculate the pump input horsepower required to move cylinders 1 and 2 against a specified force at a specified velocity for both extension and retraction. The user should be able to input geometry characteristics for all components. Take losses in the pipes and in the fittings into account. You may want to look at problem 9-33 in the text to see the sorts of values you can use for testing.154326Cylinder 1Cylinder 2
The user should be able to INPUT the following, be sure to take note of the units:•Cylinder 1 force (lbs), Cylinder 2 force (lbs), and Cylinder 1 piston speed (in/sec)•Specific gravity (unitless) and viscosity (cS) of the fluid•Piston and rod diameter (inch) for each Cylinder, they are not necessarily the same•K factors for the elbows, check valve, and DCV•Diameter to be used for the DCV (in), it doesn’t necessarily have to match connecting pipes•Diameter (in) and pipe length (ft) for each of the pipes shown, designated by a circle with a number•Overall pump efficiency•Note, in each case where a 90°turn is shown in the diagram, assume an elbow•Assume that the PRV is set high enough so that the pressure increase from the pump determines the maximum force that can be moved.
The spreadsheet should OUTPUT the following, be sure to take note of the units:•Horsepower required to be provided to the pump in extension and retraction•Cylinder 2 piston speed (in/sec) in extension and in retraction•Overall efficiency of the system for extension and retraction •Output power is the power from the cylinders, F*v•Note that F*v will give you lb-in/sec while the pump power will be in hp. You will need some unit [login to view URL] project will be graded on the following:•The instructions must be clear so that any user will know what is being calculated, where the inputs go, and where the answer is located. If there is a restriction on possible inputs, that should be included. The input and output units should be clearly indicated.•The answers need to be correct for all cases attempted. The instructor will use physical values.•The tool should be nicely formatted and professional. This should include the use of colors, borders, justification, and fonts/bolding/italicization.
19 pekerja bebas membida secara purata $145 untuk pekerjaan ini
Hi, Im a Mechanical Engineer and expert in Fluid Mechanics. I can provide a quality work with all related tools and calculations. Let the professionals deal with this. Thanks
Hi there. I am a mechanical engineer and I went through your description and i am ready to start this project. We can discuss anytime about this project. I will do my level best for you as you wish. Thank you.
Hi. I am a mechanical engineer who has many experiences in fluid machinary. I can provide perfect results according to your proposal. Please open chat window and send me details. Thanks.