Excel in the Real World – Manhattan Transit
I love hearing interesting ways that Excel is being used everyday — from simple things like making a personal budget or far more complicated things, like assessing the impact of transit prices on Manhattan’s traffic.
Check out this article from Wired magazine about Charles Komanoff, the guru behind the “Balanced Transport Analyzer.”
His model takes all sorts of variables into account, and by linking cells and forming relationships and functions, he is able to measure the traffic impact of changing a fare, adding a train, or any number of other inputs. What’s really interesting here is that nothing in this file is outlandishly complicated — these are all techniques that ExcelMates uses on a regular basis. In fact, most of the concepts are covered in our curriculum section and covered in our classes.