Create an Excel Reporting Template - Revision history

Vmurrell: /* The means to restrict */

2024-03-28T11:26:26Z

‎The means to restrict

2024-03-28T11:18:53Z

‎Data Provider and Provision Agreement

2024-03-28T11:18:15Z

‎Data Provider and Provision Agreement

2022-09-05T13:58:27Z

2021-05-03T09:26:08Z

‎Step 1 - High Level Details

2021-05-03T09:25:45Z

‎Step 2 - Create Reporting Constraint

2021-05-03T09:24:18Z

‎Step 1 - Check all the elements are in place

2021-04-28T17:57:53Z

‎Generate the Template

2021-04-28T17:55:28Z

‎Step 2 - Excel Worksheets

2021-04-28T17:54:51Z

‎Step 1 - High Level Details

← Older revision		Revision as of 11:26, 28 March 2024
Line 47:		Line 47:

	Note that the '''Cross Reference''' is a link. If I click, I will be taken to the Concept Scheme, and I can see a Cross Reference to a Codelist.		Note that the '''Cross Reference''' is a link. If I click, I will be taken to the Concept Scheme, and I can see a Cross Reference to a Codelist.
		+
		+	Note, in Version 11, the Cross References function has changed. This is now available using the References button.
		+
		+	[[File:References.png\|References button\|1000px]]<br>
		+
		+	To learn more about the [[Explore_Structure_References\| Structure Reference feature, please click here]].

@@ Line 37: / Line 37: @@
 Note, in Version 11, the Data Provider button is located lower down the page.
-[[File:Data Provider-button.png|Data Provider button|1000px]]<br>
+[[File:Data Provider-button.png|Data Provider button|950px]]<br>
 ===The means to restrict===

← Older revision		Revision as of 11:18, 28 March 2024
Line 34:		Line 34:

	[[File:RT3.PNG\|Data Provider and Provision Agreement\|1000px]]<br>		[[File:RT3.PNG\|Data Provider and Provision Agreement\|1000px]]<br>
		+
		+	Note, in Version 11, the Data Provider button is located lower down the page.
		+
		+	[[File:Data Provider-button.png\|Data Provider button\|1000px]]<br>

	===The means to restrict===		===The means to restrict===

@@ Line 1: / Line 1: @@
 [[Category:How_To]]
+[[Category:How_To V11]]
 =Overview=

← Older revision		Revision as of 09:26, 3 May 2021
Line 85:		Line 85:


−	[[File:RT12.PNG\|Create a new Template - Step 1\|~~400px~~]]<br>	+	[[File:RT12.PNG\|Create a new Template - Step 1\|450px]]<br>

	===Step 2 - Excel Worksheets===		===Step 2 - Excel Worksheets===

← Older revision		Revision as of 09:25, 3 May 2021
Line 64:		Line 64:


−	[[File:RT5.PNG\|Create a new Cube Constraint - Step 1\|~~300px~~]]<br>	+	[[File:RT5.PNG\|Create a new Cube Constraint - Step 1\|450px]]<br>

	Step 2 allows you to select a structure type, in this example it is the Data Provider who is to be constrained to only submit data for Ghana.		Step 2 allows you to select a structure type, in this example it is the Data Provider who is to be constrained to only submit data for Ghana.

@@ Line 23: / Line 23: @@
-[[File:RT1.PNG|Data Structure|1000px]]<br>
+[[File:RT1.PNG|Data Structure|Data Structure|1000px]]<br>
 ===Dataflow===
-[[File:RT2.PNG|Dataflow|1000px]]<br>
+[[File:RT2.PNG|Dataflow|Dataflow|1000px]]<br>
 ===Data Provider and Provision Agreement===

@@ Line 105: / Line 105: @@
 Only authenticated users are able to Generate a Template so this example assumes that the Template is to be generated and emailed to the person responsible for completing it.
 You will note that the Data Provider GHA has been selected, this means that the Constraint attached to the Provision Agreement will be used. The Frequency selected is Annual, so to to report for the whole of 2019, that year is placed on both the From and To dates. Click '''Generate''' when done.
@@ Line 116: / Line 119: @@
-[[File:RT15.PNG|1000px]]<br>
+[[File:RT15.PNG|The Excel workbook|1000px]]<br>

@@ Line 91: / Line 91: @@
-[[File:RT16.PNG|1000px]]<br>
+[[File:RT16.PNG|Create a new Template - Step 2|1000px]]<br>
 In this example, an Instruction worksheet is created as shown in the image below
-[[File:RT13.PNG|1000px]]<br>
+[[File:RT13.PNG|Create a new Template - Step 3|1000px]]<br>

← Older revision		Revision as of 17:54, 28 April 2021
Line 85:		Line 85:


−	[[File:RT12.PNG\|400px]]<br>	+	[[File:RT12.PNG\|Create a new Template - Step 1\|400px]]<br>

	===Step 2 - Excel Worksheets===		===Step 2 - Excel Worksheets===