Analyzing and displaying data from a PV system : Excel VBA programming and MATLAB data analysis

Sammanfattning: This thesis work’s purpose is to collect, analyze, and display data from a PV array located in Borlänge, Sweden. For the data analysis, MATLAB is used as an analysis tool, in order to have an idea of how the system is going in its entirety by drawing several different graphs such as daily irradiance or temperature but also to gather all the data that is available and regroup it in the same Excel sheet in order to simplify the usage of the program. For the display of the data, Excel Visual Basics for Applications (VBA) is used to establish a user-controlled interface which lets the choice to study a certain parameter over a certain period of time, and then display graphs and data automatically, all of this being chosen by the user, for example to create daily, monthly or yearly plots of the energy production as well as the efficiency of the system.