Year average

Track your health in Excel

Do you sometimes feel that you have not been sleeping well for a while? Or stress through work? Then it is good to keep for a while: how much you sleep, what you eat and drink, how much you work. For this I have made an easy Excel system that you can fill in every day and then automatically displays graphs of your patterns. This allows you or your doctor to see if something needs to be changed in your patterns of sleep or work. The health monitor can be downloaded here (Dutch version).

Months

The Excel system consists of 15 tabs. One for each month of the year and two with data per year and a tab with explanations.

Memo tab

Memo

The Memo tab contains comments about the use of the Excel system. For example, there are definitions for day and night, standing and computer work. Explanation for the various tabs. Here you do not have to fill in anything, just read it correctly.

Tab Months

Tab month

You enter the data in the Months tabs. This way you enter how many hours you slept, how many times you were awake, etc. These are immediately visible in the graphs above. If you fill in the whole month you can see at the end of the month a pattern of the amount of hours you have slept, worked, etc. At the end in column AG you can see average working hours and sleeping hours, etc for that month. In column AH the total is added together.

This way you get a nice overview for the months per tab and you only have to enter the numbers at the right date.

Year Totals

Year totals

You do not have to do anything yourself on the Year totals tab. As soon as you enter something in the Tabs of the months, this is included in the calculations on this page and also in the graphs. This gives you a good overview of how your sleep rhythm was in a year, how much you worked, etc. In the table you can read the total per month, just like in the graphs.

Year average

Year average

Also on the tab Year average you do not have to do anything and everything is automatically calculated for you and displayed in the graphs. On this tab you see How you have done on average per month in terms of hours of sleep, lying awake, etc. Here you can compare the months with each other and perhaps discover patterns.

Get started! Let me know if you find it useful or if you have any questions via gmcapella[@]yahoo.com. If you want to read more about Excel, read my other blogs about Excel. Or feel free to dowload another Excel template to use. You can upgrade your Excel skills with one of my Excel courses.

Blog Life

Varied vegetarian food

I have been eating less meat for a long time, but didn't no how to vary with vegetarian food.  I've...
Read More
Varied vegetarian food
Blog entrepreneur Hiking Investing Life

2nd quarter and charity 3rd quarter turnover

Business is starting to pick up again in terms of work. The second quarter turnover was better than the first,...
Read More
2nd quarter and charity 3rd quarter turnover
Blog

hip, Instagram cooking class

I had the taste of taking Instagram courses after the travel writing course and finance course. So when the opportunity...
Read More
hip, Instagram cooking class
Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
Blog Curacao entrepreneur

1st quarter 2020

1st quarter 2020 The first quarter of 2020 started with me as a digital nomad working on Curaçao. That means...
Read More
1st quarter 2020
Blog Hiking Travel

7 things I would like to do in Spain

I have been to Spain before and every time I discover new things that I would like to do. That's...
Read More
2 Replies
7 things I would like to do in Spain
Blog Hiking Life

The 5 types of hikers

In my opinion there are 5 types of hikers among the hikers. I would like to share with you those...
Read More
The 5 types of hikers
Blog Life Travel

5 reasons to live in southern Spain in winter

My dream is to escape the winter. I did that all winter in 2013/2014 by going to Australia and New...
Read More
5 reasons to live in southern Spain in winter
Blog Hiking Travel

7 reasons to walk a 4 Days hike

  While walking my 2nd Four Days Marche I have thought of 7 reasons why you should walk a 4...
Read More
7 reasons to walk a 4 Days hike
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}
Sharing is appreciated

Leave a Reply

Your email address will not be published. Required fields are marked *