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
Size:
Color:
excel 2007 does not have 64K row limitation.
Size:
Color:
For data over than a couple dozen thousand rows, a database should be used - not a spreadsheet.
Size:
Color:
I don't know of any plans for filtering, but you can sort the results by column.
Size:
Color:
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?
Size:
Color:
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.
Size:
Color: