Madhu.T.K
Industrial Relations And Labour Laws
Boss2966
Industrial Relations
JAWEDALAM
Ir & Contract Labour Management
Sridharan
Officer Trainee - Personnel
Kvjraghunath
Hr Manager
K89Manu
Student
MADHUKAR1972
Manager-hr
Msnraju2005
Sr.manager (hr)
Kaushikvyas
Sr. Officer - Hr , L&t Idpl
+4 Others

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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.
Regards.
Jawed Alam

Attached Files
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 18433 views)

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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
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.
Regards,
Madhu.T.K
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.
Regards.
Jawed Alam

Attached Files
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 6043 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".
Regards,
Madhukar
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....
regards
Jawed Alam
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
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards

Attached Files
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 2521 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
wr,
P.Govind
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...
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™