I need a 7 day a week roster for staf rotating through 4 location

[Gordon]

I'm running 2003 Excel. I need to monitor rig locations and staff assigned
to the various rigs (4 rigs) Staff roster in & out over a 6 week period

 

[Pecoflyer]

Hi,
what have you tried and where did it go wrong?