News for hackers. Stuff that matters.
Re:Excel World Championship Finals by ineedasername on Saturday December 11, 2021 @03:58PM (#29524241)
TIL you actually can enable circular references in Excel. Though I struggle to see the practical usefulness except for a few edge cases.
Re:Excel World Championship Finals by sl8r on Saturday December 11, 2021 @04:48PM (#29524583)
Interestingly, they’re actually used all the time in LBO models. Because the default is to sweep all FCF to pay down debt, but then the interest expense is dependent on FCF, which depends on the interest expense… Sort of a trivial example b/c you could solve it by being more granular with time periods, but in practice people just use the circular ref.
Re:Excel World Championship Finals by DwnVoteHoneyPot on Saturday December 11, 2021 @06:29PM (#29525324)
I've also seen it basterdize into running a loop for a monte carlo sim instead of using a VBA macro. Genius and stupid all at the same time.
Re:Excel World Championship Finals by jkaptur on Saturday December 11, 2021 @04:01PM (#29524265)
How else would you implement Newton’s method? ;)
Re:Excel World Championship Finals by dsizzle on Saturday December 11, 2021 @04:06PM (#29524303)
I'm reminded of solving Laplace's equation in Excel. It makes some cool animations too https://www.av8n.com/physics/laplace.htm