AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
New Member
NWhite
Posts: 2
Registered: ‎12-13-2002
Message 1 of 6 (96 Views)

Excel Co-Ords

96 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
*Gazit, Arad
Message 2 of 6 (96 Views)

Re: Excel Co-Ords

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

*George
Message 3 of 6 (96 Views)

Re:

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

*Gazit, Arad
Message 4 of 6 (96 Views)

Re:

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

*George
Message 5 of 6 (96 Views)

Re:

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

*Gazit, Arad
Message 6 of 6 (96 Views)

Re:

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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.