Hi, I performed additional edit, and had to remove the price field to convey the story. Column A should be "address", Column B should be "status".
To clarify a point, "value" is a given and does not need to be forecast. the only forecast that is needed is the timing of when the unit transitions through its various statuses up until closing.
Although what I am most after is how to display the forecasted data into a concise activity report.
So assuming I have the right values, and I ahve the right forecast for timing of status transition, how can one report on the activity in the portfolio between say 2/28/2015 and 4/30/2015, with a restated inventory status at 4/30/2015
