Excel function on the application of HPLC method for the determination to solve computational problems pharmaceutical content.docVIP

 PAGE \* MERGEFORMAT 6 Excel function on the application of HPLC method for the determination to solve computational problems pharmaceutical content [Abstract] Objective: Using Excel functions simplify the HPLC determination of content of the calculation of drugs. METHODS: Using Excel’s function calculations, enter the formula in the table and save the worksheet, the data input to be processed each time the cell, The results can be automatically calculated. Conclusion: complex calculations can be simplified to make quick and accurate data processing, not only improve the work efficiency, but also to avoid the manual calculation of the possible errors. [Keywords:] Excel; function; calculation; Drug content; HPLC Inspection of drugs widely used among high-performance liquid chromatography Drug content determination of each batch of samples to be drawn during the 2 copies of reference standards, each reference standard sample 2; take two copies of the test to level experiments, each the test solution were also sample 2, measured by peak area calculation pharmaceutical content. the results to be obtained when calculating the concentration of control solution and the control of the peak area ratio (f), and find the four f values #8203;#8203;rsd, requires no more than 2.0% of its rsd, then calculate the content of the sample into the 4-pin, find the average drug content of the report. This series of calculations more cumbersome, the workload is relatively large. In practice, I use Excel functions computing to solve this problem, according to the functions in Excel format, enter the relevant formula, give the formula of the variable assignment, the corresponding results can be obtained, so that the calculation becomes simple and convenient, greatly reducing the computational workload, save time, improve efficiency. The following Determination of cefepime hydrochloride for injection levels, for example, to illustrate how to use Excel formulas to solve the prob