.
Jeffrey’s “Data Plot” Lightroom Plugin
Quick Links
· Latest Download:
     data-plot-20120428.41.zip
· FAQ
· Version History
· Update Log via RSS
· Installation instructions
· “Donationware” Registration Info
· More Lightroom Goodies
· All-Plugin Update Log via RSS
· My Photo-Tech Posts
· My Blog

This plugin is somewhat of like a stripped down version of ExposurePlot, but without the coolness, except that this plugin integrates with your Lightroom catalog, which is sort of cool.

This plugin works in Lightroom 4, Lightroom 3, and Lightroom 2. (Though for Lightroom 3, you must have at least version 3.5)

The same download works for both Windows and Mac. See the box to the upper right for the download link link (in orange) and installation instructions.

Note: a Lightroom major upgrade, such as from Lr3 to Lr4, de-registers the plugin in the upgraded version, thus requiring a new (1-cent if you like) registration code in the upgraded version. It makes for a hassle every couple of years, I know. Sorry. See this note for details.

The plugin can plot the following photo parameters:

  • Focal Length — the focal lengths used, expressed in “35mm equivalent” terms so that data can be compared and contrasted reasonably among different cameras with different crop factors.

    Extra data about the use of primes vs. zooms is also shown.

  • Shutter Speed — shown on a logarithmic scale

  • Aperture

  • ISO — shown on a logarithmic scale

  • Ev — exposure value adjusted for ISO sensitivity as well. In Lr3+, any develop exposure adjustment is also taken into account.

To view a plot, select some images in the Library Module and invoke the desired plot via the File > Plugin Extras > ... menu.

Tip: to work with all photos shown in the grid or filmstrip, select none and the plugin will automatically work with all of them. This is the same as selecting all except that selecting all suffers the side effect that Lightroom tries to compute an updated metadata display, a resource-intensive operation that can be easily avoided in this case.

Other Features

You can save the plot data to a CSV file.

In Lr3+, you have the plugin create a collection of images that are represented by a row in the plot, to isolate them for further inspection.

For a focal-length plot, The plugin also reports what percent of images were taken with a prime lens, the extreme wide or tele ranges of a zoom, or beyond the range of the lens (that is, a prime or zoom with a teleconverter). A focal length 1mm within the end of the range is counted as the end, so with a 70-200mm zoom, a shot at 70mm or 71mm is considered “most wide”, and at 199mm or 200mm, “most tele”. (It may be interesting to combine this with the “Lens” metadata item in the Library Grid filter, allowing you to generate the report on a per-lens basis.)

For a focal-length plot, you can have the number reported in terms of a different kind of crop factor. This is useful, for example, when considering lens recommendations for someone with a different kind of camera.

Availability

This plugin is distributed as “donationware”. I have chosen to make it available for free — everyone can use it forever, without cost of any kind — but unless registered, its functionality is somewhat reduced after six weeks.

Registration is done via PayPal, and if you choose to register, it costs the minimum 1-cent PayPal fee; any amount you'd like to add beyond PayPal's sliding fees as a gift to me is completely optional, and completely appreciated.

For details on plugin registration and on how I came into this hobby of Lightroom plugin development, see my Plugin Registration page.

Version History
( Update Log via RSS )

20120428.41 Added another Canon camera.
20120413.40

Added some recent Canon SLRs. It's unfortunate that I have to do this, since there's a perfectly good Exif field for them to indicate the 35mm-equiv focal length, but Canon doesn't use it. Sigh.

Enhanced the send-log dialog to hopefully make reports more meaningful to me, yielding, I hope, the ability to respond more sensibly to more reports.

20120330.39 Update to handle 4.1RC
20120325.38 Added a bunch of Canon compacts to the database, and fixed a few that had been incorrect.
20120313.37 Added a camera to the database.
20120312.36 Added some more cameras to the database.
20120309.35 Had broken registrations in Lr2; Update to the debug logging to better track down timing issues that might arise.
20120304.34

More updates for Lr4.

20120221.33

More updates for Lr4.

20120207.32

Added the ability to save the raw data to a CSV file, in addition to the ability to save the summary data that was already there.

Added a few more cameras to the crop-factor database.

Fixed the data saved to the CSV file for ISO and shutter speed; it had been saving the log of the actual value instead of the actual value.

