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

Vertical Tank Selection

New Blog Entry

Low Flow in Pipes- posted in Ankur's blog

Hysys Spreadsheet

link

This topic has been archived. This means that you cannot reply to this topic.
7 replies to this topic
Share this topic:
| More

#1 Bal

Bal

    Gold Member

  • Members
  • 89 posts

Posted 05 November 2015 - 02:45 AM

Hello,

 

How can I link a hysys spread sheet in one hysys simulation to another spreadsheet in a different hsysy simulation?

 

 

Thanks!



#2 Bal

Bal

    Gold Member

  • Members
  • 89 posts

Posted 05 November 2015 - 09:27 AM

Any idea??



#3 bhautesh.mistry@gmail.com

bhautesh.mistry@gmail.com

    Brand New Member

  • Members
  • 8 posts

Posted 05 November 2015 - 10:24 AM

Hi!

 

I think you can connect your both HYSYS file with Excel through VBA. Thereafter you can link hysys spreadsheet of first file to spreadsheet of second file by writing correct codes in VBA.

 

Regards,

Bhautesh



#4 Lucian Gomoescu

Lucian Gomoescu

    Veteran Member

  • Members
  • 44 posts

Posted 05 November 2015 - 01:58 PM   Best Answer

Hello everyone,

There are more possibilities:

 

1. The one suggested by Bhautesh Mistry.

 

2. Use Macro Language Editor from Tools within HYSYS. Write with it the VBA subroutine. This option has the advantage that you don't need Excel.

 

See the attached example ( change case 1 and 2 extension to hsc and open them, then open Macro1.wwb file in HYSYS's Macro Editor and run it; i had to change the extension of these files because i couldn't upload the files with extension hsc, respectively wwb).

 

Options (1) and (2) have the same sad disadvantage that you have to run the macro manually every time the spreadsheets have to be updated. In other words, they don't assure a "live link", or at least i had not discovered yet the proper events to be used with this purpose.

 

3. Go to Tools > Case Collaboration and publish the spreadsheet blocks. Unfortunately you have to solve the Data Server, thing which i've never done so i can't give advice for now.

 

4. There may be a trick with the events assured by user variable code, among which is the variablechanged(). It is worthy to try.

 

Options 3 and 4 assure "live links".

 

Good luck,

Lucian

 

Attached Files



#5 abubakarce19

abubakarce19

    Junior Member

  • Members
  • 20 posts

Posted 08 November 2015 - 02:14 PM

you can also copy one simulation in other with its spread sheet. connect both simulation using recycle loop. In hysys recycle loop do not work as recycle process loop in different process systems, but divides the solution of simulation in two parts. so when one get solve other one will get results.

 

thanks 

ABS



#6 Bal

Bal

    Gold Member

  • Members
  • 89 posts

Posted 09 November 2015 - 11:51 PM

Thanks a lot every1 :)



#7 bhautesh.mistry@gmail.com

bhautesh.mistry@gmail.com

    Brand New Member

  • Members
  • 8 posts

Posted 15 November 2015 - 06:31 AM

Hi everyone!

 

In addition to this post, can anyone suggest me to link Matlab and HYSYS file. i want to solve an optimization problem.

 

Regards,

Bhautesh



#8 suria07100

suria07100

    Brand New Member

  • Members
  • 1 posts

Posted 17 November 2015 - 09:38 PM

@Bhautesh Mistry

Maybe you can begin by writing code with VBA, link Excel and Hysys, then link Excel and MATLAB via COM/API (mostly via VBA and matlab).

 

Link below shows how to link MATLAB and Aspen plus (not Hysys, maybe useful)






Similar Topics