Invention Grant
- Patent Title: Techniques for using a spreadsheet as a compute engine in an online data management system
-
Application No.: US15873675Application Date: 2018-01-17
-
Publication No.: US10691882B2Publication Date: 2020-06-23
- Inventor: Abraham Elias , Jason Adams , Hanno Benjamin Harms
- Applicant: Mercatus, Inc.
- Applicant Address: US CA San Mateo
- Assignee: Mercatus, Inc.
- Current Assignee: Mercatus, Inc.
- Current Assignee Address: US CA San Mateo
- Agency: Hickman Palermo Becker Bingham LLP
- Agent Adam C. Stone
- Main IPC: G06F40/18
- IPC: G06F40/18 ; G06F7/02 ; G06F17/10 ; G06F40/174

Abstract:
Computer-implemented techniques for using a spreadsheet as a compute engine in an online data management system. In one embodiment, for example, a computer-implemented method comprises the operations of: automatically causing first data items of a first named range triad to be set in a first named range of a spreadsheet; after the first data items are set in the first named range, automatically causing a spreadsheet program to calculate a cell value of the spreadsheet that is derived from one or more of the first data items as set in the spreadsheet; and after the cell value is calculated, automatically obtaining second data items from a second named range of the spreadsheet, the second data items including the cell value calculated. By doing so, quantitative models can be maintained in spreadsheets yet the data on which the models operate can be managed using an online data management system.
Public/Granted literature
- US20190220509A1 TECHNIQUES FOR USING A SPREADSHEET AS A COMPUTE ENGINE IN AN ONLINE DATA MANAGEMENT SYSTEM Public/Granted day:2019-07-18
Information query