ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Environmnetal and Safety Reporting Calculation

•
•
Engr. Md.SHAFIQUL ISLAM, IDipOSH,Grad IOSH
Engr. Md.SHAFIQUL ISLAM, IDipOSH,Grad IOSH

This document is an HSE engineer's spreadsheet for tracking environmental, health, and safety data across multiple indicators on a monthly basis. It includes tables for tracking air emissions, fuel consumption, incidents, HSE metrics, water usage, production data, and vehicle kilometers. However, all values are currently empty, as this is intended to collect data monthly over the course of a year. Instructions are provided to input relevant data into the yellow cells of the "Data input" worksheet.

1 of 4
Downloaded 14 times
Prepared by HSE Engineer EHS Data Calculation Spreadsheet Air Emissions Indicator Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total CH4 tonnes - - - - - - - - - - - - - CO2 tonnes - - - - - - - - - - - - - CO2 Equivalent (CO2E) Greenhouse Gases tonnes - - - - - - - - - - - - - NOX tonnes - - - - - - - - - - - - - SOx tonnes - - - - - - - - - - - - - VOCs tonnes - - - - - - - - - - - - - N2O tonnes - - - - - - - - - - - - - Fuel Consumption Data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Diesel Generator tonnes - Natural Gas fired Engine tonnes - Natural Gas fired Heater tonnes - Sea Diesel tonnes - Land Diesel tonnes - Land Gasoline tonnes - Land CNG tonnes - Aviation Gas tonnes - Flaring - Gas Production tonnes - Venting - Gas Production tonnes - Elecrticity KWh - Incidents Data Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Fatality No. Lost time/Recordable Incident No. First Aid Case No. Hazards and Near Misses No. Environmnetal incident No. High Potential Nearmisses No. HSE data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Manhrs (Contractor) No. - Manhrs (Company) No. - Gr. water consumption M3 - Municipal water consumption M3 - Potable water consumption M3 - Hazardous waste generation tonnes - Non hazarodous waste generation tonnes - Vehcile km driven-contractor Km - Vehcile km driven-company Km - Sangu Ambient Air Quality Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total CO μg/M3 NOX μg/M3 SO2 μg/M3 SPM μg/M3 VOC Max mg/L VOC Min mg/L Sangu PW Characteristics Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Drained PW M3 - Discharged PW M3 - Chloride conc. (mg/L) TDS (mg/L) COD (mg/L) Average Oil Conc. (mg/L) Discharged Oil (ton) - PW Reinjected (M3) - Production Data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Condensate produce tonnes - Non associate Gas produce tonnes - Input only in the yellow cell of " Data input" worksheet ( as per your relevent). Please dont touch "Final Report" and "EMR" worksheet Conversion Table: 10 MMSCF Gas=23.95x10 tonnes; 10 m3 diesel=0.98x10 tonnes; 10 m3 gasoline-0.7x 10 tonnes; 10 m3 CNG=0.0008458X10 tonnes; 10 m3 condensate=0.855x10 tonnes; 10 kwh electricity=0.0036x10 GJ HSE Data Calculation Spreadsheet Last date of update 12 January 2011 Page 1
Prepared by HSE Engineer Sulphur Content (% wt) Natural Gas Composition (Vol%) Diesel 0.30 CH4 93.87 Natural Gas 0.00 CO2 0.99 Aviation Gas 0.00 NOx as N 1 Gasoline 0.10 VOCs 4.14 Data Provided by Cairn Bangladesh Data Obtained from Gas Chromatograph Analysis for Sangu Operations 9th July 2010 Atmospheric Emission from Fuel Emission Factor (tonnes per tonne) Gas (GJ) Diesel (GJ) Gasoline (GJ) Elecrticity (GJ) CNG (GJ) CH4 Diesel Generator (A) 0.00016 Jan-10 - - - - - CH4 Land Diesel Consumption (A) 0.00013 Feb-10 - - - - - CH4 Land CNG (B) 0.00004 Mar-10 - - - - - CH4 Flaring Gas Production(B) 0.00104 Apr-10 - - - - - CH4 Aviation Gas Consumption (A) 0.00014 May-10 - - - - - CO2 Diesel (A) 3.19 Jun-10 - - - - - CO2 Sea Diesel (A) 3.27 Jul-10 - - - - - CO2 Natural Gas Fired heater(A) 2.22 Aug-10 - - - - - CO2 Land gasoline (A) 3.35 Sep-10 - - - - - CO2 Flaring Gas Production(B) 1.65524 Oct-10 - - - - - CO2 Aviation Gas Consumption (A) 2.42 Nov-10 - - - - - NOx Default Emission Factor (B) 0.0594 Dec-10 - - - - - NOx Natural Gas fired engine (B) 0.0576 Total - - - - - NOx Natural Gas fired heater (B) 0.0024 NOx flaring gas production (B) 0.0012 SOx Default Emission Factor (c) 2 VOCs Natural Gas fired engine(B) 0.0032 VOCs Land CNG (B) 0.00001 VOCs Default Emission Factor (B) 0.002 N2O Natural Gas Fired Engine (A) 0.00006 N2O Natural Gas Fired Heater(A) 0.00004 N2O Land CNG (A) 0.000004 N2O Diesel Consumption (A) 0.00003 N2O Aviation Gas Consumption (A) 0.02838 NOTE A: API 2009 Emission Factors NOTE B: EEMS 2008 Emission Factors NOTE c: Existing Emission Factors based on Known Sulphur Content of Fuel HSE Data Calculation Spreadsheet Last date of update 12 January 2011 Page 2
Parameter SI Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 1 Incidents 1.1 Fatality No. - - - - - - - - - - - - - 1.2 Recordable Incident No. - - - - - - - - - - - - 1.3 First Aid Case No. - - - - - - - - - - - - 1.4 Environmnetal Incident No. - - - - - - - - - - - - 1.5 High Potential Near Miss No. - - - - - - - - - - - - 1.6 TRCFR No/mm manhrs 1.7 TRCSR No/mm manhrs - - - - - - - - - - - - - 1.8 Safety and Environmental Proactive reporting ratios - - - - - - - - - - - - - 2 Manhours exposure 2.1 Est. number of exposure hours, total hours - - - - - - - - - - - - - 2.2 Est. number of exposure hours -Contractor hours - - - - - - - - - - - - - 2.3 Est. number of exposure hours-Company hours - - - - - - - - - - - - - 3 Land & Water Discharges 3.1 Total Produce water m3 - - - - - - - - - - - - - 3.2 Produce water discharge to sea m3 - - - - - - - - - - - - - 3.3 Produce water Reinjected m3 - - - - - - - - - - - - - 3.4 Average oil in produced water (to surface environment) mg/l - - - - - - - - - - - - - 3.5 Oil discharged with produced water to sea tonnes - - - - - - - - - - - - - 3.6 Oil spillage> 100kg kg - - - - - - - - - - - - - 3.7 Hazardodus waste generated tonnes - - - - - - - - - - - - - 3.8 Non hazardous waste generated tonnes - - - - - - - - - - - - - 4 Atmospheric Discharges 4.1 Hydrocarbons to flare tonnes - - - - - - - - - - - - - 4.2 Residual hydrocarbons venting (purge, upsets, etc) tonnes - - - - - - - - - - - - - 4.3 CO2 emission tonnes - - - - - - - - - - - - - 4.4 CH4 emission tonnes - - - - - - - - - - - - - 4.5 VOC emission tonnes - - - - - - - - - - - - - 4.6 NOx emission tonnes - - - - - - - - - - - - - 4.7 N2O emission tonnes - - - - - - - - - - - - - 4.8 SOx emission tonnes - - - - - - - - - - - - - 4.9 GHG calculated in CO2 equiv. tonnes - - - - - - - - - - - - - 4.1 GHG from flaring tonnes - - - - - - - - - - - - - 4.11 GHG from power generation and processing tonnes - - - - - - - - - - - - - 4.12 GHG from transportation tonnes - - - - - - - - - - - - - 4.13 GHG from venting tonnes - - - - - - - - - - - - - 5 Energy Consumption 5.1 Gas Consumption GJ - - - - - - - - - - - - - 5.2 Diesel Consumption GJ - - - - - - - - - - - - - 5.3 Gaoline Consumption GJ - - - - - - - - - - - - - 5.4 Elecrticity GJ - - - - - - - - - - - - - 5.5 CNG GJ - - - - - - - - - - - - - 5.6 Total Energy Consumption GJ - - - - - - - - - - - - - 6 Water Consumption 6.1 Potable water m3 - - - - - - - - - - - - - 6.2 Gr. Water consumption m3 - - - - - - - - - - - - - 6.3 Municipal water consumption m3 - - - - - - - - - - - - - 7 Hydrocarbon Production 7.1 Hydrocarbon eq. Production tonnes - - - - - - - - - - - - - 8 Vehicle Movement 8.1 Vehicle Km driven-cont km - - - - - - - - - - - - - 8.2 Vehicle Km driven-company km - - - - - - - - - - - - - Final Report HSE Performance
No. Parameter SI Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average Target (Internal) Annual Limits (Regulatory) 1 t - - - - - - - - - - - - 2 Quantity M3 - - - - - - - - - - - - - 12,000 Oil content mg/L - - - - - - - - - - - - - 30 Chloride mg/L - - - - - - - - - - - - - COD mg/L - - - - - - - - - - - - - 500 TDS mg/L - - - - - - - - - - - - - 3 t - - - - - - - - - - - - - 20 4 Methane t - - - - - - - - - - - - - VOC t - - - - - - - - - - - - - 5 Methane t - - - - - - - - - - - - - VOC t - - - - - - - - - - - - - 6 Other emissions CO2 t - - - - - - - - - - - - - 24,000 NOx t - - - - - - - - - - - - - 260 SOx t - - - - - - - - - - - - - 2,500 CO μg/M 3 - - - - - - - - - - - - - 5,000 NOx μg/M 3 - - - - - - - - - - - - - 100 SO2 μg/M 3 - - - - - - - - - - - - - 120 SPM μg/M 3 - - - - - - - - - - - - - 500 VOC, Max mg/L - - - - - - - - - - - - - VOC Min. mg/L - - - - - - - - - - - - - 7 Ambient air quality Produced water discharged to sea Hazardous waste generated and disposed Environmnetal Monitoring Report Hydrocarbons emission from flaring Hydrocarbons emission from venting Hydrocarbons to flare

