Skip to main content

Description

Output of the macro with some additional post-processing in Excel

This macro may be used as a basis for gathering field-by-field ray data in equal steps across the pupil. In this macro, the angle of incidence on a surface is reported but the operand may be changed to any that uses normalized ray coordinates. 

 

Language

ZPL

Download 

  

Click here to download the ZPL version

Click here to download the Excel API version
Date Version OpticStudio Version Comment
2019/12/10 1.0 19.8 Creation
2020/09/20 1.1 20.2 Updates for OpticsTalk+Envision.
Cleaning up the output. Additionally, a reformatted version has been made available which splits the calculation into child/parents macros.

 

For the same purpose, the ray data can be retrieved through the interactive connection between ZOS-API & Excel.

 

Description:

  1. Set customize ribbon (File>Options) to enable Developer tab in Excel
  2. Open VBA trhough Developer> Visual Basic
  3. It is required to load the ZOS-API assembly at the beginning. The macros can be checked from VBAProject> Modules 

200924-161211-image.png200924-165057-image.png

 

  1. Open the attached Exel file (with macro included), the Connect button and Surface Data button are linked to different macros. 

200924-163104-image.png

  1. Click Interactive Extension, then the connect button. A message box will pop up and show the connected message. 

200924-163748-image.png

  1. Click Surface Data button, LDE and FDE data of the current active lens file will be extracted 

200924-164042-image.png

  1. Click any surface button from the generated surface button list, incident angles of rays on the target surface that tracing across the whole pupil from specific field will be retrieved and displayed on a newly opened sheet.  

200924-164644-image.png

 

Language:

ZOS-API: Excel

Download link:

Download

Reply


Community Posting GuidelinesCookie settings


Zemax Community

Need more help?

To Chinese users:

Do not provide any information or data that is restricted by applicable law, including by the People’s Republic of China’s Cybersecurity and Data Security Laws ( e.g., Important Data, National Core Data, etc.).


不要提供任何受适用法律，包括中华人民共和国的网络安全和数据安全法限制的信息或数据（如重要数据、国家核心数据等）。



Privacy policy   License Agreements    Terms of use    Cookie Policy   Zemax Account Licensing Policies