If a column contains string data, then the format specification must be S (or S#) and the string data must be contained in single quotes. The format specification is followed by one or more spaces and then the column heading and units for each column. The first character is the type of format and the second character is the number of digits provided for this format. A format specification consists of one or two characters. If the number of columns is a negative number, EES will expect to find the format specification. If the number of rows is a negative number, EES will determine the number of rows of data in the file. TXT data needed for a Lookup file with five rows and three columns, with no column header information. Automatic formatting is used to display the data if the file is read into the Lookup Table with the Open Lookup Table command. and these column names should be used when the file is used with the Interpolate or Differentiate commands. EES assigns the names "COLUMN1', 'COLUMN2', etc. The basic form does not provide a means of specifying the names, units, or display format for the data. Each following line provides the data for one row with the value for each column separated by one or more spaces or a tab character. In the basic form, the first line of the file contains the number of rows and columns in the table. LKT64 file format can only be read or written by the 64-bit version of EES. The file is opened internally (without needing the Lookup table) when commands such as Interpolate, Lookup etc. However, it is not necessary to open the file in order to access the data in the file. LKT file format is used by 32-bit versions of EES. Once created, the Lookup file can be opened into the Lookup Table window using the Open Lookup Table menu command, the $OPENLOOK directive, or a Link button (type 6) on the Diagram window. A binary Lookup file is created using the Save Lookup Table command or with the $SaveTable directive. Details for each file type follow:īinary Lookup files store all of the information that appears in a Lookup Table window in a binary file on disk, including the data, and the column name, units, and display format for each file type. The ASCII form is easier to edit and it can be read and written by spreadsheet or other applications. The binary form is read in more quickly and it requires smaller file sizes. Each file format has advantages and disadvantages. EES recognizes both binary and ASCII forms for Lookup files. The only difference is that the name of the file (with the file name extension) is provided to the command instead of the name of the table. Lookup files can be accessed by the Differentiate, Interpolate, Lookup, LookupCol, and LookupRow, SumLookup, AvgLookup, MinLookup, MaxLookup, and StdDevLookup commands in the same manner as for Lookup tables. A name and display format for each column of data may also be stored, depending on the file format. A Lookup file is a two-dimensional table of data that has been stored in a disk file.