Workmen's Compensation Calculator - Xls Download

Mr. Jawed Alam,
This calculator is really useful for every one. Good work done. Please keep posting likewise.
Thanks & Regards,
Sridharan.K

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.

can any one plese how to calculate the workmen compensation and maximum amount 8000/- or not

Dear Jawed,
Your attached file is not opening.
I shall be thankful, if you Pl send it at
jk.pandey05@gmail .com
Regards,

Calculation with factor
dear all here attach wc calculation with factor as per employee comp. Act ( wc act )

S.no. Designation . of persons Months Wages (in Rs) Total wages (in Rs)
01. Skilled 5 4 15,600/- 3,12,000/-
02. Un-skilled 20 Nos. 4 15,000/- 12,00,000/-


Total 25 Nos. 15,12,000/-

How to calculate wcp premium amount