The Best Google Cake Ever (if you liked Insights)

Google Insights Cake

A delicious Google Insights cake

Google Cakes? There are loads of them. Look closely and you’ll even find a cake inspired by Google Analytics. But are you ready for the long, lost, long-tail, best Google cake ever?

So I was going through Evernote having a clear out, when I noticed this photo of a Google Insights cake that was made for a competition at work.

You may know that Google Insights has been absorbed into Google Trends and had a redesign, so this cake is no longer accurate. However, I like to think that this was more than just a quirky cake, it was a historically significant document. Unfortunately, it was also delicious, meaning this photograph, like the cake before it, is just a representation of something that once was.

I suppose I could do a whole range of posts of Google-related memorabilia (in fact I already posted my Android USB keychain, yes, I’m very sad). Unfortunately they move so fast these days that they’ll probably do anything I think of for real at some point. This would of course negate all the one-off novelty value, and steal the limelight for themselves.

I did look into Bing-themed cakes, but it seems nobody really wants to turn Bing into a tasty baked treat. That might be because the Bing logo doesn’t lend itself so well to the primary colours of shop-bought icing. I’d love to be proved wrong, of course. Send me your photos! Even better, send me your cake!

Share this!
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
Posted in Food | Tagged , , | Leave a comment

LOVEFiLM Buffering Problems? Here’s a workaround!

I’ve been having LOVEFiLM buffering problems for some time now. This only started when we changed broadband provider, so I’m tempted to say that it’s Virgin’s traffic shaping that is causing the issues. Anyway, I’m not writing to moan about that, I don’t know exactly what has caused the problem so I’m not pointing my finger at anyone.

When in full screen mode, I get LOVEFiLM constantly buffering every minute or so, for 2-5 seconds. This can get pretty annoying. It struck me that there was a pretty strong chance that in normal mode (with the video playing on the page it first loads on, i.e. not in full screen) it was a lower quality stream. This seems to hold true, since it never buffers for me at this size. Now, this isn’t perfect, it’s a workaround rather than a fix, but try the following if you are experiencing similar buffering issues with LOVEFiLM:

  1. Put the browser into full-screen (usually F11)
  2. Get the zoom right (usually using Ctrl and +/-)
  3. Scroll the window optimally using cursors or mouse

There you have it, a pseudo-full screen view that is pretty low quality, but in all my tests across Linux/Mac/Windows seems to do the trick and avoids all buffering problems…

Let me know how you get on.

Share this!
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
Posted in Quick Tips | Tagged | 2 Responses

Unhide Multiple Sheets in Excel

I recently had a need to unhide multiple sheets in Excel (maybe you call them tabs). Whoever sent me the original file had decided to spread their data out over so many extra sheets that it would have taken almost literally minutes to unhide them all. Naturally, I wasted even more time looking for a way to automate this process.

I found two pretty good ways to unhide multiple Excel tabs.

Unhide Multiple Excel Sheets Using Custom Views

Okay, this one doesn’t require any code and is EASY. It comes from http://www.accountingweb.com/article/hide-and-unhide-multiple-excel-worksheets-ease/220551 and works like this:

  1. Make sure all tabs are visible.
  2. On the View tab/menu, click on Custom Views.
  3. Add one and call it “Show All Worksheets” or similar.
  4. Make sure to tick the box that mentions hidden settings and press OK.

You can use the reverse of the above to hide the data sheets again by hiding them first and saving the view as “No data” or something. The only trouble with this method of revealing all your hidden Excel tabs is that it needs to be repeated for each new file. The following method can help with this.

Macro to Unhide Multiple Excel Sheets

This is a bit cooler but a bit more technical.

  1. Head over to http://excel.tips.net/T002603_Unhiding_Multiple_Worksheets.html for this one. There are two macros there, the first unhides all worksheets. The second allows you to choose which to unhide
  2. To add this to a new macro, go to the Developer tab, then Macros, then create a new one. Make sure to create it in your Personal.xlsb so that it’s universally available.
  3. Paste the code in and assign a keyboard shortcut (and/or add it to the ribbon).

There you go. I haven’t gone into too much detail here because both the sites linked above are great, I just thought I’d summarise the two methods of unhiding sheets together. I seem to recall an Excel plugin that would unhide multiple sheets in Excel — this was even easier than the above — but I can’t for the life of me remember the name, other than I think it was something like “Brian’s Excel Tab Unhider”, but I can’t find that through Google. It’d be great if someone could point it out to me again…

Choose Custom Views on the View tab or menu.Click Add, and then type a name for your custom view, such as All Sheets, and then click OK. Next, hide any worksheets as needed and then create a second view titled Presentation View, or a name of your choosing.

Share this!
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
Posted in Software | Tagged | 4 Responses

WordPress can’t edit category slug

WordPress can’t edit category slug?

WordPress wouldn’t allow me to edit the category slug “online-tools-2″ down to “online-tools” no matter what I did.

