WELCOME TO SHSE PERFORMANCE MONITORING TOOL

This is an interactive tool to boost your HSE reporting

CLICK HERE TO START

⚖️  HSE PMT is a SIMPLE excel tool to boost your HSE performance monitoring and trend
analysis.  📉📈📊

⚙️Features include;

• Easy Data Entry and Analysis

• Pivot Tables and Pivot Graphs
• Analyze Data on a Single Click
•  Analyze 20 plus KPIs on a Single Click
• Already Formatted TRIFR, LTIFR, ISR, and IR with Interpretations.
• V-lookup, Data Validation and advance excel functions integration
• Good Formatting and Precision
• Customized to include all the KPIs you need.

👉Your daily, weekly, monthly, quarterly and yearly HSE performance reports 📊📈📉 just
got easier and better, 📽 Developed by: Khuda Buksh Babar
HSE Officer
 

Contact address: k.buksh1985@gmail.com

https://hseprofessionalspakistan.blogspot.com/
# Table of Content
1 Source Data click here
2 Man days & hours click here
2 Kilometers & Miles Travelled click here
3 Lagging Indicators click here
4 Leading Indicators click here
5 Induction click here
6 JSA-Risk Assessment click here
7 Toolbox Talk by Months click here
8 Toolbox Talk by Company click here
9 Toolbox Talk Participation click here
10 Toolbox Talk Participation by Company click here
11 Permit to Work click here
12 Permit to Work Audit click here
13 Permit Validy Status click here
14 HSE Observation by Month click here
15 HSE Observation by Company click here
16 Workplace Inspection click here
17 Equipment Inspection click here
18 Safety Walkthroughs click here
19 Training click here
20 Training Particpation click here
21 Internal Audits click here
22 External Audits click here
23 Management Visits by Months click here
24 Management Visits by Company click here
25 HSE Meetings click here
26 Monthly Kilometers Travelled click here
31 Environmental Monitoring click here
32 Waste Generated click here
33 Utilities click here
34 Total Recordable Injury Frequency Rate click here
35 Lost Time Injury Frequency Rate click here
36 Incident Severity Rate click here
37 Incident Rate click here
38 Motor Vehicle Incident Rate click here
39 Motor Vehicle Incident Frequency Rate click here
Instructions
Delete all the data from the "source data" sheet and make your own entries
Always enter dates starting from the month/day/year e.g 7/14/17 for 14-Jul-17
Make sure your entries are all numeric e.g zero should be entered as 0, not -

Go to the menu bar at the top and locate "Data"

Click on Data and "Refresh All"

Click on any sheet located at the bottom of this excel book to view report

Click on manual filter to select items in the Pivot table except blank, < and >
NB: "Refresh All" automatically updates all your sheets in the excel book

Refresh All
ntries
4-Jul-17
not -

ort

nd >
k

Manual Filter
 Insert Logo HSE PERFORMANCE REPORT
Instruction

Ma
Wor
n
king Man Days
Da
hou Lost (days
Company Date Number of Staff ys Man Hours Worked
rs lost per
Wo
per LTI)
rke
day
d

Company A 1-Jan-17 17 10 1 170 -

Company B 2-Jan-17 19 10 1 190 -
Company C 3-Jan-17 22 10 1 220 -
Company D 4-Jan-17 28 10 1 280 -
Company A 5-Jan-17 22 10 1 220 -
Company B 6-Jan-17 22 10 1 220 -
Company C 7-Jan-17 24 10 1 240 -
Company D 8-Jan-17 26 10 1 260 -
Company A 9-Jan-17 27 10 1 270 -
Company B 10-Jan-17 34 10 1 340 -
Company B 26-Dec-17 19 10 1 190 -
Company C 27-Dec-17 5 10 1 50 -
Company D 28-Dec-17 28 10 1 280 -
Company A 29-Dec-17 27 10 1 270 -
Company B 30-Dec-17 26 10 1 260 -
Company C 31-Dec-17 30 10 1 300 -
Instructions Safety Lagging Indicators

Man
Man
Hours Lost Medical Damage
Hours Environme Motor First Aid Lost Time Restricted
from LTI Treated Fatal to
Worked ntal Vehicle Cases Injuries Work
(10 hrs Cases accidents Equipmen
without Impact Incidents (FAC) (LTI) Cases
per lost (MTC) t/Material
LTI incidents (RWC)
days)

