Finally – work offline with Google Docs

Previously on Google Docs and spreadsheets: you really had to be online to use them. There was a Google Drive app that let you work on this stuff in, say, your Dropbox account. But from today, you can get Google Docs and Google Sheets for iOS and work whenever you like.

I'm not a fan of Google Docs: I revise my opinion every time I see the price – it's free – yet I've found it clunky to use. And clunky to have online all the time.

This could change my mind – and I am shocked at you for making the connection that Microsoft Office for iPad just came out. Total coincidence.

Get Google Docs here and Google Sheets there. A presentation app is reportedly coming soon.

As ever, by the way, do go via these links to get the apps: going straight to the App Store and searching for them by name does not find them. Ridiculous and hopefully changing soon, but true.

Microsoft lowering cost of Office for iPad – a bit

Microsoft gives and Microsoft takes away. It’s interesting that this is in any way interesting: Microsoft Word for iPad, especially, is so much better than expected that it has become a genuine, serious contender. Enough so that if the pricing weren’t an issue, you’d have bought it and tried it already. Pricing is an issue, though, because you can’t buy Office for iPad at all, you can only rent it.

From launch to now, that meant paying $99 or so per year for an Office 365 subscription. Office 365 predates the new iPad offering so people and businesses who had already bought in to that programme for their home or work computers could just shrug, download Office for iPad and start working. While the price is a barrier to casual users, for serious regular users and devotees it was as close to a bargain as you could get. Office 365 effectively gave it to you for free: it cost you no extra to have a couple of iPads in your subscription.

That’s changed.

Now there is Office 365 Personal. There’s also Office 365 Home: Microsoft will never give up on making you study the feature list and regret your choice later.

Office 365 Home has UK pricing here and it’s £79.99 per year or £7.99 per month which gets you Microsoft Office on up to five PCs or Macs plus up to five iPads.

Office 365 Personal is £59.99/year or £5.99/month and for that much less you get much, much less. Only one PC or Mac (not even one of each) plus one tablet.

The two programmes also have storage but, hand on heart, I don’t understand the options. Whatever it’s all about, the principle is the same: the higher price gets you lots more.

But if you can live with the Personal constraints and you know you need Office for iPad, go take a look. Bring a calculator.

Readdle Printer Pro for iPhone free today

Actually, it's free for 24 hours – but I can't tell when that period started so just go grab it now.

As ever with these things, don't bother thinking about it. Grab it while it's free, ignore it or even delete it – and when you need what it does, there it is. Or you can re-download it for free. And you get updates for free. But only if you bought it during this free period.

I just went to check the details and discovered that I've done this before. I knew I had with a lot of apps – a year or two ago there was a massive spate of travel apps going briefly free and I nabbed the lot, have since used a couple too – but I found I'd done it with Readdle Printer Pro for iPhone too.

No idea when that was. But I don't believe I've ever used it. So this isn't a review, isn't a recommendation for the app per se, it's a recommendation that you take advantage of this chance to get a popular app and try it out.

France wants to stop emails after 6pm

You have to be in France. You have to be a manager there, too, because ordinary workers can lump it: if your boss needs you to answer your emails all day and night, you’ll answer them or else. But if a French plan to protect stressed bosses works, it will logically help everyone. Follow. When your boss is not allowed to go on email in the evenings then he or she can’t be emailing you anything. Everybody wins.

In many jobs, work email doesn’t stop when the employee leaves the office. And now France has decided to act. It has introduced rules to protect about a million people working in the digital and consultancy sectors from work email outside office hours. Those are taken to be before 9am and after 6pm. The deal signed between employers federations and unions says that employees will have to switch off work phones and avoid looking at work email, while firms cannot pressure staff to check messages.

Michel de La Force, chairman of the General Confederation of Managers, has said that “digital working time” would have to be measured. Some emailing outside of office hours would be allowed but only in “exceptional circumstances”.

Could work emails be banned after 6pm? BBC News

I’m more sympathetic to this idea that I might have been before. I used to live by the bleep of my incoming emails and now I’ve switched it all off. Almost all. Certain people’s emails make a bleep but the majority don’t. And I switched off push notifications too. Suddenly my battery life is longer and I am able to concentrate on more work because I just don’t get interrupted so often.

