公开(公告)号：US07379935B1

公开(公告)日：2008-05-27

申请号：US11192948

申请日：2005-07-29

Applicant: Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

Inventor： Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

IPC: G06F17/30 ,  G06F17/00

CPC classification number: G06F17/30587 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

Abstract: A calculation engine processes user-definable formulas to generate calculation results. A calculation engine may use the following types of data structures: table, column, row, and field. A sub table may be embedded within a row. Operations may be performed at various levels, such as at: table, column, and field. A calculation engine may operate on a calculation table having columns, which may each have an ordered list of formulas. Formulas within such an ordered list may be evaluated in the order specified until one of the formulas is successfully evaluated. A hierarchy of formulas may be formed by a column's formula depending on another column or table. A graph of data dependencies may be prepared for determining an order in which operands and operations should be evaluated and performed.

Abstract translation: 计算引擎处理用户可定义的公式以生成计算结果。 计算引擎可以使用以下类型的数据结构：表，列，行和字段。 子表可以嵌入到一行中。 操作可以在各个级别执行，例如：表，列和字段。 计算引擎可以在具有列的计算表上操作，每列具有公式的有序列表。 此类有序列表中的公式可以按指定的顺序进行评估，直到成功评估其中一个公式。 公式的层次结构可以由列的公式形成，具体取决于另一列或表。 可以准备数据依赖关系图以确定应该评估和执行操作数和操作的顺序。

公开(公告)号：US07107277B1

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

申请号：US10321317

申请日：2002-12-17

Applicant: Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

Inventor： Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

IPC: G06F17/30

CPC classification number: G06F17/30587 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

Abstract: A calculation engine processes user-definable formulas to generate calculation results. A calculation engine may use the following types of data structures: table, column, row, and field. A sub table may be embedded within a row. Operations may be performed at various levels, such as at: table, column, and field. A calculation engine may operate on a calculation table having columns, which may each have an ordered list of formulas. Formulas within such an ordered list may be evaluated in the order specified until one of the formulas is successfully evaluated. A hierarchy of formulas may be formed by a column's formula depending on another column or table. A graph of data dependencies may be prepared for determining an order in which operands and operations should be evaluated and performed.

Abstract translation: 计算引擎处理用户可定义的公式以生成计算结果。 计算引擎可以使用以下类型的数据结构：表，列，行和字段。 子表可以嵌入到一行中。 操作可以在各个级别执行，例如：表，列和字段。 计算引擎可以在具有列的计算表上操作，每列具有公式的有序列表。 此类有序列表中的公式可以按指定的顺序进行评估，直到成功评估其中一个公式。 公式的层次结构可以由列的公式形成，具体取决于另一列或表。 可以准备数据依赖关系图以确定应该评估和执行操作数和操作的顺序。

公开(公告)号：US20120233096A1

公开(公告)日：2012-09-13

申请号：US13042016

申请日：2011-03-07

Applicant: ATUL KUMAR GUPTA ,  ANNA V. TIMASHEVA ,  YUAN WANG ,  RAJKIRAN PANUGANTI ,  GARGI GHOSH ,  CHAOPING QIN ,  YASSER GANJISAFFAR ,  GIRISH KUMAR ,  HONGYAN ZHOU

Inventor： ATUL KUMAR GUPTA ,  ANNA V. TIMASHEVA ,  YUAN WANG ,  RAJKIRAN PANUGANTI ,  GARGI GHOSH ,  CHAOPING QIN ,  YASSER GANJISAFFAR ,  GIRISH KUMAR ,  HONGYAN ZHOU

IPC: G06F15/18 ,  G06F17/30

CPC classification number: G06F16/951 ,  G06F16/31

Abstract: Historical usage data related to user queries and training properties for a plurality of web pages is received and utilized to train a mathematical model to predict the likelihood of retrieval of a web page during a web search. Properties are extracted from the plurality of web pages in the index and the mathematical model is applied to the properties for each web page to calculate a sortrank value. The index is reordered based on the sortrank value such that the web pages most likely to be retrieved by a user submitting a search query appear first in the index. After a search query is received from a user the index is traversed in an order determined by the sortrank value. Responsive web pages are presented to the user in an order determined by a search engine ranking algorithm.

Abstract translation: 接收和利用与多个网页的用户查询和训练属性相关的历史使用数据来训练数学模型以预测在网络搜索期间检索网页的可能性。 从索引中的多个网页中提取属性，并将数学模型应用于每个网页的属性以计算排序排序值。 该索引根据排序排序值被重新排序，使得最有可能由提交搜索查询的用户检索的网页首先出现在索引中。 在从用户接收到搜索查询之后，按照排序排序值确定的顺序遍历索引。 以搜索引擎排名算法确定的顺序将响应性网页呈现给用户。

公开(公告)号：US06565609B1

公开(公告)日：2003-05-20

申请号：US09333755

申请日：1999-06-15

Applicant: Terri L. Sorge ,  Kevin J. Fischer ,  Rajeev S. Misra ,  Anna V. Timasheva

Inventor： Terri L. Sorge ,  Kevin J. Fischer ,  Rajeev S. Misra ,  Anna V. Timasheva

IPC: G06F1200

CPC classification number: G06F17/30569 ,  G06F17/30893

