Calculating a rotating roster week

[anfo]

hi

I have 2 weeks defined, for say a roster, i then rotate based on the week i am up to, how can i calculate the week I will be on in the future?

22 weeks = week 1 roster
23 weeks = week 2 roster
24 weeks = week 1 roster

Hope it makes sense
any help appreciated

 

[Ishuda]

If I understand you correctly, you have two rosters and would like to use them every other week starting week 1 with the 2nd roster.

If that is the case, then you need something a date function which will give you, for example, the number of days since the start of week 1. Functions such as that are standard in some computer libraries and they are generally available in spreadsheets. So let
D(x) = number of days since beginning of week 1 including the present day, i.e day 1 is 1, day 2 is 2, etc.
and continue from there. Hint, what does the remainder of D(x) divided by 14 tell you.

 

[anfo]

If I understand you correctly, you have two rosters and would like to use them every other week starting week 1 with the 2nd roster.

If that is the case, then you need something a date function which will give you, for example, the number of days since the start of week 1. Functions such as that are standard in some computer libraries and they are generally available in spreadsheets. So let
D(x) = number of days since beginning of week 1 including the present day, i.e day 1 is 1, day 2 is 2, etc.
and continue from there. Hint, what does the remainder of D(x) divided by 14 tell you.

Hi yes you are right that's what's I'm trying to achieve I don't quite get your help. I can calculate the number of days quite easily but say it's 154 days I don't know how to go from there.

 

[Ishuda]

Hi yes you are right that's what's I'm trying to achieve I don't quite get your help. I can calculate the number of days quite easily but say it's 154 days I don't know how to go from there.

WEEK 1
Day 1 use roster (2), remainder 1
Day 2 use roster (2), remainder 2
...
Day 6 use roster (2), remainder 6
Day 7 use roster (2), remainder 7
WEEK 2
Day 8 use roster (1), remainder 8
Day 9 use roster (1), remainder 9
...
Day 13 use roster (1), remainder 13
Day 14 use roster (1), remainder 0
WEEK 3
Day 15 use roster (2), remainder 1
Day 16 use roster (2), remainder 2
...

154: So divide 154 by 14 to get 11 two week periods even. The remainder is zero (154=11*14+0) and you use the 14 day roster (number 1).

231: So divide 231 by 14 to get 16 two week periods plus 7 days (231 = 16*14 + 7). That means you use the 7 day roster (roster 2).

 

[anfo]

WEEK 1
Day 1 use roster (2), remainder 1
Day 2 use roster (2), remainder 2
...
Day 6 use roster (2), remainder 6
Day 7 use roster (2), remainder 7
WEEK 2
Day 8 use roster (1), remainder 8
Day 9 use roster (1), remainder 9
...
Day 13 use roster (1), remainder 13
Day 14 use roster (1), remainder 0
WEEK 3
Day 15 use roster (2), remainder 1
Day 16 use roster (2), remainder 2
...

154: So divide 154 by 14 to get 11 two week periods even. The remainder is zero (154=11*14+0) and you use the 14 day roster (number 1).

231: So divide 231 by 14 to get 16 two week periods plus 7 days (231 = 16*14 + 7). That means you use the 7 day roster (roster 2).

Hi

thank you, that got me over the line, i needed a little more to make it work with dynamic weeks, so if you have 3 or 4 week rosters, but got it all sorted i think now, thanks for the help