With the release of the Lync/S4B KHI analysis tools, it looks like Microsoft saw this upload and took some of the ideas - either way the new tool is FAR improved from their last one, and it makes this Excel document unnecessary.  Very cool!


While collecting KHI data is simple using logman to install the counters and start/stop them, once you have the raw CSV's there is some data manipulation to capture the needed information.  This Excel VBA Macro will import multiple CSV's collected in a folder to summarize to the counter, the average and the max values.


More detail screenshots and video here: