Invention Grant
- Patent Title: Automatic translation of spreadsheets into scripts
-
Application No.: US16226100Application Date: 2018-12-19
-
Publication No.: US10762291B2Publication Date: 2020-09-01
- Inventor: Eliot Ball , Dustin Janatpour , Nicholas White
- Applicant: Palantir Technologies Inc.
- Applicant Address: US CA Palo Alto
- Assignee: Palantir Technologies Inc.
- Current Assignee: Palantir Technologies Inc.
- Current Assignee Address: US CA Palo Alto
- Agency: Sheppard Mullin Richter & Hampton LLP
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F40/18 ; G06F8/41 ; G06F8/40 ; G06F40/103 ; G06F40/177 ; G06F40/205

Abstract:
Systems and methods are provided for automatically translating one or more electronic spreadsheets into scripts. One or more electronic spreadsheets containing data arrays and formula arrays may be accessed. The electronic spreadsheet(s) may implement various logic using the data arrays and the formula arrays. The range(s) of the formula arrays may be determined. The range(s) of the data arrays may be determined based on the range(s) of the formula arrays. Conversion ranges may be determined based on the range(s) of formula arrays and the range(s) of data arrays. One or more dependencies between the conversion ranges may be determined and used to generate source code modeling the logic implemented by the electronic spreadsheet(s).
Public/Granted literature
- US20190121848A1 AUTOMATIC TRANSLATION OF SPREADSHEETS INTO SCRIPTS Public/Granted day:2019-04-25
Information query