ÓÐÁϺÐ×ÓÊÓƵ

Once you are granted access to the Google drive folder

1. Open your Google drive by clicking the Drive icon in your Google apps menu
2. Click on "Shared with me" in the left-hand menu
3. Find and double-click on the "Reports" folder to access the ActivePCN and Position Vacancy reports or the "Labor Budget to Expend" folder to access labor reports
   1. Double-click the "Labor Budget" folder to access folders for both current and prior fiscal year reports
   2. Double-click a fiscal year folder to view the reports
4. Locate and double-click on the file you need
   1. The file opens as a "view only"
   2. Click the download icon in the top-right corner
   3. Select the desired download option
5. You can also use the table below to directly access individual reports
   1. Clicking any link opens the report in Google as "view only"
   2. Follow the instructions under step 4 to download the report

Downloadable PDF Guide

1. Open the report in Excel
2. Select the table to activate the "PivotTable Tools"
3. Click "Field List" under the "Options" tab
4. On the Field List, select and drag the "DOC REF" field down to the Row Labels box and place it right above the "POSITION" field
5. Since this creates a PCN field that groups staff benefits by employee, you no longer need the original "POSITION" field and can uncheck it in the Field List
6. If you would prefer to arrange the information with the Staff Benefits category at the bottom of each employee section
   1. Click the outside edge of an "Staff Benefits" cell
   2. Drag the cell so it falls underneath the employee's name (make sure the cursor changes to the crosshairs icon before clicking and dragging)
   3. You can also right-click on the Fund Type subtotal and uncheck "Subtotal 'FUND TYPE'" if it aids in easier data interpretation

Play around with the pivot table to display the data in ways that work best for you. You can always revert back to the version uploaded on our website, so do not be afraid to explore all the options!

For example, some may prefer to view the data at a different org level. The table default is set up to allow choices at Level 4. However, the Field List provides Levels 4-6 as options. If you would like to filter based on Level 5, drag that field down to the Report Filter box. Tada, now you can filter at either level or both!

Downloadable PDF Guide