Populating summary table

[andrew aitken]

I want to be able to look up in the Risk assessment table which is about 250 lines and includes about 30 Group Hazards. I want to be able to create an automatic summary table when a comment is added after the "potential consequence" the entry in the comments will always lead to an assessment that is populated manually. as you can see 1 group of hazard can have several Origins with specific consequences. I have also attached my Summary sheet at the end

Risk Assessment

Type or group of hazard

Origin

Potential consequences

Comments

Initial assessment

Action required

Re-assessment after taking action

Action required

LO

FE

DPH

NP

HRN

Risk level

LO

FE

DPH

NP

HRN

Risk level

Mechanical hazards

Acceleration/deceleration

Being run over

N/A

0

Insignificant

2

2

2

1

8

Low, significant

Being thrown

N/A

0

Insignificant

0

Insignificant

Crushing

N/A

0

Insignificant

0

Insignificant

Cutting or severing

N/A

0

Insignificant

0

Insignificant

Drawing-in or trapping

N/A

0

Insignificant

0

Insignificant

Entanglement

N/A

0

Insignificant

0

Insignificant

Friction or abrasion

when using hand held grinding or sanding equipment

3

5

5

1

75

High

Wear Correct PPE

2

2

1

1

4

Insignificant

Impact

N/A

0

Insignificant

0

Insignificant

Injection

N/A

0

Insignificant

0

Insignificant

Shearing

N/A

0

Insignificant

0

Insignificant

Slipping, tripping or falling

N/A

0

Insignificant

0

Insignificant

Stabbing or puncturing

N/A

0

Insignificant

0

Insignificant

Suffocation

N/A

0

Insignificant

0

Insignificant

Kinetic energy

Being run over

N/A

0

Insignificant

0

Insignificant

Being thrown

N/A

0

Insignificant

0

Insignificant

Crushing

Rotating cable reel (approx 5kg, card or plastic flanges, no sharp edges) could become detached.

1

5

0.5

1

2.5

Insignificant

None

0

Insignificant

Cutting or severing

N/A

0

Insignificant

0

Insignificant

Drawing-in or trapping

N/A

0

Insignificant

0

Insignificant

Entanglement

N/A

0

Insignificant

0

Insignificant

Friction or abrasion

N/A

0

Insignificant

0

Insignificant

Impact

N/A

0

Insignificant

0

Insignificant

Injection

metal splinters created during cutting operation

3

5

3

3

135

High

Wear Correct PPE

2

2

1

2

8

Low, significant

Shearing

N/A

0

Insignificant

0

Insignificant

Slipping, tripping or falling

N/A

0

Insignificant

0

Insignificant

Stabbing or puncturing

N/A

0

Insignificant

0

Insignificant

Suffocation

N/A

0

Insignificant

0

Insignificant

Angular parts

Being run over

N/A

0

Insignificant

0

Insignificant

Being thrown

N/A

0

Insignificant

0

Insignificant

Crushing

N/A

0

Insignificant

0

Insignificant

Cutting or severing

N/A

0

Insignificant

0

Insignificant

Drawing-in or trapping

N/A

0

Insignificant

0

Insignificant

Entanglement

N/A

0

Insignificant

0

Insignificant

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Summary Table

	Hazard Type Or Group	Origin/Task or Event Section	Initial Assessment Hazard Risk Number (HRN)	Action Required	Re-Assessment Hazard Risk Number (HRN)	Action required:

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Smitty]

Welcome to the Board!

If you fill in all of the "Type or group of hazard" rows, you can probably summarize with a pivot table. Just note that you'll need to do something to consolidate your current rows 1 & 2 as a pivot table will only see the first row as the header and all others will be seen as data.

HTH,