CCTV lens calculator

Hello

I'm making this calculator, that will allow you to calculate focal length, angel of view, will show field of view etc.

I'm doing this in Excel, without VBA, so it should work for everyone (with MS Office ofc). I know that there are some online calculators, or VideoCAD ones, but I want something "light", offline and easy to modify.

This version is for "focal length needed"

Could you take a look, and tell me what you think?

focal_length calculator_0.89beta.xlsx.zip

You are indded a nerd...!

It does work ok also in Libre Office.

You are indded a nerd...!

 

It does work ok also in Libre Office.

Someone asked me, If I can make version for foot or pixel per inch.

NO. metric system ftw.