Spreadsheet: 84209d1284210345-sumproduct-samplefile
Sheet: Sheet1

 |  | Global |  | QTR 1 Actual
QTR | Index |  | Region | Metric |  | QTR Trend | YTD Actual | YTD Trend | Target
QTR 1 Actual | 1 |  |  | KPI 1
QTR 2 Actual | 2 |  |  | KPI 2
QTR 3 Actual | 3 |  |  | KPI 3
QTR 4 Actual | 4 |  |  | [NAME]
 |  |  |  | KPI 5
Region | Index |  |  | KPI 6
Global | 1 |  |  | KPI 7
North America | 2 |  |  | KPI 8
Europe | 3 |  |  | KPI 9
Asia Pacific | 4 |  |  | KPI 10
CEEMA | 5 |  |  | KPI 11
Latin America | 6 |  |  | KPI 12
 |  |  |  | KPI 13
 |  |  |  | KPI 14
 |  | Index | Region | Metric
 |  |  | Global | KPI 2
 |  | Index | Region | Metric | QTR 1 Actual | QTR Trend | YTD Actual | YTD Trend | Target | Q2 Actual | QTR 2 Trend | Q3 Actual | QTR 3 Trend | Q4 Actual | QTR 4 Trend | YTD Q2 Actual | YTD 2 Trend | [NAME] Actual | YTD 3 Trend | YTD Q4 Actual | YTD 4 Trend
 |  | 1 | Global | KPI 1 | 152247 | 0 | 152247 | 0 | N/A | 3293 | -1 | 3293 | 0 | 633 | 1 | 3293 | -1 | 3293 | 1 | 3293 | 0
 |  | 2 | Global | KPI 2 | 170210 | 0 | 170210 | 0 | N/A | N/A | 1 | N/A | 1 | N/A | 0 | N/A | 1 | N/A | 0 | N/A | 1
 |  | 3 | Global | KPI 3 | 26167 | 0 | 26167 | 0 | N/A | 0 | 0 | 0 | -1 | 1900 | -1 | 0 | 0 | 0 | -1 | 0 | -1
 |  | 4 | Global | [NAME] | 0 | 0 | 0 | 0 | N/A | 0 | -1 | 0 | 0 | 0 | 1 | 0 | -1 | 0 | 1 | 0 | 0
 |  | 5 | Global | KPI 5 | 0 | 0 | 0 | 0 | N/A | N/A | 1 | N/A | 1 | N/A | 0 | N/A | 1 | N/A | 0 | N/A | 1
 |  | 6 | Global | KPI 6 | 0 | 0 | 0 | 0 | N/A | 0 | 0 | 0 | -1 | N/A | -1 | 0 | 0 | 0 | -1 | 0 | -1
 |  | 7 | Global | KPI 7 | 0 | 0 | 0 | 0 | N/A | 0 | -1 | 0 | 0 | N/A | 1 | 0 | -1 | 0 | 1 | 0 | 0
 |  | 8 | Global | KPI 8 | 7710 | 0 | 7710 | 0 | 0 | 5441 | 1 | 5441 | 1 | 0 | 0 | 5441 | 1 | 5441 | 0 | 5441 | 1
 |  | 9 | Global | KPI 9 | 169 | 0 | 169 | 0 | N/A | N/A | 0 | N/A | -1 | 0 | -1 | N/A | 0 | N/A | -1 | N/A | -1
 |  | 10 | Global | KPI 10 | 5338 | 0 | 5338 | 0 | N/A | 0 | -1 | 0 | 0 | N/A | 1 | 0 | -1 | 0 | 1 | 0 | 0
 |  | 11 | Global | KPI 11 | 222 | 0 | 222 | 0 | N/A | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
 |  | 12 | Global | KPI 12 | 302 | 0 | 302 | 0 | N/A | N/A | 0 | N/A | -1 | N/A | -1 | N/A | 0 | N/A | -1 | N/A | -1
 |  | 13 | Global | KPI 13 | 1574 | 0 | 1574 | 0 | N/A | N/A | -1 | N/A | 0 | N/A | 1 | N/A | -1 | N/A | 1 | N/A | 0
 |  | 14 | Global | KPI 14 | 105 | 0 | 105 | 0 | N/A | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
 |  | 15 | North America | KPI 1 | N/A | N/A | N/A | N/A | N/A | 206 | 0 | 206 | -1 | 0 | -1 | 206 | 0 | 206 | -1 | 206 | -1
 |  | 16 | North America | KPI 2 | N/A | N/A | N/A | N/A | N/A | N/A | -1 | N/A | 0 | N/A | 1 | N/A | -1 | N/A | 1 | N/A | 0
 |  | 17 | North America | KPI 3 | 0 | 0 | 0 | 0 | N/A | 0 | 1 | 0 | 1 | N/A | 0 | 0 | 1 | 0 | 0 | 0 | 1
 |  | 18 | North America | [NAME] | 0 | 0 | 0 | 0 | N/A | 0 | 0 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | -1 | 0 | -1
 |  | 19 | North America | KPI 5 | 0 | 0 | 0 | 0 | 0 | N/A | -1 | N/A | 0 | N/A | 1 | N/A | -1 | N/A | 1 | N/A | 0
 |  | 20 | North America | KPI 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | N/A | 0 | 0 | 1 | 0 | 0 | 0 | 1
 |  | 21 | North America | KPI 7 | 0 | 0 | 0 | 0 | N/A | 0 | 0 | 0 | -1 | N/A | -1 | 0 | 0 | 0 | -1 | 0 | -1
 |  | 22 | North America | KPI 8 | 0 | 0 | 0 | 0 | N/A | 1239 | -1 | 1239 | 0 | 0 | 1 | 1239 | -1 | 1239 | 1 | 1239 | 0
 |  | 23 | North America | KPI 9 | 0 | 0 | 0 | 0 | N/A | N/A | -1 | N/A | 1 | N/A | 0 | N/A | -1 | N/A | 0 | N/A | 1
 |  | 24 | North America | KPI 10 | 7710 | 0 | 7710 | 0 | 0 | 0 | 1 | 0 | -1 | N/A | -1 | 0 | 1 | 0 | -1 | 0 | -1
 |  | 25 | North America | KPI 11 | 169 | 0 | 169 | 0 | N/A | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 |  | 26 | North America | KPI 12 | 5338 | 0 | 5338 | 0 | N/A | N/A | -1 | N/A | 0 | N/A | 0 | N/A | -1 | N/A | 0 | N/A | 0
 |  | 27 | North America | KPI 13 | 222 | 0 | 222 | 0 | N/A | N/A | 1 | N/A | 1 | N/A | -1 | N/A | 1 | N/A | -1 | N/A | 1
 |  | 28 | North America | KPI 14 | 302 | 0 | 302 | 0 | N/A | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1
 |  | 29 | Europe | KPI 1
 |  | 30 | Europe | KPI 2
 |  | 31 | Europe | KPI 3
 |  | 32 | Europe | [NAME]
 |  | 33 | Europe | KPI 5
 |  | 34 | Europe | KPI 6
 |  | 35 | Europe | KPI 7
 |  | 36 | Europe | KPI 8
 |  | 37 | Europe | KPI 9
 |  | 38 | Europe | KPI 10
 |  | 39 | Europe | KPI 11
 |  | 40 | Europe | KPI 12
 |  | 41 | Europe | KPI 13
 |  | 42 | Europe | KPI 14
 |  | 43 | Asia Pacific | KPI 1
 |  | 44 | Asia Pacific | KPI 2
 |  | 45 | Asia Pacific | KPI 3
 |  | 46 | Asia Pacific | [NAME]
 |  | 47 | Asia Pacific | KPI 5
 |  | 48 | Asia Pacific | KPI 6
 |  | 49 | Asia Pacific | KPI 7
 |  | 50 | Asia Pacific | KPI 8
 |  | 51 | Asia Pacific | KPI 9
 |  | 52 | Asia Pacific | KPI 10
 |  | 53 | Asia Pacific | KPI 11
 |  | 54 | Asia Pacific | KPI 12
 |  | 55 | Asia Pacific | KPI 13
 |  | 56 | Asia Pacific | KPI 14
 |  | 57 | CEEMA | KPI 1
 |  | 58 | CEEMA | KPI 2
 |  | 59 | CEEMA | KPI 3
 |  | 60 | CEEMA | [NAME]
 |  | 61 | CEEMA | KPI 5
 |  | 62 | CEEMA | KPI 6
 |  | 63 | CEEMA | KPI 7
 |  | 64 | CEEMA | KPI 8
 |  | 65 | CEEMA | KPI 9
 |  | 66 | CEEMA | KPI 10
 |  | 67 | CEEMA | KPI 11
 |  | 68 | CEEMA | KPI 12
 |  | 69 | CEEMA | KPI 13
 |  | 70 | CEEMA | KPI 14
 |  | 71 | Latin America | KPI 1
 |  | 72 | Latin America | KPI 2
 |  | 73 | Latin America | KPI 3
 |  | 74 | Latin America | [NAME]
 |  | 75 | Latin America | KPI 5
 |  | 76 | Latin America | KPI 6
 |  | 77 | Latin America | KPI 7
 |  | 78 | Latin America | KPI 8
 |  | 79 | Latin America | KPI 9
 |  | 80 | Latin America | KPI 10
 |  | 81 | Latin America | KPI 11
 |  | 82 | Latin America | KPI 12
 |  | 83 | Latin America | KPI 13
 |  | 84 | Latin America | KPI 14