Home

Air Emissions Inventory for the Greater Metropolitan Region of NSW

1. a DEL 1 enisi F ge ran rnit fcr M 3 pem aet te b Bis Iii REET ib Document Qj om i Fm eut x B Sore FA LU nipae LZ Cocos Tarn 1 Yos ras Pis DL Lest CEL Jnd SUA oe er mt bpm Bei peti T Fini im rane Fm Lee d Poe 3 n a QE LII piia Du 9 c cune SP Lok an ee 5 DE mado T E cu on pauli z derer ke meum lam Figure 2 1 Create directory C nsw_gmr_aei_2003 2 1 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 1 2 Download Workbook and Instructions Download the pdf file containing these instructions and the zip file containing the Excel workbook from the following web links and save to the directory created http www environment nsw gov au resources air tr10aei08260 pdf http www environment nsw gov au resources air tr10aei08260cp zip 2 1 3 Extract Workbook Extract the following file from the zip file to the directory created tri0aei08260cp xls Excel workbook To extract the file double left mouse button click the zip file highlight the file
2. Momo ban ano Latis report By CMR Chart 23 Prnporbon of annual amanoni pryot chart report by and foe eribana paitan dung 2003 in w module fer enktena pollutants during 2003 w Arai table report by regen module and Anual Gon pact chart report module and for pollutants dung 2003 in kegs eae for crideria pollutants dung 2003 kayar Tala 33 Preperben el annual amarani prot tabla report by pigeon of annual pront chart report by nien mede and lor cnbena pollutants dang T0903 ini moduie and activity cribsna pollutants during 1023 in acbwiby for pollutants dunng 2003 in kg yea for cntena pollutants dung 2003 laa 4 2 Prepgerben el annal erie pnost Labis report GHR 4 2 of annual aeons prot chart report module and zcinty for onbena pollutants dunes module and ackwity cribenis pollutacts dunng 2001 in ameppord pret Rabe report by LGA fer mtani Chat 5 1 Anmial sane pet chart report by LGA for pollutants dameg DOO n 2007 in 51 Proporbon of Lathe report LGA for Proporbion of annual chart report LGA for
3. dr i Indusirud ADOS Eutxn Bydrany Metal pang or moris 41 1 2003 Sydney feet of alcohol PARTICULATE Industrial 2003 Ree Sydney Other processing PAHTPCULATE i 2003 Suun Siray Concrete balchang PAATECLLATE Rs dios enun m aua Page 20413 Annual Tani Curt LI Out 13 Cut 1 1 Ou gt Figure 2 27 Example 3 Select Range 2 27 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 5 Select whether you would like to base the new pivot table report on an existing pivot table report or not If the primary data source of both pivot tables is the same it is preferable to select the Yes button so the Excel workbook will take up less disk space In this example the No button has been selected to simplify the number of steps as shown in Figure 2 28 28x Cime Neck p LGA 42276 2001 3 xp Ki ac AC OF NITROGEN 19277 2003 Weleda Mon Urban On Road OXIDES OF NITROGEN 51783 7547 2003 Wollonddhy Mon urban On Road Mobile PARTICULATE MATTER ium 1742 6907 12274 2003 Sydney Chri PART
4. dnahiatrud 2003 Euburn aug of works GADU E irham 2003 Eutxurn ndustrtal group A or group B wake LEAD amp CONPOUF E Industrui 2003 Auburn Sydney Other actrvibes pnnbng LEAD COMPOUF 1 dnehustruad 2003 auburn Sydney precedi LEAD COMPOU Eur i industrud 2003 Autumn Sydney Beomedcal waste OXIDES OF NITRE ET 1 Industrial 2003 Auburn Sydney Metal plabng er cnatng works OXIDES OF HITRI n D inch 20403 Aitari Cam nt kra OS HITRE I Industrial 2003 Sydney Other matal procatsrvg QxIDES OE MITRI 11 i Induztrud 2003 charted akon produc bon HITRI 2 1 200 iy drin dustral group or group B wadta procesung OxIDES OF I industrial 2001 Zur procegung OF j t Industrial 2003 Auburn Sydney Othe actreibes penibing OXIDES OF HITRI didui 2003 amp uburn Sydney Hk aso industrial group A walle geraten ir SEO OF RITRE 8 Industria 200 Eam Sydney Glorage Lhaerscal OF TRI 1 Industrial 2003 Auburn Sydney Harandous industnal group or group B sagte processing PARTICULATE 2002 Auburn ire ad ale een eo PAHTECLLATE Pindutin 2003 Juin proces
5. dunng 2003 in beg year fer criteria pollutants dung 2003 m beg year Pregerten el aua amaian pret tate report LGA Peeporbon af animal riis chart report LGA module and acinety lor entera pollutants dune 2003 iri module and ackwity for pollutants dunng 2003 mn m Proporbon of eros pet report by LOA and Chart 5 4 Proporbon of annual emmzons paot chart report by amd meus fes cetera polite dng 3033 in module fer pelutants dani 2003 im Figure 2 7 Select Security Level and Medium Step 4 Select the OK button twice 2 7 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 2 4 Password Protection The Excel workbook is write protected to ensure the data cannot be overwritten and requires a password to modify it When the Password dialog box appears select the Read Only button as shown in Figure 2 8 TT i iz 1 1 aj Lacs e 2 Be EM dee duet Det reb meron to 8 LR DINGEN GIA Xs AS fid ai eee furem E ae or Forint Ai Figure 2 8 Select Read Only 2 8 Air Emissions Inventory for the Greater Metropolitan Region in Ne
6. dunng 2003 in legs year for pollutants dung 2003 keg peor Properten of annual poet Labia report by respon Peoportion of annual chart report rote and asin lor cnbena pollutants dans T0903 ii module and actmiby for cribsrus pollutants during 2093 in amrai prot report GMA module and Annual eiie prot chart report by module amd acbwiby for pollutants dunng 2003 in kg yem for criteria pollutants dung 2003 m ka year Prepgerben el annal eren pnost Labis report Proporbon of annual aeons prot chart report module and acinety for onbena pollutants dunes module and ackity or criberia pollutacts dunng 2001 in amepp pret Rabe report by LGA fer ntena Anna Sen pot chart report LGA for pollutants dur 2003 n bp yaar pollutacts dunng 2003 in ky yes Preporbon of anna pr ct Lace report by LGA for Proportion of annual chart report by LGA for pollutants dune 2003 55 e pre TENE M cntena pobutants dummy 2003 in criteria pollutants during 2003 in kg year Proporbon od annual emimvpona pot table report by LGA and Proporbon of annual emmpons pevot chart report by LGA and macula criteria during 2003 in amp module fer cnteria pollutants duri 2003 im
7. emeppone peo tabe report by LGA moder aed Anna Gere ped chart regener LEA modos wi acbwity fer cetera pollutants dunng 2003 in activity fer pollutants during 2003 in bayas Proporbon of annual emiszons preot report by LGA Prpporbon of annual pot chart report by LGA module and actity for criteria pollutants duri 2003 i module and actnity Kr eritana pollutants duning 2603 on 14 Figure 2 9 Select File and Save As 2 9 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Tape oen ESI Their Em report by module reqaon and Li i lese x eT ee chart report by GMA and module for 2002 in kar year amanoni chart repart Ey GME and pollutants dunng 2003 in minism put By criberu pollutants during 1023 in Proportio n of annual proi chart report by LGA for criteria pollutants dunng 2001 n kg vaar module fer pollutants duri 2001 im activity for pollutants during 2003 in ka year Preporbon of annual pr ot Latte report LGA for cntena pollutants dunng 2003
8. 1 Curt 1 1 4 Curt 12 Tabla 2 Curt 2 1 Ou LI Figure 2 33 Example 3 Select Options 2 33 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 10 Uncheck the Grand total for columns Grand totals for rows and Auto format table boxes and select the OK button as shown in Figure 2 34 itl i Hr HH a i H Ti hl Se See ey I E 1 1 ba a um F Figure 2 34 Example 3 Uncheck Format Options 2 34 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 11 Select the Finish button as shown in Figure 2 35 pann 3 M iie c a OXIDES OF NITROGEN 21a21f4 467 CRIES OF RITROGEN 51783 7067 PARTICULATE MATTER ipm 1742 5907 PARTICULATE MATTER 10ym TER T3 853 FARTRLLAATE MATTER 03 PARTICULATE MATTER 2 5um 913 750471 PARTICLLATO MATTER 2 167 MATTER 2 71790 SULFUR DDOX IDE 360 4594 703 5345 SULFUR OPO 36376 4199 TOTAL VOCS 1119504 012 TOTAL TOTAL VOCS 24755 1774 CARBON ONONIDE 1B81100283 37 Cano MONOXBOE 2814211 0993 LEAD COMPOU
9. D aM vt faves 2 14 Select Chart Do pores stats mapu duda eMe crate adu c 2 15 Go Back using Data Description Worksheet 1 2 16 Example 1 Navigate to Table 7 1 2 17 Exaimple T Select LGA UR 2 18 Example 1 Select Supstanca sate ei edebat SER ek e a bea ed te ete dx ee kt ener n 2 19 Example I Pot Table he 2 20 Example 1 Pivot Table Report with all LGAs Selected 2 21 Example 2 Navigate to Table 7 2 2 22 Example 2 Pivot Table Report with all LGAs Selected 2 23 Example 3 Navigate to 2003 Annual Emissions Worksheet 2 24 Emissions to Area Report Analysis Excel Workbook Instructions List of Figures Figure 2 25 Figure 2 26 Figure 2 27 Figure 2 28 Figure 2 29 Figure 2 30 Figure 2 31 Figure 2 32 Figure 2 33 Figure 2 34 Figure 2 35 Figure 2 36 Figure 2 37 Figure 2 38 Figure 2 39 Figure 2 40 Figure 2 41 Figure 2 42 Figure 2 43 Figure 2 44 Figure 2 45 Figure 2 46 Figure 2 47 Figure 2 48 Figure 2 49 Figure 2 50 Figure 2 51 Figure 2 52 Example 3 Example 3 Example 3 Example 3 Example 3
10. prest table report by LGA and medale Tor pollutants during 2003 in Annua pret report LA amd medule for dunng 2993 in ky yei Proporbon of annual emmpons paot chart report by LEA and module fer entena paliutants dann 2003 ie fer criteria pohani donna 2003 m bayas Proponbon of animal ecran pont chart report Ey L module and ackwity tor pollitanta dunng 2003 mn Annual among peor table neport LG amp module aed actraty for pollutants during 2003 in kg year Pregerten el afer prest tate report fy LOA module and actin pollutants durs 2003 ii Figure 2 15 Select Chart 1 1 2 15 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook To go back to the Data Description worksheet left mouse button click the Data Description worksheet tab as shown in Figure 2 16 CHORD 300 000 000 _ PARTICULATE MATTER 2 Sum E PARTICULE TE MATTER Ba NEN NENNEN iu a a a a 3 a T a g p u E n E D 1 7 E g ei 5 els bi a Bl als JEJE f E i Li i 1 3 E E f 4 3 5 3 3 8 8 5 8 3 gis 5 31 3 LAE TE 4 4 pan LAE 1 4 i
11. i group A generaben aeree OF NITRE 2 8 Industria 1007 Sydney Glorage Lhaerscal TALES OF TRI f 1 Industrial 2003 Auburn Sydney Harandous industnal group or group B sagte processing PARTICULATE 2002 Auburn ire ad ale een eo PAHTECLLATE industrud 2003 Aus ri Syiney Mu i Indusirud ADOS Metal pang or moris 41 E 2003 uum fee or detiled alcohol production PARTICULATE El Other processing PARTICULATE ATE Concrete T Pomp Gc Ac Figure 2 25 Example 3 Select Data and PivotTable and PivotChart Report 2 25 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 3 Select the Microsoft Office Excel list or database and PivotTable radio buttons as shown in Figure 2 26 and then select the Next button You may also select the PivotChart Report with PivotTable report radio button at this point and complete both tasks at the same time However the steps required for creating a pivot chart report alone from a pivot table are separately discussed in Section 2 7 ria tung x Em END E n E n UM Module Hy B ILL Tear LGA Regen Activity
12. Anal emeppons preot table report by negeon and module for Citena pollutants duria 2003 m Preporbon annual empena plot Labia report by regen and messe for pollutants during 2001 in Lab neport by acid module for enters pollutants duris 2001 in ba year of acil arden pest bag report By andi module for cribanas palkin during 2003 in 9 Arai prot table report by module and for dung 2003 in Properten of annual poet Labia report by role and for crbena pollutants dang T0903 ArwaiM atric pret table report by module and acbity for pollutants dunng 2003 in Preperban of arcad emidacns pnt Labbe report by masks an iimiy dfnraontens dg PU an emper pneot table report by LGA for criteria pokute dones DOO ng year Proporben of annaal amena pret Labbe report iy LGA for cntena pollutants 2003 m Arras emepponm preot table report by LGA and module for cntena pobutants dummy 2003 in 3 E 2 by LGA and module for cribana 2003 m Anraxa prot tabe report by LGA module and acbwity fer cetera pollutants dunng 2003 in Proporbon of annual eresaons preot tabe report LGA
13. 29 m 2 A La dli LILILLIILI Ea Brus E 1ndustrud i Industria lnahuatrud i Industrud 1 Lidia Industrial i Industri 1 lnadusrud E i Industrud E E Induri 1 drahuatru 8 Irmi i Industrud 1 Industrud 1 druhr trud i Iriran i Industrud 8 Indira i Industrud Industrial 1 1 industrial Industria jnedustrud 8 Industria Indurtrud induti i Industrud i Indusirud Industrial Industri 2003 2003 2003 2003 Euburn 2000 Aun 2003 Auten 2003 Auteur ZI Rubr 2003 Eum 2002 Eun 2002 2003 Eutr 2005 Rubr 200 Luturn 2003 Eum 2003 2002 2003 Eum 2003 Suter Z003 2003 Eum 2003 Auteur 2009 Eutr 2003 Kum 30003 Aibar Z003 2003 Eum 2003 ZD03 Sukarn 2003 Eum 2003 Auber Z002 2003 Eun 2003 2002 Sateen 2003 Eum 2003 2002 Auburn 2003 Eutr 2003 Gur date 2003 Eum furl Sydney Sydney Sydney Sydney Sydnany Sydney Sydney Sytiney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Sydney Ofte mykas crop Other crop apg Othe agncultira crop Chem
14. pollutants dung 2003 qm 55 dones n Sy cntena pobutants dummy 2003 in cntena pollutants duning 2001 n ingtyear 1 a mn ions pevot chart xxt by LGA and module fer pollutants during 2003 im 7 1 emepposne peo tape report by LGA modu and Anna qe pest chaek report LGA modos acbwity fer cetera pollutants dunng 2001 in kg year activity pollutants during 2003 in kayas za 8 E eS Rte BI zm ndi L ELLE m Proporbon of anma emenka pet table report by LGA Prpporbon of annual eme mons pest chart report by LGA edule and for criteria pollitants dorrea 3003 m module and fer criteria polluted dunng 2003 in Figure 2 5 Select Tools and Options 2 5 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook O Step 2 Select the Security tab and Macro Security button as shown in Figure 2 6 NOSE REM hor dung 2003 in Ss tutarits dunng 2001 n kg year of annual ppf chart report by and r cntena pollutants dung 2003 in chart report br entera pollutants duning 2003 ka year ef annual matena pivot chart report Ey regen d acEniby n arm duning 2
15. LEAD C 00005 PARTICUL PARTICLE SULFUR E TOTAL mue 13072 POS 51292857 442556 74 4737132 Pw Wa EI DORMIT amp 555553 163956 72 426508 4 41235 9168244 174945 i 285 31727953 TSS 3075122 1274064 JEN Be 2817253 SOS 1630728 5317258 TOE 4250 261 15 JjET 7DA T 1642055 20041 9 13324773 385551 571254 938559 MEN PT it TOT 1 PE ITHE EY A54 34 1279141 1805 3593 12405803 TT OS 248825 E 23101243 E3332 OTE 42938 3511253 1 Jiu 7918004 1 QYM 13905467 Te 1053773 E 1578811 DEN 3T X2 H 275435 106596 2770676 GE AE HATS E ca em RET 1556372 WRG TERT B EL eee 2 11463 6344734 272448 FST 106077 9833575 aa ee eer ord de JE Figure 2 37 Example 3 Select 2 37 Emissions to Area Report Analysis Excel Workbook Instructi
16. r Deo parim cm 5 LI DIENEN RS x mb Tnm agi fures 1 L3 11 2 Mi renim 74 Pim Oo OFFICE 111 ran nahm s 5 Figure 2 4 Select Enable Macros 2 4 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 259 Macro Security Settings You may need to adjust your Excel macro security settings to run the macros built into the Excel Workbook If necessary follow the steps below Step 1 Select Tools and Options from the command menu as shown in Figure 2 5 Tim De inal to renort module UGA and acbwity for embana pollutants dunng 2003 in Annana ameona preot table report by and module for cribena pollutants duria 2003 m theca For eritana pollutants during 2001 in Annual amema prot table report by GMA and module for griteria pobutante duas 2003 in for pollutants dunng 2003 m kg year Proporbon of annual emamons pot chart report Ey madia Fer dunng 200 in Annual prot chart report and module Tor criteria pollutant donng 2091 n kg yaar
17. Chamari 17 12 tnd 2717 fereg 253 TE Concrete betcterd 2 FI Crha qnn ape ee BE 5 07 2780 Chores elected dnm a2 kii 21 Cows p ncosame lange puer o 10000 BL pir rai 4 55 a 2782 ao Treaster prnoseEeg by pier LOOOO ML per pear 3 958 4 320 4 2783 Weis Sd neci 251 i 3784 Industrial Total 70 037 2785 CH nad Moba Comer Ei 2785 Ces E 25 880 2n vatum 17 731 2788 3 514 r a mire d 2 Figure 2 17 Example 1 Navigate to Table 7 1 Worksheet The pivot table contains drop down menus that allow you to make the following selections Local Government Area LGA e g Ashfield Module Name i e Biogenic Commercial Domestic Commercial Industrial Off Road Mobile and On Road Mobile Activity e g Automotive Fuel Retailing Substance e g CARBON MONOXIDE 2 17 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook In Example 1 the following selections have been made using the drop down menus LGA Ashfield Module Name All Activity Q Substance TOTAL VOCS The steps required to do this are described below Step 1 Select the LGA drop down menu uncheck the Show All box and check the Ashfield box as shown in Figur
18. You will now notice all the original formatting has been lost as shown in Figure 2 51 The loss of pivot chart report formatting will occur every time a new series of selections is made from the drop down menu in a pivot table or pivot chart and is a well known Excel shortcoming One of the easiest ways to easily reapply the desired chart format is to develop a User defined Custom Type and save it This format can then be reapplied time after time quite easily TOTAL VUE Figure 2 51 Example 6 Pivot Chart Report with Selections 2 51 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook O Step 6 Select the pivot chart report right mouse button click and then select Chart Type as shown in Figure 2 52 TOTAL VOCE Figure 2 52 Example 6 Select Chart Type 2 52 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook O Step 7 At Chart 1 1 select the Custom Types tab and the User defined radio button and press the Add button as shown in Figure 2 53 Enter the Name as Pivot Chart v1 and Description as Apply to Charts 1 1 amp 2 1 and press the OK button twice as shown in Figure 2 54 At Charts 1 2 3 1 and 3 2 follow the same procedure and create Pivot Chart v2 and Apply to Charts 1 2 and 2 2 Pivot Chart v3 and Apply to Charts 3 1 4 1 5 1 6 1 and 7 1 and Pivot Chart v
19. TER Fage Data 70971 Annual 1 Curt 1 1 4 Curt 12 Tabla 2 Curt 2 1 Ou LI Figure 2 29 Example 3 Select Layout 2 29 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 7 Construct the pivot table report by dragging the field button on the right to the diagram on the left as shown in Figure 2 30 and Figure 2 31 i RUM RR Figure 2 30 Example 3 Pivot Table Layout Wizard 2 30 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook iie EX IEEE CH Fal k d ij qii ad r Ei zr 89 ed E F Figure 2 31 Example 3 Drag Field Button a Sti bes e cun wear 2142184 4567 OXIDES OF NITROGEN 51783 7647 PARTICULATE MATTER 10 1742 8907 PARTICULATE MATTER 10pm 75573 453 PARTICULATE MATTER 10ym 948 4103 PPARTRCLLATE MATTER 2 5 913 750471 PARTICLLATO MATTER ipm 1076 504404 PARTICULATE MATTER 2 5 m 72488 71796 SULFUR DIOXIDE 360 4594 703 6345 SULFUR DIOXIDE 363764199 TOTAL VOCS 1119504 012 TOTAL vOCS 102948078 TOTAL VOCS 24746 1274 CARBON MONOXIDE 18110083 37 CARBON MONOXED
20. 110 7 91 bd 1 732 1 33 11 bse 30 425 300 13 537 512 194 1 574 343 208 18 p HH 2493543 1 Ej 281 283 271 951 112 470 94 749 057 12 810 15 453 704 11 815 501 fed an TERE PETI 15 788 15434 TT 3 5 LETT 53 923 TREE 37 544 Hu 3 553 304 PET 377 544 amp 208 21 52 817 412 KL NITET TR MO am mos 07 171 227 719 244 458 2 473 1135 29 T S5 eb 1 CETT 12 345 758 3649 2 206 573 18801 8758 Figure 2 40 Example 3 Formatted Pivot Table Report Q Step 17 Make the desired selections from the Region e g Sydney Module Name e g Show All and Substance e g TOTAL VOCS drop down menus as described in Example 1 Section 2 4 1 Step 18 Copy the table from the Excel workbook past into Word document if required and format as shown in Table 2 1 Emissions kg year Region Sydney Total 2 40 Table 2 1 Example 3 Formatted Word Table Module_Name Biogenic Commercial Domestic Commercial Industrial Off Road Mobile On Road Mobile Substance TOTAL VOCS 33 988 648 9 931 259 52 008 753 13 989 467 4 796 985 50 171 664 164 886 777 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook
21. 2 6 Using and Interpreting Existing Pivot Chart Reports 2 6 1 Example 4 Using Pivot Chart Reports Example 4 investigates the use of Chart 7 1 in the Excel workbook Chart 7 1 contains an annual emissions pivot chart report by LGA module and activity during 2003 in kg year Start by navigating to the Chart 7 1 worksheet using any of the methods described previously as shown in Figure 2 41 Em Pond gp at pui qe X 4 i terea to LEADH TIREN Moa aj i LUI LIII 1 JN ILE NLIS LEM EM D Nd ID PLE LII ILB E P p sien Rd d e TOi i T 1 i LJ L LL 2 Figure 2 41 Example 4 Navigate to Chart 7 1 Worksheet The pivot chart contains drop down menus that allow you to make the following selections Local Government Area LGA e g Ashfield O Module Name i e Biogenic Commercial Domestic Commercial Industrial Off Road Mobile and On Road Mobile Activity e g Automotive Fuel Retailing Q Substance e g CARBON MONOXIDE 2 41 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook In Example 4 the following selections have been made using the drop down menus L
22. Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 3 Example 4 Example 4 Example 4 Example 4 Example 5 Example 5 Example 6 Example 6 Example 6 Example 6 Example 6 Example 6 Select Data and PivotTable and PivotChart Report Select Microsoft Office Excel list or database and PivotTable SelecE S AOV Ute NO d SelecE LAV OUP gian Pivot Table Layout Wizard ER E EY ra RE RR Ed EAE Drag Field BURON eie adesset eee t Lodo Select PIVOT able FIC ODLIOlIS ees Uncheck Format ODEIOFIS exu Select SEIDISE de dune soU de uU baut utei iR cda S due Unformatted Pivot Table silere dp TE Select Format Cate bud uda dads e Formatted Pivot Table Navigate to Chart 7 1 Select POR dup D Ua Mc i LI Iu LI Select SUDSTANCE PiVOE Char
23. 2001 Wollongong Wollongong On Road PARTICULATE MATTER 2 5m 1077798709 kJ 1 BARTBECULATE MATTER 2 17294 14719 2300 2003 Wolengena Wolengong On Esad Mobis zixrum 5331 8332 2003 Wollongong Sydney SULFUR DIOXIDE BOB 9928 MO 2003 Wollongong Sydney On Road TOTAL VOCS 313043 8228 2303 2001 Wwelongseg Wolongeng On Road Mobis TOTAL vOCS 2073171 05 2003 Woollahra Sydney On Road Mobile CARBON MONOXIDE 1997560 89 12964 2003 Woollahra Sydney On Road Mobile LEAD amp COMPOUNDS 51 83057B851 12306 2001 woclahra Sydney On Read Mobile OXIDES OF NITROGEN 251172 4581 2003 Woollahra Sydney On Road Mobde PARTICULATE MATTER 11122 7472 2003 Woclahra Sydney On Road Mobile PARTICULATE MATTER 25m 10516 18079 2003 Woollahra Diinan re Road Mbia 459 796 310 2003 Wocllahra Sy mey On Road Mobile TOTAL VOCS 230919 5237 MT 2003 Wyong Mon Urban On Road CARBON MONOXIDE _ 16719292 4 12112 2001 Wyeng Mon urban On Read Mobile LEAD COMPOUNDS 385 4155824 12913 2003 Wyong Mon Urban On Road Mobile OXIDES OF NITROGEN 2445204 838 i ii PARTICULATE MATTER 106654 7105 un j Mon Liban PARTICLEATE MATTER 2 5 102123 174 16 2003 Wyong Mon Urban On Road Mobis BPnT 30 12111 2003 Wyong Mon Urban On Road Hobia TOTAL VOCS 1852317 619 1
24. H CT x m he He a did T LID 22 170 i 8 11 x 954 11 Figure 2 19 Example 1 Select Substance 2 19 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook After making these selections the Example 1 pivot table report will look like that shown in Figure 2 20 Cris dm wig fd 41 eem m E F 12 Cutback Bturrer 13 a ee a H Pure ang 17 Lian Bowery M iari Higain Pubes pen 7 Ljed ipii ui Huei Tram Cuni 19 Doig Pom pirrar 20 231 Ste 21 ommerr al Total 2 incarna 2 24 0 25 Commarzu M e 21 rcgi rad 28 Rel 29 Beas X ESOS 11 Dn Boad 571 178 13 1 241 381 24 x W H 41 41 T me Toas Cat Cut Tibe Cart 2 8 Cort hl Curt 2 s Table 7 Chat Figure 2 20 Example 1 Pivot Table Report You should note that Chart 7 1 is based on Table 7 1 so the information presented in the chart will also be modified according to these selections
25. z Tae a gani hag 28x Dron Page Fields Sexe Fot V Zee beis m peser um or dm tergay 20 ium rcm amm caa 4 Figure 2 58 Example 6 Select Scale 2 58 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 10 The final pivot chart report will now look like that shown in Figure 2 59 Please refer to Help in the command menu for further assistance J Drop Fields TOTAL VOCS Figure 2 59 Example 6 Formatted Pivot Chart Report 2 59 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 11 You may wish to hide the pivot chart field buttons To do this select any of the pivot chart field buttons right mouse button click and then select Hide PivotChart Field Buttons as shown in Figure 2 60 is E 1 Figure 2 60 Example 6 Hide PivotChart Field Buttons 2 60 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 12 Copy the chart from the Excel workbook past into a Word document if required and format as shown in Figure 2 61 55 000 000 50 000 000 45 000 000 40 000 000 35 0
26. 012 941 704 203 67 466 186 267 267 1 E Table 1 3 of 6 gt EET B 2 24 1 49 2725839 EDT F 255 LE Faai T ELS 1 8 T EMi 3 gas 411 Sedney Total 25 9405 Aia T m mam n nu TIN nen Figure 2 14 Go Back using Web Toolbar 2 14 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook To select a chart left mouse button click the Data Description worksheet tab either move to the cell required or left mouse button click the macro hyperlink An example selection for Chart 1 1 is shown in Figure 2 15 panes ous x True eee nena Tor Eeoogh and orans phat tables 3nd charts 2003 Annual Emegong Annua ememmens to area report by module LGA and actraty fer eriterus pollutants dunng 2003 in kg year Arai rabie report by repon and module for dorsa 2003 m Ire ri mre aeger 7 Annual pror Chart repot by and module and regen for poliutants 2003 m bayas fecporbion of annual envi prat cha
27. 0709 PARTICULATE MATTER Jem 7294 14719 kJ 1 2300 2003 Wolengena Wolengong On Esad Mobis zixrum 5331 8332 2003 Wollongong Sydney On Road SULFUR DIOXIDE BOB 9928 232 2003 Wollongong Sydney On Road Mobile TOTAL VOCS 313043 8228 2303 2001 Wwelongseg Wolongeng On Road Mobis TOTAL vOCS 2073171 05 2003 Woollahra Sydney On Road Mobile CARBON MONOXIDE 1997560 89 12964 2003 Woollahra Sydney On Road Mobile LEAD amp COMPOUNDS 51 83057B851 12306 2001 woclahra Sydney On Read Mobile OF NITROGEN 251172 4581 2003 Woollahra Sydney On Road Mobde PARTICULATE MATTER 11122 7472 2003 Woclahra Sydney On Road Mobile PARTICULATE MATTER 25m 10516 18079 2003 Woollahra Diinan re Road Mbia 459 796 310 2003 Wocllahra Sy mey On Road Mobile TOTAL VOCS 230919 5237 MT 2003 Wyong Mon Urban On Road CARBON MONOXIDE _ 16719292 4 12112 2001 Wyeng Mon urban On Read Mobile LEAD COMPOUNDS 385 4155824 12913 2003 Wyong Mon Urban On Road Mobile OXIDES OF NITROGEN 2445204 838 i ii PARTICULATE MATTER 106654 7105 un j Mon Liban PARTICLEATE MATTER 2 5 102123 174 16 2003 Wyong Mon Urban On Road Mobis BPnT 30 12111 2003 Wyong Mon Urban On Road Hobia TOTAL VOCS 1852317 619 1 TER Fage Data 70971 Annual
28. 4547229 1774204 6 ERE 2747 251212 959 Stra 129 30174 METTDA T eee 13829773 2370085 3865516 SIME iex gt arae c i eet BM TAE 1 SIE 08 384165 T s aen 1855 1806 393 1844493 BITE 47 ATH Tra Trae e De Oe pen mam dm RM MENDA NOR 1 SITOZ38 184 2373 659 THAT NOT AM 4152 753 1N 20475798 WT Sore PP 1071148 ME Perle MMA 5395413 5203 87 cH NT458 TE 0 55200 17 c MAIN 106006 08 O6 Pa 1600416 90848 5073734 2207292 244A 20696 12552 1189582 114263 654794 2134848 502 447 173ELTSB 2206573 SOE 981578 FS ee 21 PCT s c B TE Page 7 2003 Emo 1 Curt 2 2 Cet 10i ruo mL dd Arii Figure 2 39 Example 3 Select Type 2 39 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 16 Select the desired cell Alignment Font Borders and Patterns according to Step 14 The final pivot table report will look lik
29. 5 8 i 5 8 E 8 5 5 5 1 Sydney Non brian Figure 2 16 Go Back using Data Description Worksheet Tab 2 3 3 Using Worksheet Tabs Rather than using the in built or macro hyperlinks to navigate the Excel workbook you may choose to left mouse button click on any of the worksheet tabs instead to access the relevant information 2 16 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 4 Using and I nterpreting Existing Pivot Table Reports 2 4 1 Example 1 Using Pivot Table Reports Example 1 investigates the use of Table 7 1 in the Excel workbook Table 7 1 contains an annual emissions pivot table report by LGA module and activity during 2003 in kg year Start by navigating to the Table 7 1 worksheet using any of the methods described previously as shown in Figure 2 17 iua 2 Pat Dubhe J T Domus iced 9 14 FR TE ETT 31 82 2757 zd 2 68 276 as heh I Took Fui Dora LIAE Ed 23 ZTT1 Caafr sgs ni Commernrini Tolal 3 170 265 5 4 1 FIER humen cr prodectmn 274 m na SITE Carmreca pezedluchen 271 Caec
30. EXISTING PIVOT TABLE 5 1 2 17 2 4 1 Example 1 Using Pivot Table Reports 2 17 2 4 2 Example 2 Interpreting Pivot Table 2 22 2 D CREATING NEW PIVOT TABLE REPORTS 2 24 2 5 1 Example Creating Pivot Table Reports 2 2 24 2 6 USING AND INTERPRETING EXISTING PIVOT CHART 5 2 41 2 6 1 Example 4 Using Pivot Chart Reports 2 2 2 2 72 0 2 2 2 7 7 2 41 2 6 2 Example 5 Interpreting Pivot Chart Reports 2 2 45 2 42 GREATING NEW PIVOT CHART REPORTS Ob a e Ua eoo ud ene me 2 47 2 7 1 Example 6 Creating Pivot Chart Reports 2 2 2 2 2 2 27 7 2 47 3 jeg zii2 lere 3 1 Emissions to Area Report Analysis Excel Workbook Instructions List of Tables Table 1 1 Table 2 1 List of Tables Definition of Greater Metropolitan Sydney Newcastle and Wollongong regions 1 1 Example 3 Formatted Word 2 40 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales List of Figures Figure 1 1 Figure 2 1 Figure
31. Hikrardous induatral or group arite processum CARDON MONOXB 1 industrial 2003 Autun Sydney Harardoum ndustnal or group A waste genwerabon or storage LEAD COMPOUF i 2003 77 Metal plating or works LEAD 17 1 dneustrud 2003 Auburn Sydney Chemeal Storage Other Chermecal Storage LEAD Wi 8 nah triad 2003 Eun Cement bma hari LEAD 19 Irnwedustirud 2003 Eur Dydy LEAD amp COMPRE 20 32003 Suburi Behe preda COMPRE 41 8 agin 2003 LEAD amp 22 20023 Sydney Other matal LEAD CONPIRE 21 D dpahr truM 2003 Auburn Crusher gring of bapa aii LEAD A 2a E Inia 200 Eum B waste prepping LEAD amp 25 i Indausiru 2003 Other gavin LEAD 26 1 dnehustruad 2003 auburn Sydney Mk precedi LEAD A COMPOU 8 initrd 2003 Em Syiney ee CXIDES GF ATRI 28 i Inui 2003 Gy Metal pling or cna vor CHRIDESG ITAL 3 2003 auburn Sydney Cament handle OXIDE Of I Industrial 2003 amp Kutu
32. Introduction 1 INTRODUCTION The Department of Environment and Climate Change NSW DECC has completed a three year air emissions inventory project DECC 2007a DECC 2007b DECC 2007c DECC 2007d DECC 2007e DECC 2007f DECC 2007g DECC 2007h amp DECC 2007i The base year of the inventory represents activities that took place during the 2003 calendar year and is accompanied by emission projections in yearly increments up to the 2031 calendar year The area included in the study covers greater Sydney Newcastle and Wollongong regions known collectively as the Greater Metropolitan Region GMR The study region defined as the GMR measures 210 km east west by 273 km north south The study region is defined in Table 1 1 and shown in Figure 1 1 Table 1 1 Definition of Greater Metropolitan Sydney Newcastle and Wollongong regions GREATER METROPOLITAN SYDNEY NEWCASTLE WOLLONGONG MGA Map Grid of Australia based on the Geocentric Datum of Australia 1994 GDA94 ICSM 2002 The air emissions inventory includes emissions from biogenic i e natural and anthropogenic i e human derived sources The anthropogenic source groups included in the air emissions inventory are as follows O Commercial businesses i e non EPA licensed Domestic commercial activities Industrial premises i e EPA licensed Off road mobile i e non registered off road vehicles and equipment and O On road mobile i e regi
33. Table 1 1 in the Excel workbook will be created from first principals Table 1 1 contains the annual emissions pivot table report by region and module during 2003 in kg year The steps required to do this are described below Step 1 Navigate to the 2003 Annual Emissions worksheet as shown in Figure 2 24 Comm Me D F Z 5 denhusirud 2003 Sydney Other PARTICULATE 3 8 Industria 2003 DE crop pe Gal ape PAHTPLLERATE i 2003 AHi Cher prec ued crop TOTAL VOLS i Imin 2003 Sydney Chemecal Other Storage CARDOM Tmin 2003 Rum ri RSM i Industrud ADOS Metal plabng or moris 2003 Suburi Sidney fete 21 ae Reo fw OADD 3 Industrial 2003 dot Dydy Ober matal procengireg 10 i Indiusirus 2003 Suban tyran Becr or aco prodsaoctum 1 dneustrud 2003 Auburn Sy ney Carent of CARDON aril E Inahusiru 2003 Juin Mu DARRI Be 01 2003 Eutr Haradous n dustral or group waste generabon por storags CARGA 2003 Auburn
34. Wales 2 Using the Excel Workbook Step 3 Select the Chart Wizard from the PivotTable toolbar as EM lap tees CARBO HOME LAD amp ere 27 315 L7 EPET LESE 10 423 705 ah ea 555 552 rre AS RT 47 762 002 545 545 161 LES 315 520 221 a 53 227 Foe AT 387 012941 Table 1 3 rr 6 E Medien 21 Haee MORE 3 801 984 145 17 anag 1 852 304 BIE dein 13 172 431 ha B8 aoa 13 137 28 713 Ia i433 TO 2512 ex 2 54 aged Lae LAETI 4 702 ETI 3 54 i17 a EN 18 ig Lou 1 072 002 Li ie Mi 153 84 1 727 741 987574 223 ILOH 354 36 5255 28 11 524 154 184 152 181 447 3 ba din R01 shown in Figure 2 49 a TE EPA 2 078 354 3 554 7 811 028 1 711 195 1 507 008 35 010 555 91 231 185 281 eo 1 705 571 dA T AT TET 81 LEE 3 049 348 14 824 718 871 2908 165 2 878 475 20 748 2 465 386 S4 2 2598 1 45 A ci 25 94 84 IL u
35. in criteri polutants dung 2003 bayer Anman emeppong pect report by LGA modu and acbwity fer dunng 2003 in Proporbon of annual prot Labia report LGA module and actnety Tor pallutanbs dura 2003 n f Prpporbon of annual emesmons pevnt chart report by LOA module and fer pole dunng 2003 8 Figure 2 10 Select Save 2 10 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 3 Navigate the Workbook 2 3 1 Excel Workbook Structure The Excel workbook is based on an Emissions to Area Report for the GMR in 2003 that has been extracted from the Emissions Data Management System EDMS v1 0 DECC 2008 The Excel workbook contains a Data Description worksheet that includes in built or macro hyperlinks to the following Q Instructions These instructions 2003 Annual Emissions Emissions to Area Report for the GMR in 2003 O Table x x 14 Interactive pivot table reports Chart 14 Interactive pivot chart reports The contents of the Excel workbook can be viewed by left mouse button clicking on the Data Description worksheet tab as shown in Figure 2 11 Iratructionn for runagatreg rough workbook and prot M 4 tables and charts e acbwity for embera pollutants dunng 2003 wn
36. listed above select Extract from the command menu select the directory to Extract to in the window and select the Extract button as shown in Figure 2 2 t Tuer Fio t EXT durum Hae tote oe Tes fee pine re Mense n 171171 Pp 8 ber pate o Len B IE dec re 1 B Speeder on lunar DE ruat ce leit DNI z d od Paco 1 Be 8 LT 9 GG Figure 2 2 Extract tr10aei08260cp xls Ensure the Excel workbook and these instructions are contained in the same directory so you can navigate to the instructions from the Excel workbook 2 2 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 2 Using the Workbook 2 2 1 Open Workbook Open Windows Explorer and navigate to the Excel workbook at gmr aei 2003 tr10aei08260cp xls Double left mouse button click the Excel workbook file as shown in Figure 2 3 Ves Tod p G sm kem CC rem gew se 200 Hume a em LL eara Aber Acrea Document ow Sy Cog z dm d LIS EET AIE fd Lcd cca i me c
37. rescue and Tor criteria pollitants dorrea 2003 i 5i Anmual emepons peoi chart report and modu and sagen for cotana poltants dune 2003 m lg Sear Chai 12 Proporbon of annual emanons prot chart report by repon ard made Kew critanua polluants dunng 2007 an Annua chart report CME and modus Tor cites pollutants dunng 2091 n Chat 2 7 Proporton of annual manoni chart report by GME and module fer crtana peliutanks during 2003 in w Anual emuiqons peek chart report module and for criteria pasanta 2003 in Peopartion of annual chart report by tegen mode and actrity fcr cribsrus pollutants during 2093 in Annual eens rect chart report module and for citons pollutanks dung 2003 m Peoporbon of annual prot chart report module and actrity for pollibaeits during 2001 amp Anna amapang pect chart report LGA for Pies 2003 keg ype Proporbon of annual amont chart report by LGA fol T cnbena polutaets 2003 in Annual prot chart report LGA amd module for pollutants duning 2001 in Proporbon of annual emwppons chart report by LGA and module fer cnteria pollutants du
38. the Next button Tra du PARTICULATE Other agricultural crop PAHTPRCLAATE Other agncultural crop procesado TOTAL VOCS 5 Chemcal Other Chimical Storage CARBON MONGKE d acirebes Sydney Metal plating works CARBON E inguinal 2003 Auburn Sydney fot al eee eo CAA Industrial 2001 Auburn Other matil CARDA MONDI TU i Industrusd 20035 Suban Bydnary Beer nr derplled aco inetd 2005 Suburi Carmen ar bres KESM XE E Industrial 2003 Mu proces CARRI 1 Industrud 2003 Auburn Sydney Harandoum industrial or group A waste bon or strae CARBON MONOXI dnadustrud 2003 Euburn 19 deri ERES industrud 2003 Exam abr ege LEAD i 2003 EAD 47 i 2003 Euren LEAD CoONMPDUT a miira 2003 Ern LEAD 15 1 Industrud 2003 Auburn LEAD amp COMPO 32003 COMPRE Industral 2003 LEAD amp 20023 Suin Other matal procezsag LEAD
39. the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 9 Select the pivot table report Options button as shown in Figure 2 33 ww EIN Sen OxIDES OF HITREHZEN 214714467 dm OXIDES OF NITROGEN 51783 7007 nn PARTICULATE MATTER 742 6907 779 2 PARTICULATE MATTER J pm 76873 45 PARTICULATE MATTER 10ym 848 4103 PARTICULATE MATTER 2 5ym 913 750471 20 PARTICLLATE MATTER ipm 1675 500404 PARTICULATE MATTER J 5m 73486 7790 122 SULFUR DIONIDE 360 4594 1285 SULFUR DLOXIDE 703 5345 122 SULFUR DIGXID E 30370 4199 23 TOTAL VOCS 1119504 012 PES 2 TOTAL vOCS 10294 8078 D 20 m TOTAL VOCS 24746 L974 12250 iur p un Pave te report CARBON MONOXEDE IB110083 37 AR 2003 Wellongeng Sydney On Rad Timm CARRION More StH 2814211 093 ZU 2001 Wollongong _ Sydney On Road gt LEAD amp COMPOUNDS 61 460912 2293 2003 Wollongong Wollongong On Road Ot LEAD amp COMPOUNDS 446 8223852 AFIM 2003 wWobongeng On Read OXIDE 5 OF NITROCEN 3105650 04 2002 Wollongong Sydney On Road OXIDES OF NITROGEN pps ITZ29 2003 Wollongong _ Sydney On Road PARTICULATE MATTER ipm 1B044 8174 12297 3003 welengeng Wollongeng On Read PARTICLLATE MATTER 10pm 113030 4744 2 2002 Wollongong Wollongong On Road PARTICULATE MATTER 1 5 107779
40. 00 000 30 000 000 TOTAL VOCS 25 000 000 20 000 000 Annual Emissions kg year 15 000 000 10 000 000 5 000 000 Biogenic Commercial Domestic Commercial Industrial Off Road Mobile On Road Mobile Sydney Region Figure 2 61 Example 6 Formatted Word Chart 2 61 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 3 References 3 REFERENCES DEC 2005 Approved Methods For the Modelling and Assessment of Air Pollutants in New South Wales New South Wales Department of Environment and Conservation Sydney Australia http www environment nsw gov au resources ammodelling05361 pdf DECC 2007a Air Emissions Inventory for the Greater Metropolitan Region in NSW Air pollution where does it come from Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air aeibroc0 7335 pdf DECC 2007b Air Emissions Inventory for the Greater Metropolitan Region in NSW Criteria Pollutant Emissions for all Sectors Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air trlaei0712 pdf DECC 2007c Air Emissions Inventory for the Greater Metropolitan Region in NSW Anthropogenic Ozone Precursors and Particle Emissions in the Greater Metropolitan and Sydney Regions Results Depar
41. 003 in w cntena pollutants during 2 2003 m bo year of annua emusmons c chart report by o coniun acres amd ttd aer developers LITE Proportion of annual emasions povot chart report by LGA Tor chtens pollutants dur 2003 in pollutants dunng 2001 Annual table report by LGA and mada Tor Aud chat report LGA amd grbina pollutants duri 2003 in bgyan pollutanbs dunng 299 in kg year Proporbon of aad amaeana pot Exe report by LEA and Chart Proporbon of annual emapons chart report by LA aed medius fer cetera pelas donng 20413 in module fer entena paliutants dari 2003 ie Anu amigos pot rabie report by LOA module aed Annual phit Chart report Erg LGA and actraty for eritenua pollutants duni 2001 in kg year for enfera pollutants dung 2003 m kgf peur asma emn post report by LGA Proparin of animal derided chart report L module and actinety for centena pollutants duris 2003 ii module and ackwity for poliitanta dunng 2003 mn Figure 2 6 Select Security and Macro Security 2 6 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook O S
42. 1 pdf DECC 2007i Air Emissions Inventory for the Greater Metropolitan Region in NSW On Road Mobile Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr8aei0713 pdf DECC 2008 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales Emissions Data Management System EDMS v1 0 User s Manual Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr9aei08181 pdf 3 1 Emissions to Area Report Analysis Excel Workbook Instructions 3 References ICSM 2002 Geocentric Datum of Australia Technical Manual Version 2 2 Intergovernmental Committee on Surveying and Mapping GPO Box 378 Canberra ACT 2601 Australia http www icsm gov au icsm gda qgdatm gdav2 2 pdf Microsoft 2008 Microsoft SQL Server 2005 web page last accessed on 17 March 2008 http www microsoft com sql default mspx NEPC 2000 National Environment Protection National Pollutant Inventory Measure As varied 20 June 2000 Environment Protection amp Heritage Council Adelaide Australia http www ephc gov au pdf npi npivar measure0600 pdf NEPC 2003 National Environment Protection Ambient Air Quality Measure as varied May 2003 Environment Protection amp Heritage Council Adelaide Australia http www ephc gov au pdf Air Quality NEPM a
43. 155531 EIA 277282 244 14 19172671 472 5411 nesr 118498 2 6 BTE Page Duca Dexrpboe Sheeti 200 Emo Tae 1 4 1 Lf 12 Tae 2 Ot imm s S OLIO c Pad Ur 097 Figure 2 38 Example 3 Select Format and Cells 2 38 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook O Step 15 Select the Number tab and the Category Custom from the list Scroll down to the end of the Type list and select the format gt 100 0 lt 0 01 0E 0 0 00 for emissions in kg year or the format gt 0 01 0 00 lt 0 00001 0 000000 0 0000 for proportion of emissions in 96 as shown in Figure 2 39 You may create other custom number formats Please refer to Help in the command menu for further assistance a Ajak Gee eet eet pasim ee eee 5 A J a UNES D b m Cnm ger ab 0058 B 1788077 51072 1011589 819057 44256 473711 Jone eM Be DOT 5801554 3505563 1635962 4265004 4120000 2850455 17275853 E i 1391758 iu 44785409 xm T
44. 2 2 Figure 2 3 Figure 2 4 Figure 2 5 Figure 2 6 Figure 2 7 Figure 2 8 Figure 2 9 Figure 2 10 Figure 2 11 Figure 2 12 Figure 2 13 Figure 2 14 Figure 2 15 Figure 2 16 Figure 2 17 Figure 2 18 Figure 2 19 Figure 2 20 Figure 2 21 Figure 2 22 Figure 2 23 Figure 2 24 List of Figures Definition of Greater Metropolitan Sydney Newcastle and Wollongong regions 1 2 Create directory C nsw gmr del 2003 2 1 ExtracE trI0del098260CD XIS aw dedu 2 2 Open Workbook 10 08260 2 44 2020202222 2 2 2 2 2 2 2 2 3 SelecL ENa pIe Macr OS oet bn 2 4 Select Tools and csse eau en ode Eq de 2 5 Select Security and Macro 7 2 7 2 2 2 2 2 2 6 Select Security Level and nennen nnn nnn 2 7 SCIGCCE Read OMIY rm 2 8 Select File Save AS inisin aine T A UA 2 9 SAVE 2 10 Select Data Description 2 2 2 11 Web suce t 2 12 SelecE Table PA ex E o darin 2 13 Web TOODA iade iare
45. 2 45 All other proportions shown in the pivot chart report are proportions of annual emissions in Ashfield LGA only However if all LGAs are selected you will notice the Ashfield Total is 0 34 96 as shown in Figure 2 46 All other proportions shown in the pivot chart report are proportions of annual emissions in all LGAs i e GMR aal di TEIL 1 00 EI Lg eee Magn Pan er Pe Lll ey eed jeie ee ee ey es eee ees LI Sr es Sy ee dm Jae i is c tip RR E 4 re BEREH 44 iE ea RR HH rH m d HERS Fiap i 11 und L pas i m T h 4 aim ete FE ine wine a 4 18 Figure 2 46 Example 5 Pivot Chart Report with all LGAs Selected 2 46 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 7 Creating New Pivot Chart Reports 2 7 1 Example 6 Creating Pivot Chart Reports Example 6 describes the steps required to create a pivot chart report Specifically Chart 1 1 in the Excel workbook will be created from first principals Chart 1 1 contains the a
46. 4 and Apply to Charts 3 2 4 2 5 2 6 2 and 7 2 Pivot Chart v1 to Pivot Chart v4 will now be available for you to apply time after time You may create other custom chart formats Please refer to Help in the command menu for further assistance de 2H x id oam Chet cusam Lea Cari BTOTAL m 649200 PARTICULATE MATTER 2 PARTICULATE MATTER 10m 2 8 a E 1 414 3 i Ble Ee SE 3 1 i i fs tr s ili 4 3 REJE 118 RA 84 3 3 EJ Lf Li E a Lu a L 1 4 T PT T T T i T a M 2 5 E 5 Sydney ag the Non Figure 2 53 Example 6 Select Add 2 53 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook TT THREE iiis ii i 818 i 5 8 i Ho Figure 2 54 Example 6 Enter Name and Description 2 54 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook O Step 8 Select the Custom Types tab and the User defined radio button as shown in Figure 2 55 Scroll down to t
47. 41 153 i4 1 727 743 ATL 22 UNS 152 TAM ae vod peg _ 2399 13 145 25 134 15 1 24 2 078 34 3 554 EL 1 711 1 5 winks ORS 35 010 855 91 251 185 243 ah 1 709 971 0480 31 LEER E 1 049 248 758 012 093 971 285 184 2 878 215 125 745 466 285 a EIE LETS 1 200187 id 414 343 OF 3d n 287 944 Ps ey cad 113 4 457 481 Lm yk at Pte 479 487 13 534 Ba El 18 852 1 578 Lond 12 8 4 2 308 1 258 10 578 18 29 iza 10 601 21 um 288 fa 1 27 148 262 257 PARTICULATE nun 2 48 Figure 2 48 Example 6 Select View Toolbars and PivotTable ELI D ICA C NEP 1 449 E D T238 ae 10 73 0 1 547 454 55 24 15 8 irs ia 2 785 0 415 Liki A ae Sm am Air Emissions Inventory for the Greater Metropolitan Region in New South
48. 42 055 457 463 2 13392 773 124 357 971 285 3524 55 38 9 54 478 241 151 547 644 185 373 19 288 uu 3 533 527 m 1 5 070 532 3 578 415 270 082 LIP R22 478 807 01 525 748 22 tirhan Total 287 012 9 4j afro pes Foe 03 amp 2 255 IBE 664 267 267 3 34 Table 1 2 Figure 2 47 Example 6 Navigate to Table 1 1 Worksheet 2 47 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook O Step 2 Select View Toolbars and PivotTable from the command menu as shown in Figure 2 48 The PivotTable toolbar will now appear D CARS HCA Del LUAR Oe OP PAETICULATT BATT NT UM INE in Nu DDE 125 524 ET UTR LESE mala yb 555 552 E 7 Tal Bis Lan TRA BA BSI TET 245 175 BY add 3 823 LLLI Thi 545 546 161 beg Fat S25 315 540 FERE ETE 2 553 207 AA 287 012 ha EEH 4 701 38 711 512 E RES 428 2 512 EN e aod Liti r amp 503 4 161 3 54 2172 21887 255 1 8507 TE 1 252 EXE 1 072 302 2 149 STE La 5 327 324 144 349 057 ANTI E 22 1
49. 5 4737131 i 05944 19 4494541 E32 3875 5801584 4595569 153396 2 426508 4 SHALI 9158 Ed 477562902 2850465 727953 1 0753122 i us MD 25 208 254 229 Tea 8 525i iT ieee MS Y 255474 JET7DA T 457460 20043 47 2170685 3855516 592559 IUE 152E 08 34844165 7373379 2155 04 wh abia 1279143 1826 393 144095905 irali 24 Ej 484 2979 4700 1335 350793276 M 1071244 GUAE EIS SURAT B 53958413 53034 07 Brasa Tb YMO 17 610121 205435 6210262 106086 2770676 2608437 6006 48 2624796 4278 967 PRES 1555372 MUAH 1889016 5073704 TAE SPP GU 12 1159590 2 E502 447 SHIHA 2205573 381 75 Figure 2 36 Example 3 Unformatted Pivot Table Report 2 36 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 13 Change the order of the regions with Sydney Newcastle Wollongong and Non Urban from first to last Move to the cell containing Sydney and right mouse button click Select Order and Move to Beginning from the drop down menus Select the order for all other regions using the same method as shown in Figure 2 37 IModule
50. 8 Figure 2 28 Example 3 Select No Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 6 Select the pivot table report Layout button as shown in Figure 2 29 Te Fw et Sen OxIDES OF HITREHZEN 214714467 dm OXIDES OF NITROGEN 51783 7547 2n PARTICULATE MATTER 1742 6907 279 2 PARTICULATE MATTER 10pm 75473453 PARTICLLATE MATTER 1m 848 4103 2281 2 PARTICULATE MATTER 2 5m 913 750471 20 PARTICLLATE MATTER ipm 1675 500404 zu PARTICULATE MATTER 2 5m 73486 7706 122 SULFUR DIOXIDE 360 4594 1285 SULFUR 703 6365 122 SULFUR 36376 4199 33 TOTAL VDCS 1119504 012 DES 2 TOTAL vOCS 10294 8078 D 20 m TOTAL VOCS 24746 L974 12290 Peers samt tp Pon ate report CARBON MONOXIDE 1B110083 37 AR 2003 Wellongeng Sydney On Rad Timm CARSON More StH 2814211 093 ZU 2001 Wollongong _ Sydney On Road gt LEAD COMPOUNDS 61 460912 2293 2003 Wollongong Wollongong On Road Ot LEAD amp COMPOUNDS 445 8223852 AFIM 2003 wWobongeng On Read OXIDE 5 OF NITROCEN 3105650 04 2002 Wollongong Sydney On Road OXIDES NITROGEN pps 2003 Wollongong _ Sydney On Road PARTICULATE MATTER 10pm 180448174 1 297 2007 Wolengeng Wolengehg On Agii PARTICLLATE MATTER 10pm 113030 4744 12291
51. Analysis Excel Workbook Instructions 2 Using the Excel Workbook After making these selections the Example 4 pivot chart report will look like that shown in Figure 2 44 Figure 2 44 Example 4 Pivot Chart Report You should note that Chart 7 1 is based on Table 7 1 so the information presented in the table will also be modified according to these selections Refer to Example 1 Section 2 4 1 which shows the accompanying changes to the table 2 44 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 6 2 Example 5 Interpreting Pivot Chart Reports Extra care should be exercised when interpreting the results of the pivot chart reports that present emissions as a proportion of the total Example 5 investigates the use of Chart 7 2 in the Excel workbook Chart 7 2 contains the proportion of annual emissions pivot chart report by LGA module and activity during 2003 in 96 Start by navigating to the Chart 7 2 worksheet using any of the methods described previously and make the selections from the drop down menus like Example 4 as shown in Figure 2 45 TOR Ad hart um ee UR Figure 2 45 Example 5 Navigate to Chart 7 2 Worksheet 2 45 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook You will notice the Ashfield Total is 10096 since only the Ashfield LGA has been selected as shown in Figure
52. E 2814211 093 LEAD amp COMPOUNDS 53 7461912 LEAD amp COMPOUNDS 345 8223852 NITROGEN 2106650 0 OXIDES OF NITROGEN 605120 336 PARTICULATE MATTER 1B044 B374 PARTICULATE MATTER 10pm 113030 4744 PARTICULATE MATTER 2 5ym 107779 07809 PARTICULATE MATTER 25m 17294 14719 SULFUR DLOXIDE 6331 02 SULFUR DIOXIDE BORE 0928 TOTAL VOCS 313043 8228 TOTAL vOCS 2073373 05 CARBON MONOXIDE 1997560 89 LEAD amp COMPOUNDS 51 63057851 OF HITROC N 251123 4581 PARTICULATE MATTER 11127 7472 PARTICULATE MATTER 5 10516 18079 OXIDE 06 TOTAL VOCS 220919 5227 CARBON MONOXIDE LEAD CONMPDUNDS 385 4156456 OXIDES OF NITROGEN 3445204 5628 PARTICULATE MATTER 106454 7145 PAKTICLLATE MATTER 2 5 102123 174 SULFUR 48207 0386 TOTAL VOCS 1852317 619 2 31 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 8 Double left mouse button click on the kg year Data field button and then select the Options button In the Summarise by menu select Sum and in the Show data as menu select Normal then select the OK button twice as shown in Figure 2 32 m ui 3 m LI Lake ii ete Figure 2 32 Example 3 Select PivotTable Field 2 32 Air Emissions Inventory for
53. GA Ashfield Module Name All Activity Q Substance TOTAL VOCS The steps required to do this are described below O Step 1 Select the LGA drop down menu uncheck the Show All box and check the Ashfield box as shown in Figure 2 42 1 pate Only Gm sem quet face pee ch 4 xx Bun FU kA TTER p TE FER a LLSD i JI SEI LUMINE EE LIB P IE EET IM I INL hori tp nti rh dt n SRF ae ep ss MA ye A A IU M RADAR Figure 2 42 Example 4 Select LGA Q Step 2 Select the Module Name drop down menu No selections are required because all are checked by default Step 3 Select the Activity drop down menu No selections are required because all are checked by default 2 42 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 4 Select the Substance drop down menu uncheck the Show All box and check the TOTAL VOCS box as shown in Figure 2 43 Drop Page Fields Here In Chart a Figure 2 43 Example 4 Select Substance 2 43 Emissions to Area Report
54. ICULATE MATTER 10ym 75673 453 12200 2002 Wolongong On Road Nobile PARTICULATE MATTER 1 948 4103 UR 2003 Wollongong On Road Mobile PARTICULATE MATTER 25m 913 7571 ANT 2003 Mon Urban On eas PARTICLLATO MATTER ipm 1675 504404 12281 2001 Wolke Sydney On Road PARTICULATE MATTER 2 5m 73486 73796 1Z2BE 2003 Wolonddy Wotongong On Road Mobile SULFUR DICXIDE 360 4594 12285 2003 Mon On Rea Noble SULFUR DDOXIDE 703 8345 12704 2003 n SULFUR DIOXIDE 36376 4199 uar 2003 Wollonddhy Sydney On Road Mobile TOTAL VOCS 1119504 012 3003 On Mole TOTAL 10294 8076 i 2003 Wolknddhy Men Urban On Road Mobile TOTAL VOCS 24746 174 12290 2003 mida 18110083 37 12291 2003 Willen 2814211 093 ud 2003 Wollongong 7119 61 7401912 2291 2003 Wolongore She ruber ropes lin tuu y rino bar rr dn D ORC D Tabla 1 2 med Eur 445 8223852 12294 5001 Wellenigeng 3 Ure DU yon um vr repart 3105450 2 2002 Wollongong O alf vno dick Tint umor pour crines Pia 605120 336 12296 2003 Wollongong Ted be separate _ LB044 B374 997 3003 unice TER 113030 4744 2003 Wollongo
55. LGA for Anns sons pet chart report LGA for puteo lg CUI E NEHME poliutarts dunng 2003 ky yaw Proporbon of annual prit chart report by LGA for dang cntena polutants during 2003 in kghyear pollutants during 2001 n year Proporbon of au smappona pivot Labs report by LGA and annua eons peyot chart report by LGA amd madale for crtana pollutants dunng 2000 in module fer cnteria pollutants duri 2003 im Annu emeppong poor report by LGA module and Annual peect chart report molada ad acbwity fer cetera pollutants dunng 2003 in kg year activity criteria pollutants during 2003 in Proporbon of annual pivot table report by LGA cna Prpporbon of annual emamons pot chart report by LGA module and Dor criberus pollutants dung SO m modulis and acit ty creda during Figure 2 13 Select Table 1 1 2 13 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook To go back to the Data Description worksheet left mouse button click the back web toolbar as shown in Figure 2 14 m parim x 3 T er a i i l tame CARBO Pie ngu PRATI
56. NDS 563 746 1917 LEAD amp COMPOUNDS 445 8223852 ON NITROCEN 7106650 04 NITROGEN 605129 336 PARTICULATE MATTER iym 1B044 B374 MATTER ipm 113030 4744 MATTER 2 107779 07H59 PARTICULATE MATTER 2 5 17294 14719 25331 2332 SULFUR Dco BUB 92H TOTAL VOCS 313433 8228 TOTAL VOCS 2073373 05 CARBON MONCXBDE 1997560 H8 LEAD amp COMPOUNDS _ B1 63057851 OXIDES OF RITROCEN 251123 4581 MEAT TER 1jam 11122 7472 PARTICLLATE MATTER Sgm 10516 18079 706 TOTAL VO S 2356919 5437 CARBON MONOXIDE 167197192 4 LEAD amp COMPOUND 305 2256856 NITROGEN 1445 54 AB PARTICULATE MATTER 1pm I106554 7155 PARTICULATE MATTER 2 5 1502123 174 SULFUR D COE IDE BIOT 30 TOTAL VOCS 1852317 619 J Figure 2 35 Example 3 Select Finish 2 35 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 12 The completed pivot table report which corresponds with Table 1 1 in the Excel workbook is shown in Figure 2 36 KETTE 14 15 1 L4 M H 9 RB WTE Fi Bench bunge 4 Aegon Module gt CARSON ILEAD X C ONDE PARTICULPARTICLA SULFUR vocis E Type i 113 072 303153153 25
57. OULATE HATTER E UU 27 48 874 2 705 009 2 131 541 e 2 07h St 41 iit Ph adi 314 2 353 21 354 131 18 853 T0475 79 33 137 1 712 135 1 754 287 1 Fee LEN ia ELI 2 552 053 a Ad rdi 555 532 498 4 4 057 24 010 30 I EET Bre 174 028 HET 87 231 3 as 99 82 343 188 282 4 5 B5 94 ae 153 94 9 978 1 727 953 1 501 758 Eii 4 847 229 EN LUE ERN TI Fr eF 1 8 112 1 mese 345 175 E zu e ams 87 239 3 583 81 32 3 3 031 304 177 04B amp E eee dad TAI 3 D FE 1555 17 2 15 2 Ofte Til so 109 az Fri RETE 53 Dm Hond Hebie 29 172 811 aa Set 118 9388 113 46 72 15 Wellengong 545 5h 16 12 345 258 3 049 5 amp R 2 3 iiti E Bom LE 737 526 a ED 14 82 718 13 45 AE ETET HRHD 174 387 70 T 1 Desunt Smee 13 828 733 2178 442 71 245 dis wig i FJ Irsa 25 571 221 34 544 184 285 243 9 533 Bat 2 876 411 d a Dr Lent 14 224 901 374 442 ias EE 287
58. Refer to Example 4 Section 2 6 1 which shows the accompanying changes to the chart You should exercise care when interpreting the results of the pivot table report In Example 1 Section 2 4 1 the value GMR Total is in fact the total for the selection being made If all LGAs are selected the TOTAL VOCS emissions would be 363 665 792 kg year as shown in Figure 2 21 rather than 1 241 381 kg year if Ashfield were selected as shown in Figure 2 20 2 20 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Tok sirrung pra rw pr hou peta pepebuetuen giri Chamas Storage Cheeta Sio Ege Figure 2 21 Example 1 Pivot Table Report with all LGAs Selected 2 21 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 4 2 Example 2 Interpreting Pivot Table Reports Extra care should be exercised when interpreting the results of the pivot table reports that present emissions as a proportion of the total Example 2 investigates the use of Table 7 2 in the Excel workbook Table 7 2 contains the proportion of annual emissions pivot table report by LGA module and activity during 2003 in 96 Start by navigating to the Table 7 2 worksheet using any of the methods described previously and make the selections from the drop down menus lik
59. Region in New South Wales Table of Contents Table of Contents 1 INTRODUCTION eK REL RENI CERE 1 1 2 USING THE EXCEL WORKBOOK PREMO E FE Xx EE 2 1 2 1 DOWNLOAD AND INSTALL WORKBOOK AND 5 5 22 111 11222 2 1 CVCAtCIDIRCCIONY UU IL UU ITE 2 1 2 1 2 Download Workbook and Instructions 2 2 2 2 2 2 222 2 2 2 22 2 2 2 1 3 HEXEFaCENVOFKDOONK ete dide 2 2 2 2 WSING THE WORKBOOK Anco diede 2 3 2 2 1 PERSE 2 3 252720 VENADIC MACOS TM 2 4 2 2 3 Macro Securty SUNOS d eto ipo nd dere tala UI DE EE 2 5 2 2 4 PasswoEld PIOEOCUIODU zi te Rapp Ea add 2 8 2219 SAVING CHange EIE 2 9 253 NAVIGATE THE VWVORKBOOK iade isti 2 11 2 3 1 Excel WorKDOOK SEFUCEUEG oue und eve edi 2 11 2 3 2 Using Built In Hyperlinks and 2 2 2 27270 0 42 2 2 2 4 2 12 2 9 9 USING Worksheet 2 16 2 4 USING AND INTERPRETING
60. Technical Report No 10 Air Emissions nventory for the Greater Metropolitan Region in New South Wales Emissions to Area Report Analysis Excel Workbook Instructions ACKNOWLEDGEMENTS This study was carried out with the assistance of organisations and individuals who should be recognised for their efforts Many thanks to the NSW Environmental Trust and Commonwealth Department of the Environment and Water Resources for providing the Department of Environment and Climate Change NSW DECC with funding to complete the study DECC would like to thank Mr Nick Agapides DECC for preparing these instructions and the accompanying Microsoft Excel 2003 workbooks Published by Department of Environment and Climate Change NSW 59 61 Goulburn Street PO Box A290 Sydney South 1232 Phone 02 9995 5000 switchboard Phone 131 555 environment information and publications requests Phone 1300 361 967 national parks information and publications requests Fax 02 9995 5999 TTY 02 9211 4723 Email info environment nsw gov au Website www environment nsw gov au In April 2007 the Department of Environment and Conservation NSW became known as the Department of Environment and Climate Change NSW This material may be reproduced in whole or in part provided the meaning is unchanged and the source is acknowledged ISBN 978 1 74122 834 2 DECC 2008 260 May 2008 Air Emissions Inventory for the Greater Metropolitan
61. acri Worker Qj een erage Deen ks 814168 1105 73008 fand Vias E open Pies Typi Cite 17401 2004 Zoe 8 Break IE Groep peed L2 is LJ been Fee 4 1 Grape i Fee anui amp Budori Lj casa J Chemery armare LJ Coe Dal furens amp 0 t Coie Lp iL a Derim here L2 Paara kane dass LL vef LESS Tp amp Ly arta Lj rd ites 9 Lj Fira oria t amp Pakam d ee LJ Pony Pu W LO eee a Dr Nu ue LT LIT amp L2 Facto L7 Bering CD eere a X eee oL OH nac a LJ amp LZ Pep ape i Soe Le ee E ji Figure 2 3 Open Workbook tr10aei08260cp xls 2 3 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 2 2 Enable Macros A Security Warning dialog box will now appear which allows you to select from the following options Disable Macros Enable Macros More Info Select Enable Macros as shown in Figure 2 4
62. e 2 18 fo a Vu o i a D i ul LEBEN ps uc 83 1 10 irer us 194 3 3383 99 3 Las xu LLLI t i mmm LFS m Foner Demeter Crestor ad Camere Graal ard Sang t d r t a 8 37 Table 7 UT UN E IM Figure 2 18 Example 1 Select LGA Step 2 Select the Module Name drop down menu No selections are required because all are checked by default O Step 3 Select the Activity drop down menu No selections are required because all are checked by default 2 18 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 4 Select the Substance drop down menu uncheck the Show All box and check the TOTAL VOCS box as shown in Figure 2 19 ps nli i Ce PT aU LX 1 1 in 8 11 329 19 hun a Hopia Excapt Pryce Homai 1 541 it eu Cir h _ ha 2 2 1 542 11 Pith a 15543 1 3 1 181 1 55 8 51
63. e Example 1 as shown in Figure 2 22 Escape De heg ET Total GAA Total EX 281 2012 Figure 2 22 Example 2 Navigate to Table 7 2 Worksheet 2 22 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook You will notice the Ashfield Total and GMR Total are both 100 since only the Ashfield LGA has been selected as shown in Figure 2 22 All other proportions shown in the pivot table report are proportions of annual emissions in Ashfield LGA only However if all LGAs are selected you will notice the Ashfield Total and GMR Total are 0 34 and 100 respectively as shown in Figure 2 23 All other proportions shown in the pivot table report are proportions of annual emissions in all LGAs i e GMR LDrermunfzesa end Gwe aed Bend regit ali ak ey mrt man A E E Cart Curt 2 Table 7 7 1 Figure 2 23 Example 2 Pivot Table Report with all LGAs Selected 2 23 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 5 Creating New Pivot Table Reports 2 5 1 Example 3 Creating Pivot Table Reports Example 3 describes the steps required to create a pivot table report Specifically
64. e that shown in Figure 2 40 Please refer to Help in the command menu for further assistance Cornero hue ni Of ised Mobi Total B Dumm TH Carrere 1 Goh fingd Ce tel SE ines coh Dormans Correr rad oaa Sydney Total Wollangeng Telal gt AIBAS JS tm Eei 83 144 83 291 345 997 8m 343 62 2182 iii 152 954 424 908 812 353 PETT XN aT Tr Lt Tg ET 3 3 b 555 123 la 1 EL 753 2 881471 457 238 5304 1 255 223 n 11 575 518 4 547 228 177 428 155 023 25 Eds f 2 512 0 9807 p 230 235 gt 449 727 351 9 3 54 37 725 1 442 05 30 2444 ld thes 15 50 981 71 244 nese E 35571 1221 1 887 3 844 2 8 12 572 830 5 372 425 1 279 24 1 3 ATA 1 867 14 187 002 942 706 202 25 169 006 7 amp 7 247 41 175 99 17 345 974 Bid 1 534 871 1 371 343 ILH 7 7 Mal TI aT 358 208 2 4271 zr 54 174
65. eal Other Chermcal Sores Ghe acirybes or coaira j tere a Er rug e Cine oce ian v datas aye beta Lr dae c lg Pint Metal plabng er coat works Cement of handig Other matal proc army Harardous iust group or group B maiba procesung Other paving of group A er Storage Other Chemical Storage Hararndous ndustnal group or group waste processmg evade Metal coat sors Other processing Concrete batchang OXIDE S HITRE QXIDES MITRI TILES OF HITRI OxIDES OF MITRE OF NITRE OXIDES OF HITRI OxIDES OF HITRE CXIDES OF MITRI PARTPCULATE PARTPCULATE PARTICLLATE PARTICULATE Acn mak 2 26 Figure 2 26 Example 3 Select Microsoft Office Excel list or database and PivotTable Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook O Step 4 Select the Range of data according to the prompt Where is the data that you want to use as shown in Figure 2 27 and then select
66. he end of the Chart type list and select Pivot Chart v1 for Charts 1 1 and 2 1 Pivot Chart v2 for Charts 1 2 and 2 2 Pivot Chart v3 for Charts 3 1 4 1 5 1 6 1 and 7 1 and Pivot Chart v4 for Charts 3 2 4 2 5 2 6 2 and 7 2 and then select the OK button as shown in Figure 2 56 Drop Fields Chart v2 gl Prat Chet v4 TOTAL VOCE pae stet D pute n s 1 1 4 2 1 fam BETTE B TOTAL VOCS Figure 2 55 Example 6 Select Custom Types and User defined 2 55 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Bx airs Figure 2 56 Example 6 Select Pivot Chart v1 2 56 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 9 You may wish to change the scale on the value axis To do this select the left vertical axis of the plot area right mouse button click and select Format Axis as shown in Figure 2 57 Select the Scale tab and under Value y axis scale and Auto uncheck the Major unit box and insert 5000000 and select the OK button as shown in Figure 2 58 Drop Page Fields Here TOTAL VOLS Figure 2 57 Example 6 Select Format Axis 2 57 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook
67. ilt in hyperlink An example selection for Table 1 1 is shown in Figure 2 13 Arrax emeppong to aas report by module LGA meson and acbwity for criteri pollutants dunng 2003 in Annual ameona preot table report by and module for prine eoim AM region for criteria patents during 2001 in and Charla firing 2003 in V criteria wig 3003 i criteria pollutants dunng 1001 in Proporbon of annual emanons gerat chart report Ey and Rer palatani during 2003 in modula for crtana poliutants during 2003 in Arai pret table report by regen module and Annual empons pret chart report by module aid fer poliutants dunng 2003 in bgyan sinet s ee Properten of annual amateni poet Fable report by rote and asin or cnbena pollutants dua T0903 mi emir preot table report by module and Annual prot chart report module amd for pollutants dunng 2003 in kg ye for criteria pollutants 2003 m ko yar Preperbon of annual amens pr t Latis report by GMH Preporben of annual chart report by module and simiy for pollutants dunn 2003 module and ackwity cribenis pollutacts dunng 2007 in Annas meppen preot pabis report by
68. ir nepm as variedO0503scaleplus pdf NEPC 2004 National Environment Protection Air Toxics Measure Environment Protection amp Heritage Council Adelaide Australia http www ephc gov au pdf Air Toxics FinalAirToxicsNEPM pdf PCO 1998 Protection of the Environment Operations General Regulation 1998 New South Wales Parliamentary Counsel s Office Sydney Australia http www legislation nsw gov au viewtop inforce subordleg 720 1998 first O N PCO 2005 Protection of the Environment Operations Clean Air Regulation 2002 New South Wales Parliamentary Counsel s Office Sydney Australia http www legislation nsw gov au viewtop inforce subordleg 642 2002 first O N 3 2
69. m 2 331 281 1 288 187 EE TUR 44 207 id 42 933 352 14 TED n 13 538 27 4 287 944 113144 FEET E 457 463 473 483 iagi 20 23 Eu Jim zl 813 10 8 1 233 11 818 23 7 35 mee D 27 2148 Per PARTICULATE ER i 0 53 Li 0 431 0 414 45 A aan i Figure 2 49 Example 6 Select Chart Wizard 2 49 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook Step 4 The completed pivot chart report which corresponds with Chart 1 1 Excel workbook is shown in Figure 2 50 QOO 000 8 8 sere day ay i 5 8 i 5 5 5 8 5 5 5 JM 3 3 3 Figure 2 50 Example 6 Pivot Chart Report with no Selections 2 50 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook Step 5 From the drop down menus in the pivot chart report make the following selections o Substance TOTAL VOCS o Region Sydney o Module Name Show
70. n New South Wales 2 Using the Excel Workbook Step 2 Select Data and PivotTable and PivotChart Report from the command menu as shown in Figure 2 25 Other Other crop Sydney Other crop processing 2003 Sydney Chemeal Other Chemical S10rae CARON E irdun 2003 Euri Syiney acirebes RSME Rd i Incite ADOS Metal pat or moris CARR E indiana 2003 Eum Sydney al mai CARION d 1 Industrial 2003 Auten Sydney Other processing CARBON MONOXB Industrusd 20035 Eun Beer nr aco prodaoctum 9 11 1 2003 Auburn Sydney Cement or Aarti CARON MON OXB E Indusina 200 dun sytney pre eee CAR Me 1 Industral 2003 Auburn Sydney Harandous industrial or group A waste generabon or storage CARBON MONCOXI 2003 Auburn Sydney Hir ardeus induatral group A or group processing CARDON MONOXB industrud 2003 Juin nr A waste generabon or LEAD A uae t Industrui 2003 Sydney Metal plabng coabng works LEAD COMPOUF Gil 1 Induatrial 2003 Auburn Sydney Chemical Storage Other Charrecal Storage LEAD COMPOUr 1 indu
71. ng Wollong 107779 0789 Ecl 2003 Sydney On Road PARTICULATE MATTER 2 Gum 17294 14719 MO 2003 Wellongens Wollongong On Kad Mobde ZULPUR DDOXIEE 58131 83132 2003 Wollongong Sydney 4 Maphia SULFUR DIOXID BOB 9928 ux 2003 Wollongong Sydney On Road TOTAL VOCS 313043 8228 2003 walangan Win hgeng Tota vOCS 207327314 122 2003 Woollahra Sydney n Road Mabie CARBON MONCOXZDE 1997560 H9 324 2003 Woollahra Sydney On Road hobis LEAD amp COMPOUNDS 51 61057851 17306 2001 Woollahra Sydney Chri esaet OxIDES OF NITROGEN 261125 4 1 12307 2003 Woollahra Sydney On Road PARTICULATE MATTER Im 11122 7472 1200 2003 Woolawa Sydney On Road Mob e PARTICULATE MATTER 2 5 10515 18079 E277 2001 amp ocllara iyiki Gmi Mobde Su Fui 459 706 17310 2003 Wocdlahra Sydney On Road TOTAL VOCS 236919 5237 12311 2003 Wyong Mon Urban On Road Mobis CARBON MONOXIDE 16719292 4 1212 2001 Wyeng Mon urban On eae LEAD amp COMPOUND H 2003 Wyong Mon Urban On Road Mote OXIDES OF NITROGEN 3445204 0B 13M 2003 Wyong Mon Liban On Road Mobis PARTICLLATE MATTER liken 106554 7155 17315 2003 Wrong Mon Ga Rosae PARTICULATE MATTER 2 102123 174 12116 2003 Wycng Urban On Road Mobis SULFUR DIOXIDE 4B207 038 2003 Wyong Mon Urban On Road Mobis TOTAL VOCS 1852317 619 2 2
72. nnual emissions pivot chart report by region and module during 2003 in kg year The steps required to do this are described below Step 1 Navigate to the Table 1 1 worksheet and select any cell within the pivot table report as shown in Figure 2 47 B 1 ELO Mast gros LAD aru Ni iic gl c BATION excu wu 1 252 EXE 2355 24 827 024 1 072 302 2 028 324 a2 ET EFE 119 2 149 370 1055174 Pet wee 112 LES LA mra PELLO 3 519 13 210 423 13 13 5 327 324 1 711 195 1 7548 T 1 178 0 38 714 grub iud 1 567 003 Led 114 piney Total 55 592 F 1 0s 35 010 555 EE TRA 13 5855 178 008 123 158 31231 44 237 ELMI 185 223 44 545 153 94 412 333 i 1 727 933 1 704 921 207 512 3 302 1582 87L 447 835 181 04 1 254 17 228 177 420 T 18 7 152 3 040 317 1 735415 10 67B ILOH 15 788 13 538 85 553 21 14 554 177 048 282 544 L 2 TASS 152 23 LETT 547 173 117 72 AM _ 19 172 831 3345 790 113 446 x 2t Wallangong 545 545 161 12 145 25 1 049 045 T aa 16 001 26 he Urban 148 37 428 11 554 14 625 758 12485 447 ir 27 315 540 322 70 1 6
73. ons 2 Using the Excel Workbook Step 14 Select the entire pivot table report and then select the custom number format created for the Excel workbook To do this select Format and Cells from the command menu as shown in Figure 2 38 EL l E a pe jar Eum aeg m BH x LE Sie M 4 5A IU L 1 1 1 1 1 CARP PARTICLE SULFUR E TOTAL WOCS i 441255 74 i 659945 EDS qM 906669 ies 426559 4 412351 1 80455 RTS TSS BOTE3Y2 GMM FRAT 40789 25203 8 i 3563002 B 22 81 2 3397352 730436 ann a 4 00 701 15004 1B 14423708 4149727 5 345474 1542054 acre S 20013097 2 mie 13829773 23 70085 STE 938555 IMG nal 48 26E 08 3425574 10 nme 180 u r amp 4744531 LN 1 2 08 4 ld t ME tii piscem TH 2373 GR GEGEGR 42938 9931259 TET 1122 1 5200871 ee ON 20425739 GTM SOS Fw Ter AEG 1075344 GN 2026242 Mug IN SEMNAT 144 T5148 530413 530 2 1578E 11 2340 010141 271438 BESTT 106596 Sree Perit THH 20 08 39
74. ri 2003 in Annual peect chart report LGA module and activity for citania pollutants during 2003 i bgyan Prpporbon gf annual emegmons pnt chart report by module and fer eribarus pellets dung 2003 n Figure 2 11 Select Data Description Worksheet 2 11 Emissions to Area Report Analysis Excel Workbook Instructions 2 Using the Excel Workbook 2 9 Using Built In Hyperlinks and Macros To assist in navigating the Excel workbook you may need to switch on the Web toolbar To switch on the Web toolbar select View Toolbars and Web from the command menu as shown in Figure 2 12 2 12 and iry for potutents during pect tates by LGA for pollutants d nne DOO bear Preporbon of anna pr ct Lace report by LGA for pollutants dune 2003 qm ti cntena pollutants dunnmg 2003 n n ol annul pivot tapis report by LGA Ch module for cribana 2003 m s Anma aminman pirot babe report by LGA module and actwity fer cetera pollutants dunng 2003 in kg year module and actity for criteria pollutants duri 2003 in Wo PTT fer critena pollutants during J00 in Annual prot chart report by GMA and modus Tor crite
75. ria 1003 n kg yii of annual perat chart report by CME and module for criteria pollutants during 2003 in Annual emisna pot chart report by regen module aed actrety for enfena pollutants dunng 2003 im kiyas Peoportion of annual chart report module and actmiby for cribsrus pollutants during 2093 in Annual aon chart report amd for criteria pollutants dung 2003 m ka year Proporbon of annual chart report by module and ackity or criberia pollutacts dunng 2001 in Annual Sen prot chart report LGA for Peis 2007 in yea Proportion of annual chart report by LGA for one pente Gunny 2093 in entina polutants 2001 in kg yuar annua eons peyot chart report LGA amd module fer cnteria pollutants during 2003 activity for pollutants during 2001 in kg year PrDporpon of annual emesmons pevot chart report by LOA module and acenity fer eribaria pollutants duning 2001 in Figure 2 12 Select Web Toolbar Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook To select a table left mouse button click the Data Description worksheet tab move to the cell required and left mouse button click the bu
76. rn Other matal procatsrvg oF hITRI 31 i 2003 E utum Beer por died prodacton GF HITRI 1 dredustru 2002 Hacrardous group or group B waste Oxi OF WITRE 20023 Sydney CFEIDES 3M fing ial 2003 Sydney somes previ 6 HITRE 35 5 obeuhusirud 2003 799 widustrial group A geraten ir SEO OXIDE OF RITRE x 1 Industrial 2003 Sydney Chemecal Storage Other Storage OXIDES OF MITRI 27 2003 Eum Hina arcup A or group B processing PAXRTPCLULATE 1 E 2003 Sydney lar a A PARTPCULATE 1 industrud 2003 Auburn Sydney processing PARTICULATE 4b i Indusirud ADOS Metal pling or moris Fi 1 2003 Aum Sydney of dibled produc ban PARTICULATE 8 Industria 2003 den DE 41 i inguin 2003 Eum Concrete ATE M do Vemm iii TEPA Figure 2 24 Example 3 Navigate to 2003 Annual Emissions Worksheet 2 24 Air Emissions Inventory for the Greater Metropolitan Region i
77. rt report by for criberus dunng 2003 in amp Annual emnpons prot chart report GMA and module Tor Ther poliutanbs dong Poo an eg year Proporbon of annual chart report by and module for cntena pollutants during 2003 in Annual prot chart report by repon module and aet trvity fer entera pollutants dann 2003 e bapan Preportion ef annual emnon phot chart report by regen PARUM MIRI INVE POCO cntena potutants 2003 n kg year Proporbon of annual emepons prect tache report by module cribena pollutants 2003 in emermons prot table report by repon module and activity fee peligrants during 2003 kegs yeur Preperben annual amanoni pret tabla report by ERN NM PU POR UNI LUN SUN Proportion of annual prof chart report by GMEL and acthnity cem TOUR S media and activity lor potters ding 2083 preot table report by LGA for cnitena pellutants dunes 2003 Praporbon of annual emssona prot tabla report by LOA for es report try LGA for cntena polkiaests dunng 2003 in kgs year Proporton of on chart report LGA Tor ribanu donng J097 ni c8
78. sis software package ul wo BUTS aa Greater Metropolitan Region atur a 1 E 3 8 E 48 A ui E z Minor Road E Railway Major River National Parks Estate B 1 E 20 Emissions Inventory Region E Kilcmetres 80 030 M x 360 370 380 390 40 4800 Figure 1 1 Definition of Greater Metropolitan Sydney Newcastle and Wollongong regions 1 2 Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 2 Using the Excel Workbook 2 USING THE EXCEL WORKBOOK This document contains instructions that explain the navigation and use of the accompanying Microsoft Excel 2003 workbooks While the instructions specifically relate to the Excel workbook tr10aei08260cp xls which is based on an Emissions to Area Report for criteria pollutants in the GMR during 2003 that has been extracted from the Emissions Data Management System EDMS v1 0 DECC 2008 the principles can easily be applied to the Excel workbooks for other air pollutants groups 2 1 Download and Install Workbook and Instructions 2 1 1 Create Directory Open Windows Explorer and create a new directory on your computer hard drive e g C nsw_gmr_aei_ 20031 by selecting File New and Folder from the command menu as shown in Figure 2 1 E ier bimesi Cuir id Meret Gotu
79. stered on road vehicles The pollutants inventoried include criteria pollutants specified in the Ambient Air Quality NEPM NEPC 2003 air toxics associated with the National Pollutant Inventory NPI NEPM NEPC 2000 and the Air Toxics NEPM NEPC 2004 and any other pollutants associated with state specific programs including Load Based Licensing Protection of the Environment Operations General Regulation 1998 PCO 1998 and Protection of the Environment Operations Clean Air Regulation 2002 PCO 2005 This document contains instructions that explain the navigation and use of the accompanying Microsoft Excel 2003 workbooks While the instructions specifically relate to the Excel workbook tr10aei08260cp xls which is based on an Emissions to Area Report for criteria pollutants in the GMR during 2003 that has been extracted from the Emissions Data Management System EDMS v1 0 DECC 2008 the principles can easily be applied to the Excel workbooks for other air pollutants groups 1 1 Emissions to Area Report Analysis Excel Workbook Instructions 1 Introduction The EDMS v1 0 is an overarching air emissions inventory database that links to individual source specific databases comprising all the data necessary to service policy and technical related queries The EDMS uses the Microsoft SQL Server 2005 relational database management system Microsoft 2008 which is a comprehensive integrated data management and analy
80. strul 2003 Auburn Sydney Cement or handing LEAD COMPDU t Industr _ 2003 Auburn Sydney Bemedcal waste nonerabon LEAD COMPOUF 2005 Sydney cer charted Hoho preda pan COMPRE E Indira 2003 Syinay paktan LEAD amp 2 20403 Auten Other matal procezsng LEAD 23 2003 Euburn Crushang gary of E irha 2003 Eutxurn ndustrtal group or group B wake LEAD amp CONPOUF n 1 Induri 2003 Auburn Sydney Other actwrbes pnnbng LEAD COMPOUF 1 dnehustruad 2003 Auburn Sydney Mk precedi LEAD COMPOU E Imira 2000 Ern Syiney Bscemaedac al CXIDES OF Fl 1 Industrial 2003 Aubum Sydney Metal plabng er cnatng works OXIDES OF HITRI D inch 20403 Suburi kra handima Xitel OS TAL I Industrial 2003 amp uturn Sydney Other matal procatsrvg QxIDES OF MITRI Industria 2003 charted produc bon TILES HITRI 1 dredustru 2002 Sydney Hacrardous group or group B mkita procesung Oxi OF WITRE 1 Industrial 2002 Auburn Sydney procesming OXIDES t Industrial 2003 Auburn Sydney Other activibes pring OMIDES OF HITRI 35 2003 auburn Sydney
81. t RODO Navigate to Chart 7 2 Pivot Chart Report with all LGAs Navigate to Table 1 1 Select View Toolbars and select Chart Wi Zardy PERRA CUI qua Ti Gur Seis eiua Pivot Chart Report with no 5 Pivot Chart Report with Selections SelecE Ghat t PY DO arna a a a Air Emissions Inventory for the Greater Metropolitan Region in New South Wales List of Figures Figure 2 53 Example 6 Select ee e eir dus Figure 2 54 Example 6 Enter Name and Description Figure 2 55 Example 6 Select Custom Types and User defined Figure 2 56 Example 6 Select Pivot Chart 1 Figure 2 57 Example 6 Select Format Figure 2 58 Example 6 Select Figure 2 59 Example 6 Formatted Pivot Chart Report Figure 2 60 Example 6 Hide PivotChart Field Buttons Figure 2 61 Example 6 Formatted Word Chart Air Emissions Inventory for the Greater Metropolitan Region in New South Wales 1
82. tep 3 Select the Security Level tab and Medium radio button as shown in Figure 2 7 rere T pet report and module amd pollutants 2001 im beg year Br fh of annual quot chart report by regen pollutants dunng 2003 in perg gh Orts macros irata t rur ofi Soa gee mau He Erud aurcs ber s Fun nap mcr an mmt eve of annual empong chart report by GME and cnteria pollutants during 2003 in br criteria pollutants duning 2003 n MNT PEL du NET qr da ortu ruined n pou aoe ail una po chart report module and pala ipe i p i aoe Proportion of annus pleat chart rapert LGA fur rib ra pollutants donndg 2003 m pollubanbs dunng 2997 in kg year Proporbon of annual emmma pot tabla report by LOA for pollutants dung 2003 e Annual efits prest Labia report by LGA and medalla Tor pollutants duri 2003 in phot taba report by LOA module aed Anual emend phot cut report Erg LGA ckraby for
83. tment of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr2aei0 7317 pdf DECC 2007d Air Emissions Inventory for the Greater Metropolitan Region in NSW Biogenic Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr3aei077 pdf DECC 2007e Air Emissions Inventory for the Greater Metropolitan Region in NSW Commercial Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr4aei078 pdf DECC 2007f Air Emissions Inventory for the Greater Metropolitan Region in NSW Domestic Commercial Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr5baei079 pdf DECC 20079 Air Emissions Inventory for the Greater Metropolitan Region in NSW Industrial Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr6aei0710 pdf DECC 2007h Air Emissions Inventory for the Greater Metropolitan Region in NSW Off Road Mobile Emissions Module Results Department of Environment and Climate Change NSW Sydney NSW 2000 Australia http www environment nsw gov au resources air tr7aei071
84. w South Wales 2 Using the Excel Workbook 2 4 5 Saving Changes If you wish to save any changes to the Excel workbook select File and Save As from the command menu as shown in Figure 2 9 use a different file name and select the Save button as shown in Figure 2 10 E T m Fu F X T Im A na EP oe and xd Anrax emesis 0 area report by module LA region and acbwaty for embera pollutants during 2003 in kgs year Annual preot table report by repon and module for cribena pollutants duria 2003 m karear ragsce for cntara poliutants duning 2003 in kg year Proporbon of annual emsaons pivot tabia report by repon and Chil 1 2 Proporbon of annual emmasons pivot chart report by regen For eritana pollutants during 2001 in and module Fe cribana during 2002 in aeons pot Fable report by GMA aed module for Annual empon prot chart report by and module Tor criteria pollutants duri 2003 in bayaa criteria pollutants duning 2001 in ky year Dioporten aoa armed report By CMR ans Prnporbon af annual amanoni peat chart report by CME and foe paitan during 2003 in amp module fer crtana peliutanks during 2003 w Arai prest table report by regen module and Anual peek chart report module and fer

Air Emissions Inventory for the Greater Metropolitan Region of NSW

Contents

Download Pdf Manuals

Related Search

Related Contents