#142-Automated Attendance Sheet in Google Spreadsheet (2021)

Automated Attendance Sheet in Google Spreadsheet (2021)

Are you looking for a attendance sheet which you can operate in cloud and share with your co-worker? So here it is.

This attendance sheet is created in google sheet and you can keep record your employees attendance in this sheet very easily and once you create it, you can continue to use it for years.

Description:

It has two sheets. First is Settings Sheet & another is Master Attendance Sheet.

So how does Settings Sheet work?

In the Settings Sheet, we have Month List, Weekend List and the last one is Holiday List.

Month List: You can keep you Month List in any order you wish but only 12 months as we have. The list is fixed. This list will be used when you select month in the attendance sheet and based on the selected month dates, day names every thing will be generated.

Weekend List: You can keep one or more than one weekend as of your wish because this list is dynamic. Based on this list weekend column in attendance sheet will be highlighted.

Holiday List: This list is also dynamic so you can enter as many holiday as you want. So when you enter a new holiday, that date date will be highlighted in the attendance sheet as holiday.

So, in the Setting sheet you can do your basic settings for your attendance sheet.

So how does Settings Sheet work?

First of all You can do two things i.e. type your Company Name at the top and then insert a Logo the top left corner of the sheet.

Then type the Employee Id & Employee Name under Employee ID & Employee Name column. Then your Master Attendance Sheet is ready. You have to copy this sheet for attendance for any month for example April 2021.

Now Right-Click on the sheet and select Duplicate. A Duplicate sheet is created.

Then Right-Click on the sheet and select Rename and type month name & Year for example April 2021. So attendance sheet of April 2021 is ready to do attendance.

Now select month name  fro the month list and  year from the year list. After selecting this change you can see the difference the day name in row 10 has changed, weekend columns and holiday column are also changed automatically.

 Now in this sheet we can make use of two buttons, one is Clear Cells and another is Check Days. Clear Cells button is to clear the attendance area where we put the attendance legends and Check Days is to generate weekend names is weekend columns and HL in holidays column.

To clear the attendance area just click the Clear Cells button, then total area will be automatically cleared.

To populate the weekend day names in weekend column and HL in holiday column, select the last cell upto which you want populate and click on Check Days button. Everything will be populated automatically.

Now its time to put the attendance legends for employees. I have created a data validation so that you can only put P as Present, A as Absent, H as Half-Day, AL as Annual Leave and SL as Sick Leave. You cannot put any other legends. 

So as start inserting the attendance legends, you can see some changes in the Report area. In the Report area total 8 headings as Total Holidays, Total Weekends, Total Workdays, Total Present, Total Absent, Total Annual Leave, Total Sick Leave, Total Payable.

In the Report part we have all the formulas to calculate the reports.

So in this way you can use this template and do your attendance of your employees for several years.

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Premium

Project File Type: Rs.800/-

************************************************************************************************