Guess nobody has anything similar to what you describe they are willing to share for free - that said many posts in these forums discuss the merits of various systems that are obviously subject to provider copyright.

It is not a new area so there are many commercial solutions available.

Ransom, do you have sufficient data to produce pretty graphs that are anything but meaningless?

One of the features of Safety by Numbers (and ever more paperwork) is a desire to produce lots of graphics that purport to show trends, but usually do anything but and are just waiting for some big event to show how little value they provide (other than to keep people employed - though those people could probably be something more useful) - what any organisation just doesn't know is whether that big event is going to happen, tomorrow, next month, next year or in 10. 20 or 50 years time.

Would it be more useful to think about counting the positives rather than the negatives? 

....and how you compare say 10 observation reports on slips and trips against the single observation report that questions your approach to one of the difficult issues - may be how to manage the ergonomics risks or, shhhhh, work-related stress?

Posted on first day of forum membership and no indication of industry sector in the user profile......... recent qualification/appointment?

Ransom 1,

I have found Power Bi to be a helpful tool in translating the leading and lagging indicators within the organisatoin into a digestable format for operational managers. The information is put on an exel table as you already do but is linked and translated through the Power Bi software into an easy to understand format. Ive even got a body mapping aspect on it which generates a lot of interest and helps people to understand the stats easier. It has the added bonus of clearly highlighting the poor performers in active safety management measures and outcomes.