As part of space management and policy enforcement, usage data from the electronic locks is gathered and analyzed. After the Electronic Locks Coordinator has Gathering Lock Audit Data Gathered lock audit data, you will take the data and extract it to create a Pivot Table using Microsoft Excel. How to do this is outlined below.
...
- Open a new Microsoft Excel sheet
- Click on the “Data” tab
- Select “New Query” then “From File” and “From Folder”. (Note: This image does not reflect the current file path.)
- Click Browse.
- Select This PC < Shared Network Space LEAD < Shared <Library Space<Shared<Library Spaces Planning & Mgmt< Rooms < Mgmt<Rooms< Research Room Audits < Audits< XXXX Audit Data< Most Recent file
- Click OK, then OK again.
- Another box will appear – just click Load at the bottom.
...