Aug 07, 2020

BREEZE TankESP uses the emission estimation procedures from Chapter 7 of U.S. EPA's AP-42 for volatile organic compound (VOC) emissions from storage tanks. TankESP estimates both routine emissions from storage tanks such as fixed-roof tanks and floating-roof tanks and non-routine emissions from tank cleanings and floating-roof landings. It is widely regarded as the most accurate tank emission calculation tool on the market.

But how can users prove that TankESP applies AP-42 estimation procedures correctly? What if regulatory agencies ask how the emissions are calculated? No need to worry! TankESP has a very convenient feature that allows consultants to easily answer these questions.

This modeling tip will walk you through how to show the emission calculation steps for three different scenarios: 1) When the tank type and service event are known, 2) When the tank type and service event are unknown, and 3) When you want to generate the verification Excel spreadsheet files for many records at one time.

For this modeling tip, we'll use the “TankESP_Back_tutorial.accdb” as an example. Load this backend file into TankESP on your computer. In the service Data portion, change the period to Jan 2012.

How to Show Emission Calculation Steps using BREEZE TankESP - 1

1. Click on the Preview Emissions Data button. You should be able to see the emission estimations for all tanks and services, similar to the screenshot below.  How to Show Emission Calculation Steps using BREEZE TankESP - 2

As was mentioned above, this modeling tip covers the process for three scenarios. Feel free to jump to your specific scenario by clicking the following links: 1) When the tank type and service event are known, 2) When the tank type and service event are unknown, and 3) When you want to generate the verification Excel spreadsheet files for many records at one time.

Scenario 1: When the tank type and service event are known

2. In the data field, click on any cell of the tank for which you want to check the calculation. For example, if the T-0001 tank needs to be checked, then the T-0001 cell is clicked.

3. Click Show Calculation Steps. It will pop up a window, asking you to select a Calculation Steps Excel template.

4. T-0001 is a fixed roof tank with routine services, using the Post-2019 AP-42 method. Select “CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx”. It will automatically open an Excel file. For other scenarios, please use the table below to select the proper templates. For the next step, skip down to Step 5.

How to Show Emission Calculation Steps using BREEZE TankESP - 3

  How to Show Emission Calculation Steps using BREEZE TankESP - 7

Scenario 2: When the tank type and service event are unknown

In Scenario 1 above, the tank type and service event are known, so the correct Calculation Steps template is manually selected. What if they are unclear though? Which template shall the users select in that case? TankESP has another convenient and time-saving function that will automatically select the correct template.

2. In the data field, click on any cell of the tank for which you want to check the calculation. For example, if the T-0001 tank needs to be checked, then the T-0001 cell is clicked.

3. Hold Ctrl on keyboard and Click Show Calculation Steps. It will pop up a window. Instead of asking you to select a Calculation Steps Excel template, it will ask you to specify a folder.

4. Select a folder. It will automatically select the correct template, create an Excel file in the selected folder, and open the Excel file. Go to the Calculation Details sheet. It will indicate that the “CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx” template is selected. For the next step, skip down to Step 5.

How to Show Emission Calculation Steps using BREEZE TankESP - 4

Scenario 3: When you want to generate the verification Excel spreadsheet files for many records at one time

Scenarios 1 and 2 cover cases where only one individual service record is verified at a time using the Calculation Steps template. What if users have hundreds of service records? It would be nice to generate the verification Excel spreadsheet files for all the records at the same time. Fortunately, TankESP has this function too.

2. Hold Shift on keyboard and Click Show Calculation Steps.

3. A window will appear that will prompt you to specify a folder. Select the desired folder.

4. The software will automatically select the correct templates and create Excel files with calculation verifications in the selected folder for all service records. For example, in this case, it has five service records, and five Excel files are created. Users can go to the folder and open those files to verify the emission calculations. For the next step, skip down to Step 5.

How to Show Emission Calculation Steps using BREEZE TankESP - 5

 

5. Examine TankESP results by comparing them with Excel Spreadsheet calculations. See the screenshot below for an example:

  • Field 1 shows the actual equation used in Excel;
  • Field 2 shows the Excel calculation results;
  • Field 3 shows the reference equation in AP-42 Chapter 7;
  • Field 4 shows the TankESP results;
  • Field 5 shows the comparison results: “Okay” means the “automatic” TankESP results are validated and are the same as the “manual” Excel spreadsheet calculations. How to Show Emission Calculation Steps using BREEZE TankESP - 6

If you have questions when showing the calculation steps in BREEZE TankESP, please click the question mark button in the Admin area to access the user guide. You can also contact the BREEZE Support Team via email at support@trinityconsultants.com or by phone at +1 (972) 661-8881 ext. 4, and it will be our pleasure to assist you.