Thursday, August 20, 2009

Friday, August 14, 2009

How To Split A Huge CSV Excel Workbook Into Separate Files

Linked from Makeuseof.com

How To Split A Huge CSV Excel Workbook Into Separate Files:
csvHeadI recently started working with a company that does HUGE mailing lists. I deal with a lot of records everyday but this really is a lot of data.
They have an opt-in mailing list that they blast to once or twice a month. When I say huge I am talking about between 7 and 8 million email addresses.

Wednesday, August 12, 2009

Excel Tips

This is kind of a ready reckoner for myself and hopefully useful to anyone who visits this blog. There are so many tips and tricks to achieve some not so easy tasks in excel. Over a period of time one gains sufficient experience and learns how to get some stuff done.

Wednesday, July 29, 2009

MonaLisa in MS Paint

I’m sure many of you must have already seen these video, but this is the first time I saw it and was stunned beyond words. As if creating something so brilliant with a mouse itself is not amazing enough(though I have a feeling the artist used a tablet), the whole thing was done using Microsoft’s much maligned and abused MS Paint.

Wednesday, July 22, 2009

Google fusion tables: is it from Gapminder?

Quite some time back, I had come across this talk by Hans Rosling at ted.com. Ted is one site, which I frequently visit to listen to great speakers, tech leaders and futuristic ideas. Hans is a Swedish professor, who built a tool to present data in a visual format using multiple dimensions rather than the usual 2 dimensional graphs.