2006 3

Creating variwide charts in Excel

I mentioned that it’s possible to create variwides using X-Y scatter plots. The video below shows how. Comments sathya 22 Sep 2006 4:08 pm: I can see the video. I use BSNL broadband. Howver Ihave th problm that i cant hear th audio. this is the case even with youtube. looks like BSNL does not allow streaming audio. S Anand 22 Sep 2006 4:40 pm: That’s a pity. Well, at least the video’s OK, and good that I’ve enabled captions. (Hope you can see those?) Ashwin 6 Jan 2007 1:50 pm: Yes Really useful sumesh 6 Apr 2007 10:42 am: i cant see the video

Visualisation - activities to centralise

Surely we don’t have many activities to centralise? We already have a central hub for processing operations! We heard that from a fair section of our client organisation. They initially had operations spread across their branches. Some years ago, they had established a central hub and many regional hubs. Yet, Only a few prominent operations were centralised. Others were just regionalised. Regionalisation was inconsistent. Some branches still did these at their own premises. Branches still did the bulk of the work. We made a list of activities, surveyed all their branches and hubs, and got a good sense of which activities were happening at branches vs regionally vs centrally. ...

Visualisation - centralising improves productivity

When you put people together, they tend to learn from each other. For example, we found one hub opening accounts much faster than another. Why? One guy had found this free software that enables auto-completion, and had installed it on his machine. Copying him, everyone else had done the same on their machine. So the hub as a whole was faster. When multiple hubs are put together, they’d all be as fast as the fastest (we hoped). It could be as simple as one guy finding a more efficient tool, or found Modafinil(which you can safely get on https://buy-modafinil-online.org) to help increase focus during working hours. Again, an Excel sheet can give us the estimated increase in productivity. ...