Understanding the Excel File
The following page helps you understand the use of an Excel file in the definition of an Optical Lens.
Description
The Excel file is an input file that allows you to drive every parameter that you can drive in a group for every facet of the Optical Lens individually. Basically the Excel file represents every facet of the feature as if one face = one group. It saves you from creating lots of groups in the Speos interface and allows you to quickly modify each parameter for each facet so that you can create a smooth evolution of the parameters value along the feature.
Excel File Compatibility with Optical Lens Parameters
The Excel file is compatible with the following types of Optical Lens. All others types not mentioned in the table are not compatible.
Optical Lens | Beam | Parameters displayed in Excel |
---|---|---|
Rectangular | Radii |
|
Rectangular | Prism |
|
Rectangular | Pyramid |
|
Rectangular | Freeform |
|
Circular | Radii |
Important:
The behavior of radii pillows in circular is different between a definition by group and a definition using an Excel file.
When using the Excel File definition, the radii pillows are built according to the values written in the Excel. They are not built according to a ratio of the position between the Start radius and End radius values. |
Circular | Prism |
|
Circular | Pyramid |
|
Circular | Freeform |
|
Excel File Format
Each sheet corresponds to a parameter driving the facets.
Each cell corresponds to a facet in the 3D view.
Each cell can be defined use a formula or a macro. Speos will only interpret the result of the formula or the macro.
If a cell is empty in the Excel file, Speos will use the value from the Speos definition.
If a sheet does not exist for a parameter or a grid value, an error is raised suggesting you to create a new valid excel file. If you use the Excel file with the missing sheet, then the parameter values from the Ungrouped Elements will be used to replace the missing sheet.