Spreadsheet in Hysys

A process engineer might be most familiar with this software, Hysys. Have learn it since in college and earlier operate it before knowing other process engineering softwares, does not mean I am mastering it (hehehe). One of Hysys function that I already understand is Spreadsheet. Once again I say, I was learning about that Spreadsheet in college, but I just already use it to develop simulation at work not long before I write this post. So please forgive me, my lecturer :p

Back to the topic, you can find Spreadsheet in the object palette. It's like having simple Excel in your Hysys. You can calculate a variable you need, from other variable that has stated in the simulation and directly input it to the empty variable without copy paste it. Check this steps out.

1. Example case: there is a fluid that contains oil, water, and slight gas. Available data:

    - Fluid pressure and temperature

    - Oil and gas composition

    - Oil flow

    - Gas oil ratio (ratio between oil and gas, usually in bbl/scf)

    - Water cut (water percentage in water and oil mixture, in %)

Below is the PFD:

Actually, the three phase separator is a dummy. ZUB Comp 2 stream = Oil stream. The objective of the simulation is to get Gas, Oil and Water stream from available data.

2. Step to appear Spreadsheet in PFD:

3. Double click the Spreadsheet icon in PFD, then appears table like picture below (after click Spreadsheet tab)

- Type the variables that corresponds with calculation in column A.

- Right click B2, choose import variable. And then choose object Oil and variable Actual Liquid Flow.

- Input GOR data to B3

- Input formula to B4 to get Total Gas (MMSCFD) = B2*B3/1000000

- Change variable type to Std Gas Flow 

- Right click B4, choose Export Formula Result

- Choose object Gas and variable Molar Flow

- Input Water Cut data to B5 (in fraction)

- Input formula to B6 to get Total Water (BWPD) = B5/(1-B5)*B2

- Right click B6, choose Export Formula Result

- Choose object Water and variable Liq Vol Flow @ Std Cond

- If you want to know Total Liq (BFPD), input formula to B7 = B2+B6

Done! We get convergent Gas, Oil and Water stream with known liquid flow (from available data), calculated gas flow (from GOR), and calculated water flow (from Water Cut).

Yeayyy! :D