Frequency and Future Planning

Hi everyone,

I know this is probably really simple and I am just overlooking something.

What I am trying to do is predict furture spendings and planning for maintenance for a proposed budget. What I have is multiple maintenance plans that use a qty of materials. These plans are set at different monthly periods and I need to be able to propose a budget for the next say 200 months.

What I am hoping is possible, is that I can create a formula that will look at the frequency in colum A, look at the month offset in row B2 and onwards and put the QTY in the corresponding months with the allowance to offset as I have manually put in for the 2 month plans.

Is this possible?

Frequency and future planning.xlsx

I am not clear about requirement.See attached file.
In D7,

Please Login or Register  to view this content.

Formula can be copied to all other cells

Thanks for the prompt reply.

Looking at what you have supplied. It looks to be what I am after.

Also what I would like to be able to do is manipulate the start period of the plans.
ie. First call for the 8 month falls on the 8th month or when we would like. 24 on the 24th etc.

Is this possible?

The plan number colum was only to indicate multiple options available on the same maintenance planning frequency. I think it may be better to have maybe a start month in there or something or remove it all together?

Pl upload file with expected results with different conditions you are expressing.

Frequency and future planning.xlsx

I have added some extra details. I have left the formula in that you provided before. I have change the name of the colum to give an idea of what I would like to be bale to do with that colum. This colum will be a manual enter colum if we need to be able to adjust plans to suit.

Hope this helps?

Pl see file.

Worked a treat. Thanks for the help.

Thanks for the compliment.Pl mark thread solved.

I felt it is very difficult to explain the formula or the answer without opening the workbook in this case. Wherever it is possible for me I am trying explaining the answer.
Thanks for the suggestion.