Use valuations to produce cashflow report for project lifespan

[rochecompaan]

Refer to the Summary (1) sheet of the DCD Building Repairs spreadsheet on Dropbox. We want to produce a report similar to this, where each column will be represented by a valuation for the project.
One could use the existing valuation report as starting point and then extend it to show columns for all valuations for a given project. The only difference should be that the value shown for each valuation item must show only what is due on that valuation eg. if 10% was claimed for Waterproofing on valuation 1 and 30% on valuation 2, then valuation 2 must show the calculate the value for 20% (30% - 10% on first claim).

[nvernooy]

@rochecompaan I have a question about displaying the valuation items/budget groups. Different valuations on the same project can have different budget groups, like when a budget group is expanded/collapsed. How should this be handled when listing the valuation items in the report? Right now I just list the first level of budget groups in a project, like in the original spreadsheet, but then their valuation total sometimes needs to be calculated.

[nvernooy]

Also, what should the procedure be if the resulting percentage is negative? Like in your example, if valuation 2 was 5%, then it would be 5% - 10% = -5%.

[rochecompaan]

I think we should make an optimistic assumption that the budget groups are likely to stay the same and not vary much from valuation to valuation. It is likely that a new budget group is added to an approved project later on but I don't think that shouldn't cause any problems. The percentage shouldn't be negative, one can say the progress is 10% in valuation 1 and then 5% in valuation 2, but even if the user does reduce the estimate in a subsequent valuation I guess we should calculate a negative amount.

[rochecompaan]

I referred to the wrong sheet in the spreadsheet, please look at the sheet titled "Cashflow (2)" instead. The implementation for this sheet is much simpler since it simply lists the percentage and amount for each valuation in chronological order and there is no need to substract totals from each other.

[rochecompaan]

Take note that the current PDF report does not render correctly - there is hardly any space for the budget group name and we somehow have to find a solution to print valuations on a second or third page rather than trying to put it all on one page.