Community
AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel Co-Ords

5 REPLIES 5
Back to AutoCAD Map 3D Category
Back to Topic Listing
Reply
Message 1 of 6
Anonymous
225 Views, 5 Replies
‎12-13-2002 09:30 PM
‎12-13-2002 09:30 PM

Excel Co-Ords

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
0 Likes
Reply
5 REPLIES 5
Message 2 of 6
Anonymous
in reply to: Anonymous
‎12-13-2002 11:00 PM
‎12-13-2002 11:00 PM

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
0 Likes
Reply
Message 3 of 6
Anonymous
in reply to: Anonymous
‎12-14-2002 02:07 PM
‎12-14-2002 02:07 PM

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
0 Likes
Reply
Message 4 of 6
Anonymous
in reply to: Anonymous
‎12-15-2002 01:11 AM
‎12-15-2002 01:11 AM

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
0 Likes
Reply
Message 5 of 6
Anonymous
in reply to: Anonymous
‎12-15-2002 01:25 PM
‎12-15-2002 01:25 PM

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
0 Likes
Reply
Message 6 of 6
Anonymous
in reply to: Anonymous
‎12-15-2002 03:41 PM
‎12-15-2002 03:41 PM

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
0 Likes
Reply
Reply

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost

 

Report a website issue