Smith S L, Lubiejewski T, Farnum J
Pharmacy Department, Saint Vincent Health Center, Erie, PA 16544.
Am J Hosp Pharm. 1990 Nov;47(11):2488-92.
The development of spreadsheets and automated instructions for transfer of drug-use data from a hospital's mainframe computer to the pharmacy department computer is described. Drug-use data are down-loaded from the mainframe as an ASCII file on a floppy disk. Instructions within the spreadsheet ("macros") are used to import the data into the first spreadsheet, arrange the data to be compatible with the database portion of the spreadsheet, and transfer the data to another spreadsheet where drug use and cost are calculated and placed in the column for the appropriate month. A series of formulas are used to arrange the imported data to account for items that have not been used. By eliminating the need for manual data input into the spreadsheets, the macros and associated formulas saved pharmacists substantial time.
本文描述了电子表格的开发以及将医院主机计算机中的用药数据传输到药房计算机的自动指令。用药数据作为ASCII文件从主机下载到软盘上。电子表格中的指令（“宏”）用于将数据导入第一个电子表格，整理数据使其与电子表格的数据库部分兼容，并将数据传输到另一个电子表格，在该表格中计算用药情况和费用，并填入相应月份的列中。使用一系列公式来整理导入的数据，以处理未使用的项目。通过消除手动输入电子表格数据的需求，宏和相关公式为药剂师节省了大量时间。
