Excel help with meeting input data requirements for a model

[mki16101]

Hi,

I am currently working on a model that has some fixed inputs that cannot be altered, it also has some auxiliary inputs, some rates that works with the inputs to produce the outputs. For this particular model, I need to meet three requirements. I was able to meet two of them and could not meet the third one with my choice of variable inputs. Please look at the excel files as I tried to make as clear as possible as to what can be varied and what the overall goal is. Since it is a very complicated system with a lot of moving parts, I did not mention everything in here. Please help. I would really appreciate it.

Thanks in advance for looking at this.

[AliGW]

That's a lot of data! Which are the cells you want help with?

[mki16101]

If we look at row 232,233,234 you will see the requirements that needs to be met.

Row 14 thru 19 is the user defined inputs which you can vary to achieve these requirements. There are some conditions as to what those values can be.

Row 27 defines the initial value of an output which can be varied as well but meeting some conditions which are listed to the right.

Please help