Opera Anyone ?

Looks like I am not the only one suffering from browse fatigue. Excel guru Dick Kusleika recently made the shift from Firefox to Chrome and he wasn't very impressed. I myself have been fiddling around with various browsers lately. Right before my earlier computer gave up the ghost and I shifted on to the new one, I had been hell bent on squeezing ...

Continue Reading

Opera Anyone ?

The Content Aggregator Called Excel

Posted on 31 January 2010

The Content Aggregator Called Excel
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

A Big Thank You
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

A New Rig
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

Treemap in Excel - Coming Soon
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 (12)

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

Posted on 16 December 2009

Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software
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 (5)

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

Posted on 09 December 2009

Pareto Chart Table - A More Meaningful Analysis (Download & Template)
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)

Remove Background Tool in Office – Results from the Test Drive

Posted on 27 November 2009

Remove Background Tool in Office - Results from the Test Drive
The remove background tool is one of the new features introduced in Office 2010. Ever since I downloaded the public beta, I've been itching to take it for a test drive and this weekend, I did just that. I tried my hands at two images - one with high and the other with low contrast. So let's look at the results Remove Background from a High Contrast Image We picked up an ...
Continue Reading

Comments (3)

Why do Women Shop

Posted on 09 November 2009

Why do Women Shop
Of all the mysteries in the world, one of the most profound is - why do women shop. A man can probably go through most of his adult career with a pair of conservatively stitched suits and matching ties. My old man still takes great pride in a dark, striped one that he got stitched when he had just been commissioned into the forces. I remember the time when he even had a slightly worn one handed over to me ...
Continue Reading

Comments     

Halloween Special – 3 Wicked Things You Can Do with Excel

Posted on 30 October 2009

Halloween Special - 3 Wicked Things You Can Do with Excel
I reckon that today would be the last working day before Halloween and it might be your only chance to get even. So here are a few Excel tricks especially for you this Halloween - each one getting progressively meaner. Send somebody a Workbook that just doesn't Scroll the Right Way This one is for your super boss (I mean boss's boss). Now wish as you may, you really can't do too many bad things to him, right - so this one's ...
Continue Reading

Comments (3)

Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Posted on 22 October 2009

Stock Tracking Dashboard and Live Stock Price Quotes Using Excel
Nearly everybody I know uses Excel for tracking the returns in the stock market. Not many however know that Excel can be used for online stock tracking and getting live price information from stock exchanges like NYSE and Nasdaq as well. Here's how. Establishing a connection to the MSN server for Stock Quotes Click on the data tab in the Excel ribbon (in Excel 2007 and later). In Excel 2003 and earlier, ...
Continue Reading

Comments (9)

HTML to Excel using Javascript and Excel to HTML using VBA

Posted on 23 September 2009

HTML to Excel using Javascript and Excel to HTML using VBA
This two part article consists of: Part A - Converting HTML to Excel using Javascript Part B - Exporting Excel to HTML using VBA HTML to Excel using javascript Let’s first take a look at tables in html. Data tables are typically stored in HTML using the <table> tag. Such a table will typically consist of one or more rows (<tr> tag) with each row having one or more cells (<td> tag). To read a table from an HTML document ...
Continue Reading

Comments (12)

Chart Table – When Chart meets Table

Posted on 15 September 2009

Chart Table - When Chart meets Table
Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...
Continue Reading

Comments (6)

Case Shiller Home Price Index and the Base Effect

Posted on 31 July 2009

Case Shiller Home Price Index and the Base Effect
The Case Shiller Home Price Indices are constant quality house price indices for the United States. A number of Case Shiller home price indices exist: A national home price index, a 20-city composite index, a 10-city composite index, and twenty individual metro area indices. These indices were developed by economists Karl Case and Robert Shiller. (wiki) The Case Shiller Index has been one of the most keenly watched indices over the past few months. It has been argued (and perhaps ...
Continue Reading

Comments     

Javascript Charting Library

Posted on 06 July 2009

Javascript Charting Library
A Javascript charting library is a compilation of javascript code which helps you create charts in a browser. Here's a list of 5 Javascript charting libraries that I had a chance to review : (Each of the Javascript charting libraries reviewed below would offer its own custom functions to interact with the chart object. If a chart fits your need, you may want to read the chart library's API documentation in greater detail. However, if you're short on development time, this ...
Continue Reading

Comments (1)

Javascript Get the Current Path without %20 and / backslash

Posted on 03 July 2009

Javascript Get the Current Path without %20 and / backslash
To get the current path using javascript without the %20 and / (backslash), use the following code: [cc lang="vb"] var path = document.location.pathname; alert (path); [/cc] However using the javascript path variable in this manner gives something like this: So now we use the string replace function in Javascript to rectify this: [cc lang="vb"] var path = document.location.pathname; path = path.replace(/\//gi, ""); path = path.replace(/%20/gi, " "); path = path.replace(/\\/gi, "\/"); alert (path); var path = document.location.pathname; [/cc] This javascript code gives us the path ...
Continue Reading

Comments (2)

How to Choose a Chart

Posted on 03 July 2009

How to Choose a Chart
How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise. The chart chooser diagram can help you make a choice in situations ...
Continue Reading

Comments (8)

Chartjunk

Posted on 29 June 2009

Chartjunk
Chartjunk, a term first coined by Edward Tufte, refers to all those elements in a chart that add no further value. Chartjunk comes in many shapes and size - redundant labels, unnecessary gridlines, over-the-top use of colors and everything that a 'creative' mind can think of. However what should be kept in mind is that this term also has a strong contextual meaning. An element that may appear as chartjunk in one graph may serve a useful function in another ...
Continue Reading

Comments (6)

Funny Side Up – I

Posted on 28 June 2009

Funny Side Up - I
What was meant to be a leisurely stroll with my more-expensive half along the beachfront yesterday, turned into half an hour of soaking in the rain followed by about 2 hours of journey back home. While on the way back, I saw a man helping a blind old woman onto the train carriage. A few minutes into the journey, as the station approached, she began walking towards the exit door. Fearing that she could miss her step and hurt herself, I ...
Continue Reading

Comments     

Funny Graphics

Posted on 21 June 2009

Funny Graphics
A couple of funny graphics to get you over the weekend blues :-) Viagra Sales (Courtesy: funnytimes.com) The right spot Finding the right man can be quite a challenge. (Courtesy: hottestsnaps.blogspot.com) Length of shorts (Courtesy: iamtheweather.com) The world of 100 If the world were to consist of only 100 people: ...
Continue Reading

Comments (3)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES