Forgot Password
Pentax Camera Forums Home
 

Reply
Show Printable Version Search this Thread
03-24-2009, 02:07 PM - 2 Likes   #1
Veteran Member
Venturi's Avatar

Join Date: Mar 2008
Location: Tulsa, OK
Photos: Gallery
Posts: 2,637
Camera and Lens Math - EASY!

One of the constant themes running through the forums is how lenses behave in the various formats of digital and film cameras.

So, whilst chained to my desk babysitting machines that go ping I put together a little Excel spreadsheet that should help folks visualize the differences. By entering your lens' focal length, aperture and distance to subject you can quickly see:
  • Hyperfocal distance
  • Depth of Field, with near/far distances
  • Field of View
  • Angle of View
  • Compare results between APS-C, 35mm, 6x4.5, 6x7 & 8x10 formats.
DISCLAIMER: This spreadsheet is intended for entertainment use only. The formulas and constants/assumptions are what I have gleaned from various internet sources with varying levels of credibility. If you pick a keyboard fight using the data herein and get your internet butt handed to you by someone with better skilz you have my sympathy, but that's all.

The XLS file in Excel 97 format is attached. Enjoy and happy number crunching.

EDIT: Re-attached original version + english only I currently use.

Attached Files
File Type: zip FORMAT_COMPARISONS_v2.5.zip (11.5 KB, 538 views)
File Type: zip FORMAT_COMPARISONS_EN.zip (10.0 KB, 532 views)

Last edited by Venturi; 05-09-2011 at 08:04 PM.
03-24-2009, 06:39 PM   #2
Veteran Member
navcom's Avatar

Join Date: Feb 2008
Location: Minnesota USA
Photos: Gallery
Posts: 807
Cool spreadsheet! This will be neat to have.

Thanks for sharing Jim!
03-24-2009, 09:48 PM   #3
Veteran Member
Venturi's Avatar

Join Date: Mar 2008
Location: Tulsa, OK
Photos: Gallery
Posts: 2,637
Original Poster
You're welcome!

It was fun to build. Got to brush up on my algebra and trigonometry a bit. (See kids they do teach ya that stuff for a reason afterall)

I uploaded a new version of the spreadsheet.
Added:
- Logic for subject distance past hyperfocal distance
- DOF spread infront and behind subject distance
- THREE NEW CAMERAS! gotta add cameras and/or lenses when you upgrade photo software, right?

The attachment link in the original post has the updated version.
03-24-2009, 11:53 PM   #4
Veteran Member




Join Date: Nov 2006
Location: Sydney, Australia
Photos: Gallery
Posts: 593
This is a fantastic spreadsheet! A hearty congratulations on a job well done. A valuable resource that I will use regularly I am sure if:

Is there some way you can modify the DISTANCE(ft) and DISTANCE(in) to show metres/cm/mm rather than ft? This would also mean the requirement of the calculated answers to be in metrics, like near focus/far focus, Hyperfocal distance etc. As much of the world is metric, I am sure that there are many who would prefer it.

Thank you again for a wonderful tool that looks much easier to use than the other on-line DOF calculator:
Online Depth of Field Calculator

03-25-2009, 04:37 AM   #5
Pentaxian
Oldschool's Avatar

Join Date: Jun 2007
Location: Central NJ
Posts: 1,277
Thanks. Great job, now I just have to refresh my understanding of hyperfocal distance.
03-25-2009, 05:37 AM   #6
Site Supporter
Site Supporter




Join Date: Apr 2008
Location: North Wales
Posts: 265
Having a play now - thank you
03-25-2009, 06:45 AM   #7
Veteran Member
*isteve's Avatar

Join Date: Nov 2006
Location: London, England
Posts: 1,187
QuoteOriginally posted by Lance B Quote
This is a fantastic spreadsheet! A hearty congratulations on a job well done. A valuable resource that I will use regularly I am sure if:

Is there some way you can modify the DISTANCE(ft) and DISTANCE(in) to show metres/cm/mm rather than ft? This would also mean the requirement of the calculated answers to be in metrics, like near focus/far focus, Hyperfocal distance etc. As much of the world is metric, I am sure that there are many who would prefer it.
Would make the maths easier too
03-25-2009, 09:10 AM   #8
Veteran Member
Venturi's Avatar

Join Date: Mar 2008
Location: Tulsa, OK
Photos: Gallery
Posts: 2,637
Original Poster
QuoteOriginally posted by Lance B Quote
This is a fantastic spreadsheet! A hearty congratulations on a job well done. A valuable resource that I will use regularly I am sure if:

