VBA icon

How'd They Do That: Realtime World Cup Scores

world cup logo

World Cup fever is here!

soccer ballsoccer field

In FIFA Worldcup Excel Spreadsheets Roundup, Chandoo has some links to useful World Cup tracking workbooks. Only one of them (the first one) can update scores for you, but the workbook code is locked. I'm not sure what method it uses, but here's one way to get realtime scores for your World Cup 2010 tracking workbook.

Continue Reading »

Excel iconVBA icon

FlightCaster API examples in VBA

flightcaster logo

FlightCaster is a web application that offers information on flight delays. According to FlightCaster,

FlightCaster predicts flight delays. We use an advanced algorithm that scours data on every domestic flight for the past 10-years and matches it to real-time conditions.

That means you can use their site to guess if your flight (or that of your loved ones) is going to be on time. Here's a colorful sample. You can also check on airport weather and ground delays imposed by the FAA.

Continue Reading »

excel school learn dashboards