1 / 43

The installation process is started by double-clicking on the USB-Key file ‘install.xls’

The installation process is started by double-clicking on the USB-Key file ‘install.xls’. Select the required language. The default directory is c:bks. Installation is completed in a few seconds. The Excel version is detected after installation. Conversion to

marika
Download Presentation

The installation process is started by double-clicking on the USB-Key file ‘install.xls’

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The installation process is started by double-clicking on the USB-Key file ‘install.xls’

  2. Select the required language

  3. The default directory is c:\bks

  4. Installation is completed in a few seconds

  5. The Excel version is detected after installation. Conversion to ‘.xlsm’ format is requested for Excel 2007 versions and higher.

  6. … changes to ‘.xlsm’ after conversion. The Excel file type indicated in cell P1 …

  7. If macros are not set correctly,a redwarning message is displayed. Consult the Application Software User Manual for instructions. A yellow background is displayed when macros are correctly set

  8. ‘Active Period’ is set by clicking on either date. These dates control the range of Time Sheet information to be viewed or printed.

  9. The ‘Active Period’ does not change until set again by the user

  10. To add an Employee, select ‘New Employee’ … … enter Employee details and click Go!

  11. The New Employee form remains on-screen. To add another, enter details and click Go!

  12. The ‘Employee List’ when 10 staff members have been registered.

  13. ‘Extend Calendars’ will be requested if the current date is newer than the last ‘Extend Calendars’ occurrence.

  14. The ‘Employee List’ also displays the Language, Excel version, Excel Time Sheet format, and the Application Version number.

  15. Six tabs at the foot of the workbook give access to other functions

  16. The ‘Control Panel’ keys select the primary functions

  17. An Employee Time Sheet has been selected with ‘Show Time Sheet’. Weekend dates are shown with a blue highlight.

  18. A right mouse click on any title cell in Row 7 allows unused columns to be hidden, eg ‘Show’Start/Stop 5’.

  19. Missing ‘time stamps’ can be added by a right mouse click on a blank cell. The action is completed with the keyboard ‘Enter’ key.

  20. Time Stamp addition or modification is indicated in bold … … and an Audit Trail is created in the Date cell.

  21. ‘After-midnight’ hours are recorded on the day after the last clock-in and cause two calculation errors in red … By selecting ‘Midnight X-Over’, the first Time Stamp of the next day is moved to the previous day, and the errors disappear. With a right mouse click on the first blank cell of the first work day, the ‘Add or Modify Time Stamps’ menu appears

  22. Absences are recorded in columns N-Q by a right mouse click on the date for ‘Absence 1’ or ‘Absence 2’ (column N or P)

  23. Enter value for ‘Duration in Hours’ - press keyboard ‘Enter’ key - then chose a code in ‘Select a Reason’ from the drop down menu …

  24. Click on ‘Apply to ALL employees’ and … … select Yes or No. Note: ABSENCE Duration value is added to ‘Net Hours’.

  25. Absence duration is added to Hours Clocked, with result in Net Hours. Totals-A at the bottom shows all Absences in the Active Period

  26. ‘Corrections’ are made in columns R-S with a right mouse click on a cell in column R. This column does not change ‘Net Hours’.

  27. This function is for recording hours that do not change Time Sheet results. Note: ‘Correction’ values do not effect Net Hours value.

  28. ‘New Records’ holds Time Stamps that cannot be imported into Time Sheets for various reasons . . .

  29. ‘Unknown Badge’ means an ID-Badge has been used for clocking-in and clocking–out, but the Badge has not been registered to an Employee.

  30. ‘Search Errors’ allows several conditions to be reported, such as Missing Time Stamps & Absent without Reason

  31. Chose the required parameters and select Go!

  32. ‘Absent without Reason’ report

  33. The ‘Search Errors’ report is saved in ‘Clocking Errors’ until requested again

  34. ‘Show Summary’ generates a report for all Employees for the dates displayed in the Control Panel

  35. which can be exported to an external Excel file with a click on line 3 ‘Summary’ report provides a single line overview per Employee

  36. Several ‘Correction Codes’ are initially provided

  37. Codes can be added, or deleted, as required.

  38. ‘Print Time Sheets’ report can be generated whenever required for the dates set in the Active Period

  39. Right click on centre of display and select one, or more, Employees

  40. Select Go! and the Time Sheets report will be created

  41. To copy the report into an external Excel file right mouse click on the screen and select Export

More Related