用结构化的图纸建模和实现方法开发重复模型
Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
摘要:
电子表格通常具有相似的变量和公式,不同之处仅在于它们引用了实体的不同实例。例如,南部和东部地区的销售收入的计算方法是南部收入=价格 * 南部销售量,东部收入=价格 * 东部销售量。在本文中,我们提出了一个概念建模方法,利用这些相似之处,并导致电子表格开发人员的公式收入=价格 * 数量。然后,我们提出了简单但严格的规则来实现电子表格。
英文摘要:
Spreadsheets often have variables and formulas that are similar, differing only by the fact that they refer to different instances of an entity. For example, the calculation of the sales revenues of the South and East regions are Revenues South = Price * Quantity Sold South and Revenues East = Price * Quantity Sold East. In this paper, we present a conceptual modelling approach that takes advantage of these similarities and leads the spreadsheet developer to the formula Revenues = Price * Quantity. We then present simple but strict rules to implement the spreadsheet.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。