Construction of a monitoring system for drug resistance screening of new pathogen positive pulmonary tuberculosis cases based on Power Pivot

doi:10.3969/j.issn.2095-3755.2019.04.012

Abstract

Abstract:

In order to understand the quality of drug resistance screening for new pathogen positive tuberculosis (TB) cases and standardize the drug resistance screening, Power Pivot tool was used in this study to construct a drug resistance screening auxiliary monitoring system. After the construction of the system, it can generate the drug resistance screening reports of new pathogen positive TB patients in different interactive dimensions according to the time conditions such as year, quarter and regional conditions such as region, institution, and accurately generate the list of patients who not screened for drug resistance. As an assistant and supplement to the statistical module of Tuberculosis Information Management System, a subsystem of the China Information System for Disease Control and Prevention, the tool provides a solution to reflect the quality of drug resistance screening work flexibly, quickly and accurately.

Key words: Tuberculosis,multidrug resistance, Multiphasic screening, Population surveillance, Software design, Database management systems

Yin-suo YAN,Li-ying TAO,Hong-wei ZHANG,Yan-yuan LI,Zhi-dong GAO. Construction of a monitoring system for drug resistance screening of new pathogen positive pulmonary tuberculosis cases based on Power Pivot[J]. Journal of Tuberculosis and Lung Health , 2019, 8(4): 294-298. doi: 10.3969/j.issn.2095-3755.2019.04.012

Figures/Tables 7

References 14

[1]	中华人民共和国国务院办公厅. “十三五”全国结核病防治规划.国办发〔2017〕16号. 2017 -02-01.
[2]	World Health Organization. Global tuberculosis report 2019. Geneva:World Health Organization, 2019. doi: 10.9745/GHSP-D-19-00210 URL pmid: 31852741
[3]	陆伟, 傅衍勇 . 我国耐药结核病控制的现状与展望. 结核病与肺部健康杂志, 2016,5(4):259-261.
[4]	de Jonge Kasper. 用Power Pivot和Excel创建仪表板和财务分析报告. 刘凯,杜美杰,译. 北京: 经济科学出版社, 2017: 1-6.
[5]	胡忠义 . 结核病耐药性检测技术进展及存在的问题和对策. 中国防痨杂志, 2013,35(11):865-867.
[6]	杨风杰 . 应用EXCEL编辑疾病监测传染病月报. 河南预防医学杂志, 2001,12(6):372-373.
[7]	彭国平 . 采用EXCEL软件建立丝虫病监测资料管理数据库的初步探讨. 中国寄生虫病防治杂志, 2000,13(3):181-183.
[8]	庄振春, 王朝娜 . 基于VBA的数据报告自动生成系统. 电子设计工程, 2017,25(11):57-60,64.
[9]	于婧洋 . 电力企业Excel VBA监测数据管理软件的实现. 现代国企研究, 2018,( 6):119-151.
[10]	杜连心, 侯刚, 范丽娟 , 等. Excel软件在三级综合医院传染病网络直报中的应用. 中国医院统计, 2019, 26(1):79-80,封3.
[11]	潘璐, 姚瑶, 张建春 , 等. 在Excel中实现统计功能扩展. 中国卫生统计, 2007,24(5):543-544.
[12]	杨恒刚, 李子民, 李彩义 , 等. 基于Excel平台扩展的应用实践. 中国卫生统计, 2011,28(6):726-727.
[13]	李潇, 王骏, 董国庆 , 等. 基于excel的数据管理及其在公共卫生领域内的应用. 中国卫生统计, 2014,31(6):1084-1086.
[14]	左良军, 李立功 . 基于大数据技术的专利价值评估与筛选系统. 中国发明与专利, 2018,15(10):41-44.

工作表名称	主要信息	字段个数	关键信息字段	来源
病案基本信息	病原学检查信息	74	[登记分类][诊断结果]	《专报系统》
耐药筛查信息	耐药检查信息	76	[综合快速确诊结果][传统确诊结果]	《专报系统》
日期表	日期筛选条件	3	[年][季度][日]	创建
机构表	机构筛选条件	2	[区][机构]	创建

度量值	输入公式
新病原学阳性患者数	新病原学阳性患者数:=COUNTA('新病原学阳性患者信息表'[登记号])
耐药筛查数	耐药筛查数:=COUNTROWS(FILTER('耐药筛查信息',[可疑者登记分类]="新患者"&&[耐药筛查情况]="已筛查"&&[辅助]<>""))
未耐药筛查数	未耐药筛查数:=[新病原学阳性患者数]-[耐药筛查数]
耐药筛查率	耐药筛查率:=[耐药筛查数]/[新病原学阳性患者数]

类别	适用范围		操作简单	监测指标呈现	未筛查名单提示
类别	各级结防机构	定点医疗机构	操作简单	监测指标呈现	未筛查名单提示
专报统计模块	√	×	√	√	×
传统手工整理	√	√	×	√	√
辅助监测系统	√	√	√	√	√

[1]	Zheng Jianli, Wu Yumei, Zhang Shili, Du Zixian, Li Turong, Chen Shisheng, Lin Wenge. Cost-effectiveness analysis of active tuberculosis screening among high-risk populations in Longyan City, Fujian Province [J]. Journal of Tuberculosis and Lung Disease, 2025, 6(1): 35-39.
[2]	Li Jing, He Jinge, Li Ting, Li Yunkui, Gao Wenfeng. Analysis of feasibility and effectiveness of the implementation of strengthened tuberculosis management model in Liangshan Yi Autonomous Prefecture, Sichuan Province [J]. Journal of Tuberculosis and Lung Disease, 2022, 3(6): 449-454.
[3]	XIAO Xiao, CHEN Jing, RAO Li-xin, JIANG Yue, LI Jin, ZHAO Ya-meng, SHEN Xin. A study of detection methods of latent Mycobacterium tuberculosis infection in close contacts of active tuberculosis patients among college students [J]. Journal of Tuberculosis and Lung Disease, 2021, 2(4): 311-316.
[4]	WU Jing. Four-wheel-driven accelerated prevention and control of chronic pulmonary diseases in the post-epidemic era [J]. Journal of Tuberculosis and Lung Disease, 2021, 2(3): 202-204.
[5]	CAO Li, ZHUANG Run-sen, ZHANG Yuan, HAN Tie-guang. Analysis of smoking status and influencing factors of employees in enterprise in Shenzhen [J]. Journal of Tuberculosis and Lung Disease, 2021, 2(2): 174-178.
[6]	WANG Yan, ZHENG Kai-qiao, WEI Yi-ting, FANG Hong-xia. Influencing factors of tuberculosis infection of newly admitted patients in a drug rehab center from 2017 to 2019 [J]. Journal of Tuberculosis and Lung Health, 2020, 9(1): 32-36.
[7]	Yu-bao QIN,Hong-xia FANG,Ming-chuan ZHANG,Yan WANG,Yi-ting WEI,Nian-sha ZHANG,Qiu-zi CHEN,Xiao-ping TAN,Kai-qiao ZHENG,Chang-wei LIU,Xin-feng YAN,Zhi-cong CHEN. Effect of video observed therapy for tuberculosis patients’ management by internet and mobile phones [J]. Journal of Tuberculosis and Lung Health, 2019, 8(4): 253-258.
[8]	Jin LI,Li-ping LU,Xiao-qin GUO,Yong LI,Jin-yan ZOU. Analysis on tuberculosis epidemical situation and screening results of close contacts in schools of Songjiang District of Shanghai in 2018 [J]. Journal of Tuberculosis and Lung Health, 2019, 8(2): 94-99.
[9]	Nan QIN,Jun CHENG,Wei-bing WANG. Research progress on risk factors and active screening strategies in senile tuberculosis [J]. Journal of Tuberculosis and Lung Health, 2018, 7(3): 208-212.
[10]	Jie XU,Zhi-hua CHEN,Can-you ZHANG,Jun CHENG. Strengthening active screening for elderly tuberculosis by integrating it into National Basic Public Health Service Project [J]. Journal of Tuberculosis and Lung Health, 2018, 7(3): 167-170.
[11]	Guo-fang DENG,Liang. FU. Current status of diagnosis and treatment of tuberculosis complicated with rheumatic diseases [J]. Journal of Tuberculosis and Lung Health, 2018, 7(2): 88-90.
[12]	Rui-ming CHEN,Jian-xiong. LIN. Discussion on the health management mode of tuberculosis patients in the information age [J]. Journal of Tuberculosis and Lung Health, 2018, 7(1): 68-70.
[13]	GUO Jun-tao. Progress of evaluation method of the tuberculosis case detection rate [J]. Journal of Tuberculosis and Lung Health, 2017, 6(3): 289-292.
[14]	XING Jin,JIN Xiao-wei,DUAN Hai-xia,WEI Xiao-hui,JIN Hong-jian,HE Shi-de,LIU Yuan-sen.. Analysis of tuberculosis death surveillance in Xinmi city, He’nan, 1992—2012 [J]. Journal of Tuberculosis and Lung Health, 2014, 3(3): 166-170.
[15]	WANG De-zheng,ZHANG Hui,ZHANG Ying,JIANG Guo-hong. The relationship between smoking and lung cancer deaths:a population based case control study [J]. Journal of Tuberculosis and Lung Health, 2012, 1(2): 91-96.