#ProductDiaries 10/28/22: do math with excel formulas

Phyllis
Oct 29, 2022

#ProductDiaries is a documented series of my experience as a product manager — what I’m doing, what I’m learning, and what I’m changing.

When you present your calculations, most people will believe you.

That said, it’s beneficial to show your math. Not only with the final numbers and formulas but with where each number plugged in came from.

The best way I know to do this is excel sheets where each cell is a formula of input from other cells. Make sure the original cells that are date from outside sources have links to those data sources.

This way people can learn from you and reproduce it themselves in the future or can fact check where you messed up.

--

--