+ Reply to Thread
Results 1 to 2 of 2

Semi Annual Counter

  1. #1
    ExcelMonkey
    Guest

    Semi Annual Counter

    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

  2. #2
    Herbert Seidenberg
    Guest

    Re: Semi Annual Counter

    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)


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1