Leighton Price
Data Analysis & Information Management
With a background in business analysis, moving, interpreting and sharing data is a big part of my life. Consequently, I just love a good spreadsheet and creating robust and dynamic solutions with them.
Mention spreadsheets and Microsoft Excel springs to mind. Indeed, I'm as enthusiastic about Excel's Power Query as the next person. However, in recent years I've become a power user of
Google Sheets.
It's a superb tool for collaboration and/or remote working, has a clean UI and for 95% of Excel users, is "good enough." Having used SQL, I find Google Sheets' built-in
QUERY function
to be extremely powerful and use it extensively. I'm also using
Google Apps Script
more and more.
You can get in touch with me
here.
Information Management: Apps & Services
A power user of both macOS (16 years) and iOS, I automate tasks using a variety of apps and services.
Highlighting my preference for portability, information relating to how I integrate the services I use with each other, is presented in differing formats below.
myMindNode - An interactive, online mind map made with MindNode on macOS and iOS
Web page - Mind map above exported as Markdown and converted inline with this script
PDF presentation - Mind map exported as Markdown and converted to slides using Deckset
Dropbox Paper - Mind map exported as Markdown and rendered as an online outline
Workflowy - Mind map exported as OPML and published as an outline online
Todoist
I'm a long-time user of
Todoist for task management. In recognition of me helping folk get the most out of it, I'm now one of a select band of
Ambassadors
for it. Here you'll find some tools and resources I've produced, specifically designed to enhance the Todoist experience. All are fully-documented to aid ease of use.
My own guide to the natural language syntax for Due Dates & Times in Todoist - Todoist's own website is far from exhaustive in detailing the natural language entries that can be used for setting due dates and times. I've documented the extra inputs I've learnt over the years, including recurring/repeating task structures
Todoist Template Generator - This Google Sheet streamlines the production of project templates, also ensuring timelines can be changed dynamically before importing into Todoist. Here's a
blog post in French about it written by a fellow Todoist Ambassador. You can make your own copy of it here
Sequential Tasks - A quick & easy means of creating a list of sequential tasks in Sheets ahead of copying into Todoist. You can make your own copy of it here
Recurring tasks 'n' days from end of each month - You can use this Google Sheet to quickly and reliably create the syntax for recurring tasks that repeat on a cycle of a specified number of days before the end of each month. You can make your own copy of it here
Relative Due Dates Tool - A further development of the previous tool, this one overcomes some of the shortcomings of the recurring tasks natural language syntax by dynamically creating multiple due dates formatted for easy pasting-in to Todoist. You can make your own copy of it here