Using Microsoft Excel as a pre-processor for CODE V optimization of air spaces when building camera lenses

Dave Stephenson

doi:10.1117/12.2029340

15 October 2013 Using Microsoft Excel as a pre-processor for CODE V optimization of air spaces when building camera lenses

Dave Stephenson

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

Abstract

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.

Citation Download Citation

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); https://doi.org/10.1117/12.2029340

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

;

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE