Excel

This menu allows conversion of the LOG files into the *.xls or *.csv format, for further processing in any desired spreadsheet program supporting these formats. This allows the creation of graphics and statistics using the recorded measurements. To adjust the generated table to suit the language-specific requirements, a comma or a full-stop can be specified as the decimal separator when generating the *.csv file.
The created files are stored as daily or monthly data in the corresponding Winsol subdirectory (“…\Excel“). As with the LOG files, the name of the generated file contains information on the date of the measurements it contains. For example, the day file „E100609.csv“ contains measurements acquired on 09th June 2010. An existing file of the same name is overwritten. A month file E1006 contains the measurement data for the month June 2010.

When logging data from two controllers or frames Winsol generates files in three directories (“…\Excel“, “…\Excel1“ and “…\Excel2“) with a combined data record in one directory and the respective separate data records in the other two directories. However in the *.xls file format only a maximum of 2 controllers or data frames can be saved in the same file.
If more than 2 data frames are to be logged, it is therefore advisable to create *.csv files, as here up to 8 possible frames can be stored for the same data record in the directory „…/Excel“. Subsequently individual files are likewise created for each data frame in the appropriate number of directories.