Energy Emissions

Running the program is simple. It works as an Excel spreadsheet with macros written in Visual Basic. It can be downloaded from the Internet and installed in any directory after being unzipped. The macros must be activated.

1. Program Installation

Transfer the benemis_e program from the CD to any archive or run it directly from the CD.

On the Program’s Cover shown in Figure A1.1 it is possible to choose the languague options (English or Portuguese), go to the Program’s Map or go directly to the three Emissions options – by Year, by Energy Source or by Account, as well as to opt for excluding or not CO2 from biomass.

Figure A1.1 : benemis_e Program’s Cover

The Program’s Map allows for initiating and calculating the program, going directecly to one of the three Emission options – by Year, by Energy Source or by Account as well as accessing the different tables and graphics for each option regarding emissions, as shown in Figure A1.2.

Figure A1.2: benemis-e Program’s Map

2. Cover

· Choose the version in the desired language (English/Portuguese)

· Choose the exclusion or not of CO₂ from biomass

· Start and calculate. This is necessary only when the desired language is changed, when the CO2 exclusion or not is changed or when there is any doubt or mistake regarding changes in the selected data during the execution of the program.

Obs.: Changing the language, excluding or not CO2 from biomass and the subsequent calculation can be carried out in each specific spreadsheet.

· Click on Program’s Map or Emissions by Year, Emissions by Energy Source or Emissions by Account.

2.1 Program’s Map

· Click on one the Emission options (Emissions by Year/Emissions by Energy Source/Emissions by Account) or

· Click on any other desired option (yellow or mustard)

2.2 Emissions by Year

It shows the emission for the chosen year and gas. It also includes the Energy option that produces data from BEN/MME.

This option has the following windows:

a) Year: from 1970 to 2001;

b) Gas: CO₂, CO, CH₄, N₂O, NO_x, NMVOCS, as well as Energy;

· Select the desired year and gas (or Energy) in the appropriate window.

The Program produces the corresponding tables and graphics. Tables can be: Table/Summary, Table of Selected Data e Tables of Transformatio. Graphics can be: Graphic by Sector, Graphic by Activity and Graphic of Transformation.

· Click on graphics and/or tables of interest, namely:

2.2.1 Tables/Summary by Sector or by Activity: Emissions of the selected gas and year for:

Group of Fuels: NG, NG and Petroleum products, Nuclear, Mineral Coal and products, Biomass and Other Renweable and Total.

Obs. Nuclear is given only in the Energy option.

Sectors: Transformation, Non-energy Final Consumption, Energy Sector, Residential, Commercial, Public, Agriculture and Husbandry, Transport (total), Final Consumption (excludes transformation) and General Total.

Activities: Final Consumption, Non-energy Consumption,Energy Sector, Residential, Commercial, Public, Agriculture and Husbandry, Road, Rail, Aviation, Navigation, Cement, Pig iron and steel, Food and Beverage, Textile, Paper and Cellulose, Ceramics, Other Industries, Non-identified Consumption and Adjustments.

2.2.2 Tables of Selected Data by Sector, by Activity: Emissions of the selected gas and year for:

Group of Fuels: All energy sources of the Consolidated Energy Balance responsible for the emissions.

Sectors: Transformation, Final Consumption, Energy Sector, Residential, Commercial, Public, Agriculture and Husbandry, Transport (total), Non-energy Final Consumption, Final Use (excludes transformation) and General Total.

Activities: Final Consumption, Energy Sector, Residential, Commercial, Public, Agriculture and Husbandry, Road, Rail, Aviation, Navigation, Cement, Pig iron and steel, Mining and Pelleting, Non-Fer. And other Metals, Chemistry, Food and Beverage, Textile, Paper and Cellulose, Ceramics, Other Industries and Adjustements.

Obs.: Data relative to final.consumption

2.2.3 Tables of Transformations: Emissions of the selected gas and year for:

Group of Fuels: All energy sources of the Consolidated Energy Balance responsible for the emissions.

