# Iowa D epartment of Natural Resources Air Quality Bureau

7900 Hickman Road, Suite 1 Urbandale, Iowa 50322

(515) 242

- 5100



# SPARS W eb U ser Manual 101

For

AQB Viewers

Prepared by :

Rachel Quill

SPARS AdministratorSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 1 

##  CONTENTS 

1.0 Defin itions and Abbreviations                       

## 2

2 .0 Introducing SPARS Web                            

## 4

3 .0 Defining the SPARS Web AQB Viewer Role            

## 9

4 .0 Setting

- up your c omputer to run SPARS Web        

## 1 1

5 .0 Running SPARS Web after inst allation               

## 19

6 .0 Changing a Password                             

## 2 3

7 .0 Reviewing a c ompleted Application or Inventory      

## 2 4

8 .0 SPARS Staff Contact Information                  

## 2 8SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 2 

## 1.0 Definitions and Abbreviations

A ppeon

– A tool used to deploy entire PowerBuilder applications to the Web. Appeon consists of three parts: a developer, a server, and a server web component.



### A pplication Query Tool

– A DataWindow which is used to access, view, create, edit, or delete electronic documents found in SPARS.



### AQB

– Air Quality Bureau . This bureau administers DNR’s air quality

program.



### Client/server

- A description for applications that have a local (client) user interface but access data on a remote server. The application distribu tes the work between the local machine and the server, depending on the strengths

of the front

- end and back

- end products.



### HTML

– Hyper Text Markup Language . The authoring language used to

create documents on the World Wide Web.



### Iowa DNR

– Iowa Departmen t of Natural Resources . Government agency responsible for maintaining state parks and forests, protecting the environment, and managing energy, fish, wildlife, land, and water resources

in Iowa.



### Oracle Database

– It is a relational database management sy stem developed by Oracle Corporation.



### PDF

– Portable Document Format . A file format which captures formatting information from a variety of desktop publishing applications.



### PowerBuilder

– A computer application development system that includes

tools for drawing the user interface and reports and accessing database

content.



### Site Management

– A DataWindow used to access and edit the following facility’s information: name, location, mailing address, air quality classification, plant number, equipment ident ification, equipment description, name and addresses for its contacts, latitude, longitude, UTM coordinates.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 3 

### SPARS

– State Permitting and Air Reporting System . An Oracle database

with a PowerBuilder front

- end used to receive and store air quality electr onic

documents.



### SPARS Web

– An application that gives external users the ability to access SPARS data and submit electronic documents to the AQB using the internet.



### TIFF

– Tagged Image File Format . One of the most widely supported file

formats for stori ng bit

- mapped images on personal computers.



### UTM

– Universal Transverse Mercator . The UTM coordinate system is a grid

- based method of specifying locations on the surface of the Earth.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 4 

## 2 .0 Introducing SPARS Web

2

. 1 What is SPARS Web?

The Iowa DNR ’s State Permitting and Air Reporting System (SPARS) is composed of an Oracle database and a PowerBuilder interface to access the contents of this database. It was first developed as a multi

- user client/server database available only to AQB staff.

In Fe bruary 2006, the Appeon system, which includes a developer, a server, and a server web component, was used to deploy the PowerBuilder interface to the Web, thus making SPARS web

- enabled. This gave facilities access to their own data and the ability to sub mit electronic applications and inventories to the AQB through the Web.

PowerBuilder has a native data

- handling object called a DataWindow, which can be used to create, edit, and display data from a database. SPARS has two main DataWindows: Site Manageme nt and the Application Query Tool

.

The Site Management DataWindow (see Figure 2.1) allows the user to access information such as facility name, AQB plant number, SPARS site ID, location, address, responsible official contact information, equipment

ident ification and description, latitude, longitude, UTM coordinates, etc. It also allows the user to edit certain information, such us description and specification for emission units, emission points, control equipment, and monitoring equipment.

The Applica tion Query Tool DataWindow (see Figure 2.2) allows the user to access, view, create, edit, review, and delete electronic applications and inventories. It also gives users the ability to submit these documents to the AQB when following the SPARS submittal process.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 5 Figure 2.1

– Site Management

DataWindow

Figure 2.2

– Application Query Tool DataWindowSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 6 An additional SPARS component that might be useful to SPARS users is the Report Interface. This is another SPARS DataWindow that allows the creation of several reports depending on the category selected (see Figure

2 .3).

