0000004685 00000 n Adding stream table in Hysys V8.8 Adding stream table in Hysys V8.8 cheme2016 (Chemical) (OP) 29 Sep 16 21:54. 0000002758 00000 n Does anyone know how to do this?
0000003709 00000 n Delta H to go from 25°C and bar to your condition = 2540 kJ/Kg Hysys use the enthalphy with the zero set to oxygen and hydrogen in reference condition. So Heat of Formation of Water at 25 °C (Liquid)-285 kJ/mol = -15833 kJ/kg. It could be for a heat and material balance table, an equipment datasheet, or just data for a calculation. 0000003529 00000 n Option #5 also makes it very easy to mix and match streams from multiple simulation files or sub-flowsheets (like a column’s streams) into a single report.Option #2 is also very flexible, takes a little longer to set up but you’ll get the reports faster and it’s less buggy. The techniques in this post have been used with Hysys 2004-V7.1 and UniSim 2004-2006, and may not work with older or newer versions.2011-03-23 – Added option #8, Aspen Simulation WorkbookHello, it used to be possible to copy/paste special link “as text”, a direct link from HYSYS to Excel.You reminded me of this program, which I’ve added to the post at Option #8: Could that be what you meant?
0000002197 00000 n Note that you could also use the spreadsheet approach to bring together the variables that you might want to change as you tune a program, as well as the variables you want to copy and paste to an outside program.Option #7 is the most powerful but requires programming knowledge and work.P.S. If you're new here, you may want to subscribe to my Personally, I find Option #5 is the easiest, quite flexible and powerful. 0000002868 00000 n 0000001426 00000 n %PDF-1.3 %���� But maybe there was/is a different way that I am not aware of.Before Aspen HYSYS 2006, when copying from HYSYS to your sheet in Excel, you would (without an external sheet or software):It was copying an address in the Excel cell, refreshing at opening of the sheet or when demanded.“An extension of this is to paste a link to the data. 0000001090 00000 n Need to get stream data from your Aspen Hysys simulation into another format; say Microsoft Excel? Thanks . 0000000747 00000 n 0000004360 00000 n
trailer << /Size 60 /Info 39 0 R /Root 41 0 R /Prev 482686 /ID[ Need to add stream table to my flowsheet showing line size, pressure, flow rate,temperature and velocity. In Excel use the Edit … Paste Special menu command and then pick As Text in the listbox, and Paste Link on the radio buttons. This gives a live link, when the data in HYSYS changes, it is automatically updated in Excel. Proceed in next Python code to save HYSYS screenshot, save HYSYS file as a new case, and repeat step #2 for next case. 0000000802 00000 n Manually check whether the simulation result is converged and nothing strange showing up 4. I have V8.8 version. Your Steam table use liquid water 0°C as the zero so the value of 2645 kJ/kg . In HYSYS V8.x, you also can use the "Send To" option to add data to process data tables. Adding Stream Tables: Adding stream tables to the process flowsheet is a simple process, but we will first go over some options for formatting and modifying your stream tables. 0000001997 00000 n On the current screen you will see two of the options for varying the stream table: Display and Format.
40 0 obj << /Linearized 1 /O 42 /H [ 802 288 ] /L 483614 /E 7942 /N 10 /T 482696 >> endobj xref 40 20 0000000016 00000 n Run Excel Macro to change HYSYS inlet condition following each case 3. Try one of the following approaches to copy out the Hysys data. 0000003331 00000 n 0000002465 00000 n Instead of pasting in the data, a special formula which links to the HYSYS data is written.”Very interesting, first I’ve heard of it but thank you for sharing!Chemical Engineering Blog | Process Design | Project Management |EPC | Business | Excel | Tools & Tricks
0000004179 00000 n Run Excel Macro to export HYSYS stream properties to Excel Table 5. 0000001244 00000 n 0000001069 00000 n
0000007713 00000 n Personally, Aspen Simulation Workbook and VBA coding are the only ways I know of to create a two-way link between Excel and Hysys. 0000002388 00000 n 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. So I’d prefer option #5 for one-off problems and option #2 for lengthy problems where I can set up the Hysys file properly and keep developing the file going forward.Option #6 is a good choice if you only need a tiny handful of variables, but many different types of variables from different places in the simulation.
Boost profitability by closing the gap between planning and actual operations through Aspen HYSYS's V11 release.