Workmen's Compensarion Calculator - id act Xls Download.. CiteHR
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Labor & Employee Relations
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.

Regards.
Jawed Alam


Attached FilesProvided by community member JAWEDALAM. Join us to learn and grow with your peers.
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 6231 views)
boss2966 -  Member Since: Jan 2009
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

Madhu.T.K -  Member Since: Sep 2007
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

JAWEDALAM -  Member Since: Aug 2010
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 FilesProvided by community member JAWEDALAM. Join us to learn and grow with your peers.
File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 2251 views)
MADHUKAR1972 -  Member Since: May 2007
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

JAWEDALAM -  Member Since: Aug 2010
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

Amir Mohammad -  Member Since: Feb 2010
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

dipil -  Member Since: Nov 2009
Dear Mr. Jawed Alam Really commanding job done... Thanks for sharing the document with us... Keep up the good work...

ravi.k457 -  Member Since: Sep 2009
Respected Sir, Thanks for the post it is really useful for the HR peoples.Keep posting. Thanks & Regards Ravi

kvjraghunath -  Member Since: Aug 2010
Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards


Attached FilesProvided by community member kvjraghunath. Join us to learn and grow with your peers.
File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 676 views)

Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
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.


PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE



3M Users, 100K+ Documents & 450K+ Discussions

Share »


Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Community Support & Professional Insights. Login or Register.
Email/Username    
Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network