Application of Excel-VBA for computation of water quality index and air pollutant index Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara

Abidin, I.Z. and Juahir, Hafizan and Azid, Azman and Mustafa, A.D. and Azaman, F. (2015) Application of Excel-VBA for computation of water quality index and air pollutant index Penggunaan Excel-VBA untuk pengiraan indeks kualiti air dan indeks pencemaran udara. Malaysian Journal of Analytical Sciences, 19 (5). pp. 1056-1064. ISSN 1394-2506

[img] Image
hj6.jpg
Restricted to Registered users only

Download (128Kb) | Request a copy
Official URL: http://www.scopus.com/inward/record.url?eid=2-s2.0...

Abstract

In Malaysia, there are two main indices which are Water Quality Index (WQI) and Air Pollutant Index (API). These indices are used as an indicator for the water quality and ambient air quality status of the environment. In conducting research regarding water and air quality, lots of time has been used to conduct other activities, an application to calculate the indices might come in handy. This project aims to construct an application for the computation of WQI and API using Visual Basic for Applications (VBA) available in Microsoft Excel. VBA is actually a programming language of Microsoft Excel and can be used to write programming and run through in an Excel workbook. The user only required to enter the value for each parameter and then press �OK� to automatically calculate the index. This will provide instance result without wasting time just to refer to the class standard and other formula. The application also has been used as a teaching tool for the secondary students. An environmental based race game called Young Environmental Scientist (YES) Explorace was conducted by Environmental East Coast Research Institute (ESERI) where secondary student are invited as the participant. The application not only provides early exposure to the environmental pollution, but also exposure to the application of computer sciences to the student. © 2015, Malaysian Society of Analytical Sciences. All rights reserved.

Item Type: Article
Additional Information: cited By 0
Subjects: Q Science > QD Chemistry
Faculty / Institute: East Coast Environmental Research Institute (ESERI)
Depositing User: Assc. Prof Hafizan Juahir
Date Deposited: 09 Nov 2015 08:07
Last Modified: 09 Nov 2015 08:07
URI: http://erep.unisza.edu.my/id/eprint/3963

Actions (login required)

View Item View Item