TDEE & Macro Planning Guide: Spreadsheet Templates for Fat Loss and Muscle Gain
calorie planningmacrosTDEEmeal planningfitness calculators

TDEE & Macro Planning Guide: Spreadsheet Templates for Fat Loss and Muscle Gain

TThe Gym Shop Editorial Team
2026-11-11
7 min read

Learn to estimate TDEE, set calories and macros, build a spreadsheet, and adjust your plan for fat loss, maintenance, or muscle gain.

Use this practical TDEE and macro planning workflow to estimate how many calories you should eat for fat loss, muscle gain, or maintenance, then turn the result into an editable spreadsheet you can revisit as your body weight, training, and goals change.

Overview

A calorie target is a starting estimate, not a permanent prescription. Your total daily energy expenditure (TDEE) changes with body size, movement, training volume, recovery, and routine. A useful plan therefore combines a calculator with several weeks of real-world feedback.

The workflow is simple:

  1. Estimate your basal metabolic rate (BMR).
  2. Apply an activity multiplier to estimate TDEE.
  3. Choose a calorie target based on your goal.
  4. Set protein and fat minimums, then assign the remaining calories to carbohydrates.
  5. Track body-weight trends, training performance, hunger, and adherence.
  6. Make small adjustments rather than changing the entire plan after a few days.

This approach is more useful than treating a TDEE calculator or macro calculator as an exact measurement. For related planning, see our TDEE calculator guide and macro planning guide.

How to estimate calories and macros

1. Estimate BMR

BMR is an estimate of the energy your body uses at rest. One commonly used equation is the Mifflin–St Jeor formula:

  • For men: BMR = (10 × weight in kilograms) + (6.25 × height in centimetres) − (5 × age) + 5
  • For women: BMR = (10 × weight in kilograms) + (6.25 × height in centimetres) − (5 × age) − 161

These equations use a binary sex input and are population-based estimates. If the result does not fit your circumstances, use it as a rough starting point and rely more heavily on your weight trend and performance data.

2. Apply an activity multiplier

Multiply BMR by an activity factor to estimate TDEE. Select the closest description rather than automatically choosing the highest category.

MultiplierGeneral descriptionUse cautiously when
1.2Mostly sedentary, with little structured exerciseYour daily steps and training are consistently low
1.35Light activity, such as regular walking and occasional trainingYou train one to three times weekly
1.5Moderate activity, with regular training and a generally active routineYou train several times weekly and move throughout the day
1.7High activity, including frequent training or a physically demanding routineYou train often and have substantial non-exercise activity

Formula: estimated TDEE = estimated BMR × activity multiplier. Because activity categories overlap, it can be sensible to calculate a low and high estimate and begin near the middle.

3. Set calories for your goal

For fat loss, begin with a modest reduction from estimated TDEE. A smaller deficit is often easier to sustain and may support training better than an aggressive cut. For maintenance, start close to estimated TDEE. For muscle gain, use a modest surplus and monitor whether body weight and gym performance are moving in the intended direction.

There is no single correct answer to “how many calories should I eat to lose weight?” The practical answer is the intake that produces a gradual, observable trend while allowing you to train, recover, and follow the plan consistently.

4. Set macros

Set protein first, using body weight as a practical reference. A general planning range for active adults is approximately 1.6–2.2 grams of protein per kilogram of body weight per day. Use the lower end when maintenance and adherence are the priority, and consider the higher end during a calorie-restricted phase or when preserving lean mass is especially important.

Set dietary fat next. A useful planning range is approximately 0.6–1.0 grams per kilogram of body weight per day, adjusted for preference and total calories. Assign the remaining calories to carbohydrates, which can support training and make meals more flexible.

Use these calorie conversions in your spreadsheet:

  • Protein: grams × 4 = calories
  • Carbohydrate: grams × 4 = calories
  • Fat: grams × 9 = calories

