Laptop showing nutrition charts beside meal cards and a notebook on a dark desk
Systems

Macro Calculator in Google Sheets for Coaches: TDEE Spreadsheet With Formulas

7 min read

Build a macro calculator and TDEE spreadsheet in Google Sheets: Mifflin-St Jeor BMR, activity multipliers, goal adjustments and protein, fat and carb targets, with copy-ready formulas and a worked example.

Try the carb cycling calculator and reverse diet calculator with your own planning assumptions.

Free starter CSV downloads

Get every tab as a CSV by email, then import them into your own Google Sheet. The previews below are open to everyone and use fictional example data.

Get the free CSVs by email

We email you a private download link. No payment. The previews below stay open to everyone.

  • Calculator
  • Formula Reference
  • Lists

One access email, even if you leave the box empty. The link works for 24 hours. Privacy policy

CSV files carry the layout and example rows only, not formatting, charts, checkboxes or a shared Google Form. Formula cells arrive as text: check each one, then delete the leading apostrophe to switch it on.

Calculator

Rows match the article’s B-cell references. Values are examples, not recommendations. Estimates for planning, not medical advice.

Calculator fictional example rows
FieldValue
SexFemale
Weight kg70
Height cm165
Age35
Activity levelExample factor 1.55
GoalExample adjustment -20%
Protein g/kg1.8
Fat fraction0.25
Body-fat fraction optional
BMR1395.25
TDEE2162.6375
Calorie target1730
Protein g126
Fat g48
Carbs g199
Macro check kcal1732
Spare
Training days4
Carb shift g30

Formula Reference

Formula strings are deliberately exported as text. Activate them in the named Calculator cell after reviewing the inputs. Mifflin MD et al., Am J Clin Nutr 1990;51(2):241–247; https://pubmed.ncbi.nlm.nih.gov/2305711/.

Formula Reference fictional example rows
DestinationFormula
Calculator!B11=10*B3+6.25*B4-5*B5+IF(B2="Male",5,-161)
Calculator!B12=B11*1.55
Calculator!B13=MROUND(B12*0.8,5)
Calculator!B14=ROUND(B3*B8,0)
Calculator!B15=ROUND(B13*B9/9,0)
Calculator!B16=ROUND((B13-B14*4-B15*9)/4,0)
Calculator!B17=B14*4+B15*9+B16*4

Lists

These are labelled example assumptions, not sourced activity prescriptions. Change the formula references if you use a lookup.

Lists fictional example rows
SettingExample value
Activity factor1.55
Goal multiplier0.8

A macro calculator in Google Sheets lets you set a client's calorie and macro targets in seconds and recalculate them when their weight changes. You enter weight, height, age, sex, activity level and goal. The sheet returns BMR, TDEE, a calorie target and grams of protein, fat and carbohydrate.

This guide shows how to build one. Every formula is ready to copy, and a worked example checks the result.

A calculator gives you a starting estimate, not an exact answer. Real energy needs vary between people. Use the client's weekly weight trend to adjust targets after two to four weeks.

Step 1: Set Up the Input Cells

Create a tab called Calculator and add these labels in column A and inputs in column B:

CellLabelExample input
B2SexFemale
B3Weight (kg)70
B4Height (cm)165
B5Age35
B6Activity levelModerately active
B7GoalFat loss
B8Protein (g per kg)1.8
B9Fat (% of calories)25%

Use Data > Data validation to make B2, B6 and B7 dropdowns. Dropdowns stop typing errors that would break the lookups.

Working in pounds and inches? Add two helper cells and point the formulas at them:

Weight in kg:  =B3*0.453592
Height in cm:  =B4*2.54

Step 2: Calculate BMR With Mifflin-St Jeor

Basal metabolic rate (BMR) estimates the energy the body uses at rest. The Mifflin-St Jeor equation is a common choice for the general population:

  • Men: 10 × weight (kg) + 6.25 × height (cm) − 5 × age + 5
  • Women: 10 × weight (kg) + 6.25 × height (cm) − 5 × age − 161

In B11, one formula handles both:

=10*B3+6.25*B4-5*B5+IF(B2="Male",5,-161)

Existing alternative formula reference: this layout also contains a lean-mass equation using body fat percentage in B10. Its original source was not verified for this update; it is not used by the new tools or CSV default example.

=370+21.6*(B3*(1-B10))

Have an appropriately qualified professional choose a suitable method for the individual.

Step 3: Calculate TDEE With Activity Multipliers

Total daily energy expenditure (TDEE) is BMR multiplied by an activity factor. Create a tab called Lists with this table in A2:B6:

Activity levelMultiplier
Sedentary1.2
Lightly active1.375
Moderately active1.55
Very active1.725
Extremely active1.9

In B12, look up the multiplier and calculate TDEE:

=B11*XLOOKUP(B6,Lists!A2:A6,Lists!B2:B6)

If your version of Sheets does not support XLOOKUP, use:

