Posted on / in Uncategorised, VFX

Working efficiently: using spreadsheets

format

One of the most important part of working efficiently is keeping a track of your tasks and assignments. I try to provide myself with as much as visual information as possible by organising my tasks in a colour coded way so by a quick glance I can see what shot is reaching it’s deadline and needs more attention. Using Google spreadsheet makes really easy to create interactive tables and keeping everything organized.

I’m going to share a few tips today about how to setup an interactive block that shows the remaining dates and changes the colour based on that.

Let’s say the deadline for Shot A is 15th of March. First step is creating a data format that can be used for further referencing. To display the date use this format:

=DATE(2014;3;15)

Now we can use the following line to extract the remaining days from our date;

=MINUS(B2,TODAY())

It will be easier to colour code the remaining days block so when it’s reaching the deadline it automatically turns red. To do that go to Format>Conditional Formatting and set a condition.

format

ok seems we have plenty time left and everything is still green! you can go home early tonight!

shhet2

Leave a Reply