Today many small companies and start-ups are manually calculating the total number of leaves taken by their employees at the end of the month. This requires a lot of time and manual effort and is completely inefficient. It is a big problem for any Start-up companies especially when they cannot afford expensive attendance systems or special HR departments.
Let me propose a solution which will surely help you solve this problem to a great extent. I will say, it is not a completely full proof solution but will definitely help you save a lot of trouble.
I have created a Google Sheet workbook that will manage all this in a very easy and simple way. All you need to access and use my system extensively is a Gmail/Gsuite account.
Before you start, view my demo of the software made on Google App Scripts and basic functions made on VLookup
Replicate this Google Sheet by subscribing to our mailing list. A link will automatically be sent to you after verification. There is no ad/double click.
You will find 4 tabs in this sheet, each of them is linked with each other. Do not delete any tabs might make the software stop working.
- Leave
- Employees
- Leave
- Lookups
There is a google app script already saved in an excel sheet of which the copy you just made. I’ll pass the updates and bug fixes as soon as I make any changes to the script.
Stay subscribed to get all the latest updates on the scripts and all the latest updates.
Well Framed!
Thankyou Priya I am glad you liked it.
Very well and helpful
Thanks a lot.
Thankyou for the amazing work I have downloaded the sheet for our organisation to calulate the leaves, let me know how can i connect you for any help or any other customisation needed for such sheets in our startup.
I am glad you liked my work.
You can drop an email on itedvantage@gmail.com or send me Whatsapp using this link: http://bit.ly/WhatsappITEdvantage