A simple spreadsheet layout can include columns for body weight, BMR, activity multiplier, TDEE, calorie target, protein grams, fat grams, carbohydrate grams, average weight, and adjustment. Enter the formulas once, then duplicate the sheet for each training block or goal phase.

Inputs and assumptions

Your estimate is only as useful as the inputs. Weigh yourself under similar conditions, record height accurately, and describe your activity based on the whole week rather than one hard workout. Include walking, commuting, standing, sport, cardio, and strength training.

Use a seven-day average for body weight when possible. Daily weight can shift because of hydration, food volume, sodium, digestion, and menstrual-cycle changes. The average is usually more informative than any single reading.

Track intake consistently enough to identify a pattern, but do not assume packaged-food labels or portion estimates are perfectly precise. Restaurant meals and informal snacks can add substantial uncertainty. Consistent measurement matters more than chasing false precision.

Macro targets are not a requirement for every person. If detailed tracking increases stress or disrupts normal eating, use a simpler structure: include a protein source at meals, eat a variety of minimally processed foods, add fruit and vegetables, and adjust portions based on your trend and training.

Worked examples

Example: a 1,800-calorie fat-loss target

Suppose a person chooses a 1,800-calorie target, 140 grams of protein, and 55 grams of fat. Protein contributes 560 calories and fat contributes 495 calories. The remaining 745 calories go to carbohydrate, which equals approximately 186 grams.

A day could include Greek yogurt or eggs at breakfast, a chicken, tofu, or bean-based lunch, a rice or potato serving around training, fruit and a protein-rich snack, and a dinner built around vegetables and a lean or plant-based protein. The exact foods are interchangeable; the target is a planning guide rather than a mandatory menu.

Example: a 2,400-calorie maintenance target

With 160 grams of protein and 75 grams of fat, protein provides 640 calories and fat provides 675 calories. That leaves 1,085 calories for carbohydrate, or approximately 271 grams. This structure may suit someone whose body weight is stable and whose priority is maintaining strength while following a regular workout plan.

Example: a 3,000-calorie muscle-gain target

At 3,000 calories, a target of 180 grams of protein and 85 grams of fat provides 720 and 765 calories respectively. The remaining 1,515 calories equal approximately 379 grams of carbohydrate. Higher-calorie plans are often easier to follow when spread across three meals and one or two snacks rather than concentrated in very large meals.

Decision checklist

  • Choose fat loss when reducing body fat is the primary goal and you can accept slower gym progress.
  • Choose maintenance when you want to practice consistent eating, support performance, or reassess your true calorie needs.
  • Choose muscle gain when gaining size and strength is the priority and you can tolerate some potential increase in body fat.
  • Choose a slower transition when your current intake or training history is unclear. Establish consistency before making a large change.

When to recalculate

Revisit the spreadsheet at the start of a new training block, after a meaningful change in body weight, or when your weekly activity changes. You do not need to recalculate after every unusual meal or missed workout.

Use this weekly review:

  1. Record average body weight and waist measurement if you use one.
  2. Check whether workouts, steps, sleep, hunger, and recovery were reasonably consistent.
  3. Compare the current trend with your goal, not with a single day.
  4. If progress has stalled for several consistent weeks, make a small calorie adjustment or review tracking accuracy.
  5. If performance, recovery, mood, or adherence deteriorates, consider a smaller deficit, a maintenance phase, or professional guidance.

Keep strength training and progressive overload in the plan where appropriate; our progressive overload guide explains how to progress weight, repetitions, and volume. If you train at home, pair your nutrition plan with a realistic routine rather than estimating extra calories for every session. You can also explore our home gym equipment comparison when your setup needs to change.

Finally, treat calculator outputs as estimates. People with a medical condition, a history of disordered eating, pregnancy, or unusually demanding training should seek individualized advice from a qualified health professional or sports dietitian. Recalculate when your inputs change, but let sustainable habits and repeated observations—not a single formula—guide the next adjustment.

Related Topics

#calorie planning#macros#TDEE#meal planning#fitness calculators
T

The Gym Shop Editorial Team

Fitness and Training Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.