Forgot Password
Pentax Camera Forums Home
 

Reply
Show Printable Version Search this Thread
06-22-2009, 07:55 AM   #1
Senior Member




Join Date: Mar 2008
Location: Highland Park, IL
Posts: 211
Lens map template with graph (Excel)

Not sure if there's one posted already (I didn't find one in a brief search), but thought others might be interested in a quick & dirty lens map worksheet with graph. Call me a geek, I like seeing the map graphed.

To use: Download the file and remove the .ZIP extension. Simply enter starting & ending focal length and description and the worksheet will update the graph.

(Not sure if this is the proper forum. Not sure where else to put it. Apologies to the mods if I flubbed the location.)

FWIW.

Attached Files
File Type: zip lensmap_template.xls.zip (22.0 KB, 675 views)
06-22-2009, 08:33 AM   #2
Inactive Account




Join Date: Nov 2007
Location: Canada eh!
Photos: Gallery
Posts: 674
That's great, thanks for posting that. I've been thinking of making one or trying to find one online and this one saves me the time. Excellent.
06-22-2009, 10:00 AM   #3
Pentaxian
Lowell Goudge's Avatar

Join Date: Jan 2007
Location: Toronto
Photos: Gallery | Albums
Posts: 15,396
I posted this a while ago

06-22-2009, 10:14 AM   #4
Senior Member




Join Date: Mar 2008
Location: Highland Park, IL
Posts: 211
Original Poster
Lowell -- do you still have and are you willing to share your template? I like the separation of zooms / primes on your map.

06-22-2009, 10:43 AM   #5
Pentaxian
Lowell Goudge's Avatar

Join Date: Jan 2007
Location: Toronto
Photos: Gallery | Albums
Posts: 15,396
QuoteOriginally posted by thirdofthree Quote
Lowell -- do you still have and are you willing to share your template? I like the separation of zooms / primes on your map.
It was really simple.

I set a minimum width for a cell, and had individual cells from 10-100mm and either 5 or 10mm per cell from 1000 to 1000. headings were centered on the cell

then I just shaded the cells appropriately for each focal length and lens. Note yellow was for lenses that don't get a lot of use, or lenses where I have upgraded

Not sure I kept it. I will need to look
06-22-2009, 10:57 AM   #6
Pentaxian
Lowell Goudge's Avatar

Join Date: Jan 2007
Location: Toronto
Photos: Gallery | Albums
Posts: 15,396
here is the roadmap

simply type your lens as you want it on the left, and shade in the appropriate focal length range.

Note the zooms and primes are simply placed by merging cells in the spread sheet
Attached Files
File Type: zip ROADMAP.zip (5.8 KB, 503 views)
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!
graph, k-mount, lens, map, pentax lens, slr lens
Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 LV (Light Value) Calculator dosdan Photography Articles 12 03-22-2011 02:33 AM
Suggestion Price graph on lens review database knoxploration Site Suggestions and Help 9 05-16-2010 12:42 PM
Excel 2003 drop-down pick lists dosdan Digital Processing, Software, and Printing 9 01-26-2010 02:28 AM
Is there MTF graph of A50/1.2? ogl Pentax SLR Lens Discussion 1 09-16-2009 07:29 PM
Pentax Lens Road Map azcavalier Pentax SLR Lens Discussion 2 04-04-2008 06:26 AM



All times are GMT -7. The time now is 12:57 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