TWI715397B - Method, computer program product as well as computer-readable medium for plotting peer data into graph according to leading standard - Google Patents

Abstract

A method for plotting peer data into a graph according to a leading standard includes: plotting at least two first polylines according to at least two initial percentile cut-off points of a plurality of peer data versus time unit, wherein the at least two initial percentile cut-off points divide the peer data into at least three intervals; when a direction code indicates a negative direction, maintaining the initial percentile cut-off point as a correct percentile cut-off point; when the direction code indicates a positive direction, subtracting the initial percentile cut-off point from 100 to obtain a correct percentile cutoff point, and separating the at least two first polylines by a visual symbol according to the correct percentile cutoff point; and plotting a second polyline according to a certain data versus time unit, and viewing an evaluation indicator according to which interval the second polyline is located.

Description

Methods of graphing peer data according to leading standards, computer program products And computer readable media

The present invention relates to a method, a computer program product and a computer readable medium for drawing a large amount of peer data into charts according to leading standards.

The use of quality indicators publicly promoted by government agencies to monitor and improve the quality of medical institutions has been a mainstream strategy in recent years. Hospital evaluation standards also have related express provisions, for example: Article 2.2.4 "Hospitals shall set medical quality control indicators And case data, annual reports and medical results data, as well as statistics, analysis and review", the medical task indicators 1.2.2 "compared with peers, medical process and effectiveness indicators are reasonable" and 1.2.1 "hospitals have continuous effectiveness improvement Promote execution performance and future prospects, and execution results are good". By presenting the quality of medical services in the form of indicators, it can be used for internal self-assessment of medical institutions and for comparison between peers of medical institutions, and the results of the comparisons are fed back to each unit, regularly reviewed, and improvement measures are made to improve the quality. Hospital-wide promotion and internalization are routine hospital measures to improve medical quality and patient safety.

However, when hundreds of indicators are to be compared between peers, because indicator data are mostly presented in the form of trial balances, relying on the traditional way of drawing charts in trial balances is not only inefficient and not conducive to the interpretation of quality control personnel in medical institutions. When quality control personnel have a need for the presentation of specific data, they can only ask for help Information personnel in medical institutions, but information personnel are often busy with other businesses and lack skills to assist the needs of quality control personnel. When quality control personnel manually select data and draw charts, it takes a lot of time and is prone to errors.

In this regard, the present inventor proposes a method of drawing peer data as a chart based on leading standards to generate a timeline and peer data chart to quickly view a to-be-evaluated indicator. The to-be-evaluated indicator has a leading standard. The standard method for drawing peer data as a chart includes: setting an X-axis as a time unit and a Y-axis as peer data; obtaining the plural peer data of the index to be evaluated, and the peer data includes a specific data. The index matches a direction code. When the leading standard of the index to be evaluated is considered to be a leader as the value of the peer data is greater, the direction code is set to a positive direction. When the value of the peer data is considered to be leading as the smaller the value, the direction code is set to a negative direction; in the peer data, at least two initial percentile cut-off points are selected, and at least two of the initial percentile cut-off points The peer data is divided into at least three intervals, and at least two first broken lines corresponding to the time unit of the peer data are drawn according to at least two of the initial percentile cutoff points; when the direction code is the negative direction, maintain the The initial percentile cut-off point is a correct percentile cut-off point; when the direction code is the positive direction, 100 minus the initial percentile cut-off point is the correct percentile cut-off point. The quantile dividing point separates at least two of the first broken lines by a visual symbol; and draws the time unit corresponding to the specific data as a second broken line, and examines the index to be evaluated according to which interval the second broken line is located.

Further, the initial percentile cut-off point is an initial first quartile, an initial second quartile, and an initial third quartile, and the correct percentile cut-off point is one in order The correct first quartile, a correct second quartile and a correct third quartile, and the correct first quartile The quantile, the correct second quartile, and the correct third quartile distinguish the peer data into a first interval, a second interval, a third interval, and a fourth interval; The direction code of the index to be evaluated is the negative direction, the initial first quartile, the initial second quartile, and the initial third quartile are the correct first quartile, the The correct second quartile and the correct third quartile; if the direction code of the indicator to be evaluated is the positive direction, the initial first quartile, the initial second quartile and the The initial third quartile is the correct third quartile, the correct second quartile, and the correct first quartile; and the specific data is calculated separately in a period of time. A frequency and a percentage of the first interval, the second interval, the third interval, and the fourth interval, and/or a progressive number and a progressive percentage.

