Jump to content



Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

3-Stage Propane Ref Performance

New Blog Entry

Steam Tracing Design- posted in Ankur's blog

1

Control Valve Sizing

control valve sizing

4 replies to this topic
Share this topic:
| More

#1 MarcoAlba

MarcoAlba

    Brand New Member

  • Members
  • 3 posts

Posted 26 July 2017 - 02:02 AM

I prepare an excell sheet for control valve sizing in Excel and VBA. It has been prepared considering to reuse the code into a bigger VBA project, so I encapsulate the valve sizing into VBA object and there is an interface with excel. This is the first coding and I would appreciate to have comments and testing by other members.

Software is fully free and open but it is supplies as it is without any warranty.

Attached Files



#2 Bobby Strain

Bobby Strain

    Gold Member

  • Members
  • 2,295 posts

Posted 26 July 2017 - 07:17 PM

What you should do, if you are really serious, is compare results with one of the free valve suppliers sizing programs. Emerson's is pretty easy to use. And we all have access to it.

 

Bobby



#3 MarcoAlba

MarcoAlba

    Brand New Member

  • Members
  • 3 posts

Posted 27 July 2017 - 05:08 AM

Thanks for your reply and let me explain that I checked with same examples. Software from Emerson is sure a reference, however I would like to have a piece of code to include into other program and I share it, hoping that could be useful.

 

Marco



#4 Bobby Strain

Bobby Strain

    Gold Member

  • Members
  • 2,295 posts

Posted 27 July 2017 - 11:13 AM

You might consider converting the sizing into a library once you have validated the results. That makes it somewhat safer and readily reusable. You might find some of the libraries at my website for download to be useful. Pipe table, for example. I am pleased that you made the code visible to us.

 

Bobby



#5 Thurston Clark

Thurston Clark

    Brand New Member

  • Members
  • 1 posts

Posted 21 November 2017 - 12:02 AM

Here is a free control valve sizing program in Excel on www.industrydocs.website

The logic is accessible, and it includes documentation.

 

Thurston






Similar Topics