Dear All,
I have a problem and try to solve .I am desperately hitting for solution.
Col B and ColI is fixed.
my Total amount in Cell j206 is fixed constraint.
Let it be 80000.00
I want to play only with quantity in colG in such a way that after multiplying each value in ColG with corresponding
value in Cell I then total Amount in j.
After Summing j2:j205 the total should be 80000.(fixed)
For Example if i put 90000.00 in cell J206 then quantity automatic adjusted in Col G.(Range G2:G205).
Moreover, The Quantity in Remove cLADDING, rEMOVE INSULATION, INSTALL INSULATION,INSTALL CLADDING must be same.
Any Solver or technique in this regard is deeply welcome.
Rgds,
Aligahk06
I have a problem and try to solve .I am desperately hitting for solution.
Col B and ColI is fixed.
my Total amount in Cell j206 is fixed constraint.
Let it be 80000.00
I want to play only with quantity in colG in such a way that after multiplying each value in ColG with corresponding
value in Cell I then total Amount in j.
After Summing j2:j205 the total should be 80000.(fixed)
For Example if i put 90000.00 in cell J206 then quantity automatic adjusted in Col G.(Range G2:G205).
Moreover, The Quantity in Remove cLADDING, rEMOVE INSULATION, INSTALL INSULATION,INSTALL CLADDING must be same.
Any Solver or technique in this regard is deeply welcome.
Rgds,
Aligahk06