JAWEDALAM Started The Discussion:
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
3rd February 2011 From India, Dhanbad
Attached Files
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 15153 views)

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
3rd February 2011 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.
3rd February 2011 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
3rd February 2011 From India, Dhanbad
Attached Files
File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 4793 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".
4th February 2011 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
4th February 2011 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
8th June 2011 From Hong Kong,
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards
18th September 2011 From India, Vijayawada
Attached Files
File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 1802 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
2nd November 2011 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...
6th January 2013 From India, Hyderabad

Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network