Spreadsheet: 328049d1403777060-survey-results-table-lookup-errors-scoring-tool-extended
Sheet: AQSCI (2)

Category | Subsection | Answer | [NAME] | Percentage1 | Percentage2
Assurance of Supply | Sub 1 | 5 | 5
Assurance of Supply | Sub 2 | 2 | 5
Assurance of Supply | Sub 3 | 4 | 5
Assurance of Supply | Sub 4 | 3 | 5 |  |  |  |  |  |  |  | RED COLUMNS ARE NEW
Assurance of Supply | Sub 5 | 2 | 5
Assurance of Supply | Sub 6 | 2 | 5
Assurance of Supply | Sub 7 | 5 | 5
Assurance of Supply | Sub 8 | 4 | 5
Assurance of Supply | Sub 9 | 4 | 5
Assurance of Supply | Sub 10 | 1 | 5
Assurance of Supply | Sub 11 | 1 | 5
Assurance of Supply | Sub 12 | 3 | 5
Assurance of Supply | Sub 13 | 3 | 5
Assurance of Supply | Sub 14 | 1 | 5
Assurance of Supply | Sub 15 | 5 | 5
Assurance of Supply | Sub 16 | 5 | 5
Assurance of Supply | Sub 17 | 1 | 5
Assurance of Supply | Sub 18 | 1 | 5
Assurance of Supply | Sub 19 | 5 | 5 |  |  |  | High Level' report | Baseline | Score
Assurance of Supply | Sub 20 | 5 | 5 |  |  |  | Assurance of Supply | 0.75 |  | Note inserting column B jumped score to 500%??
Assurance of Supply | Sub 21 | 2 | 5 |  |  |  | Quality | 0.75 |  | Delete B and correct Score % are shown..
Assurance of Supply | Sub 22 | 4 | 5 |  |  |  | Service | 0.75
Quality | Sub 23 | 5 | 5 |  |  |  | Cost | 0.75
Quality | Sub 24 | 4 | 5 |  |  |  | Innovation & Technology | 0.75
Quality | Sub 25 | 4 | 5
Quality | Sub 26 | 3 | 5 |  |  |  | Assurance of Supply | Baseline | Score
Quality | Sub 27 | 1 | 5 |  |  |  |  | 3 |  | Need to show answer from C2 as percentage of D2.
Quality | Sub 28 | 5 | 5 |  |  |  |  | 3
Quality | Sub 29 | 5 | 5 |  |  |  |  | 3
Quality | Sub 30 | 1 | 5 |  |  |  |  | 3
Quality | Sub 31 | 4 | 5 |  |  |  |  | 3
Quality | Sub 32 | 1 | 5 |  |  |  |  | 3
Quality | Sub 33 | 1 | 5 |  |  |  |  | 3
Quality | Sub 34 | 4 | 5 |  |  |  |  | 3
Quality | Sub 35 | 1 | 5 |  |  |  |  | 3
Quality | Sub 36 | 3 | 5 |  |  |  |  | 3 |  | If row is deleted from left hand table get #N/A error here
Quality | Sub 37 | 3 | 5 |  |  |  |  | 3
Quality | Sub 38 | 5 | 5 |  |  |  |  | 3
Quality | Sub 39 | 3 | 5 |  |  |  |  | 3
Quality | Sub 40 | 4 | 5 |  |  |  |  | 3
Quality | Sub 41 | 2 | 5 |  |  |  |  | 3
Quality | Sub 42 | 4 | 5 |  |  |  |  | 3
Quality | Sub 43 | 4 | 5 |  |  |  |  | 3
Quality | Sub 44 | 5 | 5 |  |  |  |  | 3
Quality | Sub 45 | 1 | 5 |  |  |  |  | 3
Service | Sub 46 | 4 | 5 |  |  |  |  | 3
Service | Sub 47 | 3 | 5 |  |  |  |  | 3
Service | Sub 48 | 2 | 5 |  |  |  |  | 3
Service | Sub 49 | 5 | 5
Service | Sub 50 | 2 | 5
Service | Sub 51 | 4 | 5
Service | Sub 52 | 2 | 5
Service | Sub 53 | 2 | 5
Service | Sub 54 | 1 | 5
Service | Sub 55 | 5 | 5
Service | Sub 56 | 4 | 5
Service | Sub 57 | 2 | 5
Service | Sub 58 | 1 | 5
Service | Sub 59 | 2 | 5
Service | Sub 60 | 2 | 5
Service | Sub 61 | 5 | 5
Service | Sub 62 | 5 | 5
Service | Sub 63 | 1 | 5
Service | Sub 64 | 3 | 5
Service | Sub 65 | 3 | 5
Service | Sub 66 | 4 | 5
Service | Sub 67 | 4 | 5
Service | Sub 68 | 1 | 5
Cost | Sub 69 | 3 | 5
Cost | Sub 70 | 3 | 5
Cost | Sub 71 | 1 | 5
Cost | Sub 72 | 5 | 5
Cost | Sub 73 | 3 | 5
Cost | Sub 74 | 2 | 5
Cost | Sub 75 | 2 | 5
Cost | Sub 76 | 4 | 5
Cost | Sub 77 | 3 | 5
Cost | Sub 78 | 5 | 5
Cost | Sub 79 | 4 | 5
Cost | Sub 80 | 3 | 5
Cost | Sub 81 | 2 | 5
Cost | Sub 82 | 3 | 5
Cost | Sub 83 | 1 | 5
Cost | Sub 84 | 4 | 5
Cost | Sub 85 | 4 | 5
Cost | Sub 86 | 4 | 5
Innovation & Technology | Sub 87 | 3 | 5
Innovation & Technology | Sub 88 | 3 | 5
Innovation & Technology | Sub 89 | 1 | 5
Innovation & Technology | Sub 90 | 4 | 5
Innovation & Technology | Sub 91 | 4 | 5
Innovation & Technology | Sub 92 | 4 | 5
Innovation & Technology | Sub 93 | 1 | 5
Innovation & Technology | Sub 94 | 4 | 5
Innovation & Technology | Sub 95 | 3 | 5
Innovation & Technology | Sub 96 | 2 | 5
Innovation & Technology | Sub 97 | 3 | 5
Innovation & Technology | Sub 98 | 3 | 5
Innovation & Technology | Sub 99 | 4 | 5
Innovation & Technology | Sub 100 | 1 | 5
Innovation & Technology | Sub 101 | 5 | 5
Innovation & Technology | Sub 102 | 5 | 5
Innovation & Technology | Sub 103 | 2 | 5
Innovation & Technology | Sub 104 | 1 | 5
Innovation & Technology | Sub 105 | 3 | 5
Innovation & Technology | Sub 106 | 1 | 5
Innovation & Technology | Sub 107 | 1 | 5