ATTENDANCE REGISTER CUM PAYROLL (Edited On 28.01.2010)

Attendance Register Cum Payroll Including All ESI PF Forms (By Joshua Alvina)

EDITED ON 28.01.2010 (and link file also given open the zip folder and copy the files and paste in ur add-in)

Regards, Joshua

How to Use: Step by Step

1. Open Workbook
2. Enable Macro
3. Enter Login Password: @joshua
4. Unhide All the Workbooks
5. Unprotect Worksheet Password: alvina
6. While Exit Lock all the workbook click on lock or Lock user Password: joshua@

You have to find all the there. Attendance register, Payroll calculation, Payslip, Advance Register, Consolidated Statement, Form 3A, Form 6A, Form 5, 7, ESI yearly Returns, Form 12A, etc.,

This will help you guys. 1st Sheet PASSWORD: Carrot All other sheet password: Alvina Login Password: @joshua Lock Password: joshua@

Hi, we can't able to see the attachment. Please send it again with the attachment.

Harjeet

Hi Joshua,

I downloaded your attachments, but the attendance register file is not opening. Could you please provide me with the password to access it? Thank you. I am also trying to send it to those who were unable to download the file. Thank you very much.

Regards,
LR

Systematic and Faster Attendance Register Fully Designed With Macro.xls (806.5 KB, 99 views)

Please provide the password for the above.

I have created an attendance sheet linked with the wage sheet, ESI register, ESI challan, EPF register, EPF challan, and bills with service tax challan. If anybody wants the same, please forward your wage sheet and bills copies so that I can forward the same duly linked with the above forms for your ease. My email ID is raodammalapati@yahoo.co.in.

Major (Retired) D. Bhushan Rao

Hi Joshua,

I am Rajesh and a new member in this network. The attached sheets are very useful, and I would like to know if I can personally use them for my requirements. If yes, please email me the details to matha.rajesh@gmail.com.

Regards,
M. Rajesh.

Hi Joshua,

I am Rajesh, a new member in this network. The attached sheets are very useful and I would like to know if I can use them. If yes, please provide me with the password and other details.

Regards,
M. Rajesh

Hi Joshua,

I am Rajesh, a new member in this network. The attached sheets are very useful, and I would like to know if I can use them. If yes, please provide me the password and other details at matha.rajesh@gmail.com.

Regards, M. Rajesh.

Dear Joshua,

Files do not open, and the password supplied (Carrot) is also incorrect. Kindly upload the working model, please.

Ravi Mishra

Hi Singh Raj,

I am sending the attendance format which I believe will be useful for you. This attendance format is typically followed by manufacturing companies.

The attachment files include:
1. Attendance format
2. Overtime format
3. Driver's and cleaners' salary attendance format.

Please find the attachments enclosed.

Thank you,
Amar
9603346857
9949455395

Dear Joshua,

The password "Carrot" is not working. How do I unprotect it? What will be the password for this so I can utilize all of its features? Other passwords like "ottffsse," "joshua," or "SALSLVS" are also not working.

Thank you.

Dear Joshua,

It says incorrect password. I have tried different combinations in upper case and lower case. Kindly send the correct password.

Thanks and Best Regards,
Ravi Mishra

Hi,

I have attached some files that will help you understand how to simplify the salary process. The documents include:

1) Attendance Sheet
2) Salary Calculator
3) Salary Bank Credit Statement (A-C No)
4) Salary Credit Report

Sudhir Singh Rawat
Mumbai, India
9821443636

Hi,

Why don't you give us the password? The passwords: CARROT, JOSHUA, SALSLVS, ALVINA, and ottffsse don't work. Please don't create a mess if you don't want to give the password. Why did you post this file here when many, including me, requested the password but you didn't give it? What are you trying to show? Disgusting.

Dear Joshua,

The password for Alvina or Carrot is not working. Could you please send me the instructions for unlocking it?

Regards

Wage sheet linked with ESI register, ESI challan, EPF register, and EPF challan attached without any passwords for the use of all CiteHR members.

Yours sincerely,

MAJ (RETD) D BHUSHAN RAO
SAIPAVAN SECURITY SERVICE
MOB 9848592330

Dear CiteHR members,

I have found that the members of this forum are well-behaved and cultured with respect to the norms of sharing and spreading knowledge to and around the world, at least. However, one of the members, Joshua, shared a password-protected Excel file named "Systematic and Faster Attendance Register Fully Designed With Macro" and also provided some incorrect passwords in this community. I wonder why this disturbed member posted this file in this elite forum. I myself was very disappointed when I tried to use it, and so was everybody else who downloaded it.

