Applicable Version(s)

HYSYS Versions 2.4.1 - Current

Problem Statement

HYSYS Stream Reporter (HSR) Version 1.6

Solution

HYSYS Stream Reporter (HSR) is an Excel spreadsheet utility that allows material stream conditions, properties and compositions to be easily reported onto a spreadsheet, it also enables streams in different cases to be conveniently compared.

HSR can report properties from the following phases: Overall, Vapour, Light and Heavy (Aqueous) Liquid, Combined Liquid and Solid. It also allows stream user variables and property correlations to be reported. It is also possible to create formulae in the output table. The user can save sets of properties or use one of the pre-built property sets. Streams from different HYSYS cases can be reported in the same stream table. Once a stream table has been generated it can be updated by pressing a single button. Stream tables can be moved to another Excel workbook whilst maintaining the ability to be updated.

HSR takes the form of an Excel spreadsheet file with embedded Visual Basic for Applications (VBA) code that demonstrates how HYSYS can be accessed programmatically. The VBA source code is freely accessible and users are encouraged to learn from it and adapt it to their own needs.

For full details please see the 'HSR User Guide.doc' document in the attached zip file.

For HSR version 1.6, ten versions of the HSR spreadsheets are provided:

To use HSR with HYSYS V7.3 use "HSR 1.6 (for HYSYS V7.3).xls"

To use HSR with HYSYS V7.2 use "HSR 1.6 (for HYSYS V7.2).xls"

To use HSR with HYSYS V7.1 use "HSR 1.6 (for HYSYS V7.1).xls"

To use HSR with HYSYS V7.0 use "HSR 1.6 (for HYSYS V7.0).xls"

To use HSR with HYSYS 2006.5 use "HSR 1.6 (for HYSYS 2006.5).xls"

To use HSR with HYSYS 2006 use "HSR 1.6 (for HYSYS 2006).xls"

To use HSR with HYSYS 2004.2 use "HSR 1.6 (for HYSYS 2004.2).xls"

To use HSR with HYSYS 2004 use "HSR 1.6 (for HYSYS 2004).xls"

To use HSR with HYSYS 3.4 use "HSR 1.6 (for HYSYS 3.4).xls"

To use HSR with HYSYS 3.2 use "HSR 1.6 (for HYSYS 3.2).xls"

To use with other HYSYS versions please read section 8 of the User Guide document.

Note

This Automation application has been created by AspenTech as an example of what can be achieved through the object architecture of HYSYS. This application is provided for academic purposes only and as such is not subject to the quality and support procedures of officially released AspenTech products. Users are strongly encouraged to check performance and results carefully and, by downloading and using, agree to assume all risk related to the use of this example. We invite any feedback through the normal support channel at eSupport@aspentech.com.

With Excel 2003 and higher, the HSR 1.6 can handle a maximum of 6 output worksheets.

KeyWords

HYSYS Stream Reporter, HSR, HYSIM Stream Summary