I just finished doing this. I built an Excel formula parser and interpreter, and then a transpiler into Python. I even had the experience of having the values off by "just a little" and there's so many things that can cause it, it's just whack-a-mole honestly.

Makes me wonder how many times this has been done haha.