Spreadsheet: 826581d1682090881-radar-chart-if-statement-formula-help-excel-if-sample
Sheet: Corporate Radar (2)

 | Select the Month | Apr |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT DELETE LINKED TO GRAPH
 |  | 36/100Ki |  |  |  |  |  |  |  |  |  |  | Evaluation HLNA |  |  |  |  | Evaluation Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  | 85%         95%         105%        115% |  |  |  |  | "Actual" MORE than "Plan" is favourable
 |  |  |  |  |  |  |  |  |  |  |  |  | 115%         105%           95%             85% |  |  |  |  | "Actual" LESS than "Plan" is favourable
 |  |  |  |  |  |  |  |  |  |  |  |  | ■ | ▲ | ○ | ∆ | □
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Values | 36Ki Target | 36Ki Target | 36Ki Result | 36Ki Result | 35Ki Result | 35Ki Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (S) RIR | 1 |  | 3.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (S) First Aid Incidents | 1 |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Q) Damage Incidents | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (C) PTNI | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (D) Mainline Downtime | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (D) Subline Downtime | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (D) IS System Impacts | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (M) MP Process Coverage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (E) [NAME] | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hlookup | hlookup | hlookup | hlookup | hlookup | hlookup
1 | KPI's |  |  |  | P v A | Apr | May | Jun | Q1 | Jul | Aug | Sep | Q2 | Oct | Nov | Dec | Q3 | Jan | Feb | Mar | Q4 | YTD
2 | (S) RIR |  |  |  | Plan | 4.01
3 |  |  |  |  | Actual | 4
4 |  |  |  |  | Signal
5 |  |  |  |  | [NAME] | 4.81
6 | (S) First Aid Incidents |  |  |  | Plan | 14
7 |  |  |  |  | Actual | 16
8 |  |  |  |  | Signal
9 |  |  |  |  | [NAME] | 16
10 | (Q) Damage Incidents |  |  |  | Plan | 6
11 |  |  |  |  | Actual | 5
12 |  |  |  |  | Signal
13 |  |  |  |  | [NAME] | 5
14 | (C) PTNI |  |  |  | Plan | 0.03
15 |  |  |  |  | Actual | -0.01
16 |  |  |  |  | Signal
17 |  |  |  |  | [NAME] | 0.03
18 | (D) Mainline Downtime | 131 | 200 | 199.7 | Plan | 6.3 | 7.3 | 6.4 |  | 7.67 | 8.67 | 7.67 |  | 16.34 | 17.34 | 16.34 |  | 11.67 | 12.67 | 11.67
19 |  | 265 | 157 | 99.8 | Actual | 7
20 |  |  |  |  | Signal
21 |  |  |  |  | [NAME] | 0 | 1.8 | 0 |  | 14.2 | 0 | 4.9 |  | 0 | 28.2 | 21.5 |  | 0 | 28.4 | 3.2
22 | (D) Subline Downtime | 224 | 130 | 130.8 | Plan | 5 | 5 | 5 |  | 6.3 | 7.3 | 6.3 |  | 8 | 9 | 8 |  | 9.7 | 10.7 | 9.7
23 |  | 163 | 43 | 161.6 | Actual | 4
24 |  |  |  |  | Signal
25 |  |  |  |  | [NAME] | 0 | 0 | 8 |  | 0 | 20 | 0 |  | 0 | 12 | 45 |  | 0 | 17.6 | 59
26 | (D) IS System Impacts | 0 | 0 | 0 | Plan | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
27 |  | 0 | 0 | 0 | Actual | 0
28 |  |  |  |  | Signal
29 |  |  |  |  | [NAME] | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
30 | (M) MP Process Coverage | NA | NA | 0.9499999999999998 | Plan | 0.96 | 0.96 | 0.96 |  | 0.96 | 0.96 | 0.96 |  | 0.96 | 0.96 | 0.96 |  | 0.96 | 0.96 | 0.96
31 |  | NA | NA | 0.9714999999999998 | Actual | 0.957
32 |  |  |  |  | Signal
33 |  |  |  |  | [NAME] | 0.996 | 0.989 | 0.951 |  | 0.954 | 0.951 | 0.968 |  | 0.97 | 0.947 | 0.988 |  | 0.95 | 0.975 | 1.019
34 | (E) [NAME] | 3366 | 3170 | 2836.878127954696 | Plan | 1256
35 |  | 2990 | 2818 | 2814.52203759905 | Actual | 1233
36 |  |  |  |  | Signal
37 |  |  |  |  | [NAME] | 269.94 | 171.63 | 141.25 |  | 92.31 | 117.81 | 113.87 |  | 129.28 | 243.08 | 285.15 |  | 369.3174893943 | 440.1383841384001 | 440.74616406635
38 | Blank 1 |  |  |  | Plan
39 |  |  |  |  | Actual
40 |  |  |  |  | Signal
41 |  |  |  |  | [NAME] |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 | 0