首页    期刊浏览 2025年06月10日 星期二
登录注册

文章基本信息

  • 标题:Dynamic Surface Charts for Scattered 4-D Data in Excel Spreadsheets
  • 本地全文:下载
  • 作者:Daniel Hsieh ; Vikas Nanda
  • 期刊名称:Spreadsheets in Education
  • 印刷版ISSN:1448-6156
  • 出版年度:2012
  • 卷号:6
  • 期号:1
  • 出版社:Faculty of Information Technology, Bond University
  • 摘要:

    Visualizations that are low-cost in memory are desirable. We present a method for stitching three-dimensional scattered data from multiple worksheets into a dynamic “animation-like” surface chart in Excel. This method is useful when (1) the user hard-codes the data points to conserve memory; employing such strategy scales better than soft-coding data values, (2) the data values are hard-coded by an unknown source, or (3) the function is complex and requires a user-defined function to output values into cells. In particular, we demonstrate an application in biology where rigid motion (rotation and translation are the only transformations applied to an object in 3-D space) is used to model the free energy gain/loss by surveying various placements and orientations of membrane proteins with respect to their environment. Our strategy involves a simple concept of scrolling through an order of worksheets, and can be extended to even more dimensions (i.e. scrolling through workbooks if necessary)

国家哲学社会科学文献中心版权所有