Local Coordinate to Real Coordinate in AutoCAD by Excel

With the help of this video you will learn how to transform the Local coordinates or Arbitrary coordinates into Real coordinates with the help of AutoCad and Excel. With this method you can easily correct any rotational or scaling problem of your drawing while talliyng with the real coordinates. You can easily merge the drawing made by local coordinates into drawing by real coordinates.
If you want to buy for us a cup of coffee then Donate us here: www.paypal.me/learnxplore
The method I have applied for transforming arbitrary coordinates to real coordinates is described below-
1) I have taken a sample data from a field survey which was collected by ETS instrument by assuming arbitrary coordinate 10000,10000. During the filed survey i have marked the points on ground and later i have taken real coordinate data of three point by using DGPS instrument.
2) Then in AutoCAD I plot the local coordinate data by applying an easy formula in excel and made a triangle with three arbitrary coordinate points of which we have DGPS point.
3) Then I opened another drawing in AutoCAD and drawn another triangle with the known real coordinate points.
4) After that I copied all data from first drawing with Copy with Base Point option and pasted it into the second drawing.
5) Then I used ROTATE / ALIGN Command in AutoCAD to solve the rotational error.
6) After merging local coordinate based drawing with the real coordinate drawing I applied LIST Command and exported all vertices from that drawing.
7) Then with the help of excel I arranged the real coordinates data.
8) and Finally our destination is ready.I have successfully converted Local coordinate data to real coordinate data.
Try this method in your work field and if any questions are there please feel free to ask. We will definitely try to answer you all. Thank you
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!
Donate us here: www.paypal.me/learnxplore

[@gajanandeokate5457]

Thanks for all your videos sir.....

[@gayatriprojectsltd7294]

thank you very much u saved my job

[@itspaulbro1994]

Thanks for this video

[@CivilEngineeringTrainer]

Good work,keep it up.Best of Luck

[@vishdubey8531]

thank you

[@anejiti6517]

Bohot kus sikha. Samanta sir se...🙏🙏🙏🙏

[@LearnExplore]

Please comment how much you learn from this video... ☺😊

[@shabeersulthan7389]

I need global coordinate convert to local coordinate. How to convert this pls give video for that one

[@khaliddiyal7998]

Excellent

[@asfiqislam2336]

nice, useful

[@ghufairahmad5719]

Thanks a Madame

[@devbhoomiboys5628]

Also tell in Hindi language it's so important!!!

[@umerfaris5604]

Nice!

[@LearnExplore]

Thank u

[@faysalkhan5352]

Kindly explain.. How to convert local elevation to utm elevation. Tnx

[@mohammadwaseem3298]

mam I understood how to correct x,y coordinate but pls explain how to correct elevation also ( X, Y , Z)

[@itspaulbro1994]

I want to get admission in your coaching centre.

[@mesfinhailegiorgis7985]

cool

[@peoplespowerhellyeah8619]

Maam can we apply bouditch rule to get local coordinate to real coordinates or that method is only applicable to rectifying local coordinates only.

[@LearnExplore]

That method is applied only for rectification or correction. Because we may have some rotational error in local coordinate. If there is no rotational error i.e. North direction was set properly in ETS then only we can apply bouditch rule otherwise it will cause error

[@soumen52samanta]

Mam I want to get admission in your coaching centre. Please reply. And excellent video very useful for civil surveyors.

[@itspaulbro1994]

Mam I want to get admission in your coaching centre. please replay.

[@nareen1925]

I have one survey data with a Bench mark value. If i want to change the whole survey to a new value with the help of new Bench Mark??? Can anyone help in this???

[@LearnExplore]

Yes its possible. Simply add the difference of benchmark to all the cells in exxcl

[@nareen1925]

@@LearnExplore thanks 👌

[@shivamchaurasiya4102]

What is real quardinates

[@LearnExplore]

Orginal ground coordinates taken by DGPS or GPS.

[@peoplespowerhellyeah8619]

Then maam local coordinates are those which r taken by local station. Right?

[@faizanbutt3112]

Please learning in Hindi or urdu

[@surenbiddu5486]

Mujhe aapki video trustable nahi lag Rahi h mam ji

[@LearnExplore]

why

[@randheermeerwal]

Excellent