Overview FXLData
Jump to navigation
Jump to search
An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet
The FXLData family of functions are Excel array formulas.
These work in the same way normal as normal single-cell functions such as =SUM() and =STDEV() with the exception that the result is an array of series and observation values spanning a range of rows and columns.
Microsoft's documentation provides general information on how to work with array formulas in Excel.
In addition to the Parameterised functions a Data Wizard is available as an Excel Ribbon Tool for interactively building and editing FXLData functions and comes as part of the addin.