One of my genuine requests to all the members and especially the Moderator of this forum is to please BAN this member from this elite forum or ensure that he will post the correct passwords for the file. If this is not possible, please delete this post from this community.

Regards,

I have given the correct password, and many of my fans have given personal thanks in private messages. I don't know why this happened. However, I have created this program for CiteHR to use. I will go through this file again and repost it. Sorry for any inconvenience caused by me.

Regards,
JA

Dear CiteHR members,

I have found that the members of this forum are well-behaved and cultured with respect to the norms of sharing and spreading knowledge to and around the world, at least. However, one of its members, Joshua, shared a password-protected Excel file named "Systematic and Faster Attendance Register Fully Designed With Macro" and also provided some incorrect passwords in this community. I wonder why this disturbed member posted this file in this elite forum. I myself was very disappointed when I tried to use it, as was everyone else who downloaded it.

One of my genuine requests to all the members, and especially the Moderator of this forum, is to please BAN this member from this elite forum or ensure that he will post the correct passwords for the file. If these actions are not possible, please delete this post from this community.

Regards,

Proof of record

Password for Lock:

Dim mypassword

tryagain:

mypassword = InputBox("Are You Sure?", "Password")

If mypassword = "joshua@" Then

ActiveWindow.DisplayWorkbookTabs = Not (ActiveWindow.DisplayWorkbookTabs)

'your code here

MsgBox ("Successfully Locked")

Else

If MsgBox("Password incorrect, try again?", vbYesNo, "Wrong password") = vbYes Then GoTo tryagain

End If

ActiveSheet.Next.Activate

ActiveWorkbook.Sheets(1).Activate

Password to open

Dim mypassword

tryagain:

mypassword = InputBox("Enter Login Password", "Password")

If mypassword = "@joshua" Then

ActiveWindow.DisplayWorkbookTabs = Not (ActiveWindow.DisplayWorkbookTabs)

'your code here

MsgBox ("Successfully Locked")

Else

If MsgBox("Password incorrect, try again?", vbYesNo, "Wrong password") = vbYes Then GoTo tryagain

End If

ActiveSheet.Next.Activate

ActiveWorkbook.Sheets(1).Activate

Password for Sheet:

Sheets(1).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Sheets(4).Protect Password:="Alvina", _

UserInterfaceOnly:=True

Joshua, I would appreciate it if you could explain the procedure to process the data as you have done earlier.

Joshua,

Please advise on how to open your file. If we open it, what should we do next to unlock it? Where should we input the given password? If you claim innocence, please let us know.

Thank you.

You have given the wrong password, as I told you many times. Please delete this post; it's stupid to waste our time with this. Members, please do not break your head with this post.

Hey, I'm not able to unprotect the sheet "Systematic and Faster Attendance Register Fully Designed With Macro.xls." Please tell me about this; I need this. Thanks.

Hi Joshua Alvina,

I could not find the attachment. When I opened the sheet, it didn't ask for a password, and there are no options to click on the login password or lock password. If you could please send it to hr2@ayantech.com, it would be really great.

Thanks

Dear Joshua,

You are right, the passwords are all correct. The only problem with me and all the not so computer-savvy people, as I am, don't know about the macros in the Excel sheet. After a long battle with the settings with macro security options, I found the solution. Here is how I found the solution:

Opened Microsoft Excel Tools -> Macro -> Security... Under "Security Level" Tab Select "Low (not recommended)" radio button

That's it. And then the passwords are working fine...

Regards

Dear All,

You need to click on "unhide all workbooks," that's it; all the sheets are very much there.

Thanks, Joshuaalvina, it seems to be very useful...!

Dear Joshua,

The unprotected password "alvina" for unprotecting the worksheet is incorrect. Please check and reply.

Regards,
Amit

Dear Joshua,

The unprotected password "alvina" or "carrot" is incorrect. Please check and repost it if possible.

Regards,
Meenakshi

Hi Joshua!

You are not cheating anybody. It really works, what you have attached. Thanks a lot.

Guys, please see scrap no. 87 (Taslima).

Opened Microsoft Excel.

Tools -> Macro -> Security...

Under the "Security Level" tab, select the "Low (not recommended)" radio button.

That's it.

I'm attaching it again.

Regards,
Pushpendra

Hi Joshua,

I am Rajm, a new member in this network. The attached sheets are very useful, and I would like to know if I can use them. If yes, please provide me the password and other details at mvram@in.com.

Thanks & Regards,

M.V. Ram

Hi Joshua,

I can easily work on your sheet. It's easy to run the file, and what a work you have done! I really appreciate it. Can you tell me when all sheets are unhidden, then what's the password for different sheets as you have mentioned?

Also, I request you to please provide me the attachment that you have attached on this forum.

