Create an HP program

[pallas23]

(08-09-2020 12:02 AM)pinkman Wrote:  Could you share with us the formulas used in the Excel sheet?

May I explain a little how it works, and if you could make it for the calculator I'm sure it will be really useful for the community.

I imported 2 tables, one with the enthalpy (for process with constant Pressure), and other with internal energy (for process with constant Volume) both at 25C and 1atm.You have to fill the lockers in the N columb, being alpha the amount of O2, beta CO2, gamma H2O, delta SO2, mu N2, nu O2, epsilon CO, and theta H2.Then you fill the hfg or ufg with the value of the enthalpy (or internal energy) of evaporation of the water, here the people must be very careful to use the same units with the coefficients and hfg.

With all of this done, you have all the values of the Q (heat) for different temperatures.
Then in the Q4 cell, you can add the quantity of Q you have. This is for calculating the coefficients, and the program will tell you (Marking ESTE in the L column) with Temperature is the nearest. When this temperature is the same as the one you assumed, you have found it. But when it is different you don't, and you have to try again with another temperature, but knowing the nearest Temperature, to try to, is really useful to save time iterating.

Please, if you can do it, or have any questions let me know.