- 170 - - - - - - - -
- 190 - - - - - - - -
- 220 - - - - - - - -
- 280 - 1 - - - - - -
- 220 - - - - - - - -
- 220 - - - - - - - -
- 240 - - - - - - - -
- 260 - - - - - - 1 -
- 270 - - 5 - - - - -
- 340 - - - - - - - -
- 190 - - - - - - - -
- 50 - - - - - - - -
- 280 - - - - - - - -
- 270 - - - - - - - -
- 260 - - - - - - - -
- 300 - - - - - - - -
 Total Toolbox Permit
Near Miss JSA/Risk Permits Permit
Recordable Toolbox Talk (PTW)
Incidents Assessment (PTW) (PTW)
Injuries Talks (TBT) Participatio nonconform
(NM) s Issued audits
(TRIs) ns ance

1 - 1 25 1 1 - -
- - 1 14 1 - - -
- - 1 34 - - - -
- - 2 21 1 - - -
- - 4 24 1 - - -
- - 2 19 1 - - -
- - 2 22 1 - - -
- 1 2 35 2 1 2 -
- - 4 28 3 - - -
- - 3 29 1 - - -
- - 4 40 1 - - -
- - 1 41 - - - -
- - 7 42 2 - - -
- - 5 42 - - - -
- - 4 43 - - - -
- - 4 43 - - - -
 Safety leading Indicators

Permit HSE Random

Permit Start Permit End Valid days
Validity Days left Permit status Observation Alcohol
Date Date left
Period s Test

1-Jan-17 7 8-Jan-17 -1884 expired - 5 -

4 -
1 -
3 -
8 -
1
4 -
7-Jan-17 7 14-Jan-17 -1878 expired - 9 -
2 -
2 -
- 1
- -
- -
1 -
- -
- -
ading Indicators

Safety Training
Workplace Equipment Emergency Safety
Inductions walkthrough Trainings Participatio
Inspections Inspections Drills Awards
s ns

- 1 1 1 - - - -
2 2 2 - - - - -
- 1 2 - - - - -
2 1 1 - - - - -
- 2 3 - 1 25 - -
- 3 4 - - - - -
- 2 2 - - - - -
1 1 1 1 - - - -
5 2 2 - - - - -
- 1 2 - - - 1 -
- 2 2 - 1 28 - -
- 1 2 - - - - -
2 1 1 1 - - - -
2 2 3 - - - - -
2 3 4 - - - - -
2 3 4 - - - - -
 Road Traffic Indicator

HSE Internal External Management No. of Distance

Manageme
Meetings Audits Audits Reviews Vehicles Travelled (Km)
nt Visits

- - - - - 50 102,971.00
- - 1 - - 50 87,493.00
- - - - - 50 96,157.00
- - - - - 50 115,000.00
1 - - 1 - 50 131,943.00
- - - - - 50 120,893.00
- - - - - 50 92,831.00
- 1 1 - 1 50 72,629.00
- - - - - 50 135,296.00
- 2 - - - 50 78,041.00
- - - - - 50 78,041.00
- - - - - 50 108,756.00
- 1 - - 1 50 73,248.00
1 - - 1 - 50 64,141.00
- - - 50 56,571.00
- - - 50 51,976.00
Road Traffic Indicators Enviro

Non- Hazardous
Distance Distance Hazardous
Motor Vehicle Distance from hazardous Liquid
Travelled Travelled Solid Waste
Incidents Accident(Km) Solid waste Waste
(miles) Safely(Km) (m3)
(m3) (litres)

102.9710 - - 102,971.00 - - -
87.4930 - - 87,493.00 - - -
96.1570 - - 96,157.00 - - -
115.0000 1 10.00 114,990.00 - - -
131.9430 - - 131,943.00 - - -
120.8930 - - 120,893.00 - - -
92.8310 - - 92,831.00 - - -
72.6290 - - 72,629.00 - - -
135.2960 - - 135,296.00 - - -
78.0410 - - 78,041.00 - 0.50 -
78.0410 - - 78,041.00 - - -
108.7560 - - 108,756.00 - - -
73.2480 - - 73,248.00 - - -
64.1410 - - 64,141.00 - - 0.67
56.5710 - - 56,571.00 - - -
51.9760 - - 51,976.00 - - -
 Environmental Indicators

Non-
Water Water
hazardous Sewage Scrap Air Quality Noise Fuel Used
Quality Used
liquid waste discharged Metals (m3) Monitoring Monitoring (litres)
Monitoring (litres)
(litres)

- - - - - - - -
- 1.00 - - - - - -
- - - - - - 2.50 -
- - - - 1 1 - -
- - - - - - 2.00 245.00
- - - - - - - -
- - - 1 - - - -
2.50 1.00 - - - - - 1.00
- - - - - - 60.20 -
2.00 - - - - - - -
- - - - - - - -
- - - - - - 60.20 -
1.00 - - - - - - 1.00
- - - 1 1 1 - -
- - - - - - -
- - - - - - -
 MAN HOURS AND MAN DAYS

Company (All)

Man hours & Man days

Average of Number of Staff 24
Sum of Man Days Worked 365
Sum of Man Hours Worked 89220
Sum of Man Hours Lost from LTI (10 hrs per lost days) 140
Sum of Man Hours Worked without LTI 89080
Sum of Man Days Lost (days lost per LTI) 14
MAN HOURS AND MAN DAYS

RETURN
Company (All)

Values
Average of No. of Vehicles 50
Sum of Distance Travelled (miles) 30,898.46
Sum of Distance Travelled (Km) 30,898,462.00
Sum of Distance from Accident(Km) 34.20
Sum of Distance Travelled Safely(Km) 30,898,427.80
RETURN
 LAGGING INDICATORS

Company (Multiple Items)

Lagging Indicators
Sum of Damage to Equipment/Material 1
Sum of Restricted Work Cases (RWC) 2
Sum of Environmental Impact incidents 3
Sum of Fatal accidents 4
Sum of Medical Treated Cases (MTC) 12
Sum of Lost Time Injuries (LTI) 14
Sum of First Aid Cases (FAC) 18
Sum of Motor Vehicle Incidents 16
Sum of Near Miss Incidents (NM) 21
LAGGING INDICATORS
 LAGGING INDICATORS

RETURN
 LEADING INDICACTORS

Company Company D

Leading Indicators
Sum of Toolbox Talks (TBT) 243
Sum of Management Visits 20
Sum of Random Alcohol Test 8
Sum of Safety Awards 11
Sum of Emergency Drills 2
Sum of External Audits 9
Sum of Workplace Inspections 140
Sum of Internal Audits 12
Sum of JSA/Risk Assessments 79
Sum of Equipment Inspections 183
Sum of Permits (PTW) Issued 12
Sum of HSE Observations 230
Sum of Inductions 108
Sum of Trainings 11
Sum of HSE Meetings 12
Sum of Management Reviews 8
Sum of Safety walkthroughs 17
LEADING INDICACTORS
 LEADING INDICACTORS

RETURN
 INDUCTION

Company (Multiple Items)

Row Labels Sum of HSE Observations

Jan 47
Feb 41
Mar 43
Apr 49
May 40
Jun 43
Jul 42
Aug 35
Sep 45
Oct 34
Nov 40
Dec 34
Grand Total 493
INDUCTION

RETURN
 INDUCTION

RETURN
 RISK ASSESSMENT

Company (All)

Row Labels Sum of JSA/Risk Assessments

Jan 29
Feb 27
Mar 30
Apr 30
May 32
Jun 27
Jul 29
Aug 30
Sep 28
Oct 33
Nov 29
Dec 27
Grand Total 351
RISK ASSESSMENT

RETURN
 TOOLBOX TALKS

Company (All)

Row Labels Sum of Toolbox Talks (TBT)

Jan 85
Feb 82
Mar 90
Apr 86
May 92
Jun 84
Jul 89
Aug 90
Sep 90
Oct 97
Nov 90
Dec 95
Grand Total 1070
TOOLBOX TALKS

RETURN
 TOOLBOX TALKS

RETURN
 TOOLBOX TALKS

Row Labels Sum of Toolbox Talks (TBT)

Company A 271
Company B 282
Company C 274
Company D 243
Grand Total 1070
TOOLBOX TALKS

RETURN
 TOOLBOX TALKS

TURN
 TOOLBOX TALK PARTICIPATION

Company (All)

Row Labels Sum of Toolbox Talk Participations

Jan 979
Feb 906
Mar 970
Apr 963
May 992
Jun 967
Jul 1004
Aug 1011
Sep 980
Oct 1023
Nov 988
Dec 1035
Grand Total 11817
TOOLBOX TALK PARTICIPATION
 TOOLBOX TALK PARTICIPATION

RETURN
 TOOLBOX TALK PARTICIPATION

Row Labels Sum of Toolbox Talk Participations

Company A 3032
Company B 2988
Company C 3070
Company D 2727
Grand Total 11817
TOOLBOX TALK PARTICIPATION

RETURN
 TOOLBOX TALK PARTICIPATION

TURN
 PERMIT TO WORK

Company (All)

Row Labels Sum of Permits (PTW) Issued

Jan 7
Feb 3
Mar 7
Apr 6
May 5
Jun 6
Jul 7
Grand Total 41
PERMIT TO WORK

RETURN
 PERMIT TO WORK

RETURN
 PERMIT TO WORK

Company (All)

Sum of Permit
Sum of Permits Sum of Permit
(PTW)
(PTW) Issued (PTW) audits
Row Labels nonconformance
Jan 7 11 1
Feb 3 5 1
Mar 7 8 1
Apr 6 7 0
May 5 5 0
Jun 6 6 0
Jul 7 10 2
Grand Total 41 52 5
PERMIT TO WORK
 PERMIT TO WORK

RETURN
 (Multiple
Company Items)

Sum of
Sum of Days Valid days
Row Labels left left
1/1/2017 -211 0
1/7/2017 -205 0
1/11/2017 -207 0
1/23/2017 -189 0
1/25/2017 -187 0
1/26/2017 -193 0
1/28/2017 -186 0
2/7/2017 -174 0
2/14/2017 -167 0
2/17/2017 -170 0
3/1/2017 -152 0
3/3/2017 -150 0
3/4/2017 -156 0
3/6/2017 -149 0
3/13/2017 -140 0
3/20/2017 -133 0
3/23/2017 -136 0
4/4/2017 -118 0
4/6/2017 -116 0
4/7/2017 -122 0
4/9/2017 -115 0
4/17/2017 -105 0
4/24/2017 -98 0
4/27/2017 -101 0
5/9/2017 -83 0
5/11/2017 -81 0
5/12/2017 -87 0
5/14/2017 -80 0
5/28/2017 -64 0
6/4/2017 -57 0
6/7/2017 -60 0
6/19/2017 -42 0
6/21/2017 -40 0
6/22/2017 -46 0
6/24/2017 -39 0
7/4/2017 -27 0
7/11/2017 -20 0
7/14/2017 -23 0
7/26/2017 -5 0
7/28/2017 -3 0
7/29/2017 -9 0
7/31/2017 -2 0
Grand Total -4448 0
RETURN
 HSE OBSERVATIONS

Company (All)

Month Sum of HSE Observations

Jan 85
Feb 75
Mar 86
Apr 88
May 84
Jun 78
Jul 83
Aug 81
Sep 86
Oct 78
Nov 75
Dec 76
Grand Total 975
HSE OBSERVATIONS

RETURN
 HSE OBSERVATIONS

Row Labels Sum of HSE Observations

Company A 281
Company B 252
Company C 212
Company D 230
Grand Total 975
HSE OBSERVATIONS

RETURN
Company (All)

Months Sum of Workplace Inspections

Jan 52
Feb 48
Mar 54
Apr 51
May 54
Jun 51
Jul 52
Aug 54
Sep 51
Oct 54
Nov 50
Dec 56
Grand Total 627
RETURN
RETURN
Company (All)

Row Labels Sum of Equipment Inspections

Jan 66
Feb 61
Mar 69
Apr 64
May 66
Jun 65
Jul 68
Aug 67
Sep 67
Oct 68
Nov 64
Dec 72
Grand Total 797
RETURN
Company (All)

Row Labels Sum of Safety walkthroughs

Jan 7
Feb 6
Mar 6
Apr 7
May 6
Jun 7
Jul 6
Aug 8
Sep 6
Oct 6
Nov 7
Dec 6
Grand Total 78
RETURN
 TRAINING

