I have a row in my life cycle cost estimate (20 year projection) that needs to follow the following command:
It should be zeroed out every year, except on acquisition years, and every 5th years. Essentially, I would like it so when I change the acquisition years, it will follow the above command.
for example: (3 year acquisition cycle)
FY1 FY2 FY3 FY4 FY5 FY6 FY7 FY8 FY9 FY10 FY11
100 0 0 100 0 100 100 0 0 100 100
*If i changed the acquisition cycle to 4 years, it would follow:
FY1 FY2 FY3 FY4 FY5 FY6 FY7 FY8 FY9 FY10 FY11
100 0 0 0 100 100 0 0 100 0 100
I would give a dummy book, but I don't even know where to go with this formula...
Any help would be much appreciated!
Bookmarks