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

Thread Started by #JAWEDALAM

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
3rd February 2011 From India, Dhanbad

Attached Files
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 18117 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.
Regards,
Madhu.T.K
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.
Regards.
Jawed Alam
3rd February 2011 From India, Dhanbad

Attached Files
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 5907 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
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....
regards
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
Membership is required for download. Create An Account First
File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 2432 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
2nd November 2011 From India, Karur
#Anonymous
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
Dear All,
Can any1 tel hw 2 calculate compensation 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
If any Managerial cadre employee or Supervisor cadre employee met with fatal accident/permanent disable accident, then is he eligible for any type of compensation under any act? Please repply
22nd May 2013 From India
Employees Compensation Act has not restricted the compensation to workmen as defined in ID Act and as such all employees are covered under the Act. Madhu.T.K
23rd May 2013 From India, Kannur
Dear Mr. Javed Alam,
The calculation sheet is really very useful, thank you very much for sharing. I have notice that you have not included point
(d) Where temporary disablement, whether total or partial results from the injury" -: a half -monthly payment of the sum equivalent to 25% of monthly wages of the employee,
This is in the case of injured employee's monthly salary to be paid.
Regards,
Kaushik Vyas
23rd May 2015 From India, Hyderabad
Sir,
Thanks for sharing to all , Good calculation, . Really worth .
Rameish Emandi
MBA,LLB
Manager-HR,IR& Admin.
Head of Human Resources.
Empee Distilleries Ltd
Hyderabad
9704420983
erameish@gmail.com
3rd August 2015 From India, Nellore
Hello sir,

I have a doubt related to Workmen compensation. One of my friend constructed a house in rural area of TamilNadu in 2010 and he is agriculturist. with lot of difficulty house work completed. He had given construction work to contractor and he had no formal agreement with contractor. One of the employee employed by contractor met with an accident due to high power electric current and lost his hand below the elbow. Medical charges taken care by both my friend and contractor. It is of no use. Now as per Workmen compensation Welfare commmission he has to pay 5.95 Lakhs and interest of 12% from the date of accident. so the total amount to pay is 10L. he is agriculturist and with lot of difficulty he built the house and he has debts too. In fact the cost of the house contruction is less compared to compensation amount he has to pay . He spent only 6L to the house.Please advice what is the procedure. He is not in a position to pay this lump sum amount at any cause. Is there any way to pay less amount / any partial/ yearly payment option avaialble. Your help is greatly appreciated.

Thanks,

Seethalakshmi P
4th January 2016 From India, Bengaluru
Excellent work done ! Really helpful to caliculate EC quickly and accurately. Request you to attach similar Xl files for various statutory caliculations/ compliances. Sarisri.
4th March 2016 From India, Mumbai
can u please clarify if the monthly wage is less than 8000/- then we have to take the actual wages or rs. 8000 for calculation purpose.
14th July 2016 From India, Vijayawada
In case the actual wages is less than 8000, you can take the actual wages. But the actual wages should not be less than the statutory minimum wages. Madhu.T.K
16th July 2016 From India, Kannur
Respected Sir
Could u plzz help me to find out the compensation of the worker got injured at my father's factory? Details are as under:
My father is a sole proprietor having manufacturing unit and employing more than 20 workers.
The worker got injured while at work, his arm got amputated at elbow.
His salary: 5500
Age: 55
Served: 1 year
plzz reply soon
and thanks in advance
23rd August 2016 From India, Delhi
Mr. Jawed Alam, This calculator is really useful for every one. Good work done. Please keep posting likewise. Thanks & Regards, Sridharan.K
30th December 2016 From India, Madras
#Anonymous
The excel sheet is very help.
I have calculated based on the details:
Employee's age - 35 years
Factor - 197.06
Salary Rs.9500/ - But for the purpose of calculation the max limit is Rs.8000/-
Nature of injury - Permanent partial disablement as mentioned in Part II of Schedule I in serial no. 35 (ring or little finger - whole) with percentage of loss of earning capacity as 7%
As per the calculation from the excel sheet (NEW), it is showing Rs. 82,765/- under the heading "compensation ppd by doctor".
Can anybody tell me what is the formula/ basis of the calculation and it it right?
Thanks in advance.
9th February 2017 From India, Kolkata
can any one plese how to calculate the workmen compensation and maximum amount 8000/- or not
22nd April 2017 From India, Hyderabad
Dear Jawed,
Your attached file is not opening.
I shall be thankful, if you Pl send it at
jk.pandey05@gmail .com
Regards,
27th May 2018 From India, Jaipur
Calculation with factor
dear all here attach wc calculation with factor as per employee comp. Act ( wc act )
29th December 2018 From India, Mumbai

Attached Files
Membership is required for download. Create An Account First
File Type: xls factor.xls (34.5 KB, 85 views)

Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™