Overview FXLData - Revision history

Vmurrell: /* Data Wizard */

2025-08-13T08:39:01Z

‎Data Wizard

Vmurrell: /* Data Wizard */

2025-08-13T08:33:13Z

‎Data Wizard

Grahamcassidy at 14:17, 28 July 2025

2025-07-28T14:17:57Z

Grahamcassidy: /* Functions taking a Fusion Registry data query URL */

2025-07-28T14:14:49Z

‎Functions taking a Fusion Registry data query URL

Grahamcassidy: /* Parameterised functions */

2025-07-28T14:10:15Z

‎Parameterised functions

Grahamcassidy at 14:03, 28 July 2025

2025-07-28T14:03:03Z

Grahamcassidy at 14:02, 28 July 2025

2025-07-28T14:02:40Z

Grahamcassidy at 14:01, 28 July 2025

2025-07-28T14:01:39Z

Grahamcassidy at 13:58, 28 July 2025

2025-07-28T13:58:17Z

Vmurrell at 08:41, 5 August 2024

2024-08-05T08:41:33Z

← Older revision		Revision as of 08:39, 13 August 2025
Line 77:		Line 77:

	[[File:Wizard Version R1.3.png\|Wizard - August 2025\|600px]]		[[File:Wizard Version R1.3.png\|Wizard - August 2025\|600px]]
−

	[[FXLData_Wizard \|Read more about the Data Wizard here. ]]		[[FXLData_Wizard \|Read more about the Data Wizard here. ]]

@@ Line 76: / Line 76: @@
 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.3.png|Wizard - August 2025|600px]]
 [[FXLData_Wizard |Read more about the Data Wizard here. ]]

@@ Line 44: / Line 44: @@
 Returns the selected resultset in 'horizontal' time-series format with one series per row<br/>
 * Behaves in the same way as =FXLData() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 <span style="color:red;>'''=FXLDataUrlV'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset in 'vertical' format with one series per column<br/>
 * Behaves in the same way as =FXLDataV() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 <span style="color:red;>'''=FXLDataUrlFact'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse style fact table]<br/>
 * Takes a single mandatory argument: a fully-formed Fusion Registry data query URL
-* A single optional argument allows the maximum number of series to be set
+* The optional MaxSeries argument allows the maximum number of series to be set
 * Returns one row per observation including all series and observation attributes
 * Following the traditional fact table model, only dimension and attributes codes are returned - there is not option to return code labels

@@ Line 41: / Line 41: @@
 Both the horizontal and 'V' vertical variants take the same arguments making it easy to switch between presentations.
-<span style="color:red;>'''=FXLDataUrl'''( ''Url , [MaxSeries] '' )</span><br/>
+<span style="color:red;>'''=FXLDataUrl'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset in 'horizontal' time-series format with one series per row<br/>
 * Behaves in the same way as =FXLData() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
 * A single optional argument allows the maximum number of series to be set
-<span style="color:red;>'''=FXLDataUrlV'''( ''Url , [MaxSeries] '' )</span><br/>
+<span style="color:red;>'''=FXLDataUrlV'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset in 'vertical' format with one series per column<br/>
 * Behaves in the same way as =FXLDataV() but takes a single mandatory argument: a fully-formed Fusion Registry data query URL
 * A single optional argument allows the maximum number of series to be set
-<span style="color:red;>'''=FXLDataUrlFact'''( ''Url , [MaxSeries] '' )</span><br/>
+<span style="color:red;>'''=FXLDataUrlFact'''( ''Url , [MaxSeries] , [TimeFormatFrequencyId] '' )</span><br/>
 Returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse style fact table]<br/>
 * Takes a single mandatory argument: a fully-formed Fusion Registry data query URL

@@ Line 26: / Line 26: @@
 * If Labels=both, setting IncludeAttributes=TRUE will show the breakdown of series / dataset attributes in the header
 * IncludeHeader controls whether the resultset metrics are shown at the top (e.g. 205/1276 series   1.78 seconds)
 '''''Examples'''''

@@ Line 20: / Line 20: @@
 Returns a selected dataset in 'vertical' format with one series per column
 * Three mandatory arguments: the base URL of the Fusion Registry, the Dataflow, a Series Key pattern specifying what series to return
-* A further nine optional arguments can be specified including: maximum number of series to retrieve, start / end period, and whether dimensions, attributes and metrics are shown
+* A further eleven optional arguments can be specified including: maximum number of series to retrieve, start / end period, and whether dimensions, attributes and metrics are shown
 * IncludeSeriesKey is ignored
 * IncludeBreakdown is ignored

@@ Line 15: / Line 15: @@
 Returns a selected dataset in 'horizontal' time-series format with one series per row<br/>
 * Three mandatory arguments: the base URL of the Fusion Registry, the Dataflow, a Series Key pattern specifying what series to return
-* A further nine optional arguments can be specified including: maximum number of series to retrieve, start / end period, labels, headers and whether dimensions and attributes are shown
+* A further eleven optional arguments can be specified including: maximum number of series to retrieve, start / end period, labels, headers and whether dimensions and attributes are shown
 <span style="color:red;>'''=FXLDataV'''( ''RegUrl , Dataflow , Expression , [MaxSeries] , [RestArguments] , [StartPeriod] , [EndPeriod] , [Labels] , [IncludeHeader] , [IncludeSeriesKey] - ignored, [IncludeBreakdown] - ignored, [IncludeAttributes], [TimeFormatFrequencyId], [DataflowName]'' )</span> <br>

@@ Line 1: / Line 1: @@
 __NOTOC__
-An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet</span>
+FXLData is an Excel add-in that enables users to retrieve statistical data from a Fusion Registry directly into their worksheets using custom formulas.
-The FXLData family of functions are Excel ''array formulas''.
+Although these formulas resemble Excel’s built-in formulas , they are handled differently behind the scenes. When a user enters an FXLData formula, the plugin calls the Fusion Registry API, processes the response, and populates the worksheet with a structured grid of series and observation values. This design promotes performance and gives the plugin more control over how data is displayed, while still offering a familiar formula-based interface.
 [[File:Fxldata animation.gif]]

← Older revision		Revision as of 08:41, 5 August 2024
Line 1:		Line 1:
		+	__NOTOC__
	An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet</span>		An Excel add-in providing a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet</span>