software

Hi,

I work in a call center and I wanted to tackle our persistent
problem of running out of work stations.

I was given the task of providing a seating arrangement for the
whole center (imagine 900 agents and 205 different start times and days
off).

They gave me a floor plan in excel.

My question is can I automate plotting agents on work stations by
teams with different start times and different days off AND sharing of
work stations.

Data available is individual schedules of agents, team groupings,
floor plan all in excel.

Thanks in advance!--
natski
------------------------------------------------------------------------
natski's Profile: www.excelforum.com/member.php...oamp;userid=21988
View this thread: www.excelforum.com/showthread...hreadid=538793Natski --

The optimization problem you face can be solved using the Excel Solver tool.
It's too complex to explain in this setting. Maybe some of the gurus have a
link. If not, you might do a web search on Excel optimization or linear
programming techniques. One book that handles it well, in short order and
pretty directly, is quot;Excel Data Analysis amp; Business Modelingquot; by Wayne
Winston.

Once you read about the technique, try with a small problem (say, 10
stations) and work out your calculations at that level. Then go for the
whole enchilada.

Good luck, and HTH

quot;natskiquot; wrote:

gt;
gt; Hi,
gt;
gt; I work in a call center and I wanted to tackle our persistent
gt; problem of running out of work stations.
gt;
gt; I was given the task of providing a seating arrangement for the
gt; whole center (imagine 900 agents and 205 different start times and days
gt; off).
gt;
gt; They gave me a floor plan in excel.
gt;
gt; My question is can I automate plotting agents on work stations by
gt; teams with different start times and different days off AND sharing of
gt; work stations.
gt;
gt; Data available is individual schedules of agents, team groupings,
gt; floor plan all in excel.
gt;
gt; Thanks in advance!
gt;
gt;
gt; --
gt; natski
gt; ------------------------------------------------------------------------
gt; natski's Profile: www.excelforum.com/member.php...oamp;userid=21988
gt; View this thread: www.excelforum.com/showthread...hreadid=538793
gt;
gt;