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

 | KPI Summary
 | Q4 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 | 26911 | 26000 | 3 |  |  | Yellow | D1
 | Strategic | KPI 2 | D2 | 0.9638901499943129 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 3 | D2 | 0.9754822509701488 | 0.85 | 3 |  |  | Grey | D2
 | Strategic | [NAME] | D2 | 19496.65573770492 | 14000 | 3 |  |  | Grey | D2
 | Strategic | KPI 5 | D2 | 0.9586871712841399 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 6 | D5 | 0.6025 | 0.73 | 2 |  |  | Yellow | D5
 | Strategic | KPI 7 | D5 | 0.875 | 0.75 | 3 |  |  | Grey | D5
 | Strategic | KPI 8 | D10 | 0.9166666666666666 | 0.43 | 3 |  |  | Grey | D10
 | Strategic | KPI 9 | D3 | 1.215717747062858 | 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.009345794392523364 | 0.01 | 3 |  |  | Green | D4
 | Operational | KPI 15 | D1 | 537 | 450 | 0 |  |  | Red | D1
 | Operational | KPI 16 | D1 | 0.8297744889869975 | 0.95 | 2 |  |  | Green | D1
 | Operational | KPI 17 | D5 | 0.07 | 1 | 1 |  |  | Red | D5
 | Operational | KPI 18 | D2 | 0.9842283398365922 | 0.95 | 3 |  |  | Yellow | D2
 | Operational | KPI 19 | D1 | 0.8823529411764706 | 0.75 | 3 |  |  | Grey | D1
 | Operational | KPI 20 | D1 | 0.7899554958221862 | 0.8 | 3 |  |  | Red | D1
 | Operational | KPI 21 | D5 | 22000 | 22000 | 3 |  |  | Green | D5
 | Operational | KPI 22 | D5 | 4 | 4 | 3 |  |  | Grey | D5
 | Operational | KPI 23 | D5 | 0.4137931034482759 | 0.8 | 1 |  |  | Green | D5
 | Operational | KPI 24 | D2 | -0.0125 | 0.01 | 1 |  |  | Red | D2
 | Operational | KPI 25 | D2 | 0.005360748207871522 | 0.015 | 0 |  |  | Red | D2
 | Operational | KPI 26 | D2 | 0.02676833969539475 | 0.003 | 1 |  |  | Red | D2
 | Operational | KPI 27 | D2 | 0.01287136640525686 | 0.005 | 1 |  |  | Red | D2
 | Operational | KPI 28 | D2 | 0.03963970610065162 | 0.015 | 1 |  |  | Red | D2
 | Operational | KPI 29 | D2 | 4 | 4 | 3 |  |  | Grey | D2
 | Operational | KPI 30 | D5 | 0.9917582417582418 | 0.9999 | 3 |  |  | Green | D5
 | Operational | KPI 31 | D5 | 0.89 | 0.8 | 0 |  |  | Red | D5
 | Operational | KPI 32 | D5 | 1 | 3 | 1 |  |  | Grey | D5
 | Operational | KPI 33 | D5 | 28 | 4 | 1 |  |  | Grey | D5
 | Operational | KPI 34 | D5 | 0.47 | 0.7 | 1 |  |  | Red | D5
 | Operational | KPI 35 | D2 | 9 | 9 | 3 |  |  | Green | D2
 | Operational | KPI 36 | D6 | 22 | 4 | 0 |  |  | Green | D6
 | Operational | KPI 37 | D6 | 1 | 1 | 3 |  |  | Green | D6
 | Operational | KPI 38 | D6 | 25 | 2 | 0 |  |  | Green | D6
 | Operational | KPI 39 | D5 | 0.965545070772287 | 0.9 | 0 |  |  | Green | D5
 | Operational | KPI 40 | D5 | 0 | 0 | 3 |  |  | Red | D5
 | Operational | KPI 41 | D7 | 0.9262295081967213 | 0.8 | 0 |  |  | Green | D7
 | Operational | KPI 42 | D8 | 3.4 | 15 | 0 |  |  | Green | D8
 | Operational | KPI 43 | D8 | 4.45 | 7 | 0 |  |  | Grey | D8
 | Operational | KPI 44 | D8 | 1 | 0.8 | 0 |  |  | Grey | D8
 | Operational | KPI 45 | D3 | 6.9 | 10 | 1 |  |  | Grey | D3
 | Operational | KPI 46 | D3 | 13 | 13 | 3 |  |  | Grey | D3
 | Operational | KPI 47 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 48 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 49 | D10 | 0.2112211221122112 | 0.2 | 3 |  |  | Grey | D10
 | Operational | KPI 50 | D10 | 0.5 | 0.35 | 0 |  |  | Green | D10
 | Operational | KPI 51 | D4 | 11.25 | 5 | 3 |  |  | Green | D4
 | Operational | KPI 52 | D4 | 14.30985915492958 | 7 | 0 |  |  | Green | D4
 | Operational | KPI 53 | D4 | 6.26872852233677 | 7 | 1 |  |  | Green | D4
 | Operational | KPI 54 | D4 | 8.875 | 7 | 0 |  |  | Green | D4
 | Operational | KPI 55 | D4 | 1 | 0.25 | 0 |  |  | Grey | D4
 | Operational | KPI 56 | D4 | 0.8169014084507042 | 0.25 | 0 |  |  | Green | D4
 | Operational | KPI 57 | D4 | 0.5378006872852233 | 0.25 | 0 |  |  | Green | D4
 | Operational | KPI 58 | D4 | 0.6785714285714286 | 0.25 | 0 |  |  | Green | D4