Why are you being so silent?

Why are you being so silent?

It has being nearly half an year since the last post about workflower was out, why did I stay so silent for that long?

I have three major updates to explain the silence:

  • 📚 Good guys at Packt publishing asked me to write one more book about R and data mining, I suppose this is because the first one was well received
  •  📦 I spend my spare time working on updateR so to get it ready to go on CRAN. We make it so shining and bright that it got noticed by our beloved Tal Galili and we are now working togheter to merge it into his great package installR
  • 👶🏻 We at home are waiting the fourth kid 

More is coming about the first two points later on this blog. If you are looking for more news on the third point you can write to me privately 🙂. 


a Checklist for your weekly review (GTD methodology)

a Checklist for your weekly review (GTD methodology)

I was crafting this checklist for my personal use, and then I found myself thinking: why should’nt I share this useful handful of bullets with my readers? So here we are, find below an useful checklist for your weekly review. The checklist is derived directly from the official GTD book by our great friend David Allen. The greatest quality of the checklist is the minimalist approach: just what you really need to read is written within each point, so that you get through your review as quick as possible. Enjoy!

Weekly Review Checklist for GTD

  • look for sleeping actions within SMS, mail, backpack, notes and whatever. collect everything into your inbox.

  • look for previous and next weeks within your calendar, any sleeping action out there?

  • process your just-feeded inbox, get it empty!

  • check all actions you completed during past week and you didn’t checked off because you were, as usual, in a rush

  • look at your waiting for list: any one to followup?

  • look at your active projects: is there at least one next action in the proper list for each one of them?

  • look at your someday/maybe list: had come the time to embrace any parked project/action?

I personally use this checklist every Saturday morning and we can therefore give it for tested, nevertheless I am here to listen to every suggestion of improvement. You can download here below a PDF version of the checklist for your convenience.

download a free PDF version

How to list file and folders within a folder ( basic file app)

How to list file and folders within a folder ( basic file app)

I know, we are not talking about analytics and no, this is not going to set me as a great data scientist… By the way: have you ever wondered how to list all files and folders within a root folder just hitting a button?

I have been looking for something like that quite a lot of times, for instance when asked to write down an index of all the working papers pertaining to a specific audit ( yes, I am an auditor, sorry about that): really time-consuming and not really value-adding activity. Continue reading “How to list file and folders within a folder ( basic file app)”

download data to excel from web

download data to excel from web

This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query.

Download data into excel

select “data” tab

download data in excel


select “from web”

 from web selection


input the desidered web URL

input web URL

click “go” button

go button click

select data you want to download

data selection

click “import” button

import button click

Refresh downloaded data


select “data” tab

Image [9]

select “connections”

dowload data into excel

select your connection

connection selection

click “refresh” button

download data into excel


How to Put Equations into Evernote

How to Put Equations into Evernote

THIS IS AN OUTDATED VERSION OF THE POST. YOU CAN FIND THE UPDATED AND MAINTAINED ONE AT http://www.andreacirillo.com/2014/09/11/equations-in-evernote/ 

If you have to put some math writing into your Evernote notes, and you have a Mac device, there is a very simple way to solve your problem out.
This way is called Grapher, a built-in application for visualising math stuffs.
Here below a simple tutorial:
1. find Grapher among your applications. You can either search for it within Spotlight or using the launchpad.
1equations in evernote
2. write the equation you would like to put into your Evernote note.

2 equations in evernote


3. copy the equation as TIFF
 equations in evernote
4. paste the equation into Evernote

3 equations in evernote

And that’s it!
I think this trick is very useful when you have some “heavy” equations that would not be clear enough if it would just be written in simple text.
Sharing the post on Google + I have received the good advice to use daum equation editor, specifically aimed at writing equations.
I think the Grapher advantage is that is a built-in application, nevertheless, I’m really grateful to Roberta Normano for the tip.
Other tips are welcome!