Tag Archives: excel

An Office 365 Home Premium subscription is not a bad deal, actually

I remember reacting with skepticism when I heard that Microsoft was rolling out their famous Microsoft Office suite as a monthly subscription for $9.99 a month. Why pay an endless subscription when you could get the same product for a … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 1 Comment

Shortcut: Generate realistically distributed randomized data in Excel

I recently wanted to create some randomized data for use in a simple proof-of-concept experiment.  I was creating a simulated population of users in various locations around the world, and so I needed to take a few hundred rows and … Continue reading

Posted in Uncategorized | Tagged , | 4 Comments

Script to extract all applications installed on a Mac

Recently, I needed to extract a full list of programs installed on a couple of Macs.  What I wanted to do was get an inventory of all of the software installed on each one and then load it into Excel … Continue reading

Posted in Uncategorized | Tagged , , , , | 3 Comments

Solved: Editing a CSV with UTF-8 encoding on a Mac

Much to my surprise, Mac’s are horribly deficient at editing a CSV file that has UTF-8 characters in it. Someone sent me a CSV file, and I needed to make some edits to one of the columns that included adding … Continue reading

Posted in Uncategorized | Tagged , , , , | 20 Comments

Performance Tuning: Visualize your web log performance data using Excel scatter plots

I’ve written previously about how to turn on time-taken values in web logs for IIS, Tomcat, and Apache.  Armed with time-taken data, you can identify which are the slow pages in your system and decide where to focus your performance … Continue reading

Posted in Uncategorized | Tagged , , , , | 1 Comment