A Macro That Writes Macros
Updated:If you are like me, you may find yourself writing a fair number of MS Excel macros to automate repeatable tasks. One day it dawned on me, however, that several of the aspects of writing macros were repeatable tasks themselves. When writing a macro I would often start by: Creating a data structure that would […]
Read moreThe Importance of Vision Casting
Published:Need help setting a vision for your team? Read about how a new leader found inspiration through a phone call to his local fire department, and learn the five practical steps to casting a vision.
Read moreUse Pareto Tables to Manage Large Data Sets
Published:As helpful as a Pareto chart is, it isn’t practical when working with reams of data and hundreds of groupings. A Pareto table, on the other hand, can analyze large data sets and point you to improvement.
Read moreTaaG Analysis – Fast and Easy for Comparing Trends in Large Data Sets
Published:TaaG (trends at a glance) analysis is a fast way to compare trends of subsets of data across large data sets. It is an ideal tool to use in the Measure and Control phases of DMAIC (Define, Measure, Analyze, Improve, Control) projects. The value of TaaG analysis is best understood by way of example. Suppose […]
Read more