{"id":5911,"date":"2016-02-08T17:24:29","date_gmt":"2016-02-08T22:24:29","guid":{"rendered":"http:\/\/www.livingreliability.com\/en\/?p=5911"},"modified":"2025-11-06T05:07:47","modified_gmt":"2025-11-06T10:07:47","slug":"rcm-dashboards","status":"publish","type":"post","link":"https:\/\/www.livingreliability.com\/en\/posts\/rcm-dashboards\/","title":{"rendered":"RCM – Dashboards"},"content":{"rendered":"

The RCM Dashboard application (App) consists of five “sheets”:<\/em><\/p>\n

    \n
  1. RCM Progress<\/em><\/li>\n
  2. Failure Mode Detail<\/em><\/li>\n
  3. Mitigation Task Detail<\/em><\/li>\n
  4. Criticality Analysis, and<\/em><\/li>\n
  5. Knowledge Management<\/em><\/li>\n<\/ol>\n

    The following explanations will help you to begin using the visualization objects of each sheet. Each object (chart or table) can be expanded to full screen using the double arrow icon on its top right corner. Filters you set up will apply to all sheets until you clear them.<\/p>\n

    1. RCM Progress<\/h1>\n

    \"DashboardRcmProgress2\"<\/a>The RCM Progress dashboard contains 9 visualization objects:<\/p>\n

      \n
    1. RCM in progress<\/li>\n
    2. RCM in audit<\/li>\n
    3. RCM completed<\/li>\n
    4. RCM implemented<\/li>\n
    5. Failure modes per hour<\/li>\n
    6. RCM completed vs schedule<\/li>\n
    7. Failure modes<\/li>\n
    8. RCM Analyses (Table of #Functions, Failures, Failure Modes by equipment type)<\/li>\n
    9. RCM Analyses (Bar chart of #Functions, Failures, Failure Modes by equipment type)<\/li>\n<\/ol>\n

      To read this dashboard, select an equipment type[1<\/a>]<\/sup>. The selection is called a “filter”. Create your filter by selecting one or more equipment types from the RCM Analyses<\/span> table. All the objects immediately reflect the item or items selected in the filter. Your filter appears in the top dark bar, for example the filter “FLEET_NAME”. Add or subtract items in the filter by clicking them in an object. Remove a filter by “X”ing it out on the top brown filter bar<\/p>\n

      RCM in progress, RCM in audit, RCM Completed, RCM Implemented<\/h2>\n

      \"DashboardRcmAnalyses2\"<\/a>By clearing the filter RCM Analyses<\/span> will indicate the number of Analyses identified in Mesh, RCM<\/span> in progress<\/span> will tell you the number and percentage of total of RCM analyses that are currently in progress, and RCM Completed<\/span> will tell you the number and percentage of RCM analyses that are currently completed the audit stage but not yet implemented.<\/p>\n

      Failure Modes per Hour<\/h2>\n

      \"FailureModesPerHour\"<\/a>This horseshoe graph indicates the skill of the analysts and facilitator. It is considered the most important KPI for judging an organization’s ability to perform initial RCM efficiently. The\u00a0RCM efficiency KPI target is between 5 and 6 Exclude the analyses that are “In progress” from the filter. Compare performance among different asset types to gain an appreciation of overall organizational RCM ability.<\/p>\n

      \u00a0RCM completed v.s. scheduled<\/h2>\n

      \"RcmCompletedVsSchedule\"<\/a>A KPI measuring compliance with schedule. The data for this graph is provided by the RCM coordinator or facilitator on a Excel spreadsheet. That information is then automatically combined with the data from Mesh to determine the progress of the RCM project against the target scheule. An example of the Excel sheet provided can be seen here<\/a>.<\/p>\n

      Failure Modes actual vs estimated<\/h2>\n

      \"FailureModesActualVsEst\"<\/a>Actual v.s. number of failure modes estimated for an equipment type at RCM project planning phase. This KPI measures the skill of the facilitator in assessing, during the RCM planning phase, the number of failure modes that will need to be documented during the analysis.<\/p>\n

      The facilitator combines this with the “Failure modes per hour” KPI in order to estimate the number of RCM sessions needed to perform the analysis. He then uses his estimate to schedule the SMEs and locations for the analysis sessions.<\/p>\n

      RCM Analyses – Table<\/h2>\n

      \"DashboardFunctionsFailuresFailureModes\"This table lists the equipment types identified in Mesh for RCM analysis. The table can be used as a filter to home in on one or more specific equipment types. The filter remains active for all other visualization objects in the App. The number of Functions, Failures, and Failure Modes can be read from the table.<\/p>\n

      RCM Analyses – Bar chart<\/h2>\n

      \"DashboardFunctionsFailuresFailureModesBarChart\"The same information as the table above but presented visually as a bar chart.<\/p>\n

      The chart on the right shows, as you scroll vertically, the current view in the context of the entire filtered sample.<\/p>\n

      2. Failure Mode detail<\/h1>\n

      Failure mode grouped by consequences<\/h2>\n

      \"FailureModesByConsequences1\"Use the filters on the left to select a physical item for failure mode examination. The pie chart breaks down the a filtered combination of Equipment, Systems, and Components by consequence (Hidden, HSE, Operational, Non-operational)<\/p>\n

      The chart itself can be used to filter the other displays.<\/p>\n

      Expected corrective v.s. mitigating time by equipment type<\/h2>\n

      \"DashboardExpectedCorrVsMitigTime\"This bar chart uses three data sources in Mesh:<\/p>\n

        \n
      1. The estimated corrective downtime in hours per failure instance<\/li>\n
      2. The probability in instances per year from the risk (criticality) analysis in the\u00a0 knowledge base, and<\/li>\n
      3. The mitigation time in hours and frequency (in times\/year)<\/li>\n<\/ol>\n

        The blue and purple bars per equipment type compare yearly proactive (mitigating) effort with expected worst case reactive effort (i.e. no PM). These results can be filtered down (using the Failure mode detail table described next) to the failure mode level in order to examine the expected benefits related to specific PM tasks and frequencies.<\/p>\n

        Failure mode detail table<\/h2>\n

        \"DashboardFailureModeDetailTable\"This table displays the details related to each failure mode identified in Mesh. The full text of, for example the Effects analysis is displayed by hovering the mouse pointer over any cell. The Equipment filter may be refined by selecting one or more failure modes in this table.<\/p>\n

        3. Mitigation task detail<\/h1>\n

        Tasks grouped by mitigating type<\/h2>\n

        \"DashboardTasksGroupedByType\"As in all sheets, we can apply a filter to combinations of physical assets and their respective systems and subsystems. The Tasks grouped by mitigating type<\/span> pie chart will display the planned relative effort (%time) to be applied in each task category.<\/p>\n

        Expected corrective vs mitigating time by failure mode table<\/h2>\n

        \"ExpectedCorrVsReactEffort\"We can further examine one or more failure modes by comparing their proactive and expected reactive efforts. The Reactive (Corrective) effort is drawn from the criticality analysis data source. This analysis could help in adjusting mitigating tasks and frequencies to arrive at acceptable risk.<\/p>\n

        Tasks grouped by frequency and skill<\/h2>\n

        \"TasksGroupedByFreqSkill\"Setting up maintenance schedules requires this data, which can be exported directly from the visualization object.<\/p>\n

        By filtering on frequency and skill you can export to Excel any or all of the individual maintenance schedules (PM task sheets) for upload to the EAM.<\/p>\n

         <\/p>\n

        Mitigating tasks<\/h2>\n

        \"MitigationTasks\"According to any filter criteria the tasks for developing maintenance schedules are displayed along with their reference number designating their positions within the RCM knowledge hierarchy.<\/p>\n

        4. Criticality analysis<\/h1>\n

        Criticality by failure mode table<\/h2>\n

        \"CriticalityByFailureMode\"Criticality analysis is considered an important maintenance information function in the oil and gas sector (particularly off-shore installations). The data source is is the risk analysis performed in Mesh knowledge builder [2<\/a>]<\/sup>.\u00a0 Mesh provides user configurable selection grids for the probability and severity of a failure mode in various categories (e.g. Cost, Safety, Environment Operations). Criticality analysis should be carried out for any failure mode only after<\/em> its RCM Effects analysis has been completed, which will ensure that the quantitative analysis is based on SME consensus.[3<\/a>]<\/sup><\/p>\n

        Failure mode risks bar chart<\/h2>\n

        \"FailureModeRisks\"Quantitative risk levels are calculated according to the user configurable formula and tables in Mesh. Various industries and organizations may apply their own standards for setting up severity and probability categories. Mesh will accommodate any Criticality standard.<\/p>\n

        5. Knowledge management<\/h1>\n

        \"DashboardKnowledgeMgt\"Knowledge management is the process by which the RCM analysis is continuously updated as new experience and new insight is gathered day to day within the work order system. The Mesh feedback system is the tool used to make knowledge suggestions and comments. The visualization objects in this sheet are designed to measure and assess the knowledge related activity conducted via the Mesh feedback system. The feedback system is the recommended tool by which RCM auditors may examine, question, and finally sign off on each RCM analysis.<\/p>\n

        See, creating a story on page 2<\/a>
        \n<\/p>\n

        Telling a story<\/h1>\n

        Assume there are two scenarios that you would like to display independently in your dashboard. Say, in your organization you practice two methods of performing RCM analysis.<\/p>\n

          \n
        1. The review group method (developed by John Moubray)<\/li>\n
        2. The interview method (described by J.C. Leverette at NAVAIR)<\/li>\n<\/ol>\n

          You would like the option of analyzing RCM analysis performance of either or both methods. Do it by using Qlik’s story function as follows. One story relates to the effectiveness of the RCM analysis project when using only the traditional “review group meeting” methodology. In this methodology SMEs and a facilitator perform the analysis as a team exercise.<\/p>\n

          A second story relates to the overall organizational RCM effectiveness which would also include RCM carried out using the “interview” methodology. In this methodology a facilitator (for example, Mai) uses existing documentation (e.g. available FMEAs) and develops the RCM analysis while consulting the SMEs as necessary for clarification and validation.<\/p>\n

          How do we use the dashboards to tell both stories? Of the 17 systems in the RCM analysis project, assume that the Scrubber and Aftercooler were analyzed using the interview method. The remaining 15 were analyzed by the review group method.<\/p>\n

            \n
          1. In “My personal cloud” In the app overview hit the stories tab.<\/li>\n
          2. Create a new story called “Excluding Interview Method”.<\/li>\n
          3. Then hit + in the time line and selected “Embedded sheet”<\/li>\n
          4. Next hit the sheets tab, go to the RCM Progress sheet, and set up the following filter:\n
              \n
            1. Aftercooler<\/li>\n
            2. Backup Generator<\/li>\n
            3. Compressed Air System<\/li>\n
            4. UMD System<\/li>\n
            5. ESD System<\/li>\n
            6. Fire Hydrant System<\/li>\n
            7. Gas Generator<\/li>\n
            8. GG Enclosure<\/li>\n
            9. GG Gas Aftercooler<\/li>\n
            10. Heating System<\/li>\n
            11. Intake Plenum<\/li>\n
            12. Measurements MA<\/li>\n
            13. Power distribution sys<\/li>\n
            14. Power gas system<\/li>\n
            15. Sprinkler system<\/li>\n<\/ol>\n<\/li>\n
            16. Go back to the stories tab and select RCM Progress as the embedded sheet. (You could also add the other four sheets to the story.) The filter is now in the story.<\/li>\n<\/ol>\n

              You can play the story by going to\u00a0 “My personal cloud”, RCM Dashboard, and Stories tab. Hit the “Excluding Interview Method” icon and the “Go to sheet” button. The RCM Progress sheet displays with the 15 RCM analyses pre-selected filter.<\/p>\n\n

                \n\t
              1. [1]<\/sup><\/strong>An equipment type\/fleet is equivalent to a unit or specific asset where it is a one-of a-type-asset. RCM analysis is performed for an equipment type. class or model. But it applies to all units of that type.↩<\/a><\/li>\n\t
              2. [2]<\/sup><\/strong>The “Risk” tab of the Failure Mode data entry dialog↩<\/a><\/li>\n\t
              3. [3]<\/sup><\/strong>Performing the risk analysis without having performed the RCM effects analysis is not advisable as it will often result in criticality numbers not supported by the SME consensus.↩<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

                The RCM Dashboard application (App) consists of five “sheets”: RCM Progress Failure Mode Detail Mitigation Task Detail Criticality Analysis, and Knowledge Management The following explanations will help you to begin using the visualization objects of each sheet. Each object (chart or table) can be expanded to full screen using the double arrow icon on its […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[35,111,112,114],"class_list":["post-5911","post","type-post","status-publish","format-standard","hentry","category-managing-lrcm","tag-continuous-improvement","tag-kpis","tag-lrcm","tag-rcm"],"_links":{"self":[{"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/posts\/5911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/comments?post=5911"}],"version-history":[{"count":42,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/posts\/5911\/revisions"}],"predecessor-version":[{"id":6908,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/posts\/5911\/revisions\/6908"}],"wp:attachment":[{"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/media?parent=5911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/categories?post=5911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.livingreliability.com\/en\/wp-json\/wp\/v2\/tags?post=5911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}