As part of space management and policy enforcement, usage data from the electronic locks is gathered and analyzed. If you haven't already done so, begin by Gathering Lock Audit Data. You After the Electronic Locks Coordinator has 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.
...