Processing Profiler Output with Microsoft Excel

PROFILER.XLM is an example Microsoft Excel^TM macro that processes a tab-delimited profiler report (generated by PLIST) and creates a graph based on the results. You will find this macro in the ..\vc\bin directory.

The PROFILER.XLM macro is composed of four sub-macros. The first two macros, in columns A and B, are helper macros that copy and preprocess the data for use by the second pair of macros in columns C and D. The macro in column C, labeled CreateColumnChart, creates a graph showing the number of times that each function or line was executed. The final macro, in column D, is CreateColumnTimeChart; it works like CreateColumnChart, but operates on timing information.