Software system for different variants of interest calculation in VBA on the MS Excel platform : Final paper

Sve obrade podataka mogu se u poslovnom subjektu obaviti manualno, no u današnjim uvjetima poslovanja koje je intenzivno i dinamično, pitanje je isplativosti, a time i smisla upotrebe manualne obrade podataka. Sve što se može, danas se teži prepustiti elektroničkoj obradi podataka jer je ona brža, pouzdanija i rentabilnija. Danas je na tržištu poslovnim subjektima na raspolaganju čitav niz programskih alata, no manji poslovni subjekti, posebice za povremene poslove, radije koriste univerzalna programska rješenja, kao što su tablični kalkulatori, za potrebe elektroničke obrade podataka. Naime, osim na osnovnoj razini, tablični se kalkulatori mogu koristiti i na naprednim razinama, koristeći pritom programske jezike koji proširuju njihove mogućnosti. Osim osnovnih formula i funkcija, formatiranja tablica, zapisivanja i čuvanja podataka u redovima i stupcima koje se mogu upotrebljavati u tabličnom kalkulatoru kao što je MS Excel, korištenje VBA programskog jezika omogućava automatizaciju poslova, dodatnu interakciju korisnika i sučelja i komunikaciju s drugim programima iz MS Office paketa. S obzirom da mali poslovni subjekti povremeno trebaju izračun ugovornih ili zateznih kamata, interesantno je vidjeti koje su mogućnosti u tom smislu MS Excela u kombinaciji s VBA programskim jezikom. Prema tome fokus je provedenog istraživanja bio na razvoju, testiranju i prijedlogu distribucije programskog rješenja za izračun kamata koji će korisnicima omogućiti lakšu interakciju s programom, te će mu predstaviti rješenje na jednostavan i shvatljiv način. S obzirom na problem istraživanja, odnosno na fokus istraživanja, istraženi su pojmovi jednostavan i složen obračun kamata, istraženi su potencijali MS Excel-a za izračun kamata korištenjem VBA programskog jezika, izrađen je model izračuna kamata u MS Excel-u, istražene su mogućnosti samog modela kroz testove i predložen je model distribucije takvog programskog rješenja. Konačni su rezultati istraživanja pokazali kako su programska rješenja ovog tipa iznimno korisna i pridonose poslovnim subjektima kroz korisničko iskustvo koje kreiraju.All data processing in businesses can be done manually, but in today’s intensive and dynamic conditions in which businesses are existing, it is the question of cost-effectiveness and with that comes the question of manual data processing. Today, everything tends to electronical data processing, because it is faster, more reliable and more cost-effective. In today’s market, businesses have a number of software tools, but smaller businesses, especially for occasional jobs, prefer to use universal software solutions such as spreadsheets for electronic data processing. In addition to basic level, spreadsheets can be used on advanced levels too, using programming languages which expand their possibilities. Except for basic formulas and functions, table formatting, writing and saving data in rows and columns which can be used in spreadsheets such as MS Excel using VBA programming language enables job automation, additional interaction between user and user-interface and communication with other programs in MS Office software package. Considering that, small businesses occasionally need to calculate contractual or default interest rate, it is interesting to see which possibilities MS Excel gives us in combination with VBA programming language. Therefore, the focus of the research was on development, testing and suggestion of distribution of software solution for calculating interest rates, which will enable easier interaction between users and the program and will also represent him solution in simple and understandable way. Considering the problem of research, actually focus of the research, the concept of simple and complex interest calculation was explored, the potential of MS Excel for calculation of interest rates, using VBA programming language, the model of calculating interest rates was built in MS Excel, possibilities of the model were explored through tests and model of distribution was proposed for that programming solution. The final results of the research showed that programming solutions of this type are extremely useful and contributing to businesses through user interface they develop