WORKSHOP 2: Community-level inventory using proxy data
Rationale: The workshop aims to introduce to the participants the Excel quantification spreadsheet of the GHG Inventory Toolkit and develop appreciation
for activity data needed for the Community-level GHG inventory.
Reminder: Please enable Macro in your computer
General Info
Click Row 10 and
Row choose 2015 from the
9 Name of Community San Juan drop-down menu
10 GHG Inventory Year 2015
11 Reporting Date
12 Population (year round resident) 500,000
13 Land Area (sq. kilometre) 100,000
14 Urbanized area 50,000
Stationary Combustion-Residential Data
Row C D E F
Total Population in District Total Number of Residential Households in Number of Households Surveyed (enter "N/A" if
7 District/ Barangay
or Barangay District/Barangay (enter "N/A" if no survey data) no data)
8 San Juan 500000 N/A N/A
Reminder: Please click Update at Row 13 Column F
Row C D E F G H I
District/ Barangay Data Source Identifier Type of Data Application Fuel Type Annual Consumption Units
16 San Juan LPG Retailer Fuel supplier cooking Propane/Liquid Petroleum Gas 1,000,000 kg
17 San Juan Gas Station Fuel supplier generator Blended-Gasoline Res/Comml 100,000 liter
1
Stationary Combustion -Commercial Data
Row C D E F G H I
District/ Data Source Identifier Type of Data Application Fuel Type Annual Consumption Units
Barangay
16 San Juan LPG Retailer Fuel supplier cooking Propane/Liquid Petroleum Gas 2,000,000 kg
17 San Juan Gas Station Fuel supplier generator Blended-Gasoline l (Res/ Comm) 300,000 liter
Mobile Combustion –Community – All Data (Fuel Based-Method)
Row B C D E F G H I J
District/ Data Source Type of Data Fuel Type Annual Consumption Amt of fuel for Annual fuel
Barangay Identifier (liters) Stat Combustion consumed
15 San Juan Gas station Fuel supplier Gasoline/Petrol 600,000 600,000
16 San Juan Gas Station Fuel supplier On-Road Diesel Fuel 700,000 700,000
Elec-Residential Data
Row B C D E F G
District/ Data Source Identifier Type of Data Actual Electricity Estimated Consumption Units (e.g. kWh/household)
Barangay Consumed (kWh)
15 San Juan Utility Provider Electricity Utility provider 2,000,000 N/A kWh
Elec-Commercial Data
Row B C D E F G
District/ Data Source Identifier Type of Data Actual Electricity Estimated Consumption Units (e.g. kWh/household)
Barangay Consumed (kWh)
15 San Juan Utility Provider Electricity Utility provider 3,000,000 N/A kWh
Elec-Other Data (i.e. street lights, public buildings)
Row B C D E F G
District/ Data Source Identifier Type of Data Actual Electricity Estimated Consumption Units (e.g. kWh/household)
Barangay Consumed (kWh)
15 San Juan Utility Provider Electricity Utility provider 500,000 N/A kWh
Agriculture-Crops Data
2
Row C D E F G
Representative Sample of
District or Total Population in District Total Hectares under Crop Hectares Represented by Sampling
Hectares Under Agricultural
Barangay or Barangay Production (hectares, ha) (enter "N/A" if no survey data)
Management
8 San Juan 500,000 2,500 N/A N/A
Row C D E F G
District/
Data Source Identifier Type of Data Application Total Hectares
Barangay
15 San Juan Agriculture-Bureau-crop Data from government agricultural agency Rice (Dry season, irrigated) 500
16 San Juan Agriculture-Bureau-crop Data from government agricultural agency Rice (Dry season, rainfed) 1,000
17 San Juan Agriculture-Bureau-crop Data from government agricultural agency Rice (wet season, irrigated) 500
18 San Juan Agriculture-Bureau-crop Data from government agricultural agency Rice (wet season, rainfed) 1,000
19 San Juan Agriculture-Bureau-crop Data from government agricultural agency Crop Residues 1,000
Agriculture-Livestock Data
Row C D E F G
District or Total Population in Total Livestock Headcount Represented in Survey Data Representative Sample of Hectares Under
Barangay District or Barangay (headcount) (enter "N/A" if survey data not used) Agricultural Management
8 San Juan 500,000 312,000 N/A N/A
Row C D E F G
District/
Data Source Identifier Type of Data Application Total Head count
Barangay
15 San Juan Agriculture-Bureau-livestock Data from government agricultural agency Buffalo 500
16 San Juan Agriculture-Bureau-livestock Data from government agricultural agency Poultry 300,000
17 San Juan Agriculture-Bureau-livestock Data from government agricultural agency Swine 10,000
18 San Juan Agriculture-Bureau-livestock Data from government agricultural agency Goat 1,000
19 San Juan Agriculture-Bureau-livestock Data from government agricultural agency Horse 500
Solid Waste-Parameters -IPCC-FOD
3
B C D E
Row IPCC default value User-defined
9 Starting year 1950 1965
Note: Copy DEFAULT VALUES (Column D) to USER-DEFINED (Columns E) starting from Row 12 to Row 44. Use the copy /paste value
function of the Excel if preferred.
Solid Waste-MCF-IPCC-FOD
B C D E F G
Row Unmanaged, shallow Unmanaged, deep Managed Managed, semi-aerobic Uncategorised
MCF MCF MCF MCF MCF
13 User-defined Values Philippines .5 0 0 .4 .1
Solid Waste-Activity-IPCC-FOD
Row B C D F H J L N
Year Population Waste per capita Waste Diversion (Destination) Rates (%) and Amounts (tonnes)
(tonnes/capita/yr) % to Solid Waste % MSW % MSW sent to % Open % Total Others/
Disposal Site (SWDS) composted Anaerobic Digestion Burned Unspecified
10 IPCC Default Values .19 50% 0% 0% 0% 37%
11 1965 400000
400000
51 2005 400000
52 2006 500000
500000
61 2015 500000
Note: Default values are provided for Waste Composition (Columns P to AD)
4
Solid Waste-Other Methods-ICLEI
Row B C D E F G H I J
Source Total Waste/ Total Solid Total Solid Waste Fraction of Solid Fraction of Fraction of Fraction of
Identifier Population capita Waste for (Actual) for Waste sent to Solid Waste Solid Waste Solid Waste
District/ District/Barangay Composting sent to sent to Open Others/
Barangay Anaerobic Burning Unspecified
(Estimated) Digestion
10 WACS 500000 .19 10% 0% 0% 3%
Wastewater –Data-Scope 1
Row C D
LGU Total Population in LGU
8 San Juan 500000
Row Is it used in the % of population
Data Needed Examples
LGU (Yes or No) using the system
12 Septic Yes 80%
13 1 Wastewat
dry climate, ground water table lower than latrine, small family (2-5 people)
er Open- No
14 systems pits/ dry climate, ground water table lower than latrine, communal No
15 or types Latrines wet climate/flush water use, ground water table than latrine Yes 15%
16 in LGU regular sediment removal for fertilizer No
17 River Stagnant oxygen deficient rivers and lakes No
18 Discharg
Rivers, lakes and estuaries
e Yes 5%
19 River Discharge- Stagnant oxygen deficient drivers and lakes
20 River Discharge - Rivers, lakes and estuaries No
Untreat
21 Sewers (closed and underground) No
ed
22 Open sewers No
23 Treated Aerobic –centralized and well managed No
24 Aerobic – not well managed No
25 Sludge anaerobic treatment No
26 Aerobic shallow ponds No
5
27 Anaerobic lagoons – shallow, (less than 2 meters) No
28 Anaerobic lagoons – shallow, (more than 2 meters) No
29 Anaerobic reactors No
Forestry Parameters
Row B C D
Default Value (tons/ha) User-Defined (tons/ha)
9 Biomass Density in Remaining Forestlands 262 Copy Default Values
(Use copy/paste value function of Excel
51 Construction if preferred)
Forest Emission Data
Row C D E F G H I
District/ Data Source Sources of Annual Total
Type of Data Emission Type Units
Barangay Identifier Emissions Consumption
16 San Juan Forest Land-Use Census Averages Changes in the Use of Forests Used for
100 Hectares
agriculture
17 San Juan Wood harvesting Census Averages Wood and wood product harvesting Fuel wood 500 Tons
18 San Juan Wood harvesting Census Averages Wood and wood product harvesting Construction 1000 Cubic meters
Forest Removal Data
Row C D E F G H I
District/ Data Source Annual Total
Type of Data Removal Type Sources of Removal Units
Barangay Identifier Removal
16 San Juan Forest Land-Use Census Averages Remaining forest land Secondary Growth 500 Hectares
17 San Juan Forest Land-Use Census Averages Land Use Change Cropland to forest land 100 Hectares
Industrial Processes Data
Row C D E F G H I
District/ Data Source Industry Type Operation Production Unit
Type of Data
Barangay Identifier
16 San Juan Business Permit Industrial Business Survey Mineral Industry Cement Production - Portland 1,000 tons