1.0Gathering Tools - Improve the reliability and security of Excel processeshttps://www.gathering-tools.com/en/rich600338<blockquote class="wp-embedded-content" data-secret="9bpvCjDXeP"><a href="https://www.gathering-tools.com/en/documentation/multi-tab-data-synthesis/">Multi-tab Data Synthesis</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.gathering-tools.com/en/documentation/multi-tab-data-synthesis/embed/#?secret=9bpvCjDXeP" width="600" height="338" title="“Multi-tab Data Synthesis” — Gathering Tools - Improve the reliability and security of Excel processes" data-secret="9bpvCjDXeP" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.gathering-tools.com/wp-includes/js/wp-embed.min.js </script> General For patterns and multi-tabs, it isn’t possible to construct a formula outside the pattern or multi-tab that points directly to a cell in the pattern or multi-tab. In the case of a pattern, functions of access to tables (INDEX, MATCH, SEARCH, SUM, SUMIF etc…) may be used. GTMS.xxxx functions generally have no equivalent in Excel for accessing ranges located “transversely” on tabs (3D references exist in Excel but they can only be used by a small number of functions). This article gives application examples for the two main non-multi-tab data extraction techniques: use of GTMS.function_agreg(expression) which allows to sum the values of […]https://www.gathering-tools.com/wp-content/uploads/2022/01/Calculation-engine_General.png970537