Weight Tracker and Calorie Analysis

Last updated Feb. 25, 2019, 7:09 p.m. by Author

Tags: nutrition gym health fitness


Attached to this post you will find a spreadsheet that allows you to track your weight on a weekly basis (it is possible to adjust it to a whatever basis, but it is recommended to track your weight on a weekly basis) together with some additional features.

The spreadsheet is provided in two formats - proprietary Excel's .xlsx file and the open source .ods file. Both of them should work fine in MS Excel and LibreOffice Calc.

To start using it, you need to provide it with some basic inputs (light yellow):
- gender
- height in cm
- starting age

Later, you will need to enter three values each week (light yellow):
1. Aim - this is what you want to achieve through your dieting and training. There are three options to choose from: bulking, maintaining and cutting.
2. Activity level - there are five options to choose from. Each one determines your daily caloric needs as a multiple of your Resting Metabolic Rate.
- 1.2 = sedentary (little or no exercise)
- 1.375 = lightly active (light exercise/sports 1–3 days/week)
- 1.55 = moderately active (moderate exercise/sports 3–5 days/week)
- 1.725 = very active (hard exercise/sports 6–7 days a week)
- 1.9 = extra active (very hard exercise/sports and physical job)
3. Weight in kg - your weight.

Other rows are as follow:
1. Date - date of your weight measurement.
2. Age - automatically calculated based on your starting age.
3. Weight in lbs - your weight in pounds, for people not belonging to the metric master race.
4. Macronutritients composition per kg - number of proteins, carbs and fats you need to eat per 1 kg of your mass. It depends on your aim. Cutting requires more protein, bulking allows for more carbs.
5. Daily intake of (in grams) - your required daily intake of proteins, carbs and fats based on your aim and current body mass.
6. Total calories - number of calories you need to eat per day in order to be able to achieve your aim (bulking, maintaining or cutting) and having given body mass.
7. RMR - Resting Metabolic Rate, it is the amount of calories needed to sustain all of your body’s functions while at rest. RMR accounts for approximately 65% of your body’s total calorie consumption, activity burning the remainder.
8. Daily Calorie Expenditure - number of calories you burn given your RMR and activity level.
9. Caloric Surplus/Deficit - your daily caloric surplus or deficit based on your calorie expenditure and calorie intake.
10. Calories from - you daily caloric intake from proteins, carbs and fats.
11. Percent of calories from - percentage split of your proteins, carbs and fats.
12. Target weekly change in weight (in kg) - approximate weekly change in weight you should achieve when pursuing the defined aim.
13. Weekly change in weight (in kg) - actual weekly change in weight you have achieved.
14. Implied weekly caloric surplus/deficit - assuming that the number of kcal it takes to gain or lose 1 kg of body is 7000.

There are also two charts provided: 1. Weight chart - linear chart of your weight in time.
2. Calorie intake chart - a stacked area chart showing the number of calories in a form of proteins, carbs and fats you had to eat each week to achieve desired goal.

To add a new row, just click the "Add New Row" button. Doing this will also update the charts.

Of course everything here is very approximate and will never fully reflect a real life situation and your specific case.

You can also notice, that when you change your activity level to moderately active (moderate exercise/sports 3–5 days/week), your daily calorie expenditure will always be above your total intake. That is the reason of approximation, and bundling data from different sources that are not necessarily compatible with each other. The thing to remember is that when doing frequent training sessions per week or having very long and hard sessions, you need significantly more calories than when your activity level is not very high.

As always, if you do not agree with any of the numbers provided in the attached worksheet or there is something that does not work as intended, please let me know.


Download the attached files

Similar posts:

Book Synopsis: "Why We Sleep" by Matthew Walker

69 comments

Comments:

Comment 1 by Metal Element Factory Nov. 11, 2020, 7:39 p.m.

Metal Element Factory

Comment 2 by File Tray Price Nov. 11, 2020, 11:02 p.m.

File Tray Price

Comment 3 by Glass Display Cabinet Price Nov. 12, 2020, 2:36 a.m.

Glass Display Cabinet Price

Comment 4 by 75m3/H Concrete Batching Plant Nov. 12, 2020, 5:23 a.m.

75m3/H Concrete Batching Plant

Comment 5 by Drag Chain Nov. 12, 2020, 7:01 a.m.

Drag Chain

Comment 6 by China PP Woven Bags Nov. 12, 2020, 7:33 a.m.

China PP Woven Bags

Comment 7 by 100w Fiber Laser Cutting Machine Nov. 12, 2020, 9:44 a.m.

100w Fiber Laser Cutting Machine

