In this method of levelling, rise is said to be occur if Back Sight reading is greater than Fore Sight reading and fall is said to be occur if Fore Sight reading is greater than Back Sight reading.
The reduced level of following points can be obtained by adding rise or deducting fall from previous point.
Suppose we have following data.
At first input the data in excel.
To calculate rise:
In the G10 cell put the following formula:
=IF(D9+E9>E10+F10,D9+E9-E10-F10,"")
To calculate fall:
In the H10 cell put the following formula:
=IF(D9+E9<E10+F10,E10+F10-D9-E9,"")
To calculate Reduced level:
In the I10 cell put the following formula:
=I9+G10-H10
After that you can drag the formula upto the last data.
In case of fly levelling, there will be no IS sight column. So, in excel formula also you can remove the IS cell.
No comments:
Post a Comment