Step-by-Step Instructions:
1 Run Z_TAM_TIMETOFILL_WITH_OFFERDT query
2 Delete the first line and add the filter to all columns
3 Sort information by the "Post Date" column.
4 Eliminate all rows with that fall outside of your effective dates
5 Add new column between at the end of all columns
Title it , "Days to Offer"
6 Enter the following equation to the cell below the new heading to calculate how
many days to offer: =NETWORKDAYS(C2,T2)
7 Copy the equation all the way down to the last cell with an active row
8 At the end of the "Days to offer column" skip a line and type,
"Average Days to Offer"
9 Skip over 1 box and select the formula to average all of the numbers in the
"Days to Offer" column
10 The answer is the average days to offer for that month.
11 All reports are saved in the Staffing Services (AS141) Shared folder labeled
"Performance Measures" Select the Performance Measure Folder ( Time to Offer)
Select or Create a folder for current fiscal year. For example, "FY 2016 , FY 2015, FY 2014, etc."
Save the spreadsheet in the fiscal year folder
(Staffing_Services (AS141) folder -> Perfomance Measures -> "Select Fiscal Year Needed" ->
Select Performance Measure Folder (Time to Offer);
-> Select Quarter (FY 2016 - Qrt. 1))
12 ∙Overall Target (NA)
∙High Variance (FY Target): = 75 days
∙Low Variance = 90 days
(Total # of days to fill positions this quarter/ # of positions to be filled)