2009 In Review
Dick Kusleika did a 2009 in Review post, so I'm obligated to imitate him.
Here's an overview of the year's stats:
The average visitor spends 2 minutes and 18 seconds here, and views 2.82 pages.
The top countries are: U.S., United Kingdom, Canada, India, Australia, Germany, Netherlands, France, and Singapore.
In terms of page views, here are the top-10 individual documents at this site for 2009:
- Spreadsheet Protection FAQ
- Referring To Ranges In Your VBA Code
- Cell Counting Techniques
- Employee Time Sheet
- A Formulas To Calculate A Ratio
- Creating A "Megaformula"
- Alternatives To Nested IF Functions
- Comparing Two Lists With Conditional Formatting
- Protecting Cells, Sheets, Workbooks, and Files
- Excel Easter Eggs
Here's a chart of the number of page views, by day:

The cyclical dips indicate weekends. That big spike was on August 11-13. Page views were about double during that period, and the extra traffic came to view that Megaformula page. Oddly, there was no major referrer for those three days, so it's possible that the link was in a printed article.
That low point was on April 9. Either my site was down most of the day, or Google Analytics was down.
Here's a chart that shows traffic by source:
Surprisingly, Internet Explorer is still the most popular browser (64%). It's followed by Firefox (28%) and Chrome (4%).
- Reader Comments -
Following are comments in response to this item.
The most recent comment is at the bottom.
- By Zach. Comment posted 14 January, 2010 3:52pmI bet the reason why most of your visitors use Explorer is because the majority of people who still use IE are people who use it at work (60% of companies use IE6 as their default browser), and since most people use Excel while at work, that is where people are reading your blog. Check out this article on the subject: news.cnet.com/8301-17939_109-10231713-2.html
- By Jonas. Comment posted 15 January, 2010 1:11amAgree with Zach. I have IE at work, and that's where I read work-related blogs. At home I use Firefox, but I am in fact considering moving back to IE. The weekly "Firefox is updating itself... please wait a couple of minutes..." is driving me nuts!
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.

