Export Coordinates from AutoCAD to Excel in regular intervals via LIST and LOGFILEPATH COMMAND
Vložit
- čas přidán 25. 08. 2024
- In this session I have shown how to export coordinate data i.e. Easting Northing data from an alignment drawing in AutoCAD to Excel. If you have only a drawing of an alignment of Road project, Railway project or any other project and you want to export the chainage wise coordinate details then this video will be helpful to you.
First, I applied MEASURE command to split the alignment in a fixed interval by placing POINTs through the alignment.
Then selected all points.
Then I applied LOGFILEPATH, LOGFILEON Command and then applied LIST Command in AutoCAD to extract the all POINTs data.
Then I copied all data to excel and used Text-to-Column feature in excel and extracted the coordinates for each chainage.
I have also shown how to cross check the extracted data by applying formula in EXCEL.
Hope you will like this video.
________________________________________________________________________
Join this channel to get access to premium excel sheets:
/ @learnexplore
Your little support will boost our potential to serve you more educative contents.
If you think this tutorial is helpful please Like & Share this video and Subscribe our channel to get free updates
With best wishes
L&E Team!
Extremely sorry for the background music, will recitify in next video. Please give a LIKE 👍 to show your support 🙏
Sir do you have a video tutorial sir on leveling surveying and how to compute for elevation from a given benchmark?
And do you have a tutorial on how to compute manual surveyed traverse and getting its correction and adjusted coordinates using excel?
Because i remember we did a traverse using TS but manually, our G.E wrote the direct and reverse & dist. shots in a paper then he did some sort of getting the mean of those then plotted in civil3d align the traverse in our given benchmarks (primary control) then he did some sort of computing of corrections and adjustments to get the coordinates of the 2ndry control we made in the ground
do u have a video like that
and if not i hope u do a video something like that. thanks alot and godbless.
good
Very useful video for every surveyor..💯👌
Thank you! This is very useful.
Best
First view👍👍
Please LIKE this video too if helpful
@@LearnExplore yes sir
Beautiful explain
Great 👍
Thanks
👍
I think Data Extraction command is same more useful.
Sir Easting and Northing Coordinat Revert Tell me how to fix it Sir
❤😂❤ thank
Hello sir how are you? I want formola (if) in excel that saying If the bearing is coming in part one add nothing
If coming in part two {180-bearing} or coming in part 3 {bearing -180} or coming in part 4 {360-bearing} if you have any idea about that please thaks
Yes. Similarly i made a program.
czcams.com/video/AQdk-kwCrSs/video.html
Download this file and unprotect it by password: LandE
You will see the formula
Why you couldn't use data extraction command?
We don't have vertices
Thank you for the data extraction info.
I need this excel sheet brother can you send me please
How to create a logfile path sir
Use logfilepath command
Isse easy Cad Tools K dwaara Excel Sheet Nikalta hai...
I agreed.
But with this method one can get the base knowledge of this conversion.
IT'S LONG PROSESS
Yes. It's like a jugaar. But somehow helpful
I enter quite too long with my 15000 points
No problem. You can export it
Pa g just make alignment and export file report…. Gal muk gayi… yea kya laila majnoon ki lamahdod kahani suna rahay ho…