# constraint

1. ### How to find all combinations within a constraint

I am after some code/advice for Access. I have a list of Order Numbers(Unique) and what cubic metres that each are, I also have a cost benefit per Order. I would like to run some code to be able to find every combination of Orders but within a given constraint of Cubic size (65Cube) to find the...
2. ### [Solver] Problem with constraints

Hi, I'm trying to do a workbook to find a maximum probability with some one constraint. It doesnt find any feasible solution but I do not find any problem with my workbook. Does anyone have a clue of how it could work? I am trying to find max value of cell D15 with help of editing cell H2:J14...
3. ### Solver - Best method/options possible to get desired result

Hi, I am trying to set up solver to determine the best possible tax distribution of income (variables) across multiple entities, based on their initial existing income, in order to minimize their gross tax payable (objective). My main constraint is a cell which must equal zero. When the...
4. ### cartesian product with Max constraint / VBA code / Power query Trick

Hi Excel Masters, I am trying to list all the combinations of a qty X breakdown within a 2 dimensions tables. In other words, lets imagine I have 1 unit of a product in stock, what are the combinations of destinations that I could send that product to (Clients x in Region Y) Example 1...
5. ### Constraint Modeling for Solver

I think my logic is a little off... I have three products (Small, Medium, Large)-produced across 3 plants/locations: Product S=Small M=Medium L= Large Plant 1=1 Plant 2=2 Plant 3=3 Constraint: Production of Small cannot be greater than 5x the production of Medium 5(Xs1+Xs2+Xs3)<=...