Excel: Find MIN for multiple ranges, with offset of 365 days

April 29th, 2015

Screen Shot 2015-04-29 at 10.20.23

To remember….

Changing Projection (Center)

April 29th, 2015

Screen Shot 2015-04-29 at 09.03.06

Screen Shot 2015-04-29 at 09.03.09

Interesting how the projection, or better the center and everything around changes dynamically, when one moves around

Andrew Stanton: The clues to a great story

March 9th, 2015

Screen Shot 2015-03-09 at 08.03.54

The children’s television host Mr. Rogers always carried in his wallet a quote from a social worker that said, “Frankly, there isn’t anyone you couldn’t learn to love once you’ve heard their story.” And the way I like to interpret that is probably the greatest story commandment, which is “Make me care” — please, emotionally, intellectually, aesthetically, just make me care.
Andrew Stanton. “The clues to a great story”

Why storytelling matters. Garr Reynolds

March 6th, 2015

Screen Shot 2015-03-06 at 12.15.33

Screen Shot 2015-03-06 at 12.16.44

Screen Shot 2015-03-06 at 12.17.54

Screen Shot 2015-03-06 at 12.19.11

Screen Shot 2015-03-06 at 12.20.07

Screen Shot 2015-03-06 at 12.21.42

Screen Shot 2015-03-06 at 12.22.09

Screen Shot 2015-03-06 at 12.22.58

Screen Shot 2015-03-06 at 12.23.20

Screen Shot 2015-03-06 at 12.24.15

Screen Shot 2015-03-06 at 12.25.01

Screen Shot 2015-03-06 at 12.26.03

Screen Shot 2015-03-06 at 12.30.02


Conflicting views: Public versus scientists

March 6th, 2015

Screen Shot 2015-03-06 at 11.45.11

Battling Infectious Diseases in the 20th Century: The Impact of Vaccines

March 6th, 2015

Screen Shot 2015-03-06 at 11.32.53

Interesting to see the what happened after vaccines have been introduced.

Global Temperature (Anomalies) Data

January 22nd, 2015

Japan Meteorological Agency – mail to:

Website launched: Global Environmental Goals (GEGs) Live

November 25th, 2014

Screen Shot 2014-11-25 at 10.40.45

Screen Shot 2014-11-25 at 10.41.07

Screen Shot 2014-11-25 at 10.38.46

There is a multitude of internationally-agreed environmental goals and objectives, which are part of outcome documents of relevant United Nations summits and conferences, resolutions of the General Assembly, decisions of other global intergovernmental conferences, multilateral environmental agreements and decisions of their governing bodies. The compendium of those goals and objectives is called the Global Environmental Goals (GEGs).
The purpose of the GEGs-Live website is to provide up-to-date information on the progress towards achieving these GEGs. In addition, it puts the information into the context of the currently elaborated Sustainable Development Goals (SDGs). The variables and data are mainly drawn from UNEP’s Environmental Data Explorer.
Users can access the information they are searching for either through the GEGs or the SDGs, as parallel points of entry. Based on the user’s choice, the website shows the direct interlinkages between politically-agreed goals and targets on the one hand, and relevant underlying data for monitoring these on the other.
This website is a value judgment-free effort by UNEP to provide up-to-date information to show progress achieved on issues identified in the GEGs and the currently elaborated SDGs. It is intended to better inform both decision-makers and the general public.

Testing EDE’s graph inclusion

November 14th, 2014

F1 racing winners and age

October 22nd, 2014

Screen Shot 2014-10-22 at 16.43.46

Great overview and display of the combination age, winner, top-10, other of Formula-1 races.

Visualizing the major causes of death in the 20th Century

October 22nd, 2014



The Graphic Continuum

October 22nd, 2014


Good overview of all those different display possibilities that we have…


Climate Economy Report

October 13th, 2014

Screen Shot 2014-10-13 at 08.45.31

Very interesting website. For once, for the report (N. Stern is the key person behind). But even more for the website design. It’s like an interactive ebook brought online, with video which can play (fullscreen) in the background, links in all directions, pages which just need to be scrolled down for overview, and to the left for deeper look into it…

Pretty cool… Although, still, I don’t read the stuff, as I don’t like reading text on screen…

Neat tool for travel planning

September 5th, 2014

Screen Shot 2014-09-05 at 11.50.15

Komoot is a pretty neat tool for planning a travel. I wanted to spend a couple of days cycling with my family, and explored several tools. This one is by far the best! Nicely done!

Extract Data From PDF Tables

July 17th, 2014

Screen Shot 2014-07-17 at 10.23.06

Screen Shot 2014-07-17 at 10.23.14

Tabula: Very nice utility to extract data from a PDF table: Just upload the PDF file, highlight the table you want to extract, you’ll get a preview, and download the data in CSV format. Pretty cool!

Water Stress Index

May 13th, 2014

Screen Shot 2014-05-13 at 07.29.11

Really like that map. Maplecraft came out with a bunch of interesting maps. Wonder how they assemble and compute these different layers, for which normally such high-resolution data are not available.

Environmental Change Media Watch

May 13th, 2014

Screen Shot 2014-05-13 at 07.25.32

Interesting, very interactive site of automatic information collection/harvesting on specific environmental topics or keywords. The engine behind runs through all major social platforms and collects information and puts it into the right perspective, respectively inserts it into its larger database for connecting the dots (that is, the environmental themes, keywords, products).

Static Gapminder

April 2nd, 2014


Gapminder is a great tool. Doesn’t work with lots of combinations of data. But how to translate this into static images? Here is a nice example.

Simulation of Flight Routes

March 14th, 2014

Pixelio – Kostenlose Bilddatenbank

January 22nd, 2014

Screen Shot 2014-01-22 at 15.28.02

Sehr nützlich, eine kostenlose Bilddatenbank, Pixelio.