Excel Application to solve Simultaneous Equation.

I created this application at the request of my friend Matthias,it is intended for young people.I feel it is the best Excel app to solve Simultaneous Equation.Please check it out and tell me what you think.

Multicomponent Flash Separation.

This application is designed to handle 14 data points,to edit any cell double click on it and press the enter key or click on another cell.
To use this application
(1) Edit the Zi,Ki and component columns(Preferably edit/fill starting from row 1)
(2) Delete the rows you don't need.(Preferably just delete row values in columns Zi and Ki).

The vapour and Liquid fraction are computed automatically
NB : If no answer returns change the value of £  by increments of 0.0001
up to 1.0010 i.e 1.0001,1.0002,1.0003.......
This application is generally reliable for Vapour fraction greater than 0.1.

Original Gas In Place (OGIP) From Gas Material Balance.

This Gas Material Balance application is designed to handle 10 data points,to use this application
first change the value of n to your number of data points,edit the table by double clicking
and changing the cells starting from the initial production.Add more values if your data is more
than 6 points and press enter and the chart will be replotted.

m1 and (P/Z)1 is the automatic fitted gradient and intercept of the data points.

If you're not satisfied with the automatic trend line(green line) and its results U can use the
Manual line fitter(red line) and its derivatives by taking the following steps.

(1)Change the value of m2 to something close to m1.
(2)Change the value of (P/Z)2 to some close to (P/Z)1.
(3)Delete (P/Z)1 and OGIP1 to remove the green line.
(3)Keep changing the value of m2 to rotate the red line.
(4)Keep changing the value of (P/Z)2 to move the red line upward or downward.
(5)After you've fitted the red line then m2,(P/Z)2 and OGIP2 becomes your new results

NB : P/Z for initial production(Gp0) is usually very reliable so U can retain and use it
by changing m2 to m1,(P/Z)2 to P/Z, OGIP2 becomes your new results

Standing and Katz Z Chart Reader

To use the Standing and Katz Z Chart Reader double click on the cells and enter values for Ppr and Tpr to 2 decimal places and then press enter or click on another cell.


"> ">

Compressibility Factor Calculator (For Sweet or Sour Gases)

To use the Compressibility factor Calculator given gas compositions double click on the cells and edit values for each component,Reservoir Pressure and Temperature then press enter or click on another cell.The results are automatically computed.