{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Lens Data","Do NOT Delete"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"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":"Input","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,3,17,6],[15,0,17,0],[14,3,14,8]]}
[]
["Image Sensor","Anafocus Lince 5M",null,"Step 1. Select imaging sensor of the camera under consideration."]
["Imaging Sensor Format (in.)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,2,FALSE)","v":1}]
["Imaging Sensor Pixel Size (µm)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,8,FALSE)","v":5}]
["Sensor Array (MegaPixels)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,3,FALSE)","v":5.2}]
["Required Lens Resolution (lp/mm) @ 50% contrast",{"$f":"1000/(2*B4)","v":100},null,"lp/mm = 1000/(2x pixel size)"]
["Lens Series",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,12,FALSE)","v":"MP Series"},null,"2. The Lens Series is selected based upon the imaging sensor."]
["Horizontal Sensor size (mm)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,9,FALSE)","v":12.8}]
["Vertical Sensor size (mm)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,10,FALSE)","v":10.24}]
["Diagonal Sensor size (mm)",{"$f":"VLOOKUP(B2,'Do NOT Delete'!A1:L30,11,FALSE)","v":16.391998047828093}]
[]
["Working Distance",1000,"mm","3. Enter the Working Distance and Horizontal Field Of View (in mm)."]
["Field of View Horizontal",200,"mm"]
[]
["Calculated Focal Length (approximate)",{"$f":"B8*B12/B13","v":64},"mm","f = (horizontal sensor size (mm) x Working Distance (mm)/ Horizontal FOV (mm)"]
[null,0,"mm","4. Enter a standard available Focal Length approximating the above (5, 8, 12, 16, 25, 35, 50, 75) and push the \"Lens Data\" button."]