And I can tell you exactly where in Damascus I had this blinding revelation. Do read the BBC article because it is interesting but for useful ideas – specifically for useful ideas you can use right this moment – buy David Sparks’s book about Email from the iBooks Store.

You don’t have to be creepy about it

But do your homework about people. I just had a terribly fun meeting with someone – er, I hope she enjoyed it as much as I did – and before I got to her, I'd read her blog. I'd seen her professional pages, I'd read what she did, I had an idea of some of the work she did.

I intended to stop there. The idea of coming to a meeting entirely cold makes me wince but equally I'm there to meet you, I'm not there to show off my deep research. I really want to meet you: easily the best part of journalism is that you get to bound off and say hello to people you might otherwise never come across. Utterly love that.

And I stopped intentionally looking into this woman's background. But I've been trying a free iPhone app called Mynd and it did some digging for me without my realising it.

Mynd is like a calendar assistant; I found it because I was exploring calendars and looking for why I nearly missed an appointment recently. I also found it because it got mentioned a few times by Katie Floyd on the Mac Power Users podcast. All it does, I thought, is show me my entire day in one screen: how many events I've got to get to, where the next one is, what the weather's like today. I also found that it calculates how long it's going to take me to drive to somewhere and it will say so right there on the screen: you need to leave in 10 minutes if you're going to make the appointment. Sometimes it sounds a notification too. I haven't figured out why it's only sometimes.

But I have figured out that it believes I drive everywhere when really it's more that I drive almost nowhere. So I got a Mynd notification that I ought to get out of Dodge and start the car right now when I was already on a train to London.

I was going to ditch it for doing that. I have Fantastical now that does all the work I need of managing my appointments and events. (Fantastical 2 for iPad is £6.99 UK, $9.99 US. Fantastical 2 for iPhone is £2.99 UK, $4.99 US. The iPad prices are launch offers and will shortly increase by about 33%.) Plus I don't care about the weather and when I do have a mind to wonder about whether it's going to rain, I ask Siri.

But.

There is a panel on this Mynd screen called People and up to now it has always been blank. Today it showed a photo of the woman I was meeting. And it got that photo from LinkedIn. When I tapped on that photo, it showed me her short LinkedIn bio and then it had options for calling her. If you're running late, you open Mynd, tap the person's photo, then tap to send her a message. If you've got the number of her mobile, anyway. Or an email address.

That would be spectacularly handy if I were ever late for anything but usually I'm cripplingly early. Still, it's impressive.

What was even more impressive is that I scrolled to tomorrow, saw the first meeting had a fella's photo there – and behind it was a list of related Evernote documents. It's just reminded me of the last note I made when talking to him. Right there. I'd forgotten I'd ever made a note but there it is.

It's like Mynd gives you a personal briefing before you go to meet someone. I don't think that means you should skip looking in to them yourself, but I feel wildly efficient about tomorrow now. And I won't feel wildly stupid if he mentions the topic of my last note.

Mynd is free for iPhone on the App Store. There's no iPad or Android version.

Have a look at the Mynd website too. It proposes using the software as your sole calendar for a week and I've just learnt that you can do that. Bugger. I think I'll continue using it as an adjunct to Fantastical but it's handy to know that all the ordinary calendar functions are in this Mynd app as well.

I nearly missed an event today

And I have fallen behind on a project I am very keen to do.

I am compelled to make an excuse about the event, at least. It’s one that was rearranged to this afternoon, okay? And I caught it when I checked my calendar at 5am this morning. So when I say I nearly missed it, it’s not like I spilt my tea and had to run for the car. But somehow even though I want to go to this, and I will go to it, for some reason it wasn’t on my mental map of the week.

This is happening to me more often now and part of it is how I think my business is in a bit of a transition. Previously I was almost completely task-focused: I had this enormous list of things to do. It wasn’t event-based: I didn’t have a lot of meetings, for instance. Now I tend to run more talks and workshops – I did ten sessions in March – so my calendar is more important than it was.

I vehemently refuse to join up my tasks and my calendar: To Dos do not belong on certain dates. Or at least, they rarely really do. If something has to be delivered on Tuesday, you could put that on the calendar, fine. But do you then put a date on there that you’ll start the job too? Odds are, you won’t start it then. Instant failure. Instant unnecessary failure. Put the flexible start date in your To Do list, if you must, put the deadline in there too and then everything to do with that task is in one place.

I have zero question about this, absolute zero doubt. If you’re looking at me now thinking you’re not so sure, the strongest chance is that I have failed to convey to you why I think this. That’s how sure I am that I’m right. This is a rare feeling: let me have it. (Unless you really do think I’m wrong and you can tell me. I would prefer to know.)

But right or wrong, it is how I am working and today that isn’t working. So I’m taking steps.

And this has become a kind of live blog as I try to get a handle on it all. The aim is to get back on top of everything and to be creating new work, producing material, instead of losing most of my time to managing it all. And I know that the way this will work for me is in software. That’s just easily obvious because of prior experience. So taking a step back from that overall aim, I think that I can have two contributory aims:

1) Restore my previous excellent grip on all my tasks
2) Find a way to cope with my newfound extra need for handling events

The shorthand for number 1 there is OmniFocus. Much as I love that software, much as it as truly transformed my working life, my copy of it is a mess at the moment.

I think the shorthand for number 2 would be Calendar plus a regime of checking it. I do currently have a task in OmniFocus called “Check calendar for today and week ahead”. That repeats every week on Mondays, Wednesdays and Fridays. I’m not sure why that isn’t working, then. I don’t want to make it a daily task but we’ll see what happens. Okay, it’s 07:47 and I’ve decided to temporarily make checking my calendar a daily task for Monday to Friday.

And I’ve just downloaded the new Fantastical 2 for iPad. I’ve been reading about this since its launch yesterday and I’ve been reading about its iPhone version since, oh, just about the day I bought Fantastical 1 for iPhone and had it superseded. I agree with the consensus that Fantastical is a good, strong app but for me it wouldn’t stay, I didn’t keep using it on my iPhone because I just found the standard Apple calendar better. Not in features, not in ease of use, but both of those are fine and the Apple one has the killer feature that it can include the current date in its icon. I struggle to believe how often I have to check today’s date but with that right there, job done. With Fantastical, I had to go into the app. Job not done.

But Fantastical 2 can show the current date as a red badge notification on its icon. I’m hoping that will be enough for me because I like what I see about the rest of Fantastical. I like how it feels holding your month and week in your hand, seeing the shape of it all. I’ll play with this and try to get it into my habitual working pattern. If it doesn’t work, I’m out £6.99. If it does, I’m out a lot more because I can see me buying the iPhone update and the Mac version too.

For now, though, at 07:52, let’s say that my second aim is at least addressed if not necessarily solved.

So it’s time for aim 1: OmniFocus.

This is going to take some time. It’s going to be a huge change for me. I’ve let OmniFocus sprawl a bit too much, I’ve let it become a repository for everything in my life. Things I want to read, for instance. I save those to Pocket but I often send them straight into OmniFocus: maybe they relate to a project, maybe I just want to remember them and OmniFocus’s mail drop service is too handy. Whatever the reason, I need to use Pocket and Evernote more, and to keep this stuff out of OmniFocus. That’ll take some re-training. But I’ll create an Evernote notebook for it all and get into the habit of using the Evernote equivalent of mail drop.

But things have also changed in my business and life. I am very pleased to say that I am still on Room 204, a Writing West Midlands development programme, but I’ve finished the formal, official year there. So about a year ago, I created OmniFocus projects to do with Room 204 and the eight separate things I was doing with them. I’m still doing them, I’m still doing them with Writing West Midlands, but the Room 204 projects need to go.

I’ve also got very lazy. If a great benefit of OmniFocus is that you know what you need to do now, that works because it hides from you everything you don’t need to do now. Only, for that to work day to day, you have to often review absolutely everything: go through all your tasks and see what’s done, what isn’t but can be, what will never be done and should be deleted. The idea is that you work through every task and you spend time on every task. This is more than an idea, it’s a principle and I have found that it works brilliantly for me.

Except lately.

Lately, I’ll do the review process and see – wait, let me try it right now – okay, I only have 12 projects review. Last time it was 67. (You set this project by project. You have to review everything but one project is my shopping list: I’ve set that to be reviewed once a year. Other stuff has to be reviewed every day.)

