DEVELOPMENT AND IMPLEMENTATION OF QUALITY MANAGEMENT SOFTWARE FOR FLOW CYTOMETRY LABORATORIES
- 1Hospital das Clínicas, Faculdade de Medicina de Botucatu (HCFMB), Botucatu, SP, Brazil
- 2SENAI Botucatu, Botucatu, SP, Brazil
Abstract
Introduction: Managing consumable resources in flow cytometry laboratories poses a complex logistical challenge, given the heterogeneity of reagents in terms of composition, concentration, and stability. This scenario requires rigorous monitoring to minimize waste and ensure the reliability of assays. Conventional management systems lack features that address the specific needs of flow cytometry. Objective: This study aimed to implement a resource management software system for flow cytometry laboratories (automated system) and compare it with a manual system (Excel spreadsheet). Materials and Methods: In partnership with SENAI-Botucatu, we developed software using VS Code (front-end IDE), Spring Tool Suite 4 (Java back-end), and MySQL Workbench (database). The web interface was built using HTML, JavaScript, and Bootstrap. The developed version was installed at the Flow Cytometry Laboratory/Unesp/Botucatu and made available on a limited basis to the laboratory staff for the Alpha Test. From January to August 2026, all consumables and immunophenotyping tests performed were recorded simultaneously in the software and in a customized spreadsheet (manual system). Subsequently, the performance of the two tools was compared, taking into account criteria such as speed, practicality, and efficiency (Alpha test). Results: The manual method developed was structured into two main modules: “Resource Management” responsible for recording supplies, and “Clinical Data”, designed to record patient samples. Among the observed advantages are that it is free of charge and semi-automated, since material consumption is automatically deducted through formulas linked between the modules. However, significant limitations were identified, such as the increased need for operator attention, which carries a risk of human error due to data entry mistakes, along with the absence of automatic alerts for expiration dates and low inventory levels on a single screen. Similar to the manual method, the developed software allows for the individual registration of supplies and their subsequent combination for recording tests, in addition to automatically linking samples to the supplies used, thereby directly writing them off from inventory. However, it offers additional advantages, such as the recording of test panels administered to each patient, the inclusion of supplementary information, and the provision of a transaction log associated with users, ensuring greater traceability and security. Discussion: Although spreadsheets offer flexibility in editing data and formulas, they have weaknesses when it comes to compliance with standards such as the LGPD and ISO 15189. In the context of laboratory quality control, reagent stability is critical; therefore, software capable of displaying expiration alerts right on the home screen represents a significant advancement. In addition, security mechanisms, such as operation logs and automatic consumption reports, make the system an indispensable resource for reliable process management. Conclusion: The automated software demonstrated superior performance compared to the manual method by optimizing consumables management, reducing the risk of human error, and enhancing process safety and traceability. However, its use requires prolonged evaluation to identify potential operational bugs and limitations in updating consumables.
Related
- The Kefallinia Score: Development and Apparent Performance Assessment of a Flow Cytometry-Based Intraoperative Classification System for Intracranial Tumors
- Flow cytometry-based direct antiglobulin test for suspected feline immune-mediated thrombocytopenia: Assay development and demographic factors associated with direct antiglobulin test positivity
- Progressive implementation of patient blood management and declining transfusion rates in major orthopedic surgery. A single-centre experience
- Focused ethnography protocol for exploring burn pain management practices in clinical settings: methodological considerations and implementation framework.
- Digital, Mobile and Artificial Intelligence‐Supported Interventions for Pressure Injury Prevention and Management: A Systematic Review of Clinical, Workflow and Implementation Outcomes
BibTeX
@article{garcia2026development,
title = {{DEVELOPMENT AND IMPLEMENTATION OF QUALITY MANAGEMENT SOFTWARE FOR FLOW CYTOMETRY LABORATORIES}},
author = {Matheus Alves GARCIA and Phillipe Franklin Coelho MAGALHÃES and Beatriz Furtado PEGATIN and Francielle Ramalho ROCHA and Iman Zuhrah DIAS and Joyce CALIXTO and Miguel Campos REIS and Edson Luiz Pontes PERGER and Aline Marcia Marques BRAZ and Marjorie Assis GOLIM},
journal = {Hematology, Transfusion and Cell Therapy},
year = {2026},
month = oct,
doi = {10.1016/j.htct.2026.108219},
url = {https://doi.org/10.1016/j.htct.2026.108219},
note = {CC BY},
}
RIS
TY - JOUR
TI - DEVELOPMENT AND IMPLEMENTATION OF QUALITY MANAGEMENT SOFTWARE FOR FLOW CYTOMETRY LABORATORIES
AU - Matheus Alves GARCIA
AU - Phillipe Franklin Coelho MAGALHÃES
AU - Beatriz Furtado PEGATIN
AU - Francielle Ramalho ROCHA
AU - Iman Zuhrah DIAS
AU - Joyce CALIXTO
AU - Miguel Campos REIS
AU - Edson Luiz Pontes PERGER
AU - Aline Marcia Marques BRAZ
AU - Marjorie Assis GOLIM
PY - 2026
DA - 2026/10/23
JO - Hematology, Transfusion and Cell Therapy
DO - 10.1016/j.htct.2026.108219
UR - https://doi.org/10.1016/j.htct.2026.108219
AB - Introduction: Managing consumable resources in flow cytometry laboratories poses a complex logistical challenge, given the heterogeneity of reagents in terms of composition, concentration, and stability. This scenario requires rigorous monitoring to minimize waste and ensure the reliability of assays. Conventional management systems lack features that address the specific needs of flow cytometry. Objective: This study aimed to implement a resource management software system for flow cytometry laboratories (automated system) and compare it with a manual system (Excel spreadsheet). Materials and Methods: In partnership with SENAI-Botucatu, we developed software using VS Code (front-end IDE), Spring Tool Suite 4 (Java back-end), and MySQL Workbench (database). The web interface was built using HTML, JavaScript, and Bootstrap. The developed version was installed at the Flow Cytometry Laboratory/Unesp/Botucatu and made available on a limited basis to the laboratory staff for the Alpha Test. From January to August 2026, all consumables and immunophenotyping tests performed were recorded simultaneously in the software and in a customized spreadsheet (manual system). Subsequently, the performance of the two tools was compared, taking into account criteria such as speed, practicality, and efficiency (Alpha test). Results: The manual method developed was structured into two main modules: “Resource Management” responsible for recording supplies, and “Clinical Data”, designed to record patient samples. Among the observed advantages are that it is free of charge and semi-automated, since material consumption is automatically deducted through formulas linked between the modules. However, significant limitations were identified, such as the increased need for operator attention, which carries a risk of human error due to data entry mistakes, along with the absence of automatic alerts for expiration dates and low inventory levels on a single screen. Similar to the manual method, the developed software allows for the individual registration of supplies and their subsequent combination for recording tests, in addition to automatically linking samples to the supplies used, thereby directly writing them off from inventory. However, it offers additional advantages, such as the recording of test panels administered to each patient, the inclusion of supplementary information, and the provision of a transaction log associated with users, ensuring greater traceability and security. Discussion: Although spreadsheets offer flexibility in editing data and formulas, they have weaknesses when it comes to compliance with standards such as the LGPD and ISO 15189. In the context of laboratory quality control, reagent stability is critical; therefore, software capable of displaying expiration alerts right on the home screen represents a significant advancement. In addition, security mechanisms, such as operation logs and automatic consumption reports, make the system an indispensable resource for reliable process management. Conclusion: The automated software demonstrated superior performance compared to the manual method by optimizing consumables management, reducing the risk of human error, and enhancing process safety and traceability. However, its use requires prolonged evaluation to identify potential operational bugs and limitations in updating consumables.
SN - 2531-1379
SN - 2531-1387
ER -