Listware for Excel:Capabilities - Revision history

Admin at 00:30, 29 June 2023

2023-06-29T00:30:35Z

← Older revision		Revision as of 00:30, 29 June 2023
Line 13:		Line 13:
	*Email Addresses		*Email Addresses
	*Append Geo-coordinates		*Append Geo-coordinates

	~~===MatchUp===~~
	*Record Matching using basic datatype matching strategies.
	*Processed lists can be evaluated in many ways…
	**Result Codes. Group Identifier and Group Count appended to each record allow you to easily analyze, group or remove identified duplicate records
	**The Processing Results output window allows you to redefine records as Output or Duplicate status
	**Choose to output cell color for alternating duplicate groups
	**Commit identified groups to a new sheet or append to the existing sheet

	===SmartMover NCOA===		===SmartMover NCOA===

Admin at 19:50, 15 September 2016

2016-09-15T19:50:27Z

← Older revision		Revision as of 19:50, 15 September 2016
Line 13:		Line 13:
	*Email Addresses		*Email Addresses
	*Append Geo-coordinates		*Append Geo-coordinates

			===MatchUp===
			*Record Matching using basic datatype matching strategies.
			*Processed lists can be evaluated in many ways…
			**Result Codes. Group Identifier and Group Count appended to each record allow you to easily analyze, group or remove identified duplicate records
			**The Processing Results output window allows you to redefine records as Output or Duplicate status
			**Choose to output cell color for alternating duplicate groups
			**Commit identified groups to a new sheet or append to the existing sheet

	===SmartMover NCOA===		===SmartMover NCOA===
Line 53:		Line 61:
	*Processing Results Summary, summary table and charts of each action performed		*Processing Results Summary, summary table and charts of each action performed
	*Result Code Summary, Table of total counts for each possible output action		*Result Code Summary, Table of total counts for each possible output action


	~~==In Development==~~
	~~===MatchUp===~~
	*Record Matching (Are there any duplicate records?)



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

Admin at 21:11, 25 September 2014

2014-09-25T21:11:48Z

← Older revision		Revision as of 21:11, 25 September 2014
Line 1:		Line 1:
			[[Listware for Excel\|← Listware for Excel]]
			{{CustomTOC}}

	~~<h3>~~See individual product pages' documentation or Result codes for a complete description of capabilities~~</h3>~~		See individual product pages' documentation or Result codes for a complete description of their respective capabilities.

	~~<span style~~=~~"color:#0000FF">'''~~Domestic US and Canada~~''' </span><br>~~		==Domestic US and Canada==
	* '''Check~~''' -~~ Standardize and ~~correct~~		===Check===
	** Names		Standardize and Correct
	** Addresses
	** Phone Numbers
	** Email Addresses
	** Append Geo-coordinates
	* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

			*Names
			*Addresses
			*Phone Numbers
			*Email Addresses
			*Append Geo-coordinates

	~~<span style~~=~~"color:#0000FF">'''Domestic US only''' </span><br>~~		===SmartMover NCOA===
	* '''Personator Verify''' - correlate the above data types, ie. ~~do they actually belong together~~		Check to see if a Name or associated Company has moved to a new address.

	* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

	* '''Personator ~~Append''' - If a record is verified or~~ data ~~sources may be able to append missing data (fill in the blanks)~~		==Domestic US Only==
			===Personator Verify===
			Correlate the above data types, E.G. Do they actually belong together?

	* '''Express Entry'''		===Personator Move===
	** Real time data entry for any field type		Check to see if a Name or associated Company has moved to a new address.
	** Real time auto-complete and validation for US addresses

			===Personator Append===
			If a record is verified or data sources may be able to append missing data (fill in the blanks.)

	~~'''Reporting'''~~		===Express Entry===
	* ~~Result Codes, the quality and errors associated with each record; appended to each record~~		*Real time data entry for any field type
	* General Processing Summary, the details of processed job		*Real time auto-complete and validation for US addresses
	* ~~Processing Results Summary, summary table~~ and ~~charts of each action performed~~
	* US Check & Verify State Distribution Summary (US only)
	* SmartMover NCOA State & Province Distribution Summary (US ~~& CAN)~~
	* Result Code Summary, Table of total counts for each possible output action

			===Reporting===
			*Result Codes, the quality and errors associated with each record; appended to each record.
			*General Processing Summary, the details of processed job.
			*Processing Results Summary, summary table and charts of each action performed.
			*US Check & Verify State Distribution Summary (US only.)
			*SmartMover NCOA State & Province Distribution Summary (US & CAN.)
			*Result Code Summary, Table of total counts for each possible output action.


	~~<span style~~=~~"color:#0000FF">'''~~For International Data (~~non~~ US or Canada)~~'''</span> <br>~~		==For International Data (Non US or Canada)==
	~~'''~~Global Check~~''' -~~ Standardize and ~~correct~~		===Global Check===
	* Addresses		Standardize and Correct
	* Append Geo-coordinates

	~~'''Reporting'''~~		*Addresses
	* Result Codes, the quality and errors associated with each record; appended to each record		*Append Geo-coordinates
	* General Processing Summary, the details of processed job
	* ~~Processing Results Summary, summary table and charts of each action performed~~
	* ~~Result Code Summary, Table of total counts for each possible output action~~

			===Reporting===
			*Result Codes, the quality and errors associated with each record; appended to each record
			*General Processing Summary, the details of processed job
			*Processing Results Summary, summary table and charts of each action performed
			*Result Code Summary, Table of total counts for each possible output action


	~~<span style~~=~~"color:#0000FF">'''~~In Development~~'''</span> <br>~~		==In Development==
	~~'''~~MatchUp~~'''~~		===MatchUp===
	* Record Matching (Are there any duplicate records?)		*Record Matching (Are there any duplicate records?)



	[[Listware for Excel~~\|Back to Listware Main Page~~]]		[[Category:Listware for Excel]]

