mswlf emcalc by ICC13Rl

VIEWS: 3 PAGES: 20

									Sheet 1

Sheet 2

Sheet 3

Sheet 4

Sheet 5

Sheet 6

Sheet 7

Sheet 8

Sheet 9

Sheet 10
TCEQ - Municipal Solid Waste Landfill Emissions Calculation Spreadsheet - 10/2006

Contents of Each Sheet

Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown. Located in Geographical Areas with a Thirty Y
Precipitation EQUAL to or GREATER Than 25 Inches
Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown. Located in Geographical Areas
with a Thirty Year Annual Average
Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown. Located in Geographical Areas
with a Thirty Year Annual Average
Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown. Located in Geographical Areas
with a Thirty Year Annual Average
Tier 3 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown. Located in Geographical Areas
with a Thirty Year Annual Average
Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Known. Located in Geographical Areas with
a Thirty Year Annual Average
Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Known. Located in Geographical Areas with
a Thirty Year Annual Average
Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Known. Located in Geographical Areas with
a Thirty Year Annual Average
Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Known. Located in Geographical Areas with
a Thirty Year Annual Average
Tier 3 Testing - Actual Year-to-Year Solid Waste Acceptance Known. Located in Geographical Areas with
a Thirty Year Annual Average
cal Areas with a Thirty Year Annual Average
               Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Equal to or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 2LoR(e-kc - e-kt)CNMOC(3.6 x 10-9)

where,

MNMOC = mass emission rate of nonmethane organic compounds (NMOC), megagrams per year
Lo = methane generation potential, cubic meters per megagram solid waste
R = average annual acceptance rate of solid waste, megagrams per year
k = methane generation rate constant, year-1
t = age of landfill, years
CNMOC = concentration of NMOC, parts per million volume as hexane
c = time since closure, years (This spreadsheet is for active landfills so c = 0.)
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, three values are set as follows:

k = 0.05 per year
Lo = 170 cubic meters per megagram
CNMOC = 4,000 parts per million by volume as hexane

The spreadsheet user needs to enter a value for R and t.

The value of R in megagrams per year is:

1102

The value of t in years is:

1

Based on the value of R and value of t you have entered, MNMOC in megagrams per year, is:

0.263136373

If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 2 testing.
If Tier 2 testing is used, this spreadsheet does not need to be submitted.
               Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 2LoR(e-kc - e-kt)CNMOC(3.6 x 10-9)

where,

MNMOC = mass emission rate of nonmethane organic compounds (NMOC), megagrams per year
Lo = methane generation potential, cubic meters per megagram solid waste
R = average annual acceptance rate of solid waste, megagrams per year
k = methane generation rate constant, year-1
t = age of landfill, years
CNMOC = concentration of NMOC, parts per million volume as hexane
c = time since closure, years (This spreadsheet is for active landfills so c = 0.)
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, three values are set as follows:

k = 0.02 per year
Lo = 170 cubic meters per megagram
CNMOC = 4,000 parts per million by volume as hexane

The spreadsheet user needs to enter a value for R and t.

The value of R in megagrams per year is:

1000000

The value of t in years is:

10

Based on the value of R and value of t you have entered, MNMOC in megagrams per year, is:

887.4942329

If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 2 testing.
If Tier 2 testing is used, this spreadsheet does not need to be submitted.
               Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Equal to or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 2LoR(e-kc - e-kt)CNMOC(3.6 x 10-9)

where,

MNMOC = mass emission rate of nonmethane organic compounds (NMOC), megagrams per year
Lo = methane generation potential, cubic meters per megagram solid waste
R = average annual acceptance rate of solid waste, megagrams per year
k = methane generation rate constant, year-1
t = age of landfill, years
CNMOC = concentration of NMOC, parts per million volume as hexane
c = time since closure, years (This spreadsheet is for active landfills so c = 0.)
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, two values are set as follows:

k = 0.05 per year
Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter values for R, t, and CNMOC.

The value of R in megagrams per year is:

1000000

The value of t in years is:

10

The value of CNMOC (based on empirical data) in parts per million volume as hexane is:

2000

Based on the values of R, t, and CNMOC you have entered, MNMOC in megagrams per year, is:

963.212945

If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC value.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 3 testing.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.
               Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 2LoR(e-kc - e-kt)CNMOC(3.6 x 10-9)

where,

MNMOC = mass emission rate of nonmethane organic carbon (NMOC), megagrams per year
Lo = methane generation potential, cubic meters per megagram solid waste
R = average annual acceptance rate of solid waste, megagrams per year
k = methane generation rate constant, year-1
t = age of landfill, years
CNMOC = concentration of NMOC, parts per million volume as hexane
c = time since closure, years (This spreadsheet is for active landfills so c = 0.)
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, two values are set as follows:

k = 0.02 per year
Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter values for R, t, and CNMOC.

The value of R in megagrams per year is:

1000000

The value of t in years is:

10

The value of CNMOC (based on empirical data) in parts per million volume as hexane is:

2000

Based on the values of R, t, and CNMOC you have entered, MNMOC in megagrams per year, is:

443.7471165

If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC value.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 3 testing.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.
               Tier 3 Testing - Actual Year-to-Year Solid Waste Acceptance Unknown
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than, Equal to, or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 2LoR(e-kc - e-kt)CNMOC(3.6 x 10-9)

where,

MNMOC = mass emission rate of nonmethane organic carbon (NMOC), megagrams per year
Lo = methane generation potential, cubic meters per megagram solid waste
R = average annual acceptance rate of solid waste, megagrams per year
k = methane generation rate constant, year-1
t = age of landfill, years
CNMOC = concentration of NMOC, parts per million volume as hexane
c = time since closure, years (This spreadsheet is for active landfills so c = 0.)
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, one value is set as follows:

Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter values for R, t, CNMOC, and k.

The value of R in megagrams per year is:

1000000

The value of t in years is:

10

The value of CNMOC (based on empirical data) in parts per million volume as hexane is:

2000

The value of k (based on 40 CFR Part 60, Method 2E) in year-1 is:

0.1

Based on the values of R, t, CNMOC, and k you have entered, MNMOC in megagrams per year, is:

1547.431128

If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC and k
values.
If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.
                Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Known
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Equal to or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 32kLoMi(e-kti)CNMOC(3.6 x 10-9) from i = 1 to n.

where,

MNMOC = Total nonmethane organic compound (NMOC) emission rate, megagrams per year (Mg/yr)
Lo = methane generation potential, cubic meters per megagram solid waste
Mi = mass of solid waste in the ith section, megagrams
k = methane generation rate constant, year-1
ti = age of the ith section, years
CNMOC = concentration of NMOC, parts per million volume as hexane
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, three values are set as follows:

k = 0.05 per year
Lo = 170 cubic meters per megagram
CNMOC = 4,000 parts per million by volume as hexane

The spreadsheet user needs to enter values for ti, Mi, and corrensponding calendar year
in the following table (up to fifty calendar years can be entered).


                        Calendar               ith NMOC
Age         Mass        Year                   Mg/yr
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0

0

Based on the table information you entered, MNMOC in megagrams per year, is:

0




If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 2 testing.
If Tier 2 testing is used, this spreadsheet does not need to be submitted.
                Tier 1 Testing - Actual Year-to-Year Solid Waste Acceptance Known
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 32kLoMi(e-kti)CNMOC(3.6 x 10-9) from i = 1 to n.

where,

MNMOC = Total nonmethane organic compound (NMOC) emission rate, megagrams per year (Mg/yr)
Lo = methane generation potential, cubic meters per megagram solid waste
Mi = mass of solid waste in the ith section, megagrams
k = methane generation rate constant, year-1
ti = age of the ith section, years
CNMOC = concentration of NMOC, parts per million volume as hexane
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, three values are set as follows:

k = 0.02 per year
Lo = 170 cubic meters per megagram
CNMOC = 4,000 parts per million by volume as hexane

The spreadsheet user needs to enter values for ti, Mi, and corrensponding calendar year
in the following table (up to fifty calendar years can be entered).


                        Calendar               ith NMOC
Age         Mass        Year                   Mg/yr
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0

0

Based on the table information you entered, MNMOC in megagrams per year, is:

0




If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 2 testing.
If Tier 2 testing is used, this spreadsheet does not need to be submitted.
                Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Known
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Equal to or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 32kLoMi(e-kti)CNMOC(3.6 x 10-9) from i = 1 to n.

