Listware for Excel:US - Revision history

Admin at 23:56, 31 May 2018

2018-05-31T23:56:43Z

← Older revision		Revision as of 23:56, 31 May 2018
Line 1:		Line 1:
	~~[[Listware for Excel:Reference\|← Listware for Excel Reference]]~~		{{LWEUSNav}}

	{~~\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"~~
	~~! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check and Verify Navigation'''~~
	\|-
	~~\| style="padding-right:220px;"\|~~
	\|-
	~~\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]~~
	\|-
	~~\|[[Listware for Excel:US\|Overview]]~~
	\|-
	~~\|[[Listware for Excel:US Tutorial\|Tutorial]]~~
	\|-
	\|
	{~~\| class="mw-collapsible mw-collapsed" style="width:100%;"~~
	~~\|- align="left"~~
	~~! style="color:black;"\|Steps~~
	\|-
	~~\|[[Listware for Excel:US:Processing Range\|Processing Range]]~~
	\|-
	~~\|[[Listware for Excel:US:Cleansing Operations\|Cleansing Operations]]~~
	\|-
	~~\|[[Listware for Excel:US:Input Columns\|Input Columns]]~~
	\|-
	~~\|[[Listware for Excel:US:Output Columns\|Output Columns]]~~
	\|-
	~~\|[[Listware for Excel:US:Reporting\|Reporting]]~~
	\|-
	~~\|[[Listware for Excel:US:Review Settings\|Review Settings]]~~
	\|-
	~~\|[[Listware for Excel:US:Processing\|Processing]]~~
	\|-
	~~\|[[Listware for Excel:US:Review Results\|Review Results]]~~
	\|}
	\|-
	\|
	~~{\| class="mw-collapsible mw-collapsed" style="width:100%;"~~
	~~\|- align="left"~~
	~~! style="color:black;"\|Result Codes~~
	\|-
	~~\|[[Returned Result Codes:Software#Listware for Excel\|Returned Result Codes]]~~
	\|-
	~~\|[[Result Codes]]~~
	\|}
	\|}

	{{CustomTOC}}		{{CustomTOC}}

Admin at 18:36, 17 April 2018

2018-04-17T18:36:36Z

← Older revision		Revision as of 18:36, 17 April 2018
Line 49:		Line 49:
	[[File:LWE_US_Button.png\|link=]]		[[File:LWE_US_Button.png\|link=]]

	US Check & Verify can be accessed by clicking the 'US' button ~~in the 'Check & Verify' section~~.		US Check & Verify can be accessed by clicking the 'US & Canada' button.

Admin at 19:41, 17 September 2014

2014-09-17T19:41:24Z

← Older revision		Revision as of 19:41, 17 September 2014
Line 75:		Line 75:

	;[[Listware for Excel:US:Processing\|Processing]]		;[[Listware for Excel:US:Processing\|Processing]]
	:Processing will display the ~~progess~~ of your data cleansing.		:Processing will display the progress of your data cleansing.

	;[[Listware for Excel:US:Review Results\|Review Results]]		;[[Listware for Excel:US:Review Results\|Review Results]]

Admin at 21:34, 15 September 2014

2014-09-15T21:34:07Z

← Older revision		Revision as of 21:34, 15 September 2014
Line 6:		Line 6:
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
	\|-		\|-
	\|[[Listware for Excel:Check and Verify\|← Check and Verify]]		\|style="border-bottom:1px solid #aaaaaa;"\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin at 21:30, 15 September 2014

2014-09-15T21:30:28Z

← Older revision		Revision as of 21:30, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
	! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check & Verify Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check and Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|

Admin at 21:30, 15 September 2014

2014-09-15T21:30:15Z

← Older revision		Revision as of 21:30, 15 September 2014
Line 2:		Line 2:

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
	! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Navigation'''		! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"\|'''US Check & Verify Navigation'''
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|

Admin at 21:29, 15 September 2014

2014-09-15T21:29:47Z

← Older revision		Revision as of 21:29, 15 September 2014
Line 1:		Line 1:
	[[Listware for Excel:Reference\|← Listware for Excel Reference]]		[[Listware for Excel:Reference\|← Listware for Excel Reference]]

	~~[[Listware for Excel:Check and Verify\|← Back]]~~

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
Line 7:		Line 5:
	\|-		\|-
	\| style="padding-right:220px;"\|		\| style="padding-right:220px;"\|
			\|-
			\|[[Listware for Excel:Check and Verify\|← Check and Verify]]
	\|-		\|-
	\|[[Listware for Excel:US\|Overview]]		\|[[Listware for Excel:US\|Overview]]

Admin at 19:42, 15 September 2014

2014-09-15T19:42:36Z

← Older revision		Revision as of 19:42, 15 September 2014
Line 1:		Line 1:
	[[Listware for Excel:Reference\|← Listware for Excel Reference]]		[[Listware for Excel:Reference\|← Listware for Excel Reference]]

			[[Listware for Excel:Check and Verify\|← Back]]

	{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"		{\| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"

Admin at 17:53, 3 July 2014

2014-07-03T17:53:26Z

← Older revision		Revision as of 17:53, 3 July 2014
Line 43:		Line 43:
	\|}		\|}

			{{CustomTOC}}

			[[File:LWE_US_Button.png\|link=]]

			US Check & Verify can be accessed by clicking the 'US' button in the 'Check & Verify' section.

	~~{{CustomTOC}}~~

			US Check & Verify allows you to do Contact Verification. Each step can be navigated to by clicking the 'Next' or 'Previous' buttons. The steps are as follows:

			;[[Listware for Excel:US:Processing Range\|Processing Range]]
			:Select the range of cells in your worksheet that you would like to process, then click the 'Select Data to Process' button.

			;[[Listware for Excel:US:Cleansing Operations\|Cleansing Operations]]
			:Check the operation(s) you want to perform.

			;[[Listware for Excel:US:Input Columns\|Input Columns]]
			:Specify the input fields you want to process by selecting them in the drop-down menus.

			;[[Listware for Excel:US:Output Columns\|Output Columns]]
			:Specify what data you want to output by checking the box next to the desired fields.

			:<span style="color:red;">'''Note: Any output data property must be specified as an input field unless you are using the Append action.'''</span>

			;[[Listware for Excel:US:Reporting\|Reporting]]
			:Listware now gives you the option of creating an additional sheet of processing statistics for a completed process.

			;[[Listware for Excel:US:Review Settings\|Review Settings]]
			:Review the settings you have selected and fix any errors. When you are ready, click 'Process!' to process your file.

			;[[Listware for Excel:US:Processing\|Processing]]
			:Processing will display the progess of your data cleansing.

			;[[Listware for Excel:US:Review Results\|Review Results]]
			:Once processing is completed, this step will display. You may take this opportunity to review, restart, or close the process.


	[[Category:Listware for Excel]]		[[Category:Listware for Excel]]

Admin: Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

2014-07-02T18:15:31Z

Created page with "← Listware for Excel Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font..."

New page

[[Listware for Excel:Reference|← Listware for Excel Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''US Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Listware for Excel:US|Overview]]
|-
|[[Listware for Excel:US Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Steps
|-
|[[Listware for Excel:US:Processing Range|Processing Range]]
|-
|[[Listware for Excel:US:Cleansing Operations|Cleansing Operations]]
|-
|[[Listware for Excel:US:Input Columns|Input Columns]]
|-
|[[Listware for Excel:US:Output Columns|Output Columns]]
|-
|[[Listware for Excel:US:Reporting|Reporting]]
|-
|[[Listware for Excel:US:Review Settings|Review Settings]]
|-
|[[Listware for Excel:US:Processing|Processing]]
|-
|[[Listware for Excel:US:Review Results|Review Results]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Software#Listware for Excel|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

[[Category:Listware for Excel]]