flowsheeting in excel, drawings + calculations

[Lalbatros]

Hello,

For the holidays period, I would like to have some fun with the Excel drawing features.
I am using the Excel drawing features quite a lot for representing flowsheets.
Besides, I have also developped a specialised class library that I am using in Excel to calculate the flowsheets.

So the next step should be: draw the flowsheet and have the calculations done (some intermediate steps needed!).

I would be quite interrested by your suggestions about how to do that without too much effort.

For example:

- is it possible to define custom autoshapes?
- is it possible (in a simple way) to give useful names to the connection point on an autoshape?
- is it possible to trap some events like when a connection is created on a drawing?
- have some people already built some similar tool?
- generally speaking, how far could I go trying to "read" the xl drawings and translate them into engineering calculations

Thanks for your suggestions