Difference between revisions of "Overview FXLData"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
[[File:Fxldata animation.gif]] | [[File:Fxldata animation.gif]] | ||
| + | |||
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 add-in. | 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 add-in. | ||
[[File:Wizard Version R1.0.png|Wizard - July 2004|600px]] | [[File:Wizard Version R1.0.png|Wizard - July 2004|600px]] | ||
Revision as of 07:26, 18 July 2024
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 add-in.
