Introduction of drawing table
Drawing table is an important feature in engineering drawings. It is one of the means of communicating required information between manufacturing partners or confined to a single manufacturing plant. There are different tables in engineering drawing for example BOM Table, Hole Dimension Table, Design table etc. . .
Many Manufacturing sectors have different norms of tables in their work-space and most users want some additional options in table than the conventional one. So it consumes so much time to generate drawing tables following those conventions. Since there is a human intervention in this monotonous work there are more chances of making miss-entries or missing some data in table. These kind of mistake can lead to a huge impact on the end product. So there is a need to automate the process of creating tables which should be enhanced one than manually created tables.
This business situation requires:
Automating the process of generating and updating of tables and check whether entered data is valid to reduce time consumption.
To reduce Human Errors like missing data and miss-entries caused because of monotonous work.
Make attribute links to each text range of the table so that whenever there is a modification in data table will update automatically.
Along with table operations some users follow font standards in Drawing sheet so it is also required to set font properties of each text range in drawing table as of excel file.
There were a range of challenges faced during the course of the project. Few of them are listed below:
After carefully consideration of requirements and analysis of the API provided by the CAD system, we have come up with two macros.
Macro to generate table from Excel data.
Some of the features we included in import table command are:
Macro to extract table data and store in excel file.
Some of the features we included in export table command are:
Some of the results that we achieved through these macros are:
Flexibility for user to handle Drawing tables with ease.
Attribute links to each text range in table gives updation of data according
to changes in sheet. Hence makes tables more enhanced.
Validating of table data and reflecting wrong data to users.
Since macro can handle variety of tables. Hence increases productivity of users.