Need help creating a rotating schedule-HELP!!!

H

Hamilton71801

New Member
Joined
Jan 26, 2017
Messages
9
Bear with me, I can only do the basic formulas. These guys have rotating days off based on the colors associated with their routes. What I need help figuring out is how to make a years worth of these schedules where the computer automatically figures out the rotation and puts their NS days in. All I want to do is enter vacations and sick leave...I spend :20-:30 minutes figuring their days off and that's wasted time in my mind if the computer can do it for me.

Here is a color coded calendar:
Color Coded Rotating Day Off - Letter Carrier Calendar

Is this even doable or am I dreaming?
[TABLE="width: 672"]
<colgroup><col width="42" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1344;"> <col width="20" style="width: 15pt; mso-width-source: userset; mso-width-alt: 640;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3285;"> <col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 2944;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2368;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 2816;" span="2"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 2816;" span="2"> <col width="20" style="width: 15pt; mso-width-source: userset; mso-width-alt: 640;"> <tbody>[TR]
[TD="width: 42, bgcolor: transparent"][/TD]
[TD="width: 20, bgcolor: transparent"][/TD]
[TD="width: 112, bgcolor: transparent"][/TD]
[TD="width: 103, bgcolor: transparent"][/TD]
[TD="width: 92, bgcolor: transparent"][/TD]
[TD="width: 74, bgcolor: transparent"][/TD]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 20, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[TD="class: xl74, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl67, bgcolor: transparent"]ROUTES[/TD]
[TD="class: xl66, bgcolor: transparent"]CARRIER[/TD]
[TD="class: xl66, bgcolor: transparent"]SAT[/TD]
[TD="class: xl66, bgcolor: transparent"]SUN[/TD]
[TD="class: xl66, bgcolor: transparent"]MON[/TD]
[TD="class: xl66, bgcolor: transparent"]TUE[/TD]
[TD="class: xl66, bgcolor: transparent"]WED[/TD]
[TD="class: xl66, bgcolor: transparent"]THU[/TD]
[TD="class: xl69, bgcolor: transparent"]FRI[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl68, bgcolor: black"] [/TD]
[TD="class: xl65, bgcolor: black"] [/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]28-Jan-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]29-Jan-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]30-Jan-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]31-Jan-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]1-Feb-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]2-Feb-17[/TD]
[TD="class: xl80, bgcolor: #BFBFBF"]3-Feb-17[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl87, bgcolor: red"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl99, bgcolor: transparent"]4302[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]AL[/TD]
[TD="class: xl96, bgcolor: white"]AL[/TD]
[TD="class: xl96, bgcolor: white"]AL[/TD]
[TD="class: xl96, bgcolor: white"]AL[/TD]
[TD="class: xl96, bgcolor: white"]AL[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: black"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4303[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: brown"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4304[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl89, bgcolor: #00B0F0"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4305[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: black"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4306[/TD]
[TD="class: xl106, bgcolor: yellow"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl105, bgcolor: yellow"]FDOT[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl94, bgcolor: lime"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4307[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl90, bgcolor: yellow"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4308[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl94, bgcolor: lime"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4309[/TD]
[TD="class: xl106, bgcolor: yellow"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]C10[/TD]
[TD="class: xl96, bgcolor: white"]C10[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]C10[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl98, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4310 AUX[/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl81, bgcolor: black"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: red"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4311[/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: yellow"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]4312[/TD]
[TD="class: xl106, bgcolor: yellow"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl98, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl101, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl89, bgcolor: #00B0F0"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]T6[/TD]
[TD="class: xl106, bgcolor: yellow"] [/TD]
[TD="class: xl96, bgcolor: white"]C2[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]C2[/TD]
[TD="class: xl96, bgcolor: white"]C8[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]C7[/TD]
[TD="class: xl96, bgcolor: white"]C4[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: brown"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"]T6[/TD]
[TD="class: xl106, bgcolor: yellow"] [/TD]
[TD="class: xl96, bgcolor: white"]C11[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl96, bgcolor: white"]C3[/TD]
[TD="class: xl96, bgcolor: white"]C12[/TD]
[TD="class: xl96, bgcolor: white"]C5[/TD]
[TD="class: xl96, bgcolor: white"]C9[/TD]
[TD="class: xl96, bgcolor: white"]NS[/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl85, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl101, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: black"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl96, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl101, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl81, bgcolor: black"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: white"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: white"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent, colspan: 4"]Color coding matches rotating scheduled off day.[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Hi Hamilton71801 and welcome to MrExcel.

I notice there is one duplicate 'ROUTE' T6. The rotations are not the same. Can you fill in some more detail?
 
Upvote 0
I have 2 separate T6 positions, I deleted their names because I get nervous about privacy issues. This calendar allows for 2 off at a time.
 
Upvote 0
We'll need unique identifiers (fake of course). I am changing the second one to T7. Will that work?

Also
All I want to do is enter vacations and sick leave...
Click to expand...
are we to understand that anything not NS is to entered manually? I can't tell which of the others are which. I count 9 unique C-#s and and one FDOT. Are those them?
 
Upvote 0
Can you change it to T-6 and T6? You are correct, all blank cells will be entered manually...if it's blank, the regular carrier is on. All routes fall into the rotation except the AUX. I should have deleted FDOT before copy/pasting...that guy is working his day off Monday (full day overtime). That will also be entered manually.
 
Upvote 0
I left the T6s as they were. I put fake names in the carrier field. Since the day of the week headers were offset from their respective dates (ex. 28-Jan-17 is a Saturday) I wasn't sure what was a 'carrier'.

Could the colored cells to the left be identifiers?
Click to expand...
If you mean can they be identified by color? Not in formula. That would take some VBA. Can't help you there. I left the colors as is.
 
Upvote 0
Here's how the output looks now. If you see anything amiss please let me know. It likely will affect the formulas.

If this is a "Go" I will post the formulas and lookup tables.

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][td]
I​
[/td][td]
J​
[/td][td]
K​
[/td][td]
L​
[/td][/tr][tr][td]
1​
[/td][td][/td][td][/td][td="bgcolor:#FAFAFA"]ROUTES[/td][td="bgcolor:#FAFAFA"]CARRIER[/td][td="bgcolor:#FAFAFA"]SAT[/td][td="bgcolor:#FAFAFA"]SUN[/td][td="bgcolor:#FAFAFA"]MON[/td][td="bgcolor:#FAFAFA"]TUE[/td][td="bgcolor:#FAFAFA"]WED[/td][td="bgcolor:#FAFAFA"]THU[/td][td="bgcolor:#FAFAFA"]FRI[/td][td="bgcolor:#FAFAFA"][/td][/tr]
[tr][td]
2​
[/td][td="bgcolor:#FAFAFA"][/td][td][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#BFBFBF"]
28-Jan-17​
[/td][td="bgcolor:#BFBFBF"]
29-Jan-17​
[/td][td="bgcolor:#BFBFBF"]
30-Jan-17​
[/td][td="bgcolor:#BFBFBF"]
31-Jan-17​
[/td][td="bgcolor:#BFBFBF"]
1-Feb-17​
[/td][td="bgcolor:#BFBFBF"]
2-Feb-17​
[/td][td="bgcolor:#BFBFBF"]
3-Feb-17​
[/td][td][/td][/tr]
[tr][td]
3​
[/td][td="bgcolor:#FF0000"][/td][td][/td][td="bgcolor:#FAFAFA"]
4302​
[/td][td="bgcolor:#FAFAFA"]Bob[/td][td]NS[/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
4​
[/td][td="bgcolor:#000000"][/td][td][/td][td="bgcolor:#FAFAFA"]
4303​
[/td][td="bgcolor:#FAFAFA"]John[/td][td][/td][td]NS[/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
5​
[/td][td="bgcolor:#A52A2A"][/td][td][/td][td="bgcolor:#FAFAFA"]
4304​
[/td][td="bgcolor:#FAFAFA"]Mike[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][td]NS[/td][td][/td][/tr]
[tr][td]
6​
[/td][td="bgcolor:#00B0F0"][/td][td][/td][td="bgcolor:#FAFAFA"]
4305​
[/td][td="bgcolor:#FAFAFA"]Jacob[/td][td][/td][td]NS[/td][td][/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
7​
[/td][td="bgcolor:#000000"][/td][td][/td][td="bgcolor:#FAFAFA"]
4306​
[/td][td="bgcolor:#FFFF00"]Kelly[/td][td][/td][td]NS[/td][td="bgcolor:#FFFF00"][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
8​
[/td][td="bgcolor:#00FF00"][/td][td][/td][td="bgcolor:#FAFAFA"]
4307​
[/td][td="bgcolor:#FAFAFA"]Martha[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td]NS[/td][td][/td][td][/td][/tr]
[tr][td]
9​
[/td][td="bgcolor:#FFFF00"][/td][td][/td][td="bgcolor:#FAFAFA"]
4308​
[/td][td="bgcolor:#FAFAFA"]Joe[/td][td][/td][td]NS[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
10​
[/td][td="bgcolor:#00FF00"][/td][td][/td][td="bgcolor:#FAFAFA"]
4309​
[/td][td="bgcolor:#FFFF00"]Rachel[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td]NS[/td][td][/td][td][/td][/tr]
[tr][td]
11​
[/td][td="bgcolor:#FAFAFA"][/td][td][/td][td="bgcolor:#FAFAFA"]4310 AUX[/td][td="bgcolor:#000000"][/td][td][/td][td="bgcolor:#000000"][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
12​
[/td][td="bgcolor:#FF0000"][/td][td][/td][td="bgcolor:#FAFAFA"]
4311​
[/td][td="bgcolor:#FFFF00"]Liz[/td][td]NS[/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
13​
[/td][td="bgcolor:#FFFF00"][/td][td][/td][td="bgcolor:#FAFAFA"]
4312​
[/td][td="bgcolor:#FFFF00"]Elsie[/td][td][/td][td]NS[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
14​
[/td][td="bgcolor:#FAFAFA"][/td][td][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td="bgcolor:#000000"][/td][td][/td][/tr]
[tr][td]
15​
[/td][td="bgcolor:#00B0F0"][/td][td][/td][td="bgcolor:#FAFAFA"]T6[/td][td="bgcolor:#FFFF00"]JoAnne[/td][td][/td][td]NS[/td][td][/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]
16​
[/td][td="bgcolor:#A52A2A"][/td][td][/td][td="bgcolor:#FAFAFA"]T6[/td][td="bgcolor:#FFFF00"]Allen[/td][td][/td][td]NS[/td][td][/td][td][/td][td][/td][td][/td][td]NS[/td][td="bgcolor:#FAFAFA"][/td][/tr]
[/table]
 
Last edited:
Upvote 0
By the way I failed to ask a critical question. What version(s) of Excel does this have to work in?

What I have done only works in Excel 2010 or newer.
 
Last edited:
Upvote 0
This is what it normally look like when I post the schedule. I highlighted a few of the routes or the first post to identify the carriers that were on the OTDL (over time desired list), but I normally post it just like the one below. The days off are correct on yours...so you cracked the code to make the days rotate from week to week?
So, I guess it is doable?

[TABLE="width: 672"]
<colgroup><col width="42" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1344;"> <col width="20" style="width: 15pt; mso-width-source: userset; mso-width-alt: 640;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3285;"> <col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 2944;"> <col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2368;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 2816;" span="2"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 2816;" span="2"> <col width="20" style="width: 15pt; mso-width-source: userset; mso-width-alt: 640;"> <tbody>[TR]
[TD="width: 42, bgcolor: transparent"][/TD]
[TD="class: xl68, width: 20, bgcolor: white"] [/TD]
[TD="class: xl71, width: 112, bgcolor: white"] [/TD]
[TD="class: xl71, width: 103, bgcolor: white"] [/TD]
[TD="class: xl71, width: 92, bgcolor: white"] [/TD]
[TD="class: xl71, width: 74, bgcolor: white"] [/TD]
[TD="class: xl71, width: 88, bgcolor: white"] [/TD]
[TD="class: xl71, width: 88, bgcolor: white"] [/TD]
[TD="class: xl71, width: 80, bgcolor: white"] [/TD]
[TD="class: xl71, width: 88, bgcolor: white"] [/TD]
[TD="class: xl71, width: 88, bgcolor: white"] [/TD]
[TD="class: xl72, width: 20, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl65, bgcolor: transparent"]ROUTES[/TD]
[TD="class: xl64, bgcolor: transparent"]CARRIER[/TD]
[TD="class: xl64, bgcolor: transparent"]SAT[/TD]
[TD="class: xl64, bgcolor: transparent"]SUN[/TD]
[TD="class: xl64, bgcolor: transparent"]MON[/TD]
[TD="class: xl64, bgcolor: transparent"]TUE[/TD]
[TD="class: xl64, bgcolor: transparent"]WED[/TD]
[TD="class: xl64, bgcolor: transparent"]THU[/TD]
[TD="class: xl67, bgcolor: transparent"]FRI[/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: black"] [/TD]
[TD="class: xl63, bgcolor: black"] [/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]21-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]22-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]23-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]24-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]25-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]26-Jan-16[/TD]
[TD="class: xl78, bgcolor: #BFBFBF"]27-Jan-16[/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: red"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl98, bgcolor: transparent"]4302[/TD]
[TD="class: xl80, bgcolor: transparent"]Bob[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl87, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4303[/TD]
[TD="class: xl80, bgcolor: transparent"]Linda[/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: brown"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4304[/TD]
[TD="class: xl80, bgcolor: transparent"]Julie[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: #00B0F0"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4305[/TD]
[TD="class: xl80, bgcolor: transparent"]Carl[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl87, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4306[/TD]
[TD="class: xl80, bgcolor: transparent"]Earl[/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: lime"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4307[/TD]
[TD="class: xl80, bgcolor: transparent"]Hayden[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl89, bgcolor: yellow"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4308[/TD]
[TD="class: xl80, bgcolor: transparent"]Becky[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"]NS [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: lime"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4309[/TD]
[TD="class: xl80, bgcolor: transparent"]Debbie[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4310 AUX[/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl79, bgcolor: black"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl90, bgcolor: red"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4311[/TD]
[TD="class: xl80, bgcolor: transparent"]Leroy[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: yellow"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]4312[/TD]
[TD="class: xl80, bgcolor: transparent"]Gill[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"]NS [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl103, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl88, bgcolor: #00B0F0"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]T6[/TD]
[TD="class: xl80, bgcolor: transparent"]Archie[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: brown"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"]T6[/TD]
[TD="class: xl80, bgcolor: transparent"]Sam[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"]NS[/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: white"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl103, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl94, bgcolor: black"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl95, bgcolor: white"][/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl95, bgcolor: white"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl103, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl79, bgcolor: black"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 88, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"] [/TD]
[TD="class: xl74, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl96, bgcolor: transparent, colspan: 4"]Color coding matches rotating scheduled off day.[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
Personnel Roster using Macro's
Replies
0
Views
322
womeclr
W
M
  • Locked
  • Question Question
How to automatically rotate cashier name list base on working schedule?
Replies
1
Views
382
Fluff
Fluff
K
  • Solved
Help with Random Formulas
2
Replies
10
Views
2K
SanjayGMusafir
SanjayGMusafir
M
  • Question Question
Finding value in a row
Replies
4
Views
994
MRN227
M
M
  • Question Question
How to rotate name list?
Replies
1
Views
654
Manith
M

Forum statistics

Threads
1,223,320
Messages
6,171,432
Members
452,402
Latest member
siduslevis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top