Simplifying Attendance and Payroll: How to Navigate Joshua's Comprehensive Guide

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 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

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.

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 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

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

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.

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.

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.

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

Dear Joshua, please provide the user admin password so that I can edit the months in the Index sheet. Thank you.

Regards

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 at my email: [Email Removed For Privacy Reasons].

Thank you.

Regards.

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.

Regards, D. DHANASHEKAR

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

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.

You can use attendance software, which provides 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 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 consolidation report, attendance regularization report, NCP report (Non-Contribution Period as per statutory), and more. https://www.greythr.com/in/features/...ment-software/

Regards

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,

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.

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.