Development of excel based VBA application for GCPV system design

Abdul Rahmat, Abdul Luqman Hakim (2023) Development of excel based VBA application for GCPV system design. Project Report. Universiti Teknikal Malaysia Melaka, Melaka, Malaysia. (Submitted)

	Text (24 Pages) Development of excel based VBA application for GCPV system design.pdf - Submitted Version Download (589kB)
	Text (Full Text) Development of excel based VBA application for GCPV system design.pdf - Submitted Version Restricted to Repository staff only Download (1MB)

Abstract

Solar photovoltaic (PV) system installation is now a multi million industry in Malaysia. This is due to the successful implementation of several government incentives such as Feed in Tariff (FiT), Net Metering (NEM) and Large Scale Solar (LSS). Designing a solar PV system involves several steps of calculation which are normally performed by a certified PV system designer. This can be a problem for potential consumers planning to install such system in estimating the size a solar system which suits their allowable budgets. Therefore, this final year project aims to rectify this issue by designing a simple application which can produce an approximation on the relative capacity of a solar PV system based on the financial input given by a user. To do so, a Microsoft Excel based Virtual Basic (VBA) are used as the platform for this application to run. The calculation set in the application are based on the datasheet of Yingli YL400D-36B PV panel and Huawei SUN2000-2KTL-L1 PV inverter. The project calculate the output power of PV panel and PV inverter can produced according to the customer’s budget. The correctness of its calculation are comparable to manual calculation. It is hope that user friendly nature of the application will be useful by solar PV installer in order to increase the number of customers.

Actions (login required)

View Item