• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
    • Discussion Groups

    AutoCAD Map 3D

    Reply
    Topic Options
    NWhite
    New Member
    Posts: 2
    Registered: ‎12-13-2002

    Excel Co-Ords

    Options
    91 Views, 5 Replies
    12-13-2002 09:30 PM
    Hi This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and turn them into a spreadsheet which looks like this
    P10 2064.800 2001.050
    P11 2065.700 1999.475
    P12 2063.900 1999.475
    P13 2072.000 2001.050
    P14 2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting and the Second the Northing

    i need to do about 5000of these so doing them by hand is tiring and dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i can constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil
    Report Inappropriate Content
    Message 1 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.
     
    *Gazit, Arad

    Re: Excel Co-Ords

    Options
    12-13-2002 11:00 PM in reply to: NWhite
    Neil hi,

     

    Autodesk Map can do this quiet easily. I don't know
    if you have this program, but you can send me your file and I will send you back
    an ASCII text file which you can import into Excel.

    Try sending a small dwg (Only the needed
    objects).

     

    Arad


     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    Hi
    This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel
    spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and turn them
    into a spreadsheet which looks like this
    P10 2064.800 2001.050
    P11
    2065.700 1999.475
    P12 2063.900 1999.475
    P13 2072.000 2001.050
    P14
    2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting and the
    Second the Northing

    need to do about 5000of these so doing them by hand is tiring and
    dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i can
    constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil

    Report Inappropriate Content
    Message 2 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.
     
    *George

    Re:

    Options
    12-14-2002 02:07 PM in reply to: NWhite
    I am very interested in how you can do that. 
    I do have Autocad 2000 map. Can you please tell me also.  I need to have
    all the points exported to excel.

    Thank you


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Neil hi,

     

    Autodesk Map can do this quiet easily. I don't
    know if you have this program, but you can send me your file and I will send
    you back an ASCII text file which you can import into Excel.

    Try sending a small dwg (Only the needed
    objects).

     

    Arad


     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    Hi
    This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel
    spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and turn
    them into a spreadsheet which looks like this
    P10 2064.800 2001.050

    P11 2065.700 1999.475
    P12 2063.900 1999.475
    P13 2072.000
    2001.050
    P14 2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting and
    the Second the Northing

    need to do about 5000of these so doing them by hand is tiring and
    dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i can
    constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil

    Report Inappropriate Content
    Message 3 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.
     
    *Gazit, Arad

    Re:

    Options
    12-15-2002 01:11 AM in reply to: NWhite
    Hi George,

     

    To make a long story short:

     

    1- Open a new, empty drawing and attach your file
    to it.

     

    2- Define a query that will return only the wanted
    objects (Use any of the criteria you need: Layer, object type, location, data
    ...).

     

    3- Execute the query in Report mode and define in
    the report the information you want (X, Y, Z, Block name, Size, scale, attribute
    ...).

     

    4- Open your report file (An ASCII text file) with
    your favorite editor/spreadsheet and complete your report (Statistics, Formating
    ...).

     

    Good luck,

    Arad

     

     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    I am very interested in how you can do
    that.  I do have Autocad 2000 map. Can you please tell me also.  I
    need to have all the points exported to excel.

    Thank you


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Neil hi,

     

    Autodesk Map can do this quiet easily. I don't
    know if you have this program, but you can send me your file and I will send
    you back an ASCII text file which you can import into Excel.

    Try sending a small dwg (Only the needed
    objects).

     

    Arad


     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    Hi
    This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel
    spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and turn
    them into a spreadsheet which looks like this
    P10 2064.800 2001.050

    P11 2065.700 1999.475
    P12 2063.900 1999.475
    P13 2072.000
    2001.050
    P14 2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting and
    the Second the Northing

    need to do about 5000of these so doing them by hand is tiring and
    dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i can
    constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil

    Report Inappropriate Content
    Message 4 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.
     
    *George

    Re:

    Options
    12-15-2002 01:25 PM in reply to: NWhite
    I'm sorry I dont get it.  Attach which file to
    the new drawing? Where does Excel come into play?

    Can you please elaborate a little more.
    Sorry and thanks.

    George


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Hi George,

     

    To make a long story short:

     

    1- Open a new, empty drawing and attach your file
    to it.

     

    2- Define a query that will return only the
    wanted objects (Use any of the criteria you need: Layer, object type,
    location, data ...).

     

    3- Execute the query in Report mode and define in
    the report the information you want (X, Y, Z, Block name, Size, scale,
    attribute ...).

     

    4- Open your report file (An ASCII text file)
    with your favorite editor/spreadsheet and complete your report (Statistics,
    Formating ...).

     

    Good luck,

    Arad

     

     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    I am very interested in how you can do
    that.  I do have Autocad 2000 map. Can you please tell me also.  I
    need to have all the points exported to excel.

    Thank you


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Neil hi,

     

    Autodesk Map can do this quiet easily. I
    don't know if you have this program, but you can send me your file and I
    will send you back an ASCII text file which you can import into
    Excel.

    Try sending a small dwg (Only the needed
    objects).

     

    Arad


     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    Hi
    This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel
    spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and
    turn them into a spreadsheet which looks like this
    P10 2064.800
    2001.050
    P11 2065.700 1999.475
    P12 2063.900 1999.475
    P13
    2072.000 2001.050
    P14 2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting
    and the Second the Northing

    need to do about 5000of these so doing them by hand is tiring and
    dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i
    can constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil

    Report Inappropriate Content
    Message 5 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.
     
    *Gazit, Arad

    Re:

    Options
    12-15-2002 03:41 PM in reply to: NWhite
    O.K. George,

     

    It was a bit short-hand but I guess some basic
    training will help.

     

    I will try and clarify what you asked:

     

    When working with Map you can set up a "Work
    session" in which you have an open drawing and a set of attached drawings (one
    or more).

    This is done by creating  "Drawing set". I am
    not going to get into this here.

     

    The report you create when Quering objects from
    your "Drawing set" is always a *.txt (ASCII format) file.

    Excel is one tool that can be used to open this
    report file and work on.

     

    I hope this helps,

    Arad


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    I'm sorry I dont get it.  Attach which file
    to the new drawing? Where does Excel come into play?

    Can you please elaborate a little more.
    Sorry and thanks.

    George


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Hi George,

     

    To make a long story short:

     

    1- Open a new, empty drawing and attach your
    file to it.

     

    2- Define a query that will return only the
    wanted objects (Use any of the criteria you need: Layer, object type,
    location, data ...).

     

    3- Execute the query in Report mode and define
    in the report the information you want (X, Y, Z, Block name, Size, scale,
    attribute ...).

     

    4- Open your report file (An ASCII text file)
    with your favorite editor/spreadsheet and complete your report (Statistics,
    Formating ...).

     

    Good luck,

    Arad

     

     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    I am very interested in how you can do
    that.  I do have Autocad 2000 map. Can you please tell me also. 
    I need to have all the points exported to excel.

    Thank you


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

    Neil hi,

     

    Autodesk Map can do this quiet easily. I
    don't know if you have this program, but you can send me your file and I
    will send you back an ASCII text file which you can import into
    Excel.

    Try sending a small dwg (Only the needed
    objects).

     

    Arad


     


    style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    Hi
    This is my first post and I'm Very New to AutoCAD

    I'm an engineer and need to turn an AutoCAD drawing into an excel
    spreadsheet

    what I need is to lift the Co-Ords from the centre of Circles and
    turn them into a spreadsheet which looks like this
    P10 2064.800
    2001.050
    P11 2065.700 1999.475
    P12 2063.900 1999.475
    P13
    2072.000 2001.050
    P14 2072.900 1999.475
    P15 2071.100 1999.475


    Where P15 is the Name of the point and the first Co-Ord is Easting
    and the Second the Northing

    need to do about 5000of these so doing them by hand is tiring
    and dangerous as i'm bound to miss type one

    It would also be hand to do the same but the other way around, so i
    can constuct an Asbuilt drawing from an excel spreadsheet

    Thanks in advance I hope someone can help

    I can Email copies of drawings or Spreadsheets if need be


    Neil

    Report Inappropriate Content
    Message 6 of 6 (91 Views)
    Reply
    0 Kudos
    Please use plain text.