Again, thanks a lot as it is very, very useful.

Regards,
Arihant

Really, I was confused, guys. I don't know why it's happening to you.

Regards,
JA

Dear Joshua,

Could you please be so kind as to resend the file "Systematic and Faster Attendance Register Fully Designed With Macro.xls" once more, along with your mobile number? This way, we can seek your direct assistance at any time.

Thank you.

Dear Josh,

I am grateful that you have provided the password-free Attendance Register to your fans. I have downloaded it and found it very helpful. When we give something to others, we find inner peace and happiness. I am sure that you will be proud of yourself because sharing your hard work with unskilled people like me without asking for anything is a matter of great pride. According to Buddhism, you have created good karma, which will be helpful in your future life.

Sher

Dear friends,

I have attached a file for the maintenance of accounts. Please review it as it may be useful to somebody.

Yours sincerely,
Major D. Bhushan Rao

Hi,

I have downloaded the attachment but am unable to access the Excel sheet due to the password. I was able to log in as the administrator, but then could not find the password to unlock it.

Please help.

Thanks and Regards,
Ferdinand Dsouza

Hi Joshua,

My name is Zeshan, and I recently joined a company as an HR Assistant Manager. First of all, thanks for your Attendance Register. However, I have a problem with it. Your calculation is based on daily wage staff, but I have permanent staff on a monthly basis. How can I manage this worksheet? Please guide me. You can reply to my email address at bajwazeshan@gmail.com.

Thanks

Only the read file is showing the excellence of the software you provided on the site we are members. Kindly let me have the password and other files to enable me to open and use them smoothly. My email IDs are pksachdeva2009@gmail.com and pks_meerapur_alld@rediffmail.com. Please help me to enable. Thanks and regards, P K Sachdeva.

Dear, your passwords are not working except for login. Please provide the correct passwords so we can edit.

The layout is really nicely done. The downside is that many people can't get the passwords to work, and this person seems to enjoy playing around with providing the correct password. It's truly a shame that this type of problem exists. Personally, I just load a macro to remove all passwords; it's much easier than constantly asking for passwords.

As instructed, I have opened the first 2 steps, but in the 3rd step, I didn't find any login. In the 4th step, when I click, I am unable to know whether it is still hidden or unhidden. The same issue arises in the 5th step as well. In the 6th step, I also faced the same problem, not finding anything after clicking the button. Additionally, I didn't understand the word "addin" and where to copy and paste these files. Please help me out.

Hi Joshua,

When I click on the calendar, it gives me an error. None of the passwords on Sheet 1 or any are correct. When I click on any button on the index, nothing opens. The rest unlock button is also not working. We, the passwords, are all wrong - Alvina and Carrot. Kindly send me a correct sheet, please.

Thank you.

I did enable the macros but it would still not work. Passwords are completely incorrect. Do you have any Gmail ID where I can add you to chat or Yahoo ID?

Thanks,
Lekha

Please reply, Joshua. The entire software seems to be the best one, but even after disabling macros, it doesn't work. You can see the screenshots that I have attached.

Joshua,

I request that you please give me the corrected sheet. I am using this as it fulfills the requirement in terms of payroll.

Hi Friend,
I am desperately in need of that file, but I didn't open it. How can I open and use it, please suggest to me. I am waiting for your suggestion.
Manoj

Dear Joshua,

The Attendance Register Cum Payroll software is good, but I am unable to operate it. The index only shows that it is protected. Please send me the password or some tips on how to operate it.

Thanks,
Nitin Jolly

Dear All,

I am Rajesh. I worked in the manufacturing industry, but now I am working in the service industry, which is registered under the Shops and Establishments Act of Karnataka. Can someone help me understand the difference in annual returns compared to the Factories Act with reference to all acts?

Hi Joshua,

Your efforts are great. I have downloaded the files too, but I am not able to enter the password even after enabling the Macros. Am I missing anything? Can you please help?

Thanks,
Tanya

Hello All,

I have been following this and other threads of Joshua for a while and was upset to see how certain individuals act weird in an open forum. If you created something and have posted it on an open forum like citehr, then you should not password protect it; this is an open forum where helping each other is the essence of it. Moderators, you should take this seriously.

Joshua, pardon me, but I cracked your Excel application and have made it password-free for all to customize as per their needs. There were many people requesting you to share the password, but you never did. Hence, I had to ethically hack it for the benefit of all in general.

Enjoy Friends! Sorry, Joshua!

Hi, this is Satish. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll and a great help for all HR people. But I am not able to unlock the Pay Slip Cum Time Card sheet. Could you please help me with the password and how to edit that sheet?

My Email id is sunjoa198@yahoo.com.

