{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Diffraction-Limited Spot","Div Angle, Max Waist","Beam Diameter Distance","f-Number","Optical Invariant"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Diffraction-Limited Spot","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,12,5,16],[3,0,6,0],[0,2,0,10],[2,2,2,3],[2,6,2,7],[2,10,4,10],[6,10,8,10]]}
[null,null,"Diffraction-Limited Spot Calculation"]
[]
[null,null,"Spot Diameter",null,null,null,"Focal Length",null,null,null,"Equation for Spot Diameter",null,"Note: It is recommended to download and open this file in the Excel desktop application, as some features are not supported in the web version of Excel. "]
["This calculator can be used to calculate the diffraction-limited spot diameter of a beam. These equations assume a round, Gaussian input beam.",null,"Focal Length (mm)",50,null,null,"Spot Diameter (µm)",4.5]
[null,null,"Input Beam Diameter (mm)",2,null,null,"Input Beam Diameter (mm)",0.7]
[null,null,"Wavelength (nm)",780,null,null,"Wavelength (nm)",633]
[null,null,null,null,null,null,null,null,null,null,"Equation for Focal Length"]
[null,null,"Spot Diameter (µm)",{"$f":"(4*D4*(D6/1000))/(D5*PI())","v":24.828171122335672},null,null,"Focal Length (mm)",{"$f":"H4*H5*PI()/(4*(H6/1000))","v":3.9083794861010457}]
["Inputs (Can Be Changed)"]
["Outputs (Cannot Be Changed)"]
[null,null,null,null,null,null,null,null,null,null,"Parameters"]
[null,null,null,null,null,null,null,null,null,null,"d = Spot Diameter"]
[null,null,null,null,null,null,null,null,null,null,"λ = Wavelength"]
[null,null,null,null,null,null,null,null,null,null,"f = Focal Length"]
[null,null,null,null,null,null,null,null,null,null,"D = Input Beam Diameter"]

{"sheet":"Div Angle, Max Waist","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,10],[2,2,2,3],[2,6,2,7],[3,0,6,0],[2,12,5,16]]}
[null,null,"Full Divergence Angle and Maximum Waist Distance"]
[]
[null,null,"Full Divergence Angle",null,null,null,"Maximum Waist Distance",null,null,null,"Equation for Full Divergence Angle (in degrees)",null,"Note: It is recommended to download and open this file in the Excel desktop application, as some features are not supported in the web version of Excel. "]
["This calculator can be used to calculate the full divergence angle and maximum waist distance of a beam. These equations assume a Gaussian input beam.",null,"Input Beam Diameter (µm)",3.5,null,null,"Input Beam Diameter (µm)",3.5]
[null,null,"Focal Length (mm)",4,null,null,"Focal Length (mm)",4]
[null,null,null,null,null,null,"Wavelength (nm)",850]
[null,null,"Full Divergence Angle  (°)",{"$f":"(D4/1000)/D5*(180/PI())","v":5.0133807073947032E-2},null,null,null,null,null,null,"Equation for Maximum Waist Distance"]
[null,null,"Full Divergence Angle (mrad)",{"$f":"D4/D5","v":0.875},null,null,"Maximum Waist Distance (mm)",{"$f":"H5+(2*H5^2*(H6/1000000))/(PI()*(H4/1000)^2)","v":710.77786973053912}]
["Inputs (Can Be Changed)"]
["Outputs (Cannot Be Changed)"]
[null,null,null,null,null,null,null,null,null,null,"Parameters"]
[null,null,null,null,null,null,null,null,null,null,"θ = Full Divergence Angle"]
[null,null,null,null,null,null,null,null,null,null,"D = Input Beam Diameter"]
[null,null,null,null,null,null,null,null,null,null,"f = Focal Length"]
[null,null,null,null,null,null,null,null,null,null,"zmax = Maximum Waist Distance"]
[null,null,null,null,null,null,null,null,null,null,"λ = Wavelength"]

{"sheet":"Beam Diameter Distance","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,3],[0,2,0,6],[3,0,5,0],[2,8,5,12]]}
[null,null,"Beam Diameter at a Certain Distance"]
[]
[null,null,"Beam Diameter at a Certain Distance",null,null,null,"Equation for Beam Diameter",null,"Note: It is recommended to download and open this file in the Excel desktop application, as some features are not supported in the web version of Excel. "]
["This calculator can be used to calculate the diameter of a beam at a certain distance away. The equation assumes a Gaussian input beam.",null,"Initial Beam Diameter (mm)",1]
[null,null,"Full Divergence Angle (rad)",1]
[null,null,"Distance (mm)",100]
[null,null,null,null,null,null,"Parameters"]
["Inputs (Can Be Changed)",null,"Final Beam Diameter (mm)",{"$f":"D4+(2*D6*TAN((RADIANS(D5))/2))","v":2.7453735581517575},null,null,"d1 = Initial Beam Diameter"]
["Outputs (Cannot Be Changed)",null,null,null,null,null,"d2 = Final Beam Diameter"]
[null,null,null,null,null,null,"z = Distance"]
[null,null,null,null,null,null,"θ = Full Divergence Angle"]

{"sheet":"f-Number","index":3,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,10,12,10],[3,0,4,0],[11,12,12,15],[0,2,0,10],[2,2,2,3],[2,6,2,7],[2,10,4,10],[2,12,5,16]]}
[null,null,"f-Number and Numerical Aperture Calculations"]
[]
[null,null,"f-Number",null,null,null,"Numerical Aperture",null,null,null,"Equation for f-Number",null,"Note: It is recommended to download and open this file in the Excel desktop application, as some features are not supported in the web version of Excel. "]
["This calculator can be used to calculate the f-number and numerical aperture of a lens.",null,"Focal Length (mm)",15,null,null,"f-number",3]
[null,null,"Entrance Pupil Diamerter (mm)",5,null,null,"Refractive Index",1]
[]
["Inputs (Can Be Changed)",null,"f-Number",{"$f":"D4/(D5)","v":3},null,null,"Angle (°)",{"$f":"DEGREES(ATAN(1/(2*H4)))","v":9.4623222080256166},null,null,"Equations for NA"]
["Outputs (Cannot Be Changed)",null,null,null,null,null,"Angle (rad)",{"$f":"ATAN(1/(2*H4))","v":0.16514867741462683}]
[null,null,null,null,null,null,"Numerical Aperture",{"$f":"H5*SIN(H8)","v":0.16439898730535726}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"The equation to the left can be used to calculate the NA in air using the small angle approximation."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Parameters"]
[null,null,null,null,null,null,null,null,null,null,"f/# = f-Number"]
[null,null,null,null,null,null,null,null,null,null,"f = Focal Length"]
[null,null,null,null,null,null,null,null,null,null,"D = Entrance Pupil Diameter"]
[null,null,null,null,null,null,null,null,null,null,"θ = Angle"]
[null,null,null,null,null,null,null,null,null,null,"NA = Numerical Aperture"]
[null,null,null,null,null,null,null,null,null,null,"n = Refractive Index"]

{"sheet":"Optical Invariant","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,4,0],[2,8,5,12],[2,2,2,3],[2,6,4,6],[6,6,8,6],[0,2,0,6]]}
[null,null,"Optical Invariant Calculation"]
[]
[null,null,"Optical Invariant",null,null,null,"Equation for Optical Invariant",null,"Note: It is recommended to download and open this file in the Excel desktop application, as some features are not supported in the web version of Excel. "]
["This calculator can be used to calculate the optical invariant of a beam.",null,"Target Radius (mm)",12.5]
[null,null,"Source Radius (mm)",25]
[null,null,"Source Numerical Aperture",0.22]
["Inputs (Can Be Changed)",null,"Refractive Index",1,null,null,"Equation for NA"]
["Outputs (Cannot Be Changed)"]
[null,null,"Source Angle (°)",{"$f":"DEGREES(ASIN(D6)/D7)","v":12.709032994395438}]
[null,null,"Target Angle (°)",{"$f":"D5/D4*D9","v":25.418065988790875}]
[null,null,"Target Numerical Aperture ",{"$f":"D7*SIN(RADIANS(D10))","v":0.4292199436186534},null,null,"Parameters"]
[null,null,null,null,null,null,"θ1 = Source Angle"]
[null,null,null,null,null,null,"θ2 = Target Angle"]
[null,null,null,null,null,null,"y1 = Source Radius"]
[null,null,null,null,null,null,"y2 = Target Radius"]
[null,null,null,null,null,null,"NA = Numerical Aperture"]
[null,null,null,null,null,null,"n = Refractive Index"]