User Defined Spreadsheet Functions in Excel

摘要: Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, only direct way use UDFs spreadsheets switch from functional and declarative style spreadsheet formulas imperative VBA, which creates high entry barrier even for proficient users. It has been proposed extend Excel by declared spreadsheet: (UDSFs). In this paper we present create limited form UDSFs without any VBA. Calls those utilize what-if data tables execute same part worksheet several times, thus turning it into reusable function definition.