1. Equipment Facility

– This report lists all the emission points, emission units, monitoring equipment, and control equipment for a facility’s operating application, minor source inventory, or construction application.

2. Actual Emissions

– This report sums the actual e missions from Form 4.0 of the facility’s operating application for the selected year.

3. Potential Emissions

– This report sums the potential emissions from Form 3.0 of the facility’s operating application.

4. Completeness Report

– This report lists missing fi elds for the facility’s minor source emissions inventory.

5. Facility

- Wide Air Emission Summary

– This report lists the potential

and actual emissions from INV

- 3 and INV

- 4 of the facility’s minor source emissions inventory by emission year and by criteria an d hazardous pollutants.

6. Major Actual Emissions

– This report sums the actual emissions from Form 4.0 of the facility’s Title V emissions inventory for the selected year.

7. Major Title V Emissions Inventory

– This report sums the actual

emissions from Form 5.0 of the facility’s Title V emissions inventory for the selected year.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 7 Figure 2 .3

– Report InterfaceSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 8 

## 2

. 2 What does SPARS Web do?

The Iowa DNR’s State Permitting and Air Reporting System (SPARS) Web application allows facilities to :

1. Access permit and emissions data electron ically.

2 . Create the following:

o C onstruction permit applications

o Title V operating permit applications

o M inor source emission s inventories, and

o Title V annual emission s inventories

3 . Submit these applications and inventories to the Iowa DNR

- Air Quali ty

Bureau (AQB) at any time.

4 . Reuse existing electronic information to create new applications or modify current applications.

5. Attach supporting documentation in Excel, PDF, Word, TIF, or HTML

formats.

6

. Receive p rompt confirmation that applicatio ns and inventories have been received by the AQB.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 9 

## 3 .0 Defining the SPARS Web AQB

Viewer Role

There are four SPARS Web AQB roles: AQB Administrator, AQB Reviewer, AQB County Reviewer, and AQB Viewer. Figure 3.1 shows the righ ts and restrictions of each SPARS Web AQB User Role.



### AQB Viewer

Description: This account is created by an AQB Administrator and it is assigned to those users who will not make changes to any SPARS documents and are not members of any AQB group. AQB Vie wer accounts can only be assigned to DNR employees from other bureaus or to EPA employees, but need to have access to air quality information

stored in SPARS. Access Rights:

o Able to access all facilities in Iowa.

o Able to change his/her password.

o Able to q uery for information using SPARS reports.

Access Restrictions:

o Cannot create, edit, or delete applications or inventories.

o Cannot reset a lost or forgotten password.

o Cannot delete or edit his/her SPARS account.

o Cannot freely navigate through applications a nd inventories submitted to the AQB through SPARS. However, the information in these is easily retrieved through the print

- preview feature of SPARS Web (see Chapter 7.0).

o Cannot delete or edit applications and inventories previously submitted to the AQB.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 10 

### SPARS Web AQB User Roles Rights & Restrictions

AQB User Role Access to

all Iowa AQ

facilities Create,

Edit, Delete

User

Accounts Navigate

through

inventories

and applications Edit

Applications

and

Inventories Delete

Applications

and

Inventorie s

AQB

Administrator Y Y Y Y Y

AQB Reviewer Y N Y Y Y

AQB County

Reviewer N N Y Y Y

AQB Viewer Y N N N N

Figure 3 .1

– SPARS Web AQB User Roles

– Rights & RestrictionsSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 11 

## 4 .0 Setting

- up your c omputer to run
SPARS Web

- Facility Administrator s and/or IT P ersonnel

Before running the SPARS Web application in your computer for the first

time , please follow the instructions described in this document to adjust your computer and internet settings. This will allow SPARS Web to run in your
comput er by simply clicking on the appropriate link and logging on.



### 4 .1 Hardware & Software Requirements

The minimum and optimal requirements for hardware and software used to

run SPARS W eb are given below.

Platform Minimum Requirements to

Run SPARS Web Enabl ed Application Recommended Requirements

to Run SPARS Web Enabled Application

 CPU  Pentium

- class processor

– 1

GHz or faster  Pentium

- class processor

– 1.8

GHz or faster

 Memory  128 MB  512 MB

 Disk  10 GB  20 GB

 Network  56k dial

