Posted on Oct 2, 2026 Last updated: 11/15/2026, 12:40:13 PM Estimated reading time: 4 min

Adaptive TDEE spreadsheet: where to get one and how to use it

An adaptive TDEE spreadsheet estimates your maintenance calories from the food you eat and your body-weight trend. Unlike a one-time calculator, it updates as you add more days of data. For a downloadable example, see the 3-Suns spreadsheet fork on GitHub, which includes an Excel file. The r/Fitness discussion of the original sheet explains its inputs and links to other versions. These are third-party resources; MacroCodex does not maintain them.

alt text
MacroCodex free app continuously tracks maintenance calories using State Space Neural Network.

Looking for the specific nSuns version? See our nSuns TDEE spreadsheet setup page for the sheet linked by The Fitness Wiki.

MacroCodex Case Studies

Lean bulk case study (MacroCodex)

Lean bulking is hardest when your maintenance calorie estimate is inaccurate. Why? Because the surplus you need is often very small, so even a modest error in estimating maintenance can turn your intended surplus into a deficit or an unnecessarily large surplus.

Neither MacroFactor nor Apple Watch or Garmin watches can estimate your maintenance calories accurately enough to eliminate this problem. Each row in the table below in the screenshot is a week.

Here's a lean bulk journey from a MacroCodex user:

alt text
MacroCodex user's Lean bulk log

Start weight: 159.2 lb (17–23 Aug)

End weight: 162.3 lb (19–25 Oct)

Actual gain: 162.3 − 159.2 = +3.1 lb

Number of weekly intervals: 9

actual gain rate:

3.1 lb/ 9 week

≈ +0.34 lb/week

≈ +0.16 kg/week

≈ +22 g/day

≈ +0.22% of body weight per week

Implied average energy surplus using 3,500 kcal/lb:

0.344×3500/7 ≈172 kcal/day

That's equivalant of additional 2 slices of bread daily over maintenance!

Cut case study (MacroCodex)

alt text alt text

Maintenance case study (MacroCodex)

alt text alt text

How to use the spreadsheet

  1. Save your own copy and check whether it expects pounds or kilograms and calories or kilojoules.
  2. Enter your calorie intake and body weight regularly, including days when you ate more or less than planned.
  3. Give the estimate several weeks of data. Look at the trend rather than reacting to one day's weight or TDEE reading.

alt text

Water retention, changes in food volume, and incomplete food logs can make the result jump around. The r/Fitness discussion recommends treating the current TDEE estimate with caution and making gradual changes after observing the trend. For the underlying calculation, read our adaptive TDEE guide.

Want the estimate without maintaining a spreadsheet?

MacroCodex gives you an initial TDEE estimate and updates it from your logged calorie totals and body weight. Its Smart Calorie Burn v2 explanation describes a state-space neural-network approach that uses patterns from thousands of users alongside your own logs to produce a highly accurate personalized estimate. It also shows calorie targets for your goal. The app is free, with no ads or subscription; you can pair it with a separate food logger if needed.

In our internal testing, popular Reddit adaptive TDEE spreadsheets were still 300–400 kcal/day off after six to eight weeks of tracking. That is our observed comparison, not a published benchmark or a prediction of how far off every spreadsheet will be. The quality of calorie and weight logs affects either method.

alt text
Google Playstore Review of MacroCodex

Our claim: See measurable weight gain or weight loss results within 2–3 weeks of using MacroCodex. Many users start seeing results as early as the first week.

Verify playstore reviews here: https://play.google.com/store/apps/details?id=com.macrocodex.app

alt text
MacroCodex user in the Telegram community.

Verify Telegram Community reviews here: https://macrocodex.app/community/

You still need consistent data, whichever method you choose. If you enjoy inspecting formulas and keeping a spreadsheet, use one of the community sheets above. If you want your estimate and targets updated in an app, try MacroCodex. Our free TDEE calculator app guide compares the workflows in more detail.