Spreadsheet: 114739d1310470749-chart-data-range-graph-help
Sheet: Example

 |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3
 |  |  |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar |  | Average |  | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 |  | [NAME]
HR | 1 | Direct FTE's at the end of the month (1) | Keyed Value | 50 | 20 | 50 |  |  |  |  |  |  |  |  |  |  | 40 | 1 | 50 | 20 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 40
 | 654 | Overhead FTE's at the end of the month (654) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 182 | Temps over 30 days – direct (182) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 183 | Temps over 30 days – overhead (183) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 655 | Total Headcount at the end of the month (655) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 186 | Number of new starters (186) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 727 | Number of Leavers (727) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 51 | Working days in month (51) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 2 | Total number of manhours worked in the month (include everyone) (2) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 184 | Total overtime hours (184) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 7 | Number of days lost (short term) due to unplanned absences (not work related) (7) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 8 | Number of days lost (long term) due to unplanned absences (not work related) (8) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 6 | Number of days lost (work related) (6) | Keyed Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 53 | Working days (YTD) (53) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 67 | Total manhours rolling 12 months (67) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 77 | Total days lost in month. (77) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 78 | Absenteeism for month (78) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 79 | Absenteeism rolling 12 months (79) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 164 | Total hours lost (164) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 165 | Total available hours (165) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 185 | Overtime hours as a % of total hours (185) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 228 | Long term absence (228) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 229 | Short term absence (229) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 241 | Work related absence (241) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 690 | BUDGET Direct FTE's at the end of the month (690) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 691 | BUDGET Overhead FTE's at the end of the month (691) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 692 | BUDGET Temps over 30 days – direct (692) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 693 | BUDGET Temps over 30 days – overhead (693) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 694 | BUDGET Total Headcount at the end of the month (694) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 695 | [NAME] hours as a % of total hours (695) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 696 | BUDGET Lost Work Day Rate (696) | Budget Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 733 | Employee Turnover % (month) (733) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A
 | 734 | Employee Turnover (YTD) (734) | Calculated Value |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | #N/A