Computerization of plateletpheresis quality control records with a commercially available spreadsheet program.

Many apheresis units lack the resources to acquire customized computer software for record keeping. We have adapted a commercially available "spreadsheet" program (Lotus 1-2-3) to aid in quality control activities for plateletpheresis. Data are entered in a grid pattern wherein each donation occupies one row and successive columns contain numerical data derived from the donation. The last two columns contain formulas that calculate yield and collection efficiency from values entered in preceding columns. The program runs on an IBM PC or equivalent with 512 K RAM; the combined cost of a computer and software is currently under $2,000.00. Data entry requires fewer keystrokes per record than computation of yield and efficiency with a calculator, and creates an inclusive permanent record for future analysis. Data sorting and statistical functions allow rapid identification of incomplete records, and derivation of average platelet yield and/or collection efficiency for any time period of interest. The program also facilitates determining the proportion of donations that fall below any chosen cutoff. Performance characteristics of a particular instrument or operator can be assessed easily by isolating the pertinent records and analyzing them separately. The system will thus accomplish a variety of quality control activities, including those mandated by licensing agencies. It can be implemented by apheresis personnel with limited "computer literacy" and is superior to manual tabulation of quality control data in both ease of data entry and facility of analysis.