Installations: Transformation (Total), Petroleum Refineries, Natural Gas Plants, Gasification Plants, Charcoal Plants, Public Service Electric Power Plant, Auto-producers Electric Power Plants, Distilleries, Other Transformantions, Losses in Distribution and Storage.

2.2.4 Complete Tables :

Energy: Consumption for all accounts and all energy sources of the Consolidated Energy Balance for the selected gas and year.

Emissions: Emissions in all accounts and all energy sources of the Consolidated Energy Balance for the selected gas and year.

Obs.: Not valid if the option is Energy.

Coefficients: Emission coefficients for all accounts and all energy sources of the Consolidated Energy Balance for the selected gas and year.

Obs: Not valid if the option is Energy.

Obs.: The Freeze Pannel option fixes column A and slides the other columns through the appropriate clicking.

2.2.5 Graphic by Sector: Emissions by sector for Nuclear, Biomass, NG, Petroleum and Natural Gas Products, Mineral Coal and Products.

Obs.: Nuclear is valid only for the Energy options.

2.2.6 Graphic by Activity: Emissions in final consumption, for all account and all energy sources of the Consolidated Energy Balance for the selected gas and year.

2.2.7 Graphic of Transformation: Emissions for the pertinent installations and their specific energy source for the selected gas and year.

Obs.: Clicking on any graphic one gets one spreadsheet containing only the graphic. In order to go back to the previous spreadsheet, click on Return that appears on the top right.

2.3 Emissions by Energy Source

It shows the emissions for the chosen energy source and gas. It also includes the Energy option that produces data from BEN/MME.

This option has the following windows:

a) Energy Source: all sources contained in the Consolidated Energy Balance;

b) Gas: CO₂, CO, CH₄, N₂O, NO_x, NMVOCS, as well as Energy;

c) Cut: percent of the average annual total (for each year) below which the energy source does not appear individually but is included in the Others heading;

d) Type of graphic: lines, lines and points, area and 100% area;

e) Selection of the interval years: interval of years (between 1970 and 2001) for which the calculation and representation of emissions is desired;

· Select the energy source, the gas (or Energy) and the cut value, the type of graphic and the interval years.

· Click on the interested graphics and/or tables, namely:

2.3.1 Tables / Summary by Sector or by Activity: Emissions of the selected gas and
energy source in the specified years for:

Sector: Transformation, Non-energy Final Consumption, Residential, Commercial, Public, Agriculture and Husbandry, Transport, Industrial (total), General Total and Outher Sectors (those below the cut percent, if it is the case);

Activity: Transformation, Public Service Electric Power Plants, Auto-producers Electric Power Plants, Final Consumption, Residential, Commercial, Agriculture and Husbandry, Road, Rail, Aviation, Navigation, Cement, Pig iron and steel, Mining and Pelleting, Non-ferrous and other metals, Chemistry, Paper and Cellulose, Ceramics, Other Industries, Total General and Other Sectors (those below the cut percent, if it is the case);

Obs.: Data relative to Final Consumption plus Transformation.

Specific years: Eight specific years from 1970 to 2001 for which the gas emissions for the chosen energy source are desired (these values may be modified in the Table/Summary option Sector – they are taken into account in the Activity option as well – and when they are, it is necessary to click on calculate in order to obtain the desired result);

2.3.2 Tables Selected Data by Sector or by Activity: Emissions for the chosen gas and energy source in the selected year interval by:

Sector: Transformation, Residential, Commercial, Public, Agriculture and Husbandry, Industrial (total) and General Total;

Activity: Public Service Electrict Power Plants, Auto-Producers Electric Power Plants, Non-energy Final Consumption, Energy Sector, Residential, Agriculture and Husbandry, Cement, Pig iron and Steel, Mining and Pelleting, Non-ferrous and other metal, Chemistry, Textile, Paper and Cellulose, Ceramics, Other Ind., Total General and Other Sectors (those whose percent value are below the cut value, whenever the case);

Obs.: Data relative to Final Consumption plus Transformation.

