基于患者的质量控制分析与评估(SPAE)电子表格。

Q2 Medicine
Hui Qi Low, Hyun-Ki Kim, Sollip Kim, Tony Badrick, Tze Ping Loh, Chun Yee Lim
{"title":"基于患者的质量控制分析与评估(SPAE)电子表格。","authors":"Hui Qi Low, Hyun-Ki Kim, Sollip Kim, Tony Badrick, Tze Ping Loh, Chun Yee Lim","doi":"","DOIUrl":null,"url":null,"abstract":"<p><strong>Introduction: </strong>Patient-based quality control (PBQC) is an alternate quality control technique to conventional (internal) quality control. It uses patient results generated for clinical care to monitor the analytical performance through statistical analysis. The use of PBQC in routine laboratory is impeded by lack of familiarity and appropriate informatics tool.</p><p><strong>Method: </strong>A Spreadsheet for PBQC Analysis and Evaluation (SPAE, based on Microsoft Excel) is developed. It incorporates IFCC recommended features for PBQC informatics tool that has been automated, including data visualization, data (Box-Cox) transformation, extreme value treatment (winsorization) and user parameter selection (block size, acceptable false positive rate, desirable bias for detection).</p><p><strong>Results: </strong>Following parameter selection and data input, the spreadsheet automatically calculates the winsorization limits, transformed values, performance verification metrics such as false positive rates and number of results affected before error detection (NPed) - a performance metric for how sensitive the PBQC model detects the predefined error (bias). The verified PBQC model can be used for routine monitoring. The performance of the spreadsheet tool was verified against an independent model based on Python. Laboratory users can download the tool at https://github.com/HuiQi96/PBQC/blob/main/PBQC_model_v2.2.zip.</p><p><strong>Discussion: </strong>The SPAE is a simple-to-use desktop tool that lowers the barrier for laboratory users to adopt PBQC in their quality control system. In addition, the spreadsheet can be used as an educational tool, such as when conducting a workshop, to help laboratory users better familiarize themselves with the PBQC concepts and used for independent verification of the output of another informatics tool.</p>","PeriodicalId":37192,"journal":{"name":"Electronic Journal of the International Federation of Clinical Chemistry and Laboratory Medicine","volume":"36 1","pages":"26-36"},"PeriodicalIF":0.0000,"publicationDate":"2025-02-28","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11886628/pdf/","citationCount":"0","resultStr":"{\"title\":\"Spreadsheet for Patient-Based Quality Control Analysis and Evaluation (SPAE).\",\"authors\":\"Hui Qi Low, Hyun-Ki Kim, Sollip Kim, Tony Badrick, Tze Ping Loh, Chun Yee Lim\",\"doi\":\"\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<p><strong>Introduction: </strong>Patient-based quality control (PBQC) is an alternate quality control technique to conventional (internal) quality control. It uses patient results generated for clinical care to monitor the analytical performance through statistical analysis. The use of PBQC in routine laboratory is impeded by lack of familiarity and appropriate informatics tool.</p><p><strong>Method: </strong>A Spreadsheet for PBQC Analysis and Evaluation (SPAE, based on Microsoft Excel) is developed. It incorporates IFCC recommended features for PBQC informatics tool that has been automated, including data visualization, data (Box-Cox) transformation, extreme value treatment (winsorization) and user parameter selection (block size, acceptable false positive rate, desirable bias for detection).</p><p><strong>Results: </strong>Following parameter selection and data input, the spreadsheet automatically calculates the winsorization limits, transformed values, performance verification metrics such as false positive rates and number of results affected before error detection (NPed) - a performance metric for how sensitive the PBQC model detects the predefined error (bias). The verified PBQC model can be used for routine monitoring. The performance of the spreadsheet tool was verified against an independent model based on Python. Laboratory users can download the tool at https://github.com/HuiQi96/PBQC/blob/main/PBQC_model_v2.2.zip.</p><p><strong>Discussion: </strong>The SPAE is a simple-to-use desktop tool that lowers the barrier for laboratory users to adopt PBQC in their quality control system. In addition, the spreadsheet can be used as an educational tool, such as when conducting a workshop, to help laboratory users better familiarize themselves with the PBQC concepts and used for independent verification of the output of another informatics tool.</p>\",\"PeriodicalId\":37192,\"journal\":{\"name\":\"Electronic Journal of the International Federation of Clinical Chemistry and Laboratory Medicine\",\"volume\":\"36 1\",\"pages\":\"26-36\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2025-02-28\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC11886628/pdf/\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Electronic Journal of the International Federation of Clinical Chemistry and Laboratory Medicine\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"2025/3/1 0:00:00\",\"PubModel\":\"eCollection\",\"JCR\":\"Q2\",\"JCRName\":\"Medicine\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Electronic Journal of the International Federation of Clinical Chemistry and Laboratory Medicine","FirstCategoryId":"1085","ListUrlMain":"","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2025/3/1 0:00:00","PubModel":"eCollection","JCR":"Q2","JCRName":"Medicine","Score":null,"Total":0}
引用次数: 0