Especially when I’ve got 67 projects ahead of me, I’ll look at the list and I won’t patiently dwell on each separate task. Rather than do them right there and then or consciously test the task – why isn’t it done? what do I need to do it? – I just think yeah, yeah, haven’t got to that yet. And then I move on.

I can’t let that continue because I’m missing things and I’m not getting stuff done as much as usual.

So. It’s 08:03 and I am going to pull out the list of projects. I’m going to do a MindNode mind map of everything I actually have to do and compare that with what I’ve got. It’s slate-clean time.

Later…

Four days later. That is a hell of a slate-cleaning. I would like to point out that I did have that meeting to go and then there was something else on Friday, plus I worked the weekend… and all the way through, I was thinking of this. Right now, Monday at 12:12, I’m happier and I think I have proof that I am.

Let me tell you the proof first: I have no overdue tasks in OmniFocus.

And only 16 more things to do today.

It’s funny but having overdue tasks was proving to be a huge weight. It’s not really funny because it isn’t funny but it also isn’t funny because that’s how things used to be. That’s how they were before I moved to OmniFocus. Maybe it was worth letting things slide because I am reminded with extreme gusto that I do not ever want to feel this weight again. It’s paralysing: you feel you can’t clear that backlog, that there’s no point doing anything more.

So you now you’ve got to know how I did it. And it turns out I was right: it was a two-step thing.

The first was the Calendar and it was Fantastical 2 for iPad. I found that I still had Fantastical 1 for iPhone and I’ve been using that too – I’m honestly not sure what the difference is beyond some obvious aesthetic ones – and the combination has been useful. I’ve had to train myself to turn to my iPad whenever something comes up that needs me to look at my Calendar: even if I’m at my Mac, I turn now to the iPad for this. It’s not a habit yet but it’s becoming so and each time Fantastical does something clever, I am that much more sold on it. The most specific clever thing it does is accept natural language statements: typing “Lunch tomorrow with Steph at Birmingham” pops all the details into my calendar in the right spot. It reckons lunch is 1pm and actually I needed to change that but it was easy enough. But it new Birmingham, actually it knew the more detailed place name I put, and it knew what day tomorrow was. It’s very satisfying entering an event like this because it parses what you type as you type it: you see the place name flying off to that section of the appointment, you see the time going there too and you can see the calendar zipping along to the right day.

Also, it turns out that having today’s date as a red badge notification means that my muscle memory automatically makes me open the calendar. See the badge, intellectually know that it’s the date, but still open it as if there is something I need to be notified about. It’s made me open the Calendar about thirty times since last Thursday and as irritating as I suppose that is, it’s helping me to reinforce this new habit of using both Calendars and OmniFocus.

The second thing began with the way that a friend pointed out how casually I had planned her working year for her in a chat one day and she was back now with a pen to do mine.

Terrifying.

And we didn’t finish. But we’re still in play and I’ve been taking her advice to heart. That coupled with the most massively tedious reorganisation of OmniFocus has all proved part of it.

I’ve been using the new OmniFocus 2 for Mac beta because it’s the quickest version and also, I now think, the most pleasant to use. But this reorganisation meant replacing every old project with an entirely new system, then seeing what fitted the new plan and what did not. I have very ruthlessly and with only a little blood deleted gigantic chunks of tasks because I haven’t done them and, William, I ain’t going to. So they’re gone. Kiss ’em goodbye.

I did a MindNode map as I told you and this is how that looks. You know I can’t let you see the details, there’s plenty of confidential stuff in there but this is the shape of what I was dealing with.

mindmap

 

Look at that mass of colour in the bottom left corner. The centre word there is ‘Kill’ – these are all the entire projects I deleted as part of this reorganisation. The smaller blog of colour is a set of seven other projects that I have taken out of OmniFocus and put into Evernote: they’re all research jobs, all reading ones where I was amassing things to read but no actual tasks yet.

Then the rest is everything I am in fact going to do. The central word, the white blob around which all the rest of the colours flow, is “OmniFocus”. And that’s apt: this app is that central to everything I do.

