• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文会议>International Conference on Inventive Computation Technologies >Bad smell refactor removable detection of audit spreadsheet
【24h】

Bad smell refactor removable detection of audit spreadsheet

机译：难闻的气味可重构检测审计电子表格

获取原文
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

Spreadsheets is one of the most generic software product to have its presence felt across industries ranging with individuals with simple needs to large companies with complex systems. In fact, mutiple judgements are disseminated owing to its high usage in U.S Firms; around 95% of the firms in U.S utilize it for financial reporting. Because of its major applicability around ample areas there is a demand to regulate and authorize its content. Many years of research study have communicated the need of identifying bad smells from spreadsheets which are very recurrent and failure of which can make a company loss billions. Bad smell is notable to be one of the leading genre of hindrance incorporated in the field of Software Engineering which can be made analogous to spreadsheet bad smells. In this paper we developed an automatic tool, a Windows Form Application embedded in .NET framework that efficiently aids in diagnosing catalog of spreadsheet bad smells. Main focus of our tool will be largely on diagnosing bad smells taking spreadsheet data generated during conducting audit process of a Company. Patterns categorizimg each smell is put to match against each spreadsheet cell to validate the reliability of the proposed tool. Main bad smells detected, concerning our tool is Long calculation Chain, Middle Man, Feature Envy, Multiple operations, Conditional Complexity and Multiple References. At the end, result of automatic detection tool on audit data is examined and future scope is considered to refine the process of automatic detection and refactor on Audit data.
机译：Spreadsheets是最通用的软件产品之一，它在各个行业中都能感受到它的存在，从具有简单需求的个人到具有复杂系统的大型公司。实际上，由于它在美国公司中的广泛使用而散布了多方面的判断。美国约有95％的公司将其用于财务报告。由于其主要用途是在足够的区域周围使用，因此需要对其内容进行规范和授权。多年的研究表明，需要从经常重复出现的电子表格中识别难闻的气味，而电子表格的失败会使公司损失数十亿美元。难闻的气味是软件工程领域中引入的主要障碍类型之一，可以类似于电子表格的难闻的气味。在本文中，我们开发了一种自动工具，即.NET框架中嵌入的Windows窗体应用程序，可以有效地帮助诊断电子表格不良气味的目录。我们工具的主要重点将主要是利用在进行公司审核过程中生成的电子表格数据来诊断难闻的气味。将每种气味的分类模式与每个电子表格单元格进行匹配，以验证所提出工具的可靠性。检测到的主要恶臭是与我们的工具有关的，包括长计算链，中间人，特征羡慕，多种操作，条件复杂性和多种参考。最后，检查了审计数据自动检测工具的结果，并考虑了未来的范围，以完善审计数据自动检测和重构的过程。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱：kefu@zhangqiaokeyan.com

京公网安备：11010802029741号 ICP备案号：京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有

  • 客服微信

  • 服务号