ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 3068|回复: 3

[灌水]“数据透视表”的诞生

[复制链接]

TA的精华主题

TA的得分主题

发表于 2005-8-30 15:09 | 显示全部楼层 |阅读模式
“数据透视表”的诞生 The concept that led to today's pivot table came from the halls of the Lotus Development Corporation with a revolutionary spreadsheet program called Lotus Improv. Improv was envisioned in 1986 by Pito Salas of the Advanced Technology Group at Lotus. Realizing that spreadsheets often have patterns of data, Pito concluded that if one could build a tool that could recognize these patterns, then one could build enhanced data models. Lotus ran with the concept and started developing the next-generation spreadsheet.

导致今天“数据透视表”的想法源自拥有具革命意义的电子表程序Lotus Improv的Lotu公司过道。1986年该公司高技术小组的Pito Salas即有了Improv这一设想。他认识到电子表常常具有各种数据样式,于是得出这样的结论:如果有人能建立识别这些样式的工具,那么他就可以建立起高级数据模型。Lotus公司正是遵循这样的观点开始研发下一代电子表软件的。 Pito Salas—— 数据透视表概念的发明者 http://www.salas.com/work/resume.htm

[此贴子已经被作者于2005-8-30 15:21:31编辑过]

[灌水]“数据透视表”的诞生

[灌水]“数据透视表”的诞生

TA的精华主题

TA的得分主题

 楼主| 发表于 2005-8-30 15:15 | 显示全部楼层
Throughout 1987, Lotus demoed its new program to a few companies. In 1988, Steve Jobs saw the program and immediately wanted it developed for his upcoming NeXT computer platform. The program, finally named Lotus Improv, was eventually shipped in 1991 for the NeXT platform. A version for Windows was introduced in 1993.

在1987年,Lotus公司便向几家公司演示了它的新程序。1988年,Steve Jobs见到了这个程序后就立即希望它能被开发成一个能在其即将发行的NeXT计算机系统上运行的版本。这个程序后来被命名为Lotus Improv,并最终在1991年被移植到了NeXT平台。1993年,Improv 的Windows版本也问世了。

TA的精华主题

TA的得分主题

 楼主| 发表于 2005-8-30 15:16 | 显示全部楼层
The core concept behind Improv was that data, data views, and formulas should be encapsulated as separate entities and treated as different animals. For the first time in a spreadsheet program, a dataset was given a name that could be grouped into larger categories. This naming and grouping capability paved the way for the most powerful feature in Improv, rearranging data. With Improv, a user could define and store a set of categories and then change the view by simply dragging the category names with the mouse. The user could also create totals and group summaries. Improv背后的核心观念是:数据、数据视图和公式都应被封装成各自独立的实体,即可以将它们看成不同的动物个体。正是在一个电子表软件中,一组数据首次被冠以一个名字且被包含于更大的分类中。这种命名和分类的功能为Improv(灵活)重置数据清除了障碍。通过Improv,用户可以定义和存储一组类别然后用鼠标只是简单的拖动类别的名称来改变视图。同时,用户也能创建类别总计和分组合计。

[此贴子已经被作者于2005-8-30 15:18:46编辑过]

TA的精华主题

TA的得分主题

 楼主| 发表于 2005-8-30 15:18 | 显示全部楼层
Microsoft eventually picked up on this concept in its pivot table functionality in Excel 5. Years later, with the release of Excel 97, Microsoft offered users an enhanced pivot table wizard and key improvements to pivot table functionality, such as the ability to add calculated fields. Excel 97 also opened up the pivot cache to developers, fundamentally changing the way pivot tables are created and managed. Microsoft introduced the pivot chart with Excel 2000, providing users a way to represent pivot tables graphically. Since Excel 2000, changes made to pivot tables have been mainly cosmetic, much to the chagrin of pivot table fans everywhere.

Microsoft公司最终在Excel 5的数据透视表功能中吸纳了上述概念。几年后,伴随Excel 97的发行,Microsoft公司是向用户提供了更为高级的数据透视表向导和关键性的功能改进,如增加了“计算字段”功能。Excel 97同时也向开发者开放了透视表缓冲区,缓冲区决定了透视表的生成和控制方式。在Excel 2000中,Microsoft公司引如了数据透视图,从而使用户能够以图表的方式更为直观地展示数据。从Excel 2000开始,数据透视表的改变都是修饰性的(没有实质性的功能改变),这主要是为了回应来自各地的透视表fans的不满意见。

[此贴子已经被作者于2005-8-30 15:24:52编辑过]
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-1 11:36 , Processed in 0.030093 second(s), 10 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表