Publication 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

Type

conference paper

Language

English

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.

Keywords

MS Excel, VBA, database function simulation, matrix functions

Authors

DYDOWICZ, P.

RIV year

2014

Released

13. 5. 2014

Publisher

IBIMA

Location

Valencia

ISBN

978-0-9860419-2-1

Book

Proceedings of The 23nd International Business Information Management Association Conference

Edition number

1

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"
}