When you test the contents of your reactor is the sample and your reactor contents all in one phase?
If not, (which seems likely) then there is no spreadsheet because the calculation is not possible.
Think about it and you will agree (I hope).
For example:
I have a bottle containing water and gases. Tell me how much is water and how much is gas?
Well, tell me the answer. Isn't there a spreadsheet to calculate how much is water and how much is each of the gases?
Gosh, I wish the real world would be simple and straightforward but it isn't.
I hope I am understood.
I have been in situations where the contents are to be measured and normalized (not trended). Unless you know:
EVERYTHING that is in a sample
and can separate it, and can measure it, you can't calibrate the measurements and transform it into an answer of wt% or vol% or mol%. Even then the sample has to be entirely in one phase, all liquid or all gas.
Sometimes this is possible, but not in this case I suspect. (water, acid anhydrides, peroxides, etc)
You can trend the content of each phase of a two phase system but you can't normalize it as you don't know the AMOUNT of each phase present at any one time.
Knowing the limitations of a situation is almost as good as knowing the true answer.......
almost.
best wishes,
Rod