I feel I should link a function mode excel ray tracer a friend wrote in 2004.

https://github.com/simon-frankau/excel-ray-tracer