Attendance system


I want the attendance system created, to sort the data in a form from which: Identifiers such as Job ID and name is used as identifier. Then, from the data, sorted and entered in a form or table, there shall be column for sign on/ sign off. From that, the hours worked can be stated and if less than the set shift hours, then the person is marked as late and the hours late are accumulated in the column for deduction.  If 24 hours passes without a registered ID registering time, then they shall be marked as absent. Thus the absent days are also accumulated in the attendance system. If someone works two shifts the same day, then they are entered in a form for overtime, with date and location set as well. Maybe this will be a good guide.
1.       From the unsorted data, filter and import data
2.       Create columns for ID, Name, Date, sign on, sign off time, longitude/latitude.
3.       From the created table, then sort the data based on:
a.       If sign the difference between sign off and sign on time for the same day is less than 12 hours, then, record in a column for lateness in hours.
b. If a registered ID and name misses time for a whole day, over 24 hours, record under absent.
c.    If someone clocks and works at intervals of 12 hours twice in a day, record as overtime.
d. At the end of the sheet, there shall be columns for the total number of days absent, late, which shall be recorded under deductions column.
 d.  Develop a chart showing, lateness, absent overtime.

Sample output of the sorted data table
Job ID
Name
Date
Time sign on
Sign off
Lateness
( min)
Overtime HOURS
Total monthly overtime in days
12341
John Doe
16/12/2016
 06:34:05 AM
18:32:05 pm
1
0
 2
1233
Rose Mary
16/12/2016
 07:34:05 AM
17:32:05 pm
2
0
 -4
1233
Mc Steve
16/12/2016
 07:34:05 AM
17:32:05 pm
1
0
 1

At the end of every month, the accumulated lateness hours is added and converted to days. So if someone has been late for 30 minutes every day for 8 days, then, the last column shall have the total monthly deduction or overtime recorded.  

Comments

Post a Comment

Popular posts from this blog

choosing scheduling software for construction companies

Image
A guide on choosing scheduling software for construction companies Scheduling software for construction companies that are advertised require proper critique before subscribing and making payments. There are many versions available for labor planning. A search on google will give contractors many web-based Apps as well as mobile phone based Apps. These scheduling software have different capabilities, which some are generalized and others are specialized for construction company’s laborers. These facts arouse a series of questions that affect not only the cost but also the outcome of the system. Notably, the use of App in construction company’s sites has various restrictions. These restrictions vary from the nature of the site, workforce education, and size of the project, stage of the project as well as the distance of the site from the planning office. These are the critical factors that one must consider to select construction companies’ staff scheduling App that will serve t
Read more

staff management system

Staff management system features 1.        Creation of unique identifier for companies, such that for a company A, the data received from a timesheet files is specifically interpreted and combined for the given company only. 2.        Under a given company, there should be a capability to create stations/ posts, where the dat. Files fetched from the given folders in a staff management system shall be matched to give information for the given post. 3.        The users at a given post, shall be created and assigned different roles, which include employee, supervisor, field officer, regional coordinator, and management. Here, there shall be job groups, which have to correspond to the given roles. 4.        Move users from one post to another. 5.        Show duplicated users, such that if a user appears in two stations at the same payment period, the system can tell. 6.        The user list should be imported directly from the company payroll in excel format, then matched
Read more
Image
1.     Proposed Timesheet Application a.       About Timesheet application The Employer is expected to host events, which may either include the pitch and the specialized zones. As such, there is a need to install staff management cameras at strategic places, to monitor the whole Employer, with a complete field of view to all areas. The staff management system shall consist of: b.       Online Employee Timesheet applications There shall be two types of cameras, which include the grid powered, IP cameras, which shall provide staff management of the main areas and the entrance. This is the points that shall experience high density of people, during major events such as football matches. These cameras shall have a 360 0 field of view, i.                    Main entrance, exit, and highly efficient employee timesheet application c.      Solar powered Timesheet applications There shall be cameras set to record the daily events of the Employer, regardless of the oc
Read more