Dear All, I am looking calucaltion sheet of accidnet/incidnet/SR/FR in excel format with all formulas. If anyone having, please send me. Thanks & Regards.
From India, Mumbai
Acknowledge(0)
Amend(0)
72From India, Mumbai
Acknowledge(0)Amend(0)
Dear Manish,
The formula for Frequency Rate is: Number of accidents x 10,00,000 / total number of man-hours worked.
The formula for Severity Rate is: Total number of mandays lost x 10,00,000 / total number of man-hours worked.
You can create an Excel sheet based on these inputs.
Thanks & Regards,
Sudhir
From India, Vadodara
Acknowledge(0)Amend(0)
The formula for Frequency Rate is: Number of accidents x 10,00,000 / total number of man-hours worked.
The formula for Severity Rate is: Total number of mandays lost x 10,00,000 / total number of man-hours worked.
You can create an Excel sheet based on these inputs.
Thanks & Regards,
Sudhir
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Manish,
Please make it in a simple Excel file. The formula for the same has already been provided by Mr. Sudhir.
Please let me know if you need any further help in creating an Excel file with the formula included.
Thank you.
From India
Acknowledge(0)Amend(0)
Please make it in a simple Excel file. The formula for the same has already been provided by Mr. Sudhir.
Please let me know if you need any further help in creating an Excel file with the formula included.
Thank you.
From India
Acknowledge(0)Amend(0)
Dear Mr. Pillai, In Europe many companies consider 7500 mandays lost. dupont takes it as 6000 man days lost. Hope this clarifies. Thanks & Regards, Sudhir
From India, Vadodara
Acknowledge(0)Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Kesava Pillai Sir,
A very warm welcome back to CiteHR EHS forum. I hope to receive your guidance through this forum as actively as before.
We are counting 6000 man-days for each fatal accident. I am unsure why it is taking this long. Can you please confirm if this is accurate, and if so, explain why 6000 man-days are required?
Thank you.
From India
Acknowledge(0)Amend(0)
A very warm welcome back to CiteHR EHS forum. I hope to receive your guidance through this forum as actively as before.
We are counting 6000 man-days for each fatal accident. I am unsure why it is taking this long. Can you please confirm if this is accurate, and if so, explain why 6000 man-days are required?
Thank you.
From India
Acknowledge(0)Amend(0)
Dear Friends, You are right! ILO and IS 3786-1983 gives percentage loss of earning capacity and equivalent loss of man-days. Accordingly for death 6000 man-days are charged. Regards, Kesava Pillai
From India, Kollam
Acknowledge(0)Amend(0)
From India, Kollam
Acknowledge(0)Amend(0)
Dear Mr. Pillai, Thanks for updating on IS number 3786 1983. Forum Members, Does any one have the standard copy. If so let us know. Thanks & Regards, Sudhir
From India, Vadodara
Acknowledge(0)Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Dear Mr.Sudhir Please find enclosed IS code 3786:1983. This is for your kind information. Thanks & Regards
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Is any weightage to be given to the victim's age for calculating loss of mandays of 6000 mandays for fatality? For example, if a 55-year-old person dies, should we take 600 mandays, which is equivalent to 20 years of service, as loss as the victim would have put in only 10 years of service had he survived?
Pradip Ghosh
From India, Mumbai
Acknowledge(0)Amend(0)
Pradip Ghosh
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Sirs,
The severity rate at our construction site was 0.55. Unfortunately, a fatal accident occurred, and a worker lost his life.
Before the fatal accident, the lost mandays were 2, and the manhours worked were 3636836. By the formula of Severity rate = No. of mandays lost x 1000000 / Manhours worked = 2 x 1000000 / 3636836 = 0.5499.
Now, after the worker's fatal accident, the severity rate will be as follows: SR = 2 x 6000 x 1000000 / 3636836 = 3299.
I have two questions regarding the above:
1. Is the calculation above correct, i.e., 3299 SR?
2. What severity rate value should we maintain at the site, like 0.1 or 0.2 (0.1 to 1 is not acceptable, etc.)?
Please reply, seniors.
Thanks
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
The severity rate at our construction site was 0.55. Unfortunately, a fatal accident occurred, and a worker lost his life.
Before the fatal accident, the lost mandays were 2, and the manhours worked were 3636836. By the formula of Severity rate = No. of mandays lost x 1000000 / Manhours worked = 2 x 1000000 / 3636836 = 0.5499.
Now, after the worker's fatal accident, the severity rate will be as follows: SR = 2 x 6000 x 1000000 / 3636836 = 3299.
I have two questions regarding the above:
1. Is the calculation above correct, i.e., 3299 SR?
2. What severity rate value should we maintain at the site, like 0.1 or 0.2 (0.1 to 1 is not acceptable, etc.)?
Please reply, seniors.
Thanks
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.