Difference between revisions of "Overview FXLData"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | + | An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet</span> The FXLData family of functions are Excel ''array formulas''. | |
| − | |||
| − | |||
| − | |||
| − | 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. | 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. | 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. | ||
| + | |||
| + | [[File:Fxldata animation.gif]] | ||
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.