Wherein, adding up the number of progressions of the first interval, the second interval, the third interval, and the fourth interval becomes a total progression number, and the progression percentage is the progression number divided by the sum progression number and then multiplied by 100%.

Further, calculate the number of times that the specific data of the multiple indicators to be evaluated fall in each of the first interval, the second interval, the third interval, and the fourth interval within the time period, and A plurality of the indicators to be evaluated and the correct first quartile, the correct second quartile, and the correct third quartile are used as benchmarks to draw the specific data for each indicator to be evaluated. A heat map of the number of advancements for each of the first interval, the second interval, the third interval, and the fourth interval.

Among them, the method of drawing peer data into charts according to leading standards is used in the evaluation of medical institutions, and the specific data is a hospital data.

Wherein, a predetermined time zone is used as a unit, and a different chart background color is assigned to the different time zone.

The inventor proposes another method of drawing peer data as a chart based on leading standards to quickly view multiple indicators to be evaluated. Each indicator to be evaluated has a leading standard. The method of drawing peer data as a chart based on the leading standard includes : Obtain the plural peer data of each of the indicators to be evaluated, the peer data contains a specific data, and each indicator to be evaluated matches a direction code, when the leading standard of each indicator to be evaluated is the peer data When the value of is considered to be leading, the direction code is set to a positive direction. When the value of the leading standard of each of the indicators to be evaluated is considered to be leading when the value of the peer data is smaller, the direction code is set to A negative direction; at least two initial percentile cutoff points are selected in the peer data, and the peer data are divided into at least three intervals by at least two of the initial percentile cutoff points; when the direction code is the negative Maintain the initial percentile cut-off point as a correct percentile cut-off point when facing the direction; when the direction code is the positive direction, subtract the initial percentile cut-off point from 100 as the correct percentile cut-off point; And calculate the number and/or percentage of each of the specific data of each of the indicators to be evaluated within each of at least three of the intervals within a time period, and divide the number of indicators to be evaluated from the correct percentile A heat map of the number and/or percentage of each of the specific data of each of the indicators to be evaluated falling in each of at least three of the intervals is drawn with a point as a reference.

A computer program product is used to execute any of the aforementioned methods of drawing peer data into charts according to leading standards after being loaded into a computer device.

A computer-readable medium is used to perform any of the aforementioned methods of drawing peer data into charts according to leading standards after being loaded into a computer device.

According to the above technical features, the following effects can be achieved:

1. Quickly and correctly process a large amount of peer data, which can reduce the time and error rate of manually selecting a large amount of peer data and making charts.

2. With the separation of visual symbols, with at least two first broken lines, you can quickly know where specific data falls from the timeline and peer data chart to view the indicators to be evaluated.

3. Get the correct percentile cut-off point according to the direction code of the indicator to be evaluated. Therefore, as long as it is close to the correct first quartile, it is good, and close to the correct third quartile is bad. It can be evaluated intuitively , No additional conversion is required.

4. Separate several intervals by the initial percentile cut-off point, and plot the cumulative number and cumulative percentage of specific data in each interval into a heat map, which is convenient for finding the main points of specific data from the color change of the heat map.

5. Different time zones are given different chart background colors, which can clearly distinguish each time zone.

[The first figure] is the first flow chart of the embodiment of the present invention.

[The second figure] is a broken line diagram 1 of the embodiment of the present invention, indicating that the direction code is negative.

[The third figure] is the second flow chart of the embodiment of the present invention, which shows that when the direction code is negative, the location of specific data is determined.

[Fourth Figure] is the second line diagram of the embodiment of the present invention, indicating that the direction code is positive.

