|
|
|
Main
> Business
& Finance >
Spread Sheets
> ExcelCube |
 ExcelCube
merges, or consolidates, entire worksheets across standard Excel workbook
files without using linking formulas, add-ins, or macros.
A Windows Explorer tree structure is used to organize workbooks into
multiple groups, or levels, of consolidation. This structure is external to
and independent of the workbooks themselves. All of the input data and
consolidated results reside in stand-alone Excel files.
The input level workbooks and consolidated workbooks can be added, deleted,
or moved around a structure using the mouse. This is done in the same way as
moving files and folders in Explorer.
After changes are made to the structure, the results held in the
consolidated workbooks are updated in a few seconds.
In ExcelCube, the folders are more than a name for the group of files below
them. They also represent the workbooks holding the results of the
consolidation of the workbooks below them. ExcelCube creates these workbooks
every time the structure is calculatted.
A single application can organize the same input-level workbooks into
several different and independent structures. Different consolidations can
be made without any duplication of data.
ExcelCube's protocol is simpler and vastly more productive than using
linking formulas or add-ins to add portions of a worksheet across a handful
of workbooks.
The structure makes up a cube of input level and merged workbooks, from
which slices can be taken along any axis without programming. The slice is
placed onto a worksheet in a new workbook. The specification of what a slice
contains can be
changed and re-run in seconds. This represents a deceptively simple OLAP
capability. This feature is referred to as a Cross Section in ExcelCube.
All of the worksheets and in the workbooks can be changed by editing the
worksheets in a single workbook. This is a centralized, one step Maintenance
capability comprising a huge time saver by itself. |
|
Buy
Now |
|
ExcelCube screenshot:
|
|
|
Product
Information
|
-
Version: 4.0
-
Price:
$49.00
-
Size:
24.7MB
-
License:
Shareware
-
Developer:
Quartermain
-
OS:
Windows
All
-
Rating:
|
|
|
|
