Dear Community,

I was trying to make the drawing for fabrication of  a binary surface. To get the sag and zone radius of the binary surface I am using "DoeSag.zpl" macro as given in this ZEMAX article.

I have also made an excel sheet to convert ZEMAX phase coefficient to the coefficient that will be provided to manufacturer. But the value specified in ZEMAX after running DoeSag.zpl is not same as what I am getting from excel sheet. I have checked my excel formulas several times and it is working fine for another DOE (excel and ZEMAX values are matching).

What could be the reason for this?

Thanks.