×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Hydraulic restrictor/flow/pressure calculator for Excel

Hydraulic restrictor/flow/pressure calculator for Excel

Hydraulic restrictor/flow/pressure calculator for Excel

(OP)
I have an Excel sheet for various calculations with cylinder volume and flow calculators and HP and Torque calcs for engine power etc.

I am looking for one with 3 entries. Flow, Pressure and restrictor size. I saw one with 3 columns. Each column you would be able to change 2 of the inputs to give the output. E.g. flow 40l/min and pressure 200bar would yield what restrictor was being used or needed to be used for the desired flow and pressure.

If anyone could point me in the right direction or the formula used, that would be great.

Thanks

RE: Hydraulic restrictor/flow/pressure calculator for Excel

Password for unlocking sheets is "12345"



"That sounds like what some idiot would use on his luggage."

Extra points to who can give the source and exact quote

kcj

RE: Hydraulic restrictor/flow/pressure calculator for Excel

(OP)
Spaceballs.............

It isn't for security, it is so I don't change anything I don't mean to by accident.

RE: Hydraulic restrictor/flow/pressure calculator for Excel

kcj...
Was it your father's brother's nephew's cousin's former roommate that siad that?

hydroman246...
Nice spreadsheet viscosity calculator winky smile

RE: Hydraulic restrictor/flow/pressure calculator for Excel

(OP)
I didn't actually create any of the complicated calculators. I just put them all in one workbook. The formula in the viscosity one is pretty crazy. I only made the basic volume/flow and speed ones.

=IF(B6<B4+10,"Wax!",IF(B6>=B5,"Fire!",10^(10^((LOG10(LOG10(B2+0.8))+(13.13*(LOG10(LOG10(B2+0.8)/LOG10(B3+0.8))))*LOG10(313))-(13.13*(LOG10(LOG10(B2+0.8)/LOG10(B3+0.8))))*LOG10(B6 +273)))-0.8))

I like the wax and fire messages though.

RE: Hydraulic restrictor/flow/pressure calculator for Excel

Spaceballs.............

yup. Mel Brooks. Fits my satirical (or warped) sense of humor

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

White Paper - Design for Additive Manufacturing
With a growing number of parts manufactured directly by additive manufacturing techniques, it is important to lay down design principles suitable for such manufacturing processes and to ensure parts are designed for additive manufacturing. There are several factors that are to be considered at the design stage. Few such design issues in additive manufacturing are discussed in this paper. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close