It has been a while since I have proposed “tweetboards” an option for people making dashboards. I have received two very good examples of the dynamic (automatically updating) tweetboard implementations from our readers.
1. The first example from Fernando
I must appreciate Fernando for sending this beautifully implemented tweetboard. Not only that, he took great troubles to change the formulas so that the dashboard would work in my version of Excel (he prepared it in Portuguese version where the formulas are named differently, so when I open it in my comp, the formulas would show #NAME! error)
Thank you Fernando 🙂
Download the tweetboard implementation example 1 and see it yourself.
2. The second example from Lee
Lee has combined traditional dashboard charts with descriptive text message idea from tweetboard to create this neat claims dashboard. It is very well implemented.
Thank you Lee 🙂
Download the tweetboard implementation example 2 and see it for yourself.
If you want to share your tweetboard implementations
Please drop a comment or tweet me at @r1c1 or email me at chandooDOTd @ gmail.com
If you are wondering what the hell tweetboards are…
Read this post.
Also, read our 6 part tutorial on preparing KPI dashboards in Excel.
4 Responses to “Office 2010 Contest Winners are here!!!”
I while ago I wrote a post on selecting a couple of names from a range via an UDF
I could have been handy.... especially because I didn't win.... lol
http://xlns.lamkamp.nl/?p=14
Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!
Sincerely,
Tom "this one" 🙂
Thank You... Thank You... Thank You... 🙂
Hi,
Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.
Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