High-efficiency disease information management index data elimination method

Abstract

The invention discloses a high-efficiency disease information management index data eliminating method which comprises the following steps: S1, a statistical template is in an excel workbook form, a statistical method is that an excel table has a statistical function, and the template is composed of a statistical index summary table and a plurality of data source tables; s2, data indexes in the summary sheet are collectively called as first-level indexes; the method is easy and convenient to operate and high in efficiency, the statistical template gathers all statistical functions needing to be used into an excel workbook, the format of exported data of an existing information management system serves as a core, a user only pastes a corresponding excel table to a specified position of the template according to requirements and clicks all refreshes, the template can automatically complete data updating and statistical work, and the statistical efficiency is greatly improved. The statistical workload of the user is greatly reduced and simplified, the statistical time is greatly shortened to 0.5-1 day through feedback after application of the provincial level and 16 cities, and the working efficiency is greatly improved compared with the previous several days or even longer time.

Description

Technical Field

[0001] The present invention relates to the technical field of disease information data management, and in particular to a method for eliminating index data in disease information management with high efficiency. Background Art

[0002] Statistical elimination data indicators are an important part of the work of eliminating mother-to-child transmission of HIV, syphilis and hepatitis B, and are directly related to the smooth implementation of a series of work contents such as statistics, evaluation, supervision and feedback of various indicators for eliminating mother-to-child transmission. Statistical elimination of all elimination indicators in a certain area within a certain period of time is relatively time-consuming and labor-intensive, with low work efficiency and poor accuracy. Depending on the statistician's proficiency in using Excel spreadsheets or other statistical analysis methods, it usually takes several days or even longer to complete. The work of eliminating mother-to-child transmission is imminent, and the elimination results need to be maintained for a long time after passing the elimination certification.

[0003] At present, there is a lack of statistical tools in the country that can accurately and timely count all 24 elimination indicators at one time. The cities are unable to accurately and timely feedback the progress and phased completion of the elimination work in each county, which has affected the smooth implementation of the province's work to eliminate mother-to-child transmission, and cannot meet the needs of maintaining the elimination results in the long term after the provincial elimination certification is passed.

[0004] In order to solve the above technical problems, we have designed a highly efficient method for disease information management to eliminate indicator data. Summary of the invention

[0005] The purpose of the present invention is to provide a highly efficient method for disease information management elimination index data, which has the advantages of completing the statistics of 24 elimination data indicators in a relatively short time in the simplest and most practical way, improving work efficiency and statistical accuracy, so as to facilitate the smooth implementation of the application evaluation for elimination of mother-to-child transmission of HIV, syphilis and hepatitis B and the long-term maintenance stage after the evaluation, and solves the problem of lack of statistical tools that can accurately and timely count all 24 elimination indicators at one time, and the problem that the existing statistical methods are time-consuming, have low work efficiency and poor accuracy.

[0006] To achieve the above object, the present invention provides the following technical solution: a method for efficiently managing disease information and eliminating index data, comprising the following steps:

[0007] S1: The statistical template is in the form of an Excel workbook. The statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables.

[0008] S2: The data indicators in the summary table are collectively referred to as the first-level indicators, which are the statistical indicators that the template ultimately needs to obtain. The data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, which are indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, which are the basic data information used for statistics in this template.

[0009] S3: The row labels of the summary table are the names of the regions. Taking provincial statistics as an example, the row labels are the names of the cities. The total for the whole province is at the bottom of the table, and the columns are the names of the 24 elimination data indicators and their numerators and denominators.

[0010] S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical area, and the columns without color on the right are the data source area.

[0011] S5: According to the statistical target requirements, the data and information available for statistics in a certain area within a certain period of time are exported from the national information management system for prevention of mother-to-child transmission;

[0012] S6: The exported data information is in Excel table format. Except for the monthly work report which is a single Excel worksheet, the other exported data is in Excel workbook format.

[0013] Preferably, all data in the summary table in step S3 are obtained by real-time statistics from the data source table, and the data that do not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

[0014] Preferably, the statistical area in step S4 is used to determine the region to which the data belongs. Taking provincial-level statistics as an example, the region to which the data belongs is a certain city. If taking municipal-level statistics as an example, the region to which the data belongs is a certain county / district. The determination of the region to which the data belongs is an important basis for extracting data from the summary table.

