Module database 

Database functions (D-functions)

Excel D-functions perform aggregate operations on a database (range with header row) filtering rows that match specified criteria.

Implementations:

• DSUM(database, field, criteria) - Sums values in field column matching criteria
• DAVERAGE(database, field, criteria) - Averages values in field column matching criteria
• DCOUNT(database, field, criteria) - Counts numeric cells in field column matching criteria
• DMAX(database, field, criteria) - Maximum value in field column matching criteria
• DMIN(database, field, criteria) - Minimum value in field column matching criteria

Database structure:

• First row contains column headers (field names)
• Subsequent rows contain data records

Field argument:

• String matching a column header (case-insensitive)
• Number representing 1-based column index

Criteria structure:

• First row contains column headers (subset of database headers)
• Subsequent rows contain criteria values (OR relationship between rows)
• Multiple columns in same row have AND relationship
• Supports comparison operators (>, <, >=, <=, <>), wildcards (*, ?)

Structs

DAverageFn

DCountAFn

DCountFn

DGetFn

DMaxFn

DMinFn

DProductFn

DStdevFn

DStdevPFn

DSumFn

DVarFn

DVarPFn

Functions

register_builtins

Register all database functions.