Watch porn. (sfw) [more inside]
posted by Joe Beese on May 8, 2009 - 57 comments

Brian Valentine takes 3D macro images of flowers and insects. (How do I view them?) He discusses his macro methods here; a more general guide for making your own (not necessarily macro) 3D images can be found here. More 3D goodness at the Flickr Stereophotography (and stereovideography!) pools. Via EMRJKC'94. [more inside]
posted by Upton O'Good on May 6, 2009 - 32 comments

The ultimate Eamesian (previously, twice) expression of systems and connections, Powers of Ten explores the relative size of things (previously) from the microscopic to the cosmic. The 1977 film travels from an aerial view of a man in a Chicago park to the outer limits of the universe directly above him and back down into the microscopic world contained in the man's hand. But in 1977, this view of the world in leaps and bounds was already 20 years old. Kees Boeke, Dutch educator and pacifist, wrote the essay Cosmic View, which provided the source for Powers of 10. The whole essay was put online 41 years later, and it's still online, if you can't find a physical copy around.
posted by filthy light thief on Apr 23, 2009 - 12 comments

Violent death in the insect world - grisly yet compelling macro photographs of bug-against-bug carnage.
posted by madamjujujive on Sep 8, 2008 - 23 comments

Macro Photography on the Cheap (film camera or digital). Reverse Ring tags and a roundup discussion on Flickr. All you need is an SLR body (scratch that: you can even do it with a point and shoot) and reverse ring for your camera mount, and a lens whose filter size matches the reverse ring (doesn't even have to be the same mount as your camera!). Or, make one from a body cap. How/why it works, tips on shooting reverse macro, and even a podcast on the subject. It's even possible to do EXTREME closeups. Come to think of it, why not try this with video? Now, need to get some light on your macro subjects? Make a cheap LED ring light, or go low tech. Make tons of more stuff for your creative photography needs at DIY Photography.
posted by spock on Jul 28, 2008 - 11 comments

Who is this Belgian man "fotoopa"? A nerd's nerd (and I say that with extreme admiration). Photopainting, Macro photography, 2004: Let's start with the simple stuff, moths (mostly at rest). Now, can you think of anything more difficult to photograph than insects in flight? 2005, 2006 (the 2006 equipment), 2008 (2008 equipment & more equipment). Images of the man working with the equipment. His Flickr photostream and new YouTube channel bears watching. (Previously)
posted by spock on Jul 24, 2008 - 13 comments

In the world of conversation killers, talking about Excel to the average person ranks up there with the best. At the same time, there is always a chance that you wish you could have that conversation at work when it gets down to the wire. Even as a pro, you might need that brush up on Array Functions, calculation tricks, VBA examples or some examples from one of the well known authors on Excel. There is also no shortage of people who dedicate their working lives to this arcane program and are more than willing to assist others for free by posting solved issues on their websites. People like David McRitchie, OzGrid, Rob Bovey, Ron de Bruin, John Walkenbach, Dick Kusleika, Joseph Rubin and Chip Pearson.

Or if you just want to be a Debbie Downer at the next party, just take page from any of the following, memorize it. and recite it when faced with that nudge you don't want to talk to: Excel Support, Jon Peltier, Colo's Junk Room, Scriptorium, Andrew's Excel Tips, Andy Pope, Anthony's VBA Page, Rodney Powell, Array Formulas, Erlandsen Data Consulting, Excel-it, ExcelUser, JKP's Excel Page, John Lacher, McGimpsey, Bill Jelen, Stephen Bullen, Tushar Mehta, VBusers.com, The Excel Nexus, The Excel Logic Page, and Anthoney Does Excel. It’s a fast and easy way to ward off lounge lizards.
posted by lampshade on Aug 18, 2007 - 42 comments

Hidden Exposures
posted by shoepal on Aug 3, 2006 - 22 comments

Aweseome, but brief Russian photo gallery of macro (mostly) insect (with a little frog thrown in for good measure) photography.
posted by jonson on Jun 24, 2006 - 29 comments