The attached file is what I am trying to achieve.
Column C is a percentage WP (win probability)
Column D is the total estimated Rev
Column E is the award or start date
Column F is the end date (calculated by taking the POP (period of Performance) column G =+E2+(G2*30)
Column G is the POP
Columns K through O is what I'm trying to calculate. In the example April should be the start date the value is the estimated Rev (col D) * the WP (col C) spread evenly in accordance to the date ranges Col E and Col F.