Link Excel to HYSYS

[darrenkhu]

Dear all,

I have a flow vs time table in excel which i wish to update the flow spec boundary condition in hysys.

I've attached a hysys file (inside the zip as the forum does not allow uploading of hsc file) and an excel file as a sample.

[link Point to another website Only the registered members can access]

[link Point to another website Only the registered members can access]
The table of datas are in column A and B.

I want to be able to import cell G4 (simulation time) from HYSYS and export cell I4 (flowrate) into the mass flowrate of stream 1. And the import and export of variable has to happen in real simulation time (not just the start).


Please advice. Thank you very much!

[omesol]

contact omesoleducation@gmail.com for free training material.

Professional Development Courses Available For Engineering & Management Professional / Students.


-::Available Courses::-

- Process Simulation & Modeling Aspen Hysys Basic
- Process Simulation & Modeling Aspen Hysys Advance
- Simulation 3 in One Package(Aspen Flare, HTFS, Pipesys)
- Process Equipment Design Engineering
- Process Design Engineering
- P&ID and PFD Development
- Energy Audit & Conservation
- Total Productive Management
- Total Productive Maintenance
- Risk Assessment
- Advance Excel
- Supply Chain Management
- Virtualization For Beginners
- Installing & Managing Windows Server 2012
- Introduction To Active Directory Domain Services
- Awareness, Implementation & Internal Auditing to IMS (ISO 9001, ISO 14001 & OHSAS 18001)
- AutoCAD 2D/3D
- MS Project
- Primavera P6
- Routing & Switching
- Certification In Information Technology
- Project Management
- Communication & Presentation Skills
- Chemical Engineering For Non–Engineers

Comprehensive courses to meet your training needs by leaders in their fields.
For More Details Visit:

[link Point to another website Only the registered members can access]

[omesol]

contact omesoleducation@gmail.com for free training material.

Professional Development Courses Available For Engineering & Management Professional / Students.


-::Available Courses::-

- Process Simulation & Modeling Aspen Hysys Basic
- Process Simulation & Modeling Aspen Hysys Advance
- Simulation 3 in One Package(Aspen Flare, HTFS, Pipesys)
- Process Equipment Design Engineering
- Process Design Engineering
- P&ID and PFD Development
- Energy Audit & Conservation
- Total Productive Management
- Total Productive Maintenance
- Risk Assessment
- Advance Excel
- Supply Chain Management
- Virtualization For Beginners
- Installing & Managing Windows Server 2012
- Introduction To Active Directory Domain Services
- Awareness, Implementation & Internal Auditing to IMS (ISO 9001, ISO 14001 & OHSAS 18001)
- AutoCAD 2D/3D
- MS Project
- Primavera P6
- Routing & Switching
- Certification In Information Technology
- Project Management
- Communication & Presentation Skills
- Chemical Engineering For Non–Engineers

Comprehensive courses to meet your training needs by leaders in their fields.
For More Details Visit:

[link Point to another website Only the registered members can access]

[almmohd]

It can be done but you will need to know excel VBA.