The sample spreadsheet templates in this database provide tools to calculate and compile HR metrics and various types of HR and other business reports. These templates use a standard spreadsheet program. They are downloadable and executable files with basic formulas included. Although these are copyrighted, SHRM members may freely use these templates to create or change their own spreadsheets.
These forms are interactive with Excel. For information on how to export to Excel and to acquaint you with or refresh your knowledge of Excel basics, click here.
For a full discussion of metrics and measurement of HR, see SHRM’s book, Proving the Value of HR: How and Why to Measure ROI. The book teaches how to calculate return on investment in a step-by-step, logical way and explains how to use ROI as a tool to strengthen the relationship with senior management and to improve HR's contribution. Click here and then scroll down to learn more or open an excerpt.
Metrics provide a number of factors that can be measured to show how HR contributes to the business. Measures such as absence rate, health cost per employee, and HR expense factors show that HR has a sense of the importance of human capital measurement in supporting business objectives. Please check back in early March, 2009 for a complete listing of interactive metrics calculators.