Spreadsheet: 869120d1715771231-creating-the-same-graphs-for-multiple-sheets-on-new-tabs-programme-dashboard-template-to-share
Sheet: A

 |  |  | PMO Period |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | 2029/30 | Contingency | Total | AFC exc Contingency | Approved Funding | Allocation
Future Transport Zones - Data Hub |  | Prior years |  |  |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312
Cost Centre |  |  |  | Quarter |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
KCT101 |  | 1451000 |  | Q1 | Baseline | 150000 | 1000 | 100000 | 45000 | 2000 | 2000 | 153020 | 47000 | 12000 | 102020 | 102020 | 5020 |  | 1352200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
202312 |  | 1451000 | 202301 |  | Apr | 150000 | 1000 | 100000 | 45000 | 2000 | 2000 | 153020 | 47000 | 12000 | 102020 | 102020 | 5020 |  | 1352200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202302 |  | May | 88000 | 2000 | 150000 | 45000 | 3000 | 2000 | 153020 | 47000 | 12000 | 107020 | 107020 | 5020 |  | 1352200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202303 | Q2 | Jun | 88000 | 0 | 150000 | 45000 | 3000 | 2000 | 153020 | 47000 | 12000 | 107020 | 107020 | 5020 |  | 1352200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
Previous Period |  | 1451000 | 202304 |  | Jul | 88000 | 0 | 65000 | 60000 | 3000 | 2000 | 153020 | 47000 | 12000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
Feb |  | 1451000 | 202305 |  | Aug | 88000 | 0 | 65000 | 52666 | 3000 | 2000 | 153020 | 110000 | 12000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202306 | Q3 | Sep | 88000 | 0 | 65000 | 52666 | 1688 | 2000 | 153020 | 110000 | 12000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202307 |  | Oct | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 168020 | 110000 | 12000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202308 |  | Nov | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 97000 | 12000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202309 | Q4 | Dec | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 32665 | 30000 | 107020 | 107020 | 5020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202310 |  | Jan | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 32665 | 8542 | 107020 | 107020 | 30020 |  | 1422200 | 0 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202311 |  | Feb | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 32665 | 8542 | 65213 | 107020 | 30020 |  | 1422200 | 10000 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  | 1451000 | 202312 |  | Mar | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 32665 | 8542 | 65213 | 101568 | 30020 |  | 1422200 | 20000 | 0 | 0 | 0 | 1389901 |  |  | 3600000 | 4000000
 |  |  |  |  | Actual | 88000 | 0 | 65000 | 52666 | 1688 | 0 | 186312 | 32665 | 8542 | 65213 | 101568 | 4000
 |  |  | Stages (Lifetime) |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  |  |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | SOBC | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000 | 289000
 |  |  |  | OBC | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280 | 1266280
 |  |  |  | FBC | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000
 |  |  |  | Delivery | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000 | 160000
 |  |  |  | Post Completion | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000 | 237000
 |  |  |  | Revenue | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000 | 62000
 |  |  |  | Total
 |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  | Approved funding |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | Prior Years | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  |  |  | Current Year | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000
 |  |  |  | 2025/26 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000 | 3000000
 |  |  |  | 2026/27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2027/28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2028/29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2029/30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  |  | Contingency |  | Baseline | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  | Prior Years | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901 | 294901
 |  |  |  | Current Year | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 |  |  |  | 2025/26 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000 | 995000
 |  |  |  | 2026/27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2027/28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2028/29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 2029/30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Graph 1 - Cumulative In Year Spend
 |  |  |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | [NAME]
 |  |  |  |  | Actuals
 |  |  |  |  | Baseline
 |  |  |  |  | Prior Month
 |  |  |  |  | Current Month
 |  |  |  |  | [NAME] Breakdown
 |  |  |  |  | Spent
 |  |  |  |  | Current Year Forecast
 |  |  |  |  | Future Year Forecast
 |  |  |  |  | Contingency
 |  |  |  |  | [NAME]
 |  |  |  |  |  | Prior Years | 2023/24 | 2024/25 | 2025/26 | 2026/27 | 2027/28 | 2028/29 | Total
 |  |  |  |  | Baseline
 |  |  |  |  | Prior Month
 |  |  |  |  | Current Month
 |  |  |  |  | Workings for Quarter Actuals vs Foreacst
 |  |  |  |  |  | Month 1 | Month 2 | Month 3
 |  |  |  |  | Actuals
 |  |  |  |  | As in Dec
 |  |  |  |  | Graph - AFC Movement
 |  |  |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | [NAME]
 |  |  |  |  | AFC