Listware for Excel:Business Coder Tutorial - Revision history

Admin at 23:35, 27 December 2019

2019-12-27T23:35:20Z

← Older revision		Revision as of 23:35, 27 December 2019
Line 32:		Line 32:
	Choose which options you require.		Choose which options you require.

	For more information on Melissa Data Credits, please see [~~http~~://www.~~melissadata~~.com/~~dqt~~/~~credit-summary.htm~~ Credit Costs].		For more information on Melissa Data Credits, please see [https://www.melissa.com/pricing/listware Credit Costs].

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

Admin at 22:20, 19 December 2016

2016-12-19T22:20:11Z

← Older revision		Revision as of 22:20, 19 December 2016
Line 5:		Line 5:
	[[File:LWE_BusinessCoder_Button.png\|link=]]		[[File:LWE_BusinessCoder_Button.png\|link=]]

	After you install Listware and set your ~~Customer~~ License Key, you are ready to use Listware.		After you install Listware and set your License Key, you are ready to use Listware.
	Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.		Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.

Admin at 22:19, 19 December 2016

2016-12-19T22:19:55Z

← Older revision		Revision as of 22:19, 19 December 2016
Line 5:		Line 5:
	[[File:LWE_BusinessCoder_Button.png\|link=]]		[[File:LWE_BusinessCoder_Button.png\|link=]]

	After you install Listware and set your Customer License ~~String~~, you are ready to use Listware.		After you install Listware and set your Customer License Key, you are ready to use Listware.
	Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.		Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.

Admin at 20:54, 9 June 2016

2016-06-09T20:54:38Z

← Older revision		Revision as of 20:54, 9 June 2016
Line 24:		Line 24:
	Choose what data you want to use by click-dragging a box around it and clicking the 'Select Data to Process' button.		Choose what data you want to use by click-dragging a box around it and clicking the 'Select Data to Process' button.

	[[File:~~LWE_BusinesCoder_Tutorial_SelectData~~.png\|link=]]		[[File:LWE_BusinessCoder_Tutorial_SelectData.png\|link=]]

	Once your data has been selected, click 'next' to move on to the Cleansing Operations step.		Once your data has been selected, click 'next' to move on to the Cleansing Operations step.

Admin at 20:50, 9 June 2016

2016-06-09T20:50:05Z

← Older revision		Revision as of 20:50, 9 June 2016
Line 13:		Line 13:


	==Select US==		==Select Business Coder==
	Select the Listware Ribbon followed by the Business Coder button.		Select the Listware Ribbon followed by the Business Coder button.

Admin: Created page with "{{LWEBusinessCoderNav}} {{CustomTOC}} link= After you install Listware and set your Customer License String, you are ready to use List..."

2016-06-07T17:57:27Z

Created page with "{{LWEBusinessCoderNav}} {{CustomTOC}} link= After you install Listware and set your Customer License String, you are ready to use List..."

New page

{{LWEBusinessCoderNav}}

{{CustomTOC}}

[[File:LWE_BusinessCoder_Button.png|link=]]

After you install Listware and set your Customer License String, you are ready to use Listware.
Follow along with the steps below to perform a sample cleansing on a data set with Business Coder.

==Open a Spreadsheet==
Open a spreadsheet containing your data in Excel.

==Select US==
Select the Listware Ribbon followed by the Business Coder button.

[[File:LWE_BusinessCoder_Tutorial_Select.png|link=]]

The Business Coder panel will open.

==Select Data==
Choose what data you want to use by click-dragging a box around it and clicking the 'Select Data to Process' button.

[[File:LWE_BusinesCoder_Tutorial_SelectData.png|link=]]

Once your data has been selected, click 'next' to move on to the Cleansing Operations step.

==Choose Options==
Choose which options you require.

For more information on Melissa Data Credits, please see [http://www.melissadata.com/dqt/credit-summary.htm Credit Costs].

[[File:LWE_BusinessCoder_Tutorial_Options.png|link=]]

Click 'next' to continue on to the Input Columns step.

==Input Columns==
Specify the input columns you want to process.

For example, if your data has Company, Address, City, State, ZIP, and Phone, you should map these columns by selecting the column in the drop-down boxes next to its corresponding column.

[[File:LWE_BusinessCoder_Tutorial_InputColumns.png|link=]]

Once your input columns have been mapped, click 'next' to continue on to the Output Columns step.

==Output Columns==
Specify what data you want to output.

[[File:LWE_BusinessCoder_Tutorial_OutputColumns.png|link=]]

Once your output data has been chosen, click 'next' to continue to the Reporting step.

==Reporting==
Specify if you want a report created and the contents of that report.

When processing is completed, you have the option of having a new sheet created and inserted immediately following the processed sheet. This reporting sheet will contain statistics and settings summarizing the processing run.

[[File:LWE_BusinessCoder_Tutorial_Reporting.png|link=]]

Once you choose what reports you want, click 'next' to continue to the Review Settings step.

==Finalize Settings==
Review and finalize your settings.

If there are any warnings, they will be listed here. These will need to be resolved before you can process the data.

[[File:LWE_BusinessCoder_Tutorial_Finalize.png|link=]]

Click 'Process!' to begin processing your file. A progress bar will be displayed.

Note: It is strongly recommended that you refrain from editing your spreadsheet while Listware is processing.

==Processing Complete==
Once processing is complete you can 'Map' the data points, 'Restart', or 'Close' the process.

[[File:LWE_BusinessCoder_Tutorial_ProcessingComplete.png|link=]]

*Map will map the data points on a web page.
*Restart will run the process again.
*Close will close the side bar.

==Review==
If you chose to create a report in Reporting, you will have a Listware Reporting sheet you can navigate to in your excel book.

[[File:LWE_BusinessCoder_Tutorial_Review.png|link=]]

Here you will see a detailed breakdown of your data and the cleansing process.

==Save==
When you are satisfied with your data, use the Excel menu to save your spreadsheet.

[[Category:Listware for Excel]]