公开(公告)号：US20060069696A1

公开(公告)日：2006-03-30

申请号：US10956940

申请日：2004-09-30

申请人： Andrew Becker ,  Charles Ellis ,  Joseph Chirilov ,  Juha Niemisto ,  Matthew Androski ,  Robert Collie ,  Robert Hawking ,  Simon Peyton-Jones ,  Weide Zhong

发明人： Andrew Becker ,  Charles Ellis ,  Joseph Chirilov ,  Juha Niemisto ,  Matthew Androski ,  Robert Collie ,  Robert Hawking ,  Simon Peyton-Jones ,  Weide Zhong

IPC分类号： A44B17/00

CPC分类号： G06F17/246 ,  Y10S707/99943

摘要： The present invention relates to a new type of structured name within a spreadsheet program that allows users to refer to tables, columns of data within tables, headers of tables, totals from tables, PivotTables®, and portions of PivotTable® data by the data's headers. Embodiments of the present invention comprise a method for referring to a set of data that comprises receiving one or more semantic designations, wherein the one or more semantic designations name a set of context information that describes one or more items of data in a data structure, automatically creating a structural reference, and associating the context information with the structural reference. Other embodiments of the present invention relate to an interaction with a user interface for displaying on a display device a structural reference to data in a spreadsheet that comprises receiving one or more semantic designations from the user that refer to one or more elements of the data structure, creating a structural reference to the elements of the data structure, and displaying the structural reference as a collection of the one or more semantic designations.

摘要翻译： 本发明涉及电子表格程序中的新型结构化名称，其允许用户参考表格中的表，数据列，表的表，表中的总计，数据透视表（RIV）以及数据透视表数据的部分 通过数据头。 本发明的实施例包括用于参考包括接收一个或多个语义指定的一组数据的方法，其中所述一个或多个语义指定命名描述数据结构中的一个或多个数据项的一组上下文信息， 自动创建结构参考，并将上下文信息与结构参考相关联。 本发明的其他实施例涉及与用户界面的交互，用于在显示设备上显示对电子表格中的数据的结构参考，其包括从用户接收一个或多个参考数据结构的一个或多个元素的语义指定 ，创建对数据结构的元素的结构参考，以及将结构引用显示为一个或多个语义指定的集合。

公开(公告)号：US20060075328A1

公开(公告)日：2006-04-06

申请号：US10957502

申请日：2004-09-30

申请人： Andrew Becker ,  Charles Ellis ,  Joseph Chirilov ,  Juha Niemisto ,  Matthew Androski ,  Robert Collie ,  Robert Hawking ,  Simon Peyton-Jones

发明人： Andrew Becker ,  Charles Ellis ,  Joseph Chirilov ,  Juha Niemisto ,  Matthew Androski ,  Robert Collie ,  Robert Hawking ,  Simon Peyton-Jones

IPC分类号： G06F17/24 ,  G06F7/00 ,  G06F17/30

CPC分类号： G06F17/246 ,  Y10S707/99942

摘要： The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, and consistently receive a set of output data. In some embodiments, the user may refer to the set of data semantically instead of specifying a range of cells to use in the database formula. Referring to the data semantically allows the database formulas to adjust to changes in the range of cells new data may occupy.

摘要翻译： 本发明提供了可以操纵大量数据的几种数据库公式。 每个数据库公式是可自定义和可重复的，无需用户干预。 因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。 在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。 参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。

公开(公告)号：US20060161844A1

公开(公告)日：2006-07-20

申请号：US11036500

申请日：2005-01-14

申请人： Roy Simkhay ,  Charles Ellis ,  Alexander Babanov ,  David Gainer ,  Daniel Cory ,  Matthew Androski ,  Andrew Becker ,  Jeremy Pankratz ,  Monica McAmis ,  Simon Jones

发明人： Roy Simkhay ,  Charles Ellis ,  Alexander Babanov ,  David Gainer ,  Daniel Cory ,  Matthew Androski ,  Andrew Becker ,  Jeremy Pankratz ,  Monica McAmis ,  Simon Jones

IPC分类号： G06F17/00

CPC分类号： G06F17/246

摘要： A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

摘要翻译： 电子表格应用程序或支持公式单元格的其他应用程序，可自动为多种公式功能提供支持。 自动提供的各种公式函数包括一个返回公式逻辑值的函数，如果逻辑可以被评估而没有错误。 另一个函数在公式单元格中找到与第一列中特定值相同的行中的值，并且与第一行中的特定值相同的列。 其他功能允许选择一组多个查找行和列，以匹配用作函数中的变量的值。 电子表格应用程序还被配置为自动提供除了所描述的功能之外的其他功能。

