Spreadsheet: 841748d1693919006-help-with-line-graph-visualisation-line-graph-test
Sheet: EV DASHBOARD

 |  |  |  |  |  |  |  | PROJECT PERFORMANCE  (+52 week lookahead) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Progress W.E |  |  |  |  |  |  | 2023-08-25 00:00:00
 | Project Performance Figures
 |  |  |  | Week No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 |  |  |  | Day | 2023-07-28 00:00:00 | 2023-08-04 00:00:00 | 2023-08-11 00:00:00 | 2023-08-18 00:00:00 | 2023-08-25 00:00:00 | 2023-09-01 00:00:00 | 2023-09-08 00:00:00 | 2023-09-15 00:00:00 | 2023-09-22 00:00:00 | 2023-09-29 00:00:00 | 2023-10-06 00:00:00 | 2023-10-13 00:00:00 | 2023-10-20 00:00:00 | 2023-10-27 00:00:00 | 2023-11-03 00:00:00 | 2023-11-10 00:00:00 | 2023-11-17 00:00:00 | 2023-11-24 00:00:00 | 2023-12-01 00:00:00 | 2023-12-08 00:00:00 | 2023-12-15 00:00:00 | 2023-12-22 00:00:00 | 2023-12-29 00:00:00 | 2024-01-05 00:00:00 | 2024-01-12 00:00:00 | 2024-01-19 00:00:00 | 2024-01-26 00:00:00 | 2024-02-02 00:00:00 | 2024-02-09 00:00:00 | 2024-02-16 00:00:00 | 2024-02-23 00:00:00 | 2024-03-01 00:00:00 | 2024-03-08 00:00:00 | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00 | 2024-04-12 00:00:00 | 2024-04-19 00:00:00 | 2024-04-26 00:00:00 | 2024-05-03 00:00:00 | 2024-05-10 00:00:00 | 2024-05-17 00:00:00 | 2024-05-24 00:00:00 | 2024-05-31 00:00:00 | 2024-06-07 00:00:00 | 2024-06-14 00:00:00 | 2024-06-21 00:00:00 | 2024-06-28 00:00:00 | 2024-07-05 00:00:00 | 2024-07-12 00:00:00 | 2024-07-19 00:00:00
 |  |  |  | Month / Year | 2023-07-28 00:00:00 | 2023-08-04 00:00:00 | 2023-08-11 00:00:00 | 2023-08-18 00:00:00 | 2023-08-25 00:00:00 | 2023-09-01 00:00:00 | 2023-09-08 00:00:00 | 2023-09-15 00:00:00 | 2023-09-22 00:00:00 | 2023-09-29 00:00:00 | 2023-10-06 00:00:00 | 2023-10-13 00:00:00 | 2023-10-20 00:00:00 | 2023-10-27 00:00:00 | 2023-11-03 00:00:00 | 2023-11-10 00:00:00 | 2023-11-17 00:00:00 | 2023-11-24 00:00:00 | 2023-12-01 00:00:00 | 2023-12-08 00:00:00 | 2023-12-15 00:00:00 | 2023-12-22 00:00:00 | 2023-12-29 00:00:00 | 2024-01-05 00:00:00 | 2024-01-12 00:00:00 | 2024-01-19 00:00:00 | 2024-01-26 00:00:00 | 2024-02-02 00:00:00 | 2024-02-09 00:00:00 | 2024-02-16 00:00:00 | 2024-02-23 00:00:00 | 2024-03-01 00:00:00 | 2024-03-08 00:00:00 | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00 | 2024-04-12 00:00:00 | 2024-04-19 00:00:00 | 2024-04-26 00:00:00 | 2024-05-03 00:00:00 | 2024-05-10 00:00:00 | 2024-05-17 00:00:00 | 2024-05-24 00:00:00 | 2024-05-31 00:00:00 | 2024-06-07 00:00:00 | 2024-06-14 00:00:00 | 2024-06-21 00:00:00 | 2024-06-28 00:00:00 | 2024-07-05 00:00:00 | 2024-07-12 00:00:00 | 2024-07-19 00:00:00
 | M&E Only In Period | Planned Manhours (PM) |  |  | 604.29 | 1027.96 | 1617.86 | 2334.26 | 3037.82 | 3941.03 | 3462.53 | 4473.42 | 7020.459999999999 | 6422.68 | 6457.26 | 5741.43 | 5834.02 | 6747.22 | 6513.290000000001 | 7065.51 | 6860.32 | 5733.93 | 5827.15 | 4003.59 | 5097.77 | 5053.57 | 0 | 0 | 4460.65 | 4648.83 | 5319.950000000001 | 4473.43 | 4221 | 4964.2 | 5138.98 | 3723.57 | 3352.03 | 3346.74 | 3658.059999999999 | 3834.31 | 3757.14 | 2940.13 | 2338.9 | 1894.06 | 1577.71 | 1292.79 | 1070.11 | 779.53 | 594.85 | 324.53 | 163.21 | 61.54 | 18.46 | 0 | 0 | 0
 |  | Latest Programme Manhours Remaining |  |  |  |  |  |  |  | 3941 | 3462.53 | 4473.42 | 7020.459999999999 | 6422.68 | 6457.26 | 5741.43 | 5834.02 | 6747.22 | 6513.290000000001 | 7065.51 | 6860.32 | 5733.93 | 5827.15 | 4003.59 | 5097.77 | 5053.57 | 0 | 0 | 4460.65 | 4648.83 | 5319.950000000001 | 4473.43 | 4221 | 4964.2 | 5138.98 | 3723.57 | 3352.03 | 3346.74 | 3658.059999999999 | 3834.31 | 3757.14 | 2940.13 | 2338.9 | 1894.06 | 1577.71 | 1292.79 | 1070.11 | 779.53 | 594.85 | 324.53 | 163.21 | 61.54 | 18.46 | 0 | 0 | 0
 |  | Earned Manhours (EM) |  |  | 604.29 | 1027.96 | 1234.17 | 5189.4 | 2847
 |  | Actual [NAME] (AM) |  |  | 2140 | 2072 | 2034 | 3195 | 3601
 |  | Forecast Manhours (FM) |  |  |  |  |  |  |  | 5733.392901272704 | 5037.311576362287 | 6507.961043494377 | 10213.41170455949 | 9343.75740145805 | 9394.06461448165 | 8352.670389534163 | 8487.370934758432 | 9815.900342888915 | 9475.577429568762 | 10278.95074292598 | 9980.438971951067 | 8341.759339861608 | 8477.37641325837 | 5824.449247806746 | 7416.269558569133 | 7351.967105832199 | 0 | 0 | 6489.38316291857 | 6763.148673236128 | 7739.498494068948 | 6507.975591560607 | 6140.738755714814 | 7221.951037934015 | 7476.222139503272 | 5417.074297232175 | 4876.555444519955 | 4868.859517484245 | 5321.76991535895 | 5578.17958266403 | 5465.912155566538 | 4277.32059650315 | 3402.647210552328 | 2755.491032373656 | 2295.262957185221 | 1880.759454157914 | 1556.803115346596 | 1134.065406833065 | 865.3917196960334 | 472.1283933646361 | 237.4389889410601 | 89.52879957988384 | 26.85573026071913 | 0 | 0 | 0 |  |  |  | uplift
 | M&E Only Cumulative | Cumulative Planned Manhours (PM) |  |  | 22026.3 | 23054.26 | 24672.12 | 27006.38 | 30044.2 | 33985.23 | 37447.76 | 41921.18 | 48941.64 | 55364.32 | 61821.58 | 67563.01000000001 | 73397.03000000001 | 80144.25000000001 | 86657.54000000001 | 93723.05 | 100583.37 | 106317.3 | 112144.45 | 116148.04 | 121245.81 | 126299.38 | 126299.38 | 126299.38 | 130760.03 | 135408.86 | 140728.81 | 145202.24 | 149423.24 | 154387.44 | 159526.42 | 163249.99 | 166602.02 | 169948.76 | 173606.82 | 177441.13 | 181198.27 | 184138.4 | 186477.3 | 188371.36 | 189949.07 | 191241.86 | 192311.97 | 193091.5 | 193686.35 | 194010.88 | 194174.09 | 194235.63 | 194254.09 | 194254.09 | 194254.09 | 194254.09
 |  | Cumulative Earned Manhours (EM) |  |  | 22073.47 | 23101.43 | 24335.60000000001 | 29525.00000000001 | 32372.00000000001
 |  | Cumulative Actual Manhours (AM) |  |  | 36193 | 38265 | 40299 | 43494 | 47095
 |  | Forecast Manhours (FM) |  |  |  |  |  |  | 47095 | 52828.3929012727 | 57865.70447763499 | 64373.66552112937 | 74587.07722568886 | 83930.8346271469 | 93324.89924162856 | 101677.5696311627 | 110164.9405659211 | 119980.8409088101 | 129456.4183383788 | 139735.3690813048 | 149715.8080532559 | 158057.5673931175 | 166534.9438063758 | 172359.3930541826 | 179775.6626127517 | 187127.6297185839 | 187127.6297185839 | 187127.6297185839 | 193617.0128815025 | 200380.1615547386 | 208119.6600488076 | 214627.6356403682 | 220768.374396083 | 227990.325434017 | 235466.5475735203 | 240883.6218707525 | 245760.1773152724 | 250629.0368327567 | 255950.8067481156 | 261528.9863307796 | 266994.8984863461 | 271272.2190828493 | 274674.8662934016 | 277430.3573257753 | 279725.6202829605 | 281606.3797371184 | 283163.182852465 | 284297.248259298 | 285162.6399789941 | 285634.7683723588 | 285872.2073612998 | 285961.7361608797 | 285988.5918911404 | 285988.5918911404 | 285988.5918911404 | 285988.5918911404