So I have had a ton of questions about how to figure out which lenses at my online store would work the best when modifying the ps3 cameras. Rather than just keep supplying the necessary formulas out to the select people who keep asking for it, I thought I’d just create an excel sheet to do the work.
I decided to research the math from a bunch of different sites which calculated the answers for you, and was surprised to find that some sites differed slightly. With that in mind, I took the formulas that most of them used to work with. When someone advertises that a lens has say 160 degree field of view (FOV), what they are not telling you is that since m12 lenses can be used in 1/3 inch and 1/4 inch camera sensor bearing cameras, their advertised FOV may be different than what you get. The reason is that the PS3 Eye Camera has a 1/4 inch sensor, but calculating the FOV with a 1/3 inch sensor in mind yields a larger FOV. Also, the FOV usually listed is a diagonal FOV, not the horizontal or vertical FOV that most people care about (which reminds me of the headache back when I worked retail at Best Buy on explaining to people that a 19″ wide LCD didn’t mean that the screen was horizontally 19″). So say you see the m12 160 degree 2.1mm lens advertised. What that really means for the ps3 camera is a 116 degree horizontal FOV…confusing, arg.
The excel chart can be downloaded below:
Microsoft Excel 2007 (.xlsx)
Microsoft Excel 2003 (.xls)
If you think a correction is needed or have a suggestion on how to make it better I’d love to hear it.