9Annexes 9.1Spreadsheet for facilitating calculations of mercury releases on Inventory Level 2
-
To supplement this Toolkit, a separate Excel spreadsheet is available electronically, intended to facilitate the calculation of inputs and outputs of the different source categories. The spreadsheet is available on-line at the UNEP Chemicals mercury toolkit website http://www.unep.org/hazardoussubstances/Mercury/MercuryPublications/GuidanceTrainingMaterialToolkits/MercuryToolkit/tabid/4566/language/en-US/Default.aspx or can be obtained by contacting UNEP Chemicals at the address given on the inside cover of this document.
-
The Excel spreadsheet consists of a number of individual work sheets - first, a summary worksheet providing an overview of the main outputs for each category, thereafter, nine individual worksheets covering each source category.
-
Specific instructions on how to use the spreadsheet are available with the spreadsheet itself. It is extremely important that users read the Toolkit chapters carefully before using the spreadsheet, as it is not self-explanatory and there is a clear risk of making serious mistakes, if the user does not acquaint himself/herself with the methodology used and the proposed principles and data are not read and understood carefully. Also, before working with an individual source sub-category in the spreadsheet, the Toolkit section describing the source category must be studied first.
-
Chapter 5, which provides detailed descriptions of the various potential source categories of mercury releases, suggests default input and output factors for a number of sub-categories for use in cases where source specific data are not available. Default calculation formulas have been entered in the Excel spreadsheet for sub-categories where such default factors are suggested. Where default ranges are suggested, the maximum default factor is used in the calculation formula. As already emphasized throughout the Toolkit, well documented national or local input and output factors should always be preferred, if available. If this is the case, the input and output factors in the worksheets must be changed manually. Also, where no default factors have been suggested, users must enter the appropriate data and calculation formula applicable for the specific conditions under consideration.
-
The primary purpose of using these default factors is to get a first impression of whether the sub-category is a significant mercury release source in the country. Usually release estimates would have to be refined further (after calculation with default factors) before any far reaching action is taken based on the release estimates.
-
The actual spreadsheet with the individual source category worksheets is not reproduced in the Toolkit, however, for illustrative purposes Table 9 -238 and Table 9 -239 show two examples of individual worksheets for source categories 5.1 Extraction and use of fuels/energy sources and 5.5 Consumer products with intentional use of mercury. See the updated Inventory Level 2 spreadsheet at http://www.unep.org/hazardoussubstances/Mercury/MercuryPublications/GuidanceTrainingMaterialToolkits/MercuryToolkit/tabid/4566/language/en-US/Default.aspx.
-
When all the nine Excel worksheets for the different source categories have been filled in, a summary table is automatically generated to show the total releases from all categories. An example of a summary table is given in Table 9 -240.below, taken from the ACAP Arctic Mercury Release Inventory (ACAP, 2005). Note - the table in the example has been adapted to fit Danish conditions, and is outlined slightly differently from the spreadsheet table, and the source categories are not fully identical.
Table 9 238 Example of an Excel worksheet showing input and output data for releases to different media for category 5.1 Extraction and use of fuels/energy sources.
Table 9 239 Example of an Excel worksheet showing input and output data for releases to different media for category 5.5 Consumer products with intentional use of mercury.
Table 9 240 Reported mercury inputs and outputs to all media in Denmark, 2001; metric tons mercury/year. For details on estimation and uncertainties, see the questionnaire response in the appendix of the referenced document (ACAP, 2005).
|
New inputs to biosphere:
|
|
Reported releases/outputs to (means of ranges):
|
|
|
|
|
|
|
|
|
Means and sums are rounded
|
Range
|
Mean
|
Air
|
Water
|
Soil
|
Municipal waste
|
Haz /Med waste
|
Sector waste deposit *1
|
Waste water system
|
By-products
|
Sum, rep. releases (means)
|
Mobilisation of mercury impurities
|
|
|
|
|
|
|
|
|
|
|
|
Large coal combustion plants
|
0.6-1
|
0.8
|
0.3
|
0
|
0
|
0
|
0
|
0.1
|
0
|
0.3
|
0.7
|
Other coal combustion and use
|
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
Extraction and use of oil, gas and biofuels
|
0.06-0.33
|
0.2
|
0.06
|
0.06
|
0.003
|
0.006
|
0
|
0.01
|
0.002
|
0
|
0.1
|
Cement production
|
0.1-0.3
|
0.2
|
0.1
|
0
|
0
|
0
|
0
|
0.03
|
0
|
0.09
|
0.2
|
Other primary extraction and processing of materials
|
0.011-0.04
|
0.03
|
0
|
0
|
0.03
|
0
|
0
|
0
|
0
|
0
|
0.03
|
Sub-sum, mobilisation of mercury impurities
|
|
1.2
|
0.4
|
0.06
|
0.03
|
0.006
|
0
|
0.2
|
0.002
|
0.4
|
1.1
|
Intentional mercury use
|
|
|
|
|
|
|
|
|
|
|
|
Dental amalgam fillings
|
1.1-1.3
|
1.2
|
0.2
|
0
|
0.07
|
0.1
|
1.2
|
0
|
0.2
|
NR
|
1.8
|
Batteries
|
0.07-0.15
|
0.1
|
0
|
0
|
0
|
0.4
|
0.4
|
0
|
0
|
NR
|
0.8
|
Thermometers
|
0.016-0.024
|
0.02
|
0
|
0
|
0
|
0.03
|
0.1
|
0
|
0.03
|
NR
|
0.2
|
Manometers, blood pressure gauges and education
|
0.013-0.049
|
0.03
|
0.04
|
0
|
0
|
0.04
|
0.3
|
0
|
0.04
|
NR
|
0.4
|
Switches, relays and contacts
|
0-0.024
|
0.01
|
0
|
0
|
0
|
0.2
|
1.1
|
0
|
0
|
NR
|
1.3
|
Light sources
|
0.06-0.17
|
0.1
|
0.005
|
0
|
0
|
0.07
|
0.07
|
0
|
0
|
NR
|
0.1
|
Other products and processes
|
0.135-2.021
|
1.1
|
0
|
0
|
0
|
0.4
|
0.05
|
0.03
|
0.01
|
NR
|
0.5
|
Sub-sum, intentional mercury use
|
|
2.6
|
0.2
|
0
|
0.07
|
1.3
|
3.2
|
0.03
|
0.2
|
0
|
5.1
|
Waste treatment and waste water systems
|
|
|
|
|
|
|
|
|
|
|
|
Incineration of general/municipal waste
|
NR
|
NR
|
0.6
|
0
|
0
|
0
|
0
|
2.5
|
0
|
NR
|
3.1
|
Incineration of hazardous/medical waste
|
NR
|
NR
|
0.008
|
0.001
|
0
|
0
|
NR
|
0
|
0
|
NR
|
0.009
|
Landfills/deposits *3
|
NR
|
NR
|
NA
|
0
|
0
|
0.08
|
0
|
2.8
|
0.003
|
NR
|
2.9
|
Waste water systems
|
NR
|
NR
|
0.04
|
0.2
|
0.08
|
0
|
0
|
0.06
|
NR
|
NR
|
0.4
|
Recycling of other materials
|
NR
|
NR
|
0.04
|
0
|
0.04
|
0.005
|
0
|
0.2
|
0
|
0.9
|
1.2
|
Other waste treatment
|
NR
|
NR
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
Sub-sum, waste treatment and waste water systems *2
|
|
|
0.71
|
0.20
|
0.12
|
0.085
|
0.0
|
5.5
|
0.003
|
0.9
|
|
Notes:
*1: Sector specific waste deposits, is an "other controlled deposition" category, including for example special deposits for coal combustion residues in some countries and industry's own deposits (subject to authorities control).
*2: Note that doubling counting can not be ruled out in overall sums for waste treatment - depends on national practices and how data were reported in questionnaire responses. Therefore, these sums were not included in the table.
*3: The output figures from landfills/deposits to municipal waste and hazardous/medical waste describe the distribution on these two deposit types, and not mercury being physically moved from deposits to municipal or hazardous wastes.
*
- Reduce consumption
- Improve recycling/recovery
- Substitute product/processes
- “End-of-pipe » techniques
- Reduce consumption
- Use alternative raw materials
- “End-of-pipe” techniques
Re-mobilisation
of anthropo-
genic
Hg
Natural sources
and
Hg
impurities
in raw
materials
Human & natural
environment
Releases mostly beyond human control
Hg used
intentionally in products & processes
**
Division of Technology, Industry and Economics (DTIE)
Chemicals Branch
Geneva
Switzerland
April, 2013
Dostları ilə paylaş: |
