@article{dydowicz2016creation,
  title = {Creation and Use of Internal Matrix Database Functions in VBA MS Excel Environment for Bulk Data Processing},
  author = {Petr Dydowicz},
  year = 2016,
  url = {https://ibimapublishing.com/articles/JSSD/2016/675401/},
  journal = {Journal of Software and Systems Development},
  volume = (2016),
  pages = 12,
  doi = 10.5171/2016.675401,
  abstract = {A whole range of organisations use the MS Office package on different levels of their internal structure, either directly or as ITC support. The package includes the MS Excel spreadsheet processor. Excel is mostly used where the deployment of stronger tools such as SQL or other database tools is too work-intensive with regard to the strategic priorities of the company in the ITC area. There are several reasons for this. MS Excel is a rather intuitive and user-friendly tool and a functioning application can be created with its help with nearly zero knowledge and skills in programming by use of MS Excel internal functions and tools. Nevertheless, an internal inquiry performed in the years 2011 - 2014 in companies daily using MS Office has found out that the utilisation of VBA (an environment for the creation of own macros, functions and forms in Visual Basic for Application), integrated across the MS Office package, is nearly zero. This article therefore aims not only at pointing out the current status of bulk data processing in the MS Excel environment, but mainly at underlining (and comparing to the current status) the options with the help of which, using the VBA language, a more effective use of the MS Excel spreadsheet processor can be achieved in the area of bulk data processing, in particular in the creation of matrix functions simulating database functionality. I have used some of the existing internal functionalities of MS Excel for a comparison with my proposal.},
  keywords = {MS Excel, VBA, database function simulation, matrix functions},
  note = Article ID: 675401
}