Dear All,
Please find enclosed a Workmen's Compensation Calculator for the calculation of compensation in case of death, Permanent Total Disablement, Permanent Partial Disablement (covered under Schedule I and not covered under Schedule I) with a WC Insurance Premium Calculator.
Kindly enter only the Serial Number mentioned against the List of Injuries Sheet in place of NATURE OF INJURY AS PER LIST OF INJURY SHEET (ENTER SL.NO ONLY).
Feel free to ask for any further queries related to the use of this calculator.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)
Amend(0)
78Please find enclosed a Workmen's Compensation Calculator for the calculation of compensation in case of death, Permanent Total Disablement, Permanent Partial Disablement (covered under Schedule I and not covered under Schedule I) with a WC Insurance Premium Calculator.
Kindly enter only the Serial Number mentioned against the List of Injuries Sheet in place of NATURE OF INJURY AS PER LIST OF INJURY SHEET (ENTER SL.NO ONLY).
Feel free to ask for any further queries related to the use of this calculator.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)Amend(0)
Dear Jawed Alam Thank you for sharing such a wonderful complete file on Workmen Compensation Calculator. Keep on sharing With warm regards S. Bhaskar 9099024667
From India, Kumbakonam
Acknowledge(0)Amend(0)
From India, Kumbakonam
Acknowledge(0)Amend(0)
Good effort. But I have a doubt. As per the Workmen's (Employees) Compensation Act, there is a minimum compensation of Rs. 120,000 for death and Rs. 140,000 in case of permanent total disability. Similarly, the salary is subject to a maximum of Rs. 8,000, and there is provision for calculating compensation based on the statutory minimum rates of wages. I think the sheet takes into account the actual salary and not the minimum compensation. Please correct me if I am wrong.
Regards, Madhu.T.K
From India, Kannur
Acknowledge(0)Amend(0)
Regards, Madhu.T.K
From India, Kannur
Acknowledge(0)Amend(0)
Dear Madhu.T.K,
Thank you very much for the suggestions you provided. I have tried to include all those which you pointed out. I hope it is correct now. Please, I need suggestions from all viewers if they have any further doubts about the new calculator.
Once again, thank you Madhu.T.K, and I look forward to further suggestions from your end.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)Amend(0)
Thank you very much for the suggestions you provided. I have tried to include all those which you pointed out. I hope it is correct now. Please, I need suggestions from all viewers if they have any further doubts about the new calculator.
Once again, thank you Madhu.T.K, and I look forward to further suggestions from your end.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)Amend(0)
Dear Javedalam,
Good efforts. One more change is required: if an employee has a disability in the middle ring finger, middle finger, and index finger, then the total of this should be included in the formula, which is currently not being accounted for. Please check.
Also, please explain the "Category of compensation."
Regards,
Madhukar
From India, Aurangabad
Acknowledge(0)Amend(0)
Good efforts. One more change is required: if an employee has a disability in the middle ring finger, middle finger, and index finger, then the total of this should be included in the formula, which is currently not being accounted for. Please check.
Also, please explain the "Category of compensation."
Regards,
Madhukar
From India, Aurangabad
Acknowledge(0)Amend(0)
Dear R. Parveen Kumar,
The changes suggested by Mr. Madhu T. K have already been incorporated in this new "Workmen's Compensation Calculator1 (New).xls". Please check this new file.
Dear Madhukar,
"Category of compensation" = in case of Permanent Total Disablement (60%), in case of death it is (50%) just for calculation purposes.
If an employee has a disability in the middle ring finger, middle finger, and index finger, then that disablement will not come under Schedule I and will be treated as Permanent Partial Disablement (Not covered under Schedule I). The doctor will decide the % of loss of earnings. This calculation is also incorporated in the 2nd sheet "COMPENSATION PPD BY DOCTOR". Please check it.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)Amend(0)
0
0
The changes suggested by Mr. Madhu T. K have already been incorporated in this new "Workmen's Compensation Calculator1 (New).xls". Please check this new file.
Dear Madhukar,
"Category of compensation" = in case of Permanent Total Disablement (60%), in case of death it is (50%) just for calculation purposes.
If an employee has a disability in the middle ring finger, middle finger, and index finger, then that disablement will not come under Schedule I and will be treated as Permanent Partial Disablement (Not covered under Schedule I). The doctor will decide the % of loss of earnings. This calculation is also incorporated in the 2nd sheet "COMPENSATION PPD BY DOCTOR". Please check it.
Regards,
Jawed Alam
From India, Dhanbad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The information provided in the user reply is accurate regarding the Workmen's Compensation Calculator and the categories of compensation. No amendments are needed. (1 Acknowledge point)
0
0
Dear All, Is there anyone help me out that how I can convert number to Text in Excel sheet. Suppose when I Type 5 It should be Automatically Five or 5000 should be Five Thousand. Thanks, Amir
From Hong Kong,
Acknowledge(0)Amend(0)
0
0
From Hong Kong,
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply is correct. Thank you for the valuable input. (1 Acknowledge point)
0
0
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards
From India, Vijayawada
Acknowledge(1)Amend(0)
From India, Vijayawada
Acknowledge(1)Amend(0)
Dear Sir,
My son, who is a Mechanical Engineer, met with an industrial accident while working in a factory. He sustained a pelvic fracture, urinary bladder rupture, and compression in his L5. As a result of this accident, he is unable to walk normally. His current health status includes partial sensory loss in the right leg fingers, sciatica with right leg foot drop. I would like to inquire if he is entitled to compensation and, if so, how much. He is currently earning a salary of 18,000/- per month, and he is 24 years old.
Regards,
P. Govind
From India, Karur
Acknowledge(0)Amend(0)
0
0
My son, who is a Mechanical Engineer, met with an industrial accident while working in a factory. He sustained a pelvic fracture, urinary bladder rupture, and compression in his L5. As a result of this accident, he is unable to walk normally. His current health status includes partial sensory loss in the right leg fingers, sciatica with right leg foot drop. I would like to inquire if he is entitled to compensation and, if so, how much. He is currently earning a salary of 18,000/- per month, and he is 24 years old.
Regards,
P. Govind
From India, Karur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The employee is entitled to compensation under the Workmen's Compensation Act for the industrial accident. The compensation amount will be calculated based on the extent of disability and salary. The specific calculation can be done using the Workmen's Compensation Calculator provided. It's crucial to follow the guidelines and procedures outlined in the Act for a fair assessment. (1 Acknowledge point)
0
0
Dear All,
Can anyone tell how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know with slab rates. Will the slab differ for different states? Kindly reply.
From India, Hyderabad
Acknowledge(0)Amend(0)
Can anyone tell how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know with slab rates. Will the slab differ for different states? Kindly reply.
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear All,
Can anyone tell how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know with slab rates... And will the slab differ for different states? Kindly reply...
From India, Hyderabad
Acknowledge(0)Amend(0)
Can anyone tell how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know with slab rates... And will the slab differ for different states? Kindly reply...
From India, Hyderabad
Acknowledge(0)Amend(0)
If any Managerial cadre employee or Supervisor cadre employee met with fatal accident/permanent disable accident, then is he eligible for any type of compensation under any act? Please repply
From India
Acknowledge(0)Amend(0)
0
0
From India
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Managerial cadre or Supervisor cadre employees are also eligible for compensation in case of fatal or permanent disable accidents under the Workmen's Compensation Act. (1 Acknowledge point)
0
0
Employees Compensation Act has not restricted the compensation to workmen as defined in ID Act and as such all employees are covered under the Act. Madhu.T.K
From India, Kannur
Acknowledge(0)Amend(0)
0
0
From India, Kannur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Employees' Compensation Act does cover all employees, not just workmen as defined in the ID Act. Madhu.T.K's response is correct. (1 Acknowledge point)
0
0
Dear Mr. Javed Alam,
The calculation sheet is really very useful; thank you very much for sharing. I have noticed that you have not included point (d) where temporary disablement, whether total or partial, results from the injury: a half-monthly payment of the sum equivalent to 25% of the monthly wages of the employee. This is in the case of the injured employee's monthly salary to be paid.
Regards,
Kaushik Vyas
From India, Hyderabad
Acknowledge(0)Amend(0)
The calculation sheet is really very useful; thank you very much for sharing. I have noticed that you have not included point (d) where temporary disablement, whether total or partial, results from the injury: a half-monthly payment of the sum equivalent to 25% of the monthly wages of the employee. This is in the case of the injured employee's monthly salary to be paid.
Regards,
Kaushik Vyas
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Sir,
Thank you for sharing your insights. The calculations provided are truly valuable.
Best regards,
Rameish Emandi
MBA, LLB
Manager-HR, IR & Admin
Head of Human Resources
Empee Distilleries Ltd
Hyderabad
9704420983
erameish@gmail.com
From India, Nellore
Acknowledge(0)Amend(0)
0
0
Thank you for sharing your insights. The calculations provided are truly valuable.
Best regards,
Rameish Emandi
MBA, LLB
Manager-HR, IR & Admin
Head of Human Resources
Empee Distilleries Ltd
Hyderabad
9704420983
erameish@gmail.com
From India, Nellore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply contains no specific information or response to the original post. It would be beneficial to acknowledge the effort and encourage more engagement in the discussion. (1 Acknowledge point)
0
0
Hello sir,
I have a doubt related to Workmen's compensation. One of my friends constructed a house in a rural area of Tamil Nadu in 2010, and he is an agriculturist. With a lot of difficulty, the housework was completed. He had given the construction work to a contractor, and he had no formal agreement with the contractor. One of the employees employed by the contractor met with an accident due to high-power electric current and lost his hand below the elbow. Medical charges were taken care of by both my friend and the contractor. Unfortunately, it is of no use. Now, as per the Workmen's Compensation Welfare Commission, he has to pay 5.95 Lakhs and an interest of 12% from the date of the accident. So, the total amount to pay is 10L. He is an agriculturist and built the house with a lot of difficulty, and he also has debts. In fact, the cost of the house construction is less compared to the compensation amount he has to pay. He spent only 6L on the house. Please advise on the procedure. He is not in a position to pay this lump sum amount under any circumstances. Is there any way to pay a lesser amount or any partial/yearly payment options available? Your help is greatly appreciated.
Thanks,
Seethalakshmi P
From India, Bengaluru
Acknowledge(0)Amend(0)
0
0
I have a doubt related to Workmen's compensation. One of my friends constructed a house in a rural area of Tamil Nadu in 2010, and he is an agriculturist. With a lot of difficulty, the housework was completed. He had given the construction work to a contractor, and he had no formal agreement with the contractor. One of the employees employed by the contractor met with an accident due to high-power electric current and lost his hand below the elbow. Medical charges were taken care of by both my friend and the contractor. Unfortunately, it is of no use. Now, as per the Workmen's Compensation Welfare Commission, he has to pay 5.95 Lakhs and an interest of 12% from the date of the accident. So, the total amount to pay is 10L. He is an agriculturist and built the house with a lot of difficulty, and he also has debts. In fact, the cost of the house construction is less compared to the compensation amount he has to pay. He spent only 6L on the house. Please advise on the procedure. He is not in a position to pay this lump sum amount under any circumstances. Is there any way to pay a lesser amount or any partial/yearly payment options available? Your help is greatly appreciated.
Thanks,
Seethalakshmi P
From India, Bengaluru
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Workmen's Compensation Act applies to the situation described. Your friend can request the commission for a structured payment plan to settle the compensation amount. (1 Acknowledge point)
0
0
Excellent work done ! Really helpful to caliculate EC quickly and accurately. Request you to attach similar Xl files for various statutory caliculations/ compliances. Sarisri.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
can u please clarify if the monthly wage is less than 8000/- then we have to take the actual wages or rs. 8000 for calculation purpose.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
In case the actual wages is less than 8000, you can take the actual wages. But the actual wages should not be less than the statutory minimum wages. Madhu.T.K
From India, Kannur
Acknowledge(0)Amend(0)
From India, Kannur
Acknowledge(0)Amend(0)
Respected Sir,
Could you please help me to find out the compensation for the worker who was injured at my father's factory? Details are as follows:
My father is a sole proprietor with a manufacturing unit that employs more than 20 workers. The worker was injured at work, resulting in his arm being amputated at the elbow.
Details of the worker:
- Salary: $5500
- Age: 55
- Years of service: 1
Please reply soon. Thank you in advance.
From India, Delhi
Acknowledge(0)Amend(0)
Could you please help me to find out the compensation for the worker who was injured at my father's factory? Details are as follows:
My father is a sole proprietor with a manufacturing unit that employs more than 20 workers. The worker was injured at work, resulting in his arm being amputated at the elbow.
Details of the worker:
- Salary: $5500
- Age: 55
- Years of service: 1
Please reply soon. Thank you in advance.
From India, Delhi
Acknowledge(0)Amend(0)
Mr. Jawed Alam, This calculator is really useful for every one. Good work done. Please keep posting likewise. Thanks & Regards, Sridharan.K
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
The Excel sheet is very helpful. I have calculated based on the following details:
Employee's age - 35 years
Factor - 197.06
Salary Rs. 9500/- but for the purpose of calculation the maximum limit is Rs. 8000/-
Nature of injury - Permanent partial disablement as mentioned in Part II of Schedule I in serial no. 35 (ring or little finger - whole) with a percentage of loss of earning capacity as 7%
As per the calculation from the Excel sheet (NEW), it is showing Rs. 82,765/- under the heading "compensation ppd by doctor".
Can anybody tell me what is the formula/basis of the calculation and is it right? Thanks in advance.
From India, Kolkata
Acknowledge(0)Amend(0)
Employee's age - 35 years
Factor - 197.06
Salary Rs. 9500/- but for the purpose of calculation the maximum limit is Rs. 8000/-
Nature of injury - Permanent partial disablement as mentioned in Part II of Schedule I in serial no. 35 (ring or little finger - whole) with a percentage of loss of earning capacity as 7%
As per the calculation from the Excel sheet (NEW), it is showing Rs. 82,765/- under the heading "compensation ppd by doctor".
Can anybody tell me what is the formula/basis of the calculation and is it right? Thanks in advance.
From India, Kolkata
Acknowledge(0)Amend(0)
can any one plese how to calculate the workmen compensation and maximum amount 8000/- or not
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Jawed, Your attached file is not opening. I shall be thankful, if you Pl send it at jk.pandey05@gmail .com Regards,
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
Calculation with factor dear all here attach wc calculation with factor as per employee comp. Act ( wc act )
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
S.No. Designation No. of persons Months Wages (in Rs) Total wages (in Rs)
01. Skilled 5 4 15,600/- 3,12,000/-
02. Unskilled 20 Nos. 4 15,000/- 12,00,000/-
Total 25 Nos. 15,12,000/-
How to calculate WCP premium amount
From India, Coimbatore
Acknowledge(0)Amend(0)
01. Skilled 5 4 15,600/- 3,12,000/-
02. Unskilled 20 Nos. 4 15,000/- 12,00,000/-
Total 25 Nos. 15,12,000/-
How to calculate WCP premium amount
From India, Coimbatore
Acknowledge(0)Amend(0)
Dear Sir,
If a worker is attending duty an average of 15 to 16 days every month due to health issues, and now has had an accident resulting in permanent disability, how do we calculate the compensation wages? Additionally, should we include HRA, conveyance, LTA allowance, etc., in the wages?
I need your help.
From India
Acknowledge(0)Amend(0)
If a worker is attending duty an average of 15 to 16 days every month due to health issues, and now has had an accident resulting in permanent disability, how do we calculate the compensation wages? Additionally, should we include HRA, conveyance, LTA allowance, etc., in the wages?
I need your help.
From India
Acknowledge(0)Amend(0)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.
Workmens Compensation Act 1923.doc
Employee's Compensation Act-2009.pdf
CiteHR.AI
(Fact Checked)-The user's reply is [B]correct[/B]. Thank you for sharing your insights. (1 Acknowledge point)