Related Experiment Videos
Computerization of plateletpheresis quality control records with a commercially available spreadsheet program.
B C McLeod1, A Viernes, S Reed
1Rush-Presbyterian-St. Luke's Medical Center, Chicago, Illinois 60612.
Journal of Clinical Apheresis
|January 1, 1990
Summary
Apheresis centers can use affordable spreadsheet software for quality control. This system simplifies data entry and analysis for platelet collection efficiency and yield, improving record-keeping.
Area of Science:
- Medical Technology
- Biotechnology
- Health Informatics
Background:
- Apheresis centers often face resource limitations for specialized record-keeping software.
- Customized software solutions can be prohibitively expensive for many facilities.
Purpose of the Study:
- To adapt a widely available spreadsheet program for quality control in plateletpheresis.
- To provide an accessible and cost-effective solution for apheresis record management.
Main Methods:
- Utilized Lotus 1-2-3 spreadsheet software on an IBM PC compatible system.
- Designed data entry in a row-column format, incorporating formulas for yield and collection efficiency calculations.
- Leveraged built-in sorting and statistical functions for data analysis.
Main Results:
- The adapted spreadsheet system requires fewer keystrokes than manual calculation, creating a permanent data record.
- Facilitates rapid identification of incomplete records and calculation of average platelet yield and collection efficiency.
- Enables assessment of instrument or operator performance and adherence to quality standards.
Conclusions:
- The spreadsheet-based system offers a practical and economical approach to apheresis quality control.
- It enhances ease of data entry and analysis compared to manual methods.
- Suitable for apheresis personnel with limited computer expertise, meeting regulatory requirements.