公开(公告)号：US20070260667A1

公开(公告)日：2007-11-08

申请号：US11430486

申请日：2006-05-08

申请人： Jeffrey Duzak ,  Andrew Becker ,  Matthew Androski ,  Duane Campbell

发明人： Jeffrey Duzak ,  Andrew Becker ,  Matthew Androski ,  Duane Campbell

IPC分类号： G06F7/32 ,  G06F17/00 ,  G06F7/38

CPC分类号： G06F17/246 ,  G06F9/5066

摘要： This disclosure relates to a method and system of processing chain calculations in spreadsheet applications utilizing multiple processors, each having a separate recalculation engine. A single calculation chain may be reordered into a unified chain where supporting and dependent formulas are organized into a tree hierarchy of child chains. The unified chain is further divided into dependency levels, where entries in each dependency level may be moved to a next dependency level during reordering. If an entry within a dependency level is dependent upon another entry not found within its own child chain, the unified chain is ordered such that an entry is only dependent upon an entry in a prior dependency level. Further, dependency levels allow a control thread to perform control-thread-only operations while maintaining multi-thread processing capabilities.

摘要翻译： 本公开涉及一种使用多个处理器的电子表格应用程序中处理链计算的方法和系统，每个处理器具有单独的重新计算引擎。 单个计算链可以重新排序成统一的链，其中支持和依赖公式被组织成儿童链的树层次结构。 统一链进一步分为依赖关系级别，每个依赖关系级别中的条目可能在重排序期间移动到下一个依赖关系级别。 如果依赖关系级别中的条目取决于在其自己的子链中未找到的另一个条目，则统一链被排序，使得条目仅依赖于先前的依赖关系级别中的条目。 此外，依赖关系级别允许控制线程在维护多线程处理能力的同时执行控制线程操作。

公开(公告)号：US08032821B2

公开(公告)日：2011-10-04

申请号：US11430486

申请日：2006-05-08

申请人： Jeffrey J. Duzak ,  Andrew Becker ,  Matthew J. Androski ,  Duane Campbell

发明人： Jeffrey J. Duzak ,  Andrew Becker ,  Matthew J. Androski ,  Duane Campbell

IPC分类号： G06F17/12

CPC分类号： G06F17/246 ,  G06F9/5066

摘要： This disclosure relates to a method and system of processing chain calculations in spreadsheet applications utilizing multiple processors, each having a separate recalculation engine. A single calculation chain may be reordered into a unified chain where supporting and dependent formulas are organized into a tree hierarchy of child chains. The unified chain is further divided into dependency levels, where entries in each dependency level may be moved to a next dependency level during reordering. If an entry within a dependency level is dependent upon another entry not found within its own child chain, the unified chain is ordered such that an entry is only dependent upon an entry in a prior dependency level. Further, dependency levels allow a control thread to perform control-thread-only operations while maintaining multi-thread processing capabilities.

摘要翻译： 本公开涉及一种使用多个处理器的电子表格应用程序中处理链计算的方法和系统，每个处理器具有单独的重新计算引擎。 单个计算链可以重新排序成统一的链，其中支持和依赖公式被组织成儿童链的树层次结构。 统一链进一步分为依赖关系级别，每个依赖关系级别中的条目可能在重排序期间移动到下一个依赖关系级别。 如果依赖关系级别中的条目取决于在其自己的子链中未找到的另一个条目，则统一链被排序，使得条目仅依赖于先前的依赖关系级别中的条目。 此外，依赖关系级别允许控制线程在维护多线程处理能力的同时执行控制线程操作。

公开(公告)号：US20160199995A1

公开(公告)日：2016-07-14

申请号：US14593484

申请日：2015-01-09

申请人： Andrew Becker

发明人： Andrew Becker

IPC分类号： B26D7/06 ,  B26D3/18 ,  A22C17/00

CPC分类号： B26D7/0608 ,  A22C17/0006 ,  B26D3/18 ,  B27B25/10

摘要： A meat saw pusher device is provided, for use with a table type meat saw machine. The device comprises a pusher panel disposed in sliding cooperation with a feed channel, the feed channel defined by a structure preferably having a smooth, flat bottom surface to promote ease of sliding across a smooth flat table of a meat saw machine. Preferably, the device includes a feed handle mounted for advancing the pusher panel, and a cutting and return stroke handle mounted to one or both sides of the channel structure for moving the entire device laterally in cutting and return stroke directions. A guide panel extending below a base of the channel structure cooperates with an edge of the meat saw table to guide a lateral cutting stroke movement of the device.

