Phase 2A-North_Model Version_8.1.0_28FEB17.xls

XLS spreadsheet 6 MB Posted

Attached to
Marysville Ring Levee (MRL) Phase 2A North
Solicitation number
W91238-17-R-0008
Issued by

About this file

Phase 2A North Model

View the file

Other files

Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

User Instructions

Welcome to the Road Construction Emissions Model, Version 8.1.0
User Instructions
This spreadsheet system contains the following individual worksheets:
1This worksheet of User Instructions
2Updates
3Emission Estimates
4Data Entry
5Non-default Off-road Equipment
6EMFAC2014
7On-road Mitigation EF
8OFFROAD Convert
9Off-road Tier 4 EF
10OFFROAD HP & LF
11OFFROAD EF
12x-ref
The Emission Estimates worksheet calculates a project's emissions in pounds per day (and tons) by project phase and tons over the entire construction period.
The worksheet can be used to estimate emissions for both vehicle exhaust and fugitive dust. The methodology used to estimate fugitive dust emissions
is a simplified methodology involving estimates of the maximum area (acreage) of land disturbed daily. Detailed fugitive dust emission estimates
associated with individual materials handling operations and/or activity/vehicle types cannot be conducted with this version of the model.
The Emission Estimates worksheet cannot be modified directly, it is a protected worksheet. It can only be modified indirectly by
entering information for the project in selected areas of the Data Entry worksheet.
The last seven of these worksheets - EMFAC2014, On-road Mitigation EF, OFFROAD Convert, Off-road Tier 4 EF, OFFROAD HP & LP, OFFROAD EF and x-ref - cannot be modified by the user.

They are protected worksheets.

Even though all or portions of several worksheets are protected, the individual formulas used in the calculations can be seen by the user.
The Data Entry worksheet includes several areas that can be modified by the user.
User instructions in the Data Entry worksheet are highlighted in red.
On the Data Entry worksheet, the user has two options for entering project data: required data and optional data. Required data is entered in the data input
section (yellow cells). That required data is then used by the worksheet to calculate default values for the project.
The user can override the default values (blue cells) calculated for a project and is encouraged to do so if project specific information is
available. Due to the difficulty in developing reliable default values for road construction projects,
the user is encouraged to enter as much site specific information as is available for the project being analyzed.
The Data Entry Worksheet also includes a button that allows the user to clear previously entered data. This button is found just at the top of and to the right of
the data entry portion of the worksheet.
When projects are discontinuous, the user must make adjustments to the spreadsheet manually, since the program cannot be setup to anticipate unexpected project delays.
<- This error message may occur during use of the spreadsheets. This occurs whenever the user
enters a non numeric value, including a space character, into a cell that is used to calculate a numeric value.
Consequently, to erase values entered into the spreadsheets, use the delete key instead of the space bar!
Note: Information in this worksheet is based on conversations with knowledgeable individuals at the Sacramento Metropolitan Air Quality Management District, the California Department of Transportation, the California Air Resources Board, the U.S. EPA, and private industry involved in road construction. Also, the 26th edition of Walker's Building Estimator's Reference Book (1999) was used in the development of this spreadsheet. This spreadsheet was prepared by Jones & Stokes, TIAX LLC and Ramboll Environ with the financial support and direction of the Sacramento Metropolitan Air Quality Management District.
http://www.airquality.orghttp://www.ramboll.com/
Karen HussJohn Grant
Khuss@airquality.orgjgrant@ramboll.com
916/874-4881415/899-0706

http://www.airquality.org Khuss@airquality.org jgrant@ramboll.com http://www.ramboll.com/

Updates

Road Construction Emissions Model, Version 8.1.0
Updates Log
Changes from previous version of Road Construction Emissions Model
(Version 7.1.5 to 8.1.0) (updated by SMAQMD 05/09/16 with assistance from Ramboll ENVIRON US Corporation)
1) Project length changed to include calendar years 2014 through 2025.
2) Added a new project type: Type 4: Other Linear Project Type. Note that there are no default vehicle or equipment activities available for the Project Type 4.
3) Emissions estimates were extended to include SOx, CH4, N2O and CO2e.
4) Updated off-road equipment emission factors and default average horsepower by equipment type to be consistent with CalEEMod (version 2013.2.2).
5) On-road vehicle emission factors have been updated to EMFAC2014.
6) Revised pollutant order for consistency throughout the calculator.
7) Added flexibility for users to specify a non-default number of working days per month.
8) Modified soil hauling import and export quantity and haul truck capacity data requests to allow users to specify soil hauling activity by phase.
9) Soil hauling emissions are now estimated separately for each construction phase.
10) Added a new feature to allow users to provide asphalt hauling quantities by phase in the "Data Entry" tab.
11) New component added where the user can specify construction start date and duration by phase.
12) The maximum daily emissions calculation was modified to sum emissions from overlapping construction phases.
13) Water truck activity can be specified and emissions estimated for the paving phase.
14) Mitigation options were added for on-road vehicles and off-road equipment. Emissions calculations include the effects of mitigations if a mitigation option is selected by the user.
15) Model allows user to estimate emissions from non-default off-road equipment for all phases and for all project types. Non-default off-road equipment specification must be included by equipment type for horsepower, number of equipment, load factor, hours of operation and emission factors in the "Non-default Off-road Equipment" tab.
16) New table of total project emissions with units of tons/phase was added in the "Emission Estimates" tab.
17) Removed table of daily emissions in metric units from the "Emission Estimates" tab.
18) Removed unnecessary data from all tabs.
(Version 7.1.4 to 7.1.5) (updated by SMAQMD 12/11/13 with assistance from ENVIRON Corporation)
1) Grubbing and Land Clearing Phase calculation of active months in 2007, 2017, 2019 fixed.
2) Soil Hauling Emissions calculation to select override if it exists for round trips/day.
3) Worker Commute Emissions calculation of starting and hot soak emissions; drainage phase PM10 emission rate.
4) Water Truck Emissions calculation to select number of months for Grubbing and Land Clearing Phase; maximum acreage/day after 2025.
(Version 6.3.2 to Version 7.1.0, 7.1.1, 7.1.2, 7.1.3 & 7.1.4) (updated by SMAQMD 8/2/13)
1) EMFAC2011 emission factors added (previous EMFAC versions dropped).
2) OFFROAD2011 emission factors added (and fixed error).
3) OFFROAD2007 for categories not in OFFROAD2011 (and fixed error)
4) Project length changed to include calendar years 2009 through 2025.
5) Average Offroad HP by Equipment Type calculation updated and corrected
6) Load Factor Adjustment deactivated (default load factors already incorporated in ARB's calculation of emission factors)
7) Crawler Tractor equipment added to model
8) Air Compressors ROG & Default Excavators calculation on Data Entry sheet corrected.
9) Default equipment list updated
10) Corrections to Worker Commute Emissions calculations

Emission Estimates

Orange highlighted cells shows overlapped project phases, maximum daily emissions shown below have been adjusted to account for phase overlap
The maximum pounds per day in row 11 is summed over overlapping phases, but the maximum tons per phase in row 34 is not summed over overlapping phases.
Road Construction Emissions Model, Version 8.1.0
Daily Emission Estimates for ->MRL-Phase 2A-NorthTotalExhaustFugitive DustTotalExhaustFugitive Dust
Project Phases (Pounds)ROG (lbs/day)CO (lbs/day)NOx (lbs/day)PM10 (lbs/day)PM10 (lbs/day)PM10 (lbs/day)PM2.5 (lbs/day)PM2.5 (lbs/day)PM2.5 (lbs/day)SOx (lbs/day)CO2 (lbs/day)CH4 (lbs/day)N2O (lbs/day)CO2e (lbs/day)Overlap?
Grubbing/Land Clearing5.4434.9946.7056.861.5655.3012.811.3011.500.1010,201.702.300.1310,298.23Yes
Grading/Excavation12.5679.77110.0158.943.6455.3014.593.0911.500.2121,824.355.090.2722,032.43Yes
Drainage/Utilities/Sub-Grade11.6874.3999.0658.483.1855.3014.322.8211.500.2019,964.594.710.2320,149.57Yes
Paving6.9944.8157.672.032.030.001.701.700.000.1312,825.192.700.1812,947.42Yes
Maximum (pounds/day)31.23198.97266.73174.288.85165.9041.727.6134.510.5454,614.1312.510.6855,129.42
Total (tons/construction project)1.006.388.665.050.284.771.240.240.990.021,743.900.410.021,760.35
Notes: Project Start Year ->2017
Project Length (months) ->6
Total Project Area (acres) ->11
Maximum Area Disturbed/Day (acres) ->6
Water Truck Used? ->Yes
Total Material Imported/Exported Volume (yd3/day)Daily VMT (miles/day)
PhaseSoilAsphaltSoil HaulingAsphalt HaulingWorker CommuteWater Truck
Grubbing/Land Clearing187030001,80040
Grading/Excavation394060003,60040
Drainage/Utilities/Sub-Grade98045001,80040
Paving034206481,80040
PM10 and PM2.5 estimates assume 50% control of fugitive dust from watering and associated dust control measures if a minimum number of water trucks are specified.
Total PM10 emissions shown in column F are the sum of exhaust and fugitive dust emissions shown in columns G and H. Total PM2.5 emissions shown in Column I are the sum of exhaust and fugitive dust emissions shown in columns J and K.
CO2e emissions are estimated by multiplying mass emissions for each GHG by its global warming potential (GWP), 1 , 25 and 298 for CO2, CH4 and N2O, respectively. Total CO2e is then estimated by summing CO2e estimates over all GHGs.
Total Emission Estimates by Phase for ->MRL-Phase 2A-NorthTotalExhaustFugitive DustTotalExhaustFugitive Dust
Project Phases
(Tons for all except CO2e. Metric tonnes for CO2e)ROG (tons/phase)CO (tons/phase)NOx (tons/phase)PM10 (tons/phase)PM10 (tons/phase)PM10 (tons/phase)PM2.5 (tons/phase)PM2.5 (tons/phase)PM2.5 (tons/phase)SOx (tons/phase)CO2 (tons/phase)CH4 (tons/phase)N2O (tons/phase)CO2e (MT/phase)
Grubbing/Land Clearing0.060.390.530.640.020.620.140.010.130.00114.770.030.00105.10
Grading/Excavation0.573.594.952.650.162.490.660.140.520.01982.100.230.01899.45
Drainage/Utilities/Sub-Grade0.352.232.971.750.101.660.430.080.350.01598.940.140.01548.39
Paving0.030.170.220.010.010.000.010.010.000.0048.090.010.0044.05
Maximum (tons/phase)0.573.594.952.650.162.490.660.140.520.01982.100.230.01899.45
Total (tons/construction project)1.006.388.665.050.284.771.240.240.990.021743.900.410.021,596.98
PM10 and PM2.5 estimates assume 50% control of fugitive dust from watering and associated dust control measures if a minimum number of water trucks are specified.
Total PM10 emissions shown in column F are the sum of exhaust and fugitive dust emissions shown in columns G and H. Total PM2.5 emissions shown in Column I are the sum of exhaust and fugitive dust emissions shown in columns J and K.
CO2e emissions are estimated by multiplying mass emissions for each GHG by its global warming potential (GWP), 1 , 25 and 298 for CO2, CH4 and N2O, respectively. Total CO2e is then estimated by summing CO2e estimates over all GHGs.
The CO2e emissions are reported as metric tons per phase.
ROGCONOxPM10PM2.5SoxCO2CH4N2OCO2e

Data Entry

