Pentax Lens Inventory Spreadsheet

**rvandenbrink** · 01-06-2023, 07:14 PM - **2 Likes**

I got to looking at the Pentax Lens Roadmap, and thought that would be a good format to do a personal lens inventory. I find that the graphical side of it highlights any "holes" I may have on the focal length side. I tried to make this work with charts, but box charts don't actually work the way I want them to, so just ended up shading cells in.

Anyway, this sheet has my list, but by all means download it and update it for your own stash of gear.
GitHub - robvandenbrink/LensInventory: Lens Inventory, Graphical Focal Length

If you have any suggestions I'm happy to update the sheet for more features etc (the next iteration will likely have serial numbers for instance)

Attached Images

**zzaletel** · 01-06-2023, 08:05 PM - **1 Like**

Should be able to use some conditional formatting logic to do the shading if you split out the min and max focal length lines - will see if I can’t play with it this weekend.

**rvandenbrink** · 01-07-2023, 04:33 PM

Originally posted by zzaletel

Should be able to use some conditional formatting logic to do the shading if you split out the min and max focal length lines - will see if I can’t play with it this weekend.

I was trying to keep it simple, but definitely go for it if you have a use for it!

**Lowell Goudge** · 01-07-2023, 05:35 PM - **1 Like**

I posted this many years ago

I had a scale in mm from 10-100, and then in 10 mm steps above 100mm. This way you could see better the difference between 50, 55, and 58 mm for example.

I also showed overlaps with different shades for with and without teleconverters etc.

Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF

**rvandenbrink** · 01-08-2023, 05:09 PM

Originally posted by Lowell Goudge

I posted this many years ago

I had a scale in mm from 10-100, and then in 10 mm steps above 100mm. This way you could see better the difference between 50, 55, and 58 mm for example.

I also showed overlaps with different shades for with and without teleconverters etc.

Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF

Cool, looks like I’m late to the game :-)

**Lowell Goudge** · 01-08-2023, 05:12 PM

Originally posted by rvandenbrink

Cool, looks like I’m late to the game :-)

Not really, this topic comes up time after time

**zzaletel** · 01-08-2023, 10:22 PM

I set up a fork with auto-highlighting - happy for feedback - GitHub - zzaletel/LensInventory: Lens Inventory, Graphical Focal Length, autohighligting focal length table

Addendum: Played with it a bit more this morning with fresh eyes and saw that I didn't fully implement some of the focal length logic for proper plotting. Will update and upload a new revision.

Last edited by zzaletel; 01-09-2023 at 01:28 PM.

angerdan · 01-15-2023, 03:38 PM

Originally posted by rvandenbrink

Anyway, this sheet has my list, but by all means download it and update it for your own stash of gear.
GitHub - robvandenbrink/LensInventory: Lens Inventory, Graphical Focal Length

Awesome idea, thanks for sharing!

Originally posted by Lowell Goudge

I posted this many years ago
Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF

Do you remeber in which thread you posted it?

**Lowell Goudge** · 01-15-2023, 05:34 PM - **1 Like**

Originally posted by angerdan

Awesome idea, thanks for sharing!

Do you remeber in which thread you posted it?

Posted it and also the excel file

See here

https://www.pentaxforums.com/forums/10-pentax-slr-lens-discussion/59343-reth...-lenses-2.html

Rethinking my lenses - PentaxForums.com

https://www.pentaxforums.com/forums/10-pentax-slr-lens-discussion/64100-lens...aph-excel.html

**JensE** · 01-17-2023, 12:58 AM - **1 Like**

I like to keep my lens inventory in a data file and create a diagram of f-stop (wide open) over focal length - points for primes, a line for zooms. to that, I added the combinations I actually use in photographs. As I use both APS-C and FF, some lenses appear twice in the diagram, which does show equivalent field of view and depth of field scales for both formats, so one needs some time to read it. I haven't refreshed those diagrams in a while, but examples are in To K1 or not K1 - that is the question? - Page 2 - PentaxForums.com.
Basically every lens below a certain set of image dots can be used to take the photographs for the images above above it - in the format represented by the like-colored scale (red FF vs. black APS-C). I have not updated it in a while, that could be a fun thing when I'm back home next week. I have long purchased most of the green candidates and others, sold some ...

angerdan · 01-17-2023, 01:23 AM

Originally posted by JensE

I like to keep my lens inventory in a data file and create a diagram of f-stop (wide open) over focal length - points for primes, a line for zooms.
As I use both APS-C and FF, some lenses appear twice in the diagram, which does show equivalent field of view and depth of field scales for both formats, so one needs some time to read it.
To K1 or not K1 - that is the question? - Page 2 - PentaxForums.com

