I have no idea how to accomplish tis but I am sure that it is possible in
Excel.

I have data that tells me for each day of the week for thre months how many
visitors I get to the area. I have 5 staff and I also know how much time they
are utilised for the day. ie they are kept busy say 20% of the time as a
group for the visitor load on a Monday.

Can I use tis info in a spread sheet to do 'what if' such that if I get an
increase in visitors what utilisation I will get from the 5 staff -
conversely if I have 3 staff with the same visitors what utilisation do I now
get from the staff?

Your Assistance appreciated.

Mike