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.

Diploma thesis is focused on the analysis of the financial health of microenterprise using statistical methods, specifically time series. The selected size of the enterprise is related to important asset, since this type of analysis is not usually automated. In theoretical part, thesis will discuss each monitored indicator that forms the basis for statistical analysis, which is also described in the theoretical level. The practical part will focus on specific statements obtained, their financial and statistical analysis, and then creating a program in the language of Excel VBA to automate these activities.