Forget about linking formulas and databases to tie spreadsheet data together.
Consolidating workbooks into any number of levels is one step away.
Excel + An Organizational Chart
ExcelCube makes it easy to combine Excel workbooks into any number of consolidated levels.
All of the Excel workbooks in an application remain free-standing, independent workbooks.
How Consolidation with ExcelCube Works
ExcelCube uses a tree structure to organize Excel workbooks into different levels of consolidation. It is similar to the Windows Explorer structure that defines folders to hold collections of files and other folders.
An ExcelCube structure defines folders to hold files and other folders...but the files are Excel workbooks. And the folders themselves each represent an Excel workbook.
Consolidated data and results from the workbooks beneath the folders in a structure are placed into each folder-level workbook.
Each spreadsheet in each workbook is merged in its entirety with its corresponding spreadsheet in all the other workbooks. Each consolidated folder workbook holds all the data of all the workbooks below it.
The structure may be changed simply by dragging and dropping workbook files and folders. It couldn’t be much easier.
In addition to the organizational structure, ExcelCube incorporates a Blueprint which contains the definitions of the different types of cells found in the workbooks. With this unique approach the data, formulas, titles, and exception logic in the spreadsheets are identified and made available to ExcelCube without any hooks to grab data.
With that, any number of workbooks can be added up and reported without any extra effort. It also allows ExcelCube to treat multiplications and divisions properly, so that real consolidation occurs, as opposed to simple aggregation.
All Excel Files are Free Standing
All of the consolidation is done using the tree structure and spreadsheet cell definition, without any internal Excel references. So the workbooks – detail and consolidated - remain stand-alone Excel workbooks with nothing added to them, and nothing to maintain in the spreadsheets.
A Cube of Data and Results
The end result using the tree structure is a “cube” of information that can be “sliced and diced” to provide the “sweet spot” – that critical piece of knowledge that reveals the key to productivity and profits.