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

  • 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...
  • The End of University
    Wrapping up my final week at University, I finished with a satisfying First Class Honours, which has made the work seem worthwhile. ...
  • Presentation Slide
  • Alginate Experiment #2
    Back to the alginate and a little more planning with this one. Firstly a made a nice little Sculpey head with no mouth for a replacement fa...
  • Karina's Project (Planning)
    Dividing up the scenes: Claire  - Bird flying (front)  - Bird flying (side) Gareth  - Clock (still)  - Feeding Me  - Clock (anima...