运用Excel函数解决HPLC法测定药品含量的计算问题

Using Excel Functions to Solve the Calculation of Drug Content which Determined by HPLC

目的:运用Excel函数简化HPLC法测定药品含量的计算问题。方法:利用Excel的函数计算功能,在表格中输入公式并保存工作表,将每次要处理的数据输入相应的单元格,即可自动求出计算结果。结论:可以把复杂的计算简单化,使数据处理既迅速又准确,不仅提高了工作效率,还可避免人工计算可能带来的差错。

Objective： Using Excel functions to simplify the calculation of Drug Content which determined by HPLC.Methods： Enter the formula in the table and save the worksheet.The computer can automatically calculate the results by excel functions when entry for each corresponding cell.Conclusions： It can simplify the complicated calculation to make quick and accurate data processing not only improves the working efficiency,but also to avoid possible errors.