Basically every lens below a certain set of image dots can be used to take the photographs for the images above above it - in the format represented by the like-colored scale (red FF vs. black APS-C).
I have not updated it in a while, that could be a fun thing when I'm back home next week.

Very interesting, thank you for sharing!

Originally posted by JensE

In order to analyze what this would mean in terms on lenses and my (our) actual way to take pictures - choice of field-of-view vs. depth-of-field - I dug out a set of scripts that I wrote when I bought my K-5 to check lens options, which analyzed a selection of my prior DSLR pictures (EOS450) for how they were actually taken.

I plotted the exposures as dots in terms of focal length vs. aperture, smeared out so that you see the number of pictures as density.

Then I added my lenses in terms of focal length and minimum F-number. All those are black in the diagram and refer to the black axes.

Basically I could have taken every picture with a lens below the respective blue dot. Some adapted and pre-A glass doesn't have F-stop recorded and are listed around F/1 instead.

Now I added the lenses which are full-frame compatible on a another pair of axes (in color) again with roughly corresponding field-of-view and depth-of-field. So I could take similar pictures (perspective, DoF) as those blue dots above the respective colored lens marks using the full K-1 sensor at full resolution, full SNR etc. I also added, in color, some other FF lenses that I am considering. The zoom lenses are a bit sketchy on how they change variable aperture, but the whole diagram aims at an overview, not precision. To identify each lens, most are obvious choices, is left as an exercise to the reader

This thread starts to becoming a quite unexped collection of lens spreadsheets

01-06-2023, 07:14 PM - 2 Likes	#1
rvandenbrink Loyal Site Supporter Join Date: Apr 2021 Location: Stratford Ontario Photos: Gallery Posts: 256	Pentax Lens Inventory Spreadsheet I got to looking at the Pentax Lens Roadmap, and thought that would be a good format to do a personal lens inventory. I find that the graphical side of it highlights any "holes" I may have on the focal length side. I tried to make this work with charts, but box charts don't actually work the way I want them to, so just ended up shading cells in. Anyway, this sheet has my list, but by all means download it and update it for your own stash of gear. GitHub - robvandenbrink/LensInventory: Lens Inventory, Graphical Focal Length If you have any suggestions I'm happy to update the sheet for more features etc (the next iteration will likely have serial numbers for instance) Attached Images

01-07-2023, 05:35 PM - 1 Like	#4
Lowell Goudge Site Supporter Join Date: Jan 2007 Location: Toronto Photos: Gallery \| Albums Posts: 17,888	My version from many years ago I posted this many years ago I had a scale in mm from 10-100, and then in 10 mm steps above 100mm. This way you could see better the difference between 50, 55, and 58 mm for example. I also showed overlaps with different shades for with and without teleconverters etc. Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF

01-15-2023, 05:34 PM - 1 Like	#9
Lowell Goudge Site Supporter Join Date: Jan 2007 Location: Toronto Photos: Gallery \| Albums Posts: 17,888	Originally posted by angerdan Awesome idea, thanks for sharing! Do you remeber in which thread you posted it? Posted it and also the excel file See here https://www.pentaxforums.com/forums/10-pentax-slr-lens-discussion/59343-reth...-lenses-2.html Rethinking my lenses - PentaxForums.com https://www.pentaxforums.com/forums/10-pentax-slr-lens-discussion/64100-lens...aph-excel.html Last edited by Lowell Goudge; 01-15-2023 at 05:43 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DxO lens support for Pentax K3 iii (spreadsheet)	MJSfoto1956	Pentax K-3 III	2	08-03-2022 11:44 PM
What are your "Hidden Gems" in your lens inventory?	Dewman	Pentax SLR Lens Discussion	67	03-15-2016 07:47 AM
Wife has demanded a spreadsheet on photography expenditure	Mohawk	Photographic Technique	119	10-22-2010 05:02 AM
Photo inventory management?	jmdeegan	Digital Processing, Software, and Printing	11	03-05-2010 08:21 AM

01-06-2023, 08:05 PM - 1 Like	#2
zzaletel Site Supporter Join Date: Dec 2011 Location: Alaska Posts: 525	Should be able to use some conditional formatting logic to do the shading if you split out the min and max focal length lines - will see if I can’t play with it this weekend.

01-07-2023, 04:33 PM	#3
rvandenbrink Loyal Site Supporter Join Date: Apr 2021 Location: Stratford Ontario Photos: Gallery Posts: 256 Original Poster	Originally posted by zzaletel Should be able to use some conditional formatting logic to do the shading if you split out the min and max focal length lines - will see if I can’t play with it this weekend. I was trying to keep it simple, but definitely go for it if you have a use for it!

01-08-2023, 05:09 PM	#5
rvandenbrink Loyal Site Supporter Join Date: Apr 2021 Location: Stratford Ontario Photos: Gallery Posts: 256 Original Poster	Originally posted by Lowell Goudge I posted this many years ago I had a scale in mm from 10-100, and then in 10 mm steps above 100mm. This way you could see better the difference between 50, 55, and 58 mm for example. I also showed overlaps with different shades for with and without teleconverters etc. Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF Cool, looks like I’m late to the game :-)

01-08-2023, 05:12 PM	#6
Lowell Goudge Site Supporter Join Date: Jan 2007 Location: Toronto Photos: Gallery \| Albums Posts: 17,888	Originally posted by rvandenbrink Cool, looks like I’m late to the game :-) Not really, this topic comes up time after time

01-08-2023, 10:22 PM	#7
zzaletel Site Supporter Join Date: Dec 2011 Location: Alaska Posts: 525	I set up a fork with auto-highlighting - happy for feedback - GitHub - zzaletel/LensInventory: Lens Inventory, Graphical Focal Length, autohighligting focal length table Addendum: Played with it a bit more this morning with fresh eyes and saw that I didn't fully implement some of the focal length logic for proper plotting. Will update and upload a new revision. Last edited by zzaletel; 01-09-2023 at 01:28 PM.

01-15-2023, 03:38 PM	#8
angerdan Pentaxian Join Date: Feb 2015 Photos: Gallery \| Albums Posts: 2,639	Originally posted by rvandenbrink Anyway, this sheet has my list, but by all means download it and update it for your own stash of gear. GitHub - robvandenbrink/LensInventory: Lens Inventory, Graphical Focal Length Awesome idea, thanks for sharing! Originally posted by Lowell Goudge I posted this many years ago Also it is useful to list lenses always in order of focal length, within each series, M42, K, KA, and AF Do you remeber in which thread you posted it?

01-17-2023, 12:58 AM - 1 Like	#10
JensE Site Supporter Join Date: Dec 2015 Location: Leipzig Photos: Gallery \| Albums Posts: 1,969	I like to keep my lens inventory in a data file and create a diagram of f-stop (wide open) over focal length - points for primes, a line for zooms. to that, I added the combinations I actually use in photographs. As I use both APS-C and FF, some lenses appear twice in the diagram, which does show equivalent field of view and depth of field scales for both formats, so one needs some time to read it. I haven't refreshed those diagrams in a while, but examples are in To K1 or not K1 - that is the question? - Page 2 - PentaxForums.com. Basically every lens below a certain set of image dots can be used to take the photographs for the images above above it - in the format represented by the like-colored scale (red FF vs. black APS-C). I have not updated it in a while, that could be a fun thing when I'm back home next week. I have long purchased most of the green candidates and others, sold some ...

01-17-2023, 01:23 AM	#11
angerdan Pentaxian Join Date: Feb 2015 Photos: Gallery \| Albums Posts: 2,639	Originally posted by JensE I like to keep my lens inventory in a data file and create a diagram of f-stop (wide open) over focal length - points for primes, a line for zooms. As I use both APS-C and FF, some lenses appear twice in the diagram, which does show equivalent field of view and depth of field scales for both formats, so one needs some time to read it. To K1 or not K1 - that is the question? - Page 2 - PentaxForums.com Basically every lens below a certain set of image dots can be used to take the photographs for the images above above it - in the format represented by the like-colored scale (red FF vs. black APS-C). I have not updated it in a while, that could be a fun thing when I'm back home next week. Very interesting, thank you for sharing! Originally posted by JensE In order to analyze what this would mean in terms on lenses and my (our) actual way to take pictures - choice of field-of-view vs. depth-of-field - I dug out a set of scripts that I wrote when I bought my K-5 to check lens options, which analyzed a selection of my prior DSLR pictures (EOS450) for how they were actually taken. I plotted the exposures as dots in terms of focal length vs. aperture, smeared out so that you see the number of pictures as density. Then I added my lenses in terms of focal length and minimum F-number. All those are black in the diagram and refer to the black axes. Basically I could have taken every picture with a lens below the respective blue dot. Some adapted and pre-A glass doesn't have F-stop recorded and are listed around F/1 instead. Now I added the lenses which are full-frame compatible on a another pair of axes (in color) again with roughly corresponding field-of-view and depth-of-field. So I could take similar pictures (perspective, DoF) as those blue dots above the respective colored lens marks using the full K-1 sensor at full resolution, full SNR etc. I also added, in color, some other FF lenses that I am considering. The zoom lenses are a bit sketchy on how they change variable aperture, but the whole diagram aims at an overview, not precision. To identify each lens, most are obvious choices, is left as an exercise to the reader This thread starts to becoming a quite unexped collection of lens spreadsheets