- up connection to

Internet  Broadband connection to

Internet
 Operating System  Windows 2000 (any edition),

or
 Windows XP (any edition),

 Windows 2003 (any edition)

,  Windows 2007 (any edition),

or
 Windows Vista (any edition)  Windows 2000 (any edition),

or  Windows XP (any edition),
 Windows 2003 (any edition)
 Windows 200 7 (any edition) , or  Windows Vista (any edition)

 Software  Microsoft Internet Explorer 6.0

SP1 or SP2, Internet Explorer

7.0

 Sybase Appeon Act iveX Accelerator (automatically

downloaded to the client browser when running the

SPARS web enabled application)  Microsoft Internet Explorer 6.0 SP1 or SP2, Internet Explorer 7.0

 Sybase Appeon ActiveX Accelerator (automatically

downloaded to the c lient browser when running the

SPARS web enabled application)

 Adobe Acrobat Reader 6.0 (for viewing printed PDF DataWindows or reports)SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 12 

### 4 .2 Adjust Desktop Display Settings

Your desktop display should be set to 1024 X 768

.

If your display is not set to 1024 X 768 , follow these instructions:

1. Right

- click inside the Windows desktop and select Properties

. 2. Select the Settings tab.

3. Note your current Screen resolution in case you need to reset it later.

4. More the Screen resolution slide bar to 1024 X 768

. 5. Cl ick Apply . The screen will be reset.

6. Click Yes

. 7. Click OK

.



### 4

. 3 Adjust Temporary Internet Files and Caching

 Delete all temporary files stored in the Internet Explorer cache:

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Ge neral tab.

4. Depending on the Internet Explorer that you have, do the following:

o Internet Explorer 6.0 :

Click Delete Files... in the Temporary Internet

Files section.

o Internet Explorer 7.0 :

Click Delete... in the Browsing History section.

Click Delete Files... in the Temporary Internet

Files section.

5. Click OK

.

 Verify settings for temporary internet files within Internet Explorer and set up file caching:

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Advanced tab. Scroll down to th e Security section

and make sure that Empty Temporary Internet Files folder

when browser is closed option is NOT checked.

4. Select the General tab.

5. Depending on the Internet Explorer version that you have, do the following:SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 13 o Internet Explorer 6.0 :

Click Se ttings... in the Temporary Internet Files

section.

Select the Automatically button to check for newer versions of stored pages.

o Internet Explorer 7.0 :

Click Settings... in the Browsing History section.

Select the Automatically button to check for

newer version s of stored pages.

6. Verify that the Amount of Disk Space to Use is set to no less

than 200MB.

7. Click OK

.



### 4 .4 If Running SPARS Web via a Proxy Server

If you are running SPARS Web through a Proxy Server, you must ensure that the Advanced Setting HTTP 1.1 th rough proxy connections remains

enabled.

NOTE: These instructions are only necessary if a Proxy Server is used

.

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Advanced tab.

4. Scroll down to the HTTP 1.1 Settings section.

5. Sel ect Use HTTP 1.1 if it is not currently selected.

6. Select Use HTTP 1.1 through proxy connections if it is not currently selected.

7. Click Apply and then OK

.



### 4 .5 Adjust Internet Security Settings

In order for SPARS Web to be set up on your machine, you must make sure that your internet security is set correctly. SPARS Web uses a version of Appeon (5.0 Xcelerator) and other functions that require specific security settings.

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Securit y tab.

4. In the Web Content Zone area, select Internet

. 5. Click Custom Level... at the bottom of the box.

6. The following settings must be in place to set up SPARS Web. Your computer might already have these selections in place, depending on the security level th at you have set. Additionally, these options maySPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 14 or may not be available to you depending on the Internet Explorer version or Service Pack that you have:

o Download signed ActiveX controls

– select Enable

.

o Download unsigned ActiveX controls

– select Prompt

.

o Initialize and script ActiveX controls not marked as safe

– select Prompt

.

o Run ActiveX controls and plug

- ins

– select Enable

.

o Script ActiveX controls marked safe for scripting

– select

Enable

.

o File download

– select Enable

.

o Active scripting

– select Enabl e

.

o Internet Explorer 6.0 :

Allow paste operations via script

– select Enable

. Allow active content to run in files on My Computer

– select Enable

.

o Internet Explorer 7.0 :

Allow websites to prompt for information using scripted

windows

– select Enable

.

7. Clic k OK when the new security settings have been selected. Some of these settings will be re

- adjusted after Appeon is installed in your
computer.



### 4 .6 Adjust Trusted Sites Security Settings

You must make sure that your “trusted sites” security is set correc tly.

SPARS Web uses a version of Appeon (5.0 Xcelerator) and other functions that require specific “trusted sites” security settings.

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Security tab.

4. In the Web Content Zone area , select Trusted Sites

. 5. Click Custom Level... at the bottom of the box.

6. If available, make sure that the following settings are selected. Your computer might already have these selections in place, depending on the security level that you have set. Additio nally, these options may or may not be available to you depending on the Internet Explorer version or Service Pack that you have:

o Download signed ActiveX controls

– select Enable

.

o Download unsigned ActiveX controls

– select Prompt

.

o Initialize and script Ac tiveX controls not marked as safe

– select Prompt

.

o Run ActiveX controls and plug

- ins

– select Enable

.

o Script ActiveX controls marked safe for scripting

– select

Enable

.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 15 o File download

– select Enable

.

o Active scripting

– select Enable

.

o Internet Explorer 6.0 :

Allow paste operations via script

– select Enable

. Allow active content to run in files on My Computer

– select Enable

.

o Internet Explorer 7.0 :

Allow websites to prompt for information using scripted

windows

– select Enable

.

7. Click OK when the new secur ity settings have been selected. Some of these settings will be re

- adjusted after Appeon is installed in your
computer.



### 4 .7 Adjust Additional Trusted Sites Settings

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Security t ab.

4. In the Web Content Zone area, select Trusted Sites

. 5. Click the Sites button.

6. Make sure that the following web addresses are included in your

Websites box:

o http://*.aq41.dnraq.state.ia.us

o http://aq41.dnraq.state.ia.us

o http://aq48.dnraq.state.ia.us/spars

7. If they are not, you must add them to your Trusted Sites:

o First, make sure that Require server verification (https ) for

all sites in this zone is not checked. Uncheck this field if

necessary.

o For each of the above web addresses, do the following (one address at a time):

Type the web address in Add this website to the zone

field.

Click the Add button.

8. When all the web addresses have added, click the Close button.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 16 

### 4 .8 Check Version of Jscript.dll

You must make sure that the version of jscript.dll on your PC is the correct

version.

1. In Windows Explorer open the \ WINNT \ system 32 folder.

2. Scroll down and locate the j script.dll file.

3. Right

- click on this file name and select Properties

. 4. Select the Version tab. The version must be at least 5.6.x.xxxx . If

the version number is older than 5.6.x.xxxx (a smaller number),

download the newer version at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c717d94

3

- 7e4b

- 4622

- 86eb

- 95a22b832caa&DisplayLang=en



### 4 .9 Disable Internet Anti

- popup/Anti

- Virus Software

In order to have Appeon correctly installed in your computer, anti

- popup software must be disabled. After installation, the anti

- popup software can be enabled. Additionally, it is recommended that your anti

- virus software be temporarily disable d until you have completed the SPARS installation. Once you have completed the installation, the anti

- virus software may be enabled.



### 4 .10 Install Appeon

1. Open Internet Explorer.

2. On the web browser, type this address: http://aq48.dnraq.state.ia.us/spars

3. If the download does not automatically start, you should be directed to a page to manually install the application. You may need administrator rights on your computer to install the Java applet

needed to co nnect you to SPARS Web.

4. When prompted, choose the following:

o Install ActiveX

o Trust this site

o Always allow popups from this site

5. When the installation is complete, close Internet Explorer.



### 4 .11 Re

- adjust Internet Security Settings

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Security tab.

4. In the Web Content Zone area, select Internet

. 5. Click Custom Level... at the bottom of the box.

6. Make the following security setting selections:SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 17 o Download signed ActiveX controls

– select Promp t

.

o Download unsigned ActiveX controls

– select Disable

.

o Initialize and script ActiveX controls not marked as safe

– select

Disable

.

o Run ActiveX controls and plug

- ins

– select Enable

.

o Script ActiveX controls marked safe for scripting

– select

Enable

.

o File d ownload

– select Enable

