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!
Пікірлер: 334
Download the Excel Program: Purchase link: for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram Thanks LE Team
@prokashkumar3870
4 жыл бұрын
Many many thanks.
@muhammadaikoyeyoonus6666
4 жыл бұрын
Go a long way in help in correcting works
@itstravelingmallik8557
4 жыл бұрын
Sir pl send the Excel copy to my I'd - ranjit.mallick123@yahoo.com Sir humbal request to you make video on the toppic of Traiangulation traversing wich we have used on tunnel project .
@radheykrishnachoudhury3842
4 жыл бұрын
Sir, I humbly thank you for your efforts, sir please send it on my mail rkchoudhury25@gmail.com
@samiaj1020
4 жыл бұрын
Wornderful work. Keep it up. I am working on road project please send me the file at: samiaj1990@gmail.com
I have gained lot of knowledge of survey from your channel.God bless you & your team.
@LearnExplore
4 жыл бұрын
Thanks for your valuable comment.
Very good knowledge about traverse calculations....
This video is useful for highway project. Thank alot.
Good work. Very informative.
This is very helpful .Great work for Engineering surveying .
@meshacknyakinda6907
4 жыл бұрын
Can I get the excel for open and closed traverse in my email nyakindashack@gmail.com.
@LearnExplore
4 жыл бұрын
We already send the access to download. Pls check your email.
@meshacknyakinda6907
4 жыл бұрын
Learn & Explore The link just expired
Excellent. Very informative.
Nice work and informative...can use this in all my traverves corrections
@LearnExplore
3 жыл бұрын
Go ahead!
So educating. I will love to practice it. Please the download link is needed. Many thanks
Very helpful😊 thank you very much.. let me take the trial version first
Informative video, very helpfull
Thank you! Could u help me to get the excel file to understand the formula?
Thank You so much sir for your given useful knowledge ❣️❣️❣️👍👍😊
@LearnExplore
4 жыл бұрын
You are welcome 😊
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
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
4 жыл бұрын
Best of luck sir!
@kaustubhinamdar4398
3 жыл бұрын
Hello sir where do you work as a chief surveyour
The piece is really informative. Good work. But am interested in knowing where the delta N and delta E came from, kindly.
Very Useful for Survey Engineers..
@LearnExplore
4 жыл бұрын
Glad you think so!
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
4 жыл бұрын
Sure..you can do that too... Actually everything depends upon accessibility and visibility. Thanks for your valuable comment.
Thanku sir❤❤❤❤❤ Full support sir
Very nice excel sheet. Pls allow me to use trial first. Thank you
GREAT WORK PLS KEEP IT UP
Kindly make videos on curve including transition curve
Nice work,Thank You so much
@LearnExplore
3 жыл бұрын
Thank You for your valuable feedback 😊
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
2 жыл бұрын
Yes it is shown there
I will use it in a class activity Universidade Federal do Paraná - UFPR. Brazil. Thanks
The explanation is very clear and helpful thankyou very much. I would need this excel file for my project.
@user-rn7xt7vn3g
11 ай бұрын
Can you send me the download link please.
@LearnExplore
11 ай бұрын
Please see pinned comment. If any contact us
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?
Kindly make a series on excel formula important for surveying.
@LearnExplore
4 жыл бұрын
good recommendation. Thanks. Will think about it!
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
Which teaversis correct ,? Easting ,northing method or bearing and distence method?
@LearnExplore
Жыл бұрын
Mathematically both are same
This is very helpfully.I need this plz
@LearnExplore
2 жыл бұрын
Traverse Correction program for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram
quiero felicitar por lo que están haciendo por compartir sus conocimientos, desde ya gracias , necesito su hoja excel para desarrollar un trabajo Topográfico
@LearnExplore
4 жыл бұрын
Gracias por tus comentarios. Nuestro equipo enviará el archivo pronto.
Can TS setup 1 and GPS point 1 , can be on same location point?
@LearnExplore
11 ай бұрын
Yes. No problem on that
Very usefull...
Thanks Sir received the file just now.
@LearnExplore
Жыл бұрын
You are welcome. Learn & Explore
It's very useful Need Excel sheet with formula
Thanks you Sir 🙏🏻☺️😘
@LearnExplore
3 жыл бұрын
Most welcome
Thank to share a good vedio
Thank you so much guruji
@LearnExplore
3 жыл бұрын
You are welcome 😊
Please give me the download link I want this for my Surveying excel sheet.
Darun mam☺️
Thanks sir
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
2 жыл бұрын
Pl send fresh access request. Thanks for being a member of our channel
It’s useful details for all Survyor
@LearnExplore
2 жыл бұрын
Thank You for your valuable feedback 😊
hi sir im an survey engineer, need this formula sheet to cross check dgps points given by consultants
@LearnExplore
3 жыл бұрын
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: kzread.info/dron/PFKMG7jmWV9zlQ_9WhNrMg.htmljoin
Very use ful for any surveyor.plz give me sir
I just wanted to adjust a traverse in a road survey
Useful
hello i need to get the excel file because I have homework about traverse that I cannot do
@LearnExplore
3 жыл бұрын
Ook
Nice Sir
thanks mam
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
Thanks
@kedirkemal7275
2 ай бұрын
please send excel sheet
Hello sir. I am from Afghanistan 🇦🇫. I can't download the excel sheet, could you help me? I need the excel sheet.
I need angle and distance open traverse correction sheet
Sir, please make also a video and excel sheet for open traverse........and describe the difference of two.....
@LearnExplore
3 жыл бұрын
ye open traverse ka hi video he
@deboprasadbiswas1987
3 жыл бұрын
@@LearnExplore sorry sir I mean to say closed traverse.....
@LearnExplore
3 жыл бұрын
Closed traverses er video deoa ache. Ei video tar end screen e jau link pabe
@souravkunti4966
9 ай бұрын
Sir please send me this format ❤
@LearnExplore
9 ай бұрын
Please follow the link provided in the comment section
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
Sir traverse shet is locked 🔐 how copy paste dada
Nice 🌹🌹🌹
nice sir I like it
@urgesageleta139
Жыл бұрын
Please, I Need the link
@LearnExplore
Жыл бұрын
I have replied to email
I am big fan of le
@LearnExplore
4 жыл бұрын
It means a lot!
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
3 жыл бұрын
Download the file from given link in pinned comment.
Hi mam can you give me excel sheet it's really helpful for me
I want buy this application,pls let me know. Thanks
@LearnExplore
11 ай бұрын
Please follow the link in comment section
Nice
Where do I get the excel file?
@LearnExplore
2 жыл бұрын
Click given link in pinned comment
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
4 жыл бұрын
Sure. We have sent download access to you. Pls check.
@VSC2021
Жыл бұрын
@@LearnExplore plz share Excel my email
Plz sheet download link send
send this link pls
welldone. I need this excel file for my open traverse computation
@oluwawomidamilare9299
3 жыл бұрын
geodamy@gmail.com
@LearnExplore
3 жыл бұрын
Sent
@jeewanlalprajapati4862
3 жыл бұрын
Sir please sent me this file my mail id jeewanlal.prajapati@gmail.com
@palashbhaumik1613
6 ай бұрын
@@LearnExploreI need excell sheet
Please I need this for my work.Thanks
@LearnExplore
2 жыл бұрын
Please follow this link to download Traverse Correction program for India: imojo.in/Traversing for abroad: learnnexplore.gumroad.com/l/Traverseexcelprogram
Sir can you send me this excel sheet .. now I'm working in road project this is very useful for me.. kindly send me sir . Thank you
i need ths for my job,,, pls,,, help me tnx
Sir, I am a civil surveyor, I need this Excel file, because sometimes I have to do this, and I am working on a road project, Can you give me this file please sir .
@LearnExplore
Жыл бұрын
Please follow the link
I need angle and distance Excel sheet.pleade provide
Can you please share this excel sheet
I need this excel file for site work. I am a surveyor.
@LearnExplore
3 жыл бұрын
Good luck
How u get the correct value?
@LearnExplore
Жыл бұрын
By Bowditch rule
Cannot use international card for payment
@LearnExplore
3 жыл бұрын
You can send us through paypal link
@LearnExplore
3 жыл бұрын
Donate us here through PayPal www.paypal.me/learnxplore
Mam password chahiye edit nai ho rha kisi b cell me
Hi I will avail, is it still available? Thank you.
@LearnExplore
3 жыл бұрын
Yes, it is
Sir Grid ,Contour spot Level lisp send please
How can I download the format
@LearnExplore
2 жыл бұрын
Link given in pinned comment
How do I create that Excell sheet
@LearnExplore
3 жыл бұрын
We have given the download link of that excel sheet
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
Plz send download link
Sir, i wanna talk with you. Is it possible?
@LearnExplore
3 жыл бұрын
Follow this link to join our WhatsApp discussion group specially for LE SUBSCRIBERS: chat.whatsapp.com/Bhs3Eyty8oJHFcY8kIcWQl
Thank you for this useful video , please send this excel sheet as I have paid Rs249 through net banking
@LearnExplore
2 жыл бұрын
You will get the download link after payment. If any problem WhatsApp me
i need excel file pls
I like you video I am land surveyor working in Kuwait. Please send me this excel file
Please send me the excel sheet because I have home work about traverse
Send the excel sheet
can i get the excel file please
@LearnExplore
2 жыл бұрын
Pl follow the pinned comment
Excel formula has to be downloaded.
Sir ple sand it's formula Iam Swapan Karmakar.
Plz send this excel sheet
Pls send link
@LearnExplore
3 жыл бұрын
File sent
I Need for new project please send me the link
@LearnExplore
3 ай бұрын
Please visit our website
Hello sir.. Please send excel sheet
Start the first