Smalera, who weighed 242 pounds at the beginning of his weight-loss journey, input his weight into the spreadsheet each morning between 2010 and 2014. His average 10-day weight trend revealed that even if it went up a bit from the previous day, he was still losing pounds. He said it spared him from agonizing over the day-to-day fluctuations of his weight.

Paul Smalera, before and after his 60 pound weight loss using Google docs.Courtesy Paul Smalera

“It gave me a sense of scale that you just can’t see on a day-to-day basis — a timeline that was just kind of beyond your brain’s ability to keep track of the number that way,” Smalera told NBC News BETTER.

Before Smalera started tracking his weight, he felt like he didn’t have control over it.

“I think the really big thing is that I cut out a lot of or pretty much all heavily processed foods, which I think can really just disrupt your body’s sense of being full or being hungry when you’ve had enough nutrition or energy for the day,” he said.

In 2011, Smalera trained for the New York City Marathon. The intense training increased his hunger and caused him to eat more, he said. His legs became more muscular, which caused him to gain some weight.

“What I found is that exercise makes you stronger, it makes you fit, it makes you healthier,” said Smalera. “It has all sorts of mental and physical benefits, but for weight loss it didn’t really seem to have an impact.”

“Figuring out just how to measure [your] goal and trust the data rather than get caught up in the day-to-day appearance and image and feeling actually was the key to avoiding some of the pitfalls,” Smalera explained.

Before Smalera started tracking his weight, he felt like he didn’t have control over it. Seeing the data allowed him to know what works best for him, he said. It also gave him more respect for his body.

“I’m more in tune with it, I kind of appreciate it and want to take care of it, because I’m starting to see now how incredible it is, and you can transform yourself that way, [and] basically have a different body if you put that intent into it,” said Smalera.

Understand that exercise may improve your overall fitness, but may not impact your weight the way you expect it to.

Trust the data. It’s easy to get discouraged when you look at the scale each morning, but your 10-day weight trend will give you a more accurate understanding of your weight loss and what works best for you.