.cool.

Make a family dashboard

May 16, 2021

In my family there are a lot of people and a lot of information that needs to be shared. Between the adults that’s easy since we both have smartphones. With the kids, not so easy – they don’t have smartphones or smart devices, and even if they did they wouldn’t have 24x7 access to them. So, I decided to make a family dashboard. All the dashboard is, is a google sheet displayed on an old monitor. It’s powered by a 10-year-old laptop but you could use a raspberry pi or something else.

What does everyone need to know? AKA The FAQ

What does everyone need to know? Or, what questions am I tired of answering all the time?

Template for you to copy

Check out this Google Sheet: Here is my dashboard template you can use!

screenshot

Why Google Sheets? Because everyone knows how to use it. That’s it.

Enhance - beyond Google Sheets

My goal was to “ship” as quickly as possible. After all, the ultimate requirement here is to get household members the information they need ASAP. And, since our house is small enough that we only need one dashboard, I didn’t care about scalability. So some things I added beyond the spreadsheet:

How does it get pulled all together? It’s literally three Firefox windows with tab auto refresh add-on configured.

This is how the final product looks:

dashboard photo

I am so cool.