|

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 |
|
|
| Top Business & Finance / Spreadsheets softs |
|
1)
Excel Unique & Duplicate Data Remover 1.2
Find (search) and remove (delete) duplicate and unique entries, values, cells, records, rows, numbers in any list or table with this Excel Addin. Finding and removing duplicates and uniques will save you hours of tedious work.
License:Shareware,
$29.99 to buy Size:
383KB
2)
Excel VBA Models Set 1 XL-VBA1.0
Excel VBA Models with Open Source Code -
Option Greeks, Lotto Number, Probability, Normal Distribution, Monte Carlo simulation, Black-Scholes, Binomial Option Pricing, Portfolio Optimization, Multiple Regression, Bootstrap, Multivariate distribution
License:Shareware,
$14.95 to buy Size:
433KB
3)
Unit Converter for Excel 3.1
Unit Converter for Excel is an addin for the Microsoft Excel to perform various conversions between many types of measurement units.
License:Shareware,
$24 to buy Size:
1048KB
4)
Merge Workbooks 2.0
Merge Workbooks is an Excel macro that will combine several Excel workbooks into one workbook. The user selects the workbooks to merge and the macro copies all the worksheets in those workbooks into a new workbook.
License:Shareware,
$9.95 to buy Size:
344KB
5)
Excel Backup File Save Scheduler 1.1
Automatically create backup save copies of your Excel files while you work. You set the how often to save, where to save, and what file name to use. This Excel Add-in resides within Excel making usage simple.
License:Shareware,
$19.82 to buy Size:
430KB
6)
MITCalc - Multi pulley calculation 1.12
The calculation is developed for geometrical designs of belt and chain transmissions with more sprocket wheels. Application is developed in MS Excel, is multi-language, supports Imperial and Metric units and support many 2D CAD systems.
License:Shareware,
$12 to buy Size:
1316KB
7)
DoneEx XCell Compiler 1.7.1
Compile XLS to EXE application (which requires MS Excel to run) with securely hidden formulas. Main features:protect EXE with regkey; set limit of work period for EXE file; save/load changed data; apply your own image as a splash screen; and more.
License:Shareware,
$49.00 to buy Size:
2860KB
8)
RemodelCost Estimator for Excel 3.01
RemodelCost Estimator for Excel. Remodel Construction Cost Estimator. Designed for home remodelers, builders, estimators. Built-in user-modifiable unit cost data for local city indexes and all cost categories covering remodel construction.
License:Shareware,
$45.00 to buy Size:
4394KB
9)
Customer Invoice Template 1.0
The customer invoicing system is an Excel invoice template with ability to store created invoices, products and customer details and perform advanced order sales reporting.
License:Shareware,
$26.00 to buy Size:
292KB
10)
Profit Loss Report Spreadsheet 3.3
Award-winning Excel spreadsheet is a simple alternative to accounting software for a small business to track income and expenses. Easier for you and tax preparer when tax time rolls around. Save time, money and tax time headaches. Requires MS Excel.
License:Demo,
$19.95 to buy Size:
425KB
|
|
| New Business & Finance / Spreadsheets softs |
|
1)
United States ZIP Code Database (Gold + Multi-County Edition) December 2007
United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA, CBSA and Census 2000 data.
License:Commercial,
$99.95 to buy Size:
306KB
2)
Unit Converter for Excel 3.1
Unit Converter for Excel is an addin for the Microsoft Excel to perform various conversions between many types of measurement units.
License:Shareware,
$24 to buy Size:
1048KB
3)
DoneEx XCell Compiler 1.7.1
Compile XLS to EXE application (which requires MS Excel to run) with securely hidden formulas. Main features:protect EXE with regkey; set limit of work period for EXE file; save/load changed data; apply your own image as a splash screen; and more.
License:Shareware,
$49.00 to buy Size:
2860KB
4)
Registry Clean 2008.062
RegClean - Fix your PC Errors! RegCLEAN will scan your registry, finding all of the errors causing your PC problems, and will then repair those errors instantaneously. - FREE DOWNLOAD
License:Shareware,
$19.95 to buy Size:
1608KB
5)
GeoDataSource World Structural Features Database (Basic Edition) November 2007
GeoDataSource World Structural Database Basic Edition contains structural feature names in original language and English, feature type classifications, country names in FIPS and ISO, regions and sub-regions. Database available in text format.
License:Data Only,
$699.95 to buy Size:
37KB
6)
Insta-Graph 1.0
Graph cell values automatically and instantly by selecting a range in Excel.
License:Shareware,
$47.97 to buy Size:
9530KB
7)
Retirement Workbook - Basic 5.8.92
Computes employer matches from salary and contribution. Two computational tiers
License:Shareware,
$29.95 to buy Size:
6182KB
8)
PaintCOST Estimator for Excel 2.0
Make paint cost estimating productive and fun with this easy-to-use software! Designed specifically for painting and wallcovering contractors, decorators, builders, remodelers, and do-it-yourself individuals.
License:Shareware,
$59.00 to buy Size:
4833KB
9)
ExcelFile Viewer 1.75
This tool allow to read/open the MS Excel files.
Application don't use any external libraries (no MS Excel/Office, no BDE, no ODBC, no ADO)
You may view the data from any sheet in xls-file, trace the internal stored BIFF-records within xls-file.
License:Shareware,
$20 to buy Size:
750KB
10)
ReplaceMagic ExcelOnly Standard 1.8.2
Have you ever been in situation that you need to change text, header, footer, comments, OLE object links, hyperlinks or even more in thousands of files and you had to open each file manually to make changes? With ReplaceMagic that is very simple.
License:Shareware,
$62 to buy Size:
2068KB
|
|
|
|