Surveying Spreadsheets
 

 

Using Spreadsheets to solve surveying problems

For a number of years now, I have been producing spreadsheets for my students to use in Surveying.  These spreadsheets are available for purchase by colleges and private individuals.  Just a nominal charge of £50 and you can make as many copies for your students as you wish.

Send me your details on the Feedback page.

 

bullet

Booking levels and calculating Reduced Levels using HPC and Rise and Fall methods on the same page.

bullet

Final Co-ordinates from a Closed Traverse

bullet

Vertical curve design data

bullet

Horizontal curve design data for Offsets from Long Chord, Deflection angles and short chords, and setting out co-ordinates.

bullet

Are you looking for Structural Design spreadsheets?

Levelling Page

BS IS FS   rise fall RL BS IS FS   HPC RL Remarks
2.130         30.000 2.130     32.13 32.130 30.000  
3.060   1.890 0.240 0.240   30.240 3.060   1.890 33.3 33.300 30.240  
2.840   1.570 1.490 1.490   31.730 2.840   1.570 34.57 34.570 31.730  
2.360   1.980 0.860 0.860   32.590 2.360   1.980 34.95 34.950 32.590  
  2.120   0.240 0.240   32.830   2.120   34.95   32.830  
  1.250   0.870 0.870   33.700   1.250   34.95   33.700  
3.140   0.380 0.870 0.870   34.570 3.140   0.380 37.71 37.710 34.570  
  2.720   0.420 0.420   34.990   2.720   37.71   34.990  
  2.100   0.620 0.620   35.610   2.100   37.71   35.610  
  1.530   0.570 0.570   36.180   1.530   37.71   36.180  
    0.770 0.760 0.760   36.940     0.770 37.71   36.940  

The students enter their results in the first three columns and these are automatically transferred into the HPC sheet.  Rise and Fall values are calculated as well as HPC and RL values for comparison.

Home Page

Last Edited :  22 August 2008 00:03:40