{"sheet":"Lens Data","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Focal Length","Series","Part number","Description","Aperture","Image Circle (mm)","Filter Thread (M[mm]-P[mm]"]
[5,"MP2","H0514-MP2","1/2\" 5mm f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.4,8,"M43 P=0.75"]
[8,"MP2","M0814-MP2","2/3\" 8mm  f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.4,11,"M30.5 P=0.5"]
[12,"MP2","M1214-MP2","2/3\" 12mm f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.4,11,"M30.5 P=0.5"]
[16,"MP2","M1614-MP2","2/3\" 16mm f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.4,11,"M30.5 P=0.5"]
[25,"MP2","M2518-MP2","2/3\" 25mm f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.8,11,"M30.5 P=0.5"]
[35,"MP2","M3514-MP","2/3\" 35mm f1.4 w/locking iris & focus, 1.5 megapixel, C-mount",1.4,11,"M30.5 P=0.5"]
[50,"MP2","M5018-MP2","2/3\" 50mm f1.8 w/locking iris & focus, 1.5 megapixel, C-mount",1.8,11,"M30.5 P=0.5"]
[75,"MP2","M7528-MP","2/3\" 75mm f2.8 w/locking iris & focus, 1.5 megapixel, C-mount",2.8,11,"M30.5 P=0.5"]
[8,"MPW2","M0824-MPW2","2/3\" 8mm f2.4, 5.0 megapixel Ultra low Distortion Lens",2.4,11,"M32.0 P=0.5"]
[12,"MPW2","M1224-MPW2","2/3\" 12mm f2.4, 5.0 megapixel Ultra low Distortion Lens",2.4,11,"M27.0 P=0.5"]
[16,"MPW2","M1620-MPW2","2/3\" 16mm f2.0, 5.0 megapixel Ultra low Distortion Lens",2,11,"M27.0 P=0.5"]
[25,"MPW2","M2518-MPW2","2/3\" 25mm f1.8, 5.0 megapixel Ultra low Distortion Lens",1.8,11,"M27.0 P=0.5"]
[35,"MPW2","M3520-MPW2","2/3\" 35mm f2.0, 5.0 megapixel Ultra low Distortion Lens",2,11,"M27.0 P=0.5"]
[50,"MPW2","M5028-MPW2","2/3\" 50mm f2.8, 5.0 megapixel Ultra low Distortion Lens",2.8,11,"M27.0 P=0.5"]
[25,"MPW","M2518-MPW","2/3\" 25mm f1.8, 5.0 megapixel Ultra low Distortion w/floating system",1.8,11," M30.5 P=0.5"]
[8,"MP","V0814-MP","1\" 8mm f1.4, 2.0 megapixel Ultra low Distortion Lens",1.4,16,"M55.0 P=0.75"]
[12,"MP","V1214-MP","1\" 12mm f1.4, 2.0 megapixel Ultra low Distortion Lens",1.4,16,"M35.5 P=0.5"]
[16,"MP","V1614-MP","1\" 16mm f1.4, 2.0 megapixel Ultra low Distortion Lens",1.4,16,"M35.5 P=0.5"]
[25,"MP","V2514-MP","1\" 25mm f1.4, 2.0 megapixel Ultra low Distortion Lens",1.4,16,"M35.5 P=0.5"]
[50,"MP","V5014-MP","1\" 50mm f1.4, 2.0 megapixel Ultra low Distortion Lens",1.4,16,"M40.5 P=0.5"]
[8,"MPY","V0828-MPY","1.1\" 8mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001]
[12,"MPY","V1228-MPY","1.1\" 12mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001,"M40.5 P=0.5"]
[16,"MPY","V1628-MPY","1.1\" 16mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001,"M34.0 P=0.5"]
[25,"MPY","V2528-MPY","1.1\" 25mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001,"M34.0 P=0.5"]
[35,"MPY","V3528-MPY","1.1\" 35mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001,"M34.0 P=0.5"]
[50,"MPY","V5028-MPY","1.1\" 50mm f2.8, 12.0 megapixel Ultra low Distortion Lens",2.8,17.600000000000001,"M34.0 P=0.5"]

{"sheet":"Do NOT Delete","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["sensor","sensor size","MP","resolution","Pixels (H)","Pixels (V)","pixel size in Square um","pixel size in um","horizontal sensor size (mm)","vertical sensor size (mm)","Diagonal measurement (mm)","recommended lenses"]
["Anafocus Lince 5M",1,5.2,{"$f":"E2&\" x \"&F2","v":"2560 x 2048"},2560,2048,{"$f":"H2&\" x \"&H2","v":"5 x 5"},5,{"$f":"H2*E2/1000","v":12.8},{"$f":"H2*F2/1000","v":10.24},{"$f":"SQRT((I2*I2) + (J2*J2))","v":16.391998047828093},"MP Series"]
["Aptina MT9P031","1/2.5",5,{"$f":"E3&\" x \"&F3","v":"2592 x 1944"},2592,1944,{"$f":"H3&\" x \"&H3","v":"2.2 x 2.2"},2.2000000000000002,{"$f":"H3*E3/1000","v":5.7024000000000008},{"$f":"H3*F3/1000","v":4.2768000000000006},{"$f":"SQRT((I3*I3) + (J3*J3))","v":7.128000000000001},"L1028K Series"]
["CMOSIS CMV2000",0.66666666666666663,2.2000000000000002,"2048 x 1088",2048,1088,"5.5 x 5.5",5.5,11.263999999999999,5.984,12.75484033612338,"MP Series"]
["CMOSIS CMV300",0.33333333333333331,2.2999999999999998,"1936 x 1216",1936,1216,"5.86 x 5.86",5.86,11.34496,7.1257600000000005,13.397185263300647,"MPW2 Series"]
["CMOSIS CMV4000",1,4.2,"2048 x 2048",2048,2048,"5.5 x 5.5",5.5,11.263999999999999,11.263999999999999,15.929701566570541,"MP Series"]
["ON Semi KAC06040","4/3",6,"3024 x 2320",3024,2320,"4.7 x 4.7",4.7,14.212800000000001,10.904,17.91370703790815,"MPY Series"]
["ON Semi KAC12040","4/3",12,"4224 x 3192",4224,3192,"4.7 x 4.7",4.7,19.852799999999998,15.002400000000002,24.883843625935281,"None"]
["e2v EV76C560","1/1.8",1.3,"1280 x 1024",1280,1024,"5.3 x 5.3",5.3,6.7839999999999998,5.4272,8.6877589653488894,"MPW2 Series"]
["e2v EV76C570","1/1.8",2,"1600 x 1200",1600,1200,"4.5 x 4.5",4.5,7.2,5.4,9,"MPW2 Series"]
["Python 1300",0.5,1.3,"1280 x 1024",1280,1024,"4.8 x 4.8",4.8,6.1440000000000001,4.9151999999999996,7.868159062957484,"MP2 Series"]
["Python 2000",0.66666666666666663,2.2999999999999998,"1920 x 1200",1920,1200,"4.8 x 4.8",4.8,9.2159999999999993,5.76,10.867946264129207,"MP Series"]
["Python 300",0.25,0.3,"640 x 480",640,480,"4.8 x 4.8",4.8,3.0720000000000001,2.3039999999999998,3.84,"None"]
["Python 5000",1,3.2,"2064 x 1544",2064,1544,"4.8 x 4.8",4.8,9.9071999999999996,7.4112,12.372489534446977,"MPY Series"]
["Sony ICX 674 CCD",0.66666666666666663,2.8,"1936 x 1456",1936,1456,"4.54 x 4.54",4.54,8.7894400000000008,6.6102400000000001,10.997705595768602,"MP Series"]
["Sony ICX 694 CCD",1,6.1,"2758 x 2208",2758,2208,"4.54 x 4.54",4.54,12.521319999999999,10.024319999999999,16.039652303114302,"MPY Series"]
["Sony ICX814 CCD",1,9.1,"3376 x 2704",3376,2704,"3.69 x 3.69",3.69,12.45744,9.97776,15.960686262538964,"MPY Series"]
["Sony ICX834 CCD",1,12,"4240 x 2832",4240,2832,"3.1 x 3.1",3.1,13.144,8.7792000000000012,15.80629901779667,"MPY Series"]
["Sony IMX174","1/1.2",2.2999999999999998,"1920 x 1200",1920,1200,"5.86 x 5.86",5.86,11.251200000000001,7.032,13.267951064124409,"MP Series"]
["Sony IMX 183",1,20,"5472 x 3648",5472,3648,"2.4 x 2.4",2.4,13.1328,8.7551999999999985,15.783661263471158,"MPY Series"]
["Sony IMX249","1/1.2",2.2999999999999998,"1920 x 1200",1920,1200,"5.86 x 5.86",5.86,11.251200000000001,7.032,13.267951064124409,"MP Series"]
["Sony IMX250",0.66666666666666663,5.04,"2456 x 2054",2456,2054,"3.45 x 3.45",3.45,8.4732000000000003,7.0863000000000005,11.045848357188325,"MPW2 Series"]
["Sony IMX252","1/1.8",3.1,"2064 x 1544",2064,1544,"3.45 x 3.45",3.45,7.1208,5.3268000000000004,8.8927268528837651,"MPW2 Series"]
["Sony IMX253",1.1000000000000001,12.37,"4112 x 3008",4112,3008,"3.45 x 3.45",3.45,14.186400000000001,10.377600000000001,17.576931663973664,"MPY Series"]
["Sony IMX255",1,8.9,"4112 x 2176",4112,2176,"3.45 x 3.45",3.45,14.186400000000001,7.507200000000001,16.050295847740628,"MPY Series"]
["Sony IMX264",0.66666666666666663,5,"2448 x 2048",2448,2048,"3.45 x 3.45",3.45,8.4456000000000007,7.0656000000000008,11.011396946800167,"MPW2 Series"]
["Sony IMX265","1/1.8",3.1,"2048 x 1536",2048,1536,"3.45 x 3.45",3.45,7.0656000000000008,5.2992000000000008,8.8320000000000007,"MPW2 Series"]
["Sony IMX267",1,8.9499999999999993,"4112 x 2176",4112,2176,"3.45 x 3.45",3.45,14.186400000000001,7.507200000000001,16.050295847740628,"MPY Series"]
["Sony IMX 273","1/2.9",1.6,"1440 x 1080",1440,1080,"3.45 x 3.45",3.45,4.968,3.726,6.21,"MPY Series"]
["Sony IMX304",1.1000000000000001,12.2,"4096 x 3000",4096,3000,"3.45 x 3.45",3.45,14.131200000000002,10.35,17.516087275416279,"MPY Series"]