Solver Question

[cartica]

I created a solver where I can get fund 1-4 and their corresponding INV 1-7 all inline by setting objective I19 to 1, and finding the correct total target % of changing D22 using the simplex LP. I have a new variable that I have been unable to figure out. There is a blank line 17 that holds INV 8. D26 shows that Fund 1 already holds this (5% or $26,557,267.66) In line 17 E-G I'm trying to get fund 2-4 to hold a combined $66,405,187, whereby D17 would be 0. Once split up, I would need everyone to still be in line and have a total of 100%. I am not sure how to do this, and if it requires multiple solvers, or some linear regression.

[Alf]

Not sure this is what you wish for. I would assume the solver setup would need some additional constraints. To test run solver.

There is no "Objective" in this model, I've just added constraints and set cells to change as two different ranges.

Alf