|
"The man who knows it all has lots to learn" - Unknown
Objective
The purpose of this assignment is twofold: first, you will have an
opportunity to practice your skills in computing elevations from data recorded
from a differential leveling survey, and second, you will get a chance to
practice your skills in developing simple engineering spreadsheets for surveying
applications.
You must
submit the coversheet for the assignment,
your work for Parts 1 & 2, and printouts of
Parts 3-4. Also, submit your Excel file for Parts 3-4 to the Dropbox in Canvas.
Problems
-
Complete and check the level notes shown below by hand
calculations.
| Station |
BS |
HI |
FS |
Elevation |
| BM1 |
1.23 |
|
|
100.00 |
| TP1 |
4.52 |
|
6.64 |
|
| TP2 |
6.78 |
|
7.54 |
|
| TP3 |
3.71 |
|
3.25 |
|
| BM2 |
|
|
9.98 |
|
-
Complete and check the level notes shown below by hand
calculations.
| Station |
BS |
HI |
FS |
Elevation |
| BM1 |
4.72 |
|
|
864.38 |
| TP1 |
7.12 |
|
3.56 |
|
| TP2 |
9.45 |
|
3.78 |
|
| TP3 |
3.95 |
|
4.98 |
|
| TP4 |
3.15 |
|
6.84 |
|
| BM2 |
|
|
1.54 |
|
-
Develop a spreadsheet to compute the elevations from
backsight (BS) and foresight (FS) data.
Your spreadsheet should look similar to the one shown below:
-
Use your spreadsheet to compute the elevations from
backsight (BS) and foresight (FS) data.
Requirements
Your name and assignment number should appear in the top left corner
of the spreadsheet. The date should appear in the top right corner of the spreadsheet.
Lastly, a web page describing the CIVL 1101
Excel
homework policy is available. Please reqad it before you turn in this assignment. You will be
graded throughout the semester according to the policy outlined in it.
Coversheet for homework
This website was originally
developed by
Charles Camp for
CIVL
1101.
This site is
Maintained by the
Department of Civil Engineering
at the University of Memphis.
Your comments and questions are welcomed.
|
