Logo

Pengolahan Data Survey Asal-Tujuan Menggunakan Microsoft Excel

Setiawan, Rudy (2010) Pengolahan Data Survey Asal-Tujuan Menggunakan Microsoft Excel. In: Simposium XIII Forum Studi Transportasi antar Perguruan Tinggi (FSTPT), 08-10-2010 - 08-10-2010, Semarang - Indonesia.

[img] PDF
Download (498Kb)

    Abstract

    A useful picture of local traffic movements can be built up by defining one or more cordons and screenlines in a local area, noting the license plates of vehicles passing these cordon or screenlines. These data samples help define the total transportation behavior and travel patterns within the study area. But a large amount of work is necessary to match the license plate numbers on the field sheets of each O-D station against nearby O-D stations to trace the route origin and destination of each vehicle. This paper describes an alternative methodology to process license plate data matching using Microsoft Excel spreadsheets to produce a matrix of flow. This simple procedure using several functions in Microsoft Excel can also modify to comply others purpose such as to produce a trip chain.

    Item Type: Conference or Workshop Item (Paper)
    Additional Information: Untuk persyaratan pengurusan KUM, BUKAN untuk pengajuan poin IKP2M
    Uncontrolled Keywords: origin-destination survey, license plate matching, OD matrix.
    Subjects: T Technology > TE Highway engineering. Roads and pavements
    Divisions: Faculty of Civil Engineering and Planning > Civil Engineering Department
    Depositing User: Admin
    Date Deposited: 04 Feb 2015 19:09
    Last Modified: 06 Feb 2015 00:27
    URI: https://repository.petra.ac.id/id/eprint/16920

    Actions (login required)

    View Item