Wednesday, May 15, 2013

A spreadsheet to calculate congestion charge

For those interested in transport modelling and congestion pricing, here is a piece in Wired about Komanoff 's spreadsheet to calculate congestion charge. He has been working for three years now on the Balanced Transportation Analyzer, an Excel spreadsheet proposed to model every aspect of New York City transportation (I thank Fabio Storino for the pointer).

And here is a 15-minute video where Komanoff explains the whole idea of the project.



The spreadsheet is quite impressive as for the amount of input data it demands. However, I'm not familiarized with transport modelling, so I'm in no position to have an opinion on this spreadsheet. I'd rahter have some experts' opinions published in scientific journal assessing it.

ps. I confess though I asked myself: why 'Excel' ?!  This is too vintage.

2 comments:

Arthur said...

I downloaded it, but my excel says it's not in the right format.

Are anyone else having the same problem? It's because my old excel 2003 can't open it? Do someone have another link to the file?

Rafael H M Pereira said...

Try this link http://www.nnyn.org/kheelplan/BTA_1.1.xls