Abstract: A method for enabling data generated in a parent application to be translated into another format, such as hypertext markup language (HTML), so that formatting functionality unique to the parent application is retained, and so that the data reintroduced into the parent application from an HTML document has all its original formatting and functionality restored. As the data are translated into the other format, formatting information specific to the parent application is included with the data, but in such a manner that the formatting information is ignored by applications such as web browsers that are compatible with the other format. While translating the data into the other format, any formatting commands in the data that are not fully supported in the other format are identified, and if found, are translated so as to emulate the form of the data in the parent application. Included in the translated data is a marker identifying changes in the formatting commands. When the translated data are reintroduced to the parent application, the parent application ignores the non-identical formatting indicated by the marker and instead uses the original formatting information that was included in the translated data. The method can be used to reduce the size of an HTML file that includes translated spreadsheet data by abbreviating the HTML code for empty cells, while ensuring that when translated spreadsheet data are reintroduced into a parent spreadsheet application, the original formatting and functionality of the spreadsheet data are maintained.

Abstract translation: 一种用于使在父应用程序中生成的数据能够被转换成另一种格式的方法，例如超文本标记语言（HTML），使得保留对父应用程序特有的格式化功能，从而将数据从 HTML文档已恢复所有原始格式和功能。 由于数据被转换为其他格式，因此数据中包含特定于父应用程序的格式化信息，但是格式化信息被诸如与其他格式兼容的web浏览器之类的应用程序忽略。 在将数据转换为其他格式的同时，识别出数据中格式化的其他格式不完全支持的格式化命令，如果找到，则转换为在母应用程序中模拟数据的形式。 翻译后的数据中包含一个标识符，用于标识格式化命令中的更改。 当翻译的数据被重新引入父应用程序时，父应用程序忽略由标记指示的不相同的格式，而是使用包含在翻译数据中的原始格式化信息。 该方法可用于通过缩写空白单元格的HTML代码来缩小包含翻译的电子表格数据的HTML文件的大小，同时确保将翻译的电子表格数据重新引入父级电子表格应用程序时，电子表格的原始格式和功能 保持数据。

公开(公告)号：US07415474B1

公开(公告)日：2008-08-19

申请号：US11192949

申请日：2005-07-29

Applicant: Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

Inventor： Kanchan Mitra ,  Anna V. Timasheva ,  Dipan Dewan ,  Kenneth L. Crocker ,  Robert E. Corrington ,  David V. Gunter

IPC: G06F17/00 ,  G06F15/00

CPC classification number: G06F17/30587 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99944

Abstract: A calculation engine processes user-definable formulas to generate calculation results. A calculation engine may use the following types of data structures: table, column, row, and field. A sub table may be embedded within a row. Operations may be performed at various levels, such as at: table, column, and field. A calculation engine may operate on a calculation table having columns, which may each have an ordered list of formulas. Formulas within such an ordered list may be evaluated in the order specified until one of the formulas is successfully evaluated. A hierarchy of formulas may be formed by a column's formula depending on another column or table. A graph of data dependencies may be prepared for determining an order in which operands and operations should be evaluated and performed.

公开(公告)号：US06613098B1

公开(公告)日：2003-09-02

申请号：US09333815

申请日：1999-06-15

Applicant: Terri L. Sorge ,  Kevin J. Fischer ,  Anna V. Timasheva ,  Russell S. Johnson ,  Rajeev S. Misra ,  Juha Niemisto ,  Robert W. Coffen ,  Ramakrishnan Natarajan

Inventor： Terri L. Sorge ,  Kevin J. Fischer ,  Anna V. Timasheva ,  Russell S. Johnson ,  Rajeev S. Misra ,  Juha Niemisto ,  Robert W. Coffen ,  Ramakrishnan Natarajan

IPC: G06F1700

CPC classification number: G06F17/246 ,  G06F17/2264

Abstract: A spreadsheet program saves data into a hypertext markup language (HTML) document that can be viewed with a browser program, but persists all of the information associated with that data necessary to maintain formatting and functionality of the data if reintroduced into the spreadsheet program. The HTML document can then be used both for displaying the data over the Internet or other network in a browser program, and also for opening the data in the spreadsheet program. The information necessary for preserving the format and functionality of the data in the spreadsheet program is incorporated into the HTML document using HTML, Cascading Style Sheets (CSS), and Extended Markup Language (XML). HTML is used for expressing cell data information that is displayed in the browser program, CSS are used for expressing cell-level properties of the data, and XML is used for expressing information that is not displayed in the browser program, but which is necessary for some functionality of the data when used in the spreadsheet program. If any formatting of the data are changed to enable display of the data in the browser program as displayed in the spreadsheet program, the original formatting information is retained in a supporting file that is ignored by a browser program.

Abstract translation: 电子表格程序将数据保存到可以使用浏览器程序查看的超文本标记语言（HTML）文档中，但如果重新引入到电子表格程序中，则会保留与维护数据格式和功能所必需的所有信息相关的所有信息。 然后可以将HTML文档用于通过互联网或浏览器程序中的其他网络显示数据，以及打开电子表格程序中的数据。 使用HTML，级联样式表（CSS）和扩展标记语言（XML）将维护电子表格程序中数据格式和功能所必需的信息合并到HTML文档中。 HTML用于表示浏览器程序中显示的单元格数据信息，CSS用于表示数据的单元级属性，XML用于表示浏览器程序中未显示的信息，但这是必需的 在电子表格程序中使用数据的一些功能。 如果数据的任何格式化被更改以使得能够在电子表格程序中显示浏览器程序中的数据的显示，则原始格式化信息被保留在被浏览器程序忽略的支持文件中。