Iterative calculations are enabled, I've refreshed the calculations every way I know how (calculate now, F9, reopening the file). Sometimes the first 30 or so calculations will produce results, but it will be patchy for the rest. Sometimes in the "results" I'll get a temperature but no pressure, pressure but no temperature, or both will come back as #VALUE, #NUM, or #DIV/0. This means for every sample, 9 thermometry calculations are referring to a specified pressure result, 7 barometry calculations are referring to a specified temperature result, and the specified pressure and temperature results are referring back to their respective calculations. 3) Set Maximum Iterations to 10, leave Maximum Change default, check the box to enable iterative calculation. 1) Disable iterative calculation 2) Type the following formula. Iterative calculations are enabled, I've refreshed the. To illustrate how iterative calculation works, follow the below steps. ![]() ![]() Since thermometry calculations require a pressure input and barometry calculations require a temperature input, I have all these calculations referring to the "results" page. Sometimes in the 'results' I'll get a temperature but no pressure, pressure but no temperature, or both will come back as VALUE, NUM, or DIV/0. I have a sheet for each mineral that converts the compositional data into the proper units, a sheet with thermometers, another with barometers, and then a final "results" sheet where you can select which thermometer and barometer you want from drop-down menus. ![]() I have a file (4.7 MB) where I try to combine multiple geological thermometers and barometers.
0 Comments
Leave a Reply. |