2023 Research in the Capitol

Development of a Water Quality Index Calculation Tool using Excel

Presentation Type

Open Access Poster Presentation

Keywords

Water quality--Measurement;

Abstract

Water Quality Indices (WQI) are vital to the decision making process. They summarize reams of data into a single value. When used in aggregate, WQI values provide a general sense of how a body of water changes holistically over a given period. The problem is that analog WQI calculations (as well as pre-existing online calculators) are onerous and time-consuming. Using my calculator, I was able to complete approximately 88 hours of work in 38 minutes. This calculator has already been used internationally to expedite the WQI calculation process; allowing for lawmakers, businesses, and citizens alike to understand more about the general quality of their water.

Start Date

6-3-2023 11:30 AM

End Date

6-3-2023 1:30 PM

Event Host

University Honors Programs, Iowa Regent Universities

Faculty Advisor

Mohammad Iqbal

Department

Department of Earth and Environmental Sciences

Comments

The poster was previously presented at the 2022 Summer Undergraduate Research Program (SURP) Symposium.

To view the poster either click on this link or the "Download" button.

File Format

application/pdf

Link to Full Text

Comments?

Share

COinS
 
Mar 6th, 11:30 AM Mar 6th, 1:30 PM

Development of a Water Quality Index Calculation Tool using Excel

Water Quality Indices (WQI) are vital to the decision making process. They summarize reams of data into a single value. When used in aggregate, WQI values provide a general sense of how a body of water changes holistically over a given period. The problem is that analog WQI calculations (as well as pre-existing online calculators) are onerous and time-consuming. Using my calculator, I was able to complete approximately 88 hours of work in 38 minutes. This calculator has already been used internationally to expedite the WQI calculation process; allowing for lawmakers, businesses, and citizens alike to understand more about the general quality of their water.