The table below summarises some of the model descriptions posted to the Design Facility. These provide a feel for the range and scope of descriptions that are possible. The buttons to the right of the table link to the individual descriptions.
Spreadsheet Title
Spreadsheet Type
Spreadsheet Description
Users?
Inputs
Processes
Results
Presentations
Completed Date
Title
Calculation List
Desc
1
1
1
1
1
Tue, 17 Oct 2006 04:15:37 GMT
Systems Risk Index
Single Calculation
Generate a standardised risk index for key systems within the enterprise
1
18
7
1
1
Mon, 23 Oct 2006 05:57:44 GMT
Title
Calculation List
Desc
1
1
0
0
0
Thu, 28 Dec 2006 13:56:18 GMT
Typical Audit Template Description
Monitoring List
My Test
1
2
0
0
0
Mon, 07 May 2007 09:52:35 GMT
Test
Single Calculation
Test
1
4
1
0
0
Sat, 25 Aug 2007 06:35:21 GMT
Test Process
Calculation List
How flexible is this?
1
3
1
0
0
Sun, 12 Jul 2009 06:33:45 GMT
Auditing Su Doku
Calculation List
To create a rationale/logical process for demonstrating how a user solved a Su Doku puzzle.
The process is based on employing a small number of analysis templates repeatedly. The repetetive element of the process uses the ACBA Electronic Working Papers software, to control and manage the index8ing of the process.
1
82
51
3
2
Thu, 04 Nov 2010 08:39:34 GMT
Demo - Recording Complex Formula
Single Calculation
This records a potential methodology for handling complex individual formulae. In this specific case the complexity is generated by nested if statements. The example is taken from the calculation of the grid reult (StdExcl-GridResult) in design model SSD51185 prepared by ACBA34.
1
0
0
0
0
Thu, 06 Jan 2011 10:13:31 GMT
Demo - Recording Complex Formula
Single Calculation
This records a potential methodology for handling complex individual formulae. In this case the complexity is generated by nested if statements. The example is taken from the calculation of the grid reult (StdExcl-CellResult) in design model SSD51185 prepared by ACBA34.
The original process description was as follows - "An extended formula to determine the presentation of the result from this analysis. It covers elements of error checking (has the user completed the vital fields), verification of the status of the cell prior to analysis (had it been solved already?) and, if not, how do we present the result of this analysis. The solution can be either a number value or a string value. The structure of the string value - "lower digit" & ", " & "higher digit" is critical to later analysis."
1
13
8
0
0
Thu, 06 Jan 2011 15:09:23 GMT
Area of a Circle
Single Calculation
A description of a spreadsheet calculation in its most simple form.