I still need to work out a system for tying those Evernote documents in to the tasks as they come up. It’s easy enough technically, you copy one thing from Evernote and paste it into OmniFocus – or vice versa – and are thereafter just a clicked-link away from either. But it’s the mental system that’s hard, the decisions I need to make about putting stuff in OmniFocus or in Evernote.

Similarly, if I get an email from you with a task in, you can bet I forward it on to OmniFocus but when do I then archive that email, when do I put it into my Follow-up inbox to make sure I see it? For that matter, when do I only put it into Follow-up, when do I not bother making it an OmniFocus task?

I’ve still got to work all that out but it will come and right now, I’m exhausted yet much happier. I mean, much. If you’ve read this far, you’re a mensch and I want you to take away this single point: getting on top of everything you have to do – just getting on top of it, not necessary even doing it all – makes you feel infinitely better.

Use Microsoft Office for free on iPad – kinda

It's a trick, but it might be useful if you don't want to pay a subscription just to make one twiddle in a one Word document. As of today – 28 March 2014 – Microsoft Office for iPhone is completely free. Not just free as in you can read a document but must pay to edit or create ones, it's completely free.

But you can run iPhone apps on your iPad. They don't look great. This one doesn't look as good as the proper iPad version of Office released yesterday. But it is Office and it will open Word and Excel documents. Possibly also PowerPoint but, seriously.

You do still have to sign up for a Microsoft account and there are myriad better ways to write and edit documents than on the scaled-up iPhone Office but it works.

