User Defined Spreadsheet Functions in Excel
Fuente:
arXiv
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Preprint |
| Veröffentlicht: |
2012
|
| Schlagworte: | |
| Online-Zugang: | |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| _version_ | 1866910765138575360 |
|---|---|
| author | Tyszkiewicz, Jerzy Balson, Dermot |
| author_facet | Tyszkiewicz, Jerzy Balson, Dermot |
| contents | Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, the only direct way to use UDFs in spreadsheets is to switch from the functional and declarative style of spreadsheet formulas to the imperative VBA, which creates a high entry barrier even for proficient spreadsheet users. It has been proposed to extend Excel by UDFs declared by a spreadsheet: user defined spreadsheet functions (UDSFs). In this paper we present a method to create a limited form of UDSFs in Excel without any use of VBA. Calls to those UDSFs utilize what-if data tables to execute the same part of a worksheet several times, thus turning it into a reusable function definition. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_1211_6781 |
| institution | arXiv |
| publishDate | 2012 |
| record_format | arxiv |
| spellingShingle | User Defined Spreadsheet Functions in Excel Tyszkiewicz, Jerzy Balson, Dermot Software Engineering Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, the only direct way to use UDFs in spreadsheets is to switch from the functional and declarative style of spreadsheet formulas to the imperative VBA, which creates a high entry barrier even for proficient spreadsheet users. It has been proposed to extend Excel by UDFs declared by a spreadsheet: user defined spreadsheet functions (UDSFs). In this paper we present a method to create a limited form of UDSFs in Excel without any use of VBA. Calls to those UDSFs utilize what-if data tables to execute the same part of a worksheet several times, thus turning it into a reusable function definition. |
| title | User Defined Spreadsheet Functions in Excel |
| topic | Software Engineering |
| url | https://arxiv.org/abs/1211.6781 |