Can you create custom autoshapes 2

[cpretty]

Has anyone ever managed to find out how to create a custom autoshape. I want to add more connectors to some of the flowchart shapes, allowing more options for connectors.

I have created 'custom' shapes by modifying properties of shapes, then using a macro and custom toolbar to put them into the worksheet, but this wont allow me to add more connection points.

Cheers,
Craig

 

[Mutt]

What I do is to add in very small boxes on top of the autoshape at places where I want the new connection points - send these to topmost layer - remove outline and fill - then group the whole lot as one object. I keep these on a separate workbook for me to copy and paste as required. Usefull for doing process flowsheets. Bit primitive.

 

[cpretty]

Good idea. I should have thought of that as I have already done something similar.

I am using Excel to create UML stateflow diagrams, as after looking on the web, there are either overkill programs which are designed to put everything into code, or drawing programs that do UML similarly to Excel but cost heaps of $$>

Thanks for your suggestion

Craig

 

[Montemayor]

cpretty (Mechanical):

I find your question very basic and also very practical and utilitarian for all engineers. I have used the drawing capabilities of Excel for some time now - going on 7 years. I have learned to develop some pretty good process flow diagrams and have created some set and standard drawing symbols like heat exchangers, distillation towers, pumps, compressors, etc. - all using nothing more that the standard figures given in Excel. I can draw, for example just about every symbol that the ISA puts out - just as good (or better) than a class A electrical designer. I use the standard, given Excel shapes and form other shapes by merging, bringing to the front, formating shapes, grouping, erasing lines, overlaying, & other techniques.

If you are interested in seeing some samples (because this is the only way for you to learn), let me know your email address and I'll send you some sample workbooks.

This is something other engineers are presently doing (some of them are better than me, I'll bet) because of a number of reasons:

1) Excel is a common, available platform; everyone has it; no CAD or other special program has to be available to disseminate the information. And, after all, isn't the name of the engineering game "communicate efficiently"?
2) It is simple; no need for investing valuable time and effort in CAD training; keep the designers doing design - engineers have to communicate with sketches and other symbols as well. This resolves that need.
3) Engineers are given the tool of combining calculations and sketches in one document: a spreadsheet. This combines two strong, traditional ways of communicating and distributing engineering information.

This is a technique that no one, to my knowledge, has written a book or article on. It's a shame, because of the strong, communication impact it makes on your engineering applications.

Art Montemayor


Art Montemayor
Spring, TX

 

[cpretty]

I am aware of what you can do by grouping etc, but I guess I was hoping for a lazy option. If you could put your own modified autoshapes etc into Excel, no-one would buy Visio. Looks like I will have to spend a bit of setup time on this but the tool will be worth it.

Cheers,

Craig