More Related Content

Environmnetal and Safety Reporting Calculation

  • 1. Prepared by HSE Engineer EHS Data Calculation Spreadsheet Air Emissions Indicator Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total CH4 tonnes - - - - - - - - - - - - - CO2 tonnes - - - - - - - - - - - - - CO2 Equivalent (CO2E) Greenhouse Gases tonnes - - - - - - - - - - - - - NOX tonnes - - - - - - - - - - - - - SOx tonnes - - - - - - - - - - - - - VOCs tonnes - - - - - - - - - - - - - N2O tonnes - - - - - - - - - - - - - Fuel Consumption Data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Diesel Generator tonnes - Natural Gas fired Engine tonnes - Natural Gas fired Heater tonnes - Sea Diesel tonnes - Land Diesel tonnes - Land Gasoline tonnes - Land CNG tonnes - Aviation Gas tonnes - Flaring - Gas Production tonnes - Venting - Gas Production tonnes - Elecrticity KWh - Incidents Data Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Fatality No. Lost time/Recordable Incident No. First Aid Case No. Hazards and Near Misses No. Environmnetal incident No. High Potential Nearmisses No. HSE data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Manhrs (Contractor) No. - Manhrs (Company) No. - Gr. water consumption M3 - Municipal water consumption M3 - Potable water consumption M3 - Hazardous waste generation tonnes - Non hazarodous waste generation tonnes - Vehcile km driven-contractor Km - Vehcile km driven-company Km - Sangu Ambient Air Quality Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total CO μg/M3 NOX μg/M3 SO2 μg/M3 SPM μg/M3 VOC Max mg/L VOC Min mg/L Sangu PW Characteristics Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Drained PW M3 - Discharged PW M3 - Chloride conc. (mg/L) TDS (mg/L) COD (mg/L) Average Oil Conc. (mg/L) Discharged Oil (ton) - PW Reinjected (M3) - Production Data Units Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Condensate produce tonnes - Non associate Gas produce tonnes - Input only in the yellow cell of " Data input" worksheet ( as per your relevent). Please dont touch "Final Report" and "EMR" worksheet Conversion Table: 10 MMSCF Gas=23.95x10 tonnes; 10 m3 diesel=0.98x10 tonnes; 10 m3 gasoline-0.7x 10 tonnes; 10 m3 CNG=0.0008458X10 tonnes; 10 m3 condensate=0.855x10 tonnes; 10 kwh electricity=0.0036x10 GJ HSE Data Calculation Spreadsheet Last date of update 12 January 2011 Page 1
  • 2. Prepared by HSE Engineer Sulphur Content (% wt) Natural Gas Composition (Vol%) Diesel 0.30 CH4 93.87 Natural Gas 0.00 CO2 0.99 Aviation Gas 0.00 NOx as N 1 Gasoline 0.10 VOCs 4.14 Data Provided by Cairn Bangladesh Data Obtained from Gas Chromatograph Analysis for Sangu Operations 9th July 2010 Atmospheric Emission from Fuel Emission Factor (tonnes per tonne) Gas (GJ) Diesel (GJ) Gasoline (GJ) Elecrticity (GJ) CNG (GJ) CH4 Diesel Generator (A) 0.00016 Jan-10 - - - - - CH4 Land Diesel Consumption (A) 0.00013 Feb-10 - - - - - CH4 Land CNG (B) 0.00004 Mar-10 - - - - - CH4 Flaring Gas Production(B) 0.00104 Apr-10 - - - - - CH4 Aviation Gas Consumption (A) 0.00014 May-10 - - - - - CO2 Diesel (A) 3.19 Jun-10 - - - - - CO2 Sea Diesel (A) 3.27 Jul-10 - - - - - CO2 Natural Gas Fired heater(A) 2.22 Aug-10 - - - - - CO2 Land gasoline (A) 3.35 Sep-10 - - - - - CO2 Flaring Gas Production(B) 1.65524 Oct-10 - - - - - CO2 Aviation Gas Consumption (A) 2.42 Nov-10 - - - - - NOx Default Emission Factor (B) 0.0594 Dec-10 - - - - - NOx Natural Gas fired engine (B) 0.0576 Total - - - - - NOx Natural Gas fired heater (B) 0.0024 NOx flaring gas production (B) 0.0012 SOx Default Emission Factor (c) 2 VOCs Natural Gas fired engine(B) 0.0032 VOCs Land CNG (B) 0.00001 VOCs Default Emission Factor (B) 0.002 N2O Natural Gas Fired Engine (A) 0.00006 N2O Natural Gas Fired Heater(A) 0.00004 N2O Land CNG (A) 0.000004 N2O Diesel Consumption (A) 0.00003 N2O Aviation Gas Consumption (A) 0.02838 NOTE A: API 2009 Emission Factors NOTE B: EEMS 2008 Emission Factors NOTE c: Existing Emission Factors based on Known Sulphur Content of Fuel HSE Data Calculation Spreadsheet Last date of update 12 January 2011 Page 2
  • 3. Parameter SI Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 1 Incidents 1.1 Fatality No. - - - - - - - - - - - - - 1.2 Recordable Incident No. - - - - - - - - - - - - 1.3 First Aid Case No. - - - - - - - - - - - - 1.4 Environmnetal Incident No. - - - - - - - - - - - - 1.5 High Potential Near Miss No. - - - - - - - - - - - - 1.6 TRCFR No/mm manhrs 1.7 TRCSR No/mm manhrs - - - - - - - - - - - - - 1.8 Safety and Environmental Proactive reporting ratios - - - - - - - - - - - - - 2 Manhours exposure 2.1 Est. number of exposure hours, total hours - - - - - - - - - - - - - 2.2 Est. number of exposure hours -Contractor hours - - - - - - - - - - - - - 2.3 Est. number of exposure hours-Company hours - - - - - - - - - - - - - 3 Land & Water Discharges 3.1 Total Produce water m3 - - - - - - - - - - - - - 3.2 Produce water discharge to sea m3 - - - - - - - - - - - - - 3.3 Produce water Reinjected m3 - - - - - - - - - - - - - 3.4 Average oil in produced water (to surface environment) mg/l - - - - - - - - - - - - - 3.5 Oil discharged with produced water to sea tonnes - - - - - - - - - - - - - 3.6 Oil spillage> 100kg kg - - - - - - - - - - - - - 3.7 Hazardodus waste generated tonnes - - - - - - - - - - - - - 3.8 Non hazardous waste generated tonnes - - - - - - - - - - - - - 4 Atmospheric Discharges 4.1 Hydrocarbons to flare tonnes - - - - - - - - - - - - - 4.2 Residual hydrocarbons venting (purge, upsets, etc) tonnes - - - - - - - - - - - - - 4.3 CO2 emission tonnes - - - - - - - - - - - - - 4.4 CH4 emission tonnes - - - - - - - - - - - - - 4.5 VOC emission tonnes - - - - - - - - - - - - - 4.6 NOx emission tonnes - - - - - - - - - - - - - 4.7 N2O emission tonnes - - - - - - - - - - - - - 4.8 SOx emission tonnes - - - - - - - - - - - - - 4.9 GHG calculated in CO2 equiv. tonnes - - - - - - - - - - - - - 4.1 GHG from flaring tonnes - - - - - - - - - - - - - 4.11 GHG from power generation and processing tonnes - - - - - - - - - - - - - 4.12 GHG from transportation tonnes - - - - - - - - - - - - - 4.13 GHG from venting tonnes - - - - - - - - - - - - - 5 Energy Consumption 5.1 Gas Consumption GJ - - - - - - - - - - - - - 5.2 Diesel Consumption GJ - - - - - - - - - - - - - 5.3 Gaoline Consumption GJ - - - - - - - - - - - - - 5.4 Elecrticity GJ - - - - - - - - - - - - - 5.5 CNG GJ - - - - - - - - - - - - - 5.6 Total Energy Consumption GJ - - - - - - - - - - - - - 6 Water Consumption 6.1 Potable water m3 - - - - - - - - - - - - - 6.2 Gr. Water consumption m3 - - - - - - - - - - - - - 6.3 Municipal water consumption m3 - - - - - - - - - - - - - 7 Hydrocarbon Production 7.1 Hydrocarbon eq. Production tonnes - - - - - - - - - - - - - 8 Vehicle Movement 8.1 Vehicle Km driven-cont km - - - - - - - - - - - - - 8.2 Vehicle Km driven-company km - - - - - - - - - - - - - Final Report HSE Performance
  • 4. No. Parameter SI Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average Target (Internal) Annual Limits (Regulatory) 1 t - - - - - - - - - - - - 2 Quantity M3 - - - - - - - - - - - - - 12,000 Oil content mg/L - - - - - - - - - - - - - 30 Chloride mg/L - - - - - - - - - - - - - COD mg/L - - - - - - - - - - - - - 500 TDS mg/L - - - - - - - - - - - - - 3 t - - - - - - - - - - - - - 20 4 Methane t - - - - - - - - - - - - - VOC t - - - - - - - - - - - - - 5 Methane t - - - - - - - - - - - - - VOC t - - - - - - - - - - - - - 6 Other emissions CO2 t - - - - - - - - - - - - - 24,000 NOx t - - - - - - - - - - - - - 260 SOx t - - - - - - - - - - - - - 2,500 CO μg/M 3 - - - - - - - - - - - - - 5,000 NOx μg/M 3 - - - - - - - - - - - - - 100 SO2 μg/M 3 - - - - - - - - - - - - - 120 SPM μg/M 3 - - - - - - - - - - - - - 500 VOC, Max mg/L - - - - - - - - - - - - - VOC Min. mg/L - - - - - - - - - - - - - 7 Ambient air quality Produced water discharged to sea Hazardous waste generated and disposed Environmnetal Monitoring Report Hydrocarbons emission from flaring Hydrocarbons emission from venting Hydrocarbons to flare