13-Aquamarine

Solved

Use end result as input for next calculation

Forum|Forum|5 years ago
August 16, 2020
2 replies
1838 views

This is most likely a very stupid question but I do not succeed in this simple program. Attached is a MC 15 file I would like to automate in a small program the process mentioned in the highlighted comment. Would anyone be so kind to help me out as I do not "see" it right now.

1_Waters-Cell-Salvage-Efficiency.zip

Programming

Best answer by Werner_E

OK, here is the all in one version

Or a bit shorter:

And in case that you also need the intermediate results, here's a way to get them:

MC15 worksheet attached

25-Diamond I

Hct.cyclestart should be replaced in eq. 6 and 7 but not in eq 5, which you wrote after eq. 6 and before eq. 7? Are you sure?

Obviously you'll need to use a "while" loop to do the iterations.

Why don't you make k and V.blood an argument of function CS, too?

25-Diamond I

Here is an approach using your function CS, assuming that the value in eq.5 has to be replaced, too:

Of course its not mandatory to split the calculation into two functions. I was simply lazy 😉

Answer

25-Diamond I

OK, here is the all in one version

Or a bit shorter:

And in case that you also need the intermediate results, here's a way to get them:

MC15 worksheet attached

6_WE_20200816_Waters-Cell-Salvage-Efficiency.zip

Author

13-Aquamarine

Werner I must have had a complete blackout... but you made my morning. Thank you for your assistance.