Importing data from the workbook

Navigation:  The optical model > Defining Materials > Material types > Imported dielectric function: Fixed data sets >

Importing data from the workbook

Previous pageReturn to chapter overviewNext page

If you have original optical constant data in a spreadsheet format (e.g. in Microsoft Excel) and you want to use them in SCOUT you can import the data via the built-in workbook. In the list of materials, create a new object of type 'Imported dielectric function' and open its window (Edit):

 

import_nk1

 

Use the Workbook|Open workbook command to open the workbook.

Now copy and paste the data to be imported into one of the sheets of the workbook. It should look like this:

 

import_nk6

 

Place the cursor in the upper left corner of data block that you want to read, in this case the cell C5 that contains the first energy value of 2.60 eV:

 

import_nk7

 

Now go back to the new 'Imported dielectric function' object. If the workbook data contain n and k values, use the command Workbook|Import x,n,k and press 'a' to autoscale the graph:

 

import_nk8

 

If the spreadsheet data block contains dielectric function data, use the command Workbook|Import x, real part, imaginary part.

 

Up to now you cannot change the spectral unit if you import data from the workbook. This will be improved soon. Use the possibility to import data from text files if your spectral unit does not match the unit of the 'Imported dielectric function' object.