摘要翻译： 提供了肉锯推杆装置，用于台式肉锯机。 该装置包括与进料通道滑动配合设置的推动器面板，该进料通道由优选地具有平滑，平坦的底部表面的结构限定，以促进易于在肉食机器的平滑平台上滑动。 优选地，该装置包括安装用于推进推动器面板的进给手柄和安装到通道结构的一侧或两侧的切割和返回行程手柄，用于在切割和返回冲程方向上横向移动整个装置。 在通道结构的底部下方延伸的引导面板与肉锯台的边缘配合以引导设备的横向切割行程。

公开(公告)号：US10513047B2

公开(公告)日：2019-12-24

申请号：US14593484

申请日：2015-01-09

申请人： Andrew Becker

发明人： Andrew Becker

IPC分类号： A22C17/00 ,  B26D7/06 ,  B26D3/18 ,  B27B25/10

摘要： A meat saw pusher device is provided, for use with a table type meat saw machine. The device comprises a pusher panel disposed in sliding cooperation with a feed channel, the feed channel defined by a structure preferably having a smooth, flat bottom surface to promote ease of sliding across a smooth flat table of a meat saw machine. Preferably, the device includes a feed handle mounted for advancing the pusher panel, and a cutting and return stroke handle mounted to one or both sides of the channel structure for moving the entire device laterally in cutting and return stroke directions. A guide panel extending below a base of the channel structure cooperates with an edge of the meat saw table to guide a lateral cutting stroke movement of the device.

公开(公告)号：US20130191714A1

公开(公告)日：2013-07-25

申请号：US13358033

申请日：2012-01-25

申请人： Chad Rothschiller ,  Eric Cohen ,  Karen Cheng ,  Josh Leong ,  Christopher Benedict ,  Keri Talbot ,  Igor Borisov Peev ,  Andrew Becker

发明人： Chad Rothschiller ,  Eric Cohen ,  Karen Cheng ,  Josh Leong ,  Christopher Benedict ,  Keri Talbot ,  Igor Borisov Peev ,  Andrew Becker

IPC分类号： G06F17/21 ,  G06F17/00

CPC分类号： G06F17/243

摘要： Animation and visuals are displayed when automatically filling/changing values within a document. A scan animation may be displayed to assist a user in understanding that an action is about to occur using their recent edit(s). A fill animation may be displayed while the suggested values are automatically filled within the document. For example, the suggested values may be displayed according to an uncommitted state (e.g. light grey text) as compared to a committed state (e.g. black text) of related values. The suggested values may be accepted/rejected while they are displayed according to the uncommitted state. When the suggested values are rejected, the suggested values are removed from the display. When the suggested values are accepted, the suggested values are transitioned to the committed state. When a user performs an edit on one or more of the suggested values, a change animation may be displayed.

摘要翻译： 自动填充/更改文档中的值时，会显示动画和视觉效果。 可以显示扫描动画以帮助用户理解使用他们最近的编辑将要发生的动作。 可以显示填充动画，同时建议的值在文档中自动填充。 例如，与相关值的提交状态（例如黑色文本）相比，可以根据未提交的状态（例如，浅灰色文本）来显示建议的值。 根据未提交状态显示建议值可能会被接受/拒绝。 当建议的值被拒绝时，建议的值将从显示中删除。 当建议的值被接受时，建议的值被转换到已提交的状态。 当用户对一个或多个建议值执行编辑时，可能会显示更改动画。

公开(公告)号：US20090006466A1

公开(公告)日：2009-01-01

申请号：US12135913

申请日：2008-06-09

申请人： Charles D. Ellis ,  Simon Loftus Petyon Jones ,  Jeffrey James Duzak ,  Joseph Matthew Chirilov ,  Andrew Becker

发明人： Charles D. Ellis ,  Simon Loftus Petyon Jones ,  Jeffrey James Duzak ,  Joseph Matthew Chirilov ,  Andrew Becker

IPC分类号： G06F17/30

CPC分类号： G06F17/246

摘要： Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a third party user defined value type that is incorporated into the spreadsheet as a supported data type. When the extensible value type is defined, an associated set of functions are developed to operate on the type. The spreadsheet manages instances of these extensible values such that they are properly maintained by the spreadsheet application while in use and released from memory when they are no longer in use.

摘要翻译： 电子表格中的单个单元格可能包含由可扩展值类型定义的可扩展值。 可扩展值类型是作为支持的数据类型合并到电子表格中的第三方用户定义的值类型。 当定义可扩展值类型时，开发一组相关的函数来对类型进行操作。 电子表格管理这些可扩展值的实例，使得它们在使用时由电子表格应用程序正确维护，并在内存中不再使用时从内存中释放。