Difference between revisions of "Overview FXLData"
Jump to navigation
Jump to search
(Created page with "text") |
|||
| Line 1: | Line 1: | ||
| − | + | __NOTOC__ | |
| + | <span style="font-size:1.5rem;">An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet</span> | ||
| + | |||
| + | [[File:Fxldata animation.gif]] | ||
| + | |||
| + | The FXLData family of functions are Excel ''array formulas''. | ||
| + | |||
| + | These work in the same way normal as normal single-cell funcions 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 [https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 documentation] provides general information on how to work with array formulas in Excel. | ||
Revision as of 08:12, 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 funcions 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.
