1

From: "Bahner, Mark A." <bahner@rti.org>

To: "Blodgett, Terry L." <Terry.Blodgett@alcoa.com>

Cc: Rochelle Boyd/RTP/USEPA/US@EPA, <Michael.Palazzolo@alcoa.com>

Date: 04/07/2011 04:58 PM

Subject: RE: Alcoa plants with spreadsheet problems

Hi Terry,

Thanks so much. I’ve got a GIS guy looking at the issue; there may not be a problem after all. If there is, I’ll give you

a call.

Thanks again,

Mark

Mark A. Bahner

RTI, International

P.O. Box 12194, 3040 Cornwallis Road

Research Triangle Park, NC 27709

- 2194

Phone: (919) 541

- 6016

Fax: (919) 541

- 7155

Email: bahner@rti.org

Internet: http://w ww.rti.org

From: Blodgett, Terry L. [ mailto:Terry.Blodgett@alcoa.com ]

Sent: Thursday, April 07, 2011 4:37 PM

To: Bahner, Mark A.

Cc: Boyd.Rochelle@epamail.epa.gov

Subject: RE: Alcoa plants with spreadsheet problems

Mark,

My cell phone number is the best way to contact me. That number is 512

- 760

- 8800. Contact me anytime.

Terry

From: Palazzolo, Michael A.

Sent: Thursday, April 07, 2011 10:54 AM

To: Bahner, M ark A.

Cc: Boyd.Rochelle@epamail.epa.gov; Putney.David@epamail.epa.gov; Green, David A.; Chrest, David;

Blodgett, Terry L.

Subject: RE: Alcoa plants with spreadsheet problems

Mark,

Rockdale reviewed the Release Point coordinates and did not find an y errors. It’s2

not clear why the points are shifted when you plot them. I also plotted a couple

points and they look fine. Could there be some sort of a rounding error?

You had also requested us to update the Category HAPs file for Rockdale. The

co rrections were marked in the Category HAP sheet provided by Rockdale in

January. Another copy is attached. For example, Column U has the revised

emission rates.

If you still have questions on these sheets, please contact Terry Blodgett at

Rockdale di rectly.

Thanks,

Mike

From: Palazzolo, Michael A.

Sent: Thursday, April 07, 2011 8:22 AM

To: 'Bahner, Mark A.'

Cc: 'Boyd.Rochelle@epamail.epa.gov'; 'Putney.David@epamail.epa.gov'; 'Green, David A.'; 'Chrest,

David'; Hulse, David G.; Moore, Chris N.

Subject: RE: Alcoa plants with spreadsheet problems

Mark,

The Alcoa TN and Wenatchee plants both reviewed their Release Point Spreadsheets

and conclude that the coordinates in these sheet s should be correct. Coordinates in

the Category HAP file are the ones that were wildly off and you should ignore these.

Wenatchee did submit a Category HAP sheet in January 2010 (as attached). Dave

Hulse at Wenatchee said that rows marked in red s hould be deleted from this file as

they are non

- MACT sources.

If you still have questions about accuracy of the Release Point coordinates, you

should contact Dave Hulse at Wenatchee or Chris Moore at TN directly to resolve.

We still need to doubl e

- check that Rockdale files.

Thanks,

Mike

Michael Palazzolo

Alcoa, Inc.

201 Isabella Street

Pittsburgh, PA 15212

- 5858

Ph: 412

- 553

- 48323

From: Palazzolo, Michael A.

Sent: Wednesday, March 30, 2011 2:27 PM

To: 'Bahner, Mark A.'

Cc: Boyd.Rochelle@epamail.epa.gov; Putney.David@epamail.epa.gov; Green, David A.; Chrest, David;

Rufa, Nathan P.

Subject: RE: Alcoa plants with spreadsheet problems

Mark,

You need to be aware that none of the “dots” from the Category HAP spreadsheets

w ere revised as part of Alcoa’s review. We were only requested by EPA to revised

the point source coordinates in the Release Point file. If you need corrected

coordinates in both spreadsheets please copy coordinates from Release Point

spreadsheets to the Category HAP spreadsheets.

I have asked people from Massena, Tennessee, Wenatchee and Rockdale to double

check the files you sent to us. At least two of the key people are out of the office

and will not get to this task until next week.

Massena has completed their review. They found a typo for one coordinate in the

Massena East Release Point file and a revised Massena East (Reynolds) Release

Point file is attached. For the January submittal, they neglected to send the

Massena West Release Point file with the others. This file is also attached.

I will forward additional corrections after we double

- check the files. Please let me

know if you have additional questions.

Thanks,

Mike

Michael Palazzolo

Alcoa, Inc.

201 Isabella Stree t

Pittsburgh, PA 15212

- 5858

Ph: 412

- 553

- 4832

From: Bahner, Mark A. [ mailto:bahner@rti.org ]

Sent: Wednesday, March 23, 2011 3:09 PM

To: Palazzolo, Michael A.

Cc: Boyd.Rochelle@epamail.epa.gov; Putn ey.David@epamail.epa.gov; Green, David A.; Chrest, David

Subject: Alcoa plants with spreadsheet problems4

Hi Mike,

Per our meeting on Monday, here are the Alcoa plants that have Excel spreadsheets that have problems. We think

we’ve removed all the n on

- primary

- aluminum points. There are spreadsheets and jpgs (made from Google Earth

files that contain the lat/longs from the spreadsheets). For Alcoa TN, there are three jpgs, because some of the

points are not in TN.

Here’s a table to explain the col ors of the dots versus the spreadsheet name:

Plant Dot Color/Spreadsheet

ID Comments

Wenatchee,

WA Red/ReleasePoint No CategoryHAPs spreadsheet

Alcoa, TN Red/ReleasePoint

Blue/CategoryHAPs Something very weird happening. A bunch of points are in NC, way

outside the plant.

Massena West Red/CategoryHAPs No ReleasePoint spreadsheet

Massena East Purple/ReleasePoint

Blue/Category HAPs Purple (ReleasePoint) looks reasonable; blue (CategoryHAPs) does not.

Rockdale Red/ReleasePoint No CategoryHAPs spreadsheet

Best wishes,

Mark

Mark A. Bahner

RTI, International

P.O. Box 12194, 3040 Cornwallis Road

Research Triangle Park, NC 27709

- 2194

Phone: (919) 541

- 6016

Fax: (919) 541

- 7155

Email: bahner@rti.org

Internet: http://www.rti.org