07 Jan 2010
I’ve been doing a little bit more work with some spreadsheets recently
and I came across a situation where I needed to work with a date and
carry out a comparison to a string of text. My first attempt fell short
as it wouldn’t get the value I wanted, but Excel’s TEXT()
function came
to my rescue.
01 Jan 2010
It’s been about a year since I started blogging here and whilst it was primarily supposed to be a site for quick useful tech-related posts several have grown into far larger posts. Whilst some posts have remained somewhat quiet on the number of reads others have generated far more interest than I could have expected.
Read More31 Dec 2009
Currently Evernote does not currently support outline structuring for notebooks. This means that you can’t group notebooks into collections (e.g. folders) or have sections/sub-notebooks. Recently I posted about why in many cases it is often better to use tags rather than notebooks as this allows you to better mark-up notes for searches and the like. However there is a desire to sometimes have information hierarchically organised and this is where an outline structure for notebooks in Evernote would be useful. Until the Evernote developers catch up on this popular request across all of the software platforms tags can provide you with a workaround.
Read More30 Dec 2009
One of my best technology purchases in 2009 was my Huawei E5830 MiFi. The best way I have to describe it is like a smart phone without the phone bit. It connects to a cellular data network and shares the connection over a self-generated WiFi network with up to five other devices such as a laptop or iPod touch.
Read More27 Dec 2009
This coming year I’ve decided to take a different approach with one of my core applications, Evernote. It’s based around reducing the number opf notebooks I’m using whilst increasing the number of tags. This is the opposite to what many Evernote users are doing, so I thought it might be useful to explain what my reasoning is behind this.
Read More08 Dec 2009
Several months ago I got a Dell Latitude E6400 laptop to replace my overworked Dell Latitude D410. Along with the laptop I got a new advanced E-dock which included two monitor outputs, so I recycled an old smaller monitor that had been relegated to the stores to have a dual monitor set-up.
Read More07 Dec 2009
Evernote is a great application for jotting down a quick note about something new, but occasionally I find that I want to jot a note that’s very similar to an existing note. I predominantly use the Windows 3.1 version and whilst it looks as though copy and paste is enabled for notes it isn’t. So how do you do it?
Read More06 Dec 2009
I regularly make use of Evernote from my iPod touch (effectively an iPhone without the inbuilt communications) and I frequently look to add information from a web page in Safari to Evernote. As I’ve written about before, the standard Evernote bookmarklet can be added to the iPod/iPhone Safari app and this will then provide an option to set a title for the note as well as providing an option to add tags. I find this useful but invariably it is quite slow.
Read More03 Dec 2009
If you’ve used Google Earth on the iPhone or iPod Touch have you ever visited one of the poles? If you do be sure to check out the compass in the top right corner of the screen. If for example you zoom in on a point roughly 90°N & 135°W you will see the compass rotate and spin freely.
Read More02 Dec 2009
We have a number of E-series Dell laptops in my organisation and whilst we don’t configure it many have Dell’s Latitude On installed. This is a small Linux install that gives quick read only access to things such as recent mail, calendar and even a web browser.
Read More