Open Traverse Theory & Excel Sheet for Correction | Land Surveying

Today, we will discuss about open traverse correction in land surveying in this video. Also, we have prepared an Excel based software for open traverse correction. Okay, so before sharing the excel sheet, I want to request you to watch the full video so that you can use the Excel sheet without any problem. Now, I will give a basic concept about open traverse and how field data have been obtained and what are the corrections we apply in open traverse surveying. Basically, in Closed Traverse survey, we start collecting data from a point and finally, return to the same point right. Thus we make a polygon in closed traverse. For correction of closed traverse, we already shared an Excel sheet which is available in our channels link. If you need the same then you can check it out from our channel playlist right. Now in open traverse, we start surveying from a known point to another known point okay. In modern surveying, two pair of known points are used in open traverse surveying which have been set by the DGPS that means Differential Global Positioning System, Total Station has been used to take measurements of intermediate points. Due to several factors like instrumental error or any other error like weather, humidity anything the total station data needs correction right. In this Excel sheet we apply Bowditch rule and use for the correction of open traverse data. This is our open traverse line diagram with the help of this line diagram I will explain the basic concept behind the open traverse theory okay. So here you can see the GPS 1 the GPS 2 the GPS 3 and GPS 4 points. These points are taken by this points are taken by DGPS also corrected by the DGPS and these points are known to us that means this is a known coordinates okay and with the help of total station we will take the intermediate points between this DGPS points okay. These intermediate points are basically taken for setting up the Temporary Benchmark of any project such as road projects, railway projects and any other projects okay and this total station set up is oriented by this known station points. Okay. We will sifting the total station many more places because of the indivisibility from one station. Okay, and at first we are setting up our total station in Station 1. This is okay station one and we are oriented our total station by this GPS 1 and GPS 2 points and from this setup we are taking the intermediate point P 1 and P 2 okay. After taking these points, other points are invisible so we are setting up our total station in Station 2, okay and this setup is oriented by Station 1. After setting up our total station in station 2, we're taking point three and point four in this way we are taking all the intermediate points and lastly, we set up our total station here and we taking this known points, GPS 3 and GPS 4 points with the help of our total station because of the correction we will find out the deviation between the GPS points with the help of total station data taking okay. And on behalf of that deviation, we will apply our open traverse correction which is made by us in an Excel sheet manner.
You have to just copy and paste your data and this output will be generated automatically and you can see these delta easting and delata northing is adjusted in each point with respect to its cumulative length. Okay. And one more thing you must have to take the data of GPS 3 GPS 4 with the help of ETS and also this GPS 3 and GPS 4 this Point ID must match with this intermediate points, okay. Otherwise our Excel sheet will not work. I hope you guys understood what I have shown here, okay and I have given the downloaded link in the Comment section. You can download it. Thank you guys for watching this video. I hope it will help you in your surveying work.
Also we have shared an excel spreadsheet for Traverse Corrections and Traverse Calculations by Compass Rule or Bowditch Rule. You can watch it here:
Closed Traverse: • Traverse Correction in...
There we have described about Traversing:
what are the types of Traverse (closed traverse, Open Traverse), Traverse calculations and adjustment of closing errors, traverse precision, latitude and departure, Bowditch Rule/Compass Rule, Transit Rule etc.
Surveying Traverse: How to Close a Traverse: Traverse adjustment
We request you all please do SUBSCRIBE our channel. And if you think that this video will help you please do LIKE SHARE and COMMENT so that other also can get help from this video.
Regards
SHREE
SOU
from LE Team!

[@LearnExplore]

Download the Excel Program: Purchase link: for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram Thanks LE Team

[@prokashkumar3870]

Many many thanks.

[@muhammadaikoyeyoonus6666]

Go a long way in help in correcting works

[@itstravelingmallik8557]

Sir pl send the Excel copy to my I'd - [e-mail] Sir humbal request to you make video on the toppic of Traiangulation traversing wich we have used on tunnel project .

[@radheykrishnachoudhury3842]

Sir, I humbly thank you for your efforts, sir please send it on my mail [e-mail]

[@samiaj1020]

Wornderful work. Keep it up. I am working on road project please send me the file at: [e-mail]

[@singhbrajesh89]

I have gained lot of knowledge of survey from your channel.God bless you & your team.

[@LearnExplore]

Thanks for your valuable comment.

[@BenefoColbe]

The explanation is very clear and helpful thankyou very much. I would need this excel file for my project.

