The Content Aggregator Called Excel

Posted on 31 January 2010

So you have been toiling away on a spreadsheet that must reach the CEO's desk before the end of the day. Your boss has been after your life to get this done as fast as possible with his frantic phone calls and a rather sharp pitchfork that he uses on special occasions like these. A gazillion formulas, allocations and calculations later, with your body screaming for some coffee, you allow yourself a break. As you return to your desk with ... Continue Reading

Comments (4)

A Big Thank You

Posted on 08 January 2010

Its been one and a half year since I started this blog. For the first few months, I thought I was writing only to myself (I still sometimes do when I don't get too many comments for a couple of days at a stretch). But, things have been great lately. The blog now receives a respectable number of visits a day and while that is good in itself, the better part is that ... Continue Reading

Comments (12)

A New Rig

Posted on 28 December 2009

Last week my computer broke down. This time, unlike previous occasions, it just wouldn't resurrect itself. That rig was my first build and had been with me for the past eight years. It wasn't a thoroughbred, a humble Duron (AMD) at heart but it had its fair share of adventures. All those impromptu college parties, those last minute project reports, getting hauled around in a rug-shack, a thousand tweaks to squeeze the last remaining MHz out of the processor, even ... Continue Reading

Comments (1)

Treemap in Excel - Coming Soon

Posted on 24 December 2009

Its been a few days since I posted. In case you were wondering what I was up to - yours truly was busy coding a program to create treemaps in Excel. Treemaps are interesting creatures. You can pack a few thousand data points in a single treemap and utilize just about the same space as any of the traditional charts. The term 'treemap', as we see it being used nowadays, actually refers to the inward growing members of the treemap ... Continue Reading

Comments (11)

Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software

Posted on 16 December 2009

In Six Sigma Control charts using Excel we saw how to make control charts using named ranges. From there on, it was a short hop to porting the logic to VBA. So here is the VBA code for automating the creation of a six sigma control charts. It has been tested with Excel 2000, Excel 2007 and Excel 2010. How to Use the Control Chart Program 1. Simply click the 'Make Control ... Continue Reading

Comments (2)

Pareto Chart Table - A More Meaningful Analysis (Download & Template)

Posted on 09 December 2009

Pareto charts are one of the basic pillars of the six sigma methodology and are typically used to depict the frequency of occurrence of issues that affect 'production'. Although one usually sees them being used as standalones, the humble pareto chart can very well be augmented in order to make it a much more meaningful tool for tracking and resolving pending issues & errors. Let's look at one such approach that utilizes a combination of a horizontal pareto chart ... Continue Reading

Comments (5)