eSigning Monthly Timesheet Template Made Easy

Signed monthly timesheet template

[Applause] good Divini everybody I mean good morning I'm introducing to you an excel here like an Excel template very good for thankin meeting but very much useful for bigger companies companies that have huge in number of manpower let's say like construction company that have thousands of workers and they have like 20 projects or more going on together it's very those companies which don't use biometric fingerprint repair metric have in the register punching machines in this and this requires that for a company with more than one project each project to have a time keeper with a computer whereby he will be making this time cut from this excel template the usefulness of this template is that on this interface I'll show you how this interface was and which means if a project has like 1000 employees staff and workers you cannot make you can make fun of them timesheets in one place also it doesn't matter how much no more hours they have standard them somehow over time some don't have you can combine all of them here together you don't have to make a separate of staff in the separate for site workers you make all of them here together the only thing you do is to enter a me time out I'll show you I have divided I have labeled this starting from this just in two different colors so very easy for you to understand here is that the only cells you can change what's in the data is the cells the good in blue first one is this templates reading as hit and if you check this another mnemonic you can change from Institute Gregorian I click and something changes here in detention look here you know it's Sunday the green color downwards it's coming to Sunday and if I change here to hit it it goes to Friday you can see now this tells you one day I built this template while working in a Muslim college I work in a Muslim country I have made this time times in the machine to be used in a Muslim country whereby they take Friday as holiday or resting day I will repeat again that this is very important for conception company most construction companies don't work on Fridays or they don't work on that day which is specialized as weekend or holiday for the weekend many workers rest for one day you can give your workers two days which by determining which ever country they are but mostly he engulfed Friday is the weekly so I took here hit Lee when I click Italy here is Friday and if yes is Friday it means Friday here is the arresting day so from there when you want to be there this will help it change which day is the weekend here you can change the month date of the in the month and the date starting date this panel you don't change the only changes that are in blue the other colors you just read what's in there so if we come here if I click this is a link to go to where they can cut up InDesign let's take a look click and it takes me to stitch through which is labeled PG PG 1 to 400 meaning page 1 to 400 which being silently our interface can make from page 1 to 400 we will have a look at that page later first of all let's have a look at the end of it the other blue Lee was this one off written 8 and above them are the cells which have headings for them shots longship fixed ship and random what does this mean you can have three for different people in the side for markers with different no more hours or for workers working at different ships within 24 hours and they all have different normal hours which means some have over time some don't have some work only for no more hours they don't walk a me overtime like that etc and the last one here this rental this is a very little means if you have a working project and his is not he doesn't belong to a company his rent Walker you will use this when putting that here we will come to this side let me first continue showing you what is above the date here now we are here blue color you can change the name of site name this one is for you this blue color and this is for here means where the site is to attend the location of the site now we go down here let's go back to starting to date one from here this corner we have serial number every Dean always has number serial number we have names employment number name of the company what you will choose from here you will check if you put his work in short ship means you're giving him eight hours as normal as you can change absolutely he is working for ten hours as no mames and we click enter and now he's got ten hours as no Morris like this you can do the same to this blue cells or which are and his cells so here we have design ation which designation is the employee so let's do for one guy we will not change the name I gave him name Kevin that a premium number two two three one company name the file will have fifth company names so now I have I have one two three four five companies which means the these are subsidiaries of one company one one company here is the main company in a company here can be the meal and the rest are subsidies so this is one company but they have different they have like branches or companies a group of companies so here we will choose which company the mahkumat in is employed by so let's say that since that's the name of the company and he is working on which if we Sorrento and he belongs to the same company it means his being paid hourly for that month I will show you the reason or the difference between giving him any of the first three shipped from here here and here and giving him this last one rent off here this one so I will tell you that later but if he he's being paid on an hourly basis he will say that he is working on which shift rental and then you can that his his designation if he's a staff what designation is a secretary is a kapenta is a meson is a driver you will just write them here we have that one we have timing we have time out we have date - we have timing we have time what you do you just write here timing and time I have given him timing he is working from six to five if you look here this is just illustration this one doesn't mean so much whatever you put he is just for you - it is just to remind you what I'm the side tax but these two cells they don't control anything in this document they are just there for you to fill in so you can you can remind you what time it starts working so we can feel all the way so here is from date one coming all the way to day two day three so all the way up to here the 31 something here I said we said is for changing the date of the month let's say now here we are on me 2021 let's say we are on now currently this is 2020 and let's say we are in February here with two and is click enter we hit enter let's see what will happen this are empty why I have programmed it such that it only feels to the last bit of that man if this man was up to that it would feel up to here and anything you right here s timing timeout and this cells of the dead cells are empty this will not be counted in the time shift it will be 0 0 in the time sheets the tank card will only take up to the last bit of that man so here you just changed it of the man but you don't change and yet you just change the last bit if you go to the next man the end date of that man will come automatically so here are the totals you will read for yourself later you can see how they work so these totals come from the only time cut on the other sheets so I hope here we have understood each other where we are ok with that and remember I said you can only above from Row 1 through 5 you can only change here when we come here you only after you don't change anything in row five and rho4 rho5 and you only put data from rosen starting with the names you don't change the data of the of the serial number that is automatically you don't touch the here we give him name and everything and we gave him times how will the time can look like we go to their all from here we can click here and it took us there but clearly there let's click here now we are on the tank we said he's from Middle East contracting you can see the name of the company just came and you can see the attention because he's won that company the name is just a detention let me show you quickly what we would happen if we said his comment accompanied on the input we change from Middle East with his rental company then we come to page and here changes rental hire company and the one time she has gotten some other ones daily change it oriental walk just like that so the time card will look like this timing time oh this is the date date one day two in out normal hours this no more hours is what shipped will put their work and what and how many how many know as the views that is happy and the overtime is is the result in time - in time - the normal hours this is the name of the project you feel the interface and here he only illustrates for you which day is the holiday is the resting day now for this Walker I will show you why we have this thing and this one's the panel and this one's in absent and here you can see if we put he has a absent and here down remember I told you the pumpkin will only calculate up to the last day of the month so not February of the year 2020 hundred twenty-nine days the time can't really ignore the rest to this day today and that one of every month and that February doesn't Korean so and the time card will look like this then here down have it Otto's deduction in death penalty he was absent for he was given penalty remember the RSP I will show you all later and stop period of days he walked he walked for 28 days deduction total over time - deduction hours he had 102 overtime hours and because we put this worker and rental these details will help you to see on a midi basis how much he can be paid through hourly basis so this is a total of how many months he has worked for that man and this is the working totals of monthly days he has worked for 26 days he was absent for one day and he was penalized for one day so this ternary abs and etc you come here there is a guide I will put a fire on my video and there's a folder you can check you can download the file and see this guide the guide will be there so this is how it looks like if this means on the interface if you put a is when the Warka is absent you put in and out a he it means he will absent if he is absent so and he will get him he will not get no more hours he will not get any overtime and in the time shift it will appear like this and he will not be present also same thing when if sickly you can put s no more hours yes he will get no more us know what I'm developing act is in the time card and he will be not present with no more hours so that day will be present if he has sick lived a new right see if you write s in the interface it will come like that if you if it is a holiday and they work I went to duty right oh it means he will get no more hours and the total time he worked from starting of the shift till end will all be over time then in the timecard it will appear as holiday will holiday o T and this will be the result in the attempt he will get normal mass and overtime total if it is holiday and he did not go to duty if holiday and not on duty he will get no more mass you write the hitch he will get no more mass and no T appearance on the Timeship it will just be holiday present no mames same case you just read here and you put the same way so in anything I have explained I have Illustrated everything here you can come back to the guide and check so this time can I have this program template I have designed it for companies with big manpower so let's go back to the input I want to show you something why why is it efficient currently this one can hold 400 time cards but I am designing it to hold the 800 time cuts 1 5 1 1 5 to hold 810 cards so for this one and hold 400 all this ourselves where you can put names and details just like that and the time cut will come here so let's try to scroll here down you see page 2 so if you put details the details will come here let me show you something very important in the interface this number means something the serial number is the page number this here the serial number if you are in here with red color 23 this means you are writing for page number 23 so we wrote here for page 1 as Kevin dad so Kevin that is here page 1 so the row number on the interface the serial number on the interface is the page number it's not row number or numbers for the file itself the serial number is the page number for that tank and as easy as that you just fill the details here and you will have your tank and if you have any question you can email me my email is on this video and I have put fire there on the video which you can make to time cuts only because it's just for advertisement actually marketing this plan so anyone who would want to get into business I can design for your company whatever kind of company you have in whatever kind of tank and you have which should look just like this or have some different aspect or some could have something changed a little bit I can design for you and the best thing the nice thing to me is that but it doesn't matter how many workers you have in your company you can make all the item cards in one file like this thank you very much I hope to hear from you people make my work great thank you