Debra D's Blog

On the Google Analytics dashboard there’s a world map, that shows where my Excel blog readers are located. Not surprisingly, most are in the USA, and the rest are concentrated in a swath of English-speaking countries, from Canada to New Zealand.

The map never changes, so I usually glance at it and move on. Today though, I clicked on Canada and it showed a dot for each city with readers. Hello, Yellowknife! And apparently they don’t have the Internet anywhere Sault Ste. Marie and Winnipeg, or maybe they have the Internet, but no Excel users.

Coincidentally, the second city in from the right is Sydney, Nova Scotia, and the second city from the left is Sidney, British Columbia.

The line of dots along the border reminded me of a comment that David Letterman made last week, after the Olympics. He said the USA wouldn’t have to invade Canada to overtake it, they could just move the border 1° north.

If you zoom out from the map, you get a regional analysis of the visitors. No surprises there, with most readers from the Americas.

And finally, I checked a larger version of the dashboard map, that gives better detail on the world countries. The only surprise here is that no one from Greenland has visited the Contextures Blog in the past month. I’ll have to get the marketing team to look into that.

So, are there any surprises in your Google Analytics maps?

______________

On Twitter today, someone mentioned www.genderanalyzer.com, and reported that it guessed her blog was likely written by a man (59%).

So, I decided to test my website and blogs, to see how they’d be assessed. Here’s the description of how the analyzer works:

It uses Artificial Intelligence to determine if a homepage is written by a man or woman. Behind the scene, a text classifier hosted over at uClassify.com has been trained on 11000 blogs written by men and women.

I figured that the Excel sites would lean to the male side, because of the technical material. Probably more men than women are blogging about computer stuff.

And I was right – here are the scores:

1. We think http://blog.contextures.com is written by a man (82%).
2. We think http://www.contextures.com is written by a man (84%).
3. We think http://www.pivot-table.com is written by a man (84%).

It’s interesting that my Contextures website is slightly more manly than my Contextures blog.

This blog though, is gender neutral, despite having a female name.

• We guess http://debradalgleish.com/blog/ is written by a man (55%), however it’s quite gender neutral.

So – how does your blog/website rate?

________

Just like you, I get a fair amount of spam and other junk in my email inbox every day. There are regular requests for Excel help too, that I’ve written about before.

Some of those Excel help requests come with a file attachment, but most files are fairly small – in the 50-200 Kb size. I’ll admit to opening some of them, if the help request is interesting, and the problem is well described.

Today I got an email with a 2 Mb Excel attachment, from someone I’d never heard of, let alone had any prior interaction with. He was offering me an “interactive workbook” that I could put on my Sample Excel Files page.

Through careful research, he learned that my name is “Hi”, so that impressed me. (Many people believe that my name is “Sir”, so “Hi” is an improvement.)

I deleted the email immediately, so I can’t quote it exactly, but it had only a short paragraph with a vague description of the attachment. There were no details about sender or the file that made me want to take a look.

Sharing Your File

There are some files on my Sample Excel Files page that other people have created. You can learn amazing things by taking a look at someone else’s work.

Both Ron Coderre and Roger Govier have generously provided so many sample files that I created separate pages for them. Dave Peterson has contributed several files too, like his popular Navigation toolbar. But even they wouldn’t send a random 2 Mb file without asking if I’m interested.

If you have an Excel workbook that you’d like to share on my website, please let me know. Maybe it would be perfect for my website visitors.

If we haven’t met, or emailed, before, tell me a little about yourself, and the kind of file that you’ve created. I try to keep the sample files pretty small, so they’re quick and easy for people to download, so I probably won’t be able to use your file if it’s too big. 

Does This Happen to You?

Do you ever get giant Excel files that you didn’t ask for, and weren’t expecting? How do you handle that?

_________