{"id":24998,"date":"2025-03-27T14:43:40","date_gmt":"2025-03-27T13:43:40","guid":{"rendered":"https:\/\/tecurat.de\/?p=24998"},"modified":"2026-02-04T12:11:08","modified_gmt":"2026-02-04T11:11:08","slug":"calculated-fields-automated-data-analysis-in-orcanos","status":"publish","type":"post","link":"https:\/\/tecurat.de\/en\/calculated-fields-automated-data-analysis-in-orcanos\/","title":{"rendered":"Calculated Fields: Automated data analysis in Orcanos"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"24998\" class=\"elementor elementor-24998 elementor-24979\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-07a3e96 e-con-full e-flex e-con e-parent\" data-id=\"07a3e96\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-11fedfa elementor-widget elementor-widget-text-editor\" data-id=\"11fedfa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>With <strong>Calculated Fields<\/strong>, the spreadsheet functionality familiar from Excel has also been available for the Orcanos platform since July 2024. The<strong> automated consolidation and processing of large volumes of data<\/strong> and the <strong>availability of process KPIs in real time<\/strong> are critical challenges in the design control processes of medical technology, where precise data processing and regulatory compliance are simply indispensable.<\/p><h3>Basic Architecture and Functionality of Calculated Fields<\/h3><p>One of the features we particularly liked when looking at the new functionality is the context-based formula definition. In other words, Calculated Fields works on three hierarchical levels (see figure below).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61e592a elementor-widget elementor-widget-image\" data-id=\"61e592a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"579\" src=\"https:\/\/tecurat.de\/wp-content\/uploads\/2025\/03\/14-03-2025_16-06-12.png\" class=\"attachment-large size-large wp-image-24981\" alt=\"Diagram illustrating the relationship and data flow between Parent Work Item, Work Item, and Child Work Item 1. - Parent Work Item (purple box) contains Input X and fields D, E, and F. - Work Item (green box) receives Input X from Parent Work Item and produces outputs X, Y, and Z. - Output X is a function of the parent&#039;s Input X. - Output Y is a function of inputs A, B, and C. - Output Z is a function of child inputs Z1 to Zn. - Inputs A, B, and C feed into the Work Item. - Child Work Item 1 (yellow box) receives Input Z1 and contains fields V, O, P, and Q. - Multiple Child Work Items are implied by stacked yellow boxes. - Arrows indicate data flow from Parent to Work Item to Child Work Items and back. - Two labeled arrows on the right: - Purple arrow pointing down labeled &quot;Integration.&quot; - Yellow arrow pointing up labeled &quot;Aggregation.&quot; - Circular green arrow between Integration and Aggregation arrows suggests a cyclical process.\" srcset=\"https:\/\/tecurat.de\/wp-content\/uploads\/2025\/03\/14-03-2025_16-06-12.png 848w, https:\/\/tecurat.de\/wp-content\/uploads\/2025\/03\/14-03-2025_16-06-12-300x217.png 300w, https:\/\/tecurat.de\/wp-content\/uploads\/2025\/03\/14-03-2025_16-06-12-768x556.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Figure 1: Context-based formula definition on three hierarchical levels<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31618c2 elementor-widget elementor-widget-text-editor\" data-id=\"31618c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Calculations are performed in the following ways:<\/p><p>1. <strong>Calculations within the fields of a work item<\/strong> by directly accessing the fields of the current item via [*Me.fieldname*]. For example, costs can be calculated from hours worked and hourly rates, or variances between target and actual values.<\/p><p>2. <strong>Integration of higher-level data from parent items<\/strong> via [*Parent.Fieldname*]. For example, parameters that are to be used for many child data objects need only be defined once in the parent item, or the child items can be labeled centrally if the data objects are to be evaluated in different queries.<\/p><p>3. <strong>Aggregation of child data records<\/strong> by [*Children.Fieldname*]. This is a very powerful feature. It ranges from simply counting the number of objects or summing quantities to searching for extreme values or determining statistical key figures. In conjunction with the embedded filters in the description field of the parent item, the subsets searched for according to the criteria can also be automatically determined and displayed in tabular form.<\/p><p>As you can see from these few examples, this opens up a whole new world of possibilities for dealing with the data. Much more complex or even entirely new information can be visualized in the <strong>dashboards<\/strong>, taking real-time monitoring to a whole new level.<\/p><h3>Mathematical and statistical operators<\/h3><ul><li>Orcanos currently supports over 40 functions from the following categories in the Calculated Fields:<\/li><li>Basic arithmetic operations (+, -, *, \/, ^)<\/li><li>Statistical functions (STDEV, STDEVP, COUNT)<\/li><li>Trigonometric functions (SIN, COS, TAN with radians\/conversion)<\/li><li>Logarithmic functions (LN, LOG10, EXP)<\/li><\/ul><p>Further functions, such as the if-then function, which supports the aggregation of data under logical criteria, are in preparation. A current list of available functions can be found on this <a href=\"https:\/\/help.orcanos.com\/knowledgebase\/calculated-fields\/\" target=\"_blank\" rel=\"noopener\">Orcanos<\/a> page<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3798c80 elementor-widget elementor-widget-text-editor\" data-id=\"3798c80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h3>Implementation<\/h3>\n<p>This functionality is currently available for text and numeric data fields. It can be defined in secure administrator mode through the field properties in the eForms Layout Editor. The step-by-step procedure is described on this <a href=\"https:\/\/help.orcanos.com\/knowledgebase\/calculated-fields\/\" target=\"_blank\" rel=\"noopener\">Orcanos<\/a> page. Calculated fields are marked with a green <span style=\"color: #008000;\">fx<\/span> on the forms and cannot be changed by the application user. The function used for the field is displayed when you move the mouse over the calculated field.<\/p>\n<h3>Real-time validation and error handling<\/h3>\n<p>As is usual with Orcanos, a <strong>multi-level validation concept<\/strong> has also been implemented for the calculated fields:<\/p>\n<ul>\n<li><strong>Syntax check<\/strong> when entering formulas<\/li>\n<li><strong>Type compatibility checks<\/strong> (e.g. text vs. numeric fields)<\/li>\n<li><strong>Runtime error detection<\/strong> such as division by zero<\/li>\n<\/ul>\n<p>A faulty field, for example, displays the detailed messages, such as:<\/p>\n<p><em>\u201cError 204: \u2018Patient Weight\u2019 field in parent item is not numeric\u201d<\/em><\/p>\n<p>This significantly speeds up the troubleshooting process during the development of the data concepts.<\/p>\n<h3>Conclusion and outlook<\/h3>\n<p>The Calculated Fields in Orcanos are a powerful tool for managing the complex requirements of medical devices development. Thanks to their deep integration into the ALM workflow, they enable:<\/p>\n<ul>\n<li>Reduction of manual data maintenance by up to 75<\/li>\n<li>Real-time compliance monitoring of critical parameters<\/li>\n<li>Extensive traceability across the entire product lifecycle<\/li>\n<\/ul>\n<p>The Calculated Fields functions are currently only available in the <strong>Professional license package<\/strong>. I think that these functions offer such fundamental enhancement possibilities to the entire platform that Calculated Fields should also be available in the Essential package. This is something that Orcanos should think about again<br><strong>Future enhancements<\/strong>, such as the If-Then function, also allow data to be consolidated under logical aspects. Combined with <strong>machine learning models (Ask Paul)<\/strong>, this is a big step in the digital world towards real-time monitoring and evaluation of processes and predicate logic.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Boost Efficiency: Calculated Fields Revolutionize Orcanos!<\/p>\n","protected":false},"author":2,"featured_media":25237,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_classifai_error":"","_classifai_text_to_speech_error":"","_classifai_text_to_speech_scheduled":false},"categories":[447,448],"tags":[439,440,441],"class_list":["post-24998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-orcanos-3","category-unkategorisiert","tag-calculated-fields","tag-data-aggregation","tag-orcanos-2"],"_links":{"self":[{"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/posts\/24998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/comments?post=24998"}],"version-history":[{"count":1,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/posts\/24998\/revisions"}],"predecessor-version":[{"id":26331,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/posts\/24998\/revisions\/26331"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/media\/25237"}],"wp:attachment":[{"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/media?parent=24998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/categories?post=24998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tecurat.de\/en\/wp-json\/wp\/v2\/tags?post=24998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}