Get Microsoft Office for iPhone (it's one app with Word, Excel and the other one together) here.

Get Microsoft Office for iPad here – if you want

It's been a long time since I would've automatically bought Microsoft Word for anything, for anywhere, let alone for my iPad. Word's last killer feature was that everyone else had it and everyone needed documents sent in that format. Once we couldn't get it on iPad, we said nuts to Microsoft Office and did just fine with everything else. We did so just fine that now Office has come, it's a shrug.

Partly because we don't need it, partly because you have to pay a subscription to use Word, Excel or PowerPoint to actually do any work.

But aren't you curious? Don't you just want to try it out? You're bound to have some Word or Excel documents somewhere and you can read those in Office for iPad. You can read them in anything, really, but you can get Office and you can have at least something of a play, so give it a go.

Except.

Truly, Apple's App Store has some severe problems when you can't find Microsoft Office for iPad on it on the day it launched. Seriously: search for Microsoft Office or Microsoft Word on the iPad App Store and you will get a slew of other apps first. I couldn't find it at all. Searching for just the word Microsoft is worse.

But somehow Microsoft OneNote pops up in various searches and if you select that, there's a Related tab which does show you Word, Excel and PowerPoint.

Don't bother digging, I've done that, here are the direct links:

Word:
https://itunes.apple.com/gb/app/microsoft-word-for-ipad/id586447913?mt=8

Excel:
https://itunes.apple.com/gb/app/microsoft-excel-for-ipad/id586683407?mt=8

PowerPoint (seriously, you want PowerPoint?)
https://itunes.apple.com/gb/app/microsoft-powerpoint-for-ipad/id586449534?mt=8

Notice the /gb/ part of those addresses: these are the UK (or Great Britain) links but tap them wherever you are, iTunes will figure it out.

Even if it's the best-ever implementation of PowerPoint, that presentation app would come a distant fifth out of the three anyway. Excel is certainly the most powerful and least top-heavy of the three. But I am a writer and I've got form writing about word processors so it is Word I naturally go for. And without yet schlepping through setting up a SkyDrive (or whatever the lawyers require Microsoft to call that now) and definitely without paying around $10/month or about $100/year just to experiment with typing, I've gone for it and got it and am now deleting it.

Good to see it finally arrive. Good to see it seemingly well-worked out. I just need a compelling reason to buy it and it's been many years since its mere existence on iPad would be enough.

How to pick the right To Do app for you

Let me do the joke first: if you have a Mac, iPhone or iPad, buy OmniFocus. That’s it, we’re done, thank you for coming, I’m here through Friday, two-drink minimum, see your waitress for details, try the veal.

OmniFocus is so good that I’ve been asked whether the makers pay me to say that. And I really would offer it up as the one-stop, suits-all solution except that you can’t just stop once and it doesn’t suit all. It’s pretty close. Two things held me back from recommending it universally and one is that the Mac version has been hard to use. I’m sure I can’t say anything in detail about the beta release of OmniFocus 2 for Mac but I will certainly tell you that it is really good and much easier to use than it was. I’m saying easier, I’m not saying easy. But OmniFocus 1 was always worth the effort it took to learn it, OmniFocus 2 gets you its powerful features much more readily and clearly.

The other thing that has held me back from universal recommendation, though, hasn’t changed. And it won’t change. OmniFocus only runs on Macs, iPhones and iPads. There’s no Android, Linux or Windows versions and seemingly there never will be. I’m fine with that. Better the company stays great on one platform than it becomes okay on a few.

But it does mean I have difficulty recommending To Do apps. Actually, I won’t blindly recommend specific ones – not even OmniFocus when it comes down to it – because everyone is different and the best I can do is point you to some great and good To Do apps. In my latest The Blank Screen workshop, I discussed specific To Do software and hit a snag. To Do apps for iPhone: legion. To Do apps for Android: myriad. To Do apps for Windows Phones: hello?

Try this yourself. Do a google search on “best to do apps for Windows Phone”. You will get many results and several will be articles that state they include such things as To Do apps – but they don’t. I’ve read many top tens, top twenties, top something else and found not one single To Do app in there.

At the other end of the scale, if you have an iPhone, you’ve already got a good To Do app. It’s called Reminders and it’s very basic but what it does, it does very well. Reminders invented the Location Reminder idea – the way that when I leave a certain client’s office, my iPhone will tell me to send them an invoice – which I think should be mandatory now for all To Do apps.

Mandatory is a hard word. To Do apps are also a great example of when the word specifications is bollocks. I do recommend that you try many different apps but if, in so doing, you decided to write up a spec sheet of what they all did, it wouldn’t help you. Remember the Milk would score high for being on the web as well as Macs and iOS; OmniFocus would score low for being limited to Apple’s gear. Yet Remember the Milk isn’t right for me and OmniFocus is. Though I love the name Remember the Milk.

You can’t quantify experiences like using the right To Do app. But you can try.

Picking the right To Do app for you means testing out a lot. But you can limit how many you have to try or buy with this one simple thing: don’t look at a To Do app for mobile phones and tablets or for desktop Macs and PCs or for using online, if it doesn’t have Start Dates. These may be called something else like Defer Until (that’s what OmniFocus calls them and I don’t like that). But when you enter or edit a task, you must have the ability to prevent yourself seeing it until you need it.

Follow. I’m doing The Blank Screen at the Stratford Literary Festival in May. I do not need and I do not want to see that on my To Do list until it’s time to prepare for it in about mid-April. So I don’t. “Prepare presentation for Stratford” is in my To Do list but it has a Start Date of 15 April and until that day, I won’t see it. I can look for it, I can see it when I review all my tasks, but each day as I look to see what I’ve got to do, Stratford will not be one of them – until it’s supposed to be.

Start Dates are as vital as Due Dates and if you use them, they are gold. But even if you don’t and never will, the fact that an app has them is a good indication that the app is powerful. Maybe you don’t need powerful features, probably you do, but it’s better to have them available, isn’t it?

 

Thoroughly biased app recommendations

But not my bias.

Staff at the fairly new site The Sweet Setup have jotted down a lot – a lot – of apps that they use on iOS and Macs. What's good about it is this is a collection of apps that a group of people have tried and tested, yes, but also come to rely on. There's no attempt to calculate a score or to compare things very much so there are many times that competing apps are mentioned just because they are what the Sweet Setup staff genuinely use.

What's not so good is the repetition in the article. It's divided into useful general categories like Productivity but then only seemingly-useful ones like Mac, iPhone and iPad. If you just dip in to one, you're fine. But I have and rely on the three equally soI read the whole article – until the repetition got too irritating. If something is mentioned in the iPhone section and there is also an iPad version, it gets listed there too along with almost identical text. Almost. Someone has obviously decided they can't repeat the text verbatim but they haven't done anything very good about it.

So read with that one caveat, okay? Here's the direct link to the piece but do then also take a look around the rest of The Sweet Setup.