Traverse computation sheet excel file
The excel file attached has the capacity to calculate 489 traverse stations and 100 opentraverse stations inside the traverse which comes with a password for opening the excel file (password is " abh " only these three letters in small letters. )
click here to download excel file
Please use only excel software for smooth operation. If you are using an open source software it's recommended to use libere office
How to use
Open the excel file type the password as abh
Clear the existing data by select all(ctrl+a then delete key)
type the x and y coordinates of starting stations at the easting and northing cells respectively preferably 2000 and 3000 as default values.
Then enter the wcb( ie whole circle bearing) of the first line ( ie the wcb(angle from North direction to the line) of line starting from first station to the second station at the wcb reference cell)
Then enter the station name or number ( capital and small letters are treated as same. so if a letter appear in capital and small in the sketch please add a number Or any other character with the second repatriation character else you can't use the open traverse sheet correctly)
Then fill the angle value in respective degree minute and seconds cells and then distance value
Repeat the process until the last station value in the sketch.
If distance correction in the traverse is nearly above 3 metres for 1000 meter distance measured then please check the angle and distance entered. It is not advisable to use the data with correction above that limit
This excel file will show error for distance correction above 5 M for 1000M measure of line and it will stop showing X Y data for correction above 20 Metre for 1000 metres)
Also look at the angular error which is distributed along each stations shown if that is too high then please recheck if necessary
After getting the X Y values in the For CSV section ,select the area from station name to easting and northing untill the last station name . Then copy the data (ctrl+c) create new excel (ctrl+n) in the blank sheet paste the values ( use paste special select values for pasting only values from the traverse calculation sheet) after that save the file in CSV ( coma space values / csv delimited) format Using save as option.
After saving the file in csv close both files (save original file as it is please don't change it's file type. )
Then make use of any CAD software for converting the csv to desired CAD format.