Difference between revisions of "Listware for Excel:Best Practices"

From Melissa Data Wiki
Jump to navigation Jump to search
Line 9: Line 9:
BP_XLPW_002
BP_XLPW_002


Save as xls or xlsx to be able to save the background colors of the cells and the comments on the fields that Personator appends.
As with most applications, it is good practice to periodically save your work. If you have opened a different file type, save as xls or xlsx to be able to save the background colors of the cells and the comments on the fields that the Personator web service appends to your Listware for Excel spreadsheet. Save the active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost.
 
Save active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost.




Line 19: Line 17:
For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes
For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes


poat-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the  
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


process significantly.
resulting in a crash.




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

Revision as of 14:39, 23 January 2014

Upgrade to latest .NET

BP_XLPW_001

Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins


Saving Output Results

BP_XLPW_002

As with most applications, it is good practice to periodically save your work. If you have opened a different file type, save as xls or xlsx to be able to save the background colors of the cells and the comments on the fields that the Personator web service appends to your Listware for Excel spreadsheet. Save the active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost.


Optimizing Speed

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.