ACBA_banner.gif (14833 bytes)

ACBA Spreadsheet Design Facility - Brief Review of Completed Models

Return to Home Page

Return to ACBA Spreadsheet Design Facility - User Guide

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
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
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
Cash Flow Analysis - Test Bed Monitoring List The "Unsubsidized" worksheet considers elements of cash flow in relation to the interests of shareholders, cost of capital, "free" cash and after tax cash flows from lenders. Delivers a conclusion concerning the cashflows TO shareholders and after tax cashflows TO lenders. 1 10 4 0 0 Wed, 28 Sep 2016 09:26:16 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. 1 4 3 1 0 Mon, 17 Jan 2011 15:16:34 GMT
Test Single Calculation Examining the continued functionality of the design facility. Very simple calc essentially 1 + 2 = 3 1 4 2 1 1 Thu, 22 Sep 2016 07:44:38 GMT