Structurizer

With only one formula Structurizer allows querying your Excel data table on multiple dimensions, consolidated hierarchies, various period grouping possibilities (e.g. YTD, QTD,…), textual and numeric comparison criteria!

3 simple steps to extract maximum understandings from your Excel database…

1. Define your hierarchies by creating an easy parent-child table in any of your Excel files.

Structurizer allows you to build your custom hierarchies on your base data, for example, grouping of product codes to product groups, product lines and brands reflecting (you can easily define your grouping level).

Structurizer provides various further possibilities to manage your hierarchy definition tables. Please refer to the demo videos or the user guide for further information.

2. Load with a click the hierarchy definitions into Structurizer's memory.

Once custom hierarchies are defined and loaded they can be applied in any of your or your colleagues Excel workbooks. No more redundant and time consuming lookup formula recoding needed!

Structurizer provides various functionality to manage your hierarchy loads, export, sharing with other users etc.

3. Apply Structurizer's worksheet functions to create impressive analysis and dynamic reports on top of your Excel database.

Structurizer provides numerous worksheets functions to easily retrieve range totals (or other statistical information) based on combined multidimensional, hierarchical and conditional criteria. It allows to analyse your Excel database in depth and to build dynamic reporting applications.

In addition Structurizer provides:

Numerous worksheets functions to test and ensure the data integrity of defined hierarchies and the Excel database table.

Worksheet functions to browse hierarchical entity relation ships.

Detailed error descriptions: In case you enter erroneous function parameters, CellworXs® will return a detailed error description in the cell, rather than a generic "#VALUE!" error. A considerable timesaving when you debug a worksheet function.

And much more to discover. For more details or examples, please check the demo videos or download the CellworXs® user guide.

"CellworXs® puts what I would call a 'virtual analysis cube' on your Excel databases. With the possibility to define your own data hierarchies - and once defined in every spreadsheet file applicable - it really helps to discover all hidden customer analytics. CellworXs® has a good return value for the purchase cost; not only for the analysis time saved but especially for the information and conclusions gained!"

Peter Panduro, Customer Operations Director Europe, Denmark