I'm trying to format work schedules in google spreadsheets in a way that makes them easy to process. I have a sheet that will tell you who is supposed to be here on what day, who was gone, and interval counts. The biggest hangup is the requirement that historical schedules need to be maintained and accessible through the other sheet that displays the intervals for that day.
A single person's schedule needs to be able to be changed at any time, or any number of times, and all of the previous schedules for that individual need to be maintained.
I've puzzled through a variety of formats and it ends up either being extremely hard to add data to (adding/editing a schedule), or extremely difficult to pull data from (to count intervals and see who is scheduled on what day).
I do, with a little work, pull schedule data from this and put it on display. However, I cannot maintain any historical schedules with this format.
This is MUCH easier to pull data from, and I could have new schedules added that would replace old ones while maintaining historical schedules. However, this would be a nightmare for data entry, and would not be acceptable.