1 / 105

Air Quality System Precision and Accuracy Data Transaction Generator (AQSP&A)

Air Quality System Precision and Accuracy Data Transaction Generator (AQSP&A). Training Session. Overview of AQSP&A. Background Setting up the application Functionality Questions. Background. How does AQSP&A fit in with AQS ? Hardware and Operating Systems. Background.

reece-walker
Download Presentation

Air Quality System Precision and Accuracy Data Transaction Generator (AQSP&A)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Air Quality System Precision and Accuracy Data Transaction Generator (AQSP&A) Training Session

  2. Overview of AQSP&A Background Setting up the application Functionality Questions

  3. Background • How does AQSP&A fit in with AQS? • Hardware and Operating Systems

  4. Background • What do RA and RP Transactions look like? RA|I|30|013|0001|42101|1|1|1|007|093|||20060401|AUDIT AND CERT BY RO|LAMINAR FLOW ELEMENT|ANALYTICAL|PE||||5|5|18|18|37|37||||| This transaction wraps around for display only… it is one continuous text line when submitted to AQS Load. RP|I|30|013|0001|42101|1|1|1|007|093|20060401|5||5|||

  5. Background (cont.) • What do RA and RP Transactions look like in XML format?

  6. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region

  7. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region

  8. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region www.epa.gov/ttn/airs/airsaqs/padata/padata.htm

  9. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region

  10. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region

  11. Setting Up AQSP&A • Note about Excel 2007 compatibility • The AQSP&A files are saved as Microsoft Office • Excel 97-2003 workbooks (.xls) • When opening with Excel 2007 • you will see the following warning: • Select Yes • The workbook will function properly

  12. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Verify Excel Security settings • Enable macros in Excel 2003 • Security setting = Medium • Check Trust Center in Excel 2007 • Enable Add-ins • Enable Macros

  13. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Verify Excel Security settings • Enable macros in Excel 2003 • Security setting = Medium

  14. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Verify Excel Security settings • Enable macros in Excel 2003 • Security setting = Medium

  15. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Check Trust Center in Excel 2007 • Enable Add-ins

  16. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Check Trust Center in Excel 2007 • Enable Macros

  17. Setting Up AQSP&A • Download Excel file to your PC • One file for each EPA Region • Enable Add-ins in Excel 2007 • From Trust Center • With notification, you will see: • Click Options and Enable

  18. Setting Up AQSP&A Download Excel file to your PC Enable macros in Excel • Set up screening group in AQSP&A

  19. Setting Up AQSP&A Download Excel file to your PC Enable macros in Excel • Set up screening group in AQSP&A

  20. Setting Up AQSP&A • Download Excel file to your PC • Enable macros in Excel • Set up screening group in AQSP&A

  21. Setting Up AQSP&A Download Excel file to your PC Enable macros in Excel • Set up screening group in AQSP&A

  22. Setting Up AQSP&A Download Excel file to your PC Enable macros in Excel • Set up screening group in AQSP&A

  23. AQSP&A Functionality • Workbook Structure • 7 Worksheets • 1 “Help” sheet • One sheet for each transaction type (RA,RP) • 1 sheet stores coding manual information • 3 sheets hold look-up data for codes and data validation

  24. AQSP&A Functionality • Workbook Structure • 7 Worksheets • 1 “Help” sheet • One sheet for each transaction type (RA,RP) • 1 sheet stores coding manual information • 3 sheets hold look-up data for codes and data validation

  25. AQSP&A Functionality • Workbook Structure • 1 “Help” sheet

  26. AQSP&A Functionality • Workbook Structure – Excel 2003 • Additional Toolbar Commands • Look up Monitor • Generate Transactions • Add New Monitor / Method • Create Report • Tribal Mode (On/Off)

  27. AQSP&A Functionality • Workbook Structure – Excel 2007 • Additional Toolbar Commands • Look up Monitor • Generate Transactions • Add New Monitor / Method • Create Report • Tribal Mode (On/Off)

  28. Using the 2 Transaction Worksheets • Column headings • Drop down lists • Look Up Monitor button • Right-click for • code values • date picker • copy monitor id fields function • Data validations

  29. Using the 2 Transaction Worksheets • Column Headings

  30. Using the 2 Transaction Worksheets • Column Headings • Drop down lists

  31. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button Selected cell in “blank” Monitor Id

  32. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button

  33. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button

  34. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values

  35. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values

  36. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values

  37. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values

  38. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values

  39. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for date-picker

  40. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click to copy monitor id fields

  41. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click to copy monitor id fields

  42. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click to lookup audit level number

  43. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values • Data validations

  44. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values • Data validations

  45. Using the 2 Transaction Worksheets • Column Headings • Drop down lists • Look Up Monitor button • Right-click for code values • Data validations

  46. New Toolbar Commands • Look up Monitor • Generate Transactions • Add New Monitor / Method • Create Report • Tribal Mode (On/Off)

  47. New Toolbar Commands • Look up Monitor • We discussed the use of this command a few slides ago

  48. New Toolbar Commands • Look up Monitor • Generate Transactions

  49. New Toolbar Commands • Look up Monitor • Generate Transactions

  50. New Toolbar Commands • Look up Monitor • Generate Transactions • Enter all of the data you want to update to AQS. • Each row is one transaction.

More Related