Hi Everyone,
I've been working on this problem for the last few days and I'm not able to crack this. I need to solve this anyhow. Can someone please help me or give me some direction?
I've shared an Excel document here. It has 14 Fields.
I will share some details here
And you can also see this in the Excel solver window
Apart from this few more details are below
of course, I am able to complete this in excel but my task is to replicate this in Alteryx. I'm trying to use the optimization tool for this but I'm not getting the desired result. I'm not able to share the workflow that I've created as that is in my work computer and becuase of company policy, I am not able to share.
Can someone please help me?
Regards,
Nitesh
Solved! Go to Solution.
Hi,
I think it's a bit tricky to solve this w Optimizer tool given that all Excel formulas will not work dynamically in Alteryx. Thus, I have to convert them to a flat formula before feeding it to Optimizer tool.
This is my answer:
Setting up Variables for O anchor:
Setting up constraint matrix for A anchor:
Same like you, i'm using Company's laptop, thus unable to upload any file to here. But if you still need it, do let me know. I will upload when i get back home using my personal laptop.
Hi @trung2403
Thanks a lot for your Answer. Yes, can you please upload your files?
I was taking the below as my input for O. The coefficient that I was taking was totally the opposite.
variable | coefficient | lb | type |
202201 | 1 | 0 | I |
202202 | 1 | 0 | I |
202203 | 1 | 0 | I |
202204 | 1 | 0 | I |
202205 | 1 | 0 | I |
202206 | 1 | 0 | I |
202207 | 1.95 | 0 | I |
202208 | 1.95 | 0 | I |
202209 | 1.95 | 0 | I |
202210 | 1.95 | 0 | I |
202211 | 1.95 | 0 | I |
202212 | 1.95 | 0 | I |
202213 | 2.805 | 0 | I |
202214 | 2.805 | 0 | I |
202215 | 2.805 | 0 | I |
202216 | 2.805 | 0 | I |
202217 | 2.805 | 0 | I |
202218 | 2.805 | 0 | I |
202219 | 3.53175 | 0 | I |
202220 | 3.53175 | 0 | I |
202221 | 3.53175 | 0 | I |
202222 | 3.53175 | 0 | I |
Thanks,
Nitesh Sharma
Hi trung2403
Thanks a lot for your Answer. Yes, can you please upload your files?
I was taking the below as my input for O. The coefficient that I was taking was totally the opposite.
variable | coefficient | lb | type |
202201 | 1 | 0 | I |
202202 | 1 | 0 | I |
202203 | 1 | 0 | I |
202204 | 1 | 0 | I |
202205 | 1 | 0 | I |
202206 | 1 | 0 | I |
202207 | 1.95 | 0 | I |
202208 | 1.95 | 0 | I |
202209 | 1.95 | 0 | I |
202210 | 1.95 | 0 | I |
202211 | 1.95 | 0 | I |
202212 | 1.95 | 0 | I |
202213 | 2.805 | 0 | I |
202214 | 2.805 | 0 | I |
202215 | 2.805 | 0 | I |
202216 | 2.805 | 0 | I |
202217 | 2.805 | 0 | I |
202218 | 2.805 | 0 | I |
202219 | 3.53175 | 0 | I |
202220 | 3.53175 | 0 | I |
202221 | 3.53175 | 0 | I |
202222 | 3.53175 | 0 | I |
Thanks,
Nitesh Sharma
Hi,
Sorry for my late response. I was out of town last weekend. This is how i convert the formula
And this is how to set it up dynamically with Alteryx, you can change n to any number that you want as i have a summarise tool to find Max.
For Constraint matrix, I will think on how to set it up dynamically and get back to you later. Currently, i set it up manually.
Best.