The following procedure shows how to create and use and Excel file that allows you to drive the
parameters of each facet of the Optical Surface individually.
To create and use an Excel file:
Prerequisites:
An Optical Surface Rectangular or Circular must already be defined.
No group must have been created. Only the Ungrouped Elements must be present.
Make sure the Optical Surface is compatible with the Excel file definition.
From the Design panel, open the Optical Surface.
If you want, modify the parameters related to the facets in the Style and
Ungrouped Elements definitions.
The Style and Ungrouped Elements parameters
corresponds to those who will be created and applied when you create the Excel file.
Open the main node of the Optical Surface.
In the main node definition, from the Excel file drop-down list, click
Create Excel.
An Excel file is created based on the input parameters set in the Style and Ungrouped Elements
definition.
The Excel file opens automatically upon creation.
If you had already created the Excel File (automatic opening of the file already done), from the
Excel file drop-down list, click Open file.
Important: For Speos to know that you modified the Excel file, you
must open the file from here. Otherwise, if you open the file outside of the interface, Speos cannot detect if you modified it.
Modify the Excel file as you want.
In the Excel file, each sheet correspond to a parameter and each cell in a sheet corresponds to
one specific facet of the Optical Surface.
Tip: To find the match between a cell in the Excel file and its facet in the 3D view,
you can hover over the feature. This will give you the cell coordinates.
Save the Excel file.
In Speos, click Compute
to generate the Optical Surface and take
into account the changes.
The Optical Surface is generated and built in the 3D view.