{"id":70658,"date":"2025-03-06T10:48:31","date_gmt":"2025-03-06T10:48:31","guid":{"rendered":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/"},"modified":"2025-03-06T10:48:31","modified_gmt":"2025-03-06T10:48:31","slug":"advanced-consolidation-manager","status":"publish","type":"product","link":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/","title":{"rendered":"Advanced Consolidation Manager"},"content":{"rendered":"<p>Merging tables and consolidating Microsoft Excel data<\/p>\n<p>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.  <\/p>\n<h2>Key Features:<\/h2>\n<ul>\n<li>Advanced Consolidation Manager will help you to consolidate data from different files in one:\n<ul>\n<li>With grouping by worksheets.<\/li>\n<li>By creation of a new worksheet for each file.<\/li>\n<li>By creation of one common table.<\/li>\n<li>With the performance of calculation: summation, calculation of quantity, calculation of average value, etc. <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><\/p>\n<h2>Advanced Consolidation Manager &#8211; Features<\/h2>\n<p>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.  <\/p>\n<p><h4>Features for Version 1.0<\/h4>\n<p>Advanced Consolidation Manager will help you to consolidate data from different files in one:  <\/p>\n<ul>\n<li>with grouping by worksheets;\n<li>by creation of a new worksheet for each file;\n<li>by creation of one common table;\n<li>with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.  <\/li>\n<\/ul>\n<p><h4>Consolidation of data from several files<\/h4>\n<p>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  <\/p>\n<p><h4>Consolidation of data with the performance of calculations<\/h4>\n<p>Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance.   <\/p>\n<p><Table class=\"purple\">   <\/p>\n<table class=\"purple\">\n<tr>\n<th>Function <\/th>\n<th>Purpose<\/th>\n<\/tr>\n<tr>\n<td>Sum<\/td>\n<td>Summation of cell values.<\/td>\n<\/tr>\n<tr>\n<td>Count<\/td>\n<td>Calculation of the number of cells in a certain range.<\/td>\n<\/tr>\n<tr>\n<td>Average<\/td>\n<td>Calculation of average value of cells.<\/td>\n<\/tr>\n<tr>\n<td>Max<\/td>\n<td>Maximum value.<\/td>\n<\/tr>\n<tr>\n<td>Min<\/td>\n<td>Minimal value<\/td>\n<\/tr>\n<tr>\n<td>Product<\/td>\n<td>The product of the values<\/td>\n<\/tr>\n<tr>\n<td>Count Nums<\/td>\n<td>The number of data values that are numbers<\/td>\n<\/tr>\n<tr>\n<td>StDev<\/td>\n<td>An estimate of the standard deviation of a population, where the sample is a  subset of the entire population.<\/td>\n<\/tr>\n<tr>\n<td>StDevP<\/td>\n<td>The standard deviation of a population, where the population is all of the data  to be summarized.<\/td>\n<\/tr>\n<tr>\n<td>Var<\/td>\n<td>An estimate of the variance of a population, where the sample is a subset of the  entire population.<\/td>\n<\/tr>\n<tr>\n<td>VarP<\/td>\n<td>The variance of a population, where the population is all of the data to be  summarized.<\/td>\n<\/tr>\n<\/table>\n<p>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.  <br \/>If you often use a standard data consolidation in Microsoft Excel, you will find the program Advanced Consolidation Manager of a great help.<\/p>\n<h2>Advanced Consolidation Manager &#8211; System Requirements<\/h2>\n<h4>System Requirements<\/h4>\n<p><strong>Operating system requirements: <\/strong> <\/p>\n<ul>\n<li>Microsoft Windows 98\n<li>Microsoft Windows 2000\n<li>Microsoft Windows 2003\n<li>Microsoft Windows XP\n<li>Microsoft Windows Vista  <\/li>\n<\/ul>\n<p><strong>Software requirements: <\/strong> <\/p>\n<ul>\n<li>Microsoft .NET Framework version 2.0\n<li>Microsoft Excel 2000\n<li>Microsoft Excel 2002 (XP)\n<li>Microsoft Excel 2003\n<li>Microsoft Excel 2007  <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Merging tables and consolidating Microsoft Excel data 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 [&hellip;]<\/p>\n","protected":false},"featured_media":70661,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false},"product_brand":[10502],"product_cat":[9309,2016,2035],"product_tag":[],"class_list":{"0":"post-70658","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_brand-mapilab","7":"product_cat-uncategorised","8":"product_cat-digital-workplace","9":"product_cat-documents","11":"first","12":"outofstock","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Advanced Consolidation Manager - QBS Software - French<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Consolidation Manager\" \/>\n<meta property=\"og:description\" content=\"Merging tables and consolidating Microsoft Excel data 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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/\" \/>\n<meta property=\"og:site_name\" content=\"QBS Software - French\" \/>\n<meta property=\"og:image\" content=\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@qbssoftware\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/\",\"url\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/\",\"name\":\"Advanced Consolidation Manager - QBS Software - French\",\"isPartOf\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png\",\"datePublished\":\"2025-03-06T10:48:31+00:00\",\"dateModified\":\"2025-03-06T10:48:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage\",\"url\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png\",\"contentUrl\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shop\",\"item\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/shop\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Advanced Consolidation Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#website\",\"url\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/\",\"name\":\"QBS Software\",\"description\":\"Software delivery platform\",\"publisher\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#organization\",\"name\":\"QBS Software\",\"url\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png\",\"contentUrl\":\"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png\",\"width\":800,\"height\":800,\"caption\":\"QBS Software\"},\"image\":{\"@id\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/qbssoftware\",\"https:\/\/www.linkedin.com\/company\/qbs-software\/\",\"https:\/\/www.youtube.com\/user\/QBSSoftwareLtd\"],\"email\":\"info@qbssoftware.com\",\"telephone\":\"+44 (0) 20 8733 7100\",\"publishingPrinciples\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/privacy-policy\/\",\"ethicsPolicy\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/\",\"diversityPolicy\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/\",\"diversityStaffingReport\":\"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Advanced Consolidation Manager - QBS Software - French","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Consolidation Manager","og_description":"Merging tables and consolidating Microsoft Excel data 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 [&hellip;]","og_url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/","og_site_name":"QBS Software - French","og_image":[{"url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png","width":1,"height":1,"type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@qbssoftware","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/","url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/","name":"Advanced Consolidation Manager - QBS Software - French","isPartOf":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage"},"image":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png","datePublished":"2025-03-06T10:48:31+00:00","dateModified":"2025-03-06T10:48:31+00:00","breadcrumb":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#primaryimage","url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png","contentUrl":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2025\/03\/advancedcm_20220503-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/product\/advanced-consolidation-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/shop\/"},{"@type":"ListItem","position":3,"name":"Advanced Consolidation Manager"}]},{"@type":"WebSite","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#website","url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/","name":"QBS Software","description":"Software delivery platform","publisher":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#organization","name":"QBS Software","url":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png","contentUrl":"https:\/\/www.qbssoftware.com\/fr\/wp-content\/uploads\/sites\/5\/2024\/06\/qbs-logo-d-i.png","width":800,"height":800,"caption":"QBS Software"},"image":{"@id":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/qbssoftware","https:\/\/www.linkedin.com\/company\/qbs-software\/","https:\/\/www.youtube.com\/user\/QBSSoftwareLtd"],"email":"info@qbssoftware.com","telephone":"+44 (0) 20 8733 7100","publishingPrinciples":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/privacy-policy\/","ethicsPolicy":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/","diversityPolicy":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/","diversityStaffingReport":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/corporate-responsibility-charter\/"}]}},"_links":{"self":[{"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product\/70658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/comments?post=70658"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/media\/70661"}],"wp:attachment":[{"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/media?parent=70658"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_brand?post=70658"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_cat?post=70658"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/qbs01devsc.qbssoftware.com\/fr\/wp-json\/wp\/v2\/product_tag?post=70658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}