Spreadsheet for Health and Safety Reporting - Template

6thsense

Involved In Discussions
#1
Hi covers,

I have been tasked with developing a reporting spreadsheet for Health and Safety reporting - to include First aid case rates. LTIs, motor vehicle etc. And would be happy for an example or guidance.
 
Elsmar Forum Sponsor

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#2
I do a lot of work with that data, and one of my internal customers uses a simple spreadsheet to track their cases.

For the most part, a single spreadsheet page can handle most needs, of course, there are a lot of commercial relational database products out there.

Generally, you are going to do a one line per event listing. Date of injury/event, Description, Classification (such as First Aid, Medical Treatment), Owning Organization are basics. If you are going to use your spreadsheet to support OSHA reporting you'll need no. of days away, restricted, cause, and other descriptive fields on the OSHA 300 form.

An important thing is to set up data validation pick lists in Excel, so that there is a standard set of body parts, causes, injury types to choose from for the appropriate fields.

One limitation of a single page file is some fields may need multiple entries, such as multiple body parts may be affected in some injuries. If you intend to chart the data, working with the data analyst for how to handle that structure (Multiple body part columns, or separating the entries with commas) is needed. One of the most time consuming parts of analyzing the spreadsheet I get is programming the logic in for new body part combinations, and mispelled items, so they will count into the proper charts.
 

batman1056

Involved In Discussions
#3
Hi - I have developed many H&S reports from SharePoint (lists) and excel spreedsheets. It would be difficult in sharing what we produce as its a differnt industry.

Firstly ask yourself will reproting on the indcator help manage that risk?

In producing a KPI,PI,SPI (or whatever you calling them) remember that your data needs to be presented in a way that allows managment to make a judgement call on what you are producing. Showing Month 5 data and not showing any trends or historic referencing will provide little help to managers when trying to understand if they are doing well or not.

Some of the things I report on are:
RIDDOR
LTA
Non-LTA
Close Calls
RTA (where staff are injured)

From investigations: cause of accident and type of accident (e.g. manual handling, and the cause being "poor applicaion of procedures etc)

I have historically used an "injured man" which showed the body part areas in a picture.

I would also consider splitting data in to contactor accidents and then the production of an AFR or AAFR (accident frequency rate based on hours worked and RIDDORS and All accident frequency rate)

Split the report into laggin and leading indicators - negative lagging - postive are leading (e.g. safety tours, inspections, audits etc)

If you are a front facing business (e.g. working with the public) - then assuaults etc are useful to record which can be used then to train and adjust Risk Assessments on the level of risk working in a specific area.

Hope this helps
 

Ettore

Quite Involved in Discussions
#4
Years ago when i worked like quality controller I usuallly wrote down the production control on Attribute control charts.
Today I have to do a continuous control in production of Conformity of safety rules (for safety department), Controls of use where required of Personal protective equipment (PPE) clothing, helmets, goggles, or other garments or equipment designed to protect the wearer's body from injury, Control of use of safety norms, etc.
Somewhere anybody use attribute control charts for report this controls? Any example?
Could you suggested other kind of spreadsheets where writing my controls ?
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#5
Years ago when i worked like quality controller I usuallly wrote down the production control on Attribute control charts.
Today I have to do a continuous control in production of Conformity of safety rules (for safety department), Controls of use where required of Personal protective equipment (PPE) clothing, helmets, goggles, or other garments or equipment designed to protect the wearer's body from injury, Control of use of safety norms, etc.
Somewhere anybody use attribute control charts for report this controls? Any example?
Could you suggested other kind of spreadsheets where writing my controls ?
Control charts are for processes that are in control. Your case does not seem to be in a state of control, or why have this request? In addition, points on a control chart don't provide detail beyond the extent to which something conforms or not. Try recording with a series of stacked bar charts instead. In this way you can show categories and compare the proportions of all good versus counts of x, y and z attributes (PPE type not being used, machine guarding removed, etc.)
 

Ettore

Quite Involved in Discussions
#6
Thank you very much for your suggestion. I'm new in this field.
I was been in this company quality system coordinator since 1991. The management have change my location from quality system coordinator to safety department. Now after two year of back office recording report about safety course my new boss just say to me to travel around the plant all the day and reporting him in the evening what I have seen using a mail. He said to me to travel around all the plant, but the plant is so big..But this is not a problem.
I would like write to him a mail of I have seen whith attached spreadsheet whit all the control that i have done. a relationed spreadsheet where the column of father row reporting the date and time of control. department, machine, position of worker, name of worker, instruction controĺled, conformity or not. and in the children row the "defect" that i have seen. And eventually a near miss report referring.
I wouldn't give to my boss and probably to the direction any occasion to leave me home.
I'm working every day from seven on the morning to seven in the evening whit no extra payment...
Any sample please? I wouldn't give to my boss and probably to the direction any occasion to leave me home.
 
Last edited:
Thread starter Similar threads Forum Replies Date
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
U Spreadsheet Context, interested parties ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
rob73 EU Medical Device Classification Spreadsheet EU Medical Device Regulations 2
S VDA 5 Variables Data GR&R Spreadsheet wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
C Visual Presentation of Supplier Score - .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 1
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 6
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet to use Basic and Mini MOST for Line Balancing Document Control Systems, Procedures, Forms and Templates 1
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
D Is a separate spreadsheet required for the ASL (Approved Supplier List)? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Ajit Basrur How do I create two different columns in Excel spreadsheet ? Excel .xls Spreadsheet Templates and Tools 5
L Auditing Tool (Excel spreadsheet) for VDA 6.3 to Audit a Service Provider VDA Standards - Germany's Automotive Standards 4
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
M Dimension Report Formula .xlsx Editable Spreadsheet Form Excel .xls Spreadsheet Templates and Tools 24
B Third Party Service Provider Risk Rating Spreadsheet Risk Management Principles and Generic Guidelines 1
K Taguchi School Assignment using an L8 Orthogonal spreadsheet tool Statistical Analysis Tools, Techniques and SPC 1
S Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 6
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet Excel .xls Spreadsheet Templates and Tools 3
R Creating a c-chart spreadsheet to use in my department Excel .xls Spreadsheet Templates and Tools 5
R XBar & R Chart Spreadsheet to apply a Control Process Statistical Analysis Tools, Techniques and SPC 1
A ECR & ECN - Looking for advice and Spreadsheet Example Document Control Systems, Procedures, Forms and Templates 1
F SPC Data Analysis - Excel Spreadsheet I can use for Diameters and Perpendicularity Capability, Accuracy and Stability - Processes, Machines, etc. 6
M Venture Capital Valuation Spreadsheet question Manufacturing and Related Processes 1
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
V Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted General Measurement Device and Calibration Topics 3
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
A Excel Spreadsheet Validation - Customer Audit Finding Other US Medical Device Regulations 2
V Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
P Calculating Process Capability from Data of attached spreadsheet Statistical Analysis Tools, Techniques and SPC 4
A How to create a Multiple Operations Specifications Comparison Spreadsheet? Excel .xls Spreadsheet Templates and Tools 3
6 Maintenance Spreadsheet to Monitor the Maintenance Process of a Fleet wanted IATF 16949 - Automotive Quality Systems Standard 7
H Is my MSA Study Spreadsheet okay to AIAG MSA Manual 4th Edition? Using Minitab Software 18
automoto Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
J ROI (Return on Investment) Excel Spreadsheet example Excel .xls Spreadsheet Templates and Tools 1
L OEM Customer Specific Requirements - Spreadsheet wanted Customer and Company Specific Requirements 14
P Measurement Uncertainty Calculations Spreadsheet help General Measurement Device and Calibration Topics 4
R Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
T Controlled Documents - Can a word document and excel spreadsheet be controlled? Document Control Systems, Procedures, Forms and Templates 5
K Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
K Seeking a sample spreadsheet - Inventory of items with 2 units Document Control Systems, Procedures, Forms and Templates 3
R Cpk & Ppk and Differences between Minitab and an Excel Spreadsheet Results Statistical Analysis Tools, Techniques and SPC 4
S Excel Spreadsheet Conditional Formatting help needed Excel .xls Spreadsheet Templates and Tools 12
J Excel Spreadsheet Validation for Calculating Data coming from our Instruments (LIMS) General Measurement Device and Calibration Topics 3

Similar threads

Top Bottom