The paper I presented at a “spreadsheet-risk” conference a while back has now been approved and entered at Cornel’s Arxiv academic archive, see:
The paper details some of the work that Xenomorph’s product development team have done on combining spreadsheet ease of use with database consistency and centralisation. We call this tech “SpreadSheet Inside” and a more detailed whitepaper on it can be provided on request. Clients are using it to centralise and control access to spreadsheet calculations and also using it within (extremely!) complex reports for risk management and trading.
Many thanks to Grenville Croll at Eusprig (www.eusprig.org) for assisting on this!