用电子表格Excel计算药物的有效期

Calculation of the Expiry Date of Pharmaceuticals by Microsoft Excel

[目的 ]计算药物的有效期。 [方法 ]运用电子表格 Excel软件处理药物稳定性试验数据。 [结果 ]计算结果与文献一致。[结论 ]与图解法相比 ,该方法快速 ,简便 ,并可避免由于观察读取图上刻度所致的误差 ,能精确地算出有效期。

To calculate the expiry date of pharmaceuticals. The data of experiment were treated with microsoft excel. The calculation by Microsoft Excel corresponds to that of literature. [CONCLUSION] Compared with graphic method, this calculting method is faster and more convenient. It avoids errors due to reading on graphs, and can calculate expiry date precisely.