Publication detail

User-Defined Matrix Function as an Alternative Method Simulating the Activity of a Relational Database in the MS Excel Environment to Be Used in Companies

DYDOWICZ, P.

Original Title

User-Defined Matrix Function as an Alternative Method Simulating the Activity of a Relational Database in the MS Excel Environment to Be Used in Companies

Type

conference paper

Language

English

Original Abstract

Thus the goal of this article is to show yet another possibility of mass data processing which consists in the development and application of user VBA matrix function, and compare this function with the other possibilities available within the MS Excel environment.

Keywords

MS Excel, VBA, relational database, matrix functions, user functions

Authors

DYDOWICZ, P.

RIV year

2015

Released

7. 5. 2015

Publisher

IBIMA

Location

Amsterdam

ISBN

978-0-9860419-4-5

Book

Innovation Vision 2020: From Regional Development Sustainability to Global Economic Growth

Edition number

1

Pages from

2356

Pages to

2367

Pages count

3397

BibTex

@inproceedings{BUT115550,
  author="Petr {Dydowicz}",
  title="User-Defined Matrix Function as an Alternative Method Simulating the Activity of a Relational Database in the MS Excel Environment to Be Used in Companies",
  booktitle="Innovation Vision 2020: From Regional Development Sustainability to Global Economic Growth",
  year="2015",
  number="1",
  pages="2356--2367",
  publisher="IBIMA",
  address="Amsterdam",
  isbn="978-0-9860419-4-5"
}