Questions

Excel sheet data linking with autocad drawings

+
0 Votes
Locked

Excel sheet data linking with autocad drawings

bizserv.2007
Dear sir,
I have lots of autocad drawings of same template. I have an ms excel sheet with the required data (Dimensions etc) to be incorporated on to the drawings. How can I do this by linking the sparead sheet to autocad drawing.
Secondly, I want to know how to incorporate changes made in a template drawing (lines, colors etc) to get automatically updated in all drawings.
Thanks.
Venugopal
  • +
    0 Votes
    pvlaxmikanth

    Excel sheet data linking with autocad drawings can be done using vba with autocad
    pl. contact 9880617242

    +
    0 Votes

    yes

    saanjoo

    We prepare custom tools (Softwares) to prepare Autocad Drawings
    Of the Engineering Components.Some Of Our Clients Provide the
    Design Calculation Steps And Sample Drawings (Templates for Eg the
    Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes,
    Layouting, General Engineering Components , Mechanical Engineering Components,
    Civil/Structural Engineering Components,Architectural Components) to follow
    and to meet their standards and specifications.The Tools we develop are
    entirely customised and specific for clients own requirements and
    they are not re distributed to others.


    Let me be precise regarding our job profile and what we can do for you

    Suppose you have to develop any design component repeatedly for different projects
    Only Some of its parameters are changing and you need the drawing for that component.
    you cannot prepare the block for that.Since even in the custom Block in Autocad you
    cannot controll all the parameters automatically and very few users in Autocad can follow
    the technicalities to handle the customisable blocks in Autocad.
    On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can
    compute the design calculations.But And it takes a long time to develop the drawings.
    Moreover if there is any revision in the General Arrangement drawings or Facilities,
    the entire things need to change and you have to start from the scratch again and
    draftsman forget to change some of the dimensions or the BOQ values in the tables
    attached to the drawings.These things are ridiculous to your clients.
    We can understand these issues since we are in the design/Detailing and drafting industry
    for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime)
    in 3 domains
    (Piping,Architecture and Structural)
    And now we have attained the expertise to develop the dxf files from Excel/EXE Applications.
    We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for)
    to develop these drawings automatically.


    Suppose you want to develop the drawings of doors/Panels with some given features many/some of
    which will change every time from task to task or from revision to revision or from project to project.
    You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of
    these several components.We can save this valuable time for you through the tools.

    Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro
    and you have to type the utilisation ratios and reactions beside the members including the sizes also.
    Have you ever calculated how much time you spend on that and how much errorprone are these ??????
    We can help you in these matters also.

    We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the
    BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide
    tools to you which will read the data from your dimensions in specific layer and will type them
    in the excel format.And can prepare the drawings of some other feature from the extracted dimensions.


    We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for
    MIS purposes and the custom checking tools for word processing industries/Quality control departments.
    We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA
    PDF technologies also.We work in the digitisation works also.


    Contact jhatsolve@gmail.com with subject "jhatsolve"

  • +
    0 Votes
    pvlaxmikanth

    Excel sheet data linking with autocad drawings can be done using vba with autocad
    pl. contact 9880617242

    +
    0 Votes

    yes

    saanjoo

    We prepare custom tools (Softwares) to prepare Autocad Drawings
    Of the Engineering Components.Some Of Our Clients Provide the
    Design Calculation Steps And Sample Drawings (Templates for Eg the
    Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes,
    Layouting, General Engineering Components , Mechanical Engineering Components,
    Civil/Structural Engineering Components,Architectural Components) to follow
    and to meet their standards and specifications.The Tools we develop are
    entirely customised and specific for clients own requirements and
    they are not re distributed to others.


    Let me be precise regarding our job profile and what we can do for you

    Suppose you have to develop any design component repeatedly for different projects
    Only Some of its parameters are changing and you need the drawing for that component.
    you cannot prepare the block for that.Since even in the custom Block in Autocad you
    cannot controll all the parameters automatically and very few users in Autocad can follow
    the technicalities to handle the customisable blocks in Autocad.
    On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can
    compute the design calculations.But And it takes a long time to develop the drawings.
    Moreover if there is any revision in the General Arrangement drawings or Facilities,
    the entire things need to change and you have to start from the scratch again and
    draftsman forget to change some of the dimensions or the BOQ values in the tables
    attached to the drawings.These things are ridiculous to your clients.
    We can understand these issues since we are in the design/Detailing and drafting industry
    for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime)
    in 3 domains
    (Piping,Architecture and Structural)
    And now we have attained the expertise to develop the dxf files from Excel/EXE Applications.
    We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for)
    to develop these drawings automatically.


    Suppose you want to develop the drawings of doors/Panels with some given features many/some of
    which will change every time from task to task or from revision to revision or from project to project.
    You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of
    these several components.We can save this valuable time for you through the tools.

    Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro
    and you have to type the utilisation ratios and reactions beside the members including the sizes also.
    Have you ever calculated how much time you spend on that and how much errorprone are these ??????
    We can help you in these matters also.

    We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the
    BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide
    tools to you which will read the data from your dimensions in specific layer and will type them
    in the excel format.And can prepare the drawings of some other feature from the extracted dimensions.


    We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for
    MIS purposes and the custom checking tools for word processing industries/Quality control departments.
    We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA
    PDF technologies also.We work in the digitisation works also.


    Contact jhatsolve@gmail.com with subject "jhatsolve"