Payroll Calculation Sheet (advanced) (NO PASSWORD) - XLS Download

Dear All,

The Advanced Payroll calculation sheet has been attached to minimize the day-to-day payroll complexities. The advanced payroll document can be modified at any step, depending upon the nature of work, the number of employees, varying CTC structures, and organizational attendance & leave policies. All the credit for this brilliant attempt is in favor of Mr. Jignesh Parmar.

Regards,
Shweta Bhatia

Hello,

This is really very useful. Thank you a ton for posting. Can you please provide the password as well, as the sheet is password-protected.

Hi,

If you provide a password, one can use the file according to their requirements. Please provide the password.

Dear Jignesh,

As the sheet is protected, please provide me with the password.

Awaiting your reply.

Regards,

Vaishaali

Dear Shweta,

I request you to send me the password of this sheet. It would be very helpful to me. So please help me out.

Regards,
Babu

Dear All,

The worksheet prepared by Jignesh was very helpful. However, we are unable to make changes to it as it is protected by Jignesh. We are unable to get full access to the sheet. Therefore, we kindly request your assistance if anyone has a solution.

Regards,
Babu. P

Hi Shweta,

Excellent work! It is truly innovative and well done. Could you please provide the password so that I can use it to format my payroll system?

Thanks and regards,
Sheetal Pal

Hi Shweta,

Excellent work! Really good and innovative. Kindly provide the password so that I can use it to format my payroll system.

Thanks and regards,
NURA ANGGRAINI
Email: nuraanggraini@yahoo.co.id

Dear Jignesh,

It's really excellent work... Please share the password so that I can change the percentage accordingly.

Thanks a ton for sharing such wonderful data.

Mail: suman.nayar1241@gmail.com

Regards,
Suman Nayar

Hi Swetha,

This is really very useful. Can you please provide me with the password as well, as the sheet is password-protected?

Here is my email address: syams100@hotmail.com

Ram
OD Practitioner

Attribution: https://www.citehr.com/319259-payroll-calculation-sheet-advanced.html#ixzz2rbZDRuCO

Hi, Ms. Shwetha,

Are you active in this forum? Please provide us with the password for the payroll calculation sheet.

Dear Shweta Bhatia,

It's really excellent work. Please share the password so that I can change the % accordingly. Thanks a ton for sharing such wonderful data.

syedafsarali99@gmail.com

Kind regards,
[Your Name]

Thank you for sharing. Please provide the password.

Email: venkatj@hwashin.co.in

Please provide the password to customize according to our needs.

[Login to view]

It seems really very useful and concerns with protecting passwords.

---

Thank you for your message. It appears that you find the information quite valuable as it pertains to password protection.

Email address: [Login to view]

Please send the password immediately.

Please provide me with the payroll sheet password. It would be greatly appreciated as it will be very helpful to me. My email address is srajulali@gmail.com. Thank you.

If you provide the password, it will help many people. I think if not, it is just like a JPG format. So please provide.

Hi Shweta Bhatia/Jignesh,

Thank you so much for your kind help. I would like to request you to provide us with the password in your response to [Login to view].

Thank you.

Thank you very much for sharing. Could you please assist with the password as the sheet is protected? My email ID is brotherpascal2006@gmail.com.

Hi, it's really nice. Great effort. Can you please provide the password.

To crack the password of an Excel or Word sheet, follow the coding below.

This code works in Excel 2010 and 2013 as I have tested it. Works great!

"Press ALT + F11 or click on View Code in Developers tab.

In the Visual Basic editor, enter the following code. Do not change the code, just copy and paste:

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

Now, click on the Run button or press F5."

For more information, email at [sarangkalamkar@gmail.com](mailto:sarangkalamkar@gmail.com).

Has anyone got the password for this Excel sheet?

Hello Sarang21,

Your code is not working. I think this code is not for unprotect.

Excellent work, thanks a lot for sharing.

Hi Shweta, thanks for sharing. Please provide the password at [Login to view].

Hi, Jignesh Sir,

Thank you very much, dear sir, for sharing. Kindly assist with the password because the sheet is protected. My email ID is activefacility@gmail.com.

Thank you.

Please send the password so I can manage my company policy.

I have a solution for this file. I have already broken the password. If anyone needs the unprotected file or wants to learn how to recover the password, please email: krkalia91@gmail.com

Dear Jignesh,

It's very good work, but your company policy setup creation is useful for some persons only, not for all. Please modify this or provide a password if you want this sheet to be useful for us.

