Accident Or Severity Rate Formula Required Pdf Download.. CiteHR

manishanand83 Started The Discussion:

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.

asudhir17 -  Member Since: Sep 2011
Dear Manish,

The Formulae for Frequency rate is No of accidents x 10,00,000 / total number of man hours worked.

The formulae for Severity Rate is Total number mandays lost x 10,00,000 / Total number of manhours worked.

You can make excel sheet based on these inputs.

Thanks & Regards,


dipil -  Member Since: Nov 2009
Dear Manish

Please make it in simple excel file... The formula for the same is already given by Mr. Sudhir...

Do let me know any further help you required in making an excel file with formula inbuilt in it...

Kesava Pillai -  Member Since: Dec 2009
Dear Friends, Nice query! Now if there is a fatal accident; how will you account for man days lost? Regards, Kesava Pillai

asudhir17 -  Member Since: Sep 2011
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

dipil -  Member Since: Nov 2009
Dear Kesava Pillai Sir

A very warm welcome back to CiteHR EHS forum... Hope to get your guidance through this forum as actively as earlier...

We are counting 6000 man-days for each fatal accident... Why it is so taking, I don't have an idea?

Can you please share whether it is right and if so why 6000?

Kesava Pillai -  Member Since: Dec 2009
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

asudhir17 -  Member Since: Sep 2011
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

manishanand83 -  Member Since: Jun 2011
Dear Mr.Sudhir Please find enclosed IS code 3786:1983. This is for your kind information. Thanks & Regards

Attached FilesProvided by community member manishanand83. Join us to learn and grow with your peers.
File Type: pdf 3786 Frequency and Severity Rates.pdf (1.30 MB, 1060 views)
mochhu -  Member Since: Oct 2011
Is any weightage to be given to victim's age for calculating loss of mandays of 6000mandays for fatality? For example, if a 55year old person dies, should we take 600mandays which is equivalent to 20years of service as loss as the victim would have put in only 10years of service had he survived?
Pradip Ghosh


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.

Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Share This Discussion:

3M Users, 100K+ Documents & 450K+ Discussions
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