The Great Bottle Deposit Financial Model

I have loved Seinfeld ever since college, when as an RA on duty I spent many a Southern Michigan weekend night watching the show with my fellow on-duty RAs. The Bottle Deposit held particular interest for me, both culturally and economically. As a Northern Ohioan, the mythical Michigan Deposit Run loomed near. Like Newman and Kramer, many Ohioans […]

Retrieve Real-time Weather Data from Weather.gov in Excel using FILTERXML

Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions. In this lesson we will get real-time updates from Weather.gov. Data source: http://w1.weather.gov/xml/current_obs/ View the YouTube tutorial here. Be sure […]