# Rotation Pattern based on the Pattern String for scheduling tasks

1. ## Rotation Pattern based on the Pattern String for scheduling tasks

Previously I got help for the 4x4 rotation schedule based on 8 hours=1day.

I've a requirement to modify 4x4 rotating schedule using a String-based pattern to define the rotation. String pattern (DDDDXXXNNNXDDDXXXNNNXXXXXXX) X=skip days/off days, D/N = Schedule days/work days.
In this case 12 hours = 1 day.

I'm trying to figure out how this rotation can be handled with formula. 4 days work then skip 3 off days then 3 workday then skip 1 off day then 3 work day again skip 3 days then 3 days work and then skip a whole week. and this pattern goes on.

I've attached the workbook to show the sample data and expected outcome.

3. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

@Bo_Ry Thank you so much and appreciated that you give your valuable time to help me.
The formula is perfectly working for Finish date, but for start date it is returning same result as Finish date.

If cell value in B7 is changed from 2 to 5 then the cell value in E13 should be 8/3/19 (start date), because from B7 to B12 the sum of hours is 23 not 24. so the next task should start on 8/3/19 and finish will be 8/4/19(returned value of formula).

like the value returned in cell C13 for Start Date. I hope i'm clear in stating the situation. please see the pic below.

Attachment 690389

Thank you again!

5. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

Maybe try at Start data at C5

Formula:
`Please Login or Register  to view this content.`

6. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

woow! that worked as intended with little tweak, by removing -0.1 from
Formula:
`Please Login or Register  to view this content.`
.

stay blessed!

7. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

Sorry to bother you again @Bo_Ry, their is small error/wrong output at cell C9, if you put values in B7:B10 as 48,36,36,48. the value returned in C10 is 16-09-19 instead of 19-08-19.Attachment 690488

this happens only with these values.

8. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

try this at C7

``Please Login or Register  to view this content.``

9. ## Re: Rotation Pattern based on the Pattern String for scheduling tasks

Thanks for helping me out! stay blessed!

There are currently 1 users browsing this thread. (0 members and 1 guests)