I would like to make a calculation that would do what the image is describing is this even possible?
Added the workbook.
To clarify I need to take the numbers from the three columns circled and ad the values of the calculations to the current and 1-30 based on percentages specified above. while keeping the same view.