Hydraulic restrictor/flow/pressure calculator for Excel 1

hydroman247 · Oct 29, 2012

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

Oldhydroman · Oct 29, 2012

Try this.

You put in the diameter and the pressure drop and it gives you the flow rate. Use the "goal seek" function to make it work in the other direction.

DOL

hydroman247 · Nov 1, 2012

Thanks. I did find the sheet I was looking for. I have attached the sheet I made with various useful calculators.

Password for unlocking sheets is "12345"

kcj · Nov 1, 2012

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

hydroman247 · Nov 1, 2012

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

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

Oldhydroman · Nov 1, 2012

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

hydroman246...
Nice spreadsheet viscosity calculator ;-)

hydroman247 · Nov 2, 2012

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.

kcj · Nov 2, 2012

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

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Hydraulic restrictor/flow/pressure calculator for Excel 1

hydroman247

Mechanical

Oldhydroman

Mechanical

hydroman247

Mechanical

kcj

Mechanical

hydroman247

Mechanical

Oldhydroman

Mechanical

hydroman247

Mechanical

kcj

Mechanical

Similar threads

Part and Inventory Search

Sponsor