Excel Assignment

Assignment # 1 – Staking out a horizontal curve.

Use an Excel spreadsheet to solve Example 2 in lecture 5 .Although the solution that we went over in class pertained to the first whole point, the procedure applies to all subsequent points along the curve, please code the solutions as formulae in the spreadsheets cells. Your spreadsheet, header should include Control points stations arc length(11) central angle subtended by li(deltai) Defelection angle (stress I) Chord length, CI To check your solution, use the last slide of lecture 8 .The answer key in lecture 5 contained some errors

Example 2. Given a 4-degree curve with a

Central angle 55degree25”. PC is at station 238+45.

What is the length of curve, the station of PT,

The deflection angle and the chord lengths

For whole station?

Your answer is calculation & Excel horizontal curve spreadsheet.

 

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)