Ovim radom implementiran je zadani algoritam za analizu brojčane tablice. Program je pisan u VBA programskom jeziku. Dan je detaljan opis zadanog algoritma analize. Ukratko je prikazano VBA programsko sučelje. VBA sintaksa opisana je kroz nekoliko njenih najvažnijih elemenata: sintaksu deklaracije varijabli i nizova, sintaksu uvjetnih grananja, sintaksu programskih petlji, podjela macro metoda na subrutine i funkcije. Zatim je dano detaljno objašnjenje funkcioniranja dizajniranog programa. Kod programa podijeljen je u zasebne module odnosno objekte koji predstavljaju Excel radne listove Sheet1 i Sheet2. Macro metodama radnog lista Sheet1 dohvaćaju se korisnički parametri i provodi potrebna analiza na brojevima iz tablice. Macro metodama radnog lista Sheet2 prikazuju se i uklanjaju rezultati provedene analize. Nadalje, ovaj radni list sadrži korisničko sučelje programa.

In this work, the given numeric table analysis algorithm was implemented. The program was written in VBA programming language. A detailed description of the numeric analysis algorithm was given. The VBA programming interface was briefly presented. VBA syntax was described trough some of its most important elements: variable and array declaration syntax, conditional statement syntax, programming loops syntax, classification of macro methods into subroutines and functions. Next, a detailed explanation of the functioning of the designed program was given. The program code was divide into independent modules or objects which represent Excel worksheets Sheet1 and Sheet2. Trough Sheet1macro methods, user parameters are imported and the required analysis of the numbers in the table is carried out. Trough Sheet2 macro methods, the results of the analysis are shown or removed. Furthermore, this worksheet contains the user interface of the program.