OBJECTIVE:To explore the intelligent management of drugs within expiry dates.METHODS:Table of drug categories was established;those categories near expiry date were screened out automatically through the paste function of Excel.RESULTS:Expiry dates of all drugs were seen clearly.CONCLUSION:It is accurate and simple by applying excel in the intelligent management of drugs within expiry dates.

OBJECTIVE:To optimize matrix composition and technique for acne emulsion.METHDOS:Oil phase,emulsifier and emulsify temperature were selected as variable factors using orthogonal design method,and table L 9 (3 4 )was used for the experiment.RESULTS:The optimum matrix composition and technique were stearic acid of15g,liquid paraffin of13g,vaseline of20g,trietha nolamine of3g,emulsifying temperature of85℃.CONCLUSIONS:The acne emulsion prepared by this kind of composition and technique accord with the stipulation of Chinese Pharmacopoeia.