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...