Utilisation Reporting
Upon selecting one of the reports you will see the following screen.
https://knowledge.stevemildner.com /wp-content/uploads/2010/09/b_templatedates.zoom75.jpg” width=”488″ height=”179″ border=”0″ alt=”B_TemplateDates” style=”margin:0 auto;margin:0px;”/>
Enter the Start and End dates for the range you wish to view a report for. The data will then be transferred to Microsoft Excel, as shown in the examples below.
The data will be arranged into a PivotTable which will allow you to customise the report. It will show you as a percentage, what the utilisation was for the Resources or for the Events which have taken place throughout the date range. These are spoilt by hours of the day.
https://knowledge.stevemildner.com /wp-content/uploads/2010/09/b_utilevt.zoom50.jpg” width=”547″ height=”450″ border=”0″ alt=”B_UtilEvt” style=”margin:0 auto;margin:0px;”/>
https://knowledge.stevemildner.com /wp-content/uploads/2010/09/b_utilres.zoom50.jpg” width=”650″ height=”450″ border=”0″ alt=”B_UtilRes” style=”margin:0 auto;margin:0px;”/>
In addition there is also a second tab at the bottom of the Excel Workbook, labelled Utilisation Chart. This will allow you to see the results of your data as a chart instead of raw data. An example is shown below.
https://knowledge.stevemildner.com /wp-content/uploads/2010/09/b_utilchart.zoom50.jpg” width=”650″ height=”450″ border=”0″ alt=”B_UtilChart” style=”margin:0 auto;margin:0px;”/>