I bet there is a space there for something between R and Excel. Something where everything is "as-code" in a scm friendly format but the primary interaction could be equally powerful in a text editor or a cell space.
The "workbook" path of things like Jupityr is close.
The "workbook" path of things like Jupityr is close.