Matronics Email List Photo Share


If you wish to submit a Photo Share of your own, please include the following information along with your email message and files:

1) Email List or Lists that they are related to:
2) Your Full Name:
3) Your Email Address:
4) One line Subject description:
5) Multi-line, multi-paragraph description of topic:
6) One-line Description of each photo or file:

Email pictures and files along with the information above to:

pictures@matronics.com

Please note that the adding of your files to the Photo Share Directory is a semi-manual process and will take a few days to become available. A message will be posted to the Email List(s) you indicated in #1 above with a link to the new Photo Share when it is available.

To view other Photo Share's members have submitted, have a look at the main Photo Share Index Page:

http://www.matronics.com/photoshare
Matt Dralle
Email List Administrator



Submitted By:   billschlatterer@sbcglobal.net
Email List:   AeroElectric-List
Name:   

Bill Schlatterer

Date:   

Jan 1 2006

Subject:   How to build custom connecting shapes (parts) for schematics in Excel
Description:   

Excel can work pretty nicely for a wiring schematic if you use the connecting lines features so that shapes move with the attached wires as you add pieces. I put a couple of screen shots up earlier on how to use connecting lines and the flow chart functions and thought that maybe a quickie on how to make custom shapes that look like real parts would be handy. Jeff reminded me that you can group shapes to make custom parts that look like whatever you choose.

You can make them look just like Jeff's or Bobs or you can do more of a comic book design that is meaningful to you. I sort of prefer switches and relays to look like the real thing and wires should attach to the points inside the shape and not just the outside corners. That is primarily because this wiring thing is all new to me and I need really simple diagrams.

On the attached screen shot, there are three steps to making a custom shape. I chose to make a DPDT switch and it took all of 30 seconds. You can see the steps and the finished product connected to a S704 relay. When complete, you can use the connecting lines tools and then the wires will move with the shapes if you shuffle them around.

These are comic book but if you like, you can make them exactly to match Bobs or industry standards. If you do something to standards, why not think about posting it for everyone to use?

Have fun!

Bill S
7a Ark
fuse/panel

 
    Excel_Grouping_Help.jpg Screen shot showing how to make custom shapes (parts) that will work with connecting line tools in schematics, once attached the shapes and lines will move together.





Other Matronics Email List Services

  • UN/SUBSCRIBE
  •   http://www.matronics.com/subscription
  • Full Archive Search Engine
  •   http://www.matronics.com/search
  • 7-Day List Browsing
  •   http://www.matronics.com/browse
  • Browse the List Digests
  •   http://www.matronics.com/digest
  • Live Online Chat!
  •   http://www.matronics.com/chat
  • Archive Downloading
  •   http://www.matronics.com/archives
  • Photo Share
  •   http://www.matronics.com/photoshare
  • Other Email Lists
  •   http://www.matronics.com/emaillists
  • Contributions
  •   http://www.matronics.com/contributions

    These Email List Services are sponsored through the generous contributions of its members.

    -- Please support this service by making your Contribution today! --