公开(公告)号：US09286286B1

公开(公告)日：2016-03-15

申请号：US14588909

申请日：2015-01-03

Applicant: Chahid Kamel Ghaddar

Inventor： Chahid Kamel Ghaddar

IPC: G06F17/24

CPC classification number: G06F17/246 ,  G06F17/11 ,  G06F17/24

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides an optimization process executed by spreadsheet functions of a spreadsheet application, and arranged in a functional paradigm for computing optimal parameters for a parameterized system modelled by variables, parameters, and dependent formulas.

Abstract translation: 本公开提供了一种与电子表格应用交互的方法，装置和计算机程序产品，用于基于所提供的变量的值来计算明确或隐含地依赖于指定为变量的一个或多个小区的公式的值， 并且不修改电子表格应用程序的任何数据。 一方面，本公开提供了一种由电子表格应用程序的电子表格功能执行的优化过程，并且被布置在用于计算由变量，参数和从属公式建模的参数化系统的最优参数的功能范例中。

公开(公告)号：US09892108B1

公开(公告)日：2018-02-13

申请号：US15003848

申请日：2016-01-22

Applicant: Chahid Kamel Ghaddar

Inventor： Chahid Kamel Ghaddar

IPC: G06F17/24 ,  G06F17/11

CPC classification number: G06F17/246 ,  G06F17/11 ,  G06F17/24

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides a method for computing numerical solution of an equation system modelled by one or more variables, parameters, and dependent formulas in a spreadsheet application, using a spreadsheet function of the spreadsheet application.

公开(公告)号：US10114812B1

公开(公告)日：2018-10-30

申请号：US15861897

申请日：2018-01-04

Applicant: Chahid Kamel Ghaddar

Inventor： Chahid Kamel Ghaddar

IPC: G06F17/24 ,  G06F17/11

Abstract: The present disclosure provides a method, an apparatus, and a computer program product to interact with a programming interface of a spreadsheet software application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables for the formula, based on supplied values for the variables, and without modifying any values or content of the spreadsheet software application. In a first utility, the method is utilized in pure solver functions of the spreadsheet application for computing numerical solution of an equation system modeled by at least one or more formulas and variables in the spreadsheet software application. In a second utility, the method is utilized in an optimization process executed by pure solver functions of the spreadsheet application for computing optimal parameters for a parameterized equation system modeled by at least one or more formulas, variables, and parameters.