Listware for Excel:Best Practices - Revision history

Oscar at 19:26, 27 October 2014

2014-10-27T19:26:35Z

← Older revision		Revision as of 19:26, 27 October 2014
Line 20:		Line 20:
	* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.		* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.
	* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.		* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.


	==Crashing on very large processing runs.==		==Crashing on very large processing runs.==

Oscar: /* Optimizing Speed */

2014-10-27T19:14:22Z

Optimizing Speed

← Older revision		Revision as of 19:14, 27 October 2014
Line 17:		Line 17:
	BP_XLPW_003		BP_XLPW_003

	* For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes post-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the process significantly. For larger runs on older machines, using these options ~~use~~ extensive memory resources resulting in a crash.		* For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes post-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the process significantly. For larger runs on older machines, using these options uses extensive memory resources resulting in a crash.
	* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.		* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.
	* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.		* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.

Oscar: /* Optimizing Speed */

2014-10-27T19:14:05Z

Optimizing Speed

← Older revision		Revision as of 19:14, 27 October 2014
Line 17:		Line 17:
	BP_XLPW_003		BP_XLPW_003

	* For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes post-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the process significantly. For larger runs on older machines, using these options ~~can also~~ use memory resources ~~than can be allocated~~ resulting in a crash.		* For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes post-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the process significantly. For larger runs on older machines, using these options use extensive memory resources resulting in a crash.
	* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.		* Don't perform unnecessary actions. Not only will unnecessary options consume more credits, but operations like verify and append, for example, check a much larger amount of our source data, therefore consume more resources.
	* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.		* Don't process your entire sheet. Its easier to select an entire sheet, but if only a specific range of the active table is missing data or needs updating, just specify that range.


	==Crashing on very large processing runs.==		==Crashing on very large processing runs.==

Admin at 21:04, 25 September 2014

2014-09-25T21:04:00Z

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

	==Upgrade to latest .NET==		==Upgrade to latest .NET==

Admin at 21:03, 25 September 2014

2014-09-25T21:03:46Z

← Older revision		Revision as of 21:03, 25 September 2014
Line 1:		Line 1:
			[[Listware for Excel\|← Listware for Excel]]
	[[Listware for Excel\|~~Back to~~ Listware ~~Main Page~~]]

	==Upgrade to latest .NET==		==Upgrade to latest .NET==
Line 45:		Line 44:

	When you use Express Entry (Data Entry Mode), Listware will prompt you to configure optimal column settings. Once you place the focus back on the sheet (to edit for example), you have overridden the configuration, and therefore bottom of sheet insertion. We recommend once you open Express Entry, you stay in that mode until data entry is complete, and do not jump back and forth from excel edit mode.		When you use Express Entry (Data Entry Mode), Listware will prompt you to configure optimal column settings. Once you place the focus back on the sheet (to edit for example), you have overridden the configuration, and therefore bottom of sheet insertion. We recommend once you open Express Entry, you stay in that mode until data entry is complete, and do not jump back and forth from excel edit mode.


	[[Category:Best Practices]]		[[Category:Best Practices]]
			[[Category:Listware for Excel]]

Admin: Admin moved page Best Practices:Excel PlugIns to Listware for Excel:Best Practices without leaving a redirect

2014-05-01T22:14:00Z

Admin moved page Best Practices:Excel PlugIns to Listware for Excel:Best Practices without leaving a redirect

← Older revision	Revision as of 22:14, 1 May 2014
(No difference)

Tim at 19:40, 21 March 2014

2014-03-21T19:40:38Z

← Older revision		Revision as of 19:40, 21 March 2014
Line 32:		Line 32:
	* Use 64-bit Office instead of 32-bit.		* Use 64-bit Office instead of 32-bit.
	* Use a newer versions of Excel (2010 and up).		* Use a newer versions of Excel (2010 and up).


	==Printing Reports==		==Printing Reports==

Tim: /* Crashing on very large processing runs. */

2014-03-21T19:40:19Z

Crashing on very large processing runs.

← Older revision		Revision as of 19:40, 21 March 2014
Line 25:		Line 25:
	BP_XLPW_004		BP_XLPW_004

	See Optimizing ~~Excel~~ (above)		See Optimizing Speed (above). The same suggestions ensure a more stable process.

	The old adage that newer is better, performance-wise applies here...		The old adage that newer is better, performance-wise applies here...

Tim: /* Crashing on very large processing runs. */

2014-03-21T19:39:20Z

Crashing on very large processing runs.

← Older revision		Revision as of 19:39, 21 March 2014
Line 24:		Line 24:
	==Crashing on very large processing runs.==		==Crashing on very large processing runs.==
	BP_XLPW_004		BP_XLPW_004

			See Optimizing Excel (above)

	The old adage that newer is better, performance-wise applies here...		The old adage that newer is better, performance-wise applies here...
Line 30:		Line 32:
	* Use 64-bit Office instead of 32-bit.		* Use 64-bit Office instead of 32-bit.
	* Use a newer versions of Excel (2010 and up).		* Use a newer versions of Excel (2010 and up).


	==Printing Reports==		==Printing Reports==

Tim: /* Printing Reports */

2014-03-12T15:56:47Z

Printing Reports

← Older revision		Revision as of 15:56, 12 March 2014
Line 38:		Line 38:
	*By selecting only the Reporting Options you need, your Output will have a more concise ready to print report that requires no editing in Excel.		*By selecting only the Reporting Options you need, your Output will have a more concise ready to print report that requires no editing in Excel.


			==Express Entry Mode==
			BP_XLEE_001

			When you use Express Entry (Data Entry Mode), Listware will prompt you to configure optimal column settings. Once you place the focus back on the sheet (to edit for example), you have overridden the configuration, and therefore bottom of sheet insertion. We recommend once you open Express Entry, you stay in that mode until data entry is complete, and do not jump back and forth from excel edit mode.

	[[Category:Best Practices]]		[[Category:Best Practices]]