Data management system (DMS) for block database

[Philipp]

I am working on electral planing for building equipment and calculation, so I make data extractions of dwg files very often.

For this reason I´ve made a block database with over 500 blocks that have informations like romm-number, distribution, power consumption, and so on.

 

I do the following calculations of drawn plans with the data export in CAD or for example trimble nova (electrical). I know how to manage the export files in excel from CAD-Programs or Trimble Nova.

In CAD every block has a unique number and same attributes, which is nice to filter and sum them up for different zones in the plan or in general.

 

Sometimes excel feels a bit to clunky and its complicate to filter out distances (from distrubutor to power cunsuming parts) and if the export does not follow my system like in Nova I cannot use predefined excel sheets for it and have to make them individually every time.

 

Do you know a tool thats makes the management of the output visually more intuitive and with possibility for setting up programs such as finding blocks with same distributors and calculate x/y distances, for cable lengths, to sum them up.

Autodesk Revit for example has good opportunitys to sum up informations within rvt-files and use informations that are in the underlaying ifc-buildings, combine the informations and calculate with them.

 

I can combine this informations in excel by hand very nice too, I just wanted to ask if you know alternatives or know good programs for this.

Best case would be excel import and export, direct dwg input and a intuitive workspace to write in little programs to combine and calculate with the data.

 

 

 

 

 

[BIGAL]

You can read and write direct to Excel. Not sure as to what info you want, it may be simply achieved or very time consuming.

 

You need to look at one task at a time and what are the rules for that task, a recent one is get info 2 blocks, that have same attribute value and say connecting length.

 

Can you post a dwg with individual tasks and expected results in a Excel.

[Philipp]

Thx for your reply!

Yes, I know that excel can handle this operations. The problem is that is time consuming sometimes.

I wanted to ask if someone knows pograms that can handle excel files or dwgs like for example revit wich can utilize AI or neat programs to filter and use the data.

Like when I draw things in Nova I can filter the data directly in the program, but with limits for this case.

 

I know I can do this with pivot tables in excel. Are there tools to chose it predefined, so I dont have to organize the lines by mayself everytime?

Also I know revit programs that can extract data and are able to get programs written in json? (java) too, to make more use of it. For example caneco alpi. Id like to get this besides using autodesk software.

 

Edited April 28 by Philipp

[BIGAL]

I think you miss understood me, yes you can get all block attributes and object data and do something with it, A table a CSV or to Excel. Yes can pass values to excel and run macros in Excel and return answers back to CAD.

 

I have a select blocks, sort them and count up to 5 attributes deep and make a table. A extract of the data. 

 

Again you need to explain with images, dwg, notes, Excel what your trying to achieve.