Transit Scheduling With Spreadsheets

by Peter Eakland, QUADRA Engineering, Anchorage, AK, USA,

Document Type: Proceeding Paper

Part of: Microcomputer Applications Within the Urban Transportation Environment


In two years, the Anchorage Transit Department has gone from having no microcomputers in use to having ten being used for route scheduling, monitoring ridership figures, maintenance management, payroll, word processing, accounting, and budgeting. Dramatic increases in productivity have occurred with only modest increases in staffing. The current use of spreadsheets to do all schedule writing for the Anchorage People Mover system is of interest not only for the specific features of the spreadsheet templates used but also for the institutional response to the introduction of the hardware and software needed to use the templates. The development of a complete schedule writing process using a spreadsheet program required only a modest investment in hardware and software and was successfully developed and implemented entirely with its limited, in-house resources.

Subject Headings: Scheduling | Spreadsheets | Transportation management | Anchorages | Computers | Ridership | Writing skills | Automated people movers

Services: Buy this book/Buy this article


Return to search