.

o Active scripting

– select Enable

.

o Internet Explorer 6.0 :

Allow paste operations via script

– select Enable

. Allow active content to run in files on My Computer

– select Enable

.

o Internet Explorer 7.0 :

Allow websites to prompt for i nformation using scripted

windows

– select Enable

.

7. Click OK when the new security settings have been selected and then

click Yes to accept the new settings.



### 4 .12 Re

- adjust Trusted Site Security Settings

1. Open Internet Explorer.

2. Select Internet Options on the Tools menu. 3. Select the Security tab.

4. In the Web Content Zone area, select Trusted Sites

. 5. Click Custom Level... at the bottom of the box.

6. Make the following security setting selections:

o Download signed ActiveX controls

– select Prompt

.

o Download unsigned ActiveX controls

– select Disable

.

o Initialize and script ActiveX controls not marked as safe

– select

Disable

.

o Run ActiveX controls and plug

- ins

– select Enable

.

o Script ActiveX controls marked safe for scripting

– select

Enable

.

o File download

– select Enab le

.

o Active scripting

– select Enable

.

o Internet Explorer 6.0 :

Allow paste operations via script

– select Enable

. Allow active content to run in files on My Computer

– select Enable

.

o Internet Explorer 7.0 :

Allow websites to prompt for information using scri pted

windows

– select Enable

.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 18 7. Click OK when the new security settings have been selected and then

click Yes to accept the new settings.

8. Close Internet Explorer.



### 4 .13 Create a SPARS Web shortcut

Creating a SPARS Web shortcut using the correct URL will e nsure your access to the Appeon logging screen regardless any SPARS upgrades installed by the

DNR.

1. Right

- click inside the Windows desktop and select New

. 2. Select S horcut

. 3. Inside the text box, type the following location: http://aq48.dnraq.state.ia.us/spars

4. Click Next

. 5. Inside the text box, type: SPARS Web

6. C lick Finish

7. Next time you need to access SPARS Web, double

- click on this

shortcut.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 19 

## 5 .0 Running SPARS Web after

Installation

5 .1 Accessing SPARS Web

1. Open Internet Explorer. Make sure any anti

- popup software is disabled while working in SPARS Web. This will allow you to see all the screens

used in SPARS Web. (You do not need to worry about this if during the Appeon installation, you chose to “alw ays accept popups from this

site ” ).

2. Open the SPARS website: http://aq48.dnraq.state.ia.us/spars This link will direct you to the w eb page where the Appeon log in resides: http://aq4 1 .dnraq.state.ia.us/spars .htm

3. Use the Appeon log

- in screen ( shown below ) to e nter the User Name and Password given to you by the AQB, or by a Facility Administrator,

or a Facility Super User

.

Figure 5.1

– Appeon Log

- In ScreenSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 20 4. A Wel come Window will appear. Close this window. If you do not want this window to appear every time you open SPARS Web, unclick the Show welcome at startup box.

5. T he following menu becomes available :

6. You are now ready to work in SPARS Web.



### 5

. 2 Working in SPARS Web

.... Issues to Consider

5 .2.1 SPARS Web Speed

Obviously, SPARS Web speed will not be the same at every facility. The following factors influence the speed at which SPARS Web will work :

 Connection type and speed (dial up, DSL, Cable, Network)

.  Firewall and security protocols (blocking ports or IP addresses, scanning data packets, restricting data download/upload speeds, either by Facility, Corporate, or Internet Service Provider)

.  Network issues including, but not limited to;

o Traffic load at th e Facility, ICN (state network), or IDNR

o Routing of data between the Facility and Corporate headquarters in other states/regions and IDNR

 Client workstation setup for computer processor speed, amount of memory, cache size, programs running, virus scanning during use of SPARS application and other items which degrade computer performance.



### 5 .2. 2 SPARS Web Time

- Out

A SPARS Web session is time d

- out at 2 hours from its start

.

Even though SPARS Web saves your work automatically, certain updates and changes d o not take place unless you save them manually. Therefore, try to save your work regularly to avoid losing information.

After being timed

- out, you can log right back in to SPARS Web

. Figure 5. 2

– SPARS Web MenuSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 21 

### 5 .2. 3 Viewing Submitted Applications/Inventories

SPARS Web AQB Viewers cannot freely navigate through applications and

