×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can you create custom autoshapes
2

Can you create custom autoshapes

Can you create custom autoshapes

(OP)
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

RE: Can you create custom autoshapes

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.

RE: Can you create custom autoshapes

(OP)
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

RE: Can you create custom autoshapes

2
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

RE: Can you create custom autoshapes

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources