I am currently doing a side project to build a Issue tracking/Dash board for our application. Current sheet we have is really dumb and needs to be updated manually all over the place and with mistakes. I have done a few other sheets with Google scripts. It’s really cool.
While researching on a good template to start with (really more for ideas), I stumbled on this post. It’s a nice use of a spreadsheet to show patient time tracking, visually with nice colors.
While I was generally impressed with the think-outside-the-box idea, I was completely taken aback, when I saw it was developed by an MD – that’s right folks, a medical doctor. Puts a lot of IT folks to shame!! Simply wow!
This solution uses Google Docs, so it’s free and easy to customize