KC
You are the only person who knows what you are talking about. For
instance, what is the significance of the dates? What does "Staff A"
represent?
You say that you want to spread the workload more evenly. How does this
need relate to the data you show. Or visa versa? HTH Otto
"KC" wrote in message
...
We have thousand of customers while they have different
peak seasons. Some of them have more business in summer
and some of them have more business in winter. How to re-
assign these customers to CS staff so that their workload
will be more evenly, but not someone's very busy in summer
but idle in winter.

My raw data looks like following:
Customer A 12/15/2005 Staff A
Customer C 12/15/2005 Staff C
Customer A 12/15/2005 Staff A
Customer A 12/16/2005 Staff A
Customer B 12/16/2005 Staff B
Customer A 12/17/2005 Staff A
Customer A 12/17/2005 Staff A
Customer A 12/17/2005 Staff C