{"id":55910,"date":"2022-06-30T11:51:16","date_gmt":"2022-06-30T03:51:16","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/?page_id=55910"},"modified":"2024-11-22T14:05:53","modified_gmt":"2024-11-22T06:05:53","slug":"automatic-case-prioritisation-4-6-1","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/cases\/automatic-case-prioritisation\/automatic-case-prioritisation-4-6-1\/","title":{"rendered":"Automatic Case Prioritisation (4.6.1)"},"content":{"rendered":"\n<p class=\"left-bar\">This article applies to P2 Explorer 4.6.1. For the latest help, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/cases\/automatic-case-prioritisation\/\">Automatic Case Prioritisation<\/a>.<\/p>\n<p class=\"note\"><strong>Note: <\/strong>These steps should be performed by administration users who have direct access to the installation directory.<\/p>\n<p class=\"intro-text\">This page describes how to create and maintain the <strong>AutoCaseCalculations<\/strong> spreadsheet, which enables cases to be automatically prioritised in Case Management.<\/p>\n<p class=\"intro-text\">When Explorer is installed, a template spreadsheet is added to the \\<em>P2 Explorer\\Case Management\\Template<\/em> directory on the Explorer server.\u00a0The Server service uses the rules defined here to update case priority. You may need to update the rules, or add rules for another category.<\/p>\n<p class=\"intro-text\">To enable auto-prioritisation, make a copy of this spreadsheet, customise it for your categories, and save it to the <span style=\"color: #000000;\"><b>Case Management\u00a0<\/b><\/span>folder, so that the Server service can access it:<\/p>\n<ol class=\"intro-text\">\n<li><strong>Copy<\/strong> the sample spreadsheet from the spreadsheet in the <strong>CaseManagement\\Template <\/strong>folder under your Explorer directory. E.g.<br \/>\n<em>C:\\Program Files\\P2 Energy Solutions\\P2 Explorer\\Case Management\\Template\\ AutoCaseCalculations.xlsx<\/em><br \/>\n\u00a0<\/li>\n<li><strong>Update<\/strong> the spreadsheet (for detailed instructions, read the rest of this article).\n<ul class=\"intro-text\">\n<li>Open the spreadsheet.<\/li>\n<li>Update priority numbers and\/or colours for a particular cell in the grid.<\/li>\n<li>To <a href=\"#Adding_Categories\">add a new category<\/a>, create a copy of a worksheet tab and give it exactly the same name as the category.<\/li>\n<li>Save the spreadsheet.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Copy<\/strong> the updated spreadsheet into the <strong>Case Management<\/strong> folder of that same directory, e.g.\u00a0<br \/>\n<em>C:\\Program Files\\P2 Energy Solutions\\P2 Explorer\\Case Management\\AutoCaseCalculations.xlsx<\/em><\/li>\n<\/ol>\n<p class=\"intro-text\">The following sections describe how the Server service reads the spreadsheet.<\/p>\n<h2 class=\"page-subheading\">Category Worksheets<\/h2>\n<p class=\"intro-text\">The spreadsheet uses a separate worksheet for each category.<\/p>\n<ul>\n<li class=\"intro-text\">If a category does not have a worksheet, then no automatic priority updates are made.<\/li>\n<li class=\"intro-text\">If there is a category worksheet that does not match a category, it is not used.<\/li>\n<\/ul>\n<p class=\"intro-text\">For example, if your categories are Financial, Operational, Environmental, Occupational Health and Safety, and Maintenance, you can have a tab for each of these in your spreadsheet.\u00a0In the following example, there are five categories, each with its own worksheet:<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44142 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image.png\" alt=\"\" width=\"785\" height=\"94\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image.png 785w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-768x92.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-150x18.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-24x3.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-36x4.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-48x6.png 48w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<ul class=\"intro-text\">\n<li><strong>In the spreadsheet, optionally create a separate worksheet for each known category<\/strong>.<\/li>\n<\/ul>\n<h2>Components of the Worksheet<\/h2>\n<p class=\"intro-text\">Here is an example of a worksheet for the Operational category:<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44143 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1.png\" alt=\"\" width=\"1210\" height=\"299\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1.png 1210w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1-768x190.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1-150x37.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1-36x9.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-1-48x12.png 48w\" sizes=\"auto, (max-width: 1210px) 100vw, 1210px\" \/><\/a><\/p>\n<p class=\"intro-text\">All worksheets should follow the same structure,\u00a0as follows:<\/p>\n<ul class=\"intro-text\">\n<li>Header row (Row 1)<\/li>\n<li>Impacts (Row 2)<\/li>\n<li>Metric and Urgency (Row 3)<\/li>\n<li>Cross-reference (Rows 4 onwards)<\/li>\n<li>Priority cells<\/li>\n<\/ul>\n<h3>Header Row<\/h3>\n<p class=\"intro-text\">Give each worksheet a header row containing <strong>Metric<\/strong>\u00a0(in Column C) for determining <strong>Impact<\/strong>. Each impact is an expression calculation in columns D onwards.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44144 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23.png\" alt=\"SNAGHTML8165cd23\" width=\"587\" height=\"45\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23.png 587w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23-150x11.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23-24x2.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23-36x3.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml8165cd23-48x4.png 48w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><\/p>\n<p class=\"intro-text\">(1) Type an expression in each of the Metric rows (for Urgency).<\/p>\n<p class=\"intro-text\">(2) Type an expression in each of the Impact columns (for Impact).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44145 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2.png\" alt=\"\" width=\"605\" height=\"164\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2.png 605w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2-150x41.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2-36x10.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-2-48x13.png 48w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<p class=\"left-bar\">Read the <a href=\"#Metrics\">Metrics<\/a>\u00a0section below, to understand how the Server service evaluates data in the update.<\/p>\n<h3>Row Two<\/h3>\n<p class=\"intro-text\">This row contains the names of the impacts, ranging from <strong>Insignificant<\/strong> through to <strong>Severe<\/strong>. You may choose as few as you like of these.<\/p>\n<p class=\"note\">The names below are only examples. You can have as many or as few of these as you choose.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44146 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1.png\" alt=\"SNAGHTML816ae8c1\" width=\"605\" height=\"29\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1.png 605w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1-150x7.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1-24x1.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1-36x2.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816ae8c1-48x2.png 48w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<h3>Row Three<\/h3>\n<p class=\"intro-text\">The third row contains headings for <strong>Metric<\/strong> and <strong>Urgency<\/strong>, in columns A and B.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44147 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3.png\" alt=\"\" width=\"238\" height=\"25\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3.png 238w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3-150x16.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3-24x3.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3-36x4.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-3-48x5.png 48w\" sizes=\"auto, (max-width: 238px) 100vw, 238px\" \/><\/a><\/p>\n<h3>Rows Four onwards<\/h3>\n<p class=\"intro-text\">The next rows contain a metric expression corresponding to an urgency (ranging from <strong>Critical<\/strong> down to <strong>None<\/strong>), as well as a priority number.<\/p>\n<p class=\"note\">The Urgencies can be named differently from the ones shown below. You can have as many or as few of these as you choose.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916.png\" rel=\"lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44148 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916.png\" alt=\"SNAGHTML816c7916\" width=\"540\" height=\"89\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916.png 540w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916-150x25.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916-24x4.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916-36x6.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/snaghtml816c7916-48x8.png 48w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<h3>Priority Cells<\/h3>\n<p class=\"intro-text\">Each grid cell in the intersection between <strong>Impact<\/strong> and <strong>Urgency<\/strong> is given a number, in black or in colour. This is used to update the case\u2019s priority. Cell <strong>D5<\/strong> in the example below has a <strong>High<\/strong> Urgency, but an <strong>Insignificant<\/strong> Impact, and has a priority number of <strong>6<\/strong>, colour <strong>black<\/strong>.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4.png\" rel=\"lightbox-7\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44149 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4.png\" alt=\"\" width=\"589\" height=\"162\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4.png 589w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4-150x41.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4-36x10.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-4-48x13.png 48w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/a><\/p>\n<h2>Metrics<\/h2>\n<p class=\"intro-text\">When the service evaluates each case to update its priority it goes through the different metrics, evaluating at each point at the time of the update.<\/p>\n<p class=\"intro-text\">Where data is specified as part of the metric equation, P2 Server does a single point fetch, to get the data\u2019s value at the time specified in <strong>PriorityCalculatorTime.<\/strong><\/p>\n<h3>Metric Syntax<\/h3>\n<p class=\"intro-text\">Each metric should evaluate to a <strong>True<\/strong> or <strong>False<\/strong> outcome. Using tokens that relate to each case, you can specify simple or complex expressions using logical operators (greater than, less than, equal to, etc.), comparison operators, Mathematical operators (addition, subtraction, etc.) Logical operators (And\/Or), and tokens (for Case Comment Count, Case Entity, and Case Duration).<\/p>\n<p class=\"intro-text\">The syntax used here is based on Server's syntax (see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/\">Calculations<\/a> for a complete reference).<\/p>\n<h4>Mathematical Operators<\/h4>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">+<\/td>\n<td>Addition<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">-<\/td>\n<td>Subtraction<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">*<\/td>\n<td>Multiplication<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\/<\/td>\n<td>Division<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">%<\/td>\n<td>Modulus<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">**<\/td>\n<td>Exponent<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Logical Operators<\/h4>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">&amp;&amp;<\/td>\n<td>And<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">||<\/td>\n<td>Or<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Comparison Operators<\/h4>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">==<\/td>\n<td>Equal<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">!=<\/td>\n<td>Not Equal<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">&lt;<\/td>\n<td>Less Than<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">&lt;=<\/td>\n<td>Less Than or Equal<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">&gt;<\/td>\n<td>Greater Than<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">&gt;=<\/td>\n<td>Greater Than or Equal<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Using Tokens<\/h4>\n<p class=\"intro-text\">As well as using attributes of named entities (as used in the example above), you can use the following Tokens in the metric expressions:<\/p>\n<p class=\"intro-text\"><strong>Duration<\/strong><\/p>\n<p class=\"intro-text\">The duration is the total time that the case has been open, measured in hours, minutes and seconds (HH:MM:SS).<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Syntax<\/strong><\/td>\n<td><strong>Example<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{Duration}}<\/td>\n<td>\n<p>{{duration}} &gt; {du'06:00:00'}<\/p>\n<p>Is duration of the case greater than 6 hours?<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Entity<\/strong><\/p>\n<p class=\"intro-text\">The entity that the case was raised against. This could be a calculation, a tag, or an attribute depending on what process input was used for the Sentinel test.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Syntax<\/strong><\/td>\n<td><strong>Examples<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{{Entity}}}<\/td>\n<td>\n<ul>\n<li>{{{Entity}}[FLOWING]:Gas Flowrate} &lt; 5<br \/>\nIs the gas flowrate for the case\u2019s entity (for example , \u2018Sapphire\u2019), in the FLOWING template less than 5?<br \/>\n\u00a0<\/li>\n<li>{{{Entity}}} &gt; 90<br \/>\nUsing a tag, is the tag entity (example 15HH.PV) value greater than 90?<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Count<\/strong><\/p>\n<p class=\"intro-text\">For cases that belong to a category using Case Aggregates, Count = the number of comments against the case.<\/p>\n<p class=\"note\">Case Aggregation is set in Sentinel, and only applies to Sentinel-raised cases.<\/p>\n<p class=\"intro-text\">For cases that belong to a category using not Case Aggregates , Count = 0.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Syntax<\/strong><\/td>\n<td><strong>Example<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{Count}}<\/td>\n<td>\n<p>{{Count}}\u00a0 &gt; 8<\/p>\n<p>Where Case Aggregates is used for the category, does the latest open case for the category have more than 8 comments?<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Examples<\/h3>\n<p class=\"intro-text\">For more complex metrics, you can use calculations as part of a metric expression.\u00a0<\/p>\n<p class=\"intro-text\"><strong>Example 1<\/strong>:\u00a0Is the gas flowrate for the case\u2019s entity (for example , \u2018Sapphire\u2019), in the FLOWING template greater than or equal to 5 and less than 7?<\/p>\n<pre class=\"lang:tsql decode:true \">{{{Entity}}[FLOWING]:Gas Flowrate} &gt;= 5 &amp;&amp; {{{Entity}}[FLOWING]:Gas Flowrate} &lt; 7<\/pre>\n<p>&nbsp;<\/p>\n<p class=\"intro-text\"><strong>Example 2<\/strong>:\u00a0Is the gas flowrate for the case\u2019s entity (for example , \u2018Sapphire\u2019), in the FLOWING template greater than or equal to 5 and is the cases duration greater than 6 hours?<\/p>\n<pre class=\"lang:tsql decode:true \">{{{Entity}}[FLOWING]:Gas Flowrate} &gt;= 5 &amp;&amp; {{duration}} &gt; {du'06:00:00'}<\/pre>\n<p>&nbsp;<\/p>\n<h2 class=\"page-subheading\">How the Service Evaluates the Rules<\/h2>\n<p class=\"intro-text\">The service reads the spreadsheet and updates a rules table in the Server database. The service then uses the database table when it updates priorities and colours.<\/p>\n<p class=\"intro-text\">Here is an explanation of how the service updates each case, following the logic of the spreadsheet (although in reality using database tables).<\/p>\n<p class=\"intro-text\">To make it easier to visualise and understand the logic, the steps refer to the spreadsheet, rather than the database tables. This will also make it easier for you to update the spreadsheet, to match the same working logic.<\/p>\n<p class=\"intro-text\">The following example uses the worksheet for the Operational Category:<\/p>\n<p class=\"intro-text\"><strong>Step 1<\/strong>. The service evaluates each of the <strong>Impact<\/strong> cell\u2019s rules (left to right) until it evaluates to FALSE. Below we are evaluating the Impact Row from Left to Right: first, second, third and fourth.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>(1<sup>st<\/sup> Metric)<\/td>\n<td>(2<sup>nd<\/sup> Metric)<\/td>\n<td>(3<sup>rd<\/sup> Metric)<\/td>\n<td>(4<sup>th<\/sup> Metric)<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td>Minor<\/td>\n<td>Major<\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #bddcf1; padding-left: 5px;\"><strong>First<\/strong><\/td>\n<td style=\"background-color: #95c7e8; padding-left: 5px;\"><strong>Second<\/strong><\/td>\n<td style=\"background-color: #79bbd8; padding-left: 5px;\"><strong>Third<\/strong><\/td>\n<td style=\"background-color: #659bbf; padding-left: 5px;\"><strong>Fourth<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(5th Metric)<\/td>\n<td>Critical<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td>(4<sup>th<\/sup> Metric)<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(2<sup>nd<\/sup> Metric)<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(1<sup>st<\/sup> Metric)<\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Step 2<\/strong>. As soon as there is a FALSE outcome, the service moves one column to the left and evaluates that column from the bottom cell upwards (each of the <strong>Urgency <\/strong>cell\u2019s metrics). Below we are evaluating the Major Urgency Column from Lowest to Highest: fifth, sixth, seventh, eighth, ninth.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>(1<sup>st<\/sup> Metric)<\/td>\n<td>(2<sup>nd<\/sup> Metric)<\/td>\n<td>(3<sup>rd<\/sup> Metric)<\/td>\n<td>(4<sup>th<\/sup> Metric)<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td>Minor<\/td>\n<td>Major<\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(5th Metric)<\/td>\n<td>Critical<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #659bbf; padding-left: 5px;\"><strong>Ninth<\/strong><\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td>High<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #79bbd8; padding-left: 5px;\"><strong>Eighth<\/strong><\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #95c7e8; padding-left: 5px;\"><strong>Seventh<\/strong><\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(2<sup>nd<\/sup> Metric)<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #bddcf1; padding-left: 5px;\"><strong>Sixth<\/strong><\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(1<sup>st<\/sup> Metric)<\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #d3ebf5; padding-left: 5px;\"><strong>Fifth<\/strong><\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Step 3<\/strong>. As soon as there is a FALSE outcome, the service stops, and the row below is used (the last TRUE).<\/p>\n<p class=\"intro-text\"><strong>Step 4<\/strong>. The grid cell that is used is the intersection between the column and row that have been identified. This grid cell has a priority which is applied to the case that is currently being evaluated.<\/p>\n<p class=\"intro-text\">In the above scenario, the current case gets priority 3 in red, as this is what High Urgency, Major Impact uses.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>(1<sup>st<\/sup> Metric)<\/td>\n<td>(2<sup>nd<\/sup> Metric)<\/td>\n<td>(3<sup>rd<\/sup> Metric)<\/td>\n<td>(4<sup>th<\/sup> Metric)<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td>Minor<\/td>\n<td><strong>Major<\/strong><\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(5th Metric)<\/td>\n<td>Critical<\/td>\n<td>&nbsp;<\/td>\n<td>4<\/td>\n<td>3<\/td>\n<td><span style=\"color: #ff0000;\">2<\/span><\/td>\n<td><span style=\"color: #ff0000;\">1<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td><strong>High<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>5<\/td>\n<td>4<\/td>\n<td><span style=\"color: #ff0000;\">3<\/span><\/td>\n<td><span style=\"color: #ff0000;\">2<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(3<sup>rd<\/sup> Metric)<\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<td>4<\/td>\n<td><span style=\"color: #ff0000;\">3<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(2<sup>nd<\/sup> Metric)<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">7<\/span><\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<td>4<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">(1<sup>st<\/sup> Metric)<\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">8<\/span><\/td>\n<td><span style=\"color: #00bf46;\">7<\/span><\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Example<\/h3>\n<p class=\"intro-text\">This is the example we\u2019ll use in the different steps. Urgency measures the duration from greater than 24 minutes to greater than 99 minutes. Impact measures the entity\u2019s current choke position. For the case that is currently being evaluated, the entity is called \u2018Saphire\u2019.<\/p>\n<p class=\"intro-text\">The service measures the current choke position as well as the case duration at 01:00 AM (the time that the service is scheduled to run) for the date that the service is running. For this example, the value is <strong>110<\/strong>.<\/p>\n<p class=\"intro-text\">The following screenshot shows a Case in P2 Explorer (unrelated to the example above).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5.png\" rel=\"lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44150 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5.png\" alt=\"\" width=\"1444\" height=\"714\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5.png 1444w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-768x380.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-150x74.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-1280x633.png 1280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-36x18.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-5-48x24.png 48w\" sizes=\"auto, (max-width: 1444px) 100vw, 1444px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>Step 5<\/strong>. In the Example, the service measures the value (110) against the different metrics for impact (Actual values replace tokens).<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;90<\/p>\n<p>110&gt;90: <strong>TRUE<\/strong><\/p>\n<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;100<\/p>\n<p>110&gt;100: <strong>TRUE<\/strong><\/p>\n<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;110<\/p>\n<p>110&gt;110: <strong>FALSE<\/strong><\/p>\n<\/td>\n<td>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;120<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td>Minor<\/td>\n<td>Major<\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'99:00:00'}<\/td>\n<td>Critical<\/td>\n<td>&nbsp;<\/td>\n<td>4<\/td>\n<td>3<\/td>\n<td><span style=\"color: #ff0000;\">2<\/span><\/td>\n<td><span style=\"color: #ff0000;\">1<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'96:00:00'}<\/td>\n<td>High<\/td>\n<td>&nbsp;<\/td>\n<td>5<\/td>\n<td>4<\/td>\n<td><span style=\"color: #ff0000;\">3<\/span><\/td>\n<td><span style=\"color: #ff0000;\">2<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'72:00:00'}<\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<td>4<\/td>\n<td><span style=\"color: #ff0000;\">3<\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'48:00:00'}<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">7<\/span><\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<td>4<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'24:00:00'}<\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\">8<\/span><\/td>\n<td><span style=\"color: #00bf46;\">7<\/span><\/td>\n<td><span style=\"color: #00bf46;\">6<\/span><\/td>\n<td>5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Step 6<\/strong>. The service stops evaluating when the expression evaluates to FALSE, and identifies the <strong>previous<\/strong> <strong>column<\/strong> as the one to evaluate next (as highlighted, below).<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;90<\/p>\n<p>110&gt;90: <strong>TRUE<\/strong><\/p>\n<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;100<\/p>\n<p>110&gt;100: <strong>TRUE<\/strong><\/p>\n<\/td>\n<td style=\"padding-left: 5px;\">\n<p>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;110<\/p>\n<p>110&gt;110: <strong>FALSE<\/strong><\/p>\n<\/td>\n<td>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;120<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">Minor<\/td>\n<td style=\"padding-left: 5px;\">Major<\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">\u00a0<\/td>\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'99:00:00'}<\/td>\n<td>Critical<\/td>\n<td>&nbsp;<\/td>\n<td><strong>4<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>3<\/strong><\/td>\n<td style=\"padding-left: 5px;\"><span style=\"color: #ff0000;\"><strong>2<\/strong><\/span><\/td>\n<td><span style=\"color: #ff0000;\"><strong>1<\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'96:00:00'}<\/td>\n<td>High<\/td>\n<td>&nbsp;<\/td>\n<td><strong>5<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>4<\/strong><\/td>\n<td style=\"padding-left: 5px;\"><span style=\"color: #ff0000;\"><strong>3<\/strong><\/span><\/td>\n<td><span style=\"color: #ff0000;\"><strong>2<\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'72:00:00'}<\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>5<\/strong><\/td>\n<td style=\"padding-left: 5px;\"><strong>4<\/strong><\/td>\n<td><span style=\"color: #ff0000;\"><strong>3<\/strong><\/span><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'48:00:00'}<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"padding-left: 5px;\"><strong>5<\/strong><\/td>\n<td><strong>4<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'24:00:00'}<\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>8<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td><strong>5<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Step 7<\/strong>. In the example, the service evaluates the Urgency from the bottom row. The urgency columns in this example all evaluate the duration of the case. In the example, the case duration at 01:00 AM for the date is <strong>55 minutes<\/strong>. (See the first column, where actual values replace tokens).<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;90<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;100<\/td>\n<td style=\"padding-left: 5px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;110<\/td>\n<td>{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;120<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">Minor<\/td>\n<td style=\"padding-left: 5px;\">Major<\/td>\n<td>Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\">\u00a0<\/td>\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'99:00:00'}<\/td>\n<td style=\"padding-left: 5px;\">Critical<\/td>\n<td>&nbsp;<\/td>\n<td><strong>4<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>3<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<td><strong>1<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'96:00:00'}<\/td>\n<td>High<\/td>\n<td>&nbsp;<\/td>\n<td><strong>5<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>4<\/strong><\/td>\n<td style=\"padding-left: 5px;\"><strong>3<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'72:00:00'}<br \/>\n<strong>55 hours &gt; 72 hours: FALSE<\/strong><\/td>\n<td>Medium<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><strong>5<\/strong><\/td>\n<td style=\"padding-left: 5px;\"><strong>4<\/strong><\/td>\n<td><strong>3<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'48:00:00'}<br \/>\n<strong>55 hours &gt; 48 hours: TRUE<\/strong><\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"padding-left: 5px;\"><strong>5<\/strong><\/td>\n<td><strong>4<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'24:00:00'}<br \/>\n<strong>55 hours &gt; 24 hours: TRUE<\/strong><\/td>\n<td>None<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>8<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td><strong>5<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"intro-text\"><strong>Step 8<\/strong>. The service stops evaluating when the expression evaluates to FALSE, and identifies the <strong>previous row<\/strong> as the one to use (as highlighted, below).<\/p>\n<p class=\"intro-text\"><strong>Step 9<\/strong>. The priority number and colour (6, green) of the intersection of the highlighted row and column is applied to the case.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">\u00a0<\/td>\n<td style=\"width: 119px;\">\u00a0<\/td>\n<td style=\"width: 107px;\">Metric<\/td>\n<td style=\"width: 291px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;90<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;100<\/td>\n<td style=\"width: 296px; padding-left: 5px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;110<\/td>\n<td style=\"width: 298px;\">{{{Entity}}[Oil Producing Well]:Choke!CurrentPosition}&gt;120<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">\u00a0<\/td>\n<td style=\"width: 119px;\">\u00a0<\/td>\n<td style=\"width: 107px;\"><strong>Impact<\/strong><\/td>\n<td style=\"width: 291px;\">Insignificant<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\">Minor<\/td>\n<td style=\"width: 296px; padding-left: 5px;\">Major<\/td>\n<td style=\"width: 298px;\">Severe<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">Metric<\/td>\n<td style=\"width: 119px;\"><strong>Urgency<\/strong><\/td>\n<td style=\"width: 107px;\">\u00a0<\/td>\n<td style=\"width: 291px;\">\u00a0<\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\">\u00a0<\/td>\n<td style=\"width: 296px; padding-left: 5px;\">\u00a0<\/td>\n<td style=\"width: 298px;\">\u00a0<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">{{duration}} &gt; {du'99:00:00'}<\/td>\n<td style=\"width: 119px;\">Critical<\/td>\n<td style=\"width: 107px;\">\u00a0<\/td>\n<td style=\"width: 291px;\"><strong>4<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\"><strong>3<\/strong><\/td>\n<td style=\"width: 296px; padding-left: 5px;\"><strong>2<\/strong><\/td>\n<td style=\"width: 298px;\"><strong>1<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">{{duration}} &gt; {du'96:00:00'}<\/td>\n<td style=\"width: 119px;\">High<\/td>\n<td style=\"width: 107px;\">\u00a0<\/td>\n<td style=\"width: 291px;\"><strong>5<\/strong><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\"><strong>4<\/strong><\/td>\n<td style=\"width: 296px; padding-left: 5px;\"><strong>3<\/strong><\/td>\n<td style=\"width: 298px;\"><strong>2<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">{{duration}} &gt; {du'72:00:00'}<br \/>\n<strong>55: hours &gt; 72 hours: FALSE<\/strong><\/td>\n<td style=\"width: 119px;\">Medium&lt;<\/td>\n<td style=\"width: 107px;\">\u00a0<\/td>\n<td style=\"width: 291px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\"><strong>5<\/strong><\/td>\n<td style=\"width: 296px; padding-left: 5px;\"><strong>4<\/strong><\/td>\n<td style=\"width: 298px;\"><strong>3<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px; background-color: #e1ff00;\">{{duration}} &gt; {du'48:00:00'}<br \/>\n<strong>55: hours &gt; 48 hours: TRUE<\/strong><\/td>\n<td style=\"width: 119px; background-color: #e1ff00;\">Low<\/td>\n<td style=\"width: 107px; background-color: #e1ff00;\">\u00a0<\/td>\n<td style=\"width: 291px; background-color: #e1ff00;\"><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"width: 299px; background-color: #e1ff00; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"width: 296px; background-color: #e1ff00; padding-left: 5px;\"><strong>5<\/strong><\/td>\n<td style=\"width: 298px; background-color: #e1ff00;\"><strong>4<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 137px;\">{{duration}} &gt; {du'24:00:00'}<br \/>\n<strong>55: hours &gt; 24 hours: TRUE<\/strong><\/td>\n<td style=\"width: 119px;\">None<\/td>\n<td style=\"width: 107px;\">\u00a0<\/td>\n<td style=\"width: 291px;\"><span style=\"color: #00bf46;\"><strong>8<\/strong><\/span><\/td>\n<td style=\"background-color: #e1ff00; padding-left: 5px; width: 299px;\"><span style=\"color: #00bf46;\"><strong>7<\/strong><\/span><\/td>\n<td style=\"width: 296px; padding-left: 5px;\"><span style=\"color: #00bf46;\"><strong>6<\/strong><\/span><\/td>\n<td style=\"width: 298px;\"><strong>5<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"note\">The above example showed a progression of very similar metrics. You can use a variety of metrics, if you prefer. For example, measure the case entity\u2019s pressure, then its temperature, and so on.<\/p>\n<h2 class=\"page-subheading\">Grading the Metrics<\/h2>\n<p class=\"intro-text\">Because of the order that the different metrics are evaluated, it makes sense to use metrics that would most likely follow that logical path as well. For example, if you are evaluating the tubing head temperature of well ABC, your metrics could progress from Impact <strong>Insignificant<\/strong> to <strong>Major<\/strong> as follows. Because the evaluation is from left to right, it makes sense for a TRUE condition to be preceded by a TRUE condition, such as here where the ABC:THT = 380. Here the Impact is <strong>Major<\/strong>.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td>Metric<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:THT}&gt;250<\/p>\n<p>(evaluates 380 &gt; 250: TRUE)<\/p>\n<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:THT}&gt;300<\/p>\n<p>(evaluates 380 &gt; 300: TRUE)<\/p>\n<\/td>\n<td>\n<p>{{{Entity}}[Oil Producing Well]:THT}&gt;400<\/p>\n<p>(evaluates 380 &gt; 400: FALSE)<\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">\u00a0<\/td>\n<td>&nbsp;<\/td>\n<td><strong>Impact<\/strong><\/td>\n<td>Insignificant<\/td>\n<td>Minor<\/td>\n<td>Major<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">Metric<\/td>\n<td><strong>Urgency<\/strong><\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<td>&nbsp;<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'10:00:00'}<\/td>\n<td>High<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>3<\/strong><\/span><\/td>\n<td><strong>2<\/strong><\/td>\n<td><strong>1<\/strong><\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\">{{duration}} &gt; {du'5:00:00'}<\/td>\n<td>Low<\/td>\n<td>&nbsp;<\/td>\n<td><span style=\"color: #00bf46;\"><strong>4<\/strong><\/span><\/td>\n<td><strong>3<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"note\">If any of the conditions cannot be parsed, the lowest urgency and the lowest impact are used (in this example, <strong>Urgency<\/strong> <em>Low<\/em>, <strong>Impact<\/strong> <em>Insignificant<\/em>), which assigns a <span style=\"color: #00bf46;\"><strong>green 4<\/strong><\/span> to the case\u2019s priority.<\/p>\n<h2 class=\"page-subheading\">Assigning Priorities<\/h2>\n<p class=\"intro-text\">You can assign any priority (numbers 1 to 100) to any of the grid cells. If you regard priority 1 to be the highest priority, then it makes sense to give the Sever\/Critical cell a priority 1, with higher numbers as you go towards lower impacts and urgencies. Note that Sentinel gives a default priority of 1 to a case when it is raised.<\/p>\n<h2 class=\"page-subheading\">Assigning Colours<\/h2>\n<p class=\"intro-text\">When assigning colours to your spreadsheet priority grids, ensure that these are from the <strong>Standard Colors <\/strong>or <strong>Automatic (black),<\/strong>\u00a0and\u00a0<em><strong>not<\/strong> <\/em>the <em>Theme Colors<\/em>.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6.png\" rel=\"lightbox-9\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44151 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6.png\" alt=\"\" width=\"190\" height=\"237\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6.png 190w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6-120x150.png 120w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-6-38x48.png 38w\" sizes=\"auto, (max-width: 190px) 100vw, 190px\" \/><\/a><\/p>\n<p class=\"intro-text\">You can have any combination of priority number and colour. For example, you may have the number 3 in four separate grid cells in the spreadsheet, with each occurrence in a different colour.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7.png\" rel=\"lightbox-10\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44152 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7.png\" alt=\"\" width=\"605\" height=\"158\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7.png 605w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7-150x39.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7-36x9.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-7-48x13.png 48w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<h2 class=\"page-subheading\">Urgency and Impact<\/h2>\n<p class=\"intro-text\">You can have one or many <strong>Urgency<\/strong> rows, and one or many <strong>Impact<\/strong> columns. You should have at least one row and\/or column, or there will be no logic to process.<\/p>\n<p class=\"intro-text\">Ensure that the <strong>Urgency<\/strong> names are unique, and likewise with the <strong>Impact<\/strong> names, and do not have any missing rows or columns.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8.png\" rel=\"lightbox-11\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44153 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8.png\" alt=\"\" width=\"605\" height=\"181\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8.png 605w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8-150x45.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8-24x7.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8-36x11.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-8-48x14.png 48w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<h2 class=\"page-subheading\">Adding Categories<\/h2>\n<p class=\"intro-text\">If you need to add categories for cases, you will need to insert rows into the <strong>NamedListItem <\/strong>table in the database.<\/p>\n<p class=\"intro-text\">1. First find the ID for the Category, in the <strong>NamedList<\/strong> table.\u00a0In the following example, the ID is 1.<\/p>\n<p class=\"intro-text\" style=\"padding-left: 30px;\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10.png\" rel=\"lightbox-12\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44155 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10.png\" alt=\"\" width=\"667\" height=\"164\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10.png 667w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10-150x37.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10-36x9.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-10-48x12.png 48w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Now open the NamedListItem, and add rows for category.<\/p>\n<p class=\"intro-text\" style=\"padding-left: 30px;\">a. For the<strong> Value<\/strong> column, add the category name.<\/p>\n<p class=\"intro-text\" style=\"padding-left: 30px;\">b. For the<strong> NamedListId<\/strong> column, use the category <strong>Id<\/strong> found in the previous step (1 in this example).<\/p>\n<p class=\"intro-text\" style=\"padding-left: 30px;\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11.png\" rel=\"lightbox-13\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-44156 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11.png\" alt=\"\" width=\"844\" height=\"186\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11.png 844w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11-768x169.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11-150x33.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2019\/01\/word-image-11-48x11.png 48w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/><\/a><\/p>\n<p class=\"intro-text\" style=\"padding-left: 30px;\">c. Save the changes.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article describes how to create and maintain the AutoCaseCalculations spreadsheet, to enable auto-prioritisation of cases in Case Management.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/cases\/automatic-case-prioritisation\/automatic-case-prioritisation-4-6-1\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":29,"featured_media":44157,"parent":44141,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[3],"tags":[631,241],"class_list":["post-55910","page","type-page","status-publish","has-post-thumbnail","hentry","category-primer","tag-case-management","tag-spreadsheet","Version-4-6-4","Product-case"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/55910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=55910"}],"version-history":[{"count":4,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/55910\/revisions"}],"predecessor-version":[{"id":55923,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/55910\/revisions\/55923"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/44141"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/44157"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=55910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=55910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=55910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}