waterflow chart with calculation

Hi, I want to make a very difficult waterfall chart from the following table: Name Type1 Type2 Type3 S C D A TBD a1 A # P 1     1   a2 B ...