Showing posts with label VBA Programming. Show all posts
Showing posts with label VBA Programming. Show all posts

Sunday, October 2, 2022

One Minute Process Engineering: Generate an Air Cooler Datasheet from Hysys, ProMax and Unisim

 Process engineers use different simulation software, such as Hysys, ProMax and Unisim. We also spend lots of time on extracting data from the simulation software to create process data sheets. Do you ever dream to create process datasheets from various simulation software in just one minute?

Tuesday, January 21, 2014

Guofu Chen is now a Certified Excel Expert by Microsoft

Guofu Chen is now a Certified Excel Expert by Microsoft.

You are using Excel everyday. Why don't you show the expertise? Get it certified.

Wednesday, January 8, 2014

Program a Cooling Water Tower extension in Aspen HYSYS

This cooling tower extension for Aspentech HYSYS is able to predict the cooling water tower performance given the design conditions and the new operating conditions. Given the flow, inlet temperature to the tower and wet bulb, the HYSYS extension will predict the cooling tower outlet temperature.

Monday, January 6, 2014

Polynomial curve fit PolyFit and PolyFits in Excel

PolyFit allows you to curve fit two sets of data into a polynomial formula and gives you the answer given the new variable. It is very flexible and it allows you specify your own polynomial power order. PolyFits allows you to fit your data into several segments of polynomial formulas.

Set HYSYS recycle tolerance with one click

This software allows you to easily switch HYSYS recycle tolerance settings by one click. It is recommended that you use "Speed" setting to run your optimization and use "Final" setting to finalize your HYSYS simulation.