20120131.31 The plugin was neglecting to report when images had a focal length encoded in the metadata, but couldn't be plotted because the plugin couldn't figure out the 35mm-equivalent. In these situations now the plugin is clear about what's happening. I also added a bunch of crop-factor data for recent Fujifilm cameras.
20120130.30

Added some extra debug logging to try to track down an issue.

20120128.29

Fixed a bug that at times caused the focal-length labels to be incorrect, citing a random lens within the actual range as one of the endpoints of the range.More on the march toward Lr4, including upheaval in the code to handle Lightroom APIs being discontinued in Lr4.

20120114.28 More tweaks for Lr4b
20120112.27

Update for Lr4 beta: explain in the plugin manager that the plugin can't be registered in the beta.

20111210.26

Had issues with the registration button sometimes not showing.

Added a system-clock check and reports to the user if the system clock is more than a minute out of date. An incorrect system clock can cause problems with various kinds of communication and authentication with some of my plugins, so I've just gone ahead and added this to every plugin.

20111030.25

When doing a plugin upgrade, offer the ability to flush all the old copies of the plugin.

More updates to the internal crop-factor database. I really need to figure out a way to crowdsource this data.

20110908.24 A few updates to the internal crop-factor database.
20110822.23 Had an issue in the previous update with photos getting dropped.
20110822.22

Rewrote all the internals, and in addition to the ability to plot focal lengths, you can now plot apertures, shutter speeds, ISO values, and Ev. In Lr3 and later, Ev includes any adjustments made to the "Exposure" slider in Develop mode.

20110628.21 Updated the internal crop-factor database for the Fuji X100, which doesn't seem to include its crop factor in its metadata.
20100829.20 Made the revalidation process much simpler, doing away with the silly need for a revalidation file.
20100822.19 Assume any camera-model Exif with 'scan' in it is from a film/slide scanner, and treat as a full-frame size.
20100820.18 Discovered a bug in my plugin build system that caused horribly difficult-to-track-down errors in one plugin, so am pushing out rebuilt versions of all plugins just in case.
20100814.17

Added code to allow plugin revalidation after having been locked due to a bad Lightroom serial number.

20100625.16 Yikes, shaking out some more build issues.
20100624.15 Discovered a nasty build bug; pushing a new version in case it affects this plugin.
20100624.14 Oops, some of the new Lr3 collection stuff wasn't working... should be now.
20100609.13

This version can be registered in Lightroom 3. It can run in Lightroom 2 or Lightroom 3; it does not work in the Lr3 betas.

It uses my new registration system when run on Lightroom 3, which avoids some of the silly issues of the old one. Please take care to note the details on the registration page: use of this version (or later) of the plugin in Lightroom 3 requires a new registration code, even if you had registered some older version of the plugin.

20100518.12 Added support for the Canon 550D/KissX4/T2i, which for some reason doesn't include the 35mm-equivalent focal length in its metadata
20100516.11 Update for the Lr3 beta.
20100315.10 Wholesale changes that attempt to honor the user's locale settings for numeric display (e.g. Europeans writing 3,14156 for pi). I've probably missed some spots, so let me know if you find some.
20100312.9 A few more UI tweaks.
20100215.8

Minor UI tweaks on Mac.

Completely changed how the one-click upgrade applies the newly-downloaded zip file, in the hopes that it'll work for more people. Rather than unzipping over the old copy, it now unzips to a temporary folder, then moves the old folder out of the way and the new folder into place. Prior versions' folders are now maintained (with the version number in the folder) in case you want to revert a version; you may want to clear them out from time to time. Of course, it won't take affect until you try to upgrade after having upgraded to or beyond this version.

20091205.7 Minor internal debugging tweaks.
20091022.6 Added a bunch of standard sensor sizes to the "view in terms of" list, so you're not limited to the view of just the cameras you already have.
20091022.5 Added the ability to save the raw data to a CSV file, and the ability in the dialog to view the focal lengths in terms of any of the cameras used.
20091022.4 Added a first draft of some rudimentary support for Lightroom 3 Beta. See this important note about plugin support in Lightroom 3 Beta and Lightroom 3, including future plans for features and my registration system.
20091018.3 Doubled the size of the crop-factor database thanks to a library of images provided by exiftool author Phil Harvey.
20091017.2 Well, I didn't realize that some camera makers (e.g. Canon) don't populate the FocalLengthIn35mmFilm metadata item, so I built a database of camera crop factors (currently: 678 cameras) to compute the 35mm- equiv focal length myself.
20091016.1 Initial public release.

