Semi Annual Counter

[Guest]

I am try to calculate semi annual masks in a model. My model has a switch
which turns the model into 1 of 4 modes (Annual, SA, Quaterly, Monthly) - the
first series. I want to be able to calculated the SA (Semi Annual) Period
Counter in all four scenarios. So when the first counter changes, I want to
semi annual counter to adjust as well.I know I have to use the MOD() function
but I can't seem to integrate so that it works in all four scenarios. The
idea being that is will use the series above it to generate the proper SA
periods. Can anyone provide a tip on this

The result should look like this below:

Annual Scenario
Annual Periods Couter 1 2 3 4 5 6 7
SA Periods Counter 2 2 2 2 2 2 2

SA Scenario
SA Periods Counter 1 2 3 4 5 6 7
SA Periods Counter 1 2 1 2 1 2 1

Quarterly Scenario
Quaterly Periods Counter1 2 3 4 5 6 7
SA Periods Counter 1 1 2 2 1 1 2

Monthly Scenario
Monthly Periods Counter 1 2 3 4 5 6 7
SA Periods Counter 1 1 1 1 1 1 2

Thanks

 

[Herbert Seidenberg]

Reduced to a general case, the task is to convert the
series {1,2,3,....,12} into

1 2 1 2 1 2 1 2 1 2 1 2
1 1 2 2 1 1 2 2 1 1 2 2
1 1 1 1 1 1 2 2 2 2 2 2

given a key of 2, 4 or 12.
For each row and its key, enter this array formula
=CEILING((MOD(series-1,key)+1)/key*2,1)