Tip:
Highlight text to annotate it
X
Here, we can look a point set
or a 3D point cloud
you can look it in isometric shape
You can look better the 3 dimensions
of the point set
Specifically
there are 124 points
For example
Here, we select a point and it has coordinates (x,y,z)
Here, we select another point
and it has different coordinate (x,y,z)
To carry these points
to an Excel table data
You have to select "insert"
and after select "extracting data"
"Linking and extraction"
To make a new extraction of date
Go to next
New template, it's going to make an empty template.
Due to it there isn't any preselect format
Select "save"
Next
Here, we are going to analyse points.
Here we have to whole the characteristics
or properties
Only the coordinates (x,y,z) are interesting for myself
for this reason I select "geometry"
That is the category filter
Here there are properties of positions (x,y,z)
Next
Next
The exit is going to be in format:
xls,
csv,
mdb or txt.
For this case
it will be in Excel (xls) format
And the name I'm going to choose is "data set"
It'll save into desktop
Next
Finalize
Here, it's saved the data set.
Now, we'll open it.
you can look 124 points
with position (x,y,z) of them
The mistake
is than these points are selected like letters
and no as numbers
Thus, we select whole
with: "Ctrl + Shift + right arrow + down arrow"
Here, I put right button and select "convert in numbers"
Select "save"
Ready!
Now
we'll look
the inverted case
from Excel to AutoCad
We have to make a function
for that this function
is into command of AutoCad
This function is write a "equal sign",
after write "quote"
"point"
"quote"
"&"
"quote", "space"
"quote"
"&"
"position x data"
"&"
"quote"
"coma", "quote"
"&"
now
"position y data"
"&"
"quote"
"coma"
"quote"
"&"
"position z data"
The quote is used
to make
a constant value
inside of function. For example, here "point"
here "space"
and these last two "coma"
The "&"
is used to separate a data of another data
inside of function
Those "&" are put in these parts
Never the "&" is going to stay either at beginning or at ending
always it is going to stay in between
Now, I select double click.
Here
I've done all operations for 124 points.
Now
we are going to open AutoCad
Is opened AutoCad
We'll take the points.
With: "Ctrl + Shift + down arrow"
after copy with: "Ctrl + C"
select the command
Select paste with: "Ctrl + V"
Like you can look here
the points are generated automatically
Those are the 124 points
Like you can look here
it's in 3D coordinate
Here
we returned
from
a data set
from Excel to put it in AutoCad
This is all. Thank you!