 |
 |
 |
|
An Excel add-in for automatic construction and management of complex formula.
|
|
 |
|
 |
|
|
|
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.
|
|
|
Free / Download (1.1 MB)
|
|
|
| Download |
Avg. User Rating |
Overall |
|
-
|
-
|
-
|
| 0 / 0 (total / last month) |
| 25-07-2004 |
| English |
| Win95, Win98, WinME, WinNT 3.x, WinNT 4.x, WinXP, Windows2000, Windows CE |
| Excel 97' or later |
| No Install Support |
|
|
Latest reviews: |
|
| JPEG Lossless Rotator 5.0 |
Rating:  |
| This thing is completely useless. Even Microsoft Paint can rotate image by 90 degree increments, which is all this does! |
| Typer Shark Deluxe 1 |
Rating:  |
| I Like it a lot... I want to play. Good and Its an excellent travel tool, which provide even sharability of the choosen deals with your loved ones. |
| Forex Strategy Builder 2.5.3.0 |
Rating:  |
| It's useful! FSB tests a strategy very fast, includes an automatic strategy generator.
It uses different method of bar interpolation and that make... |
|
|
