Re: Source apportionment modeling files Doug Boyer to: Erik Snyder, Zarena Post 03/09/2012 02:25 PM Cc: "Dick Karp", "Jim Smith", "Stephen Davis", "Weining Zhao"

From: "Doug Boyer" <Doug.Boyer@tceq.texas.gov>
To: Erik Snyder/R6/USEPA/US@EPA, "Zarena Post" <Zarena.Post@tceq.texas.gov>
Cc: "Dick Karp" <Dick.Karp@tceq.texas.gov>, "Jim Smith" <Jim.Smith@tceq.texas.gov>, "Stephen Davis" <Stephen.Davis@tceq.texas.gov>, " Weining Zhao" <Weining.Zhao@tceq.texas.gov> History: This message has been forwarded.
2 attachments

Hi Erik,

As we discussed this morning, attached are the design value component files for the Matagorda and Hood/Wise APCA runs ( 7-zipped ). For each file the top group is the APCA baseline run and the bottom is the APCA future run (total or source category/region). The values not in brackets are used to calculate the RRF (future/base, 2nd to last column) and the DVf (last column).

How did we calculate the contribution to the design value from APCA source regions/categories?

1. Our IDL procedures find the modeled daily eight-hour maxima and corresponding cell indices (i,

j ,hour) from the NxN cell array around each monitor from the APCA run's total hourly concentration output (base and future years).

2. The future year APCA component ozone concentration files (e.g. Hood County or IC/BC) were read to extract the data at the same cell indices as above. The component data is also summed at this step to get accumulated source region/category totals.

3. The contribution to the future design values are then calculated as the (future component/total base)*(Observed Baseline Design Value). Or (Step 2/Step 1)*DVb.

If you want to get a little dirty, you can follow the formulas in the "Hood-Wise

_ DVf

_ Contribution

_ wPies.xlsx" file previously provided. I used the regular APCA output files that contain the NxN cell average rather than the maximum as in Step 1 above. I had to pick the days used in the standard DVf calculation and find the maximum modeled hour. I averaged those from the base and future to get the nominator and denominator of the RRF. You'll see that the final contribution to the DVf are quite close but not exact (avg vs max).

Confused yet? If so, let's talk again.Doug

______________________________________ Doug Boyer Texas Commission on Environmental Quality Air Quality Division (512) 239-1523 doug.boyer@tceq.texas.gov Please consider the environment before printing this email

>>> Zarena Post 3/9/2012 7:56 AM >>> Hi, Erik,

As we discussed yesterday, attached is a corrected version of the Matagorda

_ DVf

_ Contribution spreadsheet. I've appended "corrected" to the file name to distinguish it from the original.

Here is a summary of the changes in Matagorda contribution to various HGB monitors, as a result of corrections:

Matagorda contribution to MACP in 2006 goes from 1.05 to 0.70 p pb (Figure 26)

Matagorda contribution to HNWA in 2006 goes from 1.86 to 1.54 p pb (Figure 30)

Matagorda contribution to TXCT in 2006 goes from 1.63 to 0.55 p pb (Figure 32)

Matagorda contribution to WALV in 2006 remains unchanged at 0.46 p pb.

Let us know if you need anything else.

Thanks! Zarena

>>> Erik Snyder <Snyder.Erik@epamail.epa.gov> 3/6/2012 4:14 PM >>> That will work fine. I'll grab them first thing in the morning and let you know that I have them.

Thanks for the quick turnaround. -Erik

Lead Regional Air Quality Modeler EPA Region 6 Phone: 214-665-7305 Fax: 214-665-7263 email: snyder.erik@epa.govFrom: "Zarena Post" <Zarena.Post@tceq.texas.gov>

To: Erik Snyder/R6/USEPA/US@EPA Cc: "Doug Boyer" <Doug.Boyer@tceq.texas .gov>, "Jim Smith" <Jim.Smith @tceq.texas.gov>, "Stephen Davis" <Stephen.Davis@tceq.texas.gov>, "Zhaohua Fang" <Zhaohua.Fang@tceq.texas.gov>

Date: 03/06/2012 03:32 PM Subject: Re: Source apportionment modeling files

Hi, Erik,

I've posted a bunch of APCA-related files on our FTP site that will mirror at 2 AM tomorrow morning - unless you want them sooner, j ust let us know pretty quick.

The address will be ftp://amdaftp.tceq.texas.gov/ p ub/file

_ transfer/forEPA/ and within that directory will be a folder called "TCEQ Ozone TSD". You should be able to log in anonymously. I've included the APCA output files for both HGB and DFW; and 4 spreadsheets - 2 wavy bacon (one each for HGB and DFW) and 2 DVf contribution (one each for HGB and DFW).

Let us know if you have any questions.

Thanks! Zarena

>>> Erik Snyder <Snyder.Erik@epamail.epa.gov> 3/6/2012 11:43 AM >>> Hi Zarena,

I am writing to request the supporting materials for the comments that TCEQ provided for the proposed designations area in Houston and Dallas. Could you provide the source original apportionment files from the modeling run (I believe they are csv format). Could you also provide the information used for the graphics supplied in the letter. When I looked at the time series plots of the source apportionment, it did not appear that the actual county was plotted in the graphics in the color pdf version we received.

Due to our deadlines, we are trying to turn a summary of comments received around quickly and this information would help greatly in this process.

Please call me to discuss or if you have any questions Thanks, Erik

Lead Regional Air Quality Modeler EPA Region 6 Phone: 214-665-7305 Fax: 214-665-7263email: sn y der.erik @ epa. g ov