Help with coverage calendar

T

Top Spin

I have three teams: the blue team, the red team, and the green team.
Each team is "on duty" for one or more 4-hour blocks. The cycle
repeats every two weeks.

I need to create a "coverage calendar". This is a linear map of a
two-week span of time in 4-hour blocks. It's kinda hard to explain
without a diagram.

Hierarchically, it's three nested tables. The outer table is a 1 x 2
where the 1st cell represents week 1 and the 2nd cell represents week
2. Inside each cell is a 1 x 7 table where each cell represents a day
of the week. Inside each of those 7 cells is a 1 x 6 table
representing the 6 4-hour blocks in a day.

Without the nesting, it's a 1 x 84 table.

Ideally, there would be a bold border around the entire table and
between the weeks (42 cells each), a lighter border between each day
(6 cells each), and then a dotted border between the 4-hour cells.

I realize that on an 8.5" page, even if I use 8", each cell will be
about .09" wide. That's OK as I don't need to put any text in them --
just color them red, blue, or green.

I found a table shape, but am having a little trouble getting to
behave. Is that the way to go?

I was also thinking of just defining tiny rectangles in each color and
then placing groups of them as I need.

I'd appreciate any suggestions for ways to proceed.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top