inventories stored in SPARS.

See Chapter 7.0 to learn the way to view information on these applications

and inventories.



### 5 .2. 4 Handling Database Messages

As you work with SPARS Web, you will find that som etimes the database will give you messages in response to what you have or have not done.

There are two types of database messages: (1) database errors and (2) warning errors ; however, database errors are the only database messages that AQB Viewers will r eceive.

Database Errors . These types of messages are displayed when a certain

action has:

 Locked one or more of the database tables

 Violated one or more of the database business rules Figure 5 .3

– Database Error Example 1:

Tables are lockedSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 22 NOTE : In order to avoid the er ror shown in Figure 5 .4 , the print

- preview

feature of SPARS must be used to see the information contained in an application or inventory already submitted to the AQB.

In either case, the immediate course of action is to use the Task Manager to

close SPARS Web (see Figure 5 .5 ). NOTE : In order to view the Task Manager window, press Ctrl

- Alt

- Delete

.

In addition to closing SPARS Web, you should call us to let us know that a database error occurred while you were working on the SPARS application.

We wil l need to know what you were doing when the error happened. We will then guide you on what you need to do next. Figure 5.4

– Database Error Example 2: Incorrect Access of a Submitted Inventory

Figure 5.5

– Closing

SPARS WebSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 23 

## 6 .0 Changing a Password

Passwords a re automatically generated by the SPARS data management system and may be changed after accessing t he SPARS Web application. When an AQB Viewer logs into the SPARS Web application, the following window opens:

To change a password, you must choose the Change Password option

.

Figure 6 .2

– Change Password Window

In the Change Password window, enter your current (“old”) password, and then enter twice the new password. Click OK to set the new password. Click

Cancel to exit without changing the password. Passwords must consist of a minimum of six characters. No special characters are allowed e xcept for a single underscore; the underscore cannot be the first character in the password. Figure 6.1

– AQB Viewers have the option of changing their password.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 24 

## 7 .0 Reviewing a completed Application or Inventory before Submittal

7 .1 After logging in SPARS Web (see Section 5 .0), click File , select Open and

then click Query Tool

.

7 .2 Selecting the Query Tool opens the Application Query Tool window: Figure 7 .1

– Selecting the Query Tool

Figure 7 .2

– Application Query Tool

WindowSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 25 7 .3 Find the facility by entering its name in the Site Name field (or enter its

ID in the Site ID field); then select the appropriate button to find the desire d

document (see Figure 7 .3)

.

Figure 7

. 3

– Finding applications and inventories already created in SPARS Web.

7 .4. Highlight the application or inventory that you wish to review (see Figure

7 .4)

. Click this

button to find

Part 1

o perating

a pplication s Click this button

to find Part 2

o perating

a pplication s Click this button

to find Title V

e missions

i nventor ies

Click this button

to find Minor

Source

e missions

i nventor ies Click this button

to find

c onstruction

p ermit

a pplication sSPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 26 7 .5. Click the Edit Application b utton. Alternatively, you may double

- click the left side of your mouse to bring up the highlighted application (see Figure

7

. 5 )

.

Figure 7

. 5

– Part 1 Operating Permit Application.

Figure 7 .4

– Choosing the documen t wished to be reviewed.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 27 7 .6. Click on the print

- preview icon as shown in Figure 7 .6.



### 7

. 7 . The following window opens:

Figure 7

. 7

– Print

- preview of a Part 1 Operating Permit Application.

7

. 8 You are now able to print the document to review its contents. This procedure applies to all applications and inventories created in SPARS Web. Figure 7 .6

– Print

- Preview Icon.SPARS Web User Manual 101

– AQB Viewers | Version 1. 0 February 9, 2009 28 

## 8 .0 SPARS Staff Contact Information

 Rachel Quill, SPARS Administrator

515

- 281

- 8983 Rachel.Quill@dnr.iowa.gov

 Jason Dowie

, SPARS Helpdesk Technician

515

- 281

- 8568 Jason.Dowie@dnr.iowa.gov

 Marguerite Fitchpatric, Information Technology Specialist

515

- 242

- 5105 Marguerite.Fitchpatric@dnr.iowa.gov

 Jason Marcel, Emissions Inventory & Support Supervisor

515

- 281

- 4873 Jason.Marcel@dnr.iowa.gov