ACBA_banner.gif (14833 bytes)

ACBA Spreadsheet Design Facility - Viewing Module

Return to Home Page

Return to ACBA Spreadsheet Design Facility - User Guide

General Description and Summary

Your Org Ref ACBA9
Quotation Number SSD50565
Start Date and Time Mon, 23 Oct 2006 04:36:00 GMT
Spreadsheet Title Systems Risk Index
Spreadsheet type or classification Single Calculation
No. of Users 1
Spreadsheet Description Generate a standardised risk index for key systems within the enterprise
Spreadsheet Size/No. of Calculations A single calculation for each key system. Indices may be summarised or compared at a later stage.
Number of Recorded Inputs 18
Number of Recorded Processes 7
Number of Recorded Final Results 1
Number of Recorded Summary/Presentational Requirements 1
Date and Time Completed Mon, 23 Oct 2006 05:57:44 GMT

Recorded Inputs

Field Name Input Type Description Units DataType Format Source Validation Type Validation Limits
Income Fixed A value of the income generated by the system Currency Integer Simple number Whole number Must be positive
Trunover Fixed Represents the overall value of the goods and services handled by the system. Currency Integer Simple number Whole number Must be positive
Experience Fixed The number of years experience that the Officer responsible has in handling this systeme specifically. Years Decimal One decimal place Decimal between 0 and 50
Staff Fixed The number of staff directly involved in managing the system. Part time staff count as decimal fractions. Decimal Decimal 0 to max of total staff in company
Clarity Fixed How well are the systems boundaries and the allocation of responsibilities defined. Text List User selects the closest from 5 statements
System Boundaries Fixed To what extent does the functional system cross departmental/ organisational boundaries. Text List User selects the closest from 5 statements
Documentation Fixed How well are the system's structure, processes and procedures documented. Text List User selects the closest from 5 statements
Commercial Sensitivity Fixed How critical is the system to the finances of the Enterprise as a whole. Text List User selects the closest from 5 statements
Political sensitivity Fixed What impact would a major systems failure have to the reputation of the Enterprise Text List User selects the closest from 5 statements
Organisation Fixed Howclear is the organisation in which the system operates? What are the opportunities for overlaps and role conflicts? Text List User selects the closest from 5 statements
Systems Interfaces Fixed How many systems interfaces are there that require regular reconciliation of values between the connecting systems. Text List User selects the closest from 5 statements
Importance Variable For each fixed input the user has the option of defining its importance to the indexing calc. Decimal Decimal Must be greater than zero
Basic risk Interim Simple evaluation of the individual risk factor Calculated None
Weighted Risk Interim Basic risk times importance Calculated None
Entries Check Interim Verify entries for all factors Calculated None
Total Weighted Risk Interim Sum of each of the weighted risks Calculated None
Max Weighted Risk Interim Worst case scenario for weighted risk Calculated None
Risk Index Interim Numeric index as proportion of max Calculated None

Recorded Calculations and Processes

Process Description Process Type Input 1 Input 2 Input 3 Other Inputs Result Type Result Name
Employ look up table to evaluate a basic numeric risk for the input source. LookUp Income Process is repeated for each of the fixed inputs Interim Basic risk
Multiplcation of importance and basic risk generates weighted risk. Simple numeric analysis Basic risk Importance Process is repeated for each of the fixed inputs Interim Weighted Risk
Ensure there are entries for all factors before generating the risk index calc. Logical analysis Basic risk For each of the fixed input elements. Interim Entries Check
If valid enries for each element - add up weighted risk Single 'If' Entries Check Weighted Risk Interim Total Weighted Risk
Calculate the maximum weighted risk if all factors recorded at highest factor Simple numeric analysis Weighted Risk Interim Max Weighted Risk
Generate a Risk index as a proportion of the weighted total risk over the weighted maximum risk. Simple numeric analysis Total Weighted Risk Max Weighted Risk Interim Risk Index
Evaluate risk in textual terms bases on the quartile within which the index falls. Logical analysis Risk Index Final Risk Sector Evaluation

Recorded Final Results

Result Name Result Description
Risk Sector Evaluation Evaluation of systems risk in broad term based on traffic light system,

Recorded Presentation Requirements

Primary Result Field Compare With Mulitple Compare Compare Commentary Select From Select By Select By - Commentary Summary Function Summary Commentary Present As
Risk Index Need to compare movements in the risk index for the same system over time Summarise from multiple worksheets Comparison table