Thanking you,

Satish Dharwadkar

Edited on 28.01.2010 (and link file also given open the zip folder and copy the files and paste in your add-in).

Regards,
Joshua

How to Use: Step by Step

1. Open Workbook
2. Enable Macro
3. Enter Login Password: @joshua
4. Unhide All the Workbooks
5. Unprotect Worksheet Password: alvina
6. While Exit Lock all the workbook click on lock or Lock user Password: joshua@

You will find all the there: Attendance register, Payroll calculation, Payslip, Advance Register, Consolidated Statement, Form 3A, Form 6A, Form 5, 7, ESI yearly Returns, Form 12A, etc.

This will help you, guys.

1st Sheet PASSWORD: Carrot
All other sheet passwords: Alvina

Login Password: @joshua

Lock Password: joshua@

Hi, this is Satish. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll and a great help for all HR people. However, I am not able to unlock the Pay Slip Cum Time Card sheet. Could you please help me with the password and how to edit that sheet?

My email id is sunjoa198@yahoo.com.

Thank you,
Satish Dharwadkar

Dear Joshua,

Please provide the user admin password so that I can edit the months in the Index sheet.

Thank you.

Dear Joshua,

Please provide me with the details of the password as I cannot update the month calendar in the index sheet. It is still showing November 2009 and it is interlinked with all other sheets, I believe. Please update it and forward it to me on my email: vrp1978@gmail.com.

Thank you.

Dear Sir,

Hats off to you for breaking the Excel macros. I am unable to include the members in the payslip format. It is indicating errors in the Employee Name and Designation everywhere. Please find the attachment of the Payslip for Employee No. 020. I have used the formulas; however, it is still showing errors. Please suggest how I can correct it.

Moreover, the Basic Salary calculations seem to be incorrect. The Net Salary for a Gross Salary of Rs. 21,000/- shows only Rs. 13,950 as Net Salary. Kindly correct and send it back to me.

Thank you.

D. DHANASHEKAR

Dear Sir,

Your job is greatly appreciated, especially for sharing the same. I have gone through the attendance sheet and noticed the markings "X, A, H, S, PH." However, in the scenario where a person works for half a day and takes half a day off, how should I mark this?

Please correct this for me, or kindly inform me on the correct method.

Thanks and regards,

MANJUNATH KS

Dear All,

To unprotect any Excel sheet, follow the program which is really beneficial to all:

1. Just open the Excel file you want to unprotect.
2. Press ALT+F11 (the macros window will open).
3. Select any sheet from the left side of the window.
4. Then paste the following program:

Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Then go to the run option and press run macros. Your file will now be unprotected.

Enjoy, everyone.

I have modified the attendance register to suit my requirements. How do I generate a report based on the recorded attendance? Can someone help me to generate an attendance and absence report.

Hi Raghavendra Vijay Rao,

You can use an attendance software, which will make it a convenient way to track your employees' attendance and monitor productivity. There are multiple software options available in the market. One such software is greytHR, which can streamline your attendance management. Additionally, greytHR (URL: https://www.greythr.com/in/features/attendance-management-software/) can generate your attendance and absence reports. It can create ten different attendance reports based on your requirements, such as the attendance summary report, attendance consolidate report, attendance regularization report, NCP report (Non-Contribution Period as per statutory), and more.

Hi,

As per your attachment "ATTENDANCE REGISTER CUM PAYROLL Including All ESI PF forms" by Joshua Alvina, edited on 28.01.2010 (and link file also given - open the zip folder, copy the files, and paste them in your add-in).

The unprotected sheet password is not working. Kindly advise me.

Regards,

Dear Sir,

I am unable to log in to the page with the passwords provided. Please make the necessary changes to access the same.

Thank you.

Hi, this is Sudhagar. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll and a great help for all HR people. However, I am not able to unlock the Pay Slip Cum Time Card sheet. Could you please help me with the password? Without the password, how could I edit that sheet? This is my email address Sudhagar_r@yahoo.in, so can you send the PW.

None of the above passwords are working on the sheet.

Hi, this is Jeevan. I have downloaded your Systematic and Faster Attendance Fully Registered with Macro Edited. It's a very beautifully planned and worked software for Salary Payroll, and a great help for all HR people. However, I am not able to unlock it. When I am trying to unlock it, it does not open. May I know the password? My email id is jeeva.ragati@polyglotit.com.

Hi Joshua,

May I know the VBA password?

Dear Joshua,

I have tried to open your attendance-related sheet, but the password is not allowing me to access it. Could you please share a systematic and faster attendance register sheet with the correct password to my email ID [Login to view]? Kindly provide us with the attendance sheet.

Thank you.