Spreadsheet Library (PQL)
Function Categories
These functions are used to access data and parameter values directly from Pyramid data sources |
|
These functions are used to analyse, count, add and filter data stored in lists or databases |
|
These functions are used for entering, manipulating and calculating dates and times |
|
These functions are used to handle complex numbers, conversions and measurements |
|
These functions are used to calculate financial logic like depreciation, accrued interest, annuities, rates of return and future values |
|
These functions are used to identify the contents of cells and determine any errors or blanks |
|
These functions are used to perform conditional analysis and apply logical conjectures to your data |
|
These functions are used to locate references and specific values within tables of data |
|
These functions are used for advanced mathematical operations like rounding, ranking, analysing trends and to calculate probabilities and logarithms |
|
These functions are used for statistical operations like standard deviation, distributions, square roots, average and median |
|
These functions are used for entering, searching, replacing and manipulating text strings |
|
These functions return data from a web service hosted on the internet |
|
These legacy functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage |
Overview
The Spreadsheet library includes all the functions available in the Tabulate App. Apart from the specialized Pyramid functions, these mirror the 500+ functions available in Microsoft Excel. All these functions can be used for any spreadsheet based calculation in the same way as Microsoft Excel.
The specialized Pyramid functions control connecting to live data and managing slicers and parameters. they can be combined with nay of the standard spreadsheet functions to extend the sophistication of the business and decision models created with tabulate.