arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 0803.1748cs.SEcs.CY
收藏

一个几乎消除电子表格风险的计算框架

A Computational Framework for the Near Elimination of Spreadsheet Risk

Yusuf Jafry, Fredrika Sidoroff, Roger Chi

摘要:

我们介绍Risk Integrated的企业电子表格平台(ESP),这是一种在企业计算环境中几乎消除电子表格风险的技术方法,同时保持电子表格的充分灵活性,以模拟复杂的财务结构和流程。在其基本使用模式中,该系统包括一个安全和强大的集中式电子表格管理框架。在高级模式中,系统可以被视为一个健壮的计算框架,用户可以通过该框架向电子表格“提交作业”,并从计算中检索结果,但不能直接存取底层电子表格。一个示例应用程序,蒙特卡洛模拟,提出了强调这种方法的好处,在复杂的,关键任务,财务计算,以减轻电子表格的风险。

英文摘要:

We present Risk Integrated's Enterprise Spreadsheet Platform (ESP), a technical approach to the near-elimination of spreadsheet risk in the enterprise computing environment, whilst maintaining the full flexibility of spreadsheets for modelling complex financial structures and processes. In its Basic Mode of use, the system comprises a secure and robust centralised spreadsheet management framework. In Advanced Mode, the system can be viewed as a robust computational framework whereby users can "submit jobs" to the spreadsheet, and retrieve the results from the computations, but with no direct access to the underlying spreadsheet. An example application, Monte Carlo simulation, is presented to highlight the benefits of this approach with regard to mitigating spreadsheet risk in complex, mission-critical, financial calculations.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