CALCULATOR INSTRUCTIONS

General

There are 7 pages in the calculator spreadsheet -- "Start Here", "Links",  "Enter Fleet Information", "Non-Fleet Inventory", "Printable Fleet Summary", "Compliance Statement", and "Engine Info".


All information needed to enter the fleet information and the inventory sheet can be found on your registration certificate or your district permit.


The following instructions discuss how to enter information on the Enter Fleet Information sheet.

General Notes:


Column and Cell Descriptions

Cell B3

Your company name. This will also appear on the Printable Fleet Summary, Non Fleet Inventory, and Compliance Statement pages.

Column A

PERP registration number or air district permit number.  Tier 4 engines added to fleet prior to 1/1/2015 may be entered twice for 2013 and twice for 2017 if the requirements of ATCM section 93116(d)(2)(C) are met.

Column B

Your own unit identification number for your reference.  This is optional.

Column C

Enter the engine family name.  This will be found on the PERP registration certificate.  Alternatively, you can enter a PM emission factor from a CARB executive order.  

If you're using the calculator to look at potential engine replacements, such as Tier 4 or interim Tier 4, the engine family name or certified emission factor may not yet be available.  You may want to use the emission standard that would apply to the engine category instead.

Note: The engine family name must be entered carefully.  No typos!  Pay attention to numbers 0 and 1 as they are easily confused with letters O or I. Make sure there are no blank spaces before or after the engine family name.
If you copy and paste into the spreadsheet, use "Edit, Paste Special, text." 

If the engine family name does not produce an emission factor in Column E or it says "EF error" in Column L,
do one of the following:

1.  Double check the engine family name.
2.  Find the CARB executive order for the engine family name.  Use the “cert” value in the table on the executive order.

 

         CARB executive orders for certified non-road engines can be found at:

         http://www.arb.ca.gov/msprog/offroad/cert/cert.php. 

           If the PM emission factor on the executive order is listed in grams per

           kilowatt-hour (g/kw-hr), divide the number shown by 1.341 to get

           grams per brake horsepower-hour (g/bhp-hr).

g/bhp-hr = g/kW-hr ÷ 1.341

3.  Call ARB PERP staff.

Column D

Enter the horsepower rating of the engine.  This can be found on the PERP registration certificate or on the engine.


If it says "bhp error" in column K, you entered a horsepower that isn't valid for the calculator you are using.  The three calculators are  "under 175 bhp",     "175-750 bhp", and "over 750 bhp".  Each group of engines in a bhp range must be on a separate spreadsheet and each bhp group must meet the emission requirements for that bhp range.  Engine power must be in brake horsepower (bhp).  To convert engine power from KiloWatts (kW) to bhp, multiply the kW number by 1.341

bhp = kW x 1.341

Column E

This column will display the PM emission factor in grams/bhp-hr as determined by the engine family name or the PM emission factor you entered. You cannot enter information in this column.

Column F

Enter  "alt-fuel," "scr" or "fuel additive" (without the quotes) if these apply to your engine(s).


"scr"
refers to an engine with a selective catalytic reduction system;

"fuel additive" refers to an engine using a fuel additive;

Alternative-fueled ("alt-fuel" ) engines added to the fleet prior to 1/1/09 may be entered twice for 2013 and twice for 2017
if the requirements of ATCM section 93116.3(d)(2)(B) are met.  These engines may only be included in the fleet if the engine
operated at least 100 hours during the 12 month period prior to the fleet emission standard becoming effective.  The net emission factor for that engine will be zero in Column J.

Column G

If you substituted operation of the engine with electric power from the grid, enter the percentage of time electric power was used.
Enter as a percentage or as a decimal.  For example, for 85 percent control efficiency you can enter 85 or .85. Don't enter as 0.85 with the leading zero.

The equipment must use grid power for more than 200 hours in lieu of operating a portable diesel-fueled engine for a given project.

Column H

Enter the PM emission factor from SCR test results or fuel additive emission factor approved by ARB.

The emission factor must be in units of g/bhp-hr.  For example 0.05 g/bhp-hr.  If the units are in g/kW-hr, divide the number by 1.341.

g/bhp-hr = g/kW-hr ÷ 1.341

Column I

Enter the "Level" of the verified emission control strategy.  These can be level 1, 2, or 3.  Information is published in the CARB Executive Order for the particular diesel particulate filter or other emission control device.

http://www.arb.ca.gov/diesel/verdev/vt/cvt.htm

Column J

Displays the net PM emission factor resulting from the inputs in Columns C through I.

Column K

Displays the value in column J multiplied by the horsepower in Column D.

Column L

Displays error messages.

"Enter Col. H" means "scr" or "fuel additive" is entered in Column F and an emission factor is needed.


"Bhp error" means the bhp value in Column D is inappropriate for this calculator horsepower range.

"EF error" means an invalid engine family name or out of range emission factor is entered in Column C.

Cell D3

The sum of the horsepower entries in column D.

Cell E3

The sum of the numbers in column K.

Cell F3

This is the weighted PM emission fleet average (E3 divided by D3).

Cells G3, H3, and I3

Fleet PM standards for the particular year and horsepower range.

Cells J3, K3, and L3

Compares cell F3 to cells G3, H3, and I3.