ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Instructions: Spreadsheet for Community-Level Greenhouse Gas (GHG) Inventory Quantification in the Philippines
3
4
This GHG Inventory Quantification Support Spreadsheet is a tool created to assist local government units (LGU) in the quantification of greenhouse gas (GHG) emissions at the community-level.
5
To use this tool, follow the instructions on each tab. Input values required from the user are entered in the yellow cells located on the yellow tabs. Once the activity data and uncertainty estimates have been entered on the yellow tabs, the user should sort the output data on the blue community "GHG" tabs according to the instructions on each tab. The final list of key source categories for the community-level emissions can be found on the green "Summary - Overall" and "Summary by Source" tabs.
6
Separate worksheets have been developed to record the data for GHG source categories and sources within the community, including emissions outside the LGU geopoltical boundaries resulting from activities inside the LGU geopolitical boundaries. The community sectors include stationary combustion for residential and commercial users, electricity consumption (from scope 2 sources) for residential and commercial users, mobile combustion for road transportation, waste and waste water and agriculture. A summary of the community GHG emissions is provided in a separate worksheet and will be automatically filled in as the user inputs the data into each sector's worksheet.
7
Tab Key:
8
Tabs highlighted in blue are GHG emissions calculations for source categories (e.g. purchased electricity)
9
Tabs highlighted in yellow require user input of activity data
10
Tabs highlighted in purple are for emission factors and other reference information
11
Tabs highlighted in green are summary tabs or general user information tabs
12
13
Cell Key:
14
Cells highlighted in grey are static identifiers, transcribed directly from another tab/cell, instructional boxes, or titles and should not be altered
15
Cells highlighted in yellow should be inputted by the user to calculate GHG emissions and document inventory development and quality management
16
Cells highlighted in orange can be filled in (e.g. with regional/custom factors), but should have default values already input
17
Cells highlighted in green can be altered with empirical data if available.
18
Cells highlighted in blue contain values or data (e.g. GHG emissions or otherwise) which are automatically calculated based on the information inputted by the user.
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100