Thursday, December 3, 2020

A Clever Use of Google Spreadsheets as a Kitchen Log

Must Read

FitKit FT200 Series Treadmill Review – Budget Treadmill for Home Workout

So the only activity during this lockdown is by walking from one room to another. I started the year...

GetInsta: Get free Instagram followers in a simple way

In times of pandemic, we have seen a significant increase in eCommerce all over the world, expanding the numbers...

How to Open Desktop version of Google Chrome on iPad

With more than 30% of the market share in the Global Tablet PC shipments in 2020, Apple is again...
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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

12 + 18 =

Freshly Published

FitKit FT200 Series Treadmill Review – Budget Treadmill for Home Workout

So the only activity during this lockdown is by walking from one room to another. I started the year...

GetInsta: Get free Instagram followers in a simple way

In times of pandemic, we have seen a significant increase in eCommerce all over the world, expanding the numbers of electronic commerce and commerce...

How to Open Desktop version of Google Chrome on iPad

With more than 30% of the market share in the Global Tablet PC shipments in 2020, Apple is again on the top for their...

Want to Use Your Mobile for Creating Videos? This Guide Should Be Helpful

Smartphones take away a lot of limitations creative filmmakers can find themselves in. From shooting videos in too crowded situations to putting the camera...

How to Fix Glitch / Corrupted Video After Exported from Final Cut Pro?

I have been using Final Cut Pro for editing my videos since 2016. Before that, I was using Vegas Pro. And I was using...

More Articles Like This