[Fifth Figure] is the third flowchart of the embodiment of the present invention, indicating that when the direction code is positive, the location of specific data is determined.

[The sixth figure] is the fourth flow chart of the embodiment of the present invention, showing the heat map of the number of times and the percentage heat map.

[The seventh figure] is a heat map of the frequency of the embodiment of the present invention.

[The eighth figure] is the percentage heat map of the embodiment of the present invention.

Based on the above technical features, the main effects of the method of drawing peer data into charts according to leading standards, computer program products, and computer readable media of the present invention will be clearly presented in the following embodiments.

Please refer to the first and second figures, which reveal the method of drawing peer data into charts according to leading standards. The method of drawing peer data into charts according to leading standards can also be used as a computer program product or a computer readable Fetch the media and execute it after loading a computer device. The method of drawing peer data into a chart based on leading standards is used to generate a timeline and peer data chart to quickly view a to-be-evaluated indicator. The to-be-evaluated indicator has a leading standard. The peer data is drawn as a chart based on the leading standard. The method includes: setting the time axis and one of the peer data charts as the time unit, and the time axis and one of the peer data charts as the Y axis as peer data; obtaining the plural peer data of the index to be evaluated, in the peer data Containing a specific data, the indicator to be evaluated matches a direction code.

Please also refer to the first and second figures, and please match the following table 1. The method of drawing peer data into a chart based on leading standards is used in the evaluation of a medical institution, and the Taiwan Clinical Performance Indicator (Taiwan Clinical Performance Indicator) , TCPI) ICU-Mort-01's intensive care unit mortality rate (including critical illness automatic discharge) is used as the indicator to be evaluated. Since the leading standard is that the lower the mortality rate of the intensive care unit of the medical institution, the more the medical institution will be regarded as leading, so the direction code of the indicator to be evaluated is a negative direction. Exclude the missing, inapplicable, etc. of the data downloaded by the TCPI system platform, and use the remaining data as the peer data, and use the data from a hospital in a medical center in the peer data as the medical institution Of that specific data. The following section records the data of ICU-Mort-01's intensive care unit mortality (including critically ill automatic discharge) from January 2017 to March 2017. Three initial percentile cutoff points are selected, and the first four are in order. Quantile, an initial second quartile, and an initial When the third quartile is started, three first broken lines corresponding to the time unit of the peer data are drawn according to the initial percentile cutoff point, and the peer data are divided into four intervals by the three first broken lines. Since the directionality of the index to be evaluated is the negative direction, the initial first quartile, the initial second quartile, and the initial third quartile of the initial percentile cut-off point are maintained respectively The digits are the three correct percentile cutoff points, which are a first quartile, a second quartile, and a third quartile. According to the correct percentile dividing point, the first broken line is separated by a visual symbol, such as a color or a line type. The time unit corresponding to the specific data is drawn as a second broken line, and the indicator to be evaluated is checked according to which interval the second broken line is located.

Please refer to the third figure, and please match the above table 1. When the directionality of the indicator to be evaluated is the negative direction, when the specific data is not greater than the first quartile, it is determined that the specific data falls in the first quartile. The first interval; when the specific data is greater than the first quartile and not greater than the second quartile, it is determined that the specific data falls in a second interval; when the specific data is greater than the second quartile When the number is not greater than the third quartile, it is determined that the specific data falls in a third interval; when the specific data is greater than the first quartile, it is determined that the specific data falls in a fourth interval.

