Home

AER Returns Excel Worksheet – User Manual

1. Fill out this section for Contact amp Facility Details 2 PRTR CLASS ACTIVITIES Activity Number ity Nam 7 a i Installations for the intensive rearing of poultry or pigs i 3 SOLVENTS REGULATIONS 5 1 No 543 of 2002 Fill outihic section for Have you been granted an exemption lf applicable which activity class applies as per Schedule 2 of the regulations Is the reduction scheme compliance route being used 4 WASTE IMPORTED ACCEPTED ONTO SITE Guidance on waste imported accepted onto site Fi Do you import waste onto your site for on pi Te either ee es ranted ill out this section for waste activities imported accepted onto site This question is only applicable if you are an IPPC or Quarry site Fig 2 2 Facility ID amp Activities Sheet This worksheet contains Licensee specific information about the facility making the return Most of this sheet will have been pre filled when you downloaded the file from the website This will only leave certain areas to be filled out The following areas should be filled out on this worksheet Production Volume Production Volume Units Number of Installations Number of Operating Hours in Year Number of Employees User Feedback Comments Web Address If you cannot fill in these sections then please ensure that the cell contains a default value of 0 rather than blank Otherwise your upload may be rejected You should a
2. Do you want to open or save this file a Name 0057_2010 xls Type Microsoft Excel 97 2003 Worksheet 975KB From aer epa ie harm your computer If you do not trust the source do not open or C While files from the Internet can be useful some files can potentially save this file What s the risk ensure the workbook is saved in the correct format You can then proceed to open the workbook Make sure that macros have been enabled in Excel before filling out the PRTR workbook When saving the PRTR workbook as you are completing it use the Save button If you do select Save As make sure you save the PRTR workbook as Excel 97 2003 workbook for Office 2007 and higher Year of Return Download Excel File Download Excel Ternplate Download Enabling Macros Document Enabling macros in Excel 2000 to 2003 Enabling macros in Excel 2007 Download XSD Download XSD Schema EPA 2011 Contact us Disclaimer Privacy Policy Change Display Preferences Accessibility Statement Glossary of Terms ca Done Fig 1 5 Saving the Excel file a eae Internet e Click the Save button and save the file to your computer e You can now open the Excel file on your computer and begin filling in your return information See section on Excel sheet for details Page 7 of 50 DJ 7 Qio 1 3 Downloading the XSD Schema AER PRTR Windows Internet Explorer A Go eee htt
3. e To select a code double click on it where you will then be brought to the next section of codes under the selected one Page 29 of 50 FJ Microsoft Excel 40013_2006 xIs la x B9 Fie Edit view Insert Format Tools Data Window Help Type a question for help X Od BISA F GB Ga FI 4 ll B 100 B i snaote e window B A k E E RON E Ye Reply with Changes End Review s i Arial z710 B Z U ZE n 390 3 EI oP AW A56 X f OF E oO OO a 33 02 05 wastes from the dairy products industry 34 02 06 wastes from the baking and confectionery industry 35 02 OF wastes from the production of alcoholic and non alcoholic beverages except coffee tea and cocoa 36 p3 01 wastes from wood processing and the production of panels and furniture 03 02 wastes from wood preservation 38 p3 03 wastes from pulp paper and cardboard production and processing 39 p4 01 wastes from the leather and fur industry 40 p4 02 wastes from the textile industry 41 p5 01 wastes from petroleum refining 42 05 06 waste from the pyrolytic treatment of coal 43 905 07 waste from natural gas purification and transportation 44 06 01 wastes from the manufacture formulation supply and use MFSU of acids 45 06 02 wastes from the MFSU of bases 46 906 03 wastes from the MFSU of salts and their solutions and metallic oxides 6 04 metal containing wastes other than those mentioned in 06 03 48 06 05 sludges from on site effluent treatment 49 6 0
4. Filling in the Method Used section continued Page 16 of 50 e Next enter the quantities of release for this pollutant under Emission Point 1 This will appear in the Total Quantity cell also Quantities are expressed in KGs per year QUANTITY Emission Point 1 T Total Karr ear 4A Accidental KG ear F Fugtiwe KG ear Oo Oo Oo Oo Fig 2 21 Filling in the release quantities __ ADD EMISSION POINT QUANTITY Emission Point 1 T Total KGY ear 4 Accidental Ka ear F Fugitive KG ear 438 455 T 0 Fig 2 22 Filling in the release quantities continued If any Accidental or Fugitive releases for this pollutant are applicable then enter these under the Accidental or Fugitive section otherwise leave these as 0 __ ADD EMISSION POINT QUAHTITY Emission Point 1 T Total KEGY ear 4 Accidental KG ear F Fugitive KG ea 458 594 F 100 56 Fig 2 23 Filling in the Accidental and Fugitive quantities optional e If you have releases from more than one Emission Point then you can add additional points by clicking on the ADD EMISSION POINT button This will add an additional Emission Point column to the right of the last one A maximum of 9 points can be used ADD EMISSION POINT QUANTITY Accident F Emission Point 1 Fig 2 24 Adding additional Emission Points e The Accidental and Fugitive quantities represent the totals for ALL emission points and not one particular point e You can also ent
5. 20 A25 TA luft inorganic dust particles class 1 A25 TA luft inorganic dust particles class 1 21 A26 TA luft inorganic dust particles class 2 A26 TA luft inorganic dust particles class 2 22 A27 TA luft inorganic dust particles class 3 A27 TA luft inorganic dust particles class 3 23 A28 TA luft organics class 1 A26 TA luft organics class 1 24 429 TA luft organics class 2 A29 TA luft organics class 2 25 A3 Acetic acid A3 Acetic acid 26 JA30 TA luft organics class 3 A30 TA luft organics class 3 27 A31 Thalium compounds A31 Thalium compounds 28 A32 toluene di isocyanate A32 toluene di isocyanate 29 433 total acids A33 total acids 30 434 total organic carbon as C A34 total organic carbon as C l 31 JA35 vandium A35 vandiurn 32 A36 volumetric flow rate A36 volumetric flow rate 33 JA37 water vapour Aa water vapour 34 A4 amines A4 amines 35 45 antimony AS antimony 36 46 Class B organics AB Class B organics 37 A7 Combustion efficiency A Combustion efficiency 38 48 condenseable volatile organic compounds AB condenseable volatile organic compounds 39 Ag dimethylformamide AQ dimethylformamide 40 v1 acetate W1 acetate 41 w10 dissolved oxygen W410 dissolved oxygen 42 W11 faecal coliforms W411 faecal coliforms 43 w12 faecal streptococci W12 faecal streptococci 44 W13 fats oils and greases W13 fats oils and greases 45 W14 formaldehyde W14 formaldeh
6. 50 Cell specific help red triangle 2 0 The Excel Workbook 2 1 Introduction The AER Returns Excel workbook is divided into numerous worksheets The first group of worksheets form the AER return once filled in by the licensee The remaining worksheets provide reference material to assist in the filling out of the data Help can also be found within the Excel sheet by either clicking on the HELP button or by hovering your mouse over the red triangle in cells that include comments Please note Facility contact details will no longer be auto populated The facility will have to enter these details into their workbook annually EJ Microsoft Excel A0013_2006 xIs a x ype a question For help X File Edit View Insert Format Tools Data Window Help DF PEE EET EE 4h T 25 Bi sract est window P ee a a To a 5 ga ith Changes End Review J Arial 10 B Z U 228 9 t 300 E E cy Oy AB AAS x A B Z D E F ia 4 I A E epa 5 6 3 Environmental Protection Agency AER Returns Worksheet Reference Year 9 REFERENCE TEAR 2 06s EE j a for return being 11 141 FACILITY IDENTIFICATION eke made FaciltyName John Smith Facility O OCOCOC NN S yO er PRTR Identification Number 15 Licence Number EE Te re er ae ae Facility details SSE Ba past Adesso O Waste or IPPC 24 City Town Village Carlow Pn 25 PostalCode O O O OOOO UOO O S Classes of Activity d
7. Save cede tance _ Whe CREATE AER XML RETURN amp UPLO your XML Return file this is the finish While files from the Internet can be useful some files can potentially o the AER PRTR Reporting folder you t Q harm your computer If you do not trust the source do not open or wee save this file What s the risk Whers orte srrvook before opening it This will Al ensure the workbook is saved in the correct format You can then proceed to open the workbook Make sure that macros have been enabled in Excel before filling out the PRTR workbook When saving the PRTR workbook as you are completing it use the Save button If you do select Save As make sure you save the PRTR workbook as Excel 97 2003 workbook for Office 2007 and higher Year of Return Download Excel File Download Excel Ternplate Download Enabling Macros Document Enabling macros in Excel 2000 to 2003 Enabling macros in Excel 2007 Download XSD Download XSD Scherna EPA 2011 Contact us Disclaimer Privacy Policy Change Display Preferences Accessibility Statement Glossary of Terms da Start downloading From site http aer epa ie reporting pqDownloadAERData aspx amp Internet fa amp 100 me Fig 1 6 Saving the XSD file e Click the Download XSD Schema button e You will be presented with a Save As dialog box e Click the Save button and save the file on your computer Page 8 of
8. betting activities 9200 8 97 0 0 Activities of households as employers of domestic personnel 9700 9 J39 0 0 Activities of extraterritorial organisations and bodies 9900 10 02 1 0 Silviculture and other forestry activities 0210 11 05 1 0 Mining of hard coal 0510 12 06 1 0 Extraction of crude petroleum 0610 13 J07 1 D Mining of iron ores 0710 14 09 1 0 Support activities for petroleum and natural gas extraction 0910 15 13 1 0 Preparation and spinning of textile fibres 1311 16 16 1 0 Sawmilling and planing of wood 1610 19 1 0 Manufacture of coke oven products 1910 18 21 1 0 Manufacture of basic pharmaceutical products 2100 19 24 1 0 Manufacture of basic iron and steel and of ferro alloys 2410 20 29 1 0 Manufacture of motor vehicles 2910 21 141 1 0 Development of building projects 4100 22 149 1 0 Passenger rail transport interurban 4911 23 50 1 0 Sea and coastal passenger water transport 5011 24 51 1 0 Passenger air transport 5110 25 52 1 0 Warehousing and storage 5210 26 53 1 0 Postal activities under universal service obligation 5310 27 55 1 0 Hotels and similar accommodation 5510 28 56 1 0 Restaurants and mobile food service activities 5610 29 60 1 0 Radio broadcasting 6010 30 61 1 0 Wired telecommunications activities 6110 31 68 1 0 Buying and selling of own real estate 6810 32 69 1 0 Legal activities 6910 33 70 1 0 Activities of head offices 7010 34 74 1 0 Specialised design activities 741
9. e Section A represents sector specific pollutants which apply to air and are based on your class activities e Section B represents all remaining pollutants that could be released to air but are not contained in Section A e This division of pollutants allows for quicker and more intuitive filling out of the worksheet as pollutants are grouped by priority e The third section Section C provides an area to fill in licensed pollutants e An additional section for Landfill operators must be filled out also e Enter a Total KG Year Method used details and the Facility Total Capacity as appropriate e Each section is filled in the same manner e Begin by selecting a pollutant from the dropdown list under the pollutant section e When you select a pollutant the pollutant number and name will appear in the corresponding cells Page 11 of 50 e Fill in the method used section of the worksheet by selecting a method from the dropdown list Only Measured Calculated or Estimated are the values that can be entered here e The Method code field is not free test and you must double click on the cell to select a relevant method code e The Designation or Description is a free text cell You must enter a value into all of these cells under the Method Used section or you will receive an error when you attempt to create the XML return file for uploading SECTION A SECTOR SPECIFIC PRTR POLLUT Clicking on the dropdown reveals a list of availabl
10. gt Cpa Environmental Protection Agency AER Returns Excel Workbook amp Website User Manual Version 2 1 January 2015 Table of Contents 1 0 Downloading the Configured Excel Workbook or XSD Schema s sssssnusnnnnnnnnnnnnnnnnnnnnnnnnnnnn tL MO OMY Ti eener E E EE EE E E E E TAN 1 2 Downloading the Configured Excel Workbook snssssssseeenssssssssseeresssssssseeresssssssseeeess 1 3 Downloading the XSD Schema 3 023 csssceascassatdecsssteencdsenncccddeaeeacdeanecedeesdvenedeannscondaaiaenteaaen 2 0 The Excel WOrKDOOK rriren A AEE aana ZAM VEO LE S e PATE A E A EEE E E AEEA E A vid ON EA Ded Facility ID amp Ac vites 9 NCC loses ESS DD R Ee O A SINC Cl ee e a A E E E E E AERE Pa EE E E E E E AE A SE EAEE EE 2 3 Offsite Transfers of PolMtantS auc ivsstonsesionanessiitstearecoiciasiauicenkereaasaearaacoasecasieessaviceesesncasiaiees LOR a S o LEA e re E E AA E E OA A Ze Trennen A l ransiers Ol WaslEeseeonia s EE A NO 28 AA Oo BL Glo SUCCI eve re ence 3 0 Creating amp Submitting an AER Returnn cccccccsescsseeeeeeseecssseseeeeeeeeeeessseeeeeeeseceensneeeeeesseoonennes ILLO OU TN eE saeeleacaaessnesennessestca E E E A E E E E E E 3 2 Uploading the completed XML return file sssnneneneessssoeennssssssseeeerssssssssseeresssssssseeeees Sg RAVI pats aire asserts ot ape EEE EE E E E A ES EE Page 1 of 50 1 0 Downloading the Configured Excel Workbook or XSD Schema 1 1 Logging In Navigate to the login page of
11. se Eoforcariar hianat Betecserrary gt ADA PRTA Aapering Pee ieee Daia AER PRTR Emissions Data Upload Page Horen Page About ARN PRM Testruchions tor uploading your XMI Retuen tle trad ore Durara Amass te the location where you saved your YM Return Me then det the lintoad We urtin neh When you have ugloeded vuur YM return bis you eed be mtd by the wetate that your upbeded hie Veer Marne Enpa na eun manng ecoepterce by our ASR PRIR detatwee A tracheng morba is attached to togeut thes notiicabon thes tracts maser shoud be retamed for future reterence When thee coepisti wuccasshsly a Verticatar of Acoepterce wnai miks wid be sent bo you enai atid ws conferred wt Oe rniomubon hss been accepted by thw ALA PRIM database thre ususdy tabas 24 hous Agee Cree enai choad be retaned carwtuly F yout Workbook m NOT suctesafully accepted by the database Yuewction nutfcabon wil be sere bo your enai ackbess Thw anad n erdeate witat the probier a Please follow the miuto un thre Raaton bo fix the preterm and upload sgen voor of totum nu Usetent fe C Tee 00ST_209 wel CPA DOLL Cortes ag Dadana 2ra Sda Cheers Duchy Preferercas Scape te te Sipser Sanari Tantu wed ER Ite ape l rimt S Sim Fig 3 8 Selecting the file for uploading e If the file uploaded without any errors then a confirmation page will be displayed e Your upload will be processed by the EPA e Check your em
12. the AER PRITR returns site ga wss ma R i x amp p e Fe Vew fetes Tok e Wiest YB renee ae RTE a o 1 rt hps moys Tooke O ao Home Loatart ut Ane Map bP A Mage Wiew Cart 3 a Vou Soe Mere honie gt Di oe Ag gt eoccerers gt Leatoe eforceriars gt ASE PRT heporrg ihoa AER PRTR Welcome to the AER PRTR Annual Environmental Reporting Website meians Docisterte Thie vedete wil anent you n mating your anrua returns of envronsertal reformation a required under your GPA ikence end or under the PRTR Reguahons The ate provider fd Quedance on the etormatian to De fMeHO ed aod Prowdes TOU To Jw you 00 do mis Cite nd ficrta Chk On the Gualavwe Co ouments box an the Wt hand naviganon De To emie the atte plewee provda your urecue Usernere acd p eernword Fisse core that the tapti hae now been rerioved from the bon paot Your utamane ad Password Oe AOE Change from ysa bo reat Ean g Sas IOL Cortes as Qomceeree Enap Stry Sna Opiy Ceianaas 4 Mp ren Moe bowen ty Q rria Ris Fig 1 1 Login page Here you will need to enter the following details e Your User ID As supplied to you by the EPA e Your password As supplied to you by the EPA Page 2 of 50 MEJLI PHIR Woridews islo ie eelore Gare menemen eS x e O Pie ES Vep Poceo Teb tb ee E ES roe ie E hein E e a eee ets B D rr d m O trrescerertal Protectan Acercy You ere here forts gt Ab
13. wastes from fruit vegetables cereals edible oils cocoa coffee tea and tabacco preparation and p 32 02 04 wastes from sugar processing 33 02 05 wastes from the dairy products industry 34 02 06 wastes from the baking and confectionery industry 35 02 oF wastes from the production of alcoholic and non alcoholic beverages except coffee tea and cocoa 36 03 01 wastes from wood processing and the production of panels and furniture 37 03 02 wastes from wood preservation 38 03 03 wastes from pulp paper and cardboard production and processing 39 04 01 wastes from the leather and fur industry 40 04 02 wastes from the textile industry 41 105 01 wastes from petroleum refining 42 05 06 waste from the pyrolytic treatment of coal 43 05 OF waste from natural gas purification and transportation 44 06 01 wastes from the manufacture formulation supply and use MFSU of acids 45 06 02 wastes from the MFSU of bases 46 J06 03 wastes from the MFSU of salts and their solutions and metallic oxides 47 06 04 metal containing wastes other than those mentioned in 06 03 gt M Releases to Land Treatment amp Transfers of Waste _ Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Re gt ha Fig 2 61 The EWC Reference Sheet e Select the appropriate chapters to build the waste code These are broken into Group SubGroup and Code on the reference sheet
14. 0 35 78 1 0 Activities of employment placement agencies 7810 36 a0 1 0 Private security activities 8010 37 81 1 0 Combined facilities support activities 6110 l 38 85 1 0 Pre primary education 8510 39 86 1 0 Hospital activities 6610 40 87 1 0 Residential nursing care activities 6710 41 88 1 0 Social work activities without accommodation for the elderly and disabled 8810 42 98 1 0 Undifferentiated goods producing activities of private households for own use 9810 43 02 2 0 Logging 0220 44 05 2 0 Mining of lignite 0520 45 06 2 0 Extraction of natural gas 0620 46 10 2 0 Processing and preserving of fish crustaceans and molluscs 1020 13 2 0 Weaving of textiles 1312 M 4 gt M Treatment amp Transfers of Waste Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Ref RecovererDisposer 4 gt Fig 2 77 NACE Codes Reference Sheet Page 36 of 50 Ref PRTR Activities This worksheet contains reference information for PRTR Class Activities EJ Microsoft Excel 40013_2006 xlIs E a x a File Edit View Insert Format Tools Data Window Help Type a question for help X Oe ee BSG WA Y Bl amp aA FI A 2l KI fl a 100 P i snag E window B EEE E E EE ERSE E Ba Ve Reply with Changes End Review p Arial 10 B z u c gt E Ill iil E1 z f amp Capacity_Threshold E T EA 1 Activity Group Activity SubG
15. 09 Conditional Format Cell Insert Delete Format Sot amp Find amp lt J Format Painter u a 5 3 oad Formatting as Table Styles 7 X X 2 Clear Filter Select Clipboard ET Font G Alignment E Number F Styles Cells Editing i4 4 gt P Ref Waste Codes Ref RecovererDisposer Codes lt Ref Method Codes lt Misc Lookups lt Ref Help lt Waste Detais 1 lt Waste Details 2 Previous YelJ _ m T em Count 58 E a0 O Fig 2 82 Recoverer Disposer Codes Reference Sheet o Page 41 of 50 Ref Methods Used This worksheet contains reference information for Methods Used A come Insert Page Layout Formulas Data Review View a Q o e m Cut 7 E H Port Autos X Arial jo JA s FS s E Wrap Te Text lt 4 x gm i E ii 2 AutoSum AY B Copy 7 g Fill Paste B Z U A B S E E Merge amp Center WI gt 8 399 Conditional Format Cell Inset Delete Format Sot amp Find amp lt J Format Painter a SF Eid Mero 3 gt seen Formatting 7 as Table Styles r r X 2 Clear Filter Select v Clipboard F Font Alignment r Number a Styles Cells Editing vr Mercury amp Compounds as Hg A B _ 1 Select a code by double clicking on the method cade cell below 2 3 4 5 6 Methods used for determination of releases to air Method Identification Codes 20 21 I 23 24 25 27 28 inns M 4 gt Ref Waste Codes Ref R
16. 37 Filling in the Accidental and Fugitive quantities optional e If you have releases from more than one Emission Point then you can add additional points by clicking on the ADD EMISSION POINT button This will add an additional Emission Point column to the right of the last one A maximum of 9 points can be used __ ADD EMISSION POINT _ QUANTITY Emission Point 1 Emizsian Point 2 Fig 2 38 Adding additional Emission Points e The Accidental and Fugitive quantities represent the totals for ALL emission points and not one particular point e You can also enter comments or a description of each emission point in the grey cell over the emission point e In order to add another pollutant in a particular section you must click the ADD NEW ROW button Click the ADD button _ ADD Nev Rowy DEL AST Roy Fig 2 40 Adding a new row to enter another pollutant Step 2 Page 21 of 50 e If you have made a mistake and wish to remove the last row entered then click the DELETE LAST ROW button in the relevant section SECTION A PRIR POLLUTANTS OFFSITE TRANSFER OF POLLUTANTS DES Click the DELETE button A ri BA JEW RON E Pa Fig 2 41 Deleting a row Step 1 warning eee xj xX Ore you sure vou want to delete the last row All data on this row will be lost Fig 2 42 Deleting a row Step 2 SECTION A PRIR POLLUTANTS OFFSITE TRANSFER OF POLLUTANTS DES Fig 2 43 D
17. 6 wastes from the MFSU of sulphur chemicals sulphur chemical processes and desulphurisation pro 50 06 OF wastes from the MFSU of halogens and halogen chemical processes 51 06 08 wastes from the MFSU of silicon and silicon derivatives 62 06 09 wastes from the MFSU of phosphorus chemicals and phosphorous chemical processes 53 06 10 wastes from the MFSU of nitrogen chemicals nitrogen chemical processes and fertiliser manufactu 54 6 11 wastes from the manufacture of inorganic pigments and opacificiers 55 p6 13 wastes from inorganic chemical processes not otherwise specified 58 59 60 61 62 63 wastes from MFSU and removal of paint and varnish 64 p8 02 wastes from MFSU of other coatings including ceramic materials 65 p8 03 wastes from MFSU of printing inks 66 p8 04 wastes from MFSU of adhesives and sealants including waterproofing products Da 05 wastes not otherwise specified in 08 68 p9 01 wastes for the photographic industry 69 f0 01 wastes from power stations and other combustion plants except 19 10 02 wastes from the iron and steel industry 10 03 wastes from aluminium thermal metallurgy 10 04 wastes from lead thermal metallurgy 10 05 wastes from zinc thermal metallurgy 10 06 wastes from copper thermal metallurgy 10 OF wastes from silver gold and platinum thermal metalurgy 10 08 wastes from other non ferous thermal metallurgy 10 09 wastes from casting of ferrous pieces 10 10 wastes from casting of non ferrous pieces 10 11 wastes f
18. AP J PERT rents pj a GPP paT Pigtrors Peporterg VWorkboo be cicteng on the Dowr oed fecal Terwivte edence Oroorvarts al E SAVO REO ihe ANE PREK Repesitang tee g DOUNE G Maros ta wid t ece tate we O ere Z wi ptt i ortar correct User Parse aY Z gt nab Lopour F yOu are noty rene bnaitne f t ang ti i bo briatve the your Fac Ft Excel wes j tt t j apo ot t r a are a P Meee rote Trust your cal the wi ortan pore ore pcoieted formetan about your fectty If there ere arty errors amp thes priorato Cheara corhect the PA pt aratu o Paps is beicre you proceed to erte ie COMPS Stel WOW Ma 139 Li ive Tadd Wardha wm De Coated Oe ont Tatety Foklor tee creche Oo currer arte vou Retee ree ated OF Atua Warto Tror rorat ovr aah of the retevaerd w orhhoals The AR PRT Beectrorec Peperterg VWorbbog and MWehefe Veer Marca S S 46t YOu N OOA miL thie CWA Of poa irtoa i n te Wy f f LA ha har lt r t re r p gt Ahen vou feed corenteteod thee Letroteteer Of syur rdonon use te CRRATE APA 6M Fe TUEN A LUALOAD aurton on thie a ets D amp Actives PSA Ot OO CTO Ae bits PE Het fae thee is ma u musi seve the workbook balore opasleg It This will tormeet Tou cas thee proceed te open the workbook h uso the Seve buttoe If you de eect Sava Ar afte 23 Lars Siete e ss ee Lee frei ereras See ee oe eee eee Sf ie we Fig 1 5 The PRTR Workbook Download pa
19. N Arim Hip PRTR AER Returns Upload Page tojiut Upiomd instructions Groane to the locetern of the sri hie that wer saved fon the Cone ie tan cht the Uplowd buttons tom f KL fhe validation tolod Tho error is Missing releases Inte epe de waste clomeearnt in impot Me taladi 805 3955 98 A gPa DOO Contam as Chases Otsalar Sowtererces Gtaseeey of Tarra 6 2 ft a ctu mesma macan Fig 3 10 Upload errors Page 49 of 50 3 3 Printing e f required the AER return details can be printed by clicking on the PRINT THIS SHEET button Alternatively you can use the standard Excel print options found under the File menu A la x Ej Microsoft Excel A0013_2006 xls _ C Type a question for help X a File Edit View Insert Format Tools Data Window Help C O eH RBBEIGRIY GBs aA FI e ElKl G e Pi E snot px window p all p 23 d oo gg gt A a Qa Ye Reply with Changes End Review i Arial 00 gt BZ UJE a gt 0 598 E De A i AAB x f A Cp a AER Returns Worksheet UE Environmental Protection Agency amaaa wne 9 REFEREHCE YEAR 11 1 FACILITY IDENTIFICATION 12 Parent Company Name John Smith Ltd 13 Facility Name John Smith Facilit 14 PRTR Identification Number 40013 15 Licence Number P0164 01 16 Waste or IPPC Classes of Activity class_name The manufacture of vegetable and animal oils and fats where the capacity for processing r
20. Ref RecovererDisposer 4 re Fig 2 79 PRTR Pollutants Reference Sheet Page 38 of 50 Ref Licensed Pollutants This worksheet contains reference information for Licensed Pollutants E Microsoft Excel A0013_2006 xls la x a File Edit View Insert Format Tools Data Window Help Type a question for help X a a a La cal Ld Y G ae 7I ERAN PNE A Z id 4 100 J snactt E window B Bot a oala DH B By A YeReply with Changes End Review Arial 10 B Z USSE wE FRAD F30 Z f A aS es eee ee a 1 Licensed Non PRTR Pollutants Pollutant Lookup Pollutant Number Pollutant Name Pollutant_Lookup From Row 3 13 JAI 1 2 trichloroethylene Al 1 2 trichloroethylene To Row 101 4 JA10 Epichlorohydrin A10 Epichlorohydrin Start Cell 2 5 JA11 formic acid A11 formic acid 6 IA12 hydrogen bromide A12 hydrogen bromide 7 JA13 hydrogen sulphide A13 hydrogen sulphide 8 JA14 lodinated compounds A14 lodinated compounds 9 JA15 isocyanate A15 isocyanate 10 JA16 merceptans A16 merceptans 11 A17 mercury Al mercury 12 A18 natural gas A18 natural gas 13 JA19 Noise A19 Noise 14 JA2 2 methyoxyethanal A2 2 methyoxyethanol 15 JA20 Organic chems with photochemical Ozone potential A20 Organic chems with photochemical Ozone potential 16 421 Ozone A21 Ozone 17 A22 potassium A22 potassium 18 JA23 pressure A23 pressure 19 A24 rubber furne A24 rubber fume
21. Uter Meruel dick on the User Hyun option on the lef Ned pignon fer Thi rears mt gwe you Getalied wrormahon and qedorme on how to Gowen od pour Excel tenci M itn wth Seese ard Waste Trareers cata then uptoed sour completed art Se bo the ARR PATER Database We recomand iat you Oeste 3 wera folder CER PATR Reporting on vour Ci Drive for thes ourpese and Of Oste subfolders for Gal ODT year You May hen Gave Die Workbook Tet Cudan Manuais and your correspondence with the Fc to thes folrter Tove we tenitate you carnyeg out you reporting tasks in an efficent ats ad wil Seo oscet you retering sng etree dng Oe information for fine Meow 25 ov be rogue AER PATH Evveseers Dato Duwv ooid pap AER f PRTR Ertesi Data Uswod page L IOL aaan aA Coens Gaa Ea aa a Gaana of teres tars imre fp Kira e Fig 3 7 Selecting the Upload page 3 2 Uploading the completed XML return file Select relevant Year Click the Browse button on the Upload page Browse to the XML file that the Excel workbook previously generated Select the XML file and click OK The file name and path should be displayed in the upload textbox Click the Upload File button Page 47 of 50 fe Cat Ren Povetes Too thet Tero ya EB frevicte amp G RR somn jen z Q 0 O8 hn r rom lt a Home Costect ae Site Mep EPA Hope View Cert epa 7 Cesvereerial Protectan Agency se are hers Cars gt tel we
22. ail for any updates or errors in your submission Page 48 of 50 LALL H gt 4 we ii Hemu Costori es Sie Map EPA Heaps View Cort jo P The t biis a twhereerta Phrnatias Aprey You are bere tora Aha me do Erteroerert Lkarps Erfercerey gt Pe beert Galpare Trereter Dagr gt PETR Ortarre Heo PRIR AER Returns Uplond Page Loess Your upload has coenoleted Feste find pour comfirreanion coce heinw Ratan the for tatuee miarnos Vout Hho wil FO GrG SUTONTOS Oa yOu sf PO00We 2 HOTT OOTER Great witten D4 ours Ther enei v wey one of two thongs Your fle hert pessesd the sctortated Cecking and the dete hac been imported succesculy nio the Fen PRIR Opener or Your te has fated Ua automated ceecheny end the Gate has not been ported nto the EPA Ofte ayatam The oroblerss that were elentfied 8 be teted ro the snai The Bocce return wd need to be asked the probin ected aret thet We resres Torena born Kurder seeROd MON RONIS TEHAST cal Lotall then 33 eA y AG Ga 2007 Congas as Chatea Dicey Sroteres ces Siumut gf Toor ai e i ae eset oe we z teaa es Fig 3 9 The upload confirmation page If any errors are found in the upload file then these will be displayed accordingly Heite Contact as Site Map EPA Mops View Cart tretormeria Putecter Agony You are hore Homme What me do Evcromrert boros Srtarrerrest iiiz Bctome Traute Regier POT
23. apecdec ADR PTR Dectrorec Reporting Gudam Documems Workbook and tor up osdng pour corr ieted Me to the AEA PRTR cistatiaes The m the brat of the three He LER PRIR Reporting Tasks for Bs ccensed fatties acd the cele tase for nom EPA cersed facies Uoer Maru Beaters cocrenemon Omura that you have dowrdnaded the guidance Goosterts which wel acest you in wo completing your reporting tysts mrresshdy In partoster you thoid dowrioad the AER PRTR Rectrorec Reporting Worktock ard Webhete Uter Myall dick on the User yun option on the left Nerd naevigstion fer This manuy al give you Getalied formation and gudonmce on haw to Goweioad your Excel tema Waste Trans are data then uptoesd sour completed ard Sle bo the ABR I We recommand that you Oreste 3 Wail folder CER PRTR Reporting or ad Oreste subfolders for eadi reporting year You May then save the W and your correspondence with the FPA to thes foder This w tonitate yo tasks in an efficent aas and wil yso asset you n retyring ang m ormugtion for future few 25 ay be rogues ts Daly Oowrtoed pa OPS DILL Citada Seekers Soaeey Coles Cees Cueto saan Asabi anan Gissac of teres 5 i W bera fpe Ridha Fig 1 4 The Emission Data Download Upload Page e Press the AER PRTR Emissions Data Download Page Page 5 of 50 1 2 Downloading the Configured Excel Workbook Jo manse t A Pe he ke Femin h b Tread D am n A o B Pepe ye Se fiout
24. at wee ie gt Eeloccenert gt coerce Aamar gt ALR PRTI Repoaeg Absit AER PRTA Welcome to the AER PRTR Annual Environmental Reporting Website Gustance Dorimerts ee IE S The webete mi arent you n matng sour anual returne of aaronmmeartal srictreabon as recuerec uncer pour EPA boecce md of onder the PETR Regqiiations The tte pravides AE quactence on the qromiabon tc ba reported arul proces toch lo aloe you bo ao tha aandy and efboertily Cich on Owe Cuntlarce Documents box on the let hand navegabor bar To Ger the ate plegse Provide your uTeouE uremanet and pism ord User ID ADOTS Pareword ereeeeee Mease Wott That tre capuo has roe Doan removed form this login Ode four username and paseword do mot change trom year ba year OPA DILL Contec Qepcheeme Preece Motes Shonas Septey Srgienenses Sommer h te Sigterers Giegeoy of Terres Seated Store EHK SU Fig 1 2 Entering login details e Click the Login button to proceed e After successfully logging in the welcome page will be displayed Page 3 of 50 Fe St Wee Peete foo e iret GO hohtaa Boo Ge oe e oan ron gt O 2 w tex sete Toh O a Horne Contact us Site Map FPA Mape View Cart Erorurrmectal Protection Agetcy fae ore beroi kome gt Aba ae Go gt Ecfarcemert gt Lkerce Setarmemers gt AFR PATR Repering About An j PRIA AER PRTR Reporting of Environmental Information Gudane Oger The evra reperteng of arrero
25. atefied urgi afl theoe shoro ae corroleted and the EPA hos confirmed ot t has a tepted Die information Goeraters al Mon EPA Leensed lacdtinns we ortly ot ged to coreplete Task 1 The nmniomubon cannet be accepted n any other manner or format otter than tut epeoted n the Geode ce docuteriabon crowded on thes webete OFA 1011 Cortacs us Diinimec Goeece Sata Chanas Commies references Saami Tatana Ghanan at Taru a len aal ha A Sane m oN Fig 3 6 The welcome page Page 46 of 50 e Click the AER PRTR Emissions Data Upload Page button G Je W mkr Fir eK fy UF earl fe Ce Ver Portes Teb Hb Writs S OF h E gt Scam jryi a D LW Por Sdr Tooke e homa Comtact we Site Hep CPA Mapa Vaw Cart You ere here Horu Aiet ye tis Eris cerere Le gt ALE PRTS fepoers AEM PRTA Moree Page AER PRTR Emissions Data Page Abar ARN PRIN Thee ts Cow page for downostteg afd uploecing your lac tyv apectc ADR PRTR Dectrorec Reporting Gualanie Documents Workbook and for uppnactng your corre eted Me to the AER PRTR clatatiaes Tha i the brat of the three mo 2ER PRIR Rooting Tasks for Bs ccensed fates and Nie gio task for mom EP 4 ocerrad faces Lioer yuz Baic coctenemon erwure that you have dowrinaeded the guidance connerie whech wel acest you in Lagurt 9 completing your reporting tects surreceha In parhosier you thoid dowrioad the ARR PRTR Rectror s Reporting Worktock and Webete
26. ating Hours in Year Number of Employees User Feedback Comments Web Address Carlow reland 0 000 114 rowing of cereals except rice leguminous crops and oil seeds 09 09 09 09 0 09 9 OO OO NN NNN NN hh iN SS lala OY OAS OS OO OND Bi O oO Om m jv jjj 2 PRTR CLASS ACTIVITIES Q ra Activity Hame Mineral oil and gas refineries Cement clinker or lime in other furnaces bp POIN h 3 SOLVENTS DIRECTIVE 45 ls it applicable 46 Have you been granted an exemption agi Comment 50 PRINT THIS SHEET 52 53 HELP 54 5 sg CREATE AER XML 57 RETURN amp UPLOAD MAr Facility ID amp Activities Releases to Air_ _ Releases to Waters _ Offsite Transfers of Pollutants ReleasestoLand Treatment amp Transfers of Waste Ref NACE Codes Gig Use this button to create your XML return file and to upload the file through the EPA website Fig 3 1 Submitting your return e This will validate the workbook and prompt you to enter a location for creating the XML AER Return file C by default Convert Excel To XML i x This procedure will create the ML File containing your return details and put it in the directory below The directory can be changed if necessary To exit the procedure click Cancel Fig 3 2 Creating the XML return file e You can either accept the default path or enter a different path where the file will be created then click the OK butt
27. ations and other combustion installations With a heat input of 50 megawatts MVV 4 NA c Chemical installations for the production on an industrial scale of phosphorous nitrogen or potas 0 18 6 NA c Installations for the disposal of non hazardous waste With a capacity of 50 tonnes per day 19 6 NA c Industrial plants for the preservation of wood and wood products with chemicals With a production capacity of 50 m3 per day x NA c Treatment and processing of milk With a capacity to receive 200 tonnes of milk per da anp NA c Installations for surface treatment of substances objects or products using organic solvents in part With a consumption capacity of 150 kg per hour or z azp NA d Coke ovens 0 2p NA d Ferrous metal foundries With a production capacity of 20 tonnes per day 24 B NA d Installations for the production of asbestos and the manufacture of asbestos based products 0 4 NA d Chemical installations for the production on an industrial scale of basic plant health products and cO 26 6 NA d Landfills Receiving 10 tonnes per day or with a total capacity EA NA d Installations for the production of carbon hard burnt coal or electro graphite by means of incinerat 0 ae cc DD MODIFIED ACTIVITY NAME MODIFIED CAPACITY THRESHOLD 29 11 NA e Coal rolling mills With a capacity of 1 tonne per hour 30 NA e Installations for the manufacture of glass including glass fibre With a melting capacity of 20 tonnes per day ap NA e Installations using a chemical or bio
28. aw materials exceeds 40 tonnes per day ho ow N orth Main Street agnelstown Address Address Address City Town v illag Postal Cod Count Countr Coordinates of Location River Basin District NACE Code Main Economic Activit Production Volume Number of Installations Number of Operating Hours in Year Number of Employees User Feedback Comments Web Address Carlow Carlow reland 0 000 114 rowing of cereals except rice leguminous crops and oil seeds Q 0 09 0 09 09 NN N aa N N N COO On BONS O00 Oo mon Bo mjm jj 2 PRTR CLASS ACTIVITIES Activity Hame Mineral oil and gas refineries Cement clinker or lime in other furnaces FHL shew seee _ 3 SOLVENTS DIRECTIVE ls it applicable Have you been granted an exemption bls bp rT 50 PRINT THIS SHEET 51 52 53 HELP 54 55 sg CREATE AER XML 57 RETURN amp UPLOAD ui M M 4 gt MN Facility ID amp Activities Releases to Air _ Releases to Waters Offsite Transfers of Pollutants Releases to Land Treatment amp Transfers of Waste Ref NACE Codes 4 Use the print button to prepare the current sheet for printing i Fig 3 11 Printing your AER return details Page 50 of 50
29. ction then do not enter any pollutant or related data into the section leave it blank e You cannot enter the same pollutant more than once in a particular section Page 14 of 50 2 4 Releases to Waters Sheet e Click on the Releases to Waters tab of the workbook to display the sheet This worksheet allows you to enter any pollutants that are released to water Re oe min Dua Reve i Link to previous P Y ial z 7 Year s Emissions to k z Water AIRIA FATOWETAS JOSE TWA EEE SEIH A PL AH Section A PRTR pollutants 1 Section B PRTR pollutants TERNA Hanri k Ling da Probe Pl na Perr cheer ch ie eee 1a IE ARETON SMS AH 1 ETAIT THESES jar raria in yar lianer A RELEASES TO WOLTEES LHII T Section C Licensed pollutants x Click on this tab to display the sheet idan amp ie awy igi s d mi sila Bebe n Balers Bee el eel ee Lapel Pe i eee amp Irandan Rade i Fig 2 16 Releases to Waters Sheet e Based on your Class Activities the PRIR pollutants list will be divided into two sections Section A and B e Section A represents sector specific pollutants which apply to water and are based on your class activities e Section B represents all remaining pollutants that could be released to water but are not contained in Section A e This division of pollutants allows for quicker and more intuitive filling out of the worksheet as pollutants are grouped by p
30. drogen chloride fluorine or hydrogen fluoride carbon oxideO 44 b i Animal raw materials other than milk With a finished product production capacity of 75 tor Ma gt Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Ref RecovererDisposer 4 tC o Fig 2 78 PRTR Activities Reference Sheet Page 37 of 50 Ref PRTR Pollutants This worksheet contains reference information for PRTR Pollutants lax Type a question for help X EJ Microsoft Excel A0013_2006 xls Bat File Edit View Insert Format Tools Data Window Help COBH RSBIGRIY Bl 4 aA JlI 3 Kl hy B 100 Bi S snam ps window p Ua ta a a o a gt Arial 10 BZU D267 Z f S W Ill i A a ga Pe Reply with Changes End Review p B Polycyclic aromatic hydrocarbons PAHs Nitrogen oxides NOx NO2 Chlorine and inorganic compounds Fluorine and inorganic compounds as HF Hydrogen cyanide HCN Particulate matter PM10 34 Remaining PRTR Pollutants 35 Pollutant Number Pollutant_Name Sulphur hexafluoride SF6 Test parameter Chlorofluorocarbons CFCs Halons Aldrin Chlordane Chlordecone DDT 1 2 dichloroethane EDC Dichloromethane DCM Dieldrin Endrin Heptachlor Hexachlorobenzene HCB 1 2 3 4 5 6 hexachlorocyclahexane HCH Lindane Mirex Pentachlorobenzene Pentachlorophenol PCP Tetrachloroethylene PER Tetrachloromethane TCM Trichlorobenz
31. e f ham Dui Sv ese esces Soom kets Sigterers Foara of Terre are beret 7 Sion Fig 3 5 Entering login details e Click the Login button to proceed e After successfully logging in the welcome page will be displayed e If you have been brought to the AER site directly from the Excel workbook then once you have logged in you will be redirected to the Upload page automatically In this case skip to the section on Uploading the completed XML return file below Page 45 of 50 e Click the AER PRTR Emissions Data Page button PRIH Windows interest tapiore oak Horne Contact us Site Map FPA Mape View Cart Ererurrmertal Protection Agetcy ae ore beroi kome gt wha we oe gt Ecfarcemers gt Lierse Selarcemer gt ABE PATR Repering About 420 PRIR AER PRTR Reporting of Environmental Information Gudane Dogue eis The wewruaa l reporting cl arrerorenental elormatron by TPA boensed facit operators lale sfo three Taste e These are Logat Jiki o AER PRTR Emissions Data Acoortng of enbsaons and ose tronsters reformation wa the Eas SER CRIS Gress Cota Ragorting Woredook 2 Fell AER Sub recsicn of your Ful annd Exeronnencal Recor AER The is te harccoge or pace GR merhed under pour karce 3 Pull POP ARR Suliranin of an electrome FOF topy of pour Tull Ann oa of OL January 2009 ead of hese Rope n madatory for af EPA Loerad fades The reparieng obi gation wil not be s
32. e pollutants 1 Methane CH4 11 Sulphur oxides SOx 14 Aydrochlorofluorac 2 Carbon monoxide 0 20 Copper and compe The selected pollutant number and name is displayed _ SECTIOH A SECTOR SPECIFIC PRTR POLLUTANTS RELEASES TO AIR Fig 2 5 After selecting a pollutant from the dropdown list RELEASES TO AIR Tl Fig 2 6 Filling in the Method Used section Page 12 of 50 e Next enter the quantities of release for this pollutant under Emission Point 1 This will appear in the Total Quantity cell also Quantities are expressed in KGs per year 400 En py FOI QUAHTITY T Total KG ear 4 Accidental KGivear F Fugitive KO ear 0 T 0 T Fig 2 7 Filling in the release quantities a ee e ie m pr E rE ar oe L m mp mission Point 4 i ear F Fugitive EGY ear F a z S00 S00 i D Fig 2 8 Filling in the release quantities continued e lf any Accidental or Fugitive releases for this pollutant are applicable then enter these under the Accidental or Fugitive section otherwise leave these as 0 QUAHTITT Emission Point 1 IT Total KG Year 4 Accidental Kerrear F Fugitives KG ear Fig 2 9 Filling in the Accidental and Fugitive quantities optional e If you have releases from more than one Emission Point then you can add additional points by clicking on the ADD EMISSION POINT button This will add an additional Emi
33. e If you have made a mistake and wish to remove the last row entered then click the DELETE LAST ROW button in the relevant section Jean Y Click the DELETE Transfer Destination Code fi button el e g oe ee h 7 T m rir Aithin the Country Jr Us 04 Fig 2 74 Deleting a row Step 1 warning eee Es x re you sure you want to delete the last row All data on this row will be lost Fig 2 75 Deleting a row Step 2 Page 34 of 50 OLME p SOL MERY MENA L Bad mi Fig 2 76 Deleting a row Step 3 e lf you have no waste data to enter then do not enter any waste or related data into this worksheet leave it blank Page 35 of 50 2 8 Reference Sheets Ref NACE Codes This worksheet contains reference information for NACE codes EJ Microsoft Excel 40013_2006 xls p _ 18 x Bd File Edit View Insert Format Tools Data Window Help Type a question for help X DBE ERSBI4GRI7 4 BB FIA Q 3h XI D 100 J i snag E window p ad fa 2a AG 2 ia a Pe Reply with Changes End Review g Arial 10 B U F SSRIS gt El DAD G3 f A SS a ee eee eee ee NACE Group NACE SubGroup NACE Code NACE Description NACE ISIC 12 0 0 Manufacture of tobacco products 1200 3 36 0 0 Water collection treatment and supply 3600 4 37 0 0 Sewerage 3700 5 9 D D Remediation activities and other waste management services 3900 6 f5 0 0 Veterinary activities 7600 7 92 0 0 Gambling and
34. ecovererDisposer Codes Ref Method Codes Misc Lookups Waste Details 1 Waste Details2 Previous Yell m 3S gt i ead Sm 100 O A H Fig 2 83 Method Used Reference Sheet Page 42 of 50 3 0 Creating amp Submitting an AER Return e Once all relevant data has been entered ref sections below click the CREATE AER XML RETURN amp UPLOAD button on the Facilities ID amp Activities worksheet EJ Microsoft Excel A0013_2006 xls E B 18 xl Bd File Edit Yiew Insert Format Tools Data Window Help Type a question for help X DBS ERGI4BAl Fyaealsaa s zZ 2l 4l i 0 5 z amp Snagit j window P bal 2 AD a 3 ga Reply with Changes End Review Arial 10 B ZU 4 Koa Ee 1 Cpa Environmental Protection Agency AER Returns Worksheet 2006 9 REFERENCE YEAR 11 1 FACILITY IDENTIFICATION 12 Parent Company Name John Smith Ltd 13 Facility Name John Smith Facilit 14 PRTR Identification Number 40013 ile Licence Number P0164 01 class_name Waste or IPPC Classes of Activit he manufacture of vegetable and animal oils and fats where the capacity for processing raw materials exceeds 40 tonnes per day orth Main Street agnelstown Address Address Address CtyTownsilag Postal Cod rlow 2 Count Countr Coordinates of Location River Basin District NACE Code Main Economic Activit Production Volume Number of Installations Number of Oper
35. eland Abroad Fig 2 70 Selecting a Treatment Location Page 32 of 50 If you select Onsite of Generation a pop up box will appear explain when to use the treatment location On Site in Ireland Warming Enter the name and licence permit number of the next destination facility for hazardous waste or the name and licence permit number of the recoverer disposer for non hazardous waste Enter the address of the next destination facility hazardous waste or the recoverer disposer non hazardous waste For hazardous waste enter the name and licence permit number and address of the final recoverer disposer For hazardous waste enter the actual address of the final destination i e final recovery disposal site If you have reported waste treated on site of generation please enter in your own facility name address details In some cases where waste generated on site is treated on site the on site treatment process may be a preliminary treatment step and residual waste from the treatment process may be sent off site for final treatment If that is the case please enter the residual wastes transferred off site as separate entry ies rows and in the description s clearly describe that this is residual waste following preliminary treatment of waste on site as detailed in previous entry row no x Some PRTR organisations have internal recycling as part of the production process It is very important that thi
36. eleting a row Step 3 e f you do not have any releases for a particular section then do not enter any pollutant or related data into the section leave it blank e You cannot enter the same pollutant more than once in a particular section Page 22 of 50 2 6 Releases to Land These activities are not currently employed in Ireland Therefore although a page has been made available in the Workbook for the reporting of releases to land to cater for future developments it is currently not expected that any operation in Ireland will report under this category This worksheet is locked and you are not able to input data on it e Click on the Releases to Land tab of the workbook to display the sheet This worksheet allows you to enter any pollutants that are released to land rl Hoa a A I E oda PRL e es SL a PC TEDE 4 PATH POUL ee Section A SU j ee ee oe eis Bee Nr Fi bta Mee ree ie ee ee Be Pe tae PRTR pollutants U SC Toe B BS PUL TES SS eo rae ed ie eo Lice 1J HLEA ZE TI LARE Section B Licensed ee pollutants Ie ee daai Oe i ha Led ae ys i h eg on be Fede Fe Fe H her sh re ee ae Click on this tab to display the sheet Fig 2 44 Releases to Land Sheet e This worksheet is divided into two sections Section A and B Section A represents PRTR pollutants while section B represents Licensed pollutants e Each section is filled in the same manner e Begin by selecting a pollutant from the d
37. enes TCBs 1 1 1 trichloroethane 1 1 2 2 tetrachloroethane Trichloroethylene Trichloromethane Toxaphene Vinyl chloride Ethylene oxide Asbestos Perfluoracarbons PFCs Hexabromobiphenyl 68 69 Emission Type Water 70 Category Specific PRTR Pollutants 71 Pollutant Number Pollutant_Name 72 Polycyclic aromatic hydrocarbons PAHs 8 Nitrogen oxides NOx NO2 80 Chlorine and inorganic compounds 64 Fluorine and inorganic compounds as HF 85 Hydrogen cyanide HCN 86 Particulate matter PM10 Pollutant_Lookup 10 Sulphur hexafluoride SF6 1234 Test parameter Chlorofluoracarbons CFCs Halons Aldrin Chlordane Chlordecone DDT 1 2 dichloroethane EDC Dichlorormethane DCM Dieldrin Endrin Heptachlor Hexachlorobenzene HCB 1 2 3 4 5 6 hexachlorocyclohexane HCH Lindane Mirex Pentachlorobenzene Pentachlorophenal PCP Tetrachloroethylene PER Tetrachloromethane TCM Trichlorobenzenes TCBs 1 1 1 trichloroethane 1 1 2 2 tetrachloroethane Trichloroethylene Trichloromethane Toxaphene Vinyl chloride Ethylene oxide Asbestos 9 Perfluorocarbons PFCs 90 Hexabromobiphenyl Pollutant_Lookup 12 Total nitrogen 12 Total nitrogen 13 Total phosphorus 13 Total phosphorus I 4 gt Dl Treatment amp Transfers of Waste Ref NACE Codes Ref PRTA Activities Ref PRTR Pollutants 4 Ref Licensed Pollutants Ref Waste Codes
38. er comments or a description of each emission point in the grey cell over the emission point e In order to add another pollutant in a particular section you must click the ADD NEW ROW button Page 17 of 50 SECTION A SECTOR SPECIFIC PRTR POLL Click the ADD button ADD MEW Row DEI AST Fh Fig 2 26 Adding a new row to enter another pollutant Step 2 e f you have made a mistake and wish to remove the last row entered then click the DELETE LAST ROW button in the relevant section SECTION A SECTOR SPECIFIC PRTR POLLUTAHTS RELEASES TO WATERS Click the DELETE button Fig 2 27 Deleting a row Step 1 warning eee x x Ore vou sure vou want bo delete the last row All data on this row will be lost _ ADD NE Row C AST ROW Fig 2 29 Deleting a row Step 3 e f you do not have any releases for a particular section then do not enter any pollutant or related data into the section leave it blank e You cannot enter the same pollutant more than once in a particular section Page 18 of 50 2 5 Offsite Transfers of Pollutants e Click on the Offsite Transfers of Pollutants tab of the workbook to display the sheet This worksheet allows you to enter any pollutants that are transferred offsite and are destined for wastewater treatment or sewer ih cut Pre s ae gt Link to previous ace PERS R r i Years Emissions to Sewer Phat fi I dI IO ES TO MEAFG TEA GE ar Lii li me
39. g on the cell under this section The Waste Treatment Operation reference worksheet will be displayed A Insert Page Layout Formulas Data Review View Design A 2 Cut 2a r ce J ras EEH AutoSum Ay amp Arial j0 JA s Ssl S Wrap Text Text A F a af oe aa Z a Ba Copy 7 a a Fill 4 Paste B F uU A A Z Z SE E Merge amp Center e o 9 2 00 Conditional Format Cell Insert Delete Format Sot amp Find amp GP Format Painter a ieee al al 3 aan Formatting as Table Styles z Clear 7 Filter Sele Clipboard 5 Font A Alignment 4 Number Styles Cells Editing M 4 gt i Ref Waste Codes Ref RecovererDisposer Codes Ref Method Codes Misc Lookups lt Ref Help Waste Details 1 Waste Details 2 Fig 2 66 The Recoverer Disposer Codes reference sheet e Select the appropriate code by double clicking on it The code will then be returned to the Treatment amp Transfers of Waste sheet that is being filled out Page 31 of 50 Fig 2 67 After selecting the Recoverer Disposer code e Select a method used from the dropdown lists in the Method Used section of the sheet Fig 2 68 Entering a Method Used Weighed Fig 2 69 Entering a Method Used continued e Select a Location of Treatment from the dropdown list valid values are Onsite of Generation Offsite in Ireland and Abroad Onsite of generation Offsite in Ir
40. ge Select required Reporting Year Click the Download Excel Template button Please wait while the Excel file is being configured You will then be presented with a Save As dialog box LWIA Ata ave Owe Me to the AR Pe TR Reporting fodar you in Fecal teeters C8tieg osl Mee POTN wiorbhouk Where seving no gt Gio gt Please be patient during this time as the configuration process may take a few moments Page 6 of 50 AER PRTR Windows Internet Explorer Go P9 http aer epa ie reporting pgDownload4ERData aspx File Edit view Favorites Tools Help M R s x ay Live Search er Uy Favorites 38 E Free Hotmail Web Slice Gallery O connecting for fy 3 mp Page gt Safety Toos s About AER PRTR Guidance Documents Help User Manual Logout Download the AER PRTR Electronic Reporting Workbook by clicking on the Download Excel Template option below and save it to the AER PRTR Reporting folder on your computer Please select the Enable Macros option when opening the Workbook to ensure that the Workbook will arrant tha infarmatian uns enter correctly If you are not prompted to select the Enable Macros option when opening to Enable the Macros in your Microsoft Excel software package on your PC F refer to the appropriate Enabling Macros document for your particular vers Please note that your Excel file will contain some pre populated information
41. il etalls 29 o RiverBasnDistia O O O OoOO O gt LL EY o o Ol Bs l O O Number ofinstalations ee yy Facility details 34 Number of Operating Hoursin Year O OOS y 35 CNumberofEmployees OOC CSCSC YTNNCSC N TNNNN _C continued 36 User Feedback Commerts O Z OOOO yO ar O O WebAddress y y O 338 2 PRTR CLASS ACTIVITIES 40 Activity Humber_______ Activity Name PRTR Class 3 Activities for 44 3 SOLVENTS DIRECTIVE ii a olsitapplicabe o O Z O O O SSS O facility 46 Have you been granted anexemption No OO O O O eee I IUO UUU UU Ba Comat OS O O O O U O 48 I 49 50 PRINT THIS SHEET z 31 Solvents Directive 52 r 53 HELP Print Help and details 54 55 CREATE AER XML Upload buttons 56 57 RETURN amp UPLOAD M 4 gt rh Facility ID amp Activities Releases to Air F Releases to Water ppb bib z z Workbook tabs for return sections and reference Fig 2 1 The AER workbook see details below Page 9 of 50 2 2 Facility ID amp Activities Sheet Sn ea a eee ARE OLE ESET AER Returns Contact Name AER Returns Contact Email Address _ AER Returns Contact Position AER Returns Contact Telephone Number _ AER Returns Contact Mobile Phone Number AER Returns Contact Fax Number Production Volume _ Production Volume Units E Number of Installations _ Number of Operating Hours in Year _ Number of Employees User Feedback Comments
42. k the ADD button Fig 2 54 Adding a new row to enter another pollutant Step 2 e If you have made a mistake and wish to remove the last row entered then click the DELETE LAST ROW button in the relevant section SECTION A PRIR POLLUTANTS Click the DELETE button Fig 2 55 Deleting a row Step 1 Warning a xj x Are vou sure vou want bo delete the last row Alldata on this row will be lost Fig 2 57 Deleting a row Step 3 Page 26 of 50 e f you do not have any releases for a particular section then do not enter any pollutant or related data into the section leave it blank e You cannot enter the same pollutant more than once in a particular section Page 27 of 50 2 Treatment amp Transfers of Waste e Click on the Treatment amp Transfers of Waste tab of the workbook to display the sheet This worksheet allows you to enter onsite treatment and offsite transfers of waste KT Sje WNO Conpti t Mose kirat Fao gt 03 Irw ran STORET foment Duta Pantin vw 20 co f amp Ata 1 ka as J r ue n x p ja j G ELIT x ber air A ole j 4 a gt 7 Ps r A Pe i tey PiN 7 format Parte as esa Fe d 7 P i Ow i ewn r sed ee sh geerre a AS f R D E gt 5 H i K t 4 ONSITE TREATIVENT S OFFSITE TMANSIENS OF VAa SIE 2 i r Pisses enter s n Link to Previous Year s Waste Transfer Data Click on this tab to disp
43. lay the sheet Wass Beiter Ar Agaa fo Vyetery Sees Vostee re Of Sone Moers to Lane fregtwant amp harale of Waste Ra are Cie Sel p e Begin by selecting the transfer destination from the dropdown list valid entries are Within the Country or To Other Countries Within the Country To Other Countries Fig 2 59 Selecting the Transfer Destination e Next select the EWC European Waste Code by double clicking on the EWC cell for the record you are filling out Page 28 of 50 Fig 2 60 Entering the EWC European Waste Code The EWC reference worksheet will be displayed FJ Microsoft Excel A0013_2006 xIs 8 x Ed File Edit view Insert Format Tools Data Window Help Type a question for help X OGM PEFEA TET EE EE T 100 E EA B a ta 2 a d 3 cap Z ay ga P4 Reply with Changes End Review Arial 10 B z Uji SSB gt so Eo AWB Al z f GroupCode O a E al GroupCode Description 24 GroupCode SubGroupCode Description 01 01 wastes from mineral excavation 03 wastes from physical and chemical processing of metalliferous minerals 27 01 04 wastes from physical and chemical processing of non metalliferous minerals 28 01 05 drilling muds and other drilling wastes 29 02 01 wastes from agriculture horticulture aquaculture forestry hunting and fishing 30 02 02 wastes from the preparation and processing of meat fish and other foods of animal origin 31102 03
44. logical process for the production on an industrial scale of bas 0 32 6 NA e Installations for the disposal or recycling of animal carcasses and animal waste With a treatment capacity of 10 tonnes per day 33 p NA e Installations for the building of and painting or removal of paint from ships With a capacity for ships 100 m long p Installations for the manufacture of coal products and solid 1 NA f smokeless fuel 0 ap NA f Installations for surface treatment of metals and plastic materials using an electrolytic or chemical Where the volume of the treatment vats equals 30 m 36 B NA f Installations for melting mineral substances including the production of mineral fibres With a melting capacity of 20 tonnes per day 4 NA f Installations for the production on an industrial scale of explosives and pyrotechnic products 0 38 NA f Urban waste water treatment plants With a capacity of 100 000 population equivalents 39 B NA g Installations for the manufacture of ceramic products by firing in particular roofing tiles bricks refr With a production capacity of 75 tonnes per day or 40 NA g Independently operated industrial waste water treatment plants which serve one or more activities With a capacity of 10 000 m3 per day 4 a i Simple hydrocarbons linear or cyclic saturated or unsaturated aliphatic or aromatic 0 a i Installations for the intensive rearing of poultry or pigs i With 40 000 places for poultry 43 A b i Gases such as ammonia chlorine or hy
45. lso fill out Section 3 Solvents Directive and Section 4 on waste imported accepted onto site Please examine all pre entered data to ensure that it is correct You will need to inform the EPA if anything should be altered Page 10 of 50 2 3 Releases to Air Sheet Click on the Releases to Air tab of the workbook to display the sheet This worksheet allows you to enter any pollutants that are released to air Link to previous Years Emissions to Air Section B os ee A a A en PRTR pollutants De ed bri DCT Rod MG LUT AT DA A ed in your Lica RELLA Si TS AR Section C Licensed pollutants irinn urs ig teba rimming a ha Pria Moma Tahaa Pd ham riri a ieee H dicho lem Requested hom Landi epersicn Pos ibre od ikr ede ered ony oe Lier Goes lod qe ees oer Peril pee see dad es Lael gas Pirm b r ed oe ed oe ihe aes hga ri ira ma mbes punand hpa arans haald asiy _ HR rii Bhe mapti EN eee be ee eee eT ee pe a iE HHA A HARE PEHE Pe HAHH H FH HHHH es 1 H Landfill Operators additional information H Lode Tenses Py ise Pee he pee ee m e par pres ot eke Bere peed e Sl wiiged a ail ke i xI MA TE its A SE wE eT E T Lar mira SEI r atp E mai ph reiri ir Click on this tab to display the sheet Fig 2 3 Releases to Air Sheet e Based on your Class Activities the PRTR pollutants list will be divided into two sections Section A and B
46. o Mhoried aod Ovada TOs to JF you fo co es Gay id off sare bo On The crore t j kha w 2 To ertte ples proved your uTrecue upetrnere oud p aera i Vsa J o Pas rhe ore that the contra h l it tt o gt ur ube j p h f A wat FE Di Cormac es Ciamar eran Sdr Dea Omi aa Sccamee ey amanan Ciamar sf Tacnu Mipi aibida h B rare gt Ris Fig 3 4 Login page Page 44 of 50 Here you will need to enter the following details e Your User ID As supplied to you by the EPA e Your password As supplied to you by the EPA MEJLI PHIR Woridews isic net Exploit owp joote i J5 w Por Selctty Tooke Oe a Homa Cosiaci we Ste Pag EPA Mapt Vew Gr p ou sre here tors gt Abat Uui frt art carce P mha zarrari AR PRTS Seppo ors ibart AER PRTR Welcome to the AER PRTR Annual Environmental Reporting Website Sirian Oocnsmerts The webtete mi assent you n mating sour anual returns of ec rorrercsl srictreatbon as regard under ur FPS barce md of order the PETR Reqidations The tte growktes Ad guiye om the eforriaion be be reported arul prowdes tog to akoo you bo Go thin aidd anrd efboetily Cech on Ce Cuntlarce Decusrrecta Sox on the let hand navigator Sa To nter thet ate ese Dorde Your UT eOUE WSSTTOME Od pIo Oo oer ID ADDIS Pasewe g ELELEE Messe wote hat to outo has Ma born removed Pom this gt on Ose cur umernane and paseviord do not changa from year bo yes bogey Cortes us eles F
47. om the dropdown list e Fill in the method used section of the worksheet by selecting a method from the dropdown list Only Measured Calculated or Estimated are the values that can be entered here e The Method code field is not free test and you must double click on the cell to select a relevant method code e The Designation or Description is a free text cell You must enter a value into all of these cells under the Method Used section or you will receive an error when you attempt to create the XML return file for uploading AHTS DESTINED FOR WASTE VWATER TREATMENT OR SEWER Fig 2 34 Filling in the Method Used section continued e Next enter the quantities of release for this pollutant under Emission Point 1 This will appear in the Total Quantity cell also Quantities are expressed in KGs per year ADD EMISSIOh PONT QUAHTITY Emission Point 1 L Total Karr ear Accidental F Fugitive oe Fig 2 35 Filling in Te release iain QUAHTITY Emission Point 1 T Total KGY ear 4 Accidental Ker ear F Fugitive KGY ear 320 320 0 0 Fig 2 36 Filling in the release quantities continued Page 20 of 50 e lf any Accidental or Fugitive releases for this pollutant are applicable then enter these under the Accidental or Fugitive section otherwise leave these as 0 ADD EMISSION POINT GUAHTITY Emission Point 1 T Total Karr ear 4 Accidental Korear F Fugitive KG ear 320 355 20 15 Fig 2
48. on e Once the file has been created a message will be displayed containing further instructions Make a note of the XML file at this point Page 43 of 50 Convert Excel To XML l x The file T 140013_2006 xml was successfully created You will now be redirected to the login page of the AER Returns website Please login and select the File that vou have just created then click Upload You may wish bo make a note of the above path and Filename IF the webpage doesn t open automatically then please visit www epa ie where your return can be made Fig 3 3 Creating the XML return file continued e You will then be redirected to the AER returns website where you must first login and then attach your XML file for uploading e t is therefore important to ensure you have Internet access from the computer you are making a return from 3 1 Logging In e Navigate to the login page of the AER returns site 5 Bae ae m d at A D p e re y Fete T Wwiecte Wo hey P MER J ORTE or T t hps ays ae Ge a Homie LOAtart ut She Map bP A Mage Wiew Cart oma gt DD oe 2b gt kOCOCDAMAc gt Leelee EDEOCOAMLACS gt Abt PRTE keponrg ihon AER PATR Welcome to the AER PRTR Annual Environmental Reporting Website Toin Docimert The vedete wel arent you n mats your aruda retume of ameonmartal riormaton at rega ed uncer your GPA kenc and or under the PRTR Asguinbone The ate provider hdl Quedance on the eiormatoan t
49. p iaer epa ie reporting pqDownload4ERData aspx x ha bed x amp Live Search HES x File Edit View Favorites Tools Help she Favorites 933 Free Hotmail Web Slice Gallery connecting a ee z B v Page Safety Tools al About AER PRTR Download the AER PRTR Electronic Reporting Workbook by clicking on the Download Excel Template Guidance Documents option below and save it to the AER PRTR Reporting folder on your computer Please select the Enable Macros option when opening the Workbook to ensure that the Workbook will accept the information you enter correctly Help User Manual Logout If you are not prompted to select the Enable Macros option when opening the Workbook you will need to Enable the Macros in your Microsoft Excel software package on your PC For further information please refer to the appropriate Enabling Macros document for your particular version of Excel Please note that your Excel file will contain some pre populated information about your facility If there are any ipors ie thie information leases contact the EDA opci os 2 2n3 ic before you proceed to enter your Mua ea att tc Baik can be created for your facility nd Off sil onic Rep lutting of _ Follo Do you want to open or save this file infor Webd Name eAER xsd Type XML Document 16 8KB You From aer epa ie Sppy that you have comp e file before closing it each time
50. rerental miormnaton by EPA boersed factty operators lafe otto three Taste tt up Thane auc __ amp AER PRTR Emissions Data Acoorting of ermecons and e the EA s AER j PRIS Giessen Cota Regortng Worebook 2 Full AER Supression of your Fuh anny Exerannenca P or pase GR emed uncer pour karce 3 Pull POP ACA Sutetessor of an eect Sur of pour Tull ALK a of OL January 2000 ead of hese Mage b mandatory for al EPA Loerd fades the repartirg obs gation wil not be samefied urgi of theese shoe ae corroleted and the EPs has confirmed ot t has accepted tie mefornaben Operators al Mon EPA Leersed lacdtins are orily oboed to coreptete Task 1 The niomubon rannet be accepted n any other maner or hormat other than tut epeocted n the Quiaca dotumnertabon crowded on thes webwte CA 103 Contacts Diinimec masz Sakay i Chanas Commies Smitui Sccamdety Saterrace Gham ct Tarr i De fas Aws Fig 1 3 The welcome page e Click the 1 AER PRTR Emissions Data Page button e The download page will be displayed Page 4 of 50 Pe ES Wer Poncebes Tab Hob ar S E hein E o a ert moan J Pre o D LI Wm Pope Sare Techs e gt epa imama serial Protectan Arey You ere here hame Vibet we ds Erizcemirs Lerro Sotorcerrars ALK PRTI Repateg ARN PRTA Horze Page AER PRTR Emissions Data Page About A amp M PRM The ts hw page for dowrnosdteg and uploecing your lac tyv
51. ria te tel Pd te PC TESw 4 PATS POUL ee STE Tee GF ee a ee ee ee ee Section A PRTR pollutants Biia pris Poic IS peo i eS as ap a J Li SEC Teoh B BRR FCT ENT BS Sete Stee ras raed eee Leg 11 WATE TAA W LLU AS Se PO TESTER TREAT 1A F Section B Licensed pollutants 17 Da HS Po DELETE PEPY i Irini a rae ie k bag aen be Fuba Flere fopa i ber shsh Gor ibe it Click on this tab to display the sheet Akorus Ti ee a Se A E p r rs ry res dl F Eh Fe Fig 2 30 Offsite Transfers Sheet e This worksheet is divided into two sections Section A and B Section A represents PRTR pollutants while section B represents Licensed pollutants e Each section is filled in the same manner e Begin by selecting a pollutant from the dropdown list under the pollutant section e When you select a pollutant the pollutant number and name will appear in the corresponding cells SECTION A PRIR POLLUTANTS OFFSITE TRANSFER OF POLLUTANTS Clicking on the dropdown reveals a list of available pollutants lz Total nitrogen 1234 Test parameter R OF POLLUTANTS 13 Total phosphorus 14 Aydrochlorofluorae 16 Chloroflucrocarbor Fig 2 31 Selecting a pollutant from the dropdown list Page 19 of 50 _ SECTION A PRIR POLLUTANTS OFFSITE TRANSFER OF POLLUTANTS DES The selected pollutant number and name is displayed Fig 2 32 After selecting a pollutant fr
52. riority e The third section Section C provides an area to fill in licensed pollutants e Each section is filled in the same manner e Begin by selecting a pollutant from the dropdown list under the pollutant section e When you select a pollutant the pollutant number and name will appear in the corresponding cells Page 15 of 50 Clicking on the dropdown reveals a list of available pollutants Total nitrogen 13 Total phosphorus Tf Arsenic and comp 18 Cadmium and com Chromium and oo SECTION A SECTOR SPECIFIC PRIR POLLUTANTS RELEASES TO WATER The selected pollutant number and name is displayed Fig 2 18 After selecting a pollutant from the dropdown list e Fill in the method used section of the worksheet by selecting a method from the dropdown list Only Measured Calculated or Estimated are the values that can be entered here e The Method code field is not free test and you must double click on the cell to select a relevant method code e The Designation or Description is a free text cell You must enter a value into all of these cells under the Method Used section or you will receive an error when you attempt to create the XML return file for uploading t POLLUTANTS RELEASES TO WATERS Tan Fig 2 19 Filling in the Method Used section siS TO WATERS E Wiethod Used es MIE Method Code Designation or Description Er tl FER test description Fig 2 20
53. rom manufacture of glass and glass products gt vif ReleasestoLand Treatment amp Transfers of Waste _f Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Re 4 l i i Fig 2 62 Navigating through the codes e Appropriate codes for the selected values will be highlighted in blue e Repeat this for the subsequent levels to retrieve the full six digit Waste Code e The code will then be returned to the Treatment amp Transfers of Waste sheet that is being filled out e f you already know the full six digit EWC then just scroll down the Waste Reference sheet and double click on the six digit code e The Hazardous value for the entered EWC will be displayed Fig 2 63 After selecting the EWC e Enter a quantity for the particular EWC Tonnes year Please ensure that all weights are entered as wet weights Page 30 of 50 Fig 2 64 Entering a Quantity e The description of waste field will be auto populated when you select the EWC code If the description does not describe your waste stream accurately double click on the description cell This allows you to enter the description manually Generally your own accurate description of the waste can be more valuable than the generic EWC description and aids the validation process J ription of Waste Fig 2 65 Entering a Description for the waste e Select a Waste Treatment Operation by double clickin
54. ropdown list under the pollutant section e When you select a pollutant the pollutant number and name will appear in the corresponding cells Page 23 of 50 SECTION A PRIR POLLUTANTS Clicking on the dropdown reveals a list of available pollutants Tz Total nitrogen T234 Test parameter 13 Total phosphorus 14 Hydrochloroflucrad 4 15 Chloroflucrocarbor w Fig 2 45 Selecting a pollutant from the dropdown list SECTION A PRTR POLLUTAE The selected pollutant number and name is displayed _ ADD NEY RoW CO Fig 2 46 After selecting a pollutant from the dropdown list e Fill in the method used section of the worksheet by selecting a method from the dropdown list Only Measured Calculated or Estimated are the values that can be entered here e The Method code field is not free test and you must double click on the cell to select a relevant method code e The Designation or Description is a free text cell You must enter a value into all of these cells under the Method Used section or you will receive an error when you attempt to create the XML return file for uploading FOLLUTANTS RELEASES TO LAND Fig 2 47 Filling in the Method Used section RELEASES TO LAND LASTROW Fig 2 48 Filling in the Method Used section continued Page 24 of 50 e Next enter the quantities of release for this pollutant under Emission Point 1 Thi
55. roup Activity Code Activity Name Capacity Threshold 2f NA a Mineral oil and gas refineries K Metal ore including sulphide ore roasting or sintering 2 NA a installations ap NA a Underground mining and related operations 0 s5 NA a Installations for the recovery or disposal of hazardous waste Receiving 10 tonnes per day 16 E NA a Industrial plants for the production of pulp from timber or similar fibrous materials 0 7 NA a Slaughterhouses With a carcass production capacity of 50 tonnes pel EJ NA a Plants for the pre treatment operations such as washing bleaching mercerisation or dyeing of fit With a treatment capacity of 10 tonnes per day sp NA b Installations for gasification and liquefaction Installations for the production of pig iron or steel primary or 2 NA b secondary melting including continuous casting With a capacity of 2 5 tonnes per hour uE NA b Opencast mining and quarrying Where the surface of the area effectively under extra 126 NA b Installations for the incineration of non hazardous waste in the scope of Directive 2000 76 EC of thiWith a capacity of 3 tonnes per hour 13 6 NA b Industrial plants for the production of paper and board and other primary wood products such as c With a production capacity of 20 tonnes per day 14 NA b Intensive aquaculture With a production capacity of 1 000 tonnes of fish or 115 NA b Plants for the tanning of hides and skins With a treatment capacity of 12 tonnes of finished pi aep NA c Thermal power st
56. rubber and man made fibres 03 wastes from the MFSU of organic dyes and pigments except 06 11 04 wastes from the MFSU of organic plant protection products except 02 01 08 and 02 01 09 wood 05 wastes from the MFSU of pharmaceuticals 06 wastes from the MFSU of fats grease soaps detergents disinfectants and cosmetics oF wastes from the MFSU of fine chemicals and chemical products not otherwise specified 01 wastes from MFSU and removal of paint and varnish 02 wastes from MFSU of other coatings including ceramic materials 03 wastes from MFSU of printing inks 04 wastes from MFSU of adhesives and sealants including waterproofing products 05 wastes not otherwise specified in 05 01 wastes for the photographic industry 01 wastes from power stations and other combustion plants except 19 02 wastes from the iron and steel industry 03 wastes from aluminium thermal metallurgy Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Ref RecovererDisposer 4 ae Fig 2 81 European Waste Codes Reference Sheet Page 40 of 50 Ref Recoverer Disposer Codes This worksheet contains reference information for Recoverer and Disposer Codes Home Insert Page Layout Formulas Data Review View Design a o 2a m a EEE AutoSum 7 Dit po oar Ssma Ewo ot E PRs Bie 7 A Ga Copy 7 Pa i Fiu Paste T B Z U A E BS B By Merge amp Center 9 8 3
57. s is correctly identified by operators so that EPA can clearly identify it for validation and reporting purposes According to guidance published by Eurostat internal recycling includes the following operations where they take place at the site of generation The reprocessing of production waste e g of cuttings shavings rejects etc in the same ora similar process by which it was generated as typically carried out in some sectors of manufacturing industry The regeneration of spent process materials in order to be used again for the same or a similar purpose e g regeneration of spent solvents acids and bases catalysts adsorbents Internal recycling excludes e Any disposal operation e Energy recovery operations e Any backfilling operations These two lists are not exhaustive Manual on waste statistics A handbook for data collection on waste generation and treatment 2013 edition European Union 2013 ISBN 978 92 79 29050 3 Page 33 of 50 When reporting on waste treated on site of generation please identify clearly in the description if it is an internal recycling process as described above and separately report on any recycling of waste received from other companies for recycling Fig 2 71 Additional waste details In order to add another waste code record you must click the ADD NEW ROW button Click the ADD button Fig 2 73 Adding a new row to enter another waste record Step 2
58. s will appear in the Total Quantity cell also Quantities are expressed in KGs per year d QUAHTITY Emission Point 1 T Total Karr ear A Accidental Korn ear T j T Fig 2 49 Filling in the release quantities ADD EMISSION POINT QUANTITY Emission Point 1 T Total KG ear A Accidental lt 145 145 Fig 2 50 Filling in the release quantities continued e f any Accidental releases for this pollutant are applicable then enter these under the Accidental section otherwise leave these as 0 ADD EMISSION POINT QUANTITY Emission Point 1 T Total KGY ear 4 Accidental TE 145 175 Fig 2 51 Filling in the Accidental quantity optional e If you have releases from more than one Emission Point then you can add additional points by clicking on the ADD EMISSION POINT button This will add an additional Emission Point column to the right of the last one A maximum of 9 points can be used ADD EMISSION POINT QUANTITY A Accident al Emission Point 1 Emission Point 2 SS i KEGY EeAr Fig 2 52 Adding additional Emission Points e The Accidental quantities represent the totals for ALL emission points and not one particular point e You can also enter comments or a description of each emission point in the grey cell over the emission point Page 25 of 50 e In order to add another pollutant in a particular section you must click the ADD NEW ROW button SECTION A PRIR POLLUTANTS Clic
59. ssion Point column to the right of the last one A maximum of 9 points can be used SDD EMISSION POINT QUANTITY SU Li Fig 2 10 Adding additional Emission Points e The Accidental and Fugitive quantities represent the totals for ALL emission points and not one particular point e You can also enter comments or a description of each emission point in the grey cell over the emission point e In order to add another pollutant in a particular section you must click the ADD NEW ROW button Page 13 of 50 SECTION A SECTOR SPECIFIC PRIR POLLUTAHTS Click the ADD button m ADD WEWN ROW 7 DELETE LAST ROW Fig 2 11 Adding a new row to enter another pollutant Step 1 SECTION A SECTOR SPECIFIC PRIR POLLUTANTS _ ADD NEV Row DELETE LAST ROY Fig 2 12 Adding a new row to enter another pollutant Step 2 e If you have made a mistake and wish to remove the last row entered then click the DELETE LAST ROW button in the relevant section SECTION A SECTOR SPECIFIC PRIR POLLUTANTS Click the DELETE button zl _ ADD NEW RON E Fig 2 13 Deleting a row Step 1 warning eee x x Ore you sure vou want to delete the last row All data on this row will be lost Fig 2 14 Deleting a row Step 2 SECTION A SECTOR SPECIFIC PRIR POLLUTAHTS _ ADD NEY ROW E LAST EON Fig 2 15 Deleting a row Step 3 e lf you do not have any releases for a particular se
60. the production of alcoholic and non alcoholic beverages except coffee tea and cocoa 01 wastes from wood processing and the production of panels and furniture 02 wastes from wood preservation 03 wastes from pulp paper and cardboard production and processing 01 wastes from the leather and fur industry 02 wastes from the textile industry 01 wastes from petroleum refining 06 waste from the pyrolytic treatment of coal OF waste from natural gas purification and transportation 01 wastes from the manufacture formulation supply and use MF SU of acids 02 wastes from the MFSU of bases i 03 wastes from the MFSU of salts and their solutions and metallic oxides 04 metal containing wastes other than those mentioned in 06 03 05 sludges from on site efluent treatment 06 wastes from the MFSU of sulphur chemicals sulphur chemical processes and desulphurisation pro 07 wastes from the MFSU of halogens and halogen chemical processes 08 wastes from the MFSU of silicon and silicon derivatives og wastes from the MFSU of phosphorus chemicals and phosphorous chemical processes 10 wastes from the MFSU of nitrogen chemicals nitrogen chemical processes and fertiliser manufactu 11 wastes from the manufacture of inorganic pigments and opacificiers 13 wastes from inorganic chemical processes not otherwise specified 01 wastes from the manufacture formulation supply and use MF SU of basic organic chemicals 02 wastes from the MFSU of plastics synthetic
61. yde 46 w15 Hardness W15 Hardness 47 W16 hydrazine W16 hydrazine M 4 gt dif Treatment amp Transfers of Waste Ref NACE Codes Ref PRTR Activities Ref PRTR Pollutants Ref Licensed Pollutants Ref Waste Codes Ref RecovererDisposer 4 gt Fig 2 80 Licensed Pollutants Reference Sheet Page 39 of 50 Ref Waste Codes This worksheet contains reference information for EWC European Waste Codes EJ Microsoft Excel A0013_2006 xIs j x a File Edit View Insert Format Tools Data Window Help Type a question for help X OAH RBBIG RIS Gls aA FIA e 2l Al hy BH oo P i snactt E window D m aa oala an H f P Reply with Changes End Review p Arial gt i xB Z UEZ R gt s C45 z fe wastes from the MFSU of bases wastes from mineral excavation 03 wastes from physical and chemical processing of metalliferous minerals 04 wastes from physical and chemical processing of non metalliferous minerals j 05 drilling muds and other drilling wastes 01 wastes from agriculture horticulture aquaculture forestry hunting and fishing 02 wastes from the preparation and processing of meat fish and other foods of animal origin 03 wastes from fruit vegetables cereals edible oils cocoa coffee tea and tabacco preparation and p 04 wastes from sugar processing 05 wastes from the dairy products industry 06 wastes from the baking and confectionery industry OF wastes from

AER Returns Excel Worksheet – User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

AER Returns Excel Worksheet &ndash; User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

AER Returns Excel Worksheet – User Manual