15 October 2013 Using Microsoft Excel as a pre-processor for CODE V optimization of air spaces when building camera lenses
Author Affiliations +
Proceedings Volume 8884, Optifab 2013; 88841E (2013) https://doi.org/10.1117/12.2029340
Event: SPIE Optifab, 2013, Rochester, New York, United States
When building high-performance camera lenses, it is often preferable to tailor element-to-element air spaces instead of tightening the fabrication tolerances sufficiently so that random assembly is possible. A tailored air space solution is usually unique for each serial number camera lens and results in nearly nominal performance. When these air spaces are computed based on measured radii, thickness, and refractive indices, this can put a strain on the design engineering department to deal with all the data in a timely fashion. Excel may be used by the assembly technician as a preprocessor tool to facilitate data entry and organization, and to perform the optimization using CODE V (or equivalent) without any training or experience in using lens design software. This makes it unnecessary to involve design engineering for each lens serial number, sometimes waiting in their work queue. In addition, Excel can be programmed to run CODE V in such a way that discrete shim thicknesses result. This makes it possible for each tailored air space solution to be achieved using a finite number of shims that differ in thickness by a reasonable amount. It is generally not necessary to tailor the air spaces in each lens to the micron level to achieve nearly nominal performance.
© (2013) COPYRIGHT Society of Photo-Optical Instrumentation Engineers (SPIE). Downloading of the abstract is permitted for personal use only.
Dave Stephenson, Dave Stephenson, "Using Microsoft Excel as a pre-processor for CODE V optimization of air spaces when building camera lenses", Proc. SPIE 8884, Optifab 2013, 88841E (15 October 2013); doi: 10.1117/12.2029340; https://doi.org/10.1117/12.2029340

Back to Top