• Buffer
  • Sharebar
  • Buffer
jethro's picture

The SpyJournal Weekly and Tim Miller Daily

Paper.li allow you create personalised newspapers – summarising your tweets, and community news in various areas.

I have been running two for some time now – the Tim Miller Daily and the SpyJournal Weekly.

Check them out and subscribe if you want an easy grab of my twitter feed in one bite

image

jethro's picture

I got my invite to Alto Mail

Alto Mail is a web based (browser) new (?) way of managing mail from services like Gmail, yMail, Aol and iCloud.ITs main benefit is the ability to group and sort in stacks mail from any sender or group of senders.

It also exposes very simply pictures and other attachments in a nice easy to see view.

I'm trying it on my Gmail account – which seeing as its chiefly used for service sign up and notifications doesn't contain much of value. However I can already see how this would be of benefit to anybody who uses Gmail for example which has a difficult to use interface. This makes Gmail far more friendly in a browser!

image

Sign up for your beta invitation and get ahead of the rest!

jethro's picture

How to remove #N/A errors in Excel

Today I had an email request:

I wasn't sure how to post, or join so I'm sending my question to you this way. I cannot figure out how to remove the #N/A error in LOOKUP. If the cells are blank it returns the #N/A error - I'd like to return either a blank or 0 instead. How do I do that? Her is my formula. (I'm sure you can tell by my formula I'm a rookie at this.) Any help is appreciated. Thanks!

=SUM((LOOKUP(B6,{1,2,3,4,5},{40,30,20,10,0}))+(LOOKUP(C6,{1,2,3,4,5},{40,30,20,10,0})+(LOOKUP(D6,{1,2,3,4,5},{40,30,20,10,0})+(LOOKUP(E6,{1,2,3,4,5},{40,30,20,10,0})+(LOOKUP(F6,{1,2,3,4,5},{40,30,20,10,0}))))))

Excel-2013I have written a post on this before when I explained the ISNA function.

In this case I will break down the first component of the formula and show you how to insert it.

First of all understand that because this formula is summing components that are lookups, if any one of them returns an error than the overall sum will be an error even if the rest is not an error.

So to fix =LOOKUP(B6,{1,2,3,4,5},{40,30,20,10,0}) when it displays #N/A (eg if B6 is less than 1) we would use this function:

=IF(ISNA(LOOKUP(B6,{1,2,3,4,5},{40,30,20,10,0}))=TRUE,0,LOOKUP(B6,{1,2,3,4,5},{40,30,20,10,0}))

The same concept could be used for each lookup component. In this case the formula would become very involved so there might be easier ways to do it. Sometimes breaking the individual components our into individual cells and then summing them is a way to give more visible results – and easily see which component is causing the error.

So Lois – i hope that helps – and thanks for liking us on Facebook!

jethro's picture

Backing up the cloud

I have been using cloud technology for a long time. I store large amounts of my data and information in numerous cloud services. cloudhqSome are free and some I pay for. Some I control (on my own servers) and some I am at the mercy of the provider. Some data I want to share with other users, either read only or read write. Some I want to have available to me wherever I am or on what ever device I am using.

Here are some examples:

  • Email – using Microsoft Exchange, I use one account on my own server, 1 on a clients server, and 2 on Microsoft Office 365 servers. I can access all my email, contacts, tasks and calendar from any device I choose or any location in the world where I have internet access.
  • Photos – I use Flickr and Skydrive.
  • Data – I primarily use Box and Dropbox. – I share with staff and family. I also share files to customers using Dropbox. I also have a Google Drive account and Skydrive.
  • Notes – I use Evernote and OneNote. I share these to staff and family.
  • Collaboration – I use Sharepoint on my own server and also on my Office 365 servers. I also use Basecamp to work with The High Calling team.
  • Blogging – I use this blog on my own server. I also use Twitter and Facebook heavily.

How do I back that all up?

So the question arises – what happens when things change. How can I protect my data.