Spreadsheet Library (PQL)

  • Family: PQL

    • Function Categories

    Pyramid

    These functions are used to access data and parameter values directly from Pyramid data sources

    Database

    These functions are used to analyse, count, add and filter data stored in lists or databases

    Date & Time

    These functions are used for entering, manipulating and calculating dates and times

    Engineering

    These functions are used to handle complex numbers, conversions and measurements

    Financial

    These functions are used to calculate financial logic like depreciation, accrued interest, annuities, rates of return and future values

    Information

    These functions are used to identify the contents of cells and determine any errors or blanks

    Logical

    These functions are used to perform conditional analysis and apply logical conjectures to your data

    Lookup

    These functions are used to locate references and specific values within tables of data

    Math & Trig

    These functions are used for advanced mathematical operations like rounding, ranking, analysing trends and to calculate probabilities and logarithms

    Statistical

    These functions are used for statistical operations like standard deviation, distributions, square roots, average and median

    Text

    These functions are used for entering, searching, replacing and manipulating text strings

    Web

    These functions return data from a web service hosted on the internet

    Compatibility

    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.