Spreadsheet: 91931d1291633187-counting-using-nested-if-and-index-section-master-business-development
Sheet: KPIs

 |  | REF | Description |  | Qtr 4 |  | YEAR |  |  |  | Qtr 1 |  |  |  | Qtr 2 |  |  |  | Qtr 3 |  |  |  | Qtr 4 |  |  |  |  |  |  |  |  |  |  |  | ä | âá | ã
Ref | Section | Internal Ref | PI Descriptor | CBP | T | A | T | A | Stat |  | T | A | Stat |  | T | A | Stat |  | T | A | Stat |  | T | A | Stat | Trend | Period Comments, Mitigation Actions and Corrective Actions | KPI | REV? | Type | Date | Time | YTD Calc | YR1 | Q1 | Q2 | Q3 | Q4 | RAGY | RAG1Q | RAG2Q | RAG3Q | RAG4Q | RagY | RAG1 | RAG2 | RAG3 | RAG4 | YTD Ave | YTD Act | YTD For | Active
1 | Short1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá | Green | Green |  |  |  |  |  |  |  |  |  |  |  | Yes
2 | Short2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá |  | Green |  |  |  |  |  |  |  |  |  |  |  | No
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  | ä | âá | âá | âá | âá
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
69 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
71 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
88 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá
98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | ä | âá | âá | âá | âá