6 replies to this topic

[Arbaaz Shaikh]

Hello everyone,

 

I wanted to know wheather my sheet is properly designed and if there are some errors. I started my career earlier this year as a process engineer, it would be great help to know flaws so I could understand them. 

Edited by Arbaaz Shaikh, 21 August 2020 - 02:48 PM.

[Arbaaz Shaikh]

My apologies for a second reply as the attachment wasn't processed.

Attached Files

•  Pipe Pressure Drop - Incompressible Flow.xlsx   1.3MB   68 downloads

[Chemitofreak]

There are some line hydraulics sheets on this site, refer the below link:

 

http://www.cheresour...l-spreadsheets/

 

Cross check your results with the same

[Bobby Strain]

There must be thousand of these already. Why do you want another? And the numbers look a bit strange. You will quickly learn that nobody is willing to check work. You must not be very busy if you have time for such activities as this.

 

Bobby

[latexman]

And stay off my grass!  Right, Bobby?

 

Arbaaz,

 

It looks good, but Bobby is right on one thing,  I'm not going to check it.  It looked crazy because when I opened it it was saved for 1/2" pipe for a relatively huge flow rate.  Pipe in that service, if it was possible, would see erosion corrosion at the rate of furlongs/fortnight.  Anyway, many, many years ago a friend and associate Engineer gave me a spreadsheet he made called Pdrop, and he asked me to check it out..  It did about the same as yours.  I checked every cell until I understood it and verified it's accuracy.  About a year later, I took his Pdrop and made Power Law Pdrop because I work with white, sticky stuff, i.e. latex.  Then my friend made PumpCalc, which had 4 worksheets of Pdrop (two suction lines and two discharge lines) and a worksheet that did NPSH and pump calculations..  I took PumpCalc and made Power Law PumpCalc.  30 years later and my friend and I are still using all these spreadsheets, plus they have been incorporated into many other calculations, like piping networks, relief documentation, etc.

 

My advice is let a friend and associate Engineer at about your same level check it out.  One that will honestly check it, and challenge and progress it's development.  If you don't have such a friend like that, then getting one is a higher priority than checking your spreadsheet, IMHO.

 

Also, I'd recommend compressing the information so when printed, everything for the one line fits on one sheet of A4 and 8.5" x 11" paper.  Your's takes up multiple pages.  Pdrop and it's successors take 1 page per pipe line.

Edited by latexman, 23 August 2020 - 09:25 AM.

[breizh]

Hi,

let you consider this resource to support your work .

https://checalc.com/fluid_flow.html

 

To get some credit , use meaningful examples .

 

Good luck

Breizh 

Edited by breizh, 25 August 2020 - 01:07 AM.

[DB Shah]

Hi Arbaaz,

Nicely compiled. 

Yes, very high flow wrt 0.5 in line size and hence velocity  affirms your recent entry into the professional world.

 

There are many online calculators available on net, you will need to validate your results yourself.

 

As pointed out by latexman, try to make it printer friendly. Avoid merging cells. Round off the calculated values to a meaningful figure and easy on eyes.

 

Over all a very well made worksheet.