2.3.3 Table of Complete Data: Emissions of the selected gas and energy source for all accounts of the Consolidated Energy Balance and all years (1970 to 2001).

2.3.4 Graphic of Selected Data by Sector: Emissions for Transformation, Non-energy Consumption, Energy Sector, Residential, Commercial, Public, Agriculture and Husbandry, Transport and Industrial (total) sectors for the selected years interval;

2.3.5 Graphic of Selected Data by Activity: Emissions of the Public Service Electric Power Plants, Auto-producers Electric Power Plants, Energy Sector, Residential, Agriculture and Husbandry, Road, Aviation, Raliway, Navigation, Cement, Pig iron and Steel, Mining and Pelleting, Non-ferrous and other metals, Chemistry, Paper and Cellulose, Ceramics, Other Ind and Other Sectors (those whose percent value are below the cut value, whenever the case) activities for the years interval chosen.

2.3.6 Graphic of Complete Data by Sector: Emission of the Residential, Commercial, Public, Agriculture and Husbandry, Energy, Transformation (total), Industrial (total) and Transport (total) sectors, for all years;

2.3.7 Graphic of Complete Data by Activity: Emissions of the Residential, Commercial, Public, Agriculture, Cement, Pig iron and Steel, Ferroalloys, Mining and Pelleting, Non-ferrous and other metals, Chemistry, Textile, Paper and Cellulose, Ceramics, Other Ind. activities, for all years.

Obs. 1: If the cut value is modified later, click on OK.

Obs. 2 :If you click on any graphic the program goes to a spreadsheet that contains only the graphic in question. In order to return to the previous spreadsheet click on Return that appears on the top right.

2.4 Emissions by Account

It shows the emissions for the selected account and year. It was also included the Energy option which shows BEN/MME data.

This option has the following windows:

a) Accounts: all accounts that are included in the Consolidated Energy Balance;

b) Gas: CO₂, CO, CH₄, N₂O, NO_x, NMVOCS, as well as Energy;

c) Cut: percent of the total annual average value (for each year) below which the energy source is not specified but it is incorporated in Other;

d) Type of graphic: lines, lines and points, area and 100% area;

e) Selection of the years interval: years intervals (between 1970 and 2001) for which it is desired the emissions calculation;

· Select the energy source, the gas and the cut value, the type of graphic and the year interval.

· Click on graphics and/or tables of interest, namely:

2.4.1 Table / Summary by Primary Energy: Emissions of the selected gas for the selected account for electricity or the pertinent primary energy of origin, for the eight years specified in the Table/Summary;

Obs.: Electricity was included in order to accomodate the energy tables.

2.4.2 Table / Summary by Energy Source: Emissions of the selected gas for the selected account for the pertinent energy sources, for the eight years specified in the Table/Summary;

2.4.3 Table of Selected Data by Primary Energy: Emissions of the selected gas for the selected account for electricity or the pertinent primary energy of origin, for the chosen years interval;

2.4.4 Table of Selected Data by Energy Source: Emissions of the selected gas for the selected account for the pertinent energy sources for the chosen year interval;

2.4.5 Table of Complete Data: Emissions of the selected gas for the selected account and all energy sources for all years (from1970 to 2001);

2.4.6 Graphic by Primary Energy: Emissions of the chosen gas for the selected account for electricity or the pertinent primary energy of origin, for the chosen year interval;

Beside this graphic there is a window that permits to get:

   2.4.7 Graphic of Selected Data: Emissions of the selected gas for the selected account for
   the pertinent primary energy of origin for the chosen year interval;

   2.4.8 Graphic of Complete Data (in order to obtain it just click on Graphic of Selected
   Data): Emissions of the selected gas for the selected account for all years (from 1970 to
   2001).

2.4.9 Graphic by Energy Source: Emissions of the selected gas for the selected account for the chosen years interval;

Obs 1: If the cut value is modified click on OK.

Graphic Edition/Edição Gráfica:
MAK
Editoração Eletrônica

Revised/Revisado:
Tuesday, 11 November 2008.

Contador de visitas