Spilled Array based on different Time Periods and applied periods – Help Needed
I have another issue that I can’t solve. Most info is in the attached example sheet
I have a set of time periods start and end dates in rows across the top running from a few historic years to a few forecast years. These are the dates to work off.
In the left hand column I have the start and end dates of different expenses and a column showing applied periods. The idea being that the expenses will start on the start period, end on the end period and occur based on the applied period. SO one starting on 1st Feb 2022 with applied period of 3 would occur on 1st Feb 22, 1st May 22, 1st Aug 22 etc – once every 3 months from the starting period till the ending period.
These can be either flags – 1 or 0 or show the applied period of say 1,3,6 etc. Ultimately these will be multiplied by the monthly amount so numbers may be more useful as that will already have the number of months to multiply by the monthly amount. This calc will come later so only need the flag or counter at this stage.
Example sheet attached. I want this a single spilled array
Note the time periods at the top will vary
Many thanks in advance. There are some super smart contributors here.
I have another issue that I can’t solve. Most info is in the attached example sheetI have a set of time periods start and end dates in rows across the top running from a few historic years to a few forecast years. These are the dates to work off.In the left hand column I have the start and end dates of different expenses and a column showing applied periods. The idea being that the expenses will start on the start period, end on the end period and occur based on the applied period. SO one starting on 1st Feb 2022 with applied period of 3 would occur on 1st Feb 22, 1st May 22, 1st Aug 22 etc – once every 3 months from the starting period till the ending period.These can be either flags – 1 or 0 or show the applied period of say 1,3,6 etc. Ultimately these will be multiplied by the monthly amount so numbers may be more useful as that will already have the number of months to multiply by the monthly amount. This calc will come later so only need the flag or counter at this stage.Example sheet attached. I want this a single spilled arrayNote the time periods at the top will vary Many thanks in advance. There are some super smart contributors here. Read More
