Unable to get desired result when using data solver option

%3CLINGO-SUB%20id%3D%22lingo-sub-1494511%22%20slang%3D%22en-US%22%3EUnable%20to%20get%20desired%20result%20when%20using%20data%20solver%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494511%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20allocate%20the%20size%20wise%20qty%20in%20various%20ratios%2C%20example%20file%20is%20given%20as%20attachment%2C%20pls%20help%20me%20to%20solve%20this%20problem...%20conditions%20and%20expects%20results%20given%20in%20the%20attachment%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1494511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494834%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20get%20desired%20result%20when%20using%20data%20solver%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494834%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712501%22%20target%3D%22_blank%22%3E%40Safy84%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20clarify%20if%20the%20condition%20you%20specified%20is%20correct%3F%3CBR%20%2F%3E%3CBR%20%2F%3E-%20cell%20E13%20to%20L17%20should%20nor%20exceed3%20and%20it%20should%20be%20rounded%20off%20(0%2C1%2C2%2C3)%3CBR%20%2F%3E-%20cell%20M13%20to%20M17%20should%20not%20exceed%205%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495212%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20get%20desired%20result%20when%20using%20data%20solver%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20it%20is%20correct%2C%20that%20means%20to%20the%20particular%20ratio%20one%20size%20maximum%20can%20come%203pce%20only%2C%20at%20the%20same%20time%20total%20no.%20of%20pcs%20should%20not%20exceed%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20each%201%20can%20come%20in%205sizes%20or%20one%20size%20can%20enter%20as%202%20and%20rest%203sizes%20can%20come%20with%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496625%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20get%20desired%20result%20when%20using%20data%20solver%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712501%22%20target%3D%22_blank%22%3E%40Safy84%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20got%20the%20parameters%20right%20based%20on%20what%20you%20intended%20to%20achieve.%20I%20believe%20the%20challenge%20will%20be%20that%20solver%20is%20looking%20for%20the%20optimal%20solution%20which%20is%20taking%20forever%20for%20it%20to%20find.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497536%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20get%20desired%20result%20when%20using%20data%20solver%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20trying%20it...%20If%20I%20get%20a%20solution%20for%20this%20I%20would%20save%20lot%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ESafy%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to allocate the size wise qty in various ratios, example file is given as attachment, pls help me to solve this problem... conditions and expects results given in the attachment itself.

4 Replies
@Safy84

Can you clarify if the condition you specified is correct?

- cell E13 to L17 should nor exceed3 and it should be rounded off (0,1,2,3)
- cell M13 to M17 should not exceed 5

Cheers

@wumolad 

 

Yes it is correct, that means to the particular ratio one size maximum can come 3pce only, at the same time total no. of pcs should not exceed 5.

 

For example, each 1 can come in 5sizes or one size can enter as 2 and rest 3sizes can come with 1.

@Safy84 

 

I think you got the parameters right based on what you intended to achieve. I believe the challenge will be that solver is looking for the optimal solution which is taking forever for it to find.

 

Cheers

@wumolad 

Thanks for trying it... If I get a solution for this I would save lot of time.

 

Regards,

Safy