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".

• Start Here will step you through the process.
• Links includes links to background information, the Portable Diesel Engine ATCM regulation, and contact information.
• Enter Fleet Information is where you enter the data.
• Non-Fleet inventory is where to list engines excluded from the fleet requirements such as engines you have designated low-use or emergency-use only or operated only outside California.  It should be printed and attached to the compliance statement only if appropriate.
• Printable Fleet Summary will show the information you entered but fits for printing on a single sheet of paper.  It should be attached to the compliance statement for submittal to ARB.

• Compliance Statement is a document to submit to ARB to meet the fleet reporting requirement.
  
• Engine Info shows the engine make, model, serial number, and year of manufacture for your engines registered in PERP.  It is automatically displayed based on information currently in the PERP database.  You should check this for completeness and accuracy. Infomation for engines you own which have local district permits or registrations is not automatically displayed.  You will need to enter the information in the yellow areas on the right side of the page.  It may be found on your permit or on the engine itself.  Print and attach this page to your compliance statement for submittal to ARB.

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:

• We recommend you don't "unprotect" the sheet because you may damage the formulas.  

• If you need a calculator for more than 20 engines, there is one for up to 200 engines available.

• Information can be entered in the areas with yellow background.  Other cells are protected.

• Don't use the spacebar to remove information from a cell.  Use delete or backspace.

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.