[@BenefoColbe]

Can you send me the download link please.

[@LearnExplore]

Please see pinned comment. If any contact us

[@noorbabamohd2843]

I need angle and distance open traverse correction sheet

[@shahabali2549]

YES SIR

[@meshacknyakinda6907]

This is very helpful .Great work for Engineering surveying .

[@meshacknyakinda6907]

Can I get the excel for open and closed traverse in my email [e-mail].

[@LearnExplore]

We already send the access to download. Pls check your email.

[@meshacknyakinda6907]

Learn & Explore The link just expired

[@ratanpandey9685]

Thank you so much for sharing this knowledge of traversing details with correction rule. I would like to take this excel formule. Thanks and regards.

[@LearnExplore]

Thank you for your interest Please go through the link in the pinned comment

[@mervinconquillo4099]

Very helpful😊 thank you very much.. let me take the trial version first

[@deboprasadbiswas1987]

Sir, please make also a video and excel sheet for open traverse........and describe the difference of two.....

[@LearnExplore]

ye open traverse ka hi video he

[@deboprasadbiswas1987]

@@LearnExplore sorry sir I mean to say closed traverse.....

[@LearnExplore]

Closed traverses er video deoa ache. Ei video tar end screen e jau link pabe

[@souravkunti4966]

Sir please send me this format ❤

[@LearnExplore]

Please follow the link provided in the comment section

[@singhbrajesh89]

Kindly make videos on curve including transition curve

[@densherpa]

Which teaversis correct ,? Easting ,northing method or bearing and distence method?

[@LearnExplore]

Mathematically both are same

[@anandcreation3906]

Can you explain how to prepare excell sheet for traverse by self and what's the formula used in excel

[@neerajgupta1975]

Very good knowledge about traverse calculations....

[@singhbrajesh89]

Kindly make a series on excel formula important for surveying.

[@LearnExplore]

good recommendation. Thanks. Will think about it!

[@debashiskoley8800]

It's very useful Need Excel sheet with formula

[@oscarandaus3618]

very interest, and i will use it due to some challanges of control points on road project where i work as a chief surveyor.

[@LearnExplore]

Best of luck sir!

[@kaustubhinamdar4398]

Hello sir where do you work as a chief surveyour

[@urgesageleta139]

Thankyou for your tutorial it is very use ful video

[@urgesageleta139]

Sir I am surveyor. I works on road project , and it helps me on my work can you send me the excel spreadsheet link?

[@LearnExplore]

Please see pinned comment. Follow the purchase link

[@sachinyoutub100]

It’s useful details for all Survyor

[@LearnExplore]

Thank You for your valuable feedback 😊

[@RajuMS-rz6hv]

Thanks Sir received the file just now.

[@LearnExplore]

You are welcome. Learn & Explore

[@taiyabali5730]

This video is useful for highway project. Thank alot.

[@sivaramnama9375]

sir when i click edit enable in excell all the formulas are dis appear and the file is not working please solve this issues

[@LearnExplore]

Pl send fresh access request. Thanks for being a member of our channel

[@sailaskuyeruka3451]

Nice work and informative...can use this in all my traverves corrections

[@LearnExplore]

Go ahead!

[@masudrashed4201]

This is very helpfully.I need this plz

[@LearnExplore]

Traverse Correction program for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram

[@pranaybadgujar3278]

Can TS setup 1 and GPS point 1 , can be on same location point?

[@LearnExplore]

Yes. No problem on that

[@alaliboalalibomercy6953]

So educating. I will love to practice it. Please the download link is needed. Many thanks

[@subhadipmondal2198]

Thanku sir❤❤❤❤❤ Full support sir

[@harshitgupta3002]

Very Useful for Survey Engineers..

[@LearnExplore]

Glad you think so!

[@MdShujaethossain]

Very use ful for any surveyor.plz give me sir

[@jacksonkaruiru5638]

The piece is really informative. Good work. But am interested in knowing where the delta N and delta E came from, kindly.

[@amitkushwaha_0]

Thank You so much sir for your given useful knowledge ❣️❣️❣️👍👍😊

[@LearnExplore]

You are welcome 😊

[@maheshpande3688]

Nice and helpful video

[@ajaykumar-yf2en]

I am big fan of le

[@LearnExplore]

It means a lot!

[@jenishn2675]

Thank you! Could u help me to get the excel file to understand the formula?

[@diegobracho994]

hello i need to get the excel file because I have homework about traverse that I cannot do