摘要

以患者为基础的质量控制(PBQC)是一种替代传统(内部)质量控制的质量控制技术。它使用临床护理产生的患者结果,通过统计分析来监测分析性能。由于缺乏熟悉度和适当的信息学工具,PBQC在常规实验室的应用受到阻碍。方法:开发PBQC分析与评价电子表格(SPAE,基于Microsoft Excel)。它结合了IFCC推荐的自动化PBQC信息学工具功能,包括数据可视化,数据(Box-Cox)转换,极值处理(winsorization)和用户参数选择(块大小,可接受的假阳性率,理想的检测偏差)。结果:在参数选择和数据输入之后,电子表格自动计算winsorization限制,转换值,性能验证指标,如假阳性率和错误检测(NPed)之前受影响的结果数量- PBQC模型检测预定义错误(偏差)的敏感度的性能指标。经验证的PBQC模型可用于常规监测。在基于Python的独立模型上验证了电子表格工具的性能。实验室用户可以从https://github.com/HuiQi96/PBQC/blob/main/PBQC_model_v2.2.zip.Discussion下载该工具:SPAE是一个简单易用的桌面工具,降低了实验室用户在其质量控制系统中采用PBQC的障碍。此外,电子表格可以用作教育工具,例如在举办研讨会时,帮助实验室用户更好地熟悉PBQC概念,并用于独立验证另一个信息学工具的输出。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
Spreadsheet for Patient-Based Quality Control Analysis and Evaluation (SPAE).

Introduction: Patient-based quality control (PBQC) is an alternate quality control technique to conventional (internal) quality control. It uses patient results generated for clinical care to monitor the analytical performance through statistical analysis. The use of PBQC in routine laboratory is impeded by lack of familiarity and appropriate informatics tool.

Method: A Spreadsheet for PBQC Analysis and Evaluation (SPAE, based on Microsoft Excel) is developed. It incorporates IFCC recommended features for PBQC informatics tool that has been automated, including data visualization, data (Box-Cox) transformation, extreme value treatment (winsorization) and user parameter selection (block size, acceptable false positive rate, desirable bias for detection).

Results: Following parameter selection and data input, the spreadsheet automatically calculates the winsorization limits, transformed values, performance verification metrics such as false positive rates and number of results affected before error detection (NPed) - a performance metric for how sensitive the PBQC model detects the predefined error (bias). The verified PBQC model can be used for routine monitoring. The performance of the spreadsheet tool was verified against an independent model based on Python. Laboratory users can download the tool at https://github.com/HuiQi96/PBQC/blob/main/PBQC_model_v2.2.zip.

Discussion: The SPAE is a simple-to-use desktop tool that lowers the barrier for laboratory users to adopt PBQC in their quality control system. In addition, the spreadsheet can be used as an educational tool, such as when conducting a workshop, to help laboratory users better familiarize themselves with the PBQC concepts and used for independent verification of the output of another informatics tool.

求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
CiteScore
2.30
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信