A brief talk on using Excel to collect quality control indicators of monthly clinical examination

doi:10.3877/cma.j.issn.2095-5820.2019.03.011

Chinese Journal of Clinical Laboratory Management(Electronic Edition) ›› 2019, Vol. 07 ›› Issue (03): 180-183. doi: 10.3877/cma.j.issn.2095-5820.2019.03.011

Special Issue: ；

• Quality Control • Previous Articles Next Articles

A brief talk on using Excel to collect quality control indicators of monthly clinical examination

Binguo Ma¹^,^†()

^1. Department of Quality Control, Shanxi Center of Clinical Laboratories, Taiyuan 030012, China

Received:2018-12-03 Online:2019-08-28 Published:2019-08-28
Contact: Binguo Ma
About author:
Corresponding author: Ma Binguo, Email: 598535167@qq.com

Abstract

Abstract:

Objective

To investigate the status of collection of quality control indicators for monthly clinical laboratory.

Methods

Using Microsoft Excel to edit and statistics the quality control indicators of monthly clinical laboratory.

Results

Through practical application, accurate and reliable monthly clinical laboratory quality indicators can be obtained.

Conclusion

If the clinical laboratory does not have the ability to collect monthly quality control indicators through LIS system, it can use Microsoft Excel editing and statistical functions to implement the collection and statistics of monthly quality control indicators.

Key words: Clinical test, Quality control indicators, Collect, Statistics

Binguo Ma. A brief talk on using Excel to collect quality control indicators of monthly clinical examination[J]. Chinese Journal of Clinical Laboratory Management(Electronic Edition), 2019, 07(03): 180-183.

/ / Recommend

Add to citation manager EndNote|Ris|BibTeX

URL: https://zhlcsysgldzzz.cma-cmc.com.cn/EN/10.3877/cma.j.issn.2095-5820.2019.03.011

https://zhlcsysgldzzz.cma-cmc.com.cn/EN/Y2019/V07/I03/180

1	中华人民共和国卫生部. 医疗机构临床实验室管理办法[Z]. 2006-02-27.
2	王治国，费阳，康凤凤，等. 国家卫生计生委发布临床检验专业15项医疗质量控制指标(2015年版)内容及解读[J]. 中华检验医学杂志, 2015,38(11):777-781.
3	魏超. 临床检验质量控制指标的现状分析[J]. 医学信息, 2014,27(9):612.
4	费阳，康凤凤，王薇，等. 2015年全国临床检验质量指标室间质量评价[J]. 中华检验医学杂志, 2016,39(6):433-437.