Please refer to the first and fourth pictures, and please match the following table two, and then use the TCPI indicator code RCC-Integ01 subacute respiratory care unit ventilator detachment success rate as the indicator to be evaluated, because the leading standard system The higher the success rate of detachment of the ventilator in the subacute respiratory care unit of the medical institution, the more the medical institution will be regarded as a leader. Therefore, the direction code of the indicator to be evaluated is a positive direction. The following table 2 excerpts the data on the success rate of ventilator detachment in the subacute respiratory care unit from January 2017 to March 2017. The initial percentile cut-off points are selected as the initial first quartile, the initial For the second quartile and the initial third quartile, since the directionality of the index to be evaluated is the positive direction, the correct percentile cut-off point is 100 minus the initial percentile The dividing point, for example, taking the initial first quartile of the initial percentile dividing point as an example, taking the 25th percentile as one of the initial percentile dividing points, the correct percentile The quantile cutoff point is 100 minus the initial percentile cutoff point, that is, 100-25=75, which is the 75th percentile of the correct percentile cutoff point, which means the initial first quartile Will be converted to the third quartile of the correct percentile cutoff point. In summary, since the initial first quartile, the initial second quartile, and the initial third quartile are selected as the initial percentile cutoff points in this embodiment, When the directionality of the index to be evaluated is the positive direction, the initial first quartile equivalent to the initial percentile cut-off point is converted to the third quartile of the correct percentile cut-off point Digit, the initial second quartile of the initial percentile cut-off point is converted to the second quartile of the correct percentile cut-off point, the initial of the initial percentile cut-off point The third quartile is converted to the first quartile of the correct percentile cutoff point. According to the correct percentile dividing point, the first broken line is separated by a visual symbol, such as a color or a line type. The time unit corresponding to the specific data is drawn as a second broken line, and the indicator to be evaluated is checked according to which interval the second broken line is located.

Please refer to the fifth figure, and please match the above table 2 to compare the specific data with the total data. When the specific data is not less than the first quartile, it is determined that the specific data falls in the first interval. When the specific data is less than the first quartile and not less than the second quartile, it is determined that the specific data falls in a second interval, and when the specific data is less than the second quartile and not less than the second quartile In the third quartile, it is determined that the specific data falls in a third interval, and when the specific data is less than the third quartile, it is determined that the specific data falls in a fourth interval.

Please refer to the second and fourth figures again. The time axis and the peer data chart are drawn using SAS v9.4 in the embodiment of the present invention, and the specific data falls into the first interval and the second interval month by month. , The number and percentage of the third interval and the fourth interval are placed at the bottom of the time axis and peer data chart, where P25 is the first interval before, P25 to P50 are the second interval, and P50 to P75 This is the third interval, and the fourth interval after P75. A predetermined time zone is used as a unit, and a different chart background color is assigned to the different time zone. For example, take one year as the time zone, set the number of times and the percentage date in each month to 15th, and set the end date of the previous time zone and the end of the next time zone The starting date is set on December 28 and January 3, then the number of times and the percentage The value of the rate will be aligned with the marked points of each month, and there will be a proper gap between the time axis and the background color of the chart on the peer data chart. While beautiful, it is convenient for users to compare the time axis with the peer data chart. The different time periods can also be clearly seen in gray scale. In addition, in the time axis and peer data chart, the first broken line except for the first quartile, the second quartile, and the third quartile of the peer data, There is also a weighted average of the peer data, and the user can select the line segment required for display according to the needs. In the timeline and peer data chart, it is close to the first broken line connected by the third quartile with the blue one-point chain line as the correct percentile cut-off point (the peer data in the legend is the first broken line). The 75th percentile) are all poor data values, which are close to the first broken line connected by the first quartile with the green dashed line as the correct percentile cutoff point (the 25th in the example of the peer data) Percentile) are all better data values. The difference between blue and green, one-point chain line and dotted line is used to separate the different correct percentile points, and the red solid line The second broken line (this hospital in the legend) connected for the specific data can be judged intuitively without additional conversion. When the user wants to confirm that the specific data is better or worse than most of the peer data, no matter the direction code is the positive or the negative, just confirm whether the red solid line is close to the green dashed line. The red solid line is far away from the blue dotted chain line and close to the green dotted line, indicating that the specific data belongs to the better group of the peer data. If the red solid line is far away from the green dotted line and close to the blue dotted chain line, it means that the specific data belongs to The poorer groups in the peer data can be used to quickly view the indicators to be evaluated, and by drawing the peer data into charts according to leading standards, a large amount of the peer data can be processed quickly and correctly, replacing the traditional manual Select the peer data to draw a graph, reducing the time required and the error rate.