Just a quick shout out here to KAVDesign.net who have posted the answer to the problem I was having… thanks guys.

The answer in my case was to delete the tag that already had the same slug (which also leads to asking what I should be using tags and categories for, how they should differ).

Share this!
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
Posted in Blogging, Quick Tips | Tagged | Leave a comment

4 Wordle Alternatives

What is Wordle?

Wordle is a popular online tool that allows you to input a web page, block of text or list of keywords, and have it spit out a graphic known as a word cloud. Wordle does this job pretty well, but something that gets asked at work quite a lot is if there are any Wordle alternatives out there. In addition, Wordle is a little awkward if all you want is an image file at the end of it that you can paste into a presentation for example, without taking screenshots.

Here’s a list of a few sites that do a similar job (being sites they are of course compatible with Windows and Mac) and a few other alternatives to Wordle that you might want to consider.

Here’s an example of a Wordle word cloud for comparison with the alternatives listed below:

wordle alternatives

Wordle Alternative #1: ABCya! Word Clouds for Kids

ABCya! Wordle alternative

ABCya! Word Clouds is pretty basic, but it can be forgiven since it’s aimed at kids. It also has a handy randomise feature, so if you need a quick result, this is a great choice. It accepts a body of text as its input.

It also allows you to quickly adjust the number of words that contribute to the word cloud, which is also handy and allows you to eliminate truly infrequent words (the aim of the word cloud is to illustrate quickly what is popular rather than give the whole picture).

It occasionally seems to place a word too far out, and the random colour schemes can be garish at times, but that’s the whole point of random and it might be what you want!

Head over to http://www.abcya.com/word_clouds.htm to check it out. It relies on Flash which may be a pain point for some.

Wordle Alternative #2: Tagxedo

tagxedo wordle alternative

Second up is Tagxedo. Tagxedo has way more options as it’s not ‘dumbed down’ for children, so straight away you can use it to make a word cloud out of your blog, tweets, other RSS feed and more.

It also allows great control over the shape of the cloud including using words and graphics. As you can see above, I have chosen to create my word cloud in the shape of a rubber duck.

Something that wasn’t immediatiely obvious is that you have to let it load a preset word cloud and then click on “Load” to be able to add your own text for transformation.

A great feature of Tagxedo is that you can add a list of keywords of the form keyword:frequency (e.g. rubberducky:7) and it will act as if the word has been used that many times. For people with PPC or other quantified data (e.g. a keyword list from Adwords with impressions or clicks) it’s only a few concatenations away from providing a nice quick way to represent keyword themes to a client.

Tagxedo can be found at http://www.tagxedo.com/ and is built on Silverlight.

Wordle Alternative #3: WordItOut

WordItOut wordle alternative

WordItOut requires you to submit your email address before you can easily download your word cloud (although you could just screengrab it). This is a big turn-off, but its reason for asking is apparently so that you can share the tag cloud and edit it again in the future, amongst other things. This seems fair enough. The site is ad-supported which I would hope means they aren’t selling the email addresses on!

It’s neither here nor there in terms of features, sort of not as advanced as Tagxedo but cleverer than ABCya!. On the other hand it has a nice summary of all the word clouds that have been created by the community, which may be inspirational or a bit too sharey for you, but it’s interesting either way.

Also it appears to be written without Flash or Silverlight which is nice if you’re on an unsupported device or OS (but could explain the slightly less ‘tidy’ arrangement of words).

Link to Word It Out: http://worditout.com/

Wordle Alternative #4: Tagul

tagul wordle alternative

Tagul requires a full sign up before you can get cracking. It’s worth it though, because like WordItOut it means you can keep working on a tag cloud in case it’s not right first time. This is handy because Tagul has a decent number of features.

You will want to filter common words which isn’t a feature as standard (the other Wordle alternatives reviewed here seem to do it by default).

One cool feature is that you can embed your cloud with a default link for each individual tag, for example to click through to a Google search for the tag text itself.

Visit http://tagul.com/ for more, it uses Flash.

Other alternatives to Wordle

There is an interesting approach to getting a more dynamic Wordle cloud out of Excel here. Whilst this isn’t strictly a Wordle alternative, if your reason for seeking one was avoiding the process rather than the end result of Wordle, then this may help.

There are a whole bunch of Javascript tutorials that probably go beyond the scope of those who simply want to create a word cloud… maybe I’ll save those for another day. In the meantime if your aim is to get a static, non-Flash or Silverlight word cloud out of some data, there is an easy to understand example at http://www.lucaongaro.eu/demos/jqcloud/ – just check out the source of the page and you’ll see that you need to have word frequency calculated in advance.

Conclusion

There are plenty of other types of visualisation out there to be used, but word clouds are simple to read and a great way to illustrate the prominence of themes within a text or body of work.

If you have found any other Wordle alternatives then please let me know in the comments and I’ll add them to this list :-)

Share this!
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Twitter
  • Google Bookmarks
Posted in Online Tools | Tagged , , , , , , , | 2 Responses