trendspotting | Excel & VBA

3 Nifty Ways to Send Email Using VBA in Excel

Posted on 21 October 2008

This article shows three methods using which you can send email using VBA in Excel. You can download a working example of sending email using vba in Excel here. Excel allows you to create the best-in-class charts, work with large amount of data and data sources work with images, flowcharts and what not. And if that was not enough, you can use the inbuilt vba editor to automate sending emails from ...

Comments (50)

World 2020

Posted on 04 October 2008

Below are my predictions for how the world is going to look like in 2020 : 1. Electric cars would form more than 75% of all cars on the roads in Europe and more than 60% in the US. However gasoline production remains at the same level and we continue to pollute more. 2. Man would have landed on Mars. 3. Voice commands become an integral feature of Windows. The keyboard will still be around but the mouse will be replaced by touchpads ...

Comments (2)

Social Network use across geographies

Posted on 14 September 2008

The study conducted by ethority.com points out the difference in the choice of the social networking tool across geographies. While the Germans tend to prefer SchülerVZ, Japanese prefer mixi and Russians livejournal. Facebook seems to occupy the #1 or #2 in all the geographies studied. However it would be very interesting to see their evolution over a period of time. What is certain is that the present social networks ...

Comments

The Internet is an Interesting Place…

Posted on 06 September 2008

....and that's partly what got Barrett Lyon to create this beautiful map the internet by locating each C Class network in it. I think this has great potential. For example and as Lyon mentions on his site, if you get a chance to look at two pictures of a geographical location before and after a disruptive event takes place(like an eartquake or a Tsunami), this can give ...

Comments

Oiling the World Economy

Posted on 06 September 2008

In recent weeks Oil has moved down from $ 140 to $ 108. After reaching record highs, some experts now predict that oil will continue to decline and go back to normal. The trillion dollar question is WILL IT? The price that we pay for oil today certainly seems high, especially when one compares them to what the prices have prevailed for the greater part of this century. Once the oil ...

Comments (1)

The rise and fall of movies – NY Times

Posted on 04 September 2008

Mathew Bloch, Lee Byron, Shan Carter and Amanda Cox at NY Times produced this amazing visual showing the performance of movies at the box office between 1986 and 2008. Though the choice of an stacked area chart does not allow the reader to pick the numbers right off the chart but it certainly does pack a lot of information. Also check out the cool search feature!! The Ebb and Flow of ...

Comments (1)

Storm chase

Posted on 03 September 2008

These beautiful maps on Wikipedia show the paths of all the storms in the past few decades. As you can see, these tropical storms are the most ferocious over the Pacific West. The entire region consisting of Japan, China and South East Asia frequently encounter these storm systems. ...

Comments

God vs. Money, Obama vs. McCain

Posted on 02 September 2008

I don't know if there's any stastical validity to these results, but Google Trends does let you know what people across the globe are seraching for. As of today: Money 1.00 vs. God 0.62 Obama 2.80 vs. McCain 1.00 John McCain 1.00 vs. Barak Obama 0.50 http://www.google.com/trends

Comments