Personnel: By SCO and Ethnic Group_m10dis_date.xlsx


Management Report:


Personnel Information

Personnel: Click on:
By SCO and Ethnic Group

Example of m10dis

Example of ...Personell


Faculty The user can select a FACULTY from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update SHEET 1.
Permanent or Temporary Staff The user can select a PERMANENT or TEMPORARY from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update SHEET 1.
Ethnic Group The user can select a ETHNIC GROUP from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update SHEET 1.
Gender The user can select a GENDER from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update SHEET 1.
Occupation The user can select a OCCUPATION from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update SHEET 1.


Graph


The Summary List The summary list is a list that is updated each time the user alters or selects a different entity on the Dashboard.
Personnel by Occupation and Ethnic Group The Totals of all Personnel by Occupation and ethnic Groups
Grant Total Grand Total of ethnic Group Occupations.

Example of the List as per filter on Permanent or Temporary.

Listing


Example
of Dashboard selected filters.
Also NOTE that the user can MOVE the Filters around on the Spreadsheet to suit there needs. By clicking on the filter next to the NAME of the filter, when the mouse poointer changes to moving the mousethe user can move the filter around.

Example of ...Explanation of Dashboard


Example of the List as per Default without filters.:

Example of ...Clear the filter


Please Note that if the user decides to Click "OPEN" directly, then the document in question is labled as "doexcel" this document SHOULD_NOT be saved, it can be worked on.
The User will have to click on SAVE and then open the document for actual e.g mis21dis....!

Open and Save



See Also:  Management Reports


History of Changes

Date System Version By Whom Job Description
26-Feb-2015 v03.0.0.0 Charlene van der Schyff t205595 New Online Manual for: Personnel: By SCO and Ethnic Group _m10dis.