Hi, could you please help reconcile, edit, and calculate the Excel sheet named “Book One” using the source of truth from the “Multi-Year Report” Excel book? In “Book One,” the formulas are located at the top and pull data from below. Click the remaining amount or other areas at the top to see the formulas.
I need the remaining amount that’s crossed out to show $8,073, but I can’t find which commitment is missing. The total budget minus commitments equals the remaining amount. Once that’s complete, the right top side needs the YTD and prior years reconciled so the total across the years is correct. However, this doesn’t calculate into the remaining amount formula. The main focus is ensuring all commitments are included and the remaining amount is correct. I can’t seem to find the issue. Thanks.