论文标题
多维电子表格的实施策略
Implementation Strategies for Multidimensional Spreadsheets
论文作者
论文摘要
经验丰富的Excel开发人员被邀请参加一项挑战，以实施具有多维变量的电子表格。我们分析了它们的电子表格，以查看采用了不同的实施策略。我们确定了两种策略：大多数参与者在Excel使用的二维平面上使用了三个或四维变量的投影。一些参与者使用了数据库方法，其中以适当的主键的数据为数据集表的形式显示了多维变量。这种方法导致更简单的公式。
Seasoned Excel developers were invited to participate in a challenge to implement a spreadsheet with multi-dimensional variables. We analyzed their spreadsheet to see the different implement strategies employed. We identified two strategies: most participants used a projection of three or four-dimensional variables on the two-dimensional plane used by Excel. A few participants used a database approach where the multi-dimensional variables are presented in the form of a dataset table with the appropriate primary key. This approach leads to simpler formulas.