Comment 8 by 赌厅网投 Nov. 12, 2020, 3:30 p.m.

欧美牲交AⅤ

Comment 9 by 在线赌场游戏 Nov. 12, 2020, 5:51 p.m.

欧美性爱视频

Comment 10 by Home Brewing Accessories Nov. 12, 2020, 9:11 p.m.

Home Brewing Accessories

Comment 11 by Products Nov. 12, 2020, 11:27 p.m.

Products

Comment 12 by China Antislip Plywood Nov. 13, 2020, 4:05 a.m.

China Antislip Plywood

Comment 13 by nxfozrztsq Nov. 13, 2020, 5:18 a.m.

Weight Tracker and Calorie Analysis [url=http://www.gqr7t9o0qrtw606wt5838882737vfpxss.org/]unxfozrztsq[/url] anxfozrztsq nxfozrztsq http://www.gqr7t9o0qrtw606wt5838882737vfpxss.org/

Comment 14 by Golf Artificial Grass Carpet Supplier Nov. 13, 2020, 5:38 a.m.

Golf Artificial Grass Carpet Supplier

Comment 15 by Bronze Parrot Sculpture Nov. 13, 2020, 7:18 a.m.

Bronze Parrot Sculpture Supplier

Comment 16 by Plastic Nylon Gasket Supplier Nov. 13, 2020, 7:55 a.m.

China Plastic Nylon Gasket

Comment 17 by giannis shoes Nov. 13, 2020, 8:37 a.m.

I needed to compose you this very little note so as to say thanks a lot yet again considering the nice concepts you have discussed on this website. This is surprisingly open-handed with you giving easily exactly what a few people might have offered for sale as an e-book to help with making some bucks for their own end, certainly now that you might have tried it in case you decided. These good tips additionally served to be the great way to realize that the rest have the identical interest just as my personal own to know the truth significantly more regarding this condition. I am sure there are many more enjoyable situations in the future for individuals who looked at your website. giannis shoes [url=http://www.giannisantetokounmposhoes.us]giannis shoes[/url]

Comment 18 by 3 Inch Pool Chlorine Tablets Nov. 13, 2020, 9:33 a.m.

3 Inch Pool Chlorine Tablets Supplier

Comment 19 by Biggest Excavator Nov. 13, 2020, 5:03 p.m.

Biggest Excavator

Comment 20 by Haky Guardrail Frame Nov. 13, 2020, 7:45 p.m.

Haky Guardrail Frame

Comment 21 by Oxford Cloth Computer Bag Nov. 14, 2020, 1:16 a.m.

Oxford Cloth Computer Bag

Comment 22 by Centrifugal Booster Pump Nov. 14, 2020, 1:54 a.m.

Centrifugal Booster Pump

Comment 23 by Heat Resistant Glass Price Nov. 14, 2020, 9:34 a.m.

Heat Resistant Glass Price

Comment 24 by Food Drying Machine Belt Nov. 14, 2020, 7:05 p.m.

Food Drying Machine Belt

Comment 25 by 3d Laser Scanning Services In Chile Nov. 14, 2020, 11:23 p.m.

3d Laser Scanning Services In Chile

Comment 26 by 日本性爱直播 Nov. 15, 2020, 5:20 a.m.

澳门博狗

Comment 27 by 欧美牲交AⅤ Nov. 15, 2020, 7:04 a.m.

快车足彩

Comment 28 by Aluminum Lotion Pump Nov. 15, 2020, 7:51 a.m.

Aluminum Lotion Pump

Comment 29 by Rf Machine Nov. 15, 2020, 9:43 a.m.

Rf Machine

Comment 30 by Designer Cat Eye Sunglasses Nov. 15, 2020, 3:23 p.m.

China Designer Cat Eye Sunglasses

Comment 31 by China Industrial Power Generator Nov. 15, 2020, 7:16 p.m.

China Industrial Power Generator

Comment 32 by China Auto Water Drain Air Compressor Nov. 16, 2020, 1:12 a.m.

China Auto Water Drain Air Compressor

Comment 33 by China China Clay Dinner Set Nov. 16, 2020, 3:17 a.m.

China China Clay Dinner Set

Comment 34 by Engine Air Supply Supplier Nov. 16, 2020, 4 a.m.

Engine Air Supply Supplier

Comment 35 by China fold container house Nov. 16, 2020, 5:28 a.m.

fold container house

Comment 36 by Separate Slip Rings Supplier Nov. 16, 2020, 7:06 a.m.

Separate Slip Rings

Comment 37 by Filling Machine Nov. 16, 2020, 7:40 a.m.

Filling Machine

Comment 38 by Apron Retro Nov. 16, 2020, 9:15 a.m.

Apron Retro

Comment 39 by Over The Shoulder Bags Mens Nov. 16, 2020, 11:46 a.m.

Over The Shoulder Bags Mens

Comment 40 by Disposable Vinyl Gloves Nov. 16, 2020, 1:59 p.m.

Disposable Vinyl Gloves

Comment 41 by jordan shoes Nov. 16, 2020, 5:17 p.m.

I and my guys happened to be digesting the excellent guides located on your web page then all of the sudden developed an awful feeling I never thanked the website owner for those techniques. All the people had been as a result happy to learn them and already have undoubtedly been taking pleasure in them. Thanks for actually being really considerate as well as for having certain perfect issues millions of individuals are really wanting to be aware of. My personal honest apologies for not expressing gratitude to you earlier. jordan shoes [url=http://www.jordan13.us.com]jordan shoes[/url]

Comment 42 by Jewelry Gift Ring Factory Nov. 16, 2020, 5:44 p.m.

Jewelry Gift Ring Factory

Comment 43 by Led Circuit Board Factory Nov. 16, 2020, 9:16 p.m.

Led Circuit Board Factory

Comment 44 by Fuan Lecom Electronic Co., Ltd. Nov. 17, 2020, 1:27 a.m.

Fuan Lecom Electronic Co., Ltd.

Comment 45 by 12v Shut Off Solenoid Valve Nov. 17, 2020, 9:30 a.m.

12v Shut Off Solenoid Valve

Comment 46 by Bathing Suits For Women Nov. 17, 2020, 11:17 a.m.

Bathing Suits For Women

Comment 47 by Acrylic Sheet Laser Cutting Machine Nov. 17, 2020, 1:11 p.m.

Acrylic Sheet Laser Cutting Machine

Comment 48 by Door Handle Stainless Steel Nov. 18, 2020, 1:55 a.m.

Door Handle Stainless Steel

Comment 49 by iso5211 3pc ball vavle Nov. 18, 2020, 3:54 a.m.

iso5211 3pc ball vavle

Comment 50 by china factory Nov. 18, 2020, 5:25 a.m.

china factory

Comment 51 by 12v Impact Wrench Nov. 18, 2020, 7:41 a.m.

China 12v Impact Wrench

Comment 52 by China Diaper Factory In China Nov. 19, 2020, 1:23 a.m.

Diaper Factory In China

Comment 53 by Chinese Design Wallpaper Nov. 19, 2020, 7:12 a.m.

Chinese Design Wallpaper

Comment 54 by curry shoes Nov. 19, 2020, 4:19 p.m.

I would like to express some thanks to the writer for rescuing me from such a condition. Because of scouting throughout the internet and finding tips that were not helpful, I was thinking my entire life was gone. Being alive devoid of the strategies to the issues you have solved all through your main site is a critical case, and those which might have in a negative way affected my career if I had not noticed your website. Your personal knowledge and kindness in handling everything was very useful. I am not sure what I would have done if I hadn't come upon such a step like this. I can at this point look ahead to my future. Thanks so much for the reliable and sensible help. I will not be reluctant to recommend your blog post to anyone who will need support about this problem. curry shoes [url=http://www.curry6shoes.us]curry shoes[/url]

Comment 55 by Featured Nov. 19, 2020, 11:52 p.m.

Featured

Comment 56 by High Performance Solar Panel Nov. 20, 2020, 11:55 a.m.

High Performance Solar Panel

Comment 57 by Crusher Machine Manufacturers Nov. 21, 2020, 3:13 a.m.

Crusher Machine Manufacturers

Comment 58 by Clevis Grab Bend Hook Nov. 22, 2020, 7:27 a.m.

Clevis Grab Bend Hook

Comment 59 by irving shoes Nov. 22, 2020, 8:36 p.m.

I wish to show some appreciation to the writer just for bailing me out of such a setting. Because of checking through the world-wide-web and seeing recommendations that were not pleasant, I was thinking my entire life was over. Being alive minus the solutions to the problems you have fixed all through your good posting is a critical case, and those that might have in a negative way damaged my career if I had not noticed your blog post. Your ability and kindness in playing with a lot of stuff was tremendous. I don't know what I would have done if I hadn't come across such a thing like this. It's possible to now look forward to my future. Thanks for your time so much for this high quality and amazing help. I will not think twice to propose the website to anyone who should have guide about this subject matter. irving shoes [url=http://www.kyrieirving-shoes.us.com]irving shoes[/url]

Comment 60 by kyrie 4 Nov. 22, 2020, 8:36 p.m.

I definitely wanted to write down a simple comment to thank you for these fabulous techniques you are writing at this website. My prolonged internet investigation has at the end been paid with pleasant points to go over with my guests. I 'd state that that we visitors are extremely blessed to dwell in a remarkable community with very many outstanding people with very beneficial concepts. I feel very lucky to have discovered the webpage and look forward to tons of more enjoyable times reading here. Thanks once more for all the details. kyrie 4 [url=http://www.kyrie4shoes.us]kyrie 4[/url]

Comment 61 by jordan shoes Nov. 22, 2020, 8:36 p.m.

I have to express appreciation to you just for bailing me out of this particular predicament. Because of surfing throughout the online world and obtaining things which were not powerful, I thought my life was done. Being alive without the answers to the difficulties you have fixed by way of your entire short article is a critical case, and those which might have adversely affected my entire career if I hadn't discovered your blog. Your actual competence and kindness in touching all things was useful. I am not sure what I would have done if I had not come across such a subject like this. It's possible to now look ahead to my future. Thanks for your time so much for the reliable and result oriented help. I won't be reluctant to propose the blog to any person who ought to have guide about this problem. jordan shoes [url=http://www.jordansshoes.us.org]jordan shoes[/url]

Comment 62 by curry shoes Nov. 22, 2020, 8:36 p.m.

I as well as my friends happened to be reviewing the excellent information and facts from your web page and so at once developed a terrible suspicion I never expressed respect to the site owner for those strategies. Those young men happened to be for this reason joyful to study all of them and have clearly been enjoying these things. Thank you for simply being very accommodating as well as for figuring out this sort of wonderful subjects most people are really needing to discover. My very own sincere apologies for not expressing appreciation to you earlier. curry shoes [url=http://www.curryshoes.net]curry shoes[/url]

Comment 63 by adidas yeezy boost 350 v2 Nov. 22, 2020, 8:36 p.m.

My husband and i felt absolutely contented that John managed to finish up his studies from your precious recommendations he was given through your site. It is now and again perplexing to simply be giving away key points which often others have been trying to sell. We really do know we now have the website owner to give thanks to because of that. The explanations you've made, the straightforward blog navigation, the friendships you help to instill - it's many astounding, and it is letting our son in addition to our family believe that the idea is entertaining, and that's quite indispensable. Many thanks for everything! adidas yeezy boost 350 v2 [url=http://www.yeezy-v2.com]adidas yeezy boost 350 v2[/url]

Comment 64 by longchamp Nov. 22, 2020, 8:36 p.m.

Thank you for your entire hard work on this blog. Betty takes pleasure in working on investigations and it's obvious why. My spouse and i notice all concerning the dynamic form you offer powerful tactics by means of your web site and therefore inspire participation from other individuals on that concept while my princess is actually starting to learn a whole lot. Take advantage of the remaining portion of the year. You have been conducting a powerful job. longchamp [url=http://www.longchamphandbagsus.com]longchamp[/url]

Comment 65 by kevin durant shoes Nov. 22, 2020, 8:37 p.m.

I simply desired to thank you very much yet again. I am not sure the things that I would have created without these methods revealed by you about this question. Certainly was a real frightening difficulty in my opinion, however , taking note of the specialised way you treated the issue made me to leap over delight. I'm thankful for your guidance and even wish you comprehend what a powerful job you're doing teaching people through your web site. I am certain you haven't got to know all of us. kevin durant shoes [url=http://www.kevindurant-shoes.us.com]kevin durant shoes[/url]

Comment 66 by jordan shoes Nov. 22, 2020, 8:37 p.m.

I not to mention my pals appeared to be viewing the excellent procedures found on your web page and then immediately I had an awful suspicion I never thanked the web site owner for those strategies. All of the men came so warmed to read all of them and have without a doubt been taking advantage of them. Thanks for simply being very helpful and then for opting for these kinds of perfect useful guides most people are really wanting to know about. My personal sincere apologies for not expressing appreciation to earlier. jordan shoes [url=http://www.jordan11retro.us.com]jordan shoes[/url]

Comment 67 by -temperature Silicone Strip Nov. 22, 2020, 9:47 p.m.

-temperature Silicone Strip

Comment 68 by 11.1v 3s 22000mah Lipo Battery Pack 25c Nov. 23, 2020, 7:35 a.m.

11.1v 3s 22000mah Lipo Battery Pack 25c

Comment 69 by 3*4 Metal Keypad Nov. 23, 2020, 9:06 p.m.

3*4 Metal Keypad

Add a new comment