Data filtering for Optimization results
Author: bgood
Creation Date: 7/3/2009 6:40 PM
profile picture

bgood

#1
The new 5.4 optimization tool is a great improvement. I had tried to sweep a large number of settings and generated about 90K results. While could review the results, save and restore the results in a file, I could not import them into Excel. I thought that I would use Excel to filter out results that were not interesting. Unfortunately, Excel will not allow a paste of more than 64K rows. I tried to open the XML file, but Excel complained about not having a Schema. I suspect that you will provide a way to filter results in the future, how can I do this now?

Bryce
profile picture

deepbuyer

#2
excel 2007 does not have 64K row limitation.
profile picture

Eugene

#3
For data over than a couple dozen thousand rows, a database should be used - not a spreadsheet.
profile picture

Cone

#4
I don't know of any plans for filtering, but you can sort the results by column.
profile picture

bgood

#5
Unlike Excel, I only understand Access. However, wouldn't Access require a Schema to be able to read the XML output file or to paste results into a database?
profile picture

Cone

#6
Saving Optimization results to file is designed to provide the ability to re-load those results in Wealth-Lab. XML, though, is designed to be a transportable format, so try googling "import xml access" for some ideas.