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 |
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) |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com