[@LearnExplore]

Ook

[@Karthiseenu]

Thank you so much guruji

[@LearnExplore]

You are welcome 😊

[@gilver6600]

Very nice excel sheet. Pls allow me to use trial first. Thank you

[@sebasthiarputharaj7425]

I want buy this application,pls let me know. Thanks

[@LearnExplore]

Please follow the link in comment section

[@gilver6600]

Excellent. Very informative.

[@ibrahimgurel9761]

Nice work,Thank You so much

[@LearnExplore]

Thank You for your valuable feedback 😊

[@bishnushil8164]

Sir traverse shet is locked 🔐 how copy paste dada

[@sodiqisiaqolamilekan2274]

Please I need this for my work.Thanks

[@LearnExplore]

Please follow this link to download Traverse Correction program for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram

[@sajeevan6256]

Nice 🌹🌹🌹

[@urgesageleta139]

nice sir I like it

[@urgesageleta139]

Please, I Need the link

[@LearnExplore]

I have replied to email

[@itspaulbro1994]

Darun mam☺️

[@sukantapal2462]

Thanks you Sir 🙏🏻☺️😘

[@LearnExplore]

Most welcome

[@srdjanm810]

Hi there, I like your videos and this sheet could be very useful for me. Only one thing a bit confuses me: At your sketch, you show as you started free station ( resection from starting points), and then you say you move TS and take orientation from the previous position of TS. Shouldn't you move your TS at the surveyed points (points for which you are doing correction)? Please if you can tell me a little bit about that.?

[@LearnExplore]

Sure..you can do that too... Actually everything depends upon accessibility and visibility. Thanks for your valuable comment.

[@Barogtalaban]

hi, this is very helpful in my work as a surveyor, please download the link, i just have one question can you show the angular error of closure in the open and closed traverse?, thanks a lot

[@LearnExplore]

Yes it is shown there

[@RajuMS-rz6hv]

Just made payment for full version excel file. Amount has been debited but your payment link says payment failed.

[@LearnExplore]

Received your payment.and I think you also got confirmation email. Good day

[@ashiqnajar8169]

Where do I get the excel file?

[@LearnExplore]

Click given link in pinned comment

[@prsimoes2010]

I will use it in a class activity Universidade Federal do Paraná - UFPR. Brazil. Thanks

[@gowthamnatra2952]

hi sir im an survey engineer, need this formula sheet to cross check dgps points given by consultants

[@LearnExplore]

Hi, we have send it enjoy this file for free but your little support will motivate us. Please JOIN our YT Membership with Rs.59/- only and get premium excel sheets for surveying field. Click here to JOIN: kzbin.info/door/PFKMG7jmWV9zlQ_9WhNrMgjoin

[@wasiullahsalami5768]

Hello sir. I am from Afghanistan 🇦🇫. I can't download the excel sheet, could you help me? I need the excel sheet.

[@hamtheedf8061]

I just wanted to adjust a traverse in a road survey

[@noorbabamohd2843]

I need angle and distance Excel sheet.pleade provide

[@hariomchandra9048]

How u get the correct value?

[@LearnExplore]

By Bowditch rule

[@nabanayak1000]

Sir Grid ,Contour spot Level lisp send please

[@randomtube1048]

Please give me the download link I want this for my Surveying excel sheet.

[@shaiksajeed9141]

It's help me thanks

[@shrikrishnakendre8433]

Good work. Very informative.

[@jabbarabdul6098]

Hi sir I am a land surveyor and your excel file is very nice , please give excel file for my Railway project in hyderabad.

[@LearnExplore]

Download the file from given link in pinned comment.

[@jayedhossain5371]

Sir, i wanna talk with you. Is it possible?

[@LearnExplore]

Follow this link to join our WhatsApp discussion group specially for LE SUBSCRIBERS: chat.whatsapp.com/Bhs3Eyty8oJHFcY8kIcWQl

[@gilver6600]

Cannot use international card for payment

[@LearnExplore]

You can send us through paypal link

[@LearnExplore]

Donate us here through PayPal www.paypal.me/learnxplore

[@oluwawomidamilare9299]

welldone. I need this excel file for my open traverse computation

[@oluwawomidamilare9299]

[e-mail]

[@LearnExplore]

Sent

[@jeewanlalprajapati4862]

Sir please sent me this file my mail id [e-mail]

[@palashbhaumik1613]

​@@LearnExploreI need excell sheet

[@adeodusina6230]

Informative video, very helpfull