[1]	Yan Li, Yangchen Liu, Meiyu Deng, Qimiao Wang, Bin Wu, Jianmin Gao, Nan Zhang, Dong Liu, Xueyi Liu. Comparison of axial length using optical and ultrasonic biometry in the observation of eyes with vitreous hemorrhage and retinal detachment [J]. Chinese Journal of Medical Ultrasound (Electronic Edition), 2017, 14(10): 738-742.
[2]	Rujun Lin, Xuanfa Li, Hongming Huang, Weiwei Long. Application of lumbar plexus combined with sciatic nerve block in total hip arthroplasty of elderly patients [J]. Chinese Journal of Joint Surgery(Electronic Edition), 2022, 16(02): 148-153.
[3]	Keren Luo, Jun Tang. Research advances in the composition and function of pulmonary surfactant [J]. Chinese Journal of Obstetrics & Gynecology and Pediatrics(Electronic Edition), 2019, 15(02): 137-142.
[4]	Min Zhang, Wei Zhang, Wen Xu. Relationships between results of neonatal screening of congenital hypothyroidism and phenylketonuria and the time of blood collection [J]. Chinese Journal of Obstetrics & Gynecology and Pediatrics(Electronic Edition), 2018, 14(05): 584-588.
[5]	Ying Wu, Rui He, Ying Xiong, Xingyuan Jiao, Qian Wang. Survey of the extra-hepatic cholangiocarcinoma patients undergoing surgeries from a tertiary hospital in Guangzhou from 2005 to 2014 [J]. Chinese Archives of General Surgery(Electronic Edition), 2015, 09(04): 323-326.
[6]	Yuemei Zhang, Xueying Li, Xiaoyan Zhang, Jiali Qiao, Xuelian Yang, Qingxue Yin, Juan Chen. Relationship between peripheral blood erythrocyte parameters of related donors and hematopoietic stem cell collection [J]. Chinese Journal of Cell and Stem Cell(Electronic Edition), 2022, 12(02): 74-78.
[7]	Ying Zheng, Changming Zhou. Comprehensive strategies, the route leading to cancer prevention and control——What we learned from US Cancer Statistics [J]. Chinese Journal of Colorectal Diseases(Electronic Edition), 2018, 07(02): 102-108.
[8]	He Li, Luoru Liu, Hailin Meng, Yazhou Ji, Jiyuan Guo. Effects of "Anyang Childhood Eye Study" on prevention and control of myopia in children [J]. Chinese Journal of Ophthalmologic Medicine(Electronic Edition), 2021, 11(06): 333-338.
[9]	Jianping Hu, Huiying Qi, Jianguang Guo, Dongsheng Wang, xiaohui Yang, ailian Hu, bingsong Wang, sairou Lin, ningli Wang. Design of the shared Chinese version of the 25-item National Eye Institute Visual Function Questionnaire electronic data capture system [J]. Chinese Journal of Ophthalmologic Medicine(Electronic Edition), 2018, 08(06): 256-263.
[10]	Kuishuai Xu, Liang Zhang, Jinli Chen, Yi Zhang, Chao Qi, Haifeng Li, Jiake Gao, Bohua Chen, Tengbo Yu. Analysis of recessive blood loss and risk factors after medial open wedge high tibial osteotomy [J]. Chinese Journal of Geriatric Orthopaedics and Rehabilitation(Electronic Edition), 2021, 07(02): 79-84.
[11]	Aijuan Fan, Haiping Mou. Systematic review and Meta-analysis of endoscopic ultrasound drainage for peripancreatic fluid collection after pancreatic surgery [J]. Chinese Journal of Digestion and Medical Imageology(Electronic Edition), 2022, 12(06): 361-366.
[12]	Liming Ji, Zimin Lu, Qi Fang, Chengzhong Liu, Xuechen Li. Factors influencing collection of non-mobilized peripheral blood stem cells from solid tumor patients and healthy donors [J]. Chinese Journal of Clinicians(Electronic Edition), 2019, 13(06): 419-423.
[13]	Wei Jiang, Junshi Zhang, Patiguli, Qingchen Li, Xinjuan Xu. Comparison of the spot urine and 24-hour urine collection method in evaluating 24-hour sodium and potassium excretion in patients with hypertension [J]. Chinese Journal of Diagnostics(Electronic Edition), 2019, 07(01): 21-25.
[14]	Limin Zhang, Hong Lyu, Guojun Zhang, Xixiong Kang. The new pattern of information collection for diagnostics [J]. Chinese Journal of Diagnostics(Electronic Edition), 2016, 04(02): 104-106.
[15]	Bo Zhang, Ningli Chai, Longsong Li, Fei Gao, Enqiang Linghu. Advances in minimally invasive therapy of pancreatic fluid collection [J]. Chinese Journal of Gastrointestinal Endoscopy(Electronic Edition), 2022, 09(01): 41-44.

Please choose a citation manager

Content to export

A brief talk on using Excel to collect quality control indicators of monthly clinical examination

RichHTML

PDF (PC)

Knowledge

Cited

Abstract

Cite this article

share this article

Figures/Tables 10

References 4

Related Articles 15

Recommended Articles

Metrics

Comments

模态框（Modal）标题

Please choose a citation manager

Content to export

A brief talk on using Excel to collect quality control indicators of monthly clinical examination

RichHTML

PDF (PC)

Knowledge

Cited

Abstract

Cite this article

share this article

Figures/Tables 10

References 4

Related Articles 15

Recommended Articles

Metrics

Comments