Creating a Memento Mori Dashboard with Google Sheets: A Step-by-Step Guide

Creating a Memento Mori Dashboard with Google Sheets: A Step-by-Step Guide

In this video, we start with a blank slate and build a unique Memento Mori dashboard using Google Sheets. The concept is inspired by the idea of visualizing how many days one has left to live, serving as a motivational tool. Watch as we walk through the entire process, from gathering initial data to finalizing the design. You'll see the decisions made along the way, including data calculations, design choices, and thematic elements. By the end, we'll have a fully functional dashboard that updates daily, showing the days and weeks left to live based on life expectancy. Join us for a deep dive into spreadsheet creation and design!

00:00 Introduction and Concept Overview
02:25 Setting Up the Data
03:40 Calculating Life Expectancy
08:10 Designing the Dashboard
13:14 Choosing Fonts and Styles
15:42 Adding Interactive Elements
16:23 Creating Button Styles
16:50 Customizing the Grid
18:15 Calculating Days and Weeks Left
19:45 Visualizing with an Hourglass
22:27 Enhancing the Hourglass Design
26:30 Final Touches and Reflections
32:22 Conclusion and Next Steps

In this tutorial I go from raw data to a full formed dashboard. In this particular case we're looking at the number of weeks someone might have left to live. A bit of stoic motivation, part baroque style. You'll see how I look for inspiration in the Memento Mori medallion and also in images representative of "Memento Mori" then I use those colors in the images to make this dashboard.

In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.

🕰️ Time Saving Tips, Tricks and Techniques

🤖 Add AI to Your Sheets

🚀 Tools and Templates For YOU:

Generate Google Sheets Formulas:

100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.

Tiny Sheets - Easily delete unnecessary rows and columns

Sheet Styles - Change your spreadsheets style to match your mood.

Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.

Generate REGEXMATCH formulas to clean data

Generate SPARKLINE formulas to make cool charts inside of cells.

😎 Most Popular Tips and Tricks

Extract Urls from Google Sheets

⚙️Automate Your Sheets:

Spreadsheet Automation 101, get started making your sheets work for you, while you sleep

Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!

📺Step-by-Step Tutorials

Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.