123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 A B C Workbook Name Purpose Sheet References Numerical Data Overall Risk Rating Longest Formula (characters) Most Complex Formula (operations) Total Number Of Formulas XLANALYST Total Number Of Unique Formulas Workbook Size No Of Worksheets VBA Code (line/components) Largest Formula Result Range analysed Number of numeric inputs 0 Number of formulas 0 SS PRO Number of unique formulas 0 Percentage of unique formulas #DIV/0! Number of labels 0 Function types All functions used Financial Date and Time Math Statistical Lookup and Reference Database Text Logical Information Potential errors Totals Circular references 0 Display number but store text 0 Mixed formulas and values 0 Formulas evaluating to an error 0 VLOOKUPs expecting an ordered list 0 HLOOKUPs expecting an ordered list 0 Links to external workbooks 0 Presence of very hidden sheets 0 XLANALYST Hidden rows or columns 0 “=+” construct 048 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 A B C Conditional formatting 0 Use of pivot tables 0 Array formulas 0 Nested IF statements 0 Use of SUMIF 0 Use of database functions 0 Use of INDIRECT 0 Unused input values 0 Unused calculations 0 No precedents 0 Dependents rule 0 Blank cells referenced 0 Errors referenced 0 Non-numeric cell referenced 0 Forward row reference 0 Forward column reference 0 Hidden cell referenced 0 SS PRO Range name 0 Duplicate range names 0 External reference 0 IF function 0 Double IF function 0 NPV function 0 VLOOKUP function 0 HLOOKUP function 0 LOOKUP function 0 Numeric rule: numbers in formula 0 Complex calculation 0 Unprotected calculation 0 Lotus evaluation rules 0 Worksheet protections 0 Calculation manual 0 Unused input values Unused calculations No precedents Dependents rule Blank cells referenced Errors referenced Non-numeric cell referenced Forward row reference Forward column reference Hidden cell referenced SS PRO Range name Duplicate range names External reference IF function Double IF function NPV function VLOOKUP function99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 A B C HLOOKUP function LOOKUP function Numeric rule: numbers in formula Complex calculation Unprotected calculation Lotus evaluation rules Worksheet protections Calculation manual Design Overall ease of understanding NA Use of modules NA Use of parameterization NA Use of range names for parameters NA Use of range names for formulas NA Ease of use NA Ease of communication NA Technical quality NA Documentation Model assumptions No Sources for inputs No Guide to sheets No Cell comments No Pseudocode for formulas No Notes in cells No Security Protected cells No Hidden cells No Data validation No Errors Cell address(es) Number of cells involved 1 Sheet1!C1:C14 14 23456789 10 Total time (minutes) Comments123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 D E 1 2 ----CELL REFERENCES48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 D E CELL COUNTS CELL REFERENCES99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 D E Error Identified by XLAnalyst? Error Identified by SS Pro? No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit No credit123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 F G H 3 4 5 ------48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 F G H99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 F G H Data validation lists 12345 NA Type of error How discovered Comments Logic error XL Analyst: Numerical tests Logic error SS PRO: Map analysis Logic error Code inspection Logic error Code inspection Logic error Code inspection Logic error Code inspection Logic error Code inspection Logic error Code inspection Logic error Code inspection Logic error Code inspection123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 I J 6 7 ----48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 I J99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 I J Yes Some No Data validation lists Error Flagged by XLAnalyst? No credit XLANALYST 1: Circular references XLANALYST 2 : Display number but store text XLANALYST3 : Mixed formulas and values XLANALYST4: Formulas evaluating to an error XLANALYST 5: VLOOKUPs expecting an ordered list XLANALYST 6: HLOOKUPs expecting an ordered list XLANALYST 7: Links to external workbooks XLANALYST 8: Presence of very hidden sheets XLANALYST 9: Hidden rows or columns XLANALYST 10: “=+” construct XLANALYST 11: Conditional formatting XLANALYST 12: Use of pivot tables XLANALYST 13: Array formulas XLANALYST 14: Nested IF statements XLANALYST 15: Use of SUMIF XLANALYST 16: Use of database functions XLANALYST 17 : Use of INDIRECT123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 K L 8 9 ----48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 K L99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 K L Error Flagged by SS Pro? Type No credit Logic error SS PRO 1: Unused input values Reference error SS PRO 2: Unused calculations Hard-coding SS PRO 3 No precedents Data input SS PRO 4: Dependents rule Copy/Paste SS PRO 5: Blank cells referenced Omission SS PRO 6: Errors referenced SS PRO 7: Non-numeric cell referenced SS PRO 8: Forward row reference SS PRO 9: Forward column reference SS PRO 10: Hidden cell referenced SS PRO 11: Range name SS PRO 12: Duplicate range names SS PRO 13: External reference SS PRO 14: IF function SS PRO 15: Double IF function SS PRO 16: NPV function SS PRO 17: VLOOKUP function SS PRO 18: HLOOKUP function SS PRO 19: LOOKUP function SS PRO 20 Numeric rule: numbers in formula SS PRO 21: Complex calculation SS PRO 22: Unprotected calculation SS PRO 23: Lotus evaluation rules SS PRO 24: Worksheet protections SS PRO 25: Calculation manual123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 M N O 10 11 12 ------48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 M N O99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 M N O How discovered SS PRO: Map analysis XL Analyst: Numerical tests SS PRO: Numerical tests Code inspection Performance testing123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 P Q R 13 14 15 ------48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 P Q R99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 P Q R123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 S T U 16 17 18 ------48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 S T U99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 S T U123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 V W 19 20 ----48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 V W99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 V W