where,

MNMOC = Total nonmethane organic compound (NMOC) emission rate, megagrams per year (Mg/yr)
Lo = methane generation potential, cubic meters per megagram solid waste
Mi = mass of solid waste in the ith section, megagrams
k = methane generation rate constant, year-1
ti = age of the ith section, years
CNMOC = concentration of NMOC, parts per million volume as hexane
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, two values are set as follows:

k = 0.05 per year
Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter a value for CNMOC.
The value for CNMOC (based on empirical data) in parts per million volume as hexane is:

3,000

The spreadsheet user needs to enter values for ti, Mi, and corrensponding calendar year
in the following table (up to fifty calendar years can be entered).


                        Calendar               ith NMOC
Age         Mass        Year                   Mg/yr
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0

0

Based on the table information you entered, MNMOC in megagrams per year, is:

0




If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC value.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 3 testing.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.
                Tier 2 Testing - Actual Year-to-Year Solid Waste Acceptance Known
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 32kLoMi(e-kti)CNMOC(3.6 x 10-9) from i = 1 to n.

where,

MNMOC = Total nonmethane organic compound (NMOC) emission rate, megagrams per year (Mg/yr)
Lo = methane generation potential, cubic meters per megagram solid waste
Mi = mass of solid waste in the ith section, megagrams
k = methane generation rate constant, year-1
ti = age of the ith section, years
CNMOC = concentration of NMOC, parts per million volume as hexane
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, two values are set as follows:

k = 0.02 per year
Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter a value for CNMOC.
The value for CNMOC (based on empirical data) in parts per million volume as hexane is:

3000

The spreadsheet user needs to enter values for ti, Mi, and corrensponding calendar year
in the following table (up to fifty calendar years can be entered).


                        Calendar               ith NMOC
Age         Mass        Year                   Mg/yr
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                     1         0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0
                                   1           0

0

Based on the information you entered, MNMOC in megagrams per year, is:

0




If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC value.

If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW or use the appropriate spreadsheet for Tier 3 testing.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.
                 Tier 3 Testing - Actual Year-to-Year Solid Waste Acceptance Known
For Landfills Located in Geographical Areas with a Thirty Year Annual Average
Precipitation of Less Than, Equal to, or Greater Than 25 Inches

This spreadsheet uses the formula:

MNMOC = 32kLoMi(e-kti)CNMOC(3.6 x 10-9) from i = 1 to n.

where,

MNMOC = Total nonmethane organic compound (NMOC) emission rate, megagrams per year (Mg/yr)
Lo = methane generation potential, cubic meters per megagram solid waste
Mi = mass of solid waste in the ith section, megagrams
k = methane generation rate constant, year-1
ti = age of the ith section, years
CNMOC = concentration of NMOC, parts per million volume as hexane
3.6 x 10-9 is a conversion factor.

As per 40 CFR 60 Supart WWW, one value is set as follows:

Lo = 170 cubic meters per megagram

The spreadsheet user needs to enter values for CNMOC and k.
The value for CNMOC (based on empirical data) in parts per million volume as hexane is:

3,000

The value for k (based on 40 CFR Part 60, Method 2E) in year-1 is:

        0.07

The spreadsheet user needs to enter values for ti, Mi, and corrensponding calendar year
in the following table (up to fifty calendar years can be entered).


                        Calendar                ith NMOC
Age            Mass     Year                    Mg/yr
1              500000   2020         0.932394   466196.91
2              600000   2019         0.869358   521614.9412
3              400000   2018         0.810584   324233.6984
4              500000   2017         0.755784   377891.8707
                                     1          0
                                     1          0
                                     1          0
                                     1          0
                                     1          0
                                     1          0
                                     1          0
                                     1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0
                                  1          0

1689937

Based on the information you entered, MNMOC in megagrams per year, is:

434.3815145




If MNMOC is less than 50 megagrams per year, submit an emission rate
report (i.e., this spreadsheet) and recalculate the MNMOC annually using the same CNMOC and k
values.
If MNMOC is equal to or greater than 50 megagrams per year, comply with additional
requirements of Supart WWW.
If Tier 3 testing is used, the Tier 1 and Tier 2 spreadsheets do not need to be submitted.

								
To top