Subset remainder question format - Revision history

Mtabadmin at 19:04, 7 August 2013

2013-08-07T19:04:37Z

Mtabadmin at 19:03, 7 August 2013

2013-08-07T19:03:29Z

Mtabadmin at 18:40, 31 July 2013

2013-07-31T18:40:32Z

Mtabadmin at 18:39, 31 July 2013

2013-07-31T18:39:22Z

Mtabadmin at 18:38, 31 July 2013

2013-07-31T18:38:27Z

Mtabadmin at 17:02, 29 July 2013

2013-07-29T17:02:26Z

Mtabadmin at 17:00, 29 July 2013

2013-07-29T17:00:12Z

Mtabadmin at 16:58, 29 July 2013

2013-07-29T16:58:29Z

Mtabadmin at 21:03, 25 July 2013

2013-07-25T21:03:07Z

Mtabadmin at 20:52, 25 July 2013

2013-07-25T20:52:08Z

@@ Line 14: / Line 14: @@
 [[File:Format subset-remainder-question-format create-new-format.jpg|thumb|center|x275px]]
-[[File:Format subset-remainder-question-format name-and-create-format.jpg|thumb|left|x275px]]
+[[File:Format subset-remainder-question-format name-and-create-format.jpg|thumb|right|x275px]]
 The next step is to choose a format style which can be used as the basis of the new format, Subset and Sample Total seems to be a logical choice in this example.

@@ Line 41: / Line 41: @@
 After running the tab, we observe the newly selected column format (shown below) now illustrates our subset total, newly added remainder subset total, and sample total column columns.
-[[File:Format subset-remainder-question-format spreadsheet-new-format-style.jpg|x350px]]
+[[File:Format subset-remainder-question-format spreadsheet-new-format-style.jpg|thumb|center|x350px]]
 Please note that you can repeat the above process to add Unweighted Remainder Totals or Weighted Remainder Totals to any of your other Column or Row formats.

@@ Line 41: / Line 41: @@
 After running the tab, we observe the newly selected column format (shown below) now illustrates our subset total, newly added remainder subset total, and sample total column columns.
 [[File:Format subset-remainder-question-format spreadsheet-new-format-style.jpg|x350px]]
-[[File:Format subset-remainder-question-format spreadsheet-view.jpg|thumb|center|x350px]]
-[[File:Format subset-remainder-question-format spreadsheet-new-format-style.jpg|thumb|center|x350px]]
 Please note that you can repeat the above process to add Unweighted Remainder Totals or Weighted Remainder Totals to any of your other Column or Row formats.

@@ Line 43: / Line 43: @@
 [[File:Format subset-remainder-question-format spreadsheet-view.jpg|thumb|center|x350px]]
-[[File:Formatsubset-remainder-question-format spreadsheet-new-format-style.jpg|x350px]]
+[[File:Format subset-remainder-question-format spreadsheet-new-format-style.jpg|thumb|center|x350px]]
 Please note that you can repeat the above process to add Unweighted Remainder Totals or Weighted Remainder Totals to any of your other Column or Row formats.

← Older revision		Revision as of 18:38, 31 July 2013
Line 43:		Line 43:

	[[File:Format subset-remainder-question-format spreadsheet-view.jpg\|thumb\|center\|x350px]]		[[File:Format subset-remainder-question-format spreadsheet-view.jpg\|thumb\|center\|x350px]]
		+	[[File:Formatsubset-remainder-question-format spreadsheet-new-format-style.jpg\|x350px]]
	Please note that you can repeat the above process to add Unweighted Remainder Totals or Weighted Remainder Totals to any of your other Column or Row formats.		Please note that you can repeat the above process to add Unweighted Remainder Totals or Weighted Remainder Totals to any of your other Column or Row formats.

← Older revision		Revision as of 17:00, 29 July 2013
Line 24:		Line 24:


−	To tidy up how the data will be displayed when using this format, drag the Formatted Subset Remainder Total around until it falls between the Subset and Sample Totals.	+	To tidy up how the data will be displayed when using this format, drag the Formatted Subset Remainder Total around until it falls between the Subset and Sample Totals. This means that the Subset Totals will be displayed first, followed by the Subset Remainder Total, followed by the Sample Totals in the spreadsheet view.

@@ Line 1: / Line 1: @@
-mTAB has always given users the option to show a Sample Total and a Subset Total.  The Sample Total provides us with a total for all respondents in the database.  The Subset Total provides us with a total for questions responses that have been subsetted.  Obviously if no subset has been applied to a question, both the Sample and Subset total will be the same.
+mTAB has always given users the option to show a Sample Total and a Subset Total.  The Sample Total provides us with a total for all respondents in the database.  The Subset Total provides us with a total for questions responses that have been subsetted.  If no subset has been applied to a question, both the Sample and Subset total will be the same.
@@ Line 7: / Line 7: @@
 '''Creating the New Format'''
-To use the Subset remainder Total in mTAB, we need to create a new format using the Format Style Editor.
+To use the Subset Remainder Total in mTAB, we need to create a new format using the Format Style Editor.
@@ Line 18: / Line 18: @@
-We now need to add the Subset Remainder Total to this format.  We can do this by clicking on the blue + next to Totals and this category will expand.
+We now need to add the Subset Remainder Total to this format.  We can do this by clicking on the blue [+] next to Totals and this category will expand.
 Now double click Formatted Subset Remainder Total or click and drag into the Format Display Ordering and this will be added to the top box on the right hand side of the screen.
 To tidy up how the data will be displayed when using this format, drag the Formatted Subset Remainder Total around until it falls between the Subset and Sample Totals.
@@ Line 38: / Line 39: @@
-After running the tab, we observe the newly selected column format as shown below, now illustrating our subset total, newly added remainder subset total, and sample total column columns.
+After running the tab, we observe the newly selected column format (shown below) now illustrates our subset total, newly added remainder subset total, and sample total column columns.
 [[File:Format subset-remainder-question-format spreadsheet-view.jpg|thumb|center|x350px]]

@@ Line 36: / Line 36: @@
 [[File:Format subset-remainder-question-format new-available-format.jpg|thumb|right|x100px]]
 With the column banner questions highlighted, pull down the available formats toolbar menu as shown below and select our newly created format.
 After running the tab, we observe the newly selected column format as shown below, now illustrating our subset total, newly added remainder subset total, and sample total column columns.

@@ Line 12: / Line 12: @@
 To create a new format, select the '''Format Style''' icon to the right of the Available Format Styles, or alternatively, right click your mouse in the desired row/column/layer panel and select Format Styles, displaying the Format Style dialog.
-[[File:Format subset-remainder-question-format create-new-format.jpg|thumb|center|x250px]]
+[[File:Format subset-remainder-question-format create-new-format.jpg|thumb|center|x275px]]
-[[File:Format subset-remainder-question-format name-and-create-format.jpg|thumb|left|x250px]]
+[[File:Format subset-remainder-question-format name-and-create-format.jpg|thumb|left|x275px]]
 The next step is to choose a format style which can be used as the basis of the new format, Subset and Sample Total seems to be a logical choice in this example.
@@ Line 34: / Line 34: @@
 '''Selecting the New Format'''
-[[File:Format subset-remainder-question-format new-available-format.jpg|thumb|right|x200px]]
+[[File:Format subset-remainder-question-format new-available-format.jpg|thumb|right|x100px]]
 With the column banner questions highlighted, pull down the available formats toolbar menu as shown below and select our newly created format.