Back to the main data prep VBA page I’ve been experimenting recently with Excel VBA dictionaries and arrays to avoid writing to disk while parsing log files. I have been using a dictionary to ca...Read More
Back to the main data prep VBA page This is a small Excel VBA script I wrote to pull the SVMON memory statistics for a specific PID that contains concatenated SVMON output. I’ve had to modify th...Read More
Back to the main data prep VBA page Here’s a relatively obscure Excel VBA script that you would likely never use, but it is helpful if you care about IBM DB2 buffer cache sizes over time that ca...Read More
Back to the main data prep VBA page I use this script to compile data from multiple DB2 snapshots into a single time series table that can be used to generate time series plots for use in enterprise w...Read More
Back to the main data prep VBA page This is a script I use for extracting data of interest from NMON output. Often I need t0 extract data from a variety of tools a customer is comfortable using, an...Read More
Back to the main data prep VBA page This is a sample script that I used in Excel VBA to extract data from IOSTAT output trapped at a regular interval (typically 15 seconds) to create a single row time...Read More
Back to the main data prep VBA page This is an old script I created that imports HTML based reports into Excel, searches for the target headers in the file, then pulls key data I specified for the OLT...Read More
Back to the main data prep VBA page I work within development organizations helping to tune high scale workloads for our large scale commercial customer base. These customers typically deploy in a var...Read More