Development of solar PV system design by energy requirement using excel based VBA

Md Sarif, Anis Nazirah (2025) Development of solar PV system design by energy requirement using excel based VBA. Project Report. Universiti Teknikal Malaysia Melaka, Melaka, Malaysia. (Submitted)

Preview

Text (Full Text) Development of solar PV system design by energy requirement using excel based VBA.pdf - Submitted Version Download (4MB) | Preview

Abstract

Nowadays, energy is primarily generated from fuel cells and coal, which significantly harms the Earth, causing depletion of the ozone layer, global warming, and air pollution. Given these ongoing issues, there's a growing need to explore alternative energy sources to reduce reliance on fuel cells and coal for electricity production. One promising alternative is solar photovoltaic (PV) technology, which eliminates pollution associated with electricity generation. To facilitate the adoption of solar PV, a user-friendly application is being developed. Users will only need to input their monthly energy consumption data from their electricity bills. The application utilizes the "VLOOKUP" function and offers a selection of three solar PV systems and three inverters for users to choose from. Based on the input data, the application will recommend the appropriate size of solar PV system and inverter for their homes. This project aims to simplify the process for consumers to determine their solar PV and inverter requirements. Additionally, the application will provide an estimated cost for consumers interested in installing solar PV systems, enabling them to make informed decisions before engaging with solar PV installation services. The project addresses the challenge of designing photovoltaic (PV) systems, a process that typically requires complex mathematical calculations to determine energy needs, solar panel size, and inverter size. This can be especially difficult for individuals without an engineering background. To solve this issue, a user-friendly Excel VBA application called Development of Solar PV System Design by Energy Requirement using Excel based VBA was developed. This application simplifies the design process by automating calculations and providing accurate results. It has been tested using 3 solar PV panels and 3 inverters and evaluated with four types of input: small, medium, large, and invalid. The application is very accurate, and it is verified through manual calculation by analysis. By making the design process simpler and the suring results match manual calculations, this project enables users to transition to solar energy with ease. With its affordable, accessible, and precise features, this tool is an excellent solution for anyone looking to adopt solar energy, reduce dependence on non-renewable resources, and lower energy costs.

Actions (login required)

View Item