Spreadsheet Implementation Technology: Basics and Extensions (Paperback)
暫譯: 試算表實作技術:基礎與擴展 (平裝本)
Peter Sestoft
- 出版商: MIT
- 出版日期: 2014-09-12
- 售價: $1,920
- 貴賓價: 9.5 折 $1,824
- 語言: 英文
- 頁數: 328
- 裝訂: Paperback
- ISBN: 0262526646
- ISBN-13: 9780262526647
無法訂購
商品描述
Spreadsheets are used daily by millions of people for tasks that range from organizing a list of addresses to carrying out complex economic simulations. Spreadsheet programs are easy to learn and convenient to use because they have a clear visual model and a simple efficient underlying computational model. Yet although the basic spreadsheet model could be extended, improved, or otherwise experimented with in many ways, there is no coherently designed, reasonably efficient open source spreadsheet implementation that is a suitable platform for such experiments. This book fills the gap, teaching users how to experiment with and implement innovative spreadsheet functionality and introducing two software platforms for doing so. Along the way, it draws on and illustrates software technologies and computer science topics that range from object-oriented programming to compiler technology.
Spreadsheet Implementation Technology surveys a wide range of information about spreadsheets drawn from user experience, the scientific literature, and patents. After summarizing the spreadsheet computation model and the most important challenges for efficient recalculation, the book describes Corecalc, a core implementation of essential spreadsheet functionality suitable for practical experiments, and Funcalc, an extension of Corecalc that allows users to define their own functions without extraneous programming languages or loss of efficiency. It also shows the advantages of automatic function specialization and offers a user's manual for Funcalc. The Corecalc and Funcalc software is downloadable free of charge.
商品描述(中文翻譯)
試算表每天被數百萬人使用,任務範圍從整理地址清單到進行複雜的經濟模擬。試算表程式易於學習且方便使用,因為它們具有清晰的視覺模型和簡單高效的底層計算模型。然而,儘管基本的試算表模型可以在許多方面進行擴展、改進或其他實驗,但目前並沒有一個設計合理、效率適中的開源試算表實現,適合進行這類實驗。本書填補了這一空白,教導用戶如何實驗和實現創新的試算表功能,並介紹兩個用於此目的的軟體平台。在此過程中,它引用並說明了從物件導向程式設計到編譯器技術等各種軟體技術和計算機科學主題。
《試算表實現技術》調查了來自用戶經驗、科學文獻和專利的廣泛試算表資訊。在總結試算表計算模型和高效重新計算的最重要挑戰後,本書描述了Corecalc,這是一個適合實際實驗的基本試算表功能的核心實現,還有Funcalc,這是Corecalc的擴展,允許用戶在不需要額外程式語言或損失效率的情況下定義自己的函數。它還展示了自動函數專門化的優勢,並提供了Funcalc的用戶手冊。Corecalc和Funcalc軟體可免費下載。