Development of excel based VBA application for residential GCPV system design by energy requirement

Michael, Rachel (2024) Development of excel based VBA application for residential GCPV system design by energy requirement. Project Report. Universiti Teknikal Malaysia Melaka, Melaka, Malaysia. (Submitted)

Text (Full Text) Development of excel based VBA application for residential GCPV system design by energy requirement.pdf - Submitted Version Download (5MB)

Abstract

Solar photovoltaic (PV) industry is not only great for the environment, but also for boosting the economy, as it is a multimillion-dollar industry. For PV system installers, designing a PV system typically requires the use of specialised software or an application that is only understandable by a technical person and can be quite challenging for customers with no technical background. Therefore, to overcome this problem, this project aims to develop an Excel-based Visual Basic for Applications (VBA) application for the design of residential grid-connected photovoltaic (GCPV) systems that is free, user-friendly, and accessible for non-technical person. The project's objectives are achieved through a combination of literature review and software development. To do so, an application is developed using the VBA programming language that is integrated into Microsoft Excel. In this semester, the full development of VBA based application is succesfully executed and the expected result from the application conforms to the actual result from manual calculation. It is envisaged that the successful implementation of this project will expedite and promote more installation of PV systems and hence reduce the dependency on fossil fuel-based electrical energy.

Actions (login required)

View Item