Oxford researcher offers tool to ease spreadsheet complexity

News

Oxford researcher offers tool to ease spreadsheet complexity

Cliff Saran

A research area of mathematics is being used to simplify spreadsheet formulas by providing users with a library of downloadable spreadsheet components.

Oxford researcher and consultant Jocelyn Paine has set up a Web-based software library for Excel users called the Ireson-Paine Spreadsheet Parts Repository, which will stock modules for users to download and "glue" into their own spreadsheets. These will do calculations that users find difficult or risky to program themselves. Jocelyn wants suggestions for suitable modules.

The idea is based on "category theory" which takes mathematical ideas such as "sum" - putting things together - and abstracts them into universal concepts applicable to diverse situations. Computer scientists can use this concept to formalise what happens when the modules are strong together to make programs.





Email Alerts

Register now to receive ComputerWeekly.com IT-related news, guides and more, delivered to your inbox.
By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
 

COMMENTS powered by Disqus  //  Commenting policy