Spreadsheet: 217651d1362141855-rollup-data-from-multiple-excel-sheets-kpi-worksheet_test
Sheet: Q1 Summary

 | KPI Summary
 | Q1 2012
 | KPI Type | KPI | Department | Measured Actual Value | Target Value | Health Indicator | Reason for Deviation from Target | Corrective Action Suggested- CAPA | C
 | Strategic | KPI 1 | D1 | 26410.5 | 24000 | 3 |  |  | Green | D1
 | Strategic | KPI 2 | D2 | 0.915493762968147 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 3 | D2 | 0.7642723718146092 | 0.6 | 3 |  |  | Green | D2
 | Strategic | [NAME] | D2 | 20526.859375 | 14000 | 3 |  |  | Green | D2
 | Strategic | KPI 5 | D3 | 2.139614045647066 | 1 | 0 |  |  | Grey | D3
 | Strategic | KPI 6 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 7 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 8 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 9 | D4 | 1 | 0.8 | 3 |  |  | Green | D4
 | Strategic | KPI 10 | D4 | 0.02236421725239617 | 0.02 | 2 |  |  | Yellow | D4
 | Operational | KPI 11 | D5 | 2 | 2 | 3 |  |  | Green | D1
 | Operational | KPI 12 | D2 | 0.04 | 0.05 | 2 |  |  | Yellow | D5
 | Operational | KPI 13 | D1 | 0.6995369733645074 | 0.75 | 0 |  |  | Yellow | D2
 | Operational | KPI 14 | D1 | 0.46364527322332 | 0.75 | 1 |  |  | Red | D1
 | Operational | KPI 15 | D5 | 0.6923076923076923 | 0.75 | 2 |  |  | Yellow | D1
 | Operational | KPI 16 | D5 | 22000 | 22000 | 3 |  |  | Green | D5
 | Operational | KPI 17 | D2 | 0.8205128205128205 | 0.77 | 3 |  |  | Green | D5
 | Operational | KPI 18 | D2 | 0.03901433515046508 | 0.015 | 0 |  |  | Red | D2
 | Operational | KPI 19 | D2 | 0.003020498737575971 | 0.006 | 0 |  |  | Grey | D2
 | Operational | KPI 20 | D2 | 0.01928960618777065 | 0.005 | 0 |  |  | Red | D2
 | Operational | KPI 21 | D2 | 0.02231010492534662 | 0.015 | 0 |  |  | Red | D2
 | Operational | KPI 22 | D5 | 4 | 4 | 3 |  |  | Green | D2
 | Operational | KPI 23 | D5 | 0.9972527472527473 | 0.9999 | 3 |  |  | Green | D5
 | Operational | KPI 24 | D5 | 0.63 | 0.75 | 2 |  |  | Yellow | D5
 | Operational | KPI 25 | D2 | 9 | 9 | 3 |  |  | Green | D2
 | Operational | KPI 26 | D6 | 8 | 8 | 3 |  |  | Green | D6
 | Operational | KPI 27 | D6 | 4 | 4 | 3 |  |  | Green | D6
 | Operational | KPI 28 | D7 | 0.9 | 0.8 | 3 |  |  | Green | D7
 | Operational | KPI 29 | D8 | 11.83 | 17 | 0 |  |  | Grey | D8
 | Operational | KPI 30 | D8 | 0 | 10 | 0 |  |  | Grey | D8
 | Operational | KPI 31 | D3 | 7.9 | 10 | 0 |  |  | Grey | D3
 | Operational | KPI 32 | D3 | 11 | 13 | 3 |  |  | Green | D3
 | Operational | KPI 33 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 34 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 35 | D10 | 24.27184466019418 | 2 | 3 |  |  | Green | D4
 | Operational | KPI 36 | D10 | 0.3076923076923077 | 0.35 | 3 |  |  | Green | D4
 | Operational | KPI 37 | D4 | 8 | 5 | 0 |  |  | Grey | D4
 | Operational | KPI 38 | D4 | 8.927536231884059 | 9 | 3 |  |  | Green | D4
 | Operational | KPI 39 | D4 | 9.007692307692308 | 9 | 3 |  |  | Green | D4
 | Operational | KPI 40 | D4 | 12.29166666666667 | 9 | 3 |  |  | Green | D4
 | Operational | KPI 41 | D4 | 0.4 | 0.25 | 0 |  |  | Grey | D4
 | Operational | KPI 42 | D4 | 0.2898550724637681 | 0.3 | 3 |  |  | Green | D4
 | Operational | KPI 43 | D4 | 0.3 | 0.3 | 3 |  |  | Green | D4
 | Operational | KPI 44 | D4 | 0.4166666666666667 | 0.3 | 3 |  |  | Green | D4