Is there some way you can modify the DISTANCE(ft) and DISTANCE(in) to show metres/cm/mm rather than ft?
QuoteOriginally posted by *isteve Quote
Would make the maths easier too
Thanks for the kudos! HOWEVER - I've got a bug.
In putting together the "metric" version I noticed my numbers didn't jive. Turns out the problem is in the Engrish part of the sheet for the hyperfocal calculation. I'm workin on my math issues now and will post a corrected version with both english and metric measurements later today.

03-25-2009, 09:56 AM   #9
Veteran Member
Venturi's Avatar

Join Date: Mar 2008
Location: Tulsa, OK
Photos: Gallery
Posts: 2,637
Original Poster
Okay, Metric version added and that pesky hyperfocal bug fixed. 1st post has the zip. Enjoy (again)!
03-25-2009, 12:20 PM   #10
Veteran Member
navcom's Avatar

Join Date: Feb 2008
Location: Minnesota USA
Photos: Gallery
Posts: 807
QuoteOriginally posted by Venturi Quote
Okay, Metric version added and that pesky hyperfocal bug fixed. 1st post has the zip. Enjoy (again)!
v2.0
03-25-2009, 04:50 PM   #11
Veteran Member
Agnostic's Avatar

Join Date: Mar 2009
Location: Netherlands
Photos: Gallery | Albums
Posts: 414
Thanks, that sounds useful
03-25-2009, 08:53 PM   #12
Veteran Member




Join Date: Nov 2006
Location: Sydney, Australia
Photos: Gallery
Posts: 593
QuoteOriginally posted by Venturi Quote
Okay, Metric version added and that pesky hyperfocal bug fixed. 1st post has the zip. Enjoy (again)!
Thank you very much, Jim.

Another job well done. It is now my official resource for DOF calculations.
03-25-2009, 09:42 PM   #13
WRB
Site Supporter
Site Supporter
WRB's Avatar

Join Date: Sep 2006
Location: Oregon
Photos: Gallery
Posts: 82
Thanks for the work

the more I learn the less I know.
03-25-2009, 10:50 PM   #14
Veteran Member
Venturi's Avatar

Join Date: Mar 2008
Location: Tulsa, OK
Photos: Gallery
Posts: 2,637
Original Poster
I'm glad you're all finding it useful.

I made one final addition to include the physical dimensions of your field of view at a given distance (e.g. if you have a 100mm lens on the K20D at 10ft your framed shot encompass an area 2.35ft by 1.57ft). If you don't care about that there's no need to download the new version. And I promise, no more patches/upgrades unless somebody finds a bug.
03-25-2009, 11:36 PM   #15
Veteran Member
Jewelltrail's Avatar

Join Date: May 2008
Location: Rhode Island
Photos: Albums
Posts: 4,180
QuoteQuote:
So, whilst chained to my desk babysitting machines that go ping I put together a little Excel spreadsheet that should help folks visualize the differences. By entering your lens' focal length, aperture and distance to subject you can quickly see:
Thank you--a nice contribution to our community!
Reply

Bookmarks
  • Submit Thread to Facebook Facebook
  • Submit Thread to Twitter Twitter
  • Submit Thread to Digg Digg
Tags - Make this thread easier to find by adding keywords to it!
camera, camera and lens, distance, field, formats, internet, lens, photography, spreadsheet, view
Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
How bad if fungus on a lens? Easy to remove? shaolin95 Pentax SLR Lens Discussion 12 08-31-2012 07:42 AM
Any Math people? Fl_Gulfer General Talk 3 11-11-2009 12:08 PM
Dismantling a lens - easy? ViS Pentax SLR Lens Discussion 24 12-02-2008 06:26 AM
I hate math, so help me.... Buddha Jones Pentax SLR Lens Discussion 8 04-22-2008 08:11 AM
How to do the math for a closeup lens? raider Pentax SLR Lens Discussion 6 03-11-2008 05:57 AM



All times are GMT -7. The time now is 04:25 AM. | See also: NikonForums.com, CanonForums.com part of our network of photo forums!
  • Red (Default)
  • Green
  • Gray
  • Dark
  • Dark Yellow
  • Dark Blue
  • Old Red
  • Old Green
  • Old Gray
  • Dial-Up Style
Hello! It's great to see you back on the forum! Have you considered joining the community?
register
Creating a FREE ACCOUNT takes under a minute, removes ads, and lets you post! [Dismiss]
Top