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
From India, Dhanbad
76Enclose 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
From India, Dhanbad
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
From India, Kannur
Regards,
Madhu.T.K
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.
Regards.
Jawed Alam
From India, Dhanbad
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
From India, Dhanbad
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
From India, Aurangabad
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
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....
regards
Jawed Alam
From India, Dhanbad
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
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,
From Hong Kong,
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards
From India, Vijayawada
From India, Vijayawada
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
From India, Karur
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
From India, Karur
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Workmen Compensation Calculator.xls
Workmen Compensation Notification.pd f