Old lens comparison Spreadsheet

	B	C	E	F	H	I	K	L	M	O	P	R
1
2
3	Manufacturer	Lens or adapter	Focal length		Aperture		Weight			Length		Cost
4			Focal length		Aperture		Grams	Ounces	Pounds	MM	Inches
5			Wide	Tele.	Wide	Tele.	---	0.035274	0.00220462	---	0.0393701
6
7	Sigma	18-35mm f/1.8	18.0	35.0	1.80	1.80	810	28.57	1.79	121.00	4.76	$719.00
8	Sigma	USB dock for EF lenses	---	---	---	---	---	---	---	---	---	$59.00
9	Viltrox	EF-M1	1.0	1.0	---	---	115	4.06	0.25	25.00	0.98	$136.00
10	Total		18.0	35.0	1.80	1.80	925	32.63	2.04	146.00	5.75	$914.00
11	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
12	Sigma	18-35mm f/1.8	18.0	35.0	1.80	1.80	810	28.57	1.79	121.0	4.76	$719.00
13	Sigma	USB dock for EF lenses	---	---	---	---	---	---	---	---	---	$59.00
14	Viltrox	EF-M2 II	0.7	0.7	-1 f/stop	-1 f/stop	85	3.00	0.19	25.0	0.98	$149.00
15	Total		12.8	24.9	1.40	1.40	895	31.57	1.97	146.0	5.75	$927.00
16	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
17	Sigma	18-35mm f/1.8	18.0	35.0	1.80	1.80	810	28.57	1.79	121.0	4.76	$719.00
18	Sigma	USB dock for EF lenses	---	---	---	---	---	---	---	---	---	$59.00
19	Viltrox	EF-M1	1.0	1.0	---	---	115	4.06	0.25	25.00	0.98	$136.00
20	Viltrox	EF-M2 II	0.7	0.7	-1 f/stop	-1 f/stop	85	3.00	0.19	25.00	0.98	$149.00
21	Total	EF-M1 on camera	18.0	35.0	1.80	1.80	925	32.63	2.04	146.00	5.75	$1,063.00
22	Total	EF-M2 on camera	12.8	24.9	1.40	1.40	895	31.57	1.97	146.00	5.75	$1,063.00
23	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
24	Sigma	18-35mm f/1.8	18.0	35.0	1.80	1.80	810	28.57	1.79	121.0	4.76	$719.00
25	Sigma	USB dock for EF lenses	---	---	---	---	---	---	---	---	---	$59.00
26	Metabones	T-smart E/EF adapter	1.0	1.0	---	---	160	5.64	0.35	25.0	0.98	$399.00
27	Total		18.0	35.0	1.80	1.80	970	34.22	2.14	146.0	5.75	$1,177.00
28	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
29	Sigma	18-35mm f/1.8	18.0	35.0	1.80	1.80	810	28.57	1.79	121.0	4.76	$719.00
30	Sigma	USB dock for EF lenses	---	---	---	---	---	---	---	---	---	$59.00
31	Metabones	Ultra	0.7	0.7	-1 f/stop	-1 f/stop	172	6.07	0.38	24.0	0.94	$649.00
32	Total		12.8	24.9	1.40	1.40	982	34.64	2.16	145.0	5.71	$1,427.00
33	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
34
35	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
36	Olympus	50-200mm f/2.8-3.5 mark I	50.0	200.0	2.80	3.50	1,070	37.74	2.36	157.0	6.18
37	Olympus	MMF-3	---	---	---	---	42	1.48	0.09	20.0	0.79
38	Total		50.0	200.0	2.80	3.50	1,112	39.22	2.45	177.0	6.97
39
40	Olympus	50-200mm f/2.8-3.5 mark I	50.0	200.0	2.80	3.50	1,070	37.74	2.36	157.0	6.18
41	Olympus	MMF-3	--	--			42	1.48	0.09	20.0	0.79
42	Olympus	EC-14	1.4	1.4	1 f/stop	1 f/stop	170	6.00	0.37	22.0	0.87
43	Total		70.0	280.0	4.00	5.00	1,282	45.22	2.83	199.0	7.83
44
45	Olympus	50-200mm f/2.8-3.5 mark I	50.0	200.0	2.80	3.50	1,070	37.74	2.36	157.0	6.18
46	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
47	Olympus	EC-20	2.0	2.0	2 f/stop	2 f/stop	225	7.94	0.50	41.0	1.61
48	Total		100.0	400.0	5.60	7.10	1,337	47.16	2.95	218.0	8.58
49	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
50
51	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
52	Olympus	14-54mm f/2.8-3.5 mark I (4/3rds)	14.0	54.0	2.80	3.50	435	15.34	0.96	88.5	3.48
53	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
54	Total		14.0	54.0	2.80	3.50	477	16.83	1.05	108.5	4.27
55	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
56
57	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
58	Olympus	14-54mm f/2.8-3.5 mark II (4/3rds)	14.0	54.0	2.80	3.50	440	15.52	0.97	88.4	3.48
59	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
60	Total		100.0	400.0	5.60	7.10	482	17.00	1.06	108.4	4.27
61	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
62
63	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
64	Olympus	50mm f/2 macro (4/3rds)	50.0	50.0	2.00	2.00	300	10.58	0.66	61.5	2.42
65	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
66	Total		50.0	50.0	2.00	2.00	342	12.06	0.75	81.5	3.21
67	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
68
69	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
70	Olympus	11-22mm f/2.8-3.5 (4/3rds)	11.0	22.0	2.80	3.50	485	17.11	1.07	92.5	3.64
71	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
72	Total		11.0	22.0	2.80	3.50	527	18.59	1.16	112.5	4.43
73	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
74
75	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
76	Olympus	70-300mm f/4-5.6 (4/3rds)	70.0	300.0	4.00	5.60	620	21.87	1.37	127.0	5.00
77	Olympus	MMF-3	--	--	--	--	42	1.48		20.0	0.79
78	Total		50.0	200.0	4.00	5.60	662	23.35	1.37	147.0	5.79
79	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
80	Olympus	70-300mm f/4-5.6 (4/3rds)	70.0	300.0	4.00	5.60	620	21.87	1.37	127.0	6.18
81	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
82	Olympus	EC-14	1.4	1.4	1 f/stop	1 f/stop	170	6.00	0.37	22.0	0.87
83	Total		98.0	420.0	5.60	8.00	832	29.35	1.83	169.0	7.83
84	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
85
86	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
87	Olympus	18-180mm f/4-5.6 (4/3rds)	18.0	180.0	3.50	6/3	435	15.34	0.96	85.0	3.35
88	Olympus	MMF-3	--	--	--	--	42	1.48	0.09	20.0	0.79
89	Total		18.0	180.0	3.50	6/3	477	16.83	1.05	105.0	4.13
90	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches
91
92	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
93	Olympus	7-14mm f/2.8	7.0	14.0	2.80	2.80	534	18.84	1.18	105.8	4.17	$1,299.00
94	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
95	Olympus	8-25mm f/4	8.0	25.0	4.00	4.00	411	14.50	0.91	88.5	3.48	$1,099.99
96	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
97	Olympus	9-18mm f/4-5.6	9.0	18.0	4.00	5.60	155	5.47	0.34	49.5	1.95	$599.00
98	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost
99	Olympus	12-40mm f/2.8	12.0	40.0	2.80	2.80	382	13.47	0.84	84.0	3.31	$999.00
100	Mfgr.	Lens/adapter	W/focal	T/focal	W/app.	T/app.	Gram	Oz.	Lb.	Mm.	Inches	Cost