Please refer to the sixth figure to calculate the number of progressions and the percentage of progression of the specific data falling in the first interval, the second interval, the third interval, and the fourth interval in a time period. In the implementation, six months (half a year) is used as the time period. Will fall in the first interval, The progression times of the second interval, the third interval, and the fourth interval are represented by parameters A1, A2, A3, and A4, respectively, and will fall in the first interval, the second interval, the third interval, and the first interval. The progressive percentages of the four intervals are represented by the parameters A11, A22, A33, and A44 respectively, and the progressive times falling in the first interval, the second interval, the third interval, and the fourth interval are added together to become a sum The number of progression, then: A11=A1/(A1+A2+A3+A4)*100%, that is, the percentage of the progression falling in the first interval is the number of progressions falling in the first interval occupying the total number of progressions Percentage, and so on, that is to say: A22=A2/(A1+A2+A3+A4)*100%, A33=A3/(A1+A2+A3+A4)*100%, and A44=A4/( A1+A2+A3+A4)*100%.

Please refer to the sixth to eighth graphs to draw each of the indicators to be evaluated and the first quartile, the second quartile, and the third quartile as the benchmark. The specific data of the evaluation index falls within the first interval, the second interval, the third interval, and the fourth interval in the time period. A heat map and a heat map of the progression times and the progression percentage of each of the Percentage heat map, the horizontal axis of the frequency heat map and the percentage heat map are the indicators to be evaluated, the vertical axis is each of the intervals, and the different time periods are placed along the vertical axis in sequence, where P25 is the previous In the first interval, P25 to P50 are the second interval, P50 to P75 are the third interval, and after P75 are the fourth interval. In the embodiment of the present invention, the frequency heat map and the percentage heat map are presented by the saturation of the color. The higher the saturation, the higher the frequency or percentage falling in this interval, which is convenient for the user to learn from the frequency. The color change of the heat map and the percentage heat map quickly finds the main point of the specific data. The seventh graph is drawn with the number of progressions, namely A1, A2, A3, and A4, and the eighth graph is drawn with the progression percentage, namely A11, A22, A33, and A44. It should be noted that the horizontal axis of the seventh and eighth graphs is not a single indicator to be evaluated. Taking the overall comprehensive acute care (2) in the leftmost column of the seventh graph as an example, it means that there are two groups of the Indicators to be evaluated. In the first half of 2017, each group of indicators to be evaluated will have six points. In other words, the total number of progressions in the overall comprehensive acute care (2) column in the first half of 2017 will be 12, and a result of 12 can indeed be obtained from 0+1+2+9.

Based on the description of the above-mentioned embodiments, when one can fully understand the operation and use of the present invention and the effects of the present invention, the above-mentioned embodiments are only preferred embodiments of the present invention, and the implementation of the present invention cannot be limited by this. The scope, that is, simple equivalent changes and modifications made according to the scope of the patent application of the present invention and the description of the invention, are all within the scope of the present invention.

Claims (10)

