I am working on a steel repair project and has got lot of repairs.
After I design and draft all my repairs and sections (steel angles, plates, concrete sections etc.) can i extract the dimensions along with their names, so I can avoid manual inputs (length, width, thickness, angles) on excel to quantify them.
I understand fully automation won't be feasible, where i need to manually input the weights and any other required elements on the excel.
But at least if could get to extract the repair pieces names, their drafted dimensions to excel, that could save days worth of work for 200 to 300 repair pieces.
Also, if the above option is feasible, can the MicroStation update the excel exported if any of the repair plates change?
Hi, I am working on a steel repair project and has got lot of repairs. After I design and draft all my repairs and sections (steel angles, plates, concrete sections etc.) can i extract the dimensions along with their names, so I can avoid manual inputs (length, width, thickness, angles) on excel to quantify them. I understand fully automation won't be feasible, where i need to manually input the weights and any other required elements on the excel. But at least if could get to extract the repair pieces names, their drafted dimensions to excel, that could save days worth of work for 200 to 300 repair pieces. Also, if the above option is feasible, can the MicroStation update the excel exported if any of the repair plates change? Looking forward for a response. Thank you
you can use Item Types and reports to create lists of quantities and then export the list to Excel. Reports will work with most dgn properties and not only item types.
Here are some Wiki articles that can help onboarding with both Item Types and Reports.
Hi,
I am working on a steel repair project and has got lot of repairs.
After I design and draft all my repairs and sections (steel angles, plates, concrete sections etc.) can i extract the dimensions along with their names, so I can avoid manual inputs (length, width, thickness, angles) on excel to quantify them.
I understand fully automation won't be feasible, where i need to manually input the weights and any other required elements on the excel.
But at least if could get to extract the repair pieces names, their drafted dimensions to excel, that could save days worth of work for 200 to 300 repair pieces.
Also, if the above option is feasible, can the MicroStation update the excel exported if any of the repair plates change?
Looking forward for a response.
Thank you
Hi,
I am working on a steel repair project and has got lot of repairs.
After I design and draft all my repairs and sections (steel angles, plates, concrete sections etc.) can i extract the dimensions along with their names, so I can avoid manual inputs (length, width, thickness, angles) on excel to quantify them.
I understand fully automation won't be feasible, where i need to manually input the weights and any other required elements on the excel.
But at least if could get to extract the repair pieces names, their drafted dimensions to excel, that could save days worth of work for 200 to 300 repair pieces.
Also, if the above option is feasible, can the MicroStation update the excel exported if any of the repair plates change?
Looking forward for a response.
Thank you
Hi Luis,
you can use Item Types and reports to create lists of quantities and then export the list to Excel. Reports will work with most dgn properties and not only item types.
Here are some Wiki articles that can help onboarding with both Item Types and Reports.
https://communities.bentley.com/products/microstation/b/microstation_blog/posts/reporting-for-cad-administrators-cell-count-reports
https://communities.bentley.com/products/microstation/w/microstation__wiki/23833/item-types---properties---microstation
https://communities.bentley.com/products/microstation/b/microstation_blog/posts/excel-and-item-type-integration
https://communities.bentley.com/products/microstation/b/microstation_blog/posts/simple-quantities-in-the-microstation-connect-edition
I hope this helps,
Regards,
Marco Salino
Product Manager, MicroStation