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

Facebook

Popular Posts

  • More Glass
    Not quite mastered glass yet, but getting there slowly, pretty pleased with this but need to work out how to get it to cast shadows correctl...
  • Basic Photoshoppery
    We had a tutorial on Photoshop today, mostly the basics on how to use the select/lasso/magic wand tool, and move parts of the image around. ...
  • Wake Up Trinity
    For several of the scenes we acted them out prior to shooting so that we could get a good feel for the character and scene, and in this case...
  • Lab Component Modelling
    In order: a book, bunsen burner, burner tripod, and the brain chamber
  • The Iceman Returneth
    So yep, back from iceland now, and will be slowly loading some of the photos from there up to my Flickr For now here's a picture of me ...