I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading
DSUM gymnastics
Post Category → Free Data
CELL Function Adventure
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading
Wayne Gretzky’s Goals
Let’s explore Wayne Gretzky’s goals (it’s his birthday tomorrow!). I’ve thought of some good questions and one “great” question that we can answer using this dataset. Finally, could Ovechkin break Gretzky’s goal record? Continue reading
Harvard CEO Ranking
Harvard Business Review ranked the top 100 CEOs with three weighted categories (80%, 10%, 10%). I downloaded their data and added some formulas to modify the weighting. Does it make a difference? Continue reading
free data from Data.world MOMA artists
In February my wife and I were planning a trip to New York City. I stumbled upon an interesting data-set that MOMA had shared with data.world. Continue reading
NYT Lack of Cat Research article leads to Spanish study
How did a New York Times article about the lack of scientific cat research lead me to this spreadsheet: “Affective norms of 875 Spanish words for five discrete emotional categories and two emotional dimensions” ? Continue reading
Rouge National Urban Park
My wife and I recently visited Rouge National Urban Park. We wanted to spend some time away from TV, internet and Excel. We did…but I discovered some data in the Park! Continue reading
Who is the blame for Subway Delays?
Subway riders cringe when a delay is announced. Emotions range from mild annoyance to outbursts of anger. Delays inconvenience us and reduce productivity. By default we blame subway management (TTC in Toronto). Is this fair? Wouldn’t it be nice if we had data to determine what causes the delays? Continue reading
Toronto Indoor Ice Rinks
I stumbled across this interesting data-set that lists Toronto’s indoor ice rinks. I thought that it would be fun to visualize the rink locations so I used Excel’s 3D Map feature. Continue reading
2016 Rio Olympics Women’s Marathon
One of the highlights of my life was travelling to the 2016 summer Olympics in Rio de Janeiro to watch my sister, Krista DuChene, run in the women’s marathon. Her story is inspirational. Krista fractured her leg on April 28, 2014 during a half marathon and then in August of 2015 she broke a bone in her foot only one year before the Olympics.