ADVANCED DATA MODELING IN BUSINESS USING DYNAMIC ARRAYS AND TRIPLE MATRICES

Valerica Greavu-Serban () and Vasile-Daniel Pavaloaia ()
Additional contact information
Valerica Greavu-Serban: Alexandru Ioan Cuza University of Iasi
Vasile-Daniel Pavaloaia: Alexandru Ioan Cuza University of Iasi

EUFIRE Conference Proceedings Series, 2025, vol. 1, issue 1, 142-151

Abstract: Recent developments in Microsoft Excel, particularly the introduction of Dynamic Arrays, have significantly enhanced the capabilities of this ubiquitous tool in financial and accounting analysis. This paper explores the application of modern Excel functions such as MAP(), LAMBDA(), SEQUENCE(), MAKEARRAY(), and LET() in automating complex tasks, minimizing formula redundancy, and enabling advanced modelling without VBA scripting. A structured application of these functions is demonstrated through real-life accounting and finance use cases, including budget projections, data reconciliation, scenario modelling, and error detection. Additionally, a novel methodology termed the Triple Matrix is introduced. Inspired by triple FOR loop logic, this approach enables multidimensional evaluation and aggregation directly within Excel using only native functions. The method systematically generates and processes combinations of values across three axes, allowing the implementation of iterative logic and scenario simulations without macros. This approach is tested in various use cases and evaluated based on automation efficiency, clarity of formulas, performance, and adaptability. Results highlight the added value of combining Dynamic Arrays and Triple Matrix logic for accountants and financial analysts, improving automation, accuracy, and process scalability using only standard Excel functionality.

Keywords: Dynamic Arrays; Triple Matrix; financial modelling; spreadsheet analysis; no-code solutions (search for similar items in EconPapers)
JEL-codes: G19 H75 M15 (search for similar items in EconPapers)
Date: 2025
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://eufire.uaic.ro/wp-content/uploads/2025/12/ ... valoaia_142__151.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:cxa:eu2025:v:1:y:2025:i:1:p:142-151

DOI: 10.47743/eufire-2025-1-12

Access Statistics for this article

More articles in EUFIRE Conference Proceedings Series from Alexandru Ioan Cuza University Publisher
Bibliographic data for series maintained by Mihaela Tofan ().