#### The Section 8 Calculator Tutorial

Slide 1 - Title Screen |  Slide 2 |  Slide 3 |  Slide 4 |  Slide 5 |  Slide 6 |  Slide 7 |  Slide 8 |  Slide 9 |  Slide 10 |  Slide 11 |  Slide 12 |  Slide 13 |  Slide 14 |  Slide 15 |

Slide 16 Slide 17 |  Slide 18 |  Slide 19 |  Slide 20 |  Slide 21 |  Slide 22 |  Slide 23 |  Slide 24 |  Slide 25 |  Slide 26 |  Slide 27 |  Slide 28 |  Slide 29 |  Slide 30 |

Slide 31 |  Slide 32 |  Slide 33 |  Slide 34 |  Slide 35 |  Slide 36 |  Slide 37 |  Slide 38 |  Slide 39 |  Slide 40 |  Slide 41 |  Slide 42 |  Slide 43 |  Slide 44 |  Slide 45 |

Slide 46 |  Slide 47 |  Slide 48 |  Slide 49 |  Slide 50 |  Slide 51 |  Slide 52 |  Slide 53 - This completes the TRI-MEweb Section 8 Calculator tutorial.

##### Slide 1 - Title Screen
Welcome to the TRI-MEweb Section 8 Calculator tutorial. This tutorial will explain how to review and edit TRI-MEweb's automatically calculated current year values for Section 8 of the Form R. The total running time of this tutorial is approximately 9 minutes.

##### Slide 2
One of the most complicated tasks in completing Form R reports is calculating current year Section 8 quantities. Section 8 also is the area of the form where errors are most common.

##### Slide 3
Current year Section 8 calculations are based primarily on data provided in Sections 5 and 6 of the form. The Forms and Instructions manual provides the formulas that are the basis for these calculations.

##### Slide 4
It is no longer necessary to rely on those formulas - TRI-MEweb automatically calculates Current Year Section 8 estimates based on the data users enter in Sections 5 and 6 of the Form R. As data is added or edited in Sections 5 and 6, TRI-MEweb's Section 8 Calculator will automatically prepare its Section 8 calculations and enter the data directly on the forms. TRI-MEweb's calculations can be reviewed at any time and tailored for each facility. To review a calculation, click the "Edit" button next to the calculated value - in this case the calculated value is 1,705 pounds.

##### Slide 5
[no transcript for slide]

##### Slide 6
[no transcript for slide]

##### Slide 7
[no transcript for slide]

##### Slide 8
After clicking the "Edit" button, TRI-MEweb displays the details of the calculation. Depending upon the specific reporting situation, there are a number of edits that can be made to TRI-MEweb's calculation. The most common edit users will make is to edit the numeric basis used in the calculation for a reported range code. TRI-MEweb defaults the numeric basis for range codes - shown in Column 2 - to the mid-point of the range. However, users should use the best data available to them, such as the calculated numeric estimate underlying their selection of the range code.

##### Slide 9
[no transcript for slide]

##### Slide 10
[no transcript for slide]

##### Slide 11
[no transcript for slide]

##### Slide 12
[no transcript for slide]

##### Slide 13
[no transcript for slide]

##### Slide 14
[no transcript for slide]

##### Slide 15
After making edits such as these, use the "Calculate" button to refresh the page and display the corrected calculation.

##### Slide 16
[no transcript for slide]

##### Slide 17
[no transcript for slide]

##### Slide 18
[no transcript for slide]

##### Slide 19
Another common edit would be to round the resulting calculation to the appropriate number of significant figures. EPA allows the rounding of reported values to two significant figures.

##### Slide 20
[no transcript for slide]

##### Slide 21
[no transcript for slide]

##### Slide 22
[no transcript for slide]

##### Slide 23
[no transcript for slide]

##### Slide 24
[no transcript for slide]

##### Slide 25
[no transcript for slide]

##### Slide 26
In some cases, a catastrophic event (or other one-time event not related to production processes) may have occurred at a facility that resulted in a release. If this is the case, enter the quantity of the release associated with the event in Column 3.

##### Slide 27
The calculator will automatically remove this quantity from the current calculation and include it in the Form R's Section 8.8.

##### Slide 28
[no transcript for slide]

##### Slide 29
[no transcript for slide]

##### Slide 30
[no transcript for slide]

##### Slide 31
[no transcript for slide]

##### Slide 32
[no transcript for slide]

##### Slide 34
Note that the calculated Section 8.1b quantity has been updated to 1,200 pounds and reflects the edits made by the user.

##### Slide 35
If a facility transfers one or more TRI chemicals in wastewater to a Publicly Owned Treatment Works, it is important to understand how the TRI-MEweb calculator handles these transfers. EPA guidance states that the quantity of TRI chemicals transferred to POTWs be included in Section 8.1c, 8.1d, or 8.7 consistent with the ultimate disposition of the TRI chemical.

##### Slide 36
By default, the TRI-MEweb Calculator assumes that...Metals and metal compounds transferred to a POTW are NOT TREATED by the POTW and are ultimately otherwise disposed and/or released (this means that 100% of the Section 6.1 transfer quantity is included in Section 8.1d by default).

##### Slide 37
For Non-metals that are transferred to the POTW, TRI-MEweb assumes they ARE TREATED by the POTW (this means that 100% of the Section 6.1 transfer quantity is included in Section 8.7 by default). If a facility has readily available information regarding the ultimate disposition of the TRI chemical from the POTW, then a user may edit the TRI-MEweb assumed dispositions. Otherwise, use the assumed dispositions.

##### Slide 38
Let's look at a sample calculation for a non-metal compound. In this example, a facility has reported a 1,500 pound POTW transfer in Section 6.1 for the chemical Benzene. As discussed on the prior page, the TRI-MEweb calculator will assume that 100% of the transfer quantity is treated by the POTW and, as a result, will include the entire 1,500 pound transfer in Section 8.7. In this case, however, the facility has data...that indicates an estimated 90% of the Benzene is treated at the POTW, 9% volatilizes from the treatment process and 1% is ultimately disposed in wastewater treatment sludge at the municipal landfill.

##### Slide 39
[no transcript for slide]

##### Slide 40
This is the Section 8.7 Details page showing how TRI-MEweb has calculated the Section 8.7 quantity for Benzene. Note that TRI-MEweb assumes 100% of the Benzene POTW transfer is treated at the POTW and, as a result, the entire 1,500 pounds is being included in the Section 8.7 quantity. To edit this default assumption, click on the percentage.

##### Slide 41
[no transcript for slide]

##### Slide 42
[no transcript for slide]

##### Slide 43
Users are now presented with a page that enables them to define the ultimate distribution of the POTW transfer by specifying the percentage of the transfer that is treated, disposed in a Class I UIC well or landfill, or otherwise released or disposed. In this example, we have better information indicating 90% of the Benzene is treated at the POTW,

##### Slide 44
[no transcript for slide]

##### Slide 45
[no transcript for slide]

##### Slide 46
[no transcript for slide]

##### Slide 47
1% is ultimately disposed in wastewater treatment sludge at the municipal landfill,

##### Slide 48
[no transcript for slide]

##### Slide 49
[no transcript for slide]

##### Slide 50
and 9% volatilizes from the treatment process. After clicking the "Calculate Percentage Total(s)" button and reviewing your work, click "Next."

##### Slide 51
[no transcript for slide]