公开(公告)号：US08745482B2

公开(公告)日：2014-06-03

申请号：US12869367

申请日：2010-08-26

Applicant: Charles D. Ellis ,  David F. Gainer ,  Samuel C. Radakovitz ,  Yonghong Zeng ,  Dave McDonald

Inventor： Charles D. Ellis ,  David F. Gainer ,  Samuel C. Radakovitz ,  Yonghong Zeng ,  Dave McDonald

IPC: G06F17/00

CPC classification number: G06F17/246 ,  G06F3/0482 ,  G06F3/04847 ,  G06F17/212

Abstract: The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.

Abstract translation: 本发明包括用于组织数据应用中显示的数据的方法和用户界面。 具体地，本发明提供了用于通过应用于数据的一个或多个部分的格式来布置数据显示的方法和系统。 格式包括显示数据的不同视觉特征。 在示例性实施例中，数据应用程序通过单元格的填充颜色，单元格内的数据的字体颜色或插入单元格的图标的类型来组织数据。 组织包括数据的任何类型的重新排列。 在示例性实施例中，数据应用根据格式对所显示的数据进行排序或过滤。

公开(公告)号：US08726143B2

公开(公告)日：2014-05-13

申请号：US11036500

申请日：2005-01-14

Applicant: Roy Simkhay ,  Charles D. Ellis ,  Alexander Babanov ,  David F. Gainer ,  Daniel P. Cory ,  Matthew J. Androski ,  Andrew J. Becker ,  Jeremy R. Pankratz ,  Monica McAmis ,  Simon Loftus Peyton Jones

Inventor： Roy Simkhay ,  Charles D. Ellis ,  Alexander Babanov ,  David F. Gainer ,  Daniel P. Cory ,  Matthew J. Androski ,  Andrew J. Becker ,  Jeremy R. Pankratz ,  Monica McAmis ,  Simon Loftus Peyton Jones

IPC: G06F17/00

CPC classification number: G06F17/246

Abstract: 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.

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

公开(公告)号：US20130013995A1

公开(公告)日：2013-01-10

申请号：US13620854

申请日：2012-09-15

Applicant: Dan Y. Khen ,  Charles D. Ellis ,  Liviu Asnash ,  Eran Megiddo ,  Ira Levin ,  Simon Peyton-Jones

Inventor： Dan Y. Khen ,  Charles D. Ellis ,  Liviu Asnash ,  Eran Megiddo ,  Ira Levin ,  Simon Peyton-Jones

IPC: G06F17/00

CPC classification number: G06F17/246 ,  G06F9/541 ,  G06F9/547 ,  H04L67/40

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

Abstract translation: 提供了一种方法，系统和装置，用于通过远程函数调用来暴露和调用工作簿模型。 根据该系统，客户端计算机执行用于创建工作簿模型的电子表格程序。 工作簿模型可以与定义功能名称的数据一起发布到服务器计算机，以及应用作模型的输入和输出的单元格。 该系统还包括服务器计算机，其接收并响应指向工作簿功能的远程功能调用。 当在服务器计算机上接收到用于工作簿功能的函数调用时，服务器计算机填充工作簿中标识为具有通过函数调用接收的输入参数的输入的单元，并重新计算工作簿。 然后，输出单元格中包含的数据作为远程函数调用的回复返回。

公开(公告)号：US07698287B2

公开(公告)日：2010-04-13

申请号：US10957502

申请日：2004-09-30

Applicant: Andrew J. Becker ,  Charles D. Ellis ,  Joseph M. Chirilov ,  Juha P. Niemisto ,  Matthew J. Androski ,  Robert C. Collie ,  Robert G. Hawking ,  Simon Peyton-Jones

Inventor： Andrew J. Becker ,  Charles D. Ellis ,  Joseph M. Chirilov ,  Juha P. Niemisto ,  Matthew J. Androski ,  Robert C. Collie ,  Robert G. Hawking ,  Simon Peyton-Jones

IPC: G06F17/00 ,  G06F17/30

CPC classification number: G06F17/246 ,  Y10S707/99942

Abstract: 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.

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

公开(公告)号：US20090172063A1

公开(公告)日：2009-07-02

申请号：US11964497

申请日：2007-12-26

Applicant: Joseph M. Chirilov ,  Jeffrey J. Duzak ,  Andrew J. Becker ,  Charles D. Ellis

Inventor： Joseph M. Chirilov ,  Jeffrey J. Duzak ,  Andrew J. Becker ,  Charles D. Ellis

IPC: G06F7/38 ,  G06F7/00

CPC classification number: G06F17/246

Abstract: A multi-threaded codeless user-defined function (UDF) may be provided. First, at least one input value may be received from a calculation thread corresponding to a spreadsheet calling the codeless UDF. Then, the at least one input value may be saved in a thread storage area outside of a UDF storage area containing the codeless UDF. Next, the codeless UDF may be performed comprising performing at least one calculation using at least one formula in the codeless UDF and the at least one input value from the thread storage area. At least one output value produced in response to performing the codeless UDF may then be returned to the calculation thread corresponding to the spreadsheet calling the codeless UDF.

Abstract translation: 可以提供多线程的无代码用户定义功能（UDF）。 首先，可以从对应于调用无代码UDF的电子表格的计算线程接收至少一个输入值。 然后，至少一个输入值可以保存在包含无代码UDF的UDF存储区域之外的线程存储区域中。 接下来，可以执行无代码UDF，其包括使用无码UDF中的至少一个公式和来自线程存储区域的至少一个输入值来执行至少一个计算。 响应于执行无代码UDF而产生的至少一个输出值然后可以被返回到与调用无代码UDF的电子表格相对应的计算线程。

公开(公告)号：US5163973A

公开(公告)日：1992-11-17

申请号：US798210

申请日：1991-11-26

Applicant: Charles D. Ellis

Inventor： Charles D. Ellis

IPC: C01F7/14

CPC classification number: C01F7/144 ,  C01P2004/50 ,  C01P2004/61

Abstract: In a process for precipitating alumina hydrate from a stream of Bayer process liquor, wherein the stream is first divided into a major portion and a minor portion, the minor portion fed to an agglomeration stage and seeded with fine seed to induce precipitation and formation of a slurry, and the major portion cooled and charged with coarse seed and directed to a growth stage to induce formation of alumina hydrate product, the steps of: separating solids from the minor portion after formation of the slurry; cooling, to a temperature of between about 45.degree. C. and about 60.degree. C., the liquid remaining after separating solids from the slurry formed in the agglomeration stage; adding an amount of coarse seed to the remaining liquid to generate a slurry of fresh hydrate nuclei; and recombining the slurry of fresh hydrate nuclei with the major portion of the stream.

Abstract translation: 在从Bayer工艺液流中沉淀氧化铝水合物的过程中，其中该物流首先被分成主要部分和少量部分，次要部分进料到附聚阶段，并用精细种子接种以诱导沉淀和形成 浆料，主要部分冷却并加入粗种子并引导至生长阶段以诱导形成水合氧化铝产物，步骤：在形成浆料后从少量部分分离固体; 冷却至约45℃至约60℃的温度，在从聚集阶段中形成的浆料中分离固体后剩余的液体; 向剩余的液体中加入一定量的粗种子以产生新鲜水合物核的浆料; 并将新鲜水合物核的浆料与料流的主要部分重新组合。

公开(公告)号：US5158577A

公开(公告)日：1992-10-27

申请号：US665340

申请日：1991-03-06

Applicant: Bruan A. Hiscox ,  Charles D. Ellis ,  Jacques E. Larocque ,  Denis R. Audet

Inventor： Bruan A. Hiscox ,  Charles D. Ellis ,  Jacques E. Larocque ,  Denis R. Audet

IPC: C01F7/14

CPC classification number: C01F7/144 ,  C01P2004/61

Abstract: An improved process for precipitating alumina from Bayer process liquors is disclosed. The process involves dividing an incoming pregnant liquor stream into a minor portion of about 10 to about 25% by volume of the total incoming pregnant liquor stream, and directing that stream into a series of small tanks where the minor stream is permitted to agglomerate. Fine aluminum hydroxide seed having a median particle size of between about 30 and about 60 microns is added to this stream. The slurry resulting from the agglomeration stage is then directed to a set of larger vessels in which the growth stage will take place. At this point, the remaining portion of the pregnant liquor is combined with the slurry resulting from the agglomeration stage. A coarse seed charge of about 150 to about 600 grams/liter of seed having a median particle size of between about 80 and about 100 microns is charged into the second set of vessels. This improved process helps to increase the yield of a strong coarse aluminum trihydroxide product.

Abstract translation: 公开了一种从拜耳法溶液中沉淀氧化铝的改进方法。 该方法包括将进入的怀孕液流分成总进入的怀孕液流的约10至约25体积％的小部分，并将该流引入一系列小容器中，其中少量流被允许聚集。 将中等粒度为约30至约60微米的氢氧化铝细粒子加入该料流中。 然后将由聚集阶段产生的浆料导向一组较大的容器，其中将发生生长阶段。 此时，将剩余部分的怀孕液与由聚集阶段产生的浆液组合。 将约150至约600克/升中值粒度为约80至约100微米的种子的粗种子装料装入第二组容器中。 这种改进的方法有助于提高强大的三氢氧化铝粗产物的产率。

公开(公告)号：US09317495B2

公开(公告)日：2016-04-19

申请号：US13620854

申请日：2012-09-15

Applicant: Dan Y. Khen ,  Charles D. Ellis ,  Liviu Asnash ,  Eran Megiddo ,  Ira Levin ,  Simon Peyton-Jones

Inventor： Dan Y. Khen ,  Charles D. Ellis ,  Liviu Asnash ,  Eran Megiddo ,  Ira Levin ,  Simon Peyton-Jones

IPC: G06F17/24 ,  G06F9/54 ,  H04L29/06

CPC classification number: G06F17/246 ,  G06F9/541 ,  G06F9/547 ,  H04L67/40

Abstract: A method, system, and apparatus are provided for exposing and calling workbook models via remote function calls. According to the system, a client computer executes a spreadsheet program for creating a workbook model. The workbook model may be published to a server computer along with data defining a function name and the cells that should be used as inputs and outputs to the model. The system also includes a server computer that receives and responds to remote function calls directed toward workbook functions. When a function call is received at the server computer for a workbook function, the server computer populates the cells in the workbook identified as inputs with input parameters received with the function call and recalculates the workbook. The data contained in the output cells is then returned as a reply to the remote function call.

公开(公告)号：US08584004B2

公开(公告)日：2013-11-12

申请号：US12107959

申请日：2008-04-23

Applicant: Chris L. Rae ,  Charles D. Ellis ,  Jeffrey J. Duzak

Inventor： Chris L. Rae ,  Charles D. Ellis ,  Jeffrey J. Duzak

IPC: G06F17/12

CPC classification number: G06Q40/04

Abstract: A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations.

Abstract translation: 提供了允许用户创建可以同时运行而不使用多个计算线程的用户定义函数（UDF）的框架。 计算引擎在开始运行异步功能而不等待接收结果时，继续执行与待处理异步功能无关的计算运算的剩余部分。 当计算引擎接收或完成时，结果值在计算周期的较后时间被引入计算。 当接收到结果时，计算诸如依赖函数的下游操作，而不改变操作内的依赖性流。

公开(公告)号：US20100312748A1

公开(公告)日：2010-12-09

申请号：US12852235

申请日：2010-08-06

Applicant: Howard J. Dickerman ,  Brian W. Boon ,  Charles D. Ellis ,  Kaicheng Hu ,  Robert G. Hawking

Inventor： Howard J. Dickerman ,  Brian W. Boon ,  Charles D. Ellis ,  Kaicheng Hu ,  Robert G. Hawking

IPC: G06F17/30

CPC classification number: G06F17/246 ,  G06F16/283

Abstract: Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.

Abstract translation: 多维数据集函数可用于从多维数据库获取数据。 多维数据集函数可以包含在电子表格的一个或多个单元格内。 这些立方体函数的行为与可能包含在电子表格中的标准函数类似。 示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。 电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。 在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。