Publication result detail

VBA as a Tool for Creating User Matrix Functions to Simulate Database Functions in Bulk Data Processing

DYDOWICZ, P.

Original Title

VBA as a Tool for Creating User Matrix Functions to Simulate Database Functions in Bulk Data Processing

English Title

VBA as a Tool for Creating User Matrix Functions to Simulate Database Functions in Bulk Data Processing

Type

Paper in proceedings (conference paper)

Original Abstract

The paper uses examples of common methods of mathematical operations for data processing in MS Excel, and provides their comparison including measures to eliminate the undesirable effect.

English abstract

The paper uses examples of common methods of mathematical operations for data processing in MS Excel, and provides their comparison including measures to eliminate the undesirable effect.

Keywords

MS Excel, VBA, database function simulation, matrix functions

Key words in English

MS Excel, VBA, database function simulation, matrix functions

Authors

DYDOWICZ, P.

Released

13.05.2014

Publisher

IBIMA

Location

Valencia

ISBN

978-0-9860419-2-1

Book

Proceedings of The 23nd International Business Information Management Association Conference

Pages from

1961

Pages to

1973

Pages count

13

BibTex

@inproceedings{BUT109276,
  author="Petr {Dydowicz}",
  title="VBA as a Tool for Creating User Matrix Functions to Simulate Database Functions in Bulk Data Processing",
  booktitle="Proceedings of The 23nd International Business Information Management Association Conference",
  year="2014",
  number="1",
  pages="1961--1973",
  publisher="IBIMA",
  address="Valencia",
  isbn="978-0-9860419-2-1"
}