Keeping on Track

/
1 Comments

My secret forbidden love of spreadsheets gets an airing now and then, and now is one of those times.

You see that (B5)? That's a countdown timer to assessment that changes colour with conditional formatting depending on how close assessment is getting.

You see those (Row 2)? Those are wieghted percentages of jobs todo/partially done/done, again with conditional formatting for a quick-glance-what-needs-to-be-worked-on cool cat kinda style. With a nice overall Project Complete percentage (B2).

You see all those jobs to do? BOOM! Conditional formatting to separate their individual completeness.

Spreadsheets are wonderful.

 


About Richard Whillock

A beardy bloke who is pleased by the production of puppets and the set-up of stop-motion stuffs. A love for the scruffy, the textured and the original.

You may also like

1 comment:

  1. Georgia8 March 2012 at 18:17

    I am SO impressed! I NEED to learn how to do this.

    ReplyDelete

Blog Archive

Popular Posts

  • Final(?) Animatic
    And here it is with most of the frames improved a little, this could be the final one depending on time, I'm pretty happy with it, even...
  • Sound Project Early Animatic
    Here is a very rough animatic of the sound project, still with a fair few sounds missing, but you can get the general idea of the story and...
  • Suzie Templeton Interview
    A Suzie Templeton interview from Don't Panic Magazine: Your adaptation of Peter and the Wolf won the Oscar for Best Animated Short F...
  • Meet the Preacher
    Remember I was getting Mike to build one of the puppets for me? Well here he is, in all his glory! He's a great little chap, ...
  • Exaggeration Animation
    Here is the final little animation for expressing and exaggerating emotion in a face, I had to slow it down to 8fps as it was whizzing pas...