Admin: Admin moved page Listware Basics:What can Listware Do? to Listware for Excel:Capabilities without leaving a redirect

2014-09-25T20:33:28Z

Admin moved page Listware Basics:What can Listware Do? to Listware for Excel:Capabilities without leaving a redirect

← Older revision	Revision as of 20:33, 25 September 2014
(No difference)

Tim at 20:20, 23 September 2014

2014-09-23T20:20:01Z

← Older revision		Revision as of 20:20, 23 September 2014
Line 47:		Line 47:


			<span style="color:#0000FF">'''In Development'''</span> <br>


	'''In Development''' <br>
	'''MatchUp'''		'''MatchUp'''
	* Record Matching (Are there any duplicate records?)		* Record Matching (Are there any duplicate records?)

Tim at 20:17, 23 September 2014

2014-09-23T20:17:58Z

← Older revision		Revision as of 20:17, 23 September 2014
Line 28:		Line 28:
	* General Processing Summary, the details of processed job		* General Processing Summary, the details of processed job
	* Processing Results Summary, summary table and charts of each action performed		* Processing Results Summary, summary table and charts of each action performed
	* State Distribution Summary (US only)		* US Check & Verify State Distribution Summary (US only)
			* SmartMover NCOA State & Province Distribution Summary (US & CAN)
	* Result Code Summary, Table of total counts for each possible output action		* Result Code Summary, Table of total counts for each possible output action

Tim at 19:50, 23 September 2014

2014-09-23T19:50:02Z

← Older revision		Revision as of 19:50, 23 September 2014
Line 13:		Line 13:

	<span style="color:#0000FF">'''Domestic US only''' </span><br>		<span style="color:#0000FF">'''Domestic US only''' </span><br>
	* '''Verify''' - correlate the above data types, ie. do they actually belong together		* '''Personator Verify''' - correlate the above data types, ie. do they actually belong together

	* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address		* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

	* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)		* '''Personator Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

	* '''Express Entry'''		* '''Express Entry'''

Tim at 19:49, 23 September 2014

2014-09-23T19:49:27Z

← Older revision		Revision as of 19:49, 23 September 2014
Line 9:		Line 9:
	** Email Addresses		** Email Addresses
	** Append Geo-coordinates		** Append Geo-coordinates
			* '''SmartMover NCOA''' - check to see if a Name or associated Company has moved to a new address

Tim at 19:47, 23 September 2014

2014-09-23T19:47:03Z

← Older revision		Revision as of 19:47, 23 September 2014
Line 18:		Line 18:
	* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)		* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

	* '''Express Entry''		* '''Express Entry'''
	** Real time data entry for any field type		** Real time data entry for any field type
	** Real time auto-complete and validation for US addresses		** Real time auto-complete and validation for US addresses

Tim at 19:46, 23 September 2014

2014-09-23T19:46:45Z

← Older revision		Revision as of 19:46, 23 September 2014
Line 14:		Line 14:
	* '''Verify''' - correlate the above data types, ie. do they actually belong together		* '''Verify''' - correlate the above data types, ie. do they actually belong together

	* '''Move''' - check to see if a Name or associated Company has moved to a new address		* '''Personator Move''' - check to see if a Name or associated Company has moved to a new address

	* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)		* '''Append''' - If a record is verified or data sources may be able to append missing data (fill in the blanks)

	~~<span style="color:#0000FF">~~'''Express Entry''~~'</span> <br>~~		* '''Express Entry''
	* Real time data entry for any field type		** Real time data entry for any field type
	* Real time auto-complete and validation for US addresses		** Real time auto-complete and validation for US addresses