| Spreadsheet Composer 2.0 |
| |
|

Spreadsheet Composer is an Excel add-in, which offers significant productivity and development benefits. The core
capability of the add-in is the 'compose' function. With this function it is possible to define a spreadsheet calculation as a series of linked steps and then automatically 'compose' the calculation into a single complex formula. Spreadsheet Composer is a very powerful tool that enables the user to attain a level of functionality and error trapping that was previously difficult to achieve in a manageable spreadsheet.
The add-in provides a number of support features to facilitate the use and management of composed formulae. It provides a database for the storage; documentation and retrieval of formulae and a 'matching' function that can link an implemented formula back to its database description. The retrieval function allows the user to copy a formula from the database into a selected spreadsheet cell, to automatically select input cells for the formula and to specify a mix of relative and absolute addressing for the selected cells.
The add-in permits complete verification of a formula before it is stored within the database. The formula can be verified against its original definition and against its intended behaviour. If a formula gives an unintended output for a particular combination of inputs, then additional error trapping can be factored into the composed formula.
The add-in provides an 'export' function, which allows a completed spreadsheet to be written out to a standalone workbook for independent operation.
Further details of Spreadsheet Composer are provided within the download. It includes an extensive description document incorporating numerous screen-shots.
|
|
|
1127KB |
|
|
Freeware |
|
|
$ |
|
|
Business & Finance / Spreadsheets |
|
|
Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE |
|
|
Dust Free Solutions |
|
|
|
|
 |
|
Related keywords: Excel, spreadsheet, add-in, formula, composition, utility,
|
|
|
| |
|
|
| Top Business & Finance / Spreadsheets softs |
|
1)
Excel Unique & Duplicate Data Remover 7.0
Search and delete duplicate and unique cells in MS Excel.
License:Shareware,
$29.99 to buy Size:
383KB
2)
Excel VBA Models Combo Set XL-VBA4 1.0
Excel VBA Open Source Code Models contains 37 programs in finance and statistics
License:Shareware,
$29.95 to buy Size:
975KB
3)
Excel VBA Models Set 3 XL-VBA3.0
Excel VBA Models Open Source Code - Numerical Methods and Option Pricing Set
License:Shareware,
$14.95 to buy Size:
224KB
4)
BREAKTRU STOCKWATCH 5.5
Create a portfolio with this spreadsheet for Excel
License:Freeware,
$0 to buy Size:
3829KB
5)
Schedule Rotating Shifts for Your Employees 4.7
Rotating or Fixed Shift Schedules for 25 People for 52 Weeks with Excel.
License:Shareware,
$249 to buy Size:
4093KB
6)
JobCost Controller for Excel 2.11
Construction Job Cost Tracking and Reporting System for Excel.
License:Shareware,
$39.00 to buy Size:
4394KB
7)
Spheresoft Zip Code Tools for Excel 1.2
Calculate the distance between address zip codes in Microsoft Excel
License:Commercial,
$49 to buy Size:
1906KB
8)
Color Palette for Excel 2.0
Bring life, color and style to your Excel charts and reports.
License:Shareware,
$29.95 to buy Size:
2332KB
9)
XLSTAT-Pro (Win) 7.5.2
XLSTAT is a data analysis and statistics add-in for MS Excel
License:Demo,
$395 to buy Size:
7925KB
10)
UltraSleuth Personal Edition 2.0
Free Excel add-in for checking, analyzing and documenting spreadsheets
License:Freeware,
$0.00 to buy Size:
562KB
|
|
|
| New Business & Finance / Spreadsheets softs |
|
1)
United States ZIP Code Database (Gold + Multi-County Edition) July.2008
United States ZIP Codes Database Subscription in text, Excel, Access and dBASE V
License:Commercial,
$99.95 to buy Size:
306KB
2)
DoneEx XCell Compiler 1.9
Compile XLS to EXE, securely hide formulas,vba, protect EXE with regkey/license.
License:Shareware,
$49.00 to buy Size:
3450KB
3)
GeoDataSource World Structural Features Database (Basic Edition) June 2008
GeoDataSource World Structural Database with Latitude Longitude Information
License:Data Only,
$699.95 to buy Size:
37KB
4)
BREAKTRU STOCKWATCH 5.5
Create a portfolio with this spreadsheet for Excel
License:Freeware,
$0 to buy Size:
3829KB
5)
Pop-up Excel Calendar 1.3.3
Enter date values in Excel with a pop-up calendar. Custom formats are supported
License:Shareware,
$19.50 to buy Size:
760KB
6)
PDB to DBF 1.51
PDB to DBF converter allows you to convert your PDB files to DBF format.
License:Shareware,
$29.95 to buy Size:
449KB
7)
SQL Excel 1.01
Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase.
License:Freeware,
$0 to buy Size:
196KB
8)
ReplaceMagic ExcelOnly Standard 2.0.5
Support for Microsoft Word, Excel, PowerPoint, Visio and Project documents
License:Shareware,
$80 to buy Size:
2844KB
9)
ReplaceMagic ExcelOnly Professional 2.0.5
Support for Microsoft Word, Excel, PowerPoint, Visio and Project documents
License:Shareware,
$200 to buy Size:
2842KB
10)
Excel Sales Invoice template 1.0
Blank Excell invoice template
License:Shareware,
$9.90 to buy Size:
26KB
|
|
|
|
|