Row Labels Sum of Trainings

Jan 3
Feb 3
Mar 4
Apr 3
May 3
Jun 3
Jul 4
Aug 3
Sep 3
Oct 4
Nov 3
Dec 3
Grand Total 39
TRAINING

RETURN
 TRAINING

RETURN
 TRAINING PARTICIPATION

Row Labels Sum of Training Participations

Jan 66
Feb 66
Mar 91
Apr 66
May 66
Jun 66
Jul 79
Aug 66
Sep 66
Oct 94
Nov 66
Dec 66
Grand Total 858
TRAINING PARTICIPATION

RETURN
 INTERNAL AUDITS

Row Labels Sum of Internal Audits

Jan 5
Feb 4
Mar 4
Apr 5
May 4
Jun 4
Jul 5
Aug 4
Sep 4
Oct 5
Nov 4
Dec 4
Grand Total 52
INTERNAL AUDITS

RETURN
 EXTERNAL AUDITS

Row Labels Sum of External Audits

Jan 3
Feb 3
Mar 4
Apr 3
May 3
Jun 3
Jul 3
Aug 3
Sep 4
Oct 3
Nov 3
Dec 4
Grand Total 39
EXTERNAL AUDITS

RETURN
 MANAGEMENT VISITS

Row Labels Sum of Management Visits

Jan 7
Feb 7
Mar 7
Apr 8
May 9
Jun 7
Jul 7
Aug 9
Sep 8
Oct 7
Nov 8
Dec 7
Grand Total 91
MANAGEMENT VISITS

RETURN
 MANAGEMENT VISITS

Row Labels Sum of Management Visits

Company A 26
Company B 28
Company C 17
Company D 20
Grand Total 91
MANAGEMENT VISITS

RETURN
 MANAGEMENT VISITS

RETURN
 WEEKLY HSE MEETINGS

Row Labels Sum of HSE Meetings

Jan 3
Feb 2
Mar 3
Apr 3
May 3
Jun 3
Jul 3
Aug 2
Sep 3
Oct 3
Nov 2
Dec 3
Grand Total 33
WEEKLY HSE MEETINGS

RETURN
 WEEKLY HSE MEETINGS

RETURN
Company (All)

Row Labels Sum of Distance Travelled (Km)

Jan 3,082,507.00
Feb 2,088,494.00
Mar 3,006,288.00
Apr 2,020,089.00
May 2,552,957.00
Jun 2,979,536.00
Jul 2,348,539.00
Aug 2,819,360.00
Sep 2,271,256.00
Oct 2,527,323.00
Nov 3,149,516.00
Dec 2,052,597.00
Grand Total 30,898,462.00
RETURN
RETURN
 MANAGEMENT REVIEW

Row Labels Sum of Management Reviews

Jan 2
Feb 2
Mar 2
Apr 3
May 2
Jun 2
Jul 2
Aug 2
Sep 2
Oct 2
Nov 3
Dec 2
Grand Total 26
MANAGEMENT REVIEW

RETURN
Company (All)

Sum of Air Quality Sum of Water Quality

Row Labels Monitoring Sum of Noise Monitoring Monitoring
Jan 3 3 2
Feb 3 3 2
Mar 3 4 3
Apr 4 3 2
May 3 3 2
Jun 3 3 2
Jul 3 4 2
Aug 3 3 2
Sep 4 3 2
Oct 3 3 2
Nov 3 3 2
Dec 4 4 3
Grand Total 39 39 26
RETURN
Company (All)

Sum of Sum of
Non- Sum of Non- Sum of
Sum of Sum of hazardous Hazardous hazardous Hazardous
Scrap Sewage liquid Liquid Solid Solid
Metals discharge waste Waste waste Waste
Row Labels (m3) d (litres) (litres) (m3) (m3)
Jan 0 5 8.5 0.67 0.5 5.96
Feb 0 4 8.5 0.67 0.5 5.96
Mar 0 4 8.5 0.67 0.5 5.96
Apr 0 5 11 0.67 0.5 5.96
May 0 4 10.5 0.67 1 7.56
Jun 0 4 8.5 0.67 0.5 5.96
Jul 0 5 8.5 0.67 0.5 5.96
Aug 0 4 10.5 0.67 0.5 7.76
Sep 0 4 9.5 0.67 0.5 5.96
Oct 0 5 8.5 0.67 0.5 8.52
Nov 0 4 9.5 0.67 0.5 5.96
Dec 0 4 8.5 1.34 0.5 5.96
Grand Total 0 52 110.5 8.71 6.5 77.48
RETURN
RETURN
Company (All)

