Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

HELP-Creating a design which can send Matrix or other form of data

Anonymous

HELP-Creating a design which can send Matrix or other form of data

Anonymous
No aplicable

Basically we are looking in creating a logical diagram which indicates multiple locations that are also point of failures. We would like to know if with CAD (or another program) it is possible to have a matrix or some other form of data that indicates where is the point of failure.

 

Example:

 

A----B---C---D---E---F

 

We have 6 connections and lets say that there is an issue with point D and therefore E and F are offline. Can CAD generate data or matrix where it indicates that the issue is from D on wards?

 

Thanks

0 Me gusta
Responder
481 Vistas
5 Respuestas
Respuestas (5)

natasha.l
Alumni
Alumni

Hello @Anonymous, 

 

This is the AutoCAD forum so I can only speak on the functionalities of AutoCAD, maybe another member of the community can provide advice on other Autodesk applications. 

 

You should be able to extract attribute information from blocks or objects into a table object or CSV file for use in another application like Excel. The Data Extraction wizard is the most efficient way to extract attribute information. It can also be used to extract property values that are associated with the other types of geometry defined in a drawing along with general information about a drawing file. Then possibly use excel formulas to create/collect failure data. 

 

Please "Accept Solution" if a reply or replies have helped resolve the issue or answered your question, to help others in the community.

0 Me gusta

Alfred.NESWADBA
Consultant
Consultant

Hi,

 

may I ask why you think this is a CAD job?

 

From what I see you have a table and fill values (or get values from anywhere else), that sounds more like Excel or databases with queries.

 

Maybe it helps to understand what you need if you show a sample with data :cara_guiñando_un_ojo:

 

- alfred -

------------------------------------------------------------------------------------
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2025
------------------------------------------------------------------------------------

(not an Autodesk consultant)
0 Me gusta

leeminardi
Mentor
Mentor

Here's a simple Excel file that does what I think you want.

The formula in cell C3 is:  =B3

The formula in cell C4 is:  =IF(AND(B4 ="Yes",C3="Yes"), "Yes","No")

and it is filled down column C.

 

Changing the operational state of any connection yields No for that connection and the following dependent connections.

 

image.png

 

lee.minardi

Anonymous
No aplicable

We have the current setup and would like to know if with CAD we can get a matrix or some sort of report in case a link or part of it is down. Links indicated below in this snapshot from one of our drawings.
node.JPG

0 Me gusta

Alfred.NESWADBA
Consultant
Consultant

Hi,

 

>> if with CAD we can get a matrix or some sort of report

If you want to get a report from the parts you showed in the screenshot, and in case these parts are blocks with attributes, then you can use _DATAEXTRACTION to create such a report.

 

If these objects are no blocks then please upload the drawing file so we know which types of objects that are.

 

>> Links indicated below in this snapshot

Sorry, I can't see any links in the screenshot (at least don't understand what you mean by links (sorry for my limited English skills)).

 

- alfred -

------------------------------------------------------------------------------------
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2025
------------------------------------------------------------------------------------

(not an Autodesk consultant)
0 Me gusta