[0015] Preferably, the statistical area in step S4 is also used to determine whether the piece of data and multiple pieces of related data meet a certain secondary indicator, and to determine the correlation between the piece of data and other data sources.

[0016] Preferably, the data information counted in step S5 includes monthly work reports, case registration cards for women infected with AIDS and their children, follow-up cards for pregnant women infected with AIDS and their children, case registration cards for pregnant women infected with syphilis and their babies, follow-up cards for children born to pregnant women infected with syphilis, case registration cards for pregnant women infected with hepatitis B and their newborns, and follow-up cards for babies born to pregnant women infected with hepatitis B.

[0017] Preferably, taking the statistical target at the provincial level in 2023 as an example, the exported data is the data information generated for statistics in the entire province in 2023, wherein the monthly work report is at the county level.

[0018] Preferably, each excel workbook in step S6 contains 2-6 worksheets, and each worksheet contains different information in the registration card and the follow-up card.

[0019] Preferably, when using the statistical template, the corresponding single Excel worksheet needs to be pasted into the specified position of the table specified by the template in the manner of "selective copy and paste values ​​and number format" according to the template requirements to convert the gestational weeks into numbers.

[0020] Preferably, some of the data source tables are equipped with pivot tables. After the data source tables are pasted as required, click on any pivot table, click "Refresh All", and the pivot table will be updated to the latest data. Open the statistical data summary table to obtain all primary data.

[0021] Preferably, the statistical template combines all the required statistical functions into an Excel workbook, with the existing information management system export data format as the core. The user only needs to paste the corresponding Excel table to the specified position of the template as required and click Refresh All, and the template can automatically complete the data update and statistical work.

[0022] Compared with the prior art, the present invention has the following beneficial effects:

[0023] 1. The present invention is easy to operate and has high efficiency. The statistical template combines all the required statistical functions into one Excel workbook, with the existing information management system exporting data format as the core. The user only needs to paste the corresponding Excel table to the specified position of the template as required and click Refresh All. The template can automatically complete the data update and statistical work, which greatly reduces and simplifies the user's statistical workload. After the application of colleagues at the provincial level and 16 cities, the feedback shows that the statistical time is greatly shortened to 0.5-1 day, which is greatly improved compared with the previous several days or even longer time.

[0024] 2. The present invention is accurate and reliable. Since the Excel table function is used for statistical calculation, the accuracy of the statistical results can be 100% guaranteed under the premise that the data format meets the statistical requirements. Compared with manual statistics, the error rate is greatly reduced, and the reliability of the data is guaranteed. BRIEF DESCRIPTION OF THE DRAWINGS DETAILED DESCRIPTION

[0025] A method for efficiently managing disease information to eliminate indicator data comprises the following steps:

[0026] S1: The statistical template is in the form of an Excel workbook. The statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables.

[0027] S2: The data indicators in the summary table are collectively referred to as the first-level indicators, which are the statistical indicators that the template ultimately needs to obtain. The data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, which are indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, which are the basic data information used for statistics in this template.

[0028] S3: The row labels of the summary table are the names of the regions. Taking provincial statistics as an example, the row labels are the names of the cities. The total for the whole province is at the bottom of the table, and the columns are the names of the 24 elimination data indicators and their numerators and denominators.

[0029] S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical area, and the columns without color on the right are the data source area.

[0030] S5: According to the statistical target requirements, the data and information available for statistics in a certain area within a certain period of time are exported from the national information management system for prevention of mother-to-child transmission;

[0031] S6: The exported data information is in Excel table format. Except for the monthly work report which is a single Excel worksheet, the other exported data is in Excel workbook format.

[0032] All data in the summary table in step S3 are obtained by real-time statistics from the data source table. The data that does not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

[0033] The statistical area in step S4 is used to determine the region to which the data belongs. Taking provincial-level statistics as an example, the region to which the data belongs is a certain city. If taking municipal-level statistics as an example, the region to which the data belongs is a certain county / district. The determination of the region to which the data belongs is an important basis for extracting data from the summary table.

[0034] The statistical area in step S4 is also used to determine whether this piece of data and multiple pieces of related data meet a certain secondary indicator, and to determine the correlation between this piece of data and other data sources.

[0035] The data information collected in step S5 includes monthly work reports, case registration cards for women infected with AIDS and their children, follow-up cards for pregnant women infected with AIDS and their children, case registration cards for pregnant women infected with syphilis and their babies, follow-up cards for children born to pregnant women infected with syphilis, case registration cards for pregnant women infected with hepatitis B and their newborns, and follow-up cards for babies born to pregnant women infected with hepatitis B.

[0036] Taking the statistical target at the provincial level in 2023 as an example, the exported data is the data information generated for statistics in the entire province in 2023, among which the monthly work report is at the county level (the county-level monthly work report is the basic data for generating the provincial monthly report).

[0037] In step S6, each excel workbook contains 2-6 worksheets, and each worksheet contains different information in the registration card and the follow-up card.

[0038] When using the statistical template, you need to paste the corresponding single Excel worksheet into the specified position of the template specified table in the "selective copy and paste values ​​and number formats" mode according to the template requirements to convert the gestational weeks into numbers.

[0039] Some data source tables are equipped with pivot tables. After pasting the data source table as required, click any pivot table and click "Refresh All". The pivot table will be updated with the latest data. Open the statistical data summary table to obtain all primary data.

[0040] The statistical template combines all the required statistical functions into an Excel workbook, with the existing information management system export data format as the core. Users only need to paste the corresponding Excel table into the specified position of the template as required and click Refresh All, and the template can automatically complete the data update and statistical work.

[0041] Embodiment 1

[0042] A method for efficiently managing disease information to eliminate indicator data comprises the following steps:

[0043] S1: The statistical template is in the form of an Excel workbook, and the statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables; S2: The data indicators in the summary table are collectively referred to as the first-level indicators, that is, the statistical indicators that the template needs to obtain in the end, and the data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, that is, the indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, that is, the basic data information used for statistics in this template; S3: The row labels of the summary table are the names of various regions. Taking provincial statistics as an example, the row labels are the names of various cities, and the total for the whole province is at the bottom of the table. The column labels are the names of the 24 elimination data indicators and their numerators and denominators; S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical areas, and the columns without color on the right are the data source areas; S5: According to the statistical target requirements, the data information available for statistics in a certain area within a certain time period is exported from the National Information Management System for Prevention of Mother-to-Child Transmission; S6: The exported data information is in the form of Excel tables. Except for the monthly work report which is a single Excel worksheet, the other exported data are in the form of Excel workbooks.

[0044] All data in the summary table in step S3 are obtained by real-time statistics from the data source table. The data that does not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

[0045] The data information collected in step S5 includes monthly work reports, case registration cards for women infected with AIDS and their children, follow-up cards for pregnant women infected with AIDS and their children, case registration cards for pregnant women infected with syphilis and their babies, follow-up cards for children born to pregnant women infected with syphilis, case registration cards for pregnant women infected with hepatitis B and their newborns, and follow-up cards for babies born to pregnant women infected with hepatitis B.

[0046] Taking the statistical target at the provincial level in 2023 as an example, the exported data is the data information generated for statistics in the entire province in 2023, among which the monthly work report is at the county level (the county-level monthly work report is the basic data for generating the provincial monthly report).

[0047] In step S6, each excel workbook contains 2 worksheets, and each worksheet contains different information in the registration card and the follow-up card.

[0048] When using the statistical template, you need to paste the corresponding single Excel worksheet into the specified position of the template specified table in the "selective copy and paste values ​​and number formats" mode according to the template requirements to convert the gestational weeks into numbers.

[0049] Some data source tables are equipped with pivot tables. After pasting the data source table as required, click any pivot table and click "Refresh All". The pivot table will be updated to the latest data. Open the statistical data summary table to obtain all primary data.

[0050] The statistical template combines all the required statistical functions into an Excel workbook, with the existing information management system export data format as the core. Users only need to paste the corresponding Excel table into the specified position of the template as required and click Refresh All, and the template can automatically complete the data update and statistical work.

[0051] Embodiment 2

[0052] A method for efficiently managing disease information to eliminate indicator data comprises the following steps:

[0053] S1: The statistical template is in the form of an Excel workbook, and the statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables; S2: The data indicators in the summary table are collectively referred to as the first-level indicators, that is, the statistical indicators that the template needs to obtain in the end, and the data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, that is, the indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, that is, the basic data information used for statistics in this template; S3: The row labels of the summary table are the names of various regions. Taking provincial statistics as an example, the row labels are the names of various cities, and the total for the whole province is at the bottom of the table. The column labels are the names of the 24 elimination data indicators and their numerators and denominators; S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical areas, and the columns without color on the right are the data source areas; S5: According to the statistical target requirements, the data information available for statistics in a certain area within a certain time period is exported from the National Information Management System for Prevention of Mother-to-Child Transmission; S6: The exported data information is in the form of Excel tables. Except for the monthly work report which is a single Excel worksheet, the other exported data are in the form of Excel workbooks.

[0054] All data in the summary table in step S3 are obtained by real-time statistics from the data source table. The data that does not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

[0055] The statistical area in step S4 is used to determine the region to which the data belongs. Taking provincial-level statistics as an example, the region to which the data belongs is a certain city. If taking municipal-level statistics as an example, the region to which the data belongs is a certain county / district. The determination of the region to which the data belongs is an important basis for extracting data from the summary table.

[0056] The statistical area in step S4 is also used to determine whether this piece of data and multiple pieces of related data meet a certain secondary indicator, and to determine the correlation between this piece of data and other data sources.

[0057] In step S6, each excel workbook contains 4 worksheets, and each worksheet contains different information in the registration card and the follow-up card.

[0058] When using the statistical template, you need to paste the corresponding single Excel worksheet into the specified position of the template specified table in the "selective copy and paste values ​​and number formats" mode according to the template requirements to convert the gestational weeks into numbers.

[0059] Some data source tables are equipped with pivot tables. After pasting the data source table as required, click any pivot table and click "Refresh All". The pivot table will be updated to the latest data. Open the statistical data summary table to obtain all primary data.

[0060] The statistical template combines all the required statistical functions into an Excel workbook, with the existing information management system export data format as the core. Users only need to paste the corresponding Excel table into the specified position of the template as required and click Refresh All, and the template can automatically complete the data update and statistical work.

[0061] Embodiment 3

[0062] A method for efficiently managing disease information to eliminate indicator data comprises the following steps:

[0063] S1: The statistical template is in the form of an Excel workbook, and the statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables; S2: The data indicators in the summary table are collectively referred to as the first-level indicators, that is, the statistical indicators that the template needs to obtain in the end, and the data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, that is, the indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, that is, the basic data information used for statistics in this template; S3: The row labels of the summary table are the names of various regions. Taking provincial statistics as an example, the row labels are the names of various cities, and the total for the whole province is at the bottom of the table. The column labels are the names of the 24 elimination data indicators and their numerators and denominators; S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical areas, and the columns without color on the right are the data source areas; S5: According to the statistical target requirements, the data information available for statistics in a certain area within a certain time period is exported from the National Information Management System for Prevention of Mother-to-Child Transmission; S6: The exported data information is in the form of Excel tables. Except for the monthly work report which is a single Excel worksheet, the other exported data are in the form of Excel workbooks.

[0064] All data in the summary table in step S3 are obtained by real-time statistics from the data source table. The data that does not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

[0065] The statistical area in step S4 is used to determine the region to which the data belongs. Taking provincial-level statistics as an example, the region to which the data belongs is a certain city. If taking municipal-level statistics as an example, the region to which the data belongs is a certain county / district. The determination of the region to which the data belongs is an important basis for extracting data from the summary table.

[0066] The statistical area in step S4 is also used to determine whether this piece of data and multiple pieces of related data meet a certain secondary indicator, and to determine the correlation between this piece of data and other data sources.

[0067] The data information collected in step S5 includes monthly work reports, case registration cards for women infected with AIDS and their children, follow-up cards for pregnant women infected with AIDS and their children, case registration cards for pregnant women infected with syphilis and their babies, follow-up cards for children born to pregnant women infected with syphilis, case registration cards for pregnant women infected with hepatitis B and their newborns, and follow-up cards for babies born to pregnant women infected with hepatitis B.

[0068] Taking the statistical target at the provincial level in 2023 as an example, the exported data is the data information generated for statistics in the entire province in 2023, among which the monthly work report is at the county level (the county-level monthly work report is the basic data for generating the provincial monthly report).

[0069] Each excel workbook in step S6 contains 6 worksheets, and each worksheet contains different information in the registration card and follow-up card.

[0070] When using the statistical template, you need to paste the corresponding single Excel worksheet into the specified position of the template specified table in the "selective copy and paste values ​​and number formats" mode according to the template requirements to convert the gestational weeks into numbers.

[0071] In summary: This efficient method of disease information management elimination indicator data, through the above steps, solves the problem of lack of statistical tools that can accurately and timely count all 24 elimination indicators at one time, and the existing statistical methods are time-consuming, low in efficiency and poor in accuracy.

Claims

1. A method for efficiently managing disease information to eliminate index data, characterized in that The following steps are involved: S1: The statistical template is in the form of an Excel workbook. The statistical method is the statistical function that comes with the Excel table. The template consists of a statistical indicator summary table and several data source tables. S2: The data indicators in the summary table are collectively referred to as the first-level indicators, which are the statistical indicators that the template ultimately needs to obtain. The data indicators in the statistical area of ​​the data source table are collectively referred to as the second-level indicators, which are indicators generated by the third-level indicators and used to count the first-level indicators. The data in the data source area of ​​the data source table are collectively referred to as the third-level indicators, which are the basic data information used for statistics in this template. S3: The row labels of the summary table are the names of the regions. Taking provincial statistics as an example, the row labels are the names of the cities. The total for the whole province is at the bottom of the table, and the column labels are the names of the 24 elimination data indicators and their numerators and denominators. S4: Each data source table is divided into two parts. The columns marked in yellow on the left are the statistical area, and the columns without color on the right are the data source area. S5: According to the statistical target requirements, the data and information available for statistics in a certain area within a certain period of time are exported from the national information management system for prevention of mother-to-child transmission; S6: The exported data information is in Excel table format. Except for the monthly work report which is a single Excel worksheet, the other exported data is in Excel workbook format.

2. The method for efficiently managing disease information and eliminating index data according to claim 1, characterized in that: All data in the summary table in step S3 are obtained by real-time statistics from the data source table, and the data that do not meet the national requirements among the 24 elimination indicators will be automatically highlighted in orange.

3. The method for efficiently eliminating index data of disease information management according to claim 1, characterized in that: The statistical area in step S4 is used to determine the region to which the data belongs. Taking provincial-level statistics as an example, the region to which the data belongs is a certain city. If taking municipal-level statistics as an example, the region to which the data belongs is a certain county / district. The determination of the region to which the data belongs is an important basis for extracting data from the summary table.

4. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: The statistical area in step S4 is also used to determine whether the piece of data and multiple pieces of related data meet a certain secondary indicator, and to determine the relevance between the piece of data and other data sources.

5. The method for efficiently managing disease information and eliminating index data according to claim 1, characterized in that: The data information collected in step S5 includes monthly work reports, case registration cards for women infected with AIDS and their children, follow-up cards for pregnant women infected with AIDS and their children, case registration cards for pregnant women infected with syphilis and their babies, follow-up cards for children born to pregnant women infected with syphilis, case registration cards for pregnant women infected with hepatitis B and their newborns, and follow-up cards for babies born to pregnant women infected with hepatitis B.

6. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: Taking the statistical target at the provincial level in 2023 as an example, the exported data is the data information generated for statistics in the entire province in 2023, among which the monthly work report is at the county level.

7. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: In step S6, each excel workbook contains 2-6 worksheets, and each worksheet contains different information in the registration card and the follow-up card.

8. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: When using the statistical template, the corresponding single Excel worksheet needs to be pasted into the specified position of the table specified by the template in the "selective copy and paste values ​​and number formats" mode according to the template requirements to convert the gestational age into numbers.

9. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: Some of the data source tables are equipped with pivot tables. After the data source tables are pasted as required, click any pivot table and click "Refresh All". The pivot table will be updated to the latest data. Open the statistical data summary table to obtain all primary data.

10. The method of claim 1 for efficiently managing disease information and eliminating index data, characterized in that: The statistical template combines all the required statistical functions into an Excel workbook, with the existing information management system export data format as the core. Users only need to paste the corresponding Excel table into the specified position of the template as required and click Refresh All, and the template can automatically complete the data update and statistical work.