Spreadsheet: 735961d1623279180-help-on-calculating-deposit-amounts-based-on-percentages-and-adding-totals-for-each-month-example-summary-sheet-calculation
Sheet: Forecast Summary

Number Of Jobs |  |  |  | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | Stage 6 |  |  | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024
Project Name | Start Date | Finish Date | Amount | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | Stage 6 | Status |  | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4 | Total | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4 | Total | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4 | Total | Q1 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q4 | Total
Project Name | Start Date | Finish Date | Total Amount | 0.2 | 0.2 | 0.25 | 0.25 | 0.04999999999999993 | 0.01 | Status |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021 Q1 Total | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021 Q2 Total | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021 Q3 Total | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2021 Q4 Total | 2021 Total | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022 Q1 Total | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022 Q2 Total | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022 Q3 Total | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022 Q4 Total | 2022 Total | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023 Q1 Total | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023 Q2 Total | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023 Q3 Total | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023 Q4 Total | 2023 Total | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024 Q1 Total | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024 Q2 Total | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024 Q3 Total | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024 Q4 Total | 2024 Total
Job 1 | 2021-04-28 00:00:00 | 2021-08-26 00:00:00 | 1000000 | 2021-05-18 00:00:00 | 2021-06-07 00:00:00 | 2021-07-07 00:00:00 | 2021-07-27 00:00:00 | 2021-08-26 00:00:00 | 2021-08-26 00:00:00 | Confirmed |  |  |  |  |  |  |  |  |  | 500000
Job 2 | 2021-04-28 00:00:00 | 2021-09-15 00:00:00 | 500000 | 2021-06-07 00:00:00 | 2021-06-27 00:00:00 | 2021-07-27 00:00:00 | 2021-08-16 00:00:00 | 2021-09-15 00:00:00 | 2021-09-15 00:00:00 | Confirmed |  |  |  |  |  |  |  |  |  |  |  | 30000
Job 3 | 2021-05-12 00:00:00 | 2021-10-14 00:00:00 | 1500000 | 2021-06-21 00:00:00 | 2021-07-21 00:00:00 | 2021-08-20 00:00:00 | 2021-09-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | Confirmed
Job 4 | 2021-06-10 00:00:00 | 2021-10-08 00:00:00 | 750000 | 2021-06-30 00:00:00 | 2021-07-20 00:00:00 | 2021-08-19 00:00:00 | 2021-09-08 00:00:00 | 2021-10-08 00:00:00 | 2021-10-08 00:00:00 | Confirmed
Job 5 | 2021-06-28 00:00:00 | 2021-10-26 00:00:00 | 650000 | 2021-07-18 00:00:00 | 2021-08-07 00:00:00 | 2021-09-06 00:00:00 | 2021-09-26 00:00:00 | 2021-10-26 00:00:00 | 2021-10-26 00:00:00 | Confirmed