RESUMEN
OBJECTIVE:To establish a fast,accurate,programmed and automatic mode for the statistical analysis of drug in-formation data so as to achieve the compatibility and the switching among multiple forms and the sharing of data information. METHODS:Common Excel commands and functions as well as their use methods were introduced and analyzed combined with drug information statistics cases. RESULTS & CONCLUSIONS:By taking steps such as exporting raw data,designing drug infor-mation sheets and summarizing drug raw data with the pivot table,the data of the drugs purchased by the hospital in a manner of centralized bidding and national essential drugs purchased can be calculated on the basis of different periods of time to fast and accu-rately search for drug data,facilitate data induction and processing and shorten statistics cycle. The above-mentioned steps are well applicable,easy to master,efficient and fast,reliable in the check of results and data,and suitable for the statistics for hospital drug information and other fields.
RESUMEN
Objective: Statistical work overtime hospital surgical performance, understand the overtime rate in all the subjects, facilitating leaders make decisions in time, reasonable allocate resources to plan as a whole. Methods:using the time function and the automatic calculation logic function, and finally use pivot table function. Results:Reflect the medical surgery, overtime data provide a reference for the head nurse in nursing management. Statistical results show that the gynecology and obstetrics, orthopaedics, thoracic surgery, secrete surgery, general surgery frequency more overtime. Facilitate the matron reasonable flexible scheduling, optimize work processes;at the same time make the nurse work enthusiasm by passive status to active status, avoid buck-passing, realize the labor remuneration is closely related to job performance. Conclusion:Inspire staff enthusiasm, to strengthen the medical management has a guiding role.