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

 | KPI Summary
 | Q3 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 | 27759 | 26000 | 3 |  |  | Green | D1
 | Strategic | KPI 2 | D2 | 0.9277861329387667 | 0.9 | 3 |  |  | Green | D2
 | Strategic | KPI 3 | D2 | 0.944884846553602 | 0.75 | 3 |  |  | Green | D2
 | Strategic | [NAME] | D2 | 20927.79365079365 | 14000 | 0 |  |  | Grey | D2
 | Strategic | KPI 5 | D3 | 1.538496152704657 | 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.85 | 3 |  |  | Green | D4
 | Strategic | KPI 10 | D4 | 0.007283321194464676 | 0.01 | 1 |  |  | Green | D4
 | Operational | KPI 11 | D5 | 0.07 | 0.75 | 1 |  |  | Red | D5
 | Operational | KPI 12 | D2 | 0.9029704900455686 | 0.95 | 1 |  |  | Green | D2
 | Operational | KPI 13 | D1 | 0.9425287356321839 | 0.8 | 3 |  |  | Green | D1
 | Operational | KPI 14 | D1 | 0.634909151042851 | 0.8 | 1 |  |  | Red | D1
 | Operational | KPI 15 | D5 | 22000 | 22000 | 3 |  |  | Green | D5
 | Operational | KPI 16 | D5 | 0.8837209302325582 | 0.83 | 3 |  |  | Green | D5
 | Operational | KPI 17 | D2 | 0.01038851709191521 | 0.01 | 1 |  |  | Red | D2
 | Operational | KPI 18 | D2 | 0.03301862986372544 | 0.004 | 1 |  |  | Red | D2
 | Operational | KPI 19 | D2 | 0.01684292285017497 | 0.005 | 1 |  |  | Red | D2
 | Operational | KPI 20 | D2 | 0.04986155271390041 | 0.015 | 1 |  |  | Red | D2
 | Operational | KPI 21 | D2 | 4 | 4 | 3 |  |  | Green | D2
 | Operational | KPI 22 | D5 | 0.9918478260869565 | 0.9999 | 3 |  |  | Green | D5
 | Operational | KPI 23 | D5 | 0.63 | 1 | 1 |  |  | Red | D5
 | Operational | KPI 24 | D5 | 0 | 2 | 1 |  |  | Red | D5
 | Operational | KPI 25 | D2 | 10 | 9 | 3 |  |  | Green | D2
 | Operational | KPI 26 | D6 | 3 | 3 | 3 |  |  | Green | D6
 | Operational | KPI 27 | D6 | 2 | 2 | 3 |  |  | Green | D6
 | Operational | KPI 28 | D7 | 0.8636363636363636 | 0.85 | 3 |  |  | Green | D7
 | Operational | KPI 29 | D8 | 12.58 | 15 | 3 |  |  | Green | D8
 | Operational | KPI 30 | D8 | 3.5 | 7 | 0 |  |  | Grey | D8
 | Operational | KPI 31 | D3 | 4.7 | 9 | 0 |  |  | Grey | D3
 | Operational | KPI 32 | D3 | 7 | 13 | 0 |  |  | Grey | D3
 | Operational | KPI 33 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 34 | D9 | 1 | 1 | 3 |  |  | Green | D9
 | Operational | KPI 35 | D10 | 30.30973451327434 | 20 | 0 |  |  | Grey | D10
 | Operational | KPI 36 | D10 | 0.8 | 0.35 | 0 |  |  | Grey | D10
 | Operational | KPI 37 | D4 | 4.6 | 5 | 2 |  |  | Yellow | D4
 | Operational | KPI 38 | D4 | 4.909090909090909 | 6 | 2 |  |  | Yellow | D4
 | Operational | KPI 39 | D4 | 2.525684931506849 | 6 | 1 |  |  | Red | D4
 | Operational | KPI 40 | D4 | 3.172413793103448 | 6 | 1 |  |  | Red | D4
 | Operational | KPI 41 | D4 | 0.4 | 0.25 | 0 |  |  | Grey | D4
 | Operational | KPI 42 | D4 | 0.3484848484848485 | 0.2 | 0 |  |  | Grey | D4
 | Operational | KPI 43 | D4 | 0.2876712328767123 | 0.2 | 0 |  |  | Grey | D4
 | Operational | KPI 44 | D4 | 0.2068965517241379 | 0.2 | 3 |  |  | Green | D4