Advanced Consolidation Manager

acm_48x48

Advanced Consolidation Manager

$39

Add-on for advanced table merging and data consolidating in MS Excel 2000-2010. Advanced Consolidation Manager will allow you to process any number of files per one program run as well as to combine data from different files in one.

Download Trial

Advanced Consolidation Manager is designed for merging tables and consolidating Microsoft Excel data. In comparison to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will allow you to process any number of files per one program run as well as to combine data from different files in one.
Click here for more screenshots
Advanced Consolidation Manager will help you to consolidate data from different files in one:
  • with grouping by worksheets;
  • by creation of a new worksheet for each file;
  • by creation of one common table;
  • with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.
Consolidation of data from several files
If you have a number of similar files or you regularly get reports in Microsoft Excel files and you need to consolidate them, Advanced Consolidation Manager can easily solve these tasks. Specify which files and their worksheets to be combined and the location where the results are to be stored – Advanced Consolidation Manager will perform these tasks. The program stores the results either in a common worksheet or in several ones. There is also a possibility to group worksheets in different Microsoft Excel files. For example:
The example for Advanced Consolidation Manager add-in
Consolidation of data with the performance of calculations
Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance of the following calculations:
Function
Purpose
Sum
Summation of cell values
Count
Calculation of the number of cells in a certain range
Average
Calculation of average value of cells
Max
Maximum value
Min
Minimal value
Product
The product of the values
Count Nums
The number of data values that are numbers
StDev
An estimate of the standard deviation of a population, where the sample is a subset of the entire population
StDevP
The standard deviation of a population, where the population is all of the data to be summarized
Var
An estimate of the variance of a population, where the sample is a subset of the entire population
VarP
The variance of a population, where the population is all of the data to be summarized
In contrast to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will enable you to perform the above mentioned operations on the unlimited number of files. Moreover, if files have a similar structure, you can specify a common range which will be applied to all these files. In other words, you can specify one a range of cells which is to be used for consolidation and this range will be used for all selected worksheets.
If you often use a standard data consolidation in Microsoft Excel, you will find the program Advanced Consolidation Manager of a great help.
Advanced Consolidation Manager Screenshots
Advanced Consolidation Manager
Advanced Consolidation Manager
Welcome
Welcome
Select several files
Select several files
Select several sheets
Select several sheets
Adding new data
Adding new data
Giving names
Giving names
Giving names and locations
Giving names and locations
Final new sheet
Final new sheet
Successfully finished
Successfully finished
Function
Function
Select cell range
Select cell range
Final new sheet
Final new sheet
Results
Results
License type
USD
Single user license    
$39
5-Users license    
$159
10-Users license    
$249
* If you are interested in purchasing more than 10 users licenses, volume prices are available. Please contact us at sales@unitedaddins.com to get an attractive quote.