Use the given code to unlock the sheet.

Hi Sir,

Kindly email the password to [Login to view].

Thank you.

We have to appreciate the skill in making intricate formulas work in spreadsheets, which is definitely good for learning payroll. However, I recommend not using such spreadsheets for processing payroll in your organization as it is very risky to leave them unprotected. Standalone spreadsheets could stop working at any time, and nobody takes ownership of lost data or other damages except you.

In this instance, I encourage the participants in this thread to refer to a helpful reading resource for anyone responsible for payroll: https://www.greythr.com/complete-guide-payroll/

Hi,

This is Ramesh. What you shared, an advanced payroll sheet using VB, is excellent. However, how do I open unprotected sheets?

Please provide me with the payroll sheet password. It would be greatly appreciated as it will help me with my tasks. My email address is ashok.patel6776@gmail.com.

Hi Jignesh Sir,

I am Ashok Patel. You shared an excellent and very helpful Advance Payroll Sheet, but I am unsure how to unprotect the sheets. Could you please share the password at [Login to view]?

Regards,
Ashok Patel
HR & ADMIN
DAMAN & DIU

Dear HR Professionals/Recruiters/Trainers and Management,

Come and join POSH for further information, please connect.

Thanks,
Radha
9811255029

Hi, if you provide a password, one can use the file according to their requirements. Please provide the password.

Can you please share the password to encrypt the sheet for further usage.

Mail ID: [Login to view].

Contact Number: 8969999030

Very nice, thanks. But please provide us the password to my mail ID wwiplhr@gmail.com.

Mohana
8072193485

Please share the password. My email ID is shivsingh77@gmail.com

The code worked properly. However, it does not allow me to fill in details as it's password-protected.

Please share the password at: [Login to view]

---
Please share the password at: [Login to view]

Please share the password at [Login to view].

Please provide the password on [Login to view].

Nice work! Kindly share the password, dear.

Dear Shweta,

Please share the password on indalkar.ganesh@gmail.com.

Thanks & Regards,
Ganesh Indalkar

Dear Jagadish,

No doubt it is really excellent and wonderful work. I appreciate your efforts. If you could share the password, it would be more helpful to all. My email id is as below: [Login to view].

Thanks a ton for sharing such wonderful data.

Can you share the password with me? It will really be helpful.

[Login to view]

Hi Connections,

I am looking for assured paid freelance recruitment work. Kindly let me know. I have 4 years of experience with top mandates in non-IT. I am looking for a project with a 2-hour deliverable each day. Kindly let me know.

Email: vadaanyug@gmail.com

Swati

Please send the password to me via email at jayshreerajguru028@gmail.com.

Hello,

This is really very useful. Thank you a ton for posting. Can you please provide the password as well? The sheet is password-protected. Kindly provide.

It's really excellent work. Please share the password so that I can change it accordingly.

[Login to view]

It is pointless for people to keep asking for the password. In any case, I am unsure why you need a password. I have no difficulty in changing information in the sheet, e.g., employee names and details, etc. I do not believe it is password protected to be usable.

This thread is 13 years old, and the OP has not posted anything since this one post in 2009. It is likely they are no longer monitoring CiteHR. If there is a password, it is likely they didn't have it anyway as another author is thanked for the work.

If you are still having problems, use your Excel skills to recreate the sheet and adapt it for your purposes. If you don't have the skills, find someone who has. Excel skills are one thing that is extremely useful for everyone to have, so you should do something about that and learn it pronto.

Using spreadsheets for an organization that has 10-20 employees is valid. However, the minute the size of the organization increases, it becomes increasingly difficult for a company to handle its payroll. That is why I think companies with more than 50 employees should consider outsourcing payroll. I would encourage all the participants in this thread to refer to this reading that supports my arguments - https://bit.ly/3VtaiJB

It is password-protected. Can you please send the password?

Please send the password to [Login to view].

As the title of the thread CLEARLY SHOWS, THERE IS NO PASSWORD.

The OP posted only once in 2009 and has not made any other posts since then. It is reasonable to assume he/she is no longer monitoring CiteHR and moved on in their career.

Use your Excel skills to replicate the sheet and modify it to suit YOUR requirements.

Follow the No. 2 Excel Password Remover Online Free - Google Sheets from this link: [https://www.wootechy.com/unlock-document/how-to-remove-password-from-excel](https://www.wootechy.com/unlock-document/how-to-remove-password-from-excel). It worked for me.

MMS

Sir, can you please provide the password to work on? Thank you for this.