They have an excel sheet next to it - they can test it against that. Plus they can ask questions if something seems off and have it explain the code.

▲

AlotOfReading 8 hours ago | parent | next [-]

I'm not sure being able to verify that it's vaguely correct really solves the issue. Consider how many edge cases inhabit a "30 sheet, mind-numbingly complicated" Excel document. Verifying equivalence sounds nontrivial, to put it mildly.

▲

Dylan16807 4 hours ago | parent [-]

Consider how many edge cases it misses. Equivalence probably shouldn't be the top priority here.

	▲	Nevermark 3 hours ago \| parent [-]
		Equivalence here would definitely be the worst test, except for all the alternatives.

▲

lmm 8 hours ago | parent | prev | next [-]

> They have an excel sheet next to it - they can test it against that.

It used to be that we'd fix the copy-paste bugs in the excel sheet when we converted it to a proper model, good to know that we'll now preserve them forever.

▲

karlgkk 8 hours ago | parent | prev [-]

[flagged]

▲

yomismoaqui 8 hours ago | parent [-]

You would be surprised at the volume of money made by businesses supported by Excel.

▲

martinald 8 hours ago | parent [-]

Yes. I suspect there are thousands of Excel files that "process" >$1bn/yr out there.

	▲	irishcoffee 5 hours ago \| parent [-]
		Allow me to introduce to you: ACH. It is truly fascinating.