A method of drawing peer data as a chart based on leading standards to generate a timeline and peer data chart to quickly view an indicator to be evaluated. The indicator to be evaluated has a leading standard, and the peer data is drawn as a chart based on the leading standard The method includes: setting an X-axis as a time unit and a Y-axis as peer data; obtaining plural peer data of the index to be evaluated. The peer data includes a specific data, and the index to be evaluated matches a direction code. When the leading standard of the indicator to be evaluated is the larger the value of the peer data and is considered to be leading, set the direction code to a positive direction, when the leading standard of the indicator to be evaluated is the smaller the value of the peer data When it is deemed to be leading, set the direction code to a negative direction; select at least two initial percentile cut-off points in the peer data, and at least two of the initial percentile cut-off points divide the peer data into at least Three intervals, and draw at least two first broken lines corresponding to the time unit of the peer data according to at least two initial percentile cut-off points; when the direction code is the negative direction, maintain the initial percentile cut-off point as A correct percentile cut-off point; when the direction code is the positive direction, 100 minus the initial percentile cut-off point is the correct percentile cut-off point, and according to the correct percentile cut-off point, at least two of the The first broken line is separated by a visual symbol; and the time unit corresponding to the specific data is drawn as a second broken line, and the index to be evaluated is checked according to which interval the second broken line is located. As described in item 1 of the scope of patent application, the method of drawing peer data into a chart based on leading standards, further, the initial percentile cut-off point is an initial first quartile and an initial second quartile in order Number and an initial third quartile, the correct percentile cutoff point is a correct first quartile, a correct second quartile, and a correct third quartile in sequence, and The correct first quartile, The correct second quartile and the correct third quartile distinguish the peer data into a first interval, a second interval, a third interval, and a fourth interval; if the index to be evaluated is The direction code is the negative direction, the initial first quartile, the initial second quartile, and the initial third quartile are the correct first quartile and the correct second quartile, respectively Quantile and the correct third quartile; if the direction code of the indicator to be evaluated is the positive direction, the initial first quartile, the initial second quartile, and the initial third and fourth quartile The quantiles are the correct third quartile, the correct second quartile, and the correct first quartile; and the specific data is calculated to fall in the first interval in a time period, A number and a percentage of the second interval, the third interval, and the fourth interval, and/or a number of progressions and a percentage of progression. As described in item 2 of the scope of patent application, the method of drawing peer data into a chart according to the leading standard, wherein after adding up the progressive times of the first interval, the second interval, the third interval, and the fourth interval It becomes a total number of progressions, and the percentage of progression is the number of progressions divided by the number of progressions of the sum multiplied by 100%. For example, according to the method of drawing peer data into charts according to the leading standard described in item 2 of the scope of patent application, it is further calculated that within the time period, the specific data of the multiple indicators to be evaluated fall within the first interval and the first interval. The number of progressions in each of the second interval, the third interval, and the fourth interval, and the number of indicators to be evaluated, the correct first quartile, the correct second quartile, and the correct first quartile The third quartile is used as a benchmark to draw a heat map of the number of progressions for each of the indicators to be evaluated that the specific data falls in each of the first interval, the second interval, the third interval, and the fourth interval . For example, the method of drawing peer data as a chart based on leading standards as described in item 1 of the scope of patent application, wherein the method of drawing peer data as charts based on leading standards is used in the evaluation of medical institutions, and the specific data is one Data from our hospital. As described in item 1 of the scope of patent application, the method of drawing peer data into a chart based on leading standards, wherein a predetermined time period is used as a unit, and different time periods are given a different chart background color. A method of drawing peer data into charts based on leading standards to quickly view multiple indicators to be evaluated. Each indicator to be evaluated has a leading standard. The method of drawing peer data into charts based on leading standards includes: obtaining each The plural peer data of the evaluation index, the peer data contains a specific data, and each index to be evaluated matches a direction code, when the leading standard of each index to be evaluated is the larger the value of the peer data, it depends When it is leading, set the direction code to a positive direction. When the leading standard of each of the indicators to be evaluated is regarded as a lead as the value of the peer data is smaller, set the direction code to a negative direction; The peer data selects at least two initial percentile cutoff points, and at least two of the initial percentile cutoff points divide the peer data into at least three intervals; when the direction code is the negative direction, maintain the initial The percentile cutoff point is a correct percentile cutoff point; when the direction code is the positive direction, 100 minus the initial percentile cutoff point is the correct percentile cutoff point; and calculated in a time period Within, the number and/or percentage of each of the specific data of each of the indicators to be evaluated falls within each of at least three of the intervals, and each is drawn based on the cutoff point between the multiple indicators to be evaluated and the correct percentile. A heat map of the number and/or percentage that the specific data of the indicator to be evaluated falls in each of at least three intervals. A computer program product used to load a computer device to execute the method of drawing peer data into charts based on leading standards as described in any one of items 1 to 6 of the scope of patent application. A computer-readable medium is used for loading a computer device to execute the method of drawing peer data into charts according to leading standards as described in any one of items 1 to 6 of the scope of patent application. A computer program product used to load a computer device to execute the method of drawing peer data into charts based on leading standards as described in item 7 of the scope of patent application.

Images