Forensic mathematics home page
|
Specifically, the log report has boxes around some answers, but the attractive box lines
usually turn into ugly strings of odd characters such as In particular I use these settings:
Another way to get the
So what we are doing with the DNAVIEW character translations is to set
up a partial conversion from PC-8 to ECMA-94 at the time that reports
are exported. The box drawing characters are missing from ECMA-94, so
we need to eliminate them.
The standard report is never shown on the DNA·VIEW screen, but is automatically
(depending on certain
The character translations mechanism discussed above doesn't apply to the
standard report. That may be a design error but a small one there are no box
drawing characters in the standard report, and Excel can handle the
Magnificent Excel Report Viewer toolI leave this section in place for reference and explanation, but the steps described are obsolete because an Excel macro to painlessly import for you is freely available. |
reports
folder within the dnaview
folder, and named something like kin160.txt
.
Excel import caveatsExcel does a few funny things if you simply accept the default behavior of the Text Import Wizard that is, if you immediately click "Finish."
|
Watch the import wizard closely. Select "Open", Files of type "text" and choose the file you want.
A this step we tell Excel that all the columns are Text rather than General, so Excel is therefore not allowed to make the mistakes in the sidebar.
The column headings won't line up with their columns because the default Word tab settings aren't wide enough for some of the wide columns. Therefore you need to adjust the tabs. Personally I find this difficult and tricky, but anyone reasonably proficient with Word should handle it easily.