Excel notes

04/21/2005

Excel Notes

(Lispix text data for export to Excel is ASCII, tab delimited.)

* This presumably should work with other spreadsheets and plotting programs, but I have not tested it.

Excel does not like double float format: 1234.5d2

All floats are converted to single float format: 1.23456e+12, or 1234.56.

Excel sometimes does not like 'nil' or ' ', which it treats as strings:
A scatterplot goofs up if some cells have these values.
(Nil values sort to the bottom.)
Lispix exports nil values for plots as "" (between the tabs which separate columns).
For spreadsheets, nil values are 'nil'. 3/13/2003
Scatterplots seem to work ok on nil values in spreadsheets exported from Lispix. I don't know why this difference.