Customized data tool
- Download the Customized Excel™ Data Tool
(This January 2007 update replaces the March 30, 2006 version.)
Please note:
- The revised version has the ability to calculate the percentage of respondents in your organization that had written comments.
- Microsoft Excel 2002 or higher is required to use this tool.
- This tool uses Excel macros. Before opening the file, be sure to set Excel's macro security level to "medium." From Excel's menu (without the file open) select Tools > Macro > Security. On the "security level" tab click "medium." Then open the tool and enable macros when prompted.
Premier developed this customized Excel™ data tool for easy entry and rapid display of the results from the surveys to provide immediate internal review and feedback. The tool is particularly useful for small hospitals or healthcare facilities.
Uses of the tool
This tool makes it very easy to:
- Input your raw data.
- Create graphs and tables to display your survey results by demographics and in the aggregate.
- Analyze which safety culture dimensions may need additional attention or further analysis to focus on specific work areas, units or professions.
- Share the results electronically with others in your organization.
- Benchmark your results. This tool will capture the data in a format that will allow for comparisons when benchmarking data are available from AHRQ. Note: the survey will need to remain in its original form to allow for accurate comparisons.
Copying data from previous to the updated version
of the Excel tool
If you have data stored in a previous version of the Excel tool, you may copy that data into the new January 2007 version by doing the following:
- Open both the previous version and revised January 2007 version of the Excel tool.
- In the previous version, click on the "Data Entry" tab, where you have data stored.
- Go to cell A12 and highlight the entire section where data are entered.
- Right click over the highlighted section and select "Copy."
- In the revised January 2007 tool, click on the "Data Entry" tab.
- Go to cell A12 and right click on your mouse and select "Paste."
- Your data has been copied from the old Excel tool into the new, revised tool.
- Save your file.
Premier wishes to thank Westat for their assistance with development, review, testing and revisions of the tool and Indian River Memorial Hospital, Vero Beach, Florida for their critique and enhancements made to the tool.
Download the tool
Important tips:
- For the file to work properly, save it to your computer first (do not open directly from web site), then when opening choose "Enable macros."
- You must at least have Microsoft Excel 2002 or higher to use this tool.
- This tool uses Excel macros. Before opening the file, be sure to set Excel's macro security level to "medium." From Excel's menu (without the file open) select Tools > Macro > Security. On the "security level" tab click "medium." Then open the tool and enable macros when prompted.
Customized Excel™ Data Tool,
January 2007 (.xls) (4.1 MB)
This January 2007 update replaces the March 30, 2006 version
Premier is unable to provide technical
support for the use of this tool. If you have any comments or suggestions for
enhancements of this tool, please send an email to
safety_culture@premierinc.com.
Alternate download:
Customized Excel™ Data Tool,
Janaury 2007 - compressed (.zip) (770 KB)
This January 2007 update replaces the March 30, 2006 version
Requires WinZip® program.