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

124 comments

Comments:

Comment 1 by Bamboo Vegetable Cutting Board Oct. 17, 2020, 5:12 p.m.

Bamboo Vegetable Cutting Board

Comment 2 by Carboxyl Methyl Cellulose Ceramic Oct. 17, 2020, 7:03 p.m.

Carboxyl Methyl Cellulose Ceramic

Comment 3 by China Wheelchair Oct. 17, 2020, 7:47 p.m.

China Wheelchair

Comment 4 by 50m3/H Cement Mixing Plant Oct. 17, 2020, 11:10 p.m.

50m3/H Cement Mixing Plant

Comment 5 by 17 key kalimba sheet music Oct. 18, 2020, 1:10 a.m.

17 key kalimba sheet music

Comment 6 by Black Tile Italian Marble Oct. 18, 2020, 1:59 a.m.

Black Tile Italian Marble

Comment 7 by Acid-Resisting Apron Oct. 18, 2020, 3:23 a.m.

Acid-Resisting Apron

Comment 8 by 12 Gauge Pvc Coated Wire Oct. 18, 2020, 3:49 a.m.

12 Gauge Pvc Coated Wire

Comment 9 by longchamp handbags Oct. 18, 2020, 3:55 a.m.

I was very pleased to find this web-site.I wanted to thanks to your time for this excellent learn!! I undoubtedly enjoying every little little bit of it and I have you bookmarked to check out new stuff you blog post. [url=http://www.longchampshandbags.us]longchamp handbags[/url]

Comment 10 by 250ml glass bottle Oct. 18, 2020, 9:05 a.m.

250ml glass bottle

Comment 11 by Big Laser Engraving Machine Oct. 18, 2020, 9:32 a.m.

Big Laser Engraving Machine

Comment 12 by 2 24vdc - Solid State Relay Oct. 18, 2020, 11 a.m.

2 24vdc - Solid State Relay

Comment 13 by Biodegradable Candy Boxes Oct. 18, 2020, 5:53 p.m.

Biodegradable Candy Boxes

Comment 14 by Digital Weighing Scale Oct. 18, 2020, 7:41 p.m.

Digital Weighing Scale

Comment 15 by 3mm Lvt Vinyl Plank Flooring Oct. 18, 2020, 9:31 p.m.

3mm Lvt Vinyl Plank Flooring

Comment 16 by Tank Products Oct. 18, 2020, 11:17 p.m.

Tank Products

Comment 17 by Cheap Price Door Frame Metal Detector Oct. 19, 2020, 3:18 a.m.

Cheap Price Door Frame Metal Detector

Comment 18 by 7.1 Sound Gaming Headphone Oct. 19, 2020, 3:36 a.m.

7.1 Sound Gaming Headphone

Comment 19 by Boiler Feed Water Supply Pump Oct. 19, 2020, 5:29 a.m.

Boiler Feed Water Supply Pump

Comment 20 by golden goose sale Oct. 19, 2020, 6:56 a.m.

Thank you for your whole effort on this blog. My aunt really likes setting aside time for investigations and it is obvious why. We hear all regarding the powerful method you present very important secrets through your web blog and in addition invigorate contribution from other ones on that concept and our daughter is truly understanding so much. Take pleasure in the remaining portion of the new year. You're doing a splendid job. golden goose sale [url=http://www.goldengoosessale.com]golden goose sale[/url]

Comment 21 by Dc Motor Rotor Oct. 19, 2020, 7:21 a.m.

Dc Motor Rotor

Comment 22 by Dewatering Sieve Oct. 19, 2020, 7:39 a.m.

Dewatering Sieve

Comment 23 by Architectural Linear Lighting Oct. 19, 2020, 7:57 a.m.

Architectural Linear Lighting

Comment 24 by Accessories Oct. 19, 2020, 9:14 a.m.

Accessories

Comment 25 by Brass Cnc Machining Oct. 19, 2020, 9:32 a.m.

Brass Cnc Machining

Comment 26 by 1 Ton Mechanical Pulling Chain Hoist Oct. 19, 2020, 11:15 a.m.

1 Ton Mechanical Pulling Chain Hoist

Comment 27 by 5v Usb Power Bank Heated Vest Oct. 19, 2020, 1:16 p.m.

5v Usb Power Bank Heated Vest

Comment 28 by Aromatherapy Bottle Oct. 19, 2020, 3:01 p.m.

Aromatherapy Bottle

Comment 29 by Bread Sealing Machine Oct. 19, 2020, 4 p.m.

Bread Sealing Machine

Comment 30 by 75m3 Concrete Mixing Plant Oct. 19, 2020, 5:54 p.m.

75m3 Concrete Mixing Plant

Comment 31 by Bag making & packing machine Oct. 19, 2020, 7:49 p.m.

Bag making & packing machine

Comment 32 by Guide Seal Oct. 19, 2020, 9:44 p.m.

Guide Seal

Comment 33 by Eddy Current Metal Separator Oct. 20, 2020, 1:51 a.m.

Eddy Current Metal Separator

Comment 34 by Click Spc Flooring Oct. 20, 2020, 3:12 a.m.

Click Spc Flooring

Comment 35 by Metallization base film Oct. 20, 2020, 5:23 a.m.

Metallization base film

Comment 36 by 2016 New Arrival Gaming Cabinet Oct. 20, 2020, 5:55 a.m.

2016 New Arrival Gaming Cabinet

Comment 37 by vrwwzttwx Oct. 20, 2020, 7:07 a.m.

Weight Tracker and Calorie Analysis avrwwzttwx vrwwzttwx http://www.gcc35x9t3660yy5201u45oy605tilaxls.org/ [url=http://www.gcc35x9t3660yy5201u45oy605tilaxls.org/]uvrwwzttwx[/url]

Comment 38 by 0.6m 2tube T8 Fixture Oct. 20, 2020, 9:08 a.m.

0.6m 2tube T8 Fixture

Comment 39 by Jacquard Textile Machines Factory Oct. 20, 2020, 9:37 a.m.

Jacquard Textile Machines Factory

Comment 40 by Medical Unit Factory Oct. 20, 2020, 11:09 a.m.

Medical Unit Factory

Comment 41 by Oil Tube Factory Oct. 20, 2020, 11:49 a.m.

Oil Tube Factory

Comment 42 by Gps Pda Price Oct. 20, 2020, 1:42 p.m.

Gps Pda Price

Comment 43 by Green Vegetables Oct. 20, 2020, 5:03 p.m.

Green Vegetables

Comment 44 by Fish Sorting Machine Oct. 20, 2020, 11:54 p.m.

Fish Sorting Machine

Comment 45 by 2000l Planetary Mixer Oct. 21, 2020, 1:17 a.m.

2000l Planetary Mixer

Comment 46 by Carbide Cnc Drill Bit Oct. 21, 2020, 3:36 a.m.

Carbide Cnc Drill Bit

Comment 47 by Fiber Laser Cutting Machine For Metal Oct. 21, 2020, 3:58 a.m.

Fiber Laser Cutting Machine For Metal

Comment 48 by Industrial Water Factory Oct. 21, 2020, 5:27 a.m.

Industrial Water Factory

Comment 49 by Glass Spice Bottle Price Oct. 21, 2020, 9:03 a.m.

Glass Spice Bottle Price

Comment 50 by jordan 13 Oct. 21, 2020, 2:47 p.m.

My spouse and i ended up being thankful Chris could finish off his investigation by way of the precious recommendations he discovered using your site. It is now and again perplexing to simply be giving for free ideas which the rest have been selling. And we all do understand we now have the blog owner to give thanks to for that. Those explanations you made, the straightforward web site navigation, the relationships you can give support to engender - it's mostly exceptional, and it's really leading our son in addition to the family understand this subject matter is fun, which is certainly pretty indispensable. Thanks for the whole lot! jordan 13 [url=http://www.jordan13.us.com]jordan 13[/url]

Comment 51 by Bushings Oct. 21, 2020, 5:03 p.m.

Bushings

Comment 52 by Barbed Rod For Pe Pipe Oct. 21, 2020, 11:33 p.m.

Barbed Rod For Pe Pipe

Comment 53 by Magnesium Carbonate Price Oct. 22, 2020, 3:23 a.m.

Magnesium Carbonate Price

Comment 54 by Flexible Rubber Pipe Price Oct. 22, 2020, 5:12 a.m.

Flexible Rubber Pipe Price

Comment 55 by Hont Electrical Co., Ltd. Oct. 22, 2020, 7:08 a.m.

Hont Electrical Co., Ltd.

Comment 56 by Hair Straightener Oct. 22, 2020, 7:34 a.m.

Hair Straightener

Comment 57 by Hydraulic Block Price Oct. 22, 2020, 9:02 a.m.

Hydraulic Block Price

Comment 58 by 3 Ply Face Mask With Ear Loops Oct. 22, 2020, 1:46 p.m.

3 Ply Face Mask With Ear Loops

Comment 59 by Apet Oct. 22, 2020, 5:11 p.m.

Apet

Comment 60 by Featured Products Oct. 22, 2020, 7:22 p.m.

Featured Products

Comment 61 by Fabric Laser Cutter For Sale Oct. 22, 2020, 9:29 p.m.

Fabric Laser Cutter For Sale

Comment 62 by Marble Stone Fountain Price Oct. 23, 2020, 1:09 a.m.

Marble Stone Fountain Price

Comment 63 by New Mobile Phone Oct. 23, 2020, 1:35 a.m.

New Mobile Phone

Comment 64 by Glass Pad Oct. 23, 2020, 3 a.m.

Glass Pad

Comment 65 by Induction Price Oct. 23, 2020, 7:02 a.m.

Induction Price

Comment 66 by Cast Iron Electrode Oct. 23, 2020, 9:34 a.m.

Cast Iron Electrode

Comment 67 by Equal Leg Angles Oct. 23, 2020, 5:46 p.m.

Equal Leg Angles

Comment 68 by Bermad Solenoid Valve Oct. 23, 2020, 9:07 p.m.

Bermad Solenoid Valve

Comment 69 by Dessert Plates Oct. 23, 2020, 11:25 p.m.

Dessert Plates

Comment 70 by kobe basketball shoes Oct. 23, 2020, 11:31 p.m.

I'm just writing to make you be aware of of the brilliant experience my wife's princess found reading your web site. She realized lots of details, not to mention what it is like to have a marvelous giving mindset to have other individuals clearly fully grasp specific complex subject matter. You really exceeded her expected results. Many thanks for offering these helpful, trusted, informative and in addition fun tips about the topic to Emily. kobe basketball shoes [url=http://www.kobebasketballshoes.net]kobe basketball shoes[/url]

Comment 71 by Inverter Transformer Factory Oct. 24, 2020, 1:13 a.m.

Inverter Transformer Factory

Comment 72 by Medical Lab Factory Oct. 24, 2020, 1:48 a.m.

Medical Lab Factory

Comment 73 by Healthy Beverage Oct. 24, 2020, 7:42 a.m.

Healthy Beverage

Comment 74 by 2 In 1 Zipper Cable Oct. 24, 2020, 9:58 a.m.

2 In 1 Zipper Cable

Comment 75 by Face Protective Masks Oct. 24, 2020, 1:49 p.m.

Face Protective Masks

Comment 76 by 10kw Home Solar Power System Oct. 24, 2020, 5:18 p.m.

10kw Home Solar Power System

Comment 77 by 5 Axis Cnc Milling Oct. 24, 2020, 7:36 p.m.

5 Axis Cnc Milling

Comment 78 by Other Oct. 24, 2020, 11:01 p.m.

Other

Comment 79 by Bottle Reed Diffuser With Box Oct. 25, 2020, 5:04 a.m.

Bottle Reed Diffuser With Box

Comment 80 by Logo Patch Oct. 25, 2020, 11:13 a.m.

Logo Patch

Comment 81 by Glass Ceramic Heater Price Oct. 25, 2020, 7:10 p.m.

Glass Ceramic Heater Price

Comment 82 by HongKong RMT Electronics Co., Ltd. Oct. 25, 2020, 9:30 p.m.

HongKong RMT Electronics Co., Ltd.

Comment 83 by Hammer Machine Price Oct. 25, 2020, 11:36 p.m.

Hammer Machine Price

Comment 84 by Automatic X Ray Machine Oct. 26, 2020, 1:41 a.m.

Automatic X Ray Machine

Comment 85 by Evaporation Oct. 26, 2020, 3:42 a.m.

Evaporation

Comment 86 by Wheels Oct. 26, 2020, 7:25 a.m.

Wheels

Comment 87 by 欧美av无码高清 Oct. 26, 2020, 8 a.m.

澳门博狗

Comment 88 by Blue Chef Apron Oct. 26, 2020, 11:11 a.m.

Blue Chef Apron

Comment 89 by Black Extractor Hood Oct. 26, 2020, 11:53 a.m.

Black Extractor Hood

Comment 90 by golden goose Oct. 26, 2020, 8:50 p.m.

I am just writing to make you be aware of what a useful discovery my cousin's princess went through viewing your blog. She even learned such a lot of details, which include how it is like to have an incredible teaching nature to have the rest easily have an understanding of selected tricky subject areas. You undoubtedly exceeded people's desires. Many thanks for producing those practical, dependable, informative as well as easy guidance on your topic to Gloria. golden goose [url=http://www.goldengoosesneakers.us]golden goose[/url]

Comment 91 by Micro Sprayer Oct. 27, 2020, 1:14 a.m.

Micro Sprayer

Comment 92 by Gasoline Garden Tool Oct. 27, 2020, 3:16 a.m.

Gasoline Garden Tool

Comment 93 by High Speed Wire Oct. 27, 2020, 3:45 a.m.

High Speed Wire

Comment 94 by Hunan Lang Le Technology Co., Ltd. Oct. 27, 2020, 5:56 a.m.

Hunan Lang Le Technology Co., Ltd.

Comment 95 by 1 Cross Quay Nelson Oct. 27, 2020, 9:08 a.m.

1 Cross Quay Nelson

Comment 96 by Disposable Kids Medical Face Mask Oct. 27, 2020, 11:27 a.m.

Disposable Kids Medical Face Mask

Comment 97 by 200 Watt Led High Bay Light Oct. 27, 2020, 1:29 p.m.

200 Watt Led High Bay Light

Comment 98 by Black Trench Coat Oct. 28, 2020, 1:11 a.m.

Black Trench Coat

Comment 99 by Black Stainless Steel Cooktop Oct. 28, 2020, 1:44 a.m.

Black Stainless Steel Cooktop

Comment 100 by Scrap PPGI Coil Steel Oct. 28, 2020, 3:13 a.m.

Scrap PPGI Coil Steel

Comment 101 by Linhai Yinglong Import & Export Co., Ltd. Oct. 28, 2020, 5:52 a.m.

Linhai Yinglong Import & Export Co., Ltd.

Comment 102 by Girl Wear Price Oct. 28, 2020, 9:35 a.m.

Girl Wear Price

Comment 103 by Automatic Jeans Button Attaching Machine Oct. 28, 2020, 7:45 p.m.

Automatic Jeans Button Attaching Machine

Comment 104 by 10 Kw Solar Panel Oct. 28, 2020, 11:58 p.m.

10 Kw Solar Panel

Comment 105 by 5.5hp Lifan Reversible Plate Compactor Oct. 29, 2020, 1:32 a.m.

5.5hp Lifan Reversible Plate Compactor

Comment 106 by Best Quality Marble Oct. 29, 2020, 3:04 a.m.

Best Quality Marble

Comment 107 by Atc Cnc Router Oct. 29, 2020, 3:37 a.m.

Atc Cnc Router

Comment 108 by 6-Layer Pcb Oct. 29, 2020, 5:50 a.m.

6-Layer Pcb

Comment 109 by 3-Layer Medical Used Face Mask Oct. 29, 2020, 7:26 a.m.

3-Layer Medical Used Face Mask

Comment 110 by 5 Inch Hose Clamp Oct. 29, 2020, 9:03 a.m.

5 Inch Hose Clamp

Comment 111 by Vertical Axial Pump Oct. 29, 2020, 11:28 a.m.

Vertical Axial Pump

Comment 112 by Measuring Meter Factory Oct. 29, 2020, 5:21 p.m.

Measuring Meter Factory

Comment 113 by curry shoes Oct. 29, 2020, 7:37 p.m.

I'm also writing to let you be aware of what a magnificent experience my wife's child developed viewing your site. She came to find such a lot of things, most notably what it's like to have an excellent teaching heart to let folks easily fully grasp chosen complicated topics. You really did more than her desires. Thank you for distributing these warm and friendly, dependable, edifying and unique tips about the topic to Tanya. curry shoes [url=http://www.curry7shoes.us]curry shoes[/url]

Comment 114 by Oil Pressure Gauge Oct. 29, 2020, 7:55 p.m.

Oil Pressure Gauge

Comment 115 by FVB Hardware Co., Ltd. Oct. 30, 2020, 3:58 a.m.

FVB Hardware Co., Ltd.

Comment 116 by HENAN FULLCARER INDUSTRY CO., LTD. Oct. 30, 2020, 5:36 a.m.

HENAN FULLCARER INDUSTRY CO., LTD.

Comment 117 by 2 Usb Ports Kitchen Socket Oct. 30, 2020, 1:26 p.m.

2 Usb Ports Kitchen Socket

Comment 118 by RFoG Optical Receiver Oct. 30, 2020, 11:24 p.m.

RFoG Optical Receiver

Comment 119 by Cat Final Drive Oct. 31, 2020, 3 a.m.

Cat Final Drive

Comment 120 by 12v Car Travel Mug Oct. 31, 2020, 3:42 a.m.

12v Car Travel Mug

Comment 121 by Husqvarna diamond pads Oct. 31, 2020, 5:30 a.m.

Husqvarna diamond pads

Comment 122 by China Pv System Oct. 31, 2020, 7:20 a.m.

China Pv System

Comment 123 by Ktv Room Projector Factory Oct. 31, 2020, 9:11 a.m.

Ktv Room Projector Factory

Comment 124 by Epoxy Polyester Resin Price Oct. 31, 2020, 1:19 p.m.

Epoxy Polyester Resin Price

Add a new comment