![]() However when we go to setup our test procedure, we have to do 40-50 separate schematics showing each individual pressure test (we pressure test each component of the system). I think AutoCAD can do what you want but, as previously suggested, why not just go to AutoCAD and draw the lines and component symbols? I'm certain that industry standard hydraulic schematic symbols are available from third party software vendors as AutoCAD blocks. I know a guy who is an expert with LISP programming who automatically generated very complex P&ID diagrams using AutoCAD given an external list of components and connectivity. New here? Try reading these, they might help FAQ731-376: Forum Policies RE: Creating Hydraulic Schematics in Excel (or other programs) zdas04 (Mechanical) 22 Oct 14 17:35 There are many languages and toolboxes around that support drag and drop GUIs, visual basic being the only one I have worked with. Ī google search turned up many possibilities including and This is not strictly relevant as it is electronic but I think it is the sort of thing you are aiming at. ![]() Obviously there are heavyweight alternatives such as simulink, which is probably overkill for your rather binary circuits (lines are either high pressure or low pressure I take it), but depending on what you think your time is worth it may make sense. RE: Creating Hydraulic Schematics in Excel (or other programs) GregLocock (Automotive) 22 Oct 14 17:17Īt first glance it seems to me that building a CAD-GUI inside Excel is possible, but not easy. The end product should be somewhat reasonably edited for different configurations and products. This may be too ambitious of a project to do in Excel, but I would like to know if it could be done (reasonably). The next step would be to change which valve is being tested, and the pressure paths should change colors dynamically. Red path is under pressure, and green path is not under pressure. So in this diagram we are testing that V1, V4, and V5 are completely sealed. All other valves are closed, so the green paths beyond those valves are where we check for leakage. It then enters through valve 3 (V3) and passes through the OPEN V2. In the attached image, we are putting pressure into the system at BBBB. I want to designate which valves are closed and which are open, then see the fluid path based on this criteria. ![]() The numbers in the hexagons are links (02 from AAAA links to 02 into V1) In the diagram below we have 4 inputs/outs: AAAA, BBBB, CCCC, DDDD I created a basic sketch of what I want to achieve in the program, although the method of creating the design is flexible (fill in cells, using drawing symboles, etc). Im not looking for exactly how to do this, but rather different ideas to accomplish the end goal. I am looking to develop hydraulic system schematics in Excel (feel free to suggest other software that can do this!!!). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |