Understanding the Excel File

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 Surface 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.

Note: The excel file replaces the management of the facets by group. Thus you cannot create groups when the Excel definition is activated.

Excel File Compatibility with Optical Surface Parameters

The Excel file is compatible with the following types of Optical Surface. All others types not mentioned in the table are not compatible.


Optical Surface	Beam	Parameters displayed in Excel
Rectangular	Radii	X radius Y radius Focal (used in case of a Parabolic support) X Center (used in case of a Parabolic support) Y Center (used in case of a Parabolic support) Shift (used in case of a Freeform support)
Rectangular	Freeform	X start X end Y start Y end X spread Y spread Focal (used in case of a Parabolic support) X Center (used in case of a Parabolic support) Y Center (used in case of a Parabolic support) Shift (used in case of a Freeform support)
Circular	Radii	Radial radius Start radius End radius Focal (used in case of a Parabolic support) X Center (used in case of a Parabolic support) Y Center (used in case of a Parabolic support) Shift (used in case of a Freeform support) 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.

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 message 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.

Warning: If you create a new Excel file from the definition in Speos, you will not have the modifications you applied directly in the previous used Excel file. You will have to re-type them manually.

Note: We recommend you to define an Excel file of a maximum size of 100x100. A bigger file would affect the performance.