How to get started with Solver for Minimization Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1621682%22%20slang%3D%22en-US%22%3EHow%20to%20get%20started%20with%20Solver%20for%20Minimization%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621682%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20Excel's%20solver%20tool%20and%20have%20a%20function%20I%20would%20like%20to%20minimize.%26nbsp%3B%20I%20am%20struggling%20with%20how%20to%20set%20it%20up.%3C%2FP%3E%3CP%3EThe%20problem%20is%3A%26nbsp%3B%20I%20am%20hosting%20several%20events%20(5)%20that%20need%20social%20distancing%20so%20I%20am%20spreading%20out%20the%20people%20that%20will%20come%20to%20them.%26nbsp%3B%20I%20have%20employees%20that%20will%20come%20to%201%2C%202%2C%203%2C%204%2C%20or%20all%205%20events.%26nbsp%3B%20It%20doesn't%20matter%20which%20ones%20they%20come%20to%2C%20but%20I%20would%20like%20to%20minimize%20the%20number%20that%20come%20across%20all%20events.%26nbsp%3B%20So%20to%20make%20it%20simple%20say%20I%20have%20events%20scheduled%20Monday%20to%20Friday%2C%20I%20would%20like%20to%20make%20sure%20that%20the%20staff%20coming%20to%20only%20one%20event%20and%20attend%20on%20Monday%2C%20don't%20overlap%20with%20the%20people%20attending%20only%202%20events%20-%20so%20I%20can%20minimize%20the%20number%20each%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20started%20off%20with%20a%20total%20number%20of%20staff%20-%20say%20100%20for%20ease.%3C%2FP%3E%3CP%3EThen%20I%20have%20variables%20as%20the%20number%20of%20people%20in%20each%20of%20the%20%22events%20buckets%22%20I%20mentioned%20above%20(1%20through%205).%20I%20want%20to%20minimize%20the%20function%20of%201*(%23%20of%20staff%20for%201%20event)%20%2B%202*(%23%20of%20staff%20for%202%20events)%20%2B%20...%20%2B%205*(%23%20staff%20for%205%20events).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20stuck%20with%20how%20to%20put%20this%20into%20the%20solver.%26nbsp%3B%20I%20also%20wrote%20out%20the%20events%20as%20well%20(Event%201%2C%20Event%202%2C%20etc.)%20and%20am%20still%20stuck.%26nbsp%3B%20Does%20anyone%20have%20a%20good%20idea%20on%20how%20to%20approach%20this%20please%3F%20to%20help%20me%20set%20it%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1621682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622447%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20started%20with%20Solver%20for%20Minimization%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776214%22%20target%3D%22_blank%22%3E%40wpav2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20clear%20to%20me%20what%20is%20your%20decision%20variables%3F%3C%2FP%3E%3CP%3Ewhat%20is%20the%20thing%20that%20you%20want%20to%20control%20or%20know%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20an%20employee%20wants%20to%20come%20to%20events%201%2C2%2C%20and%204.%20What%20can%20you%20control%20in%20their%20decision%3F%3C%2FP%3E%3CP%3EIt%20is%20not%20clear.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

I am new to Excel's solver tool and have a function I would like to minimize.  I am struggling with how to set it up.

The problem is:  I am hosting several events (5) that need social distancing so I am spreading out the people that will come to them.  I have employees that will come to 1, 2, 3, 4, or all 5 events.  It doesn't matter which ones they come to, but I would like to minimize the number that come across all events.  So to make it simple say I have events scheduled Monday to Friday, I would like to make sure that the staff coming to only one event and attend on Monday, don't overlap with the people attending only 2 events - so I can minimize the number each day.

 

I started off with a total number of staff - say 100 for ease.

Then I have variables as the number of people in each of the "events buckets" I mentioned above (1 through 5). I want to minimize the function of 1*(# of staff for 1 event) + 2*(# of staff for 2 events) + ... + 5*(# staff for 5 events).  

I am getting stuck with how to put this into the solver.  I also wrote out the events as well (Event 1, Event 2, etc.) and am still stuck.  Does anyone have a good idea on how to approach this please? to help me set it up.

 

TIA!

1 Reply

@wpav2020 

It is not clear to me what is your decision variables?

what is the thing that you want to control or know?

 

If an employee wants to come to events 1,2, and 4. What can you control in their decision?

It is not clear.