Related Experiment Video
Updated: Oct 1, 2026

Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation
Published on: November 9, 2013
Distributive and clinical activity measurement using spreadsheet software
1John Dempsy Hospital, Farmington, CT 06032.
Abstract:
Documentation of distributive and clinical activities is an important factor in maintaining and expanding pharmacy services. In order to illustrate the impact of pharmacists' efforts on risk management and the reduction of drug costs, the pharmacy must effectively monitor workload. This report describes a method to identify and estimate time required for both distributive and clinical functions. Tabulation of the distributive work units is automated through the hospital billing system. Clinical monitors are dependent on manual documentation by decentralized clinical pharmacists. The clinical coordinator and the pharmacy director review the documented clinical monitors to insure compliance and standardization. Productivity and workload calculations are performed automatically via the spreadsheet software once all the distributive and clinical units are entered. Identifying clinical functions and measuring the associated workload has aided in justifying new positions. Future considerations include calculating the impact of clinical services on revenues, expenses, and staffing.
More Related Videos
Related Concept Videos
Statistical Software for Data Analysis and Clinical Trials
Overview of Microsoft Excel as a Data Analysis Tool
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Statistical Analysis System (SAS)
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...
Microsoft Excel: Plotting Mean, SD, and SE
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...

