Saturday, August 15, 2020

A Clever Use of Google Spreadsheets as a Kitchen Log

Must Read

How to Download Instagram Reels Video and Share with Others

Are you looking to know how you can download the Instagram Reels videos locally on your mobile phone and...

How to Use MacBook for More than 5 years Without any Issues

After being a Windows PC user from a decade and a half, I finally made a switch to Mac...

How to Get A 4K Display Work at 60Hz with your MacBook?

If you are using a MacBook computer you might be aware of their terms of display resolutions. They simplify...
Asif Ahmed
Asif Ahmedhttp://techtippr.com
Founder and Cheif Editor of Techtippr, Get in touch with me on Twitter or Enjoy my Stories on Instagram. I think they are interesting. :-)

I’m a lazy person, and that’s why I am always looking for the easiest way to do something. I spend plenty of time to look for tiny gadgets that can save a few minutes of my everyday time.

I’ve done it well so far and I’ve even made my wife’s life easy with the help of a simple Google Spreadsheet.

What the Spreadsheet actually does?


I know it’s not rocket science but when I showed it to my wife, she was impressed, which is a rare event, especially when I am involved.

Prior to this, she used to keep a log of the Milk Delivered to our home. The Milkman delivers 3ltrs of milk every day, sometimes it’s 2.5ltrs and some days it’s just 2ltrs and some days he doesn’t show up.

So, she used a Table Calander to mark the dates with how much milk has been delivered. And at the end of every month, she sat down to calculate the bill.

This is how the Spreadsheet looks.

I installed the Google Spreadsheet app on her Android phone, (iOS | Android) created a new Spreadsheet and shared with me as well (so that I too can fill it). I put some formulas that that will automatically calculate the number of liters of milk delivered throughout the month.

This number was also multiplied by the fixed number (price of 1-liter milk) giving the total bill amount.

So, all she has to do now is put the number of liters of milk delivered every day. The column even changes to Red when it’s not delivered.

Not a revolutionary thing to do, but saves a few minutes every month.

It’s just one example how cool Google Spreadsheets are, you can put it to a good use, all you need is to think how to make use of it for your problem.

I’ve created a template in case you want to use it. Make sure you change it according to your needs, e.g, the price of Milk (or anything else you want to keep a log for)

Use the template

Freshly Published

How to Download Instagram Reels Video and Share with Others

Are you looking to know how you can download the Instagram Reels videos locally on your mobile phone and...

How to Use MacBook for More than 5 years Without any Issues

After being a Windows PC user from a decade and a half, I finally made a switch to Mac in 2015. I still have...

How to Get A 4K Display Work at 60Hz with your MacBook?

If you are using a MacBook computer you might be aware of their terms of display resolutions. They simplify it by giving you a...

How to Setup and Use Canned Response in Gmail

If you are a blogger, or an influencer, or anyone who uses their Gmail account extensively to reply to a lot of emails regularly,...

How to Control Your TV Using Your Smartphone

If you've got a smart TV or maybe you have converted your regular TV into a smart TV, and for some reason, the remote...

More Articles Like This