• Sankey Helper is a small macro for MS Excel, that draws simple Sankey diagrams.
• Sankey diagrams are created as editable PICT files (sample).
• Data from ordinary Excel spreadsheets are converted to Sankey diagrams.
• What Sankey Helper does is pretty basic, but it helps you create more complex Sankey diagrams.
• You can download Sankey Helper from this page (cf. below). The macro comes along with examples and a Read me file.
• Sankey Helper comes as Sankey-ware (like postcard-ware) i.e. you are allowed to use it freely (except for commercialisation of Sankey Helper) and all I ask in return is a small GIF or JPEG picture of a Sankey diagram you created with the help of Sankey Helper. Deal? Exact conditions of use in the documentation.

Sample diagram and its defining datasheet

Sankey diagrams are suitable for representing the energy or mass flows though a system. They were invented by the irish engineer M. H. P. R. Sankey (* 1853, + 1921) and were mainly used for energy flows in power plants.

The example below shows the fate of the energy in fissalbe uranium for nuclear electricity production.

Fig.1 Sample of Sankey diagram

Data from (ESU 1996): R. Frischknecht, P.Suter, G. Doka et al., "Oekoinventare von Energiesystemen", ESU (energy-materials-environment group), ETH Zurich, July 1996

Fig.2 Spreadsheet containing the defining data of the above Sankey diagram

Easy, isn't it?

Download

Sankey Helper was written for a Macintosh version of Excel 4.0. Your Excel might need to convert it which should not present any problems. Else, notify me! (Gabor Doka). I'm not a professional programmer, but I might help (and I'd like this thing bug-free).

The download files below are compressed. Decompress with suitable utilities (like stuffit expander, Unzip etc.).

Download (ZIP)	NEW Sankey Helper macro 1.1, sample data sheet (both Excel98) and Read me (as MSWord98 file), ZIP-compressed file (64kB)
Download (ZIP)	Older Version (Excel4.0) Sankey Helper macro 1.0, sample data sheet, Read me (as MSWord file), ZIP-compressed file (54kB)
Download (CPT)	Older Version (Excel4.0) Sankey Helper macro 1.0, sample data sheet, Read me (as MSWord file), Compact-compressed File (54kB)

Remember: Sankey Helper is not free-ware, but Sankey-ware!

---

Any comments or questions? Ask me (Gabor Doka)

Sankey Helper 1.1 by Gabor Doka, Zurich, Switzerland, 17. May 2003