Last time we looked at creating a simple scorecard in Excel to visualize info, data, & metrics for some entity of interest, such as a customer, potential customer, employee, etc. In that article, the underlying data lived in another Excel workbook (customers.xlsx) and we used a direct data connection in the scorecard template (scorecard_template.xlsx) to easily pull the data. This time we're going about the same goal through different means. The data will be in the same place, but we're going to handle getting the data and populating it in a copy of the scorecard template via a Windows Forms application in C# using OleDbConnection and ExcelInterop.

If you've ever wanted a quick & dirty way to visualize metrics & status info about something, there's a good chance you can get part of the way there without a fancy BI tool or a ton of time. Excel's visualization & conditional formatting tools, used in conjunction with references to data on another sheet, can easily product a scorecard like the one discussed here.

It's all in the title - a ranking of 10 breads!

Everyone loaves bread! These crumbly sandwich handles have been making us more full than we want to be before the main course arrives for billions of years. And what a variety of bread we have in the world today! With thousands of bread varieties being invented in bread labs every day across the world, it's become harder than ever to keep track of all of them and the order in which we prefer them.

It is with this challenge in mind that I bring you this bread list - a ranking of 10 breads, by an actual bread person!