clear

Clears the workbook. After this action there is only one empty worksheet.

rename sheet, sheet index, new name

Renames the sheet with the specified index

append sheet

Appends an empty worksheet

save fit parameter names, worksheet name, row, column

Writes the names of the fit parameters downwards, starting at the given row and column in the specified worksheet

save fit parameter values,worksheet name, row, column

Writes the values of the fit parameters downwards, starting at the given row and column in the specified worksheet

measurement series save fit parameter values,worksheet name, row, column

Writes the values of the fit parameters downwards, starting at the given row in the specified worksheet. The start column  is given as the sum of the specified column value and the series index of the last measurement.

4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement.

measurement series average fit parameter values

Computes and writes the average of the fit parameters for all measurements to the given row in the specified worksheet. The values are written to the column which is computed as the sum of the specified value, the number of measurements of the series and 1.

4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement.

save final number names, worksheet name, row, column, first index, last index

Writes final number names to the given worksheet, starting in the specified row and column. This routine does not write all names but only those with indices between the given first and last index.

save final number values, worksheet name, row, column, first index, last index

Writes final number values to the given worksheet, starting in the specified row and column. This routine does not write all values but only those with indices between the given first and last index.

measurement series save final number values, worksheet name, row, column, first index, last index

Writes final number values to the given worksheet, starting in the specified row. The column is the sum of the specified column and the index of the last performed measurement of the series. This routine does not write all values but only those with indices between the given first and last index.

4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement.

measurement series average final number values, worksheet name, row, column, first index, last index

Writes the average of final number values for a measurement series to the given worksheet in the specified row. The column is the one to the right of the last performed measurement of the series. This routine does not write all values but only those with indices between the given first and last index.

4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement.

save optical function names, worksheet name, row, column

Writes the names of the fit parameters downwards, starting at the given row and column in the specified worksheet

save optical function values, worksheet name, row, column

Writes the values of the fit parameters downwards, starting at the given row and column in the specified worksheet

measurement series save optical function values

Writes the values of the optical functions downwards, starting at the given row in the specified worksheet. The start column  is given as the sum of the specified column value and the series index of the last measurement.

4 cells above the selected row are filled as well with date, product name, sample name and index of the last measurement.

measurement series average optical function values

Computes and writes the average of the fit parameters for all measurements to the given row in the specified worksheet. The values are written to the column which is computed as the sum of the specified value, the number of measurements of the series and 1.

4 cells above the selected row are filled as well with the date, the product name, the sample name and the index of the last measurement.

set column width, worksheet name, column, width

Sets the width (in pixels) of the specified column of the given worksheet

write cell number,expression for cell number, worksheet name, expression for cell row, expression for cell column

Writes a number to the worksheet of the given name. The number is obtained by evaluating the given expression. Both row and column are computed by the given expressions, rounding the outcome to an integer number. All expressions can use master parameters, optical functions and fit parameters. In CODE you can use integral quantities as well.

write cell text,the text, worksheet name, expression for cell row, expression for cell column

Writes text to the worksheet of the given name. Both row and column are computed by the given expressions, rounding the outcome to an integer number. The expressions can use master parameters, optical functions and fit parameters. In CODE you can use integral quantities as well.