SankeyMATIC Manual

Example: Income [100] Checking Account

After entering one or more Flows, click “Preview”.

SankeyMATIC will automatically lay out a diagram connecting all Source and Target “Nodes” using Flows with proportional thicknesses.

Using the same Node name in multiple lines will produce multiple flows in or out of that Node.

Note: Node names are case sensitive: 'A' is not considered a match for 'a'.

[画像:Tall example]

[画像:Narrow Short example] [画像:Wide example]

Small spacing between Nodes can lead to crowded or muddy diagrams, difficult to parse visually.

[画像:Small Node spacing example]
Spacing = around 10%

Large spacing between Nodes leads to thin spidery Flows, making differences between sizes harder to distinguish.

[画像:Large Node spacing example]
Spacing = around 90%

Find a happy medium, appropriate for making clear comparisons between Flows.

[画像:Good Node spacing example]
Spacing = around 50%

Given data laid out like this in a spreadsheet document:

A	B	C
1	From	To	Amount
2	Income	Budget	100
3	Budget	Expenses	60.75
4	Budget	Savings	39.25

Add another spreadsheet column applying either of the following formulas to all of your data rows:

=A2 & " [" & C2 & "] " & B2
or
=CONCATENATE(A2, " [", C2, "] ", B2)

(Both formulas rearrange the data in the same way. Both have been tested in Excel and in Google Sheets.)

The new column will contain your data rearranged like this:

A	B	C	D
1	From	To	Amount
2	Income	Budget	100	Income [100] Budget
3	Budget	Expenses	60.75	Budget [60.75] Expenses
4	Budget	Savings	39.25	Budget [39.25] Savings

Then copy & paste the values from that new column into the SankeyMATIC “Inputs” field, and voilà: