cavalieregi
New Member
- Joined
- Aug 10, 2018
- Messages
- 1
Hi,
I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min.
I haven't had any luck and was wondering if one of you legends could help.
I've tried running solver as per the picture below
It claims it has run but I know it hasn't because the value doesn't change and when i manually change this value I can get a better min for cell T5 than it does.
I was also wondering if anyone knows how to run this sames solver operation for each cell in the range T5:T86 so I don't have to manually do it one by one.
However, if anyone can think of a better solution please let me know.
Link to the latest worksheet (https://drive.google.com/file/d/1V9v3cXwAW4NmLsR_I5UsUaJ0zvqLHBVO/view?usp=sharing) if that helps.
Cheers,
GC
Note: this was also posted on https://www.excelforum.com/excel-general/1241124-help-with-solver-inputs.html#post4953104 with no luck so far.
I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min.
I haven't had any luck and was wondering if one of you legends could help.
I've tried running solver as per the picture below
It claims it has run but I know it hasn't because the value doesn't change and when i manually change this value I can get a better min for cell T5 than it does.
I was also wondering if anyone knows how to run this sames solver operation for each cell in the range T5:T86 so I don't have to manually do it one by one.
However, if anyone can think of a better solution please let me know.
Link to the latest worksheet (https://drive.google.com/file/d/1V9v3cXwAW4NmLsR_I5UsUaJ0zvqLHBVO/view?usp=sharing) if that helps.
Cheers,
GC
Note: this was also posted on https://www.excelforum.com/excel-general/1241124-help-with-solver-inputs.html#post4953104 with no luck so far.