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

 | KPI Summary
 | Q2 2012
 | KPI Type | KPI | Department | Measured Actual Value | Target Value | Health Indicator | Reason for Deviation from Target | Corrective Action Suggested- CAPA | C | Dept.
 | Strategic | KPI 1 | D1 | 24316 | 26000 | 3 |  |  | Yellow | D1
 | Strategic | KPI 2 | D2 | 0.9127209821538583 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 3 | D2 | 0.9048728823379453 | 0.7 | 3 |  |  | Grey | D2
 | Strategic | [NAME] | D2 | 20526.859375 | 14000 | 0 |  |  | Grey | D2
 | Strategic | KPI 5 | D2 | 0.9439431387123778 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 6 | D5 | 0.445 | 0.54 | 2 |  |  | Yellow | D5
 | Strategic | KPI 7 | D5 | 0.7722 | 0.7 | 3 |  |  | Grey | D5
 | Strategic | KPI 8 | D10 | 0.6666666666666666 | 0.43 | 0 |  |  | Grey | D10
 | Strategic | KPI 9 | D3 | 2.646204928982568 | 1 | 0 |  |  | Grey | D3
 | Strategic | KPI 10 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 11 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 12 | D4 | 1 | 1 | 3 |  |  | Green | D4
 | Strategic | KPI 13 | D4 | 1 | 0.8 | 3 |  |  | Grey | D4
 | Strategic | KPI 14 | D4 | 0.01574803149606299 | 0.01 | 1 |  |  | Green | D4
 | Operational | KPI 15 | D1 | 0 | 1 | 1 |  |  | Red | D1
 | Operational | KPI 16 | D1 | 0.9620800054350365 | 0.9 | 3 |  |  | Green | D1
 | Operational | KPI 17 | D5 | 0.07 | 0.3 | 1 |  |  | Red | D5
 | Operational | KPI 18 | D2 | 0.8500817544964973 | 0.85 | 3 |  |  | Yellow | D2
 | Operational | KPI 19 | D1 | 0.9411764705882353 | 0.75 | 0 |  |  | Grey | D1
 | Operational | KPI 20 | D1 | 0.5434016016120347 | 0.75 | 1 |  |  | Red | D1
 | Operational | KPI 21 | D5 | 25268 | 22000 | 3 |  |  | Green | D5
 | Operational | KPI 22 | D5 | 4 | 4 | 3 |  |  | Grey | D5
 | Operational | KPI 23 | D5 | 0.9512195121951219 | 0.8 | 3 |  |  | Green | D5
 | Operational | KPI 24 | D2 | -0.036 | 0.01 | 1 |  |  | Red | D2
 | Operational | KPI 25 | D2 | 0.006987565501764479 | 0.015 | 0 |  |  | Red | D2
 | Operational | KPI 26 | D2 | 0.005616171248658976 | 0.005 | 3 |  |  | Red | D2
 | Operational | KPI 27 | D2 | 0.01941956205784476 | 0.005 | 0 |  |  | Red | D2
 | Operational | KPI 28 | D2 | 0.02503573330650374 | 0.015 | 0 |  |  | Red | D2
 | Operational | KPI 29 | D2 | 7 | 4 | 0 |  |  | Grey | D2
 | Operational | KPI 30 | D5 | 0.9971910112359551 | 0.9999 | 3 |  |  | Green | D5
 | Operational | KPI 31 | D5 | 0.63 | 0.9 | 1 |  |  | Red | D5
 | Operational | KPI 32 | D5 | 2 | 1 | 0 |  |  | Grey | D5
 | Operational | KPI 33 | D5 | 12 | 4 | 0 |  |  | Grey | D5
 | Operational | KPI 34 | D5 | 0.26 | 0.4 | 1 |  |  | Red | D5
 | Operational | KPI 35 | D2 | 11 | 9 | 0 |  |  | Green | D2
 | Operational | KPI 36 | D6 | 4 | 4 | 3 |  |  | Green | D6
 | Operational | KPI 37 | D6 | 0.5455 | 0.5 | 3 |  |  | Green | D6
 | Operational | KPI 38 | D6 | 2 | 2 | 3 |  |  | Green | D6
 | Operational | KPI 39 | D5 | 0.9531310026892048 | 0.9 | 3 |  |  | Green | D5
 | Operational | KPI 40 | D5 | 0 | 0 | 3 |  |  | Red | D5
 | Operational | KPI 41 | D7 | 0.87 | 0.8 | 3 |  |  | Green | D7
 | Operational | KPI 42 | D8 | 14.47 | 17 | 3 |  |  | Green | D8
 | Operational | KPI 43 | D8 | 5.79 | 10 | 0 |  |  | Grey | D8
 | Operational | KPI 44 | D8 | 0.75 | 0.75 | 3 |  |  | Grey | D8
 | Operational | KPI 45 | D3 | 5.5 | 10 | 0 |  |  | Grey | D3
 | Operational | KPI 46 | D3 | 8 | 13 | 0 |  |  | Grey | D3
 | Operational | KPI 47 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 48 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 49 | D10 | 50.78299776286354 | 2 | 0 |  |  | Grey | D10
 | Operational | KPI 50 | D10 | 0.375 | 0.35 | 3 |  |  | Green | D10
 | Operational | KPI 51 | D4 | 10.4 | 5 | 0 |  |  | Green | D4
 | Operational | KPI 52 | D4 | 7.397058823529412 | 7 | 3 |  |  | Green | D4
 | Operational | KPI 53 | D4 | 6.428051001821494 | 7 | 2 |  |  | Green | D4
 | Operational | KPI 54 | D4 | 9.4 | 7 | 3 |  |  | Green | D4
 | Operational | KPI 55 | D4 | 0.4 | 0.25 | 0 |  |  | Grey | D4
 | Operational | KPI 56 | D4 | 0.25 | 0.25 | 3 |  |  | Green | D4
 | Operational | KPI 57 | D4 | 0.2604735883424408 | 0.25 | 3 |  |  | Green | D4
 | Operational | KPI 58 | D4 | 0.3666666666666666 | 0.25 | 3 |  |  | Green | D4