Bruker minispec mq20, User Manual, Page: 51 / 86

minispec.exe Software for Diagnostic and Service Purposes
E1400912_1_001 51
8.2.3 The Spreadsheet Window
Spreadsheets have a number of functions in the minispec software:
• They allow a clear data input for the preparation of a measurement series.
• They give a listed view of the measurement results.
• They allow the data to be saved and post processed in common file formats (like MS
ACCESS/EXCEL).
• A spreadsheet will be displayed automatically if it is implemented in the loaded
application.
8.2.3.1 Execution of Spreadsheets
Normally the tables are executed after RUN is selected, beginning from row one to the end of
the entries. But you can also measure single rows of the table by marking these lines and
then selecting
RUN . This may be useful if not all samples are prepared at the beginning of
the analysis or if several measurements should be repeated.
8.2.3.2 Saving Spreadsheets
Spreadsheet data are saved automatically every time an entry is changed and any time the
ENTER key is pressed. The filename is generated by the minispec software:
<application>\MMMYY\DD\hh\mm\ss.mdb with:
<application> : path of the current application
MMM : month (Jan, Feb, Mar,..., Nov, Dec)
JJ : year (99, 00, 01, ...)
DD : day (01, 02, ..., 31)
hh : hour (00, 01, ...23)
mm : minute (00, 01, ..., 59)
ss : second (00, 01, ..., 59)
Saving in ASCII-format
The files can be saved alternatively in ASCII-format by using the Save or Save Copy As
commands. The file name will be prompted in a standard file selector box, and the file
extension used is *
.tab . The first row of the data includes the headlines of the spreadsheet,
the columns are spaced with a <TAB>. The ASCII tables can also be opened with standard
text editors like NOTEPAD/WORDPAD or MS-EXCEL.
8.2.3.3 Monitoring
During a measurement the spreadsheet is updated by the minispec software every time a
result is added. The tables can be opened on the measurement PC or any other PC
equipped with the minispec.exe software or MS-ACCESS 2013. External monitoring of the
measurement results via a network connection is therefore possible.