=B11*VLOOKUP(B6,Lists!A2:B6,2,FALSE)

These activity multipliers are example assumptions. Select or enter a factor and review it against observed data; they are not a diagnosis or a measured energy expenditure.

To check the sheet against a second calculation, enter the same client in the TDEE and maintenance calorie calculator.

Step 4: Apply the Goal Adjustment

Add a goal table in Lists!D2:E4. The percentages below are example starting points. Set your own based on your coaching method and the client's situation.

GoalAdjustment
Fat loss-20%
Maintenance0%
Muscle gain10%

In B13, calculate the calorie target and round it to the nearest 5 kcal:

=MROUND(B12*(1+XLOOKUP(B7,Lists!D2:D4,Lists!E2:E4)),5)

Step 5: Split Calories Into Macros

Use the standard energy values: protein and carbohydrate provide 4 kcal per gram, fat provides 9 kcal per gram.

To test a protein rate before you write the formula, use the protein calculator for daily and per-meal targets.

Protein (grams), in B14, based on bodyweight:

=ROUND(B3*B8,0)

The example uses 1.8 g/kg as an editable planning input, not a recommendation. Set B8 only after reviewing the client’s needs.

Fat (grams), in B15, as a percentage of calories:

=ROUND(B13*B9/9,0)

Carbohydrate (grams), in B16, from the calories that remain:

=ROUND((B13-B14*4-B15*9)/4,0)

Check total, in B17, to confirm the macros add up:

=B14*4+B15*9+B16*4

The check total will differ from the target by a few calories because of rounding. A larger gap means a formula error.

Add a guard so a very high protein or fat setting cannot produce negative carbs:

=IF(B16<0,"Reduce protein or fat","OK")

Worked Example

A 35-year-old woman, 70 kg, 165 cm, moderately active, with a fat loss goal:

StepCalculationResult
BMR10 × 70 + 6.25 × 165 − 5 × 35 − 1611,395 kcal
TDEE1,395.25 × 1.552,163 kcal
Target2,162.6 × 0.8, rounded to 51,730 kcal
Protein70 × 1.8126 g (504 kcal)
Fat1,730 × 25% ÷ 948 g (432 kcal)
Carbohydrate(1,730 − 504 − 432) ÷ 4 = 198.5, rounded199 g (796 kcal)

Check: 504 + 432 + 796 = 1,732 kcal, within 2 kcal of the target because of rounding. The sheet should return the same numbers. If it does not, check the cell references first.

Step 6: Add Training Day and Rest Day Targets

This example moves carbohydrate between day types. Keep weekly calories the same and move carbs between days. With training days per week in B19 and a carb shift in grams in B20:

Training day carbs:  =B16+B20
Rest day carbs:      =IF(B19=7,"No rest days",B16-B20*B19/(7-B19))

For example, with 4 training days and a 30 g shift, training days get 229 g and rest days get 159 g. The weekly carb total stays the same.

Step 7: Adjust From Real Data

The calculator sets the starting point. The weekly check-in tells you whether it is right. After two to four weeks:

  1. Compare the client's average weekly bodyweight with the previous weeks.
  2. Check adherence. If the client hit their targets on only three days a week, fix adherence before changing numbers.
  3. If the trend does not match the goal, change calories in small steps, then review again.

Record each change in a log tab with the date, old target, new target and reason. The online coaching check-in template shows how to track average weight and adherence each week. If a client sends daily weigh-ins, the weekly average weight calculator gives the 7-day figure.

From Macro Targets to a Meal Plan

Targets are only useful if the client can hit them. The next step is a meal plan that adds up food quantities per meal and per day. The meal plan template guide walks through a food database lookup and meal totals in Google Sheets. For a quick split without a food list, the macros per meal calculator divides the daily targets across meals.

GSheetsPro includes macro and meal plan templates with per-meal and per-day calculations and an editable 200+ food database, as part of a one-time purchase of the system. See what is included on the pricing page.

Equation source and limits

Mifflin MD et al., A new predictive equation for resting energy expenditure in healthy individuals, Am J Clin Nutr 1990;51(2):241–247. PubMed record. Citation checked 9 October 2026. Activity factors and goal adjustments are separate assumptions, not part of the Mifflin-St Jeor equation.

Estimates for planning, not medical advice. Example protein, fat and activity values are editable assumptions, not individual recommendations.

Frequently asked questions

Which equation does this sheet use?

The main calculation uses Mifflin-St Jeor, then a separately chosen activity factor. See the cited 1990 paper. The result is an estimate, not a measurement.

How much protein should I enter?

Enter a value chosen for the client by an appropriately qualified professional. The example is an arithmetic input, not a recommended intake.

Why do rounded macros differ from the target?

Rounding each macro to whole grams can change the displayed total by a few calories. Keep full precision for calculations and round only the display.

Run Your Coaching in Google Sheets

Use GSheetsPro templates for training plans, nutrition, client check-ins and progress tracking.

See GSheetsPro for £199