Comments so far....

Thanks Jeffrey

— comment by Florent Bouckenooghe on October 16th, 2009 at 4:21pm JST (2 years, 7 months ago) comment permalink

Hi Jeffrey,

Thanks for making yet another plugin. This one does not work for me though. My Canon Kiss X2 seems not write Equivalent Focal Length EXIF data so when I select photos taken with the Canon I get a “no photos had 35mm-equiv focal-length data” message. Ones taken with my Panasonic DMC-FX9 do have the exif data and the plugin works just as you describe on those pictures.

Is it possible to use Focal Length exif data directly instead of the 35mm equivalent?

Thanks

David

That’s on the todo list, sort of. I think I’d build a database of camera sensor sizes, and compute the 35mm equiv. data myself. Or, have it revert to Focal Length if no images have a 35mm equiv… —Jeffrey

— comment by David Dibben on October 16th, 2009 at 10:16pm JST (2 years, 7 months ago) comment permalink

Ahhhhhh, great! Thanks a lot Jeffrey!

— comment by Ollivier Robert on October 16th, 2009 at 11:50pm JST (2 years, 7 months ago) comment permalink

Hallo Jeffrey,

first I want to thank you for yor work.

Unfortunately none of my 14 used cameras seem to write 35-mm-eq to the metadata.
Like for David Dibben, the original focal-length-data would be ok for me.

Kindly regards from Germany
Juergen

— comment by Juergen on October 17th, 2009 at 3:02am JST (2 years, 7 months ago) comment permalink

Maybe I was a bit ambitious for a first go but I let it go on a 132,000 images and it returned results on about 6,800 of them producing the graphic.. followed by crashing lightroom. 95% of my shots were shot with Canon DSLR bodies and Canon EF lenses. LR is able to report on them so I know the data is there.

It says I have 39 different cameras, 57 different lenses used in my catalog, so if you need a tester for this one let me know!

Very Cool tool, and I posted a link on Twitter to let all the other LR users I know find out about it.

Thanks Again for the useful tools.

Christopher

When you say that LR reports about your Canon shots, does it also report the 35mm-equiv. focal length? I didn’t know it when I released the plugin, but it seems that Canon cameras don’t add that bit of metadata, so I’ll have to figure a way for the plugin to calculate it itself. As for the LR crash, that’s really unexpected. —Jeffrey

— comment by Christopher Souser on October 17th, 2009 at 6:40am JST (2 years, 7 months ago) comment permalink

Ah, pokin around in the library to grab data and stats. Great Fun!

First – this worked for me. I went straight to a large library 18,600 photos, one camera(Canon) and Four Lens.
It toook a while but the chart was displayed.

Then I thought, Now What?
===
I think that greater Utility could be had from the generation of a CSV format file containing selected columns from the photos of the library.
I would take this info into MS Excel and analyse, graph, pivot table with it there.

ex.
Fname, date, camera, lens, shutter, aperture, focal length, ISO, …

You are unlikely to satisfy everyones desire for reporting, lens chart, aperture chart, date chart, iso chart, Just a bit more data
Export to CSV can place the data in the hands of the user.

Roy

What you’re asking for is Tim Armes’ LR/Transporter plugin, which already exists so I won’t replicate it :-) , but FWIW, I’ve just pushed Data Plot v5 which allows you to save the focal-length summary-chart data as CSV. —Jeffrey

— comment by RoyReddy on October 18th, 2009 at 1:15am JST (2 years, 7 months ago) comment permalink

I second Roy’s idea.
A generic stats export plugin would be of tremendous value – IMHO, the type of people interested in these data plots (I am certainly one of them) are just the type to want to filter/sort/graph/pivot table the data to death. :)

Thanks!
AJ

— comment by AJ in NYC on October 22nd, 2009 at 5:26am JST (2 years, 7 months ago) comment permalink

I really like it – just tried it out today. Thanks for stuff like this.

Keep it up!

— comment by Eric Mesa on October 22nd, 2009 at 10:53am JST (2 years, 7 months ago) comment permalink

Interesting looking plugin. I used ImageReporter which runs separate from Lightroom. The ability to use a csv file would provide those whose like this kind of stuff to play with it the best. IR doesn’t do cvs. It does report to the nearest 10mm which makes for nicer plots. This has come in handy for looking at what lenses to buy after using a “vacation” zoom (18-200).

The one major sticking point is reporting in equivalent focal length. This is misleading and in the case of using the data to help with lens purchase – useless. I shoot both film and digital cameras using the same lenses. A 100mm lens produces the same perspective and distance compression on a crop sensor or 8×10 negative. This e-focal crap has to die… sorry, bit of a sore spot. Maybe an option to use either equiv or reported would be a solution?

And for some reason LR thinks I have 3 different cameras with the same make, model, and serial number.

Enjoy the plugins, great work!

From Midwest United States.

Consider shooting with a compact for years, and run the plot and you find that your most common focal lengths are 8.2mm and 17.8mm, but now you’re moving up to a DSLr. What lenses should you consider? Of course, the example you cite is valid, but there are plenty of situations where 35mm-equiv is exactly the most helpful way to look at things. In any case, as it turns out, I just pushed v5 which allows you to look at the data WRT any of the cameras used. And now that I think about it, I’ll add some standard crop factors in there as well, so v6 should follow soon…. —Jeffrey

— comment by Michael on October 22nd, 2009 at 3:21pm JST (2 years, 7 months ago) comment permalink

Hi Jeffrey,

Thank you for making available these great Lightroom plugins.

I was just thinking there are a couple of things that could make the Data Plot plugin even more useful IMHO:

1. Focal length is logarithmic in question – in your diagram above, the 20mm range between 14 and 31mm range is far more vast than the 492-510mm range at the other extreme, in terms of look. I suggest the scale should be logarithmic – between 7 and 20mm (35mm equiv f.l.) each range on the chart should probably be no more than 1mm, whereas at the other extreme (above 400 mm) it can be as much as 50 or 100mm.

2. Your tool takes data and turn it into information. It’d be great if it went a step further to turn it into answers. So what are the questions? I can think of:
- Which focal lengths and apertures are associated with my best rated shots?
- Which focal lengths and apertures am I using most often?
- Which lenses can I do without?
- Which lenses produce the most shots I reject?

Regards

Alex Karasev

— comment by AlexKarasev on November 11th, 2009 at 8:51am JST (2 years, 6 months ago) comment permalink

Thanks. I was looking for something like that worked with the LR library just a few weeks ago. If you could find the time I think it would be great to have graphs for ISO and other exposure info too.

— comment by Jesse on November 16th, 2009 at 11:01am JST (2 years, 6 months ago) comment permalink

Thanks for another great plugin.

Using this in combination with built in LR filters really helps me understand which lenses produce the most pleasing shots.

— comment by Jay Medeiros on November 20th, 2009 at 6:16am JST (2 years, 6 months ago) comment permalink

Jeffrey,
I have been playing with Data Plot and graphing with Excel. It has shown me some interesting things about lens use. Makes one wonder why I bought some of them…. I always like a neat program… keep up the good work. Thanks.

I first tried doing a “Screen Print”, but all I got was the background of LR2, not the Data Plot (it’s really labeled “Jeffrey’s Focal-Lenght Plot”). Not sure why this happens. Press Print SCRN and the Data Plot panel vanishes, “click”, the screen print happens, the data plot comes back on top. What gets saved is the LR2 panel.

In playing around for a day or so and looking at what I wanted out of it I found, at least for me, some “Nice to Have” ideas for the way I did my graphs. Yes, I realize “Easier Said Than Done”…

I do the Data Plot then do a Save Data to generate the CSVs. Then on to Excel (since I could not print screen it).

First thing I had to do was delete the blank lines after I opened the CSV in Excel (2000). Would be nice if the blank lines were not there.

Then I converted the StartMM and EndMM to the normal lens values. Just divided the values by 1.5 because the output of Save Data converts (or uses) 35mm equivelent. Know you are working on this. Great if it was the same choices as on the screen plot.

Then I created a new column of data that was a Range in mm, using the StartMM and EndMM converted data. Just like on the Data Plot. Would be nice if you had a column in the CSV giving range.

I would like to see nice rounded values in the StartMM EndMM and RangeMM areas. Values in multiples of 5, 10, 25, etc. Nice round numbers. Currently you might have a value of 189 or 193. How about these falling in a 185-200 range. I had lots of odd ball numbers on my plots. This would be a “Nice to Have” but most likely is a “Easier Said Than Done” item.

Thanks again for neat programs. Not to mention a neat website.

George Kindt, W0MKZ
Loveland, CO USA

— comment by George Kindt on December 5th, 2009 at 7:36am JST (2 years, 5 months ago) comment permalink

Hello,

I’m triing out your data-plot plugin but when I check my Panasonic FZ30 pictures I see in the dropdown more than 1 entry for the FZ30 with different crop factors (4,9 – 5 – 5,1 – 7,5).

The FZ30 has a lens of 7,4-88,8 mm wich is equivalent to 35-420 mm so the cropfactor is 4,73 (4,729729729729… to be more precise)

Now you can choose a lower resolution where the FZ30 only uses the center of the sensor and so seems to have a bigger cropfactor but that is in reality only a crop of the bigger picture so (in my opinion) nothing to use in your calculations.

You say you use a database of camera’s to calculate the 35mm equivalent but I suppose that it is buildin the plugin and that the user has no acces to it to add/remove entries?

Many thanks in advance,

If it were using only part of the sensor for the smaller images, it would be a bigger crop, but it’s downsizing from the full sensor to create the smaller image, and hence the crop factor is the same, but gets calculated incorrectly, which is the real problem you’re reporting. The problem is that the plugin can’t tell the difference between an image that’s been cropped, and an image that’s just smaller out of camera. I suppose it makes sense to assume it’s smaller out of camera and let it be wrong if it’s been cropped before loading into LR… I’ll look to see whether I can do that. —Jeffrey

— comment by Filip on February 9th, 2010 at 5:14am JST (2 years, 3 months ago) comment permalink

Hi ! Congrats on your program !

Just one question: does it also works with RAW anf TIF files, or only with JPG (like ExposurePlot) ?

TIA to let me know…

Regards,
J-P.

PS. I’m in Geneva, Switzerland

It works with your Lightroom catalog, so if Lightroom knows the focal length, so does the plugin. —Jeffrey

— comment by JPS on May 4th, 2010 at 1:46am JST (2 years ago) comment permalink

This is a great “self-awareness” tool.

A terrific adjunct would be a similar plot of orientation (ie, vertical/portrait, horizontal/landscape, square)!

— comment by Chris Ogden on September 17th, 2010 at 11:56pm JST (1 year, 8 months ago) comment permalink

This is a terrific plugin; though it could probably be coded/written abit better. I don’t see how reading and sorting meta-data could be so slow. It’s not even crunching my CPU or HDD… Hopefully it’ll return something on my huge set… and give me physical evidence to go and splurge on a lens in my favourite focal range…

If you tried writing a plugin using the limited API that Adobe provides, you’d see how it can be so slow. —Jeffrey

— comment by Jon Wan on December 21st, 2010 at 8:41pm JST (1 year, 5 months ago) comment permalink

Unfortunately the current version does not know my Canon EOS 60D with crop-factor 1.6. Is it possible to add this camera to the database?

Thanks and greetings from Germany, keep up your great work,
Christian

Oops, I pushed out a version with this three months ago, but neglected to let you know, sorry. It’s there now. —Jeffrey

— comment by Christian on September 11th, 2011 at 5:25am JST (8 months, 6 days ago) comment permalink

Thanks, for this greate Plugin and the further development.

— comment by Klaus on October 5th, 2011 at 9:12pm JST (7 months, 12 days ago) comment permalink

Hmm, I thought I give this plug-in a go…

It works!

… but …

It turns out it processes the photos in the grid, and throws an error: “no photos had 35mm-equiv focal-length data” … when the images are shot with a Canon 60D :)

Any information you need to add this camera to your crop table?

Cheers, Max — Brisbane, Australia

Just pushed a new version that should handle your 60D shots. —Jeffrey

— comment by MaxG on October 28th, 2011 at 7:26pm JST (6 months, 20 days ago) comment permalink

Tried with lightroom 4, using newest version available. Data plot didn’t include all focal lengths, for example, it give data from 14-24, skips to 28-30, skips again from 42-43, again to 56-67, etc. About a quarter of shots were from a 50mm prime on full frame, so there are photos taken with the lengths not included.

It took me forever to find it… one single vowel mistyped in a variable name made all the difference. I just pushed a version that should work. Thanks for the report. —Jeffrey

— comment by David Drufke on January 25th, 2012 at 5:58am JST (3 months, 23 days ago) comment permalink
Leave a comment...


All comments are invisible to others until Jeffrey approves them.

Please mention what part of the world you're writing from, if you don't mind. It's always interesting to see where people are visiting from.

More or less plain text — see below for allowed markup

You can use the following tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting