Professionally I work at BPT and focus on creating value adding App for Process Simulation. You can find more info on those on the BPT website. Below are posts that should help HYSYS, PetroSIM and UNISIM users alike in their day to day challenges to produce accurate yet fast models efficiently.

Release the true potential of your staff Apps for Process Simulation

Sunday, 8 February 2015

The HYSYS Process Data Tables - The Ugly Duckling

When you go to Tools / Databook (or use ctrl d), the items you will probably have used are the case study tool and the strip charts (if you use Dynamics). You will probably never have given the "Process Data Tables" a second glance.
On it's own, a process data table isn't much use, it can be used as a convenient means to collect input and output data in one place. But, process data tables really come into their own when you need to transfer data in and out of HYSYS. The key advantages are:
1 - Data transfer based on tag names
2 - Transfer data in blocks, 500 bits of info are transferred with the same code as for 5 bits of info
3 - The HYSYS user can easily identify the items he wants to import/export using drag&drop

Some more explanation why these advantages are key:
The HYSYS user may have identified data he wants to set in HYSYS, but the external system doesn't always have that information. The data transfer instruction take tags names and values and if the tag names are only a sub set of the tags defined in HYSYS, then only the values for that sub set will be updated. You don't have to worry about missing data.

Data transfer in blocks is self explanatory really. When the amount of data to be transferred goes up, the time it takes to do that goes up as well. By transferring blocks of data, the transfer is much faster and also simpler to program.

The third advantage is around accessing data in HYSYS, an in particular if you want programmatically access. Not all variables are properly wrapped for ActiveX access. You may be able to find a BackDoor access, but even that is sometimes difficult to find. You can use the variable browser of the data book to add data and it can be really handy if you need to add lots of variables. But for certain obscure variables, your only option is to drag&drop them to the data table. In HYSYS V8.x, you also can use the "Send To" option to add data to process data tables.

We have used process data tables in our BPT-EXT tool to quickly create a case study tool with the added capability to save every case as a separate simulation.

Below, is a sequence of how this is used in BPT-EXT.
I start with the standard deep cut tub expander example. To start with there are no data tables.

Assume I want to modify the pressure of stream 17 and I want to change to temperature of stream 13 (inside FLOW-1). I want to see how this affects the duty of stream 83 and the mass flow rate of the NGL in stream 21. I created a Process Data Table and then drag and dropped each variable in the table and gave it an appropriate tag name.

Then I started Excel and activated BPT-EXT. By clicking on the "Retrieve PDT from HYSYS" button, the summary of the table in HYSYS is imported in Excel. Now I can add extra lines for all the cases I want to run.

I added the case conditions I need and also gave them names.

After clicking the "Create Case study cases" button, the result columns are populated with results like in a standard HYSYS case study, but I now also have each case that corresponds with each set of data.

BPT-EXT can now be used to extract all sorts of information from all those cases. As shown below, it can be used to do the line sizing on all streams in all cases and then to look at the sizing result for a particular stream for all cases.


Asma Rimel said...

Hello , how can we obtain BPT-EXT?

Kwizim said...


You can license it from BPT. You can find more info at or just Email me at


Contents By Category