Dear All,
Enclose find a Workmen's Compensation Calculator for 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.
Enter only Serial Number mentioned against List of Injuries Sheet in place of NATURE OF INJURY AS PER LIST OF INJURY SHEET (ENTER SL.NO ONLY).
U r free to ask for any further queries related to use of this calculator.
Jawed Alam

From India, Dhanbad

Attached Files (Download Requires Membership)
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 19733 views)

Industrial Relations And Labour Laws
Industrial Relations
Ir & Contract Labour Management
Officer Trainee - Personnel
Hr Manager
Sr.manager (hr)
+1 Other


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
Good effort. But I have doubt. As per the Workmen's (Employees) Compensation Act there is minimum compensation for death Rs 120000 and in case of permanent total disability Rs 140000. Similarly, the salary is subject to a maximum of Rs 8000 and there is provision for calculating compensation on the statutory minimum rates of wages. I think the sheet takes in to account the actual salary and without minimum compensation. Please correct me, if I am wrong.

From India, Kannur
Dear Madhu.T.K
Thank you very much for suggestion given by u...I have tried to include all those which u pointed. Hope it is correct now. Please need suggestion of all viewer if they have further doubt in new calculator..
Once again thank u Madhu.T.K and looking forward for further suggestion please from ur end.
Jawed Alam

From India, Dhanbad

Attached Files (Download Requires Membership)
File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 6636 views)

Dear Javedalam,
Good efforts, one more change is required that if employee has disability in Middle ring finger, middle finger and index finger then the total of this should come in formula that is not taking. Pl. check.
Also Pl. explain about "Category of compensation".

From India, Aurangabad
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. plz 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 purpose.
If employee has disability in 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) and Doctor will decide %of loss of earnings. And that calculation is also incorporated in 2nd sheet "COMPENSATION PPD BY DOCTOR". Plz check it....
Jawed Alam

From India, Dhanbad
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,
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards
From India, Vijayawada

Attached Files (Download Requires Membership)
File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 2873 views)

Dear Sir,
My son who is a Mechanical Engineer while working in a Factory He met with an accident (Industrial accident) He had sustained Belvic fracture,Urinary Bladder rupture and compression in his L5.Due to this accident he is not able walk like an ordinary person His present health status is partial sensory loss in the right leg fingers and Sciatica with right leg foot drop.Is he entitled for compensation if so how much.His present salary is 18000/-p.m and his age is 24 years

From India, Karur
Dear All,
Can any1 tel hw 2 calculate comensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful bt, I want to knw with slab rates... And will the slab differs for different states? Kindly reply...

From India, Hyderabad

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server