Low frequency part (at 0:40) reminds me of this fried egg city, and high frequency part (at 1:52) reminds me of Christaller's network of central places. Probably, there is already an author using complexity theory to freak out on this stuff.
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.
As some studies have pointed out, the key element in discussing the so called 'demographic dividend' of a country is education, and more education. And of course, in the end, education and aging are crucial for productivity levels.
*A funny curious finding: "the likelihood that the twenty most popular names chosen by parents for their newborns would include one or more names of the main characters of novelas aired that year was about 33 percent if the area where parents lived received the Globo signal and only 8.5 percent if it did not."