FIG Peer Review Journal

Computation of Curve Staking out Coordinates on the Excel Spreadsheet (8671)

Gacoki Thomas Gicira (Kenya)

Mr Gacoki Thomas Gicira
Manager(Survey)
Kenya National Highways Authority
P.O. Box 75466-0020
NAIROBI
Kenya

Corresponding author Mr Gacoki Thomas Gicira (email: gachokit[at]yahoo.com, tel.: +254728961509)

Published on the web 2017-03-10
Received 2016-10-01 / Accepted 2017-02-01

This paper is one of selection of papers published for the FIG Working Week 2017 in Helsinki, Finland and has undergone the FIG Peer Review Process.

FIG Working Week 2017
ISBN 978-87-92853-61-5 (Online) ISBN 978-87-92853-62-2 (Printed)
ISSN 2307-4086
https://www.fig.net/resources/proceedings/fig_proceedings/fig2017/index.htm

Abstract

COMPUTATION OF CURVE STAKING OUT COORDINATES ON THE EXCEL SPREADSHEET T.G.Gacoki Kenya National Highways Authority (KeNHA) ABSTRACT A procedure for the computation of curve setting out data on the Excel spreadsheet is outlined. An Excel worksheet with interrelated sheets computes the curve setting out data. In sheet one the included angles are computed from the coordinates entries of the intersection points of the straights. In sheet two curve elements for the various curves are computed from the entries of the radii and lengths of the transition curves and the included angles computed in sheet one. Sheet three computes the chainages of the principal points of the curves and the coordinates of these points. The sheets that follow compute the coordinates of the points along the centre-line by alternating between straights and curves.

Keywords: n/a

Back