Yes – into Overview, Budget, Expenses and Revenues. All of that is predicted money, and not all expenses would have to be predicted at the start of the project. But the more the better for the cash flow prediction chart.
Right. Currently, all associated expenses from sheet "Expenses" are included in the "Spent" sums. In the future, we'll only include those marked as "Paid" (or as "Authorized", if we decide to remove the "Paid" column altogether from the spreadsheet).
Not really, this is just not filled as intended. The D4 cell with "Alberto" in it should be empty here. Anyway, the budget items-and-subitems / subtotals mechanism will change again, as the way it is it breaks too easily …
I fixed two mistakes in that formula compared to the version you saw, but its task stays the same: it sums up all expenses from sheet "Expenses" that refer to the budget item using the item's name (as shown in column "Item Ref"). Ask @anu for details, she made this
Confirmed. It will use all the planned expenses and turnover as entered into the "Expenses" and "Revenues" records. It's ok to enter them / correct them as more information comes in, but yes, whatever is available at the beginning of a project should be entered already.
Rather the info in the "Expenses" and "Revenues" sheets of all spreadsheet files of our projects. You'd mix them all together into a sheet equivalent to ChartData1, then convert that again to a sheet like ChartData2 to make it ready to plot, and then plot a cash flow prediction graph as on the "Overview" sheet. Just not for one project but all of them "overlaid".
Hope this helps! You can also work with Anu to create the right formulas etc., she learned a lot about Google Sheets by now.