Japan Journal of Medical Informatics
Online ISSN : 2188-8469
Print ISSN : 0289-8055
ISSN-L : 0289-8055
Proceeding of the Spring Meeting on Medical Informatics
Reagent Management System Utilizing GS1 Code and Excel VBA―Improve Accuracy of Records and Promote Operational Efficiency―
T Inoue J SakaneY MorisatoE MatsushimaT IwasakiK OnodaC WakudaM KamizonoH Kawamura
Author information
JOURNAL FREE ACCESS

2025 Volume 45 Issue 2 Pages 93-98

Details
Abstract

 Clinical Laboratory analyzes the specimens derived from patients and provides the laboratory data to patients and medical staffs. ISO 15189 assures the quality of the clinical laboratory. The Management Quality is regarded as an important factor as well as the Quality of the tests in ISO 15189.

 The reagent management is important as the laboratory management. It requires many records as lot numbers, expiration dates, good receipt records, use start records, use termination records and so on. To write records by hands increases is very troublesome and can cause the mistakes easily. It must be replaced to the labor-saving, improved paperless, efficient and sophisticated operation.

 We developed the method for the reagent management by using Visual Basic for Application (VBA) loaded standardly on Microsoft Excel and the GS1 code, which is employed to identify many goods and services for traceability. It realized the accuracy of records and the decrease of our troublesome works.

Content from these authors
© 2025 Japan Association for Medical Informatics
Previous article Next article
feedback
Top