Problems found when the workbook was imported. Work through them so the plan the team follows is correct.
0/459
Reviewed
459 issues still open
189
Warnings to decide
Need someone who knows the plant
14
Dates ready to correct
One click each
Annual group '54G1 Annual Mtce' appears 3 times in the 2026 plan (months 5, 7, 11).
Annual group '54G1 Annual Mtce' appears 3 times in the 2026 plan (months 5, 7, 11).
Annual group '54G1 Annual Mtce' appears 3 times in the 2026 plan (months 5, 7, 11).
'Power Transformer 54T3' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears (3S Bus)' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Unit 3 Aux. Power Panel' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears (3S Bus)' refers to unit 3 but sits under '54G2 4th Quarterly Mtce'.
'Unit 3 Aux. Power Panel' refers to unit 3 but sits under '54G2 4th Quarterly Mtce'.
'Station Service Switchgears (2S Bus)' refers to unit 2 but sits under '54G1 4th Quarterly Mtce'.
'Unit 2 Aux. Power Panel' refers to unit 2 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears(3S Bus)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Unit 3 Auxiliary Power Panels' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer (54T3)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Station Service Switchgears(3S Bus)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Unit 3 Auxiliary Power Panels' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer (54T3)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
Planned finish 2026-12-12 does not match the source plan, where 'Tue 09/12/25' reads as 2025-12-09.
2026-12-122026-12-09
Planned start 2026-12-12 does not match the source plan, where 'Tue 0912/25' reads as 2025-12-09.
2026-12-122026-12-09
Planned finish 2026-12-12 does not match the source plan, where 'Thu o4//12/25' reads as 2025-12-04.
2026-12-122026-12-04
Planned start 2026-12-12 does not match the source plan, where 'Thu 0412/25' reads as 2025-12-04.
2026-12-122026-12-04
Planned start 2026-11-11 does not match the source plan, where 'Tue 2511/25' reads as 2025-11-25.
2026-11-112026-11-25
Planned start 2026-10-10 does not match the source plan, where 'Thu 0910/25' reads as 2025-10-09.
2026-10-102026-10-09
Planned finish 2026-10-10 does not match the source plan, where 'Thu 02/10/25' reads as 2025-10-02.
2026-10-102026-10-02
Planned start 2026-10-10 does not match the source plan, where 'Thu 0210/25' reads as 2025-10-02.
2026-10-102026-10-02
Planned finish 2026-10-10 does not match the source plan, where 'Thu 0210/25' reads as 2025-10-02.
2026-10-102026-10-02
Planned start 2026-09-09 does not match the source plan, where 'Wed 1809/25' reads as 2025-09-18.
2026-09-092026-09-18
Planned start 2026-08-08 does not match the source plan, where 'Tue 1208/25' reads as 2025-08-12.
2026-08-082026-08-12
Planned start 2026-08-08 does not match the source plan, where 'Tue 1208/25' reads as 2025-08-12.
2026-08-082026-08-12
Planned finish 2026-08-08 does not match the source plan, where 'Mon 0408/25' reads as 2025-08-04.
2026-08-082026-08-04
Planned start 2026-06-06 does not match the source plan, where 'Wed 1106/25' reads as 2025-06-11.
2026-06-062026-06-11
'50kVA Transformer @ Zenith Bank (JT03)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 93).
'50kVA Street Light Transformer 2 (JT02)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 92).
'50kVA Street Light Transformer 1 (JT01)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 91).
'200kVA Transformer near Warehouse (F1T03)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 90).
'50kVA Transformer @ Y-junction (F1T02)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 89).
Group '54G1 3rd Quarterly Mtce' repeats row 403 exactly (same dates and tasks).
Annual group '54G1 Annual Mtce' appears 3 times in the 2025 plan (months 5, 7, 11).
Annual group '54G1 Annual Mtce' appears 3 times in the 2025 plan (months 5, 7, 11).
Annual group '54G1 Annual Mtce' appears 3 times in the 2025 plan (months 5, 7, 11).
'Power Transformer 54T3' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears (3S Bus)' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Unit 3 Aux. Power Panel' refers to unit 3 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears (3S Bus)' refers to unit 3 but sits under '54G2 4th Quarterly Mtce'.
'Unit 3 Aux. Power Panel' refers to unit 3 but sits under '54G2 4th Quarterly Mtce'.
'Station Service Switchgears (2S Bus)' refers to unit 2 but sits under '54G1 4th Quarterly Mtce'.
'Unit 2 Aux. Power Panel' refers to unit 2 but sits under '54G1 4th Quarterly Mtce'.
'Station Service Switchgears(3S Bus)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Unit 3 Auxiliary Power Panels' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer (54T3)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G3 2nd Quarterly Mtce'.
'Station Service Switchgears(3S Bus)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Unit 3 Auxiliary Power Panels' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer (54T3)' refers to unit 3 but sits under '54G1 Annual Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Power Transformer 54T1' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Station Service Switchgears (1S Bus)' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
'Unit 1 Aux. Power Panel' refers to unit 1 but sits under '54G2 1st Quarterly Mtce'.
Planned finish could not be read (unparseable date text).
Planned start could not be read (unparseable date text).
Planned finish could not be read (unparseable date text).
Planned start read as 2025-11-12 (typo in date text; month 12->11). The day may also be stale; please confirm.
Planned finish read as 2025-11-12 (month 12->11). The day may also be stale; please confirm.
Planned start read as 2025-09-15 (typo in date text; month 6->9). The day may also be stale; please confirm.
Planned start read as 2025-09-15 (month 6->9). The day may also be stale; please confirm.
Planned finish read as 2025-08-05 (typo in date text; month 7->8). The day may also be stale; please confirm.
Planned finish read as 2025-06-11 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-11 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-10 (month 4->6). The day may also be stale; please confirm.
Planned start read as 2025-06-10 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-09 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-09 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-09 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-08 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-08 (month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-13 (typo in date text; month 1->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-13 (typo in date text; month 1->6). The day may also be stale; please confirm.
Planned finish read as 2025-06-13 (typo in date text; month 4->6). The day may also be stale; please confirm.
Planned finish read as 2025-05-11 (month 2->5). The day may also be stale; please confirm.
Planned finish read as 2025-05-06 (month 2->5). The day may also be stale; please confirm.
Planned finish read as 2025-05-05 (month 2->5). The day may also be stale; please confirm.
Planned finish read as 2025-05-05 (month 2->5). The day may also be stale; please confirm.
Planned finish read as 2025-04-13 (typo in date text; month 1->4). The day may also be stale; please confirm.
Planned finish read as 2025-04-13 (typo in date text; month 1->4). The day may also be stale; please confirm.
Planned start read as 2025-02-11 (year 2024->2025; month 3->2). The day may also be stale; please confirm.
Planned finish read as 2025-02-10 (month 10->2). The day may also be stale; please confirm.
Planned finish 2025-12-02 kept as found: finish is before start.
Planned finish 2025-12-02 kept as found: finish is before start.
Planned finish 2025-12-02 kept as found: finish is before start.
Planned finish 2025-12-02 kept as found: finish is before start.
Planned finish 2025-11-05 kept as found: finish is before start.
Planned finish 2025-10-03 kept as found: finish is before start.
Planned finish 2025-09-18 kept as found: finish is before start.
Planned finish 2025-09-18 kept as found: finish is before start.
Planned finish 2025-09-18 kept as found: finish is before start.
Planned finish 2025-09-05 kept as found: typo in date text; finish is before start.
Planned finish 2025-09-05 kept as found: finish is before start.
Planned finish 2025-09-05 kept as found: finish is before start.
Planned finish 2025-09-04 kept as found: finish is before start.
Planned finish 2025-09-04 kept as found: finish is before start.
Planned finish 2025-08-17 kept as found: finish is before start.
Planned finish 2025-08-17 kept as found: finish is before start.
Planned finish 2025-06-02 kept as found: finish is before start.
Planned finish 2025-05-04 kept as found: finish is before start.
Planned finish 2025-03-18 kept as found: finish is before start.
Planned finish 2025-03-18 kept as found: finish is before start.
Planned finish 2025-02-23 kept as found: year 2024->2025; finish is before start.
Planned finish 2025-02-23 kept as found: year 2024->2025; finish is before start.
Planned finish 2025-01-02 kept as found: finish is before start.
'50kVA Transformer @ Zenith Bank (JT03)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 120).
'50kVA Street Light Transformer 2 (JT02)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 119).
'50kVA Street Light Transformer 1 (JT01)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 118).
'200kVA Transformer near Warehouse (F1T03)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 117).
'50kVA Transformer @ Y-junction (F1T02)' is listed twice under 'Bi-annual Maintenance on Utility Systems' (first at row 116).
Group '54G1 3rd Quarterly Mtce' repeats row 490 exactly (same dates and tasks).
Planned finish read as 2020-11-24 (month 6->11). The day may also be stale; please confirm.
Planned start read as 2020-11-23 (month 6->11). The day may also be stale; please confirm.
Planned finish read as 2020-05-04 (year 2019->2020; month 2->5). The day may also be stale; please confirm.
Planned start read as 2020-05-04 (year 2019->2020; month 2->5). The day may also be stale; please confirm.
Planned finish read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2020-02-03 (month 1->2). The day may also be stale; please confirm.
Planned start read as 2020-02-02 (month 1->2). The day may also be stale; please confirm.
Planned finish read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned start read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned finish read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned start read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned finish read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned start read as 2019-10-03 (month 9->10). The day may also be stale; please confirm.
Planned finish read as 2019-06-03 (month 5->6). The day may also be stale; please confirm.
Planned start read as 2019-06-03 (month 5->6). The day may also be stale; please confirm.
Workbook shows 9.65034965034965 (typed value) but the imported inputs give 12.5396.
Workbook shows 9.52167832167832 (typed value) but the imported inputs give 6.624.
Workbook shows 35 (typed value) but the imported inputs give 370.0.
Workbook shows 0.161892901618929 (formula =Q42/R42) but the imported inputs give 0.312779.
Workbook shows -218.7 (formula =SUM(S38:S41)) but the imported inputs give -230.7.
Workbook shows 722.7 (typed value) but the imported inputs give 335.7.
Workbook shows 117 (formula =SUM(Q38:Q41)) but the imported inputs give 105.0.
Workbook shows '#DIV/0!' (formula =AVERAGE(M38:M41)) but the imported inputs give 0.0.
Workbook shows 0.9895833333333334 (formula =AVERAGE(G38:G41)) but the imported inputs give 0.984615.
Workbook shows 76 (formula =SUM(F38:F41)) but the imported inputs give 64.0.
Workbook shows 77 (formula =SUM(E38:E41)) but the imported inputs give 65.0.
Workbook shows 0.2222222222222222 (formula =Q41/R41) but the imported inputs give 0.0.
Workbook shows -42 (formula =Q41-R41) but the imported inputs give -54.0.
Workbook shows 12 (formula =SUM(F41,I41,L41,O41)) but the imported inputs give 0.0.
Workbook shows 1 (formula =F41/E41) but the imported inputs give None.
Workbook shows 12 (formula =SUM(R5:R7)) but the imported inputs give 0.0.
Workbook shows 12 (formula =SUM(P5:P7)) but the imported inputs give 0.0.
Workbook shows 100 (typed value) but the imported inputs give 1.0.
Workbook shows 0.0435865504358655 (formula =Q42/R42) but the imported inputs give 0.062002.
Workbook shows 722.7 (typed value) but the imported inputs give 508.05.
Workbook shows 0.2185897435897436 (formula =AVERAGE(G38:G41)) but the imported inputs give 0.328125.
Workbook shows 100 (typed value) but the imported inputs give 1.0.
January planned activities should reference S4.
January planned activities should reference O4.
ANNUAL planned total is 74 on Sheet2 but 7 on Sheet4; both kept in kpi_type_total.
2026 UNIT THREE (54G3) ANNUAL: programme months [6] vs plan months [2].
2026 UNIT THREE (54G3) QUARTERLY: programme months [2, 9, 12] vs plan months [2, 6].
2026 UNIT TWO (54G2) LEVEL_A: programme months [1, 2, 3, 4] vs plan months -.
2026 UNIT TWO (54G2) QUARTERLY: programme months [7, 11] vs plan months [1, 4, 7, 12].
2026 UNIT ONE (54G1) ANNUAL: programme months [11] vs plan months [5, 7, 11].
2026 UNIT ONE (54G1) QUARTERLY: programme months [2, 5, 8] vs plan months [3, 8, 11, 12].
2020 UNIT THREE (54G3) QUARTERLY: programme months [6, 8] vs plan months [2, 5, 7].
2020 UNIT TWO (54G2) LEVEL_A: programme months [4, 5, 6] vs plan months [1].
2020 UNIT TWO (54G2) QUARTERLY: programme months [9, 11] vs plan months [6, 8, 11].
2020 UNIT ONE (54G1) LEVEL_A: programme months [7, 8, 9] vs plan months [3].
2020 UNIT ONE (54G1) QUARTERLY: programme months [5, 12] vs plan months [1, 9, 12].
Source plan finish 2025-12-02 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-12-02 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-12-02 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-12-02 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-11-05 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-10-03 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-09-18 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-09-18 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-09-18 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-09-05 was unusable (SUSPECT); the current plan uses the start date.
Source plan finish 2025-09-05 was unusable (SUSPECT); the current plan uses the start date.