potato psoas Posted July 28, 2017 Share Posted July 28, 2017 Hey I was wanting to convert game FOVs with different FOV types to actual HFOV in an excel spreadsheet but I'm not sure what formulas to use and if I need to adjust for radians or degrees or whatever. It tried the formulas here but they didn't seem to work: https://en.wikipedia.org/wiki/Field_of_view_in_video_games I am particularly in need of the Vertical Degrees to HFOV formula Thanks Link to comment
Wizard DPI Wizard Posted July 28, 2017 Wizard Share Posted July 28, 2017 Like this example converting 55 vertical degrees and resolution 1920x1080 to HFOV: http://www.wolframalpha.com/input/?i=radian*2*atan((tan(55degrees%2F2))%2F(1080%2F1920)) For Excel it would be (if converting vertical degrees to horizontal degrees): =DEGREES(2*ATAN(TAN((RADIANS(55)/2))/(1080/1920))) potato psoas 1 Link to comment
Drimzi Posted July 29, 2017 Share Posted July 29, 2017 (edited) Edited January 28, 2018 by Drimzi potato psoas 1 Link to comment
Drimzi Posted July 29, 2017 Share Posted July 29, 2017 (edited) Edited January 28, 2018 by Drimzi Link to comment
Skwuruhl Posted July 30, 2017 Share Posted July 30, 2017 (edited) 5 hours ago, Drimzi said: Anyone know how to get diagonal fov? edit: This seems to give me the diagonal fov for 4:3 90 fov on a 16:9 monitor. I just changed the 4:3 horizontal to 16:9 horizontal formula above by changing the aspect ratio to squareroot(((4/3)*(4/3)) + ((3/4) * (3/4))). (2 atan((squareroot(((4/3)*(4/3)) + ((3/4) * (3/4)))) tan((π 90)/360))) * (180/pi) 106.26 horizontal, 73.74 vertical, 113.66 diagonal. That sounds right? Yeah, here's how I did it: c^2 = a^2 + b^2 b = 9 / 16 * a c = sqrt( a^2 + 81 / 256 * a^2) c=1/16 sqrt(337) sqrt(a^2) = diagonal fov = 2 * arctan( sqrt(337) / 16 tan( 106.26° / 2 ) ) = 113.65618274170363734344480439356726269415009144926 Edited July 30, 2017 by Skwuruhl Drimzi 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now