[@pakallnews8709]

Plz sheet download link send

[@aynenehmanyazewal8167]

How can I download the format

[@LearnExplore]

Link given in pinned comment

[@MdMehediHasan-ys3ek]

I'm from Bangladesh.I need this excel file .Can you give me the excel file.Or, how can I get the excel file would be great.

[@LearnExplore]

Please visit the link given in pinned comment

[@rahulray5831]

I need this excel file for site work. I am a surveyor.

[@LearnExplore]

Good luck

[@babanawofrederick6134]

GREAT WORK PLS KEEP IT UP

[@engnoori8125]

Thank to share a good vedio

[@njugunasolomon9187]

How do I create that Excell sheet

[@LearnExplore]

We have given the download link of that excel sheet

[@hamtheedf8061]

I'm a land surveyor and I'm facing same problem and i need to adjust my coordinates will you please send me the file?

[@saiidalejel5186]

Need the Excel file for education

[@arabindamandal8593]

Very usefull...

[@engineeringtechnology7289]

Can you please share this excel sheet

[@yusufrayan9492]

Useful

[@allensamu40]

Nice

[@LearnExplore]

Thanks

[@AyicheMohammed]

I Need for new project please send me the link

[@LearnExplore]

Please visit our website

[@rukundoterance1051]

Sir how can I get that excel sheet. Thanks

[@LearnExplore]

Please download the file from the link given in pinned comment. Also Join us as KZbin membership for more premium excel files. Payment is not compulsory. Download it for free.

[@rukundoterance1051]

@@LearnExplore I have send access request but not yet received. Thanks

[@LearnExplore]

Okay we will send it soon

[@LearnExplore]

What is ur email id

[@rukundoterance1051]

@@LearnExplore [e-mail]

[@tanveerahmed-ur3op]

send this link pls

[@arnoldtamayomoran7001]

Hi I will avail, is it still available? Thank you.

[@LearnExplore]

Yes, it is

[@er.aamirahemad8561]

Thanks sir

[@er.aamirahemad8561]

Thanks

[@kedirkemal7275]

please send excel sheet

[@markanoche545]

Hi i work on construction i do survey if my team need support to catch up the work can i request this excel file thanking you in advance

[@tapasbasak7638]

Nice Sir

[@mdarifhossain6388]

From Bangladesh how can i pay??

[@LearnExplore]

Hope you received the file

[@tonyaculabbis1697]

Please send me the excel sheet because I have home work about traverse

[@bhaskarshahi7276]

thanks mam

[@sawpankarmakar6436]

Sir ple sand it's formula Iam Swapan Karmakar.

[@manojbhattarai6929]

can i get the excel file please

[@LearnExplore]

Pl follow the pinned comment

[@mohammedabdulawais6728]

Hi mam can you give me excel sheet it's really helpful for me

[@banothnamya562]

Send the excel sheet

[@royelbong6771]

Excel formula has to be downloaded.

[@amitabhadey6483]

Sir ji excel seet mil sakta hai kya??

[@LearnExplore]

Ofcourse...its free

[@amitabhadey6483]

@@LearnExplore please send this id adey( [e-mail] )

[@nasirawan445]

Mam password chahiye edit nai ho rha kisi b cell me

[@maheshodela3334]

Hello sir.. Please send excel sheet

[@nityanandadas3767]

Sir, I am civil surveyor, I need this Excel file, because of sometimes I have to do this, and I am working in road project, Can you give me this file please. Thank you very much...

[@LearnExplore]

Sure. We have sent download access to you. Pls check.

[@VSC2021]

@@LearnExplore plz share Excel my email

[@mfaisalkdr]

I like you video I am land surveyor working in Kuwait. Please send me this excel file

[@daveassefa313]

i need excel file pls

[@nigus-youtube6822]

Start the first

[@hamtheedf8061]

It's protected and asking for the password how can i use this bro?

[@LearnExplore]

Input cells are not protected by password

[@hamtheedf8061]

@@LearnExplore i couldn't use that could you please send me the Excel sheet which is able to use completely?? My mail address is [e-mail]

[@hamtheedf8061]

@@LearnExplore but i couldn't get the adjusted coordinates it's completely protected

[@LearnExplore]

In the Input section when you will update with your data adjusted coordinate will be updated automatically. Just copy the adjusted coordinate and paste as value in another sheet. Still if any problem arises contact us with screenshot. [e-mail]

[@LearnExplore]

We also send you the Excel file