Row Labels Sum of Water Used (litres) Sum of Fuel Used (litres)
Jan 190.6 692
Feb 188.1 692
Mar 190.1 937
Apr 188.1 693
May 248.3 692
Jun 190.1 892
Jul 189.1 692
Aug 248.3 692
Sep 188.1 692
Oct 188.1 937
Nov 248.3 693
Dec 188.1 692
Grand Total 2445.3 8996
RETURN
RETURN
 ACCIDENT AND INCIDENT RATES

Total Recordable Injury Frequency Rate

Sum of Total Recordable Injuries (TRIs) 32
Sum of Man Hours Worked 89220

TRIFR: I.e. (All reportable Accidents X 200,000) / Total Man hours worked (Own +
Contract). TRIFR measures the number of recordable injury per 200,000 man hours = 71.7
worked over a define period. This result implies that ____ injuries will occur for every
200,000 manhours worked for the period under review

NB: Reportable accidents are incidents to be reported to the competent authority. These
are Medical Treated Cases, Fatalities, Restricted Work Cases and Lost Time Injuries
ACCIDENT AND INCIDENT RATES

RETURN
 ACCIDENT AND INCIDENT RATES

RETURN
 ACCIDENT AND INCIDENT RATES

Lost Time Injury Frequency Rate

Sum of Lost Time Injuries (LTI) 14
Sum of Man Hours Worked 89220

LTIFR: I.e. (LTI X 200,000) / Total Man hours worked (Own + Contract). LTIFR is the number
of LTIs for every 200,000 man hours worked for a given period. This result implies that ___
LTIs will be recorded for every 200,000 manhours worked for the period under review. = 31.38
ACCIDENT AND INCIDENT RATES

RETURN
 ACCIDENT AND INCIDENT RATES

Incident Severity Rate

Sum of Man Days Lost (days lost per LTI) 14
Sum of Lost Time Injuries (LTI) 14
Sum of Man Hours Worked 89220

ISR (Injury Severity Rate): I.e. (No. of Man Days Lost X 1,000) / Total Man hours worked (Own + Contract). Injury
Severity Rate is the man days lost per 1 thousand manhours worked. The result implies that for every 1000 man hours
worked ___man days will be lost from LTI

ISR (Injury Severity Rate): I.e. (No. of Man Days Lost / LTI). Injury Severity Rate is the average man days lost per LTI.
This implies that on the average each LTI will result in ___ days off work
 ACCIDENT AND INCIDENT RATES

RETURN

= 0.16

= 1
 ACCIDENT AND INCIDENT RATES

Incident Rate
Sum of Lost Time Injuries (LTI) 14
Average of Number of Staff 24

Incident Rate I.e. (Incident X 100) /Average workers employed). IR is the number of
injury per a standard number of employees (what ever figure you want eg. 100) for a
given period. The results implies that for every 100 employees, the company experiences = 57.27
___ incidents.
ACCIDENT AND INCIDENT RATES

RETURN
Company (All)

Values
Sum of Motor Vehicle Incidents 16
Sum of Distance Travelled (miles) 30,898.46

Motor Vehicle Incident Rate (MVIR) i.e. (No. of Motor Vehicle Incidents X 200,000 miles
/ Sum of Distance Travelled in Miles (Business Use Miles Driven). It is the number of = 103.56503
vehicle accidents for every 200,000 miles travelled for the period under review eg. 1 year
RETURN
Company (All)

Values
Average of No. of Vehicles 50
Sum of Motor Vehicle Incidents 16

Starting Date of Vehicle Use 1-Jan-17

Latest Date of Vehicle Use 31-Dec-17
Number of Months In Period Covered 12

Motor Vehicle Incident Frequency Rate (MTIFR) I.e. (No. of Vehicle = 46.08
Accidents X 12) / Number of Vehicles x Number of Months in Period
Covered). This measures how often motor vehicle incidents are occuring.
RETURN