{"id":3536,"date":"2023-04-12T15:39:23","date_gmt":"2023-04-12T15:39:23","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/"},"modified":"2023-04-12T15:39:23","modified_gmt":"2023-04-12T15:39:23","slug":"supported-excel-and-tm1-worksheet-functions-by-webworq","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/","title":{"rendered":"Supported Excel and TM1 worksheet functions by WebWORQ"},"content":{"rendered":"<p>Excel and TM1 worksheet expressions supported by WebWORQ include:<\/p>\n<ul>\n<li>Cell references, e.g. =B$22, =Sheet5!$K$6.<\/li>\n<li>Expressions built up of combinations of the following subset of predefined Excel functions and operators:<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Operators:<\/strong>\u00a0+, -, *, &amp;, =, &lt;, &gt;, &gt;=, &lt;=, &lt;&gt;<\/p>\n<p><strong>Logical Functions:<\/strong>\u00a0TRUE, FALSE, NOT, AND, OR, IF<\/p>\n<p><strong>TM1 Functions:<\/strong>\u00a0DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM, DIMIX, DIMSIZ, DNEXT, DNLEV, DTYPE, ELCOMP, ELCOMPN, ELLEV, ELPAR, ELPARN, SUBNM, SUBSIZ<\/p>\n<p><strong>String Functions:<\/strong>\u00a0CONCATENATE, FIND, LEFT, LEN, LOWER, MID, PROPER, RIGHT, SUBSTITUTE, TEXT, TRIM, UPPER<\/p>\n<p><strong>Time Functions:<\/strong>\u00a0DATEVALUE, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, YEAR<\/p>\n<p><strong>Math Functions:<\/strong>\u00a0ABS, AVERAGE, CEILING, FLOOR, MAX, MIN, MOD, PERCENTILE, ROUND, SUM<\/p>\n<p><strong>Lookup and Reference Functions:<\/strong>\u00a0COLUMN, HYPERLINK, ROW, VLOOKUP<\/p>\n<p><strong>Error Checking Functions:<\/strong>\u00a0ISERR, ISERROR, ISNA, NA<\/p>\n<p><strong>Other Excel Functions:<\/strong>\u00a0VALUE<\/p>\n<p><strong>WebWORQ &amp; BoostWORQ Functions:<\/strong><\/p>\n<p>ExpandCount, ExpandMaxCount, ooCubeRights, ooDimensionRights, ooElementRights, ooIsOnWeb, ooGetClientNameOnServer, ooQueryData<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Example:<\/strong>\u00a0=DBSS($B9*Calculation!C7,$B$1,$C$4,$C$5,$C$6,$A9,C$8)<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Special notes<\/strong><\/p>\n<ul>\n<li>WebWORQ does not support the evaluation of cross-worksheet formula references. For example, a formula on a sheet named &#8220;Sheet1&#8221; that references a cell on a sheet named &#8220;Sheet2&#8221;:\n<ul>\n<li>=Sheet2!$A$4<\/li>\n<\/ul>\n<\/li>\n<li>Not all Excel cells referenced by a function need to be in the Range to Publish. For details on the parameters and behaviors of these functions please refer to Excel and TM1 documentation.<\/li>\n<li>Although the Excel VLOOKUP function is supported, we recommend that it be used sparingly. As a matter of &#8220;best practice&#8221;\u00a0we strongly advocate the use of TM1 dimension attributes combined with the DBRA function for lookup purposes in spreadsheets. In the long run, use of attributes leads to easier maintenance and a more robust system.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel and TM1 worksheet expressions supported by WebWORQ include: Cell references, e.g. =B$22, =Sheet5!$K$6. Expressions built up of combinations of the following subset of predefined Excel functions and operators: &nbsp; Operators:\u00a0+, -, *, &amp;, =, &lt;, &gt;, &gt;=, &lt;=, &lt;&gt; Logical Functions:\u00a0TRUE, FALSE, NOT, AND, OR, IF TM1 Functions:\u00a0DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[28],"class_list":["post-3536","post","type-post","status-publish","format-standard","hentry","category-quebit-value","tag-webworq"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT<\/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:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Excel and TM1 worksheet expressions supported by WebWORQ include: Cell references, e.g. =B$22, =Sheet5!$K$6. Expressions built up of combinations of the following subset of predefined Excel functions and operators: &nbsp; Operators:\u00a0+, -, *, &amp;, =, &lt;, &gt;, &gt;=, &lt;=, &lt;&gt; Logical Functions:\u00a0TRUE, FALSE, NOT, AND, OR, IF TM1 Functions:\u00a0DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM,&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:39:23+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"Supported Excel and TM1 worksheet functions by WebWORQ\",\"datePublished\":\"2023-04-12T15:39:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/\"},\"wordCount\":282,\"commentCount\":0,\"keywords\":[\"WebWORQ\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/\",\"name\":\"Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"datePublished\":\"2023-04-12T15:39:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/supported-excel-and-tm1-worksheet-functions-by-webworq\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Supported Excel and TM1 worksheet functions by WebWORQ\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT","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:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/","og_locale":"en_US","og_type":"article","og_title":"Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT","og_description":"Excel and TM1 worksheet expressions supported by WebWORQ include: Cell references, e.g. =B$22, =Sheet5!$K$6. Expressions built up of combinations of the following subset of predefined Excel functions and operators: &nbsp; Operators:\u00a0+, -, *, &amp;, =, &lt;, &gt;, &gt;=, &lt;=, &lt;&gt; Logical Functions:\u00a0TRUE, FALSE, NOT, AND, OR, IF TM1 Functions:\u00a0DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM,&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:39:23+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"Supported Excel and TM1 worksheet functions by WebWORQ","datePublished":"2023-04-12T15:39:23+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/"},"wordCount":282,"commentCount":0,"keywords":["WebWORQ"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/","url":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/","name":"Supported Excel and TM1 worksheet functions by WebWORQ - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"datePublished":"2023-04-12T15:39:23+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/supported-excel-and-tm1-worksheet-functions-by-webworq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Supported Excel and TM1 worksheet functions by WebWORQ"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3536"}],"version-history":[{"count":0,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3536\/revisions"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}