Jocelyn Ireson-Paine (JIP) et al developed software years ago that converts spreadsheets to language and vice versa, so you can write in code and then generate

Jocelyn Ireson-Paine (JIP) et al developed software years ago that converts spreadsheets to language and vice versa, so you can write in code and then generate a corresponding spreadsheet. This two-way capability aids, among other things, in debugging spreadsheets. JIP is in euSPRIG (see http://eusprig.org/best-practice.htm http://eusprig.org/best-practice.htm ). Here are some links: http://j-paine.org/eusprig2005.html http://j-paine.org/eusprig2005.html https://www.i-nth.com/tag/jocelyn-paine https://www.i-nth.com/tag/jocelyn-paine http://www.j-paine.org http://www.j-paine.org