Road Construction Emissions ModelVersion 8.1.0
Data Entry Worksheet
Note: Required data input sections have a yellow background.Months% TimeDays
Optional data input sections have a blue background. Only areas with aGrubbing/Land Clearing0.751023
yellow or blue background can be modified. Program defaults have a white background.Grading/Excavation3.004592
The user is required to enter information in cells D10 through D24, E28 through G35, and D38 through D41 for all project types.Drainage/Utilities/Sub-Grade2.003061
Please use "Clear Data Input & User Overrides" button first before changing the Project Type or begin a new project.0Paving0.25158
Input Type
Project NameMRL-Phase 2A-North
Construction Start Year2017Enter a Year between 2014 and 2025 (inclusive)0
Project Type41) New Road Construction : Project to build a roadway from bare ground, which generally requires more site preparation than widening an existing roadway
For 4: Other Linear Project Type, please provide project specific off-road equipment population and vehicle trip data2) Road Widening : Project to add a new lane to an existing roadway
3) Bridge/Overpass Construction : Project to build an elevated roadway, which generally requires some different equipment than a new roadway, such as a crane
4) Other Linear Project Type: Non-roadway project such as a pipeline, transmission line, or levee construction
Project Construction Time6.00months
Working Days per Month30.00days (assume 22 if unknown)
Predominant Soil/Site Type: Enter 1, 2, or 321) Sand Gravel : Use for quaternary deposits (Delta/West County)Please note that the soil type instructions provided in cells E18 to E20 are specific to Sacramento County. Maps available from the California Geologic Survey (see weblink below) can be used to determine soil type outside Sacramento County.
(for project within "Sacramento County", follow soil type selection instructions in cells E18 to E20 otherwise see instructions provided in cells J18 to J22)2) Weathered Rock-Earth : Use for Laguna formation (Jackson Highway area) or the Ione formation (Scott Road, Rancho Murieta)
3) Blasted Rock : Use for Salt Springs Slate or Copper Hill Volcanics (Folsom South of Highway 50, Rancho Murieta)
Project Length0.23miles
Total Project Area11.06acres0http://www.conservation.ca.gov/cgs/information/geologic_mapping/Pages/googlemaps.aspx#regionalseries
Maximum Area Disturbed/Day5.53acres
Water Trucks Used?11. Yes
2. No0
Material Hauling Quantity Input
Material TypePhaseHaul Truck Capacity (yd3) (assume 20 if unknown)Import Volume (yd3/day)Export Volume (yd3/day)
SoilGrubbing/Land Clearing20.00187.00
Grading/Excavation20.00207.00187.00
Drainage/Utilities/Sub-Grade20.0098.00
Paving
AsphaltGrubbing/Land Clearing
Grading/Excavation
Drainage/Utilities/Sub-Grade
Paving20.00156.00186.00
Mitigation OptionsEF source
On-road Fleet Emissions Mitigation2010 and Newer On-road Vehicles FleetSelect "2010 and Newer On-road Vehicles Fleet" option when the on-road heavy-duty truck fleet for the project will be limited to vehicles of model year 2010 or neweron-roadOn_road_Mitigation_EF
Off-road Equipment Emissions Mitigation20% NOx and 45% Exhaust PM reductionSelect "20% NOx and 45% Exhaust PM reduction" option if the project will be required to use a lower emitting off-road construction fleet. The SMAQMD Construction Mitigation Calculator can be used to confirm compliance with this mitigation measure (http://www.airquality.org/ceqa/mitigation.shtml).
Select "Tier 4 Equipment" option if some or all off-road equipment used for the project meets CARB Tier 4 Standard
Will all off-road equipment be tier 4?All Tier 4 Equipment
0
The remaining sections of this sheet contain areas that require modification when 'Other Project Type' is selected.
Note: The program's estimates of construction period phase length can be overridden in cells D50 through D53, and F50 through F53.
ProgramProgram
User Override ofCalculatedUser Override ofDefaultProgram Calculated Activity FractionsOverlapoverlapping phaseby phase
Construction PeriodsConstruction MonthsMonthsPhase Starting DatePhase Starting Datestart dateend datemonthsstart yearend yearmonths in start yearmonths in last year201420152016201720182019202020212022202320242025SUMkeyGrubbing/Land ClearingGrading/ExcavationDrainage/Utilities/Sub-GradePavingGrubbing/Land ClearingGrading/ExcavationDrainage/Utilities/Sub-GradePavingphaseROG (lbs/day)CO (lbs/day)NOx (lbs/day)PM10 (lbs/day)
Grubbing/Land Clearing0.750.605/1/171/1/175/1/175/23/170.75201720170.80.80.000.000.001.000.000.000.000.000.000.000.000.001.00Weighted - Grubbing--YesNoNo120015.4434.9946.7056.86
Grading/Excavation3.002.705/22/171/24/175/22/178/21/173201720173.03.00.000.000.001.000.000.000.000.000.000.000.000.001.00Weighted - GradingYes--YesNo1230212.5679.77110.0158.94
Drainage/Utilities/Sub-Grade2.001.808/14/174/26/178/14/1710/13/172201720172.02.00.000.000.001.000.000.000.000.000.000.000.000.001.00Weighted - DrainageNoYes--Yes0234311.6874.3999.0658.48
Paving0.250.9010/9/176/26/1710/9/1710/16/170.3201720170.30.30.000.000.001.000.000.000.000.000.000.000.000.001.00Weighted - PavingNoNoYes--003446.9944.8157.672.03
Totals (Months)60.01234
0.0
0
Note: Soil Hauling emission default values can be overridden in cells D61 through D64, and F61 through F64.
Soil Hauling EmissionsUser Override ofProgram Estimate ofUser Override of TruckDefault ValuesCalculated
User InputMiles/Round TripMiles/Round TripRound Trips/DayRound Trips/DayDaily VMT
Miles/round trip: Grubbing/Land Clearing30.000.0010300.00
Miles/round trip: Grading/Excavation30.000.0020600.00
Miles/round trip: Drainage/Utilities/Sub-Grade90.000.005450.00
Miles/round trip: Paving0.0000.00
KEY2010+ Model Year Mitigation Option Emission RatesROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Weighted - GrubbingGrubbing/Land Clearing (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - GradingGrading/Excavation (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - DrainageDraining/Utilities/Sub-Grade (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - PavingPaving (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Hauling EmissionsROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
-Pounds per day - Grubbing/Land ClearingPounds per day - Grubbing/Land Clearing0.040.231.020.070.030.011,061.030.000.031,071.49
-Tons per const. Period - Grubbing/Land ClearingTons per const. Period - Grubbing/Land Clearing0.000.000.010.000.000.0011.940.000.0012.05
-Pounds per day - Grading/ExcavationPounds per day - Grading/Excavation0.090.472.040.140.050.022,122.070.000.072,142.97
-Tons per const. Period - Grading/ExcavationTons per const. Period - Grading/Excavation0.000.020.090.010.000.0095.490.000.0096.43
-Pounds per day - Drainage/Utilities/Sub-GradePounds per day - Drainage/Utilities/Sub-Grade0.070.351.530.100.040.021,591.550.000.051,607.23
-Tons per const. Period - Drainage/Utilities/Sub-GradeTons per const. Period - Drainage/Utilities/Sub-Grade0.000.010.050.000.000.0047.750.000.0048.22
-Pounds per day - PavingPounds per day - Paving0.000.000.000.000.000.000.000.000.000.00
-Tons per const. Period - PavingTons per const. Period - Paving0.000.000.000.000.000.000.000.000.000.00
-Total tons per construction projectTotal tons per construction project0.010.030.150.010.000.00155.180.000.01156.71
Note: Asphalt Hauling emission default values can be overridden in cells D87 through D90, and F87 through F90.
Asphalt Hauling EmissionsUser Override ofProgram Estimate ofUser Override of TruckDefault ValuesCalculated
User InputMiles/Round TripMiles/Round TripRound Trips/DayRound Trips/DayDaily VMT
Miles/round trip: Grubbing/Land Clearing0.0000.00
Miles/round trip: Grading/Excavation0.0000.00
Miles/round trip: Drainage/Utilities/Sub-Grade0.0000.00
Miles/round trip: Paving36.000.0018648.00
2010+ Model Year Mitigation Option Emission RatesROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Weighted - GrubbingGrubbing/Land Clearing (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - GradingGrading/Excavation (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - DrainageDraining/Utilities/Sub-Grade (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - PavingPaving (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
EmissionsROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
-Pounds per day - Grubbing/Land ClearingPounds per day - Grubbing/Land Clearing0.000.000.000.000.000.000.000.000.000.00
-Tons per const. Period - Grubbing/Land ClearingTons per const. Period - Grubbing/Land Clearing0.000.000.000.000.000.000.000.000.000.00
-Pounds per day - Grading/ExcavationPounds per day - Grading/Excavation0.000.000.000.000.000.000.000.000.000.00
-Tons per const. Period - Grading/ExcavationTons per const. Period - Grading/Excavation0.000.000.000.000.000.000.000.000.000.00
-Pounds per day - Drainage/Utilities/Sub-GradePounds per day - Drainage/Utilities/Sub-Grade0.000.000.000.000.000.000.000.000.000.00
-Tons per const. Period - Drainage/Utilities/Sub-GradeTons per const. Period - Drainage/Utilities/Sub-Grade0.000.000.000.000.000.000.000.000.000.00
-Pounds per day - PavingPounds per day - Paving0.100.502.200.150.060.022,291.830.000.082,314.41
-Tons per const. Period - PavingTons per const. Period - Paving0.000.000.010.000.000.008.590.000.008.68
-Total tons per construction projectTotal tons per construction project0.000.000.010.000.000.008.590.000.008.68
Note: Worker commute default values can be overridden in cells D113 through D118.
Worker Commute EmissionsUser Override of Worker
User InputCommute Default ValuesDefault Values
Miles/ one-way trip600CalculatedCalculated
One-way trips/day60Daily TripsDaily VMT
No. of employees: Grubbing/Land Clearing50301,800.00
No. of employees: Grading/Excavation100603,600.00
No. of employees: Drainage/Utilities/Sub-Grade50301,800.00
No. of employees: Paving50301,800.00
Emission RatesROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Weighted - GrubbingGrubbing/Land Clearing (grams/mile)0.041.510.170.050.020.00403.730.010.01406.12
Weighted - GradingGrading/Excavation (grams/mile)0.041.510.170.050.020.00403.730.010.01406.12
Weighted - DrainageDraining/Utilities/Sub-Grade (grams/mile)0.041.510.170.050.020.00403.730.010.01406.12
Weighted - PavingPaving (grams/mile)0.041.510.170.050.020.00403.730.010.01406.12
Weighted - GrubbingGrubbing/Land Clearing (grams/trip)1.283.620.300.000.000.0089.600.020.0193.79
Weighted - GradingGrading/Excavation (grams/trip)1.283.620.300.000.000.0089.600.020.0193.79
Weighted - DrainageDraining/Utilities/Sub-Grade (grams/trip)1.283.620.300.000.000.0089.600.020.0193.79
Weighted - PavingPaving (grams/trip)1.283.620.300.000.000.0089.600.020.0193.79
EmissionsROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
-Pounds per day - Grubbing/Land ClearingPounds per day - Grubbing/Land Clearing0.236.250.690.190.080.021,608.070.050.031,617.83
-Tons per const. Period - Grubbing/Land ClearingTons per const. Period - Grubbing/Land Clearing0.000.070.010.000.000.0018.090.000.0018.20
-Pounds per day - Grading/ExcavationPounds per day - Grading/Excavation0.4612.491.380.370.160.033,216.140.100.063,235.66
-Tons per const. Period - Grading/ExcavationTons per const. Period - Grading/Excavation0.020.560.060.020.010.00144.730.000.00145.60
-Pounds per day - Drainage/Utilities/Sub-GradePounds per day - Drainage/Utilities/Sub-Grade0.236.250.690.190.080.021,608.070.050.031,617.83
-Tons per const. Period - Drainage/Utilities/Sub-GradeTons per const. Period - Drainage/Utilities/Sub-Grade0.010.190.020.010.000.0048.240.000.0048.53
-Pounds per day - PavingPounds per day - Paving0.236.250.690.190.080.021,608.070.050.031,617.83
-Tons per const. Period - PavingTons per const. Period - Paving0.000.020.000.000.000.006.030.000.006.07
-Total tons per construction projectTotal tons per construction project0.030.840.090.030.010.00217.090.010.00218.41
Note: Water Truck default values can be overridden in cells D145 through D148, and F145 through F148.
Water Truck EmissionsUser Override ofProgram Estimate ofUser Override of TruckDefault ValuesCalculated
User InputDefault # Water TrucksNumber of Water TrucksMiles Traveled/Vehicle/DayMiles Traveled/Vehicle/DayDaily VMT
Grubbing/Land Clearing - Exhaust1040.000.0040.00
Grading/Excavation - Exhaust1040.000.0040.00
Drainage/Utilities/Subgrade1040.000.0040.00
Paving1040.000.0040.00
2010+ Model Year Mitigation Option Emission RatesROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Weighted - GrubbingGrubbing/Land Clearing (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - GradingGrading/Excavation (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - DrainageDraining/Utilities/Sub-Grade (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
Weighted - PavingPaving (grams/mile)0.070.351.540.100.040.021,604.260.000.051,620.06
EmissionsROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
-Pounds per day - Grubbing/Land ClearingPounds per day - Grubbing/Land Clearing0.010.030.140.010.000.00141.470.000.00142.86
-Tons per const. Period - Grubbing/Land ClearingTons per const. Period - Grubbing/Land Clearing0.000.000.000.000.000.001.590.000.001.61
-Pounds per day - Grading/ExcavationPounds per day - Grading/Excavation0.010.030.140.010.000.00141.470.000.00142.86
-Tons per const. Period - Grading/ExcavationTons per const. Period - Grading/Excavation0.000.000.010.000.000.006.370.000.006.43
-Pounds per day - Drainage/Utilities/Sub-GradePounds per day - Drainage/Utilities/Sub-Grade0.010.030.140.010.000.00141.470.000.00142.86
-Tons per const. Period - Drainage/Utilities/Sub-GradeTons per const. Period - Drainage/Utilities/Sub-Grade0.000.000.000.000.000.004.240.000.004.29
-Pounds per day - PavingPounds per day - Paving0.010.030.140.010.000.00141.470.000.00142.86
-Tons per const. Period - PavingTons per const. Period - Paving0.000.000.000.000.000.000.530.000.000.54
-Total tons per construction projectTotal tons per construction project0.000.000.010.000.000.0012.730.000.0012.86
Note: Fugitive dust default values can be overridden in cells D171 through D173.
Fugitive DustUser Override of MaxDefaultPM10PM10PM2.5PM2.5
Acreage Disturbed/DayMaximum Acreage/Daypounds/daytons/per periodpounds/daytons/per period
Fugitive Dust - Grubbing/Land Clearing5.5355.300.6211.500.133
Fugitive Dust - Grading/Excavation5.5355.302.4911.500.523
Fugitive Dust - Drainage/Utilities/Subgrade5.5355.301.6611.500.353
20.8CEIDARS - Off Road Equipment Fugitive Dust PM2.5 % of PM10
Values in cells D183 through D216, D234 through D267, D285 through D318, and D336 through D369 are required when 'Other Project Type' is selected.
0
Off-Road Equipment Emissions
DefaultMitigation OptionEmissions reflect reduction due to 20% NOx and 45% Exhaust PM reduction Mitigation Option Selected
Grubbing/Land ClearingNumber of VehiclesOverride ofDefaultROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Override of Default Number of VehiclesProgram-estimateDefault Equipment Tier (applicable only when "Tier 4 Mitigation" Option Selected)Equipment TierTypepounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/day1 New Road Construction2 Road Widening3 Bridge/Overpass Construction
Weighted - GrubbingModel Default TierModel Default TierAerial Lifts0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierAir Compressors0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierBore/Drill Rigs0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierCement and Mortar Mixers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierConcrete/Industrial Saws0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierCranes0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing0Model Default TierModel Default TierCrawler Tractors0.000.000.000.000.000.000.000.000.000.00111
Weighted - GrubbingModel Default TierModel Default TierCrushing/Proc. Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing0Model Default TierModel Default TierExcavators0.000.000.000.000.000.000.000.000.000.00122
Weighted - GrubbingModel Default TierModel Default TierForklifts0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierGenerator Sets0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierGraders0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierOff-Highway Tractors0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing5.00Model Default TierModel Default TierOff-Highway Trucks4.3623.4339.341.000.920.076,721.322.060.066,789.86000
Weighted - GrubbingModel Default TierModel Default TierOther Construction Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierOther General Industrial Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierOther Material Handling Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierPavers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierPaving Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierPlate Compactors0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing1.00Model Default TierModel Default TierPressure Washers0.050.250.270.010.010.0039.090.000.0039.30000
Weighted - GrubbingModel Default TierModel Default TierPumps0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierRollers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierRough Terrain Forklifts0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierRubber Tired Dozers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierRubber Tired Loaders0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierScrapers0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing1.000Model Default TierModel Default TierSignal Boards0.060.300.290.010.010.0049.310.010.0049.56000
Weighted - GrubbingModel Default TierModel Default TierSkid Steer Loaders0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierSurfacing Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grubbing1.00Model Default TierModel Default TierSweepers/Scrubbers0.372.082.500.150.140.00259.850.080.00262.50000
Weighted - Grubbing1.00Model Default TierModel Default TierTractors/Loaders/Backhoes0.322.422.460.130.120.00321.550.100.00324.82000
Weighted - GrubbingModel Default TierModel Default TierTrenchers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GrubbingModel Default TierModel Default TierWelders0.000.000.000.000.000.000.000.000.000.00000
User-Defined Off-road EquipmentIf non-default vehicles are used, please provide information in 'Non-default Off-road Equipment' tabROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Number of VehiclesEquipment TierTypepounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/day
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
-pounds per day - Grubbing/Land ClearingGrubbing/Land Clearingpounds per day5.1628.4844.851.301.190.077,391.122.250.067,466.05
-tons per phase - Grubbing/Land ClearingGrubbing/Land Clearingtons per phase0.060.320.500.010.010.0083.150.030.0083.99
DefaultMitigation OptionEmissions reflect reduction due to 20% NOx and 45% Exhaust PM reduction Mitigation Option Selected
Grading/ExcavationNumber of VehiclesOverride ofDefaultROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Override of Default Number of VehiclesProgram-estimateDefault Equipment Tier (applicable only when "Tier 4 Mitigation" Option Selected)Equipment TierTypepounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/day1 New Road Construction2 Road Widening3 Bridge/Overpass Construction
Weighted - GradingModel Default TierModel Default TierAerial Lifts0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierAir Compressors0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierBore/Drill Rigs0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierCement and Mortar Mixers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierConcrete/Industrial Saws0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading0Model Default TierModel Default TierCranes0.000.000.000.000.000.000.000.000.000.00001
Weighted - Grading1.000Model Default TierModel Default TierCrawler Tractors0.682.757.270.190.180.01788.460.240.01796.51112
Weighted - GradingModel Default TierModel Default TierCrushing/Proc. Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading2.000Model Default TierModel Default TierExcavators0.736.886.470.220.200.011,089.210.330.011,100.33334
Weighted - Grading1.00Model Default TierModel Default TierForklifts0.211.251.460.080.080.00156.250.050.00157.85000
Weighted - GradingModel Default TierModel Default TierGenerator Sets0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading1.000Model Default TierModel Default TierGraders0.964.877.760.300.280.01641.270.200.01647.79122
Weighted - GradingModel Default TierModel Default TierOff-Highway Tractors0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading9.00Model Default TierModel Default TierOff-Highway Trucks7.8542.1770.811.811.660.1212,098.373.710.1012,221.75000
Weighted - GradingModel Default TierModel Default TierOther Construction Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierOther General Industrial Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierOther Material Handling Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierPavers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierPaving Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierPlate Compactors0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading1.00Model Default TierModel Default TierPressure Washers0.050.250.270.010.010.0039.090.000.0039.30000
Weighted - GradingModel Default TierModel Default TierPumps0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading1.000Model Default TierModel Default TierRollers0.312.022.350.120.110.00271.520.080.00274.29223
Weighted - GradingModel Default TierModel Default TierRough Terrain Forklifts0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierRubber Tired Dozers0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading1.000Model Default TierModel Default TierRubber Tired Loaders0.471.804.830.110.100.01629.790.190.01636.23113
Weighted - Grading0Model Default TierModel Default TierScrapers0.000.000.000.000.000.000.000.000.000.00224
Weighted - Grading1.000Model Default TierModel Default TierSignal Boards0.060.300.290.010.010.0049.310.010.0049.56000
Weighted - GradingModel Default TierModel Default TierSkid Steer Loaders0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierSurfacing Equipment0.000.000.000.000.000.000.000.000.000.00000
Weighted - Grading1.00Model Default TierModel Default TierSweepers/Scrubbers0.372.082.500.150.140.00259.850.080.00262.50000
Weighted - Grading1.000Model Default TierModel Default TierTractors/Loaders/Backhoes0.322.422.460.130.120.00321.550.100.00324.82242
Weighted - GradingModel Default TierModel Default TierTrenchers0.000.000.000.000.000.000.000.000.000.00000
Weighted - GradingModel Default TierModel Default TierWelders0.000.000.000.000.000.000.000.000.000.00000
User-Defined Off-road EquipmentIf non-default vehicles are used, please provide information in 'Non-default Off-road Equipment' tabROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e
Number of VehiclesEquipment TierTypepounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/daypounds/day
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
0.00N/A00.000.000.000.000.000.000.000.000.000.00
-pounds per day - Grading/ExcavationGrading/Excavationpounds per day12.0166.78106.463.122.870.1616,344.674.990.1416,510.94
-tons per phase - Grading/ExcavationGrading/Excavationtons per phase0.543.014.790.140.130.01735.510.220.01742.99
DefaultMitigation OptionEmissions reflect reduction due to 20% NOx and 45% Exhaust PM reduction Mitigation Option Selected
Drainage/Utilities/SubgradeNumber of VehiclesOverride ofDefaultROGCONOxPM10PM2.5SOxCO2CH4N2OCO2e

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .