Iowa Department of Natural Resources

Air Quality Bureau

7900 Hickman Road, Suite 1

Urbandale, Iowa 50322

(515) 242-5100

SPARS Web User Manual 101

For

AQB Viewers

Prepared by:

Rachel Quill

SPARS Administrator
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

1

CONTENTS

1.0 Definitions and Abbreviations  2

2.0 Introducing SPARS Web  4

3.0 Defining the SPARS Web AQB Viewer Role  9

4.0 Setting-up your computer to run SPARS Web  11

5.0 Running SPARS Web after installation  19

6.0 Changing a Password  23

7.0 Reviewing a completed Application or Inventory  24

8.0 SPARS Staff Contact Information  28
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

2

1.0 Definitions and Abbreviations

Appeon – 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. 

Application 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 distributes 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 Department 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 system 

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 identification, 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 electronic 

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 storing 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 February 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 submit 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 Management 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 

identification 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 Application 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 DataWindow
SPARS 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 emissions 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 fields 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 and 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 Interface
SPARS 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 electronically.

2. Create the following:

o Construction permit applications

o Title V operating permit applications

o Minor source emissions inventories, and

o Title V annual emissions inventories

3. Submit these applications and inventories to the Iowa DNR - Air Quality 

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 prompt confirmation that applications 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 rights 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 Viewer 

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 query 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 and 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 

Inventories

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 & Restrictions
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

11

4.0 Setting-up your computer to run 

SPARS Web 

- Facility Administrators and/or IT Personnel

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 

computer 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 Web are given below.

Platform Minimum Requirements to 

Run SPARS Web Enabled 

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 2007 (any 

edition), or

 Windows Vista (any edition)

 Software  Microsoft Internet Explorer 6.0 

SP1 or SP2, Internet Explorer 

7.0

 Sybase Appeon ActiveX 

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 client 

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. Click 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 General 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 the 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 Settings... 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 versions 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 through 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. Select 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 Security 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 that you have set. Additionally, these options may 
SPARS 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 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 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 correctly. 

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. Additionally, 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 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.
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 security 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 tab.

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 jscript.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 disabled 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 connect 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 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 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 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 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.
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 ensure 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 Shorcut.

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. Click 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 “always accept popups from this 

site”).

2. Open the SPARS website: http://aq48.dnraq.state.ia.us/spars This link 

will direct you to the web page where the Appeon log in resides: 

http://aq41.dnraq.state.ia.us/spars.htm

3. Use the Appeon log-in screen (shown below) to enter 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 Screen
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

20

4. A Welcome 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. The 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 the 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 timed-out at 2 hours from its start. 

Even though SPARS Web saves your work automatically, certain updates and 

changes do 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 Menu
SPARS 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 sometimes 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 receive.

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 locked
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

22

NOTE: In order to avoid the error 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 will 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 Web
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

23

6.0 Changing a Password

Passwords are automatically generated by the SPARS data management 

system and may be changed after accessing the 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 except 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 

Window
SPARS 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 desired 

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 

operating 

applications Click this button 

to find Part 2 

operating 

applications

Click this button 

to find Title V 

emissions 

inventories

Click this button 

to find Minor 

Source 

emissions 

inventories

Click this button 

to find

construction 

permit 

applications
SPARS Web User Manual 101 – AQB Viewers | Version 1.0

February 9, 2009

26

7.5. Click the Edit Application button. 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 document 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