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@
From India, Madras
Acknowledge(0)
Amend(0)
67EDITED 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@
From India, Madras
Acknowledge(0)Amend(0)
Hi we can’t able to see the attachment please send it again with attachment. Harjeet
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
Systematic and Faster Attendance Register Fully Designed With Macro.xls (806.5 KB, 99 views) PLease provide the password for the above
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
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
From India, Hyderabad
Acknowledge(0)Amend(0)
Major (Retired) D. Bhushan Rao
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
Dear Joshua Files do not open as well the password supplied ( Carrot ) is also incorrect. Kindly upload working model please. Ravi Mishra
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
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
From India
Acknowledge(0)Amend(0)
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.
From India, Ludhiana
Acknowledge(0)Amend(0)
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.
From India, Ludhiana
Acknowledge(0)Amend(0)
Dear Joshua It says incorrect password. Tried in different combination in upper case & lower case. Kindly send the correct password Thanks & Best Regards Ravi Mishra
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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.
From India, Delhi
Acknowledge(0)Amend(0)
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.
From India, Delhi
Acknowledge(0)Amend(0)
Dear Joshua, Pwds Alvina or Carrot is not working. Could you please send me the with unlocking one. Regards
From India, Ludhiana
Acknowledge(0)Amend(0)
From India, Ludhiana
Acknowledge(0)Amend(0)
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
From India, Hyderabad
Acknowledge(0)Amend(0)
Yours sincerely,
MAJ (RETD) D BHUSHAN RAO
SAIPAVAN SECURITY SERVICE
MOB 9848592330
From India, Hyderabad
Acknowledge(0)Amend(0)
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,
From India, Mumbai
Acknowledge(0)Amend(0)
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,
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
Regards,
JA
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
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
From India, Madras
Acknowledge(0)Amend(0)
jashuaa i will appreciate if u explain the procedure to procees the data as u have done earlier
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Joshua, Pls advice how to open your file, if we open this open what should we do next to unlock it ...where to put you given password?? If you say you are innocent, tell us...
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Once u open the password work with attendance report u will get all the detaisl in Salary Calculation Payslip ect. Gothrough with file first and ask the doubt. Regards, JA
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
You have given wrong password___as i told you many times___ pls delete this post___ its stupidity to waste our time with this___ members pls do not break head with this post__
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
hey i m not able to Unprotect Sheet "Systematic and Faster Attendance Register Fully Designed With Macro.xls " plz tell me about this, i need this. thanks...
From Pakistan, Islamabad
Acknowledge(0)Amend(0)
From Pakistan, Islamabad
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
Dear All, You need to click on unhide all workbooks dat’s it, all the sheets are very much there. Thanks Joshuaalvina, it seems to be very useful....!
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Joshua, The unprotect password alvina for unprotecting worksheet is incorrect. Please check and reply. Regards Amit
From India, Ludhiana
Acknowledge(0)Amend(0)
From India, Ludhiana
Acknowledge(0)Amend(0)
Dear Joshua, The unprotect password alvina or carrot is incorrect. Please check and post it again if possible. Regards Meenakshi
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Hyderabad
Acknowledge(0)Amend(0)
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
From India, Hyderabad
Acknowledge(0)Amend(0)
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
From India, Surat
Acknowledge(0)Amend(0)
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
From India, Surat
Acknowledge(0)Amend(0)
really i was confused guys...................................i dont know why its happen to you. Regards, JA
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
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.
From India, Delhi
Acknowledge(0)Amend(0)
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.
From India, Delhi
Acknowledge(0)Amend(0)
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
From Pakistan, Karachi
Acknowledge(0)Amend(0)
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
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Dear friends, i have attached a file for maint of accounts . Please see this. It may be usefull to somebody. Yours sincerely, major d bhushan rao
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
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
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
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.
From India, Allahabad
Acknowledge(0)Amend(0)
From India, Allahabad
Acknowledge(0)Amend(0)
Dear your passwords are not working except login please give the right passwords so we can edit
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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.
From United States, Grand Prairie
Acknowledge(0)Amend(0)
From United States, Grand Prairie
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
I did enable the macros but it would still not work.. Password are completely in correct ... do u have any gmail id where I can add u to chat or yahoo Id thanks lekha
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Please reply Joshua the entire software seems to be the best one. but even after unablingt macros it doesnt work.. u can see the screen shots that I have attached
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Joshua I request you please give me the corrected sheet. I am using this as it full fills the requirement in terms of payroll
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Friend I am despretely need of tht file. but i didn;t open it. how i open and use it plz. suggese me. I am waiting your suggestion. Manoj
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
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
From India, New Delhi
Acknowledge(0)Amend(0)
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?
From India, Kochi
Acknowledge(0)Amend(0)
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?
From India, Kochi
Acknowledge(0)Amend(0)
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
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
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!
From United States, Clifton
Acknowledge(0)Amend(0)
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!
From United States, Clifton
Acknowledge(0)Amend(0)
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@
From India, Pune
Acknowledge(0)Amend(0)
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@
From India, Pune
Acknowledge(0)Amend(0)
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
From India, Pune
Acknowledge(0)Amend(0)
My email id is sunjoa198@yahoo.com.
Thank you,
Satish Dharwadkar
From India, Pune
Acknowledge(0)Amend(0)
dera Joshua, Please provide the user admin Password.so that i can edit the months in INdex sheet
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Bangalore
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
I have attendance register modified to suit my requirement , how do i generate report based on the attendance recorded. Can someone help me . to generate attendance and absence report.
From India, Thane
Acknowledge(0)Amend(0)
From India, Thane
Acknowledge(0)Amend(0)
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.
From India, Bengaluru
Acknowledge(0)Amend(0)
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.
From India, Bengaluru
Acknowledge(0)Amend(0)
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,
From India, undefined
Acknowledge(0)Amend(0)
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,
From India, undefined
Acknowledge(0)Amend(0)
dear sir, Not Able to login the page with your given passwords.... please make necessary changes to open the sane....
From India, Gulbarga
Acknowledge(0)Amend(0)
From India, Gulbarga
Acknowledge(0)Amend(0)
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.
From India, Coimbatore
Acknowledge(0)Amend(0)
From India, Coimbatore
Acknowledge(0)Amend(0)
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.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
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
? Kindly provide us with the attendance sheet.
Thank you.
From India, Shimla
Acknowledge(0)Amend(0)
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
Thank you.
From India, Shimla
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competency-base d HR Management.ppt
Mastering HR Management with SAP.pdf