Month 1 Month 2 Month 3 Month 4
50% 30% 20% 10%
Spud Date Budget 1/31/2012 2/29/2012 3/31/2012
2/15/2012 5000
Above is mock data. I am trying to build out a forecast.
So lets say the spud date is in february, I'd want the Budget amount (i.e. $5000) * Month 1 (i.e. 50%) to fall underneath the 2/29/2012, and Budget amount * Month 2 (i.e. 30%) to fall into the 3/31/2012 cell
However if the spud date changed to April...I'd want the data to begin to populated under 4/30/2012 (not displayed). Equation would then be Budget amount * Month 1, and then subsequent months calculated
Bookmarks